array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29750159 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23407
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23409
+post_id: "1420666"
+post_author: 1
+"ListingKey": "29750159"
+"ListingId": "X13125884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T01:05:00Z"
+"RFModificationTimestamp": "2026-06-20T01:06:31Z"
+"ListPrice": 679900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T1"
+"UnparsedAddress": "146 TRUEDELL CIRCLE, Hamilton (Waterdown), Ontario L8B0T1"
+"Coordinates": array:2 [
0 => -79.9069002
1 => 43.3378824
]
+"Latitude": 43.3378824
+"Longitude": -79.9069002
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 146 Truedell Circle, a beautifully upgraded 3-story, 2-bedroom townhouse nestled in the highly desirable community of North Waterdown. This home offers one of the most functional open layouts available for this style of build, highlighted by 9-foot ceilings, wood flooring, and newer berber carpeting on the stairs. The spacious kitchen offers an abundance of cabinetry, ample counter space, and upgraded stainless steel appliances. The living room is bright and inviting, featuring a stunning modern stone wall complete with a cozy electric fireplace and mantle. Walk out to a large covered balcony equipped with a BBQ gas line, offering the perfect space for outdoor grilling and relaxation. Other convenient features include bedroom level laundry and two parking spaces in the driveway, plus a single car garage. Beyond the home itself, Waterdown provides a true sense of community, perfectly balancing a charming small-town feel with an array of modern amenities, including excellent schools, transit, and shopping. This premium location is just a short walk from a convenient plaza featuring Fortinos, McDonalds, Tim Hortons and many more. Memorial Park sits just across the street, renowned for its winter skating loop, walking path, playground and the annual Waterdown Ribfest. Waterdown's vibrant downtown core is just a few minutes farther with additional shops, restaurants and businesses. You can also enjoy local waterfalls and family-friendly programs at the local library and YMCA. For outdoor enthusiasts and active pets, nearby wooded trails lead directly to Joe Sam's Leisure Park, which offers baseball diamonds, playgrounds, and a leash-free zone, all while maintaining incredibly easy access to the QEW, 401, and 407 highways for a seamless daily commute. Enjoy all that Waterdown has to offer! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-14T06:42:40.422759+00:00"
+"Directions": "Cross Streets: Hamilton St. / Parkside Dr. ** Directions: Centre Rd. / Nisbet Blvd. / Truedell Circ."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952412"
+"ListOfficeKey": "280855"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.7 x 51.2 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-14T05:25:18Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T00:56:50Z"
+"Stories": "3.0"
+"StreetName": "Truedell"
+"StreetNumber": "146"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "4468"
+"VirtualTourURLUnbranded": "https://listings.dylonnorth.com/video/VAGRFBQtDHFkf7PfHsyhMZ8Ws8AzsRQTuXCGDnZUa2o"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1663467368"
"RoomType" => "Kitchen"
"ListingId" => "X13125884"
"RoomLevel" => "Second level"
"RoomWidth" => 2.9
"ListingKey" => "29750159"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
1 => array:11 [
"RoomKey" => "1663467369"
"RoomType" => "Living room"
"ListingId" => "X13125884"
"RoomLevel" => "Second level"
"RoomWidth" => 4.57
"ListingKey" => "29750159"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
2 => array:11 [
"RoomKey" => "1663467370"
"RoomType" => "Bedroom"
"ListingId" => "X13125884"
"RoomLevel" => "Third level"
"RoomWidth" => 2.92
"ListingKey" => "29750159"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
3 => array:11 [
"RoomKey" => "1663467371"
"RoomType" => "Bedroom 2"
"ListingId" => "X13125884"
"RoomLevel" => "Third level"
"RoomWidth" => 4.11
"ListingKey" => "29750159"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
4 => array:11 [
"RoomKey" => "1663467372"
"RoomType" => "Bathroom"
"ListingId" => "X13125884"
"RoomLevel" => "Third level"
"RoomWidth" => 1.4
"ListingKey" => "29750159"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
5 => array:11 [
"RoomKey" => "1663467373"
"RoomType" => "Bathroom"
"ListingId" => "X13125884"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.97
"ListingKey" => "29750159"
"RoomLength" => 1.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T00:56:50.9Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29750159/146-truedell-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-16"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-05-14T05:25:17.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246004"
+"ListOfficeNationalAssociationId": "1317908"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29750159_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/456bd7f6ad27f8e3594a5bd89f2a5054.webp"
"MediaSize" => 279534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-456bd7f6ad27f8e3594a5bd89f2a5054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29750159_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/14868e26d30753d120468a7a7be4a995.webp"
"MediaSize" => 326142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-14868e26d30753d120468a7a7be4a995.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29750159_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/5ddb0ba04a220a7a4c8a1f6aead5c12b.webp"
"MediaSize" => 297713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-5ddb0ba04a220a7a4c8a1f6aead5c12b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29750159_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/eee7562079f26f905cb73cf77f63dab6.webp"
"MediaSize" => 96965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-eee7562079f26f905cb73cf77f63dab6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29750159_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/42fe63d438a9e2a91f9f74e4fc17d33a.webp"
"MediaSize" => 106446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-42fe63d438a9e2a91f9f74e4fc17d33a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29750159_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/79413944a30b70b1d1f0194d0c0c733f.webp"
"MediaSize" => 102264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-79413944a30b70b1d1f0194d0c0c733f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29750159_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/2b168989e50e21cd61ed46d003d7df6d.webp"
"MediaSize" => 169292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-2b168989e50e21cd61ed46d003d7df6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29750159_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/93e121e31e6fe102aa58c2eb5f4ab01a.webp"
"MediaSize" => 177978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-93e121e31e6fe102aa58c2eb5f4ab01a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29750159_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/6a349eddb42747b2d08a9d4a3a45d2f8.webp"
"MediaSize" => 170346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-6a349eddb42747b2d08a9d4a3a45d2f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29750159_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/9b47fca9044e894ebaad06b7ef084397.webp"
"MediaSize" => 157280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-9b47fca9044e894ebaad06b7ef084397.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29750159_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/1474873d14a6d0efb394f9cfb8a6e944.webp"
"MediaSize" => 190389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-1474873d14a6d0efb394f9cfb8a6e944.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29750159_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/34b921ab2ae380fda7cd42edf74a9a65.webp"
"MediaSize" => 167277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-34b921ab2ae380fda7cd42edf74a9a65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29750159_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/f10ed6c2e9879270fc774853a6fe89ae.webp"
"MediaSize" => 194665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-f10ed6c2e9879270fc774853a6fe89ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29750159_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/068d50e5175fd494007ce5b135ac32bc.webp"
"MediaSize" => 178512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-068d50e5175fd494007ce5b135ac32bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29750159_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/6d1f6e319a13a3ec2e42182c6fe7bfef.webp"
"MediaSize" => 164202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-6d1f6e319a13a3ec2e42182c6fe7bfef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29750159_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/22a6ac6deafb125748fe212a2958a15e.webp"
"MediaSize" => 180561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-22a6ac6deafb125748fe212a2958a15e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29750159_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/cf7ae24437b42bb2b46ada90a60a82f5.webp"
"MediaSize" => 164346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-cf7ae24437b42bb2b46ada90a60a82f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29750159_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/2ebc972ddcd9cea98b059bc3b115c53c.webp"
"MediaSize" => 176118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-2ebc972ddcd9cea98b059bc3b115c53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29750159_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/447ebb804eb5c8e88f3d1b8b71553507.webp"
"MediaSize" => 156321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-447ebb804eb5c8e88f3d1b8b71553507.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29750159_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/89b2a184ba094b1ee6e92aa0cfadcd8d.webp"
"MediaSize" => 163038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-89b2a184ba094b1ee6e92aa0cfadcd8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29750159_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/c1d064cb4ae7cb1618191bc63ca5f4fd.webp"
"MediaSize" => 213982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-c1d064cb4ae7cb1618191bc63ca5f4fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29750159_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/b8cf72d69a492af427d05f373edafd9e.webp"
"MediaSize" => 125733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-b8cf72d69a492af427d05f373edafd9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29750159_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/5ea4832f2405bc7b731c56bf19110b90.webp"
"MediaSize" => 162239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-5ea4832f2405bc7b731c56bf19110b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29750159_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/dbd3b2641da3b52e10714dff4982ab40.webp"
"MediaSize" => 135772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-dbd3b2641da3b52e10714dff4982ab40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29750159_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/de381f4fe9a3c6df47cfaf5f0a5af3ed.webp"
"MediaSize" => 113791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-de381f4fe9a3c6df47cfaf5f0a5af3ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29750159_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/fb3ed8006e73e5250a53c0d3e1484b87.webp"
"MediaSize" => 106234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-fb3ed8006e73e5250a53c0d3e1484b87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29750159_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/5a410b8e4c2350ae59bf4374e2f552bc.webp"
"MediaSize" => 103362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-5a410b8e4c2350ae59bf4374e2f552bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29750159_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750159/40b9efc19a2a5e25dafd5601d9bf6830.webp"
"MediaSize" => 332596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750159/thumbnail-40b9efc19a2a5e25dafd5601d9bf6830.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13125884"
"ResourceRecordKey" => "29750159"
"ModificationTimestamp" => "2026-05-14T05:25:17.44Z"
]
]
+"DaysOnMarket": 39
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750159')"
+"ID": "1420666"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 280855" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24882
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1952412" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29750159'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25182
+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 '29750159'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25198
+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 '29750159' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9069002 43.3378824)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1551573"
+post_author: 1
+"ListingKey": "29932730"
+"ListingId": "40841118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T12:40:15Z"
+"RFModificationTimestamp": "2026-06-20T17:01:30Z"
+"ListPrice": 1249900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0S4"
+"UnparsedAddress": "103 MACBEAN Crescent, Waterdown, Ontario L8B0S4"
+"Coordinates": array:2 [
0 => -79.9141302
1 => 43.3351407
]
+"Latitude": 43.3351407
+"Longitude": -79.9141302
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautifully updated home is finished from top to bottom and ready to impress. Located on a highly desirable crescent in Waterdown, it offers exceptional convenience just steps to the primary and high school, parks, scenic trails, shops, and restaurants. The heart of the home is the stunning chef's kitchen, thoughtfully redesigned with custom soft-close cabinetry, Caesarstone quartz counters, two pantries, coffee and beverage bar, 9' x 4' centre island with seating, undermount double sink, stylish tile backsplash, bar fridge, pendant and under-cabinet lighting plus premium Café appliances with induction stove. The bright open kitchen overlooks the spacious living and dining rooms with a three-sided gas fireplace with stone surround. Main floor also offers a laundry room and 2-piece bath. Upstairs boasts 3 generous bedrooms and a bonus family room that can be converted to a 4th bedroom. The primary suite features a large walk-in closet and newly updated spa-inspired ensuite with freestanding soaker tub, oversized glass shower with custom tile, double sinks, quartz counters and LED mirrors. The second 4-piece bathroom includes double sinks and granite counters. The lower level is fully finished with a rec room and games room, offering great space for family living and entertaining, plus loads of storage. The private backyard is an oasis with wood deck, newer hot tub and gazebo. Double garage with inside entry. Hardwood flooring on both levels and staircase, luxury laminate in the lower level, 9 foot ceilings on the main with soaring 19 foot foyer, upgraded lighting throughout and California wood shutters. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T17:01:22.994425+00:00"
+"Directions": "Nisbet to Macbean"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1887625"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T12:31:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T12:31:20Z"
+"Stories": "2.0"
+"StreetName": "MACBEAN"
+"StreetNumber": "103"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7678.23"
+"VirtualTourURLUnbranded": "https://youtu.be/eMa2RGcqXno"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1663717589"
"RoomType" => "Storage"
"ListingId" => "40841118"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.52Z"
]
1 => array:11 [
"RoomKey" => "1663717590"
"RoomType" => "Games room"
"ListingId" => "40841118"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.52Z"
]
2 => array:11 [
"RoomKey" => "1663717591"
"RoomType" => "Recreation room"
"ListingId" => "40841118"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "20' x 11'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.52Z"
]
3 => array:11 [
"RoomKey" => "1663717592"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 10'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.52Z"
]
4 => array:11 [
"RoomKey" => "1663717593"
"RoomType" => "Bedroom"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
5 => array:11 [
"RoomKey" => "1663717594"
"RoomType" => "Bedroom"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
6 => array:11 [
"RoomKey" => "1663717595"
"RoomType" => "5pc Bathroom"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
7 => array:11 [
"RoomKey" => "1663717596"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
8 => array:11 [
"RoomKey" => "1663717597"
"RoomType" => "Family room"
"ListingId" => "40841118"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
9 => array:11 [
"RoomKey" => "1663717598"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "4'1'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
10 => array:11 [
"RoomKey" => "1663717599"
"RoomType" => "Laundry room"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "8' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
11 => array:11 [
"RoomKey" => "1663717600"
"RoomType" => "Dining room"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
12 => array:11 [
"RoomKey" => "1663717601"
"RoomType" => "Living room"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
13 => array:11 [
"RoomKey" => "1663717602"
"RoomType" => "Kitchen"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
14 => array:11 [
"RoomKey" => "1663717603"
"RoomType" => "Foyer"
"ListingId" => "40841118"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29932730"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 23'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-20T12:31:20.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29932730/103-macbean-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-31"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 2280
+"BelowGradeFinishedArea": 496
+"OriginalEntryTimestamp": "2026-06-20T12:31:20.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1209810"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932730_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/6f80315e34051721859b4810d95894c5.webp"
"MediaSize" => 141540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-6f80315e34051721859b4810d95894c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932730_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/8d219515342ba5ffff734ae537bbcb35.webp"
"MediaSize" => 72145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-8d219515342ba5ffff734ae537bbcb35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932730_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/fd51b274c257fd3f94c1243bb87ff26b.webp"
"MediaSize" => 75844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-fd51b274c257fd3f94c1243bb87ff26b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932730_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/cd8ca9b1b9fe12794093e43bb26365cb.webp"
"MediaSize" => 85593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-cd8ca9b1b9fe12794093e43bb26365cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932730_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/138e5e0fd3118313b70679a2333b38b2.webp"
"MediaSize" => 77187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-138e5e0fd3118313b70679a2333b38b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932730_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/2e0f14e0727c63e43904ecdb5f220676.webp"
"MediaSize" => 94884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-2e0f14e0727c63e43904ecdb5f220676.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932730_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/11381c001ed65c9808d6154922d8c3da.webp"
"MediaSize" => 86611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-11381c001ed65c9808d6154922d8c3da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932730_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/34cabb66d5d77ac3fa9f7a0893353eba.webp"
"MediaSize" => 67878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-34cabb66d5d77ac3fa9f7a0893353eba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932730_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/eb7ca965f78f4fd211c59290ddb72c51.webp"
"MediaSize" => 70518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-eb7ca965f78f4fd211c59290ddb72c51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932730_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/576be01524fcd81ddca35db260c2e203.webp"
"MediaSize" => 79604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-576be01524fcd81ddca35db260c2e203.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932730_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/55e54fcdf9b5c4852d4fa2a2b597d83e.webp"
"MediaSize" => 63242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-55e54fcdf9b5c4852d4fa2a2b597d83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932730_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/b9b06240096200569d89d9930dbce889.webp"
"MediaSize" => 72836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-b9b06240096200569d89d9930dbce889.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932730_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/fe5795eeda0059a83f46c8ce70462579.webp"
"MediaSize" => 75077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-fe5795eeda0059a83f46c8ce70462579.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932730_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/48e1221d2a62309448b1ef747857e570.webp"
"MediaSize" => 90670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-48e1221d2a62309448b1ef747857e570.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932730_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/b19609bdb6a88419254f3acbe9cbc1e7.webp"
"MediaSize" => 86257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-b19609bdb6a88419254f3acbe9cbc1e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
"ModificationTimestamp" => "2026-06-20T12:31:20.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932730_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932730/2106b48c9166054ecd23009c6b65b6c4.webp"
"MediaSize" => 74518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932730/thumbnail-2106b48c9166054ecd23009c6b65b6c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841118"
"ResourceRecordKey" => "29932730"
…1
]
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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932730')"
+"ID": "1551573"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1551457"
+post_author: 1
+"ListingKey": "29932788"
+"ListingId": "X13470618"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T13:25:33Z"
+"RFModificationTimestamp": "2026-06-20T14:53:22Z"
+"ListPrice": 1249900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S4"
+"UnparsedAddress": "103 MACBEAN CRESCENT, Hamilton (Waterdown), Ontario L8B0S4"
+"Coordinates": array:2 [
0 => -79.914176
1 => 43.3351
]
+"Latitude": 43.3351
+"Longitude": -79.914176
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautifully updated home is finished from top to bottom and ready to impress. Located on a highly desirable crescent in Waterdown, it offers exceptional convenience just steps to the primary and high school, parks, scenic trails, shops, and restaurants. The heart of the home is the stunning chef's kitchen, thoughtfully redesigned with custom soft-close cabinetry, Caesarstone quartz counters, two pantries, coffee and beverage bar, 9' x 4' centre island with seating, undermount double sink, stylish tile backsplash, bar fridge, pendant and under-cabinet lighting plus premium Café appliances with induction stove. The bright open kitchen overlooks the spacious living and dining rooms with a three-sided gas fireplace with stone surround. Main floor also offers a laundry room and 2-piece bath. Upstairs boasts 3 generous bedrooms and a bonus family room that can be converted to a 4th bedroom. The primary suite features a large walk-in closet and newly updated spa-inspired ensuite with freestanding soaker tub, oversized glass shower with custom tile, double sinks, quartz counters and LED mirrors. The second 4-piece bathroom includes double sinks and granite counters. The lower level is fully finished with a rec room and games room, offering great space for family living and entertaining, plus loads of storage. The private backyard is an oasis with wood deck, newer hot tub and gazebo. Double garage with inside entry. Hardwood flooring on both levels and staircase, luxury laminate in the lower level, 9 foot ceilings on the main with soaring 19 foot foyer, upgraded lighting throughout and California wood shutters. (id:62783)"
+"Appliances": array:6 [
0 => "All"
1 => "Water meter"
2 => "Hot Tub"
3 => "Window Coverings"
4 => "Garage door opener"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T14:53:16.682866+00:00"
+"Directions": "Cross Streets: Nisbet. ** Directions: Nisbet and Macbean."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1971138"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lighting"
1 => "Level"
]
+"LotSizeDimensions": "34.8 x 88.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-20T13:18:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T13:18:08Z"
+"Stories": "2.0"
+"StreetName": "Macbean"
+"StreetNumber": "103"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7678.23"
+"VirtualTourURLUnbranded": "https://youtu.be/eMa2RGcqXno"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932788/103-macbean-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
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 34.9
+"OriginalEntryTimestamp": "2026-06-20T13:18:08.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1258816"
+"ListOfficeNationalAssociationId": "1300540"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932788')"
+"ID": "1551457"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1550028"
+post_author: 1
+"ListingKey": "29931472"
+"ListingId": "X13469384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:35:05Z"
+"RFModificationTimestamp": "2026-06-21T18:38:14Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "34 PENTLAND ROAD, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.908196
1 => 43.321182
]
+"Latitude": 43.321182
+"Longitude": -79.908196
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "34 Pentland Road sits on a family-friendly street in one of Waterdown's most sought-after pockets - a very well maintained, classic 2-storey offering ~2,300 sq ft above grade plus a fully finished basement, where every update earns its place. The kitchen (renovated 2020) anchors the home: white shaker cabinetry with soft close doors, quartz counters, a 10.5' island, dual sinks, pot drawers & a dual-zone wine fridge, all under a vaulted ceiling that floods the space with light. Sliding doors off the kitchen lead straight to the backyard deck, while the room flows into the Great room for easy everyday living. A separate dining room with tray ceiling handles the bigger gatherings. Main floor laundry with inside entry from the double garage takes care of the daily grind. Upstairs, 4 generously sized bedrooms give everyone real space to spread out - no closet-sized afterthoughts here. The primary bedroom functions beautifully: a true escape with a walk-in closet & spa-style 5-piece ensuite featuring a double vanity & corner soaker tub. The remaining 3 bedrooms are well-proportioned & comfortable, suited to kids, guests, or a home office setup. Downstairs, the finished basement flexes to whatever you need - gym, theatre, playroom, office - with a bathroom rough-in & room to add a 5th bedroom as the family grows. Outside highlights: a large wood deck for entertaining, a welcoming front porch & concrete walkway for curb appeal that doesn't fade. Steps to parks, trails, top schools & downtown Waterdown's shops and cafés, with quick commuter access. Space, comfort & a layout that works for real life - ready now. (id:62783)"
+"Appliances": array:4 [
0 => "All"
1 => "Central Vacuum"
2 => "Alarm System"
3 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T23:15:01.311283+00:00"
+"Directions": "Cross Streets: Dundas St E & Hollybush Dr. ** Directions: Dundas St E to Hollybush to Dalrymple Dr to Pentland Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237255"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 117.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:52:50Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T12:24:06Z"
+"Stories": "2.0"
+"StreetName": "Pentland"
+"StreetNumber": "34"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7254.63"
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/sites/exodxkqv/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931472/34-pentland-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2086486"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "286883"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-19T21:52:50.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475197"
+"ListOfficeNationalAssociationId": "1364605"
+"CoListAgentNationalAssociationId": "1359804"
+"CoListOfficeNationalAssociationId": "1364605"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931472')"
+"ID": "1550028"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1549995"
+post_author: 1
+"ListingKey": "29930842"
+"ListingId": "40841314"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:19Z"
+"RFModificationTimestamp": "2026-06-20T20:43:36Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2510.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "4 VICTORIA Street Unit# 16, Waterdown, Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924343
1 => 43.3359233
]
+"Latitude": 43.3359233
+"Longitude": -79.8924343
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:57:27.905655+00:00"
+"Directions": "Dundas to Mill St N to Church"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944754"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T20:31:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:21Z"
+"Stories": "2.0"
+"StreetName": "VICTORIA"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6109"
+"VirtualTourURLUnbranded": "https://youriguide.com/16_4_victoria_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930842/4-victoria-street-unit-16-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1689
+"BelowGradeFinishedArea": 821
+"OriginalEntryTimestamp": "2026-06-19T20:32:02.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303128"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930842')"
+"ID": "1549995"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1549761"
+post_author: 1
+"ListingKey": "29931299"
+"ListingId": "X13469334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T21:25:02Z"
+"RFModificationTimestamp": "2026-06-20T21:29:53Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "16 - 4 VICTORIA STREET, Hamilton (Waterdown), Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924317
1 => 43.3358632
]
+"Latitude": 43.3358632
+"Longitude": -79.8924317
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Water Heater"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:34:14.813512+00:00"
+"Directions": "Cross Streets: Mill St N and Church Street. ** Directions: Mill St N to right on Church."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972710"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T21:17:45Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T21:17:45Z"
+"Stories": "2.0"
+"StreetName": "Victoria"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6109"
+"VirtualTourURLUnbranded": "https://youriguide.com/16_4_victoria_st_waterdown_on/"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931299/16-4-victoria-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T21:30:44.27Z"
+"ListAgentNationalAssociationId": "1259751"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931299')"
+"ID": "1549761"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1549581"
+post_author: 1
+"ListingKey": "29930850"
+"ListingId": "40840149"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:40:13Z"
+"RFModificationTimestamp": "2026-06-21T20:42:36Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.11
+"LivingArea": 3226.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0P6"
+"UnparsedAddress": "34 PENTLAND Road, Waterdown, Ontario L8B0P6"
+"Coordinates": array:2 [
0 => -79.9080964
1 => 43.3211607
]
+"Latitude": 43.3211607
+"Longitude": -79.9080964
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "34 Pentland Road sits on a family-friendly street in one of Waterdown's most sought-after pockets — a very well maintained, classic 2-storey offering ~2,300 sq ft above grade plus a fully finished basement, where every update earns its place. The kitchen (renovated 2020) anchors the home: white shaker cabinetry with soft close doors, quartz counters, a 10.5' island, dual sinks, pot drawers & a dual-zone wine fridge, all under a vaulted ceiling that floods the space with light. Sliding doors off the kitchen lead straight to the backyard deck, while the room flows into the great room for easy everyday living. A separate dining room with tray ceiling handles the bigger gatherings. Main floor laundry with inside entry from the double garage takes care of the daily grind. Upstairs, 4 generously sized bedrooms give everyone real space to spread out — no closet-sized afterthoughts here. The primary bedroom functions beautifully: a true escape with a walk-in closet & spa-style 5-piece ensuite featuring a double vanity & corner soaker tub. The remaining 3 bedrooms are well-proportioned & comfortable, suited to kids, guests, or a home office setup. Downstairs, the finished basement flexes to whatever you need — gym, theatre, playroom, office — with a bathroom rough-in & room to add a 5th bedroom as the family grows. Outside highlights: a large wood deck for entertaining, a welcoming front porch & concrete walkway for curb appeal that doesn't fade. Steps to parks, trails, top schools & downtown Waterdown's shops and cafés, with quick commuter access. Space, comfort & a layout that works for real life — ready now. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:07:43.046864+00:00"
+"Directions": "Dundas St E & Hollybush"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236132"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:41:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:32:14Z"
+"Stories": "2.0"
+"StreetName": "PENTLAND"
+"StreetNumber": "34"
+"StreetSuffix": "Road"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7254.63"
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/sites/34-pentland-rd-waterdown-on-l0r-2h5-25984504/branded"
+"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/29930850/34-pentland-road-waterdown"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2338
+"BelowGradeFinishedArea": 888
+"OriginalEntryTimestamp": "2026-06-19T20:32:15.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1474061"
+"ListOfficeNationalAssociationId": "1434122"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930850')"
+"ID": "1549581"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23421
+post_id: "1546802"
+post_author: 1
+"ListingKey": "29926451"
+"ListingId": "X13465026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T01:55:19Z"
+"RFModificationTimestamp": "2026-06-19T04:50:46Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "37 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today's busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you're purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown's most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
]
+"AssociationFee": "94.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T04:50:35.310980+00:00"
+"Directions": "Cross Streets: Hamilton St N. ** Directions: HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102522"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Flat site"
]
+"LotSizeDimensions": "19.7 x 52.3 FT"
+"ParkingFeatures": array:4 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
3 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-06-19T01:47:24Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T01:47:24Z"
+"Stories": "3.0"
+"StreetName": "Nisbet"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4319"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926451/37-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2026-06-19T01:47:24.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372275"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926451')"
+"ID": "1546802"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1546054"
+post_author: 1
+"ListingKey": "29925894"
+"ListingId": "40840606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:40:12Z"
+"RFModificationTimestamp": "2026-06-21T20:42:47Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1439.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 37, Hamilton, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9076836
1 => 43.3385672
]
+"Latitude": 43.3385672
+"Longitude": -79.9076836
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy, low-maintenance living in the heart of Waterdown. Nestled within a quiet, family-friendly enclave, this beautifully maintained townhome offers the perfect opportunity for first-time buyers, young families, professionals, or those looking for a fresh start in a welcoming community. Step inside to discover a bright and inviting open-concept layout designed for everyday living and effortless entertaining. The spacious kitchen features ample cabinetry, stainless steel appliances, and a functional layout that flows seamlessly into the living and dining areas creating a warm and welcoming atmosphere throughout. The upper level offers 2 generously sized bedrooms, providing comfortable space for growing families, guests, or a home office. Thoughtfully designed with modern finishes and neutral décor, this home is move-in ready and waiting for your personal touch. Enjoy your own private outdoor space, perfect for morning coffee or evening relaxation. With attached garage parking, additional storage, and low-maintenance living, this home checks all the boxes for today’s busy lifestyle. Ideally located within walking distance to schools, shopping, restaurants, cafés, parks, and everyday amenities. Enjoy year-round recreation at nearby Memorial Park, home to the popular skating loop, community events, and seasonal festivals that bring residents together. Commuters will appreciate quick access to Highway 403, Highway 6, the QEW, and Aldershot GO Station. Whether you’re purchasing your first home, starting a family, or beginning a new chapter, this home offers the perfect blend of comfort, convenience, and community in one of Waterdown’s most desirable locations. Welcome home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:09:05.929659+00:00"
+"Directions": "HAMILTON ST. TO NISBET BLVD, RIGHT INTO COMPLEX."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525003"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T22:52:08Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:32:04Z"
+"Stories": "3.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4919"
+"VirtualTourURLUnbranded": "https://youtu.be/YFL0PTww-3Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29925894/54-nisbet-boulevard-unit-37-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1439
+"OriginalEntryTimestamp": "2026-06-18T22:51:09.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1063779"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925894')"
+"ID": "1546054"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1545200"
+post_author: 1
+"ListingKey": "29924409"
+"ListingId": "40840763"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:05:42Z"
+"RFModificationTimestamp": "2026-06-19T20:11:05Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2815.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G3"
+"UnparsedAddress": "34 HOWARD Boulevard, Burlington, Ontario L8B0G3"
+"Coordinates": array:2 [
0 => -79.8940271
1 => 43.3276387
]
+"Latitude": 43.3276387
+"Longitude": -79.8940271
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this wonderful family home in one of Waterdown’s most sought-after neighborhoods! Beautifully landscaped gardens and an inviting flagstone staircase create exceptional curb appeal from the moment you arrive. Inside, you'll find gorgeous hardwood floors, a warm and welcoming family room with a gas fireplace, and a spacious kitchen offering abundant cabinetry, pantry storage, and plenty of room for family gatherings. The beautifully updated bathrooms add a touch of modern elegance, while the versatile lower level features a separate exterior entrance—ideal for an in-law suite, teenage retreat, or home office. Backing onto a tranquil ravine, there is a walk out from the main level to the private backyard which boasts a newer two-tier deck, perfect for entertaining or simply enjoying the natural surroundings. Conveniently located close to shopping, cafés, restaurants, pubs, walking trails, and the scenic Smokey Hollow Waterfall, this home also offers easy access to the Burlington GO Station, Highway 6, Highway 403, and Highway 407, making commuting a breeze. A perfect blend of comfort, convenience, and lifestyle—this is a home you won’t want to miss! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T20:24:33.992597+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:01Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:32:05Z"
+"Stories": "2.0"
+"StreetName": "HOWARD"
+"StreetNumber": "34"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8743"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70321"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924409/34-howard-boulevard-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CM, R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 79.0
+"AboveGradeFinishedArea": 2025
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-18T19:51:01.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064859"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924409')"
+"ID": "1545200"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 136
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]