array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29885831 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1517901"
+post_author: 1
+"ListingKey": "29885831"
+"ListingId": "X13428652"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T22:35:06Z"
+"RFModificationTimestamp": "2026-06-11T02:15:26Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "317 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to modern condo living in the heart of Waterdown. This beautifully maintained 1 bedroom + den, 1 bathroom suite at 317-470 Dundas Street East offers 676 sqft of thoughtfully designed living space complete with 1 parking space and 1 locker. Surrounded by shopping, dining, scenic trails, parks, and everyday conveniences, this vibrant location also provides easy access to Burlington, Hamilton, Aldershot GO Station, and Highway 407-perfect for commuters, first-time buyers, professionals, or downsizers seeking stylish low-maintenance living in a growing community. Inside, the bright open-concept layout is filled with natural light from oversized windows and showcases a modern, functional design ideal for both entertaining and everyday living. The kitchen features contemporary cabinetry, stainless steel appliances, stylish backsplash detailing, ample prep space, and a large island with seating overlooking the main living area. The spacious living and dining area offers seamless flow and direct access to the private balcony, creating the perfect extension of your living space. The primary bedroom offers generous closet space, while the den provides excellent flexibility for a home office, guest space, or additional living area. The well-appointed 4pc bathroom features clean contemporary finishes, while convenient in-suite laundry adds everyday practicality. Residents enjoy exceptional building amenities including a rooftop patio with lounge areas and BBQs, fully equipped fitness centre, stylish party room, and secure entry, all while being surrounded by scenic trails, restaurants, shopping, and everyday conveniences just moments away. An excellent opportunity to enjoy low-maintenance living in one of Waterdown's most connected and fast-growing communities. (id:62783)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "593.36"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-11T02:15:16.845341+00:00"
+"Directions": "Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058183"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-10T22:26:28Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T22:26:28Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2844.72"
+"VirtualTourURLUnbranded": "https://youtu.be/CrXWKfetRd4"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1656579624"
"RoomType" => "Living room"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 5.26
"ListingKey" => "29885831"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.37Z"
]
1 => array:11 [
"RoomKey" => "1656579625"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 4.78
"ListingKey" => "29885831"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.39Z"
]
2 => array:11 [
"RoomKey" => "1656579626"
"RoomType" => "Kitchen"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29885831"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.42Z"
]
3 => array:11 [
"RoomKey" => "1656579627"
"RoomType" => "Den"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "29885831"
"RoomLength" => 2.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.43Z"
]
4 => array:11 [
"RoomKey" => "1656579628"
"RoomType" => "Laundry room"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 0.99
"ListingKey" => "29885831"
"RoomLength" => 1.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.44Z"
]
5 => array:11 [
"RoomKey" => "1656579629"
"RoomType" => "Foyer"
"ListingId" => "X13428652"
"RoomLevel" => "Main level"
"RoomWidth" => 0.99
"ListingKey" => "29885831"
"RoomLength" => 2.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-10T22:26:28.45Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29885831/317-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-10T22:26:28.03Z"
+"ListAgentNationalAssociationId": "1333377"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29885831_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/366a42cda8647adc651613860772ec5c.webp"
"MediaSize" => 298565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-366a42cda8647adc651613860772ec5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29885831_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/2fd458542a89e81754ceed8ffb9af8c6.webp"
"MediaSize" => 257345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-2fd458542a89e81754ceed8ffb9af8c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29885831_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/8759f05e1aa4225524410ff60c483e5f.webp"
"MediaSize" => 162049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-8759f05e1aa4225524410ff60c483e5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29885831_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/92cc090558972affcc65632827cc72cf.webp"
"MediaSize" => 138918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-92cc090558972affcc65632827cc72cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29885831_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/61c1d04d170b30ec73d15c3d4639357f.webp"
"MediaSize" => 101861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-61c1d04d170b30ec73d15c3d4639357f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29885831_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/0dc8987bd2a9fd1dbcb0fed3db046425.webp"
"MediaSize" => 172492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-0dc8987bd2a9fd1dbcb0fed3db046425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29885831_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/cffec6323b1aef8d8da1d3b053de22ef.webp"
"MediaSize" => 232152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-cffec6323b1aef8d8da1d3b053de22ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29885831_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/662da223e2327ae49f44fa26eea25e33.webp"
"MediaSize" => 174170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-662da223e2327ae49f44fa26eea25e33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29885831_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/cd453845d478f3dba8f8fcf0b2016c30.webp"
"MediaSize" => 205857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-cd453845d478f3dba8f8fcf0b2016c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29885831_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/07947702c121de2573f02364d4f98c1c.webp"
"MediaSize" => 188740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-07947702c121de2573f02364d4f98c1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29885831_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/8e426ac62c342727843444e73878c08a.webp"
"MediaSize" => 124329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-8e426ac62c342727843444e73878c08a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29885831_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/1ac88c40e62b2b821d3d956bd7f3d9b0.webp"
"MediaSize" => 102259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-1ac88c40e62b2b821d3d956bd7f3d9b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29885831_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/f1dfb982d8eef8fd76c37e6050d0501d.webp"
"MediaSize" => 143337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-f1dfb982d8eef8fd76c37e6050d0501d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29885831_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/b38419fce2ca31168f64144f7fef42fd.webp"
"MediaSize" => 240900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-b38419fce2ca31168f64144f7fef42fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29885831_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/1ad53dbeca015da870dcd2a603415d84.webp"
"MediaSize" => 81728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-1ad53dbeca015da870dcd2a603415d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29885831_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/6ba547a539ed157a933ac68e273be2a2.webp"
"MediaSize" => 108040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-6ba547a539ed157a933ac68e273be2a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29885831_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/c6b92f9b96c49bb27ad62a149423ce95.webp"
"MediaSize" => 270050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-c6b92f9b96c49bb27ad62a149423ce95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29885831_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/d9a41bbca015c1f899fcd68cdf048ac9.webp"
"MediaSize" => 217802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-d9a41bbca015c1f899fcd68cdf048ac9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29885831_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/022229cafefa740d7d5595223506c98b.webp"
"MediaSize" => 177182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-022229cafefa740d7d5595223506c98b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29885831_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/a65928e91ec0351c2aea654cebf9d603.webp"
"MediaSize" => 216804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-a65928e91ec0351c2aea654cebf9d603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29885831_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/6aa4150bb9885fdf31e8abdf0017fe1c.webp"
"MediaSize" => 247026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-6aa4150bb9885fdf31e8abdf0017fe1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29885831_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/e23714eb540fde00eba753f212ed5481.webp"
"MediaSize" => 296950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-e23714eb540fde00eba753f212ed5481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29885831_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/e1fda9e996a6a27fdd7921e44a0d1106.webp"
"MediaSize" => 258674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-e1fda9e996a6a27fdd7921e44a0d1106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29885831_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/3a8f7fc824a8774a2ddeeaa063579594.webp"
"MediaSize" => 198485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-3a8f7fc824a8774a2ddeeaa063579594.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29885831_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/6163eb71b55eb0d6db7ca79fe98ecd6a.webp"
"MediaSize" => 236059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-6163eb71b55eb0d6db7ca79fe98ecd6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29885831_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/fbda0b1887fb9c36ba52a09d76b9b5d0.webp"
"MediaSize" => 353279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-fbda0b1887fb9c36ba52a09d76b9b5d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29885831_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/f3a78846921a8963a40be2111925e1dd.webp"
"MediaSize" => 316547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-f3a78846921a8963a40be2111925e1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29885831_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29885831/b5c87d9a92199de2d5a5087b4b6814f1.webp"
"MediaSize" => 48066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29885831/thumbnail-b5c87d9a92199de2d5a5087b4b6814f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13428652"
"ResourceRecordKey" => "29885831"
"ModificationTimestamp" => "2026-06-10T22:26:28.06Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885831')"
+"ID": "1517901"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269020" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24682
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2058183" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24718
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29885831'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25072
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29885831'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25088
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29885831' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25135
+post_id: "1518137"
+post_author: 1
+"ListingKey": "29887094"
+"ListingId": "X13429540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:50:27Z"
+"RFModificationTimestamp": "2026-06-11T05:58:26Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "905 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern Trend Living condo with 9-ft ceilings and an open-concept layout. Features ceramic tile flooring and bright LED lighting throughout. The stylish kitchen offers custom cabinetry, designer faucet, and laminate countertops with a backsplash, while the bathrooms boast quartz countertops and spa-inspired premium fixtures. Enjoy a feature wall for your TV, a French balcony, and an owned locker for extra convenience. Pet-friendly in both living areas and bedrooms. This energy-efficient building includes geothermal heating/cooling, secure entry, 2 owned underground parking spaces, rooftop terrace, and professional management. Freshly painted and perfectly located near parks, shopping, restaurants, and major highways. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "497.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T05:58:17.496106+00:00"
+"Directions": "Dundas St/ Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036997"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T04:42:09Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:42:09Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3952.38"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1656871264"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13429540"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29887094"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T04:42:09.49Z"
]
1 => array:11 [
"RoomKey" => "1656871265"
"RoomType" => "Bedroom"
"ListingId" => "X13429540"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29887094"
"RoomLength" => 3.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T04:42:09.49Z"
]
2 => array:11 [
"RoomKey" => "1656871266"
"RoomType" => "Great room"
"ListingId" => "X13429540"
"RoomLevel" => "Main level"
"RoomWidth" => 4.69
"ListingKey" => "29887094"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T04:42:09.49Z"
]
3 => array:11 [
"RoomKey" => "1656871267"
"RoomType" => "Kitchen"
"ListingId" => "X13429540"
"RoomLevel" => "Main level"
"RoomWidth" => 2.43
"ListingKey" => "29887094"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T04:42:09.49Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29887094/905-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T04:42:09.45Z"
+"ListAgentNationalAssociationId": "1313436"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29887094_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/63cdd1479165afb2b0aae6bb1decf34c.webp"
"MediaSize" => 204614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-63cdd1479165afb2b0aae6bb1decf34c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29887094_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/1c0194e0562c41b5cd3d7816f6427c4f.webp"
"MediaSize" => 234862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-1c0194e0562c41b5cd3d7816f6427c4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29887094_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/648d27c8de6f8df96baf3f306bbcc42a.webp"
"MediaSize" => 223433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-648d27c8de6f8df96baf3f306bbcc42a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29887094_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/f10dc5a33fc2fc8d70ec0893b3d3dd9a.webp"
"MediaSize" => 327051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-f10dc5a33fc2fc8d70ec0893b3d3dd9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29887094_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/7108292a2461521df102772f5d5ea361.webp"
"MediaSize" => 295859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-7108292a2461521df102772f5d5ea361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29887094_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/547bee883fc626c4ff13e08b1459a1a7.webp"
"MediaSize" => 148277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-547bee883fc626c4ff13e08b1459a1a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29887094_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/88ed12e2b80f1aa428276039ab5987ff.webp"
"MediaSize" => 190177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-88ed12e2b80f1aa428276039ab5987ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29887094_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/d9282cb89ffeebcc6b3715cab25046e9.webp"
"MediaSize" => 221545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-d9282cb89ffeebcc6b3715cab25046e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29887094_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/b21387d451ecb7d1864c323c8a9ac33a.webp"
"MediaSize" => 216552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-b21387d451ecb7d1864c323c8a9ac33a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29887094_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/3da3f36f8492426235b8c41fa4800f82.webp"
"MediaSize" => 195393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-3da3f36f8492426235b8c41fa4800f82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29887094_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/229c821265c7464568609cd5e10d53e3.webp"
"MediaSize" => 209744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-229c821265c7464568609cd5e10d53e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29887094_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/c19beae0901dcaaf4fd5afba1f571aed.webp"
"MediaSize" => 135887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-c19beae0901dcaaf4fd5afba1f571aed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29887094_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/51a787a02ab6613023e582e247c5cee6.webp"
"MediaSize" => 137763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-51a787a02ab6613023e582e247c5cee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29887094_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/76b0cbd5d21955bdd3501e20a436f0a5.webp"
"MediaSize" => 187357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-76b0cbd5d21955bdd3501e20a436f0a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29887094_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/8430dfbd4176e203918e66d405b07292.webp"
"MediaSize" => 151335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-8430dfbd4176e203918e66d405b07292.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29887094_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/a9a50261246a322ee00132c2a33d4251.webp"
"MediaSize" => 215823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-a9a50261246a322ee00132c2a33d4251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29887094_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/e7d79f952d300932699fa7b95974248f.webp"
"MediaSize" => 213230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-e7d79f952d300932699fa7b95974248f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29887094_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/24acb9e8b03911103c832c3f4cddc7ea.webp"
"MediaSize" => 428789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-24acb9e8b03911103c832c3f4cddc7ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29887094_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/fe9934452f036ee7837a1daa4432b419.webp"
"MediaSize" => 290331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-fe9934452f036ee7837a1daa4432b419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29887094_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/75db5c14a5491fe451136ac7ce850024.webp"
"MediaSize" => 237523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-75db5c14a5491fe451136ac7ce850024.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29887094_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/2a569cce7895a5c127f0bbe6c42af67a.webp"
"MediaSize" => 267675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-2a569cce7895a5c127f0bbe6c42af67a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29887094_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887094/252c69497723ce641528cc1a58a7b1dd.webp"
"MediaSize" => 218960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887094/thumbnail-252c69497723ce641528cc1a58a7b1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429540"
"ResourceRecordKey" => "29887094"
"ModificationTimestamp" => "2026-06-11T04:42:09.46Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887094')"
+"ID": "1518137"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25137
+post_id: "1517898"
+post_author: 1
+"ListingKey": "29886601"
+"ListingId": "X13429118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T00:50:04Z"
+"RFModificationTimestamp": "2026-06-11T03:18:01Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "223 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.876439
1 => 43.340782
]
+"Latitude": 43.340782
+"Longitude": -79.876439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A maintenance-free townhome that lives like a detached; and it doesn't come up often on Skinner. This home delivers over 2,100 sq ft of finished, carpet-free living across three bedrooms, three bathrooms, and a true walk-out lower level that sets it apart from every other townhome on the street. The chef-inspired kitchen is the anchor: a 10-ft island built for gathering, white cabinetry paired with gold hardware, stainless appliances, and 9-ft ceilings dotted with pot lights. Open-concept flow connects kitchen, dining, and living for everyday function and effortless entertaining. Upstairs delivers what most townhomes can't: three genuinely large bedrooms, a primary suite that functions as a true escape, and an ensuite finished with the kind of detail you'd expect in a custom build like a massive tub overlooking your backyard. The fully finished basement (2023) walks out to a fully landscaped backyard featuring over 500 sq ft of professionally laid interlock, turf grass, and matured plantings; the rose bush and tulips are already blooming. Add the upper deck (2024) and you've got two outdoor living rooms, three seasons of use, and zero weekend lawn maintenance. Mechanically dialed in: high-efficiency heat pump (2024) for year-round comfort and low operating costs, luxury laminate throughout (2020), and a garage with direct backyard access plus a custom loft (2024) for seasonal storage. Walk to top-rated schools, new parks, and the Waterdown village's cafés and Farmers' Market; with Aldershot GO and 403/407 access making the commute a non-issue. A turnkey home for a family ready to put down roots in one of the area's fastest-growing communities, without inheriting a weekend's worth of upkeep. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:17:52.207026+00:00"
+"Directions": "Skinner and McKnight"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154884"
+"ListOfficeKey": "300286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.8 x 92.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T00:44:07Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T00:44:07Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "223"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6440.21"
+"VirtualTourURLUnbranded": "https://www.223skinnerroad.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1656684314"
"RoomType" => "Foyer"
"ListingId" => "X13429118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29886601"
"RoomLength" => 1.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
1 => array:11 [
"RoomKey" => "1656684315"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13429118"
"RoomLevel" => "Basement"
"RoomWidth" => 6.65
"ListingKey" => "29886601"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
2 => array:11 [
"RoomKey" => "1656684316"
"RoomType" => "Utility room"
"ListingId" => "X13429118"
"RoomLevel" => "Basement"
"RoomWidth" => 3.84
"ListingKey" => "29886601"
"RoomLength" => 2.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
3 => array:11 [
"RoomKey" => "1656684317"
"RoomType" => "Office"
"ListingId" => "X13429118"
"RoomLevel" => "Basement"
"RoomWidth" => 2.87
"ListingKey" => "29886601"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
4 => array:11 [
"RoomKey" => "1656684318"
"RoomType" => "Other"
"ListingId" => "X13429118"
"RoomLevel" => "Basement"
"RoomWidth" => 1.55
"ListingKey" => "29886601"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
5 => array:11 [
"RoomKey" => "1656684319"
"RoomType" => "Bathroom"
"ListingId" => "X13429118"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29886601"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
6 => array:11 [
"RoomKey" => "1656684320"
"RoomType" => "Kitchen"
"ListingId" => "X13429118"
"RoomLevel" => "Main level"
"RoomWidth" => 7.26
"ListingKey" => "29886601"
"RoomLength" => 5.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
7 => array:11 [
"RoomKey" => "1656684321"
"RoomType" => "Living room"
"ListingId" => "X13429118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29886601"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.09Z"
]
8 => array:11 [
"RoomKey" => "1656684322"
"RoomType" => "Dining room"
"ListingId" => "X13429118"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29886601"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
9 => array:11 [
"RoomKey" => "1656684323"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13429118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29886601"
"RoomLength" => 5.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
10 => array:11 [
"RoomKey" => "1656684324"
"RoomType" => "Bathroom"
"ListingId" => "X13429118"
"RoomLevel" => "Second level"
"RoomWidth" => 4.52
"ListingKey" => "29886601"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
11 => array:11 [
"RoomKey" => "1656684325"
"RoomType" => "Bedroom"
"ListingId" => "X13429118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29886601"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
12 => array:11 [
"RoomKey" => "1656684326"
"RoomType" => "Bedroom"
"ListingId" => "X13429118"
"RoomLevel" => "Second level"
"RoomWidth" => 3.25
"ListingKey" => "29886601"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
13 => array:11 [
"RoomKey" => "1656684327"
"RoomType" => "Bathroom"
"ListingId" => "X13429118"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29886601"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T00:44:07.1Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886601/223-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.9
+"OriginalEntryTimestamp": "2026-06-11T00:44:07.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406384"
+"ListOfficeNationalAssociationId": "1485877"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29886601_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886601/da9ec407481d8015ab3a9906fd41e0a9.webp"
"MediaSize" => 278686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886601/thumbnail-da9ec407481d8015ab3a9906fd41e0a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13429118"
"ResourceRecordKey" => "29886601"
"ModificationTimestamp" => "2026-06-11T00:44:07.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29886601_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886601/7a5ac6d6403efe11160f5eab594384d6.webp"
"MediaSize" => 336342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886601/thumbnail-7a5ac6d6403efe11160f5eab594384d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429118"
"ResourceRecordKey" => "29886601"
"ModificationTimestamp" => "2026-06-11T00:44:07.05Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29886601_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886601/ef96f8d069e0bef2b8fa764e0fff5327.webp"
"MediaSize" => 315824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886601/thumbnail-ef96f8d069e0bef2b8fa764e0fff5327.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13429118"
"ResourceRecordKey" => "29886601"
"ModificationTimestamp" => "2026-06-11T00:44:07.05Z"
]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886601')"
+"ID": "1517898"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25134
+post_id: "1517899"
+post_author: 1
+"ListingKey": "29886669"
+"ListingId": "40838479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T01:15:19Z"
+"RFModificationTimestamp": "2026-06-11T03:13:03Z"
+"ListPrice": 355000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 570.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street E Unit# 216, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8795173
1 => 43.3433004
]
+"Latitude": 43.3433004
+"Longitude": -79.8795173
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful 1-bedroom condo featuring a modern kitchen with stainless steel appliances and quartz countertops. Enjoy the convenience of in-suite laundry and a spacious 4-piece bathroom with upgraded glass shower doors. Bright and functional layout ideal for first-time buyers, downsizers, or investors. Underground parking. Building amenities include a rooftop BBQ terrace, party room, and fully equipped exercise room. Conveniently located close to shopping, dining, transit, and everyday amenities. A great opportunity to own in a well-maintained building with desirable features and amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "522.12"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:13:00.138402+00:00"
+"Directions": "Dundas St E to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041052"
+"ListOfficeKey": "55168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-11T01:09:23Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T01:09:23Z"
+"Stories": "2.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2555"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29886669/460-e-dundas-street-e-unit-216-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1980090"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1628618"
+"CoListOfficeKey": "55167"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "55168"
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-06-11T01:09:23.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1317017"
+"ListOfficeNationalAssociationId": "1116022"
+"CoListAgentNationalAssociationId": "1265844"
+"CoListAgentNationalAssociationId2": "1162034"
+"CoListOfficeNationalAssociationId": "1003582"
+"CoListOfficeNationalAssociationId2": "1116022"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886669')"
+"ID": "1517899"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
+post_id: "1517900"
+post_author: 1
+"ListingKey": "29885330"
+"ListingId": "40838531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:25:15Z"
+"RFModificationTimestamp": "2026-06-11T02:31:41Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 676.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 317, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8791956
1 => 43.3440992
]
+"Latitude": 43.3440992
+"Longitude": -79.8791956
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to modern condo living in the heart of Waterdown. This beautifully maintained 1 bedroom + den, 1 bathroom suite at 317-470 Dundas Street East offers 676 sqft of thoughtfully designed living space complete with 1 parking space and 1 locker. Surrounded by shopping, dining, scenic trails, parks, and everyday conveniences, this vibrant location also provides easy access to Burlington, Hamilton, Aldershot GO Station, and Highway 407—perfect for commuters, first-time buyers, professionals, or downsizers seeking stylish low-maintenance living in a growing community. Inside, the bright open-concept layout is filled with natural light from oversized windows and showcases a modern, functional design ideal for both entertaining and everyday living. The kitchen features contemporary cabinetry, stainless steel appliances, stylish backsplash detailing, ample prep space, and a large island with seating overlooking the main living area. The spacious living and dining area offers seamless flow and direct access to the private balcony, creating the perfect extension of your living space. The primary bedroom offers generous closet space, while the den provides excellent flexibility for a home office, guest space, or additional living area. The well-appointed 4pc bathroom features clean contemporary finishes, while convenient in-suite laundry adds everyday practicality. Residents enjoy exceptional building amenities including a rooftop patio with lounge areas and BBQs, fully equipped fitness centre, stylish party room, and secure entry, all while being surrounded by scenic trails, restaurants, shopping, and everyday conveniences just moments away. An excellent opportunity to enjoy low-maintenance living in one of Waterdown’s most connected and fast-growing communities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "593.36"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"CreationDate": "2026-06-11T02:31:33.816947+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1585114"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-10T21:22:04Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T21:22:04Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2844.72"
+"VirtualTourURLUnbranded": "https://youtu.be/CrXWKfetRd4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29885330/470-dundas-street-e-unit-317-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-06-10T21:20:06.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1152418"
+"ListOfficeNationalAssociationId": "1324631"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885330')"
+"ID": "1517900"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25136
+post_id: "1516519"
+post_author: 1
+"ListingKey": "29885333"
+"ListingId": "40837829"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T22:30:14Z"
+"RFModificationTimestamp": "2026-06-10T22:42:25Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 667.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 103, Waterdown, Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.8790704
1 => 43.3433018
]
+"Latitude": 43.3433018
+"Longitude": -79.8790704
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful 1+1 first floor unit is move-in ready with no prior occupants. Outfitted with brand-new stainless-steel appliances, in-suite laundry, walk-in closet, 10-foot ceilings, and a spacious den! Enjoy party rooms, modern fitness facilities with yoga studio, rooftop patios with fully equipped barbeques and bike storage. One locker on same floor & one underground parking space! Short walk to Waterdown village shops, parks and restaurants. 10 min from Aldershot GO, 15 min from downtown Burlington, 18 min to downtown Hamilton. (id:62650)"
+"AssociationFee": "550"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:42:14.169248+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202234"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-10T21:20:15Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T22:20:12Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2600"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29885333/470-dundas-street-e-unit-103-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-10T21:20:15.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1450779"
+"ListOfficeNationalAssociationId": "1223042"
+"Media": array:10 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885333')"
+"ID": "1516519"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: "1516520"
+post_author: 1
+"ListingKey": "29882043"
+"ListingId": "40838516"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T15:40:11Z"
+"RFModificationTimestamp": "2026-06-10T22:16:26Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2120.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "223 SKINNER Road, Hamilton, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8764332
1 => 43.3409083
]
+"Latitude": 43.3409083
+"Longitude": -79.8764332
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A maintenance-free townhome that lives like a detached; and it doesn't come up often on Skinner. This home delivers over 2,100 sq ft of finished, carpet-free living across three bedrooms, three bathrooms, and a true walk-out lower level that sets it apart from every other townhome on the street. The chef-inspired kitchen is the anchor: a 10-ft island built for gathering, white cabinetry paired with gold hardware, stainless appliances, and 9-ft ceilings dotted with pot lights. Open-concept flow connects kitchen, dining, and living for everyday function and effortless entertaining. Upstairs delivers what most townhomes can't: three genuinely large bedrooms, a primary suite that functions as a true escape, and an ensuite finished with the kind of detail you'd expect in a custom build like a massive tub overlooking your backyard. The fully finished basement (2023) walks out to a fully landscaped backyard featuring over 500 sq ft of professionally laid interlock, turf grass, and matured plantings; the rose bush and tulips are already blooming. Add the upper deck (2024) and you've got two outdoor living rooms, three seasons of use, and zero weekend lawn maintenance. Mechanically dialed in: high-efficiency heat pump (2024) for year-round comfort and low operating costs, luxury laminate throughout (2020), and a garage with direct backyard access plus a custom loft (2024) for seasonal storage. Walk to top-rated schools, new parks, and the Waterdown village's cafés and Farmers' Market; with Aldershot GO and 403/407 access making the commute a non-issue. A turnkey home for a family ready to put down roots in one of the area's fastest-growing communities, without inheriting a weekend's worth of upkeep. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:16:25.278777+00:00"
+"Directions": "Skinner and McKnight"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2153302"
+"ListOfficeKey": "300282"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:32:14Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T15:32:13Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "223"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6440.21"
+"VirtualTourURLUnbranded": "https://www.223skinnerroad.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29882043/223-skinner-road-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1497
+"BelowGradeFinishedArea": 623
+"OriginalEntryTimestamp": "2026-06-10T15:32:13.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1404898"
+"ListOfficeNationalAssociationId": "1485466"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882043')"
+"ID": "1516520"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1511803"
+post_author: 1
+"ListingKey": "29877414"
+"ListingId": "40835826"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T19:30:30Z"
+"RFModificationTimestamp": "2026-06-09T19:35:02Z"
+"ListPrice": 1849343.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3247.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P0T2"
+"UnparsedAddress": "1811 OLD WATERDOWN Road, Burlington, Ontario L7P0T2"
+"Coordinates": array:2 [
0 => -79.8748565
1 => 43.3279071
]
+"Latitude": 43.3279071
+"Longitude": -79.8748565
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this stunning country property in the city! As you step inside, you're greeted by soaring vaulted ceilings & bright skylights. The sunken living room features a handpicked stone wood burning FP, with brand new broadloom and large windows. The newly designed open-concept kitchen showcases DeBoers cabinets, Cambria quartz counters, a full suite of s/s appliances. Enjoy cooking on the induction cooktop or relax at the breakfast bar. The kitchen flows effortlessly into the family room, highlighted by custom millwork, bookshelves & FP, while garden doors lead to a spacious wood deck, perfect for outdoor entertaining. Formal dining awaits in an elegant room with large windows & upgraded lighting, while the main floor laundry doubles as a convenient 2pcs washroom, featuring chic hexagon tile & cabinetry. Ascend to the 2nd flr where vaulted ceilings & skylights continue to impress. The expansive primary bedroom boasts an oversized bay window & a luxurious retreat featuring triple closets & a spa-like ensuite w/double vanity w/quartz counters, stand-up shower, soaker tub, & radiant finishes. Two additional bedrooms, each with ample natural light & storage, round out this floor, along with a beautifully appointed 3pc main bathroom.The fully finished basement offers a large recreation room, an additional bedroom w/egress window & closet and substantial storage space. An aggregate stone walkway leads from the driveway to a covered porch, while the serene backyard features a wooden deck accessible from the garden doors. The property includes a MASSIVE detached Garage/Workshop, equipped with an oil-fired furnace & HVAC distribution, underground 60 amp electrical sub-service, 2 10' high insulated garage doors, concrete epoxy floors & includes built in 10 delta Unisaw, 10 Mastercraft radial arm saw & Ingersoll-Ram T10-60 gallon air compressor. Perfect for tradesperson or car enthusiast. This residence offers both privacy and peaceful living close to everything! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:34:48.042596+00:00"
+"Directions": "Waterdown Rd to Old Waterdown Road - follow it south"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533175"
+"ListOfficeKey": "54923"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Country residential"
4 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T18:21:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T19:20:47Z"
+"Stories": "2.0"
+"StreetName": "OLD WATERDOWN"
+"StreetNumber": "1811"
+"StreetSuffix": "Road"
+"SubdivisionName": "302 - Aldershot Central"
+"TaxAnnualAmount": "6944.81"
+"VirtualTourURLUnbranded": "https://track.pstmrk.it/3s/listings.monstermediahouse.com%2Fsites%2F1811-old-waterdown-rd-burlington-on-l7p-0t2-25609094%2Fbranded/cUpU/1enFAQ/AQ/4ba8033d-0d7d-4b4c-a36e-c2dca737e496/2/7fVGk26W4v"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29877414/1811-old-waterdown-road-burlington"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524250"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54923"
+"GeocodeManualYN": true
+"ZoningDescription": "O3-196, RNA1-366"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 2407
+"BelowGradeFinishedArea": 840
+"OriginalEntryTimestamp": "2026-06-09T18:21:07.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1143027"
+"ListOfficeNationalAssociationId": "1003529"
+"CoListAgentNationalAssociationId": "1127411"
+"CoListOfficeNationalAssociationId": "1003529"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877414')"
+"ID": "1511803"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
+post_id: "1511413"
+post_author: 1
+"ListingKey": "29876660"
+"ListingId": "X13420134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:10:12Z"
+"RFModificationTimestamp": "2026-06-10T16:15:37Z"
+"ListPrice": 1265000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T7"
+"UnparsedAddress": "156 MCKNIGHT AVENUE, Hamilton (Waterdown), Ontario L8B0T7"
+"Coordinates": array:2 [
0 => -79.879152
1 => 43.340171
]
+"Latitude": 43.340171
+"Longitude": -79.879152
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 156 McKnight Ave, Waterdown. Step into a home that truly lives as beautifully as it looks. Located in one of Waterdown's most sought after neighbourhoods, this inviting property offers generous, light filled spaces designed for the way modern families actually live. The main floor impresses with large, well-proportioned primary rooms that lend themselves to easy entertaining and everyday comfort, along with a versatile bonus room, perfect as a home office, playroom, or guest space. Natural light pours throughout, creating a warm and welcoming atmosphere at every turn. Downstairs, a spacious unfinished basement presents a blank canvas ready for your vision. Whether that's a recreation room, home gym, or additional living space, the possibilities are yours to define. Outside, enjoy a fully fenced backyard, ideal for kids, pets, and summer gatherings. Set within a beautiful, established neighbourhood that checks every box. Top rated schools, scenic parks, and everyday amenities are all just minutes away. A rare opportunity to settle into a home that offers space, light, and community in equal measure. Don't miss your chance to make 156 McKnight Ave yours. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:05:01.085149+00:00"
+"Directions": "Burke Street & Mcknight Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "47 x 90.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T16:54:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T16:01:53Z"
+"Stories": "2.0"
+"StreetName": "McKnight"
+"StreetNumber": "156"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "7400"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=4Hh24FGSx3e"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876660/156-mcknight-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-39"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.0
+"OriginalEntryTimestamp": "2026-06-09T16:54:49.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876660')"
+"ID": "1511413"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25140
+post_id: "1510179"
+post_author: 1
+"ListingKey": "29875905"
+"ListingId": "40837871"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:30:20Z"
+"RFModificationTimestamp": "2026-06-09T22:34:52Z"
+"ListPrice": 1265000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2160.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T7"
+"UnparsedAddress": "156 MCKNIGHT Avenue, Waterdown, Ontario L8B0T7"
+"Coordinates": array:2 [
0 => -79.8790932
1 => 43.3401803
]
+"Latitude": 43.3401803
+"Longitude": -79.8790932
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 156 McKnight Ave, Waterdown. Step into a home that truly lives as beautifully as it looks. Located in one of Waterdown's most sought after neighbourhoods, this inviting property offers generous, light filled spaces designed for the way modern families actually live. The main floor impresses with large, well-proportioned primary rooms that lend themselves to easy entertaining and everyday comfort, along with a versatile bonus room, perfect as a home office, playroom, or guest space. Natural light pours throughout, creating a warm and welcoming atmosphere at every turn. Downstairs, a spacious unfinished basement presents a blank canvas ready for your vision. Whether that's a recreation room, home gym, or additional living space, the possibilities are yours to define. Outside, enjoy a fully fenced backyard, ideal for kids, pets, and summer gatherings. Set within a beautiful, established neighbourhood that checks every box. Top rated schools, scenic parks, and everyday amenities are all just minutes away. A rare opportunity to settle into a home that offers space, light, and community in equal measure. Don't miss your chance to make 156 McKnight Ave yours. (id:62783)"
+"Appliances": array:1 [
0 => "Central Vacuum - Roughed In"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:52:29.850080+00:00"
+"Directions": "Dundas Street E to Burke Street, to McKnight Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:39:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T22:20:35Z"
+"Stories": "2.0"
+"StreetName": "MCKNIGHT"
+"StreetNumber": "156"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7400"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=4Hh24FGSx3e"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875905/156-mcknight-avenue-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2058648"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "282362"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-39"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2160
+"OriginalEntryTimestamp": "2026-06-09T15:39:37.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1334211"
+"CoListOfficeNationalAssociationId": "1320359"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875905')"
+"ID": "1510179"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 164
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]