array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29172451/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172451&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172451/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172451&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23596
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "469748"
+post_author: 1
+"ListingKey": "29172451"
+"ListingId": "X12611048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T00:31:00Z"
+"RFModificationTimestamp": "2025-12-11T00:32:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1009 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 10th-floor unit in the highly sought-after Trend 3 community! Step into a bright and inviting 2-bedroom, condo. The open concept layout seamlessly connects the modern kitchen and living area, featuring brand-new stainless steel appliances, a stylish breakfast bar with quartz counter tops, and direct access to your private balcony w/exposure to two sides. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed space. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state of the art fitness center, scenic roof top patios, and secure bike storage. Located in the heart of Waterdown, this home provides effortless access to top-rated dining, shopping, schools, and picturesque parks. Included with the unit is 1 owned surface parking space and an owned locker for extra storage. Experience contemporary living at its finest in this exceptional condo (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T00:31:16.650931+00:00"
+"Directions": "Dundas Street East and Mallard"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211320"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-11T00:18:54Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T00:18:54Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1547288066"
"RoomType" => "Living room"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29172451"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.51Z"
]
1 => array:11 [
"RoomKey" => "1547288067"
"RoomType" => "Kitchen"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 2.4
"ListingKey" => "29172451"
"RoomLength" => 2.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.52Z"
]
2 => array:11 [
"RoomKey" => "1547288068"
"RoomType" => "Bedroom"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29172451"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.52Z"
]
3 => array:11 [
"RoomKey" => "1547288069"
"RoomType" => "Bathroom"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 1.6
"ListingKey" => "29172451"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.52Z"
]
4 => array:11 [
"RoomKey" => "1547288070"
"RoomType" => "Bedroom"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 2.6
"ListingKey" => "29172451"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.52Z"
]
5 => array:11 [
"RoomKey" => "1547288071"
"RoomType" => "Foyer"
"ListingId" => "X12611048"
"RoomLevel" => "Main level"
"RoomWidth" => 2.55
"ListingKey" => "29172451"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-11T00:18:54.52Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29172451/1009-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-08T22:16:56.8Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:17 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362133011"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/b8664da8c3fc221d21efc930594bffdc.webp"
"MediaSize" => 28454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-b8664da8c3fc221d21efc930594bffdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362133022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/102c2c08529921943d53b305d5d6b04f.webp"
"MediaSize" => 23136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-102c2c08529921943d53b305d5d6b04f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362133082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/fedab86cc89f367f6d4308a983096617.webp"
"MediaSize" => 24076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-fedab86cc89f367f6d4308a983096617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362133106"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/739560f2d46c4ee1e5c6d53cac47165c.webp"
"MediaSize" => 27290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-739560f2d46c4ee1e5c6d53cac47165c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362133195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/0136c9766fc2894a6a2e715929236ffd.webp"
"MediaSize" => 24018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-0136c9766fc2894a6a2e715929236ffd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362133282"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/8966acbba06a8088b4ce8542cbe787a3.webp"
"MediaSize" => 29602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-8966acbba06a8088b4ce8542cbe787a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362133353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/295c254425798de1cfb37408cdecc2ad.webp"
"MediaSize" => 29158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-295c254425798de1cfb37408cdecc2ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362133397"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/7e63675e86fba6f1c8918def48f5ddb1.webp"
"MediaSize" => 23733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-7e63675e86fba6f1c8918def48f5ddb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362133508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/c92a37f22ff6a09143a7c65f4d5becd7.webp"
"MediaSize" => 23746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-c92a37f22ff6a09143a7c65f4d5becd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362133593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/bf926d65c354ec186d3cc8159586a819.webp"
"MediaSize" => 30238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-bf926d65c354ec186d3cc8159586a819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362133690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/9a52a2854ddd129524318251119eb9a9.webp"
"MediaSize" => 26816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-9a52a2854ddd129524318251119eb9a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362133775"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/e252355f427fecf495856743f324fcdc.webp"
"MediaSize" => 21361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-e252355f427fecf495856743f324fcdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-08T22:16:56.81Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6363748192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/b82cf7bc49d1aafaec57e7808e3d4123.webp"
"MediaSize" => 39963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-b82cf7bc49d1aafaec57e7808e3d4123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-10T23:43:59.75Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6363748210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/61030aee6a22636dd5aea0b186e2b417.webp"
"MediaSize" => 40614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-61030aee6a22636dd5aea0b186e2b417.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-10T23:43:59.54Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6363748226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/96604c0bcf0a46d5437d6fa069bdb88a.webp"
"MediaSize" => 34964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-96604c0bcf0a46d5437d6fa069bdb88a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-10T23:43:59.52Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6363748247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/6894242e033e6fd1141a2a629da7ce88.webp"
"MediaSize" => 46593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-6894242e033e6fd1141a2a629da7ce88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-10T23:43:59.7Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6363748295"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172451/9dae3834f44d1b21ba44bee3d2c5c57e.webp"
"MediaSize" => 62087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172451/thumbnail-9dae3834f44d1b21ba44bee3d2c5c57e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611048"
"ResourceRecordKey" => "29172451"
"ModificationTimestamp" => "2025-12-10T23:43:59.73Z"
]
]
+"Member": array:1 [
0 => array:20 [
"MemberFullName" => "PETE VUKADIN"
"MemberFirstName" => "PETE"
"MemberLastName" => "VUKADIN"
"MemberMlsId" => "9638270"
"OriginatingSystemName" => 26
"MemberKey" => "2211320"
"ModificationTimestamp" => "2024-09-23T19:30:40Z"
"MemberStatus" => "Active"
"OfficeKey" => "291490"
"JobTitle" => "Salesperson"
"MemberAOR" => "Toronto"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-574-4600"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-02-14T20:20:00Z"
"MemberNationalAssociationId" => "1457229"
"OfficeNationalAssociationId" => "1398828"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "ROYAL LEPAGE STATE REALTY"
"OfficePhone" => "905-574-4600"
"OfficeMlsId" => "288002"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "291490"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "987 RYMAL RD UNIT 100"
"OfficeCity" => "HAMILTON"
"OfficePostalCode" => "L8W3M2"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-574-4345"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-10-07T21:43:00Z"
"OfficeNationalAssociationId" => "1398828"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1312646"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172451')"
+"ID": "469748"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 291490/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291490&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291490/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291490&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25400
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE STATE REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-574-4600"
+"OfficeMlsId": "288002"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "291490"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "987 RYMAL RD UNIT 100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "HAMILTON"
+"OfficePostalCode": "L8W3M2"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1398828"
+"OriginalEntryTimestamp": "2021-10-07T21:43:00Z"
+"OfficeFax": "905-574-4345"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "342381"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "291490"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2024-01-19T04:18:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1312646"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('291490')"
}
]
+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 2211320/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211320&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211320/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211320&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25405
+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 29172451" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25023
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172451/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172451&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172451/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172451&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25003
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172451 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172451 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172451 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172451 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.878916 43.343831)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "473599"
+post_author: 1
+"ListingKey": "29177385"
+"ListingId": "X12615794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T18:45:57Z"
+"RFModificationTimestamp": "2025-12-10T18:52:06Z"
+"ListPrice": 1299999.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X4"
+"UnparsedAddress": "219 HUMPHREY STREET, Hamilton (Waterdown), Ontario L8B1X4"
+"Coordinates": array:2 [
0 => -79.8781894
1 => 43.3406736
]
+"Latitude": 43.3406736
+"Longitude": -79.8781894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 219 Humphrey Street-a remarkable executive home in the heart of Waterdown, perfectly positioned on a premium ravine lot offering unmatched privacy and serene natural views. This stunning residence features brand new flooring in all five bedrooms, fresh paint throughout the main and second floors, brand new upgraded quartz countertops in all washrooms, and upgraded light fixtures on the main floor for a bright, modern, and luxurious feel.The main floor showcases soaring 10-foot ceilings and an impressive open-concept layout ideal for everyday living and sophisticated entertaining. Enjoy elegant formal living and dining areas, a spacious family room with large windows and a cozy gas fireplace, and a versatile office or library for work or quiet study.The modern gourmet kitchen is equipped with high-end stainless steel appliances, quartz countertops, a stylish backsplash, a large pantry, and a 6-burner gas stove, offering an exceptional culinary experience. With no walkway on the driveway, you also benefit from extended private parking.Upstairs, 9-foot ceilings enhance the open, airy feel. All bedrooms enjoy ensuite privilege-the luxurious primary suite includes its own private 5-piece ensuite and walk-in closet, while the remaining four bedrooms are thoughtfully connected through Jack-and-Jill bathrooms, providing comfort and convenience for the entire family. A second-floor laundry room adds to the practicality of this well-designed layout.The walkout legal basement apartment offers incredible flexibility, featuring two bedrooms, two full bathrooms, a full kitchen with high-end finishes, in-suite laundry, and its own private entrance. Very good tenants are willing to stay or vacate based on the buyer's preference, making this an exceptional opportunity for additional income or extended family living. With its blend of luxury, space, extensive upgrades, and a rare ravine setting, this home stands as one of Waterdown's premier offerings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Oven - Built-In"
8 => "Garage door opener remote(s)"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T18:51:51.997683+00:00"
+"Directions": "Dundas St E to Burke St to Humphrey St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2009588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Ravine"
2 => "Backs on greenbelt"
3 => "Lane"
4 => "Carpet Free"
]
+"LotSizeDimensions": "45.7 x 93.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T17:52:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T18:29:57Z"
+"Stories": "2.0"
+"StreetName": "Humphrey"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "11591"
+"VirtualTourURLUnbranded": "https://media.relavix.com/219-humphrey-street-waterdown/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1547255965"
"RoomType" => "Living room"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29177385"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
1 => array:11 [
"RoomKey" => "1547255966"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 2.97
"ListingKey" => "29177385"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
2 => array:11 [
"RoomKey" => "1547255967"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29177385"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
3 => array:11 [
"RoomKey" => "1547255968"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
4 => array:11 [
"RoomKey" => "1547255969"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
5 => array:11 [
"RoomKey" => "1547255970"
"RoomType" => "Kitchen"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
6 => array:11 [
"RoomKey" => "1547255971"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
7 => array:11 [
"RoomKey" => "1547255972"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
8 => array:11 [
"RoomKey" => "1547255973"
"RoomType" => "Family room"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 3.66
"ListingKey" => "29177385"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
9 => array:11 [
"RoomKey" => "1547255974"
"RoomType" => "Dining room"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.95Z"
]
10 => array:11 [
"RoomKey" => "1547255975"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 3.84
"ListingKey" => "29177385"
"RoomLength" => 4.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
11 => array:11 [
"RoomKey" => "1547255976"
"RoomType" => "Dining room"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29177385"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
12 => array:11 [
"RoomKey" => "1547255977"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Basement"
"RoomWidth" => 5.36
"ListingKey" => "29177385"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
13 => array:11 [
"RoomKey" => "1547255978"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29177385"
"RoomLength" => 6.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
14 => array:11 [
"RoomKey" => "1547255979"
"RoomType" => "Family room"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 4.09
"ListingKey" => "29177385"
"RoomLength" => 5.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
15 => array:11 [
"RoomKey" => "1547255980"
"RoomType" => "Kitchen"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29177385"
"RoomLength" => 4.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
16 => array:11 [
"RoomKey" => "1547255981"
"RoomType" => "Eating area"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "29177385"
"RoomLength" => 4.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
17 => array:11 [
"RoomKey" => "1547255982"
"RoomType" => "Office"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29177385"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
18 => array:11 [
"RoomKey" => "1547255983"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29177385"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
19 => array:11 [
"RoomKey" => "1547255984"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 4.44
"ListingKey" => "29177385"
"RoomLength" => 5.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.96Z"
]
20 => array:11 [
"RoomKey" => "1547255985"
"RoomType" => "Bathroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29177385"
"RoomLength" => 6.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.97Z"
]
21 => array:11 [
"RoomKey" => "1547255986"
"RoomType" => "Bedroom"
"ListingId" => "X12615794"
"RoomLevel" => "Second level"
"RoomWidth" => 2.97
"ListingKey" => "29177385"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-10T18:29:57.97Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29177385/219-humphrey-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.8
+"OriginalEntryTimestamp": "2025-12-10T17:52:11.53Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6363515240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/8444d3928138db3196019b19eac8309d.webp"
"MediaSize" => 358489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-8444d3928138db3196019b19eac8309d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6363515249"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/c463dedbcd00bfb0e879e805ea140d4a.webp"
"MediaSize" => 364878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-c463dedbcd00bfb0e879e805ea140d4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6363515285"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/7868dbfd0cb7c9acd52ffa1b38fc7370.webp"
"MediaSize" => 271727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-7868dbfd0cb7c9acd52ffa1b38fc7370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6363515322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/cbb2a80f1af845e7f50f69ab0b01b5c2.webp"
"MediaSize" => 252365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-cbb2a80f1af845e7f50f69ab0b01b5c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6363515330"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/a5e1989ccee62542cf7a66fcc5e1e4ef.webp"
"MediaSize" => 264887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-a5e1989ccee62542cf7a66fcc5e1e4ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6363515360"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/db291cbdeaff7f7acbe5dba19df964c2.webp"
"MediaSize" => 134847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-db291cbdeaff7f7acbe5dba19df964c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6363515365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/8753e0248345ae34ca2b530b23f5d59e.webp"
"MediaSize" => 130571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-8753e0248345ae34ca2b530b23f5d59e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6363515394"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/f1761b6024784e49d79d16188a9eb174.webp"
"MediaSize" => 151683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-f1761b6024784e49d79d16188a9eb174.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6363515408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/3cf5ac854cdce531dda9947f22377789.webp"
"MediaSize" => 137736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-3cf5ac854cdce531dda9947f22377789.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6363515466"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/22e5c2a22402c7fb956923e9d52f035f.webp"
"MediaSize" => 169975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-22e5c2a22402c7fb956923e9d52f035f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6363515498"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/7e5320b9e57b413b725104ac42751dff.webp"
"MediaSize" => 132242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-7e5320b9e57b413b725104ac42751dff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6363515507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/993953ee399b3e1c0dd4dbee96519e16.webp"
"MediaSize" => 195186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-993953ee399b3e1c0dd4dbee96519e16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6363515528"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/ed12021d9c9adf19f67934ef567f1a33.webp"
"MediaSize" => 160564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-ed12021d9c9adf19f67934ef567f1a33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6363515536"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/2b3a1c694da0c1e531fd64c9c1a001d7.webp"
"MediaSize" => 187865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-2b3a1c694da0c1e531fd64c9c1a001d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6363515558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/6601ea4796295f0abea40c63cc2e5e6a.webp"
"MediaSize" => 148540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-6601ea4796295f0abea40c63cc2e5e6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6363515592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/84825d38280a5410eb0e896861a565e1.webp"
"MediaSize" => 178709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-84825d38280a5410eb0e896861a565e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6363515605"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/4cc0b37ff063472de8802e794d6c9332.webp"
"MediaSize" => 149087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-4cc0b37ff063472de8802e794d6c9332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6363515626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/4a6e36744e6675a6eb3d5aa06899b384.webp"
"MediaSize" => 161877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-4a6e36744e6675a6eb3d5aa06899b384.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6363515639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/ea987cdb2c95ebad38c4fe8ff154fcc3.webp"
"MediaSize" => 159615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-ea987cdb2c95ebad38c4fe8ff154fcc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6363515653"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/e0006e9e59aae2dafdff3cb9f6313b4d.webp"
"MediaSize" => 152803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-e0006e9e59aae2dafdff3cb9f6313b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6363515704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/594da02a8d83c69c5039982982f004dc.webp"
"MediaSize" => 168015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-594da02a8d83c69c5039982982f004dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6363515707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/a56169f3020147ea4c38660eca5b2d84.webp"
"MediaSize" => 182487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-a56169f3020147ea4c38660eca5b2d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6363515732"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/1046c09f2f5d1e288bdb7e234246e000.webp"
"MediaSize" => 154565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-1046c09f2f5d1e288bdb7e234246e000.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6363515741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/8300fe5bd5cbfc44c109d75a08f74498.webp"
"MediaSize" => 134243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-8300fe5bd5cbfc44c109d75a08f74498.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6363515755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/e31c03199432fb818db09a632c00a71b.webp"
"MediaSize" => 191477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-e31c03199432fb818db09a632c00a71b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6363515776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/8e4580e2af660d5acdfd00a3bc348c47.webp"
"MediaSize" => 78836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-8e4580e2af660d5acdfd00a3bc348c47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6363515779"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/872c5a6ab51453fd0bb10f5f89184e5b.webp"
"MediaSize" => 135168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-872c5a6ab51453fd0bb10f5f89184e5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6363515785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/09c7994b89a68149ca4dbbbe43275f54.webp"
"MediaSize" => 104759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-09c7994b89a68149ca4dbbbe43275f54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6363515795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/732b3e3f51f4c6753a4a634d05aecc64.webp"
"MediaSize" => 184546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-732b3e3f51f4c6753a4a634d05aecc64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6363515803"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/5775a2edba7eefec8bafa696aba19850.webp"
"MediaSize" => 123961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-5775a2edba7eefec8bafa696aba19850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6363515814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/878f590acc39564a24cc11ae000c867c.webp"
"MediaSize" => 123364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-878f590acc39564a24cc11ae000c867c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6363515817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177385/86aaed5bf23fb98c166cbe6f5eac8a2f.webp"
"MediaSize" => 94296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177385/thumbnail-86aaed5bf23fb98c166cbe6f5eac8a2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12615794"
"ResourceRecordKey" => "29177385"
"ModificationTimestamp" => "2025-12-10T17:52:11.54Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6363515824"
…11
]
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:25 [ …25]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177385')"
+"ID": "473599"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "473174"
+post_author: 1
+"ListingKey": "29176831"
+"ListingId": "X12615130"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T16:05:20Z"
+"RFModificationTimestamp": "2025-12-10T16:32:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V3"
+"UnparsedAddress": "32 CELANO DRIVE, Hamilton (Waterdown), Ontario L8B1V3"
+"Coordinates": array:2 [
0 => -79.8816937
1 => 43.3483034
]
+"Latitude": 43.3483034
+"Longitude": -79.8816937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Well maintained 3 bedroom, 2.5 bath DETACHED home with additional 2nd floor loft just under 2000 sq.ft available for lease. This beautiful home is located in a family friendly neighborhood and backs on to Cranberry Hill park. Nine foot ceiling throughout main floor and hardwood flooring. Large gourmet style kitchen with large island and an abundance of cabinets. Upstairs, master large master bedroom with walk-in closet, 2 additional good sized bedrooms as well as a cozy family room. 2nd floor laundry for convenience. Lots of space for storage in unfinished basement. Sit on the finished private deck overlooking the beautiful park. Minutes from amenities, GO station and Burlington downtown. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T16:32:15.359270+00:00"
+"Directions": "Cross Streets: Dundas and Burke. ** Directions: Dundas and Spring Creek."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967393"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Paved yard"
2 => "In suite Laundry"
]
+"LotSizeDimensions": "36.1 x 89.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T15:52:53Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T15:52:53Z"
+"Stories": "2.0"
+"StreetName": "Celano"
+"StreetNumber": "32"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29176831/32-celano-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3650
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2025-12-10T15:52:53.46Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:22 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29176831')"
+"ID": "473174"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "469747"
+post_author: 1
+"ListingKey": "29172783"
+"ListingId": "X12611344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T23:55:23Z"
+"RFModificationTimestamp": "2025-12-09T00:55:51Z"
+"ListPrice": 970000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y3"
+"UnparsedAddress": "42 EBENEZER DRIVE, Hamilton (Waterdown), Ontario L8B1Y3"
+"Coordinates": array:2 [
0 => -79.8779031
1 => 43.337885
]
+"Latitude": 43.337885
+"Longitude": -79.8779031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 2,400sqft home, offering 4 bedrooms + an office/den on the main floor + 4 bathrooms. With not one, but two primary suites featuring their own private ensuite, comfort and flexibility are built right in! Enjoy a bright, open-concept main floor with 9-foot ceilings + modern finishes, perfect for family time and entertainment. Parking is effortless with an extended driveway providing three spaces (one in the garage and two outside), completed with an upgraded 200-amp electrical panel, ideal for homeowners looking to install an EV charger at home. Located on a quiet street in the highly sought-after Mountainview Heights neighbourhood in Waterdown, you will be close to parks, top-rated schools, shopping, and transit services. This home is truly a turnkey opportunity! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2025-12-09T00:55:36.474686+00:00"
+"Directions": "Ebenezer Drive"
+"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": "2046896"
+"ListOfficeKey": "64317"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved yard"
2 => "Carpet Free"
]
+"LotSizeDimensions": "27.9 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T23:45:35Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T23:45:35Z"
+"Stories": "2.0"
+"StreetName": "Ebenezer"
+"StreetNumber": "42"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7099.22"
+"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/29172783/42-ebenezer-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 27.1
+"OriginalEntryTimestamp": "2025-12-08T23:45:35.71Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172783')"
+"ID": "469747"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "469263"
+post_author: 1
+"ListingKey": "29172271"
+"ListingId": "40792846"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T00:05:22Z"
+"RFModificationTimestamp": "2025-12-11T00:07:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 726.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 1003, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8788802
1 => 43.3441688
]
+"Latitude": 43.3441688
+"Longitude": -79.8788802
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 10th-floor unit in the highly sought-after Trend 3 community! Step into a bright and inviting 2-bedroom, condo. The open concept layout seamlessly connects the modern kitchen and living area, featuring brand-new stainless steel appliances, a stylish breakfast bar with quartz counter tops, and direct access to your private balcony w/exposure to two sides. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed space. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state of the art fitness center, scenic roof top patios, and secure bike storage. Located in the heart of Waterdown, this home offers effortless access to top-rated dining, shopping, schools, and picturesque parks. Included with the unit is 1 owned surface parking space and an owned locker for extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T21:48:52.811107+00:00"
+"Directions": "Dundas Street East and Mallard"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525349"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-12-10T23:48:58Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T23:48:58Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29172271/470-dundas-street-e-unit-1009-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 726
+"OriginalEntryTimestamp": "2025-12-08T21:29:24.16Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:17 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172271')"
+"ID": "469263"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "468273"
+post_author: 1
+"ListingKey": "29169820"
+"ListingId": "X12608304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T19:25:23Z"
+"RFModificationTimestamp": "2025-12-07T22:51:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "BASEMENT - 7 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8831437
1 => 43.3349547
]
+"Latitude": 43.3349547
+"Longitude": -79.8831437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully renovated, this bright and spacious 2 bed, 1 bath basement apartment features a private entrance and a prime location in Waterdown, just minutes from parks, major highways, downtown Burlington, and the lake. Enjoy the convenience of a Ensuite laundry room, driveway parking for one vehicle, and ample street parking. Located close to Aldershot GO Station for easy commuting. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-07T22:51:07.326532+00:00"
+"Directions": "Dundas & Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157654"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "11.9 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-07T19:17:30Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T19:17:30Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169820/basement-7-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1529658"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "84654"
+"GeocodeManualYN": false
+"TotalActualRent": 2150
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 11.9
+"OriginalEntryTimestamp": "2025-12-07T19:17:30.06Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"Media": array:12 [
0 => array:13 [ …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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169820')"
+"ID": "468273"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24947
+post_id: "467556"
+post_author: 1
+"ListingKey": "29169238"
+"ListingId": "X12607678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T19:55:38Z"
+"RFModificationTimestamp": "2025-12-07T19:56:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X4"
+"UnparsedAddress": "UPPER LEVEL - 8 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L8B0X4"
+"Coordinates": array:2 [
0 => -79.879425
1 => 43.3461685
]
+"Latitude": 43.3461685
+"Longitude": -79.879425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous Designer Home, Perfect For Large Families, 2700Sf. 4 Bdrms./3.5 Bath. 2 Beds Have Separate Ensuite Other 2 Bdrms Have Ensuite Privilege's , An Abundance Of Upgrades, Potlights, Plantation Shutters, Crown Moulding, Oak Staircase, Quartz Countertop In Kitchen, Large Pantry, Cold Cellar. Backyard Fully Fenced W/ Large Stamped Concrete Patio. Basement is not included.Tenant pays 70% of all Utilities.EV charger in Garage. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T22:33:26.474981+00:00"
+"Directions": "Cross Streets: Springcreek Dr & Stillwater Cr. ** Directions: Dundas to Springcreek dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1415763"
+"ListOfficeKey": "50737"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42 x 85.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-06T21:46:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T19:45:13Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "8"
+"StreetSuffix": "Crescent"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://tours.myvirtualhome.ca/2361818?idx=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169238/upper-level-8-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3200
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2025-12-06T21:46:24.26Z"
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169238')"
+"ID": "467556"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23610
+post_id: "467557"
+post_author: 1
+"ListingKey": "29169242"
+"ListingId": "X12607716"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T22:30:37Z"
+"RFModificationTimestamp": "2025-12-06T22:33:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "BASEMENT - 8 STILLWATER CRESCENT, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.879425
1 => 43.3461685
]
+"Latitude": 43.3461685
+"Longitude": -79.879425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To This Spacious Renovated 2 Bedroom Basement Apartment With Separate Entrance. Stainless Steel Appliances, Beautiful Kitchen And Washroom. Separate Full Size Laundry & 1 Parking.No Carpet, Gleaming Laminate Floor Throughout. Close To Aldershot GO. Tenant Pays 30% Utilities & Liability Insurance.Move In Ready (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T22:33:11.506994+00:00"
+"Directions": "Cross Streets: Springcreek Dr & Stillwater Cr. ** Directions: Dundas to Springcreek."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1415763"
+"ListOfficeKey": "50737"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42 x 85.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-06T22:18:12Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T22:18:12Z"
+"Stories": "2.0"
+"StreetName": "Stillwater"
+"StreetNumber": "8"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169242/basement-8-stillwater-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2025-12-06T21:46:24.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:18 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169242')"
+"ID": "467557"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "467552"
+post_author: 1
+"ListingKey": "29169013"
+"ListingId": "X12607450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T18:55:07Z"
+"RFModificationTimestamp": "2025-12-06T19:34:45Z"
+"ListPrice": 985000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z7"
+"UnparsedAddress": "361 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1Z7"
+"Coordinates": array:2 [
0 => -79.8725054
1 => 43.3438198
]
+"Latitude": 43.3438198
+"Longitude": -79.8725054
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning Semi-Detached Family Home in Waterdown=This beautifully appointed, three-year-old semi-detached home is situated in the highly sought-after community of Waterdown. With its modern design and upscale finishes, the residence offers an exceptional living experience for families seeking comfort and convenience. Four spacious bedrooms and two and a half bathrooms, providing ample space for the whole family. Soaring 9-foot ceilings paired with floor-to-ceiling windows, allowing abundant natural light to fill the home and creating an inviting atmosphere. A vibrant great room featuring expansive windows, perfect for relaxing or entertaining guests. Step into the gourmet kitchen, which offers ceiling-height cabinetry for generous storage. The central island is ideal for meal preparation and casual dining. The adjacent dining area provides direct access to the deck, overlooking the backyard-a perfect spot for morning coffee or summer barbecues. Second Floor Retreat-Upstairs, the home offers four well-appointed bedrooms and two full bathrooms. The principal suite boasts a walk-in closet and a private, full ensuite bath, offering a peaceful retreat for homeowners. Additional Highlights-A pristine, untouched basement with a large, full-size window offers an excellent opportunity to customize the space according to your needs. The laundry room is conveniently located on the main floor, adding to the home's practical layout. This home is ideally located just minutes from major highways (403, 407, and 401 via Highway 6), the GO Train, parks, trails, shopping, and excellent schools. Residents enjoy easy and convenient access to all amenities, making daily living seamless and enjoyable. Perfect Family Home With its blend of style, space, and functionality, this cozy semi-detached home is the perfect choice for families seeking a vibrant community lifestyle in Waterdown (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T19:34:35.321697+00:00"
+"Directions": "Cross Streets: Dundas St & Millard Tr. ** Directions: SEE MAP."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1560637"
+"ListOfficeKey": "282720"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.6 x 90.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-06T18:47:22Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T18:47:22Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "361"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6880"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/361-skinner-road-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169013/361-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2025-12-06T18:47:22.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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('29169013')"
+"ID": "467552"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "467329"
+post_author: 1
+"ListingKey": "29168655"
+"ListingId": "40792313"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T22:10:36Z"
+"RFModificationTimestamp": "2025-12-08T22:14:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y3"
+"UnparsedAddress": "112 SKINNER Road, Hamilton, Ontario L8B1Y3"
+"Coordinates": array:2 [
0 => -79.879877
1 => 43.338415
]
+"Latitude": 43.338415
+"Longitude": -79.879877
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Like new immaculately maintained Semi Detached house in Waterdown's most desirable neighbourhood. Beautifully landscaped backyard. Single car garage plus widened driveway. 3 Bedrooms & 3 Baths, Open Concept Main Level with quality Laminate Floors & 9' Ceilings, Modern Kitchen with central island and Stainless Steel Appliances. Primary Bedroom with 4 Pc Ensuite, Minutes To Hwy 407, Qew & Go Stations, 15 Minutes To Mcmaster, Close To Shopping & Schools. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T16:40:35.261842+00:00"
+"Directions": "Dundas St. E. to Burke St. to Skinner Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T22:00:10Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T22:00:10Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "112"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29168655/112-skinner-road-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-12-06T14:30:04.25Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168655')"
+"ID": "467329"
}
]
+success: true
+page_size: 9
+page_count: 22
+count: 195
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]