302 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: af46d9e699336d507f90ec29e19a8e0fe68d28f21a29dbc6e65339465e28266f" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13020 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13206 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12092223" +"ListingId": "X12092223" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-19T16:30:00Z" +"RFModificationTimestamp": "2025-04-19T17:00:38.379443+00:00" +"ListPrice": 739900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 0C2" +"UnparsedAddress": "33 Sumac Drive, Haldimand, On N3w 0c2" +"Coordinates": array:2 [ 0 => -79.9342946 1 => 43.0728827 ] +"Latitude": 43.0728827 +"Longitude": -79.9342946 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Caledonia's Stunning Move-In Ready 3-Bedroom, 3 Bathrooms, Detached Home - Upgraded & Ready for You! Step into modern elegance with this beautifully upgraded 2-storey detached home, perfectly nestled in the heart of Caledonia! Built just 6.5 years ago by Empire Communities, this charming residence offers the perfect blend of style, comfort, and functionality ideal for families, first-time buyers, and smart investors alike.Spacious Design: Fantastic curb appeal and an inviting presence. 1.3 Generously Sized Bedrooms: Comfortably designed to meet all your family's needs. 2.5 Pristine Bathrooms. Single-Car Garage + Extended Driveway (No Sidewalk!): Park up to 3 vehicles with ease (tandem driveway plus garage). Upgraded Kitchen with Stainless Steel Appliances: Featuring a NEW stove and NEW dishwasher for your culinary adventures. Freshly Upgraded Flooring: Stylish and contemporary flooring throughout the main living areas (Carpet-Free Home). Freshly Painted: A clean, neutral palette sets the perfect backdrop for your personal style. 1.Bright, Airy Open-Concept Layout- Seamless flow between living, dining, and kitchen spaces ideal for everyday living and entertaining. Unfinished Basement with Partially Finished Area: Incredible potential to customize create a rec room, office, home gym, or an additional bedroom. New Smoke Alarms Installed: Enhanced safety features for your peace of mind. Why You'll Love It: This home truly checks all the boxes a perfect move-in ready option in a thriving, family-friendly community. Whether you're looking to upsize, downsize, or invest, you'll appreciate the thoughtful upgrades and prime location!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Full" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-19T16:39:18.763948+00:00" +"CrossStreet": "Mcclung Rd & Thompson Rd" +"DirectionFaces": "West" +"Directions": "Mcclung Rd & Thompson Rd" +"ExpirationDate": "2025-08-31" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"InteriorFeatures": array:7 [ 0 => "Rough-In Bath" 1 => "Separate Hydro Meter" 2 => "Carpet Free" 3 => "ERV/HRV" 4 => "Sump Pump" 5 => "Water Heater" 6 => "Water Meter" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-18" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-04-19T16:29:59Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-04-19T16:29:59Z" +"OriginalListPrice": 739900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2260126" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-19T16:30:00Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sumac" +"StreetNumber": "33" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4587.23" +"TaxLegalDescription": "LOT 60, PLAN 18M52 SUBJECT TO AN EASEMENT FOR ENTRY AS IN CH85927 HALDIMAND COUNTY" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + $ 3000 Bonus if Sold Firm b4 May 05, 25" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/mnkxvjz/unbranded" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 91.82 +"LotWidth": 26.89 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12092223')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"RentalItems": "HWT & ERV/HRV" +"HoldoverDays": 30 +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Haldimand, ON N3W 0C2, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"PossessionDetails": "20/30/45/Flex" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-04-19T16:30:00Z" +"SystemModificationTimestamp": "2025-04-19T16:30:07.716001Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:28 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "ab59dc65-4298-4f66-9292-d89e04d41dcf" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/9a53e3a0189ea669688b9a1b7114d5e2.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 468251 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-9a53e3a0189ea669688b9a1b7114d5e2.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ab59dc65-4298-4f66-9292-d89e04d41dcf" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ab59dc65-4298-4f66-9292-d89e04d41dcf" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "829831ab-5b80-453a-aa82-1051c0aeee76" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/3b817e9c2dcfac10205942fc694d05ee.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 500552 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-3b817e9c2dcfac10205942fc694d05ee.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1366 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "829831ab-5b80-453a-aa82-1051c0aeee76" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "829831ab-5b80-453a-aa82-1051c0aeee76" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "801c1b0f-565d-488d-b3f1-0e507e3dc17d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/5a40d266f02e2130789ae5c9c6a05b85.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 506041 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-5a40d266f02e2130789ae5c9c6a05b85.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "801c1b0f-565d-488d-b3f1-0e507e3dc17d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "801c1b0f-565d-488d-b3f1-0e507e3dc17d" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "f9da8613-b4cc-4fe4-a375-4a3598a0c739" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/88582758b92402e12cf15910821aff55.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 392082 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-88582758b92402e12cf15910821aff55.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "f9da8613-b4cc-4fe4-a375-4a3598a0c739" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "f9da8613-b4cc-4fe4-a375-4a3598a0c739" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "dd7ec008-e0ca-4fec-9912-422afc676a6f" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/55286def7b90ff58f1d4bcbcea842c16.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 239566 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-55286def7b90ff58f1d4bcbcea842c16.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1364 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "dd7ec008-e0ca-4fec-9912-422afc676a6f" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "dd7ec008-e0ca-4fec-9912-422afc676a6f" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "fb5d1c45-ae64-4efe-a581-943834d7f771" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/3fefb43088173a7fea3998e38d1920e1.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 274727 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-3fefb43088173a7fea3998e38d1920e1.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fb5d1c45-ae64-4efe-a581-943834d7f771" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fb5d1c45-ae64-4efe-a581-943834d7f771" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "fe0a5fa5-e274-40e8-afde-706fce6c2b1f" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/7014519f25a8211027e96cc57ba5def9.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 294654 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-7014519f25a8211027e96cc57ba5def9.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fe0a5fa5-e274-40e8-afde-706fce6c2b1f" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fe0a5fa5-e274-40e8-afde-706fce6c2b1f" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "b3b80829-2080-4383-9999-2c6aef3e026d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/f23983efaea839d23875c12d723cc3fc.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 284056 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-f23983efaea839d23875c12d723cc3fc.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1364 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b3b80829-2080-4383-9999-2c6aef3e026d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b3b80829-2080-4383-9999-2c6aef3e026d" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "b9663fe3-e521-4d7d-b465-7e148446d40e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/20f1b3989c9a4064ede1a2c7ad949f46.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 337527 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-20f1b3989c9a4064ede1a2c7ad949f46.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b9663fe3-e521-4d7d-b465-7e148446d40e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b9663fe3-e521-4d7d-b465-7e148446d40e" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "81a34219-506b-414c-acf7-56605cd68645" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/65f7508592f32154a7bf83233ce01236.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 249496 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-65f7508592f32154a7bf83233ce01236.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "81a34219-506b-414c-acf7-56605cd68645" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "81a34219-506b-414c-acf7-56605cd68645" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "6f0d2420-aba3-470b-92c9-9585e8c01b18" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/dcd0ccc4ce8dc8df2bcc92474e5988f4.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 265108 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-dcd0ccc4ce8dc8df2bcc92474e5988f4.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1366 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6f0d2420-aba3-470b-92c9-9585e8c01b18" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6f0d2420-aba3-470b-92c9-9585e8c01b18" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "88ab3d00-e803-44c4-9671-743c2f74c4ad" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/924f30071eadcf4508fadc53fe0340fe.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 206060 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-924f30071eadcf4508fadc53fe0340fe.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "88ab3d00-e803-44c4-9671-743c2f74c4ad" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "88ab3d00-e803-44c4-9671-743c2f74c4ad" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "deec251b-11e5-4a57-9c1d-7156fd455073" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/d399ca3bdc4049d3367bcf4c09d7d4f9.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 261880 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-d399ca3bdc4049d3367bcf4c09d7d4f9.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1364 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "deec251b-11e5-4a57-9c1d-7156fd455073" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "deec251b-11e5-4a57-9c1d-7156fd455073" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "0523f674-6272-4d13-9ff7-10cf9e06b360" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/12278af7824a3763c884a1a7474f84ac.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 274640 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-12278af7824a3763c884a1a7474f84ac.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1366 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "0523f674-6272-4d13-9ff7-10cf9e06b360" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "0523f674-6272-4d13-9ff7-10cf9e06b360" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "28aa6e47-6e79-45ce-a916-325fbddce793" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/88d0619f739cd61f4c58f757cde3fb9d.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 246708 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-88d0619f739cd61f4c58f757cde3fb9d.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "28aa6e47-6e79-45ce-a916-325fbddce793" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "28aa6e47-6e79-45ce-a916-325fbddce793" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "fd6459c3-24ab-4c5a-9ae5-1ce6d04afa3a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/a4608a9d37ed72cbe8cee5e219dcc256.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 132184 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-a4608a9d37ed72cbe8cee5e219dcc256.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fd6459c3-24ab-4c5a-9ae5-1ce6d04afa3a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fd6459c3-24ab-4c5a-9ae5-1ce6d04afa3a" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "27077cf1-3dbc-4406-b772-76730140fc33" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/418822adf58087d2c45ed07f837e3738.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 265993 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-418822adf58087d2c45ed07f837e3738.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1361 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "27077cf1-3dbc-4406-b772-76730140fc33" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "27077cf1-3dbc-4406-b772-76730140fc33" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 17 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "f4aabb0d-c22e-40e9-b629-6aff34093a6d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/1e85b2370fde1ed510c9debaa0265938.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 278954 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-1e85b2370fde1ed510c9debaa0265938.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "f4aabb0d-c22e-40e9-b629-6aff34093a6d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "f4aabb0d-c22e-40e9-b629-6aff34093a6d" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 18 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "32950d1e-261c-4975-8310-2be05e70ed96" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/111b496901ffb1135149573636450f99.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 257599 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-111b496901ffb1135149573636450f99.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "32950d1e-261c-4975-8310-2be05e70ed96" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "32950d1e-261c-4975-8310-2be05e70ed96" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 19 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "119f51ff-54b5-492b-b42e-e7a1ff112fe8" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/817f37935d4941a5fef2704fb651039e.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 164765 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-817f37935d4941a5fef2704fb651039e.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "119f51ff-54b5-492b-b42e-e7a1ff112fe8" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "119f51ff-54b5-492b-b42e-e7a1ff112fe8" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 20 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "a19c53fc-7f68-4e2b-bf54-4498c7bed575" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/2648ab1d1a00890c0fbda9910b075cb3.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 143289 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-2648ab1d1a00890c0fbda9910b075cb3.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "a19c53fc-7f68-4e2b-bf54-4498c7bed575" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "a19c53fc-7f68-4e2b-bf54-4498c7bed575" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 21 => array:26 [ "Order" => 21 "ImageOf" => null "MediaKey" => "fa4b7d78-fa8f-419e-988d-892bbe16d6db" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/969b1a2d2d6076d9b3206341cd0fb796.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 135915 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-969b1a2d2d6076d9b3206341cd0fb796.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fa4b7d78-fa8f-419e-988d-892bbe16d6db" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12092223" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fa4b7d78-fa8f-419e-988d-892bbe16d6db" "ModificationTimestamp" => "2025-04-19T16:30:00.027769Z" "MediaModificationTimestamp" => "2025-04-19T16:30:00.027769Z" ] 22 => array:26 [ "Order" => 22 "ImageOf" => null "MediaKey" => "840453fb-6f8f-4298-a54e-cb1237bf0b1d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/ffac629275a553809e4920db6540252b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 268713 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X12092223/thumbnail-ffac629275a553809e4920db6540252b.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1366 "MediaStatus" => "Active" …13 ] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13207 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12091739" +"ListingId": "X12091739" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-18T22:38:28Z" +"RFModificationTimestamp": "2025-04-19T00:58:12.633298+00:00" +"ListPrice": 975000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 7293.0 +"City": "Haldimand" +"PostalCode": "N1A 1S6" +"UnparsedAddress": "111 Broad Street, Haldimand, On N1a 1s6" +"Coordinates": array:2 [ 0 => -79.6187419 1 => 42.9041924 ] +"Latitude": 42.9041924 +"Longitude": -79.6187419 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Former municipal building. New flat roof 2025. Building offers main reception area, includes safe, open staircase, terrazzo flooring, brick and field stone feature walls. Upper level has 5 offices, board room, event room, waiting area and storage. Lower level has 5 offices, board room/mixed use space and several storage spaces. 5 washrooms and parking for 10 cars, wheelchair accessible with automatic doors, and elevator/lift system. Natural gas forced air heat and central air. Zoned Commercial Downtown. Square footage of 7,293 reflects total of upper, main and lower floors. Fire protection is Fire Extinguishers located throughout the building. Property has been severed. Sketch attached. 10 parking spaces against building and behind remain with the building. Legal description may change. Property taxes TBD" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Dunnville" +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Haldimand" +"CreationDate": "2025-04-19T00:18:30.982832+00:00" +"CrossStreet": "Cedar St" +"Directions": "At intersection Cedar St and Broad St" +"ExpirationDate": "2025-07-25" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-18" +"LotSizeDimensions": "200.00 x 85.32" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-04-18T22:37:36Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-04-18T22:37:36Z" +"OriginalListPrice": 975000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2259380" +"ParcelNumber": "00000" +"PhotosChangeTimestamp": "2025-04-18T22:37:37Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": array:1 [ 0 => "Sanitary" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Broad" +"StreetNumber": "111" +"StreetSuffix": "Street" +"TaxAnnualAmount": "1.0" +"TaxBookNumber": "281002400204500" +"TaxLegalDescription": "PT LT 10 N/S BROAD ST W, 11 N/S BROAD ST W, 12 N/S BROAD ST W PL 69 PT 2 TO 4 & 6 18R1687 & AS IN HC137471 EXCEPT PT 5 18R1687; S/T HC137473; HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% of purchase price plus HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "CD" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 85.99 +"LotShape": "Rectangular" +"LotWidth": 110.24 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12091739')" +"GarageType": "None" +"RollNumber": "0" +"PropertyUse": "Office" +"ElevatorType": "Freight" +"HoldoverDays": 60 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 10 +"provider_name": "TRREB" +"short_address": "Haldimand, ON N1A 1S6, CA" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 5 +"PossessionDetails": "Flexible" +"SurveyAvailableYN": true +"OfficeApartmentArea": 7293.0 +"ShowingAppointments": "Book through Broker Bay" +"MediaChangeTimestamp": "2025-04-18T22:37:37Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-04-18T22:38:28.499352Z" +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13213 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12091506" +"ListingId": "X12091506" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-18T18:19:33Z" +"RFModificationTimestamp": "2025-04-19T02:49:41.836763+00:00" +"ListPrice": 998000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 0H1" +"UnparsedAddress": "88 Sundin Drive, Haldimand, On N3w 0h1" +"Coordinates": array:2 [ 0 => -79.9261923 1 => 43.0655857 ] +"Latitude": 43.0655857 +"Longitude": -79.9261923 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX COMMUNITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This One Is Not To Be Missed! Amazing Opportunity To Own A 2 Storey 4 Bed 4 Bath Detached Home In Caledonia. Built By Award Winning Builder Empire! Home Boasts Hardwood Flooring Throughout Main Floor And Large Windows For Lots Of Natural Lights. Open Concept Bright Kitchen Combined Breakfast Area With Sound System. Sizable Dinning Room. Fireplace On Main Floor. Primary Bedroom Comes With 4Pc Bath And Large Walk-In Closet. 2nd And 3rd Beds With Jack And Jill Ensuite. Another Additional Spacious Bedroom With 3-Piece Bath. All New Stainless-Steel Appliances. Laundry Is Conveniently Located On 2nd Floor. Access To The Garage From Inside. Close To Schools, Shopping, Restaurants And More." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AttachedGarageYN": true +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Haldimand" +"CoveredSpaces": "2.0" +"CreationDate": "2025-04-19T02:40:39.681805+00:00" +"CrossStreet": "Mcclung Rd & Hwy 54" +"DirectionFaces": "South" +"Directions": "Continue to follow Haldimand County Hwy 54, Turn left onto Sundin Dr, The property will be on your right" +"Exclusions": "Tenant's belongings" +"ExpirationDate": "2025-10-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"HeatingYN": true +"Inclusions": "S/S Refrigerator, S/S Stove, S/S Dishwasher, Washer & Dryer, Cascade Blinds, Entertainment System In The Breakfast Area, Central Vacuum, Garage Door Opener, Elfs." +"InteriorFeatures": array:2 [ 0 => "Central Vacuum" 1 => "Auto Garage Door Remote" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-18" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "38.16 x 92.04 Feet" +"MainOfficeKey": "208100" +"MajorChangeTimestamp": "2025-04-18T18:19:33Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-04-18T18:19:33Z" +"OriginalListPrice": 998000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2258808" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-04-18T18:19:33Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "8" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Go Direct" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sundin" +"StreetNumber": "88" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4234.37" +"TaxBookNumber": "281015200316878" +"TaxLegalDescription": "Lot 68, Plan 18M65;Haldimand County" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 92.04 +"LotWidth": 38.16 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12091506')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "281015200316878" +"SurveyType": "Unknown" +"ElectricYNA": "Available" +"RentalItems": "Hwt Rental $35.46+Tax Alarm System $38+Tax" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Haldimand, ON N3W 0H1, CA" +"ApproximateAge": "New" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 8 +"StreetSuffixCode": "Dr" +"BoardPropertyType": "Free" +"PossessionDetails": "60 days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2025-04-18T18:19:33Z" +"MLSAreaDistrictOldZone": "X06" +"MLSAreaMunicipalityDistrict": "Haldimand" +"SystemModificationTimestamp": "2025-04-18T18:19:34.283147Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:27 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12066735" +"ListingId": "X12066735" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-18T00:07:03Z" +"RFModificationTimestamp": "2025-04-18T00:52:25.661505+00:00" +"ListPrice": 779900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 2G9" +"UnparsedAddress": "17 Kelso Drive, Haldimand, On N3w 2g9" +"Coordinates": array:2 [ 0 => -79.929622286907 1 => 43.070481427859 ] +"Latitude": 43.070481427859 +"Longitude": -79.929622286907 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step into luxury and sophistication with this stunning executive home in Caledonia's sought-after Avalon community. Offering 1,885 sq. ft. of beautifully designed living space, this 4-bedroom, 2.5-bath home is perfect for modern family living. Start your mornings with coffee on the charming covered porch, then step through the grand double doors into a warm and welcoming foyer. The upgraded open-concept kitchen features a spacious island, seamlessly flowing into the bright living room with a walkout to the backyard perfect for entertaining or relaxing. Soaring 9-foot ceilings on the main floor create an airy, inviting atmosphere. Upstairs, the sun-drenched primary suite easily accommodates a king-sized bed and boasts a walk-in closet plus a spa-like 4-piece ensuite. Three additional generously sized bedrooms provide plenty of space for family, guests, or a home office, while the second-floor laundry adds convenience to everyday living. With interior garage access and parking for three vehicles, this home blends elegance and practicality. Nestled in a family-friendly community, you're just minutes from parks, top-rated schools, shopping, and scenic trails along the Grand River." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-14T06:41:42.646410+00:00" +"CrossStreet": "ARNOLD MARSHALL BLVD" +"DirectionFaces": "East" +"Directions": "ARNOLD MARSHALL BLVD" +"ExpirationDate": "2025-07-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-02" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-04-18T00:07:03Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-04-07T17:16:01Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2202558" +"ParcelNumber": "381550399" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-04-11T18:22:40Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 799900.0 +"PriceChangeTimestamp": "2025-04-18T00:07:03Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Kelso" +"StreetNumber": "17" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5628.56" +"TaxLegalDescription": "LOT 175, PLAN 18M49 SUBJECT TO AN EASEMENT FOR ENTRY AS IN CH79491 HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 92.09 +"LotShape": "Rectangular" +"LotWidth": 34.06 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12066735')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "281015200508849" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Tank-Gas" ] +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-04-11T18:22:40Z" +"SystemModificationTimestamp": "2025-04-18T00:07:05.171471Z" +"Media": array:17 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13205 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12090290" +"ListingId": "X12090290" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T22:54:07Z" +"RFModificationTimestamp": "2025-04-18T01:05:45.741777+00:00" +"ListPrice": 819900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 12087.66 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N0A 1E0" +"UnparsedAddress": "44 Ottawa Street, Haldimand, On N0a 1e0" +"Coordinates": array:2 [ 0 => -79.8549941 1 => 42.9460496 ] +"Latitude": 42.9460496 +"Longitude": -79.8549941 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This is not a cookie cutter home! Immaculate two storey home with unique mansard style roof on a quiet street in the mature area of Cayuga, friendly town with lots of amenities located about 30 mins from Hamilton/403. The current owners have taken such care in maintaining this 4+1 bedroom 1 and a half bath home. Main level features gorgeous custom kitchen with white cabinetry, island/breakfast nook, stainless steel applinces & more. Massive dining room holds an impressive harvest table with ease, cozy living room with n/gas fireplace, plus main floor bedroom/den/office, two piece powder room - gleaming ash hardwood floor through out the main level with a natural finish. Upstairs offers tons of space, newer flooring throughout and includes a large primary bedroom with walk in closet, 3 additional good size bedrooms and a 5 pc bath. Recently finished lower level offers high ceilings, laminate flooring through out, and pot lighting. Good sized family room, gym room, office, and laundry/storage room. Large two car garage with bonus storage area above for the car enthusiast. Large fully fenced backyard includes two tiered deck system with hot tub, plus handy garden shed. Lots of room to park on the driveway. Windows all updated since 2007, furnace is 2010, central air is 2021, and water tank is 2013. Roof shingles replaced in 2008." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CoveredSpaces": "2.0" +"CreationDate": "2025-04-17T21:03:55.010913+00:00" +"CrossStreet": "Chippewa St / Barton St" +"DirectionFaces": "East" +"Directions": "Chippewa St / Barton St" +"Exclusions": "CHANDELIER IN THE DINING ROOM" +"ExpirationDate": "2025-07-16" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Hot Tub" 2 => "Patio" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Hot Tub, Hot Tub Equipment, Hot Water Tank Owned, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Auto Garage Door Remote" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-16" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-04-17T20:53:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-04-17T20:53:53Z" +"OriginalListPrice": 819900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2256656" +"ParcelNumber": "382270106" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-04-17T22:54:07Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Ottawa" +"StreetNumber": "44" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4800.0" +"TaxLegalDescription": "PT LT 10 S/S CHIPPEWA ST VILLAGE OF CAYUGA E OF GRAND RIVER; PT LT 11 S/S CHIPPEWA ST VILLAGE OF CAYUGA E OF GRAND RIVER PT 1, 18R1062; HALDIMAND COUNTY" +"TaxYear": "2024" +"Topography": array:1 [ 0 => "Level" ] +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/355309" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 165.0 +"LotShape": "Irregular" +"LotWidth": 74.47 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12090290')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "281015600010235" +"SurveyType": "Unknown" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "None." +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"MortgageComment": "Treat as Clear" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 5 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Level" 2 => "Library" 3 => "Park" 4 => "Place Of Worship" 5 => "River/Stream" ] +"LotIrregularities": "168.64 x 72.26 x 168.77 x 71.11ft" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "90+ Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-04-17T22:54:07Z" +"SystemModificationTimestamp": "2025-04-17T22:54:10.648708Z" +"Media": array:47 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13184 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12090181" +"ListingId": "X12090181" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T21:41:23Z" +"RFModificationTimestamp": "2025-04-18T01:58:25.290375+00:00" +"ListPrice": 1749900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1.79 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N0A 1K0" +"UnparsedAddress": "2811 North Shore Drive, Haldimand, On N0a 1k0" +"Coordinates": array:2 [ 0 => -79.4511309 1 => 42.875338 ] +"Latitude": 42.875338 +"Longitude": -79.4511309 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Once in a lifetime opportunity to own a stunning 1.79 acre hobby farm with 102 feet of frontage on Lake Erie including concrete stairs leading to your own private sand/pebble beach. As you pull into the circular driveway at 2811 North Shore Drive you will be welcomed by mature maple trees lining the driveway. Imagine waking up and enjoying your morning coffee with views of the water from your custom built 3 bedroom home. Heading inside, youll find an eat-in kitchen, dining/living room, large primary bedroom with his/her closets and 2-piece ensuite, two additional large bedrooms and main 4-piece bathroom with jacuzzi tub. The finished lower level features a kitchen with island, den and adjoining family room with gas fireplace, wet sauna, as well as a 4-season sunroom making this an incredible opportunity for multi-generational living. At the rear of the property is a custom-built 36' x 24' hobby barn, constructed in 2015, featuring durable Hardie board exterior with a 50-year metal roof. The vaulted upper level includes six dormers and sliding door access. An attached 20' x 18' workshop adds versatile storage or project space. Outside, the property boasts four custom horse paddocks, mature maples and evergreens offering shade and charm. Embrace the epitome of country living - from breathtaking lakefront views and beachfront ownership to a hobby barn, workshop, paddocks and custom built home - all in a beautiful setting like none other" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Dunnville" +"CoListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"CoListOfficePhone": "905-573-1188" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-17T22:34:00.205459+00:00" +"CrossStreet": "Hutchinson Road" +"DirectionFaces": "North" +"Directions": "Hutchinson Road to North Shore Drive" +"Disclosures": array:2 [ 0 => "Conservation Regulations" 1 => "Environmentally Protected" ] +"Exclusions": "Anchor at the waterfront" +"ExpirationDate": "2025-07-17" +"ExteriorFeatures": array:5 [ 0 => "Fishing" 1 => "Hot Tub" 2 => "Landscaped" 3 => "Patio" 4 => "Privacy" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, stove, dishwasher, washer, dryer, hot tub, basement fridge and dishwasher, light fixtures and ceiling fans." +"InteriorFeatures": array:8 [ 0 => "Auto Garage Door Remote" 1 => "Guest Accommodations" 2 => "In-Law Suite" 3 => "On Demand Water Heater" 4 => "Sauna" 5 => "Separate Heating Controls" 6 => "Sump Pump" 7 => "Water Heater Owned" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-17" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-04-17T20:26:09Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-04-17T20:26:09Z" +"OriginalListPrice": 1749900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2255680" +"OtherStructures": array:5 [ 0 => "Barn" 1 => "Fence - Partial" 2 => "Sauna" 3 => "Shed" 4 => "Workshop" ] +"ParcelNumber": "381000415" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "13.0" +"PhotosChangeTimestamp": "2025-04-17T20:26:09Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detectors" 1 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "North Shore" +"StreetNumber": "2811" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5162.27" +"TaxLegalDescription": "PT LT 4 FIRST CON FROM LAKE ERIE MOULTON PT 1 18R1648 AND PT 1 18R6855; T/W HC174884; HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1.75% + HST" +"TransactionType": "For Sale" +"View": array:4 [ 0 => "Beach" 1 => "Forest" 2 => "Pond" 3 => "Water" ] +"VirtualTourURLUnbranded": "https://book.allisonmediaco.com/sites/velnaox/unbranded" +"WaterBodyName": "Lake Erie" +"WaterfrontFeatures": array:1 [ 0 => "Stairs to Waterfront" ] +"WaterfrontYN": true +"Zoning": "RH, A" +"UFFI": "No" +"DDFYN": true +"Water": "Other" +"HeatType": "Forced Air" +"LotDepth": 623.01 +"LotShape": "Irregular" +"LotWidth": 102.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12090181')" +"Shoreline": array:2 [ 0 => "Rocky" 1 => "Sandy" ] +"WaterView": array:1 [ 0 => "Unobstructive" ] +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "281002300316300" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "Direct" ] +"DockingType": array:1 [ 0 => "None" ] +"RentalItems": "None" +"HoldoverDays": 45 +"KitchensTotal": 2 +"ParkingSpaces": 12 +"UnderContract": array:1 [ 0 => "None" ] +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Haldimand, ON N0A 1K0, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 5 +"WaterFrontageFt": "102" +"AccessToProperty": array:2 [ 0 => "Municipal Road" 1 => "Public Road" ] +"AlternativePower": array:1 [ 0 => "Unknown" ] +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Campground" 2 => "Golf" 3 => "Library" 4 => "Marina" 5 => "Park" ] +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "-" +"ShorelineExposure": "South" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WaterfrontAccessory": array:1 [ 0 => "Not Applicable" ] +"MediaChangeTimestamp": "2025-04-17T20:26:09Z" +"SystemModificationTimestamp": "2025-04-17T21:41:24.932529Z" +"Media": array:37 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13183 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11984104" +"ListingId": "X11984104" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T19:55:05Z" +"RFModificationTimestamp": "2025-04-18T01:58:59.885953+00:00" +"ListPrice": 1299900.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.49 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N0A 1L0" +"UnparsedAddress": "4006 Queen Street, Haldimand, On N0a 1l0" +"Coordinates": array:2 [ 0 => -80.0728723 1 => 42.8087034 ] +"Latitude": 42.8087034 +"Longitude": -80.0728723 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A Multi Generation Haven (3 separate living quarters) with A Car/Motorcycle Enthusiast Dream Shop!!! Take a peek at the Floor Plans for Details. Walking Distance to Lake Erie and Hoovers Marina - enjoy living close to the water for all you summertime fun and boating!! With a short drive to Port Dover this home is a Dream Come True!!! This home has been recently updated allowing for growing families to enjoy their own spaces yet grow together. Offering 6 bedrooms, 6 bathrooms, 3 kitchens, an exercise room and park for 8 plus cars. With water views from the 2 upper decks - sunrises are picturesque. Dont miss the almost 2000 Sqft man cave with its very own exercise room, office, storage 2 piece bath and in-law suite. Upgraded to include in the shop: amps 200 , triad amplifier , Denon stereo, peavey 3500 watt amp, control 4 smart home, CCTV, in-floor heating , led lighting, security cameras / hike vision and more." +"ArchitecturalStyle": array:1 [ 0 => "Sidesplit 4" ] +"Basement": array:2 [ 0 => "Full" 1 => "Separate Entrance" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:2 [ 0 => "Board & Batten" 1 => "Brick Front" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand" +"CoveredSpaces": "4.0" +"CreationDate": "2025-02-23T07:57:08.613834+00:00" +"CrossStreet": "Rainham/Erie" +"DirectionFaces": "South" +"Directions": "Rainham Rd to Erie St to Queen" +"ExpirationDate": "2025-08-05" +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Other" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "In-Law Capability" 2 => "In-Law Suite" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-22" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-02-22T19:27:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-02-22T19:27:51Z" +"OriginalListPrice": 1299900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1996700" +"ParcelNumber": "382490256" +"ParkingFeatures": array:2 [ 0 => "Front Yard Parking" 1 => "Private Triple" ] +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2025-02-22T19:27:51Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Metal" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queen" +"StreetNumber": "4006" +"StreetSuffix": "Street" +"TaxAnnualAmount": "1794.0" +"TaxLegalDescription": "LT 3 E/S WILLIAM ST, 4E/S WILLIAM ST PL 344; HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% OF PURCHASE PRICE + HST" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Creek/Stream" ] +"VirtualTourURLBranded2": "https://listings.northernsprucemedia.com/videos/0194dce4-c6f6-7203-9f55-dfb7f5bf9d9c" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/0194dce4-0fbc-7095-907b-47a25b207f64" +"WaterSource": array:1 [ 0 => "Cistern" ] +"DDFYN": true +"Water": "Other" +"HeatType": "Forced Air" +"LotDepth": 132.0 +"LotWidth": 162.36 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11984104')" +"GarageType": "Detached" +"HeatSource": "Electric" +"RollNumber": "281033200138800" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "Indirect" ] +"ElectricYNA": "Yes" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"KitchensTotal": 3 +"ParkingSpaces": 8 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:2 [ 0 => "Marina" 1 => "River/Stream" ] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 3 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType4Level": "Lower" +"WashroomsType5Level": "Upper" +"MediaChangeTimestamp": "2025-02-22T19:27:51Z" +"SystemModificationTimestamp": "2025-04-17T19:55:06.397254Z" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13182 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12022300" +"ListingId": "X12022300" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T19:54:52Z" +"RFModificationTimestamp": "2025-04-18T02:11:45.555675+00:00" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 1V3" +"UnparsedAddress": "205 Thompson Road, Haldimand, On N3w 1v3" +"Coordinates": array:2 [ 0 => -79.9351434 1 => 43.0738543 ] +"Latitude": 43.0738543 +"Longitude": -79.9351434 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AVILA REALTY GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning Detached Home in Avalon, Caledonia Modern Living at Its Finest !Discover this beautifully upgraded, all-brick detached home, nestled in the heart of Avalon, in the beautiful Caledonia, just moments from the Grand River and close to all amenities. This Empire-built gem features 3 spacious bedrooms and 3 baths, including a convenient powder room on the main floor.Step inside to an inviting open-concept layout with large windows flooding the space with natural light. The modern kitchen boasts stainless steel appliances, a central island for eat-in in the kitchen, and ample cabinetry, perfect for cooking and entertaining. The great room offers a warm, welcoming ambiance, ideal for family gatherings. The dining with ease walk-out to backyard.Upstairs, you'll find a luxurious primary bedroom retreat with a 4-piece ensuite, complete with a soaker tub, separate shower, and a generous size walk-in closet. The additional bedrooms are well-sized, complemented by a second full bath. Laundry is conveniently located on the upper floor for added ease. The unfinished basement provides ample storage space and the potential to customize to create extra living space for In-Law or extra income potential. Enjoy the attached garage with direct home access and a spacious and private backyard, ready for outdoor relaxation. This home is perfect for first-time buyers, families, or investors looking for a blend of modern comfort and convenience. Don't miss the chance to make this stunning property your own! Location: Avalon Community, Caledonia.3 Bedrooms | 3 Bathrooms | Attached Garage.Move-in Ready | Upgraded Finishes | Bright & Spacious.Book Your Private Showing Today!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CoveredSpaces": "2.0" +"CreationDate": "2025-03-17T08:40:31.777516+00:00" +"CrossStreet": "Mc Clung Rd / Thompson Rd" +"DirectionFaces": "South" +"Directions": "205 Thompson Rd, Haldimand, Caledonia, ON N3W 1V3" +"Exclusions": "Tenant's belongings" +"ExpirationDate": "2025-06-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-03-17" +"MainOfficeKey": "228300" +"MajorChangeTimestamp": "2025-03-17T08:25:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-03-17T08:25:12Z" +"OriginalListPrice": 750000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2093868" +"ParcelNumber": "381550637" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-17T19:54:52Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Thompson" +"StreetNumber": "205" +"StreetSuffix": "Road" +"TaxAnnualAmount": "4587.23" +"TaxLegalDescription": "LOT 2, PLAN 18M52 SUBJECT TO AN EASEMENT FOR ENTRY AS IN CH87319 HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + BONUS" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://propertysupnext.hd.pics/205-Thompson-Rd-Caledo" +"VirtualTourURLUnbranded": "https://propertysupnext.hd.pics/205-Thompson-Rd-Caledo/idx" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 91.87 +"LotWidth": 26.91 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12022300')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "281015200508900" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 120 +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 10 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Ground" +"MediaChangeTimestamp": "2025-04-17T19:54:52Z" +"SystemModificationTimestamp": "2025-04-17T19:54:53.482045Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:46 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13181 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12089819" +"ListingId": "X12089819" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T19:27:24Z" +"RFModificationTimestamp": "2025-04-18T05:29:16.791112+00:00" +"ListPrice": 895000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N0A 1P0" +"UnparsedAddress": "40 Hoover Point Lane, Haldimand, On N0a 1p0" +"Coordinates": array:2 [ 0 => -79.8928142 1 => 42.8167101 ] +"Latitude": 42.8167101 +"Longitude": -79.8928142 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SUTTON GROUP - SUMMIT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This stunning year-round lake house is situated on a 1/3 acre lot in a highly sought-after community nestled in the heart of Selkirk Cottage Country. Boasting direct waterfront access, the property includes 73 feet wide and 75 ft deep of private shallow entry beach with a mix of sandy sections, and smooth limestone, perfect for evening bonfires. Enjoy picnics on the beach, taking in the sun and listening to the waves. The fully fenced backyard, protected by a storm-resistant warranty, ensures privacy and security. The house itself is a blend of modern convenience and nautical charm, featuring newer plumbing, electrical systems, heating, and air conditioning. The open-concept main cottage with vaulted ceilings offers breathtaking lake views from the kitchen and living area. The master bedroom comfortably fits a king-size bed, while the second bedroom accommodates a queen-size bed and a single bed, and there's also a play loft. Additional living space is provided by a private bunkie, perfect for those needing a quiet workspace or an extra sleeping area. The property includes a large garage capable of storing a boat, a BBQ, a fire pit, an indoor fireplace, a hot tub, and air conditioning. Located on a private road in a tranquil area, the cottage is above water level, outside any flood zone, and protected by a concrete break wall with riparian rights. This is one you dont want to miss!!" +"ArchitecturalStyle": array:1 [ 0 => "1 1/2 Storey" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:1 [ 0 => "Board & Batten" ] +"Cooling": array:1 [ 0 => "Other" ] +"Country": "CA" +"CountyOrParish": "Haldimand" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-18T02:49:45.376262+00:00" +"CrossStreet": "Lakeshore Rd/Hoover Point Lane" +"DirectionFaces": "South" +"Directions": "Hwy 3 W from Cayuga, Left onto Kohler Rd/RR 8, Right onto Rainham Rd/Haldimand 3, Left onto Fisherville Rd/Haldimand 12, Right onto Lakeshore, Left onto Hoover Point ROAD, and Right onto Hoover Point LANE." +"Disclosures": array:1 [ 0 => "Unknown" ] +"Exclusions": "None" +"ExpirationDate": "2025-08-31" +"ExteriorFeatures": array:2 [ 0 => "Year Round Living" 1 => "Hot Tub" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Post & Pad" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Hot Tub, Microwave, Refrigerator, Satellite Dish, Stove, Washer, Window Coverings, All Existing Furniture, All ELFS" +"InteriorFeatures": array:2 [ 0 => "Water Purifier" 1 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-17" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "686500" +"MajorChangeTimestamp": "2025-04-17T18:57:31Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-04-17T18:57:31Z" +"OriginalListPrice": 895000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2255498" +"ParcelNumber": "382050261" +"ParkingFeatures": array:2 [ 0 => "Circular Drive" 1 => "Front Yard Parking" ] +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2025-04-17T18:57:31Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Hoover Point" +"StreetNumber": "40" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "3144.72" +"TaxLegalDescription": "PT LT 5 CON 1 RAINHAM AS IN HC286178; T/W HC286178; S/T R7560; HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Lake" ] +"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/4d3cbf71b05fe673a4a641e19797b679" +"WaterBodyName": "Lake Erie" +"WaterSource": array:1 [ 0 => "Cistern" ] +"WaterfrontFeatures": array:2 [ 0 => "Stairs to Waterfront" 1 => "Waterfront-Deeded" ] +"WaterfrontYN": true +"Zoning": "H A13F1" +"DDFYN": true +"Water": "Well" +"HeatType": "Heat Pump" +"LotDepth": 229.59 +"LotWidth": 80.7 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12089819')" +"Shoreline": array:1 [ 0 => "Unknown" ] +"WaterView": array:1 [ 0 => "Direct" ] +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "281015800211300" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "Direct" ] +"DockingType": array:1 [ 0 => "Private" ] +"RentalItems": "None" +"HoldoverDays": 90 +"KitchensTotal": 1 +"ParkingSpaces": 6 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Haldimand, ON N0A 1P0, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 7 +"AccessToProperty": array:1 [ 0 => "Year Round Private Road" ] +"AlternativePower": array:1 [ 0 => "Unknown" ] +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Golf" 2 => "Hospital" 3 => "Lake/Pond" 4 => "Park" 5 => "School" ] +"LotIrregularities": "240.64 ft x 67.16 ft x 23.79 ft x 229.59" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "Owned" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WaterfrontAccessory": array:1 [ 0 => "Bunkie" ] +"MediaChangeTimestamp": "2025-04-17T18:57:31Z" +"SystemModificationTimestamp": "2025-04-17T19:27:25.259398Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:49 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13180 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12089476" +"ListingId": "X12089476" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-17T17:39:01Z" +"RFModificationTimestamp": "2025-04-17T22:25:21.774117+00:00" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N1A 1V2" +"UnparsedAddress": "210 Lock Street, Haldimand, On N1a 1v2" +"Coordinates": array:2 [ 0 => -79.6218223 1 => 42.9033942 ] +"Latitude": 42.9033942 +"Longitude": -79.6218223 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity knocks at 210 Lock Street Westa character-filled 2.5-storey duplex directly across from the Grand River in the heart of Dunnville. Offering 2,400 sq ft of well-kept living space, this home is perfect for investors, multigenerational families, or those looking to offset their mortgage with rental income. Rich in original charm, the freshly painted interior showcases timeless woodwork, new carpet across all levels, and a blend of vintage and modern flair. The main unit features spacious living and dining rooms with classic sliding doors, gas fireplace, large windows, and a versatile bonus room ideal for an office or bedroom. The bright eat-in kitchen opens to a private patio. Upstairs, the second unit has its own entrance, full kitchen, laundry, and 2+1 bedrooms - ideal for tenants or extended family. A beautifully finished third-floor attic adds even more flexible space. Outside, enjoy a deep backyard with raised deck, above-ground pool, and room to garden or play. With curb appeal, location, and income potential, this is a rare find steps from downtown, parks, and schools." +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Dunnville" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Haldimand" +"CreationDate": "2025-04-17T19:03:29.276051+00:00" +"CrossStreet": "Pine St & Lock St W" +"DirectionFaces": "South" +"Directions": "Pine St & Lock St W" +"Exclusions": "N/A" +"ExpirationDate": "2025-10-17" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Smoke Detector, Washer, Window Coverings, Other" +"InteriorFeatures": array:2 [ 0 => "In-Law Suite" 1 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-17" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2025-04-17T17:39:01Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-04-17T17:39:01Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2255174" +"ParcelNumber": "381170174" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-17T17:39:01Z" +"PoolFeatures": array:1 [ 0 => "Above Ground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Lock" +"StreetNumber": "210" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2758.0" +"TaxLegalDescription": "W 1/2 LT 14 S/S LOCK ST PL 69 T/W HC256762; HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 212.0 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12089476')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "281002400302800" +"SurveyType": "Unknown" +"RentalItems": "N/A" +"HoldoverDays": 60 +"KitchensTotal": 2 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Haldimand, ON N1A 1V2, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 10 +"PropertyFeatures": array:6 [ 0 => "Campground" 1 => "Greenbelt/Conservation" 2 => "Hospital" 3 => "Library" 4 => "Park" 5 => "Place Of Worship" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Third" +"MediaChangeTimestamp": "2025-04-17T17:39:01Z" +"SystemModificationTimestamp": "2025-04-17T17:39:06.730127Z" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 31 +count: 302 +after_key: "" } ] ]
