array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29861943 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1500478"
+post_author: 1
+"ListingKey": "29861943"
+"ListingId": "X13249350"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T18:40:46Z"
+"RFModificationTimestamp": "2026-06-05T19:59:10Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R5"
+"UnparsedAddress": "15 MCPHAIL PLACE, Hamilton (Waterdown), Ontario L8B0R5"
+"Coordinates": array:2 [
0 => -79.883201
1 => 43.338953
]
+"Latitude": 43.338953
+"Longitude": -79.883201
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 15 McPhail Place, Waterdown! This beautiful end-unit townhouse offers over 2,000 sq. ft. of bright and functional living space with the added privacy of having no neighbors behind. Featuring newer appliances, a modern kitchen backsplash, zebra blinds throughout, smart front door lock, smart digital thermostat, LED pot lights, and a smart garage door opener with built-in camera. Custom closets in the laundry room, secondary bedrooms, finished basement with rec room and a washroom, and garage provide excellent storage and organization. Conveniently located near parks, schools, shopping, restaurants, and major highways, this move-in-ready home is perfect for families and professionals alike. Don't miss this rare opportunity to own a premium end-unit townhouse in sought-after Waterdown! (id:62650)"
+"Appliances": array:1 [
0 => "Blinds"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T19:59:02.807538+00:00"
+"Directions": "Dundas & Burke"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059122"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "35.1 x 135 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T18:33:05Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T18:33:05Z"
+"Stories": "2.0"
+"StreetName": "Mcphail"
+"StreetNumber": "15"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6420"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861943/15-mcphail-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 35.1
+"OriginalEntryTimestamp": "2026-06-05T18:33:05.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1334295"
+"ListOfficeNationalAssociationId": "1201577"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29861943_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/7df25ccf8d8886ed446578e819bdc322.webp"
"MediaSize" => 121663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-7df25ccf8d8886ed446578e819bdc322.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861943_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/96a277fcc3276716d03d57cabab72152.webp"
"MediaSize" => 143374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-96a277fcc3276716d03d57cabab72152.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861943_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/3f0395c9de6bc4182b394086c26301d5.webp"
"MediaSize" => 161781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-3f0395c9de6bc4182b394086c26301d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861943_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/2b6d196e68038487b360eab6aac01a5d.webp"
"MediaSize" => 72346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-2b6d196e68038487b360eab6aac01a5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861943_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/be3db882f29c60499d0deffb3b90b90e.webp"
"MediaSize" => 89805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-be3db882f29c60499d0deffb3b90b90e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861943_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/80e54a753c80d54754e1b82c137b8ab9.webp"
"MediaSize" => 89860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-80e54a753c80d54754e1b82c137b8ab9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861943_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/107d3aceefd57acec98ea165988624e5.webp"
"MediaSize" => 94607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-107d3aceefd57acec98ea165988624e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861943_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/b99cb83a97d1fce89f27122115dadf3e.webp"
"MediaSize" => 86977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-b99cb83a97d1fce89f27122115dadf3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861943_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/1156b0c6aaf3fc160363f842ca9b7acd.webp"
"MediaSize" => 95283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-1156b0c6aaf3fc160363f842ca9b7acd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861943_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/a6d99df9c2672d6eec3047efd89e336b.webp"
"MediaSize" => 93533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-a6d99df9c2672d6eec3047efd89e336b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29861943_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/a2beeb3bd3fdf92b8ea214df5bab7eb1.webp"
"MediaSize" => 93572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-a2beeb3bd3fdf92b8ea214df5bab7eb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29861943_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/4d593b201d461773af90f74b9bb57c51.webp"
"MediaSize" => 101318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-4d593b201d461773af90f74b9bb57c51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29861943_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/1e79a37274a62a17f2b2f331dc7fe754.webp"
"MediaSize" => 69853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-1e79a37274a62a17f2b2f331dc7fe754.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29861943_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/ea0f99d3e7208d2e9ecaf710d0ae2601.webp"
"MediaSize" => 82725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-ea0f99d3e7208d2e9ecaf710d0ae2601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29861943_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/5ea1e2e47f375892062d6ca4f5810d3d.webp"
"MediaSize" => 97255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-5ea1e2e47f375892062d6ca4f5810d3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29861943_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/a7a02d25c1d4cafc255116076400d8cd.webp"
"MediaSize" => 117259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-a7a02d25c1d4cafc255116076400d8cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29861943_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/946e67bc6e5d84393e9edc069a61cbbf.webp"
"MediaSize" => 75060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-946e67bc6e5d84393e9edc069a61cbbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29861943_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/33f97aa1ae9ee5c758ec61a2b9a141cf.webp"
"MediaSize" => 93502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-33f97aa1ae9ee5c758ec61a2b9a141cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29861943_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/5a4f272573b6aefe5e6b4d2b05cddf3e.webp"
"MediaSize" => 106540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-5a4f272573b6aefe5e6b4d2b05cddf3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29861943_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/c12d5f3b5d764fc855d843dbc7bbc428.webp"
"MediaSize" => 132276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-c12d5f3b5d764fc855d843dbc7bbc428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29861943_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/a590b41e4323b9acbeb588125b9c3af0.webp"
"MediaSize" => 164761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-a590b41e4323b9acbeb588125b9c3af0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29861943_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/9a9f71294c56abf7c87332456545f9f7.webp"
"MediaSize" => 181613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-9a9f71294c56abf7c87332456545f9f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29861943_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861943/1c5ae49ac1accd4466d8c44455294e4d.webp"
"MediaSize" => 136938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861943/thumbnail-1c5ae49ac1accd4466d8c44455294e4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13249350"
"ResourceRecordKey" => "29861943"
"ModificationTimestamp" => "2026-06-05T18:33:05.59Z"
]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861943')"
+"ID": "1500478"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 146431" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24768
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2059122" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24741
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29861943'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25065
+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 '29861943'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25081
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29861943' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.883201 43.338953)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25134
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25128
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:15:03Z"
+"RFModificationTimestamp": "2026-06-16T00:38:53Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:09:52Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660191163"
"RoomType" => "Bedroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
1 => array:11 [
"RoomKey" => "1660191164"
"RoomType" => "Living room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
2 => array:11 [
"RoomKey" => "1660191165"
"RoomType" => "Kitchen"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
3 => array:11 [
"RoomKey" => "1660191166"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
4 => array:11 [
"RoomKey" => "1660191167"
"RoomType" => "Laundry room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 3'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
5 => array:11 [
"RoomKey" => "1660191168"
"RoomType" => "Den"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
6 => array:11 [
"RoomKey" => "1660191169"
"RoomType" => "Foyer"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907463_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"MediaSize" => 125183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907463_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/bc72356ac79f3b2264abc6d6824b3c9f.webp"
"MediaSize" => 83469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-bc72356ac79f3b2264abc6d6824b3c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907463_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/44e06bde779f22ba91ef5fe6bfd071a2.webp"
"MediaSize" => 70999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-44e06bde779f22ba91ef5fe6bfd071a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907463_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/16faeb112a8ecdf073013779b7fa044c.webp"
"MediaSize" => 33797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-16faeb112a8ecdf073013779b7fa044c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907463_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b64d666be7a70cacaf5764a78510c43e.webp"
"MediaSize" => 31970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b64d666be7a70cacaf5764a78510c43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907463_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b4875166552e3987d0b6ca8975220ef3.webp"
"MediaSize" => 60275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b4875166552e3987d0b6ca8975220ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907463_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c8328b8fe00053fc69cf99a29698ae25.webp"
"MediaSize" => 28752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c8328b8fe00053fc69cf99a29698ae25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907463_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/3511a34a5512ea881f3eb2283c9659a6.webp"
"MediaSize" => 55615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-3511a34a5512ea881f3eb2283c9659a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907463_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/66bfba3bb27dcc15a888079a79d23a6c.webp"
"MediaSize" => 44723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-66bfba3bb27dcc15a888079a79d23a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907463_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/d716111056d499c6858d90b084ed8f01.webp"
"MediaSize" => 45201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-d716111056d499c6858d90b084ed8f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907463_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c40438d66bc845bda83dc577a8f882b9.webp"
"MediaSize" => 51644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c40438d66bc845bda83dc577a8f882b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29907463_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/ae43d9dd755aca838c645f5f83019c54.webp"
"MediaSize" => 51828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-ae43d9dd755aca838c645f5f83019c54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29907463_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/29b23854631b492bd400a40f5fe1076d.webp"
"MediaSize" => 64988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-29b23854631b492bd400a40f5fe1076d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29907463_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/0ca889e8432546151b5628ef398833ac.webp"
"MediaSize" => 48080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-0ca889e8432546151b5628ef398833ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29907463_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/7cf8d9135d48d65d18af5cba66e4ca79.webp"
"MediaSize" => 53801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-7cf8d9135d48d65d18af5cba66e4ca79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29907463_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/75df499fa02d9839a549139e71fc7461.webp"
"MediaSize" => 60787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-75df499fa02d9839a549139e71fc7461.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29907463_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/96acb36800b02e669fb5b275a8145a8f.webp"
"MediaSize" => 67297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-96acb36800b02e669fb5b275a8145a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29907463_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/441b3228be554b100786231740da215e.webp"
"MediaSize" => 54996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-441b3228be554b100786231740da215e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29907463_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/add99a36aea6fdfed1986ab02505c47e.webp"
"MediaSize" => 32441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-add99a36aea6fdfed1986ab02505c47e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29907463_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/e36c686937b2c82cf4e9b080c202171e.webp"
"MediaSize" => 112411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-e36c686937b2c82cf4e9b080c202171e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29907463_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/cc75075e3616ea7233b8b75fbf59c0f2.webp"
"MediaSize" => 110761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-cc75075e3616ea7233b8b75fbf59c0f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29907463_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b41fb85b7f86a0313c5efd91892ee8f5.webp"
"MediaSize" => 105368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b41fb85b7f86a0313c5efd91892ee8f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29907463_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/5c436960b6bc8c8b993ed1429528d197.webp"
"MediaSize" => 111950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-5c436960b6bc8c8b993ed1429528d197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29907463_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/268b4e06cb6165217bcd385ce38e62ac.webp"
"MediaSize" => 112034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-268b4e06cb6165217bcd385ce38e62ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29907463_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/a241f9a60300ad90da14e16524a5add0.webp"
"MediaSize" => 85916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-a241f9a60300ad90da14e16524a5add0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29907463_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/86bd90a5fcd56c08e59582935ab9b7ac.webp"
"MediaSize" => 85487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-86bd90a5fcd56c08e59582935ab9b7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29907463_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/e9a2c9c3e8ecaae417a13b4aa0cec905.webp"
"MediaSize" => 90870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-e9a2c9c3e8ecaae417a13b4aa0cec905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29907463_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/a288b2d9a664c36660f2363253c688d8.webp"
"MediaSize" => 92779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-a288b2d9a664c36660f2363253c688d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29907463_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/f062e8ed75bd28cd0047018222616ecc.webp"
"MediaSize" => 120739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-f062e8ed75bd28cd0047018222616ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29907463_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/26652347cffe3dc6939ee02b6fa3c1dd.webp"
"MediaSize" => 120473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-26652347cffe3dc6939ee02b6fa3c1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29907463_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/f402d6705581b599ac10bcd2e7fafcac.webp"
"MediaSize" => 125796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-f402d6705581b599ac10bcd2e7fafcac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29907463_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/6cdb2613e12b66e1aeea04d3bdecf67c.webp"
"MediaSize" => 132102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-6cdb2613e12b66e1aeea04d3bdecf67c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25130
+post_id: "1531843"
+post_author: 1
+"ListingKey": "29905680"
+"ListingId": "X13446596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS CRESCENT, Hamilton (Waterdown), Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.892899
1 => 43.326881
]
+"Latitude": 43.326881
+"Longitude": -79.892899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on one of Waterdown's most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well-proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard and private, tranquil green space. Enjoy summer evenings on the expansive composite deck, gather with friends friend and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town's most sought-after areas. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:35.932384+00:00"
+"Directions": "Cross Streets: Howard Blvd. ** Directions: South of Dundas St E on Howard Blvd, turn ontoMays Cres."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101938"
+"ListOfficeKey": "288807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "72.2 x 196.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:52Z"
+"Stories": "2.0"
+"StreetName": "Mays"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9061.67"
+"VirtualTourURLUnbranded": "https://listings.webbify.ca/5-Mays-Crescent-Hamilton-ON-L8B-0G4-Canada"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905680/5-mays-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 72.2
+"OriginalEntryTimestamp": "2026-06-15T18:56:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371767"
+"ListOfficeNationalAssociationId": "1371723"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905680_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/2a3f8a21c66e27b2674c8b6fbdb11977.webp"
"MediaSize" => 414273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-2a3f8a21c66e27b2674c8b6fbdb11977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905680_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e9a32890e0b7a5a7bff9f8a86df33f8d.webp"
"MediaSize" => 312810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e9a32890e0b7a5a7bff9f8a86df33f8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905680_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/37af27a6b2e13890a6bd58ee807d76e1.webp"
"MediaSize" => 472469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-37af27a6b2e13890a6bd58ee807d76e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905680_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e8b51619c9e641a165de6307fe60a4a5.webp"
"MediaSize" => 314099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e8b51619c9e641a165de6307fe60a4a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905680_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/c8aa48c00f777812b2fd00800bd8eadc.webp"
"MediaSize" => 451569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-c8aa48c00f777812b2fd00800bd8eadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905680_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/1fc3bbe9459e7d5398405cb2502fd979.webp"
"MediaSize" => 341600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-1fc3bbe9459e7d5398405cb2502fd979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905680_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e27514a867c781cbc1473d246f560524.webp"
"MediaSize" => 176499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e27514a867c781cbc1473d246f560524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905680_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/f845ad974041549464043b53a412716a.webp"
"MediaSize" => 177194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-f845ad974041549464043b53a412716a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905680_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/8b0af63c489c2efe2362bde525142f7d.webp"
"MediaSize" => 181064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-8b0af63c489c2efe2362bde525142f7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905680_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/659b0b34c69f1819e3337a37bf081413.webp"
"MediaSize" => 210876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-659b0b34c69f1819e3337a37bf081413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905680_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/62872b8d4199abe3c114fa625d292548.webp"
"MediaSize" => 226695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-62872b8d4199abe3c114fa625d292548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905680_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/9468840ce3af5fad3000545acdf31c92.webp"
"MediaSize" => 181257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-9468840ce3af5fad3000545acdf31c92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905680_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/efc5b61b0fe79c4ea516509e2db9150e.webp"
"MediaSize" => 209012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-efc5b61b0fe79c4ea516509e2db9150e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905680_4890_14"
…11
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "1530966"
+post_author: 1
+"ListingKey": "29904850"
+"ListingId": "40839710"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:00:17Z"
+"RFModificationTimestamp": "2026-06-15T19:26:25Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.33
+"LivingArea": 3344.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS Crescent, Waterdown, Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.8932325
1 => 43.3271885
]
+"Latitude": 43.3271885
+"Longitude": -79.8932325
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on one of Waterdown’s most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well- proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard as well as the private, tranquil green space behind. Enjoy summer evenings on the expansive composite deck, gather with friends and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town’s most sought-after areas. (id:62783)"
+"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 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:26:11.527080+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032649"
+"ListOfficeKey": "286831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.33"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:51:41Z"
+"Stories": "2.0"
+"StreetName": "MAYS"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9061.67"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904850/5-mays-crescent-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 2098
+"BelowGradeFinishedArea": 1246
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1309851"
+"ListOfficeNationalAssociationId": "1364228"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904850')"
+"ID": "1530966"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: "1525931"
+post_author: 1
+"ListingKey": "29898285"
+"ListingId": "X13439700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:40:08Z"
+"RFModificationTimestamp": "2026-06-12T23:51:00Z"
+"ListPrice": 2395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "345 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.870648
1 => 43.339359
]
+"Latitude": 43.339359
+"Longitude": -79.870648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 3-acres (per MPAC) this property overlooks the breathtaking natural landscape of Smokey Hollow and backs directly onto the iconic Bruce Trail. This remarkable gated estate offers a rare opportunity to acquire one of the area's most picturesque and private estates. A graceful, swooping driveway leads through expansive, awe-inspiring grounds, creating a dramatic sense of arrival while remaining discreet and private from the road. The 2.5-storey residence offers 7 bedrooms and 5 bathrooms, along with a library with a fireplace. The home in its current state needs to be renovated. Outdoor features include an inground swimming pool and a detached double-car garage, all set within the property's remarkable estate setting. For those with a vision for transformation, a new house rendering design by SMPL Design Studio offers inspiration for a spectacular modern residence. Ideally located just minutes from downtown Waterdown, Burlington, and the convenient Aldershot GO Station, providing easy access to amenities and commuting options. Property and all structures are being sold in AS-IS condition. Floor plans and a survey are available. Either renovate the existing house or build a new one. Exterior photos are current and from a few years ago. Interior photos and new home renderings are for creative / illustrative purposes only. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-12T23:50:55.953773+00:00"
+"Directions": "Cross Streets: Waterdown Rd / Mountain Brow Rd. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529018"
+"ListOfficeKey": "291562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.8 x 579.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:31:41Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:31:41Z"
+"Stories": "2.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "17408"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898285/345-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1743890"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 7
+"FrontageLengthNumeric": 151.9
+"OriginalEntryTimestamp": "2026-06-12T21:31:41.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140630"
+"ListOfficeNationalAssociationId": "1400240"
+"CoListAgentNationalAssociationId": "1292982"
+"CoListOfficeNationalAssociationId": "1400240"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898285')"
+"ID": "1525931"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25129
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891787')"
+"ID": "1522007"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25124
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892584')"
+"ID": "1522009"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25132
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891435')"
+"ID": "1521037"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25133
+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 [ …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"
+"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 [ …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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
]
+success: true
+page_size: 9
+page_count: 22
+count: 198
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]