array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29811778 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1464285"
+post_author: 1
+"ListingKey": "29811778"
+"ListingId": "X13187488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:30:06Z"
+"RFModificationTimestamp": "2026-06-15T19:40:13Z"
+"ListPrice": 3380000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Ainslie Wood)"
+"PostalCode": "L8B1H1"
+"UnparsedAddress": "712 ROBSON ROAD, Hamilton (Ainslie Wood), Ontario L8B1H1"
+"Coordinates": array:2 [
0 => -79.898312
1 => 43.356888
]
+"Latitude": 43.356888
+"Longitude": -79.898312
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A truly magical property ! Strategically positioned to capture the woodland views & natural sunlight in the house & on the pool this custom built, meticulously maintained home on the outskirts of Waterdown is a family's dream come true. Whether playing games on the sprawling lawn, reading in the gazebo, lounging by the pool, hiking through your own woods or finishing your day with smores by the campfire, this home is sure to suit a growing family. Entertain in the formal living room, dining room with recessed buffet, cozy up by the fire in the family room or take in the views in the sun filled sunroom and count the endless number of bird species always at the feeder. Enjoy gathering around the island in the spacious kitchen with ample cabinets & a desk area. Enjoy a restful primary suite and 3 additional bedrooms in the main house. Work from home with a separate private entrance to office. Also there is a 3pce bath conveniently located to serve the main floor & pool guests adjacent to the laundry room entrance and access to the loft/ office with kitchen area that can easily accommodate a nanny/ in-law /teenager suite and has its own heat pump for heating & cooling. The lower level has an excellent workshop & is otherwise an open canvas for whatever your heart desires. This is where dreams do come true. Luxury Certified. (id:62783)"
+"Appliances": array:10 [
0 => "Refrigerator"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Microwave"
6 => "Water Treatment"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:7 [
0 => "Partially finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-05-27T16:49:53.175266+00:00"
+"Directions": "Cross Streets: Parkside Dr. 5th Concession Rd. ** Directions: Parkside Dr. North on Robson Rd. Just north of Connon Nursery on the east side."
+"Electric": "Generator"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
3 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Lighting"
4 => "Gazebo"
5 => "Sump Pump"
]
+"LotSizeDimensions": "1503.2 x 725.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T15:59:12Z"
+"PhotosCount": 49
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:20:36Z"
+"Stories": "2.0"
+"StreetName": "Robson"
+"StreetNumber": "712"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "8325.46"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"ListAOR": "Toronto"
+"CityRegion": "Ainslie Wood"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29811778/712-robson-road-hamilton-ainslie-wood-ainslie-wood"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 1503.2
+"OriginalEntryTimestamp": "2026-05-27T15:59:12.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29811778_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b94d1cfc9c0c9b6b55a557f7f9e95443.webp"
"MediaSize" => 194558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b94d1cfc9c0c9b6b55a557f7f9e95443.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29811778_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/9cab78a184d714554db2fe2d42fa0a63.webp"
"MediaSize" => 187906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-9cab78a184d714554db2fe2d42fa0a63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29811778_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/7f38599e5a20674c0ef1ac0165f29a75.webp"
"MediaSize" => 178715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-7f38599e5a20674c0ef1ac0165f29a75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29811778_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/9374be00e95d401c356aa3a38f6764c0.webp"
"MediaSize" => 131465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-9374be00e95d401c356aa3a38f6764c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29811778_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/f206e0396a64f4f1b8f9ebab1adc3c67.webp"
"MediaSize" => 209679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-f206e0396a64f4f1b8f9ebab1adc3c67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29811778_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/a7b418a115a554de5a22e8c17078b985.webp"
"MediaSize" => 94814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-a7b418a115a554de5a22e8c17078b985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29811778_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/7c720ee815622b11579c3e965fc85055.webp"
"MediaSize" => 81526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-7c720ee815622b11579c3e965fc85055.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29811778_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/68b21212bf324046610f109764883b96.webp"
"MediaSize" => 82214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-68b21212bf324046610f109764883b96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29811778_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/eed0fc3eedae09d946b231bd53794b61.webp"
"MediaSize" => 86597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-eed0fc3eedae09d946b231bd53794b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29811778_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/fd48195f096bb9dbc1d96b665d6fe1f6.webp"
"MediaSize" => 86463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-fd48195f096bb9dbc1d96b665d6fe1f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29811778_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/079311ab4638b1fc0ef7600e07ad07ae.webp"
"MediaSize" => 88244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-079311ab4638b1fc0ef7600e07ad07ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29811778_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/eae6b50704ff7d30d6c1995aba09ba91.webp"
"MediaSize" => 86866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-eae6b50704ff7d30d6c1995aba09ba91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29811778_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/94a75e43bc75b9eba20c8446fa4be5bb.webp"
"MediaSize" => 104441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-94a75e43bc75b9eba20c8446fa4be5bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29811778_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b2ebdc4b4be371e6ba7c483a1bffe25e.webp"
"MediaSize" => 75862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b2ebdc4b4be371e6ba7c483a1bffe25e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29811778_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b1c8124babd1a4e3b41d5ec13af9ce13.webp"
"MediaSize" => 90549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b1c8124babd1a4e3b41d5ec13af9ce13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29811778_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/f2421c8ae11a0b3a9b3d89bcf2d7f11e.webp"
"MediaSize" => 155938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-f2421c8ae11a0b3a9b3d89bcf2d7f11e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29811778_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/d3c0dc525d03d358022d7a87117cabbf.webp"
"MediaSize" => 107636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-d3c0dc525d03d358022d7a87117cabbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29811778_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/26db551db2277af576bc2ef448e907b8.webp"
"MediaSize" => 73994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-26db551db2277af576bc2ef448e907b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29811778_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/11222f2b3ed63c0335177d9587d04ed1.webp"
"MediaSize" => 86411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-11222f2b3ed63c0335177d9587d04ed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29811778_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b5f1ddd59439d2c808c610ec364a376f.webp"
"MediaSize" => 83238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b5f1ddd59439d2c808c610ec364a376f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29811778_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/64aba56a1b81dda07223f76e2a6cb45d.webp"
"MediaSize" => 82634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-64aba56a1b81dda07223f76e2a6cb45d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29811778_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/164b2ae66521b69242419c85997d2241.webp"
"MediaSize" => 100931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-164b2ae66521b69242419c85997d2241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29811778_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/bf256c6db688f5fcee22214fb0805abe.webp"
"MediaSize" => 100820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-bf256c6db688f5fcee22214fb0805abe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29811778_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/2fca5759c6e91380a6f0b2661c957846.webp"
"MediaSize" => 130908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-2fca5759c6e91380a6f0b2661c957846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29811778_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/706bd1222124b354d5d955d42ffbfc68.webp"
"MediaSize" => 69656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-706bd1222124b354d5d955d42ffbfc68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29811778_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/5f41f3a7b07e06b104f234b598694ab6.webp"
"MediaSize" => 78174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-5f41f3a7b07e06b104f234b598694ab6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29811778_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/3bd6ea9b7a06a6fe7e85961b9adab6c8.webp"
"MediaSize" => 72983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-3bd6ea9b7a06a6fe7e85961b9adab6c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29811778_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/239433f7a26dd25e42431eaca4febdc9.webp"
"MediaSize" => 59002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-239433f7a26dd25e42431eaca4febdc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29811778_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/67f2eb09c80e9a9602ee99c4923d0dde.webp"
"MediaSize" => 66235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-67f2eb09c80e9a9602ee99c4923d0dde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29811778_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/d3e683e1d74e5179b85be15426004d69.webp"
"MediaSize" => 65798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-d3e683e1d74e5179b85be15426004d69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29811778_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/9f3a2b40cbe969d0a73dd87cbcf5f42f.webp"
"MediaSize" => 91897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-9f3a2b40cbe969d0a73dd87cbcf5f42f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29811778_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/1d46adc63c17d32a36770894e599d4ea.webp"
"MediaSize" => 79468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-1d46adc63c17d32a36770894e599d4ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29811778_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/6cb45c9db9fe56e2b4490598f8bf028e.webp"
"MediaSize" => 163258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-6cb45c9db9fe56e2b4490598f8bf028e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29811778_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/66f28c7e6c8906f6c0b9aeb61dbf384f.webp"
"MediaSize" => 165227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-66f28c7e6c8906f6c0b9aeb61dbf384f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29811778_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/7a7c4f6e5d7fca553e6e9e8b7acfe37a.webp"
"MediaSize" => 202176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-7a7c4f6e5d7fca553e6e9e8b7acfe37a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29811778_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/ff4e24cb27bf97e4f458dd43635fbb80.webp"
"MediaSize" => 202176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-ff4e24cb27bf97e4f458dd43635fbb80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29811778_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/df9811b60934de15922b43616a877fb2.webp"
"MediaSize" => 133756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-df9811b60934de15922b43616a877fb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29811778_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/35598ebaf52079fcc485da91999ac948.webp"
"MediaSize" => 168905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-35598ebaf52079fcc485da91999ac948.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29811778_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/ab07bd4714407d7d4ef9a8bdd19a3737.webp"
"MediaSize" => 204414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-ab07bd4714407d7d4ef9a8bdd19a3737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29811778_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/d196d6167da77a5ea22e5fc02272e596.webp"
"MediaSize" => 193717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-d196d6167da77a5ea22e5fc02272e596.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29811778_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b9017dfd376344433a8987952daede8d.webp"
"MediaSize" => 129726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b9017dfd376344433a8987952daede8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29811778_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/5e4495f66fc65921a4cb6a658d23516d.webp"
"MediaSize" => 132591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-5e4495f66fc65921a4cb6a658d23516d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29811778_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/2cdad137a5627ffbdc98fdd5bcbdb363.webp"
"MediaSize" => 171803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-2cdad137a5627ffbdc98fdd5bcbdb363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29811778_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/796ff907d405bcdb508f50271ed265d6.webp"
"MediaSize" => 162741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-796ff907d405bcdb508f50271ed265d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29811778_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/569de9592407c03ebc86472febb7b843.webp"
"MediaSize" => 162741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-569de9592407c03ebc86472febb7b843.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29811778_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/1d18317e3b4bd58911854bc3f34294a5.webp"
"MediaSize" => 170128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-1d18317e3b4bd58911854bc3f34294a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29811778_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/68b241e3f97d03816e59c5656fe7a0d6.webp"
"MediaSize" => 28712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-68b241e3f97d03816e59c5656fe7a0d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29811778_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/a369005cde4be1461a00f6fcbbdda9fe.webp"
"MediaSize" => 17952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-a369005cde4be1461a00f6fcbbdda9fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29811778_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29811778/b570162a926e6ce6167488f41816b9e3.webp"
"MediaSize" => 27075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29811778/thumbnail-b570162a926e6ce6167488f41816b9e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13187488"
"ResourceRecordKey" => "29811778"
"ModificationTimestamp" => "2026-05-27T15:59:12.25Z"
]
]
+"DaysOnMarket": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29811778')"
+"ID": "1464285"
}
]
+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 266588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+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 2259210" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29811778'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29811778'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25265
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29811778' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.898312 43.356888)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25338
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+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 [
"RoomKey" => "1661930131"
"RoomType" => "Bedroom 3"
"ListingId" => "X12996134"
"RoomLevel" => "Second level"
"RoomWidth" => 4.49
"ListingKey" => "29601678"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.37Z"
]
1 => array:11 [
"RoomKey" => "1661930132"
"RoomType" => "Bathroom"
"ListingId" => "X12996134"
"RoomLevel" => "Second level"
"RoomWidth" => 2.43
"ListingKey" => "29601678"
"RoomLength" => 2.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.38Z"
]
2 => array:11 [
"RoomKey" => "1661930133"
"RoomType" => "Bedroom 4"
"ListingId" => "X12996134"
"RoomLevel" => "Second level"
"RoomWidth" => 4.5
"ListingKey" => "29601678"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.39Z"
]
3 => array:11 [
"RoomKey" => "1661930134"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12996134"
"RoomLevel" => "Basement"
"RoomWidth" => 7.02
"ListingKey" => "29601678"
"RoomLength" => 8.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.4Z"
]
4 => array:11 [
"RoomKey" => "1661930135"
"RoomType" => "Utility room"
"ListingId" => "X12996134"
"RoomLevel" => "Basement"
"RoomWidth" => 3.42
"ListingKey" => "29601678"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.4Z"
]
5 => array:11 [
"RoomKey" => "1661930136"
"RoomType" => "Bathroom"
"ListingId" => "X12996134"
"RoomLevel" => "Basement"
"RoomWidth" => 1.94
"ListingKey" => "29601678"
"RoomLength" => 1.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.4Z"
]
6 => array:11 [
"RoomKey" => "1661930137"
"RoomType" => "Laundry room"
"ListingId" => "X12996134"
"RoomLevel" => "Basement"
"RoomWidth" => 3.42
"ListingKey" => "29601678"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
7 => array:11 [
"RoomKey" => "1661930138"
"RoomType" => "Foyer"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 3.16
"ListingKey" => "29601678"
"RoomLength" => 3.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
8 => array:11 [
"RoomKey" => "1661930139"
"RoomType" => "Living room"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 3.55
"ListingKey" => "29601678"
"RoomLength" => 4.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
9 => array:11 [
"RoomKey" => "1661930140"
"RoomType" => "Dining room"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 3.55
"ListingKey" => "29601678"
"RoomLength" => 4.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
10 => array:11 [
"RoomKey" => "1661930141"
"RoomType" => "Eating area"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "29601678"
"RoomLength" => 3.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
11 => array:11 [
"RoomKey" => "1661930142"
"RoomType" => "Kitchen"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29601678"
"RoomLength" => 3.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.41Z"
]
12 => array:11 [
"RoomKey" => "1661930143"
"RoomType" => "Bedroom"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29601678"
"RoomLength" => 3.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.42Z"
]
13 => array:11 [
"RoomKey" => "1661930144"
"RoomType" => "Bathroom"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 2.12
"ListingKey" => "29601678"
"RoomLength" => 1.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.42Z"
]
14 => array:11 [
"RoomKey" => "1661930145"
"RoomType" => "Bathroom"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 2.13
"ListingKey" => "29601678"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.42Z"
]
15 => array:11 [
"RoomKey" => "1661930146"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12996134"
"RoomLevel" => "Main level"
"RoomWidth" => 5.54
"ListingKey" => "29601678"
"RoomLength" => 5.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T11:55:23.42Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29601678_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29601678/2cdd20550d22cb1f992c322118a85b68.webp"
"MediaSize" => 267290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29601678/thumbnail-2cdd20550d22cb1f992c322118a85b68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12996134"
"ResourceRecordKey" => "29601678"
"ModificationTimestamp" => "2026-04-14T16:26:06.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29601678_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29601678/b92c606934b5f3c3bd961414fb6d2009.webp"
"MediaSize" => 236913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29601678/thumbnail-b92c606934b5f3c3bd961414fb6d2009.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12996134"
"ResourceRecordKey" => "29601678"
"ModificationTimestamp" => "2026-04-14T16:26:06.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29601678_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29601678/b65b82133b4d433fb3cfafb2069ba4b3.webp"
"MediaSize" => 104991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29601678/thumbnail-b65b82133b4d433fb3cfafb2069ba4b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12996134"
"ResourceRecordKey" => "29601678"
"ModificationTimestamp" => "2026-04-14T16:26:06.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29601678_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29601678/bb270102a12418f5e44c468d009234a8.webp"
"MediaSize" => 129699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29601678/thumbnail-bb270102a12418f5e44c468d009234a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12996134"
"ResourceRecordKey" => "29601678"
"ModificationTimestamp" => "2026-04-14T16:26:06.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29601678_4890_5"
…11
]
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": 67
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29601678')"
+"ID": "1542462"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920202')"
+"ID": "1542112"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1541830"
+post_author: 1
+"ListingKey": "29919855"
+"ListingId": "40840741"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:17Z"
+"RFModificationTimestamp": "2026-06-20T20:43:25Z"
+"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-20T20:31:35Z"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919855')"
+"ID": "1541830"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918739')"
+"ID": "1541267"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918493')"
+"ID": "1540723"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1520053"
+post_author: 1
+"ListingKey": "29888470"
+"ListingId": "X13430622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:07Z"
+"RFModificationTimestamp": "2026-06-12T07:20:20Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Rarely offered, this exceptional property delivers the feeling of cottage living in the city while offering the convenience of one of Waterdown's most sought after neighbourhoods. Situated on an incredible lot of nearly 10,000 sq. ft., this beautifully updated bungalow offers approximately 2,360 sq. ft. of finished living space with 3+2 bedrooms and 3 full bathrooms.The stunning open concept layout is anchored by a beautifully renovated kitchen featuring a massive centre island, stainless steel appliances, a 5 burner gas range, pot lights, and seamless flow into the living and dining areas. Bright, sun filled rooms throughout allow for an abundance of natural light, while updated railings, renovated closet spaces, and thoughtful improvements create a home that is both stylish and functional.The fully finished lower level offers incredible versatility with two additional bedrooms, a living area with a fireplace, and a relaxing 4 person infrared sauna for all your health/detox needs.Step outside and enjoy your own private backyard oasis. Surrounded by newer fencing for enhanced privacy, this expansive outdoor space features two gazebos, an extended patio, and a fire pit area, providing the perfect setting for entertaining, relaxing, and enjoying the outdoors.Major updates include a recently replaced roof and updated appliances within the last few years, providing peace of mind for years to come. With parking for 5 vehicles and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this move in ready home offers a lifestyle that is truly hard to find.VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:21:30.107435+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:54Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:54Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888470/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888470')"
+"ID": "1520053"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1508710"
+post_author: 1
+"ListingKey": "29873709"
+"ListingId": "X13417580"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T01:50:01Z"
+"RFModificationTimestamp": "2026-06-18T01:51:35Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "44 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.878431
1 => 43.346428
]
+"Latitude": 43.346428
+"Longitude": -79.878431
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stunning Waterdown home has so much to offer - and it's ready to impress from the moment you walk in! Boasting over 1,900 sq ft above grade and built in 2017, every detail has been thoughtfully designed with modern living in mind. Engineered hardwood flooring flows throughout both the main and second level, and the open concept kitchen features beautiful quartz countertops - ideal for entertaining family and friends. A main floor office and a chic powder room complete the main level with both function and flair. Upstairs you'll find 3 spacious bedrooms plus the potential for a 4th, served by 2 well-appointed bathrooms including a luxurious private ensuite. The fully finished basement offers even more living space complete with a gym and rec room, plus ample storage throughout. Step outside to your private, fully fenced backyard oasis featuring a gazebo and hot tub - the perfect place to relax and unwind. With parking for 5 vehicles, easy highway access and just minutes to Aldershot GO Station, this one checks every box. Don't miss it! (id:62650)"
+"Appliances": array:6 [
0 => "All"
1 => "Water meter"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Window Coverings"
5 => "Water Heater - Tankless"
]
+"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-09T00:21:57.360258+00:00"
+"Directions": "Cross Streets: Spring Creek. ** Directions: Spring Creek Drive to Still Water."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234778"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Ravine"
1 => "Dry"
2 => "Carpet Free"
3 => "Gazebo"
4 => "Sump Pump"
]
+"LotSizeDimensions": "30 x 89.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T23:42:26Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T01:43:43Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "44"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6644"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29873709/44-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"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": "R1-69"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-06-08T23:42:25.94Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472623"
+"ListOfficeNationalAssociationId": "1417330"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29873709')"
+"ID": "1508710"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1507953"
+post_author: 1
+"ListingKey": "29871823"
+"ListingId": "40837880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:11Z"
+"RFModificationTimestamp": "2026-06-20T20:45:34Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1909.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "44 STILLWATER Crescent, Waterdown, Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.878352
1 => 43.3464429
]
+"Latitude": 43.3464429
+"Longitude": -79.878352
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Waterdown home has so much to offer — and it's ready to impress from the moment you walk in! Boasting over 1,900 sq ft above grade and built in 2017, every detail has been thoughtfully designed with modern living in mind. Engineered hardwood flooring flows throughout both the main and second level, and the open concept kitchen features beautiful quartz countertops — ideal for entertaining family and friends. A main floor office and a chic powder room complete the main level with both function and flair. Upstairs you'll find 3 spacious bedrooms plus the potential for a 4th, served by 2 well-appointed bathrooms including a luxurious private ensuite. The fully finished basement offers even more living space complete with a gym and rec room, plus ample storage throughout. Step outside to your private, fully fenced backyard oasis featuring a gazebo and hot tub — the perfect place to relax and unwind. With parking for 5 vehicles, easy highway access and just minutes to Aldershot GO Station, this one checks every box. Don't miss it! (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"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-08T20:34:21.888112+00:00"
+"Directions": "Dundas Street East to Spring Creek to Stillwater"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043485"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T19:19:37Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:33:02Z"
+"Stories": "2.0"
+"StreetName": "STILLWATER"
+"StreetNumber": "44"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6644"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29871823/44-stillwater-crescent-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "R1-69"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1909
+"OriginalEntryTimestamp": "2026-06-08T19:19:37.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1319320"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871823')"
+"ID": "1507953"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1505882"
+post_author: 1
+"ListingKey": "29869910"
+"ListingId": "40837683"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:30:14Z"
+"RFModificationTimestamp": "2026-06-09T20:32:03Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1242.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R3H0"
+"UnparsedAddress": "352 PARKSIDE Drive, Waterdown, Ontario L0R3H0"
+"Coordinates": array:2 [
0 => -79.8971548
1 => 43.3422221
]
+"Latitude": 43.3422221
+"Longitude": -79.8971548
+"YearBuilt": 1947
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity is knocking in the heart of Old Waterdown. Welcome to 352 Parkside Drive, a 1.5 storey home sitting on a beautiful 75’ x 93’ lot in one of Waterdown’s most established and sought after neighbourhoods. With 3 bedrooms, 1+1 bathrooms, a detached garage, and 1,242 sq ft of living space, this home is ready for someone with vision to bring it back to life. TLC required, but the potential here is undeniable!! Whether you’re an investor, contractor, flipper, or a buyer dreaming of creating a home fully your own, this is the kind of property that rarely comes up in Old Town Waterdown at an approachable price point. Big lot. Incredible location. Endless potential. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T16:42:40.576751+00:00"
+"Directions": "Hamilton St N to Parkside Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922779"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T16:00:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:20:50Z"
+"Stories": "1.5"
+"StreetName": "PARKSIDE"
+"StreetNumber": "352"
+"StreetSuffix": "Drive"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5275"
+"VirtualTourURLUnbranded": "https://youtu.be/yYP-O1y40_s"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29869910/352-parkside-drive-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-74c"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 75.0
+"AboveGradeFinishedArea": 1242
+"OriginalEntryTimestamp": "2026-06-08T16:00:23.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227684"
+"ListOfficeNationalAssociationId": "1372539"
+"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": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869910')"
+"ID": "1505882"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 27
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]