array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29159043/Property?$select=ALL&$top=20&$filter=ListingKey eq 29159043&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29159043/Property?$select=ALL&$top=20&$filter=ListingKey eq 29159043&$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: "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 [
"RoomKey" => "1546322192"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "16'10'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
1 => array:11 [
"RoomKey" => "1546322193"
"RoomType" => "Bedroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
2 => array:11 [
"RoomKey" => "1546322194"
"RoomType" => "Bedroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
3 => array:11 [
"RoomKey" => "1546322195"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
4 => array:11 [
"RoomKey" => "1546322196"
"RoomType" => "3pc Bathroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
5 => array:11 [
"RoomKey" => "1546322197"
"RoomType" => "Bedroom"
"ListingId" => "40792041"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
6 => array:11 [
"RoomKey" => "1546322198"
"RoomType" => "Laundry room"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
7 => array:11 [
"RoomKey" => "1546322199"
"RoomType" => "Living room"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
8 => array:11 [
"RoomKey" => "1546322200"
"RoomType" => "Family room"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.23Z"
]
9 => array:11 [
"RoomKey" => "1546322201"
"RoomType" => "Dining room"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.24Z"
]
10 => array:11 [
"RoomKey" => "1546322202"
"RoomType" => "Eat in kitchen"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.24Z"
]
11 => array:11 [
"RoomKey" => "1546322203"
"RoomType" => "2pc Bathroom"
"ListingId" => "40792041"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29159043"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-07T21:29:19.24Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6353773421"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/1354dad01d1031f689083115216003c1.webp"
"MediaSize" => 75286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-1354dad01d1031f689083115216003c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6353773442"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/fe8dbe00192b9dd39fbe074d1f9e08e6.webp"
"MediaSize" => 69495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-fe8dbe00192b9dd39fbe074d1f9e08e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6353773500"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/f702879cb67c2383091d5a7c70aa0844.webp"
"MediaSize" => 155285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-f702879cb67c2383091d5a7c70aa0844.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6353773558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/ebdb658122262d1a19f7733f7d2b1215.webp"
"MediaSize" => 146897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-ebdb658122262d1a19f7733f7d2b1215.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6353773621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/281b588cbc2ac6e89d6d51d63399bc1f.webp"
"MediaSize" => 38763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-281b588cbc2ac6e89d6d51d63399bc1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6353773690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/f84b5b4a8f542a159f138937d29eba4d.webp"
"MediaSize" => 146231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-f84b5b4a8f542a159f138937d29eba4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6353773752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/1f24bf4e2ee1b04801009a529f044704.webp"
"MediaSize" => 85182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-1f24bf4e2ee1b04801009a529f044704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6353773768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/f226c446d03fa5d52b196f1c8c7c5cb7.webp"
"MediaSize" => 117757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-f226c446d03fa5d52b196f1c8c7c5cb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6353773797"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/029d2e075af5c245a994b7917fc6565a.webp"
"MediaSize" => 112830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-029d2e075af5c245a994b7917fc6565a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6353773817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/42f32f8633dca3327242f79a8b44b259.webp"
"MediaSize" => 108720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-42f32f8633dca3327242f79a8b44b259.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6353773933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/96409cd7df546a928c9c3aadc9319d39.webp"
"MediaSize" => 63660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-96409cd7df546a928c9c3aadc9319d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6353774005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/59701cc9c92095918b621f0907cb047d.webp"
"MediaSize" => 118796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-59701cc9c92095918b621f0907cb047d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6353774060"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/29333a02dc6156b3fd4dbac4ffab9bd9.webp"
"MediaSize" => 94037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-29333a02dc6156b3fd4dbac4ffab9bd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6353774141"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/0753778823dc721e17b34ab5fa620715.webp"
"MediaSize" => 150052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-0753778823dc721e17b34ab5fa620715.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6353774157"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/6a317f9ca12b9be8f99dd101b025c2a0.webp"
"MediaSize" => 148008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-6a317f9ca12b9be8f99dd101b025c2a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6353774224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/6cf4429d8301dc65e7c555d1321a23c9.webp"
"MediaSize" => 144257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-6cf4429d8301dc65e7c555d1321a23c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6353774302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/8631b7233ba299a9b1700c6d768ef516.webp"
"MediaSize" => 145405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-8631b7233ba299a9b1700c6d768ef516.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6353774324"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/9fa3119910a78d209b1cb7502694640f.webp"
"MediaSize" => 80739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-9fa3119910a78d209b1cb7502694640f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6353774392"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/99cbde5f0051c4093da0c18c3ba46eda.webp"
"MediaSize" => 36667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-99cbde5f0051c4093da0c18c3ba46eda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6353774416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/a774f16875fe2c1ad4b2bf4877c38beb.webp"
"MediaSize" => 74646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-a774f16875fe2c1ad4b2bf4877c38beb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6353774549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/a4b355af26bcc65aa7edc8365d53a4cc.webp"
"MediaSize" => 95553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-a4b355af26bcc65aa7edc8365d53a4cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6353774581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/d185120c4e31672336e99aba3c42900b.webp"
"MediaSize" => 164297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-d185120c4e31672336e99aba3c42900b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6353774635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/c6b6b9eb0fc252482e5549c9da45accb.webp"
"MediaSize" => 161501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-c6b6b9eb0fc252482e5549c9da45accb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6353774709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/395ff726e815d8e55ff317e67287d453.webp"
"MediaSize" => 58863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-395ff726e815d8e55ff317e67287d453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6353774819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/f8b4a0a1846ff41b1552e089c141d06c.webp"
"MediaSize" => 70690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-f8b4a0a1846ff41b1552e089c141d06c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6353774878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/2502c7f6f43a09610f42f4993c33b3ad.webp"
"MediaSize" => 63903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-2502c7f6f43a09610f42f4993c33b3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6353774883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/59a14639debd851edf079b44cf700115.webp"
"MediaSize" => 78115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-59a14639debd851edf079b44cf700115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6353774950"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/e7102c542085aec3a17717fb71eed36a.webp"
"MediaSize" => 71271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-e7102c542085aec3a17717fb71eed36a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6353775094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/f2e1890369192455f14fa0bcd2cf16d4.webp"
"MediaSize" => 79809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-f2e1890369192455f14fa0bcd2cf16d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6353775107"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/b3a39df84b28206533e2d0e9e414923e.webp"
"MediaSize" => 65410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-b3a39df84b28206533e2d0e9e414923e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6353775154"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/cc949ddfbeacf7ac00d3043cf29cd058.webp"
"MediaSize" => 137326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-cc949ddfbeacf7ac00d3043cf29cd058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6353775163"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/aa6f9446c80989d96405fd80cc4d7645.webp"
"MediaSize" => 124193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-aa6f9446c80989d96405fd80cc4d7645.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6353775268"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/e2ec9c88ab85b10e84451425efa0f71b.webp"
"MediaSize" => 140095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-e2ec9c88ab85b10e84451425efa0f71b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6353775272"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/6ccac5dd67ee16ed403301bafae757cf.webp"
"MediaSize" => 107296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-6ccac5dd67ee16ed403301bafae757cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6353775342"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/47c8ebdf0c5d89c1cf43d4c47f9c4156.webp"
"MediaSize" => 123162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-47c8ebdf0c5d89c1cf43d4c47f9c4156.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6353775348"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/78442f58da10455c911cccc301c23e26.webp"
"MediaSize" => 81218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-78442f58da10455c911cccc301c23e26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6353775392"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/c020de1385c88eeade7a96149f3002f0.webp"
"MediaSize" => 48370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-c020de1385c88eeade7a96149f3002f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6353775428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/9686cf86bd5c17d85e46ff8df36d6416.webp"
"MediaSize" => 171998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-9686cf86bd5c17d85e46ff8df36d6416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6353775461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/d1157fffada8dab8b4c9432dc79284f7.webp"
"MediaSize" => 59673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-d1157fffada8dab8b4c9432dc79284f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6353775510"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/465cef34627a29f319e8f598e8d75a7a.webp"
"MediaSize" => 31655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-465cef34627a29f319e8f598e8d75a7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6353775577"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/c1a114493ac7ff782af4a0a4d3ad8fad.webp"
"MediaSize" => 114758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-c1a114493ac7ff782af4a0a4d3ad8fad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6353775611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/7ca6bfb6d8aa50208bfc0687813bc8fa.webp"
"MediaSize" => 113408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-7ca6bfb6d8aa50208bfc0687813bc8fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6353775639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/36f5c189b310c1d367250165b95a15ef.webp"
"MediaSize" => 64560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-36f5c189b310c1d367250165b95a15ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6353775677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/b96d638813ffb04543cab1825b8c6945.webp"
"MediaSize" => 95408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-b96d638813ffb04543cab1825b8c6945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6353775712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29159043/80ce68e8ab605695be751a7a48942855.webp"
"MediaSize" => 50921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29159043/thumbnail-80ce68e8ab605695be751a7a48942855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792041"
"ResourceRecordKey" => "29159043"
"ModificationTimestamp" => "2025-12-03T18:00:52.5Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Frank Casini"
"MemberFirstName" => "Frank"
"MemberLastName" => "Casini"
"MemberMlsId" => "HBCASINFR"
"OriginatingSystemName" => 26
"MemberKey" => "2198019"
"ModificationTimestamp" => "2025-10-28T23:36:32Z"
"MemberStatus" => "Active"
"OfficeKey" => "262629"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberFax" => "905-664-2300"
"MemberCity" => "Stoney Creek"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-902-3000"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2023-08-21T14:08:00Z"
"MemberNationalAssociationId" => "1446394"
"OfficeNationalAssociationId" => "1223032"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "RE/MAX Escarpment Realty Inc."
"OfficePhone" => "905-545-1188"
"OfficeMlsId" => "HBREMAESSC"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "262629"
"ModificationTimestamp" => "2025-12-02T23:27:32Z"
"OfficeAddress1" => "860 Queenston Road"
"OfficeCity" => "Stoney Creek"
"OfficePostalCode" => "L8G4A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "905-664-2300"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2011-05-02T19:32:00Z"
"OfficeNationalAssociationId" => "1223032"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1064298"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159043')"
+"ID": "460529"
}
]
+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 262629/Office?$select=ALL&$top=10&$filter=OfficeKey eq 262629&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 262629/Office?$select=ALL&$top=10&$filter=OfficeKey eq 262629&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25525
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25527
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-545-1188"
+"OfficeMlsId": "HBREMAESSC"
+"ModificationTimestamp": "2025-12-02T23:27:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "262629"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "860 Queenston Road"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Stoney Creek"
+"OfficePostalCode": "L8G4A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1223032"
+"OriginalEntryTimestamp": "2011-05-02T19:32:00Z"
+"OfficeFax": "905-664-2300"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439658"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "262629"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-12-02T21:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064298"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('262629')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198019/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198019&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198019/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198019&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25530
+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 29159043" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25111
+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 29159043/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29159043&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29159043/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29159043&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24988
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25071
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29278031"
+"ListingKey": "29159043"
+"ListingId": "40792041"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-07"
+"OpenHouseStartTime": "2025-12-07T14:00:00Z"
+"OpenHouseEndTime": "2025-12-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-06T19:14:33Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29278031')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24986
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29278032"
+"ListingKey": "29159043"
+"ListingId": "40792041"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-06"
+"OpenHouseStartTime": "2025-12-06T14:00:00Z"
+"OpenHouseEndTime": "2025-12-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-06T19:14:33Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29278032')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25074
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29304881"
+"ListingKey": "29159043"
+"ListingId": "40792041"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-07"
+"OpenHouseStartTime": "2025-12-07T14:00:00Z"
+"OpenHouseEndTime": "2025-12-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-07T20:55:42Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29304881')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29159043 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.906797 43.328156)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29159043 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.906797 43.328156)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29159043 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.906797 43.328156)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29159043 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.906797 43.328156)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25549
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25000
+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
…4
]
7 => array:11 [ …11]
]
+"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 [ …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: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 {#25386
+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 {#25397
+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 {#25368
+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 {#25001
+post_id: "464308"
+post_author: 1
+"ListingKey": "29164823"
+"ListingId": "X12603202"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T01:55:24Z"
+"RFModificationTimestamp": "2025-12-05T03:38:03Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.886026
1 => 43.331229
]
+"Latitude": 43.331229
+"Longitude": -79.886026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. Potential to assemble with property next door. VTB FINANCING AVAILABLE. Consider the possibilities for your dream home or as an investment. (id:62650)"
+"CreationDate": "2025-12-05T03:37:47.851068+00:00"
+"Directions": "Cross Streets: Dundas Street. ** Directions: Mill St. S. is Waterdown Rd. south of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "61.88 x 124 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T01:47:01Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T01:47:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3773"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29164823/191-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 61.1
+"OriginalEntryTimestamp": "2025-12-05T01:47:01.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29164823')"
+"ID": "464308"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: "463014"
+post_author: 1
+"ListingKey": "29161684"
+"ListingId": "40792230"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T15:05:56Z"
+"RFModificationTimestamp": "2025-12-04T21:13:14Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.428
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL Street S, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8859059
1 => 43.3312732
]
+"Latitude": 43.3312732
+"Longitude": -79.8859059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. VTB FINANCING AVAILABLE. Newly severed Lot. Consider the possibilities for your dream home or as an investment. Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-04T21:12:51.956561+00:00"
+"Directions": "Mill St. S. is Waterdown Rd., S of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "284639"
+"LotSizeDimensions": "0.428"
+"PhotosChangeTimestamp": "2025-12-04T14:59:58Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T14:59:57Z"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3773"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161684/191-mill-street-s-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "O1, CM"
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2025-12-04T14:59:57.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161684')"
+"ID": "463014"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23674
+post_id: "463015"
+post_author: 1
+"ListingKey": "29161927"
+"ListingId": "40791925"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T19:40:25Z"
+"RFModificationTimestamp": "2025-12-09T19:42:39Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1682.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "383 DUNDAS Street E Unit# 21, Waterdown, Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.8875746
1 => 43.3386557
]
+"Latitude": 43.3386557
+"Longitude": -79.8875746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown’s family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:40:54.576685+00:00"
+"Directions": "Dundas St E to complex."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:00:37Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T19:28:54Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4053.09"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161927/383-dundas-street-e-unit-21-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2059038"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "HC-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1682
+"OriginalEntryTimestamp": "2025-12-04T16:00:37.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161927')"
+"ID": "463015"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "463016"
+post_author: 1
+"ListingKey": "29161992"
+"ListingId": "40792282"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T21:40:21Z"
+"RFModificationTimestamp": "2025-12-06T21:44:46Z"
+"ListPrice": 1388000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3029.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "20 VINEGAR Hill, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8900722
1 => 43.3362821
]
+"Latitude": 43.3362821
+"Longitude": -79.8900722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional 3,000+ sq ft custom-built 4-bedroom home on a rare 60-foot-wide lot in one of Waterdown's most desirable neighbourhoods. Just a 4-minute stroll to Waterdown's historic village and downtown amenities, this property showcases quality craftsmanship, a thoughtful floor plan, and features that set it apart from a standard subdivision home. The main level offers a spacious formal living/dining room, a dedicated den/home office, a large eat-in kitchen with high-end appliances, and an inviting family room filled with natural light. Upstairs, you'll find four oversized bedrooms, including a primary suite with a walk-in closet and 5-pc ensuite. The second bedroom also includes its own private 4-pc ensuite - an ideal setup for multigenerational living. A skylit landing and walkout to a charming balcony add distinctive architectural character. Excellent versatility continues on the lower level, with two staircases and a separate entrance, offering potential for an in-law suite, teen retreat, or income-generating unit. Perfectly located within walking distance to Waterdown's historic village and local conveniences, and just minutes from the Bruce Trail, Smokey Hollow Waterfall, parks, and scenic ravine paths. Easy access to major highways and Aldershot GO Station. A rare opportunity on a street where homes seldom come to market. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:02:18.932559+00:00"
+"Directions": "Dundas St & Vinegar Hill"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:11:05Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T21:29:16Z"
+"Stories": "2.0"
+"StreetName": "VINEGAR"
+"StreetNumber": "20"
+"StreetSuffix": "Hill"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7324"
+"VirtualTourURLUnbranded": "https://youtu.be/TeI63sfVOxE"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161992/20-vinegar-hill-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 3029
+"OriginalEntryTimestamp": "2025-12-04T16:09:19.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161992')"
+"ID": "463016"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25041
+post_id: "462368"
+post_author: 1
+"ListingKey": "29162472"
+"ListingId": "X12600986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T20:30:54Z"
+"RFModificationTimestamp": "2025-12-09T20:33:01Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "21 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown's family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T18:42:36.525089+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Dundas St E To Complex."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:49:49Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T20:19:39Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4053.09"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29162472/21-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1989315"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Mgmt"
+"CoListOfficeKey": "269164"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-12-04T16:49:49.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29162472')"
+"ID": "462368"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 102
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]