array:6 [
"RF Cache Key: 5b0b2f0f7dfed329c2ffb48524f455d4f45808787a2785e3bbae78b29639c6e7" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21987
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23584
+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": 247
+"@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 {#24994
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25054
+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.16 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 {#24989
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 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 {#25381
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFPropertyAdditionalInfo {#25379
+"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.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29127642' AND OpenHouseDate ge '2026-07-26'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25396
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 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 {#25513
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25484
+post_id: "1656575"
+post_author: 1
+"ListingKey": "30076777"
+"ListingId": "X13603448"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T12:10:24Z"
+"RFModificationTimestamp": "2026-07-26T12:11:39Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON CLOSE, Hamilton (Waterdown), Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8871256
1 => 43.3398225
]
+"Latitude": 43.3398225
+"Longitude": -79.8871256
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:08:45.605271+00:00"
+"Directions": "Cross Streets: Dundas & Burke. ** Directions: Dundas St E N on Burke W on Boulding Right on Milverton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958279"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 129.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:59:17Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T12:08:32Z"
+"Stories": "1.0"
+"StreetName": "Milverton"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1693769197"
"RoomType" => "Foyer"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.52
"ListingKey" => "30076777"
"RoomLength" => 1.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
1 => array:11 [
"RoomKey" => "1693769198"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 1.07
"ListingKey" => "30076777"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
2 => array:11 [
"RoomKey" => "1693769199"
"RoomType" => "Laundry room"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.74
"ListingKey" => "30076777"
"RoomLength" => 4.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
3 => array:11 [
"RoomKey" => "1693769200"
"RoomType" => "Bedroom 4"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 2.75
"ListingKey" => "30076777"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
4 => array:11 [
"RoomKey" => "1693769201"
"RoomType" => "Other"
"ListingId" => "X13603448"
"RoomLevel" => "Basement"
"RoomWidth" => 4.06
"ListingKey" => "30076777"
"RoomLength" => 7.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
5 => array:11 [
"RoomKey" => "1693769202"
"RoomType" => "Living room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.94
"ListingKey" => "30076777"
"RoomLength" => 4.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
6 => array:11 [
"RoomKey" => "1693769203"
"RoomType" => "Dining room"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.03
"ListingKey" => "30076777"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
7 => array:11 [
"RoomKey" => "1693769204"
"RoomType" => "Kitchen"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.06
"ListingKey" => "30076777"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
8 => array:11 [
"RoomKey" => "1693769205"
"RoomType" => "Eating area"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 1.84
"ListingKey" => "30076777"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
9 => array:11 [
"RoomKey" => "1693769206"
"RoomType" => "Bathroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.22
"ListingKey" => "30076777"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
10 => array:11 [
"RoomKey" => "1693769207"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "30076777"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
11 => array:11 [
"RoomKey" => "1693769208"
"RoomType" => "Bedroom 2"
"ListingId" => "X13603448"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30076777"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-26T12:08:32.78Z"
]
12 => array:11 [
"RoomKey" => "1693769209"
"RoomType" => "Bedroom 3"
…9
]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076777/45-milverton-close-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-07-24T18:39:38.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249182"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076777')"
+"ID": "1656575"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25486
+post_id: "1656576"
+post_author: 1
+"ListingKey": "30076485"
+"ListingId": "40850027"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:24Z"
+"RFModificationTimestamp": "2026-07-26T20:38:21Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.18
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0A9"
+"UnparsedAddress": "45 MILVERTON Close, Waterdown, Ontario L8B0A9"
+"Coordinates": array:2 [
0 => -79.8875341
1 => 43.3401784
]
+"Latitude": 43.3401784
+"Longitude": -79.8875341
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this all-brick raised ranch situated on a huge 60' x 130' lot on a quiet crescent. This 3+1-bedroom home offers fantastic curb appeal with a landscaped front yard, inviting front porch, 1.5-car garage, and double-wide driveway. Bright and spacious living room with bay window opens to the dining room, creating a great space for entertaining. Updated eat-in kitchen features abundant cabinetry, crown moulding, peninsula with built-in display hutch, and eating area. Updated full bathroom boasts a glass door shower with rainfall showerhead, large vanity, and additional storage cabinets. The lower level is equipped with a cozy rec room with a gas fireplace and wall-to-wall brick surround, plus a versatile flex room ideal for a home office, gym, hobby room, or playroom. An additional room (unfinished) perfect for your storage needs. Enjoy the large, landscaped and fenced backyard with plenty of space for kids, pets, and outdoor entertaining. Conveniently located close to parks, schools, shopping, and walking trails. Don't miss out! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T18:32:25.657182+00:00"
+"Directions": "Dundas St E, N on Burke W, on Boulding Right, on Milverton"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1528670"
+"ListOfficeKey": "268714"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:57Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:28Z"
+"Stories": "1.0"
+"StreetName": "MILVERTON"
+"StreetNumber": "45"
+"StreetSuffix": "Close"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6167.75"
+"VirtualTourURLUnbranded": "https://youriguide.com/45_milverton_close_waterdown_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30076485/45-milverton-close-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524684"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1218
+"OriginalEntryTimestamp": "2026-07-24T18:08:36.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140396"
+"ListOfficeNationalAssociationId": "1230749"
+"CoListAgentNationalAssociationId": "1063363"
+"CoListOfficeNationalAssociationId": "1330157"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076485')"
+"ID": "1656576"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25483
+post_id: "1653711"
+post_author: 1
+"ListingKey": "30070675"
+"ListingId": "40850288"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:30:16Z"
+"RFModificationTimestamp": "2026-07-24T18:34:35Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3763.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL Crescent, Waterdown, Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.9054139
1 => 43.3203351
]
+"Latitude": 43.3203351
+"Longitude": -79.9054139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:42:14.280225+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:15:59Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:15:59Z"
+"Stories": "1.0"
+"StreetName": "WATERWHEEL"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "9709.99"
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070675/54-waterwheel-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.0
+"AboveGradeFinishedArea": 2317
+"BelowGradeFinishedArea": 1446
+"OriginalEntryTimestamp": "2026-07-23T16:29:06.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070675')"
+"ID": "1653711"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25510
+post_id: "1653718"
+post_author: 1
+"ListingKey": "30071102"
+"ListingId": "X13598280"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:05Z"
+"RFModificationTimestamp": "2026-07-24T18:51:37Z"
+"ListPrice": 1699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L9H7B7"
+"UnparsedAddress": "54 WATERWHEEL CRESCENT, Hamilton (Waterdown), Ontario L9H7B7"
+"Coordinates": array:2 [
0 => -79.905431
1 => 43.320341
]
+"Latitude": 43.320341
+"Longitude": -79.905431
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover an exceptional bungalow living in the heart of Waterdown, a community known for its charming downtown, parks, scenic trails, and outstanding family-friendly lifestyle. Offering 4 bedrooms, 3 bathrooms, and approximately 3,583 sq ft of finished living space, this beautifully updated home blends timeless design with sophisticated modern finishes. Set on a spectacular property, the private backyard retreat features a tranquil pond, greenhouse, mature landscaping, and expansive outdoor living spaces for relaxing and entertaining. A welcoming foyer opens into an impressive great room, where expansive windows overlook the backyard and a gas fireplace creates a warm focal point. Seamlessly connected to the updated eat-in kitchen, this inviting space is ideal for everyday living and entertaining. The kitchen features abundant cabinetry, a centre island, generous prep space, and a walkout to the side yard. A dedicated home office provides excellent flexibility for today's lifestyle. The spacious primary retreat offers a walk-in closet and beautifully renovated 4pc ensuite with a glass-enclosed shower. an additional bedroom, a 4pc bathroom, and convenient main floor laundry complete the level. The fully finished walkout lower level extends the living space with a spacious recreation room centered around a second fireplace, wet bar, two additional bedrooms, full bathroom, and exceptional storage. A full-size walkout provides direct access to the lower backyard, making this level ideal for guests, recreation, hobbies, or multi-generational living. Step outside and experience a backyard unlike any other. The peaceful pond, greenhouse, mature gardens, and generous outdoor living areas create a private setting to enjoy year-round. Beautifully updated with a sophisticated contemporary aesthetic, exceptional living spaces, and an extraordinary backyard retreat, this remarkable bungalow offers a rare opportunity to enjoy one of Waterdown's most sought-after settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:19:28.284825+00:00"
+"Directions": "Dundas St E & Hollybush Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "82.3 x 105.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:28Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:28Z"
+"Stories": "1.0"
+"StreetName": "Waterwheel"
+"StreetNumber": "54"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9707.99"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/S4slIHBLukc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071102/54-waterwheel-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 82.3
+"OriginalEntryTimestamp": "2026-07-23T17:09:52.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071102')"
+"ID": "1653718"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25485
+post_id: "1649084"
+post_author: 1
+"ListingKey": "30066216"
+"ListingId": "X13593728"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:45:04Z"
+"RFModificationTimestamp": "2026-07-22T19:05:04Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID AVENUE, Hamilton (Waterdown), Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.907713
1 => 43.328158
]
+"Latitude": 43.328158
+"Longitude": -79.907713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:04:54.109562+00:00"
+"Directions": "Dundas St. N to Riley St. to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T17:37:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T17:37:22Z"
+"Stories": "2.0"
+"StreetName": "Braeheid"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5374.8"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/24_braeheid_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30066216/24-braeheid-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-22T17:37:22.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066216')"
+"ID": "1649084"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25480
+post_id: "1648557"
+post_author: 1
+"ListingKey": "30065389"
+"ListingId": "40850232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T16:15:08Z"
+"RFModificationTimestamp": "2026-07-22T16:36:51Z"
+"ListPrice": 959900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2392.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0C5"
+"UnparsedAddress": "24 BRAEHEID Avenue, Waterdown, Ontario L8B0C5"
+"Coordinates": array:2 [
0 => -79.9071668
1 => 43.3279388
]
+"Latitude": 43.3279388
+"Longitude": -79.9071668
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare chance to own a detached 2 storey on a premium 120' lot in a highly desirable, family friendly neighbourhood. Why settle for a semi or townhouse when you can have the space, privacy, and long term upside of a detached home? This move in ready property is perfect for value conscious buyers, offering more land and living space than comparable semis and townhomes nearby. The bright, open layout features a modern kitchen with quartz countertops and stainless steel appliances, flowing into spacious living and dining areas that are great for both everyday living and entertaining. Upstairs, you'll find generously sized bedrooms along with a fully updated main bathroom and a renovated primary ensuite. The finished basement adds even more functional space, complete with a cozy rec room and electric fireplace, ideal for relaxing, a home gym, or a kids' play area. Step outside to a large deck perfect for outdoor living. Located just steps from parks and schools, and only minutes to shopping, dining, and all your daily essentials. Detached living in a prime location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T16:36:38.024251+00:00"
+"Directions": "Dundas St N to Riley St to Braeheid Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198019"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T16:08:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T16:08:41Z"
+"Stories": "2.0"
+"StreetName": "BRAEHEID"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "460 - Waterdown West"
+"TaxAnnualAmount": "5374.8"
+"VirtualTourURLUnbranded": "https://youriguide.com/24_braeheid_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065389/24-braeheid-avenue-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1642
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2026-07-22T16:08:41.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446394"
+"ListOfficeNationalAssociationId": "1223032"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065389')"
+"ID": "1648557"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1647044"
+post_author: 1
+"ListingKey": "30062342"
+"ListingId": "W13590216"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T20:45:05Z"
+"RFModificationTimestamp": "2026-07-21T23:03:03Z"
+"ListPrice": 2450000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Grindstone)"
+"PostalCode": "L7P4Y6"
+"UnparsedAddress": "521 OLD YORK ROAD, Burlington (Grindstone), Ontario L7P4Y6"
+"Coordinates": array:2 [
0 => -79.893477
1 => 43.311038
]
+"Latitude": 43.311038
+"Longitude": -79.893477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client Remarks*Magnificent 3600 Sq Ft Detached on 3 Acres of Land* This One of A Kind Beautiful Custom Living Retreat Offers a Perfect Blend of Comfort, Luxury and Natural Beauty. The Property Seamlessly Combines the Best of Both, Town and Country Lifestyles. This Special Home, Rebuilt From Foundation Up, Is Like No Other In The Neighbourhood. Step Outside To Enjoy the Fresh, Coastal Vibes With Peaceful Atmosphere and You Will Never Leave. The Kitchen is Chef's Dream, Equipped With South American Granite, Massive Centre Island, 36" Stove With Pot Filler Faucet and Stainless Steel Appliances. Overlooking The Kitchen is the "Great Room" with 22 Ft Cathedral Ceilings, Open Concept, Sunny Dining Room, Fireplace, Hardwood Flooring Adding Warmth and Charm to the Living Area. Many Large Windows Bring The Outside In. The End of the Main Floor Seamlessly Flows Into Primary Bedroom With Walk-Through Closet And 4pc Ensuite, Another Bedroom, 2pc Bath And Laundry With Access to Garage. Two Bedrooms With Private Bathrooms are Located on the Upper Level But a 4th Bedroom Also Features a Balcony. The Spectacular Lower Level Boasts a Large Family Room, Fireplace, Office and 3-pc Baths. One of the Most Exciting Parts of this Home is a Private, Huge Backyard That Borders the Conservation Area. Nature Lovers Will Appreciate Its Enhanced Privacy Ensuring That Building Is Not Allowed Past the Tree Line and Preserving The Natural Beauty of the Area for Generations to Come. Step Outside on 2-Tiered Deck and Enjoy the Sunrise, Sunsets and All The Beauty The Scenic View Has to Offer! (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T23:02:46.694966+00:00"
+"Directions": "Plains Rd W. & Old York Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Hardwood"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406474"
+"ListOfficeKey": "50914"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Backs on greenbelt"
2 => "Open space"
3 => "Hilly"
]
+"LotSizeDimensions": "136.5 x 1017.5 FT ; 140.12Ftx970.84Ftx136.56Ftx1017.54Ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T20:38:07Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T20:38:07Z"
+"StreetName": "Old York"
+"StreetNumber": "521"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7455.64"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "View"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/459542"
+"WaterSource": array:1 [
0 => "Cistern"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Grindstone"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30062342/521-old-york-road-burlington-grindstone-grindstone"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "RNA1,03-196 DNA"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 136.6
+"OriginalEntryTimestamp": "2026-07-21T20:38:07.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1070488"
+"ListOfficeNationalAssociationId": "1002617"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30062342')"
+"ID": "1647044"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25511
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "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 [ …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]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038737')"
+"ID": "1636895"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25512
+post_id: "1636875"
+post_author: 1
+"ListingKey": "30040002"
+"ListingId": "40848382"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:15Z"
+"RFModificationTimestamp": "2026-07-26T20:39:46Z"
+"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-26T20:29:53Z"
+"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": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040002')"
+"ID": "1636875"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]