array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29586351 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1303795"
+post_author: 1
+"ListingKey": "29586351"
+"ListingId": "X12982100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T16:05:55Z"
+"RFModificationTimestamp": "2026-04-10T17:42:33Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "N0B1L0"
+"UnparsedAddress": "2091 CONCESSION 6 ROAD W, Hamilton, Ontario N0B1L0"
+"Coordinates": array:2 [
0 => -80.186008
1 => 43.31811
]
+"Latitude": 43.31811
+"Longitude": -80.186008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled just outside of Cambridge in the desirable Flamborough area, this 0.64-acre property offers the perfect blend of space, privacy, and potential. This 3-bedroom, 1-bath home is ready for a new owner to make it their own. Enjoy the comfort of recent updates including a new furnace, windows, and doors, ensuring energy efficiency and peace of mind. Outside, you'll find a detached two-bay shop with high ceilings - ideal for hobbyists, mechanics, or anyone needing extra workspace or storage. Whether you're looking to renovate, expand, or simply enjoy country living with city convenience nearby, this property is a rare opportunity in a sought-after location. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-10T17:42:15.645910+00:00"
+"Directions": "Cross Streets: Hwy. 8. ** Directions: Hwy 8 > 6th Concession."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceFeatures": array:1 [
0 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099891"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "100 x 280 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-10T15:57:04Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-10T15:57:04Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "Concession 6"
+"StreetNumber": "2091"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5453"
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1609611975"
"RoomType" => "Dining room"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 6.86
"ListingKey" => "29586351"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
1 => array:11 [
"RoomKey" => "1609611976"
"RoomType" => "Utility room"
"ListingId" => "X12982100"
"RoomLevel" => "Basement"
"RoomWidth" => 4.37
"ListingKey" => "29586351"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
2 => array:11 [
"RoomKey" => "1609611977"
"RoomType" => "Living room"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 6.71
"ListingKey" => "29586351"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
3 => array:11 [
"RoomKey" => "1609611978"
"RoomType" => "Eating area"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "29586351"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
4 => array:11 [
"RoomKey" => "1609611979"
"RoomType" => "Kitchen"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29586351"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
5 => array:11 [
"RoomKey" => "1609611980"
"RoomType" => "Sunroom"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 3.76
"ListingKey" => "29586351"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
6 => array:11 [
"RoomKey" => "1609611981"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29586351"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
7 => array:11 [
"RoomKey" => "1609611982"
"RoomType" => "Bedroom"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29586351"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
8 => array:11 [
"RoomKey" => "1609611983"
"RoomType" => "Bedroom"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 2.54
"ListingKey" => "29586351"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
9 => array:11 [
"RoomKey" => "1609611984"
"RoomType" => "Bathroom"
"ListingId" => "X12982100"
"RoomLevel" => "Main level"
"RoomWidth" => 1.7
"ListingKey" => "29586351"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.8Z"
]
10 => array:11 [
"RoomKey" => "1609611985"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12982100"
"RoomLevel" => "Basement"
"RoomWidth" => 8.69
"ListingKey" => "29586351"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-04-10T15:57:04.81Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29586351/2091-concession-6-road-w-hamilton-rural-flamborough"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-04-10T15:57:04.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370039"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6584064950"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/65c1d3c5ec99ec234e6b5ad676e370c9.webp"
"MediaSize" => 317272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-65c1d3c5ec99ec234e6b5ad676e370c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6584065041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/a3d6c99e02ffbe641ecdd5dc77276625.webp"
"MediaSize" => 215631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-a3d6c99e02ffbe641ecdd5dc77276625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6584065209"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/202f6e1676f71b3916cc50f44c0aa309.webp"
"MediaSize" => 262485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-202f6e1676f71b3916cc50f44c0aa309.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6584065289"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/3ba91426ae0a19df1ad963e2a447a7ec.webp"
"MediaSize" => 280087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-3ba91426ae0a19df1ad963e2a447a7ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6584065427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/00f4ad410fecafbcf3933c48047b787b.webp"
"MediaSize" => 257204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-00f4ad410fecafbcf3933c48047b787b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6584065510"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/c169f51ab69594be6a5d51f143b5b039.webp"
"MediaSize" => 193177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-c169f51ab69594be6a5d51f143b5b039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6584065578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/e7c35afcf112e5025fe43fa508cb14ae.webp"
"MediaSize" => 246503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-e7c35afcf112e5025fe43fa508cb14ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6584065692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/e912828e990d77418575d8fe4a6cc291.webp"
"MediaSize" => 226914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-e912828e990d77418575d8fe4a6cc291.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6584065779"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/78a4cdfa76184457f8bc50222cfe785c.webp"
"MediaSize" => 214650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-78a4cdfa76184457f8bc50222cfe785c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6584065868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/7d3c6011ef59437e230dc3514acc7ae3.webp"
"MediaSize" => 232378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-7d3c6011ef59437e230dc3514acc7ae3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6584065981"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/ba4830dbb3484d631e2244aebddd3691.webp"
"MediaSize" => 218825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-ba4830dbb3484d631e2244aebddd3691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6584066083"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/6585ea268efa4d0f429927515af4db15.webp"
"MediaSize" => 216053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-6585ea268efa4d0f429927515af4db15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6584066192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/2ba453d422c05d0111b2ef9026b540dd.webp"
"MediaSize" => 164156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-2ba453d422c05d0111b2ef9026b540dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6584066266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/0048a7a23e73a22f17bb3a515c2a0a91.webp"
"MediaSize" => 177004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-0048a7a23e73a22f17bb3a515c2a0a91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6584066362"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/d8a0d2e3d5951bce511f1d5239a8a1b1.webp"
"MediaSize" => 163495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-d8a0d2e3d5951bce511f1d5239a8a1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6584066394"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/4e0f62b582923b85547ad327d6cb30a4.webp"
"MediaSize" => 300211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-4e0f62b582923b85547ad327d6cb30a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6584066451"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/0377fed60bacfd6cdfe0efc267501dc3.webp"
"MediaSize" => 297327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-0377fed60bacfd6cdfe0efc267501dc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6584066469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/754e0c9cbc81b5c0af04f71725400147.webp"
"MediaSize" => 306564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-754e0c9cbc81b5c0af04f71725400147.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6584066541"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/94a47ed3afb595fd43d0d6cfe40e7d0a.webp"
"MediaSize" => 251454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-94a47ed3afb595fd43d0d6cfe40e7d0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6584066555"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/0fda5a33299637634ac7b46291d3894f.webp"
"MediaSize" => 279734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-0fda5a33299637634ac7b46291d3894f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6584066569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/4bd44840e345f51f229290986cae2f11.webp"
"MediaSize" => 302319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-4bd44840e345f51f229290986cae2f11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6584066628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/3938f439494e28ac8968c8095c0d78ab.webp"
"MediaSize" => 231776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-3938f439494e28ac8968c8095c0d78ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6584066669"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/907b2b4a49d0f18d058f2cd572983f45.webp"
"MediaSize" => 229340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-907b2b4a49d0f18d058f2cd572983f45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6584066690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/b19a431ef1d884dd58276504cefa61cc.webp"
"MediaSize" => 253534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-b19a431ef1d884dd58276504cefa61cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6584066730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/d248461153c31a59dd44ac386152e65d.webp"
"MediaSize" => 281685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-d248461153c31a59dd44ac386152e65d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6584066778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/d85f35a28e1f456bd184a0ac8b143f71.webp"
"MediaSize" => 361544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-d85f35a28e1f456bd184a0ac8b143f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6584066839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/7a2e69e02ba71fbc4dc854c9e08734df.webp"
"MediaSize" => 284620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-7a2e69e02ba71fbc4dc854c9e08734df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6584066902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/f61f7291515f1805f49d209665c1cd06.webp"
"MediaSize" => 338264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-f61f7291515f1805f49d209665c1cd06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6584066923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/684decf4d5fb06e4f939f83e287db46c.webp"
"MediaSize" => 319804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-684decf4d5fb06e4f939f83e287db46c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6584066943"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/0cf8d758a64da1da2b3e7b70c7d3bdb3.webp"
"MediaSize" => 328695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-0cf8d758a64da1da2b3e7b70c7d3bdb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6584066969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/36dc74f3362e88085c4887434d5e8085.webp"
"MediaSize" => 252580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-36dc74f3362e88085c4887434d5e8085.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6584066993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/aba5fd51a58ba1e4c5ec6ef4917e71af.webp"
"MediaSize" => 314308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-aba5fd51a58ba1e4c5ec6ef4917e71af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6584067022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29586351/993580634f96b7844314a5c620e2a995.webp"
"MediaSize" => 352965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29586351/thumbnail-993580634f96b7844314a5c620e2a995.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12982100"
"ResourceRecordKey" => "29586351"
"ModificationTimestamp" => "2026-04-10T15:57:04.78Z"
]
]
+"DaysOnMarket": 78
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29586351')"
+"ID": "1303795"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289816" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2099891" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24857
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29586351'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25241
+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 '29586351'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29586351' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.186008 43.31811)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1527623"
+post_author: 1
+"ListingKey": "29892087"
+"ListingId": "40838916"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T20:40:03Z"
+"RFModificationTimestamp": "2026-06-26T00:22:22Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1275.0
+"BuildingAreaTotal": 0
+"City": "Sheffield"
+"PostalCode": "L0R2Z0"
+"UnparsedAddress": "1235 SHEFFIELD Road, Sheffield, Ontario L0R2Z0"
+"Coordinates": array:2 [
0 => -80.2075591
1 => 43.3235668
]
+"Latitude": 43.3235668
+"Longitude": -80.2075591
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Charming 1.5-storey home situated on an incredible 80' x 360' lot (approx 2/3 of an acre) in the picturesque Village of Sheffield. Offering the perfect blend of country living and convenience, you're just minutes to Cambridge, Dundas, Ancaster and Brantford. This property is a rare find for those seeking space, privacy, and endless outdoor enjoyment. The expansive property is fully fenced around the perimeter and also features a separate fenced dog run, making it ideal for families, pet owners, gardeners, and outdoor enthusiasts alike. Whether you're dreaming of a large vegetable garden, backyard oasis, room for children and pets to roam, or simply enjoying the peace and tranquility of country living, this property delivers. Inside, you'll find a bright open-concept main floor featuring a spacious primary bedroom, bonus room and convenient 4-piece bathroom. Upstairs offers two additional bedrooms and a second 4-piece bathroom, creating a functional layout with a total of three bedrooms and two full bathrooms. The unfinished basement provides abundant storage space and has been professionally waterproofed (2021). Major infrastructure improvements include full septic replacement with permit 2021, oversized to handle up to 24 fixture units, an 85-foot drilled well producing 13 gallons per minute, and a constant-pressure water system installed 2020. Car enthusiasts, hobbyists, and contractors will appreciate the oversized 22' x 21' detached garage/workshop. The generous property offers ample parking for multiple vehicles, trailers, and recreational equipment. Perfectly positioned beside Sheffield Ball Park, this property offers direct access to recreation and green space while maintaining the privacy and charm of small-town living. Offering approximately 1,300 sq. ft. of living space, numerous major updates, and endless possibilities both inside and out, this is a rare opportunity to enjoy the best of rural living while remaining close to all major amenities. (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Entrance"
]
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:16:26.106812+00:00"
+"Directions": "Highway 8 to Old Highway 8 to Sheffield Road"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1968861"
+"ListOfficeKey": "283890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
2 => "Country residential"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T20:20:36Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T20:32:13Z"
+"Stories": "1.5"
+"StreetName": "SHEFFIELD"
+"StreetNumber": "1235"
+"StreetSuffix": "Road"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "4888.87"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1668008342"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838916"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "6' x 7'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.65Z"
]
1 => array:11 [
"RoomKey" => "1668008343"
"RoomType" => "Bedroom"
"ListingId" => "40838916"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.65Z"
]
2 => array:11 [
"RoomKey" => "1668008344"
"RoomType" => "Bedroom"
"ListingId" => "40838916"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.65Z"
]
3 => array:11 [
"RoomKey" => "1668008345"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838916"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 24'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.66Z"
]
4 => array:11 [
"RoomKey" => "1668008346"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838916"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.66Z"
]
5 => array:11 [
"RoomKey" => "1668008347"
"RoomType" => "Family room"
"ListingId" => "40838916"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.66Z"
]
6 => array:11 [
"RoomKey" => "1668008348"
"RoomType" => "Eat in kitchen"
"ListingId" => "40838916"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29892087"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T20:32:13.66Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29892087/1235-sheffield-road-sheffield"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 1275
+"OriginalEntryTimestamp": "2026-06-11T21:20:57.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1256447"
+"ListOfficeNationalAssociationId": "1336415"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29892087_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/36b2b134c725213bc9287895b900b351.webp"
"MediaSize" => 175138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-36b2b134c725213bc9287895b900b351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone exterior residence with a covered front porch, asphalt driveway, detached garage with a dark facade, and mature trees framing the property"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29892087_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/7d77d97ca61e09c198df6e8d15dc83d2.webp"
"MediaSize" => 203205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-7d77d97ca61e09c198df6e8d15dc83d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone-clad exterior featuring a covered front porch with vertical wood siding accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29892087_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/3021973011a48c144823f1f62d3ae977.webp"
"MediaSize" => 204411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-3021973011a48c144823f1f62d3ae977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rectangular lot featuring a single-story dwelling, mature trees, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29892087_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/ff879494e5b1ab6311ee0acf6dd19911.webp"
"MediaSize" => 195892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-ff879494e5b1ab6311ee0acf6dd19911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29892087_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/261979eef78ee7a17abd1334547eb877.webp"
"MediaSize" => 216129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-261979eef78ee7a17abd1334547eb877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive property featuring a substantial green space, mature trees, a perimeter fence, and visible access to a paved roadway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29892087_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/083b09c9346fbee6ccd6af7ffa7df3a8.webp"
"MediaSize" => 151449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-083b09c9346fbee6ccd6af7ffa7df3a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29892087_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/a7c05184ac50dc165ce5cd3899424b5a.webp"
"MediaSize" => 163506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-a7c05184ac50dc165ce5cd3899424b5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone veneer exterior with multiple window styles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29892087_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/7cc3fdb823b551190592483fd67d3aac.webp"
"MediaSize" => 166394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-7cc3fdb823b551190592483fd67d3aac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29892087_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/1eb1b4cb3268dee5bf9b7841c4553447.webp"
"MediaSize" => 164634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-1eb1b4cb3268dee5bf9b7841c4553447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone veneer exterior with multiple windows featuring dark trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29892087_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/119b32402e556b2dbc0738c624ac8d77.webp"
"MediaSize" => 136381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-119b32402e556b2dbc0738c624ac8d77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio terrace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29892087_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/9f7f09cf0b7487b3021cc4fa692547df.webp"
"MediaSize" => 84388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-9f7f09cf0b7487b3021cc4fa692547df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Well-appointed kitchen featuring dark cabinetry, stainless steel appliances, wood-finish countertops, and a white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29892087_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/c310d5bb77a0e47da99fd0d1f9da49f6.webp"
"MediaSize" => 89489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-c310d5bb77a0e47da99fd0d1f9da49f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish countertops, stainless steel appliances, dark cabinetry, subway tile backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29892087_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/d9c29d04aa3a6de3c21a7d3a9a266b90.webp"
"MediaSize" => 86731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-d9c29d04aa3a6de3c21a7d3a9a266b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark cabinetry with silver-tone hardware, wood-finish countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29892087_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/a8ed405cf23a4061d69ff628a67f443f.webp"
"MediaSize" => 93381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-a8ed405cf23a4061d69ff628a67f443f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark cabinetry, wood-finish countertops, subway tile backsplash, stainless steel appliances, and an undermount sink with a black faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29892087_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/2acc60711aa1585670340a8ab53285a7.webp"
"MediaSize" => 88999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-2acc60711aa1585670340a8ab53285a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark cabinetry, wood-finish countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29892087_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/fc8e4af0ec67b99b02e56e8a9aefccc4.webp"
"MediaSize" => 79131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-fc8e4af0ec67b99b02e56e8a9aefccc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area with wood-finish flooring, recessed lighting, and a prominent wood beam accent"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29892087_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/c9dc0954a710bf00ec4169359399802d.webp"
"MediaSize" => 76701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-c9dc0954a710bf00ec4169359399802d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29892087_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/09b10ac80cc7ac116090652a1bf1f060.webp"
"MediaSize" => 73393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-09b10ac80cc7ac116090652a1bf1f060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29892087_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/ca3da6b90e8d877378f7bbcb6522e4aa.webp"
"MediaSize" => 74170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-ca3da6b90e8d877378f7bbcb6522e4aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29892087_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/814c0481ff74fc5153b3c013139415ff.webp"
"MediaSize" => 75417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-814c0481ff74fc5153b3c013139415ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept living space featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29892087_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/a1453b6ccbf2ddc5d0719d09782a8b19.webp"
"MediaSize" => 60292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-a1453b6ccbf2ddc5d0719d09782a8b19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white countertop and undermount sink, matte black faucet, and a large wood-framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29892087_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/8f395f01c74fdcb46cc2174415d5731e.webp"
"MediaSize" => 62257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-8f395f01c74fdcb46cc2174415d5731e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single vanity with a white countertop and basin sink, a rustic wood-framed mirror, industrial-style wall sconce, and a window with natural wood trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29892087_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/2a51b1362008253614456d26bc3a072a.webp"
"MediaSize" => 79620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-2a51b1362008253614456d26bc3a072a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29892087_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/c2754de17ad894d461e829d5113c3e82.webp"
"MediaSize" => 71098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-c2754de17ad894d461e829d5113c3e82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29892087_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/950a4c707d378b77eacb9094a1b80b6e.webp"
"MediaSize" => 94935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-950a4c707d378b77eacb9094a1b80b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29892087_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/3b99dc55f15e19c8cd18b96513797a50.webp"
"MediaSize" => 74170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-3b99dc55f15e19c8cd18b96513797a50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29892087_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/6fade4b477ebe95a0aa29f70a2fecef3.webp"
"MediaSize" => 52950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-6fade4b477ebe95a0aa29f70a2fecef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished attic space featuring wood-finish flooring, a double-hung window, sloped ceilings, and a barn-style access door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29892087_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/4668a73bf07f0ee35c1abb1c6b8a9d6b.webp"
"MediaSize" => 54997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-4668a73bf07f0ee35c1abb1c6b8a9d6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a double window, a ceiling-mounted light fixture, a knee wall with a wood-paneled access door, and a painted accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29892087_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/228ee6a64331f9bb8edaa35afac29a07.webp"
"MediaSize" => 48328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-228ee6a64331f9bb8edaa35afac29a07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring sloped ceilings, wood-finish flooring, and a double-hung window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29892087_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/6858c5229ef2bc15facb16ffa793589a.webp"
"MediaSize" => 47536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-6858c5229ef2bc15facb16ffa793589a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Attic space featuring wood-finish flooring, a double window, and two built-in storage doors with barn door styling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29892087_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/3d87cf72d0f5653a5806d48b30498adb.webp"
"MediaSize" => 60328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-3d87cf72d0f5653a5806d48b30498adb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a white curved countertop, undermount sink, and dark bronze-finish faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29892087_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/8c4127b857bdbf2bbda6919101a9af6f.webp"
"MediaSize" => 63055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-8c4127b857bdbf2bbda6919101a9af6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with an integrated sink, dual-pane windows, a toilet, and patterned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29892087_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/704a428f4a79038a2c05e2bb61734656.webp"
"MediaSize" => 191643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-704a428f4a79038a2c05e2bb61734656.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Detached garage with black siding, a single overhead door, and a separate entry door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29892087_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/6b4b7015858fabdcc3b7048f6e9c3278.webp"
"MediaSize" => 143230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-6b4b7015858fabdcc3b7048f6e9c3278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious garage featuring exposed wood beam ceilings and walls, concrete flooring, dual windows, and ample workspace with built-in shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29892087_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/e9006f72426962723af31058d83181c4.webp"
"MediaSize" => 177512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-e9006f72426962723af31058d83181c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gravel-surfaced yard with full chain-link fencing, a large evergreen tree, and an exterior featuring stone veneer and vertical siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29892087_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/51e6b2fe4dbc89f882dc22e9e846df61.webp"
"MediaSize" => 172354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-51e6b2fe4dbc89f882dc22e9e846df61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grassy lot featuring mature trees and a partial wooden post fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29892087_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/7604321be9e7b488b4eb5236c64ec997.webp"
"MediaSize" => 178649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-7604321be9e7b488b4eb5236c64ec997.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn with a fire pit feature, surrounded by mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29892087_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/4fe8e3c00dd281ee7dd84f4dd02c3d53.webp"
"MediaSize" => 221294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-4fe8e3c00dd281ee7dd84f4dd02c3d53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, a stone fire pit, and a screened garden structure with raised beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29892087_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/cc9ad16f1c53bef4d19b82acc1c4e62d.webp"
"MediaSize" => 222330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-cc9ad16f1c53bef4d19b82acc1c4e62d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn with a wood-framed enclosure on a gravel base, an outdoor seating area with stone retaining walls, and a separate structure featuring board-and-batten siding and an asphalt shingl"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29892087_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/c53855bf960332148e16ccf5cd03f107.webp"
"MediaSize" => 228448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-c53855bf960332148e16ccf5cd03f107.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enclosed raised garden beds with a gravel perimeter, surrounded by a lush green lawn and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29892087_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/d2c185ed32d81700129563bf05c56fa8.webp"
"MediaSize" => 222230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-d2c185ed32d81700129563bf05c56fa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29892087_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/7d492a3a9414f5a75bafad856831d31e.webp"
"MediaSize" => 184100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-7d492a3a9414f5a75bafad856831d31e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grassy lawn bordered by mature trees and a post fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29892087_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/788bb1abdfd92fd114c65e1cfa2729d9.webp"
"MediaSize" => 165584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-788bb1abdfd92fd114c65e1cfa2729d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn framed by a wire fence and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29892087_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/da590228c0f0a94afd3e251d284c0078.webp"
"MediaSize" => 202078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-da590228c0f0a94afd3e251d284c0078.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential area bordered by expansive green fields and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29892087_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892087/bb1f39f51eb0ae7bf2b5a4fbcd50e668.webp"
"MediaSize" => 199510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892087/thumbnail-bb1f39f51eb0ae7bf2b5a4fbcd50e668.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green spaces define this property's setting, featuring mature trees and a substantial grassy area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838916"
"ResourceRecordKey" => "29892087"
"ModificationTimestamp" => "2026-06-11T21:20:57.74Z"
]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892087')"
+"ID": "1527623"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1527576"
+post_author: 1
+"ListingKey": "29892578"
+"ListingId": "X13434590"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:30:20Z"
+"RFModificationTimestamp": "2026-06-21T18:38:59Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R1Z0"
+"UnparsedAddress": "1235 SHEFFIELD ROAD, Hamilton, Ontario L0R1Z0"
+"Coordinates": array:2 [
0 => -80.208148
1 => 43.323622
]
+"Latitude": 43.323622
+"Longitude": -80.208148
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Charming 1.5-storey home situated on an incredible 80' x 360' lot (approx 2/3 of an acre) in the picturesque Village of Sheffield. Offering the perfect blend of country living and convenience, you're just minutes to Cambridge, Dundas, Ancaster and Brantford. This property is a rare find for those seeking space, privacy, and endless outdoor enjoyment. The expansive property is fully fenced around the perimeter and also features a separate fenced dog run, making it ideal for families, pet owners, gardeners, and outdoor enthusiasts alike. Whether you're dreaming of a large vegetable garden, backyard oasis, room for children and pets to roam, or simply enjoying the peace and tranquility of country living, this property delivers. Inside, you'll find a bright open-concept main floor featuring a spacious primary bedroom, bonus room and convenient 4-piece bathroom. Upstairs offers two additional bedrooms and a second 4-piece bathroom, creating a functional layout with a total of three bedrooms and two full bathrooms. The unfinished basement provides abundant storage space and has been professionally waterproofed (2021). Major infrastructure improvements include full septic replacement with permit 2021, oversized to handle up to 24 fixture units, an 85-foot drilled well producing 13 gallons per minute, and a constant-pressure water system installed 2020. Car enthusiasts, hobbyists, and contractors will appreciate the oversized 22' x 21' detached garage/workshop. The generous property offers ample parking for multiple vehicles, trailers, and recreational equipment. Perfectly positioned beside Sheffield Ball Park, this property offers direct access to recreation and green space while maintaining the privacy and charm of small-town living. Offering approximately 1,300 sq. ft. of living space, numerous major updates, and endless possibilities both inside and out, this is a rare opportunity to enjoy the best of rural living while remaining close to all major amenities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T22:54:34.831678+00:00"
+"Directions": "Cross Streets: Highway 8 & Sheffield. ** Directions: Highway 8 to Old Highway 8 to Sheffield Road."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2008423"
+"ListOfficeKey": "283948"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "80 x 364 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T22:19:46Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T12:22:52Z"
+"Stories": "1.5"
+"StreetName": "Sheffield"
+"StreetNumber": "1235"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4888.87"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1664641033"
"RoomType" => "Kitchen"
"ListingId" => "X13434590"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "29892578"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
1 => array:11 [
"RoomKey" => "1664641034"
"RoomType" => "Family room"
"ListingId" => "X13434590"
"RoomLevel" => "Main level"
"RoomWidth" => 5.18
"ListingKey" => "29892578"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
2 => array:11 [
"RoomKey" => "1664641035"
"RoomType" => "Bathroom"
"ListingId" => "X13434590"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29892578"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
3 => array:11 [
"RoomKey" => "1664641036"
"RoomType" => "Bedroom"
"ListingId" => "X13434590"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29892578"
"RoomLength" => 7.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
4 => array:11 [
"RoomKey" => "1664641037"
"RoomType" => "Bedroom 2"
"ListingId" => "X13434590"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29892578"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
5 => array:11 [
"RoomKey" => "1664641038"
"RoomType" => "Bedroom 3"
"ListingId" => "X13434590"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29892578"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
6 => array:11 [
"RoomKey" => "1664641039"
"RoomType" => "Bathroom"
"ListingId" => "X13434590"
"RoomLevel" => "Second level"
"RoomWidth" => 1.83
"ListingKey" => "29892578"
"RoomLength" => 2.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-21T12:22:52.43Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892578/1235-sheffield-road-hamilton-rural-flamborough"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-06-11T22:19:46.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1290297"
+"ListOfficeNationalAssociationId": "1337191"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29892578_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/73272e92575dfe8198eca5c01e60210b.webp"
"MediaSize" => 483119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-73272e92575dfe8198eca5c01e60210b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29892578_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/f2b8457bef02bff2a13e5bb4ca8c8b55.webp"
"MediaSize" => 541002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-f2b8457bef02bff2a13e5bb4ca8c8b55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29892578_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/1dcaf43e7a79f59e60c269d13db7f4e3.webp"
"MediaSize" => 497817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-1dcaf43e7a79f59e60c269d13db7f4e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29892578_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/41c1556383af45f3f2a5fe941a202ee1.webp"
"MediaSize" => 484317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-41c1556383af45f3f2a5fe941a202ee1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29892578_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/b534d7e06ecbaa0f72174eadf4368a85.webp"
"MediaSize" => 536216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-b534d7e06ecbaa0f72174eadf4368a85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29892578_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/d87d6a5bd1dd84aaa18655398c35ea60.webp"
"MediaSize" => 375574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-d87d6a5bd1dd84aaa18655398c35ea60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29892578_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/bacc90f99817c20d062e841fbd089d68.webp"
"MediaSize" => 446969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-bacc90f99817c20d062e841fbd089d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29892578_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/e2b3c0a117362cf44b20c8a7cae0b9e4.webp"
"MediaSize" => 463347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-e2b3c0a117362cf44b20c8a7cae0b9e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29892578_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/9df4207cb9f41c760bc995511cc847c9.webp"
"MediaSize" => 424686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-9df4207cb9f41c760bc995511cc847c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29892578_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/cb446abea283476ea85737dcf9dd8c4b.webp"
"MediaSize" => 349925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-cb446abea283476ea85737dcf9dd8c4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29892578_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/1d17fff340158798ec22ec86fb8b3cb3.webp"
"MediaSize" => 192985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-1d17fff340158798ec22ec86fb8b3cb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29892578_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/c0dbc18b2ff608c3fee378a3adb6288d.webp"
"MediaSize" => 202396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-c0dbc18b2ff608c3fee378a3adb6288d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29892578_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/2a3b53282f2b81e114530b94907abd44.webp"
"MediaSize" => 199704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-2a3b53282f2b81e114530b94907abd44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29892578_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/28b79e9030ac84cc39e6886af8e0dac9.webp"
"MediaSize" => 209529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-28b79e9030ac84cc39e6886af8e0dac9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29892578_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/6727dc9acc05ed6b33d223f0aabebb36.webp"
"MediaSize" => 208101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-6727dc9acc05ed6b33d223f0aabebb36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29892578_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/651ee3a04bf7d6afe5399ab0e09fced4.webp"
"MediaSize" => 167962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-651ee3a04bf7d6afe5399ab0e09fced4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29892578_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/a71908ab94b9fd49ca7804affd67752e.webp"
"MediaSize" => 177885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-a71908ab94b9fd49ca7804affd67752e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29892578_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/dd974deb5a7fb57137e516e9a3d51a3b.webp"
"MediaSize" => 172226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-dd974deb5a7fb57137e516e9a3d51a3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29892578_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/6c563c077ed9f155fad0cd1b5fb5a08f.webp"
"MediaSize" => 134206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-6c563c077ed9f155fad0cd1b5fb5a08f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29892578_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/74a1e410b903bf6e24b5b6ca078e1abe.webp"
"MediaSize" => 136395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-74a1e410b903bf6e24b5b6ca078e1abe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29892578_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/88ffc66ff94376f919209aad3e1cde86.webp"
"MediaSize" => 171305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-88ffc66ff94376f919209aad3e1cde86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29892578_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29892578/72cf47ac2f86cb8a1f652cf349c6575d.webp"
"MediaSize" => 146783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29892578/thumbnail-72cf47ac2f86cb8a1f652cf349c6575d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13434590"
"ResourceRecordKey" => "29892578"
"ModificationTimestamp" => "2026-06-11T22:19:46.61Z"
]
22 => array:13 [
"Order" => 23
…12
]
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892578')"
+"ID": "1527576"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1361196"
+post_author: 1
+"ListingKey": "29665353"
+"ListingId": "X13051502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-22T16:10:04Z"
+"RFModificationTimestamp": "2026-05-22T16:13:15Z"
+"ListPrice": 1095000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9H5E1"
+"UnparsedAddress": "1211 OLD 8 HIGHWAY, Hamilton, Ontario L9H5E1"
+"Coordinates": array:2 [
0 => -80.2001313
1 => 43.322921
]
+"Latitude": 43.322921
+"Longitude": -80.2001313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 1211 Old Hwy 8 in Sheffield. This beautifully updated raised bungalow sits on an impressive 150 x 200 ft lot backing onto open farm fields, offering space, privacy, and country views just minutes to city conveniences.Featuring 4 bedrooms, 2 full bathrooms, and approximately 2,475 sq ft of finished living space, this move in ready home has been thoughtfully renovated with an updated kitchen, bathrooms, hardwood flooring, and tile throughout.The bright main floor offers comfortable everyday living, while the finished lower level provides excellent additional space for family living, guests, a home office, or recreation.Step outside from the kitchen sliding patio doors to an elevated deck overlooking the yard. Below, enjoy a private concrete patio complete with hot tub, gazebo cover, and privacy fencing, creating the perfect outdoor retreat.The large backyard also includes a generous garden area ideal for growing your own fresh fruit and produce.Car enthusiasts, hobbyists, and families will appreciate the oversized attached garage with front and rear doors, offering flexible storage and parking for 2 vehicles, plus a wide driveway with room for 6+ more vehicles.A rare opportunity to own a renovated home on a premium lot in a desirable location. Book your private showing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-28T15:15:52.124473+00:00"
+"Directions": "Cross Streets: Settlers Rd. / Old Hwy 8. ** Directions: SETTLERS RD."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236223"
+"ListOfficeKey": "268116"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "150 x 201.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-28T14:23:32Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-22T16:01:03Z"
+"Stories": "1.0"
+"StreetName": "Old Highway 8"
+"StreetNumber": "1211"
+"StreetSuffix": "Highway"
+"TaxAnnualAmount": "6004"
+"VirtualTourURLUnbranded": "https://tours.vastvue.ca/1211-Old-Hwy-8"
+"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": "OnePoint"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29665353/1211-old-highway-8-highway-hamilton-rural-flamborough"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 150.0
+"OriginalEntryTimestamp": "2026-04-28T14:23:32.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1474141"
+"ListOfficeNationalAssociationId": "1231499"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 60
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29665353')"
+"ID": "1361196"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1295286"
+post_author: 1
+"ListingKey": "29574761"
+"ListingId": "X12972380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-07T13:50:55Z"
+"RFModificationTimestamp": "2026-05-07T17:11:54Z"
+"ListPrice": 808000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R1Z0"
+"UnparsedAddress": "1247 OLD 8 HIGHWAY, Hamilton, Ontario L0R1Z0"
+"Coordinates": array:2 [
0 => -80.2048896
1 => 43.3242574
]
+"Latitude": 43.3242574
+"Longitude": -80.2048896
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An exceptional opportunity to acquire commercially zoned land in the heart of Sheffield, Ontario. Situated along a high visibility stretch of Old Highway 8, this expansive parcel offers flexible industrial/commercial zoning, making it ideal for a wide range of uses including warehousing, contractor yard, light manufacturing, equipment storage, or future development. The property benefits from excellent road frontage and easy access to nearby transportation routes, including Highway 401 and Highway 8, connecting Cambridge, Hamilton, and the wider Golden Horseshoe region. With limited industrial land inventory in the area, this site presents strong long-term investment potential or a perfect location for an owner-user seeking room to grow. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Stove"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-04-08T21:02:28.572028+00:00"
+"Directions": "Sheffield Rd / Settlers Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182001"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Wooded area"
2 => "Flat site"
]
+"LotSizeDimensions": "124 x 223.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-08T19:47:20Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-07T13:44:16Z"
+"Stories": "1.5"
+"StreetName": "Old 8"
+"StreetNumber": "1247"
+"StreetSuffix": "Highway"
+"TaxAnnualAmount": "5049"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"View": "View"
+"VirtualTourURLUnbranded": "https://view.spiro.media/order/a4e9932c-7e1e-4f09-6db2-08de89fa6a94"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29574761/1247-old-8-highway-hamilton-rural-flamborough"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2021509"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290358"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "S2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 124.0
+"OriginalEntryTimestamp": "2026-04-08T19:47:19.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1431742"
+"ListOfficeNationalAssociationId": "1408695"
+"CoListAgentNationalAssociationId": "1301436"
+"CoListOfficeNationalAssociationId": "1386142"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 80
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29574761')"
+"ID": "1295286"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1295810"
+post_author: 1
+"ListingKey": "29574114"
+"ListingId": "40818722"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:03Z"
+"RFModificationTimestamp": "2026-06-02T17:46:28Z"
+"ListPrice": 808000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1372.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R1Z0"
+"UnparsedAddress": "1247 OLD HIGHWAY 8, Hamilton, Ontario L0R1Z0"
+"Coordinates": array:2 [
0 => -80.20489
1 => 43.324285
]
+"Latitude": 43.324285
+"Longitude": -80.20489
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An exceptional opportunity to acquire commercially zoned land in the heart of Sheffield, Ontario. Situated along a high-visibility stretch of Old Highway 8, this expansive parcel offers flexible industrial/commercial zoning, making it ideal for a wide range of uses including warehousing, contractor yard, light manufacturing, equipment storage, or future development. The property benefits from excellent road frontage and easy access to nearby transportation routes, including Highway 401 and Highway 8, connecting Cambridge, Hamilton, and the wider Golden Horseshoe region. With limited industrial land inventory in the area, this site presents strong long-term investment potential or a perfect location for an owner-user seeking room to grow. (id:62783)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-04-08T19:27:26.622611+00:00"
+"Directions": "Sheffield Rd / Settlers Rd"
+"ExteriorFeatures": array:3 [
0 => "Aluminum siding"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2009131"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Country residential"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T13:31:54Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:44:13Z"
+"Stories": "1.5"
+"StreetName": "OLD HIGHWAY 8"
+"StreetNumber": "1247"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "5049"
+"VirtualTourURLUnbranded": "https://view.spiro.media/order/a4e9932c-7e1e-4f09-6db2-08de89fa6a94"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29574114/1247-old-highway-8-hamilton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 124.0
+"AboveGradeFinishedArea": 1372
+"OriginalEntryTimestamp": "2026-04-08T18:49:58.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1290895"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 80
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29574114')"
+"ID": "1295810"
}
]
+success: true
+page_size: 5
+page_count: 1
+count: 5
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]