Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 8828438a086b340847f000e91fc62e75739a7405ad4bf87df189feaf49b92138" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4232 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4049 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10744948" +"ListingId": "X10744948" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-20T22:30:35Z" +"RFModificationTimestamp": "2025-05-07T13:23:33Z" +"ListPrice": 359900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3470.0 +"City": "Norfolk County" +"PostalCode": "N4B 2M1" +"UnparsedAddress": "165 Main St N/a, Norfolk County, On N4b 2m1" +"Coordinates": array:2 [ 0 => -71.3305516 1 => 42.1198484 ] +"Latitude": 42.1198484 +"Longitude": -71.3305516 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 Heritage House Ltd Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Investors and Business Owners! Discover an exceptional opportunity at 165 Main Street, Delhi—a versatile mixed-use building offering two main floor commercial units and two second-floor residential units. Upon closing, the north commercial unit will be vacant, presenting the perfect chance for a business to move in and benefit from rental income from the other three units. Alternatively, if you're an investor (and not looking for a location for your business) you can secure a new commercial tenant at market rent and enjoy the steady cash flow from all four units. The building’s other three units include: a long-standing and successful registered massage therapy business, AND two one-bedroom residential units on the second floor, both with long-term tenants. The property also features a clean, dry basement accessible from both commercial units, as well as three (potentially four) dedicated parking spaces at the rear for commercial tenants, with additional parking available nearby in a municipal lot. Recent updates include a newer hot water heater, fresh paint, and updated flooring throughout. Located on a bustling street, 165 Main Street is surrounded by a variety of shops, restaurants, offices, and thriving businesses, making it an ideal location for both a business and an investment. Don't miss this chance to maximize the potential of this prime property!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CoListOfficeKey": "518900" +"CoListOfficeName": "Century 21 Heritage House Ltd Brokerage" +"CoListOfficePhone": "519-539-5646" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-24T06:41:48.654617+00:00" +"CrossStreet": "From 401 Follow Highway #59 to Delhi. Turn Left onto Highway #3 and follow to Main Street of Delhi. Turn Right at the Lights, Property ahead on the Left." +"DaysOnMarket": 426 +"Disclosures": array:1 [ 0 => "Right Of Way" ] +"ExpirationDate": "2025-07-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-27" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "89.06 x 34.63" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "518900" +"MajorChangeTimestamp": "2024-10-08T12:58:24Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-08-27T14:44:31Z" +"OriginalListPrice": 389900.0 +"OriginatingSystemID": "witaar" +"OriginatingSystemKey": "40638407" +"ParcelNumber": "501600170" +"PhotosChangeTimestamp": "2024-08-27T14:44:31Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 389900.0 +"PriceChangeTimestamp": "2024-10-08T12:58:24Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "witaar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MAIN ST" +"StreetNumber": "165" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "5056.44" +"TaxAssessedValue": 195000 +"TaxBookNumber": "331049200205800" +"TaxLegalDescription": "PT LT 8 BLK 16 PL 189 PT 1 & 2 37R9820; TOWN OF DELHI, NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "CG" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"AccessToProperty": array:1 [ 0 => "Paved Road" ] +"PropertyUse": "With Property" +"GasYNA": "Yes" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 34.63 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10744948')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"TelephoneYNA": "Yes" +"provider_name": "TRREB" +"LotDepth": 89.06 +"PossessionDetails": "Immediate" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "153276095" +"ElectricYNA": "Yes" +"TaxType": "Unknown" +"HoldoverDays": 180 +"RuralUtilities": array:1 [ 0 => "Street Lights" ] +"Media": array:6 [ 0 => array:26 [ "ResourceRecordKey" => "X10744948" "MediaModificationTimestamp" => "2024-08-27T14:44:31Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10744948/thumbnail-c12386145784cb412e9a26432308ba5d.webp" "ShortDescription" => null "MediaKey" => "21623de1-ccc7-4aac-9b5d-e2fdb7956bcd" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-08-27T14:44:31Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10744948/c12386145784cb412e9a26432308ba5d.webp" "MediaSize" => 54012 "SourceSystemMediaKey" => "_itso-153276095-0" "SourceSystemID" => "witaar" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => null ] 1 => array:26 [ "ResourceRecordKey" => "X10744948" "MediaModificationTimestamp" => "2024-08-27T14:44:31Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10744948/thumbnail-b46bd6ad8c4d3f22c609f869d16a9f2a.webp" "ShortDescription" => null "MediaKey" => "8ba4c394-652c-46f7-9841-481f122bf5c6" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-08-27T14:44:31Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10744948/b46bd6ad8c4d3f22c609f869d16a9f2a.webp" "MediaSize" => 58163 "SourceSystemMediaKey" => "_itso-153276095-1" "SourceSystemID" => "witaar" "MediaHTML" => null "PreferredPhotoYN" => false …2 ] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4048 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403442" +"ListingId": "X10403442" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:45:39Z" +"RFModificationTimestamp": "2024-12-13T02:30:53Z" +"ListPrice": 949500.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3025.55 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "123 Coulas Crescent, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ 0 => -80.282205355592 1 => 42.92206687865 ] +"Latitude": 42.92206687865 +"Longitude": -80.282205355592 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Spacious Detached bungalow on a lrg lot in the quaint Waterford. ~100K in upgrades. Lrg windows lets in natural sunlight on both levels. Wood flrs throughout, no carpet. 2 separate living spaces w/ dedicated bdrms, kitchens & laundry rms. The main flr boasts a lrg open concept living space w/ recessed ceilings, 3 spacious bdrms, 2 full baths. The main kitchen features S/S appliances, quartz countertops and walk-in pantry. Eat-in kitchen features a walkout to the backyard. The fully finished basement boasts a separate entrance from the front foyer leading to the granny suite with open concept living/dining space, kitchen, 3 spacious bdrms and 1.5 baths. Perfect for housing an additional family or potential for a possible extra income venture. Dbl Garage features an auto garage door opener, a man door to the side yard and accesses the house via the laundry/mudroom. The backyard showcases a gazebo, lrg shed, rustic fire pit and enough space for possibly a family pool oasis in the future." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Walk-Up" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:29:32.157357+00:00" +"CrossStreet": "Thompson Rd E / Old Hwy 24" +"DaysOnMarket": 396 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-02-26" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Garage Door Opener, Window Coverings" +"InteriorFeatures": array:3 [ 0 => "Accessory Apartment" 1 => "Water Heater Owned" 2 => "Sump Pump" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-27" +"LotSizeDimensions": "147.1 x 63.92" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-10-31T09:37:18Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-08-27T13:21:32Z" +"OriginalListPrice": 980000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40638394" +"ParcelNumber": "502830448" +"ParkingFeatures": array:3 [ 0 => "Private Double" 1 => "Other" 2 => "Other" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-12-11T14:45:39Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 980000.0 +"PriceChangeTimestamp": "2024-10-31T09:37:18Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "16" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "COULAS" +"StreetNumber": "123" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "5884.38" +"TaxAssessedValue": 390000 +"TaxBookNumber": "331033605035016" +"TaxLegalDescription": "LOT 16, PLAN 37M-45, NORFOLK COUNTY." +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/123_coulas_crescent_waterford_on/" +"Zoning": "A" +"Water": "Municipal" +"RoomsAboveGrade": 8 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 8 +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"WashroomsType4Pcs": 2 +"LotWidth": 63.92 +"HeatType": "Forced Air" +"WashroomsType4Level": "Lower" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403442')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"LotDepth": 147.1 +"ParkingSpaces": 4 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 3 +"GarageType": "Attached" +"MediaListingKey": "153275444" +"Exposure": "South" +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 3 +"SquareFootSource": "Plans" +"MediaChangeTimestamp": "2024-12-11T14:45:39Z" +"WashroomsType2Pcs": 3 +"ApproximateAge": "6-15" +"WashroomsType3": 1 +"WashroomsType3Level": "Lower" +"WashroomsType4": 1 +"KitchensTotal": 2 +"Media": array:23 [ 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4022 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403550" +"ListingId": "X10403550" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:40:53Z" +"RFModificationTimestamp": "2024-12-13T02:43:05Z" +"ListPrice": 549500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 884.0 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "17b Lingwood Drive, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ 0 => -80.2879326 1 => 42.9357327 ] +"Latitude": 42.9357327 +"Longitude": -80.2879326 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "3 Bedroom 2 bath upgraded and well kept semi detached home on a quiet street in a lovely family oriented neighbor in quaint Waterford. Main floor has an open layout between the kitchen and living area. Very well maintained with many updated through out , the house, including new flooring. no carpet. Recently renovated kitchen with quartz countertops, stainless steep appliances. Two newly renovated bathrooms. Fully finished basement with large rec room that has a walkout to a deck, pool and shed. A large fenced backyard, backing onto rail trail and green space. Other upgrades include; newer furnace approx. 7 yrs old, shingles and attic insulation upgrade approx. 4 yrs. ago. Close to schools, parks, grocery and waterfront activities." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-03T23:04:42.271293+00:00" +"CrossStreet": "Concession 8 & Old Hwy 24" +"DaysOnMarket": 397 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Pool Equipment, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-14" +"LotSizeDimensions": "162.56 x 38.66" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-09-13T18:53:23Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-14T18:44:37Z" +"OriginalListPrice": 579900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40633601" +"ParcelNumber": "502620143" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:40:53Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 579900.0 +"PriceChangeTimestamp": "2024-09-13T18:53:23Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "9" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LINGWOOD" +"StreetNumber": "17B" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2851.66" +"TaxAssessedValue": 189000 +"TaxBookNumber": "331033504001950" +"TaxLegalDescription": "PT LT 10 PL 1006 PT 37R5395 NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17b_lingwood_dr_waterford_on/" +"Zoning": "R2" +"Water": "Municipal" +"RoomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 4 +"LotWidth": 38.66 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403550')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2023 +"provider_name": "TRREB" +"LotDepth": 162.56 +"ParkingSpaces": 2 +"PossessionDetails": "Flexible" +"BedroomsBelowGrade": 1 +"GarageType": "Unknown" +"MediaListingKey": "152958335" +"Exposure": "North" +"WashroomsType2Level": "Lower" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Other" +"MediaChangeTimestamp": "2024-12-11T14:40:53Z" +"WashroomsType2Pcs": 3 +"ApproximateAge": "31-50" +"KitchensTotal": 1 +"Media": array:25 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4025 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404331" +"ListingId": "X10404331" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:32:05Z" +"RFModificationTimestamp": "2024-12-13T03:10:57Z" +"ListPrice": 850000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Norfolk County" +"PostalCode": "N3Y 4K1" +"UnparsedAddress": "Con 6 Pt Lt 13 N/a Road, Norfolk County, On N3y 4k1" +"Coordinates": array:2 [ 0 => -80.5547698 1 => 42.7792131 ] +"Latitude": 42.7792131 +"Longitude": -80.5547698 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Beautiful Turkey Point Road Property. Create your dream oasis or hobby farm on this enchanting 23-acre\r\n parcel, nestled just a stone's throw away from the vibrant towns of Simcoe and Port Dover. Situated near\r\n Turkey Point, with its inviting beaches, marinas, and provincial parks, this picturesque location offers the\r\n perfect blend of rural tranquility and modern convenience. Embrace a lifestyle of leisure with easy access to\r\n boating, fishing, and the sun-drenched shores of Lake Erie—all just a short drive away. Seize the opportunity\r\n to craft your ideal retreat in this idyllic setting. Please do not walk property without an appointment. """ +"ArchitecturalStyle": array:1 [ 0 => "Unknown" ] +"Basement": array:1 [ 0 => "Unknown" ] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Unknown" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-04T05:44:53.423442+00:00" +"CrossStreet": "St John's RD W & Turkey Point Rd" +"DaysOnMarket": 331 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-03-19" +"InteriorFeatures": array:1 [ 0 => "Unknown" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-19" +"LotSizeDimensions": "x" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-19T10:10:04Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-10-19T10:10:04Z" +"OriginalListPrice": 850000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40665222" +"ParcelNumber": "501970145" +"ParkingFeatures": array:1 [ 0 => "Unknown" ] +"PhotosChangeTimestamp": "2024-12-11T14:32:05Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "N/A" +"StreetNumber": "CON 6 PT LT 13" +"StreetSuffix": "Road" +"TaxAnnualAmount": "507.2" +"TaxAssessedValue": 171000 +"TaxBookNumber": "331049304021400" +"TaxLegalDescription": "PT LT 13 CON 6 CHARLOTTEVILLE AS IN NR525821; NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "None" ] +"Zoning": "A" +"Water": "Other" +"PossessionDetails": "Flexable" +"DDFYN": true +"LotSizeRangeAcres": "10-24.99" +"GarageType": "Unknown" +"MediaListingKey": "154895047" +"Exposure": "East" +"HeatSource": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"MediaChangeTimestamp": "2024-12-11T14:32:05Z" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404331')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"Media": array:13 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4050 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10418337" +"ListingId": "X10418337" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T13:45:52Z" +"RFModificationTimestamp": "2025-04-26T17:35:24Z" +"ListPrice": 504900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1086.0 +"City": "Norfolk County" +"PostalCode": "N0A 1N1" +"UnparsedAddress": "12 St Andrews Street Unit 406, Norfolk County, On N0a 1n1" +"Coordinates": array:2 [ 0 => -80.39003 1 => 42.637637 ] +"Latitude": 42.637637 +"Longitude": -80.39003 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover your new home in this beautiful top-floor condo, ideally located in the heart of Port Dover. Spanning 1,086 sq. ft., this spacious unit offers a comfortable and modern lifestyle, just steps away from the river, beach, shops, and vibrant downtown area. The open floor plan features newer flooring throughout and a large kitchen with a breakfast bar, perfect for casual dining or entertaining. The cozy living room boasts a corner gas fireplace and a walkout to a large private balcony, offering serene views and an ideal spot for relaxation. The primary bedroom is a true retreat, complete with a walk-in closet and a full ensuite bath. A second bedroom with a double closet and a second full bathroom provide ample space for guests or a home office. Additional conveniences include in-suite laundry with plenty of storage space, a designated parking spot, and a locker for extra storage. This move-in-ready home is waiting for you to make it your own. Don't miss out on this rare opportunity in a sought-after location." +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"AssociationAmenities": array:3 [ 0 => "Gym" 1 => "Party Room/Meeting Room" 2 => "Visitor Parking" ] +"AssociationFee": "581.37" +"AssociationFeeIncludes": array:3 [ 0 => "Building Insurance Included" 1 => "Common Elements Included" 2 => "Water Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CoListOfficeKey": "519000" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-338-3737" +"ConstructionMaterials": array:1 [ 0 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-12T07:23:15.989049+00:00" +"CrossStreet": "Hwy 6- St Andrew" +"DaysOnMarket": 344 +"DirectionFaces": "South" +"ExpirationDate": "2025-03-31" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Inclusions": "Fridge, Stove, B/I Dishwasher, B/I Microwave, Washer, Dryer, All window covering. All ELF's., Other" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-11-09" +"LotSizeDimensions": "x" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2024-11-09T10:39:48Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-11-09T10:39:48Z" +"OriginalListPrice": 504900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40673165" +"ParcelNumber": "508170030" +"ParkingFeatures": array:1 [ 0 => "Reserved/Assigned" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-11-09T10:39:48Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Flat" ] +"RoomsTotal": "8" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ST ANDREWS" +"StreetNumber": "12" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2972.37" +"TaxAssessedValue": 197000 +"TaxBookNumber": "331033401065830" +"TaxLegalDescription": "UNIT 6, LEVEL 4, NORFOLK STANDARD CONDOMINIUM PLAN NO. 17" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "406" +"VirtualTourURLUnbranded": "https://mediatours.ca/property/406-12-st-andrew-street-port-dover/" +"Zoning": "R5" +"Water": "Municipal" +"RoomsAboveGrade": 8 +"PropertyManagementCompany": "Norfolk Property Managem" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 2 +"DDFYN": true +"LivingAreaRange": "1000-1199" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10418337')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"LegalApartmentNumber": "Call LBO" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ParkingSpaces": 1 +"LegalStories": "Call LBO" +"PossessionDetails": "Flexible" +"ParkingType1": "Unknown" +"LockerNumber": "406" +"GarageType": "Outside/Surface" +"BalconyType": "Open" +"MediaListingKey": "155315372" +"Exposure": "East" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Other" +"ApproximateAge": "16-30" +"ParkingSpot1": "406" +"KitchensTotal": 1 +"Media": array:33 [ 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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4051 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10744855" +"ListingId": "X10744855" +"PropertyType": "Commercial Sale" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-06T15:36:37Z" +"RFModificationTimestamp": "2025-04-26T18:50:51Z" +"ListPrice": 1448900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1639.0 +"City": "Norfolk County" +"PostalCode": "N0J 1G0" +"UnparsedAddress": "244 11th Concession Road, Norfolk County, On N0j 1g0" +"Coordinates": array:2 [ 0 => -80.628429 1 => 42.706569 ] +"Latitude": 42.706569 +"Longitude": -80.628429 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Re/Max a-b Realty Ltd Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 244 11th Concession Road, in Langton where tranquility and functionality blend seamlessly! Approx. 25-acre estate offers the perfect combination of functional living, stunning natural beauty, and unique amenities. Situated in a serene countryside setting, this property boasts former fish farm qualities, and various outbuildings; including a work shop and coverall fabric buildings. This home boasts 6 bedrooms and 3 bathrooms, offering ample space for family and guests. The layout has been crafted with both comfort and style in mind, with a wood pellet stove, offering a cozy heat for your home. This property has been upgraded with accessibility in mind, ensuring that everyone can enjoy the space with ease. Wide hallways, accessible bathrooms, and ramps provide a seamless experience for individuals with mobility needs. The beauty of natural light that floods every room, creating an inviting and cheerful atmosphere throughout the day. Large windows offer panoramic views of the surrounding landscape, connecting the indoors with the outdoors. This property presents a comfortable home. Whether you're looking to enjoy the property as a personal sanctuary or explore its potential, the possibilities are truly exciting. Don't miss this opportunity to own a remarkable 25-acre property that combines accessibility, and functional amenities, and an opportunity to restart a fish farm!" +"AccessibilityFeatures": array:7 [ 0 => "Modified Bathroom Counter" 1 => "Roll-In Shower" 2 => "Doors Swing In" 3 => "Ramps" 4 => "Shower Stall" 5 => "Wheelchair Access" 6 => "None" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Norfolk" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-24T06:44:26.232559+00:00" +"CrossStreet": "Cty Rd 23 thru Glen Meyer, past Roosevelt, turn left on Conc.11, 3rd ppty on right" +"DaysOnMarket": 586 +"DirectionFaces": "North" +"ExpirationDate": "2025-06-30" +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Negotiable" +"InteriorFeatures": array:1 [ 0 => "Central Vacuum" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-02-24" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "997.37 x 1382.72" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "519400" +"MajorChangeTimestamp": "2024-10-23T18:34:14Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-02-24T08:44:50Z" +"OriginalListPrice": 1575000.0 +"OriginatingSystemID": "witaar" +"OriginatingSystemKey": "40544652" +"OtherStructures": array:3 [ 0 => "Greenhouse" 1 => "Barn" 2 => "Workshop" ] +"ParcelNumber": "501340135" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2024-02-24T08:44:50Z" +"PoolFeatures": array:1 [ 0 => "Above Ground" ] +"PreviousListPrice": 1498000.0 +"PriceChangeTimestamp": "2024-10-23T18:34:14Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "18" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "witaar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "11TH CONCESSION" +"StreetNumber": "244" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3677.39" +"TaxAssessedValue": 456000 +"TaxBookNumber": "331054203000450" +"TaxLegalDescription": "PT LOTS 3 & 4, CONC. 10; PT 1, 37R-1001" +"TaxYear": "2023" +"Topography": array:2 [ 0 => "Flat" 1 => "Wooded/Treed" ] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"WaterSource": array:1 [ 0 => "Dug Well" ] +"Zoning": "A" +"Water": "Unknown" +"RoomsAboveGrade": 13 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Unknown" +"WashroomsType2": 2 +"AccessToProperty": array:1 [ 0 => "Paved Road" ] +"PropertyUse": "Unknown" +"HeatSource": "Propane" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 5 +"PropertyFeatures": array:1 [ 0 => "Fenced Yard" ] +"FarmType": "Fish" +"LotWidth": 1382.72 +"HeatType": "Wood" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10744855')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2023 +"TelephoneYNA": "Yes" +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"LotDepth": 997.37 +"ParkingSpaces": 10 +"PossessionDetails": "Flexible" +"BedroomsBelowGrade": 2 +"GarageType": "Attached" +"MediaListingKey": "147218375" +"Exposure": "East" +"ElectricYNA": "Yes" +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 4 +"WashroomsType2Pcs": 3 +"TaxType": "Unknown" +"ApproximateAge": "31-50" +"RuralUtilities": array:1 [ 0 => "Recycling Pickup" ] +"KitchensTotal": 2 +"Media": array:39 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4052 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10745661" +"ListingId": "X10745661" +"PropertyType": "Commercial Sale" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-06T15:33:30Z" +"RFModificationTimestamp": "2025-01-20T16:22:14Z" +"ListPrice": 1469900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2412.0 +"City": "Norfolk County" +"PostalCode": "N3Y 4K6" +"UnparsedAddress": "2597 Nixon Road, Norfolk County, On N3y 4k6" +"Coordinates": array:2 [ 0 => -80.40866436355 1 => 42.870445147703 ] +"Latitude": 42.870445147703 +"Longitude": -80.40866436355 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Coldwell Banker G.R. Paret Realty Limited Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Nestled on a serene 47.5 acre plot just a short drive East of Delhi lies a dwelling that commands attention. This property boasts approximately 30 acres of fertile farmland, harmoniously blending with wooded areas and designated building sites. Here, agricultural potential meets natural habitat, offering a picturesque setting for country living. Crafted as a sanctuary for both entertaining and familial comfort, this rural retreat exudes tranquility, surrounded by woodlands and expansive fields. Upon entering, the grandeur of the residence unfolds, showcasing high ceilings, laminate floors, and an open staircase leading to the finished lower level. The heart of the home lies in its gourmet shaker-style kitchen, adorned with pristine white cabinetry, stainless appliances, and a convenient rear laundry/entry area. Adjacent, the dining room basks in natural light streaming through generous windows. The impressive great room is seamlessly connected to a covered porch, blurring the lines between indoor and outdoor living. Outside, a private oasis awaits, featuring an above-ground pool and newly constructed deck, perfect for leisurely afternoons. On the main floor, three bedrooms accompany the luxurious owner's suite, boasting an elegant 4-piece bath with a soaker tub, glass shower, and walk-in closet. Descending to the lower level reveals a fully finished space, offering a sprawling recreation area and an additional guest bedroom. Completing the property is a substantial 44' x 44' pole barn that was constructed in 2020. This building has roll-up doors, high ceilings & side entry, providing ample storage & workspace. With a multitude of features too numerous to enumerate, this exceptional rural residence epitomizes the finest living Norfolk County has to offer. Don't let the chance slip by to experience it firsthand." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-28T11:12:41.006040+00:00" +"CrossStreet": "Follow Harmony Road (Windham Road # 12) East of Delhi. Turn left (North) on to Nixon Road. Property is on the left. 911# 2597." +"DaysOnMarket": 397 +"DirectionFaces": "West" +"Exclusions": "Lower level bar & bar accessories including shelving." +"ExpirationDate": "2025-05-15" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Central Vacuum, Dishwasher, Pool Equipment, Refrigerator, Smoke Detector, Stove, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Water Meter" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "1823.87 x 697.57" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "517800" +"MajorChangeTimestamp": "2024-11-13T10:38:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-18T10:32:32Z" +"OriginalListPrice": 1489900.0 +"OriginatingSystemID": "witaar" +"OriginatingSystemKey": "40648764" +"OtherStructures": array:1 [ 0 => "Barn" ] +"ParcelNumber": "501820186" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Other" ] +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2024-09-18T10:32:32Z" +"PoolFeatures": array:1 [ 0 => "Above Ground" ] +"PreviousListPrice": 1489900.0 +"PriceChangeTimestamp": "2024-11-13T10:38:54Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "14" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Unknown" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "witaar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "NIXON" +"StreetNumber": "2597" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5842.44" +"TaxAssessedValue": 731000 +"TaxBookNumber": "331049102312000" +"TaxLegalDescription": "PT LT 13 CON 11 WINDHAM PT 1 37R10677; NORFOLK COUNTY, ON." +"TaxYear": "2024" +"Topography": array:2 [ 0 => "Flat" 1 => "Wooded/Treed" ] +"TransactionBrokerCompensation": "2.0% plus HST. Should the Listing Brokerage introd" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"VirtualTourURLUnbranded": "https://Tours.Up Nclose.com/idx/227704" +"WaterSource": array:1 [ 0 => "Sand Point Well" ] +"Zoning": "A" +"Water": "Unknown" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Propane Tank" ] +"WashroomsType1": 2 +"DDFYN": true +"LotType": "Unknown" +"AccessToProperty": array:1 [ 0 => "Paved Road" ] +"PropertyUse": "Unknown" +"HeatSource": "Propane" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 4 +"LotWidth": 697.57 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10745661')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MortgageComment": "Treat as clear." +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"LotDepth": 1823.87 +"ParkingSpaces": 10 +"PossessionDetails": "To Be Arranged" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154055812" +"Exposure": "West" +"ElectricYNA": "Yes" +"BedroomsAboveGrade": 3 +"TaxType": "Unknown" +"LotIrregularities": "See Remarks" +"ApproximateAge": "6-15" +"UFFI": "No" +"HoldoverDays": 30 +"RuralUtilities": array:2 [ 0 => "Cell Services" 1 => "Recycling Pickup" ] +"KitchensTotal": 1 +"Media": array:48 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4053 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10422859" +"ListingId": "X10422859" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-29T16:35:16Z" +"RFModificationTimestamp": "2025-05-06T09:46:58Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3557.0 +"City": "Norfolk County" +"PostalCode": "N3Y 1W4" +"UnparsedAddress": "13 Kent Street, Norfolk County, On N3y 1w4" +"Coordinates": array:2 [ 0 => -80.3048832 1 => 42.8366977 ] +"Latitude": 42.8366977 +"Longitude": -80.3048832 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Rock Star Real Estate Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome To 11-13 Kent St, A Remarkable Downtown Building, With Combined Commercial & Residential Space, Currently Utilized As A Six Unit Residential, Plus One Vacant Commercial Unit, Generating Impressive Rental Income. This "Cash Cow" Property Offers An Attractive Cap Rate Of Over 9.0%! Currently Generating $71,400 Annually With One Vacant Residential Unit That Could Increase Your Income To $87,600 Per Year, Plus One Vacant Commercial Unit $$$ Perfect For Investors Seeking Substantial Rental Income Or Families Looking For Multi-Generational Living Arrangements, This Property Is Centrally Located, Offering Easy Access To Amenities and Shopping. Whether You're A Seasoned Or Novice Investor, This Multi-Unit Property Presents An Exceptional Opportunity." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Wood" ] +"Cooling": array:1 [ 0 => "Other" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-12-01T03:56:52.841960+00:00" +"CrossStreet": "Argyle Street/Norfolk Street S" +"DaysOnMarket": 409 +"ExpirationDate": "2024-12-31" +"FoundationDetails": array:2 [ 0 => "Stone" 1 => "Concrete Block" ] +"Inclusions": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-08-01" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "69.7 x 24.85" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "145500" +"MajorChangeTimestamp": "2024-11-28T15:45:42Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-08-01T11:16:14Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40628227" +"ParcelNumber": "502250118" +"PhotosChangeTimestamp": "2024-11-29T16:35:16Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "KENT" +"StreetNumber": "13" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5127.21" +"TaxAssessedValue": 121000 +"TaxBookNumber": "331040101015600" +"TaxLegalDescription": "PT LT 4 BLK 96 PL 182 AS IN NR547463 S/T NR547463 NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "CG" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 24.85 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10422859')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 69.7 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "None" +"MediaListingKey": "152625976" +"Exposure": "East" +"PriorMlsStatus": "Sold" +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"TaxType": "Unknown" +"LotIrregularities": "68.77 ft x 24.55 ft x 69.70 ft x 29.33 ft" +"UFFI": "No" +"HoldoverDays": 90 +"short_address": "Norfolk County, ON N3Y 1W4, CA" +"Media": array:7 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4054 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404168" +"ListingId": "X10404168" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-16T19:05:40Z" +"RFModificationTimestamp": "2025-04-25T20:50:47Z" +"ListPrice": 250000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Norfolk County" +"PostalCode": "N0A 1N0" +"UnparsedAddress": "N/a St George Street, Norfolk County, On N0a 1n0" +"Coordinates": array:2 [ 0 => -80.39003 1 => 42.637637 ] +"Latitude": 42.637637 +"Longitude": -80.39003 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lee & Associates Commercial Real Estate Inc." +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Opportunity to invest and develop a custom home in Port Dover! Discover the potential to create your dream home in the charming town of Port Dover. This prime location offers immediate access to Main Street and is just minute away from a variety of amenities in downtown port Dover. Enjoy the convenience of nearby shops, restaurants, and entertainment options, all within a vibrant and friendly community. This investment opportunity provides a perfect blend of small-town charm and modern conveniences, making it an ideal spot for your custom home development. Don't miss out on the chance to be a part of this growing and desirable area!\r\n \r\n *Legal Description Continued: COUNTY, The Property Is Being Sold On An "As Is" Basis. Seller is Selling Surface Rights Only (SRO). """ +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-03T22:31:26.797869+00:00" +"CrossStreet": "St. George St & Dover Ave" +"DaysOnMarket": 395 +"ExpirationDate": "2024-12-19" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-10" +"LotSizeDimensions": "189 x 120" +"MainOfficeKey": "333500" +"MajorChangeTimestamp": "2024-09-10T14:03:58Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-09-10T14:03:58Z" +"OriginalListPrice": 250000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40645055" +"ParcelNumber": "502410138" +"PhotosChangeTimestamp": "2024-11-02T20:43:13Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ST GEORGE" +"StreetNumber": "N/A" +"StreetSuffix": "Street" +"TaxAssessedValue": 92000 +"TaxBookNumber": "331033402005460" +"TaxLegalDescription": "PT RAILWAY LT 19 PL 207 SRO PT 4 37R213; NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1.5% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "None" ] +"Zoning": "R1-A-Residential" +"Water": "Municipal" +"PossessionDetails": "TBC" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "153815032" +"Exposure": "West" +"SoilTest": "No" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 120.0 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404168')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 189.0 } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4055 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403670" +"ListingId": "X10403670" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-16T18:50:37Z" +"RFModificationTimestamp": "2024-11-17T12:28:15Z" +"ListPrice": 299900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1000.0 +"City": "Norfolk County" +"PostalCode": "N3Y 1J3" +"UnparsedAddress": "60 Patterson Street, Norfolk County, On N3y 1j3" +"Coordinates": array:2 [ 0 => -80.300216208333 1 => 42.832509908333 ] +"Latitude": 42.832509908333 +"Longitude": -80.300216208333 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 People's Choice Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Welcome to 60 Patterson Street!\r\n \r\n Looking to step onto the property ladder? This adorable Simcoe home is perfect for first time buyers or savvy investors! Enjoy an affordable entry point, into a desirable neighbourhood, a spacious layout with plenty of potential for customization, a large yard for outdoor enjoyment, and a prime location close to amenities and schools. Don't miss out on this fantastic opportunity! """ +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-03T22:34:34.731108+00:00" +"CrossStreet": "Owen St/ Patterson St" +"DaysOnMarket": 380 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-03-12" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Dryer, Freezer, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x 33.5" +"MainOfficeKey": "530800" +"MajorChangeTimestamp": "2024-09-25T10:54:19Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-25T10:54:19Z" +"OriginalListPrice": 299900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40652571" +"ParcelNumber": "502360483" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-11-02T20:23:23Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "7" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:4 [ 0 => "List Salesperson" 1 => "Lockbox" 2 => "Showing System" 3 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "PATTERSON" +"StreetNumber": "60" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2293.4" +"TaxAssessedValue": 152000 +"TaxBookNumber": "331040401506300" +"TaxLegalDescription": "PT LT 4, BLK 127A, BEING PT 1 ON 37R8988" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0 %" +"TransactionType": "For Sale" +"Zoning": "R" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 33.5 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403670')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ParkingSpaces": 2 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154267966" +"Exposure": "South" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Other" +"ApproximateAge": "51-99" +"HoldoverDays": 90 +"KitchensTotal": 1 +"PossessionDate": "2024-11-12" } ] +success: true +page_size: 10 +page_count: 1 +count: 10 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4142 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4056 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12484434" +"ListingId": "X12484434" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-28T13:07:52Z" +"RFModificationTimestamp": "2025-10-28T13:10:45Z" +"ListPrice": 899999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3290.0 +"City": "Hamilton" +"PostalCode": "L8P 1B7" +"UnparsedAddress": "428 King Street W, Hamilton, ON L8P 1B7" +"Coordinates": array:2 [ 0 => -79.8819967 1 => 43.2605232 ] +"Latitude": 43.2605232 +"Longitude": -79.8819967 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Lepage Real Estate Associates" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 428 King Street West! An exceptional mixed-use investment opportunity in the heart of West Hamilton's Strathcona neighbourhood. Ideally positioned at the corner of King Street West and Pearl Street North, along the future Hamilton LRT corridor - this property offers strong income, long-term growth potential, and outstanding street visibility. The building features approximately 1,728 sq. ft. of ground-floor commercial space with large display windows and excellent exposure, plus four residential units on the second floor, with a separate entrance off Pearl Street North. The upper level includes one self-contained one-bedroom apartment and three individual rooms sharing a kitchen and bathroom. All units, including the commercial space, are fully rented, generating consistent monthly cash flow. Zoned Transit Oriented Corridor (TOC), the property allows a wide range of uses including retail, and office. With quick access to Highway 403, public transit, and within walking distance of Locke Street and West End amenities, this is a turnkey investment in one of Hamilton's most desirable growth areas." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Strathcona" +"CoListOfficeName": "Royal Lepage Real Estate Associates" +"CoListOfficePhone": "905-278-8866" +"Cooling": array:1 [ 0 => "No" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-10-27T21:27:49.964189+00:00" +"CrossStreet": "King Street West and Pearl Street" +"Directions": "King Street West and Pearl Street" +"ExpirationDate": "2026-02-27" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-27" +"MainOfficeKey": "101200" +"MajorChangeTimestamp": "2025-10-28T13:07:52Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-10-27T20:05:05Z" +"OriginalListPrice": 899999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3176736" +"ParcelNumber": "171450064" +"PhotosChangeTimestamp": "2025-10-27T20:05:06Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "King" +"StreetNumber": "428" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9829.25" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "TOC1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 54.0 +"LotWidth": 34.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12484434')" +"GarageType": "None" +"RetailArea": 1728.0 +"RollNumber": "251801010154500" +"PropertyUse": "Multi-Use" +"HoldoverDays": 60 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "flexible" +"OfficeApartmentArea": 1562.0 +"MediaChangeTimestamp": "2025-10-27T20:05:06Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-10-28T13:07:52.791656Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:10 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4115 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12483837" +"ListingId": "W12483837" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-28T13:07:47Z" +"RFModificationTimestamp": "2025-10-28T13:10:45Z" +"ListPrice": 1895000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Mississauga" +"PostalCode": "L5K 2P7" +"UnparsedAddress": "2397 Marisa Court, Mississauga, ON L5K 2P7" +"Coordinates": array:2 [ 0 => -79.6580956 1 => 43.5324244 ] +"Latitude": 43.5324244 +"Longitude": -79.6580956 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SLAVENS & ASSOCIATES REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 2397 Marisa Court - a distinguished residence nestled in the highly sought-after Sheridan / Sherwood Forrest neighbourhood of Mississauga. This elegant home perfectly balances timeless curb appeal with modern comfort, offering an ideal retreat for the growing family or discerning buyer seeking both sophistication and everyday practicality. Step inside to a spacious, light-filled foyer leading to generous principal rooms. Hardwood floors flow seamlessly throughout the main level, creating a warm and welcoming atmosphere. The formal living and dining rooms provide refined spaces for entertaining, while the adjoining kitchen and open-concept family room invite relaxed, casual living. The large, family-sized kitchen features stainless steel appliances, a bright breakfast area, and direct access to the outdoor patio and expansive landscaped backyard - complete with your very own swimming pool. Perfect for summer gatherings, weekend barbecues, or quiet mornings with coffee in hand. This home has been designed with accessibility in mind, the main floor offers full wheelchair access, including a lift from the garage and a luxurious roll-in steam shower, ensuring both comfort and independence. Upstairs, discover multiple well-appointed bedrooms, including a luxurious primary suite with a six-piece ensuite and spacious walk-in closet. Additional bedrooms offer ample comfort for family or overnight guests. Tucked away on a quiet cul-de-sac, 2397 Marisa Court backs onto lush greenery, offering exceptional privacy and serenity. Enjoy proximity to top-rated schools, scenic parks, walking trails, and public transit - all just minutes from major highways and the GO Station for effortless commuting. The Sherwood Forrest community is renowned for its mature tree-lined streets, strong neighbourhood spirit, and convenient access to shopping, dining, and prestigious post-secondary institutions.2397 Marisa Court - where timeless elegance meets modern family living." +"AccessibilityFeatures": array:4 [ 0 => "Exterior Lift" 1 => "Roll-In Shower" 2 => "Shower Stall" 3 => "Wheelchair Access" ] +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Sheridan" +"CoListOfficeName": "SLAVENS & ASSOCIATES REAL ESTATE INC." +"CoListOfficePhone": "416-483-4337" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Peel" +"CoveredSpaces": "2.0" +"CreationDate": "2025-10-27T17:37:55.863699+00:00" +"CrossStreet": "Erin Mills Parkway and Dundas" +"DirectionFaces": "East" +"Directions": "Erin Mills Parkway and Dundas" +"ExpirationDate": "2026-02-27" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Hot Tub" 2 => "Lawn Sprinkler System" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Stainless Steel: Fridge, Stove, Dishwasher and Hood Fan, Microwave, Basement Freezer, Clothes Washer & Dryer, Steam Shower Equipment Located In Laundry Room, All Electrical Light Fixtures and All Window Coverings, Furnace and Hepa Filter, (2) Liftmaster Garage Door Openers and (1) Remote & Garage Wheel Chair Lift" +"InteriorFeatures": array:3 [ 0 => "Central Vacuum" 1 => "Steam Room" 2 => "Wheelchair Access" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-27" +"MainOfficeKey": "116400" +"MajorChangeTimestamp": "2025-10-27T16:40:00Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-27T16:40:00Z" +"OriginalListPrice": 1895000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3183574" +"OtherStructures": array:2 [ 0 => "Fence - Full" 1 => "Shed" ] +"ParcelNumber": "134390131" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-10-27T16:40:00Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:2 [ 0 => "Alarm System" 1 => "Other" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Marisa" +"StreetNumber": "2397" +"StreetSuffix": "Court" +"TaxAnnualAmount": "12997.5" +"TaxLegalDescription": "PCL 37-1, SEC 43M825 ; LT 37, PL 43M825 , S/T A RIGHT AS IN LT1074354 ; MISSISSAUGA" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/h8479906" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 234.67 +"LotWidth": 49.53 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12483837')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "210506013243700" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "Hot Water Tank-Gas" ] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 2 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:6 [ 0 => "Cul de Sac/Dead End" 1 => "Golf" 2 => "Park" 3 => "Public Transit" 4 => "Ravine" 5 => "School" ] +"PossessionDetails": "30-60-90 Days/TBA" +"WashroomsType1Pcs": 1 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 6 +"WashroomsType4Pcs": 5 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Ground" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2025-10-27T16:43:45Z" +"HandicappedEquippedYN": true +"SystemModificationTimestamp": "2025-10-28T13:07:49.572723Z" +"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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4113 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12443379" +"ListingId": "X12443379" +"PropertyType": "Residential" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-28T13:07:28Z" +"RFModificationTimestamp": "2025-10-28T13:10:45Z" +"ListPrice": 579000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "K7K 0G6" +"UnparsedAddress": "121 Queen Street 601, Kingston, ON K7K 0G6" +"Coordinates": array:2 [ 0 => -76.4841479 1 => 44.2331575 ] +"Latitude": 44.2331575 +"Longitude": -76.4841479 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX RISE EXECUTIVES, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located right in Kingston's historic downtown core, this stylish 2-bedroom condo combines modern design with unmatched convenience. Just steps from Queens University, KGH, boutique shopping, and an array of dining options, the setting is vibrant yet practical. Inside, the thoughtful layout begins with a spacious foyer that flows into a bright open-concept space for living, dining, and cooking all highlighted by oversized windows framing the Cathedrals architecture. Residents also enjoy premium amenities including underground parking, private storage, secure bicycle facilities, a guest suite, a residents lounge, and a beautifully finished outdoor terrace designed for gatherings, complete with dining areas and BBQs. Built only nine years ago, this condominium offers both comfort and lifestyle in one of the city's most desirable neighbourhoods." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:3 [ 0 => "Concierge" 1 => "Guest Suites" 2 => "Party Room/Meeting Room" ] +"AssociationFee": "766.0" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Hydro Included" 2 => "Water Included" 3 => "Common Elements Included" 4 => "Parking Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Anna Lane" +"CityRegion": "22 - East of Sir John A. Blvd" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Frontenac" +"CoveredSpaces": "1.0" +"CreationDate": "2025-10-03T17:17:53.404217+00:00" +"CrossStreet": "BAGOT AND QUEEN" +"Directions": "SOUTH ON QUEEN ST TO BAGOT" +"ExpirationDate": "2026-01-02" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Kingston & Area Real Estate Association" +"ListingContractDate": "2025-10-02" +"MainOfficeKey": "470700" +"MajorChangeTimestamp": "2025-10-28T13:07:28Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-03T16:57:27Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3081338" +"ParcelNumber": "367740138" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-06T16:22:43Z" +"PreviousListPrice": 599000.0 +"PriceChangeTimestamp": "2025-10-28T13:07:28Z" +"PropertyAttachedYN": true +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queen" +"StreetNumber": "121" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5238.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.00%" +"TransactionType": "For Sale" +"UnitNumber": "601" +"DDFYN": true +"Locker": "Owned" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12443379')" +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "L1" +"RollNumber": "101103010008167" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"BalconyType": "Enclosed" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"LegalStories": "6" +"LockerNumber": "31" +"ParkingSpot1": "29" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionDate": "2025-10-02" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 74 +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:2 [ 0 => "Hospital" 1 => "Lake/Pond" ] +"SquareFootSource": "Plans" +"ParkingLevelUnit1": "P1" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "1" +"MediaChangeTimestamp": "2025-10-06T16:22:52Z" +"PropertyManagementCompany": "BENDALE PROPERTY MANAGEMENT" +"SystemModificationTimestamp": "2025-10-28T13:07:30.49419Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:35 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4111 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12232919" +"ListingId": "X12232919" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-28T13:07:26Z" +"RFModificationTimestamp": "2025-10-28T13:10:45Z" +"ListPrice": 850000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 2.74 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cavan Monaghan" +"PostalCode": "L0A 1C0" +"UnparsedAddress": "243 Stewart Line, Cavan Monaghan, ON L0A 1C0" +"Coordinates": array:2 [ 0 => -78.545849 1 => 44.22125 ] +"Latitude": 44.22125 +"Longitude": -78.545849 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXIT REALTY LIFTLOCK" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "VENDORS MOTIVATED! Hilltop Home with Fantastic Views! Cavan area bungalow situated on 2.74 acres with spectacular views, trees, trails, with natural gas heat! Home features 3+1 bedrooms and updated bathroom as well as main floor laundry. Extra bedroom on the lower level. Most of the basement is unfinished and ready for you to make it your own special retreat. Double detached garage, fully insulated and heated, has wood stove and plenty of built-in storage. Interlocking brick between house and garage as well as a privacy fence, allows for a private courtyard area. Covered porch on house and above ground pool add to the "vacation at home" atmosphere. Quiet, dead end street. A must to view!" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Partially Finished" ] +"CityRegion": "Cavan Twp" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Peterborough" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-19T23:12:01.279756+00:00" +"CrossStreet": "Stewart Line & Jill Ln" +"DirectionFaces": "South" +"Directions": "Follow Sir Sandford Fleming Dr turns into Stewart Line, follow to #243" +"Disclosures": array:1 [ 0 => "Environmentally Protected" ] +"Exclusions": "Personal belongings, generator, Air compressor & related garage items, vice & bench grinder & all tools, fridge in garage, metal ornaments" +"ExpirationDate": "2025-11-30" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Light fixtures, window coverings, fridge, stove, washer, dryer, dishwasher, auto garage door opener with 3 remotes, woodstove in garage, workbenches, pool & all equipment including natural gas heater for pool." +"InteriorFeatures": array:10 [ 0 => "Auto Garage Door Remote" 1 => "Carpet Free" 2 => "Generator - Partial" 3 => "Primary Bedroom - Main Floor" 4 => "Storage" 5 => "Suspended Ceilings" 6 => "Upgraded Insulation" 7 => "Water Heater Owned" 8 => "Water Softener" 9 => "Workbench" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2025-06-19" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "282900" +"MajorChangeTimestamp": "2025-10-28T13:07:26Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-19T17:01:59Z" +"OriginalListPrice": 899999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2577568" +"OtherStructures": array:3 [ 0 => "Garden Shed" 1 => "Greenhouse" 2 => "Shed" ] +"ParcelNumber": "280020133" +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2025-07-07T13:20:28Z" +"PoolFeatures": array:1 [ 0 => "Above Ground" ] +"PreviousListPrice": 871500.0 +"PriceChangeTimestamp": "2025-10-28T13:07:26Z" +"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" ] +"SoilType": array:1 [ 0 => "Clay" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Stewart" +"StreetNumber": "243" +"StreetSuffix": "Line" +"TaxAnnualAmount": "4143.0" +"TaxLegalDescription": "LT 30 RCP 124 CAVAN T/W CMR25168; CVN-MIL-NMO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://pages.finehomesphoto.com/243-Stewart-Line/idx" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Zoning": "R" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"CableYNA": "No" +"HeatType": "Forced Air" +"LotDepth": 192.38 +"LotShape": "Rectangular" +"LotWidth": 600.38 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12232919')" +"WellDepth": 199.0 +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "150901004034828" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"RentalItems": "N/A" +"HoldoverDays": 60 +"TelephoneYNA": "Available" +"WellCapacity": 20.0 +"KitchensTotal": 1 +"ParkingSpaces": 8 +"UnderContract": array:1 [ 0 => "None" ] +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Other" +"PriorMlsStatus": "New" +"RuralUtilities": array:8 [ 0 => "Cell Services" 1 => "Electricity Connected" 2 => "Garbage Pickup" 3 => "Internet High Speed" 4 => "Natural Gas" 5 => "Recycling Pickup" 6 => "Telephone Available" 7 => "Underground Utilities" ] +"WashroomsType1": 1 +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:5 [ 0 => "Clear View" 1 => "Cul de Sac/Dead End" 2 => "School Bus Route" 3 => "Sloping" 4 => "Wooded/Treed" ] +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Main" +"MediaChangeTimestamp": "2025-08-13T18:05:11Z" +"SystemModificationTimestamp": "2025-10-28T13:07:28.599455Z" +"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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4109 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "E12479188" +"ListingId": "E12479188" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-28T13:06:58Z" +"RFModificationTimestamp": "2025-10-28T13:10:45Z" +"ListPrice": 649800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Oshawa" +"PostalCode": "L1H 5Y6" +"UnparsedAddress": "332 Lasalle Avenue, Oshawa, ON L1H 5Y6" +"Coordinates": array:2 [ 0 => -78.8435381 1 => 43.8925995 ] +"Latitude": 43.8925995 +"Longitude": -78.8435381 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX IMPACT REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning Fully Renovated 3-Bedroom plus one bedroom Brick Bungalow on La Salle Ave, Oshawa. Finished basement with large recroom ,3PC washroom and extra bedroom. Welcome to this beautifully updated home Located in a quiet, mature neighbourhood in Central Oshawa. This move-in ready and is filled with modern upgrades and timeless charm Features & Upgrades: Freshly painted throughout with hardwood floors, bright modern kitchen with quartz countertops and stainless steel appliances. Elegant living room featuring crown moulding and pot lights, updated main and basement bathrooms with contemporary finishes. Finished basement with separate entrance - ideal for in-laws, guests, or potential income suite. Newer roof, furnace, and air conditioning for peace of mind and a large detached 1.5-car garage." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"CityRegion": "Central" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Durham" +"CoveredSpaces": "5.0" +"CreationDate": "2025-10-23T20:59:06.677629+00:00" +"CrossStreet": "Central Park Blvd S/Olive" +"DirectionFaces": "West" +"Directions": "Central Park Blvd S/Olive" +"Exclusions": "N/A" +"ExpirationDate": "2026-02-28" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove,Dishwasher, Washer, Dryer, All Light Fixtures and Window Coverings." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2025-10-23" +"MainOfficeKey": "280400" +"MajorChangeTimestamp": "2025-10-23T19:44:31Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-10-23T19:44:31Z" +"OriginalListPrice": 649800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3170716" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-10-23T19:44:31Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Shingles" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lasalle" +"StreetNumber": "332" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4802.1" +"TaxLegalDescription": "Plan 502 Lot 13" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://show.tours/332-lasalle-ave-oshawa-4pzy" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 107.33 +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12479188')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "181304002202100" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"KitchensTotal": 1 +"ParkingSpaces": 5 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "1-29 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 3 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-10-23T19:44:31Z" +"SystemModificationTimestamp": "2025-10-28T13:07:00.951168Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:32 [ 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] ] } ] +success: true +page_size: 5 +page_count: 25943 +count: 129713 +after_key: "" } ] ]