array:6 [
"RF Cache Key: 5b0b2f0f7dfed329c2ffb48524f455d4f45808787a2785e3bbae78b29639c6e7" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21928
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23525
+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": 242
+"@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=OfficeKey eq 296698" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24947
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24939
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ComFree"
+"OfficeEmail": null
+"OfficePhone": "877-888-3131"
+"OfficeMlsId": "MIB7464"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "296698"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "10807 - 124 Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Edmonton"
+"OfficePostalCode": "T5M0H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1461275"
+"OriginalEntryTimestamp": "2024-04-26T18:19:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "440397"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "296698"
"SocialMediaUrlOrId" => "https://comfree.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1461221"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('296698')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2216487" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24960
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29127642'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25334
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFPropertyAdditionalInfo {#25332
+"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' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25349
+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 {#25422
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25416
+post_id: "1636895"
+post_author: 1
+"ListingKey": "30038737"
+"ListingId": "40848610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T20:25:30Z"
+"RFModificationTimestamp": "2026-07-18T20:28:30Z"
+"ListPrice": 575000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1349.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C6"
+"UnparsedAddress": "79 BRAEHEID Avenue Unit# 6, Waterdown, Ontario L8B0C6"
+"Coordinates": array:2 [
0 => -79.9100562
1 => 43.3290621
]
+"Latitude": 43.3290621
+"Longitude": -79.9100562
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Walk the kids to school! Perfectly situated in a family-friendly townhouse complex just a 5-minute walk to Guy Brown Public School, this well-maintained 3-bedroom, 2-bathroom home is ideal for families looking to get settled before the new school year. Enjoy a bright, functional layout, spacious bedrooms, a finished basement for additional living space, and a private backyard. Conveniently located close to parks, shopping, restaurants, and commuter routes, this is a fantastic opportunity to own in one of Waterdown’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "625"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:38:26.849219+00:00"
+"Directions": "Parkside Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-15T21:18:26Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T20:18:16Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "79"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "3587"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1687972543"
"RoomType" => "Other"
"ListingId" => "40848610"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.93Z"
]
1 => array:11 [
"RoomKey" => "1687972544"
"RoomType" => "Storage"
"ListingId" => "40848610"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.93Z"
]
2 => array:11 [
"RoomKey" => "1687972545"
"RoomType" => "Utility room"
"ListingId" => "40848610"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.93Z"
]
3 => array:11 [
"RoomKey" => "1687972546"
"RoomType" => "Family room"
"ListingId" => "40848610"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.93Z"
]
4 => array:11 [
"RoomKey" => "1687972547"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848610"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.93Z"
]
5 => array:11 [
"RoomKey" => "1687972548"
"RoomType" => "Bedroom"
"ListingId" => "40848610"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
6 => array:11 [
"RoomKey" => "1687972549"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848610"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "4'2'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
7 => array:11 [
"RoomKey" => "1687972550"
"RoomType" => "Bedroom"
"ListingId" => "40848610"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
8 => array:11 [
"RoomKey" => "1687972551"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848610"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
9 => array:11 [
"RoomKey" => "1687972552"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848610"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
10 => array:11 [
"RoomKey" => "1687972553"
"RoomType" => "Living room"
"ListingId" => "40848610"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
11 => array:11 [
"RoomKey" => "1687972554"
"RoomType" => "Dining room"
"ListingId" => "40848610"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
12 => array:11 [
"RoomKey" => "1687972555"
"RoomType" => "Kitchen"
"ListingId" => "40848610"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038737"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:16.94Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30038737/79-braeheid-avenue-unit-6-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1349
+"OriginalEntryTimestamp": "2026-07-15T21:18:26.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30038737_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/1b11690d3347b3791b8e2828f1cca363.webp"
"MediaSize" => 129830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-1b11690d3347b3791b8e2828f1cca363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30038737_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/eca91a006cf8ced4398019cc897ca617.webp"
"MediaSize" => 123522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-eca91a006cf8ced4398019cc897ca617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30038737_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/5b2a34262d22d33b0a46f5ec51ea8f47.webp"
"MediaSize" => 54926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-5b2a34262d22d33b0a46f5ec51ea8f47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30038737_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/2097c2df2b53df016c9e0e711ba57144.webp"
"MediaSize" => 57424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-2097c2df2b53df016c9e0e711ba57144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30038737_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/10b0c0e22baaceac576b3ff86ab98637.webp"
"MediaSize" => 57138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-10b0c0e22baaceac576b3ff86ab98637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30038737_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/0800450dd83b9de8d8736b09a3e3f5d7.webp"
"MediaSize" => 65341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-0800450dd83b9de8d8736b09a3e3f5d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30038737_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/2ce0bfa861fb78e9b50418440cf272be.webp"
"MediaSize" => 66994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-2ce0bfa861fb78e9b50418440cf272be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30038737_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/41ae45ca9d2f5f148310b864352cd316.webp"
"MediaSize" => 72504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-41ae45ca9d2f5f148310b864352cd316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30038737_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/3c5d0322c1ff2827f3392edb83882cee.webp"
"MediaSize" => 91613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-3c5d0322c1ff2827f3392edb83882cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30038737_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/f3f2b9e6276bcbb6bb1fcc17f11b480f.webp"
"MediaSize" => 84462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038737/thumbnail-f3f2b9e6276bcbb6bb1fcc17f11b480f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848610"
"ResourceRecordKey" => "30038737"
"ModificationTimestamp" => "2026-07-15T21:18:26.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30038737_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038737/d8cd4a3845f10108e9c7312729abbead.webp"
"MediaSize" => 69016
…9
]
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038737')"
+"ID": "1636895"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25418
+post_id: "1636875"
+post_author: 1
+"ListingKey": "30040002"
+"ListingId": "40848382"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T01:05:17Z"
+"RFModificationTimestamp": "2026-07-21T01:08:16Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2700.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "39 AVANTI Crescent, Waterdown, Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8829439
1 => 43.334933
]
+"Latitude": 43.334933
+"Longitude": -79.8829439
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional Starlane built executive home, ideally located on a quiet crescent in the highly desirable Mountainview Heights community of Waterdown. Surrounded by beautiful homes and welcoming neighbours, this family friendly neighbourhood offers parks, playgrounds, scenic trails and sought after schools. Enjoy easy access to shopping, restaurants, GO Transit, major highways and the Niagara Escarpment, making this the perfect place to enjoy both convenience and an active lifestyle. Offering approximately 4,000 sq. ft. of finished living space, including a professionally finished basement, this meticulously maintained home showcases approximately $350K in upgrades. Designed for family living and entertaining, the main floor features an elegant dining room with butler's pantry, upgraded kitchen with granite countertops, premium appliances and a spacious family room overlooking the backyard oasis. Upstairs offers a rare layout with four spacious bedrooms, including two private primary retreats, each with a walk in closet and ensuite bathroom. The additional bedrooms share a convenient Jack and Jill bathroom, creating an ideal setup for families. The finished basement adds two bedrooms, a full bathroom, large recreation room and ample storage, providing exceptional flexibility for guests, teens or extended family. The south facing backyard is a private retreat featuring a heated saltwater in ground pool with non slip concrete surround, professionally installed trench drains, custom cedar gazebo, elevated deck with natural gas BBQ hookup and beautifully landscaped grounds. Perfect for entertaining, relaxing and creating lasting memories with family and friends throughout the summer months. A rare opportunity to own a beautifully upgraded Starlane home in one of Waterdown's most desirable communities, offering exceptional space, privacy and a lifestyle you'll love. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:31:12.312980+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T20:23:39Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T00:59:19Z"
+"Stories": "2.0"
+"StreetName": "AVANTI"
+"StreetNumber": "39"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8891.77"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/39-Avanti-Cres"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30040002/39-avanti-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R1-62"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2700
+"OriginalEntryTimestamp": "2026-07-16T01:59:04.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1218041"
+"ListOfficeNationalAssociationId": "1473831"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040002')"
+"ID": "1636875"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25415
+post_id: "1630783"
+post_author: 1
+"ListingKey": "30042462"
+"ListingId": "X13571784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T12:20:14Z"
+"RFModificationTimestamp": "2026-07-20T12:23:25Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0N9"
+"UnparsedAddress": "7 ARNHEM COURT, Hamilton (Waterdown), Ontario L8B0N9"
+"Coordinates": array:2 [
0 => -79.913283
1 => 43.324504
]
+"Latitude": 43.324504
+"Longitude": -79.913283
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional Multigenerational Living in the Heart of Waterdown.Welcome to this beautifully maintained 5+2 -bedroom home, thoughtfully designed for today's modern family. Located in one of Waterdown's most sought-after neighbourhoods, this spacious property offers exceptional versatility, generous living space, and outstanding multigenerational potential.The bright and inviting main level features expansive principal rooms and five generously sized bedrooms, providing plenty of space for large or growing families. A separate entrance leads to a fully finished two-bedroom lower level, offering an ideal setup for extended family, adult children, in-laws, guests, or potential rental income (buyer to verify permitted uses).Step outside to your private backyard oasis, complete with a sparkling heated salt water swimming pool-perfect for entertaining, hosting summer gatherings, or simply relaxing in your own peaceful retreat.Enjoy everything Waterdown has to offer, from its welcoming small-town charm to its exceptional convenience. You'll be just minutes from highly regarded schools, parks, scenic trails, shopping, restaurants, Aldershot GO Station, and major highways, with easy access to Burlington, Hamilton, and the GTA.Whether you're searching for a home that comfortably accommodates multiple generations, offers flexible living arrangements, or presents the opportunity for supplemental rental income, this exceptional property delivers the space, lifestyle, and location you've been waiting for. Please Request the LIST of The Upgrades and Improvements to this beautiful property ! (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Water meter"
3 => "Oven"
4 => "Microwave"
5 => "Freezer"
6 => "Garage door opener remote(s)"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T17:20:59.371969+00:00"
+"Directions": "Hollybush Dr. and Arnhem Ct."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1904498"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "74.6 x 134.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T16:40:53Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T12:11:26Z"
+"Stories": "2.0"
+"StreetName": "Arnhem"
+"StreetNumber": "7"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "9246.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/7_arnhem_ct_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30042462/7-arnhem-court-hamilton-waterdown-waterdown"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R1-2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 74.7
+"OriginalEntryTimestamp": "2026-07-16T16:40:52.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1219386"
+"ListOfficeNationalAssociationId": "1003210"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042462')"
+"ID": "1630783"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25419
+post_id: "1628145"
+post_author: 1
+"ListingKey": "30037921"
+"ListingId": "X13568170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T19:35:18Z"
+"RFModificationTimestamp": "2026-07-15T19:45:38Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "411 - 30 HAMILTON STREET S, Hamilton (Waterdown), Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.893998
1 => 43.330366
]
+"Latitude": 43.330366
+"Longitude": -79.893998
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 411-30 Hamilton St S, a beautifully maintained corner unit, 1-bedroom condo offering a bright, open-concept layout, modern finishes, 2 parking spaces and an unbeatable location in the heart of Waterdown! Upon entering, you'll notice the stunning kitchen with fresh white cabinetry, sleek quartz counters, high-end S/S appliances, subway tile backsplash & spacious centre island with seating-perfect for casual dining or entertaining friends. The sun-filled living & dining area is framed by oversized windows & sliding glass doors that flood the space with natural light while providing seamless access to private balcony. Whether you're enjoying your morning coffee or unwinding after a long day, it's the perfect outdoor retreat. Spacious bedroom with large window, generous dbl closet & lots of room for a king-sized bed. Stylish 4pc bathroom boasts a modern quartz vanity & tub/shower. In-suite stacked laundry adds everyday convenience. Unit includes 1 underground parking space, an additional surface parking space & ample visitor parking for guests. Enjoy an impressive array of amenities including fully equipped fitness centre, beautifully appointed main-floor & 6th-floor terraces with BBQs & panoramic views, sophisticated party lounge with a library, meeting room, electric vehicle charging station, secure bike storage, pet washing station, impeccably maintained common spaces & convenience of fulltime concierge. Enjoy an unbeatable location with everything at your doorstep. Just 4-min walk away you'll find a shopping plaza with a grocery store, Shoppers Drug Mart, banks, restaurants, cafes & other everyday conveniences. You're also just mins from charming downtown Waterdown, beautiful parks, trails & major highways for effortless commuting. Perfect blend of walkability, convenience & low-maintenance living. Whether you're a first-time buyer, downsizer or investor, this move-in-ready condo offers incredible value in one of Waterdown's most desirable buildings (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "633.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T19:45:29.084434+00:00"
+"Directions": "Barton St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953737"
+"ListOfficeKey": "85454"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T19:29:17Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T19:29:17Z"
+"StreetDirSuffix": "South"
+"StreetName": "Hamilton"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4049.4"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30037921/411-30-hamilton-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2017352"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "85454"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-15T19:29:17.69Z"
+"ListAgentNationalAssociationId": "1246950"
+"ListOfficeNationalAssociationId": "1187906"
+"CoListAgentNationalAssociationId": "1298494"
+"CoListOfficeNationalAssociationId": "1187906"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037921')"
+"ID": "1628145"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25417
+post_id: "1627666"
+post_author: 1
+"ListingKey": "30037724"
+"ListingId": "40845258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T19:20:06Z"
+"RFModificationTimestamp": "2026-07-15T19:23:43Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1V8"
+"UnparsedAddress": "30 HAMILTON Street S Unit# 411, Waterdown, Ontario L8B1V8"
+"Coordinates": array:2 [
0 => -79.8938615
1 => 43.330413
]
+"Latitude": 43.330413
+"Longitude": -79.8938615
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 411-30 Hamilton St S, a beautifully maintained corner unit, 1-bedroom condo offering a bright, open-concept layout, modern finishes, 2 parking spaces and an unbeatable location in the heart of Waterdown! Upon entering, you'll notice the stunning kitchen with fresh white cabinetry, sleek quartz counters, high-end S/S appliances, subway tile backsplash & spacious centre island with seating—perfect for casual dining or entertaining friends. The sun-filled living & dining area is framed by oversized windows & sliding glass doors that flood the space with natural light while providing seamless access to private balcony. Whether you're enjoying your morning coffee or unwinding after a long day, it's the perfect outdoor retreat. Spacious bedroom with large window, generous dbl closet & lots of room for a king-sized bed. Stylish 4pc bathroom boasts a modern quartz vanity & tub/shower. In-suite stacked laundry adds everyday convenience. Unit includes 1 underground parking space, an additional surface parking space & ample visitor parking for guests. Enjoy an impressive array of amenities including fully equipped fitness centre, beautifully appointed main-floor & 6th-floor terraces with BBQs & panoramic views, sophisticated party lounge with a library, meeting room, electric vehicle charging station, secure bike storage, pet washing station, impeccably maintained common spaces & convenience of full-time concierge. Enjoy an unbeatable location with everything at your doorstep. Just 4-min walk away you'll find a shopping plaza with a grocery store, Shoppers Drug Mart, banks, restaurants, cafes & other everyday conveniences. You're also just mins from charming downtown Waterdown, beautiful parks, trails & major highways for effortless commuting. Perfect blend of walkability, convenience & low-maintenance living. Whether you're a first-time buyer, downsizer or investor, this move-in-ready condo offers incredible value in one of Waterdown's most desirable buildings (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "633.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T19:15:12.697844+00:00"
+"Directions": "Barton St"
+"ExteriorFeatures": array:4 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
3 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237567"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-15T19:11:53Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T19:18:37Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "HAMILTON"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4049.4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30037724/30-hamilton-street-s-unit-411-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R8-1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-07-15T19:00:03.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1475453"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037724')"
+"ID": "1627666"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25411
+post_id: "1627222"
+post_author: 1
+"ListingKey": "30035514"
+"ListingId": "X13565504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T14:50:06Z"
+"RFModificationTimestamp": "2026-07-15T17:40:33Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A4"
+"UnparsedAddress": "214 - 5 HAMILTON STREET N, Hamilton (Waterdown), Ontario L8B2A4"
+"Coordinates": array:2 [
0 => -79.896456
1 => 43.331203
]
+"Latitude": 43.331203
+"Longitude": -79.896456
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 214 at 5 Hamilton Street North, where contemporary style meets small-town charm in the heart of vibrant Waterdown. This beautifully appointed 2-bedroom, 2-bathroom condo offers the perfect blend of comfort, functionality, and modern design. Step inside to a bright, open-concept layout featuring floor-to-ceiling windows that flood the space with natural light, creating an airy and inviting atmosphere throughout. The carpet-free interior provides a clean, modern aesthetic and low-maintenance living, while the thoughtfully designed floor plan is ideal for both everyday living and entertaining. From the spacious kitchen you can easily see the living and dining areas, conveniently staying connected while preparing meals or hosting family and friends. The primary bedroom offers a private retreat complete with its own ensuite bathroom, while the second bedroom is perfect for guests, a home office, or growing families. A second full bathroom adds convenience and flexibility for visitors. Enjoy your morning coffee or unwind at the end of the day on your private balcony, surrounded by the charm of one of Waterdown's newest boutique condominium communities. This six-story building offers modern construction and an unbeatable location just steps from downtown shops, restaurants, cafés, parks, and everyday amenities, with quick access to major highways, Aldershot GO Station, Burlington, Hamilton, and the Niagara Escarpment. Whether you're a first-time buyer, downsizer, or investor, this exceptional home offers stylish, low-maintenance living in one of Waterdown's most desirable locations. Move in, unpack, and enjoy everything this thriving community has to offer. Unit 214 is the perfect place to call home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "475.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T17:40:30.175289+00:00"
+"Directions": "Dundas Street E and Hamilton Street N"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Tile"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104597"
+"ListOfficeKey": "288501"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-15T14:40:56Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T14:40:55Z"
+"StreetDirSuffix": "North"
+"StreetName": "Hamilton"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4193.1"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/214-5-hamilton-street-north-waterdown/"
+"Rooms": array:6 [
0 => array:11 [ …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/30035514/214-5-hamilton-street-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "PROPERTY MANAGEMENT GUILD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-15T14:40:55.97Z"
+"ListAgentNationalAssociationId": "1373973"
+"ListOfficeNationalAssociationId": "1368759"
+"Media": array:28 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035514')"
+"ID": "1627222"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23539
+post_id: "1626132"
+post_author: 1
+"ListingKey": "30034489"
+"ListingId": "X13564610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T15:50:05Z"
+"RFModificationTimestamp": "2026-07-20T16:45:19Z"
+"ListPrice": 795900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0K3"
+"UnparsedAddress": "34 KILDONAN CRESCENT, Hamilton (Waterdown), Ontario L8B0K3"
+"Coordinates": array:2 [
0 => -79.912882
1 => 43.321118
]
+"Latitude": 43.321118
+"Longitude": -79.912882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 34 Kildonan Crescent, a beautifully maintained home situated on a quiet, family-friendly crescent in one of Waterdown's most desirable neighbourhoods. Backing directly ontoscenic trails and green space with no rear neighbours, this property offers exceptionalprivacy and a peaceful natural setting.Inside, you'll find a bright and inviting layout featuring hardwood flooring, pot lightsthroughout, spacious principal rooms, and abundant natural light. The primary bedroom includesa ceiling fan for added comfort. Smart-home enthusiasts will appreciate the impressivetechnology package, including a 15-inch Alexa control centre, smart switches, smart lightingon all levels, and a smart front-door lock with fingerprint entry.Extensively updated and move-in ready, this home features a new patio door (2020), owned airconditioner (2021), renovated washrooms (2022), front door and second-floor windows (2022),energy-efficient main-level windows (2025), a newly reconstructed backyard deck (2025), and anew refrigerator (2025). The furnace, air conditioner, and water heater are all fully owned,providing added value and eliminating rental costs.Step outside to your private backyard retreat overlooking mature greenery and walking trails -perfect for entertaining, relaxing, or enjoying nature year-round. Conveniently located nearparks, schools, shopping, dining, and commuter routes, this meticulously cared-for home offersan exceptional opportunity to enjoy the best of Waterdown living. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T06:45:14.695233+00:00"
+"Directions": "Cross Streets: Dundas Street East & Burke Street. ** Directions: Hwy 403 to Hwy 6 North, exit at Dundas St. E., right on Burke St., left on Kildonan Crescent."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074363"
+"ListOfficeKey": "283868"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "26.3 x 133.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T05:03:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T15:40:11Z"
+"Stories": "2.0"
+"StreetName": "Kildonan"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4880.37"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/oNxwtfAeCQA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30034489/34-kildonan-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.3
+"OriginalEntryTimestamp": "2026-07-15T05:03:02.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1349557"
+"ListOfficeNationalAssociationId": "1336201"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034489')"
+"ID": "1626132"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1620942"
+post_author: 1
+"ListingKey": "30027846"
+"ListingId": "X13558740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T12:20:12Z"
+"RFModificationTimestamp": "2026-07-20T12:23:41Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO STREET, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.891184
1 => 43.331196
]
+"Latitude": 43.331196
+"Longitude": -79.891184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:43:18.555618+00:00"
+"Directions": "Cross Streets: Flamboro St. and Barton St. ** Directions: Take Highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Flat site"
3 => "Carpet Free"
]
+"LotSizeDimensions": "68.1 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T21:40:18Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T12:11:07Z"
+"Stories": "1.0"
+"StreetName": "Flamboro"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30027846/75-flamboro-street-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-13T21:40:18.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027846')"
+"ID": "1620942"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25421
+post_id: "1620738"
+post_author: 1
+"ListingKey": "30027582"
+"ListingId": "40847601"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T20:25:18Z"
+"RFModificationTimestamp": "2026-07-19T20:28:10Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "75 FLAMBORO Street, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8912452
1 => 43.3312034
]
+"Latitude": 43.3312034
+"Longitude": -79.8912452
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3+1 bedroom, 2-bathroom home, ideally located in the heart of Waterdown's historic village. Recent updates include five new main-floor windows and a full suite of new appliances in the kitchen, adding both comfort and value to this move in ready property. Set on a quiet, tree-lined street in a mature and sought-after neighbourhood, this bright and inviting home offers the perfect blend of small-town charm and everyday convenience. Enjoy a walkable lifestyle just steps from downtown Waterdown's shops, restaurants, parks, and scenic trails, with Seeley Park only a 4-minute walk away. Commuters will appreciate quick access to major highways and the convenience of the nearby GO Transit station, located just 7 minutes away. Inside, natural light fills the warm and functional living spaces, creating an inviting atmosphere throughout. The spacious finished basement adds exceptional versatility, featuring a fourth bedroom and abundant storage, making it ideal for guests, a home office, a playroom, or a comfortable family room. Step outside to a generous backyard with plenty of room to relax, entertain, garden, or enjoy time with family and friends. Whether you're hosting summer gatherings or simply unwinding in your own private outdoor space, this backyard offers endless possibilities. With excellent schools, parks, and community amenities nearby, this move-in-ready home is perfectly suited for young families, downsizers, or anyone seeking the charm and convenience of village living. Don't miss this opportunity to own a wonderful home in one of Waterdown's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T21:46:37.455766+00:00"
+"Directions": "Take highway 5 into Waterdown from Burlington. Turn left at Flamboro St., just past Main St. The home is on the left side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024789"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-13T21:18:11Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T20:18:40Z"
+"Stories": "1.0"
+"StreetName": "FLAMBORO"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6797.12"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027582/75-flamboro-street-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 992
+"OriginalEntryTimestamp": "2026-07-13T21:18:11.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304516"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063598"
+"CoListOfficeNationalAssociationId": "1325425"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027582')"
+"ID": "1620738"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]