array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29861030 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1499131"
+post_author: 1
+"ListingKey": "29861030"
+"ListingId": "X13248500"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T16:56:08Z"
+"RFModificationTimestamp": "2026-06-06T17:16:56Z"
+"ListPrice": 1297000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "21 FERN AVENUE, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.895724
1 => 43.332624
]
+"Latitude": 43.332624
+"Longitude": -79.895724
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 21 Fern Avenue - a lovingly maintained, one-owner home that has been thoughtfully customized, upgraded, and impeccably cared for throughout. Designed in collaboration with the original builder, this exceptional residence features soaring cathedral ceilings, rich hardwood flooring, a main-floor office, a spacious family room with a gas fireplace, and elegant formal living and dining rooms with French doors. The bright eat-in kitchen is perfect for family gatherings and offers double wall ovens, a gas cooktop, built-in dishwasher, and ample space for everyday dining. The second level boasts four generously sized bedrooms, including a luxurious primary suite featuring a five-piece ensuite with double sinks, a separate glass shower, and a relaxing step-up soaker tub. Filled with natural light, the additional bedrooms are beautifully appointed. with one currently serving as a comfortable second den. Several custom upgrades were incorporated during construction, adding both character and functionality. The partially finished basement provides a huge recreation room, cold room, workshop, and abundant storage space. Outside, the pride of ownership continues with professional landscaping, an irrigation system, and a patterned double driveway. The private backyard retreat features a deck, gazebo with hydro, cable, and ceiling fan, plus a power awning that creates a comfortable shaded outdoor living space. Notable updates and features include: New double wall ovens Newer furnace Roof with lifetime warranty Electronic air cleaner 200-amp electrical service Two chair lifts New primary bedroom window New kitchen patio door Ideally located within walking distance of shopping, schools, parks, hiking trails, and everyday amenities, with the YMCA just minutes away. Commuters will appreciate the easy highway access and proximity to the Aldershot GO Station. This stunning family home offers space, comfort, quality, and exceptional value. (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Oven"
4 => "Dryer"
5 => "Cooktop"
6 => "Oven - Built-In"
7 => "Furniture"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:38:22.828668+00:00"
+"Directions": "Cross Streets: Hamilton Street and Cedar. ** Directions: Hamilton Street to Cedar to Fern Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423034"
+"ListOfficeKey": "284791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Sloping"
2 => "Gazebo"
3 => "Sump Pump"
]
+"LotSizeDimensions": "47.2 x 131.8 FT ; 47.34 ft x 132.11 ft x 67.71 ft x 123.37"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T16:57:48Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T16:46:24Z"
+"Stories": "2.0"
+"StreetName": "Fern"
+"StreetNumber": "21"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "8217.51"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1653286717"
"RoomType" => "Living room"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.33
"ListingKey" => "29861030"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
1 => array:11 [
"RoomKey" => "1653286718"
"RoomType" => "Bedroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29861030"
"RoomLength" => 4.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
2 => array:11 [
"RoomKey" => "1653286719"
"RoomType" => "Bedroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29861030"
"RoomLength" => 4.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
3 => array:11 [
"RoomKey" => "1653286720"
"RoomType" => "Bathroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 1.85
"ListingKey" => "29861030"
"RoomLength" => 2.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
4 => array:11 [
"RoomKey" => "1653286721"
"RoomType" => "Bedroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 3.53
"ListingKey" => "29861030"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
5 => array:11 [
"RoomKey" => "1653286722"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13248500"
"RoomLevel" => "Basement"
"RoomWidth" => 5.49
"ListingKey" => "29861030"
"RoomLength" => 9.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
6 => array:11 [
"RoomKey" => "1653286723"
"RoomType" => "Furnace"
"ListingId" => "X13248500"
"RoomLevel" => "Basement"
"RoomWidth" => 8.71
"ListingKey" => "29861030"
"RoomLength" => 11.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
7 => array:11 [
"RoomKey" => "1653286724"
"RoomType" => "Dining room"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.66
"ListingKey" => "29861030"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
8 => array:11 [
"RoomKey" => "1653286725"
"RoomType" => "Cold room"
"ListingId" => "X13248500"
"RoomLevel" => "Basement"
"RoomWidth" => 2.06
"ListingKey" => "29861030"
"RoomLength" => 2.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
9 => array:11 [
"RoomKey" => "1653286726"
"RoomType" => "Family room"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.66
"ListingKey" => "29861030"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
10 => array:11 [
"RoomKey" => "1653286727"
"RoomType" => "Kitchen"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.25
"ListingKey" => "29861030"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
11 => array:11 [
"RoomKey" => "1653286728"
"RoomType" => "Eating area"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.97
"ListingKey" => "29861030"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.01Z"
]
12 => array:11 [
"RoomKey" => "1653286729"
"RoomType" => "Office"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.38
"ListingKey" => "29861030"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.02Z"
]
13 => array:11 [
"RoomKey" => "1653286730"
"RoomType" => "Bathroom"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.91
"ListingKey" => "29861030"
"RoomLength" => 2.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.02Z"
]
14 => array:11 [
"RoomKey" => "1653286731"
"RoomType" => "Laundry room"
"ListingId" => "X13248500"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.98
"ListingKey" => "29861030"
"RoomLength" => 2.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.02Z"
]
15 => array:11 [
"RoomKey" => "1653286732"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 4.6
"ListingKey" => "29861030"
"RoomLength" => 6.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.02Z"
]
16 => array:11 [
"RoomKey" => "1653286733"
"RoomType" => "Bathroom"
"ListingId" => "X13248500"
"RoomLevel" => "Second level"
"RoomWidth" => 2.62
"ListingKey" => "29861030"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T16:46:24.02Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861030/21-fern-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1423830"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285730"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.2
+"OriginalEntryTimestamp": "2026-06-05T16:57:48.14Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1071641"
+"ListOfficeNationalAssociationId": "1344890"
+"CoListAgentNationalAssociationId": "1071225"
+"CoListOfficeNationalAssociationId": "1353943"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29861030_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/d6be2411a51d60971b11e6e83e7f57ca.webp"
"MediaSize" => 475729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-d6be2411a51d60971b11e6e83e7f57ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29861030_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/d6a130f957697cc96df21b77da27be56.webp"
"MediaSize" => 428397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-d6a130f957697cc96df21b77da27be56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29861030_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/0856d308719f0789ba379dfcb03e0e6e.webp"
"MediaSize" => 468242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-0856d308719f0789ba379dfcb03e0e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29861030_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/e9add12e0df0a261c14029e066a4019e.webp"
"MediaSize" => 225343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-e9add12e0df0a261c14029e066a4019e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29861030_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/640401b3f5d4a4c6425314912b0d735f.webp"
"MediaSize" => 205401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-640401b3f5d4a4c6425314912b0d735f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29861030_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/38986cec737fc8b2e1a370d20f6e0689.webp"
"MediaSize" => 177687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-38986cec737fc8b2e1a370d20f6e0689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29861030_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/7c04f56d91a52cf6411c2d580b39b9e9.webp"
"MediaSize" => 160962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-7c04f56d91a52cf6411c2d580b39b9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29861030_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/7b51ae7198f2bc2626c4112c702f83d4.webp"
"MediaSize" => 184651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-7b51ae7198f2bc2626c4112c702f83d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29861030_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/9c97ad2edbe61de52d1978c422880f91.webp"
"MediaSize" => 185537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-9c97ad2edbe61de52d1978c422880f91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29861030_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/20aa07c67efd008fc57e1a85e4186fc3.webp"
"MediaSize" => 197971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-20aa07c67efd008fc57e1a85e4186fc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29861030_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/96cf1a22412c31cc428017a5b6c26d21.webp"
"MediaSize" => 256436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-96cf1a22412c31cc428017a5b6c26d21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29861030_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/50cab3a10677f41b0d2433f89f6309df.webp"
"MediaSize" => 189465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-50cab3a10677f41b0d2433f89f6309df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29861030_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/29923a2805b8114490bfe148fddff15a.webp"
"MediaSize" => 224942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-29923a2805b8114490bfe148fddff15a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29861030_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/b8a7df42b6b699e0f76a65de5e62e864.webp"
"MediaSize" => 181896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-b8a7df42b6b699e0f76a65de5e62e864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29861030_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/44c8c08cbcef89696a3127d370c60ad7.webp"
"MediaSize" => 257125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-44c8c08cbcef89696a3127d370c60ad7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29861030_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/efe66bdc9058c9889de775133c93a967.webp"
"MediaSize" => 259680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-efe66bdc9058c9889de775133c93a967.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29861030_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/73bd6a1db4a8cc5c8de354bad5e3ed85.webp"
"MediaSize" => 206820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-73bd6a1db4a8cc5c8de354bad5e3ed85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29861030_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/6f2ec526334176ae94529ad15b4882fb.webp"
"MediaSize" => 149774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-6f2ec526334176ae94529ad15b4882fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29861030_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/3d113c79e3cd1d00bf30ec5c45d70ebd.webp"
"MediaSize" => 112397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-3d113c79e3cd1d00bf30ec5c45d70ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29861030_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/9eb617e7a71c71185cc4db21cbda3f40.webp"
"MediaSize" => 179516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-9eb617e7a71c71185cc4db21cbda3f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29861030_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/495f7b566fc7ee453c52bec3e5062880.webp"
"MediaSize" => 149494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-495f7b566fc7ee453c52bec3e5062880.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29861030_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/6bd34b2065310353cb1393ebef639a4a.webp"
"MediaSize" => 147748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-6bd34b2065310353cb1393ebef639a4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29861030_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/29359191c50f49720f16bb5d18473d67.webp"
"MediaSize" => 217682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-29359191c50f49720f16bb5d18473d67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29861030_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/0bdef212e2a9dc06f2eec8bdf8ca6fef.webp"
"MediaSize" => 208126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-0bdef212e2a9dc06f2eec8bdf8ca6fef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29861030_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/c35d091e8239dbd6ab654d5461282583.webp"
"MediaSize" => 163454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-c35d091e8239dbd6ab654d5461282583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29861030_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/d2140d8a36f31a3181ca3b39cde188b9.webp"
"MediaSize" => 151637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-d2140d8a36f31a3181ca3b39cde188b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29861030_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/a507fee3fe78426b7913f263442fe63a.webp"
"MediaSize" => 170499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-a507fee3fe78426b7913f263442fe63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29861030_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/83fc180cc25deffe597b397ce1e4615c.webp"
"MediaSize" => 134755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-83fc180cc25deffe597b397ce1e4615c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29861030_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/e946c06adc6e54ae9671da8ab79654be.webp"
"MediaSize" => 193831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-e946c06adc6e54ae9671da8ab79654be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29861030_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/e03c94ce669e699e15ebf349a2240dc3.webp"
"MediaSize" => 317295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-e03c94ce669e699e15ebf349a2240dc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29861030_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/ac4da4c5c2fbdbd411d86c0db31e98c2.webp"
"MediaSize" => 426038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-ac4da4c5c2fbdbd411d86c0db31e98c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29861030_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/c7a627f40ed12d1763e15a01d8ec4ae7.webp"
"MediaSize" => 488435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-c7a627f40ed12d1763e15a01d8ec4ae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29861030_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/a4b1da3c47f9e69228ccf2a099df10a2.webp"
"MediaSize" => 442177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-a4b1da3c47f9e69228ccf2a099df10a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29861030_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/239b30cba1ec6fd8d3ea77b02f96d817.webp"
"MediaSize" => 366771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-239b30cba1ec6fd8d3ea77b02f96d817.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29861030_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29861030/eb1d123b2773b54341ee0c8c2ee38948.webp"
"MediaSize" => 537992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29861030/thumbnail-eb1d123b2773b54341ee0c8c2ee38948.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13248500"
"ResourceRecordKey" => "29861030"
"ModificationTimestamp" => "2026-06-05T16:57:48.15Z"
]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861030')"
+"ID": "1499131"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284791" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24856
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1423034" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24829
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29861030'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25163
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29861030'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25179
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29861030' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.895724 43.332624)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25232
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1546295"
+post_author: 1
+"ListingKey": "29925650"
+"ListingId": "X13464400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:30:05Z"
+"RFModificationTimestamp": "2026-06-19T01:17:17Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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 (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-19T01:17:14.633197+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T22:21:55Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:21:55Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4363"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1662492348"
"RoomType" => "Bedroom"
"ListingId" => "X13464400"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29925650"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T22:21:55.26Z"
]
1 => array:11 [
"RoomKey" => "1662492349"
"RoomType" => "Great room"
"ListingId" => "X13464400"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29925650"
"RoomLength" => 6.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T22:21:55.26Z"
]
2 => array:11 [
"RoomKey" => "1662492350"
"RoomType" => "Kitchen"
"ListingId" => "X13464400"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29925650"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T22:21:55.27Z"
]
3 => array:11 [
"RoomKey" => "1662492351"
"RoomType" => "Den"
"ListingId" => "X13464400"
"RoomLevel" => "Main level"
"RoomWidth" => 2.54
"ListingKey" => "29925650"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T22:21:55.27Z"
]
4 => array:11 [
"RoomKey" => "1662492352"
"RoomType" => "Den"
"ListingId" => "X13464400"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29925650"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T22:21:55.28Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925650/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T22:21:55.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29925650_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/66a6340c3de908472f9176556eff85f3.webp"
"MediaSize" => 234115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-66a6340c3de908472f9176556eff85f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29925650_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/287e43e13a06a8a77908dbd60118b993.webp"
"MediaSize" => 138168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-287e43e13a06a8a77908dbd60118b993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29925650_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/ef62df273343eb455b490636b65b52fe.webp"
"MediaSize" => 102928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-ef62df273343eb455b490636b65b52fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29925650_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/82773b7d04da27638f9f3737fce1e691.webp"
"MediaSize" => 105918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-82773b7d04da27638f9f3737fce1e691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29925650_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/1696e0fdee0c5fc00bc2893ade5a22fd.webp"
"MediaSize" => 95365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-1696e0fdee0c5fc00bc2893ade5a22fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29925650_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/87c48f2f6ea85204a44a8210293a464c.webp"
"MediaSize" => 100782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-87c48f2f6ea85204a44a8210293a464c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29925650_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/3bec9b70b04122d034b7f580db4ef302.webp"
"MediaSize" => 103936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-3bec9b70b04122d034b7f580db4ef302.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29925650_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/d0c326d72fefb5e2b23d404411ddce47.webp"
"MediaSize" => 96575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-d0c326d72fefb5e2b23d404411ddce47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29925650_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925650/b243caa108e6fa2d04eb11246acbfff4.webp"
"MediaSize" => 78125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925650/thumbnail-b243caa108e6fa2d04eb11246acbfff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464400"
"ResourceRecordKey" => "29925650"
"ModificationTimestamp" => "2026-06-18T22:21:55.1Z"
]
9 => array:13 [
"Order" => 10
…12
]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925650')"
+"ID": "1546295"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1546054"
+post_author: 1
+"ListingKey": "29925894"
+"ListingId": "40840606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:00:08Z"
+"RFModificationTimestamp": "2026-06-19T01:45:59Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1439.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 37, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9076836
1 => 43.3385672
]
+"Latitude": 43.3385672
+"Longitude": -79.9076836
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today’s busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you’re purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown’s most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:09:05.929659+00:00"
+"Directions": "HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525003"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T22:52:08Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T00:50:34Z"
+"Stories": "3.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4919"
+"VirtualTourURLUnbranded": "https://youtu.be/YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29925894/54-nisbet-boulevard-unit-37-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1439
+"OriginalEntryTimestamp": "2026-06-18T22:51:09.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1063779"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925894')"
+"ID": "1546054"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1545200"
+post_author: 1
+"ListingKey": "29924409"
+"ListingId": "40840763"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:05:04Z"
+"RFModificationTimestamp": "2026-06-18T20:24:46Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2815.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L8B0G3"
+"UnparsedAddress": "34 HOWARD Boulevard, Burlington, Ontario L8B0G3"
+"Coordinates": array:2 [
0 => -79.8940271
1 => 43.3276387
]
+"Latitude": 43.3276387
+"Longitude": -79.8940271
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this wonderful family home in one of Waterdown’s most sought-after neighborhoods! Beautifully landscaped gardens and an inviting flagstone staircase create exceptional curb appeal from the moment you arrive. Inside, you'll find gorgeous hardwood floors, a warm and welcoming family room with a gas fireplace, and a spacious kitchen offering abundant cabinetry, pantry storage, and plenty of room for family gatherings. The beautifully updated bathrooms add a touch of modern elegance, while the versatile lower level features a separate exterior entrance—ideal for an in-law suite, teenage retreat, or home office. Backing onto a tranquil ravine, there is a walk out from the main level to the private backyard which boasts a newer two-tier deck, perfect for entertaining or simply enjoying the natural surroundings. Conveniently located close to shopping, cafés, restaurants, pubs, walking trails, and the scenic Smokey Hollow Waterfall, this home also offers easy access to the Burlington GO Station, Highway 6, Highway 403, and Highway 407, making commuting a breeze. A perfect blend of comfort, convenience, and lifestyle—this is a home you won’t want to miss! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"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-18T20:24:33.992597+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:01Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:51:01Z"
+"Stories": "2.0"
+"StreetName": "HOWARD"
+"StreetNumber": "34"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8743"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70321"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924409/34-howard-boulevard-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CM, R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 79.0
+"AboveGradeFinishedArea": 2025
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-18T19:51:01.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064859"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924409')"
+"ID": "1545200"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1544376"
+post_author: 1
+"ListingKey": "29922718"
+"ListingId": "X13462164"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:01Z"
+"RFModificationTimestamp": "2026-06-18T18:33:13Z"
+"ListPrice": 1750000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "184 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.902542
1 => 43.324431
]
+"Latitude": 43.324431
+"Longitude": -79.902542
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Discover luxury and lifestyle in this beautifully crafter custom bungalow, situated on animpressive .45 acre lot just minutes from downtown Waterdown. Exterior features the following:full house generator, sprinkler system, 2 hammer head paved parking spaces, landscaped gardenswith rockery, front light pillars. large trees for privacy. wrought iron front porch withdouble custom doors with side lights and separate door for the lower level also. 2.5 car garagewith work bench. fully fenced yard. flag stone patio and stairs, garden shed, fire pit. Theupper level with 3 bedroom/2 ensuites and powder room. sunken family room overlooking rearflagstone/gardens and awning. Separate office, dining room and garden room with an open conceptfloor plan. Along with the lower level being wonderful for in-laws or multi generation familywith its own walk out patio to walk up yard. The home has 2 laundry rooms, 2 full stainlessappliance kitchens with islands.Please note that the listing agent is related to the seller. (id:62783)"
+"Appliances": array:20 [
0 => "All"
1 => "Washer"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Range"
9 => "Oven"
10 => "Dryer"
11 => "Microwave"
12 => "Freezer"
13 => "Oven - Built-In"
14 => "Water Treatment"
15 => "Window Coverings"
16 => "Garage door opener remote(s)"
17 => "Water Heater - Tankless"
18 => "Water Heater"
19 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:8 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "Walk-up"
5 => "N/A"
6 => "N/A"
7 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:33:08.954267+00:00"
+"Directions": "Cross Streets: Dundas Street East & Riley. ** Directions: Hwy 6 & Dundas Street East to the 3rd stoplightin intersection."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992922"
+"ListOfficeKey": "47632"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Lighting"
2 => "Wheelchair access"
3 => "Carpet Free"
4 => "Sump Pump"
5 => "In-Law Suite"
]
+"LotSizeDimensions": "105.4 x 184.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-18T16:56:27Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:56:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "184"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10000"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29922718/184-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 105.4
+"OriginalEntryTimestamp": "2026-06-18T16:56:27.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276178"
+"ListOfficeNationalAssociationId": "1001102"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922718')"
+"ID": "1544376"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1542841"
+post_author: 1
+"ListingKey": "29921322"
+"ListingId": "40841038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:00:08Z"
+"RFModificationTimestamp": "2026-06-18T15:45:26Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1663.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H6"
+"UnparsedAddress": "46 HARNESWORTH Crescent, Waterdown, Ontario L0R2H6"
+"Coordinates": array:2 [
0 => -79.9053216
1 => 43.3341711
]
+"Latitude": 43.3341711
+"Longitude": -79.9053216
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**4 bedrooms, 3 washrooms, finished basement and a renovated kitchen! Welcome to 46 Harnesworth Crescent, located in one of Waterdown's most desirable neighbourhoods. This lovely semi-detached home features a beautifully upgraded custom kitchen, a renovated primary ensuite, an outdoor gas line for BBQs, and an exposed aggregate driveway and backyard patio pad. Boasting a fantastic layout, this home offers four generously sized bedrooms and a professionally finished basement, providing the perfect extra space for family living, entertaining, or a home office setup. Ideally situated within walking distance to grocery stores, plazas, and parks, and just minutes from the YMCA and schools, this home is perfectly located for growing families and active lifestyles. Set in a wonderful, family-friendly neighbourhood, this is an exceptional opportunity to enjoy comfort, convenience, and community all in one place. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:45:22.122250+00:00"
+"Directions": "Hamilton to Rockhaven to Harnesworth"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946034"
+"ListOfficeKey": "78242"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:52:51Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:52:51Z"
+"Stories": "2.0"
+"StreetName": "HARNESWORTH"
+"StreetNumber": "46"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4971.97"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_harnesworth_crescent_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921322/46-harnesworth-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1663
+"OriginalEntryTimestamp": "2026-06-18T14:52:50.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303132"
+"ListOfficeNationalAssociationId": "1137129"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921322')"
+"ID": "1542841"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1542462"
+post_author: 1
+"ListingKey": "29601678"
+"ListingId": "X12996134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T12:05:01Z"
+"RFModificationTimestamp": "2026-06-18T12:08:56Z"
+"ListPrice": 1189000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0M5"
+"UnparsedAddress": "40 BROOKHURST CRESCENT, Hamilton (Waterdown), Ontario L8B0M5"
+"Coordinates": array:2 [
0 => -79.8889313
1 => 43.3454208
]
+"Latitude": 43.3454208
+"Longitude": -79.8889313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 40 Brookhurst Crescent - an exceptional detached home nestled in one of Waterdown's most sought-after communities. Once you discover this neighbourhood, you truly won't want to leave. Known for its quiet, family-friendly atmosphere and outstanding walkability, you're just steps to local shops, restaurants, and everyday conveniences, with easy access to major highways for a seamless commute. This beautifully maintained 4-bedroom, 4-bathroom home offers a versatile layout designed for both comfort and functionality. The main level features soaring cathedral ceilings and rich hardwood flooring throughout, creating a bright and inviting space. Enjoy an open-concept living and dining area centered around a cozy gas fireplace, perfect for entertaining or relaxing evenings at home. The well-appointed eat-in kitchen offers ample cabinetry and workspace, with a convenient walk-out to the backyard. Two bedrooms and a 4-piece bathroom complete this level, offering ideal flexibility for families, guests, or a home office setup. Upstairs, you'll find two additional generously sized bedrooms and another 4-piece bathroom, providing privacy and separation for growing families. The fully finished basement expands your living space with a large recreation room, laundry area, and plenty of storage options - perfect for hobbies, a home gym, or movie nights. Additional highlights include a 2-car garage and double driveway parking, ensuring ample space for vehicles and guests. A rare opportunity to own a thoughtfully designed home in a welcoming, established neighbourhood - this is one you won't want to miss. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T12:08:50.429061+00:00"
+"Directions": "Cross Streets: Laurendale Ave. ** Directions: Parkside Dr to Boulding Ave to Laurendale Ave to Brookhurst Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043570"
+"ListOfficeKey": "300091"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 107.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-14T16:26:06Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T11:55:23Z"
+"Stories": "2.0"
+"StreetName": "Brookhurst"
+"StreetNumber": "40"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7061.44"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/40_brookhurst_crescent_hamilton_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": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29601678/40-brookhurst-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-18"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-04-14T16:26:06.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1319401"
+"ListOfficeNationalAssociationId": "1482797"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 65
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29601678')"
+"ID": "1542462"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1542112"
+post_author: 1
+"ListingKey": "29920202"
+"ListingId": "X13459544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T13:30:10Z"
+"RFModificationTimestamp": "2026-06-18T13:42:26Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0M2"
+"UnparsedAddress": "119 BOULDING AVENUE, Hamilton (Waterdown), Ontario L8B0M2"
+"Coordinates": array:2 [
0 => -79.88651
1 => 43.345316
]
+"Latitude": 43.345316
+"Longitude": -79.88651
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Full"
1 => "Apartment in basement"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T04:33:20.723539+00:00"
+"Directions": "Cross Streets: Parkside & Boulding. ** Directions: Parkside Dr, turn on Boulding."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213297"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "40.8 x 110.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T03:41:53Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T13:19:14Z"
+"Stories": "2.0"
+"StreetName": "Boulding"
+"StreetNumber": "119"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6806.15"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/119_boulding_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920202/119-boulding-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.9
+"OriginalEntryTimestamp": "2026-06-18T03:41:53.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459157"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920202')"
+"ID": "1542112"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1541830"
+post_author: 1
+"ListingKey": "29919855"
+"ListingId": "40840741"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T12:00:03Z"
+"RFModificationTimestamp": "2026-06-18T12:02:55Z"
+"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:62650)"
+"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-18T11:50:17Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"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 [ …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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919855')"
+"ID": "1541830"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+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 [ …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]
]
+"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 [ …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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918739')"
+"ID": "1541267"
}
]
+success: true
+page_size: 9
+page_count: 27
+count: 236
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]