array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29936356 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1554337"
+post_author: 1
+"ListingKey": "29936356"
+"ListingId": "X13474102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:30:04Z"
+"RFModificationTimestamp": "2026-06-23T14:31:34Z"
+"ListPrice": 434999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "230 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown. This well maintained 1+den condo offers 692 sq ft of thoughtfully designed living space, ideal for comfortable everyday living.Situated on the second floor, the unit features an open concept layout with laminate flooring throughout and a versatile den that can easily function as a home office, guest area, or additional living space. Walk out to a private balcony, perfect for relaxing outdoors.The unit includes two parking spaces, one underground and one outdoor, along with a private locker, offering a rare and highly practical combination.Located in the sought after Trend community, close to parks, shopping, dining, and major highways, while still enjoying the charm of Waterdown. A great opportunity for first time buyers, professionals, or investors seeking a move in ready property. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "494.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:19:43.183868+00:00"
+"Directions": "Dundas and Riverwalk"
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1975151"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T14:22:05Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T14:22:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3020.94"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/c3234619"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1665441436"
"RoomType" => "Den"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 2.01
"ListingKey" => "29936356"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
1 => array:11 [
"RoomKey" => "1665441437"
"RoomType" => "Kitchen"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 3.47
"ListingKey" => "29936356"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
2 => array:11 [
"RoomKey" => "1665441438"
"RoomType" => "Living room"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 3.47
"ListingKey" => "29936356"
"RoomLength" => 5.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
3 => array:11 [
"RoomKey" => "1665441439"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13474102"
"RoomLevel" => "Flat"
"RoomWidth" => 2.93
"ListingKey" => "29936356"
"RoomLength" => 3.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T16:26:49.16Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936356/230-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 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T16:26:49.13Z"
+"ListAgentNationalAssociationId": "1261992"
+"ListOfficeNationalAssociationId": "1336201"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29936356_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/a8674cc0c7e2b1ddc1b4da770e7bff21.webp"
"MediaSize" => 252824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-a8674cc0c7e2b1ddc1b4da770e7bff21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29936356_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/540b6bd9112355da0b2129c80dd5b2b6.webp"
"MediaSize" => 241816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-540b6bd9112355da0b2129c80dd5b2b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29936356_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/635dcf52a172d44cc9a0d95c5db0558b.webp"
"MediaSize" => 86800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-635dcf52a172d44cc9a0d95c5db0558b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29936356_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/973d44fb490aa6493f2451f4e5034e72.webp"
"MediaSize" => 152840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-973d44fb490aa6493f2451f4e5034e72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29936356_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/353e933d4072ecbd64f9db6e5eb086d9.webp"
"MediaSize" => 151836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-353e933d4072ecbd64f9db6e5eb086d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29936356_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ec5e23db47fe43414c2dd990118c5ed9.webp"
"MediaSize" => 141319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ec5e23db47fe43414c2dd990118c5ed9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29936356_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/2da058580aabdb52368f08380f054128.webp"
"MediaSize" => 120489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-2da058580aabdb52368f08380f054128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29936356_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/0c8fa154540e3122d645be2f7cb1bc40.webp"
"MediaSize" => 139745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-0c8fa154540e3122d645be2f7cb1bc40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29936356_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/043bd7a3f80b5fb5fa16048f2c856c27.webp"
"MediaSize" => 141270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-043bd7a3f80b5fb5fa16048f2c856c27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29936356_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/09cdab163d3850d63110f101f4471873.webp"
"MediaSize" => 137948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-09cdab163d3850d63110f101f4471873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29936356_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/05bd35089cab18e605268a30144006b1.webp"
"MediaSize" => 143989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-05bd35089cab18e605268a30144006b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29936356_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/07db18149faf2c7b355839c345c66df8.webp"
"MediaSize" => 133851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-07db18149faf2c7b355839c345c66df8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29936356_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/094cc8efdae72ee209d7b64844f0f7ed.webp"
"MediaSize" => 159670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-094cc8efdae72ee209d7b64844f0f7ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29936356_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/cb7adf75124194e25156a91a9ff84e07.webp"
"MediaSize" => 157235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-cb7adf75124194e25156a91a9ff84e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29936356_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/3a65ce8a5bd6109c03167ba24578fd86.webp"
"MediaSize" => 145521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-3a65ce8a5bd6109c03167ba24578fd86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29936356_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/232a98349aa685cb3987675311b42e15.webp"
"MediaSize" => 132981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-232a98349aa685cb3987675311b42e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29936356_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/8f908aad49132176ad819ff25f28bc52.webp"
"MediaSize" => 149454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-8f908aad49132176ad819ff25f28bc52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29936356_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/0365cb1433349e93372ae4a0f5a1d3da.webp"
"MediaSize" => 139721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-0365cb1433349e93372ae4a0f5a1d3da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29936356_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ba501bfa7ccff07e452b3a77689de3ea.webp"
"MediaSize" => 172883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ba501bfa7ccff07e452b3a77689de3ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29936356_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/63f57dd7115e023074e000d2e6ac6301.webp"
"MediaSize" => 133368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-63f57dd7115e023074e000d2e6ac6301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29936356_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/2870329740d24daddc38f4fdc6e94bac.webp"
"MediaSize" => 121909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-2870329740d24daddc38f4fdc6e94bac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29936356_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/09513d4e5971308b99a248c1996b7874.webp"
"MediaSize" => 92866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-09513d4e5971308b99a248c1996b7874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29936356_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/e62bc2bfa7e4a1f7dc4f979bd67b6347.webp"
"MediaSize" => 247090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-e62bc2bfa7e4a1f7dc4f979bd67b6347.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29936356_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/91e10654eb09d1eeda77d6b5d7226e8f.webp"
"MediaSize" => 209583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-91e10654eb09d1eeda77d6b5d7226e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29936356_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/c64e3874ce4a9e125c6529b563f34845.webp"
"MediaSize" => 198300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-c64e3874ce4a9e125c6529b563f34845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29936356_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/fbe55b111e04afa06bff4300a1585e62.webp"
"MediaSize" => 210645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-fbe55b111e04afa06bff4300a1585e62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29936356_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/219487900eb05d1e679cfbcb151c279a.webp"
"MediaSize" => 202985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-219487900eb05d1e679cfbcb151c279a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29936356_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/ca61a953813d4f84d638abbfc98115be.webp"
"MediaSize" => 175080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-ca61a953813d4f84d638abbfc98115be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29936356_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936356/3be0b8f0182b2ecc84a2ab0cba420072.webp"
"MediaSize" => 190806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936356/thumbnail-3be0b8f0182b2ecc84a2ab0cba420072.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474102"
"ResourceRecordKey" => "29936356"
"ModificationTimestamp" => "2026-06-22T16:26:49.13Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936356')"
+"ID": "1554337"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283868" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24765
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1975151" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24744
+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 '29936356'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+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 '29936356'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+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 '29936356' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.880553 43.342598)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25250
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1555247"
+post_author: 1
+"ListingKey": "29938814"
+"ListingId": "X13476286"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T01:05:20Z"
+"RFModificationTimestamp": "2026-06-23T01:09:52Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "213 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.894191
1 => 43.330175
]
+"Latitude": 43.330175
+"Longitude": -79.894191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Outstanding value awaits in this sophisticated two-bedroom, two-bathroom, 1,170 square foot, corner residence at 213-30 Hamilton Street South-offering some of the best price-per-square-foot value in the sought-after The View Condominium, downtown Waterdown. As one of the area's newer buildings, it pairs contemporary design with exceptional amenities, making it a smart choice for first-time buyers and investors alike. The building offers concierge service, a state-of-the-art fitness center, stylish party room, pet washing station, rooftop terrace and lush garden. Inside, floor-to-ceiling windows frame sweeping views and flood the open-concept living, dining and kitchen spaces with natural light. The kitchen features a large island, premium appliances and elegant finishes. Step onto your private balcony to savor morning coffee or breathtaking sunsets. The primary suite impresses with two walls of windows and a serene ambiance, complemented by a spa-inspired ensuite. The second bedroom suits guests or a refined home office. In-suite laundry, underground parking and a storage locker complete the offering. Stroll to boutiques, fine dining, cafés and markets, with quick access to major highways. A rare opportunity to own in a newer building with low-maintenance, high-value living. RSA. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "1021.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"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-06-22T22:32:18.605669+00:00"
+"Directions": "Cross Streets: Dundas St W. ** Directions: Dundas St W to Hamilton St S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T00:59:01Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T00:59:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5827"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1665684169"
"RoomType" => "Kitchen"
"ListingId" => "X13476286"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29938814"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:44.7Z"
]
1 => array:11 [
"RoomKey" => "1665684170"
"RoomType" => "Living room"
"ListingId" => "X13476286"
"RoomLevel" => "Main level"
"RoomWidth" => 3.61
"ListingKey" => "29938814"
"RoomLength" => 6.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:44.7Z"
]
2 => array:11 [
"RoomKey" => "1665684171"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13476286"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29938814"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:44.7Z"
]
3 => array:11 [
"RoomKey" => "1665684172"
"RoomType" => "Bedroom"
"ListingId" => "X13476286"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29938814"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:44.7Z"
]
4 => array:11 [
"RoomKey" => "1665684173"
"RoomType" => "Laundry room"
"ListingId" => "X13476286"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29938814"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:44.7Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938814/213-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Daycare"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Security/Concierge"
5 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-22T21:46:25.38Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29938814_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/7b772beb897770fb0281f0e840e46c02.webp"
"MediaSize" => 94302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-7b772beb897770fb0281f0e840e46c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:44.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29938814_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/3426a31a0f770562d5a3b243343276b4.webp"
"MediaSize" => 118247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-3426a31a0f770562d5a3b243343276b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:21.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29938814_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/5d64bc5e985d2546ae0ba4697a940028.webp"
"MediaSize" => 143921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-5d64bc5e985d2546ae0ba4697a940028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:18.77Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29938814_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/aa9553f902e09391eeb7f0ee404a6ae2.webp"
"MediaSize" => 120699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-aa9553f902e09391eeb7f0ee404a6ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:34.54Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29938814_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/40156ca953427926da97b3445eb65a9b.webp"
"MediaSize" => 87609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-40156ca953427926da97b3445eb65a9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:40.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29938814_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/4f92663bea14cf399dd4cbafdd074923.webp"
"MediaSize" => 57575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-4f92663bea14cf399dd4cbafdd074923.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:42.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29938814_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/4da477e90a2b9a0b4ff04719bfd55f72.webp"
"MediaSize" => 53119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-4da477e90a2b9a0b4ff04719bfd55f72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:13.35Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29938814_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/1a848d5baa135c08df5e927ae63d1731.webp"
"MediaSize" => 69321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-1a848d5baa135c08df5e927ae63d1731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:14.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29938814_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/789ba0b73cb2743a914b0a77f088c16d.webp"
"MediaSize" => 101436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-789ba0b73cb2743a914b0a77f088c16d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:20.53Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29938814_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/ee71d7b4b98f4d3f6af7f217dfbc8d70.webp"
"MediaSize" => 94291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-ee71d7b4b98f4d3f6af7f217dfbc8d70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:11.03Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29938814_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/19d5a0d015585c00954b2641a805ed74.webp"
"MediaSize" => 101394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-19d5a0d015585c00954b2641a805ed74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:16.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29938814_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/693a5e7ccb109d4ef1fe1837ea5cd78e.webp"
"MediaSize" => 103351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-693a5e7ccb109d4ef1fe1837ea5cd78e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29938814_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/d7a06f80c75f1f7c7125ab486006066e.webp"
"MediaSize" => 90820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-d7a06f80c75f1f7c7125ab486006066e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:29.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29938814_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/76726b734a4db04d7faec72f6b08cbb6.webp"
"MediaSize" => 85066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-76726b734a4db04d7faec72f6b08cbb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:34.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29938814_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/de2ccf371730d4c1b372bffd5d69d981.webp"
"MediaSize" => 90160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-de2ccf371730d4c1b372bffd5d69d981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:37.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29938814_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/247a2177bf82226c43f0462f3c4c8a0e.webp"
"MediaSize" => 78226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-247a2177bf82226c43f0462f3c4c8a0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:40.8Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29938814_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/8c04ed7547208df0c47b275c63419a5c.webp"
"MediaSize" => 82150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-8c04ed7547208df0c47b275c63419a5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:42.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29938814_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/b33d778602aabf26b792c2135f1e3e40.webp"
"MediaSize" => 76695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-b33d778602aabf26b792c2135f1e3e40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:10.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29938814_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/a37830efa2fa2ebf7fb99b4ffc086733.webp"
"MediaSize" => 105814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-a37830efa2fa2ebf7fb99b4ffc086733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:16.38Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29938814_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/5f8d3630850b1e96d33f8d5aa43a43bf.webp"
"MediaSize" => 135702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-5f8d3630850b1e96d33f8d5aa43a43bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:29.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29938814_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/61f677601facb5a966346cca7ad68768.webp"
"MediaSize" => 160937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-61f677601facb5a966346cca7ad68768.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:11.5Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29938814_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/98f4dc1db8551bd4e1a7aa3907947d8a.webp"
"MediaSize" => 71320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-98f4dc1db8551bd4e1a7aa3907947d8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:16.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29938814_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/544b8b864b939d5f65bfcf27708bd27a.webp"
"MediaSize" => 80811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-544b8b864b939d5f65bfcf27708bd27a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:22.91Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29938814_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/315cd77b30c4c82e56f500ea9edc253e.webp"
"MediaSize" => 70992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-315cd77b30c4c82e56f500ea9edc253e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:30.43Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29938814_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/d2c1cef9663f9adc203e34914137748b.webp"
"MediaSize" => 56053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-d2c1cef9663f9adc203e34914137748b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:13.03Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29938814_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/8330124b61b37c2a4880219693e6cef9.webp"
"MediaSize" => 76907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-8330124b61b37c2a4880219693e6cef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:18.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29938814_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/cda528cd694ff8911c1873faa972530e.webp"
"MediaSize" => 79256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-cda528cd694ff8911c1873faa972530e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:25.42Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29938814_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/7285665cdf98720827029c3d9f5d3ddb.webp"
"MediaSize" => 60256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-7285665cdf98720827029c3d9f5d3ddb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:32.06Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29938814_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/56a1a0b00af4207444a02bb39325dfd6.webp"
"MediaSize" => 75968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-56a1a0b00af4207444a02bb39325dfd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:13.35Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29938814_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/b029ec573cefa2400068d133fdebc681.webp"
"MediaSize" => 81636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-b029ec573cefa2400068d133fdebc681.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:25.57Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29938814_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/f602833a979bb292cd33f750b55c24d4.webp"
"MediaSize" => 92448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-f602833a979bb292cd33f750b55c24d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:30.42Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29938814_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/7973dd73d3ee5923fcb4c6d231f1b2fa.webp"
"MediaSize" => 58839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-7973dd73d3ee5923fcb4c6d231f1b2fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:13.45Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29938814_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/a205b462a3b4cfd83c1760028545ec49.webp"
"MediaSize" => 78253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-a205b462a3b4cfd83c1760028545ec49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:18.66Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29938814_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/67f0f0c89af8ed9d2ed58a7be7156e5b.webp"
"MediaSize" => 79213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-67f0f0c89af8ed9d2ed58a7be7156e5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:24.8Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29938814_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/776ae5dbe64a749515bc0aadcda2b48b.webp"
"MediaSize" => 78446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-776ae5dbe64a749515bc0aadcda2b48b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:29.03Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29938814_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/b78ecf9e2f8a8491fd25d67fbb25d167.webp"
"MediaSize" => 90946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-b78ecf9e2f8a8491fd25d67fbb25d167.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:14.01Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29938814_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/37719e465402eac8c620d43dd5d44f7f.webp"
"MediaSize" => 74797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-37719e465402eac8c620d43dd5d44f7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:19.34Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29938814_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/1a7c1771ca5b331aa27b5dbc31628dae.webp"
"MediaSize" => 99888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-1a7c1771ca5b331aa27b5dbc31628dae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:25.05Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29938814_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/65fa91dc30102e444830b03b3b5784cd.webp"
"MediaSize" => 114906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-65fa91dc30102e444830b03b3b5784cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:31.15Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29938814_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938814/5380b6a5923f60ee324c88d3d9b1b517.webp"
"MediaSize" => 95881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938814/thumbnail-5380b6a5923f60ee324c88d3d9b1b517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13476286"
"ResourceRecordKey" => "29938814"
"ModificationTimestamp" => "2026-06-22T23:20:38.33Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938814')"
+"ID": "1555247"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1555354"
+post_author: 1
+"ListingKey": "29938075"
+"ListingId": "40842057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T20:00:10Z"
+"RFModificationTimestamp": "2026-06-22T22:20:19Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1170.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 213, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8940406
1 => 43.3302884
]
+"Latitude": 43.3302884
+"Longitude": -79.8940406
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Outstanding value awaits in this sophisticated two-bedroom, two-bathroom, 1,170 square foot, corner residence at 213-30 Hamilton Street South—offering some of the best price-per-square-foot value in the sought-after The View Condominium, downtown Waterdown. As one of the area's newer buildings, it pairs contemporary design with exceptional amenities, making it a smart choice for first-time buyers and investors alike. The building offers concierge service, a state-of-the-art fitness center, stylish party room, pet washing station, rooftop terrace and lush garden. Inside, floor-to-ceiling windows frame sweeping views and flood the open-concept living, dining and kitchen spaces with natural light. The kitchen features a large island, premium appliances and elegant finishes. Step onto your private balcony to savor morning coffee or breathtaking sunsets. The primary suite impresses with two walls of windows and a serene ambiance, complemented by a spa-inspired ensuite. The second bedroom suits guests or a refined home office. In-suite laundry, underground parking and a storage locker complete the offering. Stroll to boutiques, fine dining, cafés and markets, with quick access to major highways. A rare opportunity to own in a newer building with low-maintenance, high-value living. Don’t be TOO LATE*! *REG TM. RSA. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "1021.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:20:10.655688+00:00"
+"Directions": "Dundas St W to Hamilton St S"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-22T19:50:48Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T19:50:47Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "5827"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1665587822"
"RoomType" => "Laundry room"
"ListingId" => "40842057"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29938075"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T19:50:47.95Z"
]
1 => array:11 [
"RoomKey" => "1665587823"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842057"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29938075"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T19:50:47.96Z"
]
2 => array:11 [
"RoomKey" => "1665587824"
"RoomType" => "Bedroom"
"ListingId" => "40842057"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29938075"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T19:50:47.96Z"
]
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/29938075/30-hamilton-street-s-unit-213-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1170
+"OriginalEntryTimestamp": "2026-06-22T19:50:47.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938075')"
+"ID": "1555354"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1554503"
+post_author: 1
+"ListingKey": "29937656"
+"ListingId": "X13475240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:25:12Z"
+"RFModificationTimestamp": "2026-06-22T23:31:38Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "15 HAGER CREEK TERRACE, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.874634
1 => 43.341421
]
+"Latitude": 43.341421
+"Longitude": -79.874634
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Semi Detached Absolutely Gorgeous Glendale 4 Model Elevation 1A, 4 Bedroom 2.5Washroom In Beautiful Waterdown Hamilton. This Home Offers An Open Concept Layout, 9' Ceilings On Main Floor, Upgraded Staircase With Metal Pickets, Laminate Flooring Throughout The Home, Builders Upgraded Master Bedroom Tiles And Tub, Beautiful Kitchen, And Central Air Conditioning. This Home Also Offers Many Windows Allowing Natural Light To Fill The Home. The unfinished basement offers endless potential making it a fantastic opportunity. Located just minutes from schools, parks, shopping, transit, and highway access, this home combines comfort, space, and convenience in one desirable package. Don't miss your chance to call this Waterdown gem home (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:44:47.904613+00:00"
+"Directions": "Dundas St. East & Burke St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979241"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:17:28Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:17:28Z"
+"Stories": "2.0"
+"StreetName": "Hager Creek"
+"StreetNumber": "15"
+"StreetSuffix": "Terrace"
+"TaxAnnualAmount": "7100"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937656/15-hager-creek-terrace-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-06-22T18:51:13.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1265168"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937656')"
+"ID": "1554503"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1553188"
+post_author: 1
+"ListingKey": "29935233"
+"ListingId": "X13473008"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T21:40:06Z"
+"RFModificationTimestamp": "2026-06-22T21:45:09Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G7"
+"UnparsedAddress": "585 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0G7"
+"Coordinates": array:2 [
0 => -79.870095
1 => 43.351879
]
+"Latitude": 43.351879
+"Longitude": -79.870095
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to the exquisite 585 Dundas Street East! This home boasts classic elegance and attention to detail, while preserving it's heritage and original charm. Entering through the front door, you will be greeted with a large foyer and 9' ceilings throughout the main floor! The spacious living room, dining room and kitchen are ideal for families and entertaining, with gorgeous hardwood floors, granite countertops and stainless steel appliances. The main floor continues on with an oversized family room, featuring a fireplace and perfect atmosphere for entertaining and cozy movie nights. Upstairs you will find 3 very large bedrooms, a bonus closet room and a 5 piece bathroom. The partially finished basement and outdoor shed offer ample storage space, in addition to the double car garage. The beauty of this house keeps going to the backyard with your very own beautifully landscaped private oasis, including an above ground pool built into the huge deck! The property is 0.7 acres, with tons of privacy! Minutes from both downtown Waterdown and Burlington, close to parks and all amenities! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Treatment"
10 => "Window Coverings"
11 => "Water Heater"
]
+"Basement": array:1 [
0 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:50:39.541985+00:00"
+"Directions": "Cross Streets: Dundas Street and Kerns Road. ** Directions: Brant Street to Dundas Street."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026848"
+"ListOfficeKey": "279692"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "137.1 x 225.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T21:34:13Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T21:34:13Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "585"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6363"
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29935233/585-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 137.1
+"OriginalEntryTimestamp": "2026-06-22T13:25:59.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306408"
+"ListOfficeNationalAssociationId": "1307219"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935233')"
+"ID": "1553188"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1549995"
+post_author: 1
+"ListingKey": "29930842"
+"ListingId": "40841314"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:19Z"
+"RFModificationTimestamp": "2026-06-20T20:43:36Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2510.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "4 VICTORIA Street Unit# 16, Waterdown, Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924343
1 => 43.3359233
]
+"Latitude": 43.3359233
+"Longitude": -79.8924343
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:57:27.905655+00:00"
+"Directions": "Dundas to Mill St N to Church"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944754"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T20:31:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:21Z"
+"Stories": "2.0"
+"StreetName": "VICTORIA"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6109"
+"VirtualTourURLUnbranded": "https://youriguide.com/16_4_victoria_st_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930842/4-victoria-street-unit-16-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1689
+"BelowGradeFinishedArea": 821
+"OriginalEntryTimestamp": "2026-06-19T20:32:02.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1303128"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930842')"
+"ID": "1549995"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1549761"
+post_author: 1
+"ListingKey": "29931299"
+"ListingId": "X13469334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T21:25:02Z"
+"RFModificationTimestamp": "2026-06-20T21:29:53Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H2B8"
+"UnparsedAddress": "16 - 4 VICTORIA STREET, Hamilton (Waterdown), Ontario L9H2B8"
+"Coordinates": array:2 [
0 => -79.8924317
1 => 43.3358632
]
+"Latitude": 43.3358632
+"Longitude": -79.8924317
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit townhouse tucked away in one of Waterdown's most desirable locations. Perfect for first-time buyers, young families, downsizers, or anyone seeking a low-maintenance lifestyle without sacrificing space or convenience. The bright, open-concept main floor features large windows, vaulted ceiling that fill the home with natural light, a cozy gas fireplace, and a functional layout designed for everyday living and entertaining. With three bedrooms, including a convenient main-floor bedroom, and 2.5 bathrooms, this home offers flexibility for families, guests, or a home office. Retreat to the spacious primary suite on the second level, complete with a 5-piece ensuite. Step outside to your private backyard patio and enjoy the low maintenance backyard. This sought-after condominium community offers a spacious grassy common area and is ideally situated just a short walk to downtown Waterdown's charming shops, cafés, restaurants, pubs, schools, churches, and everyday amenities. Outdoor enthusiasts will love the nearby access to the Bruce Trail and surrounding trail systems. The YMCA is only minutes away, and Memorial Park hosts popular community events, including Waterdown Ribfest. A rare opportunity to enjoy nature, convenience, and community all in one exceptional location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Water Heater"
]
+"AssociationFee": "515"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:34:14.813512+00:00"
+"Directions": "Cross Streets: Mill St N and Church Street. ** Directions: Mill St N to right on Church."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972710"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T21:17:45Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T21:17:45Z"
+"Stories": "2.0"
+"StreetName": "Victoria"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6109"
+"VirtualTourURLUnbranded": "https://youriguide.com/16_4_victoria_st_waterdown_on/"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931299/16-4-victoria-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "C5a, CM, R6-5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T21:30:44.27Z"
+"ListAgentNationalAssociationId": "1259751"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931299')"
+"ID": "1549761"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1547964"
+post_author: 1
+"ListingKey": "29928453"
+"ListingId": "X13466818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:40:11Z"
+"RFModificationTimestamp": "2026-06-19T17:43:02Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "404 - 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": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "523.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-19T16:57:01.019811+00:00"
+"Directions": "Cross Streets: Riverwalk Dr. ** Directions: Dundas to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106841"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:09Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:34:04Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2988"
+"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/29928453/404-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential Ontario"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T15:59:09.75Z"
+"ListAgentNationalAssociationId": "1375881"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928453')"
+"ID": "1547964"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1547714"
+post_author: 1
+"ListingKey": "29927387"
+"ListingId": "40840891"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:20:20Z"
+"RFModificationTimestamp": "2026-06-23T16:25:02Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 587.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0L7"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 404, Waterdown, Ontario L8B0L7"
+"Coordinates": array:2 [
0 => -79.879919
1 => 43.342805
]
+"Latitude": 43.342805
+"Longitude": -79.879919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in Waterdown! This newer 1 bed, 1 bath condo at 450 Dundas St E offers a bright open-concept layout with modern finishes throughout. Includes 1 surface parking space and a storage locker on the same floor as the unit. Enjoy great building amenities including a gym and party room. Conveniently located close to shopping, dining, parks, and major routes. Ideal for professionals or retirees seeking low-maintenance living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "398.52"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T14:50:15.014895+00:00"
+"Directions": "Dundas to Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1829888"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-19T14:33:52Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:11:44Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2988"
+"VirtualTourURLUnbranded": "https://paulandadam.com/listing/404-450-dundas-st-e-2/"
+"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/29927387/450-dundas-street-e-unit-404-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1756268"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 587
+"OriginalEntryTimestamp": "2026-06-19T13:51:29.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1195588"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1183377"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927387')"
+"ID": "1547714"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1546295"
+post_author: 1
+"ListingKey": "29925650"
+"ListingId": "X13464400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:30:05Z"
+"RFModificationTimestamp": "2026-06-19T01:17:17Z"
+"ListPrice": 534990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A7"
+"UnparsedAddress": "336 - 10 MALLARD TRAIL, Hamilton (Waterdown), Ontario L8B2A7"
+"Coordinates": array:2 [
0 => -79.878112
1 => 43.344161
]
+"Latitude": 43.344161
+"Longitude": -79.878112
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2 + Den condo built by award winning developer New Horizon Development Group. Featuring in-suite laundry, geo-thermal heating & cooling, storage locker and 2 underground parking spaces! Many building amenities include a party room, gym, rooftop patios and bike storage. Located in the desirable Waterdown community with extensive dining, shopping, schools, parks and a 5 minute drive to downtown Burlington or the Aldershot GO Station (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "708.33"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-19T01:17:14.633197+00:00"
+"Directions": "Dundas St E."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T22:21:55Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:21:55Z"
+"StreetName": "Mallard"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4363"
+"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/29925650/336-10-mallard-trail-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T22:21:55.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925650')"
+"ID": "1546295"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 185
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]