array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29918995 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: "1541136"
+post_author: 1
+"ListingKey": "29918995"
+"ListingId": "X13458554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T12:20:19Z"
+"RFModificationTimestamp": "2026-07-06T14:02:15Z"
+"ListPrice": 643000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "219 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all down-sizers, right-sizers and anyone looking for a bungalow-sized condo without the upkeep of a house! This sun-filled, end-unit suite in the heart of Waterdown offers 1,320 square feet of one-level living, anchored by a spacious open-concept living and dining area that gives you plenty of room to spread out. Step inside and the ten-foot ceilings paired with oversized south-west facing windows fill the entire open-concept space with natural light. A cozy gas fireplace anchors the living and dining area. Classic wainscoting throughout gives the whole unit a polished, finished look without you having to lift a finger. The kitchen pairs granite countertops with stainless steel appliances, ready for everything from a quick weeknight dinner to hosting friends. Both bedrooms offer comfortable, private space. Semi-ensuite four-piece main bathroom, and a separate guest powder room means visitors have their own space too. In-suite pantry and laundry makes life a little easier. Your own southern exposure open balcony is the perfect spot for a quiet morning coffee. This unit truly sets itself apart with two parking spaces, one underground #33 and one at main level #20, plus your own exclusive locker on the same floor as your suite, no trekking up or down for storage. Life in this boutique, low-rise community comes with real perks too. The building offers a recreation room, party and meeting room, visitor parking and a barbecue-friendly policy, and pets are welcome with some restrictions. Your maintenance fee covers water, building insurance, parking and common elements. Step outside and you are just steps from restaurants, groceries, parks, the library, transit and everything Waterdown's charming downtown has to offer. This is bungalow-style living with the parking, storage and location to match. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "841"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:41:58.635595+00:00"
+"Directions": "Cross Streets: HAMILTON ST N. ** Directions: PARKSIDE DR TO HAMILTON ST N TO DUNSAD ST E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Balcony"
2 => "Paved yard"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-24T18:55:51Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T12:13:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4511"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1676295880"
"RoomType" => "Kitchen"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 2.59
"ListingKey" => "29918995"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.88Z"
]
1 => array:11 [
"RoomKey" => "1676295881"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 4.34
"ListingKey" => "29918995"
"RoomLength" => 4.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
2 => array:11 [
"RoomKey" => "1676295882"
"RoomType" => "Bathroom"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 1.73
"ListingKey" => "29918995"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
3 => array:11 [
"RoomKey" => "1676295883"
"RoomType" => "Bathroom"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 1.8
"ListingKey" => "29918995"
"RoomLength" => 1.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
4 => array:11 [
"RoomKey" => "1676295884"
"RoomType" => "Bedroom"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29918995"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
5 => array:11 [
"RoomKey" => "1676295885"
"RoomType" => "Laundry room"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29918995"
"RoomLength" => 1.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
6 => array:11 [
"RoomKey" => "1676295886"
"RoomType" => "Living room"
"ListingId" => "X13458554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.59
"ListingKey" => "29918995"
"RoomLength" => 6.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T12:13:37.89Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918995/219-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T21:55:05.79Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918995_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/e444c027c1ffbc15d66b113370fb5856.webp"
"MediaSize" => 327072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-e444c027c1ffbc15d66b113370fb5856.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:42.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918995_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/80a4fbb0c4b9a9bf0800678bdc3e82c1.webp"
"MediaSize" => 380510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-80a4fbb0c4b9a9bf0800678bdc3e82c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:43.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918995_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/598b770fd593890ca21826d2864b9c0e.webp"
"MediaSize" => 373316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-598b770fd593890ca21826d2864b9c0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:45.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918995_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/45ecaa888e57bb6dd58a1f79a2daa952.webp"
"MediaSize" => 128936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-45ecaa888e57bb6dd58a1f79a2daa952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:53.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918995_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/433c6835ec4a0e870929e2a8276dc816.webp"
"MediaSize" => 146081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-433c6835ec4a0e870929e2a8276dc816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:45.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918995_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/d8bd51077f972561ef35dbf1590b2d8d.webp"
"MediaSize" => 110876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-d8bd51077f972561ef35dbf1590b2d8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:53.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918995_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/812578dd92e9e8db535efe8574a23cc4.webp"
"MediaSize" => 122056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-812578dd92e9e8db535efe8574a23cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:44.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918995_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/fea43d37ef7d21911724c8dd863f6a1c.webp"
"MediaSize" => 183850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-fea43d37ef7d21911724c8dd863f6a1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:52.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918995_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/e7120f4dba674b070249247e018cf081.webp"
"MediaSize" => 176662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-e7120f4dba674b070249247e018cf081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:48.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918995_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/a03d562d92bb8b8eaccaf2ee5d8a4f33.webp"
"MediaSize" => 197824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-a03d562d92bb8b8eaccaf2ee5d8a4f33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:07:13.19Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918995_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/252bdf515d2a3ab07c01546979bd46e7.webp"
"MediaSize" => 173051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-252bdf515d2a3ab07c01546979bd46e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:43.12Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918995_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/7c8f3566815e3934459d716fcc92e4ca.webp"
"MediaSize" => 212089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-7c8f3566815e3934459d716fcc92e4ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:07:14.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918995_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/da4f1473aee2d9bc932558a870d899c6.webp"
"MediaSize" => 174962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-da4f1473aee2d9bc932558a870d899c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:43.16Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29918995_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/c7fcd53360e71d9bf2d2b1e6deb7c04e.webp"
"MediaSize" => 193820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-c7fcd53360e71d9bf2d2b1e6deb7c04e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:39.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29918995_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/7bd237f438a2052c2ad9e0c7b85e13f8.webp"
"MediaSize" => 205294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-7bd237f438a2052c2ad9e0c7b85e13f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:49.14Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29918995_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/f1bd52c124b9204fcff5ac0263e48f65.webp"
"MediaSize" => 164170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-f1bd52c124b9204fcff5ac0263e48f65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:43.13Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29918995_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/d70eea320a80a7ea0774d80ea4e55b0c.webp"
"MediaSize" => 143352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-d70eea320a80a7ea0774d80ea4e55b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:41.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29918995_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/0bd5600b97069f30f1019f2b9cbdedaa.webp"
"MediaSize" => 120330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-0bd5600b97069f30f1019f2b9cbdedaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:49.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29918995_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/f04725671befd0b7e9561d901a194f4d.webp"
"MediaSize" => 168216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-f04725671befd0b7e9561d901a194f4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:44.36Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29918995_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/85b629fe267626aaa6fca064bd796423.webp"
"MediaSize" => 181592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-85b629fe267626aaa6fca064bd796423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:07:14.41Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29918995_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/ed8ec0a07d53d28d93094f0a8d81e157.webp"
"MediaSize" => 192580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-ed8ec0a07d53d28d93094f0a8d81e157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:44.41Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29918995_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/ec52bb61db7eedf50a336443a6c99f06.webp"
"MediaSize" => 121284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-ec52bb61db7eedf50a336443a6c99f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:52.46Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29918995_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/57cbdd636c8ead08f0738e54d775ceec.webp"
"MediaSize" => 205245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-57cbdd636c8ead08f0738e54d775ceec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:43.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29918995_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/5b0c0b405e63c20864879a55ad6e0d07.webp"
"MediaSize" => 164352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-5b0c0b405e63c20864879a55ad6e0d07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:07:14.41Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29918995_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/4849d9b6fcd406c9a7ef60857507abb2.webp"
"MediaSize" => 419125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-4849d9b6fcd406c9a7ef60857507abb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:44.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29918995_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/84288c9bb958f462c208952e4491ffa9.webp"
"MediaSize" => 414585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-84288c9bb958f462c208952e4491ffa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:52.18Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29918995_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/b46a793a124eee377528a9977e84aee8.webp"
"MediaSize" => 351205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-b46a793a124eee377528a9977e84aee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:44.16Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29918995_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918995/77717362570a63e2f5f4dd68a1948539.webp"
"MediaSize" => 409486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918995/thumbnail-77717362570a63e2f5f4dd68a1948539.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458554"
"ResourceRecordKey" => "29918995"
"ModificationTimestamp" => "2026-06-24T18:06:46.08Z"
]
]
+"DaysOnMarket": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918995')"
+"ID": "1541136"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293273" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24939
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24847
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-689-9223"
+"OfficeMlsId": "184019"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293273"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "493 DUNDAS ST E UNIT 1B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERDOWN"
+"OfficePostalCode": "L0R2H1"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1424812"
+"OriginalEntryTimestamp": "2022-09-14T17:33:00Z"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1243509"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293273')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1979013" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24920
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.28 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29918995'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29918995' AND OpenHouseDate ge '2026-07-09'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25246
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29918995' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.896393 43.330174)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25299
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+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"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.6Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30013506_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/df59dc5f7af186bf73d3a070d5a9e39c.webp"
"MediaSize" => 69210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-df59dc5f7af186bf73d3a070d5a9e39c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30013506_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/6137d3b796a7fd80e428e18827acfb9f.webp"
"MediaSize" => 64813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-6137d3b796a7fd80e428e18827acfb9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30013506_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/80a1099ea250d45af8d9ec533a5c656c.webp"
"MediaSize" => 74503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-80a1099ea250d45af8d9ec533a5c656c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.49Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30013506_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/94341af35f53739b90703bbc144c5482.webp"
"MediaSize" => 76181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-94341af35f53739b90703bbc144c5482.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.48Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30013506_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/9cfefc3cbb54ff85fcd24a4c45904bb8.webp"
"MediaSize" => 80084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-9cfefc3cbb54ff85fcd24a4c45904bb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30013506_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/a74ecf88fa5c8c40aa589baddd1c2eca.webp"
"MediaSize" => 67679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-a74ecf88fa5c8c40aa589baddd1c2eca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.59Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30013506_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/0f771e8b5cb55617007ba8ef1ca7995e.webp"
"MediaSize" => 59522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-0f771e8b5cb55617007ba8ef1ca7995e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:29.52Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30013506_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/44c4453543f49080413cbcc9be0fb247.webp"
"MediaSize" => 66717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-44c4453543f49080413cbcc9be0fb247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:28.48Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30013506_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/50848b5fc673d4f596a241b061de2d4a.webp"
"MediaSize" => 75055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-50848b5fc673d4f596a241b061de2d4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:29.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30013506_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/e121f9bc2e1d03e9a7e63049378c495b.webp"
"MediaSize" => 72078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-e121f9bc2e1d03e9a7e63049378c495b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:29.56Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30013506_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/925a28e369a0d803ac125b1c3f7c3e7a.webp"
"MediaSize" => 81575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013506/thumbnail-925a28e369a0d803ac125b1c3f7c3e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846843"
"ResourceRecordKey" => "30013506"
"ModificationTimestamp" => "2026-07-09T20:02:29.57Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30013506_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013506/23dbd45248cdf678d2ef1cb0de752fa9.webp"
"MediaSize" => 92735
"MediaType" => "webp"
…8
]
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 {#25295
+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 {#25292
+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 {#25296
+post_id: "1609624"
+post_author: 1
+"ListingKey": "30013126"
+"ListingId": "X13544800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:20:06Z"
+"RFModificationTimestamp": "2026-07-09T19:42:46Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "110 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker-an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "724.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:42:44.122416+00:00"
+"Directions": "Dundas St E and Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994256"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Level lot"
1 => "Elevator"
2 => "Balcony"
3 => "Level"
4 => "Carpet Free"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-09T19:10:55Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:10:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4682.53"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013126/110-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T19:10:55.81Z"
+"ListAgentNationalAssociationId": "1277414"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013126')"
+"ID": "1609624"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1609422"
+post_author: 1
+"ListingKey": "30012116"
+"ListingId": "40846676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T17:35:25Z"
+"RFModificationTimestamp": "2026-07-09T19:24:44Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1074.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 110, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.8802837
1 => 43.3432106
]
+"Latitude": 43.3432106
+"Longitude": -79.8802837
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker—an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "724.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-09T19:24:36.554161+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL TO RIVERWALK DRIVE. THE ENTRANCE TO 450 DUNDAS IS OFF RIVERWALK WHICH IS SOUTH OF DUNDAS ST E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596388"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T17:29:15Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T17:29:15Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4682.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012116/450-dundas-street-e-unit-110-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1074
+"OriginalEntryTimestamp": "2026-07-09T17:29:15.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1096193"
+"ListOfficeNationalAssociationId": "1333115"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012116')"
+"ID": "1609422"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010590')"
+"ID": "1608069"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1608080"
+post_author: 1
+"ListingKey": "30010583"
+"ListingId": "X13542342"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:50:09Z"
+"RFModificationTimestamp": "2026-07-09T15:07:30Z"
+"ListPrice": 710000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "2 - 279 SKINNER ROAD N, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.877083
1 => 43.340355
]
+"Latitude": 43.340355
+"Longitude": -79.877083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover stylish, low-maintenance living in this beautifully maintained, sun-filled condo townhome nestled in the highly desirable East Waterdown community. Boasting soaring 9-foot ceilings and a unique open-concept design, this home offers an inviting blend of space, natural light, and everyday functionality. The spacious eat-in kitchen is designed for both entertaining and daily living, featuring stainless steel appliances, abundant cabinetry, generous prep space, and a walk-out to a private balcony-perfect for morning coffee, evening sunsets, or summer BBQs. Upstairs, you'll find two generously sized bedrooms, each with its own private ensuite, including a spacious primary retreat with a 4-piece bath and a second bedroom with a 3-piece ensuite-an ideal layout for families, guests, or professionals seeking added privacy. Enjoy the convenience of an attached garage with inside entry, plus parking for up to three vehicles-a rare and valuable feature. Low condo fees make ownership even more affordable while allowing you to enjoy a carefree, low-maintenance lifestyle. Located in one of Waterdown's most sought-after neighbourhoods, you're just minutes from top-rated schools, scenic parks and trails, shopping, restaurants, the GO Station, major highways, downtown Waterdown, and Burlington, offering the perfect balance of small-town charm and effortless connectivity. Whether you're a first-time buyer, downsizer, busy professional, or savvy investor, this move-in-ready home delivers exceptional value, comfort, and lifestyle in an outstanding location. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"AssociationFee": "194.39"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-09T15:07:27.431020+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Skinner. ** Directions: South of Dundas at Mallard & Skinner Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1660663"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:41:25Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "Skinner"
+"StreetNumber": "279"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4497.87"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/279-skinner-road-hamilton-l8b-1w5/nb/"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010583/2-279-skinner-road-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WENTWORTH STANDARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.22Z"
+"ListAgentNationalAssociationId": "1167703"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010583')"
+"ID": "1608080"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 176
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]