array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29076270 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "939043"
+post_author: 1
+"ListingKey": "29076270"
+"ListingId": "40786306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-09T23:10:22Z"
+"RFModificationTimestamp": "2026-02-09T23:16:03Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 545.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 811, Waterdown, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8794513
1 => 43.34297919
]
+"Latitude": 43.34297919
+"Longitude": -79.8794513
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Modern condo 545sf + 59sf Balcony one-bedroom condo offers the perfect blend of comfort, versatility, and location in a highly desirable area. Built by the award winning New Horizon Development Group. This unit features numerous upgrades throughout, including a balcony with the best exposure in the building. Also, modern appliances and stylish finishes, the unit provides a contemporary living experience. Situated in a prime location, residents enjoy convenient access to amenities, public transportation, and the vibrant offerings of the neighborhood. Whether looking for a cozy urban retreat or a functional space, this condo presents an excellent opportunity for both homeowners and investors seeking quality and convenience. Geothermal heating & cooling, includes 1 parking spot and 1 locker. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFee": "341.2"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-06T23:10:17.720065+00:00"
+"Directions": "Dundas to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007886"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-11-06T18:59:48Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-02-09T22:51:36Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2300"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1571663060"
"RoomType" => "4pc Bathroom"
"ListingId" => "40786306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29076270"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-02-09T22:51:36.93Z"
]
1 => array:11 [
"RoomKey" => "1571663061"
"RoomType" => "Foyer"
"ListingId" => "40786306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29076270"
"RoomLength" => null
"RoomDimensions" => "3'4'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-02-09T22:51:36.93Z"
]
2 => array:11 [
"RoomKey" => "1571663062"
"RoomType" => "Living room"
"ListingId" => "40786306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29076270"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-02-09T22:51:36.93Z"
]
3 => array:11 [
"RoomKey" => "1571663063"
"RoomType" => "Kitchen"
"ListingId" => "40786306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29076270"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-02-09T22:51:36.93Z"
]
4 => array:11 [
"RoomKey" => "1571663064"
"RoomType" => "Primary Bedroom"
"ListingId" => "40786306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29076270"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-02-09T22:51:36.93Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29076270/470-dundas-street-e-unit-811-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "0"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 545
+"OriginalEntryTimestamp": "2025-11-06T18:59:48.16Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1289860"
+"ListOfficeNationalAssociationId": "1114492"
+"Media": array:33 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6299266714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/39afd9911c1a9b4ccb31f2704f6cb45d.webp"
"MediaSize" => 87908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-39afd9911c1a9b4ccb31f2704f6cb45d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6299266743"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/42bf42f208300481fd0dd29534c86bde.webp"
"MediaSize" => 63578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-42bf42f208300481fd0dd29534c86bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6299266753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/4dd59a2283de6018850e95d734bc26c7.webp"
"MediaSize" => 61334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-4dd59a2283de6018850e95d734bc26c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6299266837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/c3b668f6c63c2fb9420e900a35d30564.webp"
"MediaSize" => 66514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-c3b668f6c63c2fb9420e900a35d30564.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6299266912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/b4f76b4b6e51d427dee29854cddb242e.webp"
"MediaSize" => 70573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-b4f76b4b6e51d427dee29854cddb242e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6299266935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/93f8a9a1002aa8af9cac432f499f266a.webp"
"MediaSize" => 55370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-93f8a9a1002aa8af9cac432f499f266a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6299267002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/5a016e67aa65b385faa1b6930151baff.webp"
"MediaSize" => 49576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-5a016e67aa65b385faa1b6930151baff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6299267039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/9332bf2260904a68393cef3ccb17f31f.webp"
"MediaSize" => 66668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-9332bf2260904a68393cef3ccb17f31f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6299267121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/fe556f381d678c35090601f551ff2963.webp"
"MediaSize" => 56613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-fe556f381d678c35090601f551ff2963.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6299267146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/8bdd0b973cf4a1fc7c02abf242daafbb.webp"
"MediaSize" => 50853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-8bdd0b973cf4a1fc7c02abf242daafbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6299267172"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/4b7b59c2cb821e90b62f4a11cdb0e544.webp"
"MediaSize" => 54067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-4b7b59c2cb821e90b62f4a11cdb0e544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6299267255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/844ff920474147ac6b051e0f79c4c1a7.webp"
"MediaSize" => 57044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-844ff920474147ac6b051e0f79c4c1a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6299267314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/d39771d9b1c5ebee8e379a82dac2ddb2.webp"
"MediaSize" => 55956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-d39771d9b1c5ebee8e379a82dac2ddb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6299267380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/d8ecf23b0d14c9222068184a800b4c0c.webp"
"MediaSize" => 60285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-d8ecf23b0d14c9222068184a800b4c0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6299267449"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/50a8e0d5efed006a5fa31efd8835ad27.webp"
"MediaSize" => 56180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-50a8e0d5efed006a5fa31efd8835ad27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6299267508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/746da44806ddd77317a6489e16cfd6b2.webp"
"MediaSize" => 40618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-746da44806ddd77317a6489e16cfd6b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6299267548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/c7919cd4b2d570440de4c90337f860df.webp"
"MediaSize" => 38235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-c7919cd4b2d570440de4c90337f860df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6299267620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/cf0a3665708afe3970a10ac9a6abe547.webp"
"MediaSize" => 45587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-cf0a3665708afe3970a10ac9a6abe547.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6299267680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/c2300552ba8d1effd4be715afa3e1680.webp"
"MediaSize" => 41639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-c2300552ba8d1effd4be715afa3e1680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6299267729"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/d205b5473ac643d72a3871d4b5891a23.webp"
"MediaSize" => 62730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-d205b5473ac643d72a3871d4b5891a23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6299267780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/67aad5f9baf23885f752f85812f51cfc.webp"
"MediaSize" => 44125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-67aad5f9baf23885f752f85812f51cfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6299267811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/0044862d59731088c03d16da0ca6d741.webp"
"MediaSize" => 40100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-0044862d59731088c03d16da0ca6d741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6299267841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/d9f5cc9d9eeee8891d5ab2ff0fa75fd9.webp"
"MediaSize" => 45719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-d9f5cc9d9eeee8891d5ab2ff0fa75fd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6299267851"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/ad8ebe84c0e20550d40960346c5021f7.webp"
"MediaSize" => 46410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-ad8ebe84c0e20550d40960346c5021f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6299267886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/1298401d2771123a13b6f985636733d5.webp"
"MediaSize" => 52316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-1298401d2771123a13b6f985636733d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6299267893"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/214cb661af88e7fd1d3ada88ac3fadbf.webp"
"MediaSize" => 67351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-214cb661af88e7fd1d3ada88ac3fadbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6299267937"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/d7de75e35f3bcc42a9ceb034268ebe18.webp"
"MediaSize" => 124427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-d7de75e35f3bcc42a9ceb034268ebe18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6299267974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/e3dfc393a52db63f2d3bcb75385e4fc4.webp"
"MediaSize" => 112280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-e3dfc393a52db63f2d3bcb75385e4fc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6299267994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/7bef1d79a2458fe8e429635ac2546fb4.webp"
"MediaSize" => 113566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-7bef1d79a2458fe8e429635ac2546fb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6299268030"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/b279c12fc0d614998e5468ff2ec1b17a.webp"
"MediaSize" => 121783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-b279c12fc0d614998e5468ff2ec1b17a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6299268048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/fc84df4cf5e1e08a28c41d9a51ed2bc3.webp"
"MediaSize" => 121241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-fc84df4cf5e1e08a28c41d9a51ed2bc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6299268067"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/ee10f0e11a21c879d0edf3d5f39175d7.webp"
"MediaSize" => 120199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-ee10f0e11a21c879d0edf3d5f39175d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6299268096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076270/cc0a1f4952a9fcc681ee09bf23795652.webp"
"MediaSize" => 23207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076270/thumbnail-cc0a1f4952a9fcc681ee09bf23795652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786306"
"ResourceRecordKey" => "29076270"
"ModificationTimestamp" => "2025-11-06T18:59:48.17Z"
]
]
+"DaysOnMarket": 260
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29076270')"
+"ID": "939043"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 55165" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25070
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25013
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "HBREMAESBU"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55165"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 Itabashi Way Unit 4A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1114492"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-681-9908"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439640"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55165"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('55165')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2007886" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25093
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29076270'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25389
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29076270' AND OpenHouseDate ge '2026-07-24'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25405
+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 '29076270' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8794513 43.34297919)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25458
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25452
+post_id: "1656575"
+post_author: 1
+"ListingKey": "30076777"
+"ListingId": "X13603448"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T19:45:04Z"
+"RFModificationTimestamp": "2026-07-24T19:53:26Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON CLOSE, Hamilton (Waterdown), Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8871256
1 => 43.3398225
]
+"Latitude": 43.3398225
+"Longitude": -79.8871256
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:08:45.605271+00:00"
+"Directions": "Cross Streets: Dundas & Burke. ** Directions: Dundas St E N on Burke W on Boulding Right on Milverton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958279"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 129.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:59:17Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T19:38:43Z"
+"Stories": "1.0"
+"StreetName": "Milverton"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1692650595"
"RoomType" => "Foyer"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.52
"ListingKey" => "30076777"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
1 => array:11 [
"RoomKey" => "1692650596"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 1.07
"ListingKey" => "30076777"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
2 => array:11 [
"RoomKey" => "1692650597"
"RoomType" => "Laundry room"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.74
"ListingKey" => "30076777"
"RoomLength" => 4.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
3 => array:11 [
"RoomKey" => "1692650598"
"RoomType" => "Bedroom 4"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.75
"ListingKey" => "30076777"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
4 => array:11 [
"RoomKey" => "1692650599"
"RoomType" => "Other"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 4.06
"ListingKey" => "30076777"
"RoomLength" => 7.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
5 => array:11 [
"RoomKey" => "1692650600"
"RoomType" => "Living room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.94
"ListingKey" => "30076777"
"RoomLength" => 4.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
6 => array:11 [
"RoomKey" => "1692650601"
"RoomType" => "Dining room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.03
"ListingKey" => "30076777"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
7 => array:11 [
"RoomKey" => "1692650602"
"RoomType" => "Kitchen"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.06
"ListingKey" => "30076777"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
8 => array:11 [
"RoomKey" => "1692650603"
"RoomType" => "Eating area"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.84
"ListingKey" => "30076777"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
9 => array:11 [
"RoomKey" => "1692650604"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.22
"ListingKey" => "30076777"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
10 => array:11 [
"RoomKey" => "1692650605"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "30076777"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
11 => array:11 [
"RoomKey" => "1692650606"
"RoomType" => "Bedroom 2"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30076777"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.75Z"
]
12 => array:11 [
"RoomKey" => "1692650607"
"RoomType" => "Bedroom 3"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "30076777"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.76Z"
]
13 => array:11 [
"RoomKey" => "1692650608"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 3.98
"ListingKey" => "30076777"
"RoomLength" => 6.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T19:38:43.76Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076777/45-milverton-close-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-07-24T18:39:38.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249182"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30076777_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/d8df7092df14e7d09656e5add5e7cba6.webp"
"MediaSize" => 391821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-d8df7092df14e7d09656e5add5e7cba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:59:09.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30076777_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/0e344f3a67da67b4927de97d8bfc6823.webp"
"MediaSize" => 424211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-0e344f3a67da67b4927de97d8bfc6823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:59:17.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30076777_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/ccf43b7d2089d0e7608f34fcb523d3f8.webp"
"MediaSize" => 355387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-ccf43b7d2089d0e7608f34fcb523d3f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30076777_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/412a77aaf49d7cc49b3234539e613cb6.webp"
"MediaSize" => 169305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-412a77aaf49d7cc49b3234539e613cb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30076777_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/4e3b258a1796e8946af88e1d4fde77fa.webp"
"MediaSize" => 159703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-4e3b258a1796e8946af88e1d4fde77fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30076777_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/20b8347b30944e1912bb239e6e52f618.webp"
"MediaSize" => 209081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-20b8347b30944e1912bb239e6e52f618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30076777_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/28b891999d5b05c9895141aa20aaaeaf.webp"
"MediaSize" => 225102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-28b891999d5b05c9895141aa20aaaeaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30076777_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/7715d7abc5594ca2585b4dca5d14b1e5.webp"
"MediaSize" => 221942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-7715d7abc5594ca2585b4dca5d14b1e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30076777_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/076fa862b5189960845c13a146f73260.webp"
"MediaSize" => 197016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-076fa862b5189960845c13a146f73260.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30076777_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/2ed3cca10e629a27b6b8f139042a83e8.webp"
"MediaSize" => 199963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-2ed3cca10e629a27b6b8f139042a83e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30076777_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a38c27a3f239621c7e195c5cb773ce43.webp"
"MediaSize" => 183887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a38c27a3f239621c7e195c5cb773ce43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30076777_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/6f9c544da794162586324665bb4da015.webp"
"MediaSize" => 196164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-6f9c544da794162586324665bb4da015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30076777_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/e70eddd86428acedb22a8d9f224933d3.webp"
"MediaSize" => 192187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-e70eddd86428acedb22a8d9f224933d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30076777_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/16f512a7d6f6e1ac1666912f8ad35ec4.webp"
"MediaSize" => 188894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-16f512a7d6f6e1ac1666912f8ad35ec4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30076777_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/27bec663d72accbfcc285b7d874cbf0c.webp"
"MediaSize" => 185262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-27bec663d72accbfcc285b7d874cbf0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30076777_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a71ce5734c030c88fedd02d981ea497c.webp"
"MediaSize" => 188302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a71ce5734c030c88fedd02d981ea497c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30076777_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/a77c4bf54f2a90b8a177408bc217093f.webp"
"MediaSize" => 180495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-a77c4bf54f2a90b8a177408bc217093f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30076777_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/cd608c58ad05e956e791c85806573bde.webp"
"MediaSize" => 175511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-cd608c58ad05e956e791c85806573bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603448"
"ResourceRecordKey" => "30076777"
"ModificationTimestamp" => "2026-07-24T18:39:38.23Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30076777_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076777/3052f08a2c22b23873427068289e8913.webp"
"MediaSize" => 140645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076777/thumbnail-3052f08a2c22b23873427068289e8913.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076777')"
+"ID": "1656575"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25454
+post_id: "1656576"
+post_author: 1
+"ListingKey": "30076485"
+"ListingId": "40850027"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:30:18Z"
+"RFModificationTimestamp": "2026-07-24T18:32:37Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.18
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON Close, Waterdown, Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8875341
1 => 43.3401784
]
+"Latitude": 43.3401784
+"Longitude": -79.8875341
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T18:32:25.657182+00:00"
+"Directions": "Dundas St E, N on Burke W, on Boulding Right, on Milverton"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1528670"
+"ListOfficeKey": "268714"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:57Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:15:57Z"
+"Stories": "1.0"
+"StreetName": "MILVERTON"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30076485/45-milverton-close-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524684"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1218
+"OriginalEntryTimestamp": "2026-07-24T18:08:36.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140396"
+"ListOfficeNationalAssociationId": "1230749"
+"CoListAgentNationalAssociationId": "1063363"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076485')"
+"ID": "1656576"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25451
+post_id: "1652965"
+post_author: 1
+"ListingKey": "30072265"
+"ListingId": "X13599284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T19:45:04Z"
+"RFModificationTimestamp": "2026-07-23T20:10:08Z"
+"ListPrice": 369800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "603 - 450 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.879686
1 => 43.3426389
]
+"Latitude": 43.3426389
+"Longitude": -79.879686
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1 Bed, 1 Bath. This condo unit has tons of natural light with a large window with sliding Glass door in the Great Room which goes well with the open concept Kitchen completed with Rich white cabinets. Includes, light flooring in Kitchen, Great-room and Foyer and Bedroom. The Kitchen includes a large attached breakfast bar. The Spacious bedroom includes a large closet. Includes a Generous 4 piece bathroom. Also included, an in-suite laundry. The amenities include Fitness centre, Rooftop Patio, Bike Storage, Party Room. Located in Sought-after Waterdown Neighbourhood, surrounded by excellent dining options, shopping, schools, and parks. The unit also comes with 1 Parking spot and 1 Locker. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "525.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-07-23T20:09:57.942682+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Dundas St to Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145415"
+"ListOfficeKey": "289645"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T19:38:51Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T19:38:51Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2592.96"
+"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/30072265/603-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-23T19:38:51.38Z"
+"ListAgentNationalAssociationId": "1396795"
+"ListOfficeNationalAssociationId": "1379865"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072265')"
+"ID": "1652965"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25455
+post_id: "1652966"
+post_author: 1
+"ListingKey": "30072263"
+"ListingId": "X13599186"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T19:45:04Z"
+"RFModificationTimestamp": "2026-07-23T20:09:51Z"
+"ListPrice": 515000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "1011 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8789471
1 => 43.3440122
]
+"Latitude": 43.3440122
+"Longitude": -79.8789471
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous 2 Bed + 1 Bath Condo Nestled In Waterdown's Luxurious Trend Complex Built by New Horizon; Boasting 726 Sq/Ft Of Beautiful, Bright Open Concept Living; Floor to Ceiling Windows with a Stunning South View of the Lake; Premium Upgrades Incl. Stainless Steel Appliances; Quartz Counters; Breakfast Bar; Vinyl Flooring, Pristine Full Bathroom; Efficient Geothermal Heating & Cooling; W/O To Private Balcony with Unparalleled South and West Views; In-Suite Laundry; Enjoy Socializing on the Rooftop Terrace or Party Room & Staying Active in the Gym; Mins To Major Highways, GO Station, Parks and Schools. Includes TWO Parking Spots (1 Underground & 1 Surface) & Locker; Come Look - Love - Live! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "537.94"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T20:09:45.116050+00:00"
+"Directions": "Dundas & Mallord Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092288"
+"ListOfficeKey": "270960"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-23T19:38:51Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T19:38:51Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3548.18"
+"View": "Lake view"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072263/1011-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential Ontario - (416) 293-5900"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-23T19:38:51.16Z"
+"ListAgentNationalAssociationId": "1364870"
+"ListOfficeNationalAssociationId": "1237096"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072263')"
+"ID": "1652966"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25453
+post_id: "1652967"
+post_author: 1
+"ListingKey": "30069638"
+"ListingId": "X13596746"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T14:20:04Z"
+"RFModificationTimestamp": "2026-07-23T17:36:29Z"
+"ListPrice": 509000.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 FROM THE 10TH FLOOR! 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-07-23T17:36:24.146711+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 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T14:10:27Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T14:10:27Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3884"
+"View": "View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/1001450-Dundas-St-E/idx"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30069638/1001-450-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-23T14:10:27.91Z"
+"ListAgentNationalAssociationId": "1253863"
+"ListOfficeNationalAssociationId": "1417330"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069638')"
+"ID": "1652967"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25448
+post_id: "1649364"
+post_author: 1
+"ListingKey": "30067135"
+"ListingId": "40850211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T14:30:02Z"
+"RFModificationTimestamp": "2026-07-23T14:34:33Z"
+"ListPrice": 369800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 587.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 603, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8803609
1 => 43.3428115
]
+"Latitude": 43.3428115
+"Longitude": -79.8803609
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 1 Bed, 1 Bath. This condo unit has tons of natural light with a large window with sliding Glass door in the Great Room which goes well with the open concept Kitchen completed with Rich white cabinets. Includes, light flooring in Kitchen, Great-room and Foyer and Bedroom. The Kitchen includes a large attached breakfast bar. The Spacious bedroom includes a large closet. Includes a Generous 4 piece bathroom. Also included, an in-suite laundry. The amenities include Fitness centre, Rooftop Patio, Bike Storage, Party Room. Located in Sought-after Waterdown Neighbourhood, surrounded by excellent dining options, shopping, schools, and parks. The unit also comes with 1 Parking spot and 1 Locker. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "525.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-22T20:25:32.218205+00:00"
+"Directions": "Dundas St to Mallard Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1904585"
+"ListOfficeKey": "289618"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-23T14:22:43Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T14:29:16Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2592.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30067135/450-dundas-street-e-unit-603-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": 0
+"AboveGradeFinishedArea": 587
+"OriginalEntryTimestamp": "2026-07-22T19:37:59.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1219423"
+"ListOfficeNationalAssociationId": "1379562"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067135')"
+"ID": "1649364"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1649365"
+post_author: 1
+"ListingKey": "30064928"
+"ListingId": "X13592536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:45:05Z"
+"RFModificationTimestamp": "2026-07-23T20:48:57Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W6"
+"UnparsedAddress": "23 - 261 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1W6"
+"Coordinates": array:2 [
0 => -79.875544
1 => 43.341897
]
+"Latitude": 43.341897
+"Longitude": -79.875544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Have you been waiting to experience roof top entertaining? Well look no further... at 261 Skinner #23 this awesome end-unit townhome offers a600 square foot rooftop terrace overlooking the escarpment. Boasting 4 Bedrooms, 3 Bathrooms and nearly 1600 square feet this home is built for entertaining this townhome offers an excellent layout. The main floor offers a spacious kitchen with white cabinetry, stainless appliances, oversized breakfast island, open to your living and dining room area offering direct access to your private balcony. Additionally the main floor boasts a main 3 piece bathroom, laundry room, and potential main floor master bedroom or office! The upper level of this home features 3bedrooms. The primary retreat boasts beautiful bright windows, and a spacious 4 piece en-suite. The additional 2 bedrooms both generous in size feature double closets. The upper level additionally features a spacious 4 piece main bath. The upper level directly to the roof top terrace.Enjoy quiet evenings sipping wine on this amazing patio! This townhome also features a built in garage. Located minutes to all major amenities in Waterdown, quick access to the highway .. if you've been looking for something that is totally move in ready offering an easy lifestyle this is the one! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFee": "482.62"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T15:38:51.992667+00:00"
+"Directions": "Located south of Dundas Street at Mallard. Corner of Skinner Road and Mallard."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952638"
+"ListOfficeKey": "302161"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T15:10:17Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:39:49Z"
+"Stories": "3.0"
+"StreetName": "Skinner"
+"StreetNumber": "261"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4594.38"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/261-skinner-rd-23-waterdown-on-l8b-1w6-24790206/branded"
+"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"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30064928/23-261-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Essence Condos MSP"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R6-31"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-22T15:10:17.16Z"
+"ListAgentNationalAssociationId": "1246196"
+"ListOfficeNationalAssociationId": "1499250"
+"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('30064928')"
+"ID": "1649365"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25456
+post_id: "1642010"
+post_author: 1
+"ListingKey": "30055810"
+"ListingId": "X13584220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T17:15:12Z"
+"RFModificationTimestamp": "2026-07-20T19:18:16Z"
+"ListPrice": 898000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "274 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.874621
1 => 43.341818
]
+"Latitude": 43.341818
+"Longitude": -79.874621
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An opportunity in Waterdown you do not want to miss! One of the largest semi-detached homes currently available on the market spanning over 2,288sqft of living space. This four bedroom home in uniquely situated at one of the most convenient points of the community. With clear views to the east, the home allows for plenty of natural sunlight throughout the day. Open concept living, and dining that spills into a balcony in the backyard that makes this the main floor the perfect space for spending time with family and entertaining guests. The walkout basement is a blank slate to customize to your liking, and with the added light from the larger windows it truly feels like an extension of the home. With four generously sized bedroom upstairs, the second floors higher ceilings and uncompromising spaces gives the flow of the second floor an airy feel. Located in a sought-after and growing area of Waterdown, just minutes walk to St. Thomas the Apostle Catholic Elementary School, Skinner park, trails, and convenience stores. Best of all you're a short drive to highways 403, 407, ten minutes to Aldershot GO station, hardware stores, grocery, and plenty other amenities nearby! (id:62650)"
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:18:03.969180+00:00"
+"Directions": "Cross Streets: Skinner Rd & Mallard Trl. ** Directions: Please see Google Maps."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072068"
+"ListOfficeKey": "290380"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "27.9 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T17:09:53Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T17:09:53Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "274"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6682.61"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30055810/274-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 27.1
+"OriginalEntryTimestamp": "2026-07-20T17:09:53.61Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347263"
+"ListOfficeNationalAssociationId": "1386425"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055810')"
+"ID": "1642010"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: "1640551"
+post_author: 1
+"ListingKey": "30053418"
+"ListingId": "X13581880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T18:10:01Z"
+"RFModificationTimestamp": "2026-07-19T18:42:27Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "279 SKINNER ROAD N, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.877083
1 => 43.340355
]
+"Latitude": 43.340355
+"Longitude": -79.877083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover stylish, low-maintenance living in this beautifully maintained, sun-filled condo townhome nestled in the highly desirable East Waterdown community. Boasting soaring 9-foot ceilings and a unique open-concept design, this home offers an inviting blend of space, natural light, and everyday functionality. The spacious eat-in kitchen is designed for both entertaining and daily living, featuring stainless steel appliances, abundant cabinetry, generous prep space, and a walk-out to a private balcony-perfect for morning coffee, evening sunsets, or summer BBQs. Upstairs, you'll find two generously sized bedrooms, each with its own private ensuite, including a spacious primary retreat with a 4-piece bath and a second bedroom with a 3-piece ensuite-an ideal layout for families, guests, or professionals seeking added privacy. Enjoy the convenience of an attached garage with inside entry, plus parking for up to three vehicles-a rare and valuable feature. Low condo fees make ownership even more affordable while allowing you to enjoy a carefree, low-maintenance lifestyle. Located in one of Waterdown's most sought-after neighbourhoods, you're just minutes from top-rated schools, scenic parks and trails, shopping, restaurants, the GO Station, major highways, downtown Waterdown, and Burlington, offering the perfect balance of small-town charm and effortless connectivity. Whether you're a first-time buyer, downsizer, busy professional, or savvy investor, this move-in-ready home delivers exceptional value, comfort, and lifestyle in an outstanding location. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"AssociationFee": "194.39"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-19T18:42:15.396330+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Skinner. ** Directions: South of Dundas at Mallard & Skinner Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1660663"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-19T18:03:24Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T18:03:24Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "Skinner"
+"StreetNumber": "279"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4497.87"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/279-skinner-road-hamilton-l8b-1w5/nb/"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30053418/279-skinner-road-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WENTWORTH STANDARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-19T18:03:24.72Z"
+"ListAgentNationalAssociationId": "1167703"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30053418')"
+"ID": "1640551"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 163
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]