array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29956107 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1567703"
+post_author: 1
+"ListingKey": "29956107"
+"ListingId": "X13491700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T00:50:21Z"
+"RFModificationTimestamp": "2026-06-26T05:00:06Z"
+"ListPrice": 510000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "502 - 470 DUNDAS STREET, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 470 Dundas St E, Unit 502 - a bright corner two-bedroom condo with rare side-by-side parking and unobstructed sunset views. This modern suite features 10-foot ceilings,floor-to-ceiling windows, vinyl flooring, custom roller blinds, and an oversized balcony perfect for relaxing or entertaining. Enjoy the added convenience of two parking spots near the elevator and a same-floor storage locker. Building amenities include fitness centres, party rooms, rooftop terraces with BBQs, on-site management, and a superintendent. Conveniently located near highways, GO Transit, parks, trails, and everyday amenities. Ideally situated with quick access to major highways, the GO Train, nearby parks, trails, shopping, and everyday conveniences, this condo is a fantastic option for commuters, downsizers, and anyone looking for modern condo living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Barbeque"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"AssociationFee": "634.77"
+"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:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-26T04:59:56.667005+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203994"
+"ListOfficeKey": "282937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-26T00:45:10Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T00:45:10Z"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2020"
+"View": "City view"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1668197097"
"RoomType" => "Bedroom"
"ListingId" => "X13491700"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29956107"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.08Z"
]
1 => array:11 [
"RoomKey" => "1668197098"
"RoomType" => "Bedroom 2"
"ListingId" => "X13491700"
"RoomLevel" => "Main level"
"RoomWidth" => 2.8
"ListingKey" => "29956107"
"RoomLength" => 3.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.08Z"
]
2 => array:11 [
"RoomKey" => "1668197099"
"RoomType" => "Kitchen"
"ListingId" => "X13491700"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29956107"
"RoomLength" => 2.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.08Z"
]
3 => array:11 [
"RoomKey" => "1668197100"
"RoomType" => "Great room"
"ListingId" => "X13491700"
"RoomLevel" => "Main level"
"RoomWidth" => 4.72
"ListingKey" => "29956107"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T00:45:10.08Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956107/502-470-dundas-street-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 => "Recreation Centre"
3 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-26T00:45:10.04Z"
+"ListAgentNationalAssociationId": "1452632"
+"ListOfficeNationalAssociationId": "1323558"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29956107_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/1b0ad7a144d6a7b002379e169680de98.webp"
"MediaSize" => 231096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-1b0ad7a144d6a7b002379e169680de98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29956107_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/ef2a2baf24b40eb1c9e630a7e6ab4867.webp"
"MediaSize" => 243851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-ef2a2baf24b40eb1c9e630a7e6ab4867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29956107_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/e6f8393406035292a5a6e36b326f6483.webp"
"MediaSize" => 257306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-e6f8393406035292a5a6e36b326f6483.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29956107_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/13b64c6c49afede986d8e841eebf2403.webp"
"MediaSize" => 162155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-13b64c6c49afede986d8e841eebf2403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29956107_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/29ef2213d6d3dfb25c7d2734275b522e.webp"
"MediaSize" => 206613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-29ef2213d6d3dfb25c7d2734275b522e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29956107_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/85340c4d353007e6d34217217728f993.webp"
"MediaSize" => 218990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-85340c4d353007e6d34217217728f993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29956107_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/73c95d666703b2b3e67b21e08602b50c.webp"
"MediaSize" => 120731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-73c95d666703b2b3e67b21e08602b50c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29956107_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/db8e4d093518e9cb000e012a28ff7612.webp"
"MediaSize" => 64423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-db8e4d093518e9cb000e012a28ff7612.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29956107_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/7632be4b3c075211042f57e33b5a0f9b.webp"
"MediaSize" => 66940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-7632be4b3c075211042f57e33b5a0f9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29956107_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/e190011e9c2f9082d36c74e0fdd06f8f.webp"
"MediaSize" => 75983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-e190011e9c2f9082d36c74e0fdd06f8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29956107_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/32fc15f0df01ecce42bc315b136648dd.webp"
"MediaSize" => 178421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-32fc15f0df01ecce42bc315b136648dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29956107_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/6a8d19e60658fc1b34ba74da0ee0985e.webp"
"MediaSize" => 143554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-6a8d19e60658fc1b34ba74da0ee0985e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29956107_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/bd61a7d5766025c6bd8b2974c51955f7.webp"
"MediaSize" => 173262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-bd61a7d5766025c6bd8b2974c51955f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29956107_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/ff33bc36e5a6f4f8e126f193261cc5c2.webp"
"MediaSize" => 130959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-ff33bc36e5a6f4f8e126f193261cc5c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29956107_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/b5d8882ea892bf967def5df9b677de42.webp"
"MediaSize" => 125529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-b5d8882ea892bf967def5df9b677de42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29956107_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/0521329feaf03f3f47dcedcbb3ed9eaa.webp"
"MediaSize" => 119961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-0521329feaf03f3f47dcedcbb3ed9eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29956107_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/574d8f423ba816a48784895c2c95cbc6.webp"
"MediaSize" => 147682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-574d8f423ba816a48784895c2c95cbc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29956107_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/a65a316e239395f0829191fe42f9f7cc.webp"
"MediaSize" => 87864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-a65a316e239395f0829191fe42f9f7cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29956107_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/b95ff00984eefaa712f526f24bf31f32.webp"
"MediaSize" => 104330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-b95ff00984eefaa712f526f24bf31f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29956107_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/3cf7ac81152cc75fd5064861b8662d71.webp"
"MediaSize" => 127715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-3cf7ac81152cc75fd5064861b8662d71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29956107_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/9ee7627609017e65a7ca4791f81b6030.webp"
"MediaSize" => 99409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-9ee7627609017e65a7ca4791f81b6030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29956107_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/442654fbc4f4ae05b686b79745a2af37.webp"
"MediaSize" => 109079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-442654fbc4f4ae05b686b79745a2af37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29956107_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/ce54a99d39732dc1170b4bba5f770e1a.webp"
"MediaSize" => 82129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-ce54a99d39732dc1170b4bba5f770e1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29956107_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/00fa5b5dda42161a3e7001aa66ba4e56.webp"
"MediaSize" => 87576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-00fa5b5dda42161a3e7001aa66ba4e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29956107_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/21bf1d440164f436d28cde6894571c93.webp"
"MediaSize" => 200878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-21bf1d440164f436d28cde6894571c93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29956107_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/f7bc4ad6c228c934567b9b440bf486b4.webp"
"MediaSize" => 207141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-f7bc4ad6c228c934567b9b440bf486b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29956107_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/f00400f3db0ed229cef7fab3fa37ed1a.webp"
"MediaSize" => 360225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-f00400f3db0ed229cef7fab3fa37ed1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29956107_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/e593296fcb3fa17d63b58c3d82eb8d99.webp"
"MediaSize" => 156057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-e593296fcb3fa17d63b58c3d82eb8d99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29956107_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/cf4c8aa43d4a3cf2468832aabb13111b.webp"
"MediaSize" => 180899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-cf4c8aa43d4a3cf2468832aabb13111b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29956107_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/d26da530fb3f2d4f2f3854ca041761f2.webp"
"MediaSize" => 205641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-d26da530fb3f2d4f2f3854ca041761f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29956107_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/e0aa88632e085ff8f6482777e1032c93.webp"
"MediaSize" => 161980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-e0aa88632e085ff8f6482777e1032c93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29956107_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29956107/23a73e6010a842e7c4f6d1788b80d997.webp"
"MediaSize" => 179144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29956107/thumbnail-23a73e6010a842e7c4f6d1788b80d997.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13491700"
"ResourceRecordKey" => "29956107"
"ModificationTimestamp" => "2026-06-26T00:45:10.04Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956107')"
+"ID": "1567703"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 282937" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2203994" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24817
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29956107'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25200
+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 '29956107'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29956107' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1565694"
+post_author: 1
+"ListingKey": "29954208"
+"ListingId": "40843154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:40:04Z"
+"RFModificationTimestamp": "2026-06-26T01:25:03Z"
+"ListPrice": 969990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "26 GRANITE RIDGE Trail, Waterdown, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.8786022
1 => 43.3372225
]
+"Latitude": 43.3372225
+"Longitude": -79.8786022
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2,400 sq. ft. home offering 4 bedrooms and 3.5 bathrooms in one of Waterdown's most sought-after family neighbourhoods. Built in 2021 and well cared for by the original owners, this home is beautifully upgraded throughout. The open-concept main floor features vinyl plank flooring, hardwood stairs, California shutters, a private office, and a bright living room with a gas fireplace. The kitchen features custom Barzotti cabinetry, quartz countertops, a large island, and a subway tile backsplash. The second level offers four spacious bedrooms, including two with private ensuites. The primary suite features his-and-hers walk-in closets, a double vanity, and a frameless glass shower. Additional features include upper-level laundry, a gas BBQ line, and a basement bathroom rough-in for future potential. Ideally located close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. Call to book your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:24:56.281861+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:31:01Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:31:01Z"
+"Stories": "2.0"
+"StreetName": "GRANITE RIDGE"
+"StreetNumber": "26"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7254.63"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1667961685"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.37Z"
]
1 => array:11 [
"RoomKey" => "1667961686"
"RoomType" => "Bedroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.37Z"
]
2 => array:11 [
"RoomKey" => "1667961687"
"RoomType" => "Bedroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.38Z"
]
3 => array:11 [
"RoomKey" => "1667961688"
"RoomType" => "Bedroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.38Z"
]
4 => array:11 [
"RoomKey" => "1667961689"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.38Z"
]
5 => array:11 [
"RoomKey" => "1667961690"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.39Z"
]
6 => array:11 [
"RoomKey" => "1667961691"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843154"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.39Z"
]
7 => array:11 [
"RoomKey" => "1667961692"
"RoomType" => "Office"
"ListingId" => "40843154"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.4Z"
]
8 => array:11 [
"RoomKey" => "1667961693"
"RoomType" => "Living room"
"ListingId" => "40843154"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 23'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.4Z"
]
9 => array:11 [
"RoomKey" => "1667961694"
"RoomType" => "Kitchen"
"ListingId" => "40843154"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.41Z"
]
10 => array:11 [
"RoomKey" => "1667961695"
"RoomType" => "Dining room"
"ListingId" => "40843154"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.41Z"
]
11 => array:11 [
"RoomKey" => "1667961696"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843154"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954208"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:31:01.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954208/26-granite-ridge-trail-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2400
+"OriginalEntryTimestamp": "2026-06-25T19:31:01.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29954208_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/c13f1f6eebb5fa8365a544c4e2a14343.webp"
"MediaSize" => 123837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-c13f1f6eebb5fa8365a544c4e2a14343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29954208_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/535e930b279d6fdbb40ccabec820d9a1.webp"
"MediaSize" => 138478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-535e930b279d6fdbb40ccabec820d9a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29954208_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/4e2d4579c48aa5fe1f6bda542c0d1c5c.webp"
"MediaSize" => 73738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-4e2d4579c48aa5fe1f6bda542c0d1c5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29954208_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/7eb2395e7d09812b4b16c5e154af27d6.webp"
"MediaSize" => 54299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-7eb2395e7d09812b4b16c5e154af27d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29954208_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/69822973932e925216398981b9ffa8ea.webp"
"MediaSize" => 37276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-69822973932e925216398981b9ffa8ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29954208_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/0629e1cab8eebdc531abfcac70498448.webp"
"MediaSize" => 68655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-0629e1cab8eebdc531abfcac70498448.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29954208_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/9c20902181d5cf7d72ea0aa2d275e46f.webp"
"MediaSize" => 69307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-9c20902181d5cf7d72ea0aa2d275e46f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29954208_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/09d693dd3fd2d6b3a32b0b6d90cd172d.webp"
"MediaSize" => 67926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-09d693dd3fd2d6b3a32b0b6d90cd172d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29954208_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/05ecd9a3c636ffd683206d62efe83281.webp"
"MediaSize" => 79152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-05ecd9a3c636ffd683206d62efe83281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29954208_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/94abe228e92f7216bb35e7d47da23382.webp"
"MediaSize" => 59826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-94abe228e92f7216bb35e7d47da23382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29954208_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/b42786302b8e3607a169cf9953f90a55.webp"
"MediaSize" => 63790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-b42786302b8e3607a169cf9953f90a55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29954208_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/2746fefd878baeb47529a6d20de7ed63.webp"
"MediaSize" => 77926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-2746fefd878baeb47529a6d20de7ed63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29954208_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/1c2831f2af3a36ed1e5b93f9c7074b51.webp"
"MediaSize" => 85703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-1c2831f2af3a36ed1e5b93f9c7074b51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29954208_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/23c5938296003cbc97ae1bf408b2cdd4.webp"
"MediaSize" => 66558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-23c5938296003cbc97ae1bf408b2cdd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29954208_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/68a288a5d701181a7d7e917d080d0f81.webp"
"MediaSize" => 74621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-68a288a5d701181a7d7e917d080d0f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29954208_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/78096b17798aa363e016917925690d95.webp"
"MediaSize" => 84801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-78096b17798aa363e016917925690d95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29954208_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/f42cb6d4d35dfb18b601b9ebc4157112.webp"
"MediaSize" => 89141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-f42cb6d4d35dfb18b601b9ebc4157112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29954208_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/8a6ba426ca80291fd7d8dfcf04a6352d.webp"
"MediaSize" => 73455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-8a6ba426ca80291fd7d8dfcf04a6352d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29954208_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/632148d45a0f337b4e81bfb8638ca6cc.webp"
"MediaSize" => 53349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-632148d45a0f337b4e81bfb8638ca6cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29954208_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/4834b94a034e82881308b321ff6ff2f7.webp"
"MediaSize" => 45302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-4834b94a034e82881308b321ff6ff2f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29954208_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/d10a0cbab653a8045dae440e55250717.webp"
"MediaSize" => 63412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-d10a0cbab653a8045dae440e55250717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29954208_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/9f31d0b09ce6b8622a56b0507f3dad52.webp"
"MediaSize" => 71803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-9f31d0b09ce6b8622a56b0507f3dad52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843154"
"ResourceRecordKey" => "29954208"
"ModificationTimestamp" => "2026-06-25T19:31:01.1Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29954208_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954208/1b48d0633da36612737d1d3db25af0ca.webp"
"MediaSize" => 71032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954208/thumbnail-1b48d0633da36612737d1d3db25af0ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954208')"
+"ID": "1565694"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1565408"
+post_author: 1
+"ListingKey": "29954379"
+"ListingId": "40843052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:42:15Z"
+"ListPrice": 1649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1908.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "17 FLANDERS Drive, Waterdown, Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.8821102
1 => 43.3322944
]
+"Latitude": 43.3322944
+"Longitude": -79.8821102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A custom-built Branthaven bungalow nestled on spectacular 66' x 162' ravine lot, where mature trees & natural surroundings create a peaceful, private retreat in one of Waterdown's most desirable neighbourhoods. Backing directly onto the renowned Bruce Trail, this exceptional property offers a rare opportunity to enjoy nature from your own backyard. Step inside to a welcoming foyer opening to spacious great room w/ vaulted ceiling, floor-to-ceiling FP, & abundant natural light. Dining area walks out to a raised deck overlooking the ravine setting—perfect for morning coffee, outdoor dining, or unwinding to the peaceful sounds of birds & nature. Updated kitchen w/ high-end SS appliances, breakfast bar, & large windows bringing the beauty of the outdoors in. Whether preparing gourmet meals for family gatherings or hosting friends, this space is as functional as it is inviting. Main level offers spacious primary suite w/ backyard views & updated 4pc ensuite w/ soaker tub & glass shower w/ steam sauna. 2 addtl generously sized bedrooms & updated 3pc bath complete the level. Heated floors in all bathrooms. Impressive walkout lower level expands the living space w/ large recreation & games room, family room w/ FP, den, 4th bedroom, 4pc updated bath w/ steam sauna, laundry area, & ample storage. With direct backyard access, this level offers exceptional flexibility for multi-generational living, working from home, relaxing, or entertaining. Pool-sized backyard offers endless possibilities for children, pets, gardening enthusiasts, or creating your dream outdoor oasis. Ideal for downsizers seeking main-floor living without compromise or growing families looking for a forever home w/ room to live, work, & play. Located in a prestigious Waterdown enclave known for executive homes, schools, parks, & strong sense of community, w/ convenient access to shopping, dining, major highways, & Aldershot GO Station. A truly special home where nature, comfort, & convenience come together. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:42:07.112139+00:00"
+"Directions": "MOUNTAIN BROW ROAD TO FLANDERS DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:10:55Z"
+"Stories": "1.0"
+"StreetName": "FLANDERS"
+"StreetNumber": "17"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8661.19"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204278829"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954379/17-flanders-drive-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1908
+"OriginalEntryTimestamp": "2026-06-25T19:50:37.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954379')"
+"ID": "1565408"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1562607"
+post_author: 1
+"ListingKey": "29950035"
+"ListingId": "40842858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T14:20:13Z"
+"RFModificationTimestamp": "2026-06-25T21:06:00Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3216.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER Road, Waterdown, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8764861
1 => 43.3410353
]
+"Latitude": 43.3410353
+"Longitude": -79.8764861
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don’t miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space — larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you’ll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite — complete with a full bath and bedroom for added convenience. Outside, you’ll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! Don’t be TOO LATE*! *REG TM. RSA. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:04:42.432242+00:00"
+"Directions": "DUNDAS ST E TO MALLARD TR TO SKINNER RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:49:53Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T14:11:08Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8117"
+"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/29950035/225-skinner-road-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 2316
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-24T23:49:53.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950035')"
+"ID": "1562607"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1562228"
+post_author: 1
+"ListingKey": "29953948"
+"ListingId": "X13489854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:25:16Z"
+"RFModificationTimestamp": "2026-06-26T01:43:17Z"
+"ListPrice": 1649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G6"
+"UnparsedAddress": "17 FLANDERS DRIVE, Hamilton (Waterdown), Ontario L8B0G6"
+"Coordinates": array:2 [
0 => -79.882184
1 => 43.33223
]
+"Latitude": 43.33223
+"Longitude": -79.882184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A custom-built Branthaven bungalow nestled on spectacular 66' x 162' ravine lot, where mature trees & natural surroundings create a peaceful, private retreat in one of Waterdown's most desirable neighbourhoods. Backing directly onto the renowned Bruce Trail, this exceptional property offers a rare opportunity to enjoy nature from your own backyard. Step inside to a welcoming foyer opening to spacious great room w/ vaulted ceiling, floor-to-ceiling FP, & abundant natural light. Dining area walks out to a raised deck overlooking the ravine setting-perfect for morning coffee, outdoor dining, or unwinding to the peaceful sounds of birds & nature. Updated kitchen w/ high-end SS appliances, breakfast bar, & large windows bringing the beauty of the outdoors in. Whether preparing gourmet meals for family gatherings or hosting friends, this space is as functional as it is inviting. Main level offers spacious primary suite w/ backyard views & updated 4pc ensuite w/ soaker tub & glass shower w/ steam sauna. 2 addtl generously sized bedrooms & updated 3pc bath complete the level. Heated floors in all bathrooms. Impressive walkout lower level expands the living space w/ large recreation & games room, family room w/ FP, den, 4th bedroom, 4pc updated bath w/ steam sauna, laundry area, & ample storage. With direct backyard access, this level offers exceptional flexibility for multi-generational living, working from home, relaxing, or entertaining. Pool-sized backyard offers endless possibilities for children, pets, gardening enthusiasts, or creating your dream outdoor oasis. Ideal for downsizers seeking main-floor living without compromise or growing families looking for a forever home w/ room to live, work, & play. Located in a prestigious Waterdown enclave known for executive homes, schools, parks, & strong sense of community, w/ convenient access to shopping, dining, major highways, & Aldershot GO Station. A truly special home where nature, comfort, & convenience come together. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Alarm System"
9 => "Oven - Built-In"
10 => "Window Coverings"
11 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:21:29.228149+00:00"
+"Directions": "Cross Streets: Mountain Brow Road. ** Directions: Mountain Brow Road to Flanders Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047588"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "66 x 162.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:58:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:19:12Z"
+"Stories": "1.0"
+"StreetName": "Flanders"
+"StreetNumber": "17"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8661.19"
+"VirtualTourURLUnbranded": "https://17flandersdrive.marketingrmx.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953948/17-flanders-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-06-25T18:58:52.61Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323031"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953948')"
+"ID": "1562228"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1561206"
+post_author: 1
+"ListingKey": "29950224"
+"ListingId": "X13486430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T22:25:13Z"
+"RFModificationTimestamp": "2026-06-25T22:34:31Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H1"
+"UnparsedAddress": "225 SKINNER ROAD S, Hamilton (Waterdown), Ontario L0R2H1"
+"Coordinates": array:2 [
0 => -79.876469
1 => 43.341084
]
+"Latitude": 43.341084
+"Longitude": -79.876469
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space - larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you'll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite - complete with a full bath and bedroom for added convenience. Outside, you'll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! Don't be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-25T18:58:48.609943+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: DUNDAS ST E TO MALLARD TR TO SKINNER RD."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T00:44:11Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T22:19:05Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "8117"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950224/225-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2026-06-25T00:44:11.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950224')"
+"ID": "1561206"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1555247"
+post_author: 1
+"ListingKey": "29938814"
+"ListingId": "X13476286"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:55:19Z"
+"RFModificationTimestamp": "2026-06-23T18:58:51Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "213 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.894191
1 => 43.330175
]
+"Latitude": 43.330175
+"Longitude": -79.894191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Outstanding value awaits in this sophisticated two-bedroom, two-bathroom, 1,170 square foot, corner residence at 213-30 Hamilton Street South-offering some of the best price-per-square-foot value in the sought-after The View Condominium, downtown Waterdown. As one of the area's newer buildings, it pairs contemporary design with exceptional amenities, making it a smart choice for first-time buyers and investors alike. The building offers concierge service, a state-of-the-art fitness center, stylish party room, pet washing station, rooftop terrace and lush garden. Inside, floor-to-ceiling windows frame sweeping views and flood the open-concept living, dining and kitchen spaces with natural light. The kitchen features a large island, premium appliances and elegant finishes. Step onto your private balcony to savor morning coffee or breathtaking sunsets. The primary suite impresses with two walls of windows and a serene ambiance, complemented by a spa-inspired ensuite. The second bedroom suits guests or a refined home office. In-suite laundry, underground parking and a storage locker complete the offering. Stroll to boutiques, fine dining, cafés and markets, with quick access to major highways. A rare opportunity to own in a newer building with low-maintenance, high-value living. RSA. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "1021.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:32:18.605669+00:00"
+"Directions": "Cross Streets: Dundas St W. ** Directions: Dundas St W to Hamilton St S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T18:48:33Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:48:33Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5827"
+"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/29938814/213-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Daycare"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Security/Concierge"
5 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-22T21:46:25.38Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938814')"
+"ID": "1555247"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1555354"
+post_author: 1
+"ListingKey": "29938075"
+"ListingId": "40842057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T20:00:10Z"
+"RFModificationTimestamp": "2026-06-22T22:20:19Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1170.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 213, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940406
1 => 43.3302884
]
+"Latitude": 43.3302884
+"Longitude": -79.8940406
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Outstanding value awaits in this sophisticated two-bedroom, two-bathroom, 1,170 square foot, corner residence at 213-30 Hamilton Street South—offering some of the best price-per-square-foot value in the sought-after The View Condominium, downtown Waterdown. As one of the area's newer buildings, it pairs contemporary design with exceptional amenities, making it a smart choice for first-time buyers and investors alike. The building offers concierge service, a state-of-the-art fitness center, stylish party room, pet washing station, rooftop terrace and lush garden. Inside, floor-to-ceiling windows frame sweeping views and flood the open-concept living, dining and kitchen spaces with natural light. The kitchen features a large island, premium appliances and elegant finishes. Step onto your private balcony to savor morning coffee or breathtaking sunsets. The primary suite impresses with two walls of windows and a serene ambiance, complemented by a spa-inspired ensuite. The second bedroom suits guests or a refined home office. In-suite laundry, underground parking and a storage locker complete the offering. Stroll to boutiques, fine dining, cafés and markets, with quick access to major highways. A rare opportunity to own in a newer building with low-maintenance, high-value living. Don’t be TOO LATE*! *REG TM. RSA. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "1021.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:20:10.655688+00:00"
+"Directions": "Dundas St W to Hamilton St S"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-22T19:50:48Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T19:50:47Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "5827"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29938075/30-hamilton-street-s-unit-213-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1170
+"OriginalEntryTimestamp": "2026-06-22T19:50:47.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938075')"
+"ID": "1555354"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1554503"
+post_author: 1
+"ListingKey": "29937656"
+"ListingId": "X13475240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:50:08Z"
+"RFModificationTimestamp": "2026-06-23T18:54:07Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "15 HAGER CREEK TERRACE, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.874634
1 => 43.341421
]
+"Latitude": 43.341421
+"Longitude": -79.874634
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Semi Detached Absolutely Gorgeous Glendale 4 Model Elevation 1A, 4 Bedroom 2.5Washroom In Beautiful Waterdown Hamilton. This Home Offers An Open Concept Layout, 9' Ceilings On Main Floor, Upgraded Staircase With Metal Pickets, Laminate Flooring Throughout The Home, Builders Upgraded Master Bedroom Tiles And Tub, Beautiful Kitchen, And Central Air Conditioning. This Home Also Offers Many Windows Allowing Natural Light To Fill The Home. The unfinished basement offers endless potential making it a fantastic opportunity. Located just minutes from schools, parks, shopping, transit, and highway access, this home combines comfort, space, and convenience in one desirable package. Don't miss your chance to call this Waterdown gem home (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:44:47.904613+00:00"
+"Directions": "Dundas St. East & Burke St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979241"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:42:25Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:42:25Z"
+"Stories": "2.0"
+"StreetName": "Hager Creek"
+"StreetNumber": "15"
+"StreetSuffix": "Terrace"
+"TaxAnnualAmount": "7100"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937656/15-hager-creek-terrace-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-06-22T18:51:13.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1265168"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937656')"
+"ID": "1554503"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1554337"
+post_author: 1
+"ListingKey": "29936356"
+"ListingId": "X13474102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:34Z"
+"ListPrice": 434999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "230 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown. This well maintained 1+den condo offers 692 sq ft of thoughtfully designed living space, ideal for comfortable everyday living.Situated on the second floor, the unit features an open concept layout with laminate flooring throughout and a versatile den that can easily function as a home office, guest area, or additional living space. Walk out to a private balcony, perfect for relaxing outdoors.The unit includes two parking spaces, one underground and one outdoor, along with a private locker, offering a rare and highly practical combination.Located in the sought after Trend community, close to parks, shopping, dining, and major highways, while still enjoying the charm of Waterdown. A great opportunity for first time buyers, professionals, or investors seeking a move in ready property. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "494.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:19:43.183868+00:00"
+"Directions": "Dundas and Riverwalk"
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1975151"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T14:22:05Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:22:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3020.94"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/c3234619"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936356/230-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 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T16:26:49.13Z"
+"ListAgentNationalAssociationId": "1261992"
+"ListOfficeNationalAssociationId": "1336201"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936356')"
+"ID": "1554337"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 165
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]