array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29944330 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: "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 [
"RoomKey" => "1678270337"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842486"
"RoomLevel" => "Upper Level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.02Z"
]
1 => array:11 [
"RoomKey" => "1678270338"
"RoomType" => "Bedroom"
"ListingId" => "40842486"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.02Z"
]
2 => array:11 [
"RoomKey" => "1678270339"
"RoomType" => "Bedroom"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.02Z"
]
3 => array:11 [
"RoomKey" => "1678270340"
"RoomType" => "Bonus Room"
"ListingId" => "40842486"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.02Z"
]
4 => array:11 [
"RoomKey" => "1678270341"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842486"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
5 => array:11 [
"RoomKey" => "1678270342"
"RoomType" => "Recreation room"
"ListingId" => "40842486"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 32'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
6 => array:11 [
"RoomKey" => "1678270343"
"RoomType" => "Bonus Room"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
7 => array:11 [
"RoomKey" => "1678270344"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
8 => array:11 [
"RoomKey" => "1678270345"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
9 => array:11 [
"RoomKey" => "1678270346"
"RoomType" => "Laundry room"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
10 => array:11 [
"RoomKey" => "1678270347"
"RoomType" => "Bedroom"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
11 => array:11 [
"RoomKey" => "1678270348"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
12 => array:11 [
"RoomKey" => "1678270349"
"RoomType" => "Kitchen"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
13 => array:11 [
"RoomKey" => "1678270350"
"RoomType" => "Dining room"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
14 => array:11 [
"RoomKey" => "1678270351"
"RoomType" => "Living room"
"ListingId" => "40842486"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29944330"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T16:59:29.03Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29944330_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/eb74a4991ff589707d2e4f035db640af.webp"
"MediaSize" => 154765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-eb74a4991ff589707d2e4f035db640af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29944330_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/2e29d831e7329db78088274c45b3edf1.webp"
"MediaSize" => 96858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-2e29d831e7329db78088274c45b3edf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29944330_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/f090fa465f06ce5691a5a50d74e9a402.webp"
"MediaSize" => 132419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-f090fa465f06ce5691a5a50d74e9a402.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.3Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29944330_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/eb44223d7d5f65d72968cdefc0a12d0c.webp"
"MediaSize" => 112518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-eb44223d7d5f65d72968cdefc0a12d0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29944330_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/f7dc76d24a20de6e0f6fc41b96732a97.webp"
"MediaSize" => 100297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-f7dc76d24a20de6e0f6fc41b96732a97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29944330_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/6cc9016164df1954737757980345f895.webp"
"MediaSize" => 94939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-6cc9016164df1954737757980345f895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.3Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29944330_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/71cf3021ce46cd31ecc6fb488248fb35.webp"
"MediaSize" => 125527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-71cf3021ce46cd31ecc6fb488248fb35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29944330_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/d7cbe1b63191e613eb0d60695e2edd4f.webp"
"MediaSize" => 116861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-d7cbe1b63191e613eb0d60695e2edd4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29944330_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/b885cb1ac11a40a02127cf3adf3f5dcf.webp"
"MediaSize" => 109759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-b885cb1ac11a40a02127cf3adf3f5dcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:47.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29944330_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/2a9046dc10b595e0a7d32d05dd606d2d.webp"
"MediaSize" => 115633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-2a9046dc10b595e0a7d32d05dd606d2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29944330_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/c3377979c4848138e7e41322867123b4.webp"
"MediaSize" => 85993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-c3377979c4848138e7e41322867123b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29944330_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/74b4a30f891b876dc3c9d793eba77f0a.webp"
"MediaSize" => 67730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-74b4a30f891b876dc3c9d793eba77f0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29944330_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/20991bc99c0e6726be091ebbd62408aa.webp"
"MediaSize" => 65829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-20991bc99c0e6726be091ebbd62408aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.25Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29944330_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/458e40056b3172f5262507e194917c79.webp"
"MediaSize" => 82251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-458e40056b3172f5262507e194917c79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29944330_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/b23e5eaa229fa56884d3ffbe9ce2faaa.webp"
"MediaSize" => 60784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-b23e5eaa229fa56884d3ffbe9ce2faaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29944330_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/1a0cad9b9e5233409fabcf44b14b688a.webp"
"MediaSize" => 77624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-1a0cad9b9e5233409fabcf44b14b688a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29944330_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/48e36e9554dafe00d2bcd8bacb0a4eb0.webp"
"MediaSize" => 82779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-48e36e9554dafe00d2bcd8bacb0a4eb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29944330_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/c0e0b534ac6f9f71ae6a2bd0eb33ac87.webp"
"MediaSize" => 81433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-c0e0b534ac6f9f71ae6a2bd0eb33ac87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29944330_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/2f50fef9d0dbe7038bb6571895f039d3.webp"
"MediaSize" => 84854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-2f50fef9d0dbe7038bb6571895f039d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29944330_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/9e81679bb94c4dfb68a8be29e72c8957.webp"
"MediaSize" => 71255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-9e81679bb94c4dfb68a8be29e72c8957.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.77Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29944330_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/05e4121d33221a88a3e4aa925fb340e5.webp"
"MediaSize" => 80866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-05e4121d33221a88a3e4aa925fb340e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29944330_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/cc8a5bf341040a3740f7a933bbce0f41.webp"
"MediaSize" => 72907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-cc8a5bf341040a3740f7a933bbce0f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.25Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29944330_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/3b950bea2d611ab90dac7b9032fef3bb.webp"
"MediaSize" => 95736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-3b950bea2d611ab90dac7b9032fef3bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29944330_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/94ddc540fe129989f6bdc0bdc12d4812.webp"
"MediaSize" => 93249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-94ddc540fe129989f6bdc0bdc12d4812.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29944330_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/71add999144d395b3e3ebb1200a6f10b.webp"
"MediaSize" => 150978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-71add999144d395b3e3ebb1200a6f10b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29944330_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/a4f24b629cd0725f2c28dd7bca865637.webp"
"MediaSize" => 68737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-a4f24b629cd0725f2c28dd7bca865637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.26Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29944330_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/a7d611c50b45a0f9ab89ed19bc89dbf7.webp"
"MediaSize" => 74117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-a7d611c50b45a0f9ab89ed19bc89dbf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.69Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29944330_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/fbe4997ab2f2b6970ebddc8d210f412a.webp"
"MediaSize" => 122274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-fbe4997ab2f2b6970ebddc8d210f412a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.2Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29944330_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/e5372eb85607da48dc7d11314bfbda2c.webp"
"MediaSize" => 108686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-e5372eb85607da48dc7d11314bfbda2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:47.35Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29944330_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/9d4a5de09037b0b0db33a1cd74df4c7a.webp"
"MediaSize" => 125337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-9d4a5de09037b0b0db33a1cd74df4c7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29944330_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/02c15881c9ea66b5437ee6f0b03c4b3c.webp"
"MediaSize" => 146812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-02c15881c9ea66b5437ee6f0b03c4b3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29944330_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/9bec62d92b385ca689fab030a3992b85.webp"
"MediaSize" => 139793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-9bec62d92b385ca689fab030a3992b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.88Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29944330_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/1a92aa391b2da8ba0ede896032383b0c.webp"
"MediaSize" => 93380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-1a92aa391b2da8ba0ede896032383b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:47.48Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29944330_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/768ba8258a7ebe08154d67a9d40e0112.webp"
"MediaSize" => 116876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-768ba8258a7ebe08154d67a9d40e0112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:51.65Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29944330_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/edabe8218859f4bc9df67fa2b0ab3f86.webp"
"MediaSize" => 142643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-edabe8218859f4bc9df67fa2b0ab3f86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29944330_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/4dc21594787a575709ddee19a081647a.webp"
"MediaSize" => 87247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-4dc21594787a575709ddee19a081647a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.25Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29944330_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/acfe49ef8abfb8a921d84476be0a385c.webp"
"MediaSize" => 186340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-acfe49ef8abfb8a921d84476be0a385c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.77Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29944330_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/8341c4c62b89505c623a77da8ed7724b.webp"
"MediaSize" => 169023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-8341c4c62b89505c623a77da8ed7724b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29944330_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/3744cc1a084d36e8b352a05ed8113360.webp"
"MediaSize" => 163041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-3744cc1a084d36e8b352a05ed8113360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.33Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29944330_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/0cde3db8b32df25d87798dcc4435f762.webp"
"MediaSize" => 143658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-0cde3db8b32df25d87798dcc4435f762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29944330_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/7f131def9f1c8aad58d6b604466ae365.webp"
"MediaSize" => 99847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-7f131def9f1c8aad58d6b604466ae365.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29944330_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/2252bf591714f59aad2bc53a643092d3.webp"
"MediaSize" => 39092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-2252bf591714f59aad2bc53a643092d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29944330_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/8f381a4659b3af1020d390e7dbb09ac4.webp"
"MediaSize" => 166945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-8f381a4659b3af1020d390e7dbb09ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.3Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29944330_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/6d8d0c77aa36d07c763f9fdac3870ac5.webp"
"MediaSize" => 84928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-6d8d0c77aa36d07c763f9fdac3870ac5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.31Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29944330_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/7fb203fd2020810ed75472675762a168.webp"
"MediaSize" => 210585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-7fb203fd2020810ed75472675762a168.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.32Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29944330_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/b7e994961a6fe599b43619116fc4a6a7.webp"
"MediaSize" => 159268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-b7e994961a6fe599b43619116fc4a6a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.88Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29944330_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/20cf1467be1d18c4ff2464a1d56008d2.webp"
"MediaSize" => 151346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-20cf1467be1d18c4ff2464a1d56008d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:44.68Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29944330_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/df429b7ff8bb09eb11b48bb8cd95fa31.webp"
"MediaSize" => 143575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-df429b7ff8bb09eb11b48bb8cd95fa31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:51.65Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29944330_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/26e824a5343de93085171689f1a97d35.webp"
"MediaSize" => 27692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-26e824a5343de93085171689f1a97d35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:42.77Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29944330_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944330/0fa6d8c4dcbb6a10705d5caae971db3d.webp"
"MediaSize" => 21509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944330/thumbnail-0fa6d8c4dcbb6a10705d5caae971db3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842486"
"ResourceRecordKey" => "29944330"
"ModificationTimestamp" => "2026-06-23T21:51:45.25Z"
]
]
+"DaysOnMarket": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944330')"
+"ID": "1559220"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293261" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25013
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24957
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-689-9223"
+"OfficeMlsId": "HBRMXESCDUND"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293261"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#1B-493 Dundas Street E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterdown"
+"OfficePostalCode": "L0R2H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1424570"
+"OriginalEntryTimestamp": "2022-09-12T18:20:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439666"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "293261"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293261')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525426" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24967
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29944330'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25323
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29944330' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25339
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29944330' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9334947 43.3790968)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23486
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25406
+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"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-d0a9e9d2ceeb07cc5231da3d2a82f0bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481536"
"ResourceRecordKey" => "29944681"
"ModificationTimestamp" => "2026-06-23T22:45:22.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29944681_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29944681/9c14b979fd686f85e9580addbdaf60fc.webp"
"MediaSize" => 182899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29944681/thumbnail-9c14b979fd686f85e9580addbdaf60fc.webp"
"ResourceName" => "Property"
…6
]
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 {#25408
+post_id: "1538193"
+post_author: 1
+"ListingKey": "29914404"
+"ListingId": "X13454300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:15:04Z"
+"RFModificationTimestamp": "2026-07-18T00:18:20Z"
+"ListPrice": 1888000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0P1B0"
+"UnparsedAddress": "424 CONCESSION RD 8 E, Hamilton (Carlisle), Ontario L0P1B0"
+"Coordinates": array:2 [
0 => -79.9508346
1 => 43.3911121
]
+"Latitude": 43.3911121
+"Longitude": -79.9508346
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely offered 13.5-acre country estate in the heart of sought-after Carlisle. Privately set back from the road and surrounded by mature trees, rolling farmland and picturesque countryside views, this classic brick farmhouse offers a lifestyle that is becoming increasingly difficult to find.Rich in character and extensively improved over the years, the home offers approximately 4,000 sq ft of functional living space across multiple levels, including spacious principal rooms, a finished third-floor loft, a substantially finished lower level, updated bathrooms, and flexible spaces ideal for family living, entertaining, home office use, or multigenerational living. The inviting wraparound covered veranda and multiple walk-outs create a seamless connection between indoor and outdoor living, allowing you to fully enjoy the beauty of the surrounding landscape.The picturesque grounds are a rare combination of open green space and exceptional privacy, enhanced by mature tree-lined boundaries, extensive white and black fencing, orchard areas, a private pond, and beautifully maintained outdoor spaces. A substantial 75' x 35' driveshed/workshop offers outstanding versatility for hobbyists, collectors, tradespeople, hobby farming, equipment storage, or recreational use.Perched within one of Carlisle's most desirable rural settings, this remarkable property delivers the peace and privacy of country living without sacrificing convenience. Enjoy quick access to Carlisle Village, golf courses, Waterdown, Burlington, Highway 6, Highway 403 and major amenities.A rare opportunity to own one of Carlisle's most distinctive estate properties, where land, space, character, privacy and lifestyle come together in perfect balance. ***Note: Property Taxes Reflect Participation in the Farm Property Tax Rate Program.*** (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:32.091829+00:00"
+"Directions": "Centre & Concession 8 Rd E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Slate"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109741"
+"ListOfficeKey": "285622"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "234.6 x 881.6 FT ; 864' Across Back. See Geowarehouse"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:07:53Z"
+"Stories": "2.5"
+"StreetDirSuffix": "East"
+"StreetName": "Concession Rd 8"
+"StreetNumber": "424"
+"TaxAnnualAmount": "3492"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://view.phocus.ca/424_concession_8_e-7249"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914404/424-concession-rd-8-e-hamilton-rural-flamborough"
+"ParkingTotal": 21
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "A2,P7,P8"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 234.7
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1378468"
+"ListOfficeNationalAssociationId": "1352832"
+"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": 30
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914404')"
+"ID": "1538193"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+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 {#25409
+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 {#25407
+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 [ …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/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 [ …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('29687086')"
+"ID": "1376615"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+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"
}
]
+success: true
+page_size: 6
+page_count: 1
+count: 6
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]