array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29918493 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: "1540723"
+post_author: 1
+"ListingKey": "29918493"
+"ListingId": "X13458298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:00:17Z"
+"RFModificationTimestamp": "2026-06-17T21:34:39Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0M9"
+"UnparsedAddress": "174 FELLOWES CRESCENT, Hamilton (Waterdown), Ontario L8B0M9"
+"Coordinates": array:2 [
0 => -79.885869
1 => 43.347193
]
+"Latitude": 43.347193
+"Longitude": -79.885869
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Affordable living in the heart of Waterdown! This impeccably maintained and move-in-ready three-bedroom freehold quad townhome offers the perfect blend of comfort, convenience and value. Nestled in a quiet, established neighbourhood surrounded by mature trees, this home offers exceptional access to Highway 6, the QEW, and Highway 403, with Aldershot GO Station just a short drive away. A new stone walkway welcomes you from the two-car driveway into a bright and spacious living room featuring stylish vinyl plank flooring and a cozy gas fireplace. The eat-in kitchen is ideal for everyday living, complete with a gas range and walkout to the private rear yard. The main floor also features a newly renovated two-piece powder room, while all-new (2026) LED lighting and California shutters add a modern touch throughout. Upstairs, the generous primary bedroom boasts dual closets and direct access to the beautifully renovated main bathroom, showcasing a beautiful quartz-topped vanity and updated tub surround. Two additional spacious bedrooms provide plenty of room for family, guests or a home office. The fully finished basement expands your living space with a large family room featuring a second gas fireplace, a convenient two-piece bathroom, and laundry area. Step outside to enjoy the backyard oasis, complete with a stone patio, hot tub, and a Generac generator for added peace of mind year-round. Enjoy all that Waterdown has to offer, including scenic hiking and biking trails, parks, boutique shopping, dining, and a vibrant downtown atmosphere. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:34:30.457162+00:00"
+"Directions": "Cross Streets: Parkside Dr & Boulding AVe. ** Directions: Parkside Dr to Boulding Ave to Niska Dr to Fellowes Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16.6 x 131.3 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:53:46Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:53:46Z"
+"Stories": "2.0"
+"StreetName": "Fellowes"
+"StreetNumber": "174"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4565"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661484608"
"RoomType" => "Kitchen"
"ListingId" => "X13458298"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "29918493"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.65Z"
]
1 => array:11 [
"RoomKey" => "1661484609"
"RoomType" => "Living room"
"ListingId" => "X13458298"
"RoomLevel" => "Main level"
"RoomWidth" => 4.27
"ListingKey" => "29918493"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.66Z"
]
2 => array:11 [
"RoomKey" => "1661484610"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13458298"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29918493"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.66Z"
]
3 => array:11 [
"RoomKey" => "1661484611"
"RoomType" => "Bedroom"
"ListingId" => "X13458298"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29918493"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.67Z"
]
4 => array:11 [
"RoomKey" => "1661484612"
"RoomType" => "Bedroom"
"ListingId" => "X13458298"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29918493"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.67Z"
]
5 => array:11 [
"RoomKey" => "1661484613"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13458298"
"RoomLevel" => "Basement"
"RoomWidth" => 5.77
"ListingKey" => "29918493"
"RoomLength" => 6.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.68Z"
]
6 => array:11 [
"RoomKey" => "1661484614"
"RoomType" => "Laundry room"
"ListingId" => "X13458298"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29918493"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.68Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918493/174-fellowes-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-2,R6-7"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 16.7
+"OriginalEntryTimestamp": "2026-06-17T20:53:46.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918493_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/08e050f3d5d6c1f4b6387b019e98ec08.webp"
"MediaSize" => 343888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-08e050f3d5d6c1f4b6387b019e98ec08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918493_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/4ffe4d1c6292b6bf2a262185d664112f.webp"
"MediaSize" => 316248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-4ffe4d1c6292b6bf2a262185d664112f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918493_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/d146776b85524bc2dc5d1c4b3927185b.webp"
"MediaSize" => 200223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-d146776b85524bc2dc5d1c4b3927185b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918493_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/374b22ce9f28e517dfac950a9c783248.webp"
"MediaSize" => 155118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-374b22ce9f28e517dfac950a9c783248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918493_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/bd3e0df09a02db36236c1521ce7d13d3.webp"
"MediaSize" => 191959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-bd3e0df09a02db36236c1521ce7d13d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918493_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/c35bf4869e54e4b7f309a6967ecb8026.webp"
"MediaSize" => 196631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-c35bf4869e54e4b7f309a6967ecb8026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918493_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/4220d310d6f5006ab6c8d7079d3867eb.webp"
"MediaSize" => 204522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-4220d310d6f5006ab6c8d7079d3867eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918493_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/061328dc44b9e6801108866e5ef829ea.webp"
"MediaSize" => 206802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-061328dc44b9e6801108866e5ef829ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918493_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/3c8a4756a799439dd989eeeedec108de.webp"
"MediaSize" => 168833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-3c8a4756a799439dd989eeeedec108de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918493_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/757fc0c776d373b2b555e5b4d9ca016c.webp"
"MediaSize" => 152335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-757fc0c776d373b2b555e5b4d9ca016c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918493_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/b16d0bff31e372c9d044919dfda88613.webp"
"MediaSize" => 150625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-b16d0bff31e372c9d044919dfda88613.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918493_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/84c78d3c4014216fcfc2fd3b0a552af1.webp"
"MediaSize" => 148548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-84c78d3c4014216fcfc2fd3b0a552af1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918493_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/148f6b566855b8fb2fe0e3c8ac6a5c8b.webp"
"MediaSize" => 120209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-148f6b566855b8fb2fe0e3c8ac6a5c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29918493_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/aef3d6894e70f88e098240558f8972c1.webp"
"MediaSize" => 147761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-aef3d6894e70f88e098240558f8972c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29918493_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/0b2f99d377f7631d7ccfc1233bf5d575.webp"
"MediaSize" => 122874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-0b2f99d377f7631d7ccfc1233bf5d575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29918493_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/02174238acb3a4d0cb2041a0b24c50d4.webp"
"MediaSize" => 174087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-02174238acb3a4d0cb2041a0b24c50d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29918493_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/f4e77a761e9c58f49ce4e99f05a74f2a.webp"
"MediaSize" => 171858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-f4e77a761e9c58f49ce4e99f05a74f2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29918493_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/57826044f50c0c7293ea3776eac1d2e9.webp"
"MediaSize" => 137668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-57826044f50c0c7293ea3776eac1d2e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29918493_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/c3a8b48811012aff3ab57034f7ae8ad4.webp"
"MediaSize" => 139019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-c3a8b48811012aff3ab57034f7ae8ad4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29918493_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/174774d8f13106691c86b1579b10f8cf.webp"
"MediaSize" => 136134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-174774d8f13106691c86b1579b10f8cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29918493_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/284d9e1e510aff8181cfa2bec418f92f.webp"
"MediaSize" => 169432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-284d9e1e510aff8181cfa2bec418f92f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29918493_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/808bcd564c2862852be60a73323938e5.webp"
"MediaSize" => 220048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-808bcd564c2862852be60a73323938e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29918493_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/9b9f916410116bcd167360cbcfdc5648.webp"
"MediaSize" => 182331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-9b9f916410116bcd167360cbcfdc5648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29918493_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/d8dc2cba5ccfbc0b03e42bf0ee877b34.webp"
"MediaSize" => 212552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-d8dc2cba5ccfbc0b03e42bf0ee877b34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29918493_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/e73739285c3001bf49c7e60d334eac4e.webp"
"MediaSize" => 102185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-e73739285c3001bf49c7e60d334eac4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29918493_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/175423043fe73f1ab59f93ed0d94fd39.webp"
"MediaSize" => 400933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-175423043fe73f1ab59f93ed0d94fd39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29918493_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/3a6ec665c067da84d4c2bc55c1f233a3.webp"
"MediaSize" => 351762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-3a6ec665c067da84d4c2bc55c1f233a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29918493_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/b81d70cb3204e5719144e66f7ac37474.webp"
"MediaSize" => 281021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-b81d70cb3204e5719144e66f7ac37474.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29918493_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918493/ab17954b238622360ef249b6613d2f6c.webp"
"MediaSize" => 437863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918493/thumbnail-ab17954b238622360ef249b6613d2f6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458298"
"ResourceRecordKey" => "29918493"
"ModificationTimestamp" => "2026-06-17T20:53:46.45Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918493')"
+"ID": "1540723"
}
]
+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 293273" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24753
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1979013" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24838
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29918493'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25144
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29918493'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29918493' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.885869 43.347193)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1541267"
+post_author: 1
+"ListingKey": "29918739"
+"ListingId": "40840867"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:07Z"
+"RFModificationTimestamp": "2026-06-17T22:46:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1280.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0M9"
+"UnparsedAddress": "174 FELLOWES Crescent, Waterdown, Ontario L8B0M9"
+"Coordinates": array:2 [
0 => -79.8856786
1 => 43.3474298
]
+"Latitude": 43.3474298
+"Longitude": -79.8856786
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Affordable living in the heart of Waterdown! This impeccably maintained and move-in-ready three-bedroom freehold quad townhome offers the perfect blend of comfort, convenience and value. Nestled in a quiet, established neighbourhood surrounded by mature trees, this home offers exceptional access to Highway 6, the QEW, and Highway 403, with Aldershot GO Station just a short drive away. A new stone walkway welcomes you from the two-car driveway into a bright and spacious living room featuring stylish vinyl plank flooring and a cozy gas fireplace. The eat-in kitchen is ideal for everyday living, complete with a gas range and walkout to the private rear yard. The main floor also features a newly renovated two-piece powder room, while all-new (2026) LED lighting and California shutters add a modern touch throughout. Upstairs, the generous primary bedroom boasts dual closets and direct access to the beautifully renovated main bathroom, showcasing a beautiful quartz-topped vanity and updated tub surround. Two additional spacious bedrooms provide plenty of room for family, guests or a home office. The fully finished basement expands your living space with a large family room featuring a second gas fireplace, a convenient two-piece bathroom, and laundry area. Step outside to enjoy the backyard oasis, complete with a stone patio, hot tub, and a Generac generator for added peace of mind year-round. Enjoy all that Waterdown has to offer, including scenic hiking and biking trails, parks, boutique shopping, dining, and a vibrant downtown atmosphere. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:46:16.179310+00:00"
+"Directions": "Parkside Dr to Boulding Ave to Niska Dr to Fellowes Cres"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-17T21:31:22Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:22Z"
+"Stories": "2.0"
+"StreetName": "FELLOWES"
+"StreetNumber": "174"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4565"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1661514751"
"RoomType" => "Laundry room"
"ListingId" => "40840867"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.26Z"
]
1 => array:11 [
"RoomKey" => "1661514752"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840867"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.26Z"
]
2 => array:11 [
"RoomKey" => "1661514753"
"RoomType" => "Recreation room"
"ListingId" => "40840867"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "18'11'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.27Z"
]
3 => array:11 [
"RoomKey" => "1661514754"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840867"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.27Z"
]
4 => array:11 [
"RoomKey" => "1661514755"
"RoomType" => "Bedroom"
"ListingId" => "40840867"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.28Z"
]
5 => array:11 [
"RoomKey" => "1661514756"
"RoomType" => "Bedroom"
"ListingId" => "40840867"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.28Z"
]
6 => array:11 [
"RoomKey" => "1661514757"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840867"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.28Z"
]
7 => array:11 [
"RoomKey" => "1661514760"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840867"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.29Z"
]
8 => array:11 [
"RoomKey" => "1661514765"
"RoomType" => "Living room"
"ListingId" => "40840867"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.29Z"
]
9 => array:11 [
"RoomKey" => "1661514770"
"RoomType" => "Kitchen"
"ListingId" => "40840867"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918739"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:31:22.3Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918739/174-fellowes-crescent-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-2, R6-7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 17.0
+"AboveGradeFinishedArea": 1280
+"OriginalEntryTimestamp": "2026-06-17T21:31:22.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918739_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/7e7284a9fa189f02361bfe360b869e45.webp"
"MediaSize" => 144758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-7e7284a9fa189f02361bfe360b869e45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918739_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/9719e237833ad1f9fdfdbac96a1f7246.webp"
"MediaSize" => 140018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-9719e237833ad1f9fdfdbac96a1f7246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918739_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/26d1c3a2e15c2156577428cc0852efa7.webp"
"MediaSize" => 87433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-26d1c3a2e15c2156577428cc0852efa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918739_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/0249617428c61b0d063505a76b4366d8.webp"
"MediaSize" => 60603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-0249617428c61b0d063505a76b4366d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918739_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/d64e388e6705a1ae9c45cb05bc0630d7.webp"
"MediaSize" => 78008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-d64e388e6705a1ae9c45cb05bc0630d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918739_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/9692be861826bf600be300c32a711483.webp"
"MediaSize" => 85720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-9692be861826bf600be300c32a711483.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918739_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/7a56e15559610da8a420891c9ca77207.webp"
"MediaSize" => 82544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-7a56e15559610da8a420891c9ca77207.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918739_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/9c68cd9f4f509f57807bbb57b402209d.webp"
"MediaSize" => 84319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-9c68cd9f4f509f57807bbb57b402209d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918739_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/83aecfb8751e9e8b7c1d57bf49efd010.webp"
"MediaSize" => 73678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-83aecfb8751e9e8b7c1d57bf49efd010.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918739_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/3fadffd902d17f7b25333b0c39380e66.webp"
"MediaSize" => 67305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-3fadffd902d17f7b25333b0c39380e66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918739_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/381b64bc6a68d0b0ee96d403133bec8a.webp"
"MediaSize" => 65322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-381b64bc6a68d0b0ee96d403133bec8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918739_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/14d2b12c5f135040cc0c5b579bd5a7e9.webp"
"MediaSize" => 65151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-14d2b12c5f135040cc0c5b579bd5a7e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918739_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/51ccc73d3e7cd4327dc493f71d439f25.webp"
"MediaSize" => 48016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-51ccc73d3e7cd4327dc493f71d439f25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29918739_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/a56b877e5afa29b0e010105686e4cbde.webp"
"MediaSize" => 61262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-a56b877e5afa29b0e010105686e4cbde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29918739_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/985b37e672d3812e7b15a89e6e6c72e9.webp"
"MediaSize" => 49634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-985b37e672d3812e7b15a89e6e6c72e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29918739_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/8f09345f5b98b27038a11acd6c656411.webp"
"MediaSize" => 69959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-8f09345f5b98b27038a11acd6c656411.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29918739_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/407b6aea50763e8b8d348406bf233e46.webp"
"MediaSize" => 68384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-407b6aea50763e8b8d348406bf233e46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29918739_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/1614d3fd58ec28a58e674c71b9b89709.webp"
"MediaSize" => 59321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-1614d3fd58ec28a58e674c71b9b89709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29918739_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/2117a15f1396e77bdb8e1808f4d80136.webp"
"MediaSize" => 56272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-2117a15f1396e77bdb8e1808f4d80136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29918739_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/518342a446c10b7d9a88514d5cd1fa96.webp"
"MediaSize" => 56195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-518342a446c10b7d9a88514d5cd1fa96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29918739_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/7508b1eab3b3270982b5222407508dcd.webp"
"MediaSize" => 71697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-7508b1eab3b3270982b5222407508dcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29918739_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/0698523b3a36ad09666292b2879be032.webp"
"MediaSize" => 82868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-0698523b3a36ad09666292b2879be032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29918739_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/857de41c2d72c52759f13ec988c296e4.webp"
"MediaSize" => 68677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-857de41c2d72c52759f13ec988c296e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29918739_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/e9082c271999b6fc0601ac2ce837f51b.webp"
"MediaSize" => 82736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-e9082c271999b6fc0601ac2ce837f51b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29918739_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/33cc6b5763f4017fdb4b08d3535b35d5.webp"
"MediaSize" => 42307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-33cc6b5763f4017fdb4b08d3535b35d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29918739_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/5cdee88e8c193b8ce7263ed5f2299c82.webp"
"MediaSize" => 166672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-5cdee88e8c193b8ce7263ed5f2299c82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29918739_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/0dc1f364c8f94b22cea2e74c0b9ab27b.webp"
"MediaSize" => 147173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-0dc1f364c8f94b22cea2e74c0b9ab27b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29918739_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/afe9c44e64795bf2d00f791db7f9a41a.webp"
"MediaSize" => 119822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-afe9c44e64795bf2d00f791db7f9a41a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29918739_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918739/5c8ef356a3c3574216c6ff0ee9706162.webp"
"MediaSize" => 171790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918739/thumbnail-5c8ef356a3c3574216c6ff0ee9706162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840867"
"ResourceRecordKey" => "29918739"
"ModificationTimestamp" => "2026-06-17T21:31:22.09Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918739')"
+"ID": "1541267"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+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"
…10
]
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/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 [ …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('29917865')"
+"ID": "1540555"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"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 [ …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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913010')"
+"ID": "1537265"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+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"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 176
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]