array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30010583 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1608080"
+post_author: 1
+"ListingKey": "30010583"
+"ListingId": "X13542342"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:50:09Z"
+"RFModificationTimestamp": "2026-07-09T15:07:30Z"
+"ListPrice": 710000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "2 - 279 SKINNER ROAD N, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.877083
1 => 43.340355
]
+"Latitude": 43.340355
+"Longitude": -79.877083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover stylish, low-maintenance living in this beautifully maintained, sun-filled condo townhome nestled in the highly desirable East Waterdown community. Boasting soaring 9-foot ceilings and a unique open-concept design, this home offers an inviting blend of space, natural light, and everyday functionality. The spacious eat-in kitchen is designed for both entertaining and daily living, featuring stainless steel appliances, abundant cabinetry, generous prep space, and a walk-out to a private balcony-perfect for morning coffee, evening sunsets, or summer BBQs. Upstairs, you'll find two generously sized bedrooms, each with its own private ensuite, including a spacious primary retreat with a 4-piece bath and a second bedroom with a 3-piece ensuite-an ideal layout for families, guests, or professionals seeking added privacy. Enjoy the convenience of an attached garage with inside entry, plus parking for up to three vehicles-a rare and valuable feature. Low condo fees make ownership even more affordable while allowing you to enjoy a carefree, low-maintenance lifestyle. Located in one of Waterdown's most sought-after neighbourhoods, you're just minutes from top-rated schools, scenic parks and trails, shopping, restaurants, the GO Station, major highways, downtown Waterdown, and Burlington, offering the perfect balance of small-town charm and effortless connectivity. Whether you're a first-time buyer, downsizer, busy professional, or savvy investor, this move-in-ready home delivers exceptional value, comfort, and lifestyle in an outstanding location. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"AssociationFee": "194.39"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-09T15:07:27.431020+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Skinner. ** Directions: South of Dundas at Mallard & Skinner Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1660663"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:41:25Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:41:25Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "Skinner"
+"StreetNumber": "279"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4497.87"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/279-skinner-road-hamilton-l8b-1w5/nb/"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1679105037"
"RoomType" => "Foyer"
"ListingId" => "X13542342"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.0
"ListingKey" => "30010583"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
1 => array:11 [
"RoomKey" => "1679105038"
"RoomType" => "Living room"
"ListingId" => "X13542342"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "30010583"
"RoomLength" => 6.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
2 => array:11 [
"RoomKey" => "1679105039"
"RoomType" => "Kitchen"
"ListingId" => "X13542342"
"RoomLevel" => "Second level"
"RoomWidth" => 2.95
"ListingKey" => "30010583"
"RoomLength" => 6.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
3 => array:11 [
"RoomKey" => "1679105040"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13542342"
"RoomLevel" => "Third level"
"RoomWidth" => 2.95
"ListingKey" => "30010583"
"RoomLength" => 3.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
4 => array:11 [
"RoomKey" => "1679105041"
"RoomType" => "Bedroom 2"
"ListingId" => "X13542342"
"RoomLevel" => "Third level"
"RoomWidth" => 2.96
"ListingKey" => "30010583"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
5 => array:11 [
"RoomKey" => "1679105042"
"RoomType" => "Laundry room"
"ListingId" => "X13542342"
"RoomLevel" => "Second level"
"RoomWidth" => 1.06
"ListingKey" => "30010583"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:41:25.24Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30010583/2-279-skinner-road-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WENTWORTH STANDARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T14:41:25.22Z"
+"ListAgentNationalAssociationId": "1167703"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30010583_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/f574ba665293ec4fcf60e728b1d5f509.webp"
"MediaSize" => 420210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-f574ba665293ec4fcf60e728b1d5f509.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30010583_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/c93ac4782ec5a1a4b5c0049c8a8aa710.webp"
"MediaSize" => 462415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-c93ac4782ec5a1a4b5c0049c8a8aa710.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30010583_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/1294b8bfa6925c013f3be5dbb9109569.webp"
"MediaSize" => 228772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-1294b8bfa6925c013f3be5dbb9109569.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30010583_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/f8f2f895c948d9d621e36676386ff851.webp"
"MediaSize" => 216608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-f8f2f895c948d9d621e36676386ff851.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30010583_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/7b4f2b52ae548635ff67372e9a3eaa42.webp"
"MediaSize" => 178893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-7b4f2b52ae548635ff67372e9a3eaa42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30010583_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/ba58f8cd047b1a7a8401d5f9dbe93089.webp"
"MediaSize" => 271476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-ba58f8cd047b1a7a8401d5f9dbe93089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30010583_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/6cb13334814405c2d1a2164751162e83.webp"
"MediaSize" => 170858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-6cb13334814405c2d1a2164751162e83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30010583_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/fbd6490b85cb557eb348a13d3c468781.webp"
"MediaSize" => 344422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-fbd6490b85cb557eb348a13d3c468781.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30010583_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/7c1ef2f55103fbe26b7faa55d2d9b31c.webp"
"MediaSize" => 163511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-7c1ef2f55103fbe26b7faa55d2d9b31c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30010583_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/f056aecb6f04fff21962b42dd3751b61.webp"
"MediaSize" => 255379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-f056aecb6f04fff21962b42dd3751b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30010583_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/aef6dca67e970b1a10e278f31c5fe493.webp"
"MediaSize" => 261689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-aef6dca67e970b1a10e278f31c5fe493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30010583_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/cda1cbbeacce385c98410c3e83346905.webp"
"MediaSize" => 264457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-cda1cbbeacce385c98410c3e83346905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30010583_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/e05dc850c89e742e5eb882a14e93a875.webp"
"MediaSize" => 235684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-e05dc850c89e742e5eb882a14e93a875.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30010583_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/5b32e797e0c24ccbccf606408d6ad7ac.webp"
"MediaSize" => 191172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-5b32e797e0c24ccbccf606408d6ad7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30010583_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/aed18fde2cd87035c170962750f2188d.webp"
"MediaSize" => 167165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-aed18fde2cd87035c170962750f2188d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30010583_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/0829107c6577b493017afa21ef8ce3bc.webp"
"MediaSize" => 282536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-0829107c6577b493017afa21ef8ce3bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30010583_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/d368cad0fbd254ed2441ff38445d8950.webp"
"MediaSize" => 237559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-d368cad0fbd254ed2441ff38445d8950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30010583_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/40cd889973f4b46a64917135d8c5465a.webp"
"MediaSize" => 195456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-40cd889973f4b46a64917135d8c5465a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30010583_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/585ee8e7fb24baa87c2fd1e0825e3e12.webp"
"MediaSize" => 137046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-585ee8e7fb24baa87c2fd1e0825e3e12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30010583_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30010583/ff1be8d09287d82ce0d973da3ba29122.webp"
"MediaSize" => 348742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30010583/thumbnail-ff1be8d09287d82ce0d973da3ba29122.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13542342"
"ResourceRecordKey" => "30010583"
"ModificationTimestamp" => "2026-07-09T14:41:25.22Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010583')"
+"ID": "1608080"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 93711" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "KINGSWAY REAL ESTATE"
+"OfficeEmail": null
+"OfficePhone": "905-277-2000"
+"OfficeMlsId": "101400"
+"ModificationTimestamp": "2026-03-03T10:59:08Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "93711"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "3180 Ridgeway Drive Unit 36"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5L5S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1158326"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-277-0020"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "8130"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "93711"
"SocialMediaUrlOrId" => "http://www.kingswayrealestate.com/"
"ModificationTimestamp" => "2025-06-11T21:26:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1061882"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('93711')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1660663" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24825
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30010583'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25211
+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 '30010583' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30010583' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.877083 43.340355)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25280
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1609700"
+post_author: 1
+"ListingKey": "30012970"
+"ListingId": "40846786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T18:55:20Z"
+"RFModificationTimestamp": "2026-07-09T19:51:08Z"
+"ListPrice": 818000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1484.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A9"
+"UnparsedAddress": "245 BURKE Street, Waterdown, Ontario L8B2A9"
+"Coordinates": array:2 [
0 => -79.8788273
1 => 43.3366865
]
+"Latitude": 43.3366865
+"Longitude": -79.8788273
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional built townhouse in one of Waterdown’s most sought-after communities! Offering 1,484 square feet of thoughtfully designed living space, this move-in ready home features three spacious bedrooms, three bathrooms and the convenience of upper-level laundry. The bright, open-concept layout is perfect for everyday living and entertaining. Far from builder basic, the owners invested thousands in premium upgrades, custom window coverings and high-end finishes that elevate every room. Immaculately maintained and truly turnkey, this home offers all the benefits of new construction without the wait. Enjoy a low-maintenance lifestyle just minutes from charming downtown Waterdown, with its boutique shops, restaurants, parks, schools, and everyday amenities. Simply unpack and enjoy everything this beautiful home has to offer! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "242.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:51:04.615921+00:00"
+"Directions": "HAMILTON ST N TO DUNDAS ST E TO BURKE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T18:48:29Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T18:48:29Z"
+"Stories": "3.0"
+"StreetName": "BURKE"
+"StreetNumber": "245"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4872"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1679341995"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
1 => array:11 [
"RoomKey" => "1679341996"
"RoomType" => "Full bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
2 => array:11 [
"RoomKey" => "1679341997"
"RoomType" => "Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
3 => array:11 [
"RoomKey" => "1679341998"
"RoomType" => "Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
4 => array:11 [
"RoomKey" => "1679341999"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846786"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
5 => array:11 [
"RoomKey" => "1679342000"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
6 => array:11 [
"RoomKey" => "1679342001"
"RoomType" => "Kitchen"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
7 => array:11 [
"RoomKey" => "1679342002"
"RoomType" => "Dining room"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
8 => array:11 [
"RoomKey" => "1679342003"
"RoomType" => "Living room"
"ListingId" => "40846786"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30012970"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T18:48:29.46Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012970/245-burke-street-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1484
+"OriginalEntryTimestamp": "2026-07-09T18:48:29.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30012970_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/0dcadc755b05fdb2adfa8650b272ecd1.webp"
"MediaSize" => 131586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-0dcadc755b05fdb2adfa8650b272ecd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30012970_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/1b68c324d6d0624a84ef75a959a047ec.webp"
"MediaSize" => 131367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-1b68c324d6d0624a84ef75a959a047ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30012970_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/c864b5f6b4b30edf17588ef14c9f9686.webp"
"MediaSize" => 57481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-c864b5f6b4b30edf17588ef14c9f9686.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30012970_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8e57ce416e40050417c126a05a4dc4b9.webp"
"MediaSize" => 79483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8e57ce416e40050417c126a05a4dc4b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30012970_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/1f6e0493a65ae96db0092fcb95e78674.webp"
"MediaSize" => 64858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-1f6e0493a65ae96db0092fcb95e78674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30012970_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7083306925ddce4a4680ff1de227e665.webp"
"MediaSize" => 73258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7083306925ddce4a4680ff1de227e665.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30012970_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/20aec0fae8a9a617cd7f6783e6e87a69.webp"
"MediaSize" => 90324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-20aec0fae8a9a617cd7f6783e6e87a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30012970_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/680599972c46aeeaac7169297dfad373.webp"
"MediaSize" => 69317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-680599972c46aeeaac7169297dfad373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30012970_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/0680aa1a69e83e794e0d3729c08750fd.webp"
"MediaSize" => 68764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-0680aa1a69e83e794e0d3729c08750fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30012970_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/73fdab46c9d4fb5e5119c3f51d1b7501.webp"
"MediaSize" => 53055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-73fdab46c9d4fb5e5119c3f51d1b7501.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30012970_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/db71c8326fd9ec910d3c8e64e8656090.webp"
"MediaSize" => 62123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-db71c8326fd9ec910d3c8e64e8656090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30012970_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/82f4d7e6d12b68ff019cf10d38f9ef21.webp"
"MediaSize" => 87759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-82f4d7e6d12b68ff019cf10d38f9ef21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30012970_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/67e41614330d3fac851a7f563ed6ad90.webp"
"MediaSize" => 71250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-67e41614330d3fac851a7f563ed6ad90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30012970_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/e9c10faca38601f06b5729e619f1cc21.webp"
"MediaSize" => 34178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-e9c10faca38601f06b5729e619f1cc21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30012970_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7816826fb4c6b0f558bfbc561ca69769.webp"
"MediaSize" => 49782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7816826fb4c6b0f558bfbc561ca69769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30012970_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/224de8c58d470d855ddc2b942d4ffbe7.webp"
"MediaSize" => 64972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-224de8c58d470d855ddc2b942d4ffbe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30012970_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/3567be07c3d9ebe35f80f949670951bb.webp"
"MediaSize" => 48406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-3567be07c3d9ebe35f80f949670951bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30012970_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/b4f95196509c038c5c0aad8aa9d9dd6d.webp"
"MediaSize" => 42846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-b4f95196509c038c5c0aad8aa9d9dd6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30012970_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/7338680127abb1798133ba890dd0023b.webp"
"MediaSize" => 47311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-7338680127abb1798133ba890dd0023b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30012970_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/f3cf691455e58e4ae8fc0724a2845b4d.webp"
"MediaSize" => 49625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-f3cf691455e58e4ae8fc0724a2845b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30012970_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/36dcc72e096c1ff64b84a7cb165230c9.webp"
"MediaSize" => 49836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-36dcc72e096c1ff64b84a7cb165230c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30012970_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/4e506a58371f98b3447d54d458bae702.webp"
"MediaSize" => 45386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-4e506a58371f98b3447d54d458bae702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30012970_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/16c97dcca9852b6f68ee6545346aa649.webp"
"MediaSize" => 54440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-16c97dcca9852b6f68ee6545346aa649.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30012970_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/ff72228394a9dc39946450985ab8c52e.webp"
"MediaSize" => 51465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-ff72228394a9dc39946450985ab8c52e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30012970_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/5d7e70200c4484ca43b94c9a721698f7.webp"
"MediaSize" => 46889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-5d7e70200c4484ca43b94c9a721698f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30012970_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/b6e9ed41070b833775e7b8d6d2f0ceda.webp"
"MediaSize" => 35801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-b6e9ed41070b833775e7b8d6d2f0ceda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30012970_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/77ff414812edcb29f3f0b69354d29dd6.webp"
"MediaSize" => 112105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-77ff414812edcb29f3f0b69354d29dd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30012970_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/2616f233816a46178754f37dbdb9dc8e.webp"
"MediaSize" => 111486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-2616f233816a46178754f37dbdb9dc8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30012970_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8bac8bb853acaedcaad76b3f58a06df5.webp"
"MediaSize" => 51962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8bac8bb853acaedcaad76b3f58a06df5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30012970_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8d37a632b4b859f81dbfbc12658dfb80.webp"
"MediaSize" => 93025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8d37a632b4b859f81dbfbc12658dfb80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30012970_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/d491a0906cbc7d7b4e4eb0536c730dc3.webp"
"MediaSize" => 127378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-d491a0906cbc7d7b4e4eb0536c730dc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30012970_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30012970/8094e04cc37afa4508579c4a636be87f.webp"
"MediaSize" => 131421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30012970/thumbnail-8094e04cc37afa4508579c4a636be87f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846786"
"ResourceRecordKey" => "30012970"
"ModificationTimestamp" => "2026-07-09T18:48:29.44Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012970')"
+"ID": "1609700"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1609624"
+post_author: 1
+"ListingKey": "30013126"
+"ListingId": "X13544800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:20:06Z"
+"RFModificationTimestamp": "2026-07-09T19:42:46Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "110 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker-an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "724.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:42:44.122416+00:00"
+"Directions": "Dundas St E and Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Other"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994256"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Level lot"
1 => "Elevator"
2 => "Balcony"
3 => "Level"
4 => "Carpet Free"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-09T19:10:55Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:10:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4682.53"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1679360187"
"RoomType" => "Kitchen"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.28
"ListingKey" => "30013126"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
1 => array:11 [
"RoomKey" => "1679360188"
"RoomType" => "Living room"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.17
"ListingKey" => "30013126"
"RoomLength" => 6.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
2 => array:11 [
"RoomKey" => "1679360189"
"RoomType" => "Den"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.08
"ListingKey" => "30013126"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
3 => array:11 [
"RoomKey" => "1679360190"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "30013126"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
4 => array:11 [
"RoomKey" => "1679360191"
"RoomType" => "Bedroom"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30013126"
"RoomLength" => 4.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
5 => array:11 [
"RoomKey" => "1679360192"
"RoomType" => "Laundry room"
"ListingId" => "X13544800"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30013126"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T19:10:55.84Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013126/110-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-09T19:10:55.81Z"
+"ListAgentNationalAssociationId": "1277414"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30013126_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/e7cc9e7e1bf4ca242f9a8b78c4e45517.webp"
"MediaSize" => 125528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-e7cc9e7e1bf4ca242f9a8b78c4e45517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30013126_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/e4b3bbb7ed5232cbc72be589e22c0c38.webp"
"MediaSize" => 50733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-e4b3bbb7ed5232cbc72be589e22c0c38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30013126_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/2bf92fe41ba94afc968123006e021a5b.webp"
"MediaSize" => 51801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-2bf92fe41ba94afc968123006e021a5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30013126_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/56b1f10db0f33dd4220619de94f53838.webp"
"MediaSize" => 58013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-56b1f10db0f33dd4220619de94f53838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30013126_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/4c0751c44befda9349692caab3b6255c.webp"
"MediaSize" => 117817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-4c0751c44befda9349692caab3b6255c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30013126_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/44180e5935ab2e310b33b3b75f7e143c.webp"
"MediaSize" => 62657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-44180e5935ab2e310b33b3b75f7e143c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13544800"
"ResourceRecordKey" => "30013126"
"ModificationTimestamp" => "2026-07-09T19:10:55.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30013126_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30013126/14a695f69ab0fddeb1511ace19446b6d.webp"
"MediaSize" => 54859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30013126/thumbnail-14a695f69ab0fddeb1511ace19446b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013126')"
+"ID": "1609624"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1609422"
+post_author: 1
+"ListingKey": "30012116"
+"ListingId": "40846676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T17:35:25Z"
+"RFModificationTimestamp": "2026-07-09T19:24:44Z"
+"ListPrice": 609000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1074.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 110, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.8802837
1 => 43.3432106
]
+"Latitude": 43.3432106
+"Longitude": -79.8802837
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely offered ground-level suite offering approximately 1,074 sq. ft. of bright, open-concept living in one of Waterdown's most convenient locations. This spacious south-facing 2+1 BR, 2 full unit features soaring 10-foot ceilings, two private balconies, and a thoughtfully designed layout that is ideal for professionals, downsizers, or those seeking low-maintenance living without compromising on space. The versatile den is perfect for a home office, guest room, or additional living space. Enjoy two walk-in closets, upgraded appliances, and an abundance of natural light throughout. The suite also includes two underground parking spaces and a large storage locker—an exceptional combination rarely found in condominium living. Residents enjoy outstanding building amenities, including a fully equipped fitness centre, stylish party room, bike storage, and a spectacular rooftop lounge with BBQ area, perfect for entertaining or relaxing with friends and family. Ideally located close to shopping, restaurants, parks, trails, major highways, and all the amenities that make Waterdown such a desirable community. This is a rare opportunity to own a spacious ground-level condo offering comfort, convenience, and exceptional value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "724.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-09T19:24:36.554161+00:00"
+"Directions": "DUNDAS ST TO MALLARD TRAIL TO RIVERWALK DRIVE. THE ENTRANCE TO 450 DUNDAS IS OFF RIVERWALK WHICH IS SOUTH OF DUNDAS ST E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596388"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T17:29:15Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T17:29:15Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "4682.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012116/450-dundas-street-e-unit-110-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1074
+"OriginalEntryTimestamp": "2026-07-09T17:29:15.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1096193"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012116')"
+"ID": "1609422"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1608450"
+post_author: 1
+"ListingKey": "30011163"
+"ListingId": "40846705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:55:19Z"
+"RFModificationTimestamp": "2026-07-09T16:53:51Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 714.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 201, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940353
1 => 43.3303591
]
+"Latitude": 43.3303591
+"Longitude": -79.8940353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 201 at The View, a stylish south-facing 1-bedroom plus den overlooking a canopy of mature trees that gives the whole suite a calm, retreat-like feel. The versatile den is ideal for a home office, the dining area fits a proper table, and the generous living room features a wall-mounted electric fireplace and walkout to a private balcony. White quartz counters, stainless steel appliances, and an oversized peninsula anchor the kitchen, while the bedroom fits a full furniture set and the spa-inspired bathroom offers a tiled walk-in shower, floating vanity, linen storage, and laundry closet.Beyond the suite, this impeccably maintained 6-year-old building delivers: concierge and security staff, a gym, party room with prep kitchen, lounge, sixth-floor terraces with sweeping views, a pet spa, EV parking, and ample visitor parking.And then there's the location. Set on a quiet, tree-lined side street in sought-after Waterdown, you're a short walk to downtown shops, restaurants, and the Niagara Escarpment trails and lookouts, with quick access to highways, GO transit, and shopping centres. Peaceful, connected, and move-in ready. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "664.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T16:53:36.393879+00:00"
+"Directions": "South on Hamilton Street S from Dundas St E"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094790"
+"ListOfficeKey": "289709"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T15:48:20Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:48:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3851.69"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30011163/30-hamilton-street-s-unit-201-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 714
+"OriginalEntryTimestamp": "2026-07-09T15:48:20.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1367005"
+"ListOfficeNationalAssociationId": "1380244"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011163')"
+"ID": "1608450"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1599892"
+post_author: 1
+"ListingKey": "29998683"
+"ListingId": "X13531344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:50:06Z"
+"RFModificationTimestamp": "2026-07-07T18:01:22Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "310 PARKSIDE DRIVE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.90055364
1 => 43.3397812
]
+"Latitude": 43.3397812
+"Longitude": -79.90055364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "THE HOME YOU HAVE BEEN WAITING FOR IS HERE! Welcome to this beautifully updated bungalow offering approximately 2,360 sq. ft. of finished living space in one of Waterdown's most sought-after neighbourhoods. Thoughtfully renovated with exceptional attention to detail, this spacious 3+2 bedroom, 3 bathroom home combines modern style, comfort, and functionality for today's family. The heart of the home is the stunning open-concept kitchen, featuring a massive centre island, stainless steel appliances, a 5-burner gas range, pot lights, and seamless flow into the main living and dining areas! Offers opportunity for perfect entertaining and everyday living. Generously sized rooms throughout provide plenty of space for the whole family, while updated railings, renovated closet spaces, and numerous interior improvements add both style and practicality. The fully finished lower level offers incredible versatility, complete with two additional bedrooms and a relaxing infrared 4-person sauna, creating the perfect retreat after a long day. Step outside to enjoy the extra-large private backyard, featuring TWO beautiful gazebos, newer fencing, and ample space for outdoor gatherings, play, and relaxation. Extended outdoor patio with a fire pit brings everything together. Additional updates include a recently replaced roof and updated appliances, providing peace of mind for years to come. With parking for four vehicles on the driveway and one in the attached garage and a prime location just steps to shopping, schools, parks, and the renowned Bruce Trail, this is an exceptional opportunity to own a move-in-ready family home in the heart of Waterdown. VIEW THE MATTERPORT TOUR AND IMMERSE YOURSELF IN ALL THE BEAUTY OF THIS HOME! ----> https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1 (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Sauna"
2 => "Window Coverings"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:26:16.161594+00:00"
+"Directions": "Main St./Parkside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102095"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sauna"
]
+"LotSizeDimensions": "56 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:42:20Z"
+"Stories": "1.0"
+"StreetName": "Parkside"
+"StreetNumber": "310"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6054.31"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=3Uop6F8x9zp&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998683/310-parkside-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-07-07T14:42:20.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371918"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998683')"
+"ID": "1599892"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1599648"
+post_author: 1
+"ListingKey": "29999791"
+"ListingId": "X13532616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:50:06Z"
+"RFModificationTimestamp": "2026-07-07T17:08:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "57 MAIN STREET N, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8947788
1 => 43.3345316
]
+"Latitude": 43.3345316
+"Longitude": -79.8947788
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 57 Main Street! A charming bungalow set on an impressive 67' x 164' lot in the heart of Waterdown. Thoughtfully updated while preserving its original character, this inviting 2-bedroom home seamlessly blends modern updates with timeless charm. Inside you'll find soaring ceilings, original hardwood floors, and beautiful architectural details. The updated kitchen features quartz countertops, stainless steel appliances, and plenty of workspace. The spacious bathroom includes the convenience of in-suite laundry. Outside you will step into your own private backyard retreat complete with a newly renovated deck that overlooks a saltwater pool and an expansive tree-lined yard offering exceptional privacy and space to relax or entertain. The location is second to none. Nestled in Waterdown's sought-after downtown core, you're just steps from local boutiques, restaurants, cafés, parks, and year-round community events including the beloved Santa Claus Parade. This is a rare opportunity to own a beautifully updated home on an oversized lot in one of Waterdown's most desirable neighborhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:08:24.916673+00:00"
+"Directions": "Cross Streets: Main St N and Dundas St E. ** Directions: Dundas St E to Main St N."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252185"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "66 x 164.4 FT"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:40:48Z"
+"PhotosCount": 21
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:40:48Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "Main"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5843.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999791/57-main-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-07-07T16:40:48.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1491120"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999791')"
+"ID": "1599648"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1599737"
+post_author: 1
+"ListingKey": "29999223"
+"ListingId": "40844409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T00:05:21Z"
+"RFModificationTimestamp": "2026-07-08T00:10:32Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.22
+"LivingArea": 1259.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "57 MAIN Street N, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8939354
1 => 43.3339742
]
+"Latitude": 43.3339742
+"Longitude": -79.8939354
+"YearBuilt": 1875
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 57 Main Street! A charming bungalow set on an impressive 67' x 164' lot in the heart of Waterdown. Thoughtfully updated while preserving its original character, this inviting 2-bedroom home seamlessly blends modern updates with timeless charm. Inside you'll find soaring ceilings, original hardwood floors, and beautiful architectural details. The updated kitchen features quartz countertops, stainless steel appliances, and plenty of workspace. The spacious bathroom includes the convenience of in-suite laundry. Outside you will step into your own private backyard retreat complete with a newly renovated deck, overlooking a saltwater pool and an expansive tree-lined yard offering exceptional privacy and space to relax or entertain. The location is second to none. Nestled in Waterdown's sought-after downtown core, you're just steps from local boutiques, restaurants, cafés, parks, and year-round community events including the beloved Santa Claus Parade. This is a rare opportunity to own a beautifully updated home on an oversized lot in one of Waterdown's most desirable neighborhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T16:50:34.839893+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2170504"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.22"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-07T15:48:25Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T23:59:11Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "MAIN"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5843.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29999223/57-main-street-n-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1259
+"OriginalEntryTimestamp": "2026-07-07T15:48:25.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1421059"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999223')"
+"ID": "1599737"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1596640"
+post_author: 1
+"ListingKey": "29994928"
+"ListingId": "X13528040"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T00:15:06Z"
+"RFModificationTimestamp": "2026-07-09T00:18:21Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "112 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to care-free condo living in the heart of Waterdown! This unit features an open-concept layout with a versatile den, ideal for a home office or guest space plus modern finishes and plenty of natural light. Enjoy great amenities including a fully equipped gym, stylish party room, and a stunning rooftop terrace with BBQs, perfect for relaxing or entertaining. Located in one of Waterdown's most desirable communities, you're just minutes to Aldershot GO Station, Burlington, major highways, shopping, restaurants, parks, and scenic trails, making commuting a breeze while still enjoying the charm and warmth of a welcoming small-town community. Experience the best of low-maintenance living in a location you'll love. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "440.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:55:44.048019+00:00"
+"Directions": "Cross Streets: Riverwalk Drive. ** Directions: Dundas St E to Mallard Trail."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-06T18:40:58Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T00:08:27Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2944.87"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1sZ_GBh3xQXszk3WGaydnKYoRuewBW1Rg/view"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29994928/112-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Separate Heating Controls"
3 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-06T18:40:58.71Z"
+"ListAgentNationalAssociationId": "1366297"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994928')"
+"ID": "1596640"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1596641"
+post_author: 1
+"ListingKey": "29993854"
+"ListingId": "X13527238"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T16:50:07Z"
+"RFModificationTimestamp": "2026-07-06T19:29:16Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0Y5"
+"UnparsedAddress": "286 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L8B0Y5"
+"Coordinates": array:2 [
0 => -79.885433
1 => 43.350048
]
+"Latitude": 43.350048
+"Longitude": -79.885433
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2,300 sq. ft. family home in the heart of Waterdown! Offering 3 spacious bedrooms, 3 bathrooms, and a versatile second-floor loft that can easily serve as a 4th bedroom, home office, or second living space, this home is designed to grow with your family. Step inside to a bright, open-concept layout featuring rich hardwood flooring, a cozy gas fireplace, and an abundance of natural light. The chef-inspired kitchen boasts stainless steel appliances, a large centre island, and plenty of workspace, flowing seamlessly into the dining area with walkout access to the spacious backyard-perfect for entertaining family and friends. Upstairs, the primary retreat offers a generous walk-in closet and a spa-like ensuite. Two additional bedrooms, a beautifully appointed 4-piece bathroom, convenient second-floor laundry, and the bonus loft complete the upper level. The unspoiled basement provides endless possibilities to create the space you've always envisioned. Complete with a double-car garage and ideally located to parks, schools, shopping, downtown Waterdown, and everyday amenities, this exceptional home offers the perfect combination of style, comfort, and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:29:10.466553+00:00"
+"Directions": "Parkside Drive and Spring Creek Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2257460"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.1 x 88.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:41:35Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T16:41:35Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "286"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6300"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29993854/286-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-07-06T16:41:35.09Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1496299"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993854')"
+"ID": "1596641"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 166
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]