array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30013126 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: "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"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30013126_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/44180e5935ab2e310b33b3b75f7e143c.webp"
"MediaSize" => 62657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-44180e5935ab2e310b33b3b75f7e143c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30013126_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/14a695f69ab0fddeb1511ace19446b6d.webp"
"MediaSize" => 54859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-14a695f69ab0fddeb1511ace19446b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30013126_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/659326690b8721d92480707619314528.webp"
"MediaSize" => 53768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-659326690b8721d92480707619314528.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30013126_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/567be31c02bec3853f68b70ead8ccb1b.webp"
"MediaSize" => 50854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-567be31c02bec3853f68b70ead8ccb1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30013126_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/70d23333039285c72e91352e4fcab089.webp"
"MediaSize" => 122619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-70d23333039285c72e91352e4fcab089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30013126_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/47b5d291da4840a693bb53eab24e65c8.webp"
"MediaSize" => 62423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-47b5d291da4840a693bb53eab24e65c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30013126_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/24a4943efe289cb29548d7ea4b762aff.webp"
"MediaSize" => 52716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-24a4943efe289cb29548d7ea4b762aff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30013126_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/0c8c92bd9faca317973731320938ac1d.webp"
"MediaSize" => 62097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-0c8c92bd9faca317973731320938ac1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30013126_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/1663f3ea7ab71bf30d5b48ac6ca5f134.webp"
"MediaSize" => 105768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-1663f3ea7ab71bf30d5b48ac6ca5f134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30013126_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/973f515c19fd3d2480f3e49644e071a5.webp"
"MediaSize" => 131668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-973f515c19fd3d2480f3e49644e071a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30013126_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/38d721f24560f5e9e95a67020e3ed0b3.webp"
"MediaSize" => 132144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-38d721f24560f5e9e95a67020e3ed0b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30013126_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/974668aee78a05d99ffe08877aa4336e.webp"
"MediaSize" => 146648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-974668aee78a05d99ffe08877aa4336e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30013126_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/2afb427d4dd7c8f803933646bd46a4ed.webp"
"MediaSize" => 103224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-2afb427d4dd7c8f803933646bd46a4ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30013126_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/9843dafe3842e19f6dc566503d66ce27.webp"
"MediaSize" => 123753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-9843dafe3842e19f6dc566503d66ce27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30013126_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/f0db3e8e3e88b9be2c1ff913a3ce1863.webp"
"MediaSize" => 129803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-f0db3e8e3e88b9be2c1ff913a3ce1863.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30013126_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/a35129a65a8488d14c0df3f881de737f.webp"
"MediaSize" => 190366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-a35129a65a8488d14c0df3f881de737f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013126')"
+"ID": "1609624"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 266588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24925
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "184000"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "266588"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 ITABASHI WAY #4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1274323"
+"OriginalEntryTimestamp": "2011-09-09T03:45:00Z"
+"OfficeFax": "905-681-9908"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "324280"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "266588"
"SocialMediaUrlOrId" => "http://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-16T17:35:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1499122"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('266588')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1994256" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24833
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30013126'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25221
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30013126' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25237
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30013126' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.880553 43.342598)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25290
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+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 [
"RoomKey" => "1679267579"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.87Z"
]
1 => array:11 [
"RoomKey" => "1679267580"
"RoomType" => "3pc Bathroom"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
2 => array:11 [
"RoomKey" => "1679267581"
"RoomType" => "Laundry room"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
3 => array:11 [
"RoomKey" => "1679267582"
"RoomType" => "Bedroom"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
4 => array:11 [
"RoomKey" => "1679267583"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
5 => array:11 [
"RoomKey" => "1679267584"
"RoomType" => "Den"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => "6'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
6 => array:11 [
"RoomKey" => "1679267585"
"RoomType" => "Living room"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 21'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
7 => array:11 [
"RoomKey" => "1679267586"
"RoomType" => "Eat in kitchen"
"ListingId" => "40846676"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012116"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:29:15.88Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30012116_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/a5b5d108d2f44990143490214eedc4f9.webp"
"MediaSize" => 124269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-a5b5d108d2f44990143490214eedc4f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30012116_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/7ace7210bc51330a6dfb0e02695573e9.webp"
"MediaSize" => 46348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-7ace7210bc51330a6dfb0e02695573e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30012116_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/af095d16726dfb0ba2c3d2e056bc75dc.webp"
"MediaSize" => 46871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-af095d16726dfb0ba2c3d2e056bc75dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30012116_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/e6d5d7b7a6442362a4ad9df536d66c29.webp"
"MediaSize" => 53831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-e6d5d7b7a6442362a4ad9df536d66c29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30012116_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/a548980048d6ecffb6e7d3af85895890.webp"
"MediaSize" => 114734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-a548980048d6ecffb6e7d3af85895890.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30012116_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/578086cafe1d110a6383ec97980bf428.webp"
"MediaSize" => 58697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-578086cafe1d110a6383ec97980bf428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30012116_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/db16da4c5947948138286470daf0e762.webp"
"MediaSize" => 50955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-db16da4c5947948138286470daf0e762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30012116_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/7935052e21f60690be789171ebf2e6bd.webp"
"MediaSize" => 49208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-7935052e21f60690be789171ebf2e6bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30012116_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/40f6b7db1738e797aa01bf0b5dba3daf.webp"
"MediaSize" => 46829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-40f6b7db1738e797aa01bf0b5dba3daf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30012116_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/e358d269301648f997acbd9eca8f1ca6.webp"
"MediaSize" => 120391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-e358d269301648f997acbd9eca8f1ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30012116_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/daa88ad110b8a59f9c42d87747a46308.webp"
"MediaSize" => 59365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-daa88ad110b8a59f9c42d87747a46308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30012116_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/0b9df9b182729ad3fb2da545eab798d4.webp"
"MediaSize" => 48686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-0b9df9b182729ad3fb2da545eab798d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30012116_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/9423dc42f4d14b727f31be215405f336.webp"
"MediaSize" => 58536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-9423dc42f4d14b727f31be215405f336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30012116_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/15afe8f5864343ad3b821d2e18ecf300.webp"
"MediaSize" => 103898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-15afe8f5864343ad3b821d2e18ecf300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30012116_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/bfbf97117e64dc83bbcec34fc41928e4.webp"
"MediaSize" => 128580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-bfbf97117e64dc83bbcec34fc41928e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30012116_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/b5c64e4d81d86381d0cd4b01ac9ceea9.webp"
"MediaSize" => 129140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-b5c64e4d81d86381d0cd4b01ac9ceea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30012116_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/ca60ccbfa2680b6abd133e70f3c400af.webp"
"MediaSize" => 144225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-ca60ccbfa2680b6abd133e70f3c400af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30012116_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/cae09e173417daf9c74af0f619be32f8.webp"
"MediaSize" => 100947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-cae09e173417daf9c74af0f619be32f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30012116_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/5efd1b90d9cda3ac712ba2094b531c53.webp"
"MediaSize" => 122056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-5efd1b90d9cda3ac712ba2094b531c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30012116_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/2ed8b2882c8364936e24c1b0896ee43c.webp"
"MediaSize" => 127370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-2ed8b2882c8364936e24c1b0896ee43c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30012116_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012116/5261355b0e5c0d00c83563ef299533fc.webp"
"MediaSize" => 189053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012116/thumbnail-5261355b0e5c0d00c83563ef299533fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846676"
"ResourceRecordKey" => "30012116"
"ModificationTimestamp" => "2026-07-09T17:29:15.86Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012116')"
+"ID": "1609422"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+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 [
"RoomKey" => "1679168899"
"RoomType" => "3pc Bathroom"
"ListingId" => "40846705"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30011163"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T15:48:20.71Z"
]
1 => array:11 [
"RoomKey" => "1679168900"
"RoomType" => "Dining room"
"ListingId" => "40846705"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30011163"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T15:48:20.71Z"
]
2 => array:11 [
"RoomKey" => "1679168901"
"RoomType" => "Living room"
"ListingId" => "40846705"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30011163"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T15:48:20.71Z"
]
3 => array:11 [
"RoomKey" => "1679168902"
"RoomType" => "Kitchen"
"ListingId" => "40846705"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30011163"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T15:48:20.71Z"
]
4 => array:11 [
"RoomKey" => "1679168903"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846705"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30011163"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T15:48:20.71Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30011163_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/257c305520dda209e2f662029224a69c.webp"
"MediaSize" => 118547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-257c305520dda209e2f662029224a69c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-story building featuring a facade of light-toned brick and stone accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30011163_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/3d189c284099ecf0657e9c66bed9f927.webp"
"MediaSize" => 122606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-3d189c284099ecf0657e9c66bed9f927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30011163_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/6178859de84d811188ea02d55b063133.webp"
"MediaSize" => 79057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-6178859de84d811188ea02d55b063133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30011163_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/6be0a84d464bd125732e2839a3df957f.webp"
"MediaSize" => 83650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-6be0a84d464bd125732e2839a3df957f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30011163_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/dd1a5cbd76f44e717930751cbadf994f.webp"
"MediaSize" => 48074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-dd1a5cbd76f44e717930751cbadf994f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30011163_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/f60b8193b0f90b8ed84de75142926fe4.webp"
"MediaSize" => 58404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-f60b8193b0f90b8ed84de75142926fe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious shower area featuring white subway tile walls, a built-in shower base, and a chrome shower fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30011163_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/9ba2f60deaf3f2a6e04b65181be72691.webp"
"MediaSize" => 87583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-9ba2f60deaf3f2a6e04b65181be72691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30011163_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/5944bed55be0ed91eeffde2915161ea0.webp"
"MediaSize" => 84074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-5944bed55be0ed91eeffde2915161ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby featuring a cityscape wall mural, recessed lighting, grid ceiling tiles, and large glass entry doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30011163_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/2970ad0c109b55421de592dc878d8f23.webp"
"MediaSize" => 83303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-2970ad0c109b55421de592dc878d8f23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lobby featuring large format dark-toned tile flooring, recessed lighting, and a reception desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30011163_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/b5eb0f87afdf846d81e3927526e71cb8.webp"
"MediaSize" => 69068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-b5eb0f87afdf846d81e3927526e71cb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious common area featuring a coffered ceiling with recessed lighting, large window wall, and dark-toned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30011163_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/54d5d474ff953e511e0aaba30d1eac2b.webp"
"MediaSize" => 79079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-54d5d474ff953e511e0aaba30d1eac2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30011163_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/767827cb32cf9897837f1155e5dbb138.webp"
"MediaSize" => 90144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-767827cb32cf9897837f1155e5dbb138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring floor-to-ceiling windows, a contemporary chandelier, recessed lighting, concrete structural pillars, and large format tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30011163_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/906705167683c6dd71b82059bf5d61e3.webp"
"MediaSize" => 84523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-906705167683c6dd71b82059bf5d61e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring floor-to-ceiling windows, recessed lighting, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30011163_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/1afbccd3810851060df515546b6722e3.webp"
"MediaSize" => 58855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-1afbccd3810851060df515546b6722e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette featuring light-toned upper cabinetry, dark-toned lower cabinetry, and light countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30011163_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/ea635a8eea32ab2ffab83ae56cad512a.webp"
"MediaSize" => 52141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-ea635a8eea32ab2ffab83ae56cad512a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette featuring a stainless steel refrigerator, white upper cabinetry, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30011163_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/7f5501cd856e7cddfd79ce51c54b5a63.webp"
"MediaSize" => 60536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-7f5501cd856e7cddfd79ce51c54b5a63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette featuring white shaker cabinetry, stainless steel dishwasher, and light-toned countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30011163_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/453a6e6bc6ace52deb2bdb5a81c7996a.webp"
"MediaSize" => 82247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-453a6e6bc6ace52deb2bdb5a81c7996a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rooftop patio featuring large format pavers, a frosted glass privacy wall, and panoramic outdoor scenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30011163_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/26caf43698415258bbb05377fbec680d.webp"
"MediaSize" => 74195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-26caf43698415258bbb05377fbec680d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rooftop patio featuring large format pavers, a partial privacy screen, and an exterior wall clad in horizontal wood-look siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
"ResourceRecordKey" => "30011163"
"ModificationTimestamp" => "2026-07-09T15:48:20.65Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30011163_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30011163/cac432f483cf8e2f43c70e3bb864b906.webp"
"MediaSize" => 91526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30011163/thumbnail-cac432f483cf8e2f43c70e3bb864b906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rooftop terrace featuring a glass and metal railing, concrete tile flooring, and a panoramic tree-lined horizon"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846705"
…2
]
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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"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 [ …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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999791')"
+"ID": "1599648"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1599737"
+post_author: 1
+"ListingKey": "29999223"
+"ListingId": "40844409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T00:05:21Z"
+"RFModificationTimestamp": "2026-07-08T00:10:32Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.22
+"LivingArea": 1259.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "57 MAIN Street N, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8939354
1 => 43.3339742
]
+"Latitude": 43.3339742
+"Longitude": -79.8939354
+"YearBuilt": 1875
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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, overlooking 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:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T16:50:34.839893+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2170504"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.22"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-07T15:48:25Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T23:59:11Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "MAIN"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5843.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29999223/57-main-street-n-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1259
+"OriginalEntryTimestamp": "2026-07-07T15:48:25.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1421059"
+"ListOfficeNationalAssociationId": "1344653"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999223')"
+"ID": "1599737"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1596640"
+post_author: 1
+"ListingKey": "29994928"
+"ListingId": "X13528040"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T00:15:06Z"
+"RFModificationTimestamp": "2026-07-09T00:18:21Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "112 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to care-free condo living in the heart of Waterdown! This unit features an open-concept layout with a versatile den, ideal for a home office or guest space plus modern finishes and plenty of natural light. Enjoy great amenities including a fully equipped gym, stylish party room, and a stunning rooftop terrace with BBQs, perfect for relaxing or entertaining. Located in one of Waterdown's most desirable communities, you're just minutes to Aldershot GO Station, Burlington, major highways, shopping, restaurants, parks, and scenic trails, making commuting a breeze while still enjoying the charm and warmth of a welcoming small-town community. Experience the best of low-maintenance living in a location you'll love. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "440.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:55:44.048019+00:00"
+"Directions": "Cross Streets: Riverwalk Drive. ** Directions: Dundas St E to Mallard Trail."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-06T18:40:58Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T00:08:27Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2944.87"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1sZ_GBh3xQXszk3WGaydnKYoRuewBW1Rg/view"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29994928/112-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Separate Heating Controls"
3 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-06T18:40:58.71Z"
+"ListAgentNationalAssociationId": "1366297"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994928')"
+"ID": "1596640"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1596641"
+post_author: 1
+"ListingKey": "29993854"
+"ListingId": "X13527238"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T16:50:07Z"
+"RFModificationTimestamp": "2026-07-06T19:29:16Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y5"
+"UnparsedAddress": "286 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B0Y5"
+"Coordinates": array:2 [
0 => -79.885433
1 => 43.350048
]
+"Latitude": 43.350048
+"Longitude": -79.885433
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2,300 sq. ft. family home in the heart of Waterdown! Offering 3 spacious bedrooms, 3 bathrooms, and a versatile second-floor loft that can easily serve as a 4th bedroom, home office, or second living space, this home is designed to grow with your family. Step inside to a bright, open-concept layout featuring rich hardwood flooring, a cozy gas fireplace, and an abundance of natural light. The chef-inspired kitchen boasts stainless steel appliances, a large centre island, and plenty of workspace, flowing seamlessly into the dining area with walkout access to the spacious backyard-perfect for entertaining family and friends. Upstairs, the primary retreat offers a generous walk-in closet and a spa-like ensuite. Two additional bedrooms, a beautifully appointed 4-piece bathroom, convenient second-floor laundry, and the bonus loft complete the upper level. The unspoiled basement provides endless possibilities to create the space you've always envisioned. Complete with a double-car garage and ideally located to parks, schools, shopping, downtown Waterdown, and everyday amenities, this exceptional home offers the perfect combination of style, comfort, and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:29:10.466553+00:00"
+"Directions": "Parkside Drive and Spring Creek Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2257460"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.1 x 88.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:41:35Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T16:41:35Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "286"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6300"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29993854/286-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-07-06T16:41:35.09Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1496299"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993854')"
+"ID": "1596641"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1596207"
+post_author: 1
+"ListingKey": "29994347"
+"ListingId": "40845456"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T23:35:17Z"
+"RFModificationTimestamp": "2026-07-08T23:38:45Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 654.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 112, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8796353
1 => 43.3436937
]
+"Latitude": 43.3436937
+"Longitude": -79.8796353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to care-free condo living in the heart of Waterdown! This unit features an open-concept layout with a versatile den, ideal for a home office or guest space plus modern finishes and plenty of natural light. Enjoy great amenities including a fully equipped gym, stylish party room, and a stunning rooftop terrace with BBQs, perfect for relaxing or entertaining. Located in one of Waterdown’s most desirable communities, you’re just minutes to Aldershot GO Station, Burlington, major highways, shopping, restaurants, parks, and scenic trails, making commuting a breeze while still enjoying the charm and warmth of a welcoming small-town community. Experience the best of low-maintenance living in a location you’ll love. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "440.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T18:54:05.186054+00:00"
+"Directions": "DUNDAS ST E TO MALLARD TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047928"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-06T17:48:21Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T23:29:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2944.97"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1sZ_GBh3xQXszk3WGaydnKYoRuewBW1Rg/view"
+"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/29994347/460-dundas-street-e-unit-112-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 654
+"OriginalEntryTimestamp": "2026-07-06T17:48:21.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1323283"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994347')"
+"ID": "1596207"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 167
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]