array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29603577 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1317296"
+post_author: 1
+"ListingKey": "29603577"
+"ListingId": "X12997616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T12:25:35Z"
+"RFModificationTimestamp": "2026-05-31T18:49:35Z"
+"ListPrice": 929000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "274 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8752403
1 => 43.3416134
]
+"Latitude": 43.3416134
+"Longitude": -79.8752403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An opportunity in Waterdown you do not want to miss! One of the largest semi-detached homes currently available on the market spanning over 2,288sqft of living space. This four bedroom home in uniquely situated at one of the most convenient points of the community. With clear views to the east, the home allows for plenty of natural sunlight throughout the day. Open concept living, and dining that spills into a balcony in the backyard that makes this the main floor the perfect space for spending time with family and entertaining guests. The walkout basement is a blank slate to customize to your liking, and with the added light from the larger windows it truly feels like an extension of the home. With four generously sized bedroom upstairs, the second floors higher ceilings and uncompromising spaces gives the flow of the second floor an airy feel. Located in a sought-after and growing area of Waterdown, just minutes walk to St. Thomas the Apostle Catholic Elementary School, Skinner park, trails, and convenience stores. Best of all you're a short drive to highways 403, 407, and Aldershot GO station, and minutes drive from hardware stores, grocery, and plenty amenities nearby! (id:62650)"
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-15T02:29:04.425309+00:00"
+"Directions": "Cross Streets: Skinner Rd & Mallard Trl. ** Directions: Please see Google Maps."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072068"
+"ListOfficeKey": "290380"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "27.9 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-14T19:51:10Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-31T12:19:33Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "274"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6682.61"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=pk6W82M1Q5b"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1647611632"
"RoomType" => "Foyer"
"ListingId" => "X12997616"
"RoomLevel" => "Main level"
"RoomWidth" => 2.46
"ListingKey" => "29603577"
"RoomLength" => 2.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.32Z"
]
1 => array:11 [
"RoomKey" => "1647611633"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12997616"
"RoomLevel" => "Lower level"
"RoomWidth" => 5.0
"ListingKey" => "29603577"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.32Z"
]
2 => array:11 [
"RoomKey" => "1647611634"
"RoomType" => "Office"
"ListingId" => "X12997616"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29603577"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
3 => array:11 [
"RoomKey" => "1647611635"
"RoomType" => "Living room"
"ListingId" => "X12997616"
"RoomLevel" => "Main level"
"RoomWidth" => 6.86
"ListingKey" => "29603577"
"RoomLength" => 10.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
4 => array:11 [
"RoomKey" => "1647611636"
"RoomType" => "Kitchen"
"ListingId" => "X12997616"
"RoomLevel" => "Main level"
"RoomWidth" => 6.86
"ListingKey" => "29603577"
"RoomLength" => 10.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
5 => array:11 [
"RoomKey" => "1647611637"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.72
"ListingKey" => "29603577"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
6 => array:11 [
"RoomKey" => "1647611638"
"RoomType" => "Other"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.02
"ListingKey" => "29603577"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
7 => array:11 [
"RoomKey" => "1647611639"
"RoomType" => "Bedroom 2"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.02
"ListingKey" => "29603577"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
8 => array:11 [
"RoomKey" => "1647611640"
"RoomType" => "Bedroom 3"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.03
"ListingKey" => "29603577"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
9 => array:11 [
"RoomKey" => "1647611641"
"RoomType" => "Bedroom 4"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.58
"ListingKey" => "29603577"
"RoomLength" => 3.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
10 => array:11 [
"RoomKey" => "1647611642"
"RoomType" => "Laundry room"
"ListingId" => "X12997616"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.42
"ListingKey" => "29603577"
"RoomLength" => 1.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-31T12:19:33.33Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29603577/274-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 27.1
+"OriginalEntryTimestamp": "2026-04-14T19:51:10.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347263"
+"ListOfficeNationalAssociationId": "1386425"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6597176754"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/97af1ef361907cc1f989126d96e9613b.webp"
"MediaSize" => 147854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-97af1ef361907cc1f989126d96e9613b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6597175489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/29885745e3801e1b031fdd22471f2591.webp"
"MediaSize" => 116870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-29885745e3801e1b031fdd22471f2591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6597176044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/9a078526866a67fb36bf854f12eb9929.webp"
"MediaSize" => 129442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-9a078526866a67fb36bf854f12eb9929.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6597177103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/d9cc8cb6df9df5f1b8c3afb9d4045df8.webp"
"MediaSize" => 116971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-d9cc8cb6df9df5f1b8c3afb9d4045df8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6597176319"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/6f1542e0e48f63c755ec79f09eda15bc.webp"
"MediaSize" => 128154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-6f1542e0e48f63c755ec79f09eda15bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6597176187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/0aa60db6024e643ae7908e28ed34587c.webp"
"MediaSize" => 124101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-0aa60db6024e643ae7908e28ed34587c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6597176989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/f5e7fecd5be003a30e4e51e5e2804b72.webp"
"MediaSize" => 118943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-f5e7fecd5be003a30e4e51e5e2804b72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6597175805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/b305688e0d8d52906a5b51b0e1af9c0c.webp"
"MediaSize" => 118799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-b305688e0d8d52906a5b51b0e1af9c0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6597175882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/a14bbb3bd6bb940dac3dd76404340824.webp"
"MediaSize" => 115767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-a14bbb3bd6bb940dac3dd76404340824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6597177064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/1bd65e22cab4c5e3639d80ea45277d67.webp"
"MediaSize" => 117280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-1bd65e22cab4c5e3639d80ea45277d67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6597175556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/ef6ee454acef01d84000c2e6fb132dbd.webp"
"MediaSize" => 104297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-ef6ee454acef01d84000c2e6fb132dbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6597176601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/b6b3fbb6352967158084ba13078114c3.webp"
"MediaSize" => 114446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-b6b3fbb6352967158084ba13078114c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6597177198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/dc4e678a84cbe602d7ab263dc73950b0.webp"
"MediaSize" => 108757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-dc4e678a84cbe602d7ab263dc73950b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6597175361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/02e25f248b00ed3cf8d2b0fcd7957597.webp"
"MediaSize" => 55850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-02e25f248b00ed3cf8d2b0fcd7957597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6597176724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/c55e026d1b2fe208347cf2da74f08428.webp"
"MediaSize" => 107170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-c55e026d1b2fe208347cf2da74f08428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6597177189"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/53632773e5562a397c22fbc4e33bf028.webp"
"MediaSize" => 132057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-53632773e5562a397c22fbc4e33bf028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6597176292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/b4f66b670f742d2a2825763219ad7719.webp"
"MediaSize" => 113558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-b4f66b670f742d2a2825763219ad7719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6597176521"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/d86f8f14c28015e2631b7e1e5983f675.webp"
"MediaSize" => 89534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-d86f8f14c28015e2631b7e1e5983f675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6597177243"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/0c3027d5aac9eafec9088290a72ce73b.webp"
"MediaSize" => 91405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-0c3027d5aac9eafec9088290a72ce73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6597176072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/759b1132f8ff049052bf7772f1bbdb58.webp"
"MediaSize" => 101581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-759b1132f8ff049052bf7772f1bbdb58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6597176488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/d128fe98e10c260291449205f7bf827d.webp"
"MediaSize" => 92445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-d128fe98e10c260291449205f7bf827d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6597177131"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/ead4bb5f226548dcab7b0803b76b33a8.webp"
"MediaSize" => 79378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-ead4bb5f226548dcab7b0803b76b33a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6597175709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/13757b11bd5ca200fbad677620345e98.webp"
"MediaSize" => 89143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-13757b11bd5ca200fbad677620345e98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6597176415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/962c0f6087a1e6d9db7e5a093f0f1f01.webp"
"MediaSize" => 80889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-962c0f6087a1e6d9db7e5a093f0f1f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6597175315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/6c58ab4305b3fb5a6b01f029e5c9b0e0.webp"
"MediaSize" => 94404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-6c58ab4305b3fb5a6b01f029e5c9b0e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6597175909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/dc1b586894003cee9adbdd32996c843b.webp"
"MediaSize" => 100560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-dc1b586894003cee9adbdd32996c843b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6597176827"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/3c18cb3c99b24eb308f147bbb0c39b36.webp"
"MediaSize" => 93506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-3c18cb3c99b24eb308f147bbb0c39b36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6597175210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/81872d3c5f4f75be8c709354831a86c6.webp"
"MediaSize" => 66804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-81872d3c5f4f75be8c709354831a86c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6597176003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/8d964960ab55d2be24ad1e631886aa37.webp"
"MediaSize" => 191888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-8d964960ab55d2be24ad1e631886aa37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6597176910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/5e647e19cc717ef6466315efa5998193.webp"
"MediaSize" => 210442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-5e647e19cc717ef6466315efa5998193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6597175065"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/9f4cca16846838f3bdd756e54af68db2.webp"
"MediaSize" => 156868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-9f4cca16846838f3bdd756e54af68db2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6597176895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/07e463633dc42fbca2263df973275e9e.webp"
"MediaSize" => 222696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-07e463633dc42fbca2263df973275e9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6597176973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/c231628651d6f1c5d0d0406d496f7a03.webp"
"MediaSize" => 189687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-c231628651d6f1c5d0d0406d496f7a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6597175074"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/8de8a91c0bced1f98dfce871ab6d048e.webp"
"MediaSize" => 143618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-8de8a91c0bced1f98dfce871ab6d048e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6597176640"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29603577/dbdc1120511ee2b9c0bcfbf61ef57b80.webp"
"MediaSize" => 137980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29603577/thumbnail-dbdc1120511ee2b9c0bcfbf61ef57b80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12997616"
"ResourceRecordKey" => "29603577"
"ModificationTimestamp" => "2026-04-14T19:51:10.11Z"
]
]
+"DaysOnMarket": 62
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29603577')"
+"ID": "1317296"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290380" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24794
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2072068" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24767
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29603577'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25103
+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 '29603577'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25121
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25119
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31198879"
+"ListingKey": "29603577"
+"ListingId": "X12997616"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-30"
+"OpenHouseStartTime": "2026-05-30T13:00:00Z"
+"OpenHouseEndTime": "2026-05-30T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T04:11:45Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31198879')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29603577' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8752403 43.3416134)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25174
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: 1534315
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"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": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1660529758"
"RoomType" => "Great room"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29909863"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
1 => array:11 [
"RoomKey" => "1660529759"
"RoomType" => "Kitchen"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29909863"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
2 => array:11 [
"RoomKey" => "1660529760"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "29909863"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
3 => array:11 [
"RoomKey" => "1660529761"
"RoomType" => "Den"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29909863"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": 1534315
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+post_id: "1534027"
+post_author: 1
+"ListingKey": "29908612"
+"ListingId": "40840175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:11:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street Unit# 709, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8792813
1 => 43.3435237
]
+"Latitude": 43.3435237
+"Longitude": -79.8792813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to elevated condo living in the heart of East Waterdown! This beautifully upgraded 1-bedroom + oversized den condo offers modern style, functional space, and thoughtful design throughout. Currently used as an additional sleeping area, the spacious den offers exceptional flexibility and could easily function as a guest room, home office, nursery, fitness space, or multi-purpose retreat to suit your lifestyle. The open-concept layout is ideal for both everyday living and entertaining, highlighted by a stunning upgraded kitchen featuring a sleek granite waterfall peninsula, extended cabinetry for added storage, upgraded stainless steel appliances, and a contemporary single-basin sink. Premium upgraded flooring flows seamlessly throughout, complemented by smooth ceilings that create a clean, refined finish. Adding to the value and convenience, geothermal heating is included in the condo fees, offering efficient year-round comfort and reduced monthly utility costs. This well-appointed building also offers exceptional amenities including a stylish party room complete with a pool table, fireplace, comfortable seating area, and full kitchen, along with an exercise room, bicycle storage room, storage locker, underground parking space, and an outdoor terrace featuring seating areas and BBQs—perfect for entertaining and enjoying the community atmosphere. Ideally located in desirable East Waterdown, enjoy quick access to major highways while being close to parks, shopping, dining, and the natural beauty of the nearby Niagara Escarpment and surrounding trails—offering the perfect blend of urban convenience and outdoor living. Move in and enjoy stylish, low-maintenance living in one of Waterdown’s most sought-after communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "417.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:29.675759+00:00"
+"Directions": "Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021739"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:17Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:17Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3007.36"
+"VirtualTourURLUnbranded": "https://youtu.be/U-fSD3T-vSs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1660422859"
"RoomType" => "Laundry room"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
1 => array:11 [
"RoomKey" => "1660422860"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
2 => array:11 [
"RoomKey" => "1660422861"
"RoomType" => "Great room"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
3 => array:11 [
"RoomKey" => "1660422862"
"RoomType" => "Kitchen"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
4 => array:11 [
"RoomKey" => "1660422863"
"RoomType" => "Den"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
5 => array:11 [
"RoomKey" => "1660422864"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908612"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T12:50:17.35Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908612/460-e-dundas-street-unit-709-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-16T12:50:17.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1301652"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:13 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908612_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/04ecb95f45f81011225bf091a5f3951c.webp"
"MediaSize" => 167108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-04ecb95f45f81011225bf091a5f3951c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern residential building with a stone-clad address monument"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908612_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/b2f971daab078f9a288d53da177bf16a.webp"
"MediaSize" => 123065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-b2f971daab078f9a288d53da177bf16a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908612_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/27efa8a4b5b0a0594fbba5d64505379a.webp"
"MediaSize" => 112907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-27efa8a4b5b0a0594fbba5d64505379a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a full-height sliding glass door, and an overhead lighting fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908612_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/0a131f76ee085b698860580b1582db63.webp"
"MediaSize" => 91273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-0a131f76ee085b698860580b1582db63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a waterfall-edge countertop, stainless steel appliances, light-toned cabinetry, a tiled backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908612_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/28d2a1d9eb69488de365c0937b154769.webp"
"MediaSize" => 70144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-28d2a1d9eb69488de365c0937b154769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a white countertop with integrated breakfast bar, light-toned cabinetry, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908612_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/e24d1e128c33bf1de49da3b7f635d8e3.webp"
"MediaSize" => 104702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-e24d1e128c33bf1de49da3b7f635d8e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright sleeping area featuring wood-finish flooring and a large window with privacy blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908612_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/26723329ae1b202867907fe1832d28f5.webp"
"MediaSize" => 124200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-26723329ae1b202867907fe1832d28f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, white baseboards, and a built-in sliding door closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908612_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/a348e66f370b9907c70c1e0f8848e621.webp"
"MediaSize" => 116745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-a348e66f370b9907c70c1e0f8848e621.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact bedroom featuring light-colored walls and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908612_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/a8aebcfd23ff4e2d75e99483030e64c1.webp"
"MediaSize" => 88603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-a8aebcfd23ff4e2d75e99483030e64c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a light-toned countertop, an integrated sink, and an overhead vanity light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908612_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/fcba4dca359cfe3c769db8f24e2edb2b.webp"
"MediaSize" => 61509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-fcba4dca359cfe3c769db8f24e2edb2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a stackable washer and dryer, wood-finish flooring, and crisp white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908612_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/b13d150bd91d157a222bc7f0e2ca959f.webp"
"MediaSize" => 122833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-b13d150bd91d157a222bc7f0e2ca959f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private balcony with glass railing system"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908612_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/b3d12dd60d2010875dcaa5a88f4c36a5.webp"
"MediaSize" => 131045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-b3d12dd60d2010875dcaa5a88f4c36a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness center featuring wood-finish flooring, mirrored wall, recessed lighting, and expansive windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908612_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908612/c6b0fd59af96a75b0f168d22d528390b.webp"
"MediaSize" => 112960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908612/thumbnail-c6b0fd59af96a75b0f168d22d528390b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rooftop terrace featuring large format stone tile flooring, a built-in outdoor kitchen with a stainless steel grill, a contemporary lounge seating area, and multiple round tables with chairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840175"
"ResourceRecordKey" => "29908612"
"ModificationTimestamp" => "2026-06-16T12:50:17.24Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908612')"
+"ID": "1534027"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:15:03Z"
+"RFModificationTimestamp": "2026-06-16T00:38:53Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:09:52Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660191163"
"RoomType" => "Bedroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
1 => array:11 [
"RoomKey" => "1660191164"
"RoomType" => "Living room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
2 => array:11 [
"RoomKey" => "1660191165"
"RoomType" => "Kitchen"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
3 => array:11 [
"RoomKey" => "1660191166"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
4 => array:11 [
"RoomKey" => "1660191167"
"RoomType" => "Laundry room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 3'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
5 => array:11 [
"RoomKey" => "1660191168"
"RoomType" => "Den"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
6 => array:11 [
"RoomKey" => "1660191169"
"RoomType" => "Foyer"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-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": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907463_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"MediaSize" => 125183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907463_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/bc72356ac79f3b2264abc6d6824b3c9f.webp"
"MediaSize" => 83469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-bc72356ac79f3b2264abc6d6824b3c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907463_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/44e06bde779f22ba91ef5fe6bfd071a2.webp"
"MediaSize" => 70999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-44e06bde779f22ba91ef5fe6bfd071a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907463_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/16faeb112a8ecdf073013779b7fa044c.webp"
"MediaSize" => 33797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-16faeb112a8ecdf073013779b7fa044c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907463_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b64d666be7a70cacaf5764a78510c43e.webp"
"MediaSize" => 31970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b64d666be7a70cacaf5764a78510c43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907463_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b4875166552e3987d0b6ca8975220ef3.webp"
"MediaSize" => 60275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b4875166552e3987d0b6ca8975220ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907463_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c8328b8fe00053fc69cf99a29698ae25.webp"
"MediaSize" => 28752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c8328b8fe00053fc69cf99a29698ae25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907463_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/3511a34a5512ea881f3eb2283c9659a6.webp"
"MediaSize" => 55615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-3511a34a5512ea881f3eb2283c9659a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907463_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/66bfba3bb27dcc15a888079a79d23a6c.webp"
"MediaSize" => 44723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-66bfba3bb27dcc15a888079a79d23a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907463_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/d716111056d499c6858d90b084ed8f01.webp"
"MediaSize" => 45201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-d716111056d499c6858d90b084ed8f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907463_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c40438d66bc845bda83dc577a8f882b9.webp"
"MediaSize" => 51644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c40438d66bc845bda83dc577a8f882b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
…2
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171
+post_id: "1525931"
+post_author: 1
+"ListingKey": "29898285"
+"ListingId": "X13439700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:40:08Z"
+"RFModificationTimestamp": "2026-06-12T23:51:00Z"
+"ListPrice": 2395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H7"
+"UnparsedAddress": "345 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L0R2H7"
+"Coordinates": array:2 [
0 => -79.870648
1 => 43.339359
]
+"Latitude": 43.339359
+"Longitude": -79.870648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 3-acres (per MPAC) this property overlooks the breathtaking natural landscape of Smokey Hollow and backs directly onto the iconic Bruce Trail. This remarkable gated estate offers a rare opportunity to acquire one of the area's most picturesque and private estates. A graceful, swooping driveway leads through expansive, awe-inspiring grounds, creating a dramatic sense of arrival while remaining discreet and private from the road. The 2.5-storey residence offers 7 bedrooms and 5 bathrooms, along with a library with a fireplace. The home in its current state needs to be renovated. Outdoor features include an inground swimming pool and a detached double-car garage, all set within the property's remarkable estate setting. For those with a vision for transformation, a new house rendering design by SMPL Design Studio offers inspiration for a spectacular modern residence. Ideally located just minutes from downtown Waterdown, Burlington, and the convenient Aldershot GO Station, providing easy access to amenities and commuting options. Property and all structures are being sold in AS-IS condition. Floor plans and a survey are available. Either renovate the existing house or build a new one. Exterior photos are current and from a few years ago. Interior photos and new home renderings are for creative / illustrative purposes only. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-12T23:50:55.953773+00:00"
+"Directions": "Cross Streets: Waterdown Rd / Mountain Brow Rd. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1529018"
+"ListOfficeKey": "291562"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.8 x 579.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:31:41Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T21:31:41Z"
+"Stories": "2.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "17408"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898285/345-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1743890"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291562"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 7
+"FrontageLengthNumeric": 151.9
+"OriginalEntryTimestamp": "2026-06-12T21:31:41.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1140630"
+"ListOfficeNationalAssociationId": "1400240"
+"CoListAgentNationalAssociationId": "1292982"
+"CoListOfficeNationalAssociationId": "1400240"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898285')"
+"ID": "1525931"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: "1522008"
+post_author: 1
+"ListingKey": "29892469"
+"ListingId": "X13434412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:25:12Z"
+"RFModificationTimestamp": "2026-06-12T14:28:02Z"
+"ListPrice": 519998.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "617 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L0R2H4"
+"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": "State of the Art Trend Condos. This unit boosts 792 sq. ft., one of the largest one bedroom units available. Located on the 6th floor, this unit offers spacious, modern living with 1 bedroom plus den ideal for a home office or additional bedroom. A fantastic open-concept layout featuring upgraded appliances, breakfast bar & sleek laminate flooring in the Great room. The openness of the kitchen allows you to enjoy the bright living area, perfect for entertaining and viewing the great outdoors. An upgraded private balcony gives you unobstructed views. A generously sized bedroom with walk-in closet & a 4 piece bathroom finished with modern fixtures. Additional features include convenient in-unit laundry and a storage locker located on the same floor. Added bonus this unit comes with one designated underground & one surface parking spot very much high in demand.. Minutes away from local amenities, Hwy 403/407 makingfor an easier commute. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "551.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:02:54.162610+00:00"
+"Directions": "Dundas St E & Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995891"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:56Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:19:15Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3700"
+"Rooms": array:1 [
0 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892469/617-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:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-11T21:53:56.23Z"
+"ListAgentNationalAssociationId": "1278700"
+"ListOfficeNationalAssociationId": "1230066"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892469')"
+"ID": "1522008"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1518137"
+post_author: 1
+"ListingKey": "29887094"
+"ListingId": "X13429540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T04:50:27Z"
+"RFModificationTimestamp": "2026-06-11T05:58:26Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "905 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Modern Trend Living condo with 9-ft ceilings and an open-concept layout. Features ceramic tile flooring and bright LED lighting throughout. The stylish kitchen offers custom cabinetry, designer faucet, and laminate countertops with a backsplash, while the bathrooms boast quartz countertops and spa-inspired premium fixtures. Enjoy a feature wall for your TV, a French balcony, and an owned locker for extra convenience. Pet-friendly in both living areas and bedrooms. This energy-efficient building includes geothermal heating/cooling, secure entry, 2 owned underground parking spaces, rooftop terrace, and professional management. Freshly painted and perfectly located near parks, shopping, restaurants, and major highways. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "497.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T05:58:17.496106+00:00"
+"Directions": "Dundas St/ Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036997"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T04:42:09Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T04:42:09Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3952.38"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29887094/905-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T04:42:09.45Z"
+"ListAgentNationalAssociationId": "1313436"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887094')"
+"ID": "1518137"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1517898"
+post_author: 1
+"ListingKey": "29886601"
+"ListingId": "X13429118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T00:50:04Z"
+"RFModificationTimestamp": "2026-06-11T03:18:01Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "223 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.876439
1 => 43.340782
]
+"Latitude": 43.340782
+"Longitude": -79.876439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A maintenance-free townhome that lives like a detached; and it doesn't come up often on Skinner. This home delivers over 2,100 sq ft of finished, carpet-free living across three bedrooms, three bathrooms, and a true walk-out lower level that sets it apart from every other townhome on the street. The chef-inspired kitchen is the anchor: a 10-ft island built for gathering, white cabinetry paired with gold hardware, stainless appliances, and 9-ft ceilings dotted with pot lights. Open-concept flow connects kitchen, dining, and living for everyday function and effortless entertaining. Upstairs delivers what most townhomes can't: three genuinely large bedrooms, a primary suite that functions as a true escape, and an ensuite finished with the kind of detail you'd expect in a custom build like a massive tub overlooking your backyard. The fully finished basement (2023) walks out to a fully landscaped backyard featuring over 500 sq ft of professionally laid interlock, turf grass, and matured plantings; the rose bush and tulips are already blooming. Add the upper deck (2024) and you've got two outdoor living rooms, three seasons of use, and zero weekend lawn maintenance. Mechanically dialed in: high-efficiency heat pump (2024) for year-round comfort and low operating costs, luxury laminate throughout (2020), and a garage with direct backyard access plus a custom loft (2024) for seasonal storage. Walk to top-rated schools, new parks, and the Waterdown village's cafés and Farmers' Market; with Aldershot GO and 403/407 access making the commute a non-issue. A turnkey home for a family ready to put down roots in one of the area's fastest-growing communities, without inheriting a weekend's worth of upkeep. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:17:52.207026+00:00"
+"Directions": "Skinner and McKnight"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154884"
+"ListOfficeKey": "300286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.8 x 92.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T00:44:07Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T00:44:07Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "223"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6440.21"
+"VirtualTourURLUnbranded": "https://www.223skinnerroad.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886601/223-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.9
+"OriginalEntryTimestamp": "2026-06-11T00:44:07.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406384"
+"ListOfficeNationalAssociationId": "1485877"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886601')"
+"ID": "1517898"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+post_id: "1517899"
+post_author: 1
+"ListingKey": "29886669"
+"ListingId": "40838479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T01:15:19Z"
+"RFModificationTimestamp": "2026-06-11T03:13:03Z"
+"ListPrice": 355000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 570.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 E DUNDAS Street E Unit# 216, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8795173
1 => 43.3433004
]
+"Latitude": 43.3433004
+"Longitude": -79.8795173
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful 1-bedroom condo featuring a modern kitchen with stainless steel appliances and quartz countertops. Enjoy the convenience of in-suite laundry and a spacious 4-piece bathroom with upgraded glass shower doors. Bright and functional layout ideal for first-time buyers, downsizers, or investors. Underground parking. Building amenities include a rooftop BBQ terrace, party room, and fully equipped exercise room. Conveniently located close to shopping, dining, transit, and everyday amenities. A great opportunity to own in a well-maintained building with desirable features and amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "522.12"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:13:00.138402+00:00"
+"Directions": "Dundas St E to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041052"
+"ListOfficeKey": "55168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-11T01:09:23Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T01:09:23Z"
+"Stories": "2.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2555"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29886669/460-e-dundas-street-e-unit-216-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1980090"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1628618"
+"CoListOfficeKey": "55167"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "55168"
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 570
+"OriginalEntryTimestamp": "2026-06-11T01:09:23.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1317017"
+"ListOfficeNationalAssociationId": "1116022"
+"CoListAgentNationalAssociationId": "1265844"
+"CoListAgentNationalAssociationId2": "1162034"
+"CoListOfficeNationalAssociationId": "1003582"
+"CoListOfficeNationalAssociationId2": "1116022"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886669')"
+"ID": "1517899"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173
+post_id: "1517900"
+post_author: 1
+"ListingKey": "29885330"
+"ListingId": "40838531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:25:15Z"
+"RFModificationTimestamp": "2026-06-11T02:31:41Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 676.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 317, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8791956
1 => 43.3440992
]
+"Latitude": 43.3440992
+"Longitude": -79.8791956
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to modern condo living in the heart of Waterdown. This beautifully maintained 1 bedroom + den, 1 bathroom suite at 317-470 Dundas Street East offers 676 sqft of thoughtfully designed living space complete with 1 parking space and 1 locker. Surrounded by shopping, dining, scenic trails, parks, and everyday conveniences, this vibrant location also provides easy access to Burlington, Hamilton, Aldershot GO Station, and Highway 407—perfect for commuters, first-time buyers, professionals, or downsizers seeking stylish low-maintenance living in a growing community. Inside, the bright open-concept layout is filled with natural light from oversized windows and showcases a modern, functional design ideal for both entertaining and everyday living. The kitchen features contemporary cabinetry, stainless steel appliances, stylish backsplash detailing, ample prep space, and a large island with seating overlooking the main living area. The spacious living and dining area offers seamless flow and direct access to the private balcony, creating the perfect extension of your living space. The primary bedroom offers generous closet space, while the den provides excellent flexibility for a home office, guest space, or additional living area. The well-appointed 4pc bathroom features clean contemporary finishes, while convenient in-suite laundry adds everyday practicality. Residents enjoy exceptional building amenities including a rooftop patio with lounge areas and BBQs, fully equipped fitness centre, stylish party room, and secure entry, all while being surrounded by scenic trails, restaurants, shopping, and everyday conveniences just moments away. An excellent opportunity to enjoy low-maintenance living in one of Waterdown’s most connected and fast-growing communities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "593.36"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"CreationDate": "2026-06-11T02:31:33.816947+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1585114"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-10T21:22:04Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T21:22:04Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2844.72"
+"VirtualTourURLUnbranded": "https://youtu.be/CrXWKfetRd4"
+"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/29885330/470-dundas-street-e-unit-317-hamilton"
+"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": 676
+"OriginalEntryTimestamp": "2026-06-10T21:20:06.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1152418"
+"ListOfficeNationalAssociationId": "1324631"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885330')"
+"ID": "1517900"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 155
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]