array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30035514 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1627222"
+post_author: 1
+"ListingKey": "30035514"
+"ListingId": "X13565504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T14:50:06Z"
+"RFModificationTimestamp": "2026-07-15T17:40:33Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "214 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.896456
1 => 43.331203
]
+"Latitude": 43.331203
+"Longitude": -79.896456
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 214 at 5 Hamilton Street North, where contemporary style meets small-town charm in the heart of vibrant Waterdown. This beautifully appointed 2-bedroom, 2-bathroom condo offers the perfect blend of comfort, functionality, and modern design. Step inside to a bright, open-concept layout featuring floor-to-ceiling windows that flood the space with natural light, creating an airy and inviting atmosphere throughout. The carpet-free interior provides a clean, modern aesthetic and low-maintenance living, while the thoughtfully designed floor plan is ideal for both everyday living and entertaining. From the spacious kitchen you can easily see the living and dining areas, conveniently staying connected while preparing meals or hosting family and friends. The primary bedroom offers a private retreat complete with its own ensuite bathroom, while the second bedroom is perfect for guests, a home office, or growing families. A second full bathroom adds convenience and flexibility for visitors. Enjoy your morning coffee or unwind at the end of the day on your private balcony, surrounded by the charm of one of Waterdown's newest boutique condominium communities. This six-story building offers modern construction and an unbeatable location just steps from downtown shops, restaurants, cafés, parks, and everyday amenities, with quick access to major highways, Aldershot GO Station, Burlington, Hamilton, and the Niagara Escarpment. Whether you're a first-time buyer, downsizer, or investor, this exceptional home offers stylish, low-maintenance living in one of Waterdown's most desirable locations. Move in, unpack, and enjoy everything this thriving community has to offer. Unit 214 is the perfect place to call home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "475.88"
+"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-07-15T17:40:30.175289+00:00"
+"Directions": "Dundas Street E and Hamilton Street N"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Tile"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104597"
+"ListOfficeKey": "288501"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T14:40:56Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T14:40:55Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4193.1"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/214-5-hamilton-street-north-waterdown/"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1684933084"
"RoomType" => "Kitchen"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 3.32
"ListingKey" => "30035514"
"RoomLength" => 2.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:55.99Z"
]
1 => array:11 [
"RoomKey" => "1684933085"
"RoomType" => "Living room"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 3.93
"ListingKey" => "30035514"
"RoomLength" => 7.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:55.99Z"
]
2 => array:11 [
"RoomKey" => "1684933086"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 4.2
"ListingKey" => "30035514"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:55.99Z"
]
3 => array:11 [
"RoomKey" => "1684933087"
"RoomType" => "Bedroom 2"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 3.59
"ListingKey" => "30035514"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:56Z"
]
4 => array:11 [
"RoomKey" => "1684933088"
"RoomType" => "Bathroom"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 2.68
"ListingKey" => "30035514"
"RoomLength" => 1.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:56Z"
]
5 => array:11 [
"RoomKey" => "1684933089"
"RoomType" => "Bathroom"
"ListingId" => "X13565504"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "30035514"
"RoomLength" => 1.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T14:40:56Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035514/214-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "PROPERTY MANAGEMENT GUILD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-15T14:40:55.97Z"
+"ListAgentNationalAssociationId": "1373973"
+"ListOfficeNationalAssociationId": "1368759"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30035514_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/c18fe5233512a7ac0c7329a8289d6718.webp"
"MediaSize" => 235559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-c18fe5233512a7ac0c7329a8289d6718.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30035514_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/dad9fdf7eaaedddb39c774e0a657b7ea.webp"
"MediaSize" => 258254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-dad9fdf7eaaedddb39c774e0a657b7ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30035514_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/62cdd116b5d51180324c0fce1cc20e79.webp"
"MediaSize" => 200509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-62cdd116b5d51180324c0fce1cc20e79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30035514_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/68f58553c504c51487530d9714b204bd.webp"
"MediaSize" => 148169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-68f58553c504c51487530d9714b204bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30035514_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/834cef665c5f9a0e26260057946e673d.webp"
"MediaSize" => 89797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-834cef665c5f9a0e26260057946e673d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30035514_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/007346f721e9f9b8ce21914ef676eec8.webp"
"MediaSize" => 98622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-007346f721e9f9b8ce21914ef676eec8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30035514_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/3d34b15eaf61a8560e1f4a2be82ed94a.webp"
"MediaSize" => 112341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-3d34b15eaf61a8560e1f4a2be82ed94a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30035514_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/ffd5c092c4eef75e068bf4a437d3050d.webp"
"MediaSize" => 113522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-ffd5c092c4eef75e068bf4a437d3050d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30035514_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/8afa6b3c11c40322cfe54131ec04b28b.webp"
"MediaSize" => 126769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-8afa6b3c11c40322cfe54131ec04b28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30035514_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/49cbe091e2df620f5e3cc91aa408c89a.webp"
"MediaSize" => 130547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-49cbe091e2df620f5e3cc91aa408c89a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30035514_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/b7bceb1115c4edd6072cec2c5a807b61.webp"
"MediaSize" => 136651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-b7bceb1115c4edd6072cec2c5a807b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30035514_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/f67fbaead395cd6e5a233548ea33d4e0.webp"
"MediaSize" => 134315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-f67fbaead395cd6e5a233548ea33d4e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30035514_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/c73d057e10c77a089c3bcd346d028f26.webp"
"MediaSize" => 142260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-c73d057e10c77a089c3bcd346d028f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30035514_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/0770b6e78c6a6cf85f7116cdae832430.webp"
"MediaSize" => 164201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-0770b6e78c6a6cf85f7116cdae832430.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30035514_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/457cf45cce0a54e281a7aff2f3d68157.webp"
"MediaSize" => 161967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-457cf45cce0a54e281a7aff2f3d68157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30035514_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/b8fd3630190427c38efe1b77951e096b.webp"
"MediaSize" => 167619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-b8fd3630190427c38efe1b77951e096b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30035514_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/8b78fee814604d18b0233bae053a07d7.webp"
"MediaSize" => 139295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-8b78fee814604d18b0233bae053a07d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30035514_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/4a2ccf4e2f7558a9925f3850f80d03e6.webp"
"MediaSize" => 128991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-4a2ccf4e2f7558a9925f3850f80d03e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30035514_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/2b7a2f9d2edc97bf51953563573a5566.webp"
"MediaSize" => 123880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-2b7a2f9d2edc97bf51953563573a5566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30035514_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/a466933b6c3de00b5d991ade1a5d17de.webp"
"MediaSize" => 107996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-a466933b6c3de00b5d991ade1a5d17de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30035514_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/c75dbf7963a21185a07fb38bd1824d25.webp"
"MediaSize" => 149399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-c75dbf7963a21185a07fb38bd1824d25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30035514_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/013c8f4f13448da9162a8c34aad6460a.webp"
"MediaSize" => 157506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-013c8f4f13448da9162a8c34aad6460a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30035514_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/2fb11971578226da84fa009f67e1aa39.webp"
"MediaSize" => 116029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-2fb11971578226da84fa009f67e1aa39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30035514_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/c8a95a5c80ce845eb1f68ac5a481c035.webp"
"MediaSize" => 133842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-c8a95a5c80ce845eb1f68ac5a481c035.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30035514_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/cc475b77efd9ff14f3ba34ff69125599.webp"
"MediaSize" => 224724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-cc475b77efd9ff14f3ba34ff69125599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30035514_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/74793c0a477bf51b5b4dab5bcbb1c623.webp"
"MediaSize" => 275224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-74793c0a477bf51b5b4dab5bcbb1c623.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30035514_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/62fe2b53c05591b1728c21fe8c2922cd.webp"
"MediaSize" => 191206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-62fe2b53c05591b1728c21fe8c2922cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30035514_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035514/d3dee19d3b3e85d3bf54bb2e549aac01.webp"
"MediaSize" => 212815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035514/thumbnail-d3dee19d3b3e85d3bf54bb2e549aac01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13565504"
"ResourceRecordKey" => "30035514"
"ModificationTimestamp" => "2026-07-15T14:40:55.98Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035514')"
+"ID": "1627222"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 288501" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24963
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "REVEL REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "289-429-1529"
+"OfficeMlsId": "344702"
+"ModificationTimestamp": "2026-01-06T18:52:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288501"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "336 BRONTE ST S UNIT 225A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MILTON"
+"OfficePostalCode": "L9T6V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1368759"
+"OriginalEntryTimestamp": "2020-09-02T18:10:00Z"
+"OfficeFax": "905-357-1705"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1361986"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('288501')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2104597" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24911
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24944
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2104597"
+"ModificationTimestamp": "2024-10-19T07:00:27Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2104597"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2104597')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30035514'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25255
+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 '30035514' AND OpenHouseDate ge '2026-07-14'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+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 '30035514' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.896456 43.331203)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25324
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1628145"
+post_author: 1
+"ListingKey": "30037921"
+"ListingId": "X13568170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T19:35:18Z"
+"RFModificationTimestamp": "2026-07-15T19:45:38Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "411 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.893998
1 => 43.330366
]
+"Latitude": 43.330366
+"Longitude": -79.893998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 411-30 Hamilton St S, a beautifully maintained corner unit, 1-bedroom condo offering a bright, open-concept layout, modern finishes, 2 parking spaces and an unbeatable location in the heart of Waterdown! Upon entering, you'll notice the stunning kitchen with fresh white cabinetry, sleek quartz counters, high-end S/S appliances, subway tile backsplash & spacious centre island with seating-perfect for casual dining or entertaining friends. The sun-filled living & dining area is framed by oversized windows & sliding glass doors that flood the space with natural light while providing seamless access to private balcony. Whether you're enjoying your morning coffee or unwinding after a long day, it's the perfect outdoor retreat. Spacious bedroom with large window, generous dbl closet & lots of room for a king-sized bed. Stylish 4pc bathroom boasts a modern quartz vanity & tub/shower. In-suite stacked laundry adds everyday convenience. Unit includes 1 underground parking space, an additional surface parking space & ample visitor parking for guests. Enjoy an impressive array of amenities including fully equipped fitness centre, beautifully appointed main-floor & 6th-floor terraces with BBQs & panoramic views, sophisticated party lounge with a library, meeting room, electric vehicle charging station, secure bike storage, pet washing station, impeccably maintained common spaces & convenience of fulltime concierge. Enjoy an unbeatable location with everything at your doorstep. Just 4-min walk away you'll find a shopping plaza with a grocery store, Shoppers Drug Mart, banks, restaurants, cafes & other everyday conveniences. You're also just mins from charming downtown Waterdown, beautiful parks, trails & major highways for effortless commuting. Perfect blend of walkability, convenience & low-maintenance living. Whether you're a first-time buyer, downsizer or investor, this move-in-ready condo offers incredible value in one of Waterdown's most desirable buildings (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "633.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T19:45:29.084434+00:00"
+"Directions": "Barton St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953737"
+"ListOfficeKey": "85454"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T19:29:17Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T19:29:17Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4049.4"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1685217595"
"RoomType" => "Kitchen"
"ListingId" => "X13568170"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "30037921"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T19:29:17.71Z"
]
1 => array:11 [
"RoomKey" => "1685217596"
"RoomType" => "Living room"
"ListingId" => "X13568170"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "30037921"
"RoomLength" => 7.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T19:29:17.71Z"
]
2 => array:11 [
"RoomKey" => "1685217597"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13568170"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "30037921"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T19:29:17.71Z"
]
3 => array:11 [
"RoomKey" => "1685217598"
"RoomType" => "Bathroom"
"ListingId" => "X13568170"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30037921"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T19:29:17.71Z"
]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30037921/411-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2017352"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "85454"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-15T19:29:17.69Z"
+"ListAgentNationalAssociationId": "1246950"
+"ListOfficeNationalAssociationId": "1187906"
+"CoListAgentNationalAssociationId": "1298494"
+"CoListOfficeNationalAssociationId": "1187906"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30037921_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/ba6b112bccacd33b83909e4e643bc993.webp"
"MediaSize" => 134990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-ba6b112bccacd33b83909e4e643bc993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30037921_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/af3da26f149ea0fc45a0ee8d9e2f0f33.webp"
"MediaSize" => 157748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-af3da26f149ea0fc45a0ee8d9e2f0f33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30037921_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/df0991fbc3d14671326eec8306420f14.webp"
"MediaSize" => 158805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-df0991fbc3d14671326eec8306420f14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30037921_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/f22713e1cfc28bd0ab66f5aad8d3c44f.webp"
"MediaSize" => 120653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-f22713e1cfc28bd0ab66f5aad8d3c44f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30037921_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/733333175e81dde29743bf19ab95c4ce.webp"
"MediaSize" => 145243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-733333175e81dde29743bf19ab95c4ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30037921_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/95c13cad8622d9f82d48731671e85084.webp"
"MediaSize" => 147189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-95c13cad8622d9f82d48731671e85084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30037921_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/1b7087358962556d6ab2e79808818bc5.webp"
"MediaSize" => 202182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-1b7087358962556d6ab2e79808818bc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30037921_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/377c9aa40fa93086318434a4ed1089c5.webp"
"MediaSize" => 255970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-377c9aa40fa93086318434a4ed1089c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30037921_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/2f360f90bddcde65a4e97b0f3d899bc3.webp"
"MediaSize" => 177749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-2f360f90bddcde65a4e97b0f3d899bc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30037921_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/ff0fc73748b3686c288c4445c0d648a2.webp"
"MediaSize" => 133898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-ff0fc73748b3686c288c4445c0d648a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30037921_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/41baa2a032174c2298d463956ee927d8.webp"
"MediaSize" => 102124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-41baa2a032174c2298d463956ee927d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30037921_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/094d92d8c99c65c2e96c7d59c525dd87.webp"
"MediaSize" => 108558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-094d92d8c99c65c2e96c7d59c525dd87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30037921_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/00407bd35de5b690a3deb2c80e521b9f.webp"
"MediaSize" => 243721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-00407bd35de5b690a3deb2c80e521b9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30037921_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/1654b572dc64b803fa982d1012485b64.webp"
"MediaSize" => 209889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-1654b572dc64b803fa982d1012485b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30037921_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/68f2395319bbab52d7821ef91d2daaeb.webp"
"MediaSize" => 222667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-68f2395319bbab52d7821ef91d2daaeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30037921_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/8bb2ec3ce825992d5ad4cf520a6c7101.webp"
"MediaSize" => 234989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-8bb2ec3ce825992d5ad4cf520a6c7101.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30037921_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/83cb2ee68692d84de30a3b962d06256a.webp"
"MediaSize" => 274027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-83cb2ee68692d84de30a3b962d06256a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30037921_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/209e3d2a44aa80ec65e7751192731b53.webp"
"MediaSize" => 233024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-209e3d2a44aa80ec65e7751192731b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30037921_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/956287fee80287682db35eea9a6a4bdb.webp"
"MediaSize" => 185669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-956287fee80287682db35eea9a6a4bdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30037921_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/3ae014b2bd04ce026120f2c17d813a85.webp"
"MediaSize" => 198981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-3ae014b2bd04ce026120f2c17d813a85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30037921_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/5893fddb6cf0e428d87eb21ab978e9fc.webp"
"MediaSize" => 209472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-5893fddb6cf0e428d87eb21ab978e9fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30037921_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/e5c3f8705aa78bd5aa3ab9e725e24e8c.webp"
"MediaSize" => 136809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-e5c3f8705aa78bd5aa3ab9e725e24e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30037921_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037921/b3027f0f77f52e7b74c7d9957e3b154f.webp"
"MediaSize" => 225262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037921/thumbnail-b3027f0f77f52e7b74c7d9957e3b154f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13568170"
"ResourceRecordKey" => "30037921"
"ModificationTimestamp" => "2026-07-15T19:29:17.7Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037921')"
+"ID": "1628145"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1627666"
+post_author: 1
+"ListingKey": "30037724"
+"ListingId": "40845258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T19:20:06Z"
+"RFModificationTimestamp": "2026-07-15T19:23:43Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 411, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8938615
1 => 43.330413
]
+"Latitude": 43.330413
+"Longitude": -79.8938615
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 411-30 Hamilton St S, a beautifully maintained corner unit, 1-bedroom condo offering a bright, open-concept layout, modern finishes, 2 parking spaces and an unbeatable location in the heart of Waterdown! Upon entering, you'll notice the stunning kitchen with fresh white cabinetry, sleek quartz counters, high-end S/S appliances, subway tile backsplash & spacious centre island with seating—perfect for casual dining or entertaining friends. The sun-filled living & dining area is framed by oversized windows & sliding glass doors that flood the space with natural light while providing seamless access to private balcony. Whether you're enjoying your morning coffee or unwinding after a long day, it's the perfect outdoor retreat. Spacious bedroom with large window, generous dbl closet & lots of room for a king-sized bed. Stylish 4pc bathroom boasts a modern quartz vanity & tub/shower. In-suite stacked laundry adds everyday convenience. Unit includes 1 underground parking space, an additional surface parking space & ample visitor parking for guests. Enjoy an impressive array of amenities including fully equipped fitness centre, beautifully appointed main-floor & 6th-floor terraces with BBQs & panoramic views, sophisticated party lounge with a library, meeting room, electric vehicle charging station, secure bike storage, pet washing station, impeccably maintained common spaces & convenience of full-time concierge. Enjoy an unbeatable location with everything at your doorstep. Just 4-min walk away you'll find a shopping plaza with a grocery store, Shoppers Drug Mart, banks, restaurants, cafes & other everyday conveniences. You're also just mins from charming downtown Waterdown, beautiful parks, trails & major highways for effortless commuting. Perfect blend of walkability, convenience & low-maintenance living. Whether you're a first-time buyer, downsizer or investor, this move-in-ready condo offers incredible value in one of Waterdown's most desirable buildings (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "633.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T19:15:12.697844+00:00"
+"Directions": "Barton St"
+"ExteriorFeatures": array:4 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
3 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237567"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-15T19:11:53Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T19:18:37Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4049.4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1685204154"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845258"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037724"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T19:18:37.41Z"
]
1 => array:11 [
"RoomKey" => "1685204155"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845258"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037724"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T19:18:37.41Z"
]
2 => array:11 [
"RoomKey" => "1685204156"
"RoomType" => "Living room/Dining room"
"ListingId" => "40845258"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037724"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 24'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T19:18:37.41Z"
]
3 => array:11 [
"RoomKey" => "1685204157"
"RoomType" => "Kitchen"
"ListingId" => "40845258"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037724"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T19:18:37.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30037724/30-hamilton-street-s-unit-411-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-07-15T19:00:03.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1475453"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30037724_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/7dea3effec2b72e64250d5f9c3239310.webp"
"MediaSize" => 71983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037724/thumbnail-7dea3effec2b72e64250d5f9c3239310.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and living area featuring wood-finish flooring, white cabinetry with stainless steel hardware, and a white subway tile backsplash"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845258"
"ResourceRecordKey" => "30037724"
"ModificationTimestamp" => "2026-07-15T19:00:03.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30037724_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/a65442734eb7202001b81b304fcb49a3.webp"
"MediaSize" => 69192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037724/thumbnail-a65442734eb7202001b81b304fcb49a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white shaker cabinetry, stainless steel appliances, light wood-finish flooring, and an island with a light wood countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845258"
"ResourceRecordKey" => "30037724"
"ModificationTimestamp" => "2026-07-15T19:00:03.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30037724_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/06dfa895b125d5aa2349c601f3fbbf98.webp"
"MediaSize" => 57080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037724/thumbnail-06dfa895b125d5aa2349c601f3fbbf98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, wood-finish flooring, and a central island with a wood countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845258"
"ResourceRecordKey" => "30037724"
"ModificationTimestamp" => "2026-07-15T19:00:03.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30037724_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/8f1b0278e64c9c894c278a2a79bd5016.webp"
"MediaSize" => 63847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037724/thumbnail-8f1b0278e64c9c894c278a2a79bd5016.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white shaker cabinetry, stainless steel appliances, a subway tile backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845258"
"ResourceRecordKey" => "30037724"
"ModificationTimestamp" => "2026-07-15T19:00:03.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30037724_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/0ce5b4fcf9ca1509e605f89d0f3e4cf7.webp"
"MediaSize" => 73401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037724/thumbnail-0ce5b4fcf9ca1509e605f89d0f3e4cf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, a center island with a wood-finish countertop, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845258"
"ResourceRecordKey" => "30037724"
"ModificationTimestamp" => "2026-07-15T19:00:03.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30037724_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037724/05814e2bfff25adac27e77b96c3f35be.webp"
"MediaSize" => 69376
"MediaType" => "webp"
…8
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037724')"
+"ID": "1627666"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1626132"
+post_author: 1
+"ListingKey": "30034489"
+"ListingId": "X13564610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T05:10:00Z"
+"RFModificationTimestamp": "2026-07-15T06:45:20Z"
+"ListPrice": 795900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K3"
+"UnparsedAddress": "34 KILDONAN CRESCENT, Hamilton (Waterdown), Ontario L8B0K3"
+"Coordinates": array:2 [
0 => -79.912882
1 => 43.321118
]
+"Latitude": 43.321118
+"Longitude": -79.912882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 34 Kildonan Crescent, a beautifully maintained home situated on a quiet, family-friendly crescent in one of Waterdown's most desirable neighbourhoods. Backing directly ontoscenic trails and green space with no rear neighbours, this property offers exceptionalprivacy and a peaceful natural setting.Inside, you'll find a bright and inviting layout featuring hardwood flooring, pot lightsthroughout, spacious principal rooms, and abundant natural light. The primary bedroom includesa ceiling fan for added comfort. Smart-home enthusiasts will appreciate the impressivetechnology package, including a 15-inch Alexa control centre, smart switches, smart lightingon all levels, and a smart front-door lock with fingerprint entry.Extensively updated and move-in ready, this home features a new patio door (2020), owned airconditioner (2021), renovated washrooms (2022), front door and second-floor windows (2022),energy-efficient main-level windows (2025), a newly reconstructed backyard deck (2025), and anew refrigerator (2025). The furnace, air conditioner, and water heater are all fully owned,providing added value and eliminating rental costs.Step outside to your private backyard retreat overlooking mature greenery and walking trails -perfect for entertaining, relaxing, or enjoying nature year-round. Conveniently located nearparks, schools, shopping, dining, and commuter routes, this meticulously cared-for home offersan exceptional opportunity to enjoy the best of Waterdown living. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T06:45:14.695233+00:00"
+"Directions": "Cross Streets: Dundas Street East & Burke Street. ** Directions: Hwy 403 to Hwy 6 North, exit at Dundas St. E., right on Burke St., left on Kildonan Crescent."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074363"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "26.3 x 133.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T05:03:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T05:03:02Z"
+"Stories": "2.0"
+"StreetName": "Kildonan"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4880.37"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/oNxwtfAeCQA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30034489/34-kildonan-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-07-15T05:03:02.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1349557"
+"ListOfficeNationalAssociationId": "1336201"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034489')"
+"ID": "1626132"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1622277"
+post_author: 1
+"ListingKey": "30029200"
+"ListingId": "X13559688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "904 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 bed, 1 bath condo showcasing a bright, open-concept design with modern finishes throughout. Featuring an upgraded kitchen with stainless steel appliances, a spacious island with built-in storage, and elegant pendant lighting, this unit flows effortlessly into the sun-filled living area with expansive windows and beautiful views. The generous bedroom is complemented by a contemporary 4-piece bath and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Enjoy premium building amenities including a party room, gym, rooftop patios, and bike storage. Ideally located in the sought-after Waterdown community, just minutes to dining, shopping, parks, and a quick 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"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-07-14T06:44:12.429132+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"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:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029200/904-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentia"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.26Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029200')"
+"ID": "1622277"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1622278"
+post_author: 1
+"ListingKey": "30029198"
+"ListingId": "X13559668"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:15:03Z"
+"RFModificationTimestamp": "2026-07-14T06:44:18Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "804 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 1 bed, 1 bath condo offering a bright, open-concept layout with modern finishes throughout. The stylish kitchen features stainless steel appliances, a breakfast bar, and contemporary cabinetry, flowing effortlessly into the spacious living area with large windows and plenty of natural light. The well-sized bedroom offers comfort and great views, complemented by a sleek 4-piece bathroom and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Residents have access to excellent amenities including a party room, gym, rooftop patios, and bike storage. Located in the highly desirable Waterdown community, close to dining, shopping, schools, parks, and just a 5-minute drive to downtown Burlington or Aldershot GO Station. (id:62650)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "Garage door opener remote(s)"
]
+"AssociationFee": "553.7"
+"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-07-14T06:44:11.804722+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Riverwalk Dr."
+"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:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T05:07:37Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T05:07:37Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1184.89"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30029198/804-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-14T05:07:37.08Z"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30029198')"
+"ID": "1622278"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1621732"
+post_author: 1
+"ListingKey": "30028166"
+"ListingId": "X13558984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T22:45:02Z"
+"RFModificationTimestamp": "2026-07-14T01:10:34Z"
+"ListPrice": 849999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "205 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.912066
1 => 43.335242
]
+"Latitude": 43.335242
+"Longitude": -79.912066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spacious freehold end-unit townhouse offering approximately 1,890 sq. ft. ofbeautifully maintained living space in the heart of Waterdown.Designed for both comfortable everyday living and effortless entertaining, this bright open-concept home features large windows that fill the space with natural light while showcasingpeaceful views of the private backyard oasis.Step outside and enjoy the serene backyard backing onto a school - an ideal setting forfamilies seeking a safe, family-friendly neighbourhood with added privacy and convenience.The second floor offers 3 spacious bedrooms, including a generous primary suite complete witha walk-in closet, additional his closet, and a private ensuite bathroom. A second full bathroom provides added comfort for family and guests.Ideally located within walking distance to all schools from kindergarten through Grade 12, aswell as parks, shopping, dining, and the community centre. Commuters will appreciate the easyaccess to Hwy 6, 403, 407, the QEW, and Aldershot GO Station.This gorgeous townhouse presents an incredible opportunity for first-time home buyers, growing families, or anyone looking to settle into one of Waterdown's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T01:10:25.622227+00:00"
+"Directions": "Nisbet Blvd and Cathedral CRT"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055502"
+"ListOfficeKey": "277399"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T22:38:23Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T22:38:23Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "205"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5601"
+"View": "View"
+"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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30028166/205-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-13T22:38:23.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1330819"
+"ListOfficeNationalAssociationId": "1282815"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028166')"
+"ID": "1621732"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1620942"
+post_author: 1
+"ListingKey": "30027846"
+"ListingId": "X13558740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T14:50:06Z"
+"RFModificationTimestamp": "2026-07-15T14:54:16Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.891184
1 => 43.331196
]
+"Latitude": 43.331196
+"Longitude": -79.891184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:43:18.555618+00:00"
+"Directions": "Cross Streets: Flamboro St. and Barton St. ** Directions: Take Highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Flat site"
3 => "Carpet Free"
]
+"LotSizeDimensions": "68.1 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T21:40:18Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T14:40:50Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30027846/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-13T21:40:18.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T13:55:22Z"
+"RFModificationTimestamp": "2026-07-15T13:57:31Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8912452
1 => 43.3312034
]
+"Latitude": 43.3312034
+"Longitude": -79.8912452
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T21:46:37.455766+00:00"
+"Directions": "Take highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024789"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-13T21:18:11Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T13:48:40Z"
+"Stories": "1.0"
+"StreetName": "FLAMBORO"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027582/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2026-07-13T21:18:11.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304516"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063598"
+"CoListOfficeNationalAssociationId": "1325425"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1619363"
+post_author: 1
+"ListingKey": "30025665"
+"ListingId": "X13556592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T12:20:11Z"
+"RFModificationTimestamp": "2026-07-14T12:27:22Z"
+"ListPrice": 1579990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H9"
+"UnparsedAddress": "156 NISBET BOULEVARD, Hamilton (Waterdown), Ontario L0R2H9"
+"Coordinates": array:2 [
0 => -79.911159
1 => 43.336589
]
+"Latitude": 43.336589
+"Longitude": -79.911159
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set in a quiet, established Waterdown neighbourhood just down the street from Allan A. Greenleaf Elementary & Waterdown District High School, this beautifully cared-for home offers the kind of location, quality, and lifestyle that families rarely find all in one place. Inside, every space reflects pride of ownership and thoughtful investment. The custom 2025 kitchen sets the tone with tailored cabinetry, quartz counters, royal brass hardware, under-cabinet lighting, custom storage, a built-in bay-window bench, and a chef's island with wraparound seating that naturally becomes the heart of the home. Elegant living & dining areas, a renovated powder room, and a custom laundry room continue the refined main-floor feel. The mid-level family room is a standout retreat with a custom media wall, Napoleon electric fireplace, built-in cabinetry, a 75" LG TV, and a walkout to a covered front balcony. Upstairs, the primary suite features a double-door entry, dual walk-in closets and a beautifully renovated 5-piece ensuite. The impeccably finished lower level adds 1025 square feet of impressive flexibility with a large rec room, den or guest space, luxurious second kitchen, second laundry area, 5-pc spa-inspired bathroom, oversized walk-in closet, and above-grade windows. Out back, the property transforms into a private resort. A heated saltwater pool with a sheer-descent waterfall, interlocking patio, mature trees, landscape irrigation, and lounging & entertaining zones create an outdoor setting designed for summer days, quiet evenings, and unforgettable gatherings. Major recent updates include a $70,000 Nordik windows & doors package in 2025 with triple-pane glass & a 25-year transferable warranty; a high-efficiency furnace in 2023; a Jandy pool heater in 2025 & iAquaLink pool control. This is a home that needs to be experienced in person to fully appreciate the quality, care, and attention found in every detail. (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Cooktop"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:25:19.484551+00:00"
+"Directions": "Cross Streets: Hamilton St N/Parkside Dr. ** Directions: Hamilton St N to Nisbet Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959027"
+"ListOfficeKey": "50325"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Carpet Free"
4 => "Gazebo"
]
+"LotSizeDimensions": "48.8 x 88.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:08Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T12:07:04Z"
+"Stories": "2.0"
+"StreetName": "Nisbet"
+"StreetNumber": "156"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "8495"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/156_nisbet_blvd_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025665/156-nisbet-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1962563"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50325"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 48.9
+"OriginalEntryTimestamp": "2026-07-13T16:40:08.57Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249697"
+"ListOfficeNationalAssociationId": "1285004"
+"CoListAgentNationalAssociationId": "1252070"
+"CoListOfficeNationalAssociationId": "1285004"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025665')"
+"ID": "1619363"
}
]
+success: true
+page_size: 9
+page_count: 22
+count: 193
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]