array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29148499/Property?$select=ALL&$top=20&$filter=ListingKey eq 29148499&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29148499/Property?$select=ALL&$top=20&$filter=ListingKey eq 29148499&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23660
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23662
+post_id: "453133"
+post_author: 1
+"ListingKey": "29148499"
+"ListingId": "X12587452"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T16:06:00Z"
+"RFModificationTimestamp": "2025-11-29T16:20:44Z"
+"ListPrice": 835000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W3"
+"UnparsedAddress": "137 BORERS CREEK CIR CIRCLE, Hamilton (Waterdown), Ontario L8B1W3"
+"Coordinates": array:2 [
0 => -79.918744
1 => 43.332311
]
+"Latitude": 43.332311
+"Longitude": -79.918744
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully upgraded, turn-key executive freehold townhome-an exceptional blend of space, style, and comfort in one of the area's most sought-after locations. Boasting over 3 bedrooms, 2.5 bathrooms, and a rare interior layout filled with natural light, this meticulously maintained home features 9-foot ceilings, a main floor library/office, and a finished basement with custom detailing. Enjoy a stunning gourmet kitchen with quartz countertops, stainless steel appliances, and a walk-out to a balcony perfect for morning coffee or evening relaxation. The inviting living room offers a cozy fireplace, built-in shelving, and oversized windows, while the spacious primary suite includes a custom wall feature, 3-piece ensuite, walk-in closet, and its own balcony. With newly upgraded flooring throughout, upper-level laundry, and a private backyard patio with a new fence, this home is designed for modern living. Located close to top-rated schools, scenic trails, restaurants, shops, the GO Station, and highways, this bright and clean gem is ready to welcome its new owner. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-29T16:20:32.215942+00:00"
+"Directions": "Cross Streets: Parkside Dr / Mosaic Dr. ** Directions: Parkside Dr/Mosaic Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1642225"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 77.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-29T15:53:14Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T15:53:14Z"
+"Stories": "3.0"
+"StreetName": "Borers Creek cir"
+"StreetNumber": "137"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "5430"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1541997719"
"RoomType" => "Living room"
"ListingId" => "X12587452"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.02Z"
]
1 => array:11 [
"RoomKey" => "1541997720"
"RoomType" => "Family room"
"ListingId" => "X12587452"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.02Z"
]
2 => array:11 [
"RoomKey" => "1541997721"
"RoomType" => "Dining room"
"ListingId" => "X12587452"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
3 => array:11 [
"RoomKey" => "1541997722"
"RoomType" => "Kitchen"
"ListingId" => "X12587452"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
4 => array:11 [
"RoomKey" => "1541997723"
"RoomType" => "Laundry room"
"ListingId" => "X12587452"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
5 => array:11 [
"RoomKey" => "1541997724"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12587452"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
6 => array:11 [
"RoomKey" => "1541997725"
"RoomType" => "Bedroom 2"
"ListingId" => "X12587452"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
7 => array:11 [
"RoomKey" => "1541997726"
"RoomType" => "Bedroom 3"
"ListingId" => "X12587452"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29148499"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T15:53:14.03Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29148499/137-borers-creek-cir-circle-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2025-11-29T15:53:13.86Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6346190845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/4eacfe8dc0770f911dfc799a10932b5f.webp"
"MediaSize" => 76449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-4eacfe8dc0770f911dfc799a10932b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6346190850"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/fee96002ddf1adfff3bae4b835e1f8e5.webp"
"MediaSize" => 81362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-fee96002ddf1adfff3bae4b835e1f8e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6346190853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/cdcab8996436f5c84b356cf7851a4459.webp"
"MediaSize" => 94403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-cdcab8996436f5c84b356cf7851a4459.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6346190855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/744f97b9727399c6a01582a409e14818.webp"
"MediaSize" => 114445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-744f97b9727399c6a01582a409e14818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6346190857"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/2d58a152b7506c61082f06f354d6e87c.webp"
"MediaSize" => 88547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-2d58a152b7506c61082f06f354d6e87c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6346190859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/8705e92f4f2699f66bc524afc4de3188.webp"
"MediaSize" => 96725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-8705e92f4f2699f66bc524afc4de3188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6346190862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/74f22edf3bd2507b6639d2499512c32d.webp"
"MediaSize" => 75092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-74f22edf3bd2507b6639d2499512c32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6346190864"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/1cf3fd412f2d328e2ca108c893a1ebdb.webp"
"MediaSize" => 111620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-1cf3fd412f2d328e2ca108c893a1ebdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6346190865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/34035b257ece28dc4f58f25b96fd95df.webp"
"MediaSize" => 51500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-34035b257ece28dc4f58f25b96fd95df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6346190867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/94e3ce0bb72ffbb316eb82ec3c11acea.webp"
"MediaSize" => 100454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-94e3ce0bb72ffbb316eb82ec3c11acea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6346190868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/dfa0784af88be2ffc79c18ae94349259.webp"
"MediaSize" => 102544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-dfa0784af88be2ffc79c18ae94349259.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6346190871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/069b1cd785734435e4b28e70ad813f23.webp"
"MediaSize" => 76373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-069b1cd785734435e4b28e70ad813f23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6346190872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/bee7d7fc6a7a952217c02d87d720206e.webp"
"MediaSize" => 114859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-bee7d7fc6a7a952217c02d87d720206e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6346190874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/8e18dad6db2800c740a61c8e2a19ae97.webp"
"MediaSize" => 198350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-8e18dad6db2800c740a61c8e2a19ae97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6346190875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/e6936ad2a7ec84cc16fe6ab3d7aa5730.webp"
"MediaSize" => 70193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-e6936ad2a7ec84cc16fe6ab3d7aa5730.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6346190877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/9f4048e3bd80da0f0ca4900204acc9a4.webp"
"MediaSize" => 49524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-9f4048e3bd80da0f0ca4900204acc9a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6346190882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/4fb84d70b1fed1c63bd256b088062b8e.webp"
"MediaSize" => 82539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-4fb84d70b1fed1c63bd256b088062b8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6346190887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/6222691295eb0d44b38c50641e104769.webp"
"MediaSize" => 167861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-6222691295eb0d44b38c50641e104769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6346190892"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/359cc79e9408f16b3442272974ba60ab.webp"
"MediaSize" => 99389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-359cc79e9408f16b3442272974ba60ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6346190893"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/2b9a249c5219d858a2830c33bd99664d.webp"
"MediaSize" => 107740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-2b9a249c5219d858a2830c33bd99664d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6346190894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/2f341bc18038b8f0c4f552a84a15857a.webp"
"MediaSize" => 115612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-2f341bc18038b8f0c4f552a84a15857a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6346190895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/c487b1335432ea70a5e2513ecb55fb0c.webp"
"MediaSize" => 127866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-c487b1335432ea70a5e2513ecb55fb0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6346190896"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/869a901e9f841e2b70c813277ff1fc6e.webp"
"MediaSize" => 100249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-869a901e9f841e2b70c813277ff1fc6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6346190897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/2dd71d62876f9a8a7a2aca539f2162fb.webp"
"MediaSize" => 96521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-2dd71d62876f9a8a7a2aca539f2162fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6346190898"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/af6cd46a1e6bfd95fae07f8079c5132d.webp"
"MediaSize" => 89004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-af6cd46a1e6bfd95fae07f8079c5132d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6346190899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/1ecc785d79f0afe535dd329098bfed99.webp"
"MediaSize" => 62791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-1ecc785d79f0afe535dd329098bfed99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6346190900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/e5667c3ad25f01539a435846c47dc5ee.webp"
"MediaSize" => 99140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-e5667c3ad25f01539a435846c47dc5ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6346190901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/876f46c913e61d952641a6351e637efc.webp"
"MediaSize" => 101986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-876f46c913e61d952641a6351e637efc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6346190902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/79330fe4cec71fcd390ad964373dcdd6.webp"
"MediaSize" => 100261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-79330fe4cec71fcd390ad964373dcdd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6346190903"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29148499/9c55659e6a701058d9dd4650f254ff3e.webp"
"MediaSize" => 103891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29148499/thumbnail-9c55659e6a701058d9dd4650f254ff3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12587452"
"ResourceRecordKey" => "29148499"
"ModificationTimestamp" => "2025-11-29T15:53:13.87Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "TAREK EL-MASRY"
"MemberFirstName" => "TAREK"
"MemberLastName" => "EL-MASRY"
"MemberMlsId" => "9526012"
"OriginatingSystemName" => 26
"MemberKey" => "1642225"
"ModificationTimestamp" => "2025-08-13T13:00:44Z"
"MemberStatus" => "Active"
"OfficeKey" => "285001"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "905-270-2000"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1165210"
"OfficeNationalAssociationId" => "1346507"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX REAL ESTATE CENTRE INC."
"OfficePhone" => "905-270-2000"
"OfficeMlsId" => "79822"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "285001"
"ModificationTimestamp" => "2025-08-26T23:33:50Z"
"OfficeAddress1" => "1140 BURNHAMTHORPE RD W #141-A"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5C4E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-270-0047"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2019-04-01T22:53:00Z"
"OfficeNationalAssociationId" => "1346507"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1457687"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29148499')"
+"ID": "453133"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 285001/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285001&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285001/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285001&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25491
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25493
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OfficeEmail": null
+"OfficePhone": "905-270-2000"
+"OfficeMlsId": "79822"
+"ModificationTimestamp": "2025-08-26T23:33:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285001"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1140 BURNHAMTHORPE RD W #141-A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5C4E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1346507"
+"OriginalEntryTimestamp": "2019-04-01T22:53:00Z"
+"OfficeFax": "905-270-0047"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1457687"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('285001')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1642225/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1642225&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1642225/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1642225&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25496
+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 29148499" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25092
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29148499/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29148499&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29148499/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29148499&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25072
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29148499 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.918744 43.332311)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29148499 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.918744 43.332311)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29148499 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.918744 43.332311)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29148499 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.918744 43.332311)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "470906"
+post_author: 1
+"ListingKey": "29174288"
+"ListingId": "X12612860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T22:00:41Z"
+"RFModificationTimestamp": "2025-12-09T22:06:45Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0T3"
+"UnparsedAddress": "61 BOUSFIELD RISE, Hamilton (Waterdown), Ontario L8B0T3"
+"Coordinates": array:2 [
0 => -79.9218276
1 => 43.3275486
]
+"Latitude": 43.3275486
+"Longitude": -79.9218276
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**Absolutely Beautiful** Spacious Semi-Detached Premium Lot Backing onto Greenspace. Open concept with over 2200SF of Finished Living Space, nestled in a quiet area of Waterdown. This turnkey home is move in ready with tons of upgrades, California Shutters (2023), Retractable Zebra Shutter (2023), Closet Organizers (2022), Finished Laundry Rm with Floating shelves & Stainless-steel sink (2024), Bathrooms on Upper Fl with quartz vanities (2024), Toilets (2022), Bidets in bathrooms. Hardwood Flr in Bdrms (2020), Updated Kitchen Cabinets (2020) Kitchen appliances, Upgraded Windows & Frosted windows in Upper bathrooms (2022 & 2024), Entire yard fully Landscaped (2023), Sump pump with backup generator (2024), Bsmt carpet (2020), Furnace & AC (2025), Weather Proofing Inside & Out (2024), Driveway (2023). Hardwood Floors, Stainless Steel Appliances, Oak Staircase with Wrought Iron Spindles, Finished Basement with Rough in bathroom. Finished Laundry room with built in Floating Shelves. Close to Hwy 403, 6, 401. Schools, Shopping, Ymca, Library. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T18:45:23.617260+00:00"
+"Directions": "Cross Streets: Parkside/Sadielou. ** Directions: Parkside and Sadielou."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417041"
+"ListOfficeKey": "51273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
]
+"LotSizeDimensions": "26.9 x 99.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T17:46:07Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T21:45:41Z"
+"Stories": "2.0"
+"StreetName": "Bousfield"
+"StreetNumber": "61"
+"StreetSuffix": "Rise"
+"TaxAnnualAmount": "5928.61"
+"VirtualTourURLUnbranded": "https://tours.sf-photography-photographer.com/61-bousfield-rise-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1547199960"
"RoomType" => "Family room"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29174288"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
1 => array:11 [
"RoomKey" => "1547199961"
"RoomType" => "Kitchen"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 2.56
"ListingKey" => "29174288"
"RoomLength" => 5.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
2 => array:11 [
"RoomKey" => "1547199962"
"RoomType" => "Dining room"
"ListingId" => "X12612860"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29174288"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
3 => array:11 [
"RoomKey" => "1547199963"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.77
"ListingKey" => "29174288"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
4 => array:11 [
"RoomKey" => "1547199964"
"RoomType" => "Bedroom 2"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.66
"ListingKey" => "29174288"
"RoomLength" => 3.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
5 => array:11 [
"RoomKey" => "1547199965"
"RoomType" => "Bedroom 3"
"ListingId" => "X12612860"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.71
"ListingKey" => "29174288"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
6 => array:11 [
"RoomKey" => "1547199966"
"RoomType" => "Laundry room"
"ListingId" => "X12612860"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.88
"ListingKey" => "29174288"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
7 => array:11 [
"RoomKey" => "1547199967"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12612860"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.99
"ListingKey" => "29174288"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T21:45:41.4Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29174288/61-bousfield-rise-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2025-12-09T17:46:07.53Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362888228"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/0dd13fafa73e64ad24634c2736ea35c3.webp"
"MediaSize" => 233376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-0dd13fafa73e64ad24634c2736ea35c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362888240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ceb985d0413eaa1cdcaa973a6b99f0c6.webp"
"MediaSize" => 216993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ceb985d0413eaa1cdcaa973a6b99f0c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362888255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/4304dd1ea799b28ec79c04bfb8993308.webp"
"MediaSize" => 259688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-4304dd1ea799b28ec79c04bfb8993308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362888266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/cca114e5e0a4798241e8bf6f3e08cff7.webp"
"MediaSize" => 227266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-cca114e5e0a4798241e8bf6f3e08cff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362888281"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/1fe9d53413789c30d24b075bfe2163f4.webp"
"MediaSize" => 187106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-1fe9d53413789c30d24b075bfe2163f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362888294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ba9a1c14bf82066ce3dffc5d03004ba6.webp"
"MediaSize" => 86857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ba9a1c14bf82066ce3dffc5d03004ba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362888310"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/2263eb9de499f02ab032d1505fb1b02b.webp"
"MediaSize" => 65972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-2263eb9de499f02ab032d1505fb1b02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362888316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/76398dded3a888a13265332436fa73f4.webp"
"MediaSize" => 97217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-76398dded3a888a13265332436fa73f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362888336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ff29bdbf4c20ef5ff8c708523eb61877.webp"
"MediaSize" => 80767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ff29bdbf4c20ef5ff8c708523eb61877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362888358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/ed17564bf229e71fd003af6286f40fae.webp"
"MediaSize" => 64984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-ed17564bf229e71fd003af6286f40fae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362888390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/005c978ab127a527fba9c3483ed44315.webp"
"MediaSize" => 78828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-005c978ab127a527fba9c3483ed44315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362888400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/020fbe52de07e8441da603e48b9c64ce.webp"
"MediaSize" => 89355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-020fbe52de07e8441da603e48b9c64ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362888436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/44c2a94c5094fa8992f70972af1f5054.webp"
"MediaSize" => 105041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-44c2a94c5094fa8992f70972af1f5054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362888446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/5e3cfebce9028fde9875718d7c07a73a.webp"
"MediaSize" => 108211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174288/thumbnail-5e3cfebce9028fde9875718d7c07a73a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612860"
"ResourceRecordKey" => "29174288"
"ModificationTimestamp" => "2025-12-09T17:46:07.57Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362888462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174288/b37a561c582b86436c42f40d337e98be.webp"
"MediaSize" => 121755
…9
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174288')"
+"ID": "470906"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "465887"
+post_author: 1
+"ListingKey": "29167450"
+"ListingId": "X12605800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T19:30:29Z"
+"RFModificationTimestamp": "2025-12-08T19:36:06Z"
+"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-08T19:20:03Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T19:20:03Z"
+"Stories": "3.0"
+"StreetName": "Truedell"
+"StreetNumber": "154"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "4380.37"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/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:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167450')"
+"ID": "465887"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24951
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "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 [ …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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165840')"
+"ID": "465641"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29165443')"
+"ID": "465136"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159998')"
+"ID": "461429"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24950
+post_id: "461233"
+post_author: 1
+"ListingKey": "29160044"
+"ListingId": "40792086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T20:45:54Z"
+"RFModificationTimestamp": "2025-12-03T23:09:13Z"
+"ListPrice": 2097000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4342.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9H7B6"
+"UnparsedAddress": "116 GRINDSTONE Way, Hamilton, Ontario L9H7B6"
+"Coordinates": array:2 [
0 => -79.9064392
1 => 43.3172581
]
+"Latitude": 43.3172581
+"Longitude": -79.9064392
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked away in one of Waterdown’s most desirable neighbourhoods, this executive Vanhoeve built home blends luxury with nature, backing onto a serene ravine. The professionally landscaped yard feels like a private oasis, showcasing a stamped-concrete patio with a custom gas fire pit, a rebuilt composite deck framed by a sleek glass railing, and peaceful, tree-lined views that invite you to unwind. The curb appeal is equally striking with refreshed stucco and a beautifully stamped-concrete driveway and walkway. Inside, the main floor master suite is nothing short of spectacular—anchored by a three-sided wall-hung gas fireplace and complemented by a spa-worthy ensuite featuring a soaker tub, walk-in shower, heated floors, and exquisite slab sliding doors. The living area impresses with vaulted ceilings and a floor-to-ceiling stone fireplace that draws your eye to the stunning ravine backdrop. A stylish dining room, private main-floor den, entertainer’s kitchen, and convenient laundry make main-level living effortless. Upstairs, the loft offers two inviting bedrooms and a gorgeous walk-through bathroom. The fully finished basement transforms into an entertainer’s haven with a custom bar by The Bar Shop, complete with a dishwasher, sink, bar fridge, and convection microwave. The mirror-TV adds a touch of magic, creating the perfect setting for game nights and gatherings. Every corner of this home showcases exceptional craftsmanship and thoughtful detail. Come see this marvelous home for yourself today...you will be glad you did! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dryer"
4 => "Wet Bar"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T23:08:55.792325+00:00"
+"Directions": "Dundas ST E to Dennis Ave, right on Grindstone, left on Waterwheel, Left on Grindstone"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524502"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Wet bar"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T20:38:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T20:38:23Z"
+"Stories": "1.5"
+"StreetName": "GRINDSTONE"
+"StreetNumber": "116"
+"StreetSuffix": "Way"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "11416.65"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=69724"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29160044/116-grindstone-way-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2830
+"BelowGradeFinishedArea": 1512
+"OriginalEntryTimestamp": "2025-12-03T20:38:23.14Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29160044')"
+"ID": "461233"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23674
+post_id: "460528"
+post_author: 1
+"ListingKey": "29159443"
+"ListingId": "X12597946"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T19:00:06Z"
+"RFModificationTimestamp": "2025-12-03T20:02:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "8 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.900589
1 => 43.32762
]
+"Latitude": 43.32762
+"Longitude": -79.900589
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the vibrant heart of Waterdown, this modern 3-level townhome offers an urban oasis with exclusive CTOR rooftop terrace. Perfectly positioned for convenience, The Tannery is steps from local dining, shops, parks, and the library, ideal for those desiring upscale amenities with a charming small-town ambiance. Easy access to 407/403/QEW & Aldershot GO Station. The open-concept main floor is designed for seamless entertaining, featuring a spacious layout and an eat-in kitchen equipped w SS appliances & expansive island/breakfast bar. Retreat to the upper floors where two sizable bedrooms await, each with W/I closets. The master boasts a Juliet balcony with sliding doors & ensuite bath. A convenient in-suite laundry & 2nd full bathroom add to the thoughtful layout. The pinnacle of this unique property is the private rooftop terrace. Enjoy serene evenings under a partially covered area. Including 1 parking space. The perfect package for stylish, convenient living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T20:02:11.134009+00:00"
+"Directions": "Cross Streets: Hamilton St N and Dundas St E. ** Directions: Hamilton St N t o Dundas St E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T18:54:33Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T18:54:33Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29159443/8-219-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2204095"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-03T18:54:33.38Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159443')"
+"ID": "460528"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "460529"
+post_author: 1
+"ListingKey": "29159043"
+"ListingId": "40792041"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T21:40:28Z"
+"RFModificationTimestamp": "2025-12-07T21:41:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2903.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0H4"
+"UnparsedAddress": "71 ROYALEDGE Way, Hamilton, Ontario L8B0H4"
+"Coordinates": array:2 [
0 => -79.906797
1 => 43.328156
]
+"Latitude": 43.328156
+"Longitude": -79.906797
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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, cozy 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. A rare opportunity to own a truly cared-for home in one of Waterdown's most sought-after communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T19:08:22.574897+00:00"
+"Directions": "Dundas St E - Riley St - Royaledge Way"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198019"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T18:00:52Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T21:29:19Z"
+"Stories": "2.0"
+"StreetName": "ROYALEDGE"
+"StreetNumber": "71"
+"StreetSuffix": "Way"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "6495.02"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://listinglightmedia.hd.pics/71-Royaledge-Way"
+"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/29159043/71-royaledge-way-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2084
+"BelowGradeFinishedArea": 819
+"OriginalEntryTimestamp": "2025-12-03T18:00:52.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159043')"
+"ID": "460529"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24976
+post_id: "460173"
+post_author: 1
+"ListingKey": "29158906"
+"ListingId": "40791682"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T17:45:53Z"
+"RFModificationTimestamp": "2025-12-03T18:11:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1474.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "219 DUNDAS Street E Unit# 8, Waterdown, Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.8997755
1 => 43.3271399
]
+"Latitude": 43.3271399
+"Longitude": -79.8997755
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the vibrant heart of Waterdown, this modern 3-level townhome offers an urban oasis with exclusive CTOR rooftop terrace. Perfectly positioned for convenience, The Tannery is steps from local dining, shops, parks, and the library, ideal for those desiring upscale amenities with a charming small-town ambiance. Easy access to 407/403/QEW & Aldershot GO Station. The open-concept main floor is designed for seamless entertaining, featuring a spacious layout and an eat-in kitchen equipped w SS appliances & expansive island/breakfast bar. Retreat to the upper floors where two sizable bedrooms await, each with W/I closets. The master boasts a Juliet balcony with sliding doors & ensuite bath. A convenient in-suite laundry & 2nd full bathroom add to the thoughtful layout. The pinnacle of this unique property is the private rooftop terrace. Enjoy serene evenings under a partially covered area. Including 1 parking space. The perfect package for stylish, convenient living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T18:11:10.805363+00:00"
+"Directions": "Hamilton St. N to Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-03T17:38:24Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T17:38:24Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29158906/219-dundas-street-e-unit-8-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2109591"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "HC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1474
+"OriginalEntryTimestamp": "2025-12-03T17:38:24.56Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29158906')"
+"ID": "460173"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 67
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]