array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29888470 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1520053"
+post_author: 1
+"ListingKey": "29888470"
+"ListingId": "X13430622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:07Z"
+"RFModificationTimestamp": "2026-06-12T07:20:20Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Rarely offered, this exceptional property delivers the feeling of cottage living in the city while offering the convenience of one of Waterdown's most sought after neighbourhoods. Situated on an incredible lot of nearly 10,000 sq. ft., this beautifully updated bungalow offers approximately 2,360 sq. ft. of finished living space with 3+2 bedrooms and 3 full bathrooms.The stunning open concept layout is anchored by a beautifully renovated kitchen featuring a massive centre island, stainless steel appliances, a 5 burner gas range, pot lights, and seamless flow into the living and dining areas. Bright, sun filled rooms throughout allow for an abundance of natural light, while updated railings, renovated closet spaces, and thoughtful improvements create a home that is both stylish and functional.The fully finished lower level offers incredible versatility with two additional bedrooms, a living area with a fireplace, and a relaxing 4 person infrared sauna for all your health/detox needs.Step outside and enjoy your own private backyard oasis. Surrounded by newer fencing for enhanced privacy, this expansive outdoor space features two gazebos, an extended patio, and a fire pit area, providing the perfect setting for entertaining, relaxing, and enjoying the outdoors.Major updates include a recently replaced roof and updated appliances within the last few years, providing peace of mind for years to come. With parking for 5 vehicles and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this move in ready home offers a lifestyle that is truly hard to find.VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:21:30.107435+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:54Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:54Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1657222093"
"RoomType" => "Laundry room"
"ListingId" => "X13430622"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.99
"ListingKey" => "29888470"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.2Z"
]
1 => array:11 [
"RoomKey" => "1657222094"
"RoomType" => "Living room"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.52
"ListingKey" => "29888470"
"RoomLength" => 4.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.2Z"
]
2 => array:11 [
"RoomKey" => "1657222095"
"RoomType" => "Dining room"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.51
"ListingKey" => "29888470"
"RoomLength" => 2.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.2Z"
]
3 => array:11 [
"RoomKey" => "1657222096"
"RoomType" => "Kitchen"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.2
"ListingKey" => "29888470"
"RoomLength" => 5.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.2Z"
]
4 => array:11 [
"RoomKey" => "1657222097"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.16
"ListingKey" => "29888470"
"RoomLength" => 3.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
5 => array:11 [
"RoomKey" => "1657222098"
"RoomType" => "Bedroom 2"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.51
"ListingKey" => "29888470"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
6 => array:11 [
"RoomKey" => "1657222099"
"RoomType" => "Bedroom 3"
"ListingId" => "X13430622"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.67
"ListingKey" => "29888470"
"RoomLength" => 3.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
7 => array:11 [
"RoomKey" => "1657222100"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13430622"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.51
"ListingKey" => "29888470"
"RoomLength" => 6.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
8 => array:11 [
"RoomKey" => "1657222101"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13430622"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.24
"ListingKey" => "29888470"
"RoomLength" => 5.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
9 => array:11 [
"RoomKey" => "1657222102"
"RoomType" => "Bedroom 2"
"ListingId" => "X13430622"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.45
"ListingKey" => "29888470"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T17:59:54.21Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888470/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29888470_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/756951490f388a04120cae4652c6d28f.webp"
"MediaSize" => 339770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-756951490f388a04120cae4652c6d28f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:38.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29888470_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/c2ccace2f531ad294c39ade2bb1a6744.webp"
"MediaSize" => 427990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-c2ccace2f531ad294c39ade2bb1a6744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:47.17Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29888470_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/e69176314baad2de15656475b13399dc.webp"
"MediaSize" => 139160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-e69176314baad2de15656475b13399dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29888470_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/74054f37b99a30a188b6d2401194d7ac.webp"
"MediaSize" => 149807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-74054f37b99a30a188b6d2401194d7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:38.32Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29888470_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/ca8b0fe6120856a9e52b23e522ff8ad5.webp"
"MediaSize" => 144298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-ca8b0fe6120856a9e52b23e522ff8ad5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29888470_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/4ed25df8285d4d67c77a20087192d409.webp"
"MediaSize" => 154648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-4ed25df8285d4d67c77a20087192d409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:43.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29888470_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/e1937ae004de790892dedacca66e49b5.webp"
"MediaSize" => 139649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-e1937ae004de790892dedacca66e49b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:47.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29888470_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/36c01190f839697f78e73160ff61fc24.webp"
"MediaSize" => 135378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-36c01190f839697f78e73160ff61fc24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:42.54Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29888470_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/37442b1cdb0b75157c3459b4fb255c60.webp"
"MediaSize" => 131893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-37442b1cdb0b75157c3459b4fb255c60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29888470_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/830f3fb99ff2ed2be739a6db4df635f8.webp"
"MediaSize" => 122214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-830f3fb99ff2ed2be739a6db4df635f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:43.36Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29888470_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/b0bb3e67c5b5dfe5148b4a335c3e726b.webp"
"MediaSize" => 143977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-b0bb3e67c5b5dfe5148b4a335c3e726b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29888470_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/18acf1f1a4398303e8f973bc3bbed004.webp"
"MediaSize" => 143577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-18acf1f1a4398303e8f973bc3bbed004.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:45.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29888470_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/9f120296b2c5b2278b243cf96d4ae5b3.webp"
"MediaSize" => 188071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-9f120296b2c5b2278b243cf96d4ae5b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:38.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29888470_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/54538b63681a8c3bd1c5e14c845700b7.webp"
"MediaSize" => 126167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-54538b63681a8c3bd1c5e14c845700b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:43.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29888470_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/89b13df4373158ac9f3f50651d987e50.webp"
"MediaSize" => 116990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-89b13df4373158ac9f3f50651d987e50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:38.26Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29888470_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/2eae115e7fae3d864f005403fa0a0155.webp"
"MediaSize" => 114712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-2eae115e7fae3d864f005403fa0a0155.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:44.22Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29888470_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/074ff841110456a2b71b6a97efac1021.webp"
"MediaSize" => 92956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-074ff841110456a2b71b6a97efac1021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:42.86Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29888470_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/ff2bb2442026f4ad5c6c5691c6d3d4b9.webp"
"MediaSize" => 118564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-ff2bb2442026f4ad5c6c5691c6d3d4b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:47.22Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29888470_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/9349ac3c56873b62263a819cf2a04018.webp"
"MediaSize" => 117429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-9349ac3c56873b62263a819cf2a04018.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:42.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29888470_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/7cd2300a826a29446fbe5105b972944a.webp"
"MediaSize" => 124361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-7cd2300a826a29446fbe5105b972944a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.75Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29888470_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/53e831a5367a3bcee3440fc757bc963a.webp"
"MediaSize" => 101954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-53e831a5367a3bcee3440fc757bc963a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29888470_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/ec19f03427b355182f46ccc7e5ab2957.webp"
"MediaSize" => 90234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-ec19f03427b355182f46ccc7e5ab2957.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29888470_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/74c9f44c9f0900b0ff883e55fe9c01ea.webp"
"MediaSize" => 97689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-74c9f44c9f0900b0ff883e55fe9c01ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29888470_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/461f9034a36afd7f5e33547a314407cd.webp"
"MediaSize" => 151438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-461f9034a36afd7f5e33547a314407cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:42.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29888470_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/95cade900a6da25c9a47c77b7417f83f.webp"
"MediaSize" => 124650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-95cade900a6da25c9a47c77b7417f83f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.15Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29888470_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/5c34c7d0bc6bf892c18abe4ff3c2459f.webp"
"MediaSize" => 94268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-5c34c7d0bc6bf892c18abe4ff3c2459f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29888470_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/94b013a73b2963ee713fcc26a48d02ef.webp"
"MediaSize" => 161993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-94b013a73b2963ee713fcc26a48d02ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:45.66Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29888470_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/60692bc8bbf4f9a4c7e169bbdcd75766.webp"
"MediaSize" => 147062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-60692bc8bbf4f9a4c7e169bbdcd75766.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.86Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29888470_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/f5f9cc197e0b11a5ba0024ebbdc97a3c.webp"
"MediaSize" => 151922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-f5f9cc197e0b11a5ba0024ebbdc97a3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.36Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29888470_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/120f2083a3349d53f8e6ea6687ef5186.webp"
"MediaSize" => 155780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-120f2083a3349d53f8e6ea6687ef5186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:45.79Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29888470_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/f445de9eec235e7b0d12480a9a022caf.webp"
"MediaSize" => 125552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-f445de9eec235e7b0d12480a9a022caf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.19Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29888470_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/9fc4230eecb60f5d14670c26d757bd63.webp"
"MediaSize" => 133729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-9fc4230eecb60f5d14670c26d757bd63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:44.58Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29888470_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/d4ab20da63da3ebc2b21ec3a544399c7.webp"
"MediaSize" => 338602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-d4ab20da63da3ebc2b21ec3a544399c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.94Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29888470_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/7c18bda4f70c568dcb840d422bb12c56.webp"
"MediaSize" => 312193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-7c18bda4f70c568dcb840d422bb12c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:46.81Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29888470_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/ac90d3045b5103761e46769bd32bf662.webp"
"MediaSize" => 368710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-ac90d3045b5103761e46769bd32bf662.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.96Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29888470_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/7d59781af7c803cf29cc34b71fffaf4a.webp"
"MediaSize" => 404717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-7d59781af7c803cf29cc34b71fffaf4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:47.33Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29888470_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/43e0be143d3762013124f4d3257e9e58.webp"
"MediaSize" => 388702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-43e0be143d3762013124f4d3257e9e58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:41.16Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29888470_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888470/24de41ab51029683f6094609a1673817.webp"
"MediaSize" => 429850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888470/thumbnail-24de41ab51029683f6094609a1673817.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13430622"
"ResourceRecordKey" => "29888470"
"ModificationTimestamp" => "2026-06-11T17:15:44.37Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
]
+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 275438" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24779
+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 2102095" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24755
+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 '29888470'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25094
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29888470'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25110
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29888470' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.90055364 43.3397812)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25163
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "1524109"
+post_author: 1
+"ListingKey": "29896100"
+"ListingId": "X13437788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T18:40:09Z"
+"RFModificationTimestamp": "2026-06-12T18:44:46Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "36 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907654
1 => 43.328335
]
+"Latitude": 43.328335
+"Longitude": -79.907654
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to own a detached 3-bedroom family home in one of Waterdown's most sought-after neighbourhoods. Located directly across from Guy B. Brown Elementary School, a highly regarded school offering a French Immersion program, this home is perfect for young families looking to put down roots in a fantastic community.Offering solid bones and endless potential, this property is an ideal opportunity for buyers looking to renovate, personalize, and build equity in their forever home. Enjoy a family-friendly location, and the chance to create a space that truly reflects your style and needs.Conveniently located close to parks, trails, shopping, restaurants, and all the amenities Waterdown has to offer, this is your chance to get into a detached home in a premium location for under $800,000. Don't miss this incredible opportunity to unlock the potential of this family home and make it your own (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:24:02.957529+00:00"
+"Directions": "Cross Streets: Parkside Dr. ** Directions: Parkside Drive to Braeheid Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024918"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:38Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T18:33:48Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "36"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5126"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/36-Braeheid-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1657888103"
"RoomType" => "Kitchen"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29896100"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
1 => array:11 [
"RoomKey" => "1657888104"
"RoomType" => "Dining room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
2 => array:11 [
"RoomKey" => "1657888105"
"RoomType" => "Living room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29896100"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
3 => array:11 [
"RoomKey" => "1657888106"
"RoomType" => "Laundry room"
"ListingId" => "X13437788"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29896100"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
4 => array:11 [
"RoomKey" => "1657888107"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29896100"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
5 => array:11 [
"RoomKey" => "1657888108"
"RoomType" => "Bedroom 2"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
6 => array:11 [
"RoomKey" => "1657888109"
"RoomType" => "Bedroom 3"
"ListingId" => "X13437788"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29896100"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
7 => array:11 [
"RoomKey" => "1657888110"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13437788"
"RoomLevel" => "Basement"
"RoomWidth" => 5.49
"ListingKey" => "29896100"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
8 => array:11 [
"RoomKey" => "1657888111"
"RoomType" => "Den"
"ListingId" => "X13437788"
"RoomLevel" => "Basement"
"RoomWidth" => 2.44
"ListingKey" => "29896100"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T18:33:48.37Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896100/36-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-06-12T17:01:38.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304615"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29896100_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/4ad1c2a26f57e9170fe1a82b6686021d.webp"
"MediaSize" => 339607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-4ad1c2a26f57e9170fe1a82b6686021d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29896100_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/302b04d97d179c9fd20bd4139416f4cf.webp"
"MediaSize" => 289259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-302b04d97d179c9fd20bd4139416f4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29896100_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/b065fb1d32ef425ddcfc14447872e3e2.webp"
"MediaSize" => 145928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-b065fb1d32ef425ddcfc14447872e3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29896100_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/be6bc53cf7ddb714f33ee06a34a478b0.webp"
"MediaSize" => 134599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-be6bc53cf7ddb714f33ee06a34a478b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29896100_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/f837a6e1709138503826e7391c5ec3ae.webp"
"MediaSize" => 170617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-f837a6e1709138503826e7391c5ec3ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29896100_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/4679887de4c935cf80ec5494a2397e0a.webp"
"MediaSize" => 149503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-4679887de4c935cf80ec5494a2397e0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29896100_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/3fec9fb15294a79e9ea257d0f2e04419.webp"
"MediaSize" => 170319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-3fec9fb15294a79e9ea257d0f2e04419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29896100_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/2ce1f8c6fadf498cee9b4ce821d4a0af.webp"
"MediaSize" => 161608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-2ce1f8c6fadf498cee9b4ce821d4a0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29896100_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/ed33dbb8ccaa8a1ebe366826005f5357.webp"
"MediaSize" => 168562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-ed33dbb8ccaa8a1ebe366826005f5357.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29896100_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/038730c1ac2a0d1b634c7a5c908881de.webp"
"MediaSize" => 152946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-038730c1ac2a0d1b634c7a5c908881de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29896100_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/b485afb685b241e4ca58eeeb96d75f4f.webp"
"MediaSize" => 167016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-b485afb685b241e4ca58eeeb96d75f4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29896100_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/f4bc4afacc46c3cb349481a24ba3e2b9.webp"
"MediaSize" => 146879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-f4bc4afacc46c3cb349481a24ba3e2b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29896100_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/1fdb4035e9533f607fe18c3d2a5557ab.webp"
"MediaSize" => 178894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-1fdb4035e9533f607fe18c3d2a5557ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13437788"
"ResourceRecordKey" => "29896100"
"ModificationTimestamp" => "2026-06-12T17:01:38.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29896100_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896100/5c5f1d8d6563e007e66c6d69d1d00f22.webp"
"MediaSize" => 173003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896100/thumbnail-5c5f1d8d6563e007e66c6d69d1d00f22.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896100')"
+"ID": "1524109"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: "1523612"
+post_author: 1
+"ListingKey": "29895204"
+"ListingId": "40838264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:00:11Z"
+"RFModificationTimestamp": "2026-06-12T17:02:11Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "36 BRAEHEID Avenue, Waterdown, Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.9072948
1 => 43.3279506
]
+"Latitude": 43.3279506
+"Longitude": -79.9072948
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing opportunity to own a detached 3-bedroom, 2.5 bath family home in one of Waterdown's most sought-after neighbourhoods. Located directly across from Guy B. Brown Elementary School, a highly regarded school offering a French Immersion program, this home is perfect for young families looking to put down roots in a fantastic community.Offering solid bones and endless potential, this property is an ideal opportunity for buyers looking to renovate, personalize, and build equity in their forever home. Enjoy a family-friendly location, and the chance to create a space that truly reflects your style and needs.Conveniently located close to parks, trails, shopping, restaurants, and all the amenities Waterdown has to offer, this is your chance to get into a detached home in a premium location for under $800,000. Don't miss this incredible opportunity to unlock the potential of this family home and make it your own (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Central Vacuum - Roughed In"
8 => "Wet Bar"
9 => "Hood Fan"
10 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T16:26:08.539471+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991807"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T16:32:55Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:52:00Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "36"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5126"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/36-Braeheid-Ave"
+"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/29895204/36-braeheid-avenue-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1435
+"OriginalEntryTimestamp": "2026-06-12T15:31:50.93Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1275275"
+"ListOfficeNationalAssociationId": "1408460"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895204')"
+"ID": "1523612"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25156
+post_id: "1522007"
+post_author: 1
+"ListingKey": "29891787"
+"ListingId": "40839144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:45:04Z"
+"RFModificationTimestamp": "2026-06-12T01:28:39Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 33, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9069775
1 => 43.3380781
]
+"Latitude": 43.3380781
+"Longitude": -79.9069775
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and stylish townhome featuring low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral décor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:27:27.209917+00:00"
+"Directions": "Hamilton St N to Nisbet Blvd, right into complex"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933651"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:39:39Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:39:39Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29891787/54-nisbet-boulevard-unit-33-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2185296"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283666"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1408
+"OriginalEntryTimestamp": "2026-06-11T20:39:39.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1233597"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1434925"
+"CoListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891787')"
+"ID": "1522007"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: "1522008"
+post_author: 1
+"ListingKey": "29892469"
+"ListingId": "X13434412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:25:12Z"
+"RFModificationTimestamp": "2026-06-12T14:28:02Z"
+"ListPrice": 519998.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom units available. Located on the 6th floor, this unit offers spacious, modern living with 1 bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the Great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 makingfor an easier commute. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "551.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:02:54.162610+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:56Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:19:15Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3700"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892469/617-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-11T21:53:56.23Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+post_id: "1522009"
+post_author: 1
+"ListingKey": "29892584"
+"ListingId": "X13434636"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:25:10Z"
+"RFModificationTimestamp": "2026-06-11T22:54:34Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "33 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and stylish townhome offering low-maintenance living in a highly desirable Waterdown location. Featuring a functional open-concept main floor with neutral decor and thoughtful design throughout. Sleek dark kitchen complete with stainless steel appliances, breakfast bar, abundant cabinetry, pantry and storage space, seamlessly flowing into the spacious dining area and bright living room. Convenient powder room, additional storage, and inside garage access add to the practicality of this home. The upper level offers a spacious primary bedroom with double closets and private ensuite, a generous second bedroom, additional full bathroom, and convenient full laundry room with extra storage, linen closet, and drying rack. Enjoy outdoor living on the private terrace featuring an awning for added comfort and shade. The unfinished basement provides exceptional storage space and offers great potential to customize and finish to suit your needs, whether for a recreation room, home gym, office, or additional living space. Amazing location with convenient access to major highways, GO Transit, and public transit. Move-in ready and perfectly located on a quiet, family-friendly court. Walking distance to parks, trails, schools, shopping, restaurants, and everyday amenities (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T22:54:28.009574+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: Hamilton St N to Nisbet Blvd, right into complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2222832"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "24.2 x 53.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T22:19:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T22:19:47Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4900"
+"VirtualTourURLUnbranded": "https://visithome.ai/XDtEMoVHECyeZNFcEfNpdF?mu=ft"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892584/33-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.2
+"OriginalEntryTimestamp": "2026-06-11T22:19:47.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466475"
+"ListOfficeNationalAssociationId": "1274323"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892584')"
+"ID": "1522009"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1521037"
+post_author: 1
+"ListingKey": "29891435"
+"ListingId": "X13433494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:06Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R2"
+"UnparsedAddress": "4 COLE STREET, Hamilton (Waterdown), Ontario L8B0R2"
+"Coordinates": array:2 [
0 => -79.9062491
1 => 43.3361384
]
+"Latitude": 43.3361384
+"Longitude": -79.9062491
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained freehold townhouse in sought-after Waterdown offering approximately 1470 sq. ft. of above ground finished living space. This 3-bedroom, 4-bathroom home features a bright open-concept layout with 9-ft ceilings on the main floor, a finished basement, and numerous quality upgrades throughout. Major updates include new basement/staircase carpeting (2021); kitchen countertops, backsplash, sinks, faucets, microwave, bathroom countertops, sinks and faucets, primary ensuite glass shower door, pot lights throughout the main and second floors, basement light fixtures, automated garage door opener, and humidifier (2022); new furnace, water softener, drinking water filtration system, and smart door lock (2023); plus a smart thermostat and Google video doorbell (2020).The functional layout offers spacious principal rooms, a modernized kitchen with ample cabinetry and workspace, and a finished lower level ideal for recreation, work-from-home space, or extended family living. Attached garage and private driveway parking add everyday convenience. Ideally located close to schools, the YMCA, Park, playgrounds, public transit, and a full-service shopping plaza featuring Fortinos, Tim Hortons, McDonald's, restaurants, daycare services, family medical and dental offices, convenience stores, and more. Move-in ready and thoughtfully updated, this home offers exceptional comfort, convenience, and value in one of Waterdown's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Humidifier"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:54.750046+00:00"
+"Directions": "Parkside Dr/Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072378"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 100.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:52Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:52Z"
+"Stories": "2.0"
+"StreetName": "Cole"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4896.45"
+"VirtualTourURLUnbranded": "https://homes.motionstudio.ca/listings/DsjdOGEOX8hCTJ3iwqUy/website/basic/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891435/4-cole-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2190178"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2130691"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "282777"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:52.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347560"
+"ListOfficeNationalAssociationId": "1321336"
+"CoListAgentNationalAssociationId": "1439294"
+"CoListAgentNationalAssociationId2": "1383597"
+"CoListOfficeNationalAssociationId": "1470118"
+"CoListOfficeNationalAssociationId2": "1321336"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1521038"
+post_author: 1
+"ListingKey": "29889732"
+"ListingId": "X13432108"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:35:13Z"
+"RFModificationTimestamp": "2026-06-11T19:14:32Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0V6"
+"UnparsedAddress": "156 GUNBY BOULEVARD, Hamilton (Waterdown), Ontario L8B0V6"
+"Coordinates": array:2 [
0 => -79.917048
1 => 43.330745
]
+"Latitude": 43.330745
+"Longitude": -79.917048
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 156 Gunby Blvd, a move in ready all brick detached home located in a highly desirable neighbourhood. From the moment you arrive, you'll appreciate the home's inviting curb appeal and well-maintained exterior. Step inside to discover a thoughtfully designed layout featuring 9-foot ceilings on the main level, a stunning solid wood staircase, and an abundance of natural light throughout.The spacious kitchen is ideal for both everyday living and entertaining, offering built-in oven and microwave and stainless steel appliances, quartz countertops, a large centre island with breakfast bar, and seamless flow into the welcoming family room complete with a cozy fireplace. A convenient laundry/mudroom provides direct access to the double-car garage.Upstairs, you'll find three generously sized bedrooms and two full bathrooms, including a spacious primary retreat featuring a walk-in closet and ensuite privileges.The bright, fully finished basement expands your living space with large windows, an open-concept recreation room, a 3-piece bathroom with stand-up shower, and a versatile bonus room perfect for guests, a home office, or extended family. Step outside and enjoy your private backyard oasis, complete with a large two-tier wood deck and relaxing hot tub-perfect for entertaining or unwinding after a long day.Ideally situated close to shopping, schools, the YMCA, and major commuter routes including Highways 403, 407, and the QEW, this exceptional home offers comfort, convenience, and lifestyle all in one package. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:00:11.265398+00:00"
+"Directions": "Cross Streets: Centre Rd / Parkside. ** Directions: Parkside Dr > Mosaic Dr> Gunby Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024328"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "33 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T16:58:28Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T18:21:21Z"
+"Stories": "2.0"
+"StreetName": "Gunby"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "6608.33"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/156-gunby-boulevard-waterdown/"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29889732/156-gunby-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-11T16:58:28.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304065"
+"ListOfficeNationalAssociationId": "1427673"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889732')"
+"ID": "1521038"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+post_id: "1520592"
+post_author: 1
+"ListingKey": "29887232"
+"ListingId": "X13429762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:05:09Z"
+"RFModificationTimestamp": "2026-06-11T16:34:04Z"
+"ListPrice": 1589000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "194 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.901709
1 => 43.325096
]
+"Latitude": 43.325096
+"Longitude": -79.901709
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to charming Waterdown where this estate style property feels like the country but has all the perks of in-town-living! This raised bungalow features over 2600 square feet of finished living space with 5 bedrooms and 3 bathrooms combined on both levels. Tons of room for a growing family or set it up with a nanny/income suite in the lower level with a separate walk out to the backyard. Sitting on over half an acre, you've got excellent space to play and entertain. Fully fenced backyard with saltwater inground pool, deck and gas bbq line. Invite all your friends because there's parking for 15 vehicles! Recent upgrades include basement flooring with R4 thermal subfloor (2026), furnace (2025), upper front windows (2024), main bath (2022), ensuite (2022), roof (2022). Please see the attached feature sheet for a complete list of features and upgrades. Fireplace not currently operational. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:33:51.597596+00:00"
+"Directions": "Cross Streets: Dundas/Hamilton. ** Directions: On the south side of Dundas just east of Riley."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004228"
+"ListOfficeKey": "285613"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Sloping"
1 => "Flat site"
2 => "Carpet Free"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"LotSizeDimensions": "110.4 x 207.4 FT ; 110.44 x 207.42 x 110.21 x 214.83"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T11:35:12Z"
+"PhotosCount": 42
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:56:47Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "194"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9299.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/194_dundas_street_east_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29887232/194-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 17
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1841558"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285613"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.4
+"OriginalEntryTimestamp": "2026-06-11T11:35:11.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287388"
+"ListOfficeNationalAssociationId": "1352696"
+"CoListAgentNationalAssociationId": "1197719"
+"CoListOfficeNationalAssociationId": "1352696"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887232')"
+"ID": "1520592"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: "1518137"
+post_author: 1
+"ListingKey": "29887094"
+"ListingId": "X13429540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:50:27Z"
+"RFModificationTimestamp": "2026-06-11T05:58:26Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "905 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern Trend Living condo with 9-ft ceilings and an open-concept layout. Features ceramic tile flooring and bright LED lighting throughout. The stylish kitchen offers custom cabinetry, designer faucet, and laminate countertops with a backsplash, while the bathrooms boast quartz countertops and spa-inspired premium fixtures. Enjoy a feature wall for your TV, a French balcony, and an owned locker for extra convenience. Pet-friendly in both living areas and bedrooms. This energy-efficient building includes geothermal heating/cooling, secure entry, 2 owned underground parking spaces, rooftop terrace, and professional management. Freshly painted and perfectly located near parks, shopping, restaurants, and major highways. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "497.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T05:58:17.496106+00:00"
+"Directions": "Dundas St/ Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036997"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T04:42:09Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:42:09Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3952.38"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29887094/905-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T04:42:09.45Z"
+"ListAgentNationalAssociationId": "1313436"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:22 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887094')"
+"ID": "1518137"
}
]
+success: true
+page_size: 9
+page_count: 25
+count: 219
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]