array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29164823/Property?$select=ALL&$top=20&$filter=ListingKey eq 29164823&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29164823/Property?$select=ALL&$top=20&$filter=ListingKey eq 29164823&$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: "464308"
+post_author: 1
+"ListingKey": "29164823"
+"ListingId": "X12603202"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T01:55:24Z"
+"RFModificationTimestamp": "2025-12-05T03:38:03Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.886026
1 => 43.331229
]
+"Latitude": 43.331229
+"Longitude": -79.886026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. Potential to assemble with property next door. VTB FINANCING AVAILABLE. Consider the possibilities for your dream home or as an investment. (id:62650)"
+"CreationDate": "2025-12-05T03:37:47.851068+00:00"
+"Directions": "Cross Streets: Dundas Street. ** Directions: Mill St. S. is Waterdown Rd. south of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "61.88 x 124 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T01:47:01Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T01:47:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3773"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29164823/191-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 61.1
+"OriginalEntryTimestamp": "2025-12-05T01:47:01.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6356271897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/86cbd972edf8c33924d403ebdd2b70ab.webp"
"MediaSize" => 241855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-86cbd972edf8c33924d403ebdd2b70ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6356271907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/5501185293857adbe503bd0d22360c1f.webp"
"MediaSize" => 213499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-5501185293857adbe503bd0d22360c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6356271915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/8b65b6b98ab580d5590a2084d8eb7a92.webp"
"MediaSize" => 219530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-8b65b6b98ab580d5590a2084d8eb7a92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6356271943"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/b9d907c5fd459d84a7b2aaa4e370d3a5.webp"
"MediaSize" => 229613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-b9d907c5fd459d84a7b2aaa4e370d3a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6356271968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/68427f5b4d83fdea591ec085d317220e.webp"
"MediaSize" => 220001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-68427f5b4d83fdea591ec085d317220e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6356271992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/1178065df19746464d5e6c2e7cb9d453.webp"
"MediaSize" => 220849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-1178065df19746464d5e6c2e7cb9d453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6356272015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/2074e522086156b45d92f2fff52e7a02.webp"
"MediaSize" => 223582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-2074e522086156b45d92f2fff52e7a02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6356272038"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/969321864f5ffe287a20ee930c67531c.webp"
"MediaSize" => 223787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-969321864f5ffe287a20ee930c67531c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6356272048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/bdbdafa9441f4f58c233a5bdaf426159.webp"
"MediaSize" => 207834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-bdbdafa9441f4f58c233a5bdaf426159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6356272088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/07017849a486d20dc046b0f8f6da5411.webp"
"MediaSize" => 205272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-07017849a486d20dc046b0f8f6da5411.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6356272099"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/55a0fc4de160a96f04be6bbcff8c2024.webp"
"MediaSize" => 199765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-55a0fc4de160a96f04be6bbcff8c2024.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6356272159"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/4e2e6f204ac4068804a2bf1a68818140.webp"
"MediaSize" => 189710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-4e2e6f204ac4068804a2bf1a68818140.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6356272232"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/12bab165159561e1b379c5965b43c77c.webp"
"MediaSize" => 192722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-12bab165159561e1b379c5965b43c77c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6356272285"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/fbb68a21489db7de509a151f2ba5b190.webp"
"MediaSize" => 204593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-fbb68a21489db7de509a151f2ba5b190.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6356272320"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/3195748659ea17f5310fd65891565677.webp"
"MediaSize" => 209790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-3195748659ea17f5310fd65891565677.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6356272356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/4f9d451ae22d45e767b61cc1fab43c6e.webp"
"MediaSize" => 210581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-4f9d451ae22d45e767b61cc1fab43c6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6356272419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/ba0d046e35d02e90da01b0ba134721a3.webp"
"MediaSize" => 209170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-ba0d046e35d02e90da01b0ba134721a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6356272480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/7b6299ca8b1a53112757f0ee45894326.webp"
"MediaSize" => 214337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-7b6299ca8b1a53112757f0ee45894326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6356272536"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/d8fbb0052183bff7b729cb3cc06d5f74.webp"
"MediaSize" => 218216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-d8fbb0052183bff7b729cb3cc06d5f74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6356272585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/b1cfa75adbb886a61d1a28df439b042f.webp"
"MediaSize" => 247768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-b1cfa75adbb886a61d1a28df439b042f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6356272591"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/b15b94cddcb364c3c5f240aff84e1298.webp"
"MediaSize" => 249976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-b15b94cddcb364c3c5f240aff84e1298.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6356272633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/9375c542e35baafa357d687c7b3beb92.webp"
"MediaSize" => 251202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-9375c542e35baafa357d687c7b3beb92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6356272645"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/9f0edb1e26c8fa11a5bf425874807e58.webp"
"MediaSize" => 246582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-9f0edb1e26c8fa11a5bf425874807e58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6356272703"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/4ea5190ca3daf60ef0521debdb8f82d3.webp"
"MediaSize" => 246544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-4ea5190ca3daf60ef0521debdb8f82d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6356272733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/6b0b23fe366167860c7dbec05ca525ed.webp"
"MediaSize" => 243057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-6b0b23fe366167860c7dbec05ca525ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6356272763"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/d99286cc22f87105423db7d7b086cebe.webp"
"MediaSize" => 246788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-d99286cc22f87105423db7d7b086cebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6356272824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/def837c719f27837217c4929cd7e6f8b.webp"
"MediaSize" => 254115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-def837c719f27837217c4929cd7e6f8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6356272887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/87ff935f2b3bcb77c472b5c13c28a2eb.webp"
"MediaSize" => 215210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-87ff935f2b3bcb77c472b5c13c28a2eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6356272939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29164823/f22a5b38ff37a415d3c16bc3810ef128.webp"
"MediaSize" => 219483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29164823/thumbnail-f22a5b38ff37a415d3c16bc3810ef128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12603202"
"ResourceRecordKey" => "29164823"
"ModificationTimestamp" => "2025-12-05T01:47:01.4Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "CONRAD GUY ZURINI"
"MemberFirstName" => "CONRAD GUY"
"MemberLastName" => "ZURINI"
"MemberMlsId" => "3813025"
"OriginatingSystemName" => 26
"MemberKey" => "1413922"
"ModificationTimestamp" => "2025-08-18T20:21:51Z"
"MemberStatus" => "Active"
"OfficeKey" => "266588"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-639-7676"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1243509"
"OfficeNationalAssociationId" => "1274323"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX ESCARPMENT REALTY INC."
"OfficePhone" => "905-639-7676"
"OfficeMlsId" => "184000"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "266588"
"ModificationTimestamp" => "2024-10-04T01:24:44Z"
"OfficeAddress1" => "2180 ITABASHI WAY #4B"
"OfficeCity" => "BURLINGTON"
"OfficePostalCode" => "L7M5A5"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-681-9908"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2011-09-09T03:45:00Z"
"OfficeNationalAssociationId" => "1274323"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1243509"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29164823')"
+"ID": "464308"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 266588/Office?$select=ALL&$top=10&$filter=OfficeKey eq 266588&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 266588/Office?$select=ALL&$top=10&$filter=OfficeKey eq 266588&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "184000"
+"ModificationTimestamp": "2024-10-04T01:24:44Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "266588"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 ITABASHI WAY #4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7M5A5"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1274323"
+"OriginalEntryTimestamp": "2011-09-09T03:45:00Z"
+"OfficeFax": "905-681-9908"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "324280"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "266588"
"SocialMediaUrlOrId" => "http://www.remaxescarpment.com/"
"ModificationTimestamp" => "2024-10-04T00:06:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1243509"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('266588')"
}
]
+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 1413922/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1413922&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1413922/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1413922&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25319
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29164823" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24948
+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 29164823/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29164823&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29164823/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29164823&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24930
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29164823 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.886026 43.331229)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29164823 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.886026 43.331229)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29164823 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.886026 43.331229)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29164823 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.886026 43.331229)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24840
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24851
+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"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/0f35100348a49031f715e451a04f41cd.webp"
"MediaSize" => 29041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-0f35100348a49031f715e451a04f41cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6410660281"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/d088cec68040be077f119b05bd433f36.webp"
"MediaSize" => 22911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-d088cec68040be077f119b05bd433f36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6410660332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/49fd7f8d06eeb8d162f72a829b6d1565.webp"
"MediaSize" => 27200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-49fd7f8d06eeb8d162f72a829b6d1565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6410660367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/79a531465ab9206d2afbfdbef82d85f1.webp"
"MediaSize" => 28392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-79a531465ab9206d2afbfdbef82d85f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6410660412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/43a981448f615cb5f4851fedef6aabc2.webp"
"MediaSize" => 21717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-43a981448f615cb5f4851fedef6aabc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6410660459"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29265095/75755ec02a6d1c86ed32a21b7ee59f61.webp"
"MediaSize" => 59031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29265095/thumbnail-75755ec02a6d1c86ed32a21b7ee59f61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12708588"
"ResourceRecordKey" => "29265095"
"ModificationTimestamp" => "2026-01-19T16:14:17Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "IHAB BASHA"
"MemberFirstName" => "IHAB"
"MemberLastName" => "BASHA"
"MemberMlsId" => "9556823"
"OriginatingSystemName" => 26
"MemberKey" => "1967588"
"ModificationTimestamp" => "2025-12-15T06:03:50Z"
"MemberStatus" => "Active"
"OfficeKey" => "74308"
"MemberAOR" => "Toronto"
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "647-700-0316"
"MemberSocialMedia" => array:3 [ …3]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2013-12-04T00:58:00Z"
"MemberNationalAssociationId" => "1255452"
"OfficeNationalAssociationId" => "1004451"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "ROYAL LEPAGE REALTY PLUS"
"OfficePhone" => "905-828-6550"
"OfficeMlsId" => "65800"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "74308"
"ModificationTimestamp" => "2025-01-12T14:00:57Z"
"OfficeAddress1" => "2575 DUNDAS STREET WEST"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5K2M"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-828-1511"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeNationalAssociationId" => "1004451"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1062073"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29265095')"
+"ID": "545177"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24790
+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 [
"RoomKey" => "1561929794"
"RoomType" => "Kitchen"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 2.95
"ListingKey" => "29263985"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.77Z"
]
1 => array:11 [
"RoomKey" => "1561929795"
"RoomType" => "Living room"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 4.67
"ListingKey" => "29263985"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.77Z"
]
2 => array:11 [
"RoomKey" => "1561929796"
"RoomType" => "Dining room"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 5.59
"ListingKey" => "29263985"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
3 => array:11 [
"RoomKey" => "1561929797"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 3.15
"ListingKey" => "29263985"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
4 => array:11 [
"RoomKey" => "1561929798"
"RoomType" => "Bedroom"
"ListingId" => "X12707442"
"RoomLevel" => "Flat"
"RoomWidth" => 2.74
"ListingKey" => "29263985"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-18T22:40:29.78Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6409660358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/246c518ce8b1a87a90837c16371d9d27.webp"
"MediaSize" => 328307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-246c518ce8b1a87a90837c16371d9d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6409660361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/a947659c881349d6c2d9261f075d7e38.webp"
"MediaSize" => 314581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-a947659c881349d6c2d9261f075d7e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6409660364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/194150345f959f0177dd5084b43a174e.webp"
"MediaSize" => 152110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-194150345f959f0177dd5084b43a174e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6409660367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/c4363a3af3a5139e24dc8c19ae1cdfe6.webp"
"MediaSize" => 132067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-c4363a3af3a5139e24dc8c19ae1cdfe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6409660370"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/5c9448bab8e59cda9a8c310f4d40e051.webp"
"MediaSize" => 130042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-5c9448bab8e59cda9a8c310f4d40e051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6409660374"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/09f0a349721df9633fc26f3679880be5.webp"
"MediaSize" => 145726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-09f0a349721df9633fc26f3679880be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6409660376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/1948c0f42e0318b88f02ec46efb8d045.webp"
"MediaSize" => 130361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-1948c0f42e0318b88f02ec46efb8d045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6409660379"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/909f4e8c8c2178eb37d958cf7f8909db.webp"
"MediaSize" => 121988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-909f4e8c8c2178eb37d958cf7f8909db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6409660380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/5ed92e70cf05ca3e00bca2f631665c0a.webp"
"MediaSize" => 132189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-5ed92e70cf05ca3e00bca2f631665c0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6409660382"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/1c81e505afab7bd7d249ebad85197d19.webp"
"MediaSize" => 127452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-1c81e505afab7bd7d249ebad85197d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6409660384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/4a48da3c3e72f1ccc8a6dcb6c00fb57e.webp"
"MediaSize" => 105818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-4a48da3c3e72f1ccc8a6dcb6c00fb57e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6409660387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/adf2ccb8a9cf3b0237e652b7bc5fb30a.webp"
"MediaSize" => 153617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-adf2ccb8a9cf3b0237e652b7bc5fb30a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12707442"
"ResourceRecordKey" => "29263985"
"ModificationTimestamp" => "2026-01-18T22:40:29.72Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6409660389"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29263985/501b2d4886ca3a75c7346d8226fc19b3.webp"
"MediaSize" => 148690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29263985/thumbnail-501b2d4886ca3a75c7346d8226fc19b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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 {#24850
+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 {#24849
+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 {#24766
+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 {#25162
+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 {#24830
+post_id: "538578"
+post_author: 1
+"ListingKey": "29257510"
+"ListingId": "X12701608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T20:00:18Z"
+"RFModificationTimestamp": "2026-01-16T20:03:11Z"
+"ListPrice": 920000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "31 - 54 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.906772
1 => 43.339029
]
+"Latitude": 43.339029
+"Longitude": -79.906772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "URBAN ELEGANCE MEETS MODERN COMFORT! Welcome to this fabulous freehold townhome nestled in a highly desirable area of Waterdown. This rare end unit boasts three spacious bedrooms and a double car garage allowing for four vehicle parking a true luxury in today's market! With an impressive 2,200 square feet of finished living space, this home offers room to breathe and grow. The gourmet kitchen features an extended island with a convenient breakfast bar, premium stainless steel appliances, and abundant cabinet space for all your culinary needs. Upstairs, you'll discover three generously sized bedrooms, including a stunning primary bedroom complete with a three-piece ensuite and a walk-in closet expertly fitted with organizers. Step outside to enjoy morning coffee or evening relaxation on your private balcony, complete with a gas line for barbecuing enthusiasts. Second-floor laundry with a utility sink adds everyday convenience. The professionally finished lower level provides additional entertaining space perfect for family movie nights or hosting friends. A 3 pc bathroom, and ample storage complete the level. Recently refreshed with fresh paint throughout, this immaculate home is move-in ready. The child-friendly neighbourhood offers peace of mind for families, while proximity to Waterdown District High School (just 381 meters away) and Memorial Park makes this location ideal. Enjoy the convenience of walking to shops, restaurants, and recreational areas. Commuters will appreciate easy highway access and just a 10-minute drive to Aldershot GO Station. Your urban oasis awaits! (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Stove"
2 => "Window Coverings"
3 => "Garage door opener"
4 => "Garage door opener remote(s)"
5 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T01:11:10.786294+00:00"
+"Directions": "Cross Streets: Hamilton St N and Nisbet Blvd. ** Directions: Hamilton St N, Left on Nesbit Blvd. Turn right into complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1602209"
+"ListOfficeKey": "291557"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Carpet Free"
]
+"LotSizeDimensions": "34.7 x 52.5 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-16T00:25:41Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:45:37Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5083.86"
+"VirtualTourURLUnbranded": "https://youtu.be/MsqbTz-DJOY"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29257510/31-54-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1529018"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 34.8
+"OriginalEntryTimestamp": "2026-01-16T00:25:41.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29257510')"
+"ID": "538578"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24832
+post_id: "538579"
+post_author: 1
+"ListingKey": "29257266"
+"ListingId": "40798749"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-16T20:00:18Z"
+"RFModificationTimestamp": "2026-01-16T20:03:11Z"
+"ListPrice": 920000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2200.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0Y3"
+"UnparsedAddress": "54 NISBET Boulevard Unit# 31, Waterdown, Ontario L8B0Y3"
+"Coordinates": array:2 [
0 => -79.9067904
1 => 43.3386394
]
+"Latitude": 43.3386394
+"Longitude": -79.9067904
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "URBAN ELEGANCE MEETS MODERN COMFORT! Welcome to this fabulous freehold townhome nestled in a highly desirable area of Waterdown. This rare end unit boasts three spacious bedrooms and a double car garage allowing for four vehicle parking a true luxury in today's market! With an impressive 2,200 square feet of finished living space, this home offers room to breathe and grow. The gourmet kitchen features an extended island with a convenient breakfast bar, premium stainless steel appliances, and abundant cabinet space for all your culinary needs. Upstairs, you'll discover three generously sized bedrooms, including a stunning primary bedroom complete with a three-piece ensuite and a walk-in closet expertly fitted with organizers. Step outside to enjoy morning coffee or evening relaxation on your private balcony, complete with a gas line for barbecuing enthusiasts. Second-floor laundry with a utility sink adds everyday convenience. The professionally finished lower level provides additional entertaining space perfect for family movie nights or hosting friends. A 3 pc bathroom, and ample storage complete the level. Recently refreshed with fresh paint throughout, this immaculate home is move-in ready. The child-friendly neighbourhood offers peace of mind for families, while proximity to Waterdown District High School (just 381 meters away) and Memorial Park makes this location ideal. Enjoy the convenience of walking to shops, restaurants, and recreational areas. Commuters will appreciate easy highway access and just a 10-minute drive to Aldershot GO Station. Your urban oasis awaits! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-16T00:58:52.213335+00:00"
+"Directions": "HAMILTON ST. N LEFT ON BISBET BLVD. TURN RIGHT INOT COMPLEX"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026061"
+"ListOfficeKey": "291745"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T23:29:19Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-16T19:50:11Z"
+"Stories": "2.0"
+"StreetName": "NISBET"
+"StreetNumber": "54"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "6562"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=lZlAUnaUwBU"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29257266/54-nisbet-boulevard-unit-31-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931491"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291745"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-27"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1578
+"BelowGradeFinishedArea": 622
+"OriginalEntryTimestamp": "2026-01-15T23:29:18.82Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"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:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29257266')"
+"ID": "538579"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 171
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]