array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29983786 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1589423"
+post_author: 1
+"ListingKey": "29983786"
+"ListingId": "40843660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T13:35:20Z"
+"RFModificationTimestamp": "2026-07-03T18:05:17Z"
+"ListPrice": 521000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 686.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 428, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8806923
1 => 43.3421839
]
+"Latitude": 43.3421839
+"Longitude": -79.8806923
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful corner unit, located on the fourth floor with no neighbors above. Discover this roomy 2-bedroom condominium offering beautiful vistas through its floor-to-ceiling windows. The airy layout seamlessly integrates an open concept kitchen with upgraded stainless-steel appliances, a quartz breakfast bar, and direct entry to your personal balcony. The spacious primary bedroom and secondary bedroom add to the allure, while an upgraded 4-piece bathroom and the convenience of an in-suite full-sized washer and dryer complete the package. The building amenities include a gym, bike storage room, party room, and a rooftop BBQ patio. Additionally, this condo features one underground parking spot and a personal locker located steps from your unit. Located in Waterdown, a charming town with abundant amenities, schools, and shops nearby. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFee": "459.73"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:05:12.223079+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101735"
+"ListOfficeKey": "282362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Conservation/green belt"
3 => "Balcony"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T13:28:58Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T13:28:58Z"
+"Stories": "12.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3205.23"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1674088015"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843660"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29983786"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T13:28:58.53Z"
]
1 => array:11 [
"RoomKey" => "1674088016"
"RoomType" => "Kitchen"
"ListingId" => "40843660"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29983786"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T13:28:58.54Z"
]
2 => array:11 [
"RoomKey" => "1674088017"
"RoomType" => "Living room"
"ListingId" => "40843660"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29983786"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T13:28:58.54Z"
]
3 => array:11 [
"RoomKey" => "1674088018"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843660"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29983786"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T13:28:58.54Z"
]
4 => array:11 [
"RoomKey" => "1674088019"
"RoomType" => "Bedroom"
"ListingId" => "40843660"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29983786"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T13:28:58.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983786/450-dundas-street-e-unit-428-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 686
+"OriginalEntryTimestamp": "2026-07-03T13:28:58.49Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1371503"
+"ListOfficeNationalAssociationId": "1320359"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29983786_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/ec7e9773eceb3245f837aee92cbdc017.webp"
"MediaSize" => 58418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-ec7e9773eceb3245f837aee92cbdc017.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corner Unit, the space above is an exterior terrace associated with the upper unit, not interior living space."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29983786_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/66474ee1afef9ae911d33e6026d76508.webp"
"MediaSize" => 87631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-66474ee1afef9ae911d33e6026d76508.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring laminate flooring, a full-height window, and a sliding glass door to a balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29983786_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/0a28fe858d2e501d925ae6eaaeaaf143.webp"
"MediaSize" => 55965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-0a28fe858d2e501d925ae6eaaeaaf143.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring white shaker cabinetry, stainless steel appliances, white subway tile backsplash, and a large island with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29983786_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/362785d39e72ec77a322cdffe0c1d8ec.webp"
"MediaSize" => 49994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-362785d39e72ec77a322cdffe0c1d8ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a white quartz island with a built-in sink and seating, white cabinetry, stainless steel appliances, a white subway tile backsplash, and grey laminate flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29983786_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/0205b08daacf351bb97521026b2b1312.webp"
"MediaSize" => 75673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-0205b08daacf351bb97521026b2b1312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious main bedroom featuring light grey laminate flooring and a wide window."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29983786_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/8ade2837e70e7fd7fc02a800cb0cefc9.webp"
"MediaSize" => 43459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-8ade2837e70e7fd7fc02a800cb0cefc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring a large window, light grey laminate flooring, and a flush mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29983786_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/c223185ff15d9646f19337a3a40e21ad.webp"
"MediaSize" => 36369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-c223185ff15d9646f19337a3a40e21ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a light grey vanity with a white quartz countertop, a shower-over-tub combination with white subway tile surround, a toilet, and light-toned floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29983786_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/7dfeb37ee4b97910ff2564f22eb6365b.webp"
"MediaSize" => 33079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-7dfeb37ee4b97910ff2564f22eb6365b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private entryway featuring light grey laminate flooring and bright white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29983786_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/0ce7fa90c9f60eb0610a5d5be1d94584.webp"
"MediaSize" => 34077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-0ce7fa90c9f60eb0610a5d5be1d94584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In-suite laundry closet featuring a white stacked Full size Whirlpool washer and dryer unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29983786_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/1ae04ccce70e363420b99672a08021d0.webp"
"MediaSize" => 58585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-1ae04ccce70e363420b99672a08021d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Underground parking space located close to elevators"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29983786_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/5967efca3596bd9d13c366f680fd9941.webp"
"MediaSize" => 129989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-5967efca3596bd9d13c366f680fd9941.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Individual storage locker located on same floor as unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29983786_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/877b852afbe52f85f3ab2055e01c327e.webp"
"MediaSize" => 57341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-877b852afbe52f85f3ab2055e01c327e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Condo front entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29983786_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/2c5ddfdb99b736a18597a864f7d4cd2f.webp"
"MediaSize" => 102659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-2c5ddfdb99b736a18597a864f7d4cd2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby area with stylish seating area and a glowing fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29983786_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/e08283a07775764bd3c628b26672968f.webp"
"MediaSize" => 120776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-e08283a07775764bd3c628b26672968f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness area featuring multiple treadmills, free weights and universal weight machine"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29983786_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/a5db2a27f16f34914198795662dd94b3.webp"
"MediaSize" => 75678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-a5db2a27f16f34914198795662dd94b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness center featuring a multi-station weight rack, dumbbell set with rack, and exercise mats"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29983786_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/a0caad648bb2bd91cabc6e30f91de735.webp"
"MediaSize" => 74174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-a0caad648bb2bd91cabc6e30f91de735.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness center featuring elliptical trainers and stationary bikes."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29983786_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/992366f15ece0f55447851e47275b437.webp"
"MediaSize" => 93466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-992366f15ece0f55447851e47275b437.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room Rental for events, featuring a kitchen area, seating and tables for dining."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29983786_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/b5d491887792c8a7168464f81ba1b488.webp"
"MediaSize" => 89256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-b5d491887792c8a7168464f81ba1b488.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room Rental for events, featuring a billiards table."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29983786_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/f317f17afc8524a8aea267f40b6b6f84.webp"
"MediaSize" => 81264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-f317f17afc8524a8aea267f40b6b6f84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room Rental for events, featuring a modern kitchen featuring an island and seating tables."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29983786_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/4ed2d29f0cbc432db82bed12be7f3b64.webp"
"MediaSize" => 77002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-4ed2d29f0cbc432db82bed12be7f3b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bike storage on main floor of building for easy access."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29983786_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983786/eeaea69750a9a2d9184b8d9740945ed7.webp"
"MediaSize" => 91923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983786/thumbnail-eeaea69750a9a2d9184b8d9740945ed7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rooftop terrace featuring multiple outdoor seating areas, a dedicated outdoor kitchen area with two built-in grills, and a round dining tables."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843660"
"ResourceRecordKey" => "29983786"
"ModificationTimestamp" => "2026-07-03T13:28:58.5Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983786')"
+"ID": "1589423"
}
]
+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 282362" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24864
+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 2101735" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24822
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29983786'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25200
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29983786'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+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 '29983786' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8806923 43.3421839)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1589371"
+post_author: 1
+"ListingKey": "29983992"
+"ListingId": "X13517516"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T14:20:08Z"
+"RFModificationTimestamp": "2026-07-03T17:51:14Z"
+"ListPrice": 1680000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "60 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.883376
1 => 43.334537
]
+"Latitude": 43.334537
+"Longitude": -79.883376
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A Rare Opportunity to Own This Magnificent Executive Residence in One of Waterdown's Most Prestigious Communities! Never Lived In Like New. This Stunning 3,718 Sqft. Home Sits on A Wide Lot Backing on Greenspace, Offering Walk-Out Basement and Private Southeast-Facing Backyard. Showcasing Timeless Architecture with Elegant Brick and Natural Stone, 3-Car Garage, and Oversized Driveway, Making It a Truly Exceptional Luxury Residence! Step Into 2-Storey Foyer, Spectacular Formal Living Room Boasts A Soaring 14.8-Ft Ceiling and Dramatic Windows, while 10-Ft Smooth Ceilings on Main, The Formal Dining Room Is Perfect for Entertaining. Spacious Family Room Features Coffered Ceiling, Gas Fireplace, With Views of Backyard and Greenspace. The Upgraded Gourmet Kitchen Offers Granite Countertops, Centre Island, Ample Cabinetry, And Spacious Breakfast Area with Walkout to Sundeck. A Private Main-Floor Office Provides Work-From-Home Space. Solid Hardwood Stairs Lead to the 2nd Level with 9-Ft Ceilings Throughout. The Luxurious Primary Retreat Features 2 Walk-In Closets and Spa-Inspired 5pc Ensuite. 2nd Bedroom Has Its Own 4pc Ensuite and Walk-In Closet, While the Remaining Bedrooms Share a Jack & Jill Bathroom with Upgraded Glass Shower. The Open Hallway Overlooks Grand Foyer Below. Unspoiled Walk-Out Basement Offers 8.5-Ft Ceilings, and 2nd Hardwood Staircase from The Side Entrance and Garage, Creating Potential for An In-Law or Future 2nd Suite. The 200-Amp Electrical Service, Ideal for Future EV Charger Installation. Nestled On a Quiet Crescent Surrounded by Conservation Areas, Parks, Pond and Scenic Trails, This Exceptional Location Offers the Perfect Blend of Small-Town Charm and Modern Convenience. Minutes To Schools, Historical Waterdown Village, Boutique Shops, Cafés, Farmers' Market, And Easy Access to Hwys 403, 407, QEW, Hwy 6, And GO Station. A Truly Rare Offering with No Comparable Homes and Perfect Combination of Natural Beauty, Family Living, And Urban Convenience. (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "Garage door opener"
]
+"Basement": array:6 [
0 => "Unfinished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-03T17:51:04.537824+00:00"
+"Directions": "Dundas/Burke"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423924"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "59.7 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:09:55Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T14:09:55Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "60"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "11103.31"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://tours.aisonphoto.com/328271"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1674111770"
"RoomType" => "Living room"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.79
"ListingKey" => "29983992"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
1 => array:11 [
"RoomKey" => "1674111771"
"RoomType" => "Bedroom 4"
"ListingId" => "X13517516"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "29983992"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
2 => array:11 [
"RoomKey" => "1674111772"
"RoomType" => "Laundry room"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29983992"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
3 => array:11 [
"RoomKey" => "1674111773"
"RoomType" => "Dining room"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29983992"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
4 => array:11 [
"RoomKey" => "1674111774"
"RoomType" => "Family room"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29983992"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
5 => array:11 [
"RoomKey" => "1674111775"
"RoomType" => "Kitchen"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29983992"
"RoomLength" => 4.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
6 => array:11 [
"RoomKey" => "1674111776"
"RoomType" => "Eating area"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29983992"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
7 => array:11 [
"RoomKey" => "1674111777"
"RoomType" => "Library"
"ListingId" => "X13517516"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29983992"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
8 => array:11 [
"RoomKey" => "1674111778"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13517516"
"RoomLevel" => "Second level"
"RoomWidth" => 5.03
"ListingKey" => "29983992"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
9 => array:11 [
"RoomKey" => "1674111779"
"RoomType" => "Bathroom"
"ListingId" => "X13517516"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29983992"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
10 => array:11 [
"RoomKey" => "1674111780"
"RoomType" => "Bedroom 2"
"ListingId" => "X13517516"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29983992"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.63Z"
]
11 => array:11 [
"RoomKey" => "1674111781"
"RoomType" => "Bedroom 3"
"ListingId" => "X13517516"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29983992"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T14:09:55.64Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983992/60-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 59.8
+"OriginalEntryTimestamp": "2026-07-03T14:09:55.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1117087"
+"ListOfficeNationalAssociationId": "1328651"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29983992_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/3aaa72e033878ade2abb806f08afbd34.webp"
"MediaSize" => 358094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-3aaa72e033878ade2abb806f08afbd34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29983992_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/8de43693aae8af70ce532f5f17912bfb.webp"
"MediaSize" => 383035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-8de43693aae8af70ce532f5f17912bfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29983992_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/0fe80ae9c00755df443ba401871c1765.webp"
"MediaSize" => 359073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-0fe80ae9c00755df443ba401871c1765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29983992_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/70941765610d901a0b414e6e883f9b86.webp"
"MediaSize" => 420554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-70941765610d901a0b414e6e883f9b86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29983992_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/0905e8d0783d8dee0f93f48c329204a9.webp"
"MediaSize" => 115891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-0905e8d0783d8dee0f93f48c329204a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29983992_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/a62fa49020dd0bb954b069f0ba0c4ff3.webp"
"MediaSize" => 167386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-a62fa49020dd0bb954b069f0ba0c4ff3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29983992_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/e0d7cb63e3c59dd918e543a4e3846491.webp"
"MediaSize" => 200828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-e0d7cb63e3c59dd918e543a4e3846491.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29983992_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/b797b449837cdc52f3166b31e3c172c5.webp"
"MediaSize" => 176732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-b797b449837cdc52f3166b31e3c172c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29983992_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/487651c115efeaff3d1be7f99be2e386.webp"
"MediaSize" => 189943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-487651c115efeaff3d1be7f99be2e386.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29983992_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/06c878e918a3e2ad268690837afb16f5.webp"
"MediaSize" => 150570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-06c878e918a3e2ad268690837afb16f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29983992_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/f551e996bc5ae1e10ca8a500e58949e8.webp"
"MediaSize" => 191946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-f551e996bc5ae1e10ca8a500e58949e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29983992_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/f2dc8c623029f00b05687e3254a1cbb7.webp"
"MediaSize" => 206287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-f2dc8c623029f00b05687e3254a1cbb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29983992_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/4d590d25e9af352f230940959e43b3c8.webp"
"MediaSize" => 222483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-4d590d25e9af352f230940959e43b3c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29983992_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/00805feeadad7600fef8fb925e8035d2.webp"
"MediaSize" => 195792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-00805feeadad7600fef8fb925e8035d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29983992_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/760a8c315fc996da9b192fa725a81d23.webp"
"MediaSize" => 185722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-760a8c315fc996da9b192fa725a81d23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29983992_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/9df28a334631213a8f2335ac92a9dd5a.webp"
"MediaSize" => 172906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-9df28a334631213a8f2335ac92a9dd5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29983992_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/1e55d1d36afb0c8442e5fb4152ff40a9.webp"
"MediaSize" => 164835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-1e55d1d36afb0c8442e5fb4152ff40a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29983992_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/f0cc8f9948e5e9d3c295b7ad0776c8a5.webp"
"MediaSize" => 246333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-f0cc8f9948e5e9d3c295b7ad0776c8a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29983992_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/864f484bbb6dc3c8d91c9bf4846ee7de.webp"
"MediaSize" => 505687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-864f484bbb6dc3c8d91c9bf4846ee7de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29983992_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/58fae18dbab6bcd8649f33c5c575f2ed.webp"
"MediaSize" => 206313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-58fae18dbab6bcd8649f33c5c575f2ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29983992_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/72fa6455864a65ca7addc28017992363.webp"
"MediaSize" => 223220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-72fa6455864a65ca7addc28017992363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29983992_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/1c8d802a8a9f530ccef4355134ebef6e.webp"
"MediaSize" => 174385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-1c8d802a8a9f530ccef4355134ebef6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29983992_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/fb01e5689d709bb6266f4a5885a13f8d.webp"
"MediaSize" => 95720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-fb01e5689d709bb6266f4a5885a13f8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29983992_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/c8e6155f28f8b45d2589d086bac993ee.webp"
"MediaSize" => 95500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-c8e6155f28f8b45d2589d086bac993ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29983992_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/764e751dbc59e256a02ddc293f46804e.webp"
"MediaSize" => 176735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-764e751dbc59e256a02ddc293f46804e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29983992_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/60edf4926e0cdb76d971d502632e00d1.webp"
"MediaSize" => 260704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-60edf4926e0cdb76d971d502632e00d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29983992_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/503ebb063e45dfe68863a66527e6c015.webp"
"MediaSize" => 133168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-503ebb063e45dfe68863a66527e6c015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29983992_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/d7e29b29bed27ad3c37864f4bed2c17e.webp"
"MediaSize" => 141407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-d7e29b29bed27ad3c37864f4bed2c17e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29983992_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/e0313d091369b1d94c43e74182159e62.webp"
"MediaSize" => 193834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-e0313d091369b1d94c43e74182159e62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29983992_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/cadad7e8ed6da4b62044b0edcb6d86a7.webp"
"MediaSize" => 112379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-cadad7e8ed6da4b62044b0edcb6d86a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29983992_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/90fae559573590274b5829e1789bf615.webp"
"MediaSize" => 203315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-90fae559573590274b5829e1789bf615.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29983992_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/7a1aeba86acc3f4712e3bcb348ecdbed.webp"
"MediaSize" => 279857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-7a1aeba86acc3f4712e3bcb348ecdbed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29983992_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/010bf08736c9a5653fd699f89819fa73.webp"
"MediaSize" => 146497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-010bf08736c9a5653fd699f89819fa73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29983992_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/2dc2269473296111da5edaeb7b6afcbc.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983992')"
+"ID": "1589371"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1577559"
+post_author: 1
+"ListingKey": "29968968"
+"ListingId": "X13503168"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:35:12Z"
+"RFModificationTimestamp": "2026-07-02T23:40:05Z"
+"ListPrice": 890000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V3"
+"UnparsedAddress": "63 LUPO DRIVE, Hamilton (Waterdown), Ontario L8B0V3"
+"Coordinates": array:2 [
0 => -79.886278
1 => 43.348321
]
+"Latitude": 43.348321
+"Longitude": -79.886278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautifully refreshed 3-bedroom family home set on a premium deep lot in one of Waterdown's most desirable family-friendly communities. Vacant and offering immediate possession, this home is ideal for buyers looking to settle in without delay. attached only by the garage on one side, with the other side unattached, it offers rare privacy, space, and comfort. Step inside to a bright, spacious layout with fresh paint throughout, hardwood flooring on the first floor, brand-new upper-level carpet, modern, move-in-ready feel. The main floor offers comfortable living/dining areas for everyday family life, entertaining, and relaxing, while the Extra space on 2nd floor provides valuable extra space for a home office. The true standout is the exceptional backyard. Sitting on a deep premium lot, the outdoor space features , charming gazebo, storage shed, children's play area, and plenty of open green space for kids, pets, and gatherings. Close to schools, parks, shopping, restaurants, community amenities, and major commuter routes, this home delivers the perfect balance of privacy, family lifestyle, and Waterdown convenience. A rare opportunity to own a vacant, move-in-ready 3-bedroom home with a backyard that sets it apart. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T01:32:09.797975+00:00"
+"Directions": "Cross Streets: Dundas street/Spring Creek Drive. ** Directions: Dundas/Spring Creek."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994173"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.5 x 94 FT ; Irregular"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:29:37Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:29:37Z"
+"Stories": "2.0"
+"StreetName": "Lupo"
+"StreetNumber": "63"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6582"
+"VirtualTourURLUnbranded": "https://trreb-listing.ampre.ca/listing/X13503168"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29968968/63-lupo-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-30T00:50:29.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1277260"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968968')"
+"ID": "1577559"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1577313"
+post_author: 1
+"ListingKey": "29967190"
+"ListingId": "X13501524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:05:18Z"
+"RFModificationTimestamp": "2026-06-29T23:23:45Z"
+"ListPrice": 498000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "232 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 Bedroom + 1 Bathroom Suite in the Trend Build Boutique Building. Split Floor Plan Layout With Each Good Sized Bedroom On Either Side of The Living room. Floor to Ceiling Windows, Light Flooring Throughout. Granite Countertops In The Kitchen With Stainless Steel Appliances And A Breakfast Bar. One Owned Underground Parking Space And One Owned Locker Conveniently Located on the Same Floor as the Suite. Residents Benefit From Multiple Fitness Facilities, Party Rooms, Rooftop Patio and Bike Storage All Accessed Without Leaving The Building. Geothermal Heating and Cooling System Keeps the Hydro Bill Low. Located Just Down The Street From The Quaint Downtown Waterdown Area With Specialty Shops and Restaurants, Parks and Schools. Aldershot Go Station Is A Short 10 Minute Drive As Is Brant Street Bringing You To Downtown Burlington. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "497.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T23:23:34.513341+00:00"
+"Directions": "Dundas & Mallard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049985"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T18:56:59Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:56:59Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "3083.88"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29967190/232-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-29T18:56:59.59Z"
+"ListAgentNationalAssociationId": "1325352"
+"ListOfficeNationalAssociationId": "1268183"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967190')"
+"ID": "1577313"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1574963"
+post_author: 1
+"ListingKey": "29964718"
+"ListingId": "X13499420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:35:18Z"
+"RFModificationTimestamp": "2026-06-29T13:55:43Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "86 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.8776048
1 => 43.347112
]
+"Latitude": 43.347112
+"Longitude": -79.8776048
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional detached home in the highly sought-after community of Waterdown, offering nearly 3,000 sq. ft. of beautifully finished living space designed for modern family life and elegant entertaining. Situated on a premium corner lot, this impressive 4-bedroom, 4-bathroom residence showcases timeless finishes and meticulous attention to detail throughout. Step inside to discover 9-foot smooth ceilings, rich oak hardwood flooring, and elegant crown moulding that create a sophisticated and inviting atmosphere. At the heart of the home is the chef-inspired kitchen, featuring high-end cabinetry, a large centre island, stainless steel appliances, and an ideal layout for both everyday living and hosting family and friends. Spacious principal rooms provide plenty of room to gather, while large windows fill the home with natural light. Upstairs, you'll find four generously sized bedrooms, including a luxurious primary retreat complete with a spa-inspired 5 pc ensuite and 2 walk-in closets! The professionally finished basement extends your living space, offering endless possibilities for recreation, a home theatre, gym, office, or guest accommodations. Step outside to your professionally landscaped backyard oasis, with multiple deck areas, gazebo and shed - thoughtfully designed for outdoor enjoyment, relaxation, and entertaining. Ideally located with quick access to Burlington, major highways, and the GO Train, this home offers the perfect blend of small-town charm and commuter convenience. An outstanding opportunity to own a beautifully upgraded family home in one of Waterdown's most desirable neighbourhoods. See the MultiMedia Video Tour, then book your private tour before it's gone! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:55:31.363991+00:00"
+"Directions": "Cross Streets: Dundas/Spring Creek. ** Directions: Dundas to Spring Creek to Stillwater."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947927"
+"ListOfficeKey": "86922"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38.1 x 89.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T12:27:43Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:27:43Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "86"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7465.65"
+"VirtualTourURLUnbranded": "https://tour.shutterhouse.ca/vd/253689401"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964718/86-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-06-29T12:27:43.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267694"
+"ListOfficeNationalAssociationId": "1148953"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964718')"
+"ID": "1574963"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1574964"
+post_author: 1
+"ListingKey": "29964832"
+"ListingId": "40843093"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:10:11Z"
+"RFModificationTimestamp": "2026-06-29T14:12:46Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.322
+"LivingArea": 951.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 E DUNDAS Street E Unit# 315, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8960168
1 => 43.3299381
]
+"Latitude": 43.3299381
+"Longitude": -79.8960168
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Absolutely meticulously maintained 1+1 condo located in the heart of Waterdown. This spotless unit features 10 foot ceilings, crown molding, transom window, patio sliding doors to private balcony, ceiling fans, in-suite laundry room, and breakfast bar. This wonderful unit is bright and airy with a stunning open concept layout. Double French doors lead to a spacious office or second bedroom if required. Furnace and C/Air replaced 2022. The apartment is within walking distance to all amenities, transportation, and recreational parks and shops. Fantastic unit in a quite and safe location. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "733.54"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:47:04.205980+00:00"
+"Directions": "Dundas Street East to Hamilton Street South"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524989"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"LotSizeDimensions": "2.322"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T13:10:02Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:02:20Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3719.65"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364556"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964832/262-dundas-street-e-unit-315-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 510.0
+"AboveGradeFinishedArea": 951
+"OriginalEntryTimestamp": "2026-06-29T13:10:02.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063309"
+"ListOfficeNationalAssociationId": "1286675"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964832')"
+"ID": "1574964"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1574426"
+post_author: 1
+"ListingKey": "29963842"
+"ListingId": "X13498608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T14:50:13Z"
+"RFModificationTimestamp": "2026-06-28T16:21:44Z"
+"ListPrice": 389900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "612 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and sunny 1-bedroom condo with underground parking and locker in a well-managed, modern condo community. This stylish unit features an unobstructed balcony, upgraded flooring, sleek kitchen cabinetry, granite countertops, and upgraded stainless steel appliances. You'll also enjoy full-sized front-loading laundry, and a contemporary bathroom vanity with quartz finishes. The building offers top-tier amenities including a fully equipped gym, rooftop terrace with BBQs, elegant party room, and secure bike storage. Conveniently located just minutes from Aldershot GO, major highways, scenic trails, shops, and a short drive to Lake Ontario.The unit includes 1 underground parking space and 1 locker. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "518.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-28T16:21:38.959899+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Riverwalk. ** Directions: Dundas St E to Mallard Trail to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048285"
+"ListOfficeKey": "257079"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-28T14:43:29Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T14:43:29Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2600"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963842/612-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-28T14:43:29.33Z"
+"ListAgentNationalAssociationId": "1323624"
+"ListOfficeNationalAssociationId": "1213993"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963842')"
+"ID": "1574426"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1572570"
+post_author: 1
+"ListingKey": "29961749"
+"ListingId": "X13496704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:05:04Z"
+"RFModificationTimestamp": "2026-07-02T16:17:18Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.882882
1 => 43.329912
]
+"Latitude": 43.329912
+"Longitude": -79.882882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Waterdown's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T01:10:19.307439+00:00"
+"Directions": "Cross Streets: Mountain Brow Road. ** Directions: Waterdown Road to Mountain Brow Road."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047588"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "256.3 x 127.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T00:44:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:57:52Z"
+"Stories": "1.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://344mountainbrowroad.marketingrmx.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961749/344-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 256.3
+"OriginalEntryTimestamp": "2026-06-27T00:44:49.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323031"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961749')"
+"ID": "1572570"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1571505"
+post_author: 1
+"ListingKey": "29961017"
+"ListingId": "40843479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:15Z"
+"RFModificationTimestamp": "2026-07-02T15:04:07Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.75
+"LivingArea": 3492.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW Road, Waterdown, Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.8823409
1 => 43.3299879
]
+"Latitude": 43.3299879
+"Longitude": -79.8823409
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Waterdown's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:2 [
0 => "Window Coverings"
1 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:10.046221+00:00"
+"Directions": "WATERDOWN ROAD TO MOUNTAIN BROW ROAD"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"LotSizeDimensions": "0.75"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:51:28Z"
+"Stories": "1.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204661223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961017/344-mountain-brow-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 256.0
+"AboveGradeFinishedArea": 3492
+"OriginalEntryTimestamp": "2026-06-26T21:50:06.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961017')"
+"ID": "1571505"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1570187"
+post_author: 1
+"ListingKey": "29958286"
+"ListingId": "X13493838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:30:18Z"
+"RFModificationTimestamp": "2026-06-26T18:29:29Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z8"
+"UnparsedAddress": "446 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1Z8"
+"Coordinates": array:2 [
0 => -79.87188
1 => 43.345646
]
+"Latitude": 43.345646
+"Longitude": -79.87188
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the family-oriented Waterdown community, 446 Humphrey St is an exceptional 5-bedroom, 4-bathroom executive residence that blends refined finishes and functionality across its 3,474 sq ft above-grade layout.The main level introduces itself with a grand double-door entry, an elegant tiled foyer, rich hardwood flooring, and expansive principal spaces designed for both everyday comfort and sophisticated entertaining. A private main-floor office provides exceptional flexibility for remote work or a potential 6th bedroom. The chef-inspired kitchen is thoughtfully curated with quartz countertops, a sleek quartz backsplash, premium Samsung appliances, and a dedicated servery designed with extensive cabinetry for staging, serving, and discreet storage. The adjoining breakfast area and family room are flooded with natural light and anchored by a fireplace, creating a warm and inviting atmosphere overlooking the backyard. The second level unfolds with intention, featuring five generously proportioned bedrooms, all complete with walk-in closets. The primary retreat is a true sanctuary with a spacious walk-in closet and a spa-inspired 5-piece ensuite featuring dual vanities and elegant finishes. Secondary bedrooms are exceptionally well-sized and connected through thoughtfully designed Jack & Jill bathroom layouts, creating both privacy and functionality for growing families. A dedicated upper-level laundry room further enhances convenience. The unfinished lower level presents extraordinary future potential with oversized windows, expansive open-concept space, a cold room, and the flexibility to design a custom recreation space, gym, home theatre, or in-law suite tailored to your lifestyle. Outdoors, the backyard awaits transformation into a private outdoor retreat, while the home is located in close proximity to major highways, top-rated schools, shopping, restaurants, conservation areas, golf courses, and scenic walking trails. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:29:21.625328+00:00"
+"Directions": "Cross Streets: Dundas St E & Skinner Rd. ** Directions: Dundas St E to Skinner Rd to Humphrey St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417634"
+"ListOfficeKey": "270338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Guest Suite"
]
+"LotSizeDimensions": "57.1 x 97.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T16:21:49Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:21:49Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "446"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9900"
+"VirtualTourURLUnbranded": "https://vimeo.com/1190320791?share=copy&fl=sv&fe=ci"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958286/446-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2222228"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269129"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.1
+"OriginalEntryTimestamp": "2026-06-26T16:21:49.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1035732"
+"ListOfficeNationalAssociationId": "1235224"
+"CoListAgentNationalAssociationId": "1465862"
+"CoListOfficeNationalAssociationId": "1231804"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958286')"
+"ID": "1570187"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 169
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]