array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29861304 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1500032"
+post_author: 1
+"ListingKey": "29861304"
+"ListingId": "X13248632"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T12:30:23Z"
+"RFModificationTimestamp": "2026-06-14T12:40:51Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S1"
+"UnparsedAddress": "77 CATHEDRAL COURT, Hamilton (Waterdown), Ontario L8B0S1"
+"Coordinates": array:2 [
0 => -79.911965
1 => 43.332472
]
+"Latitude": 43.332472
+"Longitude": -79.911965
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 77 Cathedral Crt, a spacious Waterdown townhome situated on a quiet cul-de-sac in a highly convenient, family-friendly neighbourhood. This move-in ready 3-bedroom (plus den) home offers a bright, open-concept layout with a well-defined dining area and a large eat-in kitchen featuring a walkout to an oversized deck, overlooking a lovely rear yard-perfect for entertaining and everyday living. The freshly painted main floor is complemented by generous principal living and dining spaces, enhanced by a cozy double-sided fireplace, while the second level offers a well-appointed primary bedroom complete with a 4-piece ensuite, separate shower, large soaker tub, and his-and-hers closets, along with two additional bedrooms and a versatile den ideal, for a home office or nursery. The finished lower level adds valuable living space with a large family room featuring a walkout to a private backyard with no rear neighbours, a 2-piece bathroom, laundry area, and ample storage. Additional features include an attached garage, with access from house, for added convenience and secure parking. Located within walking distance to schools, daycare, the YMCA, and Memorial Park with its baseball diamond, splash pad, and skating loop. Quick access to Highway 403, QEW, 407, and Aldershot GO ensures an easy commute. A fantastic turnkey opportunity in a sought-after location-don't miss it. Updates: Furnace (2023), Ecobee smart thermostat, Stonework at front (2025), New Garage Door (2025) & Garage Door Opener operated with MyQ App (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:43:44.180906+00:00"
+"Directions": "Hamilton St, Nisbet, Cathedral"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1433530"
+"ListOfficeKey": "279258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "19.7 x 100.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T17:33:11Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T12:23:42Z"
+"Stories": "2.0"
+"StreetName": "Cathedral"
+"StreetNumber": "77"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "6239.2"
+"VirtualTourURLUnbranded": "https://hometours.blackhausvisuals.com/77_cathedral_ct-1286?branding=false"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1659054221"
"RoomType" => "Foyer"
"ListingId" => "X13248632"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.83
"ListingKey" => "29861304"
"RoomLength" => 2.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
1 => array:11 [
"RoomKey" => "1659054222"
"RoomType" => "Dining room"
"ListingId" => "X13248632"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.0
"ListingKey" => "29861304"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
2 => array:11 [
"RoomKey" => "1659054223"
"RoomType" => "Other"
"ListingId" => "X13248632"
"RoomLevel" => "Basement"
"RoomWidth" => 3.41
"ListingKey" => "29861304"
"RoomLength" => 9.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
3 => array:11 [
"RoomKey" => "1659054224"
"RoomType" => "Cold room"
"ListingId" => "X13248632"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29861304"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
4 => array:11 [
"RoomKey" => "1659054225"
"RoomType" => "Living room"
"ListingId" => "X13248632"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.0
"ListingKey" => "29861304"
"RoomLength" => 4.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
5 => array:11 [
"RoomKey" => "1659054226"
"RoomType" => "Kitchen"
"ListingId" => "X13248632"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.4
"ListingKey" => "29861304"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.52Z"
]
6 => array:11 [
"RoomKey" => "1659054227"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13248632"
"RoomLevel" => "Second level"
"RoomWidth" => 3.6
"ListingKey" => "29861304"
"RoomLength" => 5.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
7 => array:11 [
"RoomKey" => "1659054228"
"RoomType" => "Bedroom 2"
"ListingId" => "X13248632"
"RoomLevel" => "Second level"
"RoomWidth" => 2.8
"ListingKey" => "29861304"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
8 => array:11 [
"RoomKey" => "1659054229"
"RoomType" => "Bedroom 3"
"ListingId" => "X13248632"
"RoomLevel" => "Second level"
"RoomWidth" => 2.75
"ListingKey" => "29861304"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
9 => array:11 [
"RoomKey" => "1659054230"
"RoomType" => "Den"
"ListingId" => "X13248632"
"RoomLevel" => "Second level"
"RoomWidth" => 2.0
"ListingKey" => "29861304"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
10 => array:11 [
"RoomKey" => "1659054231"
"RoomType" => "Family room"
"ListingId" => "X13248632"
"RoomLevel" => "Basement"
"RoomWidth" => 4.4
"ListingKey" => "29861304"
"RoomLength" => 5.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
11 => array:11 [
"RoomKey" => "1659054232"
"RoomType" => "Laundry room"
"ListingId" => "X13248632"
"RoomLevel" => "Basement"
"RoomWidth" => 2.46
"ListingKey" => "29861304"
"RoomLength" => 2.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-14T12:23:42.53Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861304/77-cathedral-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2163670"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279258"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-05T17:33:11.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1062037"
+"ListOfficeNationalAssociationId": "1302363"
+"CoListAgentNationalAssociationId": "1414651"
+"CoListOfficeNationalAssociationId": "1302363"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29861304_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/ed08d958b6e4889726ed8f0345f63cae.webp"
"MediaSize" => 322883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-ed08d958b6e4889726ed8f0345f63cae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 77 Cathedral Court."
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861304_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/c7d114f6fcd2ec1d1614ec8e83fb1666.webp"
"MediaSize" => 360063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-c7d114f6fcd2ec1d1614ec8e83fb1666.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Located in Waterdown, ON."
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861304_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/ba077fe42a112e048467f76dcdec3271.webp"
"MediaSize" => 314796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-ba077fe42a112e048467f76dcdec3271.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861304_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/539b9f20592da3f6923e6ffe4664050c.webp"
"MediaSize" => 480658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-539b9f20592da3f6923e6ffe4664050c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861304_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/b603ecd7d3dcbb2f109bf3c01e6e0ba5.webp"
"MediaSize" => 164512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-b603ecd7d3dcbb2f109bf3c01e6e0ba5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861304_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/e426b53fe61212b108a406fbfadcc8db.webp"
"MediaSize" => 177790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-e426b53fe61212b108a406fbfadcc8db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861304_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/d07e3c6b24daea27de961dc25fca4cf2.webp"
"MediaSize" => 200466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-d07e3c6b24daea27de961dc25fca4cf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861304_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/f47b9d53bd8b1ec36804d17fdeb8642e.webp"
"MediaSize" => 192950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-f47b9d53bd8b1ec36804d17fdeb8642e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861304_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/7cf3c65483de1e4515c30bd8565a675b.webp"
"MediaSize" => 169910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-7cf3c65483de1e4515c30bd8565a675b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861304_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/d298c410091200fed6f693ecfc24b2c3.webp"
"MediaSize" => 222329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-d298c410091200fed6f693ecfc24b2c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29861304_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/2edc45486c51677aa50a2fcbe25eb93f.webp"
"MediaSize" => 253187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-2edc45486c51677aa50a2fcbe25eb93f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29861304_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/c04276c0b673caf774d676e4aeb91dcf.webp"
"MediaSize" => 223130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-c04276c0b673caf774d676e4aeb91dcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29861304_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/03a06155969497aaeb88a4dcf7c4a7e4.webp"
"MediaSize" => 229489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-03a06155969497aaeb88a4dcf7c4a7e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29861304_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/241c32f3e83957445b785afdf2c877b2.webp"
"MediaSize" => 164585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-241c32f3e83957445b785afdf2c877b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29861304_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/0bd97dd9ce9298503316229c31117650.webp"
"MediaSize" => 231876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-0bd97dd9ce9298503316229c31117650.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29861304_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/4b02e3abb65587a0ace23c1d40255f37.webp"
"MediaSize" => 208076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-4b02e3abb65587a0ace23c1d40255f37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29861304_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/cf8bd0c816daff9181f7553a1232609a.webp"
"MediaSize" => 211578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-cf8bd0c816daff9181f7553a1232609a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29861304_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/a20ee1becbe101ae6cba731666df7681.webp"
"MediaSize" => 216687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-a20ee1becbe101ae6cba731666df7681.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29861304_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/33584965e88b92d7bb6ec7ad7498fb99.webp"
"MediaSize" => 192029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-33584965e88b92d7bb6ec7ad7498fb99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29861304_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/d0fe94610e653d9a453869ac0823fcc2.webp"
"MediaSize" => 157956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-d0fe94610e653d9a453869ac0823fcc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29861304_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/408bf01049346b7a09badccea3af9674.webp"
"MediaSize" => 107498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-408bf01049346b7a09badccea3af9674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29861304_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/ece007fdb15a95a1fc923994593f41fe.webp"
"MediaSize" => 217254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-ece007fdb15a95a1fc923994593f41fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29861304_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/99641f50f1ce5aba0b6fae2ad982fe54.webp"
"MediaSize" => 208548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-99641f50f1ce5aba0b6fae2ad982fe54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29861304_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/1d4880f79a014c86821ef93dc8449187.webp"
"MediaSize" => 210151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-1d4880f79a014c86821ef93dc8449187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "With 4 pc ensuite."
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29861304_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/2816b8121d1cd20c891e11b0793553ff.webp"
"MediaSize" => 207927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-2816b8121d1cd20c891e11b0793553ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29861304_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/7891de4c837c6c01ad3f50e338e2388f.webp"
"MediaSize" => 167277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-7891de4c837c6c01ad3f50e338e2388f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29861304_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/64a83d6fa19a2e457d6c965b4b5209a6.webp"
"MediaSize" => 177955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-64a83d6fa19a2e457d6c965b4b5209a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29861304_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/b42629ce122726135b8c5d2e89082417.webp"
"MediaSize" => 182941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-b42629ce122726135b8c5d2e89082417.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29861304_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/545d61deca1ecb031c8a1093d24fd8f3.webp"
"MediaSize" => 164678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-545d61deca1ecb031c8a1093d24fd8f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29861304_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/71151a23cfdc9b2bb75e0e3015f5ce2f.webp"
"MediaSize" => 211718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-71151a23cfdc9b2bb75e0e3015f5ce2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3rd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29861304_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/0a7c8fe0ded2340c1da7bdfefc56bb89.webp"
"MediaSize" => 183309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-0a7c8fe0ded2340c1da7bdfefc56bb89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29861304_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/d7a927ffc0f1ea507a206dac99cc8b2b.webp"
"MediaSize" => 148425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-d7a927ffc0f1ea507a206dac99cc8b2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Den"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29861304_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/83f96af127e143183504b519dd2c9c88.webp"
"MediaSize" => 177808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-83f96af127e143183504b519dd2c9c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "A second 4pc bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29861304_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/8a37b2d966ba7b8a2816fa3f2361639b.webp"
"MediaSize" => 209812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-8a37b2d966ba7b8a2816fa3f2361639b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29861304_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/4ea13516388e0d96e316ebaf55ecca13.webp"
"MediaSize" => 212995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-4ea13516388e0d96e316ebaf55ecca13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Relaxing entertainment space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29861304_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/b8bb896c5d49a0a25220ca8597f3fa5d.webp"
"MediaSize" => 244313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-b8bb896c5d49a0a25220ca8597f3fa5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "With a walk out to the backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29861304_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/4020d2bed210aaddc8d4ea71ca263d73.webp"
"MediaSize" => 144611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-4020d2bed210aaddc8d4ea71ca263d73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "A laundry room/ 2pc bathroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29861304_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/642c2d3efc30e18aa367449c6d0d511b.webp"
"MediaSize" => 339016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-642c2d3efc30e18aa367449c6d0d511b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The upper deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29861304_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/14f66f72ce1b621a45953c8bba55be05.webp"
"MediaSize" => 314476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-14f66f72ce1b621a45953c8bba55be05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29861304_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/ff49c6600b8bcd5748b69ae4ce80835c.webp"
"MediaSize" => 364938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-ff49c6600b8bcd5748b69ae4ce80835c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29861304_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/a14e62854274406ac89e2eefc472a2d4.webp"
"MediaSize" => 439013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-a14e62854274406ac89e2eefc472a2d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "A lovely backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29861304_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/e0aa2fa3b38404996f03efde0cfd7556.webp"
"MediaSize" => 439972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-e0aa2fa3b38404996f03efde0cfd7556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29861304_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/dbab3d770736a7b413e9aa24978b1083.webp"
"MediaSize" => 441177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-dbab3d770736a7b413e9aa24978b1083.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29861304_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/f79b9cea3d972d7105cc0016cb79f9a8.webp"
"MediaSize" => 314849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-f79b9cea3d972d7105cc0016cb79f9a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29861304_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/9df9d5453982bfc76a6af57cfd4e1add.webp"
"MediaSize" => 414668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-9df9d5453982bfc76a6af57cfd4e1add.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29861304_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/09bdef05edcac52a44473d9083f36ca3.webp"
"MediaSize" => 413608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-09bdef05edcac52a44473d9083f36ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29861304_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861304/8d17b7100f6a17d3a70430f2d248d634.webp"
"MediaSize" => 421191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861304/thumbnail-8d17b7100f6a17d3a70430f2d248d634.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248632"
"ResourceRecordKey" => "29861304"
"ModificationTimestamp" => "2026-06-05T17:33:11.85Z"
]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861304')"
+"ID": "1500032"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 279258" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24879
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1433530" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24852
+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 '29861304'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25198
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29861304'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31389581"
+"ListingKey": "29861304"
+"ListingId": "X13248632"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T12:00:00Z"
+"OpenHouseEndTime": "2026-06-13T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T01:47:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31389581')"
}
]
+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 '29861304' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.911965 43.332472)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25289
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1546802"
+post_author: 1
+"ListingKey": "29926451"
+"ListingId": "X13465026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:55:19Z"
+"RFModificationTimestamp": "2026-06-19T04:50:46Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "37 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today's busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you're purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown's most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T04:50:35.310980+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102522"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Flat site"
]
+"LotSizeDimensions": "19.7 x 52.3 FT"
+"ParkingFeatures": array:4 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
3 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-06-19T01:47:24Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T01:47:24Z"
+"Stories": "3.0"
+"StreetName": "Nisbet"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4319"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662654788"
"RoomType" => "Foyer"
"ListingId" => "X13465026"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.57
"ListingKey" => "29926451"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.15Z"
]
1 => array:11 [
"RoomKey" => "1662654789"
"RoomType" => "Laundry room"
"ListingId" => "X13465026"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.57
"ListingKey" => "29926451"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T01:47:24.16Z"
]
2 => array:11 [
"RoomKey" => "1662654790"
"RoomType" => "Bathroom"
"ListingId" => "X13465026"
"RoomLevel" => "Second level"
"RoomWidth" => 0.79
"ListingKey" => "29926451"
"RoomLength" => 1.99
"RoomDimensions" => null
"RoomDescription" => null
…2
]
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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926451/37-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-19T01:47:24.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372275"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926451')"
+"ID": "1546802"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1546054"
+post_author: 1
+"ListingKey": "29925894"
+"ListingId": "40840606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:00:08Z"
+"RFModificationTimestamp": "2026-06-19T01:45:59Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1439.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 37, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9076836
1 => 43.3385672
]
+"Latitude": 43.3385672
+"Longitude": -79.9076836
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today’s busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you’re purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown’s most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:09:05.929659+00:00"
+"Directions": "HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525003"
+"ListOfficeKey": "284639"
+"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-18T22:52:08Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T00:50:34Z"
+"Stories": "3.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4919"
+"VirtualTourURLUnbranded": "https://youtu.be/YFL0PTww-3Y"
+"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/29925894/54-nisbet-boulevard-unit-37-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1439
+"OriginalEntryTimestamp": "2026-06-18T22:51:09.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1063779"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925894')"
+"ID": "1546054"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1545200"
+post_author: 1
+"ListingKey": "29924409"
+"ListingId": "40840763"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:05:04Z"
+"RFModificationTimestamp": "2026-06-18T20:24:46Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2815.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L8B0G3"
+"UnparsedAddress": "34 HOWARD Boulevard, Burlington, Ontario L8B0G3"
+"Coordinates": array:2 [
0 => -79.8940271
1 => 43.3276387
]
+"Latitude": 43.3276387
+"Longitude": -79.8940271
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this wonderful family home in one of Waterdown’s most sought-after neighborhoods! Beautifully landscaped gardens and an inviting flagstone staircase create exceptional curb appeal from the moment you arrive. Inside, you'll find gorgeous hardwood floors, a warm and welcoming family room with a gas fireplace, and a spacious kitchen offering abundant cabinetry, pantry storage, and plenty of room for family gatherings. The beautifully updated bathrooms add a touch of modern elegance, while the versatile lower level features a separate exterior entrance—ideal for an in-law suite, teenage retreat, or home office. Backing onto a tranquil ravine, there is a walk out from the main level to the private backyard which boasts a newer two-tier deck, perfect for entertaining or simply enjoying the natural surroundings. Conveniently located close to shopping, cafés, restaurants, pubs, walking trails, and the scenic Smokey Hollow Waterfall, this home also offers easy access to the Burlington GO Station, Highway 6, Highway 403, and Highway 407, making commuting a breeze. A perfect blend of comfort, convenience, and lifestyle—this is a home you won’t want to miss! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T20:24:33.992597+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:01Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:51:01Z"
+"Stories": "2.0"
+"StreetName": "HOWARD"
+"StreetNumber": "34"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8743"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70321"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924409/34-howard-boulevard-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CM, R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 79.0
+"AboveGradeFinishedArea": 2025
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-18T19:51:01.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064859"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924409')"
+"ID": "1545200"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1544376"
+post_author: 1
+"ListingKey": "29922718"
+"ListingId": "X13462164"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:01Z"
+"RFModificationTimestamp": "2026-06-18T18:33:13Z"
+"ListPrice": 1750000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafter custom bungalow, situated on animpressive .45 acre lot just minutes from downtown Waterdown. Exterior features the following:full house generator, sprinkler system, 2 hammer head paved parking spaces, landscaped gardenswith rockery, front light pillars. large trees for privacy. wrought iron front porch withdouble custom doors with side lights and separate door for the lower level also. 2.5 car garagewith work bench. fully fenced yard. flag stone patio and stairs, garden shed, fire pit. Theupper level with 3 bedroom/2 ensuites and powder room. sunken family room overlooking rearflagstone/gardens and awning. Separate office, dining room and garden room with an open conceptfloor plan. Along with the lower level being wonderful for in-laws or multi generation familywith its own walk out patio to walk up yard. The home has 2 laundry rooms, 2 full stainlessappliance kitchens with islands.Please note that the listing agent is related to the seller. (id:62783)"
+"Appliances": array:20 [
0 => "All"
1 => "Washer"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Range"
9 => "Oven"
10 => "Dryer"
11 => "Microwave"
12 => "Freezer"
13 => "Oven - Built-In"
14 => "Water Treatment"
15 => "Window Coverings"
16 => "Garage door opener remote(s)"
17 => "Water Heater - Tankless"
18 => "Water Heater"
19 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:8 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "Walk-up"
5 => "N/A"
6 => "N/A"
7 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:33:08.954267+00:00"
+"Directions": "Cross Streets: Dundas Street East & Riley. ** Directions: Hwy 6 & Dundas Street East to the 3rd stoplightin intersection."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Lighting"
2 => "Wheelchair access"
3 => "Carpet Free"
4 => "Sump Pump"
5 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-18T16:56:27Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:56:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10000"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29922718/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-18T16:56:27.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922718')"
+"ID": "1544376"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1542841"
+post_author: 1
+"ListingKey": "29921322"
+"ListingId": "40841038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:00:08Z"
+"RFModificationTimestamp": "2026-06-18T15:45:26Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1663.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H6"
+"UnparsedAddress": "46 HARNESWORTH Crescent, Waterdown, Ontario L0R2H6"
+"Coordinates": array:2 [
0 => -79.9053216
1 => 43.3341711
]
+"Latitude": 43.3341711
+"Longitude": -79.9053216
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**4 bedrooms, 3 washrooms, finished basement and a renovated kitchen! Welcome to 46 Harnesworth Crescent, located in one of Waterdown's most desirable neighbourhoods. This lovely semi-detached home features a beautifully upgraded custom kitchen, a renovated primary ensuite, an outdoor gas line for BBQs, and an exposed aggregate driveway and backyard patio pad. Boasting a fantastic layout, this home offers four generously sized bedrooms and a professionally finished basement, providing the perfect extra space for family living, entertaining, or a home office setup. Ideally situated within walking distance to grocery stores, plazas, and parks, and just minutes from the YMCA and schools, this home is perfectly located for growing families and active lifestyles. Set in a wonderful, family-friendly neighbourhood, this is an exceptional opportunity to enjoy comfort, convenience, and community all in one place. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"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-18T15:45:22.122250+00:00"
+"Directions": "Hamilton to Rockhaven to Harnesworth"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946034"
+"ListOfficeKey": "78242"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:52:51Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:52:51Z"
+"Stories": "2.0"
+"StreetName": "HARNESWORTH"
+"StreetNumber": "46"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4971.97"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_harnesworth_crescent_hamilton_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921322/46-harnesworth-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1663
+"OriginalEntryTimestamp": "2026-06-18T14:52:50.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303132"
+"ListOfficeNationalAssociationId": "1137129"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921322')"
+"ID": "1542841"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1541136"
+post_author: 1
+"ListingKey": "29918995"
+"ListingId": "X13458554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:55:04Z"
+"RFModificationTimestamp": "2026-06-18T15:05:52Z"
+"ListPrice": 673000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "219 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all down-sizers, right-sizers and anyone looking for a bungalow-sized condo without the upkeep of a house! This sun-filled, end-unit suite in the heart of Waterdown offers 1,320 square feet of one-level living, anchored by a spacious open-concept living and dining area that gives you plenty of room to spread out. Step inside and the ten-foot ceilings paired with oversized south-west facing windows fill the entire open-concept space with natural light. A cozy gas fireplace anchors the living and dining area. Classic wainscoting throughout gives the whole unit a polished, finished look without you having to lift a finger. The kitchen pairs granite countertops with stainless steel appliances, ready for everything from a quick weeknight dinner to hosting friends. Both bedrooms offer comfortable, private space. Semi-ensuite four-piece main bathroom, and a separate guest powder room means visitors have their own space too. In-suite pantry and laundry makes life a little easier. Your own southern exposure open balcony is the perfect spot for a quiet morning coffee. This unit truly sets itself apart with two parking spaces, one underground and one at main level, plus your own exclusive locker on the same floor as your suite, no trekking up or down for storage. Life in this boutique, low-rise community comes with real perks too. The building offers a recreation room, party and meeting room, visitor parking and a barbecue-friendly policy, and pets are welcome with some restrictions. Your maintenance fee covers water, building insurance, parking and common elements. Step outside and you are just steps from restaurants, groceries, parks, the library, transit and everything Waterdown's charming downtown has to offer. This is bungalow-style living with the parking, storage and location to match. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "841"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:41:58.635595+00:00"
+"Directions": "Cross Streets: HAMILTON ST N. ** Directions: PARKSIDE DR TO HAMILTON ST N TO DUNSAD ST E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Balcony"
2 => "Paved yard"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T14:46:35Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:46:35Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5108"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918995/219-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T21:55:05.79Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918995')"
+"ID": "1541136"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1540586"
+post_author: 1
+"ListingKey": "29918287"
+"ListingId": "40840739"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:07Z"
+"RFModificationTimestamp": "2026-06-17T21:43:46Z"
+"ListPrice": 673000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1298.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 DUNDAS Street E Unit# 219, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896064
1 => 43.329851
]
+"Latitude": 43.329851
+"Longitude": -79.896064
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Calling all down-sizers, right-sizers and anyone looking for a bungalow-sized condo without the upkeep of a house! This sun-filled, end-unit suite in the heart of Waterdown offers 1,320 square feet of one-level living, anchored by a spacious open-concept living and dining area that gives you plenty of room to spread out. Step inside and the ten-foot ceilings paired with oversized south-west facing windows fill the entire open-concept space with natural light. A cozy gas fireplace anchors the living and dining area. Classic wainscoting throughout gives the whole unit a polished, finished look without you having to lift a finger. The kitchen pairs granite countertops with stainless steel appliances, ready for everything from a quick weeknight dinner to hosting friends. Both bedrooms offer comfortable, private space. Semi-ensuite four-piece main bathroom, and a separate guest powder room means visitors have their own space too. In-suite pantry and laundry makes life a little easier. Your own southern exposure open balcony is the perfect spot for a quiet morning coffee. This unit truly sets itself apart with two parking spaces, one underground and one at main level, plus your own exclusive locker on the same floor as your suite, no trekking up or down for storage. Life in this boutique, low-rise community comes with real perks too. The building offers a recreation room, party and meeting room, visitor parking and a barbecue-friendly policy, and pets are welcome with some restrictions. Your maintenance fee covers water, building insurance, parking and common elements. Step outside and you are just steps from restaurants, groceries, parks, the library, transit and everything Waterdown's charming downtown has to offer. This is bungalow-style living with the parking, storage and location to match. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"AssociationFee": "841"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T20:55:07.340654+00:00"
+"Directions": "PARKSIDE DR TO HAMILTON ST N TO DUNSAD ST E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T20:20:58Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5108"
+"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/29918287/262-dundas-street-e-unit-219-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1298
+"OriginalEntryTimestamp": "2026-06-17T20:20:57.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918287')"
+"ID": "1540586"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1540334"
+post_author: 1
+"ListingKey": "29917254"
+"ListingId": "X13457120"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:30:07Z"
+"RFModificationTimestamp": "2026-06-17T19:44:58Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L3"
+"UnparsedAddress": "29 SUNNYCROFT COURT, Hamilton (Waterdown), Ontario L8B0L3"
+"Coordinates": array:2 [
0 => -79.8987563
1 => 43.3270443
]
+"Latitude": 43.3270443
+"Longitude": -79.8987563
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 29 Sunnycroft Court, a beautifully maintained freehold semi-detached home nestled on a quiet court in one of Waterdown's most sought-after neighbourhoods. Backing onto greenspace with no rear neighbours, this home offers the perfect blend of privacy, convenience, and low-maintenance living-with no condo or road fees. Built in 2005 and thoughtfully designed with timeless finishes, the main floor features 9-foot ceilings, abundant natural light, hardwood flooring, and an inviting open-concept layout ideal for everyday living and entertaining. The upgraded kitchen is equipped with tall cabinetry, crown moulding, granite countertops, stainless steel appliances, a gas stove, and a breakfast bar overlooking the spacious great room with gas fireplace and backyard views. Step outside to a large elevated deck surrounded by mature landscaping, creating the perfect setting to enjoy your morning coffee or unwind while overlooking the peaceful greenspace beyond while soaking in the hot tub. Upstairs, the spacious primary retreat features a 4-piece ensuite and dual closets, while two additional bedrooms are served by a convenient Jack-and-Jill style full bathroom. The finished lower level adds valuable living space with a versatile bright rec room, 2--piece bathroom, laundry area, and plenty of storage. Additional highlights include inside garage access, a private two-car driveway, covered front porch entrance with transom windows, and a freshly painted interior throughout. Upgrades include a new furnace and light fixtures April 2026, and roof shingles replaced in 2018. Ideally located just steps to downtown Waterdown's shops, restaurants, library, public transit, and scenic escarpment trails, this is an exceptional opportunity to enjoy executive-style living in a mature, family-friendly community. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:44:51.825583+00:00"
+"Directions": "Cross Streets: Dundas St E. & Sunnycroft. ** Directions: Take Dundas St E. to Sunnycroft Court and head East. Property will be on your left hand side."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2223245"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Wooded area"
]
+"LotSizeDimensions": "20.1 x 120.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T18:21:36Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:21:36Z"
+"Stories": "2.0"
+"StreetName": "Sunnycroft"
+"StreetNumber": "29"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5412.52"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/29-sunnycroft-ct-hamilton-on-l8b-0l3-25857874/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917254/29-sunnycroft-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4-2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.1
+"OriginalEntryTimestamp": "2026-06-17T18:21:36.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1466673"
+"ListOfficeNationalAssociationId": "1408695"
+"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('29917254')"
+"ID": "1540334"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1539021"
+post_author: 1
+"ListingKey": "29915426"
+"ListingId": "X13455236"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:05:08Z"
+"RFModificationTimestamp": "2026-06-17T20:22:33Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J9"
+"UnparsedAddress": "178 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L8B0J9"
+"Coordinates": array:2 [
0 => -79.903351
1 => 43.332329
]
+"Latitude": 43.332329
+"Longitude": -79.903351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Freehold semi-detached home on child-friendly street in desirable Waterdown! This very clean and bright brick home with a covered front porch features an open-concept kitchen and dining area overlooking the family room with a cozy gas fireplace. Walk out to the generous backyard with large decks and plenty of green space for kids and pets to enjoy. The spacious Primary bedroom offers a 4-piece ensuite and a walk-in closet with built-in organizers, complemented by Closets by Design organizers in the foyer and all other bedrooms. Recent upgrades include: appliances, backyard deck, engineered hardwood flooring throughout the upper level, updated stair carpeting, front door blinds, and Kohler toilets with bidet assemblies in both the ensuite and main bathroom. The home is also equipped with an alarm system featuring a doorbell camera, front and rear exterior cameras, garage sensors, and three door sensors for peace of mind. Fantastic location within walking distance to Memorial Park with splash pad, baseball diamonds, and year-round skating. Surrounded by the Greenbelt and close to parks, trails, the farmers' market, schools, YMCA, shopping, restaurants, and everyday amenities. Just 10 minutes to Aldershot GO Station with quick access to the 403, 407, and QEW. This home is a real gem! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Alarm System"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:21:32.702523+00:00"
+"Directions": "Cross Streets: ROCKHAVEN LN AND SEGWUN RD. ** Directions: DUNDAS ST E, HAMILTON ST N, WHITE OAK DR, CHUDLEIGH ST."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972724"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "26.3 x 119.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T15:03:10Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T19:59:54Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "178"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5646"
+"VirtualTourURLUnbranded": "https://youriguide.com/178_chudleigh_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915426/178-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-06-17T15:03:10.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1259714"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915426')"
+"ID": "1539021"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 115
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]