array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30010590 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1608069"
+post_author: 1
+"ListingKey": "30010590"
+"ListingId": "X13542482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:50:10Z"
+"RFModificationTimestamp": "2026-07-09T15:08:04Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J4"
+"UnparsedAddress": "156 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L8B0J4"
+"Coordinates": array:2 [
0 => -79.902987
1 => 43.332965
]
+"Latitude": 43.332965
+"Longitude": -79.902987
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious 3-bedroom semi-detached home, ideally nestled in a family-friendly neighbourhood. This move-in-ready home features a functional layout with ample space and abundant natural light throughout. Windows create a warm and inviting atmosphere, while the spacious living areas and functionality of a split-level home provide room for everyday living and entertaining. This home features new engineered flooring, freshly painted walls, and space for a home office, gym, or kids playroom. A fully fenced backyard offers an outdoor escape with a very well-maintained patio area. Conveniently situated within walking distance to grocery stores, the YMCA, elementary and high school, parks, and transit. An excellent opportunity for families and first-time buyers alike, offering exceptional value in a desirable location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:07:57.964449+00:00"
+"Directions": "Cross Streets: Hamilton St & Parkside Dr. ** Directions: Hamilton St. to White Oak Dr to Chudleigh St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908399"
+"ListOfficeKey": "50914"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.1 x 108.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:41:25Z"
+"StreetName": "Chudleigh"
+"StreetNumber": "156"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5104.61"
+"VirtualTourURLUnbranded": "https://tours.boldimaging.com/Wrg_ODsOB?branded=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010590/156-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.1
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1221272"
+"ListOfficeNationalAssociationId": "1002617"
+"Media": array:46 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30010590_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/1577735e95732fef0aaf5e4d70a52e24.webp"
"MediaSize" => 406547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-1577735e95732fef0aaf5e4d70a52e24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30010590_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/0c92cb2446aa90c7e93171046c054e7f.webp"
"MediaSize" => 375222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-0c92cb2446aa90c7e93171046c054e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30010590_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/bb5fcbe795e00cc61d417ecd51ba99a4.webp"
"MediaSize" => 493822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-bb5fcbe795e00cc61d417ecd51ba99a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30010590_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/35db96847f7ecc47d5b273157f8ecd9a.webp"
"MediaSize" => 144306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-35db96847f7ecc47d5b273157f8ecd9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30010590_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/aa3b2e908fd2bf7730861f8b0ec9210e.webp"
"MediaSize" => 152554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-aa3b2e908fd2bf7730861f8b0ec9210e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30010590_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/725b9c7f92ac529264656c84f3170ddd.webp"
"MediaSize" => 113434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-725b9c7f92ac529264656c84f3170ddd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30010590_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/f25367530aceee182608342fc04d2066.webp"
"MediaSize" => 148075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-f25367530aceee182608342fc04d2066.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30010590_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/6396f5a06855f060468ba41115edaa6f.webp"
"MediaSize" => 140290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-6396f5a06855f060468ba41115edaa6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30010590_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/d1facf3bcaf20babf80d00a8efa03f41.webp"
"MediaSize" => 140149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-d1facf3bcaf20babf80d00a8efa03f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30010590_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/751146f4dd293bc2d0440f877806802a.webp"
"MediaSize" => 99462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-751146f4dd293bc2d0440f877806802a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30010590_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/828a9c16f43ae6f4ca4fea64f4a236e6.webp"
"MediaSize" => 139864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-828a9c16f43ae6f4ca4fea64f4a236e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30010590_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/b480625766cd964e20c6b61271d977d0.webp"
"MediaSize" => 137279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-b480625766cd964e20c6b61271d977d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30010590_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/4ce484b988d7ba214f26f255f3cac401.webp"
"MediaSize" => 139272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-4ce484b988d7ba214f26f255f3cac401.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30010590_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/5947822654faab8b2ef60f2cf7800bcd.webp"
"MediaSize" => 112039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-5947822654faab8b2ef60f2cf7800bcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30010590_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/ffe4a563a20a5932b035590531f402ab.webp"
"MediaSize" => 131773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-ffe4a563a20a5932b035590531f402ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30010590_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/f333b25303c3f5a5ab862c1285909d7a.webp"
"MediaSize" => 115613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-f333b25303c3f5a5ab862c1285909d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30010590_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/67a5f3e332d7f9cfcaaf4d04b280ae35.webp"
"MediaSize" => 126765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-67a5f3e332d7f9cfcaaf4d04b280ae35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30010590_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/f558ab63271d05285a01f3e67972010b.webp"
"MediaSize" => 203502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-f558ab63271d05285a01f3e67972010b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30010590_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/9604921f812aa1e1d5e5e1a01aa8bd80.webp"
"MediaSize" => 187308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-9604921f812aa1e1d5e5e1a01aa8bd80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30010590_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/1f9be130fc72f24287e1ea7502389394.webp"
"MediaSize" => 146286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-1f9be130fc72f24287e1ea7502389394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30010590_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/2c3bc59f112cb6b29c587e98fcf74d76.webp"
"MediaSize" => 145461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-2c3bc59f112cb6b29c587e98fcf74d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30010590_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/af2ec9efd7dbf52a0d4b887efb203d1d.webp"
"MediaSize" => 122474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-af2ec9efd7dbf52a0d4b887efb203d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30010590_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/47d39c3dd9d75b1a8f75f36f38885647.webp"
"MediaSize" => 125541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-47d39c3dd9d75b1a8f75f36f38885647.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30010590_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/3ae4d4ae3f3ce69540522bc691679c72.webp"
"MediaSize" => 95491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-3ae4d4ae3f3ce69540522bc691679c72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30010590_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/7293287e84a32a33b7e99032e9fe4e4d.webp"
"MediaSize" => 77925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-7293287e84a32a33b7e99032e9fe4e4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30010590_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/5db510f3947359923ce4ee5d9a907734.webp"
"MediaSize" => 100620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-5db510f3947359923ce4ee5d9a907734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30010590_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/f1ad1f4d1b342dba4108d8406385c6ef.webp"
"MediaSize" => 102722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-f1ad1f4d1b342dba4108d8406385c6ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30010590_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/9ee4ab841e89c939fad3b7a29c36f3f4.webp"
"MediaSize" => 152925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-9ee4ab841e89c939fad3b7a29c36f3f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30010590_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/80e5e59371e771c90217029ace240a95.webp"
"MediaSize" => 148949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-80e5e59371e771c90217029ace240a95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30010590_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/916b8833897220694b9f058075b09e1f.webp"
"MediaSize" => 207132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-916b8833897220694b9f058075b09e1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30010590_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/54b93a8a4ccc0588be3bf63c3b708441.webp"
"MediaSize" => 185882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-54b93a8a4ccc0588be3bf63c3b708441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30010590_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/215c91d3750dec7f1ec5d954089c1690.webp"
"MediaSize" => 87815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-215c91d3750dec7f1ec5d954089c1690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30010590_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/6996e3cfac821972a7d4b30a40652bab.webp"
"MediaSize" => 97928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-6996e3cfac821972a7d4b30a40652bab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30010590_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/b0dca4b1eeede5eba7e9c29bc9fec388.webp"
"MediaSize" => 143508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-b0dca4b1eeede5eba7e9c29bc9fec388.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30010590_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/830626f72de8b70cb68807ef50dc9e8c.webp"
"MediaSize" => 125444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-830626f72de8b70cb68807ef50dc9e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30010590_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/9a7d286a52b5ba628af545272ad02cb0.webp"
"MediaSize" => 495301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-9a7d286a52b5ba628af545272ad02cb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30010590_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/0f5afb6c27e0951fb26627ad1148459b.webp"
"MediaSize" => 341300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-0f5afb6c27e0951fb26627ad1148459b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30010590_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/291a0bf49dec18231c06e35397f350f4.webp"
"MediaSize" => 357145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-291a0bf49dec18231c06e35397f350f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30010590_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/c01f97bcbae647ddab79b46ecbeed983.webp"
"MediaSize" => 342883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-c01f97bcbae647ddab79b46ecbeed983.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30010590_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/8b3f8f299e0a0c137c56bb70aaabf2fb.webp"
"MediaSize" => 352355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-8b3f8f299e0a0c137c56bb70aaabf2fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30010590_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/a8775ccee770007fcbc3549765c097a5.webp"
"MediaSize" => 376386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-a8775ccee770007fcbc3549765c097a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30010590_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/94952cfb8f786b01b270b8c375f2537c.webp"
"MediaSize" => 453953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-94952cfb8f786b01b270b8c375f2537c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30010590_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/f5c85410b89f216d80763245880f6d11.webp"
"MediaSize" => 460369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-f5c85410b89f216d80763245880f6d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30010590_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/e829b0b47bee5c0e09f238115400cafd.webp"
"MediaSize" => 319186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-e829b0b47bee5c0e09f238115400cafd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30010590_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/8efa1846b9610cd3d7f5a392889fe9d4.webp"
"MediaSize" => 424051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-8efa1846b9610cd3d7f5a392889fe9d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30010590_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010590/82d3fed160e03f20654ff5a713db47b8.webp"
"MediaSize" => 440315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010590/thumbnail-82d3fed160e03f20654ff5a713db47b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542482"
"ResourceRecordKey" => "30010590"
"ModificationTimestamp" => "2026-07-09T14:41:25.82Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010590')"
+"ID": "1608069"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 50914" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24975
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24883
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE REALTY CENTRE"
+"OfficeEmail": null
+"OfficePhone": "905-279-8300"
+"OfficeMlsId": "95300"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "50914"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2150 HURONTARIO STREET"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5B1M8"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1002617"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-279-5344"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "369868"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "50914"
"SocialMediaUrlOrId" => "http://www.royallepagerealtycentre.ca/"
"ModificationTimestamp" => "2024-09-26T19:43:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1051104"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('50914')"
}
]
+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 1908399" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24923
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24956
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "1908399"
+"ModificationTimestamp": "2025-05-23T03:29:34Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "1908399"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('1908399')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30010590'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25285
+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 '30010590' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25301
+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 '30010590' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.902987 43.332965)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1610402"
+post_author: 1
+"ListingKey": "30013506"
+"ListingId": "40846843"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T21:35:27Z"
+"RFModificationTimestamp": "2026-07-09T21:49:39Z"
+"ListPrice": 2399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.274
+"LivingArea": 4887.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "81 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8849311
1 => 43.334616
]
+"Latitude": 43.334616
+"Longitude": -79.8849311
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Inspired by timeless European architecture, this distinguished residence pairs classic character with beautifully reimagined interiors, creating a home that feels both refined and effortlessly livable. Set on one of Waterdown's most coveted tree-lined streets, surrounded by mature homes and an established sense of community, it offers more than 4800 sq ft of finished living space. Step inside and your eye is immediately drawn to the elegant central staircase—an architectural focal point that anchors the home. From the kitchen to the dining area and into the inviting living rm, each space flows naturally into the next, creating the perfect setting for everything from quiet weekday mornings to lively holiday celebrations. A versatile main-floor office offers the flexibility to work from home, create a children's playroom, or design a cozy lounge tailored to your lifestyle. Then, almost seamlessly, the indoors give way to the outdoors. Open the doors from the sunroom and discover a backyard designed for entertaining on every scale. The saltwater pool becomes the centerpiece of summer, while the pergola creates an inviting space to dine, unwind, or gather with friends long after sunset. Framed by mature landscaping and exceptional privacy, it's a backyard that feels like a private retreat without ever leaving home. The second level is equally impressive, offering four spacious bdrms, the convenience of bdrm-level laundry, and a thoughtfully designed primary retreat complete with its own walk-in dressing rm and a beautifully appointed five-pc ensuite. Completing the home is a fully finished lower lvl, providing exceptional flexibility for family movie nights, a home gym, games room, or additional living space as your needs evolve. Timeless in its architecture, exceptional in its design, and perfectly positioned within one of Waterdown's most sought-after neighbourhoods, this is more than a home-it's where everyday living is elevated and lasting memories are made. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T21:49:32.478193+00:00"
+"Directions": "MOUNTAIN BROW RD TO FLANDERS DR"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043485"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Recreational"
]
+"LotSizeDimensions": "0.274"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T20:02:31Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T21:28:51Z"
+"Stories": "2.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "81"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "18628"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1679486477"
"RoomType" => "Bedroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 22'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
1 => array:11 [
"RoomKey" => "1679486478"
"RoomType" => "Bedroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
2 => array:11 [
"RoomKey" => "1679486479"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
3 => array:11 [
"RoomKey" => "1679486480"
"RoomType" => "Bedroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
4 => array:11 [
"RoomKey" => "1679486481"
"RoomType" => "Laundry room"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
5 => array:11 [
"RoomKey" => "1679486482"
"RoomType" => "Full bathroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
6 => array:11 [
"RoomKey" => "1679486483"
"RoomType" => "Other"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
7 => array:11 [
"RoomKey" => "1679486484"
"RoomType" => "Sitting room"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:51.99Z"
]
8 => array:11 [
"RoomKey" => "1679486485"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846843"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "19'9'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
9 => array:11 [
"RoomKey" => "1679486486"
"RoomType" => "3pc Bathroom"
"ListingId" => "40846843"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
10 => array:11 [
"RoomKey" => "1679486487"
"RoomType" => "Recreation room"
"ListingId" => "40846843"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "32'5'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
11 => array:11 [
"RoomKey" => "1679486488"
"RoomType" => "Gym"
"ListingId" => "40846843"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 22'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
12 => array:11 [
"RoomKey" => "1679486489"
"RoomType" => "Games room"
"ListingId" => "40846843"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
13 => array:11 [
"RoomKey" => "1679486490"
"RoomType" => "Mud room"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
14 => array:11 [
"RoomKey" => "1679486491"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
15 => array:11 [
"RoomKey" => "1679486492"
"RoomType" => "Living room"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "21'8'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
16 => array:11 [
"RoomKey" => "1679486493"
"RoomType" => "Sunroom"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
17 => array:11 [
"RoomKey" => "1679486494"
"RoomType" => "Kitchen"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
18 => array:11 [
"RoomKey" => "1679486495"
"RoomType" => "Dining room"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
19 => array:11 [
"RoomKey" => "1679486496"
"RoomType" => "Office"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
20 => array:11 [
"RoomKey" => "1679486497"
"RoomType" => "Sitting room"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52Z"
]
21 => array:11 [
"RoomKey" => "1679486498"
"RoomType" => "Other"
"ListingId" => "40846843"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30013506"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T21:28:52.01Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30013506/81-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 3845
+"BelowGradeFinishedArea": 1042
+"OriginalEntryTimestamp": "2026-07-09T19:59:21.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1319320"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30013506_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/ff85dd2881e19489d1e05d869655643c.webp"
"MediaSize" => 170219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-ff85dd2881e19489d1e05d869655643c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30013506_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/c4d0e9bc9924d54c01dfcaffb5c0ce5c.webp"
"MediaSize" => 93626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-c4d0e9bc9924d54c01dfcaffb5c0ce5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:31.53Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30013506_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/3be99bf99ea48921791381abcf8e5ab5.webp"
"MediaSize" => 136293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-3be99bf99ea48921791381abcf8e5ab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.49Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30013506_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/728c4af43e44e989cf49c35464ab97c5.webp"
"MediaSize" => 58327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-728c4af43e44e989cf49c35464ab97c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30013506_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/8e16ba82001cc6798bc7cd112aaaa2f0.webp"
"MediaSize" => 76448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-8e16ba82001cc6798bc7cd112aaaa2f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30013506_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/28105c1c7564c97c0c71f419d857bd62.webp"
"MediaSize" => 76981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-28105c1c7564c97c0c71f419d857bd62.webp"
"ResourceName" => "Property"
…6
]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013506')"
+"ID": "1610402"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1610403"
+post_author: 1
+"ListingKey": "30014021"
+"ListingId": "X13545804"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T21:15:10Z"
+"RFModificationTimestamp": "2026-07-09T21:36:56Z"
+"ListPrice": 2399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "81 FLANDERS DRIVE, Hamilton (Waterdown), Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.885026
1 => 43.334606
]
+"Latitude": 43.334606
+"Longitude": -79.885026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Inspired by timeless European architecture, this distinguished residence pairs classic character with beautifully reimagined interiors, creating a home that feels both refined and effortlessly livable. Set on one of Waterdown's most coveted tree-lined streets, surrounded by mature homes and an established sense of community, it offers more than 4,800 square feet of finished living space designed for every chapter of family life.Step inside and your eye is immediately drawn to the elegant central staircase-an architectural focal point that anchors the home while effortlessly connecting the open-concept main floor. From the kitchen to the dining area and into the inviting living room, each space flows naturally into the next, creating the perfect setting for everything from quiet weekday mornings to lively holiday celebrations. A versatile main-floor office offers the flexibility to work from home, create a children's playroom, or design a cozy lounge tailored to your lifestyle.Open the doors from the sunroom and discover a backyard designed for entertaining on every scale. The saltwater pool becomes the centerpiece of summer, while the pergola creates an inviting space to dine, unwind, or gather with friends long after sunset. Framed by mature landscaping and exceptional privacy, it's a backyard that feels like a private retreat without ever leaving home.The second level is equally impressive, offering four spacious bedrooms, the convenience of bedroom-level laundry, and a thoughtfully designed primary retreat complete with its own walk-in dressing room and a beautifully appointed five-piece ensuite, creating a peaceful escape at the end of each day.Completing the home is a fully finished lower level, providing exceptional flexibility for family movie nights, a home gym, games room, or additional living space as your needs evolve. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T21:36:49.788881+00:00"
+"Directions": "Cross Streets: Mountain Brow Rd. ** Directions: Mountain Brow to Flanders Drive."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234778"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Irregular lot size"
2 => "Conservation/green belt"
3 => "Gazebo"
]
+"LotSizeDimensions": "65.6 x 119.9 FT ; 117.18 FT X 74.46 FT X 59.16 FT X 119.89"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T21:09:35Z"
+"PhotosCount": 38
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T21:09:34Z"
+"Stories": "2.0"
+"StreetName": "Flanders"
+"StreetNumber": "81"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "18628"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30014021/81-flanders-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-07-09T21:09:34.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472623"
+"ListOfficeNationalAssociationId": "1417330"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30014021')"
+"ID": "1610403"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1609700"
+post_author: 1
+"ListingKey": "30012970"
+"ListingId": "40846786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T18:55:20Z"
+"RFModificationTimestamp": "2026-07-09T19:51:08Z"
+"ListPrice": 818000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "245 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8788273
1 => 43.3366865
]
+"Latitude": 43.3366865
+"Longitude": -79.8788273
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional built townhouse in one of Waterdown’s most sought-after communities! Offering 1,484 square feet of thoughtfully designed living space, this move-in ready home features three spacious bedrooms, three bathrooms and the convenience of upper-level laundry. The bright, open-concept layout is perfect for everyday living and entertaining. Far from builder basic, the owners invested thousands in premium upgrades, custom window coverings and high-end finishes that elevate every room. Immaculately maintained and truly turnkey, this home offers all the benefits of new construction without the wait. Enjoy a low-maintenance lifestyle just minutes from charming downtown Waterdown, with its boutique shops, restaurants, parks, schools, and everyday amenities. Simply unpack and enjoy everything this beautiful home has to offer! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "242.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:51:04.615921+00:00"
+"Directions": "HAMILTON ST N TO DUNDAS ST E TO BURKE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T18:48:29Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T18:48:29Z"
+"Stories": "3.0"
+"StreetName": "BURKE"
+"StreetNumber": "245"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4872"
+"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/30012970/245-burke-street-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1484
+"OriginalEntryTimestamp": "2026-07-09T18:48:29.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012970')"
+"ID": "1609700"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1608450"
+post_author: 1
+"ListingKey": "30011163"
+"ListingId": "40846705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:55:19Z"
+"RFModificationTimestamp": "2026-07-09T16:53:51Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 714.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 201, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940353
1 => 43.3303591
]
+"Latitude": 43.3303591
+"Longitude": -79.8940353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 201 at The View, a stylish south-facing 1-bedroom plus den overlooking a canopy of mature trees that gives the whole suite a calm, retreat-like feel. The versatile den is ideal for a home office, the dining area fits a proper table, and the generous living room features a wall-mounted electric fireplace and walkout to a private balcony. White quartz counters, stainless steel appliances, and an oversized peninsula anchor the kitchen, while the bedroom fits a full furniture set and the spa-inspired bathroom offers a tiled walk-in shower, floating vanity, linen storage, and laundry closet.Beyond the suite, this impeccably maintained 6-year-old building delivers: concierge and security staff, a gym, party room with prep kitchen, lounge, sixth-floor terraces with sweeping views, a pet spa, EV parking, and ample visitor parking.And then there's the location. Set on a quiet, tree-lined side street in sought-after Waterdown, you're a short walk to downtown shops, restaurants, and the Niagara Escarpment trails and lookouts, with quick access to highways, GO transit, and shopping centres. Peaceful, connected, and move-in ready. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "664.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T16:53:36.393879+00:00"
+"Directions": "South on Hamilton Street S from Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094790"
+"ListOfficeKey": "289709"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T15:48:20Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:48:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3851.69"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30011163/30-hamilton-street-s-unit-201-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 714
+"OriginalEntryTimestamp": "2026-07-09T15:48:20.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1367005"
+"ListOfficeNationalAssociationId": "1380244"
+"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('30011163')"
+"ID": "1608450"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+post_id: "1608068"
+post_author: 1
+"ListingKey": "30010584"
+"ListingId": "X13542358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:20:04Z"
+"RFModificationTimestamp": "2026-07-09T15:38:03Z"
+"ListPrice": 729999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W4"
+"UnparsedAddress": "124 MOSAIC DRIVE, Hamilton (Waterdown), Ontario L8B1W4"
+"Coordinates": array:2 [
0 => -79.919614
1 => 43.331667
]
+"Latitude": 43.331667
+"Longitude": -79.919614
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience modern living in this beautifully maintained, truly freehold townhouse (no POTL or road fees), ideally located on a quiet, family-friendly street with no homes directly in front - offering added privacy and open view. Showcasing an attractive stone and stucco exterior, this home offers a thoughtfully designed open-concept layout filled with natural light. Enjoy 9-ft ceilings & pot lights throughout the main floor, elegant hardwood flooring throughout the entire home - complete carpet-free, providing a seamless, stylish, and low-maintenance living environment. The upgraded kitchen is complete with quartz countertops, perfect for both everyday living and entertaining. Upstairs, the spacious primary bedroom offers a private 4-piece ensuite with a relaxing soaker tub. A convenient second-floor laundry room adds everyday comfort and functionality. Ideally situated close to high-rated schools, major highways, shopping centers, and the GO Station, this location provides both comfort and accessibility. A perfect opportunity to own a stylish, move-in ready home in a highly desirable neighborhood! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:08:37.491191+00:00"
+"Directions": "Cross Streets: Mosaic Dr & Parkside Dr. ** Directions: Mosaic Dr North of Parkside Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060502"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.7 x 86.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:11:01Z"
+"Stories": "2.0"
+"StreetName": "Mosaic"
+"StreetNumber": "124"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5160.78"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/458638/branded/59461"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010584/124-mosaic-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1335647"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010584')"
+"ID": "1608068"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1605124"
+post_author: 1
+"ListingKey": "30007554"
+"ListingId": "40846496"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:55:19Z"
+"RFModificationTimestamp": "2026-07-09T20:00:31Z"
+"ListPrice": 799900.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.9054918
1 => 43.3344338
]
+"Latitude": 43.3344338
+"Longitude": -79.9054918
+"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-07-08T20:54:52.232292+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-07-09T19:48:10Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:48:10Z"
+"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/30007554/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-07-08T20:29:11.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303132"
+"ListOfficeNationalAssociationId": "1137129"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30007554')"
+"ID": "1605124"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1599892"
+post_author: 1
+"ListingKey": "29998683"
+"ListingId": "X13531344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:50:06Z"
+"RFModificationTimestamp": "2026-07-07T18:01:22Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Welcome to this beautifully updated bungalow offering approximately 2,360 sq. ft. of finished living space in one of Waterdown's most sought-after neighbourhoods. Thoughtfully renovated with exceptional attention to detail, this spacious 3+2 bedroom, 3 bathroom home combines modern style, comfort, and functionality for today's family. The heart of the home is the stunning open-concept kitchen, featuring a massive centre island, stainless steel appliances, a 5-burner gas range, pot lights, and seamless flow into the main living and dining areas! Offers opportunity for perfect entertaining and everyday living. Generously sized rooms throughout provide plenty of space for the whole family, while updated railings, renovated closet spaces, and numerous interior improvements add both style and practicality. The fully finished lower level offers incredible versatility, complete with two additional bedrooms and a relaxing infrared 4-person sauna, creating the perfect retreat after a long day. Step outside to enjoy the extra-large private backyard, featuring TWO beautiful gazebos, newer fencing, and ample space for outdoor gatherings, play, and relaxation. Extended outdoor patio with a fire pit brings everything together. Additional updates include a recently replaced roof and updated appliances, providing peace of mind for years to come. With parking for four vehicles on the driveway and one in the attached garage and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this is an exceptional opportunity to own a move-in-ready family home in the heart of Waterdown. VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:26:16.161594+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:42:20Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998683/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-07-07T14:42:20.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998683')"
+"ID": "1599892"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1599648"
+post_author: 1
+"ListingKey": "29999791"
+"ListingId": "X13532616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:50:06Z"
+"RFModificationTimestamp": "2026-07-07T17:08:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "57 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8947788
1 => 43.3345316
]
+"Latitude": 43.3345316
+"Longitude": -79.8947788
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 57 Main Street! A charming bungalow set on an impressive 67' x 164' lot in the heart of Waterdown. Thoughtfully updated while preserving its original character, this inviting 2-bedroom home seamlessly blends modern updates with timeless charm. Inside you'll find soaring ceilings, original hardwood floors, and beautiful architectural details. The updated kitchen features quartz countertops, stainless steel appliances, and plenty of workspace. The spacious bathroom includes the convenience of in-suite laundry. Outside you will step into your own private backyard retreat complete with a newly renovated deck that overlooks a saltwater pool and an expansive tree-lined yard offering exceptional privacy and space to relax or entertain. The location is second to none. Nestled in Waterdown's sought-after downtown core, you're just steps from local boutiques, restaurants, cafés, parks, and year-round community events including the beloved Santa Claus Parade. This is a rare opportunity to own a beautifully updated home on an oversized lot in one of Waterdown's most desirable neighborhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:08:24.916673+00:00"
+"Directions": "Cross Streets: Main St N and Dundas St E. ** Directions: Dundas St E to Main St N."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252185"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "66 x 164.4 FT"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:40:48Z"
+"PhotosCount": 21
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:40:48Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5843.26"
+"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"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999791/57-main-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-07-07T16:40:48.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1491120"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999791')"
+"ID": "1599648"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1600801"
+post_author: 1
+"ListingKey": "29999554"
+"ListingId": "X13532526"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:40:15Z"
+"RFModificationTimestamp": "2026-07-07T17:06:35Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "1A WESTVIEW CRESCENT, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.906152
1 => 43.340513
]
+"Latitude": 43.340513
+"Longitude": -79.906152
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rare Opportunity to Build Your Dream Home in One of East Waterdown's Most Established Neighbourhoods! This newly created 80' x 103' premium building lot is recently severed from an original estate property, offering the perfect canvas for a custom home tailored to your lifestyle. Nestled on a quiet, tree-lined street just steps to parks, top-rated schools, shopping, restaurants, trails and everyday conveniences, you'll enjoy the charm and character of a mature neighbourhood with the freedom to build new. The generous 80-foot frontage offers exceptional flexibility for a stunning custom residence with spacious outdoor living or expansive landscaping. Bring your own builder and create the home you've always envisioned in one of Waterdown's most sought-after, family-friendly communities with convenient access to Burlington, minutes to Aldershot GO Transit and major highways. Rarely do opportunities like this become available (id:59439)"
+"CreationDate": "2026-07-07T17:06:31.747912+00:00"
+"Directions": "Cross Streets: Centre Road. ** Directions: Centre Road to Northlawn Avenue to Westview Crescent."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145705"
+"ListOfficeKey": "289659"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Partially cleared"
2 => "Conservation/green belt"
]
+"LotSizeDimensions": "80 x 103 FT"
+"PhotosChangeTimestamp": "2026-07-07T16:30:40Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:30:40Z"
+"StreetName": "Westview"
+"StreetNumber": "1A"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7500"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/sites/1-westview-crescent-hamilton-on-l8b-0e4-26396027/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29999554/1a-westview-crescent-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "R1-14"
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-07-07T16:30:40.34Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1397049"
+"ListOfficeNationalAssociationId": "1379904"
+"Media": array:13 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999554')"
+"ID": "1600801"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 141
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]