array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29919855 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23364
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23366
+post_id: "1541830"
+post_author: 1
+"ListingKey": "29919855"
+"ListingId": "40840741"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T01:30:10Z"
+"RFModificationTimestamp": "2026-06-18T01:32:39Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.1
+"LivingArea": 2436.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0M2"
+"UnparsedAddress": "119 BOULDING Avenue, Waterdown, Ontario L8B0M2"
+"Coordinates": array:2 [
0 => -79.8864323
1 => 43.3453597
]
+"Latitude": 43.3453597
+"Longitude": -79.8864323
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this beautifully updated, all-brick detached home in one of Waterdown’s most sought-after, family-friendly neighbourhoods. Offering stylish finishes and a newly created legal secondary suite, this move-in-ready property is perfect for growing families, multigenerational living, or buyers looking for mortgage-helper income. The bright, open-concept main floor is designed for both everyday living and entertaining. It features hardwood flooring, pot lights, spacious living and dining rooms, and a large eat-in kitchen complete with quartz countertops, stainless steel appliances, abundant cabinetry, and an island overlooking the main living areas. Upstairs, you will find three spacious bedrooms, updated bathrooms, and the convenience of a second-floor stacked washer and dryer. The primary suite combines comfort and functionality with a walk-in closet and a beautifully renovated ensuite. The finished, legal basement suite provides outstanding flexibility and income potential, complete with its own kitchen, living area, bedroom, bathroom, laundry, and plenty of storage. Step outside to a beautifully redesigned backyard oasis featuring an expansive stone patio and landscaped green space, perfect for entertaining, relaxing, and enjoying summer evenings with family and friends. Additional highlights include a double-car garage with lots of storage space, six parking spots, an EV charger, and extensive upgrades throughout. Conveniently located just 10 minutes from Aldershot GO Station and Highway 403, this home offers easy access to parks, schools, shopping, and amazing trails. This is a rare opportunity to own a turnkey home with a legal secondary suite in one of Waterdown’s most desirable communities. Simply move in and enjoy. Call today for your private showing! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T01:32:31.558023+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040099"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:01:53Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T01:20:25Z"
+"Stories": "2.0"
+"StreetName": "BOULDING"
+"StreetNumber": "119"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6806.15"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/119_boulding_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1661706967"
"RoomType" => "Foyer"
"ListingId" => "40840741"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.82Z"
]
1 => array:11 [
"RoomKey" => "1661706969"
"RoomType" => "Utility room"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.82Z"
]
2 => array:11 [
"RoomKey" => "1661706971"
"RoomType" => "Cold room"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.83Z"
]
3 => array:11 [
"RoomKey" => "1661706973"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.83Z"
]
4 => array:11 [
"RoomKey" => "1661706975"
"RoomType" => "Laundry room"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.84Z"
]
5 => array:11 [
"RoomKey" => "1661706977"
"RoomType" => "Kitchen"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.84Z"
]
6 => array:11 [
"RoomKey" => "1661706978"
"RoomType" => "Bedroom"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.85Z"
]
7 => array:11 [
"RoomKey" => "1661706980"
"RoomType" => "Living room/Dining room"
"ListingId" => "40840741"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "22'9'' x 26'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.85Z"
]
8 => array:11 [
"RoomKey" => "1661706982"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840741"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.85Z"
]
9 => array:11 [
"RoomKey" => "1661706984"
"RoomType" => "Full bathroom"
"ListingId" => "40840741"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.86Z"
]
10 => array:11 [
"RoomKey" => "1661706986"
"RoomType" => "Bedroom"
"ListingId" => "40840741"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.86Z"
]
11 => array:11 [
"RoomKey" => "1661706988"
"RoomType" => "Bedroom"
"ListingId" => "40840741"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.87Z"
]
12 => array:11 [
"RoomKey" => "1661706991"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840741"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.87Z"
]
13 => array:11 [
"RoomKey" => "1661706994"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840741"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.88Z"
]
14 => array:11 [
"RoomKey" => "1661706995"
"RoomType" => "Dining room"
"ListingId" => "40840741"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.88Z"
]
15 => array:11 [
"RoomKey" => "1661706996"
"RoomType" => "Eat in kitchen"
"ListingId" => "40840741"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.89Z"
]
16 => array:11 [
"RoomKey" => "1661706997"
"RoomType" => "Living room"
"ListingId" => "40840741"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29919855"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T01:20:25.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29919855/119-boulding-avenue-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1-18"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 1661
+"BelowGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-06-18T01:01:52.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1316149"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919855_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/5de3d07c80bdb04eccd9cb4b589a0572.webp"
"MediaSize" => 149835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-5de3d07c80bdb04eccd9cb4b589a0572.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "All Brick Detached House"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919855_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/cbb5dad7c058ed13446a05ff45ebe55b.webp"
"MediaSize" => 179735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-cbb5dad7c058ed13446a05ff45ebe55b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large concrete staircase"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919855_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/7320bdaa943c229e0a262c4ffef2eaa9.webp"
"MediaSize" => 74662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-7320bdaa943c229e0a262c4ffef2eaa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring tile flooring, a wood staircase with dark balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919855_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/1e03562d68c29e91b1969e46b19f2502.webp"
"MediaSize" => 71890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-1e03562d68c29e91b1969e46b19f2502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919855_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/358c6c4c87bb643114755cc103b05d4c.webp"
"MediaSize" => 74703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-358c6c4c87bb643114755cc103b05d4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring an expansive island with a stainless steel sink and touchless faucet, dark wood-finish cabinetry, stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919855_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/d3d765891a63efe608280a1675ae3ac7.webp"
"MediaSize" => 73036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-d3d765891a63efe608280a1675ae3ac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Eat In Kitchen with plenty of cabinetry and SS appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919855_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/74cb222aa21c7c4b348bb6cbdf8a5b6c.webp"
"MediaSize" => 68074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-74cb222aa21c7c4b348bb6cbdf8a5b6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919855_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/eb733a775ffe623a90963cad4bdc0f81.webp"
"MediaSize" => 64731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-eb733a775ffe623a90963cad4bdc0f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring a large island with a quartz countertop and integrated sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919855_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/1c6f6cadce0a367244226edfaaff55bb.webp"
"MediaSize" => 66065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-1c6f6cadce0a367244226edfaaff55bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29919855_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/fbc7e9297c19fb8d70f0f313c3a49ea9.webp"
"MediaSize" => 70377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-fbc7e9297c19fb8d70f0f313c3a49ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, open-concept living and dining"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29919855_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/3f1a0b8028c571f211877a68eac26910.webp"
"MediaSize" => 70096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-3f1a0b8028c571f211877a68eac26910.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29919855_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/050dc5616785ad51092e362d65c7dcaf.webp"
"MediaSize" => 83099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-050dc5616785ad51092e362d65c7dcaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring rich wood-finish flooring, electric fireplace and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29919855_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/c8a94f6b8b395147b1b3d1a376ff3f98.webp"
"MediaSize" => 78810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-c8a94f6b8b395147b1b3d1a376ff3f98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious dining area with wood-finish flooring, recessed lighting, and large windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29919855_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/a6de233e1a736b8f340d1c79b0733026.webp"
"MediaSize" => 77551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-a6de233e1a736b8f340d1c79b0733026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom featuring WIC and 4 piece ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29919855_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/a25c298caf291be7fb26ecbc3561d83f.webp"
"MediaSize" => 56975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-a25c298caf291be7fb26ecbc3561d83f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom featuring WIC and 4 piece ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29919855_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/d54fc22cfb2b3250f98d5e2009a27eb0.webp"
"MediaSize" => 65252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-d54fc22cfb2b3250f98d5e2009a27eb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29919855_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/689a70225f276048ec7caa5503094e3a.webp"
"MediaSize" => 83217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-689a70225f276048ec7caa5503094e3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3rd Bedroom as office"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29919855_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/02df5d6a06e1d964fc94bee7b18c74c4.webp"
"MediaSize" => 63798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-02df5d6a06e1d964fc94bee7b18c74c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29919855_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/4c5f36c087cea271f8d29b3a83e3feeb.webp"
"MediaSize" => 65567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-4c5f36c087cea271f8d29b3a83e3feeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second floor Bathroom/Laundry set up"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29919855_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/efe4bccb9dc07cefde9f982d5178a057.webp"
"MediaSize" => 68044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-efe4bccb9dc07cefde9f982d5178a057.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom featuring WIC and 4 piece ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29919855_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/41015fffee1d1fd6c10e818ac4394251.webp"
"MediaSize" => 34057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-41015fffee1d1fd6c10e818ac4394251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood staircase featuring dark wood newel posts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29919855_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/efd0e493a6f44133671a6736f603329a.webp"
"MediaSize" => 70582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-efd0e493a6f44133671a6736f603329a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Legal Secondary Suite - bright and large, open concept one bedroom apartment"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29919855_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/53feb5937d52902bd2483ed15a0dfd0d.webp"
"MediaSize" => 44664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-53feb5937d52902bd2483ed15a0dfd0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Legal Secondary Suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29919855_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/72be1a540c6490b00ef9f41686af0c53.webp"
"MediaSize" => 56085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-72be1a540c6490b00ef9f41686af0c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept area featuring light colored flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29919855_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/7f507819a63141896477d53b5f2ddee2.webp"
"MediaSize" => 63816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-7f507819a63141896477d53b5f2ddee2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring large window and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29919855_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/3b5a667e94421cda2a66c299f1d73525.webp"
"MediaSize" => 64608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-3b5a667e94421cda2a66c299f1d73525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Secondary Suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29919855_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/c8eac0e77df9d04620b7fc5a2a190531.webp"
"MediaSize" => 51784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-c8eac0e77df9d04620b7fc5a2a190531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29919855_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/e8d5efce147b9344b51041af2ef0e979.webp"
"MediaSize" => 54856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-e8d5efce147b9344b51041af2ef0e979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept secondary suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29919855_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/1ca991a5cc5cd947f71e4c74a42b3032.webp"
"MediaSize" => 67317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-1ca991a5cc5cd947f71e4c74a42b3032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29919855_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/40810d7ee0a08aad96b2353a304aa673.webp"
"MediaSize" => 58255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-40810d7ee0a08aad96b2353a304aa673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright bedroom secondary suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29919855_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/897bdb628cdcd6ce18b725e297558c1b.webp"
"MediaSize" => 133002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-897bdb628cdcd6ce18b725e297558c1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio terrace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29919855_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/a2f807a4f0d2b841f33c88b5543e7d44.webp"
"MediaSize" => 159284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-a2f807a4f0d2b841f33c88b5543e7d44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio terrace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29919855_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/0042b4436cdfe1a9a9e0b0e28bcdeac3.webp"
"MediaSize" => 152997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-0042b4436cdfe1a9a9e0b0e28bcdeac3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard and mature landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29919855_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/4421a2135a1ef5db07f90558b5a2da2b.webp"
"MediaSize" => 144176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-4421a2135a1ef5db07f90558b5a2da2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29919855_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/a8d08092ddca2148d31d1caef76afa93.webp"
"MediaSize" => 182284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-a8d08092ddca2148d31d1caef76afa93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29919855_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/2b93c12ce715a80d5b65a31e8b267f6c.webp"
"MediaSize" => 192127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-2b93c12ce715a80d5b65a31e8b267f6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29919855_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/5918199812faa1a936bde59093316162.webp"
"MediaSize" => 204129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-5918199812faa1a936bde59093316162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard with large patio and wood shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29919855_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/88b96197ef00bb851460f5dfd6255687.webp"
"MediaSize" => 177922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-88b96197ef00bb851460f5dfd6255687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front house"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29919855_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/aed6ec4cf66ae4aa12b2cae97f3a52f5.webp"
"MediaSize" => 208474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-aed6ec4cf66ae4aa12b2cae97f3a52f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29919855_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919855/1e84a271e8a55e9dcf8ef9429f95d9b7.webp"
"MediaSize" => 193125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919855/thumbnail-1e84a271e8a55e9dcf8ef9429f95d9b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840741"
"ResourceRecordKey" => "29919855"
"ModificationTimestamp" => "2026-06-18T01:01:52.76Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919855')"
+"ID": "1541830"
}
]
+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 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2040099" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24861
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29919855'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25178
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29919855'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31524188"
+"ListingKey": "29919855"
+"ListingId": "40840741"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T02:03:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31524188')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29919855' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8864323 43.3453597)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+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"
…6
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918739')"
+"ID": "1541267"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1541136"
+post_author: 1
+"ListingKey": "29918995"
+"ListingId": "X13458554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:55:15Z"
+"RFModificationTimestamp": "2026-06-17T23:02:18Z"
+"ListPrice": 673000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "219 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all down-sizers, right-sizers and anyone looking for a bungalow-sized condo without the upkeep of a house! This sun-filled, end-unit suite in the heart of Waterdown offers 1,320 square feet of one-level living, anchored by a spacious open-concept living and dining area that gives you plenty of room to spread out. Step inside and the ten-foot ceilings paired with oversized south-west facing windows fill the entire open-concept space with natural light. A cozy gas fireplace anchors the living and dining area. Classic wainscoting throughout gives the whole unit a polished, finished look without you having to lift a finger. The kitchen pairs granite countertops with stainless steel appliances, ready for everything from a quick weeknight dinner to hosting friends. Both bedrooms offer comfortable, private space. Semi-ensuite four-piece main bathroom, and a separate guest powder room means visitors have their own space too. In-suite pantry and laundry makes life a little easier. Your own southern exposure open balcony is the perfect spot for a quiet morning coffee. This unit truly sets itself apart with two parking spaces, one underground and one at main level, plus your own exclusive locker on the same floor as your suite, no trekking up or down for storage. Life in this boutique, low-rise community comes with real perks too. The building offers a recreation room, party and meeting room, visitor parking and a barbecue-friendly policy, and pets are welcome with some restrictions. Your maintenance fee covers water, building insurance, parking and common elements. Step outside and you are just steps from restaurants, groceries, parks, the library, transit and everything Waterdown's charming downtown has to offer. This is bungalow-style living with the parking, storage and location to match. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "841"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:41:58.635595+00:00"
+"Directions": "Cross Streets: HAMILTON ST N. ** Directions: PARKSIDE DR TO HAMILTON ST N TO DUNSAD ST E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Balcony"
2 => "Paved yard"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T21:55:06Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:48:45Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5108"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918995/219-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T21:55:05.79Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918995')"
+"ID": "1541136"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918493')"
+"ID": "1540723"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1540586"
+post_author: 1
+"ListingKey": "29918287"
+"ListingId": "40840739"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:07Z"
+"RFModificationTimestamp": "2026-06-17T21:43:46Z"
+"ListPrice": 673000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1298.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 DUNDAS Street E Unit# 219, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896064
1 => 43.329851
]
+"Latitude": 43.329851
+"Longitude": -79.896064
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Calling all down-sizers, right-sizers and anyone looking for a bungalow-sized condo without the upkeep of a house! This sun-filled, end-unit suite in the heart of Waterdown offers 1,320 square feet of one-level living, anchored by a spacious open-concept living and dining area that gives you plenty of room to spread out. Step inside and the ten-foot ceilings paired with oversized south-west facing windows fill the entire open-concept space with natural light. A cozy gas fireplace anchors the living and dining area. Classic wainscoting throughout gives the whole unit a polished, finished look without you having to lift a finger. The kitchen pairs granite countertops with stainless steel appliances, ready for everything from a quick weeknight dinner to hosting friends. Both bedrooms offer comfortable, private space. Semi-ensuite four-piece main bathroom, and a separate guest powder room means visitors have their own space too. In-suite pantry and laundry makes life a little easier. Your own southern exposure open balcony is the perfect spot for a quiet morning coffee. This unit truly sets itself apart with two parking spaces, one underground and one at main level, plus your own exclusive locker on the same floor as your suite, no trekking up or down for storage. Life in this boutique, low-rise community comes with real perks too. The building offers a recreation room, party and meeting room, visitor parking and a barbecue-friendly policy, and pets are welcome with some restrictions. Your maintenance fee covers water, building insurance, parking and common elements. Step outside and you are just steps from restaurants, groceries, parks, the library, transit and everything Waterdown's charming downtown has to offer. This is bungalow-style living with the parking, storage and location to match. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"AssociationFee": "841"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T20:55:07.340654+00:00"
+"Directions": "PARKSIDE DR TO HAMILTON ST N TO DUNSAD ST E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T20:20:58Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5108"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918287/262-dundas-street-e-unit-219-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1298
+"OriginalEntryTimestamp": "2026-06-17T20:20:57.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918287')"
+"ID": "1540586"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23379
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1539021"
+post_author: 1
+"ListingKey": "29915426"
+"ListingId": "X13455236"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:05:08Z"
+"RFModificationTimestamp": "2026-06-17T20:22:33Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J9"
+"UnparsedAddress": "178 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L8B0J9"
+"Coordinates": array:2 [
0 => -79.903351
1 => 43.332329
]
+"Latitude": 43.332329
+"Longitude": -79.903351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Freehold semi-detached home on child-friendly street in desirable Waterdown! This very clean and bright brick home with a covered front porch features an open-concept kitchen and dining area overlooking the family room with a cozy gas fireplace. Walk out to the generous backyard with large decks and plenty of green space for kids and pets to enjoy. The spacious Primary bedroom offers a 4-piece ensuite and a walk-in closet with built-in organizers, complemented by Closets by Design organizers in the foyer and all other bedrooms. Recent upgrades include: appliances, backyard deck, engineered hardwood flooring throughout the upper level, updated stair carpeting, front door blinds, and Kohler toilets with bidet assemblies in both the ensuite and main bathroom. The home is also equipped with an alarm system featuring a doorbell camera, front and rear exterior cameras, garage sensors, and three door sensors for peace of mind. Fantastic location within walking distance to Memorial Park with splash pad, baseball diamonds, and year-round skating. Surrounded by the Greenbelt and close to parks, trails, the farmers' market, schools, YMCA, shopping, restaurants, and everyday amenities. Just 10 minutes to Aldershot GO Station with quick access to the 403, 407, and QEW. This home is a real gem! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Alarm System"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:21:32.702523+00:00"
+"Directions": "Cross Streets: ROCKHAVEN LN AND SEGWUN RD. ** Directions: DUNDAS ST E, HAMILTON ST N, WHITE OAK DR, CHUDLEIGH ST."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972724"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "26.3 x 119.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-17T15:03:10Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T19:59:54Z"
+"Stories": "2.0"
+"StreetName": "Chudleigh"
+"StreetNumber": "178"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5646"
+"VirtualTourURLUnbranded": "https://youriguide.com/178_chudleigh_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915426/178-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-06-17T15:03:10.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1259714"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915426')"
+"ID": "1539021"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914078')"
+"ID": "1537794"
}
]
+success: true
+page_size: 9
+page_count: 23
+count: 203
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]