array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29731147 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: "1408247"
+post_author: 1
+"ListingKey": "29731147"
+"ListingId": "X13109826"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T12:35:36Z"
+"RFModificationTimestamp": "2026-06-01T12:41:28Z"
+"ListPrice": 1289900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "123 ATTRIDGE CRESCENT, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.8836105
1 => 43.3369175
]
+"Latitude": 43.3369175
+"Longitude": -79.8836105
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Come and live on this rare corner lot facing gorgeous 5.3 acre Agro park in this coveted street in Waterdown. Privacy from neighbours and natural sunlight throughout with large windows flooded with bright natural light! This spacious and well laid out family home just over 10 years old has separate living, dining and family room. Large kitchen with granite countertops plus back splash plus island. Enjoy morning breakfast within the large kitchen overlooking private fenced in backyard through large double sliding doors with bonus side panel transom style windows for brightness. Large Family room with gas fireplace with lots of windows. Main floor laundry for convenience. Second level offers 4 bedrooms,3 full baths on 2nd level with 2 ensuite bath including master and 2nd bedroom. 3rd and 4th bedroom share a jack & Jill bath with separate area for shower. All baths upgraded with granite vanities. Expansive L shaped unfinished basement with limitless potential. Brick exterior enhances the curb appeal with porch to enjoy summer evenings. Exposed concrete work throughout front and back of the house. Newly insulated garage installed. Plenty of parking with 2 in garage parking spots and driveway can accommodate 4 cars. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-11T17:21:04.304700+00:00"
+"Directions": "Cross Streets: Dundas St E/Burke St. ** Directions: Dundas to Burke."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967393"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.9 x 93.5 FT ; 60 Feet (North Side)"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-11T14:49:16Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T12:27:45Z"
+"Stories": "2.0"
+"StreetName": "Attridge"
+"StreetNumber": "123"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8685"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/355996"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1648495958"
"RoomType" => "Living room"
"ListingId" => "X13109826"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29731147"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
1 => array:11 [
"RoomKey" => "1648495959"
"RoomType" => "Dining room"
"ListingId" => "X13109826"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29731147"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
2 => array:11 [
"RoomKey" => "1648495960"
"RoomType" => "Family room"
"ListingId" => "X13109826"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29731147"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
3 => array:11 [
"RoomKey" => "1648495961"
"RoomType" => "Kitchen"
"ListingId" => "X13109826"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29731147"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
4 => array:11 [
"RoomKey" => "1648495962"
"RoomType" => "Eating area"
"ListingId" => "X13109826"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29731147"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
5 => array:11 [
"RoomKey" => "1648495963"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13109826"
"RoomLevel" => "Second level"
"RoomWidth" => 4.88
"ListingKey" => "29731147"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
6 => array:11 [
"RoomKey" => "1648495964"
"RoomType" => "Bedroom 2"
"ListingId" => "X13109826"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29731147"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
7 => array:11 [
"RoomKey" => "1648495965"
"RoomType" => "Bedroom 3"
"ListingId" => "X13109826"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29731147"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
8 => array:11 [
"RoomKey" => "1648495966"
"RoomType" => "Bedroom 4"
"ListingId" => "X13109826"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29731147"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T12:27:45.1Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29731147/123-attridge-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "Single Family Residence"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 55.1
+"OriginalEntryTimestamp": "2026-05-11T14:49:16.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1255255"
+"ListOfficeNationalAssociationId": "1328652"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29731147_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/b86fa6121a96108c32dd8056eab5a3e6.webp"
"MediaSize" => 280310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-b86fa6121a96108c32dd8056eab5a3e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29731147_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/05949c9c2e856d684c7278e4eb75f724.webp"
"MediaSize" => 314754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-05949c9c2e856d684c7278e4eb75f724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29731147_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/ad1d109415b5e75a6caa296559297c12.webp"
"MediaSize" => 251018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-ad1d109415b5e75a6caa296559297c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29731147_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/a1066c65c13315b581885dfd8f85c4bc.webp"
"MediaSize" => 327169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-a1066c65c13315b581885dfd8f85c4bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29731147_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/2ce5dde07b0069784665f68542e2cef8.webp"
"MediaSize" => 193879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-2ce5dde07b0069784665f68542e2cef8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29731147_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/7e5e49b0c861db8b4153e93799ee02d7.webp"
"MediaSize" => 189476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-7e5e49b0c861db8b4153e93799ee02d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29731147_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/8363a1da4552428ed40659c83450f884.webp"
"MediaSize" => 179141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-8363a1da4552428ed40659c83450f884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29731147_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/a3df52b5d7330343b94fb968d2e1aa90.webp"
"MediaSize" => 178855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-a3df52b5d7330343b94fb968d2e1aa90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29731147_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/e948dc2eba748e1d789a3eecbda4ca34.webp"
"MediaSize" => 183437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-e948dc2eba748e1d789a3eecbda4ca34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29731147_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/333de08b1fc4bfb182dcf5098095f278.webp"
"MediaSize" => 221406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-333de08b1fc4bfb182dcf5098095f278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29731147_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/f8355b06fd1c23e005e15a2f77333cc2.webp"
"MediaSize" => 197975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-f8355b06fd1c23e005e15a2f77333cc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29731147_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/ae5748ba3e0024d20321c35022fc9965.webp"
"MediaSize" => 236542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-ae5748ba3e0024d20321c35022fc9965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29731147_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/b9836f5799b9838938e8f9aed357afee.webp"
"MediaSize" => 120782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-b9836f5799b9838938e8f9aed357afee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29731147_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/a1b89393b543df8b2ab12d287307467f.webp"
"MediaSize" => 127701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-a1b89393b543df8b2ab12d287307467f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29731147_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/2094f02c2ac614584d7e68b4f834e0d5.webp"
"MediaSize" => 144240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-2094f02c2ac614584d7e68b4f834e0d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29731147_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/dbe73598cae6dbeafc7cff2688afda7b.webp"
"MediaSize" => 157703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-dbe73598cae6dbeafc7cff2688afda7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29731147_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/1f03940c0c27f6e1c046df0729e1fe46.webp"
"MediaSize" => 93126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-1f03940c0c27f6e1c046df0729e1fe46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29731147_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/e5c9511b69cc32bd0967d073dc1ec0a1.webp"
"MediaSize" => 298402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-e5c9511b69cc32bd0967d073dc1ec0a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29731147_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/8c140be192fbf577342a06a7d4ca55ff.webp"
"MediaSize" => 333901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-8c140be192fbf577342a06a7d4ca55ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29731147_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29731147/2b4400ed79150a2069678e8e13688383.webp"
"MediaSize" => 347950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29731147/thumbnail-2b4400ed79150a2069678e8e13688383.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13109826"
"ResourceRecordKey" => "29731147"
"ModificationTimestamp" => "2026-05-11T14:49:16.33Z"
]
]
+"DaysOnMarket": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29731147')"
+"ID": "1408247"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283413" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24764
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1967393" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24737
+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 '29731147'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25058
+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 '29731147'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25076
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25074
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31183913"
+"ListingKey": "29731147"
+"ListingId": "X13109826"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-01T02:55:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31183913')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29731147' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8836105 43.3369175)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25123
+post_id: 1535992
+post_author: 1
+"ListingKey": "29911949"
+"ListingId": "40840369"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:00:08Z"
+"RFModificationTimestamp": "2026-06-16T20:34:46Z"
+"ListPrice": 395000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 515.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 604, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786396
1 => 43.3439185
]
+"Latitude": 43.3439185
+"Longitude": -79.8786396
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.125636+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1647189"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T19:53:05Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:53:05Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2592.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1660696046"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840369"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29911949"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T19:51:02.35Z"
]
1 => array:11 [
"RoomKey" => "1660696047"
"RoomType" => "Bedroom"
"ListingId" => "40840369"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29911949"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T19:51:02.35Z"
]
2 => array:11 [
"RoomKey" => "1660696048"
"RoomType" => "Kitchen"
"ListingId" => "40840369"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29911949"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T19:51:02.35Z"
]
3 => array:11 [
"RoomKey" => "1660696049"
"RoomType" => "Living room"
"ListingId" => "40840369"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29911949"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T19:51:02.35Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911949/470-dundas-street-e-unit-604-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1568615"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "103841"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 515
+"OriginalEntryTimestamp": "2026-06-16T19:50:58.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1283810"
+"ListOfficeNationalAssociationId": "1325050"
+"CoListAgentNationalAssociationId": "1150320"
+"CoListOfficeNationalAssociationId": "1165450"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29911949_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/1f8292c7bc3239031976dc7ba5b01e8c.webp"
"MediaSize" => 132966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-1f8292c7bc3239031976dc7ba5b01e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29911949_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/8b3e5bbdfeb1638232366c217c641908.webp"
"MediaSize" => 131142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-8b3e5bbdfeb1638232366c217c641908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29911949_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/9c0b9268fc0c8cd7bb64a4cd4661f0d9.webp"
"MediaSize" => 134011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-9c0b9268fc0c8cd7bb64a4cd4661f0d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29911949_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/61534ca30394ae4d8b3f0e33c9f8c52f.webp"
"MediaSize" => 160758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-61534ca30394ae4d8b3f0e33c9f8c52f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29911949_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/2cd768e8338049b9ae17c7f92c987ec3.webp"
"MediaSize" => 129645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-2cd768e8338049b9ae17c7f92c987ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29911949_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/b2efe52082ab8c4544b5ed510c81542f.webp"
"MediaSize" => 137087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-b2efe52082ab8c4544b5ed510c81542f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29911949_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/cf7e16e48be1d3a0516a757046b3cb9b.webp"
"MediaSize" => 77841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-cf7e16e48be1d3a0516a757046b3cb9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:56.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29911949_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/bdace8f7da6ec00d30df5236f22205db.webp"
"MediaSize" => 104250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-bdace8f7da6ec00d30df5236f22205db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29911949_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/5d41cf56f6ac6e0a8b891d250fc7b543.webp"
"MediaSize" => 112857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-5d41cf56f6ac6e0a8b891d250fc7b543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29911949_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/1b4a474e88c531a52377c1f8fbb7b86b.webp"
"MediaSize" => 73121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-1b4a474e88c531a52377c1f8fbb7b86b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29911949_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/934fdbbca651cbae723feae778258d74.webp"
"MediaSize" => 79942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-934fdbbca651cbae723feae778258d74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29911949_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/8906a73058da0c5161aab000748e64c6.webp"
"MediaSize" => 88758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-8906a73058da0c5161aab000748e64c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29911949_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/f699fba95c3d2eb59c029b624859c172.webp"
"MediaSize" => 84571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-f699fba95c3d2eb59c029b624859c172.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29911949_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/09a6ac42693d092565b73519b7a50c84.webp"
"MediaSize" => 68290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-09a6ac42693d092565b73519b7a50c84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29911949_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/063c94ea0d91ca182a0864e6cbb0cc7a.webp"
"MediaSize" => 52560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-063c94ea0d91ca182a0864e6cbb0cc7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:54.56Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29911949_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/77d7b9ba07414a4686a98bafeea3b52d.webp"
"MediaSize" => 77345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-77d7b9ba07414a4686a98bafeea3b52d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29911949_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/ff592f09221bf61b8d6865b5db16a769.webp"
"MediaSize" => 88524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-ff592f09221bf61b8d6865b5db16a769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:55.29Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29911949_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/232ec0f65aa4cd3bd6d8e7b42a0644f0.webp"
"MediaSize" => 77268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-232ec0f65aa4cd3bd6d8e7b42a0644f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.36Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29911949_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/76723c2ff60f255e417b4d3d0e352621.webp"
"MediaSize" => 71360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-76723c2ff60f255e417b4d3d0e352621.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29911949_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/085875b11e433fe8f598eef485f41532.webp"
"MediaSize" => 66469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-085875b11e433fe8f598eef485f41532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29911949_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/4e2fd6b624cc2480f32fed6418a833f9.webp"
"MediaSize" => 75715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-4e2fd6b624cc2480f32fed6418a833f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29911949_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/63289d0419bf8a5c031b2c6393fb495a.webp"
"MediaSize" => 72553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-63289d0419bf8a5c031b2c6393fb495a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29911949_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/8bc27e2a667e2ac4dec2a76990677fc4.webp"
"MediaSize" => 73314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-8bc27e2a667e2ac4dec2a76990677fc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29911949_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/61ef36a9f849f1aa6ca7b57c09727981.webp"
"MediaSize" => 66644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-61ef36a9f849f1aa6ca7b57c09727981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29911949_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/05d67c76e4241a67c37a102c43e0347d.webp"
"MediaSize" => 91331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-05d67c76e4241a67c37a102c43e0347d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29911949_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/73a3cab16a6489df50266a13b9cb3be0.webp"
"MediaSize" => 85376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-73a3cab16a6489df50266a13b9cb3be0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.62Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29911949_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/05ff71edd21b9b19f0bc4430e43de044.webp"
"MediaSize" => 89182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-05ff71edd21b9b19f0bc4430e43de044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:53:05.09Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29911949_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/740cdcaba1b906bc1280ab7de10d7289.webp"
"MediaSize" => 89003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-740cdcaba1b906bc1280ab7de10d7289.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:53:01.7Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29911949_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/f3929799deb69c4d84e05b00d52faf3a.webp"
"MediaSize" => 83879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-f3929799deb69c4d84e05b00d52faf3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29911949_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/39fe26ce4e61f3ec30397773d564584f.webp"
"MediaSize" => 86819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-39fe26ce4e61f3ec30397773d564584f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29911949_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/4bf1d1dba27724ad83815a3c1eb7374e.webp"
"MediaSize" => 70900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-4bf1d1dba27724ad83815a3c1eb7374e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29911949_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/4db2b1b5ebaed60e5181cac45d0032e8.webp"
"MediaSize" => 58559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-4db2b1b5ebaed60e5181cac45d0032e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.2Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29911949_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/32ec5bde4f0cc8976a5737ab6706fc97.webp"
"MediaSize" => 62367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-32ec5bde4f0cc8976a5737ab6706fc97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.56Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29911949_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/afd9517648fdcf29eb180168d36bfb93.webp"
"MediaSize" => 94683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-afd9517648fdcf29eb180168d36bfb93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29911949_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/ff90596c7ebd9234613f2cb549db1048.webp"
"MediaSize" => 71159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-ff90596c7ebd9234613f2cb549db1048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29911949_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/5d143bcea5da114a9180c808858b0eba.webp"
"MediaSize" => 117281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-5d143bcea5da114a9180c808858b0eba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.2Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29911949_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/97709e8a5e37c2cb368eff34ac8f3ba4.webp"
"MediaSize" => 101930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-97709e8a5e37c2cb368eff34ac8f3ba4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:53:00.59Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29911949_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/219e1fa844bad982527eabd72fbe46de.webp"
"MediaSize" => 88890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-219e1fa844bad982527eabd72fbe46de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.68Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29911949_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/fcefae3f76e229eaa98308162ddf1dec.webp"
"MediaSize" => 87910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-fcefae3f76e229eaa98308162ddf1dec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29911949_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/62e2cbce9f600778125c8b298c67d50e.webp"
"MediaSize" => 95765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-62e2cbce9f600778125c8b298c67d50e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:58.46Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29911949_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/57651e0d1ff3f21a753652b4024b076c.webp"
"MediaSize" => 134082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-57651e0d1ff3f21a753652b4024b076c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.67Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29911949_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/4f55effee1ba542d473236f543966dc1.webp"
"MediaSize" => 68229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-4f55effee1ba542d473236f543966dc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29911949_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/ee74819aad6fa110cb3cf2e759f7651f.webp"
"MediaSize" => 64964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-ee74819aad6fa110cb3cf2e759f7651f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:52:57.69Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29911949_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29911949/8fccb4b7ad9082ef7cedb689995e7cd2.webp"
"MediaSize" => 102641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29911949/thumbnail-8fccb4b7ad9082ef7cedb689995e7cd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840369"
"ResourceRecordKey" => "29911949"
"ModificationTimestamp" => "2026-06-16T19:53:04.03Z"
]
44 => array:13 [
"Order" => 45
…12
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911949')"
+"ID": 1535992
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25125
+post_id: "1534978"
+post_author: 1
+"ListingKey": "29910671"
+"ListingId": "X13451454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:35:22Z"
+"RFModificationTimestamp": "2026-06-16T17:56:35Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0K2H6"
+"UnparsedAddress": "100 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L0K2H6"
+"Coordinates": array:2 [
0 => -79.900192
1 => 43.331966
]
+"Latitude": 43.331966
+"Longitude": -79.900192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Tucked into an established, tree-lined pocket with rare walkability, 100 Chudleigh Street is a mature-lot Waterdown home with the main floor opened up and reimagined for how families actually live now. This beautifully updated 4-bedroom, 2.5-bath home blends the open, connected layout buyers love in newer builds with the privacy, greenery, and lot size of an established neighbourhood. The main floor feels bright, warm, and easy, with designer touches throughout, a cozy fireplace, new luxury vinyl flooring, and a large kitchen featuring quartz counters, quartz backsplash, refreshed cabinetry, and generous space to gather. Carpet-free living continues throughout, with four comfortable bedrooms upstairs and a finished lower level that creates a huge suite-style retreat for teens, guests, long-staying in-laws, movie nights, or play space - with room for the wine collection tucked in too. Outside, the backyard is lush and surprisingly private, surrounded by mature greenery with no rear residential neighbours. Steps to everyday amenities, schools, trails, the YMCA, library, restaurants, shopping, Dairy Queen, and the summer farmers market - this is Waterdown family living with space, style, privacy, and true walkability. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:56:25.167411+00:00"
+"Directions": "Cross Streets: Hamilton & Dundas. ** Directions: Hamilton, Weston on White Oak Dr., Left on Chudleigh."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038275"
+"ListOfficeKey": "280499"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "50 x 125 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-16T17:26:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:26:57Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "100"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6718"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29910671/100-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-16T17:26:56.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314465"
+"ListOfficeNationalAssociationId": "1314683"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910671')"
+"ID": "1534978"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25122
+post_id: "1534315"
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"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": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": "1534315"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+post_id: "1534027"
+post_author: 1
+"ListingKey": "29908612"
+"ListingId": "40840175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:11:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street Unit# 709, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792813
1 => 43.3435237
]
+"Latitude": 43.3435237
+"Longitude": -79.8792813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to elevated condo living in the heart of East Waterdown! This beautifully upgraded 1-bedroom + oversized den condo offers modern style, functional space, and thoughtful design throughout. Currently used as an additional sleeping area, the spacious den offers exceptional flexibility and could easily function as a guest room, home office, nursery, fitness space, or multi-purpose retreat to suit your lifestyle. The open-concept layout is ideal for both everyday living and entertaining, highlighted by a stunning upgraded kitchen featuring a sleek granite waterfall peninsula, extended cabinetry for added storage, upgraded stainless steel appliances, and a contemporary single-basin sink. Premium upgraded flooring flows seamlessly throughout, complemented by smooth ceilings that create a clean, refined finish. Adding to the value and convenience, geothermal heating is included in the condo fees, offering efficient year-round comfort and reduced monthly utility costs. This well-appointed building also offers exceptional amenities including a stylish party room complete with a pool table, fireplace, comfortable seating area, and full kitchen, along with an exercise room, bicycle storage room, storage locker, underground parking space, and an outdoor terrace featuring seating areas and BBQs—perfect for entertaining and enjoying the community atmosphere. Ideally located in desirable East Waterdown, enjoy quick access to major highways while being close to parks, shopping, dining, and the natural beauty of the nearby Niagara Escarpment and surrounding trails—offering the perfect blend of urban convenience and outdoor living. Move in and enjoy stylish, low-maintenance living in one of Waterdown’s most sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:29.675759+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021739"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:17Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3007.36"
+"VirtualTourURLUnbranded": "https://youtu.be/U-fSD3T-vSs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908612/460-e-dundas-street-unit-709-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-16T12:50:17.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1301652"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908612')"
+"ID": "1534027"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25124
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:15:22Z"
+"ListPrice": 454900.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-16T16:51:19Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25119
+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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904850')"
+"ID": "1530966"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25128
+post_id: "1522007"
+post_author: 1
+"ListingKey": "29891787"
+"ListingId": "40839144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:40:07Z"
+"RFModificationTimestamp": "2026-06-16T14:43:38Z"
+"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:62650)"
+"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-16T14:31:48Z"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891787')"
+"ID": "1522007"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 210
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]