array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29983992 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: "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"
"MediaSize" => 147621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-2dc2269473296111da5edaeb7b6afcbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29983992_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/6cf2c63ea87209db9dfede4cc274c944.webp"
"MediaSize" => 174582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-6cf2c63ea87209db9dfede4cc274c944.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29983992_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/65042735e02ddc0cc49fcb08db363df8.webp"
"MediaSize" => 207366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-65042735e02ddc0cc49fcb08db363df8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29983992_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/07283f6e2f7324683e970177920f83e0.webp"
"MediaSize" => 137333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-07283f6e2f7324683e970177920f83e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29983992_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/95e5d9a6b595d08b3919b6f5175f71cf.webp"
"MediaSize" => 160315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-95e5d9a6b595d08b3919b6f5175f71cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29983992_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/a8188545cd1eab079d7fa98c46a28e4c.webp"
"MediaSize" => 181241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-a8188545cd1eab079d7fa98c46a28e4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29983992_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/d99ad0efc892107e289a5c7cc7d7b530.webp"
"MediaSize" => 188475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-d99ad0efc892107e289a5c7cc7d7b530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29983992_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/c93e4a3120773565469705ba1400a962.webp"
"MediaSize" => 121516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-c93e4a3120773565469705ba1400a962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29983992_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/775c90cc2f68cc7e138c8bdca7d5a269.webp"
"MediaSize" => 277739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-775c90cc2f68cc7e138c8bdca7d5a269.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29983992_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/eb41da79e7af6352c6b939ab432109aa.webp"
"MediaSize" => 600599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-eb41da79e7af6352c6b939ab432109aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29983992_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29983992/6ed9d7b26164946ec36119efd720e0af.webp"
"MediaSize" => 561905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29983992/thumbnail-6ed9d7b26164946ec36119efd720e0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13517516"
"ResourceRecordKey" => "29983992"
"ModificationTimestamp" => "2026-07-03T14:09:55.59Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983992')"
+"ID": "1589371"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283410" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24912
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1423924" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24870
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29983992'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+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 '29983992'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29983992' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.883376 43.334537)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25360
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1590269"
+post_author: 1
+"ListingKey": "29986990"
+"ListingId": "40845073"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:10:10Z"
+"RFModificationTimestamp": "2026-07-03T20:18:57Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "8 NORTHLAWN Avenue, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.906227
1 => 43.340693
]
+"Latitude": 43.340693
+"Longitude": -79.906227
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare Opportunity to Build Your Dream Home in One of East Waterdown's Most Established Neighbourhoods! This newly created 50' x 160' premium building lot is one of three parcels recently severed from an original estate property, offering the perfect canvas for a custom home tailored to your lifestyle. Two additional lots (both 80' x 103') are also available and offered for sale separately, presenting a unique opportunity for families, friends or investors looking to build side by side. Nestled on a quiet, tree-lined street just steps to parks, top-rated schools, shopping, restaurants, trails and everyday conveniences, you'll enjoy the charm and character of a mature neighbourhood with the freedom to build new. The generous 80-foot frontage offers exceptional flexibility for a stunning custom residence with spacious outdoor living or expansive landscaping. Bring your own builder and create the home you've always envisioned in one of Waterdown's most sought-after, family-friendly communities with convenient access to Burlington, minutes to Aldershot GO Transit and major highways. Rarely do opportunities like this become available! Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-03T20:18:52.740301+00:00"
+"Directions": "Centre Road to Northlawn Avenue"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "289630"
+"PhotosChangeTimestamp": "2026-07-03T19:58:58Z"
+"PhotosCount": 8
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:58:58Z"
+"StreetName": "NORTHLAWN"
+"StreetNumber": "8"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986990/8-northlawn-avenue-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-14"
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-03T19:58:58.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1250393"
+"ListOfficeNationalAssociationId": "1379683"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986990_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/fb05f4ffa42e16acb898fb0b5a7e51e3.webp"
"MediaSize" => 193512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-fb05f4ffa42e16acb898fb0b5a7e51e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "There are 3 lots available side by side creating a unique opportunity for families, friends or investors looking to build side by side. Lot lines are not to scale."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986990_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/bb76c0cf2d4b7499c847eed437ca17ea.webp"
"MediaSize" => 189669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-bb76c0cf2d4b7499c847eed437ca17ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Build your Dream Home in one of Easter Waterdown's most established neighbourhoods. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986990_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/81ee3b20d7ee0d00f478ca82e62125bf.webp"
"MediaSize" => 187148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-81ee3b20d7ee0d00f478ca82e62125bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "8 Northlawn Avenue - severed new lot 50'w x 160'd. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986990_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/7fa2f2f8624ba5ab2f266f79db7b0414.webp"
"MediaSize" => 186331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-7fa2f2f8624ba5ab2f266f79db7b0414.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fantastic location close to shops, schools & amenities. Lot lines not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986990_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/7ee772da14c884e1a8a949887d4ba9c2.webp"
"MediaSize" => 198921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-7ee772da14c884e1a8a949887d4ba9c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lot lies are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986990_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/b6f31ab5a682ee6a837bd3c2c10e566e.webp"
"MediaSize" => 209431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-b6f31ab5a682ee6a837bd3c2c10e566e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lot lines are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986990_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/d18037c3ff34f3a09b71997f1bf3d419.webp"
"MediaSize" => 208318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-d18037c3ff34f3a09b71997f1bf3d419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986990_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986990/09ff1dbd454e8547b4a50e496aed29eb.webp"
"MediaSize" => 189669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986990/thumbnail-09ff1dbd454e8547b4a50e496aed29eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bring your own Builder and create the home you've always envisioned in one of Waterdown's most sought after, family friendly communities. Lot lines are not to scale."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845073"
"ResourceRecordKey" => "29986990"
"ModificationTimestamp" => "2026-07-03T19:58:58.37Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986990')"
+"ID": "1590269"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1589791"
+post_author: 1
+"ListingKey": "29985393"
+"ListingId": "40844589"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:10:10Z"
+"RFModificationTimestamp": "2026-07-03T18:59:55Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1499.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "219 DUNDAS Street E Unit# 29, Waterdown, Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.9001162
1 => 43.3280419
]
+"Latitude": 43.3280419
+"Longitude": -79.9001162
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5 wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you’ll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:59:19.033948+00:00"
+"Directions": "Enter on North side Of Dundas."
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988755"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:48:27Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:00:07Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5065.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1674286335"
"RoomType" => "Laundry room"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
1 => array:11 [
"RoomKey" => "1674286336"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
2 => array:11 [
"RoomKey" => "1674286337"
"RoomType" => "Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
3 => array:11 [
"RoomKey" => "1674286338"
"RoomType" => "Full bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
4 => array:11 [
"RoomKey" => "1674286339"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
5 => array:11 [
"RoomKey" => "1674286340"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
6 => array:11 [
"RoomKey" => "1674286341"
"RoomType" => "Kitchen"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
7 => array:11 [
"RoomKey" => "1674286342"
"RoomType" => "Dining room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
8 => array:11 [
"RoomKey" => "1674286343"
"RoomType" => "Living room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
9 => array:11 [
"RoomKey" => "1674286344"
"RoomType" => "Foyer"
"ListingId" => "40844589"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985393/219-dundas-street-e-unit-29-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1562390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55164"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "HC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1499
+"OriginalEntryTimestamp": "2026-07-03T16:48:27.09Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1272793"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1148234"
+"CoListOfficeNationalAssociationId": "1003546"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29985393_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/054bc8973faece78defe1f7e0ff63a11.webp"
"MediaSize" => 128775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-054bc8973faece78defe1f7e0ff63a11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29985393_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/3fdc437a85d9b9e59e690772a56d9855.webp"
"MediaSize" => 77326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-3fdc437a85d9b9e59e690772a56d9855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29985393_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"MediaSize" => 132036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29985393_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f8afda4081f28fbeab7bc5c6fc350867.webp"
"MediaSize" => 151903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-f8afda4081f28fbeab7bc5c6fc350867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29985393_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/53f914f77d326497dfd69fbb725e69d2.webp"
"MediaSize" => 113187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-53f914f77d326497dfd69fbb725e69d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29985393_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f6194f0bd97e7da1ac9604e5e57390a0.webp"
"MediaSize" => 41833
…9
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985393')"
+"ID": "1589791"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1589421"
+post_author: 1
+"ListingKey": "29985763"
+"ListingId": "X13519154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:50:04Z"
+"RFModificationTimestamp": "2026-07-03T19:53:15Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7H8"
+"UnparsedAddress": "29 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7H8"
+"Coordinates": array:2 [
0 => -79.90059
1 => 43.327623
]
+"Latitude": 43.327623
+"Longitude": -79.90059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5" wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you'll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:11:05.119669+00:00"
+"Directions": "Cross Streets: Dundas & Sunnycroft. ** Directions: Entry to complex on North side of Dundas."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031562"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:40:21Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5065.04"
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985763/29-219-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Guild Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.41Z"
+"ListAgentNationalAssociationId": "1309006"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985763')"
+"ID": "1589421"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1589422"
+post_author: 1
+"ListingKey": "29985762"
+"ListingId": "X13519138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:55:19Z"
+"RFModificationTimestamp": "2026-07-03T18:10:49Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN LANE, Hamilton (Waterdown), Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904144
1 => 43.333008
]
+"Latitude": 43.333008
+"Longitude": -79.904144
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard-ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:10:41.052691+00:00"
+"Directions": "Cross Streets: Segwun Rd. ** Directions: Hamilton St N to Rockhaven Lane."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089558"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Sump Pump"
]
+"LotSizeDimensions": "31.2 x 127.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:41:39Z"
+"Stories": "2.0"
+"StreetName": "Rockhaven"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985762/84-rockhaven-lane-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 31.2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1362909"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985762')"
+"ID": "1589422"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983786')"
+"ID": "1589423"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1589372"
+post_author: 1
+"ListingKey": "29984029"
+"ListingId": "40843518"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T14:25:13Z"
+"RFModificationTimestamp": "2026-07-03T17:46:27Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1932.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN Lane, Waterdown, Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904394
1 => 43.3326997
]
+"Latitude": 43.3326997
+"Longitude": -79.904394
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard—ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:46:17.621941+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524975"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:30Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T14:18:30Z"
+"Stories": "2.0"
+"StreetName": "ROCKHAVEN"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984029/84-rockhaven-lane-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975579"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2172717"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1589
+"BelowGradeFinishedArea": 343
+"OriginalEntryTimestamp": "2026-07-03T14:18:30.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1063275"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1262231"
+"CoListAgentNationalAssociationId2": "1423204"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984029')"
+"ID": "1589372"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+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"
}
]
+success: true
+page_size: 9
+page_count: 23
+count: 201
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]