array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29956109 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1567901"
+post_author: 1
+"ListingKey": "29956109"
+"ListingId": "X13491706"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T00:55:01Z"
+"RFModificationTimestamp": "2026-06-26T04:59:45Z"
+"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)"
+"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-26T00:45:10Z"
+"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" => "1668197114"
"RoomType" => "Dining room"
"ListingId" => "X13491706"
"RoomLevel" => "Main level"
"RoomWidth" => 3.09
"ListingKey" => "29956109"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.7Z"
]
1 => array:11 [
"RoomKey" => "1668197115"
"RoomType" => "Living room"
"ListingId" => "X13491706"
"RoomLevel" => "Main level"
"RoomWidth" => 4.88
"ListingKey" => "29956109"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.71Z"
]
2 => array:11 [
"RoomKey" => "1668197116"
"RoomType" => "Kitchen"
"ListingId" => "X13491706"
"RoomLevel" => "Main level"
"RoomWidth" => 3.18
"ListingKey" => "29956109"
"RoomLength" => 2.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.71Z"
]
3 => array:11 [
"RoomKey" => "1668197117"
"RoomType" => "Bedroom"
"ListingId" => "X13491706"
"RoomLevel" => "Second level"
"RoomWidth" => 4.99
"ListingKey" => "29956109"
"RoomLength" => 3.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.71Z"
]
4 => array:11 [
"RoomKey" => "1668197118"
"RoomType" => "Bedroom 2"
"ListingId" => "X13491706"
"RoomLevel" => "Second level"
"RoomWidth" => 3.53
"ListingKey" => "29956109"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.71Z"
]
5 => array:11 [
"RoomKey" => "1668197119"
"RoomType" => "Bedroom 3"
"ListingId" => "X13491706"
"RoomLevel" => "Second level"
"RoomWidth" => 4.65
"ListingKey" => "29956109"
"RoomLength" => 3.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.71Z"
]
6 => array:11 [
"RoomKey" => "1668197120"
"RoomType" => "Laundry room"
"ListingId" => "X13491706"
"RoomLevel" => "Second level"
"RoomWidth" => 1.82
"ListingKey" => "29956109"
"RoomLength" => 2.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.72Z"
]
7 => array:11 [
"RoomKey" => "1668197121"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13491706"
"RoomLevel" => "Basement"
"RoomWidth" => 7.73
"ListingKey" => "29956109"
"RoomLength" => 5.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.72Z"
]
8 => array:11 [
"RoomKey" => "1668197122"
"RoomType" => "Playroom"
"ListingId" => "X13491706"
"RoomLevel" => "Basement"
"RoomWidth" => 4.37
"ListingKey" => "29956109"
"RoomLength" => 3.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.72Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29956109_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/702e9917e201b4ae17a57c0a8fc4a0de.webp"
"MediaSize" => 298936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-702e9917e201b4ae17a57c0a8fc4a0de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29956109_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/bddfd9093415661f92c650690d6389cd.webp"
"MediaSize" => 243770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-bddfd9093415661f92c650690d6389cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29956109_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/a30fc69f97b13f660b520e183225959a.webp"
"MediaSize" => 334347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-a30fc69f97b13f660b520e183225959a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29956109_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/58ee89291c35d0866286e8fb9b38bc76.webp"
"MediaSize" => 290347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-58ee89291c35d0866286e8fb9b38bc76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29956109_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/2b1b4fd225b88c505286666c714e19d4.webp"
"MediaSize" => 115620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-2b1b4fd225b88c505286666c714e19d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29956109_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/141db74c005e3ce5334d758f77f99ed4.webp"
"MediaSize" => 162088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-141db74c005e3ce5334d758f77f99ed4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29956109_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/ae48fe8682a05460fcd1aafb9510f667.webp"
"MediaSize" => 130206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-ae48fe8682a05460fcd1aafb9510f667.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29956109_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/a53de29c24bec2a3dc281884b0cf91a0.webp"
"MediaSize" => 159517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-a53de29c24bec2a3dc281884b0cf91a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29956109_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/396f86e3856a3537cc04e1b3a62272e6.webp"
"MediaSize" => 130813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-396f86e3856a3537cc04e1b3a62272e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29956109_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/1b2db243d98a86099806cc26075a61e5.webp"
"MediaSize" => 156131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-1b2db243d98a86099806cc26075a61e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29956109_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/5476df4375b08479f5456ed58a5e6447.webp"
"MediaSize" => 136611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-5476df4375b08479f5456ed58a5e6447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29956109_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/fb244cab3f09b17a9a54ccd08608105b.webp"
"MediaSize" => 122718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-fb244cab3f09b17a9a54ccd08608105b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29956109_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/ba663b738557ccaa1289c3193ba3877b.webp"
"MediaSize" => 133313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-ba663b738557ccaa1289c3193ba3877b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29956109_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/3f83694c568929211aa4822ca45fe0e2.webp"
"MediaSize" => 144297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-3f83694c568929211aa4822ca45fe0e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29956109_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/379a6167232c19075172806750d49a91.webp"
"MediaSize" => 148843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-379a6167232c19075172806750d49a91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29956109_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/62672538ec5ebe2d6e31ee7ce3fdffd0.webp"
"MediaSize" => 167411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-62672538ec5ebe2d6e31ee7ce3fdffd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29956109_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/b5efeb205c04382ba2eb1b04a44a8562.webp"
"MediaSize" => 134476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-b5efeb205c04382ba2eb1b04a44a8562.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29956109_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/d2d1046bb8c111c7008f9b281cd0fac1.webp"
"MediaSize" => 146471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-d2d1046bb8c111c7008f9b281cd0fac1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29956109_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/10d93b040dcce2486c8de20c9669a952.webp"
"MediaSize" => 139609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-10d93b040dcce2486c8de20c9669a952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29956109_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/5b0241451d6ad6e1763fb3313950f8b3.webp"
"MediaSize" => 87604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-5b0241451d6ad6e1763fb3313950f8b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29956109_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/32b258022b8faa1c36ffdcf040059ad9.webp"
"MediaSize" => 119001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-32b258022b8faa1c36ffdcf040059ad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29956109_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/f7bc2192aacd12d2de4e9ee9be142ec0.webp"
"MediaSize" => 121873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-f7bc2192aacd12d2de4e9ee9be142ec0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29956109_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/b6d2b9656a0d8f757ded4efb1f5f353c.webp"
"MediaSize" => 193290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-b6d2b9656a0d8f757ded4efb1f5f353c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29956109_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/b1b3e1182879740859b7e5e153af35f6.webp"
"MediaSize" => 140362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-b1b3e1182879740859b7e5e153af35f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29956109_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/3806134b6a3f36c870c50d030c109a79.webp"
"MediaSize" => 143349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-3806134b6a3f36c870c50d030c109a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29956109_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/8ce090ccbd1300dffc308e5e78c1ed72.webp"
"MediaSize" => 115801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-8ce090ccbd1300dffc308e5e78c1ed72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29956109_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/8e402627af73c24be5066153e9e64fa7.webp"
"MediaSize" => 210869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-8e402627af73c24be5066153e9e64fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29956109_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/75c99b320afc3dd8f7037cf49bc04ccb.webp"
"MediaSize" => 145961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-75c99b320afc3dd8f7037cf49bc04ccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29956109_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/de312717b6953daf06a1034ad1367a9d.webp"
"MediaSize" => 145101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-de312717b6953daf06a1034ad1367a9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29956109_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/00a8a5e705bc5ea7c376b7c7482ba6f9.webp"
"MediaSize" => 129560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-00a8a5e705bc5ea7c376b7c7482ba6f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29956109_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/371e13b43b288c8ccfd6a8f94602ce8c.webp"
"MediaSize" => 129539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-371e13b43b288c8ccfd6a8f94602ce8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29956109_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/7d0774ba75d0eaa591ff1a213b0fa6f9.webp"
"MediaSize" => 79292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-7d0774ba75d0eaa591ff1a213b0fa6f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29956109_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/c2f0f99f19369ae22b69d15d50ff2dc7.webp"
"MediaSize" => 113155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-c2f0f99f19369ae22b69d15d50ff2dc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29956109_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/4c4546df06ff275396c9d90de81f5e84.webp"
"MediaSize" => 134657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-4c4546df06ff275396c9d90de81f5e84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29956109_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/34446b99684e403d420264cb3b4759be.webp"
"MediaSize" => 135838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-34446b99684e403d420264cb3b4759be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29956109_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/369be79429be6bf7cf2b1628d8cc6442.webp"
"MediaSize" => 136259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-369be79429be6bf7cf2b1628d8cc6442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29956109_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/089b6d28ae7fbb39af758a5945d9c27b.webp"
"MediaSize" => 118508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-089b6d28ae7fbb39af758a5945d9c27b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29956109_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/6de2adf95d351c47fa78ac7675f549a1.webp"
"MediaSize" => 102131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-6de2adf95d351c47fa78ac7675f549a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29956109_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/6b0ad644511df633b41304bbb1baed53.webp"
"MediaSize" => 282968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-6b0ad644511df633b41304bbb1baed53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29956109_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/c4e2707d1cf7e7ae403fbb5e49d36813.webp"
"MediaSize" => 306520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-c4e2707d1cf7e7ae403fbb5e49d36813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29956109_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/eccf1765cc5635b0d8085f227e970779.webp"
"MediaSize" => 286226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-eccf1765cc5635b0d8085f227e970779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29956109_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/ddc2139c83b8a917478c2dabd3761d92.webp"
"MediaSize" => 276911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-ddc2139c83b8a917478c2dabd3761d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29956109_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/3aea104f6bb58dbd37c8e9f39c95b8ff.webp"
"MediaSize" => 263692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-3aea104f6bb58dbd37c8e9f39c95b8ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29956109_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/39e40ea5556e84abaa45668d96d7e876.webp"
"MediaSize" => 334660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-39e40ea5556e84abaa45668d96d7e876.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29956109_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/def058eb24950b8208f070bea91dfa63.webp"
"MediaSize" => 310915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-def058eb24950b8208f070bea91dfa63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29956109_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/57b0df69f8d22153328b0902471c7a86.webp"
"MediaSize" => 291908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-57b0df69f8d22153328b0902471c7a86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29956109_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956109/047f9854673f5d29744cde5735cb1e9f.webp"
"MediaSize" => 303331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956109/thumbnail-047f9854673f5d29744cde5735cb1e9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491706"
"ResourceRecordKey" => "29956109"
"ModificationTimestamp" => "2026-06-26T00:45:10.62Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956109')"
+"ID": "1567901"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 286883" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+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 1909594" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24838
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29956109'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25295
+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 '29956109'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25311
+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 '29956109' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.913238 43.336236)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25386
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+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 [
"RoomKey" => "1666887162"
"RoomType" => "Foyer"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29946398"
"RoomLength" => 2.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
1 => array:11 [
"RoomKey" => "1666887163"
"RoomType" => "Bathroom"
"ListingId" => "X13482892"
"RoomLevel" => "Second level"
"RoomWidth" => 2.51
"ListingKey" => "29946398"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
2 => array:11 [
"RoomKey" => "1666887164"
"RoomType" => "Dining room"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29946398"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
3 => array:11 [
"RoomKey" => "1666887165"
"RoomType" => "Living room"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 3.61
"ListingKey" => "29946398"
"RoomLength" => 5.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
4 => array:11 [
"RoomKey" => "1666887166"
"RoomType" => "Eating area"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 3.73
"ListingKey" => "29946398"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
5 => array:11 [
"RoomKey" => "1666887167"
"RoomType" => "Kitchen"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29946398"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
6 => array:11 [
"RoomKey" => "1666887168"
"RoomType" => "Bathroom"
"ListingId" => "X13482892"
"RoomLevel" => "Main level"
"RoomWidth" => 2.24
"ListingKey" => "29946398"
"RoomLength" => 0.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.91Z"
]
7 => array:11 [
"RoomKey" => "1666887169"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13482892"
"RoomLevel" => "Second level"
"RoomWidth" => 6.02
"ListingKey" => "29946398"
"RoomLength" => 5.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.92Z"
]
8 => array:11 [
"RoomKey" => "1666887170"
"RoomType" => "Bedroom"
"ListingId" => "X13482892"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29946398"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.92Z"
]
9 => array:11 [
"RoomKey" => "1666887171"
"RoomType" => "Bedroom"
"ListingId" => "X13482892"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29946398"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.92Z"
]
10 => array:11 [
"RoomKey" => "1666887172"
"RoomType" => "Bedroom"
"ListingId" => "X13482892"
"RoomLevel" => "Second level"
"RoomWidth" => 4.14
"ListingKey" => "29946398"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T14:51:08.92Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29946398_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946398/1884adc58d80c4980fcd9e3b512a111d.webp"
"MediaSize" => 336808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946398/thumbnail-1884adc58d80c4980fcd9e3b512a111d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13482892"
"ResourceRecordKey" => "29946398"
"ModificationTimestamp" => "2026-06-24T14:51:08.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946398_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946398/193cb9abb0faab54c25a86471d1e6e39.webp"
"MediaSize" => 295778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946398/thumbnail-193cb9abb0faab54c25a86471d1e6e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482892"
"ResourceRecordKey" => "29946398"
"ModificationTimestamp" => "2026-06-24T14:51:08.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946398_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946398/86cb259d33aab73e162fc339a4714db1.webp"
"MediaSize" => 381175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946398/thumbnail-86cb259d33aab73e162fc339a4714db1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482892"
…2
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946398')"
+"ID": "1567003"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955785')"
+"ID": "1566854"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947056')"
+"ID": "1565407"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953558')"
+"ID": "1562606"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951143')"
+"ID": "1562247"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952743')"
+"ID": "1561960"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953943')"
+"ID": "1562248"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+post_id: "1561660"
+post_author: 1
+"ListingKey": "29946673"
+"ListingId": "40842645"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:20:07Z"
+"RFModificationTimestamp": "2026-06-25T19:50:46Z"
+"ListPrice": 1379999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3309.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0N9"
+"UnparsedAddress": "5 SHETLAND Drive, Waterdown, Ontario L8B0N9"
+"Coordinates": array:2 [
0 => -79.9140968
1 => 43.3249347
]
+"Latitude": 43.3249347
+"Longitude": -79.9140968
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:50:34.028703+00:00"
+"Directions": "Hoilybush to Arnhem Crt to Shetland Drive"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:08Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:10:58Z"
+"Stories": "2.0"
+"StreetName": "SHETLAND"
+"StreetNumber": "5"
+"StreetSuffix": "Drive"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7602.72"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=XL7yVjgL3Px"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946673/5-shetland-drive-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2147849"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2340
+"BelowGradeFinishedArea": 969
+"OriginalEntryTimestamp": "2026-06-24T15:32:08.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1398898"
+"CoListOfficeNationalAssociationId": "1477945"
+"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('29946673')"
+"ID": "1561660"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25385
+post_id: "1557895"
+post_author: 1
+"ListingKey": "29942285"
+"ListingId": "40842358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T20:00:19Z"
+"RFModificationTimestamp": "2026-06-23T20:04:56Z"
+"ListPrice": 599990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1349.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C6"
+"UnparsedAddress": "79 BRAEHEID Avenue Unit# 6, Waterdown, Ontario L8B0C6"
+"Coordinates": array:2 [
0 => -79.9100295
1 => 43.3290674
]
+"Latitude": 43.3290674
+"Longitude": -79.9100295
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious 2-storey condo townhouse offering the perfect blend of comfort, functionality, and convenience. Featuring 3 bedrooms, 3 bathrooms, and a finished basement with a cozy family room, this home provides plenty of space for growing families, first-time buyers, or those looking to downsize without compromise. Enjoy a private backyard ideal for relaxing, entertaining, or summer BBQS. Located next to a public school and just a short walk to parks and green spaces, this home is perfectly situated in a family-friendly neighbourhood close to everyday amenities. A fantastic opportunity to own a well-appointed home in a desirable location! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "625"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T19:13:53.129486+00:00"
+"Directions": "Parkside Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T19:51:21Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T19:51:21Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "79"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3587"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29942285/79-braeheid-avenue-unit-6-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1349
+"OriginalEntryTimestamp": "2026-06-23T17:11:11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942285')"
+"ID": "1557895"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 111
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
]