array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29999791 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1599648"
+post_author: 1
+"ListingKey": "29999791"
+"ListingId": "X13532616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:50:06Z"
+"RFModificationTimestamp": "2026-07-07T17:08:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "57 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8947788
1 => 43.3345316
]
+"Latitude": 43.3345316
+"Longitude": -79.8947788
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 57 Main Street! A charming bungalow set on an impressive 67' x 164' lot in the heart of Waterdown. Thoughtfully updated while preserving its original character, this inviting 2-bedroom home seamlessly blends modern updates with timeless charm. Inside you'll find soaring ceilings, original hardwood floors, and beautiful architectural details. The updated kitchen features quartz countertops, stainless steel appliances, and plenty of workspace. The spacious bathroom includes the convenience of in-suite laundry. Outside you will step into your own private backyard retreat complete with a newly renovated deck that overlooks a saltwater pool and an expansive tree-lined yard offering exceptional privacy and space to relax or entertain. The location is second to none. Nestled in Waterdown's sought-after downtown core, you're just steps from local boutiques, restaurants, cafés, parks, and year-round community events including the beloved Santa Claus Parade. This is a rare opportunity to own a beautifully updated home on an oversized lot in one of Waterdown's most desirable neighborhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:08:24.916673+00:00"
+"Directions": "Cross Streets: Main St N and Dundas St E. ** Directions: Dundas St E to Main St N."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252185"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "66 x 164.4 FT"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:40:48Z"
+"PhotosCount": 21
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:40:48Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5843.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1677437858"
"RoomType" => "Bedroom"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29999791"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.77Z"
]
1 => array:11 [
"RoomKey" => "1677437859"
"RoomType" => "Bedroom 2"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29999791"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.77Z"
]
2 => array:11 [
"RoomKey" => "1677437860"
"RoomType" => "Dining room"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29999791"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.77Z"
]
3 => array:11 [
"RoomKey" => "1677437861"
"RoomType" => "Living room"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29999791"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.77Z"
]
4 => array:11 [
"RoomKey" => "1677437862"
"RoomType" => "Kitchen"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 4.17
"ListingKey" => "29999791"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.78Z"
]
5 => array:11 [
"RoomKey" => "1677437863"
"RoomType" => "Den"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29999791"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.78Z"
]
6 => array:11 [
"RoomKey" => "1677437864"
"RoomType" => "Bathroom"
"ListingId" => "X13532616"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29999791"
"RoomLength" => 1.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:40:48.78Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999791/57-main-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-07-07T16:40:48.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1491120"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29999791_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/49525b10b79058fdd1d64179095b20c3.webp"
"MediaSize" => 369482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-49525b10b79058fdd1d64179095b20c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29999791_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/a3ea7134259dc959a8bd3631ee698942.webp"
"MediaSize" => 421578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-a3ea7134259dc959a8bd3631ee698942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29999791_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/b6d186fd05da3bfe78a5143e0b96ca52.webp"
"MediaSize" => 359869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-b6d186fd05da3bfe78a5143e0b96ca52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29999791_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/cb7985b661fc715396099486f140f7b1.webp"
"MediaSize" => 174134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-cb7985b661fc715396099486f140f7b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29999791_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/c3c3807e8146581b337162478264c11b.webp"
"MediaSize" => 167454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-c3c3807e8146581b337162478264c11b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29999791_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/7c339504163a530eaeac1db9bc062540.webp"
"MediaSize" => 188538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-7c339504163a530eaeac1db9bc062540.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29999791_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/b7c47123e5916a6c28f7e425669f9fea.webp"
"MediaSize" => 164357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-b7c47123e5916a6c28f7e425669f9fea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29999791_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/2173bc751336e99ff92fc97527a5b72b.webp"
"MediaSize" => 205511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-2173bc751336e99ff92fc97527a5b72b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29999791_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/87fc1cb18683a2227ab5621c90293f34.webp"
"MediaSize" => 195548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-87fc1cb18683a2227ab5621c90293f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29999791_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/a676eec7fbd3c0cff9148b99979f7abc.webp"
"MediaSize" => 189336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-a676eec7fbd3c0cff9148b99979f7abc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29999791_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/d71b5dd98a96253b0df5da227a9ce1b5.webp"
"MediaSize" => 138914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-d71b5dd98a96253b0df5da227a9ce1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29999791_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/f4714f74d7b076c443eac90b69b977f0.webp"
"MediaSize" => 199902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-f4714f74d7b076c443eac90b69b977f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29999791_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/ca461817f3c91159a45f89d74b9f97dc.webp"
"MediaSize" => 149142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-ca461817f3c91159a45f89d74b9f97dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29999791_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/a1de1c223b3b3de2dbfeec62283eb2b3.webp"
"MediaSize" => 160680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-a1de1c223b3b3de2dbfeec62283eb2b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29999791_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/ceb4074bdaafa8238c5e2a753b82f20e.webp"
"MediaSize" => 172850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-ceb4074bdaafa8238c5e2a753b82f20e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29999791_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/1720dfd8bf4f66cb84e81acae3153f66.webp"
"MediaSize" => 141924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-1720dfd8bf4f66cb84e81acae3153f66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29999791_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/a79faed4b82bb50f65bd992cfdfb5fc5.webp"
"MediaSize" => 151834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-a79faed4b82bb50f65bd992cfdfb5fc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29999791_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/0184599376ad1681afda84781315f780.webp"
"MediaSize" => 324851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-0184599376ad1681afda84781315f780.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29999791_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/e7acaab8b5df2dd9fa8e5e83466841a6.webp"
"MediaSize" => 325019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-e7acaab8b5df2dd9fa8e5e83466841a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29999791_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/c3fcadd548debd260c14225c182ef39b.webp"
"MediaSize" => 415404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-c3fcadd548debd260c14225c182ef39b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29999791_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999791/3d4e1c8da5c8a2aa525d279791851f32.webp"
"MediaSize" => 450641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999791/thumbnail-3d4e1c8da5c8a2aa525d279791851f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532616"
"ResourceRecordKey" => "29999791"
"ModificationTimestamp" => "2026-07-07T16:40:48.67Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999791')"
+"ID": "1599648"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 284790" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24926
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24823
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "184006"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284790"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "502 BRANT ST #1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7R2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344892"
+"OriginalEntryTimestamp": "2019-02-27T19:51:00Z"
+"OfficeFax": "905-631-5445"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1499122"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284790')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2252185" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24897
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24829
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2252185"
+"ModificationTimestamp": "2025-12-03T00:02:11Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2252185"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2252185')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29999791'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+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 '29999791' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25313
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29999791' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8947788 43.3345316)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1609700"
+post_author: 1
+"ListingKey": "30012970"
+"ListingId": "40846786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T18:55:20Z"
+"RFModificationTimestamp": "2026-07-09T19:51:08Z"
+"ListPrice": 818000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "245 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8788273
1 => 43.3366865
]
+"Latitude": 43.3366865
+"Longitude": -79.8788273
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional built townhouse in one of Waterdown’s most sought-after communities! Offering 1,484 square feet of thoughtfully designed living space, this move-in ready home features three spacious bedrooms, three bathrooms and the convenience of upper-level laundry. The bright, open-concept layout is perfect for everyday living and entertaining. Far from builder basic, the owners invested thousands in premium upgrades, custom window coverings and high-end finishes that elevate every room. Immaculately maintained and truly turnkey, this home offers all the benefits of new construction without the wait. Enjoy a low-maintenance lifestyle just minutes from charming downtown Waterdown, with its boutique shops, restaurants, parks, schools, and everyday amenities. Simply unpack and enjoy everything this beautiful home has to offer! Don’t be TOO LATE*! *REG TM. RSA. (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": "242.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:51:04.615921+00:00"
+"Directions": "HAMILTON ST N TO DUNDAS ST E TO BURKE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T18:48:29Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T18:48:29Z"
+"Stories": "3.0"
+"StreetName": "BURKE"
+"StreetNumber": "245"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4872"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1679341995"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
1 => array:11 [
"RoomKey" => "1679341996"
"RoomType" => "Full bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
2 => array:11 [
"RoomKey" => "1679341997"
"RoomType" => "Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
3 => array:11 [
"RoomKey" => "1679341998"
"RoomType" => "Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
4 => array:11 [
"RoomKey" => "1679341999"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
5 => array:11 [
"RoomKey" => "1679342000"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
6 => array:11 [
"RoomKey" => "1679342001"
"RoomType" => "Kitchen"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
7 => array:11 [
"RoomKey" => "1679342002"
"RoomType" => "Dining room"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
8 => array:11 [
"RoomKey" => "1679342003"
"RoomType" => "Living room"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012970/245-burke-street-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1484
+"OriginalEntryTimestamp": "2026-07-09T18:48:29.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30012970_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/0dcadc755b05fdb2adfa8650b272ecd1.webp"
"MediaSize" => 131586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-0dcadc755b05fdb2adfa8650b272ecd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30012970_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/1b68c324d6d0624a84ef75a959a047ec.webp"
"MediaSize" => 131367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-1b68c324d6d0624a84ef75a959a047ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30012970_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/c864b5f6b4b30edf17588ef14c9f9686.webp"
"MediaSize" => 57481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-c864b5f6b4b30edf17588ef14c9f9686.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30012970_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8e57ce416e40050417c126a05a4dc4b9.webp"
"MediaSize" => 79483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8e57ce416e40050417c126a05a4dc4b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30012970_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/1f6e0493a65ae96db0092fcb95e78674.webp"
"MediaSize" => 64858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-1f6e0493a65ae96db0092fcb95e78674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30012970_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7083306925ddce4a4680ff1de227e665.webp"
"MediaSize" => 73258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7083306925ddce4a4680ff1de227e665.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30012970_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/20aec0fae8a9a617cd7f6783e6e87a69.webp"
"MediaSize" => 90324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-20aec0fae8a9a617cd7f6783e6e87a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30012970_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/680599972c46aeeaac7169297dfad373.webp"
"MediaSize" => 69317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-680599972c46aeeaac7169297dfad373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30012970_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/0680aa1a69e83e794e0d3729c08750fd.webp"
"MediaSize" => 68764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-0680aa1a69e83e794e0d3729c08750fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30012970_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/73fdab46c9d4fb5e5119c3f51d1b7501.webp"
"MediaSize" => 53055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-73fdab46c9d4fb5e5119c3f51d1b7501.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30012970_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/db71c8326fd9ec910d3c8e64e8656090.webp"
"MediaSize" => 62123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-db71c8326fd9ec910d3c8e64e8656090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30012970_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/82f4d7e6d12b68ff019cf10d38f9ef21.webp"
"MediaSize" => 87759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-82f4d7e6d12b68ff019cf10d38f9ef21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30012970_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/67e41614330d3fac851a7f563ed6ad90.webp"
"MediaSize" => 71250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-67e41614330d3fac851a7f563ed6ad90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30012970_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/e9c10faca38601f06b5729e619f1cc21.webp"
"MediaSize" => 34178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-e9c10faca38601f06b5729e619f1cc21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30012970_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7816826fb4c6b0f558bfbc561ca69769.webp"
"MediaSize" => 49782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7816826fb4c6b0f558bfbc561ca69769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30012970_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/224de8c58d470d855ddc2b942d4ffbe7.webp"
"MediaSize" => 64972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-224de8c58d470d855ddc2b942d4ffbe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30012970_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/3567be07c3d9ebe35f80f949670951bb.webp"
"MediaSize" => 48406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-3567be07c3d9ebe35f80f949670951bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30012970_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/b4f95196509c038c5c0aad8aa9d9dd6d.webp"
"MediaSize" => 42846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-b4f95196509c038c5c0aad8aa9d9dd6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30012970_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7338680127abb1798133ba890dd0023b.webp"
"MediaSize" => 47311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7338680127abb1798133ba890dd0023b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30012970_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/f3cf691455e58e4ae8fc0724a2845b4d.webp"
"MediaSize" => 49625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-f3cf691455e58e4ae8fc0724a2845b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30012970_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/36dcc72e096c1ff64b84a7cb165230c9.webp"
"MediaSize" => 49836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-36dcc72e096c1ff64b84a7cb165230c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30012970_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/4e506a58371f98b3447d54d458bae702.webp"
"MediaSize" => 45386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-4e506a58371f98b3447d54d458bae702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30012970_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/16c97dcca9852b6f68ee6545346aa649.webp"
"MediaSize" => 54440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-16c97dcca9852b6f68ee6545346aa649.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30012970_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/ff72228394a9dc39946450985ab8c52e.webp"
"MediaSize" => 51465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-ff72228394a9dc39946450985ab8c52e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30012970_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/5d7e70200c4484ca43b94c9a721698f7.webp"
"MediaSize" => 46889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-5d7e70200c4484ca43b94c9a721698f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30012970_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/b6e9ed41070b833775e7b8d6d2f0ceda.webp"
"MediaSize" => 35801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-b6e9ed41070b833775e7b8d6d2f0ceda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30012970_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/77ff414812edcb29f3f0b69354d29dd6.webp"
"MediaSize" => 112105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-77ff414812edcb29f3f0b69354d29dd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30012970_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/2616f233816a46178754f37dbdb9dc8e.webp"
"MediaSize" => 111486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-2616f233816a46178754f37dbdb9dc8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30012970_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8bac8bb853acaedcaad76b3f58a06df5.webp"
"MediaSize" => 51962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8bac8bb853acaedcaad76b3f58a06df5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30012970_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8d37a632b4b859f81dbfbc12658dfb80.webp"
"MediaSize" => 93025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8d37a632b4b859f81dbfbc12658dfb80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30012970_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/d491a0906cbc7d7b4e4eb0536c730dc3.webp"
"MediaSize" => 127378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-d491a0906cbc7d7b4e4eb0536c730dc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30012970_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8094e04cc37afa4508579c4a636be87f.webp"
"MediaSize" => 131421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8094e04cc37afa4508579c4a636be87f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012970')"
+"ID": "1609700"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1609624"
+post_author: 1
+"ListingKey": "30013126"
+"ListingId": "X13544800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:20:06Z"
+"RFModificationTimestamp": "2026-07-09T19:42:46Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "110 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker-an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "724.17"
+"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-07-09T19:42:44.122416+00:00"
+"Directions": "Dundas St E and Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994256"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Level lot"
1 => "Elevator"
2 => "Balcony"
3 => "Level"
4 => "Carpet Free"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-09T19:10:55Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:10:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4682.53"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1679360187"
"RoomType" => "Kitchen"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.28
"ListingKey" => "30013126"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
1 => array:11 [
"RoomKey" => "1679360188"
"RoomType" => "Living room"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.17
"ListingKey" => "30013126"
"RoomLength" => 6.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
2 => array:11 [
"RoomKey" => "1679360189"
"RoomType" => "Den"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.08
"ListingKey" => "30013126"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
3 => array:11 [
"RoomKey" => "1679360190"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "30013126"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
4 => array:11 [
"RoomKey" => "1679360191"
"RoomType" => "Bedroom"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30013126"
"RoomLength" => 4.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
5 => array:11 [
"RoomKey" => "1679360192"
"RoomType" => "Laundry room"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30013126"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013126/110-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T19:10:55.81Z"
+"ListAgentNationalAssociationId": "1277414"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30013126_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/e7cc9e7e1bf4ca242f9a8b78c4e45517.webp"
"MediaSize" => 125528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-e7cc9e7e1bf4ca242f9a8b78c4e45517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30013126_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/e4b3bbb7ed5232cbc72be589e22c0c38.webp"
"MediaSize" => 50733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-e4b3bbb7ed5232cbc72be589e22c0c38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30013126_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/2bf92fe41ba94afc968123006e021a5b.webp"
"MediaSize" => 51801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-2bf92fe41ba94afc968123006e021a5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30013126_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/56b1f10db0f33dd4220619de94f53838.webp"
"MediaSize" => 58013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-56b1f10db0f33dd4220619de94f53838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30013126_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/4c0751c44befda9349692caab3b6255c.webp"
"MediaSize" => 117817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-4c0751c44befda9349692caab3b6255c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
…2
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013126')"
+"ID": "1609624"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1609422"
+post_author: 1
+"ListingKey": "30012116"
+"ListingId": "40846676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T17:35:25Z"
+"RFModificationTimestamp": "2026-07-09T19:24:44Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1074.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 110, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.8802837
1 => 43.3432106
]
+"Latitude": 43.3432106
+"Longitude": -79.8802837
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker—an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "724.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-09T19:24:36.554161+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL TO RIVERWALK DRIVE. THE ENTRANCE TO 450 DUNDAS IS OFF RIVERWALK WHICH IS SOUTH OF DUNDAS ST E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596388"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T17:29:15Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T17:29:15Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4682.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012116/450-dundas-street-e-unit-110-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1074
+"OriginalEntryTimestamp": "2026-07-09T17:29:15.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1096193"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012116')"
+"ID": "1609422"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1608450"
+post_author: 1
+"ListingKey": "30011163"
+"ListingId": "40846705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:55:19Z"
+"RFModificationTimestamp": "2026-07-09T16:53:51Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 714.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 201, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940353
1 => 43.3303591
]
+"Latitude": 43.3303591
+"Longitude": -79.8940353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 201 at The View, a stylish south-facing 1-bedroom plus den overlooking a canopy of mature trees that gives the whole suite a calm, retreat-like feel. The versatile den is ideal for a home office, the dining area fits a proper table, and the generous living room features a wall-mounted electric fireplace and walkout to a private balcony. White quartz counters, stainless steel appliances, and an oversized peninsula anchor the kitchen, while the bedroom fits a full furniture set and the spa-inspired bathroom offers a tiled walk-in shower, floating vanity, linen storage, and laundry closet.Beyond the suite, this impeccably maintained 6-year-old building delivers: concierge and security staff, a gym, party room with prep kitchen, lounge, sixth-floor terraces with sweeping views, a pet spa, EV parking, and ample visitor parking.And then there's the location. Set on a quiet, tree-lined side street in sought-after Waterdown, you're a short walk to downtown shops, restaurants, and the Niagara Escarpment trails and lookouts, with quick access to highways, GO transit, and shopping centres. Peaceful, connected, and move-in ready. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "664.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T16:53:36.393879+00:00"
+"Directions": "South on Hamilton Street S from Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094790"
+"ListOfficeKey": "289709"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T15:48:20Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:48:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3851.69"
+"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/30011163/30-hamilton-street-s-unit-201-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 714
+"OriginalEntryTimestamp": "2026-07-09T15:48:20.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1367005"
+"ListOfficeNationalAssociationId": "1380244"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011163')"
+"ID": "1608450"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1608069"
+post_author: 1
+"ListingKey": "30010590"
+"ListingId": "X13542482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:50:10Z"
+"RFModificationTimestamp": "2026-07-09T15:08:04Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J4"
+"UnparsedAddress": "156 CHUDLEIGH STREET, Hamilton (Waterdown), Ontario L8B0J4"
+"Coordinates": array:2 [
0 => -79.902987
1 => 43.332965
]
+"Latitude": 43.332965
+"Longitude": -79.902987
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious 3-bedroom semi-detached home, ideally nestled in a family-friendly neighbourhood. This move-in-ready home features a functional layout with ample space and abundant natural light throughout. Windows create a warm and inviting atmosphere, while the spacious living areas and functionality of a split-level home provide room for everyday living and entertaining. This home features new engineered flooring, freshly painted walls, and space for a home office, gym, or kids playroom. A fully fenced backyard offers an outdoor escape with a very well-maintained patio area. Conveniently situated within walking distance to grocery stores, the YMCA, elementary and high school, parks, and transit. An excellent opportunity for families and first-time buyers alike, offering exceptional value in a desirable location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:07:57.964449+00:00"
+"Directions": "Cross Streets: Hamilton St & Parkside Dr. ** Directions: Hamilton St. to White Oak Dr to Chudleigh St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908399"
+"ListOfficeKey": "50914"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.1 x 108.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:41:25Z"
+"StreetName": "Chudleigh"
+"StreetNumber": "156"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5104.61"
+"VirtualTourURLUnbranded": "https://tours.boldimaging.com/Wrg_ODsOB?branded=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010590/156-chudleigh-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.1
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1221272"
+"ListOfficeNationalAssociationId": "1002617"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010590')"
+"ID": "1608069"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1608080"
+post_author: 1
+"ListingKey": "30010583"
+"ListingId": "X13542342"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:50:09Z"
+"RFModificationTimestamp": "2026-07-09T15:07:30Z"
+"ListPrice": 710000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "2 - 279 SKINNER ROAD N, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.877083
1 => 43.340355
]
+"Latitude": 43.340355
+"Longitude": -79.877083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover stylish, low-maintenance living in this beautifully maintained, sun-filled condo townhome nestled in the highly desirable East Waterdown community. Boasting soaring 9-foot ceilings and a unique open-concept design, this home offers an inviting blend of space, natural light, and everyday functionality. The spacious eat-in kitchen is designed for both entertaining and daily living, featuring stainless steel appliances, abundant cabinetry, generous prep space, and a walk-out to a private balcony-perfect for morning coffee, evening sunsets, or summer BBQs. Upstairs, you'll find two generously sized bedrooms, each with its own private ensuite, including a spacious primary retreat with a 4-piece bath and a second bedroom with a 3-piece ensuite-an ideal layout for families, guests, or professionals seeking added privacy. Enjoy the convenience of an attached garage with inside entry, plus parking for up to three vehicles-a rare and valuable feature. Low condo fees make ownership even more affordable while allowing you to enjoy a carefree, low-maintenance lifestyle. Located in one of Waterdown's most sought-after neighbourhoods, you're just minutes from top-rated schools, scenic parks and trails, shopping, restaurants, the GO Station, major highways, downtown Waterdown, and Burlington, offering the perfect balance of small-town charm and effortless connectivity. Whether you're a first-time buyer, downsizer, busy professional, or savvy investor, this move-in-ready home delivers exceptional value, comfort, and lifestyle in an outstanding location. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"AssociationFee": "194.39"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-09T15:07:27.431020+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Skinner. ** Directions: South of Dundas at Mallard & Skinner Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1660663"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:41:25Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "Skinner"
+"StreetNumber": "279"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4497.87"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/279-skinner-road-hamilton-l8b-1w5/nb/"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010583/2-279-skinner-road-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WENTWORTH STANDARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.22Z"
+"ListAgentNationalAssociationId": "1167703"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010583')"
+"ID": "1608080"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1605124"
+post_author: 1
+"ListingKey": "30007554"
+"ListingId": "40846496"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:55:19Z"
+"RFModificationTimestamp": "2026-07-09T20:00:31Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1663.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H6"
+"UnparsedAddress": "46 HARNESWORTH Crescent, Waterdown, Ontario L0R2H6"
+"Coordinates": array:2 [
0 => -79.9054918
1 => 43.3344338
]
+"Latitude": 43.3344338
+"Longitude": -79.9054918
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**4 bedrooms, 3 washrooms, finished basement and a renovated kitchen! Welcome to 46 Harnesworth Crescent, located in one of Waterdown's most desirable neighbourhoods. This lovely semi-detached home features a beautifully upgraded custom kitchen, a renovated primary ensuite, an outdoor gas line for BBQs, and an exposed aggregate driveway and backyard patio pad. Boasting a fantastic layout, this home offers four generously sized bedrooms and a professionally finished basement, providing the perfect extra space for family living, entertaining, or a home office setup. Ideally situated within walking distance to grocery stores, plazas, and parks, and just minutes from the YMCA and schools, this home is perfectly located for growing families and active lifestyles. Set in a wonderful, family-friendly neighbourhood, this is an exceptional opportunity to enjoy comfort, convenience, and community all in one place. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T20:54:52.232292+00:00"
+"Directions": "Hamilton to Rockhaven to Harnesworth"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946034"
+"ListOfficeKey": "78242"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T19:48:10Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:48:10Z"
+"Stories": "2.0"
+"StreetName": "HARNESWORTH"
+"StreetNumber": "46"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4971.97"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_harnesworth_crescent_hamilton_on/"
+"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/30007554/46-harnesworth-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1663
+"OriginalEntryTimestamp": "2026-07-08T20:29:11.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303132"
+"ListOfficeNationalAssociationId": "1137129"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30007554')"
+"ID": "1605124"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1599892"
+post_author: 1
+"ListingKey": "29998683"
+"ListingId": "X13531344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:50:06Z"
+"RFModificationTimestamp": "2026-07-07T18:01:22Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Welcome to this beautifully updated bungalow offering approximately 2,360 sq. ft. of finished living space in one of Waterdown's most sought-after neighbourhoods. Thoughtfully renovated with exceptional attention to detail, this spacious 3+2 bedroom, 3 bathroom home combines modern style, comfort, and functionality for today's family. The heart of the home is the stunning open-concept kitchen, featuring a massive centre island, stainless steel appliances, a 5-burner gas range, pot lights, and seamless flow into the main living and dining areas! Offers opportunity for perfect entertaining and everyday living. Generously sized rooms throughout provide plenty of space for the whole family, while updated railings, renovated closet spaces, and numerous interior improvements add both style and practicality. The fully finished lower level offers incredible versatility, complete with two additional bedrooms and a relaxing infrared 4-person sauna, creating the perfect retreat after a long day. Step outside to enjoy the extra-large private backyard, featuring TWO beautiful gazebos, newer fencing, and ample space for outdoor gatherings, play, and relaxation. Extended outdoor patio with a fire pit brings everything together. Additional updates include a recently replaced roof and updated appliances, providing peace of mind for years to come. With parking for four vehicles on the driveway and one in the attached garage and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this is an exceptional opportunity to own a move-in-ready family home in the heart of Waterdown. VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:26:16.161594+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:42:20Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998683/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-07-07T14:42:20.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998683')"
+"ID": "1599892"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1600801"
+post_author: 1
+"ListingKey": "29999554"
+"ListingId": "X13532526"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:40:15Z"
+"RFModificationTimestamp": "2026-07-07T17:06:35Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "1A WESTVIEW CRESCENT, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.906152
1 => 43.340513
]
+"Latitude": 43.340513
+"Longitude": -79.906152
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rare Opportunity to Build Your Dream Home in One of East Waterdown's Most Established Neighbourhoods! This newly created 80' x 103' premium building lot is recently severed from an original estate property, offering the perfect canvas for a custom home tailored to your lifestyle. Nestled on a quiet, tree-lined street just steps to parks, top-rated schools, shopping, restaurants, trails and everyday conveniences, you'll enjoy the charm and character of a mature neighbourhood with the freedom to build new. The generous 80-foot frontage offers exceptional flexibility for a stunning custom residence with spacious outdoor living or expansive landscaping. Bring your own builder and create the home you've always envisioned in one of Waterdown's most sought-after, family-friendly communities with convenient access to Burlington, minutes to Aldershot GO Transit and major highways. Rarely do opportunities like this become available (id:59439)"
+"CreationDate": "2026-07-07T17:06:31.747912+00:00"
+"Directions": "Cross Streets: Centre Road. ** Directions: Centre Road to Northlawn Avenue to Westview Crescent."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145705"
+"ListOfficeKey": "289659"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Partially cleared"
2 => "Conservation/green belt"
]
+"LotSizeDimensions": "80 x 103 FT"
+"PhotosChangeTimestamp": "2026-07-07T16:30:40Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:30:40Z"
+"StreetName": "Westview"
+"StreetNumber": "1A"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7500"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/sites/1-westview-crescent-hamilton-on-l8b-0e4-26396027/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29999554/1a-westview-crescent-hamilton-waterdown-waterdown"
+"GeocodeManualYN": false
+"ZoningDescription": "R1-14"
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-07-07T16:30:40.34Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1397049"
+"ListOfficeNationalAssociationId": "1379904"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999554')"
+"ID": "1600801"
}
]
+success: true
+page_size: 9
+page_count: 26
+count: 228
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]