array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29689241 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1378042"
+post_author: 1
+"ListingKey": "29689241"
+"ListingId": "X13072468"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-06T16:26:13Z"
+"RFModificationTimestamp": "2026-05-06T16:33:33Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "53 DUNCAN AVENUE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.912685
1 => 43.3261113
]
+"Latitude": 43.3261113
+"Longitude": -79.912685
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 53 Duncan Ave in the heart of Waterdown - a beautifully maintained 5-level backsplit detached offering the perfect blend of space, functionality, and comfort for growing families.This spacious home features 3+1 bedrooms and 4 bathrooms, providing plenty of room for both everyday living and entertaining. The multi-level layout offers distinct living areas, including a bright and inviting main floor, a generous family room, and a fully finished basement that adds valuable living space - ideal for a guest suite, home office, or recreation area.The updated kitchen flows seamlessly into the dining and living areas, creating a warm and welcoming atmosphere. Upstairs, you'll find well-sized bedrooms, including a comfortable primary bedroom with en suite bathroom, The fully finished basement expands your options even further, perfect for extended family living or additional entertainment space.Located in a desirable, family-friendly neighbourhood close to parks, schools, shopping, and all the amenities Waterdown has to offer, this home is a fantastic opportunity you won't want to miss. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-02T01:28:23.936039+00:00"
+"Directions": "Dundas/Hollybush/Longyear/Duncan"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972704"
+"ListOfficeKey": "285271"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40.3 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-06T16:17:06Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-06T16:17:06Z"
+"StreetName": "Duncan"
+"StreetNumber": "53"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5400"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1628803035"
"RoomType" => "Living room"
"ListingId" => "X13072468"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
1 => array:11 [
"RoomKey" => "1628803036"
"RoomType" => "Bedroom 4"
"ListingId" => "X13072468"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
2 => array:11 [
"RoomKey" => "1628803037"
"RoomType" => "Den"
"ListingId" => "X13072468"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
3 => array:11 [
"RoomKey" => "1628803038"
"RoomType" => "Cold room"
"ListingId" => "X13072468"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
4 => array:11 [
"RoomKey" => "1628803039"
"RoomType" => "Dining room"
"ListingId" => "X13072468"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
5 => array:11 [
"RoomKey" => "1628803040"
"RoomType" => "Kitchen"
"ListingId" => "X13072468"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
6 => array:11 [
"RoomKey" => "1628803041"
"RoomType" => "Eating area"
"ListingId" => "X13072468"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
7 => array:11 [
"RoomKey" => "1628803042"
"RoomType" => "Family room"
"ListingId" => "X13072468"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
8 => array:11 [
"RoomKey" => "1628803043"
"RoomType" => "Laundry room"
"ListingId" => "X13072468"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.53Z"
]
9 => array:11 [
"RoomKey" => "1628803044"
"RoomType" => "Bedroom 2"
"ListingId" => "X13072468"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.54Z"
]
10 => array:11 [
"RoomKey" => "1628803045"
"RoomType" => "Bedroom 3"
"ListingId" => "X13072468"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.54Z"
]
11 => array:11 [
"RoomKey" => "1628803046"
"RoomType" => "Bedroom 3"
"ListingId" => "X13072468"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.54Z"
]
12 => array:11 [
"RoomKey" => "1628803047"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13072468"
"RoomLevel" => "Third level"
"RoomWidth" => 1.0
"ListingKey" => "29689241"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-06T16:17:06.54Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29689241/53-duncan-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1891317"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285271"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.3
+"OriginalEntryTimestamp": "2026-05-01T22:42:18.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1259748"
+"ListOfficeNationalAssociationId": "1349718"
+"CoListAgentNationalAssociationId": "1211698"
+"CoListOfficeNationalAssociationId": "1349718"
+"Media": array:25 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6657560732"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/91798bdbd265c7a455db196ec6c8b0ea.webp"
"MediaSize" => 239066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-91798bdbd265c7a455db196ec6c8b0ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:47.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6657560744"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/ade491f8d75a71488222ef99673294a9.webp"
"MediaSize" => 212149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-ade491f8d75a71488222ef99673294a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:43.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6657560773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/1bede1a3ebdc8a8dc1936f891b4c32a4.webp"
"MediaSize" => 132525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-1bede1a3ebdc8a8dc1936f891b4c32a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:04.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6657560802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/ace136ba51a91f9a1f7f1f112b976415.webp"
"MediaSize" => 117473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-ace136ba51a91f9a1f7f1f112b976415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:47.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6657560830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/5897bc2bd3833b1feddcf06307fb2587.webp"
"MediaSize" => 71395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-5897bc2bd3833b1feddcf06307fb2587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:53.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6657560843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/f44a7f747d8eb8926433ead4d6ba0ad4.webp"
"MediaSize" => 227389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-f44a7f747d8eb8926433ead4d6ba0ad4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:03.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6657560851"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/4ea914d538114155aa6c62ba28103d23.webp"
"MediaSize" => 65379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-4ea914d538114155aa6c62ba28103d23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:11.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6657560876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/e5d00011b53d314a79cbafa3a917dba1.webp"
"MediaSize" => 79042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-e5d00011b53d314a79cbafa3a917dba1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:47.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6657560897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/dfdac6e718f9eb03d0e4f919c6250537.webp"
"MediaSize" => 71985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-dfdac6e718f9eb03d0e4f919c6250537.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:53.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6657560949"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/c261d4417f0ee5ceb105a5965a0e165f.webp"
"MediaSize" => 75620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-c261d4417f0ee5ceb105a5965a0e165f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:53.13Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6657560995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/f3a1a72cc59a3571183b04dc8e854f16.webp"
"MediaSize" => 200971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-f3a1a72cc59a3571183b04dc8e854f16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:02.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6657561004"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/9b02bc14bbef6a528de559606c9942cc.webp"
"MediaSize" => 90384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-9b02bc14bbef6a528de559606c9942cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:42.71Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6657561034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/b8031007d8610967795fcc0d75428219.webp"
"MediaSize" => 211147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-b8031007d8610967795fcc0d75428219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:48.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6657561039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/4a69dc549c30f7098d0bd083e3a3ffc8.webp"
"MediaSize" => 57709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-4a69dc549c30f7098d0bd083e3a3ffc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:54.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6657561073"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/bf15dffd542a02bb051ab79c5ab5b82f.webp"
"MediaSize" => 76745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-bf15dffd542a02bb051ab79c5ab5b82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:02.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6657561097"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/80a3398743fe62e61d97172fdec51804.webp"
"MediaSize" => 72945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-80a3398743fe62e61d97172fdec51804.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:42.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6657561187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/23e93624e1cba6e3defa60e132d436b5.webp"
"MediaSize" => 91433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-23e93624e1cba6e3defa60e132d436b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:48.09Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6657561224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/58980003dcc75544349bbfd434f299a3.webp"
"MediaSize" => 63702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-58980003dcc75544349bbfd434f299a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:53.87Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6657610982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/d354630c4b7380e35b4db5a299b9b313.webp"
"MediaSize" => 271011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-d354630c4b7380e35b4db5a299b9b313.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:03.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6657611075"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/cb46d6bb16f1b1c267d6e9dfcf581e97.webp"
"MediaSize" => 89631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-cb46d6bb16f1b1c267d6e9dfcf581e97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:49.16Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6657611093"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/69864890e179bb0db058555a8170f0cf.webp"
"MediaSize" => 56938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-69864890e179bb0db058555a8170f0cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:56.38Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6657611198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/a149f27aef37dcfb9c696bae68583cbf.webp"
"MediaSize" => 84671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-a149f27aef37dcfb9c696bae68583cbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:03:02.73Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6657611322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/98599e683a8bd734dfe99a8af7f41918.webp"
"MediaSize" => 81608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-98599e683a8bd734dfe99a8af7f41918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:43.82Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6657611422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/d10f9f953af803def126106303d89dc6.webp"
"MediaSize" => 80883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-d10f9f953af803def126106303d89dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:49.68Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6657611527"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29689241/902175accf9152b01fce64528b2e67b1.webp"
"MediaSize" => 87307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29689241/thumbnail-902175accf9152b01fce64528b2e67b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13072468"
"ResourceRecordKey" => "29689241"
"ModificationTimestamp" => "2026-05-06T16:02:56.23Z"
]
]
+"DaysOnMarket": 57
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29689241')"
+"ID": "1378042"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285271" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24840
+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 1972704" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24875
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29689241'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25215
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29689241'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25231
+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 '29689241' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.912685 43.3261113)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1571912"
+post_author: 1
+"ListingKey": "29960542"
+"ListingId": "X13495616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:02Z"
+"RFModificationTimestamp": "2026-06-26T23:04:46Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X1"
+"UnparsedAddress": "14 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X1"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained and move-in-ready corner-unit townhouse offering approximately 1,800 sq. ft. of bright and functional living space. This spacious home features 3+1 bedrooms, 3 bathrooms, a double-car garage, plus 2 additional driveway parking spaces. The desirable corner location allows for an abundance of natural light through numerous windows throughout the home. Enjoy an open-concept kitchen overlooking the dining area, complete with a large pantry and excellent storage space. The well-designed layout includes generously sized bedrooms and a primary suite with an ensuite bath. An unfinished basement offers exceptional potential for future customization and added living space while providing ample storage. Relax on the private balcony with gas hookups and enjoy comfortable, low-maintenance living in a sought-after, family-friendly community. Ideally located with exceptional accessibility, this home is just minutes from major highways, shopping centres, schools, parks, restaurants, and all everyday amenities, making it a perfect choice for families seeking both convenience and comfort. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:04:38.815915+00:00"
+"Directions": "Hamilton St N / Dundas St E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946962"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:00Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:00Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6356.58"
+"View": "View"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960542/14-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1892161"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 905-540-8800"
+"CoListOfficeKey": "50236"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "R6-33"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T20:48:00.12Z"
+"ListAgentNationalAssociationId": "1241888"
+"ListOfficeNationalAssociationId": "1002993"
+"CoListAgentNationalAssociationId": "1212143"
+"CoListOfficeNationalAssociationId": "1002993"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29960542_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/85e36632dca1380886f7f93b23e05535.webp"
"MediaSize" => 448451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-85e36632dca1380886f7f93b23e05535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29960542_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/34bb3d7129d44760177fc7824cc059eb.webp"
"MediaSize" => 448927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-34bb3d7129d44760177fc7824cc059eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29960542_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/64365beed3d8b7981a27262036f55ce2.webp"
"MediaSize" => 211082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-64365beed3d8b7981a27262036f55ce2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29960542_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/11a836ff0ef5fb29a6fc9a543c7353a8.webp"
"MediaSize" => 277863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-11a836ff0ef5fb29a6fc9a543c7353a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29960542_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/e85d7942ba081725001774266be539ea.webp"
"MediaSize" => 276073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-e85d7942ba081725001774266be539ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29960542_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/1c8dc41f9b94a6ed65516b9389c6be41.webp"
"MediaSize" => 274044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-1c8dc41f9b94a6ed65516b9389c6be41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29960542_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/8bd4522cd3d1cd661cf0eca1064b0382.webp"
"MediaSize" => 277342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-8bd4522cd3d1cd661cf0eca1064b0382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29960542_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/816bb7e334ada8a0f62c70240031dc83.webp"
"MediaSize" => 228616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-816bb7e334ada8a0f62c70240031dc83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29960542_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/4e3c77e6fc802a1e2ff264848f35cad9.webp"
"MediaSize" => 227330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-4e3c77e6fc802a1e2ff264848f35cad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29960542_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/1c01defb5f2fdec6a5a634bcd0daf710.webp"
"MediaSize" => 244291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-1c01defb5f2fdec6a5a634bcd0daf710.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29960542_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/25844c4c07980dae3c5c3fd0aa249fc6.webp"
"MediaSize" => 293213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-25844c4c07980dae3c5c3fd0aa249fc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29960542_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/38d7a67573af324021e54a367764f559.webp"
"MediaSize" => 225886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-38d7a67573af324021e54a367764f559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29960542_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/0579ed04017fc474819e28a3f0324b33.webp"
"MediaSize" => 153173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-0579ed04017fc474819e28a3f0324b33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29960542_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/993cb387627d7cfa772c9b6856fc55d8.webp"
"MediaSize" => 249657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-993cb387627d7cfa772c9b6856fc55d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29960542_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/f633ea05f85e07a987bea1873223b8d3.webp"
"MediaSize" => 266353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-f633ea05f85e07a987bea1873223b8d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29960542_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/5f75f93b331c8d5311d11274723ee482.webp"
"MediaSize" => 244923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-5f75f93b331c8d5311d11274723ee482.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29960542_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/cfe76ba0621a479b48265fd2f8fff6f2.webp"
"MediaSize" => 218141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-cfe76ba0621a479b48265fd2f8fff6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29960542_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/87965cbd3ce534ffc32e36ec0f3df9ce.webp"
"MediaSize" => 153434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-87965cbd3ce534ffc32e36ec0f3df9ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29960542_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/cf077710710c852d398132476f77f6d5.webp"
"MediaSize" => 190288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-cf077710710c852d398132476f77f6d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29960542_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/fd1f965c9e8e42971e819a57fc22cf53.webp"
"MediaSize" => 196054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-fd1f965c9e8e42971e819a57fc22cf53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29960542_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/bceba4f56642f8b878bceafaabac48e9.webp"
"MediaSize" => 181211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-bceba4f56642f8b878bceafaabac48e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29960542_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/b101f0f2b90b94d7dfddb77a31153859.webp"
"MediaSize" => 178035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-b101f0f2b90b94d7dfddb77a31153859.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29960542_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/373e7f1bcefe0a366d096325d85579af.webp"
"MediaSize" => 208921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-373e7f1bcefe0a366d096325d85579af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29960542_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/6d554d4299c0bb51063ec878c398e5b3.webp"
"MediaSize" => 241791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-6d554d4299c0bb51063ec878c398e5b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29960542_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/2603b98a0098939918d10e8a01986288.webp"
"MediaSize" => 189583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-2603b98a0098939918d10e8a01986288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29960542_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/d5cec9eaed44db00c5b1a57ea0735ee7.webp"
"MediaSize" => 216038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-d5cec9eaed44db00c5b1a57ea0735ee7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29960542_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/626640c2331f0ca23fb8856f7eae69ae.webp"
"MediaSize" => 178471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-626640c2331f0ca23fb8856f7eae69ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29960542_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/609dc7ac75f779b6f304d606f3e5b800.webp"
"MediaSize" => 205977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-609dc7ac75f779b6f304d606f3e5b800.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29960542_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/c5e525e484858b8e89cd05960aa879f9.webp"
"MediaSize" => 154817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-c5e525e484858b8e89cd05960aa879f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29960542_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/5ea3d9ae4513c9ab323636c70e3726da.webp"
"MediaSize" => 315822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-5ea3d9ae4513c9ab323636c70e3726da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29960542_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/a3b9391798926e843eb7c17cd4b9cbed.webp"
"MediaSize" => 271855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-a3b9391798926e843eb7c17cd4b9cbed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29960542_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/fed5bd480c162c7bf33212e04b577e21.webp"
"MediaSize" => 290050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-fed5bd480c162c7bf33212e04b577e21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29960542_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/e996fada227687cf3a80c2140862ddca.webp"
"MediaSize" => 386302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-e996fada227687cf3a80c2140862ddca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29960542_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29960542/da52fa69409199309c813fa27ca6e354.webp"
"MediaSize" => 317752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29960542/thumbnail-da52fa69409199309c813fa27ca6e354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13495616"
"ResourceRecordKey" => "29960542"
"ModificationTimestamp" => "2026-06-26T20:48:00.13Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960542')"
+"ID": "1571912"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1567901"
+post_author: 1
+"ListingKey": "29956109"
+"ListingId": "X13491706"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T03:20:11Z"
+"RFModificationTimestamp": "2026-06-27T03:20:34Z"
+"ListPrice": 1089000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S6"
+"UnparsedAddress": "28 BABCOCK STREET, Hamilton (Waterdown), Ontario L8B0S6"
+"Coordinates": array:2 [
0 => -79.913238
1 => 43.336236
]
+"Latitude": 43.336236
+"Longitude": -79.913238
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 28 Babcock Street, an impeccably upgraded home in the quaint, highly sought-after community of Waterdown. This residence offers nearly 3,000 sq ft of total living space, featuring three large bedrooms & 2.5 bathrooms, and convenient second-floor laundry. Situated on a family friendly street, this property is truly exceptional, showcasing over $100,000 in quality upgrades. The interior boasts a sophisticated aesthetic, with the entire house repainted in elegant Farrow and Ball colours. Nine-foot ceilings and hardwood floors span the main level, which features a beautiful open-concept living room anchored by a cozy gas fireplace. The eat-in kitchen offers plentiful countertop space with marble-top designer island & ample storage, upgraded painted cabinets, granite countertops & stainless steel appliances. Key design elements include a striking black and white main stairwell and new designer lighting throughout. Light dimmers are installed in all main living areas for perfect ambiance. The basement has been fully finished to provide highly flexible space, featuring a large recreation room, and a versatile separate room - perfectly suited for an office, home gym, or playroom. Curb appeal abounds this professionally landscaped property with a front yard boasting a redesigned walkway using engineered & natural stones, and wrought iron railing. The backyard has been entirely transformed into a luxurious, highly functional outdoor entertaining area, highlighted by modern large interlock and an extensive sitting wall for relaxation and hosting. The location is unbeatable, offering a real community atmosphere and unparalleled convenience. It's just a few minutes' walk from Waterdown District High School and the YMCA, and within easy walking distance to multiple schools, trails, parks, shopping, and restaurants. This home truly ticks all the boxes for family-friendly living in a desirable Waterdown setting! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T04:59:06.262023+00:00"
+"Directions": "Babcock St & Nisbet Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909594"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "34.8 x 88.6 M"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T00:45:10Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T03:12:52Z"
+"Stories": "2.0"
+"StreetName": "Babcock"
+"StreetNumber": "28"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7506.6"
+"VirtualTourURLUnbranded": "https://matthewprior.ca/28-babcock-st-hamilton?fromCms=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1669121452"
…10
]
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956109/28-babcock-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 34.78
+"OriginalEntryTimestamp": "2026-06-26T00:45:10.62Z"
+"FrontageLengthNumericUnits": "meters"
+"ListAgentNationalAssociationId": "1221920"
+"ListOfficeNationalAssociationId": "1364605"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956109')"
+"ID": "1567901"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1567003"
+post_author: 1
+"ListingKey": "29946398"
+"ListingId": "X13482892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:00:19Z"
+"RFModificationTimestamp": "2026-06-26T03:23:48Z"
+"ListPrice": 1325000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J6"
+"UnparsedAddress": "31 COMMANDO COURT, Hamilton (Waterdown), Ontario L8B0J6"
+"Coordinates": array:2 [
0 => -79.903711
1 => 43.329889
]
+"Latitude": 43.329889
+"Longitude": -79.903711
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "If you have been looking for an exclusive court enclave in Waterdown, we have the perfect opportunity for you! 31 Commando Court, nestled in a quiet part of town, offers privacy and excellent walkability. This 4-bedroom, 2.5-bath home boasts over 2,500 sq ft of finished living space, an unfinished basement awaiting your final touches, and a double-car garage. Step inside to discover a beautiful staircase, open-concept layout, and gleaming strip hardwood flooring throughout the main level. Designed for comfort and functionality, this floor features a formal dining room, spacious eat-in kitchen, inviting living area, and a front-facing office perfect for working from home or a playroom. The dining room connects seamlessly to the family room through elegant pocket doors, creating an ideal space for entertaining. The updated eat-in kitchen showcases white cabinetry, quartz countertops, tile backsplash, peninsula seating, and a walkout to the concrete patio. Open to the living room, this space is highlighted by a stunning stone fireplace and expansive windows overlooking the private backyard and desirable court setting. The upper level features a thoughtfully designed split floor plan, providing the primary retreat with exceptional privacy. This inviting space includes a large built-in wall closet, front-facing picture windows, and a spa-like 4-piece ensuite. Three additional bedrooms offer hardwood flooring, picture windows, and double closets. A spacious 4-piece main bath, double linen closet, and convenient upper-level laundry add to this well-designed floor's functionality. The unfinished basement presents an excellent opportunity to create additional living space, complete with a rough-in for a future bathroom. Outdoors, enjoy a large stamped concrete patio, iron fencing, and ample space for a pool, play area, or other amenities. Situated on one of Waterdown's most sought-after streets, this exceptional property offers the perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:22:28.727807+00:00"
+"Directions": "Hamilton St N & Parkside Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "302161"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "48.3 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T14:51:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:51:08Z"
+"Stories": "2.0"
+"StreetName": "Commando"
+"StreetNumber": "31"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "8000"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/31-commando-ct-hamilton-on-l8b-0j6-25408789/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946398/31-commando-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-24"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 48.3
+"OriginalEntryTimestamp": "2026-06-24T14:51:08.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246196"
+"ListOfficeNationalAssociationId": "1499250"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946398')"
+"ID": "1567003"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1566854"
+post_author: 1
+"ListingKey": "29955785"
+"ListingId": "X13491468"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:25:17Z"
+"RFModificationTimestamp": "2026-06-26T01:41:30Z"
+"ListPrice": 759999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7N3"
+"UnparsedAddress": "9 - 122 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7N3"
+"Coordinates": array:2 [
0 => -79.9071568
1 => 43.3200318
]
+"Latitude": 43.3200318
+"Longitude": -79.9071568
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish spacious 3-bedroom townhome nestled in the heart of Waterdown, ideal for first-time buyers and young professionals. Thoughtfully designed layout offers bright, open-concept living with contemporary finishes throughout. Modern kitchen with ample cabinetry and prep space flows seamlessly into the living and dining areas, perfect for entertaining. Generous bedrooms provide comfort and flexibility for work-from home or guest space. Large comfortable primary suite with a 4-piece ensuite. Outdoor patio area extends your living space for summer evenings and morning coffee. Well-managed complex with visitor parking and a strong sense of community. Conveniently located close to Rockcliffe trails, shops, cafes, parks, and everyday amenities. Easy access to major highways makes commuting effortless. A fantastic opportunity to enter the market in one of Waterdown's most in demand neighbourhoods. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "239.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:41:27.793387+00:00"
+"Directions": "Cross Streets: Dundas & Hollybush. ** Directions: South of Dundas."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154241"
+"ListOfficeKey": "290346"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T23:19:15Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:19:15Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "122"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3788"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/9_122_dundas_st_e_waterdown_on/"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29955785/9-122-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Arthrex Property Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R6-36"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-25T23:19:14.89Z"
+"ListAgentNationalAssociationId": "1405758"
+"ListOfficeNationalAssociationId": "1386100"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955785')"
+"ID": "1566854"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1565407"
+post_author: 1
+"ListingKey": "29947056"
+"ListingId": "X13483738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:55:03Z"
+"RFModificationTimestamp": "2026-06-26T01:08:52Z"
+"ListPrice": 1379999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0N9"
+"UnparsedAddress": "5 SHETLAND DRIVE, Hamilton (Waterdown), Ontario L8B0N9"
+"Coordinates": array:2 [
0 => -79.914081
1 => 43.324933
]
+"Latitude": 43.324933
+"Longitude": -79.914081
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 5 Shetland Dr in the heart of Waterdown, a fully updated home that blends timeless design with high end, executive finishes throughout. Every detail has been thoughtfully curated, offering a true turnkey experience for today's modern buyer. The main level showcases stunning updates completed in 2021, including a custom kitchen with a large island, updated hardwood flooring, a striking new main staircase, and elegant coffered and California knockdown ceilings. Natural light pours in through updated windows, while a custom fiberglass front door with a Euro locking system adds both style and security. Upstairs, all bathrooms have been beautifully renovated, highlighted by a luxurious ensuite featuring in floor heating and a towel warmer, creating a spa like retreat right at home. The fully finished basement, completed in 2022, adds incredible versatility with a kitchenette and bar setup, offering excellent in law potential or the perfect space for entertaining. Step outside to enjoy a professionally finished 20 x 20 stamped concrete patio, ideal for relaxing or hosting summer gatherings. Additional updates include the roof in 2016, garage doors and openers in 2018, and California shutters installed in 2022. Located in one of Waterdown's most desirable neighbourhoods, this home offers refined living with nothing left to do but move in and enjoy. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:08:49.072465+00:00"
+"Directions": "Cross Streets: Holybush & Arnhem. ** Directions: Hoilybush to Arnhem Crt to Shetland Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"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": "49.9 x 127.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:49:58Z"
+"Stories": "2.0"
+"StreetName": "Shetland"
+"StreetNumber": "5"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7602.72"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=XL7yVjgL3Px"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29947056/5-shetland-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.1
+"OriginalEntryTimestamp": "2026-06-24T16:17:48.09Z"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947056')"
+"ID": "1565407"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1562606"
+post_author: 1
+"ListingKey": "29953558"
+"ListingId": "X13487868"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:12Z"
+"RFModificationTimestamp": "2026-06-25T21:11:05Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9B1A9"
+"UnparsedAddress": "311 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to a truly rare offering-this top-floor, end-unit condo delivers an exceptional level of privacy, quiet, and space that is seldom found. With no neighbours above or beside, this home offers a peaceful, almost penthouse-like experience (without the penthouse price tag), tucked away in a private section of a solid, well-built building. Thoughtfully renovated from top to bottom, this spacious unit features a flexible layout with 3 bedrooms or 2 bedrooms plus a den-ideal for families, downsizers, or anyone seeking room to live and work comfortably. The openconcept kitchen has been beautifully updated with modern cabinetry and appliances, seamlessly connecting to the bright living and dining areas. Soaring ceilings and large south-facing windows flood the space with natural light, while patio doors lead to two private balconies overlooking mature trees-creating a serene, retreat-like atmosphere rarely found in condo living. The home continues to impress with new hardwood floors, updated bathrooms (including an ensuite), in-suite laundry, large bedrooms, and a walk-in closet. Storage is exceptional, highlighted by an unusually large storage locker-perfect for seasonal items, sports equipment, or downsizing without compromise. Additional features include two underground parking spaces, access to a common room for gatherings, and low-maintenance living with landscaping, maintenance, and snow removal all taken care of. Located in a highly convenient, walkable neighbourhood close to shopping, downtown, and parks including Memorial Park, this home offers the perfect balance of tranquility and accessibility. Rarely do units like this become available-quiet, private, spacious, and move-in ready. A unique opportunity for those seeking the ease of condo living without sacrificing space, light, or lifestyle. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"AssociationFee": "845"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:10:52.008176+00:00"
+"Directions": "Cross Streets: HWY 6 and Dundas. ** Directions: Main and Dundas."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132710"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Street"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:25Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:36:25Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4594.34"
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953558/311-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-25T18:36:25.58Z"
+"ListAgentNationalAssociationId": "1385379"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953558')"
+"ID": "1562606"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23460
+post_id: "1562247"
+post_author: 1
+"ListingKey": "29951143"
+"ListingId": "40842956"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T14:40:09Z"
+"RFModificationTimestamp": "2026-06-25T20:56:08Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 DUNDAS Street E Unit# 311, Hamilton, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8961688
1 => 43.3300384
]
+"Latitude": 43.3300384
+"Longitude": -79.8961688
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly rare offering-this top-floor, end-unit condo delivers an exceptional level of privacy, quiet, and space that is seldom found. With no neighbours above or beside, this home offers a peaceful, almost penthouse-like experience (without the penthouse price tag), tucked away in a private section of a solid, well-built building. Thoughtfully renovated from top to bottom, this spacious unit features a flexible layout with 3 bedrooms or 2 bedrooms plus a den-ideal for families, downsizers, or anyone seeking room to live and work comfortably. The openconcept kitchen has been beautifully updated with modern cabinetry and appliances, seamlessly connecting to the bright living and dining areas. Soaring ceilings and large south-facing windows flood the space with natural light, while patio doors lead to two private balconies overlooking mature trees-creating a serene, retreat-like atmosphere rarely found in condo living. The home continues to impress with new hardwood floors, updated bathrooms (including an ensuite), in-suite laundry, large bedrooms, and a walk-in closet. Storage is exceptional, highlighted by an unusually large storage locker-perfect for seasonal items, sports equipment, or downsizing without compromise. Additional features include two underground parking spaces, access to a common room for gatherings, and low-maintenance living with landscaping, maintenance, and snow removal all taken care of. Located in a highly convenient, walkable neighbourhood close to shopping, downtown, and parks including Memorial Park, this home offers the perfect balance of tranquility and accessibility. Rarely do units like this become available-quiet, private, spacious, and move-in ready. A unique opportunity for those seeking the ease of condo living without sacrificing space, light, or lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "845"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:54:44.348763+00:00"
+"Directions": "HWY 6 and Dundas St. E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1724159"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-25T14:11:05Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T14:31:58Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4594.34"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951143/262-dundas-street-e-unit-311-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1322
+"OriginalEntryTimestamp": "2026-06-25T14:11:04.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1314305"
+"ListOfficeNationalAssociationId": "1372539"
+"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('29951143')"
+"ID": "1562247"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1561960"
+post_author: 1
+"ListingKey": "29952743"
+"ListingId": "40843021"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:00:06Z"
+"RFModificationTimestamp": "2026-06-25T20:30:09Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1225.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0A2"
+"UnparsedAddress": "12 HISCOTT Drive, Waterdown, Ontario L8B0A2"
+"Coordinates": array:2 [
0 => -79.9078504
1 => 43.3393498
]
+"Latitude": 43.3393498
+"Longitude": -79.9078504
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained home nestled in a quiet, friendly community in an exceptional location. Enjoy the convenience of being just a short walk to the YMCA-YWCA, parks, shopping, schools, hwy access and everyday amenities, making it an ideal setting for families, professionals, and anyone seeking a connected lifestyle. Step inside to a welcoming foyer with direct access to the garage and a spacious laundry room offering plenty of valuable storage space. Upstairs, the bright and airy main living area showcases 9-foot ceilings, wide plank flooring, and a unique open-concept design that creates an inviting atmosphere for both everyday living and entertaining. The stylish kitchen features a breakfast bar that overlooks the living and dining areas, making it easy to stay connected with family and guests. Start your day with a coffee or unwind in the evening with a glass of wine on the cozy private terrace—your own outdoor retreat. The spacious primary bedroom offers a peaceful escape, complete with a walk-in closet and private ensuite bath. Combining comfort, functionality, and an outstanding location, this is a home you'll be proud to call your own. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:24:25.415636+00:00"
+"Directions": "Parkside Drive to Cole Street to Hugill Way to Hiscott Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1727252"
+"ListOfficeKey": "294391"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T17:53:30Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T17:53:30Z"
+"Stories": "3.0"
+"StreetName": "HISCOTT"
+"StreetNumber": "12"
+"StreetSuffix": "Drive"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4748.48"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/12_hiscott_dr_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29952743/12-hiscott-drive-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1225
+"OriginalEntryTimestamp": "2026-06-25T17:52:02.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1176083"
+"ListOfficeNationalAssociationId": "1438340"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952743')"
+"ID": "1561960"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1562248"
+post_author: 1
+"ListingKey": "29953943"
+"ListingId": "X13489814"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:25Z"
+"RFModificationTimestamp": "2026-06-25T20:29:02Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A2"
+"UnparsedAddress": "12 HISCOTT DRIVE, Hamilton (Waterdown), Ontario L8B0A2"
+"Coordinates": array:2 [
0 => -79.907846
1 => 43.33935
]
+"Latitude": 43.33935
+"Longitude": -79.907846
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained home nestled in a quiet, friendly community in an exceptional location. Enjoy the convenience of being just a short walk to the YMCA-YWCA, parks, shopping, schools, hwy access and everyday amenities, making it an ideal setting for families, professionals, and anyone seeking a connected lifestyle.Step inside to a welcoming foyer with direct access to the garage and a spacious laundry room offering plenty of valuable storage space. Upstairs, the bright and airy main living area showcases 9-foot ceilings, wide plank flooring, and a unique open-concept design that creates an inviting atmosphere for both everyday living and entertaining. The stylish kitchen features a breakfast bar that overlooks the living and dining areas, making it easy to stay connected with family and guests.Start your day with a coffee or unwind in the evening with a glass of wine on the cozy private terrace-your own outdoor retreat. The spacious primary bedroom offers a peaceful escape, complete with a walk-in closet and private ensuite bath. Combining comfort, functionality, and an outstanding location, this is a home you'll be proud to call your own. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater - Tankless"
7 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:21:29.789700+00:00"
+"Directions": "Cross Streets: Centre Road and Parkside Drive. ** Directions: Parkside to Centre to Cole to Humill to Hiscott."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1938192"
+"ListOfficeKey": "294503"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "19.7 x 49.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:58:51Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:51Z"
+"Stories": "3.0"
+"StreetName": "Hiscott"
+"StreetNumber": "12"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4748.48"
+"VirtualTourURLUnbranded": "https://youriguide.com/12_hiscott_dr_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953943/12-hiscott-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-25T18:58:51.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1236297"
+"ListOfficeNationalAssociationId": "1439741"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953943')"
+"ID": "1562248"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]