array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29913010 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1537265"
+post_author: 1
+"ListingKey": "29913010"
+"ListingId": "X13453332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:30:06Z"
+"RFModificationTimestamp": "2026-06-17T00:36:47Z"
+"ListPrice": 395000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "604 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8787922
1 => 43.343573
]
+"Latitude": 43.343573
+"Longitude": -79.8787922
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T00:36:45.583991+00:00"
+"Directions": "Cross Streets: Dundas St E/Mallard. ** Directions: Dundas."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036737"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:25:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:25:02Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2592.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/604_470_dundas_st_e_hamilton_on/"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1660789634"
"RoomType" => "Kitchen"
"ListingId" => "X13453332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.65
"ListingKey" => "29913010"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T22:25:02.57Z"
]
1 => array:11 [
"RoomKey" => "1660789635"
"RoomType" => "Living room"
"ListingId" => "X13453332"
"RoomLevel" => "Main level"
"RoomWidth" => 5.35
"ListingKey" => "29913010"
"RoomLength" => 3.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T22:25:02.57Z"
]
2 => array:11 [
"RoomKey" => "1660789636"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13453332"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29913010"
"RoomLength" => 2.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T22:25:02.57Z"
]
3 => array:11 [
"RoomKey" => "1660789637"
"RoomType" => "Bathroom"
"ListingId" => "X13453332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29913010"
"RoomLength" => 1.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T22:25:02.58Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29913010/604-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T22:25:02.55Z"
+"ListAgentNationalAssociationId": "1313206"
+"ListOfficeNationalAssociationId": "1300540"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29913010_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/29b93c35883d81cfbb671cd8a498f609.webp"
"MediaSize" => 341360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-29b93c35883d81cfbb671cd8a498f609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29913010_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/0b9629eb549596ea31b9cade72cb38f5.webp"
"MediaSize" => 382264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-0b9629eb549596ea31b9cade72cb38f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29913010_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/e4f66af9b1d1eb203979419aba5367eb.webp"
"MediaSize" => 342608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-e4f66af9b1d1eb203979419aba5367eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29913010_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/77945f838cf438b5c7e5de2bf7327c1f.webp"
"MediaSize" => 446988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-77945f838cf438b5c7e5de2bf7327c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29913010_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/1dc6486409159a280791a500841a827c.webp"
"MediaSize" => 346570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-1dc6486409159a280791a500841a827c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29913010_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/161d0b84de7e7df26cb5a6d396214c7b.webp"
"MediaSize" => 347628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-161d0b84de7e7df26cb5a6d396214c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29913010_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/6278a071f33204e226a7bb72e2f61046.webp"
"MediaSize" => 200165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-6278a071f33204e226a7bb72e2f61046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29913010_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/7fb87dec342ded78cfa690cb59bdb887.webp"
"MediaSize" => 194681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-7fb87dec342ded78cfa690cb59bdb887.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29913010_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/37e117e96749e23dbed3fff88379ff00.webp"
"MediaSize" => 299037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-37e117e96749e23dbed3fff88379ff00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29913010_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/3a8b4064c8e96bfe9ce203cbf95b1076.webp"
"MediaSize" => 281831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-3a8b4064c8e96bfe9ce203cbf95b1076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29913010_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/d761e1681c80c2ffe332383d74c79b85.webp"
"MediaSize" => 234931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-d761e1681c80c2ffe332383d74c79b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29913010_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/8bf90eb592bc138f0b1a5b1182b203e6.webp"
"MediaSize" => 200032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-8bf90eb592bc138f0b1a5b1182b203e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29913010_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/32be9ba9f9f7c2fb4e6753e8b9f738d0.webp"
"MediaSize" => 133828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-32be9ba9f9f7c2fb4e6753e8b9f738d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29913010_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/1bc708e1c9567cdf3f40942a78baed21.webp"
"MediaSize" => 190285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-1bc708e1c9567cdf3f40942a78baed21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29913010_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/2b68785bb26bc701a0437731760ef1f9.webp"
"MediaSize" => 195412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-2b68785bb26bc701a0437731760ef1f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29913010_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/22a4ce53b53b78b644f6cf6972b2f50d.webp"
"MediaSize" => 213384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-22a4ce53b53b78b644f6cf6972b2f50d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29913010_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/5daa8c8ca0e8a762bb5494bc503953af.webp"
"MediaSize" => 179081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-5daa8c8ca0e8a762bb5494bc503953af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29913010_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/5ca88ed572481de5151f9638e87a96e6.webp"
"MediaSize" => 175663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-5ca88ed572481de5151f9638e87a96e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29913010_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/15bab65cc5d65f9551517b2a4d55f456.webp"
"MediaSize" => 179102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-15bab65cc5d65f9551517b2a4d55f456.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29913010_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/1dca3bbda14a92f4e7fad302e5a7936f.webp"
"MediaSize" => 166931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-1dca3bbda14a92f4e7fad302e5a7936f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29913010_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/274af7f58988dd84181adfc1e681a9b3.webp"
"MediaSize" => 203440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-274af7f58988dd84181adfc1e681a9b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29913010_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/1666d6c330189eff5d9a1c3e7b1209ce.webp"
"MediaSize" => 214330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-1666d6c330189eff5d9a1c3e7b1209ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29913010_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/fb5a8f8c65ca3a42fecdf6e04eae035c.webp"
"MediaSize" => 233481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-fb5a8f8c65ca3a42fecdf6e04eae035c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29913010_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/8c4ca551a42642ffb6446c05611a6b80.webp"
"MediaSize" => 225935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-8c4ca551a42642ffb6446c05611a6b80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29913010_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/ee849508b7dbc93bc9fa29c4d0730da8.webp"
"MediaSize" => 189810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-ee849508b7dbc93bc9fa29c4d0730da8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29913010_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/6741239709bdf975c5910d4b82e6fa29.webp"
"MediaSize" => 225767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-6741239709bdf975c5910d4b82e6fa29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29913010_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/ef1d03c2e2f45b320a0a0464c1a0ea81.webp"
"MediaSize" => 218190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-ef1d03c2e2f45b320a0a0464c1a0ea81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29913010_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/e41c61ec2f8526b32d751daeecc62ec4.webp"
"MediaSize" => 179422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-e41c61ec2f8526b32d751daeecc62ec4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29913010_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/c0f22e0069275113e1291b7cf24bb9fb.webp"
"MediaSize" => 168942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-c0f22e0069275113e1291b7cf24bb9fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29913010_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/b3e9260b4f419f20fee0460516e34f5c.webp"
"MediaSize" => 150574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-b3e9260b4f419f20fee0460516e34f5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29913010_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/65909f16378463f48776faabb93ab2ae.webp"
"MediaSize" => 157351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-65909f16378463f48776faabb93ab2ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29913010_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/5395a40bc8ff80ecee09a91b07233ada.webp"
"MediaSize" => 236037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-5395a40bc8ff80ecee09a91b07233ada.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29913010_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/9469a66ba1ceaea927761f7c6809de24.webp"
"MediaSize" => 183665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-9469a66ba1ceaea927761f7c6809de24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29913010_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/0a97c0f458ce59b1e4683c935dcf9e3f.webp"
"MediaSize" => 320524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-0a97c0f458ce59b1e4683c935dcf9e3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29913010_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/b41d6f747c92d04cd349859e3168c1dd.webp"
"MediaSize" => 264125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-b41d6f747c92d04cd349859e3168c1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29913010_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/9f3976e47e2542945b6363f39eeb2666.webp"
"MediaSize" => 241745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-9f3976e47e2542945b6363f39eeb2666.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29913010_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/7ad703912e5fcbb6c3fbb53907ea47ad.webp"
"MediaSize" => 245951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-7ad703912e5fcbb6c3fbb53907ea47ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29913010_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/c84c03e8782276871108845550168181.webp"
"MediaSize" => 244032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-c84c03e8782276871108845550168181.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29913010_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/539562aa89fd7508a0c4943cf566c6db.webp"
"MediaSize" => 342302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-539562aa89fd7508a0c4943cf566c6db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29913010_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/8213ead1e79f16cef41677ee46f6581f.webp"
"MediaSize" => 284097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-8213ead1e79f16cef41677ee46f6581f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29913010_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/b6e8a98a79ba3d7b15b865cb586db5e5.webp"
"MediaSize" => 306422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-b6e8a98a79ba3d7b15b865cb586db5e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29913010_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/8d2fb2ab44c3c9f3c4f2db22599778e0.webp"
"MediaSize" => 197462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-8d2fb2ab44c3c9f3c4f2db22599778e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29913010_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913010/65ad16d74973f8f218b72a9844b5e356.webp"
"MediaSize" => 95113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913010/thumbnail-65ad16d74973f8f218b72a9844b5e356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453332"
"ResourceRecordKey" => "29913010"
"ModificationTimestamp" => "2026-06-16T22:25:02.55Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913010')"
+"ID": "1537265"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 279033" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24781
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2036737" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24866
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29913010'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25186
+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 '29913010'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25202
+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 '29913010' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8787922 43.343573)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: 1540555
+post_author: 1
+"ListingKey": "29917865"
+"ListingId": "X13457556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:05:09Z"
+"RFModificationTimestamp": "2026-06-17T20:30:03Z"
+"ListPrice": 1284900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R5"
+"UnparsedAddress": "23 MCKNIGHT AVENUE, Hamilton (Waterdown), Ontario L8B0R5"
+"Coordinates": array:2 [
0 => -79.883411
1 => 43.338026
]
+"Latitude": 43.338026
+"Longitude": -79.883411
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 23 McKnight Avenue, Nestled in a Sought-After, Family-Friendly Neighbourhood in East Waterdown. Ideally Located Just Steps from Parks and Scenic Trails, This Detached, 4-Bedroom Home Offers Over 3,000 Sq Ft of FULLY FINISHED Living Space. The Main Level Features a Bright, Open-Concept Layout with a Spacious Eat-in Kitchen Complete with Granite Countertops & Backsplash, a Center Island and a Pantry - Perfect for Both Everyday Living and Entertaining. A Convenient Mudroom/Laundry Area Provides Inside Access to the Double Car Garage. Upstairs, the Primary Bedroom Retreat Boasts a Walk-in Closet and a 4-Piece Ensuite. Three Additional Good Sized Bedrooms Complete the Upper Level. The Fully Finished Lower Level Showcases a Modern Farmhouse Design and Offers Exceptional Versatility, Featuring a Wet Bar, 2- Piece Bathroom, and an Additional Room Ideal for a Home Gym, Office or Guest Space. Step Outside to a Low-Maintenance Backyard Oasis, Complete with Concrete Patio & Walkway, Artificial Turf, Hot Tub, Pergola, and a Gas Line for BBQ - Great for Hosting Summer Gatherings! Located in a Vibrant, Growing Community, This Home is Just Minutes from Shopping, Amenities, Major Highways and the Aldershot GO, Making Commuting a Breeze! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Storage Shed"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T20:29:50.514406+00:00"
+"Directions": "Cross Streets: Burke St. ** Directions: Dundas St. E/Burke St./McKnight Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2155639"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "38.1 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T19:59:57Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T19:59:57Z"
+"Stories": "2.0"
+"StreetName": "McKnight"
+"StreetNumber": "23"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "7237.67"
+"VirtualTourURLUnbranded": "https://youriguide.com/23_mcknight_ave_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1661430652"
"RoomType" => "Bedroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 3.18
"ListingKey" => "29917865"
"RoomLength" => 2.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.66Z"
]
1 => array:11 [
"RoomKey" => "1661430653"
"RoomType" => "Bathroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 3.18
"ListingKey" => "29917865"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
2 => array:11 [
"RoomKey" => "1661430654"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13457556"
"RoomLevel" => "Basement"
"RoomWidth" => 8.97
"ListingKey" => "29917865"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
3 => array:11 [
"RoomKey" => "1661430655"
"RoomType" => "Den"
"ListingId" => "X13457556"
"RoomLevel" => "Basement"
"RoomWidth" => 2.35
"ListingKey" => "29917865"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
4 => array:11 [
"RoomKey" => "1661430656"
"RoomType" => "Bathroom"
"ListingId" => "X13457556"
"RoomLevel" => "Basement"
"RoomWidth" => 1.65
"ListingKey" => "29917865"
"RoomLength" => 2.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
5 => array:11 [
"RoomKey" => "1661430657"
"RoomType" => "Utility room"
"ListingId" => "X13457556"
"RoomLevel" => "Basement"
"RoomWidth" => 1.8
"ListingKey" => "29917865"
"RoomLength" => 3.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
6 => array:11 [
"RoomKey" => "1661430658"
"RoomType" => "Bathroom"
"ListingId" => "X13457556"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29917865"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
7 => array:11 [
"RoomKey" => "1661430659"
"RoomType" => "Dining room"
"ListingId" => "X13457556"
"RoomLevel" => "Main level"
"RoomWidth" => 3.78
"ListingKey" => "29917865"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
8 => array:11 [
"RoomKey" => "1661430660"
"RoomType" => "Living room"
"ListingId" => "X13457556"
"RoomLevel" => "Main level"
"RoomWidth" => 5.31
"ListingKey" => "29917865"
"RoomLength" => 3.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
9 => array:11 [
"RoomKey" => "1661430661"
"RoomType" => "Kitchen"
"ListingId" => "X13457556"
"RoomLevel" => "Main level"
"RoomWidth" => 4.85
"ListingKey" => "29917865"
"RoomLength" => 6.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
10 => array:11 [
"RoomKey" => "1661430662"
"RoomType" => "Bathroom"
"ListingId" => "X13457556"
"RoomLevel" => "Main level"
"RoomWidth" => 2.18
"ListingKey" => "29917865"
"RoomLength" => 0.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
11 => array:11 [
"RoomKey" => "1661430663"
"RoomType" => "Laundry room"
"ListingId" => "X13457556"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29917865"
"RoomLength" => 2.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
12 => array:11 [
"RoomKey" => "1661430664"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 5.84
"ListingKey" => "29917865"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
13 => array:11 [
"RoomKey" => "1661430665"
"RoomType" => "Bathroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 3.18
"ListingKey" => "29917865"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.67Z"
]
14 => array:11 [
"RoomKey" => "1661430666"
"RoomType" => "Bedroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 4.39
"ListingKey" => "29917865"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.68Z"
]
15 => array:11 [
"RoomKey" => "1661430667"
"RoomType" => "Bedroom"
"ListingId" => "X13457556"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29917865"
"RoomLength" => 3.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T19:59:57.68Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917865/23-mcknight-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-06-17T19:22:02.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1407065"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29917865_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/225fd56c3a654a21766d05d43406709f.webp"
"MediaSize" => 403012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-225fd56c3a654a21766d05d43406709f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:22:02.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29917865_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/3690be71d16db0231d9ab699a5500088.webp"
"MediaSize" => 192636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-3690be71d16db0231d9ab699a5500088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:22:02.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29917865_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/b0fde532e079632a23cd3a37cd518f95.webp"
"MediaSize" => 503299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-b0fde532e079632a23cd3a37cd518f95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:22:02.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29917865_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/919b3ef474de9d80536c60ae35bc9586.webp"
"MediaSize" => 201404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-919b3ef474de9d80536c60ae35bc9586.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:22:02.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29917865_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/72a1725aa5a6311217bc6bb571ec94a4.webp"
"MediaSize" => 220810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-72a1725aa5a6311217bc6bb571ec94a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:22:02.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29917865_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/8fde626d3999d57fab4eac4c5cf194fc.webp"
"MediaSize" => 237939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-8fde626d3999d57fab4eac4c5cf194fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:37.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29917865_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/4b97456fd2c6c52cb16b34085bace202.webp"
"MediaSize" => 265478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-4b97456fd2c6c52cb16b34085bace202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:44.96Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29917865_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/29bd67e42a04bf3c1358d85eac508524.webp"
"MediaSize" => 222621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-29bd67e42a04bf3c1358d85eac508524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:44.91Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29917865_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/59f9a660a56e593aa41a4955a170b1f1.webp"
"MediaSize" => 276265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-59f9a660a56e593aa41a4955a170b1f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:45.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29917865_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/e3ae8ddce8d123f5515c3ec97c0c32c8.webp"
"MediaSize" => 307541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-e3ae8ddce8d123f5515c3ec97c0c32c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:33.69Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29917865_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/3ab667816217c770d213830420d0e1bc.webp"
"MediaSize" => 130607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-3ab667816217c770d213830420d0e1bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:32.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29917865_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/88a264d806441e696ec219b27705fbeb.webp"
"MediaSize" => 131948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-88a264d806441e696ec219b27705fbeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:32.96Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29917865_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/86fe70eda1853932f6d844de69cd2e6c.webp"
"MediaSize" => 135620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-86fe70eda1853932f6d844de69cd2e6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:33.69Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29917865_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/fb0ade9f12e1071b54612e599b25f746.webp"
"MediaSize" => 299903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-fb0ade9f12e1071b54612e599b25f746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:33.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29917865_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/8f249c990db6930cbbc7b0483f56791b.webp"
"MediaSize" => 282495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-8f249c990db6930cbbc7b0483f56791b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:34.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29917865_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/94f032ec8fc24bb257418826feff408e.webp"
"MediaSize" => 175598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-94f032ec8fc24bb257418826feff408e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13457556"
"ResourceRecordKey" => "29917865"
"ModificationTimestamp" => "2026-06-17T19:29:32.95Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29917865_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917865/657326668e2870b3513fbd4e58b00299.webp"
"MediaSize" => 212811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917865/thumbnail-657326668e2870b3513fbd4e58b00299.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917865')"
+"ID": 1540555
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1539930"
+post_author: 1
+"ListingKey": "29917464"
+"ListingId": "40840531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:50:07Z"
+"RFModificationTimestamp": "2026-06-17T19:17:56Z"
+"ListPrice": 1284900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3289.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0R5"
+"UnparsedAddress": "23 MCKNIGHT Avenue, Waterdown, Ontario L8B0R5"
+"Coordinates": array:2 [
0 => -79.8833993
1 => 43.3380225
]
+"Latitude": 43.3380225
+"Longitude": -79.8833993
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 23 McKnight Avenue, Nestled in a Sought-After, Family-Friendly Neighbourhood in East Waterdown. Ideally Located Just Steps from Parks and Scenic Trails, This Detached, 4-Bedroom Home Offers Over 3,000 Sq Ft of FULLY FINISHED Living Space. The Main Level Features a Bright, Open-Concept Layout with a Spacious Eat-in Kitchen Complete with Granite Countertops & Backsplash, a Center Island and a Pantry - Perfect for Both Everyday Living and Entertaining. A Convenient Mudroom/Laundry Area Provides Inside Access to the Double Car Garage. Upstairs, the Primary Bedroom Retreat Boasts a Walk-in Closet and a 4-Piece Ensuite. Three Additional Good Sized Bedrooms Complete the Upper Level. The Fully Finished Lower Level Showcases a Modern Farmhouse Design and Offers Exceptional Versatility, Featuring a Wet Bar, 2- Piece Bathroom, and an Additional Room Ideal for a Home Gym, Office or Guest Space. Step Outside to a Low-Maintenance Backyard Oasis, Complete with Concrete Patio & Walkway, Artificial Turf, Hot Tub, Pergola, and a Gas Line for BBQ - Great for Hosting Summer Gatherings! Located in a Vibrant, Growing Community, This Home is Just Minutes from Shopping, Amenities, Major Highways and the Aldershot GO, Making Commuting a Breeze (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:17:03.197619+00:00"
+"Directions": "Dundas St. E/Burke St./McKnight Ave."
+"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": "1626863"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T18:40:17Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:40:17Z"
+"Stories": "2.0"
+"StreetName": "MCKNIGHT"
+"StreetNumber": "23"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7237.67"
+"VirtualTourURLUnbranded": "https://youriguide.com/23_mcknight_ave_waterdown_on/"
+"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/29917464/23-mcknight-avenue-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-39"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 2245
+"BelowGradeFinishedArea": 1044
+"OriginalEntryTimestamp": "2026-06-17T18:40:17.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1161695"
+"ListOfficeNationalAssociationId": "1372539"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917464')"
+"ID": "1539930"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1539700"
+post_author: 1
+"ListingKey": "29916287"
+"ListingId": "X13456242"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:25:01Z"
+"RFModificationTimestamp": "2026-06-17T19:05:36Z"
+"ListPrice": 689990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "173 BURKE STREET, Hamilton (Waterdown), Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8802507
1 => 43.3377303
]
+"Latitude": 43.3377303
+"Longitude": -79.8802507
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to SOL Stacked Towns, a brand-new community in sought-after Waterdown. This thoughtfully designed 3-bedroom, 2.5-bathroom townhome offers 1,362 sq. ft. of modern living space featuring an open-concept layout, contemporary vinyl plank flooring throughout, stone kitchen countertops, 1 garage & 1 driveway space. Enjoy the convenience of low-maintenance living in a vibrant neighbourhood close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. An exceptional opportunity to own in one of Waterdown's newest communities. (id:62783)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"AssociationFee": "246"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"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-17T17:30:27.545428+00:00"
+"Directions": "Cross Streets: Skinner Rd. ** Directions: Dundas St E - 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": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T16:39:02Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:00:05Z"
+"Stories": "2.0"
+"StreetName": "Burke"
+"StreetNumber": "173"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eccdf-412b-7208-9da8-f100cec98dfc"
+"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/29916287/173-burke-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TBD"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T16:39:02.13Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916287')"
+"ID": "1539700"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1537794"
+post_author: 1
+"ListingKey": "29914078"
+"ListingId": "40840582"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T03:55:09Z"
+"RFModificationTimestamp": "2026-06-17T04:32:06Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 853.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 336, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8784192
1 => 43.3443494
]
+"Latitude": 43.3443494
+"Longitude": -79.8784192
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 2 underground parking spaces! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station. Book your private showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"CreationDate": "2026-06-17T04:32:05.599995+00:00"
+"Directions": "Dundas St E to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T03:51:49Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T03:51:49Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4363"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914078/10-mallard-trail-unit-336-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 853
+"OriginalEntryTimestamp": "2026-06-17T03:50:02.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914078')"
+"ID": "1537794"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1537737"
+post_author: 1
+"ListingKey": "29913910"
+"ListingId": "40840573"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T14:40:10Z"
+"RFModificationTimestamp": "2026-06-17T14:44:47Z"
+"ListPrice": 649990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1362.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "90 SKINNER Road Unit# 6, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8792313
1 => 43.3374704
]
+"Latitude": 43.3374704
+"Longitude": -79.8792313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to SOL Stacked Towns, a brand-new community in sought-after Waterdown. This thoughtfully designed 3-bedroom, 2.5-bathroom townhome offers 1,362 sq. ft. of modern living space featuring an open-concept layout, contemporary vinyl plank flooring throughout, stone kitchen countertops, and 1 garage parking space. Enjoy the convenience of low-maintenance living in a vibrant neighbourhood close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. An exceptional opportunity to own in one of Waterdown's newest communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "246"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T04:02:38.416681+00:00"
+"Directions": "Dundas St E. to Burke St. to Kenesky Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T02:31:47Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T14:31:11Z"
+"Stories": "3.0"
+"StreetName": "SKINNER"
+"StreetNumber": "90"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eccdf-412b-7208-9da8-f100cec98dfc"
+"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/29913910/90-skinner-road-unit-6-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "RC-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1362
+"OriginalEntryTimestamp": "2026-06-17T02:31:46.89Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913910')"
+"ID": "1537737"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1537738"
+post_author: 1
+"ListingKey": "29913869"
+"ListingId": "40840566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T14:40:10Z"
+"RFModificationTimestamp": "2026-06-17T14:44:47Z"
+"ListPrice": 689990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1362.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "173 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8801075
1 => 43.3378942
]
+"Latitude": 43.3378942
+"Longitude": -79.8801075
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to SOL Stacked Towns, a brand-new community in sought-after Waterdown. This thoughtfully designed 3-bedroom, 2.5-bathroom townhome offers 1,362 sq. ft. of modern living space featuring an open-concept layout, contemporary vinyl plank flooring throughout, stone kitchen countertops, 1 garage & 1 driveway space. Enjoy the convenience of low-maintenance living in a vibrant neighbourhood close to parks, schools, shopping, dining, and everyday amenities, with quick access to Highway 407, Aldershot GO Station, Burlington, and Hamilton. An exceptional opportunity to own in one of Waterdown's newest communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "246"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T02:46:35.140507+00:00"
+"Directions": "Dundas St E. to Burke St. to Kenesky Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T02:12:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T14:31:12Z"
+"Stories": "3.0"
+"StreetName": "BURKE"
+"StreetNumber": "173"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "1"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eccdf-412b-7208-9da8-f100cec98dfc"
+"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/29913869/173-burke-street-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "RC-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1362
+"OriginalEntryTimestamp": "2026-06-17T02:09:48.54Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913869')"
+"ID": "1537738"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1535992"
+post_author: 1
+"ListingKey": "29911949"
+"ListingId": "40840369"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:00:08Z"
+"RFModificationTimestamp": "2026-06-16T20:34:46Z"
+"ListPrice": 395000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 515.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 604, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786396
1 => 43.3439185
]
+"Latitude": 43.3439185
+"Longitude": -79.8786396
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.125636+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1647189"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T19:53:05Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:53:05Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2592.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911949/470-dundas-street-e-unit-604-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1568615"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "103841"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 515
+"OriginalEntryTimestamp": "2026-06-16T19:50:58.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1283810"
+"ListOfficeNationalAssociationId": "1325050"
+"CoListAgentNationalAssociationId": "1150320"
+"CoListOfficeNationalAssociationId": "1165450"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911949')"
+"ID": "1535992"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1534315"
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 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": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"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/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": "1534315"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1534027"
+post_author: 1
+"ListingKey": "29908612"
+"ListingId": "40840175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:11:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street Unit# 709, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792813
1 => 43.3435237
]
+"Latitude": 43.3435237
+"Longitude": -79.8792813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to elevated condo living in the heart of East Waterdown! This beautifully upgraded 1-bedroom + oversized den condo offers modern style, functional space, and thoughtful design throughout. Currently used as an additional sleeping area, the spacious den offers exceptional flexibility and could easily function as a guest room, home office, nursery, fitness space, or multi-purpose retreat to suit your lifestyle. The open-concept layout is ideal for both everyday living and entertaining, highlighted by a stunning upgraded kitchen featuring a sleek granite waterfall peninsula, extended cabinetry for added storage, upgraded stainless steel appliances, and a contemporary single-basin sink. Premium upgraded flooring flows seamlessly throughout, complemented by smooth ceilings that create a clean, refined finish. Adding to the value and convenience, geothermal heating is included in the condo fees, offering efficient year-round comfort and reduced monthly utility costs. This well-appointed building also offers exceptional amenities including a stylish party room complete with a pool table, fireplace, comfortable seating area, and full kitchen, along with an exercise room, bicycle storage room, storage locker, underground parking space, and an outdoor terrace featuring seating areas and BBQs—perfect for entertaining and enjoying the community atmosphere. Ideally located in desirable East Waterdown, enjoy quick access to major highways while being close to parks, shopping, dining, and the natural beauty of the nearby Niagara Escarpment and surrounding trails—offering the perfect blend of urban convenience and outdoor living. Move in and enjoy stylish, low-maintenance living in one of Waterdown’s most sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:29.675759+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021739"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:17Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3007.36"
+"VirtualTourURLUnbranded": "https://youtu.be/U-fSD3T-vSs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908612/460-e-dundas-street-unit-709-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-16T12:50:17.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1301652"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:13 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908612')"
+"ID": "1534027"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 166
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]