array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29127642/Property?$select=ALL&$top=20&$filter=ListingKey eq 29127642&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29127642/Property?$select=ALL&$top=20&$filter=ListingKey eq 29127642&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23618
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23620
+post_id: "436984"
+post_author: 1
+"ListingKey": "29127642"
+"ListingId": "40786336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T16:20:16Z"
+"RFModificationTimestamp": "2025-11-22T16:22:50Z"
+"ListPrice": 2299000.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:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T21:09:33Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T16:09:42Z"
+"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" => "1538107151"
"RoomType" => "Kitchen"
"ListingId" => "40786336"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.75Z"
]
1 => array:11 [
"RoomKey" => "1538107152"
"RoomType" => "3pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.76Z"
]
2 => array:11 [
"RoomKey" => "1538107153"
"RoomType" => "2pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.76Z"
]
3 => array:11 [
"RoomKey" => "1538107154"
"RoomType" => "3pc Bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.76Z"
]
4 => array:11 [
"RoomKey" => "1538107155"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.77Z"
]
5 => array:11 [
"RoomKey" => "1538107156"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.77Z"
]
6 => array:11 [
"RoomKey" => "1538107157"
"RoomType" => "Bedroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.78Z"
]
7 => array:11 [
"RoomKey" => "1538107158"
"RoomType" => "Full bathroom"
"ListingId" => "40786336"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29127642"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T16:09:42.78Z"
]
8 => array:11 [
"RoomKey" => "1538107159"
"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" => "2025-11-22T16:09:42.79Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29127642/1962-snake-road-burlington"
+"ParkingTotal": 15
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "Nec Dev Control Area"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 2705
+"OriginalEntryTimestamp": "2025-11-21T21:09:33.76Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Erin Holowach"
"MemberFirstName" => "Erin"
"MemberLastName" => "Holowach"
"MemberMlsId" => "MI7501"
"OriginatingSystemName" => 26
"MemberKey" => "2216487"
"ModificationTimestamp" => "2025-10-28T23:35:39Z"
"MemberStatus" => "Active"
"OfficeKey" => "296698"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberCity" => "Edmonton"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "877-888-3131"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-05-10T16:17:00Z"
"MemberNationalAssociationId" => "1462159"
"OfficeNationalAssociationId" => "1461275"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "ComFree"
"OfficePhone" => "877-888-3131"
"OfficeMlsId" => "MIB7464"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "296698"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "10807 - 124 Street"
"OfficeCity" => "Edmonton"
"OfficePostalCode" => "T5M0H"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2024-04-26T18:19:00Z"
"OfficeNationalAssociationId" => "1461275"
"OfficeBrokerNationalAssociationId" => "1461221"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29127642')"
+"ID": "436984"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 296698/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296698&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296698/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296698&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25457
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25459
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ComFree"
+"OfficeEmail": null
+"OfficePhone": "877-888-3131"
+"OfficeMlsId": "MIB7464"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"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 - Hamilton-Burlington"
+"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" => "2025-08-19T15:26:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1461221"
+"@odata.id": "https://api.realtyfeed.com/reso/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/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2216487&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2216487/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2216487&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25462
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 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 {#25056
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFPropertyAdditionalInfo {#25058
+"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/reso/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/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29127642&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29127642/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29127642&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25037
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 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/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&$expand=Office,Member,Media/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/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&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25304
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24942
+post_id: "469747"
+post_author: 1
+"ListingKey": "29172783"
+"ListingId": "X12611344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T23:55:23Z"
+"RFModificationTimestamp": "2025-12-09T00:55:51Z"
+"ListPrice": 970000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y3"
+"UnparsedAddress": "42 EBENEZER DRIVE, Hamilton (Waterdown), Ontario L8B1Y3"
+"Coordinates": array:2 [
0 => -79.8779031
1 => 43.337885
]
+"Latitude": 43.337885
+"Longitude": -79.8779031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 2,400sqft home, offering 4 bedrooms + an office/den on the main floor + 4 bathrooms. With not one, but two primary suites featuring their own private ensuite, comfort and flexibility are built right in! Enjoy a bright, open-concept main floor with 9-foot ceilings + modern finishes, perfect for family time and entertainment. Parking is effortless with an extended driveway providing three spaces (one in the garage and two outside), completed with an upgraded 200-amp electrical panel, ideal for homeowners looking to install an EV charger at home. Located on a quiet street in the highly sought-after Mountainview Heights neighbourhood in Waterdown, you will be close to parks, top-rated schools, shopping, and transit services. This home is truly a turnkey opportunity! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2025-12-09T00:55:36.474686+00:00"
+"Directions": "Ebenezer Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046896"
+"ListOfficeKey": "64317"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved yard"
2 => "Carpet Free"
]
+"LotSizeDimensions": "27.9 x 107.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T23:45:35Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T23:45:35Z"
+"Stories": "2.0"
+"StreetName": "Ebenezer"
+"StreetNumber": "42"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7099.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1546930521"
"RoomType" => "Office"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 2.4384
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
1 => array:11 [
"RoomKey" => "1546930522"
"RoomType" => "Dining room"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5814
"ListingKey" => "29172783"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
2 => array:11 [
"RoomKey" => "1546930523"
"RoomType" => "Living room"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5814
"ListingKey" => "29172783"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
3 => array:11 [
"RoomKey" => "1546930524"
"RoomType" => "Kitchen"
"ListingId" => "X12611344"
"RoomLevel" => "Main level"
"RoomWidth" => 3.048
"ListingKey" => "29172783"
"RoomLength" => 7.3152
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
4 => array:11 [
"RoomKey" => "1546930525"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.6576
"ListingKey" => "29172783"
"RoomLength" => 5.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
5 => array:11 [
"RoomKey" => "1546930526"
"RoomType" => "Bedroom 3"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.566
"ListingKey" => "29172783"
"RoomLength" => 3.5814
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.74Z"
]
6 => array:11 [
"RoomKey" => "1546930527"
"RoomType" => "Bedroom 2"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.048
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.75Z"
]
7 => array:11 [
"RoomKey" => "1546930528"
"RoomType" => "Bedroom 4"
"ListingId" => "X12611344"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.1242
"ListingKey" => "29172783"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-08T23:45:35.75Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29172783/42-ebenezer-drive-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": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 27.1
+"OriginalEntryTimestamp": "2025-12-08T23:45:35.71Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:44 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362067416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7571bcf000afa83865a0cc8b8384bbeb.webp"
"MediaSize" => 265114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7571bcf000afa83865a0cc8b8384bbeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362067427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/ce12dbcc7b9443ff3e8477e07a2b9287.webp"
"MediaSize" => 295042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-ce12dbcc7b9443ff3e8477e07a2b9287.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362067435"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/d284c0041a48301e4ccaa150f7ce3bea.webp"
"MediaSize" => 185253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-d284c0041a48301e4ccaa150f7ce3bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362067446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/2b2c832fd097ed4e2abdecd6568d3310.webp"
"MediaSize" => 183833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-2b2c832fd097ed4e2abdecd6568d3310.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362067452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/58e238c490ff80d6cc26630121d2de9c.webp"
"MediaSize" => 125589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-58e238c490ff80d6cc26630121d2de9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362067460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/883d68a7963170757a8636421e1d24b7.webp"
"MediaSize" => 163408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-883d68a7963170757a8636421e1d24b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362067469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/7409e82ec34b85b120eca43ca1424315.webp"
"MediaSize" => 165911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-7409e82ec34b85b120eca43ca1424315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362067480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/d799c58164fad1ebb7d9471acb48784d.webp"
"MediaSize" => 162578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-d799c58164fad1ebb7d9471acb48784d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362067489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/9d786d270efd9fb7613f46c143dd917f.webp"
"MediaSize" => 172902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-9d786d270efd9fb7613f46c143dd917f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362067497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/5b6200cf28c8d84f563acf7a138fbc56.webp"
"MediaSize" => 145472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-5b6200cf28c8d84f563acf7a138fbc56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362067506"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/1740e2d156d272039ac98bd017bb0d00.webp"
"MediaSize" => 128671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-1740e2d156d272039ac98bd017bb0d00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362067515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/ec2bdfa3bafd34079388a4119d4df12b.webp"
"MediaSize" => 144194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-ec2bdfa3bafd34079388a4119d4df12b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362067532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/4fc24b8dd71b50c44a3ffa921f331888.webp"
"MediaSize" => 123978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-4fc24b8dd71b50c44a3ffa921f331888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362067543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/04ffb5762a013095ec2d5183d0e26ede.webp"
"MediaSize" => 121480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-04ffb5762a013095ec2d5183d0e26ede.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362067547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/329746fde7a15fa330ac08c2a99e920d.webp"
"MediaSize" => 88071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-329746fde7a15fa330ac08c2a99e920d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362067556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6e633a013447d67b25054b18a050e606.webp"
"MediaSize" => 137172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6e633a013447d67b25054b18a050e606.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362067561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/4a15a02b519ee921ccaab6b43ae89d16.webp"
"MediaSize" => 120338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-4a15a02b519ee921ccaab6b43ae89d16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362067569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6538b79ad41523d41b8f6f6726672884.webp"
"MediaSize" => 120523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6538b79ad41523d41b8f6f6726672884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362067572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/b0b8995426f8ff0f32dd94649a2f9c5d.webp"
"MediaSize" => 164993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-b0b8995426f8ff0f32dd94649a2f9c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362067586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6a5293c5b98ae59026c84c4fd41fa991.webp"
"MediaSize" => 160387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6a5293c5b98ae59026c84c4fd41fa991.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6362067593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/6ea5a0be8816859e08c010fed97380a4.webp"
"MediaSize" => 149734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-6ea5a0be8816859e08c010fed97380a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6362067597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/f965e98bb5e05ce41e68649d7d437cf8.webp"
"MediaSize" => 171509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-f965e98bb5e05ce41e68649d7d437cf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611344"
"ResourceRecordKey" => "29172783"
"ModificationTimestamp" => "2025-12-08T23:45:35.72Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6362067609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29172783/21ae95e37d68dede9d38e5cd98e8dc28.webp"
"MediaSize" => 141964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29172783/thumbnail-21ae95e37d68dede9d38e5cd98e8dc28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172783')"
+"ID": "469747"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "468273"
+post_author: 1
+"ListingKey": "29169820"
+"ListingId": "X12608304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T19:25:23Z"
+"RFModificationTimestamp": "2025-12-07T22:51:18Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "BASEMENT - 7 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8831437
1 => 43.3349547
]
+"Latitude": 43.3349547
+"Longitude": -79.8831437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully renovated, this bright and spacious 2 bed, 1 bath basement apartment features a private entrance and a prime location in Waterdown, just minutes from parks, major highways, downtown Burlington, and the lake. Enjoy the convenience of a Ensuite laundry room, driveway parking for one vehicle, and ample street parking. Located close to Aldershot GO Station for easy commuting. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-07T22:51:07.326532+00:00"
+"Directions": "Dundas & Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157654"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "11.9 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-07T19:17:30Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T19:17:30Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29169820/basement-7-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1529658"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "84654"
+"GeocodeManualYN": false
+"TotalActualRent": 2150
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 11.9
+"OriginalEntryTimestamp": "2025-12-07T19:17:30.06Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169820')"
+"ID": "468273"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "467329"
+post_author: 1
+"ListingKey": "29168655"
+"ListingId": "40792313"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T22:10:36Z"
+"RFModificationTimestamp": "2025-12-08T22:14:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y3"
+"UnparsedAddress": "112 SKINNER Road, Hamilton, Ontario L8B1Y3"
+"Coordinates": array:2 [
0 => -79.879877
1 => 43.338415
]
+"Latitude": 43.338415
+"Longitude": -79.879877
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Like new immaculately maintained Semi Detached house in Waterdown's most desirable neighbourhood. Beautifully landscaped backyard. Single car garage plus widened driveway. 3 Bedrooms & 3 Baths, Open Concept Main Level with quality Laminate Floors & 9' Ceilings, Modern Kitchen with central island and Stainless Steel Appliances. Primary Bedroom with 4 Pc Ensuite, Minutes To Hwy 407, Qew & Go Stations, 15 Minutes To Mcmaster, Close To Shopping & Schools. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T16:40:35.261842+00:00"
+"Directions": "Dundas St. E. to Burke St. to Skinner Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T22:00:10Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T22:00:10Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "112"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29168655/112-skinner-road-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-12-06T14:30:04.25Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168655')"
+"ID": "467329"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "464308"
+post_author: 1
+"ListingKey": "29164823"
+"ListingId": "X12603202"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T01:55:24Z"
+"RFModificationTimestamp": "2025-12-05T03:38:03Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL STREET S, Hamilton (Waterdown), Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.886026
1 => 43.331229
]
+"Latitude": 43.331229
+"Longitude": -79.886026
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. Potential to assemble with property next door. VTB FINANCING AVAILABLE. Consider the possibilities for your dream home or as an investment. (id:62650)"
+"CreationDate": "2025-12-05T03:37:47.851068+00:00"
+"Directions": "Cross Streets: Dundas Street. ** Directions: Mill St. S. is Waterdown Rd. south of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "61.88 x 124 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T01:47:01Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T01:47:01Z"
+"StreetDirSuffix": "South"
+"StreetName": "Mill"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3773"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29164823/191-mill-street-s-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 61.1
+"OriginalEntryTimestamp": "2025-12-05T01:47:01.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29164823')"
+"ID": "464308"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25004
+post_id: "463014"
+post_author: 1
+"ListingKey": "29161684"
+"ListingId": "40792230"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T15:05:56Z"
+"RFModificationTimestamp": "2025-12-04T21:13:14Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.428
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "191 MILL Street S, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8859059
1 => 43.3312732
]
+"Latitude": 43.3312732
+"Longitude": -79.8859059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Build your Dream Home just steps from the Village of Waterdown! Take advantage of this rare opportunity! Already a level clearing surrounded by beautiful mature trees & evergreens on an almost half acre lot (.42ac) give a great start to this ideal building location; nestled amongst the trees across from the charming Grindstone Creek Trail & a short walk to Smokey Hollow Waterfall. Enjoy Country in the City living just steps from shops & restaurants, minutes to first class amenities, transit, schools, The Bruce Trail, GO & easy Hwy access to the 403 & 407. Much of the land preparation is already done; Property is on municipal water & sewer and is ready with hydro & gas service. New Property Survey is available. VTB FINANCING AVAILABLE. Newly severed Lot. Consider the possibilities for your dream home or as an investment. Book a private viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-04T21:12:51.956561+00:00"
+"Directions": "Mill St. S. is Waterdown Rd., S of Dundas St."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960190"
+"ListOfficeKey": "284639"
+"LotSizeDimensions": "0.428"
+"PhotosChangeTimestamp": "2025-12-04T14:59:58Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T14:59:57Z"
+"StreetDirSuffix": "South"
+"StreetName": "MILL"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3773"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/191_mill_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161684/191-mill-street-s-waterdown"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "O1, CM"
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2025-12-04T14:59:57.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161684')"
+"ID": "463014"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "463015"
+post_author: 1
+"ListingKey": "29161927"
+"ListingId": "40791925"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T21:41:05Z"
+"RFModificationTimestamp": "2025-12-13T21:44:01Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1682.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "383 DUNDAS Street E Unit# 21, Waterdown, Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.8875746
1 => 43.3386557
]
+"Latitude": 43.3386557
+"Longitude": -79.8875746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown’s family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"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": "2025-12-04T20:40:54.576685+00:00"
+"Directions": "Dundas St E to complex."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:00:37Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T21:30:06Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "4053.09"
+"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/29161927/383-dundas-street-e-unit-21-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2059038"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"ZoningDescription": "HC-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1682
+"OriginalEntryTimestamp": "2025-12-04T16:00:37.86Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161927')"
+"ID": "463015"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23632
+post_id: "463016"
+post_author: 1
+"ListingKey": "29161992"
+"ListingId": "40792282"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T21:40:21Z"
+"RFModificationTimestamp": "2025-12-06T21:44:46Z"
+"ListPrice": 1388000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3029.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "20 VINEGAR Hill, Waterdown, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.8900722
1 => 43.3362821
]
+"Latitude": 43.3362821
+"Longitude": -79.8900722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional 3,000+ sq ft custom-built 4-bedroom home on a rare 60-foot-wide lot in one of Waterdown's most desirable neighbourhoods. Just a 4-minute stroll to Waterdown's historic village and downtown amenities, this property showcases quality craftsmanship, a thoughtful floor plan, and features that set it apart from a standard subdivision home. The main level offers a spacious formal living/dining room, a dedicated den/home office, a large eat-in kitchen with high-end appliances, and an inviting family room filled with natural light. Upstairs, you'll find four oversized bedrooms, including a primary suite with a walk-in closet and 5-pc ensuite. The second bedroom also includes its own private 4-pc ensuite - an ideal setup for multigenerational living. A skylit landing and walkout to a charming balcony add distinctive architectural character. Excellent versatility continues on the lower level, with two staircases and a separate entrance, offering potential for an in-law suite, teen retreat, or income-generating unit. Perfectly located within walking distance to Waterdown's historic village and local conveniences, and just minutes from the Bruce Trail, Smokey Hollow Waterfall, parks, and scenic ravine paths. Easy access to major highways and Aldershot GO Station. A rare opportunity on a street where homes seldom come to market. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:02:18.932559+00:00"
+"Directions": "Dundas St & Vinegar Hill"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:11:05Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T21:29:16Z"
+"Stories": "2.0"
+"StreetName": "VINEGAR"
+"StreetNumber": "20"
+"StreetSuffix": "Hill"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7324"
+"VirtualTourURLUnbranded": "https://youtu.be/TeI63sfVOxE"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161992/20-vinegar-hill-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 3029
+"OriginalEntryTimestamp": "2025-12-04T16:09:19.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161992')"
+"ID": "463016"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "462368"
+post_author: 1
+"ListingKey": "29162472"
+"ListingId": "X12600986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T20:30:54Z"
+"RFModificationTimestamp": "2025-12-09T20:33:01Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X6"
+"UnparsedAddress": "21 - 383 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B1X6"
+"Coordinates": array:2 [
0 => -79.887763
1 => 43.339072
]
+"Latitude": 43.339072
+"Longitude": -79.887763
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 3-storey townhome offering 2+1 bedrooms, 2.5 bathrooms, and nearly 1,700 sq. ft. of bright, functional living space. The open-concept main floor features a stylish kitchen with an upgraded backsplash, clean neutral finishes, and a spacious living area perfect for everyday living and entertaining. Upstairs are two comfortable bedrooms and a full bathroom, including an upgraded glass shower. The 3rd bedroom offers a flexible work or guest space with a full bathroom and a walkout to the private, fenced backyard. Enjoy turn-key living with a finished basement, exterior natural gas hookup, central AC, and included appliances. Parking for two with both a garage and a surface spot. Located in Waterdown's family-friendly, walkable community, you're close to Copper Kettle Café, Kamoosh Bistro, The Watermark Taphouse, Fortinos, Shoppers, the Waterdown Trail system, and have quick access to Dundas St. E, the 403, and Aldershot GO. A perfect low-maintenance, move-in-ready option for first-time buyers, downsizers, or young professionals. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "215.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T18:42:36.525089+00:00"
+"Directions": "Cross Streets: Dundas St E. ** Directions: Dundas St E To Complex."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T16:49:49Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T20:19:39Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "383"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4053.09"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29162472/21-383-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1989315"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Melbourne Property Mgmt"
+"CoListOfficeKey": "269164"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-12-04T16:49:49.04Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29162472')"
+"ID": "462368"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "461429"
+post_author: 1
+"ListingKey": "29159998"
+"ListingId": "X12598508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T20:35:28Z"
+"RFModificationTimestamp": "2025-12-03T23:14:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0H4"
+"UnparsedAddress": "71 ROYALEDGE WAY, Hamilton (Waterdown), Ontario L8B0H4"
+"Coordinates": array:2 [
0 => -79.9067199
1 => 43.3285726
]
+"Latitude": 43.3285726
+"Longitude": -79.9067199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 71 Royaledge Way, a meticulously cared-for 4-bedroom, 3-bathroom family home located in Waterdown West - one of the city's most desirable and truly family-friendly neighbourhoods. Loved by the same owners for 20 years, this property shines with pride of ownership and thoughtful updates throughout. The second floor features four spacious bedrooms, including a generous primary suite with ensuite and walk-in closet. The main floor offers a timeless dining/family room combo, an eat-in kitchen, main-floor laundry, a 2-piece bath, and a warm, cosy living room with a working gas fireplace - an ideal space to unwind. The kitchen was fully renovated in 2022, and the appliances are only six months old, offering a fresh and modern space for everyday living. Additional major upgrades include window replacements in 2013 and 2021, a front door replaced in 2021, a furnace installed in 2018, and two air conditioners (2010 & 2013). The roof was replaced in 2008 with 40-year shingles, providing long-term peace of mind. Step into the backyard to find a true retreat. The swim spa (installed four years ago) includes a brand-new cover and features a designated electrical breaker, adding safety and convenience. Paired with the gazebo and the beautifully maintained landscaping, this space is perfect for hosting friends, family, or enjoying quiet evenings outdoors. The double garage offers a brand-new epoxy floor, steel insulated garage door, and room for two cars plus storage, along with a four-car driveway. All systems and utilities have been regularly serviced, ensuring dependable upkeep for years to come. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Full"
1 => "Walk-up"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T23:14:36.077805+00:00"
+"Directions": "Dundas St W & Hamilton St N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "45 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T20:24:33Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T20:24:33Z"
+"Stories": "2.0"
+"StreetName": "Royaledge"
+"StreetNumber": "71"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "6495.02"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/71_royaledge_way_hamilton_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": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29159998/71-royaledge-way-hamilton-waterdown-waterdown"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Canopy"
1 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-12-03T20:24:33.37Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159998')"
+"ID": "461429"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 135
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]