array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29167450/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167450&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167450/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167450&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23658
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23660
+post_id: "465887"
+post_author: 1
+"ListingKey": "29167450"
+"ListingId": "X12605800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T21:35:58Z"
+"RFModificationTimestamp": "2025-12-05T22:59:18Z"
+"ListPrice": 734000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T1"
+"UnparsedAddress": "154 TRUEDELL CIRCLE, Hamilton (Waterdown), Ontario L8B0T1"
+"Coordinates": array:2 [
0 => -79.9070855
1 => 43.3377516
]
+"Latitude": 43.3377516
+"Longitude": -79.9070855
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Carpet-Free Freehold Townhome on a Quiet Cul-de-Sac! Rare opportunity to own a freehold townhouse with no maintenance fees in one of Waterdown's most desirable neighborhoods. This elegantly updated home features solid oak stairs spanning all three levels, and a bright, spacious layout perfect for modern living. Enjoy a large open-concept kitchen with stainless steel appliances and plenty of counter space- ideal for cooking and entertaining. The inviting living and dining areas offer seamless flow and abundant natural light. Step outside to a huge covered deck, perfect for year-round BBQs and gatherings with family and friends. Upstairs, the oversized primary bedroom boasts a large walk-in closet and convenient Ensuite access. Additional highlights include a modern washer and dryer, 1-car garage and 2-car driveway, providing excellent parking for guests. Located just minutes from shopping, banks, restaurants, Hwy 6, Mapleview, Costco and IKEA - this home offers comfort, convenience and truly move-in-ready lifestyle. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Garage door opener"
2 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T22:59:07.141069+00:00"
+"Directions": "Hamilton St/Nisbet/Truedell"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1882220"
+"ListOfficeKey": "50479"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "19.7 x 51.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T21:21:08Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T21:21:08Z"
+"Stories": "3.0"
+"StreetName": "Truedell"
+"StreetNumber": "154"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "4380.37"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1545456522"
"RoomType" => "Utility room"
"ListingId" => "X12605800"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.57
"ListingKey" => "29167450"
"RoomLength" => 5.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.11Z"
]
1 => array:11 [
"RoomKey" => "1545456527"
"RoomType" => "Kitchen"
"ListingId" => "X12605800"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29167450"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.12Z"
]
2 => array:11 [
"RoomKey" => "1545456530"
"RoomType" => "Bathroom"
"ListingId" => "X12605800"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29167450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.12Z"
]
3 => array:11 [
"RoomKey" => "1545456531"
"RoomType" => "Dining room"
"ListingId" => "X12605800"
"RoomLevel" => "Second level"
"RoomWidth" => 2.67
"ListingKey" => "29167450"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.12Z"
]
4 => array:11 [
"RoomKey" => "1545456534"
"RoomType" => "Living room"
"ListingId" => "X12605800"
"RoomLevel" => "Second level"
"RoomWidth" => 4.04
"ListingKey" => "29167450"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.13Z"
]
5 => array:11 [
"RoomKey" => "1545456536"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12605800"
"RoomLevel" => "Third level"
"RoomWidth" => 3.23
"ListingKey" => "29167450"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.13Z"
]
6 => array:11 [
"RoomKey" => "1545456538"
"RoomType" => "Bedroom 2"
"ListingId" => "X12605800"
"RoomLevel" => "Third level"
"RoomWidth" => 2.69
"ListingKey" => "29167450"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.14Z"
]
7 => array:11 [
"RoomKey" => "1545456541"
"RoomType" => "Bathroom"
"ListingId" => "X12605800"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29167450"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T21:21:08.14Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29167450/154-truedell-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-12-05T21:21:07.93Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:26 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6357579838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/c906947cc8c2e482d57abbe6e2872b0f.webp"
"MediaSize" => 156131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-c906947cc8c2e482d57abbe6e2872b0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6357579839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/1f695acff2f0366cddb65adebcdad8d7.webp"
"MediaSize" => 182348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-1f695acff2f0366cddb65adebcdad8d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6357579842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/d1acd0163f6055f9dfd1d3a7149488e0.webp"
"MediaSize" => 171598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-d1acd0163f6055f9dfd1d3a7149488e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6357579843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/fca4df0fa5a22733e4dc3fcea2bfbf1a.webp"
"MediaSize" => 105541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-fca4df0fa5a22733e4dc3fcea2bfbf1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6357579844"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/05d84412165e9da098806fb276dd47da.webp"
"MediaSize" => 94919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-05d84412165e9da098806fb276dd47da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6357579846"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/efa306ef7407b614c6a8a7e186652400.webp"
"MediaSize" => 75251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-efa306ef7407b614c6a8a7e186652400.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6357579847"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/e9822e033ff2a0da693ee2e0cb8535aa.webp"
"MediaSize" => 78219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-e9822e033ff2a0da693ee2e0cb8535aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6357579849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/48cbe31c01e9bce067c7e868e16a92ab.webp"
"MediaSize" => 95687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-48cbe31c01e9bce067c7e868e16a92ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6357579851"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/43b99ea750fc9f926a3bb76a7d0d061e.webp"
"MediaSize" => 113783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-43b99ea750fc9f926a3bb76a7d0d061e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6357579853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/e9f7a9c57c7c2876060870302c3913c1.webp"
"MediaSize" => 94200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-e9f7a9c57c7c2876060870302c3913c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6357579855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/6bb4a69c5df099139e3e18a9370ce309.webp"
"MediaSize" => 86218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-6bb4a69c5df099139e3e18a9370ce309.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6357579857"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/66854e37f52e8ef6758e4751a99134ea.webp"
"MediaSize" => 111599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-66854e37f52e8ef6758e4751a99134ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6357579859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/6baea130669b87e36225d1f7414ba101.webp"
"MediaSize" => 86793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-6baea130669b87e36225d1f7414ba101.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6357579862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/d8bb0919a8cdc3c6b20d585d6354895a.webp"
"MediaSize" => 97647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-d8bb0919a8cdc3c6b20d585d6354895a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6357579866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/7ab51963b910ee0f8ceedd8ce2c42d4b.webp"
"MediaSize" => 161406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-7ab51963b910ee0f8ceedd8ce2c42d4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6357579869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/6c58dde735785e3ab46ab1146f995e4f.webp"
"MediaSize" => 84523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-6c58dde735785e3ab46ab1146f995e4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6357579872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/2e712beea73de9a6bba5b85dfb0c60d9.webp"
"MediaSize" => 93150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-2e712beea73de9a6bba5b85dfb0c60d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6357579874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/e6923e4882dcaa4ef090306fd06b87d3.webp"
"MediaSize" => 99458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-e6923e4882dcaa4ef090306fd06b87d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6357579877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/fc8f01ac0e68841b9c8028bac063e2e4.webp"
"MediaSize" => 134069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-fc8f01ac0e68841b9c8028bac063e2e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6357579880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/a96f4e111847dba30409978b96e32733.webp"
"MediaSize" => 120397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-a96f4e111847dba30409978b96e32733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6357579882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/1fd4bef85ee1763a15581fbc310df52a.webp"
"MediaSize" => 91323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-1fd4bef85ee1763a15581fbc310df52a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6357579883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/02c1788e90a3ca932032cb87e7077d61.webp"
"MediaSize" => 140341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-02c1788e90a3ca932032cb87e7077d61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6357579884"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/601134138c47c7dae641914eee614bfb.webp"
"MediaSize" => 105385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-601134138c47c7dae641914eee614bfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6357579885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/bed05d33855615e4ed67fd0e3778f32e.webp"
"MediaSize" => 96772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-bed05d33855615e4ed67fd0e3778f32e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6357579886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/a4134cd51929de98b7cc6dee0981df41.webp"
"MediaSize" => 259174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-a4134cd51929de98b7cc6dee0981df41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6357579887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167450/11ab3dc190661b2076babace75de6e01.webp"
"MediaSize" => 122832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167450/thumbnail-11ab3dc190661b2076babace75de6e01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605800"
"ResourceRecordKey" => "29167450"
"ModificationTimestamp" => "2025-12-05T21:21:07.95Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167450')"
+"ID": "465887"
}
]
+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=OfficeKey eq 50479/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50479&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50479/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50479&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25487
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25489
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SPECTRUM REALTY SERVICES INC."
+"OfficeEmail": null
+"OfficePhone": "416-736-6500"
+"OfficeMlsId": "45200"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "50479"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "8400 JANE ST., UNIT 9"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CONCORD"
+"OfficePostalCode": "L4K4L8"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003173"
+"OriginalEntryTimestamp": null
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "5402586532"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/26/office-50479/f35c2da73ed594bfbe25fc259fabe636.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "45200"
"ResourceRecordKey" => "50479"
"ModificationTimestamp" => "2021-02-23T19:51:00Z"
]
]
+"OfficeFax": "416-736-9766"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "12753"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "50479"
"SocialMediaUrlOrId" => "http://www.spectrumrealtyservices.com/"
"ModificationTimestamp" => "2021-02-23T19:51:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1058281"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('50479')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882220/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882220&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882220/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882220&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25492
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29167450" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25098
+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 29167450/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167450&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167450/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167450&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25078
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167450 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9070855 43.3377516)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167450 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9070855 43.3377516)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167450 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9070855 43.3377516)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167450 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9070855 43.3377516)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25343
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24946
+post_id: "468273"
+post_author: 1
+"ListingKey": "29169820"
+"ListingId": "X12608304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T19:25:23Z"
+"RFModificationTimestamp": "2025-12-07T22:51:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "BASEMENT - 7 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8831437
1 => 43.3349547
]
+"Latitude": 43.3349547
+"Longitude": -79.8831437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully renovated, this bright and spacious 2 bed, 1 bath basement apartment features a private entrance and a prime location in Waterdown, just minutes from parks, major highways, downtown Burlington, and the lake. Enjoy the convenience of a Ensuite laundry room, driveway parking for one vehicle, and ample street parking. Located close to Aldershot GO Station for easy commuting. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-07T22:51:07.326532+00:00"
+"Directions": "Dundas & Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157654"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "11.9 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-07T19:17:30Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T19:17:30Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169820/basement-7-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1529658"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "84654"
+"GeocodeManualYN": false
+"TotalActualRent": 2150
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 11.9
+"OriginalEntryTimestamp": "2025-12-07T19:17:30.06Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6359952410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/c567e6e033af767f81ae3007490159ab.webp"
"MediaSize" => 67262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-c567e6e033af767f81ae3007490159ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6359952411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/bb4976318b3df1b8c5dfa59f6db5cf7c.webp"
"MediaSize" => 73824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-bb4976318b3df1b8c5dfa59f6db5cf7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6359952412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/9facb7eb1e7dbff901a71165ebe18d8f.webp"
"MediaSize" => 54920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-9facb7eb1e7dbff901a71165ebe18d8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6359952413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/930e07a52e8859a13fa6a6ee2cea1c22.webp"
"MediaSize" => 53914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-930e07a52e8859a13fa6a6ee2cea1c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6359952414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/c54b6485c92f00c7aa2b7ed2da3f3fab.webp"
"MediaSize" => 55242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-c54b6485c92f00c7aa2b7ed2da3f3fab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6359952415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/fe511e75e81f75d6fd9bb8ae6f6db675.webp"
"MediaSize" => 59986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-fe511e75e81f75d6fd9bb8ae6f6db675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6359952416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/0da27420513e89cd3700f7b66aea988c.webp"
"MediaSize" => 60379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-0da27420513e89cd3700f7b66aea988c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6359952417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/a7aaba3783df4196d4d04a885d7cff6f.webp"
"MediaSize" => 58597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-a7aaba3783df4196d4d04a885d7cff6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6359952418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/caa7376e4aa10db651e2d54195f4c00e.webp"
"MediaSize" => 59361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-caa7376e4aa10db651e2d54195f4c00e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6359952419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/7ff54308cff960525dd1fe840dc08aa4.webp"
"MediaSize" => 55362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-7ff54308cff960525dd1fe840dc08aa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6359952420"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/08029850606b623206a0803a6fe73731.webp"
"MediaSize" => 57056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-08029850606b623206a0803a6fe73731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6359952421"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29169820/ba4d7d092f624b6291c473002cea7cda.webp"
"MediaSize" => 61609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29169820/thumbnail-ba4d7d092f624b6291c473002cea7cda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12608304"
"ResourceRecordKey" => "29169820"
"ModificationTimestamp" => "2025-12-07T19:17:30.07Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169820')"
+"ID": "468273"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "465641"
+post_author: 1
+"ListingKey": "29165840"
+"ListingId": "X12604156"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:55:38Z"
+"RFModificationTimestamp": "2025-12-07T21:59:30Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0S5"
+"UnparsedAddress": "24 MACBEAN CRESCENT, Hamilton (Waterdown), Ontario L8B0S5"
+"Coordinates": array:2 [
0 => -79.9148351
1 => 43.3358708
]
+"Latitude": 43.3358708
+"Longitude": -79.9148351
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 24 Macbean Crescent where elegance meets sophistication, a testament to the ultimate design in every detail. This meticulously maintained 2 Storey home with a gorgeous exterior facade and a double car garage will have you falling in love, not to mention the professionally installed stamped concrete front porch and steps (2021). Over 3000 sq ft of finished living space, 4 spacious bedrooms, 5 updated bathrooms, it truly offers all that you desire! As you enter the home through the upgraded front entrance door (2020), you will appreciate the bright and open foyer with lovely floor tiles (2019) and custom built in cabinets. Next is the luxurious living room, the shiny and bright pot lights that complement the coffered ceilings so seamlessly to the opulent brick veneer wall (2022) and custom built in cabinetry for those memorable family photos. Let's make our way to the exquisite kitchen (2019) with gorgeous cabinetry and cedar stone countertops to add that unique touch. With newer appliances, stylish fixtures, an oversized kitchen island and large sliding doors that lead to the backyard, what more could you ask for? Speaking of the backyard, check that oasis out. Some notable features are the canopy awning (2023) and the exposed aggregate concrete (2023). As we head upstairs you will appreciate that the carpets have been removed & replaced with newer flooring in all the bedrooms. There are 4 spacious bedrooms & 3 bathrooms. Two of the bedrooms have updated ensuites. The primary bedroom has a huge walk-in closet and a 5pc ensuite! All the bedrooms have CUSTOM closet organizers (2023) that were specifically designed for each closet. WOW! The finished basement (2019) provides a kitchenette, a 3-pc bathroom, family area for those get-togethers, and a spacious room that could be used as a gym or office, you decide! This beautiful home is within steps to the conservation area and parks. All other amenities are conveniently located near you. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T20:08:14.985128+00:00"
+"Directions": "Cross Streets: Macbean & Nisbet. ** Directions: PARKSIDE DR., WINBERLEY AVE, NISBET BLVD, MACBEAN."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238085"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 88.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T16:25:12Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:41:19Z"
+"Stories": "2.0"
+"StreetName": "Macbean"
+"StreetNumber": "24"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8735.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1546311111"
"RoomType" => "Foyer"
"ListingId" => "X12604156"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29165840"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.73Z"
]
1 => array:11 [
"RoomKey" => "1546311112"
"RoomType" => "Other"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 2.34
"ListingKey" => "29165840"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.73Z"
]
2 => array:11 [
"RoomKey" => "1546311113"
"RoomType" => "Bathroom"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 2.36
"ListingKey" => "29165840"
"RoomLength" => 2.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.73Z"
]
3 => array:11 [
"RoomKey" => "1546311114"
"RoomType" => "Kitchen"
"ListingId" => "X12604156"
"RoomLevel" => "Basement"
"RoomWidth" => 3.4
"ListingKey" => "29165840"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.73Z"
]
4 => array:11 [
"RoomKey" => "1546311115"
"RoomType" => "Bathroom"
"ListingId" => "X12604156"
"RoomLevel" => "Basement"
"RoomWidth" => 1.24
"ListingKey" => "29165840"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
5 => array:11 [
"RoomKey" => "1546311116"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12604156"
"RoomLevel" => "Basement"
"RoomWidth" => 4.39
"ListingKey" => "29165840"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
6 => array:11 [
"RoomKey" => "1546311117"
"RoomType" => "Dining room"
"ListingId" => "X12604156"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29165840"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
7 => array:11 [
"RoomKey" => "1546311118"
"RoomType" => "Exercise room"
"ListingId" => "X12604156"
"RoomLevel" => "Basement"
"RoomWidth" => 4.52
"ListingKey" => "29165840"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
8 => array:11 [
"RoomKey" => "1546311119"
"RoomType" => "Other"
"ListingId" => "X12604156"
"RoomLevel" => "Basement"
"RoomWidth" => 2.95
"ListingKey" => "29165840"
"RoomLength" => 6.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
9 => array:11 [
"RoomKey" => "1546311120"
"RoomType" => "Kitchen"
"ListingId" => "X12604156"
"RoomLevel" => "Main level"
"RoomWidth" => 5.18
"ListingKey" => "29165840"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
10 => array:11 [
"RoomKey" => "1546311121"
"RoomType" => "Living room"
"ListingId" => "X12604156"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29165840"
"RoomLength" => 5.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
11 => array:11 [
"RoomKey" => "1546311122"
"RoomType" => "Bathroom"
"ListingId" => "X12604156"
"RoomLevel" => "Main level"
"RoomWidth" => 1.3
"ListingKey" => "29165840"
"RoomLength" => 1.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
12 => array:11 [
"RoomKey" => "1546311123"
"RoomType" => "Bedroom"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29165840"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
13 => array:11 [
"RoomKey" => "1546311124"
"RoomType" => "Bedroom 2"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.73
"ListingKey" => "29165840"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
14 => array:11 [
"RoomKey" => "1546311125"
"RoomType" => "Bedroom 3"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29165840"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.74Z"
]
15 => array:11 [
"RoomKey" => "1546311126"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29165840"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.75Z"
]
16 => array:11 [
"RoomKey" => "1546311127"
"RoomType" => "Bathroom"
"ListingId" => "X12604156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29165840"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-07T21:16:52.75Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29165840/24-macbean-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2025-12-05T16:25:12.31Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6357026811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/b60197cc24403f8260a095a53783aee3.webp"
"MediaSize" => 129799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-b60197cc24403f8260a095a53783aee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6357026834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/0011fe6bef9237bd30b420dbe09a426f.webp"
"MediaSize" => 157967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-0011fe6bef9237bd30b420dbe09a426f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6357026849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/9ad09d932aa490b948983c8dc7bce7b8.webp"
"MediaSize" => 147821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-9ad09d932aa490b948983c8dc7bce7b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6357026864"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/332d3dba6b7a8ad9ee7a95979473b842.webp"
"MediaSize" => 67851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-332d3dba6b7a8ad9ee7a95979473b842.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6357026876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/3ea052d7cddd8dc0854f72391428f362.webp"
"MediaSize" => 55524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-3ea052d7cddd8dc0854f72391428f362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6357026895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/e6e54a8c6c2e873bc6b36ad639a949bc.webp"
"MediaSize" => 97834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-e6e54a8c6c2e873bc6b36ad639a949bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6357026906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/3d153f2607bfc7c74c6148ba46081d81.webp"
"MediaSize" => 84881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-3d153f2607bfc7c74c6148ba46081d81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6357026927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/c4db22b52ab8df0d4d547c0f29b55d12.webp"
"MediaSize" => 79438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-c4db22b52ab8df0d4d547c0f29b55d12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6357026958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/a623aca0f6c314ccc9369e9b605f454d.webp"
"MediaSize" => 54766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-a623aca0f6c314ccc9369e9b605f454d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6357027046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/ed4259a6d14eebfab72126ad33fbb8a7.webp"
"MediaSize" => 56752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-ed4259a6d14eebfab72126ad33fbb8a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6357027069"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/67e78ff020f0e7a035a5285701a343b9.webp"
"MediaSize" => 80548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-67e78ff020f0e7a035a5285701a343b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6357027089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/98bc86d0b5ec57ee8936eaa6311b8664.webp"
"MediaSize" => 74781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-98bc86d0b5ec57ee8936eaa6311b8664.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6357027091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/ad134ca4e93a29b8c4f81d7fa1bbe683.webp"
"MediaSize" => 73672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-ad134ca4e93a29b8c4f81d7fa1bbe683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6357027107"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/0f2fb50d52cb744e01a61103bf4d6904.webp"
"MediaSize" => 64792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-0f2fb50d52cb744e01a61103bf4d6904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6357027124"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/1ed73c3d0b1aa91b9962bbb8d5decb06.webp"
"MediaSize" => 81229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-1ed73c3d0b1aa91b9962bbb8d5decb06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6357027146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29165840/a08e196b589548cca3bb7a7dc87890cd.webp"
"MediaSize" => 76753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29165840/thumbnail-a08e196b589548cca3bb7a7dc87890cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12604156"
"ResourceRecordKey" => "29165840"
"ModificationTimestamp" => "2025-12-05T16:25:12.31Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6357027159"
…11
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165840')"
+"ID": "465641"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24959
+post_id: "465136"
+post_author: 1
+"ListingKey": "29165443"
+"ListingId": "40792547"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:26:03Z"
+"RFModificationTimestamp": "2025-12-07T21:28:21Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2814.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0S5"
+"UnparsedAddress": "24 MACBEAN Crescent, Waterdown, Ontario L8B0S5"
+"Coordinates": array:2 [
0 => -79.9138217
1 => 43.3358699
]
+"Latitude": 43.3358699
+"Longitude": -79.9138217
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 24 Macbean Crescent where elegance meets sophistication, a testament to the ultimate design in every detail. This meticulously maintained 2 Storey home with a gorgeous exterior facade and a double car garage will have you falling in love, not to mention the professionally installed stamped concrete front porch and steps (2021). Over 3000 sq ft of finished living space, 4 spacious bedrooms, 5 updated bathrooms, it truly offers all that you desire! As you enter the home through the upgraded front entrance door (2020), you will appreciate the bright and open foyer with lovely floor tiles (2019) and custom built in cabinets. Next is the luxurious living room, the shiny and bright pot lights that complement the coffered ceilings so seamlessly to the opulent brick veneer wall (2022) and custom built in cabinetry for those memorable family photos. Let’s make our way to the exquisite kitchen (2019) with gorgeous cabinetry and cedar stone countertops to add that unique touch. With newer appliances, stylish fixtures, an oversized kitchen island and large sliding doors that lead to the backyard, what more could you ask for? Speaking of the backyard, check that oasis out. Some notable features are the canopy awning (2023) and the exposed aggregate concrete (2023). As we head upstairs you will appreciate that the carpets have been removed & replaced with newer flooring in all the bedrooms. There are 4 spacious bedrooms & 3 bathrooms. Two of the bedrooms have updated ensuites. The primary bedroom has a huge walk-in closet and a 5pc ensuite! All the bedrooms have CUSTOM closet organizers (2023) that were specifically designed for each closet. WOW! The finished basement (2019) provides a kitchenette, a 3-pc bathroom, family area for those get-togethers, and a spacious room that could be used as a gym or office, you decide! This beautiful home is within steps to the conservation area and parks. All other amenities are conveniently located near you. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T17:14:21.584969+00:00"
+"Directions": "PARKSIDE DR., WINBERLEY AVE, NISBET BLVD, MACBEAN"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159089"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T15:08:43Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:11:27Z"
+"Stories": "2.0"
+"StreetName": "MACBEAN"
+"StreetNumber": "24"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "8735.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29165443/24-macbean-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-31"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2814
+"OriginalEntryTimestamp": "2025-12-05T15:08:43.47Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165443')"
+"ID": "465136"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24947
+post_id: "464308"
+post_author: 1
+"ListingKey": "29164823"
+"ListingId": "X12603202"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T01:55:24Z"
+"RFModificationTimestamp": "2025-12-05T03:38:03Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.886026
1 => 43.331229
]
+"Latitude": 43.331229
+"Longitude": -79.886026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. Potential to assemble with property next door. VTB FINANCING AVAILABLE. Consider the possibilities for your dream home or as an investment. (id:62650)"
+"CreationDate": "2025-12-05T03:37:47.851068+00:00"
+"Directions": "Cross Streets: Dundas Street. ** Directions: Mill St. S. is Waterdown Rd. south of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "61.88 x 124 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T01:47:01Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T01:47:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3773"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29164823/191-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 61.1
+"OriginalEntryTimestamp": "2025-12-05T01:47:01.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29164823')"
+"ID": "464308"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24945
+post_id: "463014"
+post_author: 1
+"ListingKey": "29161684"
+"ListingId": "40792230"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T15:05:56Z"
+"RFModificationTimestamp": "2025-12-04T21:13:14Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.428
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL Street S, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8859059
1 => 43.3312732
]
+"Latitude": 43.3312732
+"Longitude": -79.8859059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. VTB FINANCING AVAILABLE. Newly severed Lot. Consider the possibilities for your dream home or as an investment. Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-04T21:12:51.956561+00:00"
+"Directions": "Mill St. S. is Waterdown Rd., S of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "284639"
+"LotSizeDimensions": "0.428"
+"PhotosChangeTimestamp": "2025-12-04T14:59:58Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T14:59:57Z"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3773"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161684/191-mill-street-s-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "O1, CM"
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2025-12-04T14:59:57.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161684')"
+"ID": "463014"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24970
+post_id: "463015"
+post_author: 1
+"ListingKey": "29161927"
+"ListingId": "40791925"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:40:28Z"
+"RFModificationTimestamp": "2025-12-07T21:41:40Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1682.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "383 DUNDAS Street E Unit# 21, Waterdown, Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.8875746
1 => 43.3386557
]
+"Latitude": 43.3386557
+"Longitude": -79.8875746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown’s family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:40:54.576685+00:00"
+"Directions": "Dundas St E to complex."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:00:37Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:29:21Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4053.09"
+"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/29161927/383-dundas-street-e-unit-21-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2059038"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "HC-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1682
+"OriginalEntryTimestamp": "2025-12-04T16:00:37.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:44 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161927')"
+"ID": "463015"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23672
+post_id: "463016"
+post_author: 1
+"ListingKey": "29161992"
+"ListingId": "40792282"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T21:40:21Z"
+"RFModificationTimestamp": "2025-12-06T21:44:46Z"
+"ListPrice": 1388000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3029.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "20 VINEGAR Hill, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8900722
1 => 43.3362821
]
+"Latitude": 43.3362821
+"Longitude": -79.8900722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional 3,000+ sq ft custom-built 4-bedroom home on a rare 60-foot-wide lot in one of Waterdown's most desirable neighbourhoods. Just a 4-minute stroll to Waterdown's historic village and downtown amenities, this property showcases quality craftsmanship, a thoughtful floor plan, and features that set it apart from a standard subdivision home. The main level offers a spacious formal living/dining room, a dedicated den/home office, a large eat-in kitchen with high-end appliances, and an inviting family room filled with natural light. Upstairs, you'll find four oversized bedrooms, including a primary suite with a walk-in closet and 5-pc ensuite. The second bedroom also includes its own private 4-pc ensuite - an ideal setup for multigenerational living. A skylit landing and walkout to a charming balcony add distinctive architectural character. Excellent versatility continues on the lower level, with two staircases and a separate entrance, offering potential for an in-law suite, teen retreat, or income-generating unit. Perfectly located within walking distance to Waterdown's historic village and local conveniences, and just minutes from the Bruce Trail, Smokey Hollow Waterfall, parks, and scenic ravine paths. Easy access to major highways and Aldershot GO Station. A rare opportunity on a street where homes seldom come to market. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:02:18.932559+00:00"
+"Directions": "Dundas St & Vinegar Hill"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:11:05Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T21:29:16Z"
+"Stories": "2.0"
+"StreetName": "VINEGAR"
+"StreetNumber": "20"
+"StreetSuffix": "Hill"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7324"
+"VirtualTourURLUnbranded": "https://youtu.be/TeI63sfVOxE"
+"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/29161992/20-vinegar-hill-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 3029
+"OriginalEntryTimestamp": "2025-12-04T16:09:19.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161992')"
+"ID": "463016"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "462368"
+post_author: 1
+"ListingKey": "29162472"
+"ListingId": "X12600986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T13:30:52Z"
+"RFModificationTimestamp": "2025-12-07T13:32:57Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "21 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown's family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T18:42:36.525089+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Dundas St E To Complex."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:49:49Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T13:16:04Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4053.09"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29162472/21-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1989315"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Mgmt"
+"CoListOfficeKey": "269164"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-12-04T16:49:49.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:44 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29162472')"
+"ID": "462368"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "461429"
+post_author: 1
+"ListingKey": "29159998"
+"ListingId": "X12598508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T20:35:28Z"
+"RFModificationTimestamp": "2025-12-03T23:14:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0H4"
+"UnparsedAddress": "71 ROYALEDGE WAY, Hamilton (Waterdown), Ontario L8B0H4"
+"Coordinates": array:2 [
0 => -79.9067199
1 => 43.3285726
]
+"Latitude": 43.3285726
+"Longitude": -79.9067199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 71 Royaledge Way, a meticulously cared-for 4-bedroom, 3-bathroom family home located in Waterdown West - one of the city's most desirable and truly family-friendly neighbourhoods. Loved by the same owners for 20 years, this property shines with pride of ownership and thoughtful updates throughout. The second floor features four spacious bedrooms, including a generous primary suite with ensuite and walk-in closet. The main floor offers a timeless dining/family room combo, an eat-in kitchen, main-floor laundry, a 2-piece bath, and a warm, cosy living room with a working gas fireplace - an ideal space to unwind. The kitchen was fully renovated in 2022, and the appliances are only six months old, offering a fresh and modern space for everyday living. Additional major upgrades include window replacements in 2013 and 2021, a front door replaced in 2021, a furnace installed in 2018, and two air conditioners (2010 & 2013). The roof was replaced in 2008 with 40-year shingles, providing long-term peace of mind. Step into the backyard to find a true retreat. The swim spa (installed four years ago) includes a brand-new cover and features a designated electrical breaker, adding safety and convenience. Paired with the gazebo and the beautifully maintained landscaping, this space is perfect for hosting friends, family, or enjoying quiet evenings outdoors. The double garage offers a brand-new epoxy floor, steel insulated garage door, and room for two cars plus storage, along with a four-car driveway. All systems and utilities have been regularly serviced, ensuring dependable upkeep for years to come. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Full"
1 => "Walk-up"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T23:14:36.077805+00:00"
+"Directions": "Dundas St W & Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "45 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T20:24:33Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T20:24:33Z"
+"Stories": "2.0"
+"StreetName": "Royaledge"
+"StreetNumber": "71"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "6495.02"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/71_royaledge_way_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29159998/71-royaledge-way-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Canopy"
1 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-12-03T20:24:33.37Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159998')"
+"ID": "461429"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 111
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]