These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=165420&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24509 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24585 +post_id: "1057689" +post_author: 1 +"ListingKey": "29222912" +"ListingId": "40796494" +"PropertyType": "Farm" +"PropertySubType": "Agriculture" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T00:00:43Z" +"RFModificationTimestamp": "2026-06-10T00:04:25Z" +"ListPrice": 3895000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 2 +"BedroomsTotal": 3.0 +"LotSizeArea": 140.0 +"LivingArea": 5000.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H5E3" +"UnparsedAddress": "1457 97 REGIONAL Road, Hamilton, Ontario L9H5E3" +"Coordinates": array:2 [ 0 => -80.11295 1 => 43.386208 ] +"Latitude": 43.386208 +"Longitude": -80.11295 +"YearBuilt": 1850 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "A rare 142-acre offering combining historic character, natural beauty, and exceptional versatility. The property features mixed flat and rolling land, a majestic 10,000 sq ft century barn with hand-hewn beams and timber floors, a rare standing stone silo, and three houses with five residential units. Flexible agricultural zoning and abundant amenities create an extraordinary canvas for living, farming, hospitality, or a legacy project. Ideal for multiple buyer types, the property can support a working farm with production and agritourism, a hospitality venture such as a bed and breakfast or retreat, a multi-generational compound, or a signature architectural conversion of the barn and silo. The combination of acreage, water features, multiple dwellings, and significant road frontage makes this a distinctive investment and lifestyle opportunity. Approximately 120 acres of workable fields and pasture support crops or grazing, while 30 acres of buildings and mature woodlands offer privacy and trails. A year-round creek feeds a large pond, providing reliable water, wildlife habitat, and recreational enjoyment. The original 1885 barn and stone silo are defining assets. The barn’s scale and character suit conversion to a residence, event venue, or hospitality space. The stone silo offers unique potential as a stair tower, study, or display feature. Agricultural zoning permits bed and breakfast operations and agritourism, enabling boutique farm-hospitality or agriculture-based enterprises. Located 15 minutes from Cambridge and Waterdown with access to Highways 401 and 6, the property balances rural privacy with convenience. Three houses offer five Legal Non-Conforming residential units, allowed to continue in their current form with renovations. The homes require updating, giving buyers the opportunity to customize while benefiting from immediate vacant possession. (id:62650)" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"BathroomsPartial": 2 +"Cooling": array:1 [ 0 => "Ductless" ] +"CreationDate": "2026-01-07T01:35:01.988710+00:00" +"Directions": "Hwy 6 to Regional Road 97, West to 1457" +"ExteriorFeatures": array:2 [ 0 => "Stone" 1 => "Other" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:1 [ 0 => "Other" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525445" +"ListOfficeKey": "279638" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "In-Law Suite" ] +"LotSizeDimensions": "140" +"NumberOfUnitsTotal": "2" +"PhotosChangeTimestamp": "2026-01-07T01:08:22Z" +"PhotosCount": 48 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:53:33Z" +"Stories": "2.0" +"StreetName": "97 REGIONAL" +"StreetNumber": "1457" +"StreetSuffix": "Road" +"SubdivisionName": "045 - Beverly" +"TaxAnnualAmount": "8117" +"WaterSource": array:1 [ 0 => "Bored Well" ] +"Rooms": array:16 [ 0 => array:11 [ "RoomKey" => "1656001039" "RoomType" => "Utility room" "ListingId" => "40796494" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.14Z" ] 1 => array:11 [ "RoomKey" => "1656001040" "RoomType" => "Bedroom" "ListingId" => "40796494" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.14Z" ] 2 => array:11 [ "RoomKey" => "1656001041" "RoomType" => "Bedroom" "ListingId" => "40796494" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 11'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.14Z" ] 3 => array:11 [ "RoomKey" => "1656001042" "RoomType" => "4pc Bathroom" "ListingId" => "40796494" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 4 => array:11 [ "RoomKey" => "1656001043" "RoomType" => "Primary Bedroom" "ListingId" => "40796494" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 13'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 5 => array:11 [ "RoomKey" => "1656001044" "RoomType" => "2pc Bathroom" "ListingId" => "40796494" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 6 => array:11 [ "RoomKey" => "1656001045" "RoomType" => "Foyer" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "7'2'' x 9'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 7 => array:11 [ "RoomKey" => "1656001046" "RoomType" => "Dining room" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 16'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 8 => array:11 [ "RoomKey" => "1656001047" "RoomType" => "Dinette" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 9'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 9 => array:11 [ "RoomKey" => "1656001048" "RoomType" => "Dining room" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "14'0'' x 16'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 10 => array:11 [ "RoomKey" => "1656001049" "RoomType" => "2pc Bathroom" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 11 => array:11 [ "RoomKey" => "1656001050" "RoomType" => "Den" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "10'1'' x 7'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.15Z" ] 12 => array:11 [ "RoomKey" => "1656001051" "RoomType" => "Living room" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "17'0'' x 16'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.16Z" ] 13 => array:11 [ "RoomKey" => "1656001052" "RoomType" => "Laundry room" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "5'4'' x 7'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.16Z" ] 14 => array:11 [ "RoomKey" => "1656001053" "RoomType" => "Mud room" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "10' x 6'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.16Z" ] 15 => array:11 [ "RoomKey" => "1656001054" "RoomType" => "Kitchen" "ListingId" => "40796494" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29222912" "RoomLength" => null "RoomDimensions" => "15'9'' x 14'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:53:33.16Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29222912/1457-97-regional-road-hamilton" +"ParkingTotal": 40 +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "Farm" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 1264.0 +"AboveGradeFinishedArea": 5000 +"OriginalEntryTimestamp": "2026-01-07T01:08:22.26Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1122313" +"ListOfficeNationalAssociationId": "1306586" +"Media": array:48 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6394822680" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/6ec678ae61ddceb49a8ec24159397a93.webp" "MediaSize" => 195736 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-6ec678ae61ddceb49a8ec24159397a93.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6394822685" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/85f1ef5769452cbe1ec23eee0598335f.webp" "MediaSize" => 231783 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-85f1ef5769452cbe1ec23eee0598335f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6394822690" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/4fc5282126906d617b67e524b540f6fd.webp" "MediaSize" => 93066 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-4fc5282126906d617b67e524b540f6fd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6394822700" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/b0b9691d47b1aea0b261618a5b66bc76.webp" "MediaSize" => 156038 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-b0b9691d47b1aea0b261618a5b66bc76.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6394822709" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/c2be349020e95d0134e2cb849e0d5a4e.webp" "MediaSize" => 170636 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-c2be349020e95d0134e2cb849e0d5a4e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6394822719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/87165bf7d0c61aca87fa9a53cae99eb0.webp" "MediaSize" => 137053 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-87165bf7d0c61aca87fa9a53cae99eb0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6394822729" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/d0aa22c83aa880726a71679a5386cde3.webp" "MediaSize" => 132971 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-d0aa22c83aa880726a71679a5386cde3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6394822738" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/5b842803a342f3a3e8d02410cd37e8f4.webp" "MediaSize" => 118648 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-5b842803a342f3a3e8d02410cd37e8f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6394822743" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/f70df5bcf1ac8b9eca0b718daea889de.webp" "MediaSize" => 68803 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-f70df5bcf1ac8b9eca0b718daea889de.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6394822755" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/c0816b7ec924182533777c692368e3f4.webp" "MediaSize" => 69956 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-c0816b7ec924182533777c692368e3f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6394822773" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/f40b06b00aeaf9a835d87e941854808c.webp" "MediaSize" => 69037 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-f40b06b00aeaf9a835d87e941854808c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6394822781" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/de395b4a55c203d9eb01d90b8614a98d.webp" "MediaSize" => 62167 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-de395b4a55c203d9eb01d90b8614a98d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6394822788" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/bfa104ed5c0a393570b74412225c96e2.webp" "MediaSize" => 122768 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-bfa104ed5c0a393570b74412225c96e2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6394822799" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/27a6e2ce6caf61f24bdc38b04368554b.webp" "MediaSize" => 197925 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-27a6e2ce6caf61f24bdc38b04368554b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6394822815" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/7dc56eafd0abc858e0f1722d40d16166.webp" "MediaSize" => 195873 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-7dc56eafd0abc858e0f1722d40d16166.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6394822825" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/c603a06688ecdb968032bd5f286d2057.webp" "MediaSize" => 173726 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-c603a06688ecdb968032bd5f286d2057.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6394822834" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/5ce9df06d771b6d689169de6664d5e24.webp" "MediaSize" => 148361 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-5ce9df06d771b6d689169de6664d5e24.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6394822843" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/3cc6e18f77404afcbcb25726695ce84f.webp" "MediaSize" => 220153 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-3cc6e18f77404afcbcb25726695ce84f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6394822852" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/047c8dffa2217742384a3a0a97a59a1e.webp" "MediaSize" => 238997 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-047c8dffa2217742384a3a0a97a59a1e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6394822860" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/661b217b9f4523c8cde77890ea79a26f.webp" "MediaSize" => 143999 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-661b217b9f4523c8cde77890ea79a26f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6394822866" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/b2e6ebe61e7f7b26ea72a89acd412c84.webp" "MediaSize" => 214941 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-b2e6ebe61e7f7b26ea72a89acd412c84.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6394822873" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/c69a71df6d1f6878df01893eca0eac27.webp" "MediaSize" => 149182 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-c69a71df6d1f6878df01893eca0eac27.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6394822880" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/a1277c43abe0693afff5927ac0a83a7f.webp" "MediaSize" => 161851 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-a1277c43abe0693afff5927ac0a83a7f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6394822883" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/1253b7f5be48dfafe97365a260c79603.webp" "MediaSize" => 216814 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-1253b7f5be48dfafe97365a260c79603.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6394822889" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/8538978bd7e6b2efbf4a3d8a62b3d5e4.webp" "MediaSize" => 247997 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-8538978bd7e6b2efbf4a3d8a62b3d5e4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6394822894" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/52a7bc2a5a749615cc98ce39e4b76c70.webp" "MediaSize" => 250055 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-52a7bc2a5a749615cc98ce39e4b76c70.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6394822898" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/4dba36d2dfa2123933914ad4c00f38a7.webp" "MediaSize" => 264019 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-4dba36d2dfa2123933914ad4c00f38a7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6394822902" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/6980b23ddd1ad0d2d86a22cd7b7f72c4.webp" "MediaSize" => 259238 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-6980b23ddd1ad0d2d86a22cd7b7f72c4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6394822907" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/be94ab19e4a565d52cd8618a292227ad.webp" "MediaSize" => 182672 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-be94ab19e4a565d52cd8618a292227ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6394822912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/fc887c6820d6ee3e2d47b1879f3aa07a.webp" "MediaSize" => 242230 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-fc887c6820d6ee3e2d47b1879f3aa07a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6394822916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/ed0ad390c282d7bd4158aa148267a18a.webp" "MediaSize" => 212294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-ed0ad390c282d7bd4158aa148267a18a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6394822919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/3f3ef6a9e44dbfb07a1aad914e2c1c00.webp" "MediaSize" => 217306 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-3f3ef6a9e44dbfb07a1aad914e2c1c00.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6394822924" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/fd15d104b3783868bb250b7d7c9b1fe8.webp" "MediaSize" => 235074 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-fd15d104b3783868bb250b7d7c9b1fe8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6394822927" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/f470a3df816b2f2a8cfd09839b5e5947.webp" "MediaSize" => 43045 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-f470a3df816b2f2a8cfd09839b5e5947.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 34 => array:13 [ "Order" => 34 "MediaKey" => "6394822930" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/3e8881b098d3ddd502cd520109fae8d1.webp" "MediaSize" => 57127 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-3e8881b098d3ddd502cd520109fae8d1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 35 => array:13 [ "Order" => 35 "MediaKey" => "6394822933" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/00dfa10d59dfeed727bcd66cd486c8d4.webp" "MediaSize" => 60537 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-00dfa10d59dfeed727bcd66cd486c8d4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 36 => array:13 [ "Order" => 36 "MediaKey" => "6394822937" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/ae5465727e85d8857e06d0c966dc575b.webp" "MediaSize" => 96259 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-ae5465727e85d8857e06d0c966dc575b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 37 => array:13 [ "Order" => 37 "MediaKey" => "6394822940" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/c8cc1ef83b9febcf65741ef621df1eb7.webp" "MediaSize" => 99063 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-c8cc1ef83b9febcf65741ef621df1eb7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 38 => array:13 [ "Order" => 38 "MediaKey" => "6394822943" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/4a4d6077cd7d9a8c302c29b16cdbf667.webp" "MediaSize" => 66179 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-4a4d6077cd7d9a8c302c29b16cdbf667.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 39 => array:13 [ "Order" => 39 "MediaKey" => "6394822947" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/d81b94a389f7617dbdff1e7ee6110769.webp" "MediaSize" => 75940 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-d81b94a389f7617dbdff1e7ee6110769.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 40 => array:13 [ "Order" => 40 "MediaKey" => "6394822950" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/1503011c8d0cbeddcc2d87b99d04970e.webp" "MediaSize" => 47294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-1503011c8d0cbeddcc2d87b99d04970e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 41 => array:13 [ "Order" => 41 "MediaKey" => "6394822953" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/51189b9ad2e38c00c2dbb4e7b195f5d1.webp" "MediaSize" => 110479 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-51189b9ad2e38c00c2dbb4e7b195f5d1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 42 => array:13 [ "Order" => 42 "MediaKey" => "6394822956" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/8860716650714a96ebe1bb32e6fd10df.webp" "MediaSize" => 74640 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-8860716650714a96ebe1bb32e6fd10df.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 43 => array:13 [ "Order" => 43 "MediaKey" => "6394822960" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/ae68bebf3fc5b02fc3b03dc8e5faa4e9.webp" "MediaSize" => 239622 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-ae68bebf3fc5b02fc3b03dc8e5faa4e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 44 => array:13 [ "Order" => 44 "MediaKey" => "6394822964" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/ab8f0ada9897d19bd101f23120e33c61.webp" "MediaSize" => 239241 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-ab8f0ada9897d19bd101f23120e33c61.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 45 => array:13 [ "Order" => 45 "MediaKey" => "6394822967" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/3fc2674bde2ef1edb5ac5662da82a01f.webp" "MediaSize" => 52392 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-3fc2674bde2ef1edb5ac5662da82a01f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 46 => array:13 [ "Order" => 46 "MediaKey" => "6394822970" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/1e9138444f5ba92e37f4cb3e05086b59.webp" "MediaSize" => 48561 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-1e9138444f5ba92e37f4cb3e05086b59.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] 47 => array:13 [ "Order" => 47 "MediaKey" => "6394822973" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29222912/d30cd806d5fce75c1abd8655d144e1c0.webp" "MediaSize" => 54809 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29222912/thumbnail-d30cd806d5fce75c1abd8655d144e1c0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40796494" "ResourceRecordKey" => "29222912" "ModificationTimestamp" => "2026-01-07T01:08:22.27Z" ] ] +"DaysOnMarket": 163 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29222912')" +"ID": "1057689" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24450 +post_id: "1056526" +post_author: 1 +"ListingKey": "29221006" +"ListingId": "40796472" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T15:30:50Z" +"RFModificationTimestamp": "2026-06-02T15:45:06Z" +"ListPrice": 869000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1130.0 +"BuildingAreaTotal": 0 +"City": "Long Point" +"PostalCode": "N0E1M0" +"UnparsedAddress": "57 ERIE Boulevard, Long Point, Ontario N0E1M0" +"Coordinates": array:2 [ 0 => -80.4349375 1 => 42.5781568 ] +"Latitude": 42.5781568 +"Longitude": -80.4349375 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Live or vacation on the shores of Lake Erie. Waterfront home ready for you. Gorgeous panoramic views of the lake to take in year round. This home has three bedrooms with a fourth TV room outfitted with a futon that can be the fourth for overflow guests or a place to watch a movie while listening to the waves. Beautifully decorated inside with white wash pickled pine walls and ceilings. Originally pine floors have been lovingly restored to add to the beach chic of this property. No water bills with its own sand point well. Spacious and bright with lots of windows. Large size beachfront lot with extensive rock protection and room to park 8 cars. Lake side deck for the morning coffee. A simply beautiful place to retire to or make that decision to live at the lake. All plumbing and electrical are updated. New propane gas fireplace in a custom stone fireplace mantle. New cast iron propane fireplace in the Bunkie room. New ductless split heat pump providing heat and air-conditioning. Tons of up grades in this classic beach house named The Pickled Dune. Make your move to the beach! (id:62650)" +"Appliances": array:5 [ 0 => "Refrigerator" 1 => "Stove" 2 => "Microwave" 3 => "Hood Fan" 4 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"Cooling": array:1 [ 0 => "Ductless" ] +"CreationDate": "2026-01-06T20:52:52.752851+00:00" +"Directions": "Long Point Road turns into Erie Blvd beachfront side" +"ExteriorFeatures": array:1 [ 0 => "Wood" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Baseboard heaters" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1987928" +"ListOfficeKey": "291581" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-01-06T19:34:01Z" +"PhotosCount": 36 +"Sewer": array:1 [ 0 => "Holding Tank" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T15:17:35Z" +"Stories": "1.0" +"StreetName": "ERIE" +"StreetNumber": "57" +"StreetSuffix": "Boulevard" +"SubdivisionName": "Long Point" +"TaxAnnualAmount": "5996" +"View": "Lake view" +"WaterBodyName": "Lake Erie" +"WaterSource": array:1 [ 0 => "Well" ] +"Rooms": array:7 [ 0 => array:11 [ "RoomKey" => "1649656658" "RoomType" => "4pc Bathroom" "ListingId" => "40796472" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29221006" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T15:17:35.47Z" ] 1 => array:11 [ "RoomKey" => "1649656659" "RoomType" => "Kitchen/Dining room" "ListingId" => "40796472" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29221006" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T15:17:35.47Z" ] 2 => array:11 [ "RoomKey" => "1649656660" "RoomType" => "Great room" "ListingId" => "40796472" "RoomLevel" => "Main level" …7 ] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29221006/57-erie-boulevard-long-point" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"FrontageLengthNumeric": 66.0 +"AboveGradeFinishedArea": 1130 +"OriginalEntryTimestamp": "2026-01-06T19:34:01.55Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1272130" +"ListOfficeNationalAssociationId": "1400487" +"Media": array:36 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] ] +"DaysOnMarket": 164 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29221006')" +"ID": "1056526" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24573 +post_id: "1069734" +post_author: 1 +"ListingKey": "29239312" +"ListingId": "40796463" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-18T16:05:01Z" +"RFModificationTimestamp": "2026-06-18T16:26:02Z" +"ListPrice": 1269000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2325.0 +"BuildingAreaTotal": 0 +"City": "Port Dover" +"PostalCode": "N0A1N7" +"UnparsedAddress": "27 BRANT Avenue, Port Dover, Ontario N0A1N7" +"Coordinates": array:2 [ 0 => -80.1969613 1 => 42.783955 ] +"Latitude": 42.783955 +"Longitude": -80.1969613 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Set in a truly exceptional location, this property offers breathtaking, unobstructed views of Lake Erie, including the Port Dover Pier, lighthouse and lake. The 19-year-old log home blends traditional charm with comfortable living, showcasing warm wood interiors, quality craftsmanship, and a welcoming atmosphere that feels like a private retreat. A stunning two-storey great room anchors the home, complete with a gas fireplace and a dramatic wall of south-facing windows that flood the space with natural light and open to a covered outdoor living area. From here, enjoy sweeping views of Lake Erie, the harbour, pier, and lighthouse—an ideal setting for morning coffee, sunset dining, or watching the fishing tugs come and go. The second-storey loft offers flexible space for guests, a home office, or a quiet reading retreat with a gorgeous view of the marina. A main-floor primary bedroom with ensuite and main floor laundry provide everyday convenience, while the unfinished basement features high ceilings, seperate entrance and an open layout - excellent potential for future living space. Bonus attached cottage, circa 1920, adds additional space and character, featuring three bedrooms, a living room with fireplace, and a wrap-around sunroom overlooking the marina. Easy walk to downtown shops, restaurants, and live theatre. This is a rare opportunity to own a unique property offering timeless warmth, panoramic views, privacy, and versatile living in a premier location to enjoy 'one of the best waterviews in town'. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Gas stove(s)" 3 => "Dishwasher" 4 => "Dryer" 5 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-01-12T17:27:47.033140+00:00" +"ExteriorFeatures": array:2 [ 0 => "Log" 1 => "Other" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1908114" +"ListOfficeKey": "275393" +"LivingAreaUnits": "square feet" +"LotFeatures": array:7 [ 0 => "Cul-de-sac" 1 => "Southern exposure" 2 => "Corner Site" 3 => "Paved driveway" 4 => "Skylight" 5 => "Sump Pump" 6 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-15T16:31:34Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-18T15:55:32Z" +"Stories": "1.5" +"StreetName": "BRANT" +"StreetNumber": "27" +"StreetSuffix": "Avenue" +"SubdivisionName": "Port Dover" +"TaxAnnualAmount": "9238" +"View": "Lake view" +"WaterBodyName": "Lake Erie" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:14 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29239312/27-brant-avenue-port-dover" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2142304" +"CommonInterest": "Freehold" +"CoListOfficeKey": "275393" +"GeocodeManualYN": true +"ZoningDescription": "R1-A, HL" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"FrontageLengthNumeric": 283.0 +"AboveGradeFinishedArea": 2325 +"OriginalEntryTimestamp": "2026-01-12T13:48:38.81Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1221113" +"ListOfficeNationalAssociationId": "1264550" +"CoListAgentNationalAssociationId": "1393889" +"CoListOfficeNationalAssociationId": "1264550" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 158 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29239312')" +"ID": "1069734" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24464 +post_id: "1070880" +post_author: 1 +"ListingKey": "29239166" +"ListingId": "40796447" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T14:15:23Z" +"RFModificationTimestamp": "2026-06-08T14:21:21Z" +"ListPrice": 490000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1.0 +"LivingArea": 1750.0 +"BuildingAreaTotal": 0 +"City": "Simcoe" +"PostalCode": "N3Y4K1" +"UnparsedAddress": "740 HILLCREST Road, Simcoe, Ontario N3Y4K1" +"Coordinates": array:2 [ 0 => -80.310166 1 => 42.7955572 ] +"Latitude": 42.7955572 +"Longitude": -80.310166 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to the perfect blend of peaceful country living and everyday convenience. Set on a beautifully treed 1-acre lot, this inviting 3-bedroom bungalow offers the space, privacy, and lifestyle so many buyers are searching for—without sacrificing proximity to town amenities. From the moment you arrive you will appreciate the wide-open feel of the property. The bungalow features a practical, well-designed layout ideal for families, downsizers, or anyone looking for comfortable one-level living. The bright main living areas are filled with natural light, creating a warm and welcoming atmosphere that’s perfect for both everyday living and entertaining. Three well-sized bedrooms provide flexibility for family, guests, or a home office, while the functional floor plan offers excellent flow throughout the home. Step outside and discover the true highlight of this property. The expansive 1-acre lot provides endless opportunities—garden, play, relax, or simply enjoy the quiet country setting. A detached workshop adds incredible value, offering space for hobbies, storage, or a home-based business. Whether you’re a tradesperson, car enthusiast, or DIYer, this versatile space is sure to impress. Despite the tranquil setting, this property is conveniently located just minutes from schools, shopping, dining, and essential services, making daily errands quick and easy. Enjoy the freedom of country living with the comfort of knowing everything you need is close at hand. This property is ideal for buyers seeking space, privacy, and functionality in a sought-after location. A rare opportunity to enjoy the best of both worlds—don’t miss your chance to make this country retreat your next home. (id:62650)" +"Appliances": array:4 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-01-12T20:15:23.331156+00:00" +"Directions": "South on Hwy 24 to St Johns Road - go west to Hillcrest Rd." +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1396698" +"ListOfficeKey": "48558" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Corner Site" 1 => "Conservation/green belt" 2 => "Crushed stone driveway" 3 => "Country residential" 4 => "Private Yard" ] +"LotSizeDimensions": "1" +"ParkingFeatures": array:2 [ 0 => "Detached Garage" 1 => "Open" ] +"PhotosChangeTimestamp": "2026-05-15T03:22:42Z" +"PhotosCount": 16 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-08T14:04:02Z" +"Stories": "1.0" +"StreetName": "HILLCREST" +"StreetNumber": "740" +"StreetSuffix": "Road" +"SubdivisionName": "Town of Simcoe" +"TaxAnnualAmount": "2831" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Telephone" ] +"WaterSource": array:1 [ 0 => "Sand point" ] +"Rooms": array:8 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29239166/740-hillcrest-road-simcoe" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "AGR" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 165.0 +"AboveGradeFinishedArea": 1750 +"OriginalEntryTimestamp": "2026-01-12T12:49:25.75Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1069141" +"ListOfficeNationalAssociationId": "1004255" +"Media": array:16 [ 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] ] +"DaysOnMarket": 158 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29239166')" +"ID": "1070880" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24467 +post_id: "1101976" +post_author: 1 +"ListingKey": "29282811" +"ListingId": "40796399" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:56Z" +"RFModificationTimestamp": "2026-06-02T18:17:54Z" +"ListPrice": 1400000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 8.0 +"LotSizeArea": 0 +"LivingArea": 3762.0 +"BuildingAreaTotal": 0 +"City": "Aylmer" +"PostalCode": "N5H1P8" +"UnparsedAddress": "104 SOUTH Street, Aylmer, Ontario N5H1P8" +"Coordinates": array:2 [ 0 => -80.9764816 1 => 42.7701595 ] +"Latitude": 42.7701595 +"Longitude": -80.9764816 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "This property at 104 South Street, Aylmer offers a compelling multi-unit investment opportunity with flexible use options. Live in one unit and rent out the remaining units, or lease all units to maximize income potential. The layout and location support strong rental appeal, making this an excellent option for owner-occupiers, first-time investors, or experienced landlords. Located less than 20 minutes from St. Thomas, the property benefits from strong regional growth driven by major industrial and clean-technology investment, supporting increased employment and long-term housing demand in surrounding communities. This proximity enhances tenant demand while offering a more affordable entry point compared to larger urban centres. With its income potential, strategic location, and exposure to regional economic expansion, this property presents an attractive opportunity for investors seeking both stable cash flow and long-term appreciation. 104 South Street East provides two side by side duplex units, allowing for 4 separate living spaces. (id:62783)" +"Appliances": array:1 [ 0 => "Microwave" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-01-23T15:14:12.980553+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Baseboard heaters" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2242922" +"ListOfficeKey": "290392" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "4" +"PhotosChangeTimestamp": "2026-01-23T20:11:22Z" +"PhotosCount": 41 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:59:24Z" +"Stories": "1.0" +"StreetName": "SOUTH" +"StreetNumber": "104" +"StreetSuffix": "Street" +"SubdivisionName": "Aylmer" +"TaxAnnualAmount": "4890" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29282811/104-south-street-aylmer" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "Fourplex" ] +"CoListAgentKey": "2078917" +"CommonInterest": "Freehold" +"CoListOfficeKey": "294394" +"GeocodeManualYN": true +"ZoningDescription": "R2" +"FrontageLengthNumeric": 66.0 +"AboveGradeFinishedArea": 1886 +"BelowGradeFinishedArea": 1876 +"OriginalEntryTimestamp": "2026-01-23T14:19:11.05Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1481028" +"ListOfficeNationalAssociationId": "1386847" +"CoListAgentNationalAssociationId": "1353785" +"CoListOfficeNationalAssociationId": "1438749" +"Media": array:41 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] ] +"DaysOnMarket": 147 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29282811')" +"ID": "1101976" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24580 +post_id: "1059574" +post_author: 1 +"ListingKey": "29223690" +"ListingId": "40796378" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:50Z" +"RFModificationTimestamp": "2026-06-02T18:12:06Z" +"ListPrice": 595000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1880.0 +"BuildingAreaTotal": 0 +"City": "Dunnville" +"PostalCode": "N1A1N8" +"UnparsedAddress": "108 FOREST Street E, Dunnville, Ontario N1A1N8" +"Coordinates": array:2 [ 0 => -79.6162356 1 => 42.906779 ] +"Latitude": 42.906779 +"Longitude": -79.6162356 +"YearBuilt": 2011 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "All brick semi-detached one floor home with great location. Short walk to downtown, shopping, banking, and library. 2+ bedrooms, 2 baths with an open concept main floor kitchen and living room off living room patio door to patio and rear yard. Main floor laundry, covered front porch-garage with inside access. Lower level finished with rooms which could be used as bedrooms- 3 piece bath and large games room. Double wide concrete drive and central air compliment this home. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-01-07T17:22:54.127868+00:00" +"Directions": "Cedar Street to Forest-East on Forest Street" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525116" +"ListOfficeKey": "55124" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-01-07T14:41:20Z" +"PhotosCount": 38 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:59:25Z" +"Stories": "1.0" +"StreetDirSuffix": "East" +"StreetName": "FOREST" +"StreetNumber": "108" +"StreetSuffix": "Street" +"SubdivisionName": "061 - Dunnville Municipal" +"TaxAnnualAmount": "3088.48" +"Utilities": array:1 [ 0 => "Natural Gas" ] +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/358137" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29223690/108-forest-street-e-dunnville" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1949937" +"CommonInterest": "Freehold" +"CoListOfficeKey": "55124" +"GeocodeManualYN": true +"ZoningDescription": "D A4B" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 36.0 +"AboveGradeFinishedArea": 1080 +"BelowGradeFinishedArea": 800 +"OriginalEntryTimestamp": "2026-01-07T14:39:23.84Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1064317" +"ListOfficeNationalAssociationId": "1003486" +"CoListAgentNationalAssociationId": "1244225" +"CoListOfficeNationalAssociationId": "1003486" +"Media": array:38 [ 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] ] +"DaysOnMarket": 163 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29223690')" +"ID": "1059574" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24582 +post_id: "1059490" +post_author: 1 +"ListingKey": "29224838" +"ListingId": "40796304" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T17:35:07Z" +"RFModificationTimestamp": "2026-06-05T17:51:55Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1H4E9" +"UnparsedAddress": "117 WYNDHAM Street N, Guelph, Ontario N1H4E9" +"Coordinates": array:2 [ 0 => -80.2499564 1 => 43.5464427 ] +"Latitude": 43.5464427 +"Longitude": -80.2499564 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Turn your passion for animals into a thriving business opportunity with the sale of My Kitty Café - Ontario's first-ever cat café, ideally located in the heart of Downtown Guelph! This well-established, one-of-a-kind business combines a cozy café experience with a playful cat lounge, offering a welcoming environment for animal lovers and visitors from all over. With a loyal customer base, strong community support, and a successful track record of cat adoptions in partnership with local rescues, My Kitty Café is more than just a business - it's a destination. The café features a charming, themed interior, a fully built-out cat lounge with custom play structures and cozy seating areas, and an operational café space for serving beverages and snacks. The business includes all equipment, branding, website, social media presence, and goodwill - allowing for a seamless transition to new ownership. Profitable and turn-key, this is a rare opportunity to take over a well-loved business with a solid revenue stream, strong brand identity, and tremendous heart and purpose. Continue the legacy, grow the brand, and be part of something truly meaningful. (id:62783)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-01-07T19:20:04.125516+00:00" +"Directions": "Woolwich St and Wyndham St N" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2238484" +"ListOfficeKey": "292003" +"PhotosChangeTimestamp": "2026-01-07T17:33:54Z" +"PhotosCount": 25 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T17:24:40Z" +"StreetDirSuffix": "North" +"StreetName": "WYNDHAM" +"StreetNumber": "117" +"StreetSuffix": "Street" +"VirtualTourURLUnbranded": "https://youriguide.com/117_wyndham_st_n_guelph_on/" +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29224838/117-wyndham-street-n-guelph" +"GeocodeManualYN": true +"OriginalEntryTimestamp": "2026-01-07T17:33:54.4Z" +"ListAgentNationalAssociationId": "1476314" +"ListOfficeNationalAssociationId": "1407357" +"Media": array:25 [ 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] ] +"DaysOnMarket": 163 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29224838')" +"ID": "1059490" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010 +post_id: "1055333" +post_author: 1 +"ListingKey": "29219300" +"ListingId": "40796291" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-14T20:50:00Z" +"RFModificationTimestamp": "2026-06-14T20:52:15Z" +"ListPrice": 2299900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 5410.0 +"BuildingAreaTotal": 0 +"City": "Ancaster" +"PostalCode": "L9R4E9" +"UnparsedAddress": "712 HIGHVALLEY Road, Ancaster, Ontario L9R4E9" +"Coordinates": array:2 [ 0 => -79.9566486 1 => 43.2328394 ] +"Latitude": 43.2328394 +"Longitude": -79.9566486 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Unique, custom-built luxury home offering just over 5000 sq ft of Finished Living Space. Attention to detail & fine construction throughout, this home offers elegance, comfort, & functionality. Step into the grand sitting area, featuring soaring ceilings, stunning windows, & an impressive open staircase that connects all levels of the home. Sunken dining room boasts coffered gold leafing ceilings for refined entertaining. Custom Built Downsview kitchen offers abundant cabinetry, granite countertops, & top-of-the-line stainless steel appliances, including a Sub-Zero refrigerator, Wolf gas range, Gaggenau built-in oven, Miele dishwasher, & microwave storage. Relax or entertain in the expansive great room, featuring dramatic ceiling heights & a backlit onyx walls for your tv. An open-concept office with natural light, perfect workspace. Main-floor laundry room includes garage access. Upstairs, the spacious primary suite offers a large walk-in closet & a renovated 5-piece ensuite (2025). Two generous bedrooms share a beautifully appointed 4-piece bathroom, & a bright loft area overlooks both the front & rear of the home. The lower level features large windows & offers in-law suite potential with separate walk-ups to both the rear yard & garage. Cozy recreation room with fireplace, a fully equipped gym, a sauna for relaxation, 3 pc bath (2025), workshop, cold room, & plenty of storage space. The outdoor oasis includes a composite deck with built-in BBQ, hot tub, & an oversized waterfall feature with fireplace, artificial turf & a storage shed. Additional highlights include an oversized 2-car garage with abundant storage & a long interlock driveway accommodating up to 8 vehicles & irrigation system. Trillium award several years for landscaping. Ideally located near Tiffany Falls, Tamahaac Club, Highway 403, the Linc, Costco, schools, parks, & trails, luxury living with convenience & lifestyle. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Central Vacuum" 4 => "Gas stove(s)" 5 => "Wine Fridge" 6 => "Dryer" 7 => "Window Coverings" 8 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-01-06T17:23:51.706627+00:00" +"Directions": "MOHAWK RD TO FILMAN RD TO HIGHVALLEY RD" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Stucco" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1599523" +"ListOfficeKey": "54949" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Sump Pump" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-03-18T18:42:15Z" +"PhotosCount": 48 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-14T20:41:25Z" +"Stories": "2.0" +"StreetName": "HIGHVALLEY" +"StreetNumber": "712" +"StreetSuffix": "Road" +"SubdivisionName": "422 - Ancaster Heights/Mohawk Meadows/Maywood" +"TaxAnnualAmount": "12127" +"VirtualTourURLUnbranded": "https://viralrealestate.media/712-highvalley-rd" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:21 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29219300/712-highvalley-road-ancaster" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Alarm system" ] +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 3345 +"BelowGradeFinishedArea": 2065 +"OriginalEntryTimestamp": "2026-01-06T15:28:56.9Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1157654" +"ListOfficeNationalAssociationId": "1003557" +"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": 164 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29219300')" +"ID": "1055333" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24538 +post_id: "1066983" +post_author: 1 +"ListingKey": "29228918" +"ListingId": "40796256" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T15:30:50Z" +"RFModificationTimestamp": "2026-06-02T15:45:06Z" +"ListPrice": 999999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5.38 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Simcoe" +"PostalCode": "N3Y4K6" +"UnparsedAddress": "290 FOURTEENTH Street W, Simcoe, Ontario N3Y4K6" +"Coordinates": array:2 [ 0 => -80.3351254 1 => 42.8522363 ] +"Latitude": 42.8522363 +"Longitude": -80.3351254 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "BUILD TO SUIT or LAND FOR SALE. Advertised price is value of the land. Industrial build to suit on 5.38 acres with MG General Industrial zoning. Size from 5000-150,000sq ft. Price for building will vary based on clients needs. Suitable for warehouse, manufacturing, contractor yard or truck yard. Please see supplemental documents for complete list of permitted uses per Norfolk County Zoning By-Law. Inquire within today. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-01-08T16:46:07.904450+00:00" +"Directions": "North on Park Road, then left on Fourteenth St W" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2252468" +"ListOfficeKey": "92544" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"LotSizeDimensions": "5.38" +"PhotosChangeTimestamp": "2026-01-08T16:04:11Z" +"PhotosCount": 6 +"Sewer": array:1 [ 0 => "No sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T15:17:35Z" +"StreetDirSuffix": "West" +"StreetName": "FOURTEENTH" +"StreetNumber": "290" +"StreetSuffix": "Street" +"SubdivisionName": "Town of Simcoe" +"TaxAnnualAmount": "5500" +"VirtualTourURLUnbranded": "https://youtu.be/ZquKR8My_T0" +"WaterSource": array:1 [ 0 => "None" ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29228918/290-fourteenth-street-w-simcoe" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "MG" +"FrontageLengthNumeric": 0.0 +"OriginalEntryTimestamp": "2026-01-08T16:04:11Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1491436" +"ListOfficeNationalAssociationId": "1183612" +"Media": array:6 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] ] +"DaysOnMarket": 162 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29228918')" +"ID": "1066983" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24499 +post_id: "1087541" +post_author: 1 +"ListingKey": "29265353" +"ListingId": "40796237" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:54Z" +"RFModificationTimestamp": "2026-06-02T18:11:48Z" +"ListPrice": 2875000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.08 +"LivingArea": 6898.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8R2L2" +"UnparsedAddress": "237 JAMES Street N, Hamilton, Ontario L8R2L2" +"Coordinates": array:2 [ 0 => -79.8666559 1 => 43.2626888 ] +"Latitude": 43.2626888 +"Longitude": -79.8666559 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Strategically positioned on a through lot with exposure and access from both James Street North and Severn Street, offering two ground-floor commercial units and four residential units above.This diversified income profile may be suitable as a holding strategy for purchasers interested in properties within growing urban corridors. An abutting parcel located at 29 Severn Street is also available for purchase under separate ownership and representation (MLS#40797994). The availability of two side-by-side properties presents a rare opportunity. Acquiring adjacent parcels may increase total land area and frontage, consolidate lot lines, and provide optionality for improved access, servicing, circulation, parking, site layout, and massing. Paired with applicable zoning permissions, an assembly of this nature may unlock a unique potential development pathway that is independent of — and incremental to — the existing income-producing investment property. 29 Severn Street is a vacant parcel that previously had conceptual drawings prepared for a mixed-use building consisting of 1 commercial unit at grade and 6 residential units above under Permit No. BP-125643; the permit has since expired. The Seller of 29 Severn Street may have drawings or related materials available for purchaser's assistance. James Street North is a vibrant cultural and commercial district known for independent shops, restaurants, galleries, and Art Crawl events that draw strong local and regional foot traffic. The corridor has also benefited from sustained institutional and private investment, including the redevelopment of the TD Colosseum, which has emerged as a major economic contributor to Hamilton’s downtown by attracting international touring acts, large-scale events, and hundreds of thousands of new visitors and potential customers annually. Recent features include wiring upgrades, a Laars FT Series boiler/tankless system (2005). (id:62650)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2026-01-19T18:43:00.613571+00:00" +"Directions": "Located on the west side of James Street North between Mulberry and Colbourne Streets." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2197238" +"ListOfficeKey": "282362" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Visual exposure" ] +"LotSizeDimensions": "0.08" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-01-25T04:01:23Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:59:27Z" +"Stories": "3.0" +"StreetDirSuffix": "North" +"StreetName": "JAMES" +"StreetNumber": "237" +"StreetSuffix": "Street" +"SubdivisionName": "101 - Strathcona Central North" +"TaxAnnualAmount": "13817.28" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29265353/237-james-street-n-hamilton" +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "D2 - Downtown Mixed Use - Pedestrian Focus" +"FrontageLengthNumeric": 28.0 +"OriginalEntryTimestamp": "2026-01-19T16:38:55.25Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1445671" +"ListOfficeNationalAssociationId": "1320359" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 151 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29265353')" +"ID": "1087541" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24470 +post_id: "1069010" +post_author: 1 +"ListingKey": "29225312" +"ListingId": "40796236" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T00:00:43Z" +"RFModificationTimestamp": "2026-06-10T00:04:26Z" +"ListPrice": 2500000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2840.0 +"BuildingAreaTotal": 0 +"City": "Bayham" +"PostalCode": "N0J1H0" +"UnparsedAddress": "54428 TALBOT Line, Bayham, Ontario N0J1H0" +"Coordinates": array:2 [ 0 => -80.835091 1 => 42.7925527 ] +"Latitude": 42.7925527 +"Longitude": -80.835091 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Looking for a business opportunity ? Consider owning your own seasonal trailer park ! With 3 Bedroom Home with Double car Garage , This 18.3 -Acre property located in a beautiful rural area conveniently located between London and Hamilton has a great reputation for being a top destination for families looking for a fun and relaxation. The Property includes full time seasonal trailer sites with full hookups, 30 Amp electrical service and 15 Amp to a few weekend site, with weekend sites and possible potential for more seasonal sites, a fully-stocked convenience store/office & Recreation Hall , washrooms and laundry facilities . Park members and visitors can enjoy the large 30 x 60 swimming pool and the peaceful forest setting, outdoor activities , and the close proximity to nearby towns of Aylmer or Tillsonburg. As an owner, you will have opportunity to generate income from site rentals etc, all while living in the home that is situated on the property, with the ability to expand and grow the business as you see fit. Don't miss out on this exciting opportunity to own a successful seasonal trailer park business ! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Gas stove(s)" 3 => "Dishwasher" 4 => "Dryer" 5 => "Freezer" 6 => "Window Coverings" 7 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-01-07T18:49:36.146809+00:00" +"Directions": "From Alymer head east on Talbot line to 54428 , or if coming from Tillsonburg head west on Talbot line" +"ExteriorFeatures": array:2 [ 0 => "Shingles" 1 => "Brick Veneer" ] +"Heating": array:2 [ 0 => "Stove" 1 => "Propane" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2085979" +"ListOfficeKey": "299468" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Visual exposure" 1 => "Crushed stone driveway" 2 => "Country residential" ] +"NumberOfUnitsTotal": "3" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-01-27T05:22:08Z" +"PhotosCount": 43 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:53:34Z" +"Stories": "2.0" +"StreetName": "TALBOT" +"StreetNumber": "54428" +"StreetSuffix": "Line" +"SubdivisionName": "Eden" +"TaxAnnualAmount": "9603" +"Utilities": array:1 [ 0 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Well" ] +"Rooms": array:14 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29225312/54428-talbot-line-bayham" +"ParkingTotal": 20 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "OS2-7" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 1652.0 +"AboveGradeFinishedArea": 1876 +"BelowGradeFinishedArea": 964 +"OriginalEntryTimestamp": "2026-01-07T18:19:26.83Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1359351" +"ListOfficeNationalAssociationId": "1473084" +"Media": array:43 [ 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] ] +"DaysOnMarket": 163 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29225312')" +"ID": "1069010" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24513 +post_id: "1115653" +post_author: 1 +"ListingKey": "29225313" +"ListingId": "40796234" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:50Z" +"RFModificationTimestamp": "2026-06-02T18:12:08Z" +"ListPrice": 2500000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 2435.0 +"BuildingAreaTotal": 0 +"City": "Bayham" +"PostalCode": "N0J1H0" +"UnparsedAddress": "54428 TALBOT Line, Bayham, Ontario N0J1H0" +"Coordinates": array:2 [ 0 => -80.835091 1 => 42.7925527 ] +"Latitude": 42.7925527 +"Longitude": -80.835091 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Looking for a business opportunity ? Consider owning your own seasonal trailer park ! With 3 Bedroom Home with Double car Garage , This 18.3 -Acre property located in a beautiful rural area conveniently located between London and Hamilton has a great reputation for being a top destination for families looking for a fun and relaxation. The Property includes full time seasonal trailer sites with full hookups, 30 Amp electrical service and 15 Amp to a few weekend site, with weekend sites and possible potential for more seasonal sites, a fully-stocked convenience store/office & Recreation Hall , washrooms and laundry facilities . Park members and visitors can enjoy the large 30 x 60 swimming pool and the peaceful forest setting, outdoor activities , and the close proximity to nearby towns of Aylmer or Tillsonburg. As an owner, you will have opportunity to generate income from site rentals etc, all while living in the home that is situated on the property, with the ability to expand and grow the business as you see fit. Don't miss out on this exciting opportunity to own a successful seasonal trailer park business ! (id:62650)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2026-01-07T18:49:55.401754+00:00" +"Directions": "From Alymer head east on Talbot line to 54428 , or if coming from Tillsonburg head west on Talbot line" +"ExteriorFeatures": array:2 [ 0 => "Shingles" 1 => "Brick Veneer" ] +"Fencing": array:1 [ 0 => "Fenced yard" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2085979" +"ListOfficeKey": "299468" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Visual exposure" 1 => "Crushed stone driveway" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-01-27T05:22:10Z" +"PhotosCount": 41 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:59:28Z" +"Stories": "2.0" +"StreetName": "TALBOT" +"StreetNumber": "54428" +"StreetSuffix": "Line" +"SubdivisionName": "Eden" +"TaxAnnualAmount": "9603" +"Utilities": array:1 [ 0 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Well" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29225313/54428-talbot-line-bayham" +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "OS2-7" +"FrontageLengthNumeric": 1652.0 +"OriginalEntryTimestamp": "2026-01-07T18:19:27.02Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1359351" +"ListOfficeNationalAssociationId": "1473084" +"Media": array:41 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] ] +"DaysOnMarket": 163 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29225313')" +"ID": "1115653" } ] +success: true +page_size: 12 +page_count: 17241 +count: 206884 +after_key: "" } "RF Response Time" => "0.2 seconds" ] ]