array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29802175 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1457562"
+post_author: 1
+"ListingKey": "29802175"
+"ListingId": "X13171758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T11:50:26Z"
+"RFModificationTimestamp": "2026-06-08T11:51:31Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "322 - 262 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.896393
1 => 43.330174
]
+"Latitude": 43.330174
+"Longitude": -79.896393
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Stunning, renovated, and thoughtfully designed, this spacious suite offers a dream layout with stylish, chic upgrades at every turn. Sun-filled and beautifully appointed, the open concept living and dining area is anchored by a board and batten fireplace feature wall with an electric fireplace, custom built-in shelving, office nook and grand living space. Wide plank oak-inspired laminate flooring runs throughout, tying the space together with a clean, modern feel. Double sliding doors open to a private north-facing balcony, bringing in natural light. The kitchen was fully custom-designed and features quartz countertops, a tile backsplash, white cabinetry, an undermount double sink, stainless steel appliances, and upgraded lighting. Polished and well-equipped for everyday cooking with a customized island breakfast bar/dining area to gather around. The primary bedroom is generously sized with an oversized window and a double door closet. The bathroom was renovated to match with patterned tile flooring, a custom glass shower door, upgraded wall tile, a custom vanity, and updated fixtures throughout. Storage is a standout. The spacious foyer includes a double sliding door entry closet, a linen/pantry-style closet, and an additional hallway storage closet, all with upgraded trim and casings. The oversized laundry and utility room adds even more flexibility with a utility sink and ample additional storage. Double sliding doors open to a private north-facing balcony, bringing in natural light overlooking everyday amenities within walking distance. This is a move-in ready home that delivers genuine value. A turn-the-key-and-unpack opportunity that doesn't come along often. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "728.68"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T20:52:50.660840+00:00"
+"Directions": "Cross Streets: HAMILTON ST. ** Directions: Hamilton St N to Dundas St E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955536"
+"ListOfficeKey": "205316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-05-25T20:26:24Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T11:35:20Z"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3222.3"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/videos/019d0843-5688-7326-9eff-4b560ee545c3?v=221"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1654851786"
"RoomType" => "Foyer"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29802175"
"RoomLength" => 1.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
1 => array:11 [
"RoomKey" => "1654851787"
"RoomType" => "Kitchen"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29802175"
"RoomLength" => 1.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
2 => array:11 [
"RoomKey" => "1654851788"
"RoomType" => "Living room"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 5.64
"ListingKey" => "29802175"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
3 => array:11 [
"RoomKey" => "1654851789"
"RoomType" => "Bathroom"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29802175"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
4 => array:11 [
"RoomKey" => "1654851790"
"RoomType" => "Bedroom"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29802175"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
5 => array:11 [
"RoomKey" => "1654851791"
"RoomType" => "Utility room"
"ListingId" => "X13171758"
"RoomLevel" => "Main level"
"RoomWidth" => 2.21
"ListingKey" => "29802175"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:35:20.03Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29802175/322-262-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2227828"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD MANAGEMENT INC."
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Fireplace(s)"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-05-25T20:26:24.87Z"
+"ListAgentNationalAssociationId": "1247407"
+"ListOfficeNationalAssociationId": "1264489"
+"CoListAgentNationalAssociationId": "1470830"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29802175_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/eab3b488e848b37febae8dfe9c7b846f.webp"
"MediaSize" => 122437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-eab3b488e848b37febae8dfe9c7b846f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29802175_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/c019e0b77e183bd7ef9be7ecce378a97.webp"
"MediaSize" => 77842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-c019e0b77e183bd7ef9be7ecce378a97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29802175_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/bb5e98224ec9d44c31db9506b1920b47.webp"
"MediaSize" => 72054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-bb5e98224ec9d44c31db9506b1920b47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29802175_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/2c1a8b03b5a6a4dec76a731e09ee9d92.webp"
"MediaSize" => 81563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-2c1a8b03b5a6a4dec76a731e09ee9d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29802175_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/a6a748571342b9bfcb32c8b876126cf6.webp"
"MediaSize" => 79785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-a6a748571342b9bfcb32c8b876126cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29802175_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/43a3016ac40cc57ced26678c8bc7eeac.webp"
"MediaSize" => 83865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-43a3016ac40cc57ced26678c8bc7eeac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29802175_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/4827a5165e6618044d37f0690b972452.webp"
"MediaSize" => 68781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-4827a5165e6618044d37f0690b972452.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29802175_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/e17bd4d83e5bc4b3543db3b25dcabc2c.webp"
"MediaSize" => 63590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-e17bd4d83e5bc4b3543db3b25dcabc2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29802175_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/f2885dd077e2e2358d1b74400ad888b2.webp"
"MediaSize" => 79483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-f2885dd077e2e2358d1b74400ad888b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29802175_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/0bb9def584f183c8f78c2024049ca19c.webp"
"MediaSize" => 64860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-0bb9def584f183c8f78c2024049ca19c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29802175_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/f904d76a9b37de9df32bbd4322c2dd8c.webp"
"MediaSize" => 69877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-f904d76a9b37de9df32bbd4322c2dd8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29802175_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/a3d9937617b82c53b48761dc65d1ef60.webp"
"MediaSize" => 58094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-a3d9937617b82c53b48761dc65d1ef60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29802175_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/07753ea824b7b70e5b02fa2994dda9e2.webp"
"MediaSize" => 62575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-07753ea824b7b70e5b02fa2994dda9e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29802175_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/c52907cd1f9ca66522f9061e7abfc9d4.webp"
"MediaSize" => 98179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-c52907cd1f9ca66522f9061e7abfc9d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29802175_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/e22e8dc95a2cec4e87f633956934c0b7.webp"
"MediaSize" => 89345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-e22e8dc95a2cec4e87f633956934c0b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29802175_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29802175/3caa049cdc64c50e169bd0913e63493d.webp"
"MediaSize" => 81102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29802175/thumbnail-3caa049cdc64c50e169bd0913e63493d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13171758"
"ResourceRecordKey" => "29802175"
"ModificationTimestamp" => "2026-05-25T20:26:24.88Z"
]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29802175')"
+"ID": "1457562"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 205316" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24755
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1955536" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24728
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29802175'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25045
+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 '29802175'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25063
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25061
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31285128"
+"ListingKey": "29802175"
+"ListingId": "X13171758"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-08T03:59:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31285128')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29802175' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.896393 43.330174)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25110
+post_id: "1534315"
+post_author: 1
+"ListingKey": "29909863"
+"ListingId": "X13450332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:40Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "1001 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.880553
1 => 43.342598
]
+"Latitude": 43.342598
+"Longitude": -79.880553
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "STUNNING UNOBSTRUCTED ESCARPMENT VIEWS! Welcome to one of the building's most desirable floorplans - the only 1-bedroom PLUS oversized den design PLUS 2 bathrooms, thoughtfully laid out across almost 800 square feet of upscale living. An impressive upgrade package, exceptional functionality, and breathtaking views combine to create a residence that truly stands apart. The stylish kitchen blends beauty and practicality with upgraded stainless steel appliances, built-in microwave/ventilation, upgraded quartz countertops, designer backsplash, ceiling-height mist grey cabinetry with brushed stainless hardware, and a breakfast bar comfortably seating 3-4 guests. Wake each morning to captivating escarpment views from the spacious primary retreat, complete with a generous walk-in closet and beautifully appointed 4-piece ensuite. The oversized den offers exceptional versatility as a sophisticated home office, guest retreat, media lounge or 2nd Bedroom! Additional highlights include 9-foot ceilings, modern blond-toned flooring, designer lighting, separate walk-in laundry closet, and elevated finishes throughout. Residents enjoy an impressive collection of amenities including a stylish community/games room, private theatre, bike storage, and a spectacular rooftop terrace with BBQs for effortless entertaining. Perfectly positioned just minutes to the GO Train, major highways, parks, trails, shopping, and dining, this address delivers exceptional convenience and connectivity. A rare opportunity to own a beautifully upgraded residence that offers the lifestyle, layout, and unforgettable views! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "666.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:30.196972+00:00"
+"Directions": "Dundas/Riverwalk"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1965478"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Open space"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:55Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:55Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1660529758"
"RoomType" => "Great room"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29909863"
"RoomLength" => 5.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
1 => array:11 [
"RoomKey" => "1660529759"
"RoomType" => "Kitchen"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29909863"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
2 => array:11 [
"RoomKey" => "1660529760"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "29909863"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
3 => array:11 [
"RoomKey" => "1660529761"
"RoomType" => "Den"
"ListingId" => "X13450332"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29909863"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:59:55.15Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909863/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Ressidential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.12Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909863')"
+"ID": "1534315"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25112
+post_id: "1532846"
+post_author: 1
+"ListingKey": "29907463"
+"ListingId": "40839864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:15:03Z"
+"RFModificationTimestamp": "2026-06-16T00:38:53Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 614.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1008, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8797837
1 => 43.3431877
]
+"Latitude": 43.3431877
+"Longitude": -79.8797837
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained, move-in ready condo offering modern style and exceptional convenience from the 10th floor. This bright and spacious 1 bedroom plus den suite features an open-concept layout with floor-to-ceiling windows, freshly painted interiors, and breathtaking unobstructed views that fill the home with natural light. The contemporary kitchen is designed for both everyday living and entertaining, showcasing quartz countertops, stainless steel appliances, ample cabinetry, and a functional breakfast bar overlooking the living space. The versatile den is perfect for a home office, guest room, or additional flex space, while the spacious bedroom offers comfort and functionality. Enjoy your private balcony with spectacular panoramic views, creating the perfect place to unwind morning or night. This well-maintained suite is ideal for first-time buyers, downsizers, or investors looking for a truly turn-key opportunity. Residents enjoy outstanding building amenities including a fitness centre, party room, rooftop terrace, concierge services, bike storage, EV charging, and visitor parking. Ideally located in the heart of Waterdown, you're just minutes from Highway 403, the QEW, Aldershot GO Station, shopping, restaurants, parks, scenic trails, and all everyday amenities, offering the perfect balance of convenience and lifestyle. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "340.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T00:38:48.464749+00:00"
+"Directions": "Dundas St / Riverwalk Dr"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-15T23:09:52Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:09:52Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3043"
+"VirtualTourURLUnbranded": "https://youtu.be/Y_21zv3G7GQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660191163"
"RoomType" => "Bedroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
1 => array:11 [
"RoomKey" => "1660191164"
"RoomType" => "Living room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
2 => array:11 [
"RoomKey" => "1660191165"
"RoomType" => "Kitchen"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
3 => array:11 [
"RoomKey" => "1660191166"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
4 => array:11 [
"RoomKey" => "1660191167"
"RoomType" => "Laundry room"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 3'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
5 => array:11 [
"RoomKey" => "1660191168"
"RoomType" => "Den"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
6 => array:11 [
"RoomKey" => "1660191169"
"RoomType" => "Foyer"
"ListingId" => "40839864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29907463"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T23:09:52.44Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29907463/460-dundas-street-e-unit-1008-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-15T23:09:52.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29907463_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"MediaSize" => 125183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-afc03f9d8e622b9fe1b4d6a6da7f966f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29907463_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/bc72356ac79f3b2264abc6d6824b3c9f.webp"
"MediaSize" => 83469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-bc72356ac79f3b2264abc6d6824b3c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29907463_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/44e06bde779f22ba91ef5fe6bfd071a2.webp"
"MediaSize" => 70999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-44e06bde779f22ba91ef5fe6bfd071a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29907463_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/16faeb112a8ecdf073013779b7fa044c.webp"
"MediaSize" => 33797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-16faeb112a8ecdf073013779b7fa044c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29907463_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b64d666be7a70cacaf5764a78510c43e.webp"
"MediaSize" => 31970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b64d666be7a70cacaf5764a78510c43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29907463_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b4875166552e3987d0b6ca8975220ef3.webp"
"MediaSize" => 60275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b4875166552e3987d0b6ca8975220ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29907463_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c8328b8fe00053fc69cf99a29698ae25.webp"
"MediaSize" => 28752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c8328b8fe00053fc69cf99a29698ae25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29907463_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/3511a34a5512ea881f3eb2283c9659a6.webp"
"MediaSize" => 55615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-3511a34a5512ea881f3eb2283c9659a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29907463_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/66bfba3bb27dcc15a888079a79d23a6c.webp"
"MediaSize" => 44723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-66bfba3bb27dcc15a888079a79d23a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29907463_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/d716111056d499c6858d90b084ed8f01.webp"
"MediaSize" => 45201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-d716111056d499c6858d90b084ed8f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29907463_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/c40438d66bc845bda83dc577a8f882b9.webp"
"MediaSize" => 51644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-c40438d66bc845bda83dc577a8f882b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29907463_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/ae43d9dd755aca838c645f5f83019c54.webp"
"MediaSize" => 51828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-ae43d9dd755aca838c645f5f83019c54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29907463_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/29b23854631b492bd400a40f5fe1076d.webp"
"MediaSize" => 64988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-29b23854631b492bd400a40f5fe1076d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29907463_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/0ca889e8432546151b5628ef398833ac.webp"
"MediaSize" => 48080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-0ca889e8432546151b5628ef398833ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29907463_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/7cf8d9135d48d65d18af5cba66e4ca79.webp"
"MediaSize" => 53801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-7cf8d9135d48d65d18af5cba66e4ca79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29907463_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/75df499fa02d9839a549139e71fc7461.webp"
"MediaSize" => 60787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-75df499fa02d9839a549139e71fc7461.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29907463_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/96acb36800b02e669fb5b275a8145a8f.webp"
"MediaSize" => 67297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-96acb36800b02e669fb5b275a8145a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29907463_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/441b3228be554b100786231740da215e.webp"
"MediaSize" => 54996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-441b3228be554b100786231740da215e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29907463_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/add99a36aea6fdfed1986ab02505c47e.webp"
"MediaSize" => 32441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-add99a36aea6fdfed1986ab02505c47e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29907463_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/e36c686937b2c82cf4e9b080c202171e.webp"
"MediaSize" => 112411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-e36c686937b2c82cf4e9b080c202171e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29907463_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/cc75075e3616ea7233b8b75fbf59c0f2.webp"
"MediaSize" => 110761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-cc75075e3616ea7233b8b75fbf59c0f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29907463_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/b41fb85b7f86a0313c5efd91892ee8f5.webp"
"MediaSize" => 105368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-b41fb85b7f86a0313c5efd91892ee8f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29907463_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/5c436960b6bc8c8b993ed1429528d197.webp"
"MediaSize" => 111950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-5c436960b6bc8c8b993ed1429528d197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29907463_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/268b4e06cb6165217bcd385ce38e62ac.webp"
"MediaSize" => 112034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-268b4e06cb6165217bcd385ce38e62ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29907463_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/a241f9a60300ad90da14e16524a5add0.webp"
"MediaSize" => 85916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-a241f9a60300ad90da14e16524a5add0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29907463_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/86bd90a5fcd56c08e59582935ab9b7ac.webp"
"MediaSize" => 85487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-86bd90a5fcd56c08e59582935ab9b7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29907463_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/e9a2c9c3e8ecaae417a13b4aa0cec905.webp"
"MediaSize" => 90870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-e9a2c9c3e8ecaae417a13b4aa0cec905.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29907463_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/a288b2d9a664c36660f2363253c688d8.webp"
"MediaSize" => 92779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-a288b2d9a664c36660f2363253c688d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29907463_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/f062e8ed75bd28cd0047018222616ecc.webp"
"MediaSize" => 120739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-f062e8ed75bd28cd0047018222616ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29907463_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/26652347cffe3dc6939ee02b6fa3c1dd.webp"
"MediaSize" => 120473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-26652347cffe3dc6939ee02b6fa3c1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29907463_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/f402d6705581b599ac10bcd2e7fafcac.webp"
"MediaSize" => 125796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-f402d6705581b599ac10bcd2e7fafcac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29907463_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29907463/6cdb2613e12b66e1aeea04d3bdecf67c.webp"
"MediaSize" => 132102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29907463/thumbnail-6cdb2613e12b66e1aeea04d3bdecf67c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839864"
"ResourceRecordKey" => "29907463"
"ModificationTimestamp" => "2026-06-15T23:09:52.41Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907463')"
+"ID": "1532846"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25109
+post_id: "1531843"
+post_author: 1
+"ListingKey": "29905680"
+"ListingId": "X13446596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS CRESCENT, Hamilton (Waterdown), Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.892899
1 => 43.326881
]
+"Latitude": 43.326881
+"Longitude": -79.892899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on one of Waterdown's most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well-proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard and private, tranquil green space. Enjoy summer evenings on the expansive composite deck, gather with friends friend and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town's most sought-after areas. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:35.932384+00:00"
+"Directions": "Cross Streets: Howard Blvd. ** Directions: South of Dundas St E on Howard Blvd, turn ontoMays Cres."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101938"
+"ListOfficeKey": "288807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "72.2 x 196.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:52Z"
+"Stories": "2.0"
+"StreetName": "Mays"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9061.67"
+"VirtualTourURLUnbranded": "https://listings.webbify.ca/5-Mays-Crescent-Hamilton-ON-L8B-0G4-Canada"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905680/5-mays-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 72.2
+"OriginalEntryTimestamp": "2026-06-15T18:56:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371767"
+"ListOfficeNationalAssociationId": "1371723"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905680_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/2a3f8a21c66e27b2674c8b6fbdb11977.webp"
"MediaSize" => 414273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-2a3f8a21c66e27b2674c8b6fbdb11977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905680_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e9a32890e0b7a5a7bff9f8a86df33f8d.webp"
"MediaSize" => 312810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e9a32890e0b7a5a7bff9f8a86df33f8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905680_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/37af27a6b2e13890a6bd58ee807d76e1.webp"
"MediaSize" => 472469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-37af27a6b2e13890a6bd58ee807d76e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905680_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e8b51619c9e641a165de6307fe60a4a5.webp"
"MediaSize" => 314099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e8b51619c9e641a165de6307fe60a4a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905680_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/c8aa48c00f777812b2fd00800bd8eadc.webp"
"MediaSize" => 451569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-c8aa48c00f777812b2fd00800bd8eadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905680_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/1fc3bbe9459e7d5398405cb2502fd979.webp"
"MediaSize" => 341600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-1fc3bbe9459e7d5398405cb2502fd979.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446596"
"ResourceRecordKey" => "29905680"
"ModificationTimestamp" => "2026-06-15T18:56:52.52Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905680_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905680/e27514a867c781cbc1473d246f560524.webp"
"MediaSize" => 176499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905680/thumbnail-e27514a867c781cbc1473d246f560524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905680')"
+"ID": "1531843"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25113
+post_id: "1531736"
+post_author: 1
+"ListingKey": "29905626"
+"ListingId": "40830994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:00:17Z"
+"RFModificationTimestamp": "2026-06-15T21:51:19Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2804.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK Place, Waterdown, Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.9103799
1 => 43.3224782
]
+"Latitude": 43.3224782
+"Longitude": -79.9103799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous “site lines” enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer’s dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:51:15.502458+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1751064"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:52:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:52:03Z"
+"Stories": "2.0"
+"StreetName": "FENWICK"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7011.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/17_fenwick_pl_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905626/17-fenwick-place-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1950
+"BelowGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2026-06-15T18:52:03.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1181610"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905626')"
+"ID": "1531736"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25111
+post_id: "1531326"
+post_author: 1
+"ListingKey": "29906158"
+"ListingId": "X13446970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:17Z"
+"RFModificationTimestamp": "2026-06-15T20:56:18Z"
+"ListPrice": 1419000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H5"
+"UnparsedAddress": "17 FENWICK PLACE, Hamilton (Waterdown), Ontario L0R2H5"
+"Coordinates": array:2 [
0 => -79.910126
1 => 43.322235
]
+"Latitude": 43.322235
+"Longitude": -79.910126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 17 Fenwick Place, located in the highly desirable West Waterdown neighbourhood, close to parks, shopping, transit, and major commuter routes. These gorgeous "site lines" enhance this beautifully updated home. Offering 2817 sq ft. 4+1 bedrooms and 2+2 bathrooms, combining style, comfort, and functionality throughout. Freshly painted and tastefully finished, the home features a stunning designer kitchen with Neolith Mont Blanc countertops and backsplash, complemented by custom black and walnut cabinetry. Elegant white oak hardwood flooring flows through the main and upper levels, while the finished basement features durable Pergo vinyl flooring. The home also offers modern, spa-inspired bathrooms, multiple walk-in closets, and a convenient laundry/mudroom. Additional highlights include dual shade window coverings, California shutters on the main and lower levels, and thoughtfully designed custom built-ins throughout. The bright, fully finished basement extends the living space with a cozy gas fireplace and a walkout to the backyard. Step outside to a private, fully fenced yard, an entertainer's dream featuring a heated saltwater pool and plenty of space to relax and unwind. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:56:14.701422+00:00"
+"Directions": "Hollybush/Fenwick"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981607"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 121.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:46Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:01Z"
+"Stories": "2.0"
+"StreetName": "Fenwick"
+"StreetNumber": "17"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7011"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17_fenwick_pl_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906158/17-fenwick-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-8"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:46.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267040"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906158')"
+"ID": "1531326"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25106
+post_id: "1530966"
+post_author: 1
+"ListingKey": "29904850"
+"ListingId": "40839710"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:00:17Z"
+"RFModificationTimestamp": "2026-06-15T19:26:25Z"
+"ListPrice": 1689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.33
+"LivingArea": 3344.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0G4"
+"UnparsedAddress": "5 MAYS Crescent, Waterdown, Ontario L8B0G4"
+"Coordinates": array:2 [
0 => -79.8932325
1 => 43.3271885
]
+"Latitude": 43.3271885
+"Longitude": -79.8932325
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on one of Waterdown’s most coveted streets, this exceptional 3-bedroom, 2.5-bathroom home offers over 3,300 SF of beautifully finished living space, a walk-out lower-level, all backing onto breathtakingly serene green space. Thoughtfully updated throughout, the home features an upgraded kitchen designed for both everyday living and entertaining, complemented by premium flooring and spacious principal rooms that are flooded with natural light thanks to its Western exposure. The top floor features 3 well- proportioned bedrooms, including a primary with an oversized, updated ensuite with soaker tub and glass-enclosed shower. The walkout lower-level seamlessly connects indoor and outdoor, leading to an incredible backyard with multiple living spaces to enjoy the oversized yard as well as the private, tranquil green space behind. Enjoy summer evenings on the expansive composite deck, gather with friends and family on the lower patio, or simply relax and take in the peaceful views and calming privacy. Combining quality upgrades, generous living space, and an outstanding setting, this is a rare opportunity to own a home in one of the town’s most sought-after areas. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:26:11.527080+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032649"
+"ListOfficeKey": "286831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.33"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:51:41Z"
+"Stories": "2.0"
+"StreetName": "MAYS"
+"StreetNumber": "5"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9061.67"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904850/5-mays-crescent-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 2098
+"BelowGradeFinishedArea": 1246
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1309851"
+"ListOfficeNationalAssociationId": "1364228"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904850')"
+"ID": "1530966"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1530774"
+post_author: 1
+"ListingKey": "29905119"
+"ListingId": "X13446180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:05:15Z"
+"RFModificationTimestamp": "2026-06-15T18:25:09Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7C5"
+"UnparsedAddress": "37 MELISSA CRESCENT, Hamilton (Waterdown), Ontario L9H7C5"
+"Coordinates": array:2 [
0 => -79.905585
1 => 43.32541
]
+"Latitude": 43.32541
+"Longitude": -79.905585
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully renovated bungalow nestled on a quiet, highly sought-after crescent in the heart of Waterdown. Offering over 2,500 sq. ft. of finished living space, this fully renovated, turn-key home features 3+1 bedrooms and 2 full bathrooms, thoughtfully updated with quality finishes and timeless style throughout. The bright and inviting main level offers large rooms designed for comfortable everyday living, while the fully finished lower level provides versatile additional space for family, guests, a home office, or recreation. Step outside to your private backyard retreat, complete with a hot tub, and a large tiered deck perfect for entertaining, outdoor dining, and enjoying warm summer evenings. Located within walking distance to scenic trails, parks, and Waterdown's vibrant downtown core, this home offers the perfect balance of nature, convenience, and community. A rare opportunity to own a move-in-ready bungalow in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:24:46.422319+00:00"
+"Directions": "Cross Streets: Scott Street. ** Directions: Riley St to Scott St to Melissa Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"LotSizeDimensions": "55 x 119 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:58:08Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:58:08Z"
+"Stories": "1.0"
+"StreetName": "Melissa"
+"StreetNumber": "37"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7384"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/-My3LeJd9kI"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905119/37-melissa-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"OriginalEntryTimestamp": "2026-06-15T17:58:08.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1355945"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905119')"
+"ID": "1530774"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25114
+post_id: "1530367"
+post_author: 1
+"ListingKey": "29904015"
+"ListingId": "40839637"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:35:28Z"
+"RFModificationTimestamp": "2026-06-15T17:57:30Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2660.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7C5"
+"UnparsedAddress": "37 MELISSA Crescent, Waterdown, Ontario L9H7C5"
+"Coordinates": array:2 [
0 => -79.9054306
1 => 43.3255289
]
+"Latitude": 43.3255289
+"Longitude": -79.9054306
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated bungalow nestled on a quiet, highly sought-after crescent in the heart of Waterdown. Offering over 2,500 sq. ft. of finished living space, this fully renovated, turn-key home features 3+1 bedrooms and 2 full bathrooms, thoughtfully updated with quality finishes and timeless style throughout. The bright and inviting main level offers large rooms designed for comfortable everyday living, while the fully finished lower level provides versatile additional space for family, guests, a home office, or recreation. Step outside to your private backyard retreat, complete with a hot tub, and a large tiered deck perfect for entertaining, outdoor dining, and enjoying warm summer evenings. Located within walking distance to scenic trails, parks, and Waterdown's vibrant downtown core, this home offers the perfect balance of nature, convenience, and community. A rare opportunity to own a move-in-ready bungalow in one of Waterdown's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T17:29:31.396162+00:00"
+"Directions": "Riley St to Scott St to Melissa Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:12:37Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:10:45Z"
+"Stories": "1.0"
+"StreetName": "MELISSA"
+"StreetNumber": "37"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "7384"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/-My3LeJd9kI?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904015/37-melissa-crescent-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1500
+"BelowGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2026-06-15T16:11:56.41Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204077"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904015')"
+"ID": "1530367"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25115
+post_id: "1524109"
+post_author: 1
+"ListingKey": "29896100"
+"ListingId": "X13437788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:05:09Z"
+"RFModificationTimestamp": "2026-06-16T16:10:28Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "36 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907654
1 => 43.328335
]
+"Latitude": 43.328335
+"Longitude": -79.907654
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to own a detached 3-bedroom family home in one of Waterdown's most sought-after neighbourhoods. Located directly across from Guy B. Brown Elementary School, a highly regarded school offering a French Immersion program, this home is perfect for young families looking to put down roots in a fantastic community.Offering solid bones and endless potential, this property is an ideal opportunity for buyers looking to renovate, personalize, and build equity in their forever home. Enjoy a family-friendly location, and the chance to create a space that truly reflects your style and needs.Conveniently located close to parks, trails, shopping, restaurants, and all the amenities Waterdown has to offer, this is your chance to get into a detached home in a premium location for under $800,000. Don't miss this incredible opportunity to unlock the potential of this family home and make it your own (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:24:02.957529+00:00"
+"Directions": "Cross Streets: Parkside Dr. ** Directions: Parkside Drive to Braeheid Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024918"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:38Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:41Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "36"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5126"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/36-Braeheid-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896100/36-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-06-12T17:01:38.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304615"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896100')"
+"ID": "1524109"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 188
+after_key: ""
}
"RF Response Time" => "0.34 seconds"
]
]