array:6 [
"RF Cache Key: 5b0b2f0f7dfed329c2ffb48524f455d4f45808787a2785e3bbae78b29639c6e7" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21847
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29127642"
+"ListingId": "40786336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:35:44Z"
+"RFModificationTimestamp": "2026-06-02T18:12:57Z"
+"ListPrice": 2225000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.53
+"LivingArea": 2705.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P4Y4"
+"UnparsedAddress": "1962 SNAKE Road, Burlington, Ontario L7P4Y4"
+"Coordinates": array:2 [
0 => -79.8907745
1 => 43.3237656
]
+"Latitude": 43.3237656
+"Longitude": -79.8907745
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your dream home awaits in this custom-built 2705 sq ft masterpiece on a half-acre lot. Natural light floods the home through skylights, while the spacious family room features a stunning vaulted ceiling—perfect for both relaxing and entertaining. The sun-drenched kitchen, with wall-to-wall windows, brings the beauty of nature indoors as you cook and gather. Upstairs, retreat to the luxurious primary suite with a five-piece ensuite and dual walk-in closets. Two additional bedrooms and a stylish four-piece bath complete the second floor. The fully finished walkout basement offers versatility with an extra bedroom and full bathroom, ideal for guests or a home office. Outside, enjoy your private oasis with a sparkling pool, hot tub, and cozy campfire spot—perfect for evenings under the stars. This home blends modern comfort with thoughtful design, creating the perfect balance of indoor luxury and outdoor living. This is your chance to call this exquisite property your own. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Microwave"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T23:13:04.435790+00:00"
+"Directions": "See map for directions."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2216487"
+"ListOfficeKey": "296698"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.53"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2025-11-21T21:09:33Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T17:01:39Z"
+"Stories": "1.5"
+"StreetName": "SNAKE"
+"StreetNumber": "1962"
+"StreetSuffix": "Road"
+"SubdivisionName": "300 - Aldershot West"
+"TaxAnnualAmount": "7168.9"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=2sK4MXveabb"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1649953253"
"RoomType" => "Kitchen"
"ListingId" => "40786336"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
1 => array:11 [
"RoomKey" => "1649953254"
"RoomType" => "3pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
2 => array:11 [
"RoomKey" => "1649953255"
"RoomType" => "2pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
3 => array:11 [
"RoomKey" => "1649953256"
"RoomType" => "3pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
4 => array:11 [
"RoomKey" => "1649953257"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
5 => array:11 [
"RoomKey" => "1649953258"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.7Z"
]
6 => array:11 [
"RoomKey" => "1649953259"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.71Z"
]
7 => array:11 [
"RoomKey" => "1649953260"
"RoomType" => "Full bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.71Z"
]
8 => array:11 [
"RoomKey" => "1649953261"
"RoomType" => "Primary Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T17:01:39.71Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29127642/1962-snake-road-burlington"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Nec Dev Control Area"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 2705
+"OriginalEntryTimestamp": "2025-11-21T21:09:33.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1462159"
+"ListOfficeNationalAssociationId": "1461275"
+"Media": array:34 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6332548880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/1fb040a7881bec306492205ca182985b.webp"
"MediaSize" => 121588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-1fb040a7881bec306492205ca182985b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6332548993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/476cd94bcc90f3b9d574b6068c6b6c38.webp"
"MediaSize" => 78653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-476cd94bcc90f3b9d574b6068c6b6c38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6332549089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/29a06f4ee1256721ba0828152e518793.webp"
"MediaSize" => 83393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-29a06f4ee1256721ba0828152e518793.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6332549164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/06b9a5ccecbdae6503d9c3b2dbe8b921.webp"
"MediaSize" => 81971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-06b9a5ccecbdae6503d9c3b2dbe8b921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6332549226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/04606b12cc6b971e9925a40112010611.webp"
"MediaSize" => 99071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-04606b12cc6b971e9925a40112010611.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6332549302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/9e67d30ccce4a7f6323354764c5794f3.webp"
"MediaSize" => 99816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-9e67d30ccce4a7f6323354764c5794f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6332549388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/812d738a55a350ae594ad7da44280e33.webp"
"MediaSize" => 106593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-812d738a55a350ae594ad7da44280e33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6332549431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/95c98b5b0b97002762e6519b7ef57815.webp"
"MediaSize" => 77814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-95c98b5b0b97002762e6519b7ef57815.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6332549484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/9f8e59ae5f9d474c95bf57dc38074cd6.webp"
"MediaSize" => 98816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-9f8e59ae5f9d474c95bf57dc38074cd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6332549505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/6b90774d3a5c055955612fe5ec3ac5f1.webp"
"MediaSize" => 91154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-6b90774d3a5c055955612fe5ec3ac5f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6332549525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/4e83139f26054880e678584aa06228a4.webp"
"MediaSize" => 93322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-4e83139f26054880e678584aa06228a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6332549564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/0b733a24d8c93c988ef818e404a67702.webp"
"MediaSize" => 70015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-0b733a24d8c93c988ef818e404a67702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6332549588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/9a3adea63ee1f52d838242c364125971.webp"
"MediaSize" => 65537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-9a3adea63ee1f52d838242c364125971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6332549627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/c57028d1af987929fb580c0df0c3183c.webp"
"MediaSize" => 76632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-c57028d1af987929fb580c0df0c3183c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6332549677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/119ef2197b29e688c679f2e884ecdf92.webp"
"MediaSize" => 74068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-119ef2197b29e688c679f2e884ecdf92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6332549702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/0f2c03eb9625a9898fa2a6d711b655dc.webp"
"MediaSize" => 82645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-0f2c03eb9625a9898fa2a6d711b655dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6332549723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/4ec64b9a08e154d65197a328a4a2e54c.webp"
"MediaSize" => 62129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-4ec64b9a08e154d65197a328a4a2e54c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6332549748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/8fa0b1bb200d94c83965dc936ab89e38.webp"
"MediaSize" => 77207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-8fa0b1bb200d94c83965dc936ab89e38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6332549760"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/0e019cc57c2d5b4185aaf66eb088c4c8.webp"
"MediaSize" => 72283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-0e019cc57c2d5b4185aaf66eb088c4c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6332549764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/54047d2454e8b85c7710f2700a7b71c8.webp"
"MediaSize" => 70765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-54047d2454e8b85c7710f2700a7b71c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6332549780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/b54429a2f1b4a6b594462e6805bc105c.webp"
"MediaSize" => 67004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-b54429a2f1b4a6b594462e6805bc105c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6332549793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/13f0b474d114fe08793e257a1f134afb.webp"
"MediaSize" => 87353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-13f0b474d114fe08793e257a1f134afb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6332549806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/a043b61618b2abb6531d468e507a5e12.webp"
"MediaSize" => 77562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-a043b61618b2abb6531d468e507a5e12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6332549818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/7ec71ea38a59383e74e6afcc7a357a10.webp"
"MediaSize" => 44584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-7ec71ea38a59383e74e6afcc7a357a10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6332549827"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/4138dd379089ecaade11314860b77a4f.webp"
"MediaSize" => 87521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-4138dd379089ecaade11314860b77a4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6332549838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/35e9cd27e5199e7f5fa7921664c1a187.webp"
"MediaSize" => 89586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-35e9cd27e5199e7f5fa7921664c1a187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6332549854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/99cdc6db7dcb2ef14eed391bb008a578.webp"
"MediaSize" => 132725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-99cdc6db7dcb2ef14eed391bb008a578.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6332549875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/439d50a27376e84343613230d921510e.webp"
"MediaSize" => 139562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-439d50a27376e84343613230d921510e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6332549887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/f86faac64261eb5b7a23f23ca0ee3a5d.webp"
"MediaSize" => 137588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-f86faac64261eb5b7a23f23ca0ee3a5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6332549897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/0f59a65173f9b6c26750ce4290f9e88a.webp"
"MediaSize" => 130162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-0f59a65173f9b6c26750ce4290f9e88a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6332549904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/40cb3803c3c22f337344d7409cfc8520.webp"
"MediaSize" => 131754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-40cb3803c3c22f337344d7409cfc8520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6332549909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/c831ecf7df7932a42b1436b0f0c1667c.webp"
"MediaSize" => 117600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-c831ecf7df7932a42b1436b0f0c1667c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6332549913"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/c73422fea680b648d427e9c0492a8707.webp"
"MediaSize" => 151989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-c73422fea680b648d427e9c0492a8707.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6332549917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29127642/3064268e6ed9ea54eb5c89ff07d040bd.webp"
"MediaSize" => 116770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29127642/thumbnail-3064268e6ed9ea54eb5c89ff07d040bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786336"
"ResourceRecordKey" => "29127642"
"ModificationTimestamp" => "2025-11-21T21:09:33.76Z"
]
]
+"DaysOnMarket": 225
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29127642')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 296698" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24917
+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 2216487" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24915
+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 '29127642'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFPropertyAdditionalInfo {#25228
+"OriginatingSystemName": "CREA"
+"ListingKey": "29127642"
+"AdditionalInfo": array:2 [
"email" => ""
"phoneNumber" => "1-905-808-1970"
]
+"ModificationTimestamp": "2025-11-22T15:59:57Z"
+"PropertyAdditionalInfoKey": "5460_26_29127642_389"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/PropertyAdditionalInfo('5460_26_29127642_389')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29127642'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+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 '29127642' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8907745 43.3237656)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1589791"
+post_author: 1
+"ListingKey": "29985393"
+"ListingId": "40844589"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:10:10Z"
+"RFModificationTimestamp": "2026-07-03T18:59:55Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1499.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V9"
+"UnparsedAddress": "219 DUNDAS Street E Unit# 29, Waterdown, Ontario L8B1V9"
+"Coordinates": array:2 [
0 => -79.9001162
1 => 43.3280419
]
+"Latitude": 43.3280419
+"Longitude": -79.9001162
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5 wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you’ll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:59:19.033948+00:00"
+"Directions": "Enter on North side Of Dundas."
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988755"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:48:27Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:00:07Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5065.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1674286335"
"RoomType" => "Laundry room"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
1 => array:11 [
"RoomKey" => "1674286336"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
2 => array:11 [
"RoomKey" => "1674286337"
"RoomType" => "Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
3 => array:11 [
"RoomKey" => "1674286338"
"RoomType" => "Full bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
4 => array:11 [
"RoomKey" => "1674286339"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844589"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
5 => array:11 [
"RoomKey" => "1674286340"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.57Z"
]
6 => array:11 [
"RoomKey" => "1674286341"
"RoomType" => "Kitchen"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
7 => array:11 [
"RoomKey" => "1674286342"
"RoomType" => "Dining room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
8 => array:11 [
"RoomKey" => "1674286343"
"RoomType" => "Living room"
"ListingId" => "40844589"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
9 => array:11 [
"RoomKey" => "1674286344"
"RoomType" => "Foyer"
"ListingId" => "40844589"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985393"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:07.58Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985393/219-dundas-street-e-unit-29-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1562390"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55164"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "HC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1499
+"OriginalEntryTimestamp": "2026-07-03T16:48:27.09Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1272793"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1148234"
+"CoListOfficeNationalAssociationId": "1003546"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29985393_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/054bc8973faece78defe1f7e0ff63a11.webp"
"MediaSize" => 128775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-054bc8973faece78defe1f7e0ff63a11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29985393_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/3fdc437a85d9b9e59e690772a56d9855.webp"
"MediaSize" => 77326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-3fdc437a85d9b9e59e690772a56d9855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29985393_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"MediaSize" => 132036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-4dbf3f9609f5a1657a2d9550e0cd3283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29985393_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f8afda4081f28fbeab7bc5c6fc350867.webp"
"MediaSize" => 151903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-f8afda4081f28fbeab7bc5c6fc350867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29985393_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/53f914f77d326497dfd69fbb725e69d2.webp"
"MediaSize" => 113187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-53f914f77d326497dfd69fbb725e69d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29985393_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/f6194f0bd97e7da1ac9604e5e57390a0.webp"
"MediaSize" => 41833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-f6194f0bd97e7da1ac9604e5e57390a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29985393_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/341f87767006ead7df22190951fd5547.webp"
"MediaSize" => 50715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-341f87767006ead7df22190951fd5547.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29985393_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/d6b4918e67cdc20dfb50588e18a39cbe.webp"
"MediaSize" => 46636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-d6b4918e67cdc20dfb50588e18a39cbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29985393_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/8195e5cb2b5d5d0f299c5cf5748a1a96.webp"
"MediaSize" => 85094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-8195e5cb2b5d5d0f299c5cf5748a1a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29985393_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/29aad8fc5e2be753ba2788e7f803c114.webp"
"MediaSize" => 80502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-29aad8fc5e2be753ba2788e7f803c114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29985393_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/93321acca11c54ca903afd3e5bde748f.webp"
"MediaSize" => 97243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-93321acca11c54ca903afd3e5bde748f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29985393_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/271f3bb6c36f4322f9b4a004f816308e.webp"
"MediaSize" => 82203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985393/thumbnail-271f3bb6c36f4322f9b4a004f816308e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844589"
"ResourceRecordKey" => "29985393"
"ModificationTimestamp" => "2026-07-03T16:48:27.1Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29985393_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985393/8e47a3a5fafa731abe5252d8e7eb650b.webp"
…10
]
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985393')"
+"ID": "1589791"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1589421"
+post_author: 1
+"ListingKey": "29985763"
+"ListingId": "X13519154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:50:04Z"
+"RFModificationTimestamp": "2026-07-03T19:53:15Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7H8"
+"UnparsedAddress": "29 - 219 DUNDAS STREET E, Hamilton (Waterdown), Ontario L9H7H8"
+"Coordinates": array:2 [
0 => -79.90059
1 => 43.327623
]
+"Latitude": 43.327623
+"Longitude": -79.90059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 2 bedroom, 2.5 bathroom end unit townhome. This home offers the perfect blend of space, comfort, and convenience. The bright, open-concept main level is flooded with natural light and showcases 7.5" wide premium grade flooring throughout, smooth 9-foot ceilings with potlights, upgraded ceramic tiles, a solid oak staircase with upgraded spindles, and a modern kitchen featuring a spacious breakfast peninsula perfect for everyday living and entertaining. Step outside to your private second-floor terrace, offering an ideal space to relax, cook, or enjoy your morning coffee. Upstairs, you'll find two generously sized bedrooms, including a spacious primary retreat featuring an abundance of natural light, complete with a walk-in closet and ensuite which features a glass walk-in shower. A second full bathroom and convenient side-by-side laundry complete the upper level. Ideally located close to shopping, restaurants, schools, parks, major highways, and everyday amenities, this exceptional home offers an unbeatable lifestyle. Opportunities to own in The Tannery are few and far between. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "329.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:11:05.119669+00:00"
+"Directions": "Cross Streets: Dundas & Sunnycroft. ** Directions: Entry to complex on North side of Dundas."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031562"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:40:21Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5065.04"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985763/29-219-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Guild Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.41Z"
+"ListAgentNationalAssociationId": "1309006"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985763')"
+"ID": "1589421"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1589422"
+post_author: 1
+"ListingKey": "29985762"
+"ListingId": "X13519138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:55:19Z"
+"RFModificationTimestamp": "2026-07-03T18:10:49Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN LANE, Hamilton (Waterdown), Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904144
1 => 43.333008
]
+"Latitude": 43.333008
+"Longitude": -79.904144
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard-ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:10:41.052691+00:00"
+"Directions": "Cross Streets: Segwun Rd. ** Directions: Hamilton St N to Rockhaven Lane."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089558"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Sump Pump"
]
+"LotSizeDimensions": "31.2 x 127.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:41:39Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:41:39Z"
+"Stories": "2.0"
+"StreetName": "Rockhaven"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985762/84-rockhaven-lane-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 31.2
+"OriginalEntryTimestamp": "2026-07-03T17:41:39.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1362909"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985762')"
+"ID": "1589422"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1589371"
+post_author: 1
+"ListingKey": "29983992"
+"ListingId": "X13517516"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T00:10:13Z"
+"RFModificationTimestamp": "2026-07-04T00:20:18Z"
+"ListPrice": 1680000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "60 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.883376
1 => 43.334537
]
+"Latitude": 43.334537
+"Longitude": -79.883376
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A Rare Opportunity to Own This Magnificent Executive Residence in One of Waterdown's Most Prestigious Communities! Never Lived In Like New. This Stunning 3,718 Sqft. Home Sits on A Wide Lot Backing on Greenspace, Offering Walk-Out Basement and Private Southeast-Facing Backyard. Showcasing Timeless Architecture with Elegant Brick and Natural Stone, 3-Car Garage, and Oversized Driveway, Making It a Truly Exceptional Luxury Residence! Step Into 2-Storey Foyer, Spectacular Formal Living Room Boasts A Soaring 14.8-Ft Ceiling and Dramatic Windows, while 10-Ft Smooth Ceilings on Main, The Formal Dining Room Is Perfect for Entertaining. Spacious Family Room Features Coffered Ceiling, Gas Fireplace, With Views of Backyard and Greenspace. The Upgraded Gourmet Kitchen Offers Granite Countertops, Centre Island, Ample Cabinetry, And Spacious Breakfast Area with Walkout to Sundeck. A Private Main-Floor Office Provides Work-From-Home Space. Solid Hardwood Stairs Lead to the 2nd Level with 9-Ft Ceilings Throughout. The Luxurious Primary Retreat Features 2 Walk-In Closets and Spa-Inspired 5pc Ensuite. 2nd Bedroom Has Its Own 4pc Ensuite and Walk-In Closet, While the Remaining Bedrooms Share a Jack & Jill Bathroom with Upgraded Glass Shower. The Open Hallway Overlooks Grand Foyer Below. Unspoiled Walk-Out Basement Offers 8.5-Ft Ceilings, and 2nd Hardwood Staircase from The Side Entrance and Garage, Creating Potential for An In-Law or Future 2nd Suite. The 200-Amp Electrical Service, Ideal for Future EV Charger Installation. Nestled On a Quiet Crescent Surrounded by Conservation Areas, Parks, Pond and Scenic Trails, This Exceptional Location Offers the Perfect Blend of Small-Town Charm and Modern Convenience. Minutes To Schools, Historical Waterdown Village, Boutique Shops, Cafés, Farmers' Market, And Easy Access to Hwys 403, 407, QEW, Hwy 6, And GO Station. A Truly Rare Offering with No Comparable Homes and Perfect Combination of Natural Beauty, Family Living, And Urban Convenience. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Alarm System"
2 => "Garage door opener"
]
+"Basement": array:6 [
0 => "Unfinished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-03T17:51:04.537824+00:00"
+"Directions": "Dundas/Burke"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423924"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "59.7 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T00:04:55Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T00:04:55Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "60"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "11103.31"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://tours.aisonphoto.com/328271"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983992/60-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2106037"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283410"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 59.8
+"OriginalEntryTimestamp": "2026-07-03T14:09:55.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1117087"
+"ListOfficeNationalAssociationId": "1328651"
+"CoListAgentNationalAssociationId": "1375264"
+"CoListOfficeNationalAssociationId": "1328651"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983992')"
+"ID": "1589371"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1589372"
+post_author: 1
+"ListingKey": "29984029"
+"ListingId": "40843518"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T14:25:13Z"
+"RFModificationTimestamp": "2026-07-03T17:46:27Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1932.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0J2"
+"UnparsedAddress": "84 ROCKHAVEN Lane, Waterdown, Ontario L8B0J2"
+"Coordinates": array:2 [
0 => -79.904394
1 => 43.3326997
]
+"Latitude": 43.3326997
+"Longitude": -79.904394
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this 3-bedroom, 2.5-bathroom detached home nestled in one of Waterdown's sought-after family neighbourhoods. Thoughtfully designed for everyday living, this home offers spacious rooms, a functional layout, and plenty of room for a growing family. The bright main level features comfortable living and dining spaces that flow effortlessly into the well-appointed kitchen, creating the perfect setting for both daily life and entertaining. Upstairs, you'll find three generous bedrooms, including a spacious primary retreat complete with its own private ensuite. Step outside to enjoy the large, fully fenced backyard—ideal for children, pets, or hosting summer barbecues. Located close to parks, schools, trails, shopping, and commuter routes, this home offers the perfect balance of convenience and community. Whether you're purchasing your first home, upsizing, or looking to settle into a welcoming neighbourhood, this is an opportunity you won't want to miss. (id:62650)"
+"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 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:46:17.621941+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524975"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:30Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T14:18:30Z"
+"Stories": "2.0"
+"StreetName": "ROCKHAVEN"
+"StreetNumber": "84"
+"StreetSuffix": "Lane"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "6164.09"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984029/84-rockhaven-lane-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975579"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2172717"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1589
+"BelowGradeFinishedArea": 343
+"OriginalEntryTimestamp": "2026-07-03T14:18:30.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1063275"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1262231"
+"CoListAgentNationalAssociationId2": "1423204"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984029')"
+"ID": "1589372"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1574964"
+post_author: 1
+"ListingKey": "29964832"
+"ListingId": "40843093"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:10:11Z"
+"RFModificationTimestamp": "2026-06-29T14:12:46Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 2.322
+"LivingArea": 951.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1A9"
+"UnparsedAddress": "262 E DUNDAS Street E Unit# 315, Waterdown, Ontario L8B1A9"
+"Coordinates": array:2 [
0 => -79.8960168
1 => 43.3299381
]
+"Latitude": 43.3299381
+"Longitude": -79.8960168
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Absolutely meticulously maintained 1+1 condo located in the heart of Waterdown. This spotless unit features 10 foot ceilings, crown molding, transom window, patio sliding doors to private balcony, ceiling fans, in-suite laundry room, and breakfast bar. This wonderful unit is bright and airy with a stunning open concept layout. Double French doors lead to a spacious office or second bedroom if required. Furnace and C/Air replaced 2022. The apartment is within walking distance to all amenities, transportation, and recreational parks and shops. Fantastic unit in a quite and safe location. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "733.54"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T13:47:04.205980+00:00"
+"Directions": "Dundas Street East to Hamilton Street South"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524989"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"LotSizeDimensions": "2.322"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-29T13:10:02Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:02:20Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "262"
+"StreetSuffix": "Street"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3719.65"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364556"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964832/262-dundas-street-e-unit-315-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 510.0
+"AboveGradeFinishedArea": 951
+"OriginalEntryTimestamp": "2026-06-29T13:10:02.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063309"
+"ListOfficeNationalAssociationId": "1286675"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964832')"
+"ID": "1574964"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1572570"
+post_author: 1
+"ListingKey": "29961749"
+"ListingId": "X13496704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T17:45:02Z"
+"RFModificationTimestamp": "2026-07-04T17:55:08Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW ROAD, Hamilton (Waterdown), Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.882882
1 => 43.329912
]
+"Latitude": 43.329912
+"Longitude": -79.882882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Waterdown's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T01:10:19.307439+00:00"
+"Directions": "Cross Streets: Mountain Brow Road. ** Directions: Waterdown Road to Mountain Brow Road."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047588"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "256.3 x 127.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T00:44:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T17:39:32Z"
+"Stories": "1.5"
+"StreetName": "Mountain Brow"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://344mountainbrowroad.marketingrmx.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961749/344-mountain-brow-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 256.3
+"OriginalEntryTimestamp": "2026-06-27T00:44:49.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323031"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961749')"
+"ID": "1572570"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1571912"
+post_author: 1
+"ListingKey": "29960542"
+"ListingId": "X13495616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:02Z"
+"RFModificationTimestamp": "2026-06-26T23:04:46Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X1"
+"UnparsedAddress": "14 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X1"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained and move-in-ready corner-unit townhouse offering approximately 1,800 sq. ft. of bright and functional living space. This spacious home features 3+1 bedrooms, 3 bathrooms, a double-car garage, plus 2 additional driveway parking spaces. The desirable corner location allows for an abundance of natural light through numerous windows throughout the home. Enjoy an open-concept kitchen overlooking the dining area, complete with a large pantry and excellent storage space. The well-designed layout includes generously sized bedrooms and a primary suite with an ensuite bath. An unfinished basement offers exceptional potential for future customization and added living space while providing ample storage. Relax on the private balcony with gas hookups and enjoy comfortable, low-maintenance living in a sought-after, family-friendly community. Ideally located with exceptional accessibility, this home is just minutes from major highways, shopping centres, schools, parks, restaurants, and all everyday amenities, making it a perfect choice for families seeking both convenience and comfort. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"AssociationFee": "216.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:04:38.815915+00:00"
+"Directions": "Hamilton St N / Dundas St E"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946962"
+"ListOfficeKey": "50236"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:00Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:00Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6356.58"
+"View": "View"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960542/14-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1892161"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 905-540-8800"
+"CoListOfficeKey": "50236"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "R6-33"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T20:48:00.12Z"
+"ListAgentNationalAssociationId": "1241888"
+"ListOfficeNationalAssociationId": "1002993"
+"CoListAgentNationalAssociationId": "1212143"
+"CoListOfficeNationalAssociationId": "1002993"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960542')"
+"ID": "1571912"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1571505"
+post_author: 1
+"ListingKey": "29961017"
+"ListingId": "40843479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:55:10Z"
+"RFModificationTimestamp": "2026-07-04T16:57:26Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.75
+"LivingArea": 3492.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L7P5A3"
+"UnparsedAddress": "344 MOUNTAIN BROW Road, Waterdown, Ontario L7P5A3"
+"Coordinates": array:2 [
0 => -79.8823409
1 => 43.3299879
]
+"Latitude": 43.3299879
+"Longitude": -79.8823409
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 344 Mountain Brow Road, an extraordinary Arts & Crafts-inspired custom bungaloft set on a spectacular 0.75-acre ravine lot in one of Waterdown's most coveted escarpment locations. Designed by Darren Sanger-Smith of Structured Creations, this exceptional residence blends timeless craftsmanship, luxury finishes, & breathtaking natural surroundings. Thoughtfully designed for main-floor living w/ versatile upper-level accommodations, the heart of the home is a chef-inspired kitchen featuring a large centre island, premium S/S appliances, custom cabinetry, designer hardware, & pot lighting, seamlessly connected to the impressive great room. Soaring 27ft vaulted ceilings, exposed timber frame trusses, & a dramatic floor-to-ceiling stone fireplace create a truly unforgettable living space. The elegant dining room flows into the formal living room, ideal for everyday living & entertaining. A thoughtfully designed main-floor laundry/mud room adds convenience, while a custom wine cellar provides the perfect space to showcase your collection. Main level features a luxurious primary retreat w/ walk-in closet, private ensuite, & beautiful views of the backyard deck & ravine. 2nd main-floor bedroom also offers its own ensuite & picturesque backyard views. Upper loft provides exceptional flexibility w/ a bedroom, full bathroom, sitting room, & a dedicated den/home office. Enjoy year-round ravine views from the inviting 3-season room w/ a wood-burning fireplace. Outdoor living is equally impressive w/ a newly rebuilt wraparound composite deck & hot tub, creating the perfect space to relax or entertain while immersed in nature. Ideally situated alongside the renowned Bruce Trail system, this rare offering combines the tranquility of escarpment living w/ the convenience of being minutes to downtown Burlington, everyday amenities, & less than 5 minutes to Aldershot GO Station. A truly exceptional home where luxury, architecture, & nature come together in perfect harmony. (id:62650)"
+"Appliances": array:2 [
0 => "Window Coverings"
1 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:10.046221+00:00"
+"Directions": "WATERDOWN ROAD TO MOUNTAIN BROW ROAD"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002888"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"LotSizeDimensions": "0.75"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:48:25Z"
+"Stories": "1.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "344"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "13121.79"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204661223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961017/344-mountain-brow-road-waterdown"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "P6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 256.0
+"AboveGradeFinishedArea": 3492
+"OriginalEntryTimestamp": "2026-06-26T21:50:06.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1285800"
+"ListOfficeNationalAssociationId": "1333115"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961017')"
+"ID": "1571505"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 115
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]