array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29069490 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "935040"
+post_author: 1
+"ListingKey": "29069490"
+"ListingId": "40785817"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T20:50:00Z"
+"RFModificationTimestamp": "2026-07-16T20:56:45Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.195
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0E8"
+"UnparsedAddress": "24 BERRY HILL Avenue, Waterdown, Ontario L8B0E8"
+"Coordinates": array:2 [
0 => -79.89674798
1 => 43.32712753
]
+"Latitude": 43.32712753
+"Longitude": -79.89674798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Lot in Waterdown (61.5' X 137')* Located steps from Waterdown’s downtown, this prime lot offers a unique development opportunity, nestled on a quiet closed avenue (cul-de-sac). With services available at the road and a full plan/permit package included, it’s ready for your custom dream home. Just minutes from parks, schools, shops, trails, and easy access to highways, it’s a rare chance to buy and hold or build now, as property values rise in this flourishing area. *Original Design* Development charges are already paid, and permits are approved for a single detached home of up to 4,000 sq ft with a walk-out basement. Architectural drawings are ready. *New Design* The new plans include a main floor bedroom with a walk-in closet and ensuite, ideal as an in-law suite. A separate spice kitchen adds convenience. The second floor features two master bedrooms with ensuites, plus a loft that can be converted into a fifth bedroom, opening to a covered balcony. Each bedroom has a walk-in closet and ensuite, ensuring privacy and comfort. This lot offers flexibility and potential, whether you’re ready to build or looking for an investment opportunity in a flourishing area. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-06T01:17:50.129630+00:00"
+"Directions": "403/Hwy 6/ Dundas/ Berryhill"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147155"
+"ListOfficeKey": "67816"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"LotSizeDimensions": "0.195"
+"PhotosChangeTimestamp": "2026-07-16T20:40:27Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T20:40:27Z"
+"StreetName": "BERRY HILL"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3466"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29069490/24-berry-hill-avenue-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"FrontageLengthNumeric": 62.0
+"OriginalEntryTimestamp": "2025-11-05T15:49:19.29Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1398255"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:25 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6296484642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/f2accf62739bca3324df72885bd7f776.webp"
"MediaSize" => 63461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-f2accf62739bca3324df72885bd7f776.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6296484644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/c5c07acf30f9390337e440d8da8e438a.webp"
"MediaSize" => 57387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-c5c07acf30f9390337e440d8da8e438a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6296484652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/5727d0ad131286218012ddcc77d9a6ed.webp"
"MediaSize" => 51975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-5727d0ad131286218012ddcc77d9a6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6296484661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/e79a271586f719727ad79bb3d4d4f21d.webp"
"MediaSize" => 60124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-e79a271586f719727ad79bb3d4d4f21d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6296484668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/cf6b05e3a0a22b57133b9526686d4a77.webp"
"MediaSize" => 39476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-cf6b05e3a0a22b57133b9526686d4a77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6296484679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/5a87949d6542651c955aa02a2fff2333.webp"
"MediaSize" => 42785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-5a87949d6542651c955aa02a2fff2333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6296484685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/d19ce1c49f76763acd3eed6191dbb4e1.webp"
"MediaSize" => 63223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-d19ce1c49f76763acd3eed6191dbb4e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6296484707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/586e014cd3585f68899925636548af97.webp"
"MediaSize" => 47710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-586e014cd3585f68899925636548af97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6296484741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/0b5d60abacf6d0ccb5ac529fddeaa2f9.webp"
"MediaSize" => 56770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-0b5d60abacf6d0ccb5ac529fddeaa2f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6296484743"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/bda77fb566a0c01353020c63ca5b1fde.webp"
"MediaSize" => 86549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-bda77fb566a0c01353020c63ca5b1fde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6296484789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/03452eb59cfea3c8d912d30c0b74992d.webp"
"MediaSize" => 143732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-03452eb59cfea3c8d912d30c0b74992d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6296484802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/7be1149f9e29b99ea0e2a7d368f053e3.webp"
"MediaSize" => 59252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-7be1149f9e29b99ea0e2a7d368f053e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6296484812"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/42aba55041c6b457db40600791ca6ee0.webp"
"MediaSize" => 57132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-42aba55041c6b457db40600791ca6ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6296484826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/833aae431ad9f24461ac0eeaff0db4f7.webp"
"MediaSize" => 40052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-833aae431ad9f24461ac0eeaff0db4f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6296484848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/842792cecc8ed011c1d44714ff78e8d5.webp"
"MediaSize" => 39155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-842792cecc8ed011c1d44714ff78e8d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6296484867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/644ebffc05136031807c6551417f459c.webp"
"MediaSize" => 38653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-644ebffc05136031807c6551417f459c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6296484909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/46035baa76253a58c888fab1f4bd3ba9.webp"
"MediaSize" => 36632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-46035baa76253a58c888fab1f4bd3ba9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6296484950"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/36d6717f3ccd1d106bf536461997b85e.webp"
"MediaSize" => 54659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-36d6717f3ccd1d106bf536461997b85e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6296484994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/6a1a19a87a95fb1c9e3f3304f9b87bac.webp"
"MediaSize" => 60800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-6a1a19a87a95fb1c9e3f3304f9b87bac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6296485040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/a3b8ca74f8cb09c253f9864eac8aa839.webp"
"MediaSize" => 66982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-a3b8ca74f8cb09c253f9864eac8aa839.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6296485060"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/1996a68c403bfe61a3bb0717b0488720.webp"
"MediaSize" => 50617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-1996a68c403bfe61a3bb0717b0488720.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6296485108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/4bc37ae552407073010ff4815d2459c1.webp"
"MediaSize" => 96634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-4bc37ae552407073010ff4815d2459c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6296485122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/b3ba11019a7a4566fdeea964bbbe4f6a.webp"
"MediaSize" => 58236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-b3ba11019a7a4566fdeea964bbbe4f6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6296485203"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/e680762651ab1a20701b81ec3a7bf7c0.webp"
"MediaSize" => 150089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-e680762651ab1a20701b81ec3a7bf7c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6296485264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29069490/538fa929f9060cc5a132419f979dcef1.webp"
"MediaSize" => 80757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29069490/thumbnail-538fa929f9060cc5a132419f979dcef1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785817"
"ResourceRecordKey" => "29069490"
"ModificationTimestamp" => "2025-11-05T15:49:19.3Z"
]
]
+"DaysOnMarket": 263
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29069490')"
+"ID": "935040"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 67816" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25047
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24990
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Macro Realty"
+"OfficeEmail": null
+"OfficePhone": "905-574-3038"
+"OfficeMlsId": "HBRLPMACRO"
+"ModificationTimestamp": "2026-02-06T22:31:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "67816"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#250-2247 Rymal Road East"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Stoney Creek"
+"OfficePostalCode": "L8J2V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1132083"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-574-8333"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439624"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "67816"
"SocialMediaUrlOrId" => "https://www.royallepagemacro.ca/"
"ModificationTimestamp" => "2026-02-06T16:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1064635"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('67816')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2147155" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25070
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29069490'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25358
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29069490' AND OpenHouseDate ge '2026-07-25'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29069490' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.89674798 43.32712753)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25427
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25421
+post_id: "1656575"
+post_author: 1
+"ListingKey": "30076777"
+"ListingId": "X13603448"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T12:10:24Z"
+"RFModificationTimestamp": "2026-07-26T12:11:39Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON CLOSE, Hamilton (Waterdown), Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8871256
1 => 43.3398225
]
+"Latitude": 43.3398225
+"Longitude": -79.8871256
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:08:45.605271+00:00"
+"Directions": "Cross Streets: Dundas & Burke. ** Directions: Dundas St E N on Burke W on Boulding Right on Milverton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958279"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 129.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:59:17Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T12:08:32Z"
+"Stories": "1.0"
+"StreetName": "Milverton"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1693769197"
"RoomType" => "Foyer"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.52
"ListingKey" => "30076777"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
1 => array:11 [
"RoomKey" => "1693769198"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 1.07
"ListingKey" => "30076777"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
2 => array:11 [
"RoomKey" => "1693769199"
"RoomType" => "Laundry room"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.74
"ListingKey" => "30076777"
"RoomLength" => 4.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
3 => array:11 [
"RoomKey" => "1693769200"
"RoomType" => "Bedroom 4"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.75
"ListingKey" => "30076777"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
4 => array:11 [
"RoomKey" => "1693769201"
"RoomType" => "Other"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 4.06
"ListingKey" => "30076777"
"RoomLength" => 7.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
5 => array:11 [
"RoomKey" => "1693769202"
"RoomType" => "Living room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.94
"ListingKey" => "30076777"
"RoomLength" => 4.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
6 => array:11 [
"RoomKey" => "1693769203"
"RoomType" => "Dining room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.03
"ListingKey" => "30076777"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
7 => array:11 [
"RoomKey" => "1693769204"
"RoomType" => "Kitchen"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.06
"ListingKey" => "30076777"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
8 => array:11 [
"RoomKey" => "1693769205"
"RoomType" => "Eating area"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.84
"ListingKey" => "30076777"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
9 => array:11 [
"RoomKey" => "1693769206"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.22
"ListingKey" => "30076777"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
10 => array:11 [
"RoomKey" => "1693769207"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "30076777"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
11 => array:11 [
"RoomKey" => "1693769208"
"RoomType" => "Bedroom 2"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30076777"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
12 => array:11 [
"RoomKey" => "1693769209"
"RoomType" => "Bedroom 3"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "30076777"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.79Z"
]
13 => array:11 [
"RoomKey" => "1693769210"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 3.98
"ListingKey" => "30076777"
"RoomLength" => 6.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.79Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076777/45-milverton-close-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": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-07-24T18:39:38.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249182"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30076777_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/d8df7092df14e7d09656e5add5e7cba6.webp"
"MediaSize" => 391821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-d8df7092df14e7d09656e5add5e7cba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:59:09.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30076777_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/0e344f3a67da67b4927de97d8bfc6823.webp"
"MediaSize" => 424211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-0e344f3a67da67b4927de97d8bfc6823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:59:17.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30076777_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/ccf43b7d2089d0e7608f34fcb523d3f8.webp"
"MediaSize" => 355387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-ccf43b7d2089d0e7608f34fcb523d3f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30076777_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/412a77aaf49d7cc49b3234539e613cb6.webp"
"MediaSize" => 169305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-412a77aaf49d7cc49b3234539e613cb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30076777_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/4e3b258a1796e8946af88e1d4fde77fa.webp"
"MediaSize" => 159703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-4e3b258a1796e8946af88e1d4fde77fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30076777_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/20b8347b30944e1912bb239e6e52f618.webp"
"MediaSize" => 209081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-20b8347b30944e1912bb239e6e52f618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30076777_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/28b891999d5b05c9895141aa20aaaeaf.webp"
"MediaSize" => 225102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-28b891999d5b05c9895141aa20aaaeaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30076777_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/7715d7abc5594ca2585b4dca5d14b1e5.webp"
"MediaSize" => 221942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-7715d7abc5594ca2585b4dca5d14b1e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30076777_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/076fa862b5189960845c13a146f73260.webp"
"MediaSize" => 197016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-076fa862b5189960845c13a146f73260.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30076777_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/2ed3cca10e629a27b6b8f139042a83e8.webp"
"MediaSize" => 199963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-2ed3cca10e629a27b6b8f139042a83e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30076777_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a38c27a3f239621c7e195c5cb773ce43.webp"
"MediaSize" => 183887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a38c27a3f239621c7e195c5cb773ce43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30076777_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/6f9c544da794162586324665bb4da015.webp"
"MediaSize" => 196164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-6f9c544da794162586324665bb4da015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30076777_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/e70eddd86428acedb22a8d9f224933d3.webp"
"MediaSize" => 192187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-e70eddd86428acedb22a8d9f224933d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30076777_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/16f512a7d6f6e1ac1666912f8ad35ec4.webp"
"MediaSize" => 188894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-16f512a7d6f6e1ac1666912f8ad35ec4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30076777_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/27bec663d72accbfcc285b7d874cbf0c.webp"
"MediaSize" => 185262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-27bec663d72accbfcc285b7d874cbf0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30076777_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a71ce5734c030c88fedd02d981ea497c.webp"
"MediaSize" => 188302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a71ce5734c030c88fedd02d981ea497c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30076777_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a77c4bf54f2a90b8a177408bc217093f.webp"
"MediaSize" => 180495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a77c4bf54f2a90b8a177408bc217093f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30076777_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/cd608c58ad05e956e791c85806573bde.webp"
"MediaSize" => 175511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-cd608c58ad05e956e791c85806573bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30076777_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/3052f08a2c22b23873427068289e8913.webp"
"MediaSize" => 140645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-3052f08a2c22b23873427068289e8913.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30076777_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/312df5ba2bc8f165649ef23b09d9d2d1.webp"
"MediaSize" => 134164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-312df5ba2bc8f165649ef23b09d9d2d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30076777_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/b1d068ca211821dea8a5b3e0c3cda5f4.webp"
"MediaSize" => 179488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-b1d068ca211821dea8a5b3e0c3cda5f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30076777_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/06daf6b498dda180ae53eb4fd03de389.webp"
"MediaSize" => 196503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-06daf6b498dda180ae53eb4fd03de389.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
22 => array:13 [
"Order" => 23
…12
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076777')"
+"ID": "1656575"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1656576"
+post_author: 1
+"ListingKey": "30076485"
+"ListingId": "40850027"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T20:15:17Z"
+"RFModificationTimestamp": "2026-07-25T20:18:49Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.18
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON Close, Waterdown, Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8875341
1 => 43.3401784
]
+"Latitude": 43.3401784
+"Longitude": -79.8875341
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"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-07-24T18:32:25.657182+00:00"
+"Directions": "Dundas St E, N on Burke W, on Boulding Right, on Milverton"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1528670"
+"ListOfficeKey": "268714"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:57Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T20:08:24Z"
+"Stories": "1.0"
+"StreetName": "MILVERTON"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30076485/45-milverton-close-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524684"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1218
+"OriginalEntryTimestamp": "2026-07-24T18:08:36.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140396"
+"ListOfficeNationalAssociationId": "1230749"
+"CoListAgentNationalAssociationId": "1063363"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076485')"
+"ID": "1656576"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1653706"
+post_author: 1
+"ListingKey": "30069107"
+"ListingId": "40850435"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T01:10:03Z"
+"RFModificationTimestamp": "2026-07-25T01:19:40Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2022.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0T3"
+"UnparsedAddress": "4 BOUSFIELD Court, Waterdown, Ontario L8B0T3"
+"Coordinates": array:2 [
0 => -79.9200053
1 => 43.3269474
]
+"Latitude": 43.3269474
+"Longitude": -79.9200053
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 4 Bousfield Court! Nestled on a cult de sac next to a pond. This beautifully updated 3-bedroom, 3-bath home offers luxury and privacy in one of Waterdown's most desirable neighbourhoods. The open-concept main floor is enhanced by rich hardwood flooring, custom lighting, and impressive coffered ceilings, a chef-inspired kitchen with granite countertops, gas stove and plenty of storage . Upstairs, the spacious primary suite offers a spa-like ensuite with heated honed marble floors, soaker tub and marble shower. Step outside to your professionally landscaped backyard complete with a pond, gazebo, and lush greenery. Additional highlights include an on-demand hot water system, 2nd floor laundry room with overflow drain, EV charger plug, and numerous updates throughout. Close to parks, schools, shopping, and commuter routes, this move-in-ready home truly has it all. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:57:19.869705+00:00"
+"Directions": "Parkside to Sadielou to Gundy to Bousfield"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917243"
+"ListOfficeKey": "264845"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T01:00:24Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T01:08:27Z"
+"Stories": "2.0"
+"StreetName": "BOUSFIELD"
+"StreetNumber": "4"
+"StreetSuffix": "Court"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7799"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30069107/4-bousfield-court-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2022
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-23T11:48:33.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1225588"
+"ListOfficeNationalAssociationId": "1225289"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069107')"
+"ID": "1653706"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1653711"
+post_author: 1
+"ListingKey": "30070675"
+"ListingId": "40850288"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:30:16Z"
+"RFModificationTimestamp": "2026-07-24T18:34:35Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3763.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL Crescent, Waterdown, Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.9054139
1 => 43.3203351
]
+"Latitude": 43.3203351
+"Longitude": -79.9054139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:42:14.280225+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:59Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:15:59Z"
+"Stories": "1.0"
+"StreetName": "WATERWHEEL"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9709.99"
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070675/54-waterwheel-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.0
+"AboveGradeFinishedArea": 2317
+"BelowGradeFinishedArea": 1446
+"OriginalEntryTimestamp": "2026-07-23T16:29:06.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070675')"
+"ID": "1653711"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1653718"
+post_author: 1
+"ListingKey": "30071102"
+"ListingId": "X13598280"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:05Z"
+"RFModificationTimestamp": "2026-07-24T18:51:37Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL CRESCENT, Hamilton (Waterdown), Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.905431
1 => 43.320341
]
+"Latitude": 43.320341
+"Longitude": -79.905431
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:19:28.284825+00:00"
+"Directions": "Dundas St E & Hollybush Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "82.3 x 105.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:28Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:28Z"
+"Stories": "1.0"
+"StreetName": "Waterwheel"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9707.99"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071102/54-waterwheel-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.3
+"OriginalEntryTimestamp": "2026-07-23T17:09:52.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071102')"
+"ID": "1653718"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25417
+post_id: "1649084"
+post_author: 1
+"ListingKey": "30066216"
+"ListingId": "X13593728"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:45:04Z"
+"RFModificationTimestamp": "2026-07-22T19:05:04Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907713
1 => 43.328158
]
+"Latitude": 43.328158
+"Longitude": -79.907713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:04:54.109562+00:00"
+"Directions": "Dundas St. N to Riley St. to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T17:37:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T17:37:22Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5374.8"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/24_braeheid_ave_hamilton_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/30066216/24-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-22T17:37:22.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066216')"
+"ID": "1649084"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1648557"
+post_author: 1
+"ListingKey": "30065389"
+"ListingId": "40850232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T16:15:08Z"
+"RFModificationTimestamp": "2026-07-22T16:36:51Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2392.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID Avenue, Waterdown, Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.9071668
1 => 43.3279388
]
+"Latitude": 43.3279388
+"Longitude": -79.9071668
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T16:36:38.024251+00:00"
+"Directions": "Dundas St N to Riley St to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198019"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T16:08:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T16:08:41Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5374.8"
+"VirtualTourURLUnbranded": "https://youriguide.com/24_braeheid_ave_hamilton_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065389/24-braeheid-avenue-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1642
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2026-07-22T16:08:41.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446394"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065389')"
+"ID": "1648557"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25425
+post_id: "1647044"
+post_author: 1
+"ListingKey": "30062342"
+"ListingId": "W13590216"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T20:45:05Z"
+"RFModificationTimestamp": "2026-07-21T23:03:03Z"
+"ListPrice": 2450000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Grindstone)"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "521 OLD YORK ROAD, Burlington (Grindstone), Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.893477
1 => 43.311038
]
+"Latitude": 43.311038
+"Longitude": -79.893477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client Remarks*Magnificent 3600 Sq Ft Detached on 3 Acres of Land* This One of A Kind Beautiful Custom Living Retreat Offers a Perfect Blend of Comfort, Luxury and Natural Beauty. The Property Seamlessly Combines the Best of Both, Town and Country Lifestyles. This Special Home, Rebuilt From Foundation Up, Is Like No Other In The Neighbourhood. Step Outside To Enjoy the Fresh, Coastal Vibes With Peaceful Atmosphere and You Will Never Leave. The Kitchen is Chef's Dream, Equipped With South American Granite, Massive Centre Island, 36" Stove With Pot Filler Faucet and Stainless Steel Appliances. Overlooking The Kitchen is the "Great Room" with 22 Ft Cathedral Ceilings, Open Concept, Sunny Dining Room, Fireplace, Hardwood Flooring Adding Warmth and Charm to the Living Area. Many Large Windows Bring The Outside In. The End of the Main Floor Seamlessly Flows Into Primary Bedroom With Walk-Through Closet And 4pc Ensuite, Another Bedroom, 2pc Bath And Laundry With Access to Garage. Two Bedrooms With Private Bathrooms are Located on the Upper Level But a 4th Bedroom Also Features a Balcony. The Spectacular Lower Level Boasts a Large Family Room, Fireplace, Office and 3-pc Baths. One of the Most Exciting Parts of this Home is a Private, Huge Backyard That Borders the Conservation Area. Nature Lovers Will Appreciate Its Enhanced Privacy Ensuring That Building Is Not Allowed Past the Tree Line and Preserving The Natural Beauty of the Area for Generations to Come. Step Outside on 2-Tiered Deck and Enjoy the Sunrise, Sunsets and All The Beauty The Scenic View Has to Offer! (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T23:02:46.694966+00:00"
+"Directions": "Plains Rd W. & Old York Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Hardwood"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406474"
+"ListOfficeKey": "50914"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Backs on greenbelt"
2 => "Open space"
3 => "Hilly"
]
+"LotSizeDimensions": "136.5 x 1017.5 FT ; 140.12Ftx970.84Ftx136.56Ftx1017.54Ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T20:38:07Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T20:38:07Z"
+"StreetName": "Old York"
+"StreetNumber": "521"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7455.64"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "View"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/459542"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Toronto"
+"CityRegion": "Grindstone"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30062342/521-old-york-road-burlington-grindstone-grindstone"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "RNA1,03-196 DNA"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 136.6
+"OriginalEntryTimestamp": "2026-07-21T20:38:07.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1070488"
+"ListOfficeNationalAssociationId": "1002617"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30062342')"
+"ID": "1647044"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25426
+post_id: "1642276"
+post_author: 1
+"ListingKey": "30056512"
+"ListingId": "X13584798"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T18:45:08Z"
+"RFModificationTimestamp": "2026-07-20T19:55:50Z"
+"ListPrice": 819900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "215 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.91234
1 => 43.33503
]
+"Latitude": 43.33503
+"Longitude": -79.91234
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this freehold townhouse located in a desirable, family-friendly neighbourhood in Waterdown. This well-maintained home features three bedrooms, including a spacious primary suite with a private ensuite and relaxing soaker tub. Two additional generously sized bedrooms provide plenty of space for family The functional kitchen has ample counter space, a separate eating area and a walkout to a deck. The unfinished lower level awaits your finishing touch, with endless possibilities for additional living space. Ideally situated within walking distance to the YMCA, Parkside Hills Park, Waterdown Memorial Park schools and just minutes from shopping restaurants, and all the amenities Waterdown has. This home provides the perfect blend of comfort, convenience, and lifestyle. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:55:38.619565+00:00"
+"Directions": "Cross Streets: Hamilton Street North. ** Directions: Hamilton Street North to Nisbet."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1989469"
+"ListOfficeKey": "284791"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.6 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T18:39:48Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T18:39:48Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "215"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5758"
+"VirtualTourURLUnbranded": "https://youriguide.com/215_nisbet_blvd_hamilton_on"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30056512/215-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.7
+"OriginalEntryTimestamp": "2026-07-20T18:39:48.19Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1273410"
+"ListOfficeNationalAssociationId": "1344890"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30056512')"
+"ID": "1642276"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 136
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]