array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29687086 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1376615"
+post_author: 1
+"ListingKey": "29687086"
+"ListingId": "X13070476"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-10T12:25:40Z"
+"RFModificationTimestamp": "2026-05-10T12:29:15Z"
+"ListPrice": 3990000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1A3"
+"UnparsedAddress": "437 6TH CONCESSION ROAD E, Hamilton, Ontario L8B1A3"
+"Coordinates": array:2 [
0 => -79.9248099
1 => 43.3733881
]
+"Latitude": 43.3733881
+"Longitude": -79.9248099
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 437 6th Concession Road East, an exceptional legacy estate where historic charm meets modern luxury. Tucked away nearly 2,000 feet from the road, this private country retreat offers unmatched tranquility for the discerning buyer. The property features two distinct residences. The original 1893 farmhouse, rich in character, offers approximately 2,162 sq. ft. of timeless appeal equipped with a 40 ft drilled well and is heated by propane. Complementing it is a custom-built ranch-style bungalow (2015) with over 5,600 sq. ft. is heated by natural gas, equipped with a 70 ft well supplying a 500 gallon cistern complete with open-concept living, soaring ceilings, and a two-storey garage with loft, perfect for car enthusiasts or additional living space. A gas-heated workshop spanning more than 3,500 sq. ft. provides incredible flexibility for trades, hobbyists, or storage. The entire estate is supported by a powerful 100 kW generator, ensuring reliable energy and peace of mind year-round. Adding to its unique charm, the property includes a saloon reminiscent of a classic country-western film providing an unforgettable setting for entertaining, private events, or simply enjoying its nostalgic ambiance. Set on approximately 96 Acres zoned A-1, P7 and P8 this magnificent property boasts 10 acres of beautifully manicured grounds, 38 Acres of farmed land, approx 20 acres under protected Treed designations, 4 acres of paddocks and a winding driveway that leads to approx 24 acres of bush. Located just minutes from Burlington and only 6 minutes from Waterdown this dream home is more than a property, it's an incredible lifestyle. Whether it's peaceful morning walks, hosting memorable gatherings, or embracing the freedom of wide-open space, this estate offers the perfect balance of luxury and country living. Rarely does a property of this scale, versatility, and beauty come to market. Priced For Immediate Action. Do not let this opportunity pass you by. Luxury Certified (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T20:00:44.832230+00:00"
+"Directions": "Cross Streets: Highway 6. ** Directions: Highway 6 to Concession 6 Road East."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:3 [
0 => "Concrete"
1 => "Poured Concrete"
2 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005092"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Wooded area"
1 => "Flat site"
2 => "Conservation/green belt"
3 => "Hilly"
4 => "Country residential"
5 => "Guest Suite"
6 => "In-Law Suite"
]
+"LotSizeDimensions": "1484.9 x 2817.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-01T18:45:44Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-10T12:18:54Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "6th Concession"
+"StreetNumber": "437"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4309"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"View": "View"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1631858533"
"RoomType" => "Great room"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 6.63
"ListingKey" => "29687086"
"RoomLength" => 5.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.22Z"
]
1 => array:11 [
"RoomKey" => "1631858534"
"RoomType" => "Kitchen"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 2.62
"ListingKey" => "29687086"
"RoomLength" => 5.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.22Z"
]
2 => array:11 [
"RoomKey" => "1631858535"
"RoomType" => "Dining room"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29687086"
"RoomLength" => 6.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
3 => array:11 [
"RoomKey" => "1631858536"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 6.21
"ListingKey" => "29687086"
"RoomLength" => 5.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
4 => array:11 [
"RoomKey" => "1631858537"
"RoomType" => "Bedroom"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 5.26
"ListingKey" => "29687086"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
5 => array:11 [
"RoomKey" => "1631858538"
"RoomType" => "Bedroom"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 6.91
"ListingKey" => "29687086"
"RoomLength" => 8.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
6 => array:11 [
"RoomKey" => "1631858539"
"RoomType" => "Loft"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 9.5
"ListingKey" => "29687086"
"RoomLength" => 9.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
7 => array:11 [
"RoomKey" => "1631858540"
"RoomType" => "Games room"
"ListingId" => "X13070476"
"RoomLevel" => "Main level"
"RoomWidth" => 6.86
"ListingKey" => "29687086"
"RoomLength" => 9.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-10T12:18:54.23Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29687086/437-6th-concession-road-e-hamilton-rural-flamborough"
+"ParkingTotal": 50
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1994256"
+"CoListOfficeKey": "266588"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 100000
+"LivingAreaMinimum": 5000
+"ZoningDescription": "A1 , P7, P8"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 1484.1
+"OriginalEntryTimestamp": "2026-05-01T18:45:44.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1287486"
+"ListOfficeNationalAssociationId": "1344854"
+"CoListAgentNationalAssociationId": "1277414"
+"CoListOfficeNationalAssociationId": "1274323"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6643905688"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/823489fbfe3023f71c6f592f83249fe1.webp"
"MediaSize" => 147851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-823489fbfe3023f71c6f592f83249fe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6643905766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/1ea9c56ae7d183ebab72a2ef64f14e7d.webp"
"MediaSize" => 125054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-1ea9c56ae7d183ebab72a2ef64f14e7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6643905854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/357675377dc779a44dc812ee3e5d0a2a.webp"
"MediaSize" => 141907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-357675377dc779a44dc812ee3e5d0a2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6643905953"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/940a160ad34c803f4de9d6a4dee7ef93.webp"
"MediaSize" => 104451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-940a160ad34c803f4de9d6a4dee7ef93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6643906025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/a9b7b29000bcfa0b8cba4741f3192593.webp"
"MediaSize" => 114937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-a9b7b29000bcfa0b8cba4741f3192593.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6643906116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/331a1330c12551964ee9d24c2c22d380.webp"
"MediaSize" => 107149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-331a1330c12551964ee9d24c2c22d380.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6643906207"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/00989dfc8d23f6217411794e88bb8427.webp"
"MediaSize" => 126137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-00989dfc8d23f6217411794e88bb8427.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6643906247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/62b72174115248ec76090f582ca56fdd.webp"
"MediaSize" => 129856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-62b72174115248ec76090f582ca56fdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6643906343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/c624fbc3a6f58be89f874d103c393519.webp"
"MediaSize" => 100800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-c624fbc3a6f58be89f874d103c393519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6643906449"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/1f73c8b10bb311eec527fdab308b9b98.webp"
"MediaSize" => 114889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-1f73c8b10bb311eec527fdab308b9b98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6643906526"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/166e8309359baff0b365786df62881f6.webp"
"MediaSize" => 108469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-166e8309359baff0b365786df62881f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6643906601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/30e09d2e18a11e8dc2f6729fff7df144.webp"
"MediaSize" => 81253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-30e09d2e18a11e8dc2f6729fff7df144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6643906674"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/2e46e62ab61b2d10076ff49a4d94096d.webp"
"MediaSize" => 109451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-2e46e62ab61b2d10076ff49a4d94096d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6643906753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/9fc8fc0c5894be38b56c47f6b5efd0d8.webp"
"MediaSize" => 111667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-9fc8fc0c5894be38b56c47f6b5efd0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6643906832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/6b4ea2281e5481da450984260342c4f9.webp"
"MediaSize" => 109912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-6b4ea2281e5481da450984260342c4f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6643906930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/c585cd242618c7e10c73ebfd4211929b.webp"
"MediaSize" => 111787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-c585cd242618c7e10c73ebfd4211929b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6643907032"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/8dcd88f7bde4701c2c43f9ed02602425.webp"
"MediaSize" => 123413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-8dcd88f7bde4701c2c43f9ed02602425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6643907148"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/a37a308d82679aefe6017d2ef5eeb0c5.webp"
"MediaSize" => 115179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-a37a308d82679aefe6017d2ef5eeb0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6643907246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/7239b7e5ee113dd7994cbf7a2861a8e1.webp"
"MediaSize" => 135799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-7239b7e5ee113dd7994cbf7a2861a8e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6643907348"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/59e39ff38e3c921d3e889488dc80d58e.webp"
"MediaSize" => 120886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-59e39ff38e3c921d3e889488dc80d58e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6643907382"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/8f44d15f466e47e985eb4a8375ad9955.webp"
"MediaSize" => 136070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-8f44d15f466e47e985eb4a8375ad9955.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6643907484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/048384d29272f160c1f83c23e7aec0c6.webp"
"MediaSize" => 175002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-048384d29272f160c1f83c23e7aec0c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6643907570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/ab5f82efb558421289ff342f670e9b6c.webp"
"MediaSize" => 72459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-ab5f82efb558421289ff342f670e9b6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6643907585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/cf2b2edbfde7653ae83dc15c589276b7.webp"
"MediaSize" => 93185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-cf2b2edbfde7653ae83dc15c589276b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6643907615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/72bc33c36b814d5d8f3f2942c89b8bc1.webp"
"MediaSize" => 100528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-72bc33c36b814d5d8f3f2942c89b8bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6643907683"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/e5e546ef6c690df610e781c6b60bc324.webp"
"MediaSize" => 82747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-e5e546ef6c690df610e781c6b60bc324.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6643907755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/10282e23567a2a88825a19a6a15cec34.webp"
"MediaSize" => 75840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-10282e23567a2a88825a19a6a15cec34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6643907848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/2fff37e69eaabd469bec254b8ad883e2.webp"
"MediaSize" => 68591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-2fff37e69eaabd469bec254b8ad883e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6643907865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/85a62ead3989d81e09a3db143145095b.webp"
"MediaSize" => 51988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-85a62ead3989d81e09a3db143145095b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6643907924"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/372cc9d62d759cc2285515ce5b21b74e.webp"
"MediaSize" => 101902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-372cc9d62d759cc2285515ce5b21b74e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6643907957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/420d3d169d01c7ef7261362b68ce1359.webp"
"MediaSize" => 114297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-420d3d169d01c7ef7261362b68ce1359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6643908023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/c65d9fff32f4587e9be55e3e3d40537c.webp"
"MediaSize" => 107250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-c65d9fff32f4587e9be55e3e3d40537c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6643908045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/af10443bfa76c421ab8133edbdc23b3a.webp"
"MediaSize" => 112271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-af10443bfa76c421ab8133edbdc23b3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6643908118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/7a5d4881a9b7072db2cf71d55e4845b6.webp"
"MediaSize" => 167480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-7a5d4881a9b7072db2cf71d55e4845b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6643908194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/a5431b92a74b069b72e51b762291e8fc.webp"
"MediaSize" => 138034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-a5431b92a74b069b72e51b762291e8fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6643908215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/c621447c9ab2c811b90f1e58d24b9d02.webp"
"MediaSize" => 149429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-c621447c9ab2c811b90f1e58d24b9d02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6643908285"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687086/4622939dba1420ad0611fe1b2b9ebdac.webp"
"MediaSize" => 148575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687086/thumbnail-4622939dba1420ad0611fe1b2b9ebdac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070476"
"ResourceRecordKey" => "29687086"
"ModificationTimestamp" => "2026-05-01T18:45:44.11Z"
]
]
+"DaysOnMarket": 77
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29687086')"
+"ID": "1376615"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: e0d3f070a5f5c9afb21b5106e332dddacb05ba431b9c0ddb6b6a85d72b9835fe" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24659
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24975
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-573-1188"
+"OfficeMlsId": "184005"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284787"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "325 WINTERBERRY DRIVE #4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "HAMILTON"
+"OfficePostalCode": "L8J0B"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344854"
+"OriginalEntryTimestamp": "2019-02-26T19:45:00Z"
+"OfficeFax": "905-573-1189"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1499122"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284787')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2005092" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24890
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29687086'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29687086' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25303
+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 '29687086' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9248099 43.3733881)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25355
+items: array:8 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1559949"
+post_author: 1
+"ListingKey": "29944681"
+"ListingId": "X13481536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:00:10Z"
+"RFModificationTimestamp": "2026-07-02T19:45:39Z"
+"ListPrice": 3379000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1T5"
+"UnparsedAddress": "314 7TH CONCESSION ROAD E, Hamilton, Ontario L8B1T5"
+"Coordinates": array:2 [
0 => -79.9454422
1 => 43.3729808
]
+"Latitude": 43.3729808
+"Longitude": -79.9454422
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience tranquility & beauty on this idyllic property, only minutes from Waterdown. Set back nearly 1,000' from the road you'll drive up a private, paved tree lined driveway. This eight-acre property is guaranteed to impress! Dubbed "The Resort" by those that know it. Offered for the first time in 19 years. The 3,800+ square foot home exudes charm & warmth. Upgrades are far too numerous to list. Move-in ready is an understatement. No detail has been overlooked or expense spared. A spectacular addition added a voluminous upper-level, open concept great room with an incredible dedicated home theatre, now "movie night" can be any night. The massive kitchen with exquisite cabinetry and high-end appliances is a true chef's dream. A center island with seating for 6 stretches 15'. Three fridges, double ovens and two sinks are ideal for cooking and entertaining. There is a dining room overlooking the yard near a cozy two-sided fireplace and beamed ceilings. The lower level is finished and includes an additional bedroom, three-piece bath and yard access. Outdoors you will find a multi-level deck with a fire table, hot tub, built in BBQ in a stone cook center with pergola. Beside the deck sits a Finnish wood burning sauna. Lounge by the massive 48' x 21' saltwater pool. A stunning crafted 46' x 30' garage features dual heat (regular & in-floor) with AC. Finished in natural wood, it has a great aesthetic. Perfect for the "special car" or? Attached to the garage is a one-of-a-kind post & beam timber frame cabana with a wood burning fireplace. The floor of the structure features a beautiful flagstone sitting area. There is a 120' x 60' pond and a cozy 'A' frame cabin, perfect for warming up after a mid-night hockey game on the well-lit pond. In the summer you'll catch a glimpse of giant koi! Experience the ultimate in charm, privacy, quality and sophistication that this truly unique and incomparable property has to offer. RSA. Luxury Certified. (id:62650)"
+"Appliances": array:1 [
0 => "Hot Tub"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-24T01:06:32.557187+00:00"
+"Directions": "Centre Rd East on 7th Concession"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Irregular lot size"
]
+"LotSizeDimensions": "348.5 x 1001.8 FT ; 348.85ft x1009.04ft x 349.13ftx1001.80ft"
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Other"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-23T22:45:22Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:54:39Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "7th Concession"
+"StreetNumber": "314"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "11614"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019efadd-a388-70de-82c8-538d18f9f4d4"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1673510571"
"RoomType" => "Living room"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 4.29
"ListingKey" => "29944681"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
1 => array:11 [
"RoomKey" => "1673510572"
"RoomType" => "Dining room"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 4.5
"ListingKey" => "29944681"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
2 => array:11 [
"RoomKey" => "1673510573"
"RoomType" => "Bedroom"
"ListingId" => "X13481536"
"RoomLevel" => "Basement"
"RoomWidth" => 3.63
"ListingKey" => "29944681"
"RoomLength" => 4.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
3 => array:11 [
"RoomKey" => "1673510574"
"RoomType" => "Bathroom"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29944681"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
4 => array:11 [
"RoomKey" => "1673510575"
"RoomType" => "Bathroom"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29944681"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
5 => array:11 [
"RoomKey" => "1673510576"
"RoomType" => "Bathroom"
"ListingId" => "X13481536"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29944681"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
6 => array:11 [
"RoomKey" => "1673510577"
"RoomType" => "Bathroom"
"ListingId" => "X13481536"
"RoomLevel" => "Upper Level"
"RoomWidth" => 0.0
"ListingKey" => "29944681"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
7 => array:11 [
"RoomKey" => "1673510578"
"RoomType" => "Kitchen"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29944681"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.85Z"
]
8 => array:11 [
"RoomKey" => "1673510579"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 4.39
"ListingKey" => "29944681"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
9 => array:11 [
"RoomKey" => "1673510580"
"RoomType" => "Bedroom"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29944681"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
10 => array:11 [
"RoomKey" => "1673510581"
"RoomType" => "Bedroom"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29944681"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
11 => array:11 [
"RoomKey" => "1673510582"
"RoomType" => "Laundry room"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29944681"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
12 => array:11 [
"RoomKey" => "1673510583"
"RoomType" => "Other"
"ListingId" => "X13481536"
"RoomLevel" => "Main level"
"RoomWidth" => 3.68
"ListingKey" => "29944681"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
13 => array:11 [
"RoomKey" => "1673510584"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13481536"
"RoomLevel" => "Basement"
"RoomWidth" => 4.39
"ListingKey" => "29944681"
"RoomLength" => 9.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
14 => array:11 [
"RoomKey" => "1673510585"
"RoomType" => "Other"
"ListingId" => "X13481536"
"RoomLevel" => "Basement"
"RoomWidth" => 1.78
"ListingKey" => "29944681"
"RoomLength" => 1.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T18:54:39.86Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29944681/314-7th-concession-road-e-hamilton-rural-flamborough"
+"ParkingTotal": 25
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "A2, P8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 348.6
+"OriginalEntryTimestamp": "2026-06-23T22:45:22.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29944681_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/fbcddb77eca7328bb3a6c8f51a201ffd.webp"
"MediaSize" => 395268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-fbcddb77eca7328bb3a6c8f51a201ffd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29944681_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/b91a3faa9f65668c61a592024592cfc5.webp"
"MediaSize" => 219613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-b91a3faa9f65668c61a592024592cfc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29944681_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/c548307bc6aff2ea965685169ce5fcce.webp"
"MediaSize" => 309780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-c548307bc6aff2ea965685169ce5fcce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29944681_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/7ae3b2dc5d6d99d161bedf9e333dc47d.webp"
"MediaSize" => 265077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-7ae3b2dc5d6d99d161bedf9e333dc47d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29944681_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/41de61a42a8c2004d73905a40e8644f5.webp"
"MediaSize" => 229920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-41de61a42a8c2004d73905a40e8644f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29944681_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/51da908281ad7c3ccb09892b1431da18.webp"
"MediaSize" => 222898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-51da908281ad7c3ccb09892b1431da18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29944681_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/59987c324d816e758b51e609c392c6ba.webp"
"MediaSize" => 295387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-59987c324d816e758b51e609c392c6ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29944681_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/284a7351cdbbad5a7c1c3e3279a9cbf8.webp"
"MediaSize" => 262982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-284a7351cdbbad5a7c1c3e3279a9cbf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29944681_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/fa1ff402621034e7f9f8cab85486a447.webp"
"MediaSize" => 251424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-fa1ff402621034e7f9f8cab85486a447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29944681_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/8854d9fd8ac5faf5f58fb46d2c05307d.webp"
"MediaSize" => 259998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-8854d9fd8ac5faf5f58fb46d2c05307d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29944681_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/8df2ca1c8b736567cbd297e6dc88467b.webp"
"MediaSize" => 195803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-8df2ca1c8b736567cbd297e6dc88467b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29944681_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/97d3275eae747fd25d8137c39967d66d.webp"
"MediaSize" => 153479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-97d3275eae747fd25d8137c39967d66d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29944681_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/f5e60de68cd6d5730581a26f4f3457e9.webp"
"MediaSize" => 151270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-f5e60de68cd6d5730581a26f4f3457e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29944681_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/6666801846e314686b4c6c0b8c49442e.webp"
"MediaSize" => 190834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-6666801846e314686b4c6c0b8c49442e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29944681_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/792c5f42f105f916433575602bf4ad8e.webp"
"MediaSize" => 140414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-792c5f42f105f916433575602bf4ad8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29944681_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/d0a9e9d2ceeb07cc5231da3d2a82f0bd.webp"
"MediaSize" => 179918
"MediaType" => "webp"
…8
]
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": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944681')"
+"ID": "1559949"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "1559220"
+post_author: 1
+"ListingKey": "29944330"
+"ListingId": "40842486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T17:30:23Z"
+"RFModificationTimestamp": "2026-07-08T19:15:58Z"
+"ListPrice": 3379000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3072.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L8B1T5"
+"UnparsedAddress": "314 7TH CONCESSION Road E, Millgrove, Ontario L8B1T5"
+"Coordinates": array:2 [
0 => -79.9334947
1 => 43.3790968
]
+"Latitude": 43.3790968
+"Longitude": -79.9334947
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience tranquility & beauty on this idyllic property, only minutes from Waterdown. Set back nearly 1,000’ from the road you’ll drive up a private, paved tree lined driveway. This eight-acre property is guaranteed to impress! Dubbed “The Resort” by those that know it. Offered for the first time in 19 years. The 3,800+ square foot home exudes charm & warmth. Upgrades are far too numerous to list. Move-in ready is an understatement. No detail has been overlooked or expense spared. A spectacular addition added a voluminous upper-level, open concept great room with an incredible dedicated home theatre, now “movie night” can be any night. The massive kitchen with exquisite cabinetry and high-end appliances is a true chef’s dream. A center island with seating for 6 stretches 15’. Three fridges, double ovens and two sinks are ideal for cooking and entertaining. There is a dining room overlooking the yard near a cozy two-sided fireplace and beamed ceilings. The lower level is finished and includes an additional bedroom, three-piece bath and yard access. Outdoors you will find a multi-level deck with a fire table, hot tub, built in BBQ in a stone cook center with pergola. Beside the deck sits a Finnish wood burning sauna. Lounge by the massive 48’ x 21’ saltwater pool. A stunning crafted 46’ x 30’ garage features dual heat (regular & in-floor) with AC. Finished in natural wood, it has a great aesthetic. Perfect for the “special car” or? Attached to the garage is a one-of-a-kind post & beam timber frame cabana with a wood burning fireplace. The floor of the structure features a beautiful flagstone sitting area. There is a 120’ x 60’ pond and a cozy ‘A’ frame cabin, perfect for warming up after a mid-night hockey game on the well-lit pond. In the summer you’ll catch a glimpse of giant koi! Experience the ultimate in charm, privacy, quality and sophistication that this truly unique and incomparable property has to offer. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:35:57.443114+00:00"
+"Directions": "CENTRE RD EAST ON 7TH CONCESSION"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Crushed stone driveway"
1 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T21:51:51Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T16:59:29Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "7TH CONCESSION"
+"StreetNumber": "314"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "11614"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019efadd-a388-70de-82c8-538d18f9f4d4"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"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/29944330/314-7th-concession-road-e-flamborough"
+"ParkingTotal": 20
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2, P8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 348.0
+"AboveGradeFinishedArea": 3072
+"OriginalEntryTimestamp": "2026-06-23T21:51:06.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"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": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944330')"
+"ID": "1559220"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25349
+post_id: "1435040"
+post_author: 1
+"ListingKey": "29770564"
+"ListingId": "40830883"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:30:03Z"
+"RFModificationTimestamp": "2026-07-05T20:42:24Z"
+"ListPrice": 2090000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 10.03
+"LivingArea": 2119.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "10 HUISMAN Lane, Hamilton, Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.9408696
1 => 43.3661215
]
+"Latitude": 43.3661215
+"Longitude": -79.9408696
+"YearBuilt": 1968
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on approximately 10 acres in the heart of desirable Flamborough, this distinguished country estate offers a rare blend of refined rural living and a fully equipped equestrian facility. The four-bedroom bungalow is thoughtfully positioned to take in the surrounding pastoral landscape, offering privacy, comfort, and an authentic countryside lifestyle. Purpose-built for the discerning equestrian, the property showcases an impressive 70' x 110' indoor riding arena complete with four box stalls, a heated tack room, and wash stall. Complementing the indoor facilities are a 200' x 85' outdoor riding arena, 70' x 65' lunging paddock, and four well-maintained paddocks designed for efficient rotational grazing. A 25' x 40' detached garage/workshop further enhances the functionality of the estate. The land offers a harmonious balance of open, usable acreage and naturalized areas, providing both operational flexibility and exceptional privacy. This is a turnkey opportunity for equestrian professionals, hobby farm enthusiasts, or those seeking a true rural estate lifestyle. The property is subject to A2 (Agricultural) zoning with portions designated under P8 (Conservation/Hazard Land) overlay. A2 zoning support rural residential and agricultural/equestrian uses, while P8- regulated areas are environmentally protected and not available for development. Ideally located within easy reach of Waterdown, Ancaster, and Hamilton, and offering convenient access to Highway 403 and the QEW, this estate delivers an exceptional balance of country seclusion and commuter accessibility. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-19T18:27:29.989356+00:00"
+"Directions": "Hamilton Drive (Centre Road) north from Waterdown, East on Huisman Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524719"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Country residential"
]
+"LotSizeDimensions": "10.03"
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T16:21:18Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:21:02Z"
+"Stories": "1.0"
+"StreetName": "HUISMAN"
+"StreetNumber": "10"
+"StreetSuffix": "Lane"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "5481.95"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019e273e-1c1d-70a0-b5d0-71cda8b63ef8"
+"WaterSource": array:1 [
0 => "Well"
]
+"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/29770564/10-huisman-lane-hamilton"
+"ParkingTotal": 22
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2, P8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 737.0
+"AboveGradeFinishedArea": 2119
+"OriginalEntryTimestamp": "2026-05-19T17:31:46.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1063960"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 59
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770564')"
+"ID": "1435040"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "1430620"
+post_author: 1
+"ListingKey": "29763218"
+"ListingId": "X13137474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T12:20:09Z"
+"RFModificationTimestamp": "2026-07-06T12:41:49Z"
+"ListPrice": 2090000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "10 HUISMAN LANE, Hamilton, Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -79.9409568
1 => 43.3658963
]
+"Latitude": 43.3658963
+"Longitude": -79.9409568
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on approximately 10 acres in the heart of desirable Flamborough, this distinguished country estate offers a rare blend of refined rural living and a fully equipped equestrian facility. The four-bedroom bungalow is thoughtfully positioned to take in the surrounding pastoral landscape, offering privacy, comfort, and an authentic countryside lifestyle. Purpose-built for the discerning equestrian, the property showcases an impressive 70' x 110' indoor riding arena complete with four box stalls, a heated tack room, and wash stall. Complementing the indoor facilities are a 200' x 85' outdoor riding arena, 70' x 65' lunging paddock, and four well-maintained paddocks designed for efficient rotational grazing. A 25' x 40' detached garage/workshop further enhances the functionality of the estate. The land offers a harmonious balance of open, usable acreage and naturalized areas, providing both operational flexibility and exceptional privacy. This is a turnkey opportunity for equestrian professionals, hobby farm enthusiasts, or those seeking a true rural estate lifestyle. The property is subject to A2 (Agricultural) zoning with portions designated under P8 (Conservation/Hazard Land) overlay. A2 zoning support rural residential and agricultural/equestrian uses, while P8- regulated areas are environmentally protected and not available for development. Ideally located within easy reach of Waterdown, Ancaster, and Hamilton, and offering convenient access to Highway 403 and the QEW, this estate delivers an exceptional balance of country seclusion and commuter accessibility. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Treatment"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Crawl space"
1 => "Walk out"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-05-16T01:05:17.592756+00:00"
+"Directions": "Cross Streets: Centre Road (Hamilton Drive). ** Directions: Hamilton Drive (Centre Road) North from Waterdown, East on Huisman Lane."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159941"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Wooded area"
1 => "Irregular lot size"
2 => "Partially cleared"
3 => "Flat site"
4 => "Conservation/green belt"
5 => "Sump Pump"
]
+"LotSizeDimensions": "737 x 519 FT ; L shaped lot"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-21T13:13:20Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"PossibleUse": "Pasture"
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T12:12:15Z"
+"Stories": "1.0"
+"StreetName": "Huisman"
+"StreetNumber": "10"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "5481.95"
+"Utilities": array:2 [
0 => "Wireless"
1 => "Electricity Connected"
]
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019e273e-1c1d-70a0-b5d0-71cda8b63ef8"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29763218/10-huisman-lane-hamilton-rural-flamborough"
+"ParkingTotal": 24
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 737.0
+"OriginalEntryTimestamp": "2026-05-16T00:42:00.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1411113"
+"ListOfficeNationalAssociationId": "1374261"
+"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": 63
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29763218')"
+"ID": "1430620"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+post_id: "1415275"
+post_author: 1
+"ListingKey": "29742865"
+"ListingId": "W13119624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-13T19:35:59Z"
+"RFModificationTimestamp": "2026-05-13T19:40:39Z"
+"ListPrice": 400000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P0C5"
+"UnparsedAddress": "7 ASH - 4449 MILBUROUGH LINE, Burlington, Ontario L7P0C5"
+"Coordinates": array:2 [
0 => -79.9007019
1 => 43.3763678
]
+"Latitude": 43.3763678
+"Longitude": -79.9007019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 7 Ash, 4449 Milburough Line, Burlington Nestled in a quiet, community-focused setting, this well-maintained two-bedroom modular home offers the perfect blend of comfort, functionality, and relaxed living.Step outside onto the natural wood front and side decks - ideal for morning coffee or evening unwinding. Inside, the layout is thoughtfully designed with a flexible second bedroom that adapts effortlessly to your lifestyle, whether you need a home office, den, or dedicated TV room. The primary bedroom features a full-size washer and dryer conveniently located in the ensuite, adding everyday ease to your routine.Recent upgrades bring lasting peace of mind: a brand new Generac generator installed in January 2025 ensures you're never left in the dark, while the central air conditioner (2020) keeps things cool all summer long. The double-wide driveway accommodates two vehicles with ease, and a garden shed offers generous additional storage for all your tools and seasonal essentials.The low-maintenance lot means less time working and more time enjoying - a simple, relaxed lifestyle just minutes from Burlington, Waterdown, and convenient access to major highways. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater - Tankless"
5 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-13T00:53:47.731420+00:00"
+"Directions": "Cross Streets: Con 6. ** Directions: Con.6 &Milb. Line."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1419937"
+"ListOfficeKey": "275900"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Wooded area"
2 => "Conservation/green belt"
3 => "Level"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-12T23:38:01Z"
+"PhotosCount": 6
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-13T19:25:51Z"
+"Stories": "1.0"
+"StreetName": "Milburough"
+"StreetNumber": "4449"
+"StreetSuffix": "Line"
+"TaxAnnualAmount": "426.5"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Burlington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29742865/7-ash-4449-milburough-line-burlington-rural-burlington"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-05-12T23:38:01.6Z"
+"ListAgentNationalAssociationId": "1056017"
+"ListOfficeNationalAssociationId": "1269109"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 66
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29742865')"
+"ID": "1415275"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1390342"
+post_author: 1
+"ListingKey": "29707126"
+"ListingId": "W13088800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T20:15:04Z"
+"RFModificationTimestamp": "2026-07-16T20:19:57Z"
+"ListPrice": 568880.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P0C5"
+"UnparsedAddress": "5 BEECH - 4449 MILBUROUGH LINE, Burlington, Ontario L7P0C5"
+"Coordinates": array:2 [
0 => -79.9007019
1 => 43.3763678
]
+"Latitude": 43.3763678
+"Longitude": -79.9007019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is the epitome of Lost Forest living, where nature, privacy, and timeless design come together seamlessly. Nestled at the end of Beech Street and surrounded by lush forest and green space, this home offers spectacular views from every angle. A charming front porch and fully enclosed three-season room with sliding windows encompass indoor / outdoor living. Inside, you'll find a meticulously maintained 2-bedroom, 2-bathroom home offering over 1,220 sq ft of thoughtfully designed living space. The open-concept kitchen features a large centre island with breakfast bar and overlooks the spacious living room with fireplace. Just off the kitchen, the Muskoka room with pocket doors provides a versatile space, ideal as a dining room or home office, while taking full advantage of the serene forest views. Sliding doors lead to a newer four-season room, perfect as a den, reading room, office, or gym. A soft, neutral palette flows throughout. The primary suite includes a 3-piece ensuite. The second bedroom is well-sized and conveniently located near the 4-piece main bathroom. The generous laundry room offers ample storage. Additional features include luxury vinyl flooring, a Generac generator, two propane tanks, a concrete driveway, LeafFilter gutter protection, outdoor shed, and crawl space for extra storage. Residents of Lost Forest enjoy access to community amenities including an outdoor pool, recreational pavilion and an abundance of shared green spaces. Ideally located in Burlington, just minutes to shopping, highways, and everyday conveniences. Wake up to the sounds of nature and unwind surrounded by forest views, this is where peaceful living begins. Land Lease Fee: $802.55 (includes Taxes, Water & Sewer, Park Amenities & Maintenance). (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Hot Water Instant"
2 => "Window Coverings"
3 => "Water Heater - Tankless"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-06T15:29:45.641319+00:00"
+"Directions": "Cross Streets: Milburough Town Line. ** Directions: Milburough to Ash to Cherry to Beech."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1971138"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:06:14Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T20:05:18Z"
+"Stories": "1.0"
+"StreetName": "Milburough"
+"StreetNumber": "4449"
+"StreetSuffix": "Line"
+"VirtualTourURLUnbranded": "https://youtu.be/4M6oHBjxIio"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"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"
+"TaxYear": 2025
+"CityRegion": "Rural Burlington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29707126/5-beech-4449-milburough-line-burlington-rural-burlington"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-05-06T14:12:43.26Z"
+"ListAgentNationalAssociationId": "1258816"
+"ListOfficeNationalAssociationId": "1300540"
+"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": 72
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29707126')"
+"ID": "1390342"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1376616"
+post_author: 1
+"ListingKey": "29686630"
+"ListingId": "40826022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:45:42Z"
+"RFModificationTimestamp": "2026-06-02T16:58:34Z"
+"ListPrice": 3990000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 96.46
+"LivingArea": 7653.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L8B1A3"
+"UnparsedAddress": "437 6TH CONCESSION Road E, Flamborough, Ontario L8B1A3"
+"Coordinates": array:2 [
0 => -79.9248312
1 => 43.3733545
]
+"Latitude": 43.3733545
+"Longitude": -79.9248312
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An exceptional legacy estate where historic charm meets modern luxury. Tucked away nearly 2,000 feet from the road, this private country retreat offers unmatched tranquility for the discerning buyer. Featuring two distinct residences. A 1893 farmhouse, rich in character, offers approx 2,162 sq. ft. of timeless appeal equipped with a 40 ft drilled well, heated by propane. Plus a custom-built ranch-style bungalow (2015) with over 5,600 sq. ft. heated by natural gas, equipped with a 70 ft well supplying a 5000 gallon cistern complete with open-concept living, soaring ceilings, and a two-storey garage with loft, perfect for car enthusiasts or additional living space. A gas-heated workshop spanning more than 3,500 sq. ft. provides incredible flexibility for trades, hobbiests, or storage. The entire estate is supported by a powerful 100 kW generator, ensuring reliable energy and peace of mind all year-round. Adding to its unique charm, the property includes a saloon reminiscent of a classic country-western film providing an unforgettable setting for entertaining, private events, or simply enjoying its nostalgic ambiance. Set on approx 96 Acres zoned A-1, P7 and P8 this magnificent property boasts 10 acres of beautifully manicured grounds, 38 Acres of farmed land, approx 20 acres under protected Treed designations, 4 acres of paddocks and a winding driveway that leads to approx 24 acres of bush. Located just minutes from Burlington and only 6 minutes from Waterdown this dream home is more than a property, its an increadible lifestyle. Whether it's peaceful morning walks, hosting memorable gatherings, or embracing the freedom of wide-open space, this estate offers the perfect balance of luxury and country living. Rarely does a property of this scale, versatility, and beauty come to market. Priced For Immediate Action. Do not let this opportunity pass you by. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Freezer"
7 => "Wet Bar"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T19:59:51.485064+00:00"
+"Directions": "Highway 6 to Concession 6 Road East"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596388"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Southern exposure"
1 => "Corner Site"
2 => "Wet bar"
3 => "Skylight"
4 => "Country residential"
5 => "Automatic Garage Door Opener"
6 => "In-Law Suite"
]
+"LotSizeDimensions": "96.46"
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-01T18:10:26Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:33:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "6TH CONCESSION"
+"StreetNumber": "437"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "4309"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"WaterSource": array:1 [
0 => "Cistern"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29686630/437-6th-concession-road-e-flamborough"
+"ParkingTotal": 34
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1525072"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284641"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "A1, P7, P8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1485.0
+"AboveGradeFinishedArea": 7653
+"OriginalEntryTimestamp": "2026-05-01T18:10:26.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1096193"
+"ListOfficeNationalAssociationId": "1333115"
+"CoListAgentNationalAssociationId": "1064619"
+"CoListOfficeNationalAssociationId": "1344650"
+"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": 77
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29686630')"
+"ID": "1376616"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1147088"
+post_author: 1
+"ListingKey": "29352865"
+"ListingId": "40802306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-22T20:40:35Z"
+"RFModificationTimestamp": "2026-03-22T20:43:29Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1929.0
+"BuildingAreaTotal": 0
+"City": "Millgrove"
+"PostalCode": "L0R2H0"
+"UnparsedAddress": "41 JOHN MARTIN Crescent, Millgrove, Ontario L0R2H0"
+"Coordinates": array:2 [
0 => -79.9315284
1 => 43.3610119
]
+"Latitude": 43.3610119
+"Longitude": -79.9315284
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this amazing bungalow offering the perfect blend of space, comfort, and opportunity, all set on an impressive 0.6-acre fully fenced lot ideal for families craving room to grow. Step inside to an updated main floor designed for both everyday living and entertaining. A bright and welcoming family room with a beautiful bay window fills the space with natural light, while the separate dining room provides the perfect setting for hosting holidays and special gatherings. The expansive kitchen offers generous square footage and endless potential to design and customize your dream chef’s kitchen exactly to your taste. The cozy open-concept living room is accented by a charming corner gas fireplace and features patio doors that lead directly to the backyard deck, creating seamless indoor-outdoor living. The spacious primary bedroom retreat includes an updated 4-piece ensuite and a walk-in closet. Main floor laundry adds convenience and provides direct access to the oversized double car garage. The partially finished basement presents incredible flexibility, already offering a fourth bedroom and additional space awaiting your finishing touches, whether you envision a recreation room, home gym, office, or in-law potential, the space is there to work with. Outside, the property truly shines. The massive concrete driveway accommodates 6+ vehicles, plus additional parking beside the garage, perfect for trailers or toys. A desirable 35 ft x 25 ft WORKSHOP in the rear yard is ideal for hobbyists, contractors, or extra storage needs. The backyard is built for entertaining and family fun, featuring a stunning two-tier composite deck with built-in lighting, a gazebo for relaxing summer evenings, and a dedicated kids’ playground area. With space, privacy, and endless possibilities, this exceptional bungalow offers a rare opportunity to enjoy country-sized living just minutes from city conveniences. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-02-12T17:41:51.327082+00:00"
+"Directions": "Hwy 6 or Centre Road to the 6th Conc. East. East of Centre Road."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1559767"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Country residential"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-03-18T14:30:50Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-22T20:33:00Z"
+"Stories": "1.0"
+"StreetName": "JOHN MARTIN"
+"StreetNumber": "41"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "8570.25"
+"VirtualTourURLUnbranded": "https://youriguide.com/41_john_martin_crescent_hamilton_on/"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29352865/41-john-martin-crescent-millgrove"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 132.0
+"AboveGradeFinishedArea": 1929
+"OriginalEntryTimestamp": "2026-02-12T12:50:06.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1108522"
+"ListOfficeNationalAssociationId": "1333115"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 155
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29352865')"
+"ID": "1147088"
}
]
+success: true
+page_size: 8
+page_count: 1
+count: 8
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]