array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29172783/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172783&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172783/Property?$select=ALL&$top=20&$filter=ListingKey eq 29172783&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23498
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23500
+post_id: "469747"
+post_author: 1
+"ListingKey": "29172783"
+"ListingId": "X12611344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-05T20:35:55Z"
+"RFModificationTimestamp": "2026-01-05T20:56:08Z"
+"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 impeccable 2,400sqft home (bigger than most detached homes!) on a 28' wide lot, offering 4 beds + an office/den on the main floor + 4 baths. Wow! 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": "2026-01-05T20:18:40Z"
+"Stories": "2.0"
+"StreetName": "Ebenezer"
+"StreetNumber": "42"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7099.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1556881881"
"RoomType" => "Office"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 2.4384
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
1 => array:11 [
"RoomKey" => "1556881882"
"RoomType" => "Dining room"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5814
"ListingKey" => "29172783"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
2 => array:11 [
"RoomKey" => "1556881883"
"RoomType" => "Living room"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5814
"ListingKey" => "29172783"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
3 => array:11 [
"RoomKey" => "1556881884"
"RoomType" => "Kitchen"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.048
"ListingKey" => "29172783"
"RoomLength" => 7.3152
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
4 => array:11 [
"RoomKey" => "1556881885"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.6576
"ListingKey" => "29172783"
"RoomLength" => 5.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
5 => array:11 [
"RoomKey" => "1556881886"
"RoomType" => "Bedroom 3"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.566
"ListingKey" => "29172783"
"RoomLength" => 3.5814
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
6 => array:11 [
"RoomKey" => "1556881887"
"RoomType" => "Bedroom 2"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.048
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
7 => array:11 [
"RoomKey" => "1556881888"
"RoomType" => "Bedroom 4"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.1242
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-05T20:18:40.03Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6362067416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7571bcf000afa83865a0cc8b8384bbeb.webp"
"MediaSize" => 265114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7571bcf000afa83865a0cc8b8384bbeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362067427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/ce12dbcc7b9443ff3e8477e07a2b9287.webp"
"MediaSize" => 295042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-ce12dbcc7b9443ff3e8477e07a2b9287.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362067435"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/d284c0041a48301e4ccaa150f7ce3bea.webp"
"MediaSize" => 185253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-d284c0041a48301e4ccaa150f7ce3bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362067446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/2b2c832fd097ed4e2abdecd6568d3310.webp"
"MediaSize" => 183833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-2b2c832fd097ed4e2abdecd6568d3310.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362067452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/58e238c490ff80d6cc26630121d2de9c.webp"
"MediaSize" => 125589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-58e238c490ff80d6cc26630121d2de9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362067460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/883d68a7963170757a8636421e1d24b7.webp"
"MediaSize" => 163408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-883d68a7963170757a8636421e1d24b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362067469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7409e82ec34b85b120eca43ca1424315.webp"
"MediaSize" => 165911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7409e82ec34b85b120eca43ca1424315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362067480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/d799c58164fad1ebb7d9471acb48784d.webp"
"MediaSize" => 162578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-d799c58164fad1ebb7d9471acb48784d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362067489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/9d786d270efd9fb7613f46c143dd917f.webp"
"MediaSize" => 172902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-9d786d270efd9fb7613f46c143dd917f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362067497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/5b6200cf28c8d84f563acf7a138fbc56.webp"
"MediaSize" => 145472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-5b6200cf28c8d84f563acf7a138fbc56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362067506"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/1740e2d156d272039ac98bd017bb0d00.webp"
"MediaSize" => 128671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-1740e2d156d272039ac98bd017bb0d00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362067515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/ec2bdfa3bafd34079388a4119d4df12b.webp"
"MediaSize" => 144194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-ec2bdfa3bafd34079388a4119d4df12b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362067532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/4fc24b8dd71b50c44a3ffa921f331888.webp"
"MediaSize" => 123978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-4fc24b8dd71b50c44a3ffa921f331888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362067543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/04ffb5762a013095ec2d5183d0e26ede.webp"
"MediaSize" => 121480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-04ffb5762a013095ec2d5183d0e26ede.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362067547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/329746fde7a15fa330ac08c2a99e920d.webp"
"MediaSize" => 88071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-329746fde7a15fa330ac08c2a99e920d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362067556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6e633a013447d67b25054b18a050e606.webp"
"MediaSize" => 137172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6e633a013447d67b25054b18a050e606.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362067561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/4a15a02b519ee921ccaab6b43ae89d16.webp"
"MediaSize" => 120338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-4a15a02b519ee921ccaab6b43ae89d16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362067569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6538b79ad41523d41b8f6f6726672884.webp"
"MediaSize" => 120523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6538b79ad41523d41b8f6f6726672884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362067572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/b0b8995426f8ff0f32dd94649a2f9c5d.webp"
"MediaSize" => 164993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-b0b8995426f8ff0f32dd94649a2f9c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362067586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6a5293c5b98ae59026c84c4fd41fa991.webp"
"MediaSize" => 160387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6a5293c5b98ae59026c84c4fd41fa991.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6362067593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6ea5a0be8816859e08c010fed97380a4.webp"
"MediaSize" => 149734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6ea5a0be8816859e08c010fed97380a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6362067597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/f965e98bb5e05ce41e68649d7d437cf8.webp"
"MediaSize" => 171509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-f965e98bb5e05ce41e68649d7d437cf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6362067609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/21ae95e37d68dede9d38e5cd98e8dc28.webp"
"MediaSize" => 141964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-21ae95e37d68dede9d38e5cd98e8dc28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6362067614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/52f53542609f40774a181b33df27d79a.webp"
"MediaSize" => 141006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-52f53542609f40774a181b33df27d79a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6362067619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/064c78d5aa41257a7381d0e04152eb31.webp"
"MediaSize" => 145858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-064c78d5aa41257a7381d0e04152eb31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6362067622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/24bc8167b60ab02e9ae0f1f5006b37de.webp"
"MediaSize" => 146590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-24bc8167b60ab02e9ae0f1f5006b37de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6362067634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7394a9900ceab99b450ead8e796bc36b.webp"
"MediaSize" => 94582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7394a9900ceab99b450ead8e796bc36b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6362067644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/bdbdbb824f52ca80d3baec013876d107.webp"
"MediaSize" => 99058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-bdbdbb824f52ca80d3baec013876d107.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6362067652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/a5a35dcfd90ddb2ad969b6debd56f775.webp"
"MediaSize" => 112932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-a5a35dcfd90ddb2ad969b6debd56f775.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6362067662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/171bc94ec6b48d83c157f738bf4e7f23.webp"
"MediaSize" => 121522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-171bc94ec6b48d83c157f738bf4e7f23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6362067665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/3d367db8926cfaf0a258c1f35fb3b0fb.webp"
"MediaSize" => 115441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-3d367db8926cfaf0a258c1f35fb3b0fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6362067675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/ff9777586ae2a846ccb945f543c7d1c8.webp"
"MediaSize" => 137545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-ff9777586ae2a846ccb945f543c7d1c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6362067681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/96fe6342ddf8c2deb3f05252b78c4b74.webp"
"MediaSize" => 134333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-96fe6342ddf8c2deb3f05252b78c4b74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6362067690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/fe6c6241d203bbb9e5a00eb3f2ca9199.webp"
"MediaSize" => 142135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-fe6c6241d203bbb9e5a00eb3f2ca9199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6362067698"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/90874265526ce49064a2b43ca3639bda.webp"
"MediaSize" => 140012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-90874265526ce49064a2b43ca3639bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6362067707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/036d4488e4543591e8f33635d6c2ae71.webp"
"MediaSize" => 124661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-036d4488e4543591e8f33635d6c2ae71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6362067714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7823a053bd2cd96638ee366d0b181e29.webp"
"MediaSize" => 96844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7823a053bd2cd96638ee366d0b181e29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6362067721"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/b2f87af6bbb97e95e7891e14b81b0c5d.webp"
"MediaSize" => 105058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-b2f87af6bbb97e95e7891e14b81b0c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6362067728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/d64498f4cda1a82fb739247b436068aa.webp"
"MediaSize" => 121063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-d64498f4cda1a82fb739247b436068aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6362067735"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/3a9fd773b611e619f625c331a61f8c1e.webp"
"MediaSize" => 145738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-3a9fd773b611e619f625c331a61f8c1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6362067740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/0817a02dcae0c5e997f9bb3bb2ab4739.webp"
"MediaSize" => 71365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-0817a02dcae0c5e997f9bb3bb2ab4739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6362067748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/41e214d6a03f6e07c31fb2c5ee9d0a37.webp"
"MediaSize" => 287178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-41e214d6a03f6e07c31fb2c5ee9d0a37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6362067754"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/bb0f118075dda2d76294b1e15d29a7b0.webp"
"MediaSize" => 285827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-bb0f118075dda2d76294b1e15d29a7b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6362067758"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/3298e001598db13c9864f9ff48de9555.webp"
"MediaSize" => 308014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-3298e001598db13c9864f9ff48de9555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "MANISH PATEL"
"MemberFirstName" => "MANISH"
"MemberLastName" => "PATEL"
"MemberMlsId" => "9584784"
"OriginatingSystemName" => 26
"MemberKey" => "2046896"
"ModificationTimestamp" => "2025-12-15T10:19:21Z"
"MemberStatus" => "Active"
"OfficeKey" => "64317"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:4 [ …4]
"MemberDesignation" => array:1 [ …1]
"MemberOfficePhone" => "416-819-1666"
"MemberSocialMedia" => array:3 [ …3]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2018-01-16T00:46:00Z"
"MemberNationalAssociationId" => "1322379"
"OfficeNationalAssociationId" => "1129022"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "TFN REALTY INC."
"OfficePhone" => "416-789-0288"
"OfficeMlsId" => "57500"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "64317"
"ModificationTimestamp" => "2025-07-21T21:40:10Z"
"OfficeAddress1" => "71 VILLARBOIT CRES #2"
"OfficeCity" => "VAUGHAN"
"OfficePostalCode" => "L4K4K"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "416-789-2028"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeNationalAssociationId" => "1129022"
"OfficeBrokerNationalAssociationId" => "1242250"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172783')"
+"ID": "469747"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 64317/Office?$select=ALL&$top=10&$filter=OfficeKey eq 64317&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 64317/Office?$select=ALL&$top=10&$filter=OfficeKey eq 64317&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25445
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "TFN REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "416-789-0288"
+"OfficeMlsId": "57500"
+"ModificationTimestamp": "2025-07-21T21:40:10Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "64317"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "71 VILLARBOIT CRES #2"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "VAUGHAN"
+"OfficePostalCode": "L4K4K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1129022"
+"OriginalEntryTimestamp": null
+"OfficeFax": "416-789-2028"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1242250"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('64317')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2046896/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2046896&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2046896/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2046896&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25448
+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 29172783" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25062
+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 29172783/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172783&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172783/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29172783&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25044
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172783 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8779031 43.337885)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172783 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8779031 43.337885)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172783 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8779031 43.337885)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29172783 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8779031 43.337885)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24982
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24910
+post_id: "545177"
+post_author: 1
+"ListingKey": "29265095"
+"ListingId": "X12708588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-19T16:25:53Z"
+"RFModificationTimestamp": "2026-01-19T20:07:38Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V7"
+"UnparsedAddress": "74 - 22 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B1V7"
+"Coordinates": array:2 [
0 => -79.87842
1 => 43.34543
]
+"Latitude": 43.34543
+"Longitude": -79.87842
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "End Unit Mattamy Build Hannon End 3+1 Br, 3 Wr - 1824 Sqft Townhouse, Very Good Size Terrace. Modern Kitchen With Breakfast Bar, Granite Counter Top, Backsplash, Stainless Steel Appliances& Additional Walk In Pantry. Nov. 2018 Laminate Throughout House, 2 Full Bathrooms In Bedroom Area Upstairs. Close To Shopping, Aldershot Go, Hwy 403 Or 407. 15 Minute Drive To McMaster University. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-19T20:07:12.649730+00:00"
+"Directions": "Dundas & Spring Creek Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967588"
+"ListOfficeKey": "74308"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "25.5 x 62.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-19T16:14:17Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-19T16:14:17Z"
+"Stories": "3.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "22"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5652"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1562250038"
"RoomType" => "Office"
"ListingId" => "X12708588"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "29265095"
"RoomLength" => 3.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
1 => array:11 [
"RoomKey" => "1562250039"
"RoomType" => "Kitchen"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 2.47
"ListingKey" => "29265095"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
2 => array:11 [
"RoomKey" => "1562250040"
"RoomType" => "Eating area"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "29265095"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
3 => array:11 [
"RoomKey" => "1562250041"
"RoomType" => "Family room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.44
"ListingKey" => "29265095"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
4 => array:11 [
"RoomKey" => "1562250042"
"RoomType" => "Living room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
5 => array:11 [
"RoomKey" => "1562250043"
"RoomType" => "Dining room"
"ListingId" => "X12708588"
"RoomLevel" => "Second level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.02Z"
]
6 => array:11 [
"RoomKey" => "1562250044"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.84
"ListingKey" => "29265095"
"RoomLength" => 4.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
7 => array:11 [
"RoomKey" => "1562250045"
"RoomType" => "Bedroom 2"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.77
"ListingKey" => "29265095"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
8 => array:11 [
"RoomKey" => "1562250046"
"RoomType" => "Bedroom 3"
"ListingId" => "X12708588"
"RoomLevel" => "Third level"
"RoomWidth" => 3.07
"ListingKey" => "29265095"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-19T16:14:17.03Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29265095/74-22-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 25.6
+"OriginalEntryTimestamp": "2026-01-19T16:14:16.99Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6410659818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/36a359313980773152ae1c1cf808182d.webp"
"MediaSize" => 61734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-36a359313980773152ae1c1cf808182d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6410659837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/a7a4d60a5a65092eedc84017792fa217.webp"
"MediaSize" => 32452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-a7a4d60a5a65092eedc84017792fa217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6410659845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/601498a42c12a23c26b803ae916a984f.webp"
"MediaSize" => 31728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-601498a42c12a23c26b803ae916a984f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6410659869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/f74a1dbe5cb77d27582b15c6657fb317.webp"
"MediaSize" => 27641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-f74a1dbe5cb77d27582b15c6657fb317.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6410659894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/b5d8ed0b82ae617e7d3e0ef25a795545.webp"
"MediaSize" => 32045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-b5d8ed0b82ae617e7d3e0ef25a795545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6410659935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/136b7e03c39fbc7d85d4c4d5c6cd624e.webp"
"MediaSize" => 33402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-136b7e03c39fbc7d85d4c4d5c6cd624e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6410659973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/1c0058964d339c7e27c9f3a9eb6d06a6.webp"
"MediaSize" => 29863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-1c0058964d339c7e27c9f3a9eb6d06a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6410660002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/5da5fb7e27f93b20407bb30ab544a3f0.webp"
"MediaSize" => 24611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-5da5fb7e27f93b20407bb30ab544a3f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6410660006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/cd2de39dd96e7816b7aab8fbf18d2d56.webp"
"MediaSize" => 25285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-cd2de39dd96e7816b7aab8fbf18d2d56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6410660047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/5801c2bbeed64d99acc8f8c7fa10b185.webp"
"MediaSize" => 30965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-5801c2bbeed64d99acc8f8c7fa10b185.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6410660081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/baa126496269d0d2f8af472799ceeae1.webp"
"MediaSize" => 28855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-baa126496269d0d2f8af472799ceeae1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6410660121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/3add034dc64ce8e3614160546da97c9f.webp"
"MediaSize" => 24995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-3add034dc64ce8e3614160546da97c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6410660147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/e402b003ff90e86668c670ace23f6eca.webp"
"MediaSize" => 21056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-e402b003ff90e86668c670ace23f6eca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6410660185"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/76c17674383fec9e610607dbf69503e2.webp"
"MediaSize" => 23889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-76c17674383fec9e610607dbf69503e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6410660247"
…11
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29265095')"
+"ID": "545177"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24967
+post_id: "543745"
+post_author: 1
+"ListingKey": "29263985"
+"ListingId": "X12707442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-18T22:51:03Z"
+"RFModificationTimestamp": "2026-01-18T23:00:12Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "503 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.896456
1 => 43.331203
]
+"Latitude": 43.331203
+"Longitude": -79.896456
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This bright and modern unit features neutral colors throughout, quartz countertops, and pot lights creating a warm and inviting atmosphere. Step out onto your private balcony to enjoy the afternoon sun. This open-concept unit features upgraded appliances and lighting throughout. The kitchen features a new ceramic backsplash and large island that offers seating and well as additional storage. Upgraded cabinetry throughout. In-suite laundry with upgraded washer and dryer is also included. Adjacent to the primary bedroom you will find a large walk-in closet and spacious 4-piece ensuite with oversized shower, upgraded counter-height vanities with quartz tops, LED mirrors and double sinks. A heated underground parking space and a storage locker are included. The building features a party room and bike room for secure storage. Enjoy the convenience of living at 5 Hamilton Condos, perfectly situated in the vibrant Waterdown core. Just steps away from your front door you'll enjoy local shops, services and restaurants including a pharmacy and grocery stores. Within walking distance, you will discover the charm of Waterdown including scenic trails, Smokey Hollow Waterfall, and Memorial Park. With shopping and services nearby and easy access to highways, this location offers both convenience and connectivity. This condo offers the perfect balance of comfort, convenience, and low maintenance living in one of Waterdown's most desirable locations. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater - Tankless"
]
+"AssociationFee": "475.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-18T22:59:56.260050+00:00"
+"Directions": "Cross Streets: Dundas St E & Hamilton St N. ** Directions: 5 Hamilton St N."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "Not known"
2 => "Natural gas"
3 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059353"
+"ListOfficeKey": "283746"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-18T22:40:29Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-18T22:40:29Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3839.11"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29263985/503-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C5"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-18T22:40:29.71Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:30 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29263985')"
+"ID": "543745"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24908
+post_id: "543746"
+post_author: 1
+"ListingKey": "29263951"
+"ListingId": "40798680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-18T22:30:37Z"
+"RFModificationTimestamp": "2026-01-18T22:34:17Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1025.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "5 HAMILTON Street N Unit# 503, Waterdown, Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.8964452
1 => 43.3313139
]
+"Latitude": 43.3313139
+"Longitude": -79.8964452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This bright and modern unit features neutral colors throughout, quartz countertops, and pot lights creating a warm and inviting atmosphere. Step out onto your private balcony to enjoy the afternoon sun. This open-concept unit features upgraded appliances and lighting throughout. The kitchen features a new ceramic backsplash and large island that offers seating and well as additional storage. Upgraded cabinetry throughout. In-suite laundry with upgraded washer and dryer is also included. Adjacent to the primary bedroom you will find a large walk-in closet and spacious 4-piece ensuite with oversized shower, upgraded counter-height vanities with quartz tops, LED mirrors and double sinks. A heated underground parking space and a storage locker are included. The building features a party room and bike room for secure storage. Enjoy the convenience of living at 5 Hamilton Condos, perfectly situated in the vibrant Waterdown core. Just steps away from your front door you’ll enjoy local shops, services and restaurants including a pharmacy and grocery stores. Within walking distance, you will discover the charm of Waterdown including scenic trails, Smokey Hollow Waterfall, and Memorial Park. With shopping and services nearby and easy access to highways, this location offers both convenience and connectivity. This condo offers the perfect balance of comfort, convenience, and low maintenance living in one of Waterdown’s most desirable locations. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "475.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-18T22:33:57.274340+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523819"
+"ListOfficeKey": "272222"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-18T21:38:28Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-18T22:18:35Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "HAMILTON"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3839.11"
+"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/29263951/5-hamilton-street-n-unit-503-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1523818"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "272222"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "C5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1025
+"OriginalEntryTimestamp": "2026-01-18T21:38:28.27Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:30 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29263951')"
+"ID": "543746"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24968
+post_id: "541859"
+post_author: 1
+"ListingKey": "29260381"
+"ListingId": "X12704084"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:50:56Z"
+"RFModificationTimestamp": "2026-01-16T23:42:24Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "909 - 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": "Stunning Corner Condo with Expansive Private Rooftop Terrace, a storage locker and two parking spots! Discover a one-of-a-kind opportunity to own this beautiful corner unit with breathtaking views and a massive private terrace-your very own rooftop retreat. Whether you love to entertain, need a play space, or simply want to bask in the sun, this outdoor oasis is a rare find. Inside, the open concept living space is designed for both style and functionality. The upgraded kitchen boasts ample cabinetry, quartz countertops, and high-end finishes, perfect for cooking and hosting. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy ambiance. Step into the primary bedroom and enjoy expansive windows and a spacious walk-in closet. The second bedroom, also featuring a walk-in closet and floor-to-ceiling windows, is ideal as a guest room or home office. The sleek, upgraded bathroom includes a stunning walk-in shower with a waterfall showerhead for a spa-like experience. Located in a prime area, you'll be within walking distance of restaurants and shops, with easy access to highways and the GO Station for commuters. Residents enjoy top-tier amenities, including a state-of-the-art fitness center, an elegant party room, and a rooftop deck with a community BBQ area. Don't miss this rare opportunity to own a beautiful, modern condo with a private rooftop terrace that truly sets it apart. Schedule your viewing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "440.93"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T23:41:50.671688+00:00"
+"Directions": "Dundas St. E"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192347"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:42:05Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:42:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3297.86"
+"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/29260381/909-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Separate Heating Controls"
4 => "Party Room"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-16T19:42:05.04Z"
+"MapCoordinateVerifiedYN": false
+"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:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260381')"
+"ID": "541859"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24998
+post_id: "541750"
+post_author: 1
+"ListingKey": "29260620"
+"ListingId": "X12704262"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T20:30:57Z"
+"RFModificationTimestamp": "2026-01-16T23:28:21Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "233 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Sun-filled corner unit One Bedroom + Den condo comes with one underground parking spot, one storage locker, and features a State Of The Art Geothermal Heating and Cooling system which keeps the hydro bills low!!! Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "417.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T23:27:52.729556+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Waterdown Road - Dundas ST E - Mallard Trail."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T20:18:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T20:18:44Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "3146.83"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29260620/233-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-16T20:18:44.1Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260620')"
+"ID": "541750"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24917
+post_id: "540495"
+post_author: 1
+"ListingKey": "29260071"
+"ListingId": "40799183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:25:17Z"
+"RFModificationTimestamp": "2026-01-16T19:30:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 233, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8795131
1 => 43.3431207
]
+"Latitude": 43.3431207
+"Longitude": -79.8795131
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sun-filled corner unit one bedroom + Den condo comes with one underground parking spot, one storage locker, and features a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low!!!\u{A0} Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T19:30:13.709623+00:00"
+"Directions": "Waterdown Rd - Dundas St E - Mallard Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:19:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:19:44Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29260071/10-mallard-trail-unit-233-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"TotalActualRent": 2375
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "UC-13"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 728
+"OriginalEntryTimestamp": "2026-01-16T18:59:53.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29260071')"
+"ID": "540495"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23512
+post_id: "540288"
+post_author: 1
+"ListingKey": "29259992"
+"ListingId": "40799165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T19:25:17Z"
+"RFModificationTimestamp": "2026-01-16T19:28:04Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "10 MALLARD Trail Unit# 233, Waterdown, Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.8795253
1 => 43.3431313
]
+"Latitude": 43.3431313
+"Longitude": -79.8795253
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sun-filled corner unit one bedroom + Den condo comes with one underground parking spot, one storage locker, and features a state of the art Geothermal Heating and Cooling system which keeps the hydro bills low!!!\u{A0} Includes upgraded flooring throughout, open concept kitchen and living room with upgraded appliances. The condo is complete with in-suite laundry, a 3-pc bathroom with a stand-up shower, and a spacious Den perfect for your home office needs. Enjoy all of the fabulous amenities that this building has to offer; including party rooms, modern fitness facilities, rooftop patios and bike storage. Situated in the desirable Waterdown community with fabulous dining, shopping, schools and parks. 5 minute drive to downtown Burlington or the Aldershot GO Station, 20 minute commute to Mississauga. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T19:28:00.739172+00:00"
+"Directions": "Waterdown Rd - Dundas St E - Mallard Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-16T19:19:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:19:44Z"
+"Stories": "1.0"
+"StreetName": "MALLARD"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3146.83"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29259992/10-mallard-trail-unit-233-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2110390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "UC-13"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 728
+"OriginalEntryTimestamp": "2026-01-16T18:49:12.13Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29259992')"
+"ID": "540288"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24988
+post_id: "537032"
+post_author: 1
+"ListingKey": "29255398"
+"ListingId": "X12699852"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T18:30:35Z"
+"RFModificationTimestamp": "2026-01-15T20:00:18Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "604 - 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 the highly sought-after Trend 3 community in the heart of Waterdown! This bright and inviting 1-bedroom condo offers an open-concept layout that seamlessly connects the modern kitchen and living area. The kitchen features brand-new stainless steel appliances, quartz countertops, and a stylish breakfast bar, creating an ideal space for cooking and entertaining. A well-appointed 4-piece bathroom and the convenience of in-suite laundry complete this thoughtfully designed suite. Enjoy a lifestyle of comfort and convenience with exceptional building amenities, including vibrant party rooms, a state-of-the-art fitness centre, scenic rooftop patios, and secure bike storage. Situated just minutes from top-rated dining, shopping, schools, and picturesque parks, this location is perfect for those seeking walkable urban living. One owned surface parking space and an owned locker are included, providing added ease and extra storage. Experience contemporary living at its finest in this exceptional condo! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "335.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T20:00:05.314321+00:00"
+"Directions": "Dundas/Mallard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036737"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T18:23:32Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T18:23:32Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2592.96"
+"VirtualTourURLUnbranded": "https://youriguide.com/604_470_dundas_st_e_hamilton_on/"
+"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/29255398/604-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-15T18:23:32.47Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29255398')"
+"ID": "537032"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24983
+post_id: "535565"
+post_author: 1
+"ListingKey": "29252282"
+"ListingId": "X12697348"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T22:50:54Z"
+"RFModificationTimestamp": "2026-01-15T01:06:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G7"
+"UnparsedAddress": "545 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0G7"
+"Coordinates": array:2 [
0 => -79.872959
1 => 43.348888
]
+"Latitude": 43.348888
+"Longitude": -79.872959
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Opportunity To Lease A Versatile 3.2-Acre Property With Commercial Zoning. Ideal For Entrepreneurs, Creatives, Or Business Owners Seeking A Live-Work Environment. This Partially Finished Residence Offers Four Spacious Bedrooms, Including A Main-Floor Primary Suite With Ensuite, Providing Both Comfort And Functionality. The Expansive Lot Provides Ample Parking And Outdoor Space, Making It Suitable For A Wide Range Of Permitted Business Uses. Whether You're Looking To Operate A Studio, Professional Office, Creative Workspace, Or Home-Based Business, Tenants Are Encouraged To Verify Zoning To Suit Their Needs. Conveniently Located Just 10 Minutes From Downtown Waterdown And Close To Major Routes And Amenities, This Property Offers The Perfect Balance Of Accessibility, Privacy, And Commercial Potential. A Unique Opportunity For Those Looking To Work And Live In One Exceptional Space. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-01-15T01:06:01.459321+00:00"
+"Directions": "Dundas St E & Evans Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1971659"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "386.5 x 351 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T22:43:43Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T22:43:43Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "545"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252282/545-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 386.6
+"OriginalEntryTimestamp": "2026-01-14T22:43:43.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:20 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252282')"
+"ID": "535565"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 161
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]