Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
0 of 0array:2 [▼ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=111150&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=111150&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=111150&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=111150&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [▶ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14238 ▶ +items: array:9 [▶ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14232 ▶ +post_id: "141855" +post_author: 1 +"ListingKey": "X11904793" +"ListingId": "X11904793" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:22:41Z" +"RFModificationTimestamp": "2025-05-06T09:37:10Z" +"ListPrice": 450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 110.0 +"City": "Hamilton" +"PostalCode": "L8H 2W1" +"UnparsedAddress": "#6 - 279 Kenilworth Avenue, Hamilton, On L8h 2w1" +"Coordinates": array:2 [▶ 0 => -79.8113217 1 => 43.2371069 ] +"Latitude": 43.2371069 +"Longitude": -79.8113217 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "NEW AGE REAL ESTATE GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professionally Finished Executive Office Space In A Fully Renovated Office Building @ High Traffic Location. Easy Access-2 Min Drive To QEW & Red Hill Parkway. Walk To The Centre Mall On Barton. Private Parking! Office Amenities Are 24 Hour Office Access, Common Reception, Board Room & Cafeteria. Suitable For Professionals Like Lawyers, Accountants, And Mortgage Brokers! ◀Professionally Finished Executive Office Space In A Fully Renovated Office Building @ High Traffic Location. Easy Access-2 Min Drive To QEW & Red Hill Parkway. ▶" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [▶ 0 => "Professional Office" ] +"CityRegion": "Crown Point" +"CommunityFeatures": "Major Highway,Public Transit" +"Cooling": "Yes" +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T02:44:26.814926+00:00" +"CrossStreet": "Kenilworth/Barton" +"ExpirationDate": "2025-06-30" +"HeatingYN": true +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "61.91 x 95.00 Feet" +"MainOfficeKey": "379800" +"MajorChangeTimestamp": "2025-01-02T21:22:41Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-02T21:22:41Z" +"OriginalListPrice": 450.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1817198" +"PhotosChangeTimestamp": "2025-01-02T21:22:41Z" +"SecurityFeatures": array:1 [▶ 0 => "No" ] +"ShowingRequirements": array:1 [▶ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Kenilworth" +"StreetNumber": "279" +"StreetSuffix": "Avenue" +"TaxYear": "2025" +"TransactionBrokerCompensation": "Half month rent" +"TransactionType": "For Lease" +"UnitNumber": "6" +"Utilities": "Yes" +"Zoning": "Commercial" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"LotWidth": 61.91 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904793')" +"MinimumRentalTermMonths": 24 +"RetailArea": 110.0 +"provider_name": "TRREB" +"LotDepth": 95.0 +"ParkingSpaces": 1 +"MaximumRentalMonthsTerm": 60 +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"PriorMlsStatus": "Draft" +"PictureYN": true +"MediaChangeTimestamp": "2025-01-02T21:22:41Z" +"TaxType": "N/A" +"BoardPropertyType": "Com" +"HoldoverDays": 30 +"StreetSuffixCode": "Ave" +"MLSAreaDistrictOldZone": "X14" +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"OfficeApartmentArea": 110.0 +"MLSAreaMunicipalityDistrict": "Hamilton" +"PossessionDate": "2025-02-01" +"short_address": "Hamilton, ON L8H 2W1, CA" +"Media": array:8 [▶ 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] ] +"ID": "141855" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 ▶ +post_id: "141867" +post_author: 1 +"ListingKey": "X9194849" +"ListingId": "X9194849" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:15:32Z" +"RFModificationTimestamp": "2025-01-03T02:51:13Z" +"ListPrice": 180000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 545.0 +"City": "Bayham" +"PostalCode": "N0J 1Z0" +"UnparsedAddress": "6231 PLANK Rd, Bayham, Ontario N0J 1Z0" +"Coordinates": array:2 [▶ 0 => -80.788698 1 => 42.680097 ] +"Latitude": 42.680097 +"Longitude": -80.788698 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A Bright Idea! Act now on this affordable, attractive Commercial opportunity in downtown Vienna! Prime main street exposure guarantees maximum visibility plus its directly across the street from the villages beautiful Memorial Park providing reliable foot traffic. Situated on the scenic banks of the Big Otter Creek, Vienna is a quaint and friendly village with a longstanding/notable history. Its a mere 5 minute drive to Port Burwell & Lake Erie, just 20 minutes to Tillsonburg & offers easy 401 access. Great curb appeal and many recent updates in this low maintenance property with a generous 545+/- sf of bright, open, well-appointed space and on-site parking. The large picture window is ideal for showcasing your business! Currently laid out with a very spacious L-shaped primary retail/business space, a dedicated office/storage/staff room with 2nd entrance, large walk-in cooler/freezer that includes the refrigeration unit and 2-pce washroom with laundry provision. Included are: security cameras, a triple stainless steel sink & live edge front counter. Updates since 2022: exterior paint, heat pump, wall insulation, commercial grade vinyl cladding on walls and ceilings, new flooring, combination washer/dryer, refrigeration unit and LED lighting. The C1 zoning provides an extensive range of permitted uses a perfect fit for aspiring entrepreneurs and/or franchisees! Here you can launch your dream: retail outlet, professional office, specialty store, studio, salon, take-out, bakery or dining establishment! So many possibilities to establish your business in this well-maintained, versatile property in a fantastic location. Imagine the bright ideas you can bring to light here! ◀A Bright Idea! Act now on this affordable, attractive Commercial opportunity in downtown Vienna! Prime main street exposure guarantees maximum visibility plus i ▶" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [▶ 0 => "Retail Store Related" ] +"CityRegion": "Vienna" +"CommunityFeatures": "Recreation/Community Centre" +"Cooling": "Yes" +"CountyOrParish": "Elgin" +"CreationDate": "2024-07-27T02:40:01.547677+00:00" +"CrossStreet": "EDISON DRIVE" +"Exclusions": "2 Chest Freezers, Upright display Freezer, Display case, Stainless Steel Saw, Storefront signage," +"ExpirationDate": "2025-01-31" +"Inclusions": "Security Camera, Water Heater, triple stainless steel sink, Live edge front counter, Haier Washer/Dryer Combination, Refrigeration unit for the walk-in cooler/freezer, ◀Security Camera, Water Heater, triple stainless steel sink, Live edge front counter, Haier Washer/Dryer Combination, Refrigeration unit for the walk-in cooler/f ▶" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-26" +"MainOfficeKey": "355000" +"MajorChangeTimestamp": "2024-09-20T14:11:49Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-07-26T22:45:30Z" +"OriginalListPrice": 200000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1324634" +"ParcelNumber": "353320236" +"PhotosChangeTimestamp": "2024-07-26T22:45:30Z" +"PreviousListPrice": 200000.0 +"PriceChangeTimestamp": "2024-09-20T14:11:49Z" +"SecurityFeatures": array:1 [▶ 0 => "No" ] +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "PLANK" +"StreetNumber": "6231" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1169.28" +"TaxAssessedValue": 35500 +"TaxLegalDescription": "PT LT 2 W/S MAIN ST, 3 W/S MAIN ST PL 54 BAYHAM PT 1, 5 11R2970; BAYHAM" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"Utilities": "Yes" +"Zoning": "H-C1" +"TotalAreaCode": "Sq Ft" +"Community Code": "47.08.0008" +"lease": "Sale" +"class_name": "CommercialProperty" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Retail" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 55.25 +"Amps": 100 +"HeatType": "Other" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9194849')" +"HSTApplication": array:1 [▶ 0 => "Yes" ] +"RollNumber": "340100400103200" +"RetailArea": 545.0 +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 84.4 +"PossessionDetails": "FLEXIBLE" +"GarageType": "None" +"PriorMlsStatus": "New" +"MediaChangeTimestamp": "2024-08-22T15:50:50Z" +"TaxType": "Annual" +"RentalItems": "None" +"HoldoverDays": 60 +"RetailAreaCode": "Sq Ft" +"Media": array:23 [▶ 0 => array:11 [ …11] 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] ] +"ID": "141867" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14231 ▶ +post_id: "141869" +post_author: 1 +"ListingKey": "W10403858" +"ListingId": "W10403858" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:15:20Z" +"RFModificationTimestamp": "2025-01-03T02:51:32Z" +"ListPrice": 2495000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3720.0 +"City": "Oakville" +"PostalCode": "L6H 6K6" +"UnparsedAddress": "1688 Glenvista Drive, Oakville, On L6h 6k6" +"Coordinates": array:2 [▶ 0 => -79.688523847204 1 => 43.490968124308 ] +"Latitude": 43.490968124308 +"Longitude": -79.688523847204 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Nestled on one of Joshua Creek’s most sought-after streets, this charming family home boasts 3,720 sq ft of elegant living space on a premium, mature pie-shaped lot adjacent to serene greenspace. The backyard is a private oasis featuring a luxurious spa-like ambiance with an inground pool, hot tub, expansive terrace and a charming cedar pool hut. Inside, you'll find a spacious great room, a main floor office and soaring vaulted ceilings. Recent updates include new stainless-steel appliances, a custom front door (2021), roof (2013), windows (2011), furnace (2017), garage doors (2022), pool liner (2018) and driveway (2021). Additional highlights include 9-foot ceilings on the main floor, hardwood flooring and two inviting fireplaces. Ideally situated near top-rated schools, parks, walking trails and transit. This is a must-see! ◀Nestled on one of Joshua Creek’s most sought-after streets, this charming family home boasts 3,720 sq ft of elegant living space on a premium, mature pie-shaped ▶" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [▶ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1009 - JC Joshua Creek" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:1 [▶ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-04T05:39:50.666208+00:00" +"CrossStreet": "Upper Middle Road E/Grand Blvd/Valleybrook/Glenvista" +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": "Hot Tub" +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [▶ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Electric Light Fixtures, Window Coverings, GDO + Remotes, Hot Tub, Pool Equipment, CVAC & Attachments, Other ◀Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Electric Light Fixtures, Window Coverings, GDO + Remotes, Hot Tub, Pool Equipment, CVAC & Attachments, Othe ▶" +"InteriorFeatures": "Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-06" +"LotFeatures": array:1 [▶ 0 => "Irregular Lot" ] +"LotSizeDimensions": "135.89 x 53.67" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-11-11T09:58:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-06T12:29:42Z" +"OriginalListPrice": 2595000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40641901" +"ParcelNumber": "250630508" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-12-11T14:51:12Z" +"PoolFeatures": "Inground" +"PreviousListPrice": 2595000.0 +"PriceChangeTimestamp": "2024-11-11T09:58:37Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "15" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GLENVISTA" +"StreetNumber": "1688" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "10775.0" +"TaxAssessedValue": 1354000 +"TaxBookNumber": "240101002048410" +"TaxLegalDescription": "LOT 80, PLAN 20M636, S/T PT 6, 20R12115, AS IN H641267;OAKVILLE S/T RIGHT UNTIL THE LATER OF 2 YEARS FROM 96 08 26 OR UNTIL COMPLETE ASSUMPTION BY THE CORP OF THE TOWN OF OAKVILLE OF THE ROADS & SERVICES ON PLAN 20M636, AS IN H642731 S/T RT AS IN H695047 ◀LOT 80, PLAN 20M636, S/T PT 6, 20R12115, AS IN H641267;OAKVILLE S/T RIGHT UNTIL THE LATER OF 2 YEARS FROM 96 08 26 OR UNTIL COMPLETE ASSUMPTION BY THE CORP OF T ▶" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/155812626" +"Zoning": "RL5 sp:45" +"Water": "Municipal" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [▶ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 53.67 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403858')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 135.89 +"ParkingSpaces": 4 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "153491563" +"Exposure": "West" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Builder" +"MediaChangeTimestamp": "2024-12-11T14:51:12Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"LotIrregularities": "53.7x136.12x72.34x135.03'" +"ApproximateAge": "16-30" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"KitchensTotal": 1 +"Media": array:38 [▶ 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] ] +"ID": "141869" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 ▶ +post_id: "141874" +post_author: 1 +"ListingKey": "W10403750" +"ListingId": "W10403750" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:12:11Z" +"RFModificationTimestamp": "2025-01-03T02:56:10Z" +"ListPrice": 2799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3735.0 +"City": "Oakville" +"PostalCode": "L6J 4M5" +"UnparsedAddress": "273 Cairncroft Road, Oakville, On L6j 4m5" +"Coordinates": array:2 [▶ 0 => -79.6559923 1 => 43.4670675 ] +"Latitude": 43.4670675 +"Longitude": -79.6559923 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located in the heart of South East Oakville in one of the areas most sought after neighbourhoods, this home offers a gorgeous 100' x 154' lot with towering trees and complete privacy. Situated close to top ranked schools (OTHS, EJ James, Maple Grove, St Mildreds, Linbrook), parks, shopping and easy access to highways. The home offers 4 bedrooms, 3 baths, 2 fireplaces, solarium, hardwood floors, finished basement, double garage and more! Move in, renovate or build your dream home in a prime location. Call for further details on private viewing. ◀Located in the heart of South East Oakville in one of the areas most sought after neighbourhoods, this home offers a gorgeous 100' x 154' lot with towering tree ▶" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [▶ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1011 - MO Morrison" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:1 [▶ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T22:16:04.872720+00:00" +"CrossStreet": "Lakeshore Rd E/Cairncroft Rd" +"DirectionFaces": "Unknown" +"Disclosures": array:1 [▶ 0 => "Unknown" ] +"ExpirationDate": "2025-01-16" +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [▶ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, stove, dishwasher, washer, dryer, window coverings, electric light fixtures, garage door opener, CVAC (All chattels, fixtures and fireplaces in As Is condition), Other ◀Fridge, stove, dishwasher, washer, dryer, window coverings, electric light fixtures, garage door opener, CVAC (All chattels, fixtures and fireplaces in As Is co ▶" +"InteriorFeatures": "Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-24" +"LotSizeDimensions": "154 x 100" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-11-08T15:42:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-24T10:57:22Z" +"OriginalListPrice": 2900000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40648192" +"ParcelNumber": "247970115" +"ParkingFeatures": "Private Double" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-01-02T21:12:10Z" +"PoolFeatures": "None" +"PreviousListPrice": 2900000.0 +"PriceChangeTimestamp": "2024-11-08T15:42:35Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "17" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CAIRNCROFT" +"StreetNumber": "273" +"StreetSuffix": "Road" +"TaxAnnualAmount": "12900.0" +"TaxAssessedValue": 1621000 +"TaxBookNumber": "240104014004300" +"TaxLegalDescription": "LT 23, PL 1322 ; S/T 186027 OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/158738131" +"Zoning": "RL1-0" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [▶ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 3 +"LotWidth": 100.0 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403750')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 154.0 +"ParkingSpaces": 6 +"PossessionDetails": "Immediate" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154029332" +"Exposure": "East" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Plans" +"MediaChangeTimestamp": "2025-01-02T21:12:10Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"ApproximateAge": "51-99" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"KitchensTotal": 1 +"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] ] +"ID": "141874" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14233 ▶ +post_id: "141883" +post_author: 1 +"ListingKey": "W10404239" +"ListingId": "W10404239" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:03:22Z" +"RFModificationTimestamp": "2025-01-03T03:04:59Z" +"ListPrice": 8499000.0 +"BathroomsTotalInteger": 8.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10020.0 +"City": "Oakville" +"PostalCode": "L6J 4B6" +"UnparsedAddress": "64 Brentwood Road, Oakville, On L6j 4b6" +"Coordinates": array:2 [▶ 0 => -79.65474570396 1 => 43.456071902554 ] +"Latitude": 43.456071902554 +"Longitude": -79.65474570396 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible custom-built home situated on a beautiful 100 x 162' lot with desirable SW exposure steps from the lake on one of Southeast Oakville's most coveted streets. The house is Michael Pettes designed and PCM built and offers incredible and hard to replicate features including over 10,000 square feet of living space with elegant and luxurious finishings throughout, an elevator, second floor balcony overlooking the back gardens and a triple car garage with soaring ceilings and a car lift. The interior's open concept floor plan and architectural nuances truly make this a one of a kind family home with too many features and finishings to list but includes 10' ceilings on main, a gorgeous central staircase open to all 3 levels, hardwood flooring and detailed millwork through out, custom gourmet kitchen overlooking expansive eat-in area and family room, large separate dining room with butler's servery, main floor office with built-ins and walk-out to covered porch, a peaceful primary retreat complete with a double door walk out to balcony, a sitting area, spectacular walk through closet and a luxurious 6-piece ensuite. The fabulously finished lower level has a double french door walk up, theatre room, exercise room, 5th bedroom, rec room with bar and walk-in wine cellar. The stunning back garden is complete with an inground pool and stone surround, outdoor 3-piece washroom, covered porch areas, outdoor kitchen and wood burning fireplace, cedar fencing and extensive landscaping providing a private oasis to enjoy. “Winco” natural gas powered backup generator. This truly is a one of a kind offering and a detailed feature brochure is available upon request. ◀Incredible custom-built home situated on a beautiful 100 x 162' lot with desirable SW exposure steps from the lake on one of Southeast Oakville's most coveted s ▶" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [▶ 0 => "Walk-Up" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1011 - MO Morrison" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:2 [▶ 0 => "Stucco (Plaster)" 1 => "Stone" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "4.0" +"CreationDate": "2024-11-03T22:10:26.163194+00:00" +"CrossStreet": "Lakeshore Rd E/Brentwood Road" +"DirectionFaces": "Unknown" +"Exclusions": "Kitchen Pendant Lights, Backyard Sculpture, EV Charger." +"ExpirationDate": "2025-02-04" +"ExteriorFeatures": "Lawn Sprinkler System,Privacy" +"FireplaceYN": true +"FireplacesTotal": "4" +"FoundationDetails": array:1 [▶ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "All Kitchen Appliances, 2 Washers, 2 Dryers, All ELFs, All Window Coverings, Theatre Room TV & Surround Sound, CVAC & Equip, 2 Furnaces, 2 A/C, Irrigation Sys, Control 4 Sys, Pool Equip, Outdoor Kitchen, Garage Door Opener, Car Lift, Generator, Other ◀All Kitchen Appliances, 2 Washers, 2 Dryers, All ELFs, All Window Coverings, Theatre Room TV & Surround Sound, CVAC & Equip, 2 Furnaces, 2 A/C, Irrigation Sys, ▶" +"InteriorFeatures": "Other,Water Heater Owned,Central Vacuum,Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [▶ 0 => "Multiple Locations" ] +"ListingContractDate": "2024-10-04" +"LotSizeDimensions": "162 x 100" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-10-04T16:13:24Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-04T16:13:24Z" +"OriginalListPrice": 8499000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40656583" +"ParcelNumber": "247820157" +"ParkingFeatures": "Private Double" +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2025-01-02T21:00:44Z" +"PoolFeatures": "Inground" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "30" +"SecurityFeatures": array:2 [▶ 0 => "Alarm System" 1 => "Smoke Detector" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [▶ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "BRENTWOOD" +"StreetNumber": "64" +"StreetSuffix": "Road" +"TaxAnnualAmount": "35119.0" +"TaxAssessedValue": 4413000 +"TaxBookNumber": "240104011007500" +"TaxLegalDescription": "LT 5, PL 548 TOWN OF OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/159730596" +"Zoning": "RL1-0" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [▶ 0 => "None" ] +"WashroomsType1": 2 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 5 +"WashroomsType4Pcs": 3 +"LotWidth": 100.0 +"HeatType": "Forced Air" +"WashroomsType4Level": "Second" +"WashroomsType3Pcs": 6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404239')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 162.0 +"ParkingSpaces": 8 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154485107" +"Exposure": "West" +"WashroomsType5Level": "Lower" +"WashroomsType5Pcs": 3 +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Plans" +"MediaChangeTimestamp": "2025-01-02T21:00:44Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"WashroomsType5": 2 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"WashroomsType4": 1 +"KitchensTotal": 1 +"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] ] +"ID": "141883" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14230 ▶ +post_id: "141884" +post_author: 1 +"ListingKey": "X9515967" +"ListingId": "X9515967" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:03:18Z" +"RFModificationTimestamp": "2025-01-03T03:04:59Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10560.0 +"City": "Rideau Lakes" +"PostalCode": "K0G 1V0" +"UnparsedAddress": "28 Colborne Street, Rideau Lakes, On K0g 1v0" +"Coordinates": array:2 [▶ 0 => -76.1898633 1 => 44.6982823 ] +"Latitude": 44.6982823 +"Longitude": -76.1898633 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER FIRST OTTAWA REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Grocery store with 10,500 sq ft and exposure on three roads. This store is located in the popular tourist destination of Portland Village, on shores of Big Rideau Lake with attractions such as swimming beaches, boat launches, houseboat rentals, Conservation Area and restaurants. The store has high visibility and signage on busy Hwy 15 that is major traffic route. Inside is 4,500sf grocery section plus deli, bakery, offices, loading dock and basement storage areas. Store also has half an acre, to grow your own produce. Fully equipped with all that you need to operate a one-stop shop, with large prep areas and lotto sales. All equipment included. Opportunity to improve profits with modernizing and increasing sales of local crafts, specialties and gourmet items. Electrical panels 1000 amps. Plenty of street parking available. Zoning is Local Commercial which allows for many uses. A gem with immense business potential, especially since nearest grocery store competitor is 15 min drive away. ◀Grocery store with 10,500 sq ft and exposure on three roads. This store is located in the popular tourist destination of Portland Village, on shores of Big Ride ▶" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Portland Foodmarket" +"BusinessType": array:1 [▶ 0 => "Grocery/Supermarket" ] +"CityRegion": "818 - Rideau Lakes (Bastard) Twp" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Leeds & Grenville" +"CreationDate": "2024-10-29T06:36:46.135943+00:00" +"CrossStreet": "From Ottawa, Hwy 417. Exit Hwy 7. At Carleton Place left on Hwy 15 to Portland. Right Main St. Property fronts Hwy 15, Main St and Colborne St. From Kingston, east Hwy 401. North on Hwy 15. At Portland, property fronts Hwy 15, Main St & Colborne St. ◀From Ottawa, Hwy 417. Exit Hwy 7. At Carleton Place left on Hwy 15 to Portland. Right Main St. Property fronts Hwy 15, Main St and Colborne St. From Kingston, e ▶" +"DirectionFaces": "South" +"ExpirationDate": "2025-04-03" +"FrontageLength": "34.64" +"HoursDaysOfOperationDescription": "Variable" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-04" +"MainOfficeKey": "484400" +"MajorChangeTimestamp": "2024-07-04T10:21:33Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 1 +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-07-04T10:21:33Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "OREB" +"OriginatingSystemKey": "1399892" +"ParcelNumber": "441240180" +"PetsAllowed": array:1 [▶ 0 => "Unknown" ] +"PhotosChangeTimestamp": "2025-01-02T21:02:53Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [▶ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:1 [▶ 0 => "List Brokerage" ] +"SourceSystemID": "oreb" +"SourceSystemName": "oreb" +"StateOrProvince": "ON" +"StreetName": "COLBORNE" +"StreetNumber": "28" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9150.0" +"TaxLegalDescription": "PT BLK PHILIP WING PL 27 AS IN LR371686; RIDEAU LAKES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "https://mikeclarkproductions.com/28-colborne-st" +"Zoning": "Local Commercial" +"Water": "Well" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Estimated" +"PropertyUse": "With Property" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"SurveyAvailableYN": true +"PortionPropertyLease": array:1 [▶ 0 => "Unknown" ] +"LotWidth": 113.64 +"Amps": 1000 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9515967')" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"RollNumber": "083183103649700" +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"RetailArea": 4410.0 +"ChattelsYN": true +"provider_name": "TRREB" +"LotDepth": 209.2 +"ParkingSpaces": 3 +"PossessionDetails": "TBD" +"GarageType": "Unknown" +"MediaListingKey": "38497700" +"ClearHeightInches": 11 +"MediaChangeTimestamp": "2025-01-02T21:02:54Z" +"TaxType": "Unknown" +"LotIrregularities": "0" +"HoldoverDays": 90 +"ClearHeightFeet": 10 +"RetailAreaCode": "Sq Ft" +"OfficeApartmentArea": 3800.0 +"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] ] +"ID": "141884" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14229 ▶ +post_id: "141924" +post_author: 1 +"ListingKey": "X10403376" +"ListingId": "X10403376" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:38:53Z" +"RFModificationTimestamp": "2025-01-03T03:31:41Z" +"ListPrice": 8999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 17985.0 +"City": "St. Catharines" +"PostalCode": "L2S 1M3" +"UnparsedAddress": "109 St. Paul Crescent, St. Catharines, On L2s 1m3" +"Coordinates": array:2 [▶ 0 => -79.245954005348 1 => 43.14992455 ] +"Latitude": 43.14992455 +"Longitude": -79.245954005348 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Every once in a while, an opportunity presents itself to acquire a truly spectacular property; a property so unique and special, that it must be seen to be understood. Rodman Hall is such a property. Originally built in 1857 as a private home, and operated for years as an art gallery, this remarkable estate has been completely rebuilt into a breathtaking boutique hotel and banquet hall/events centre. Situated on a very private lot with over 7 acres overlooking downtown St. Catharines, this stunning facility offers 13 lavish hotel rooms and a variety of exquisite event spaces including meeting rooms, a large bar area, and a banquet hall that can accommodate up to 150+ seated guests. Anchored by a brand new state-of-the-art commercial kitchen, walk-in coolers, and a dock-level loading bay, the event facilities are ideal for banquets, corporate events, weddings, and more! The zoning allows for institutional uses as well. The sprawling grounds include a large parking lot, beautiful lawns, and a botanical forest with an outdoor amphitheatre and paths leading down to Twelve Mile Creek. The current owner recently completed a comprehensive renovation of the property; restoring and updating nearly every aspect of the building including electrical, HVAC, plumbing, roofing, mechanical and building systems as well as all of the bathrooms, surfaces, fixtures and the many opulent heritage elements. Custom high-grade carpet has even been installed on the grand staircase, bearing the crest of the original owner. No expense was spared in the renovation - a legacy project that truly was a labour of love. Now offered for sale, this landmark hold tremendous potential waiting to be realized! ◀Every once in a while, an opportunity presents itself to acquire a truly spectacular property; a property so unique and special, that it must be seen to be unde ▶" +"Basement": array:1 [▶ 0 => "Partial Basement" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Rodman Hall" +"CityRegion": "458 - Western Hill" +"ConstructionMaterials": array:2 [▶ 0 => "Concrete" 1 => "Stone" ] +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-04T05:40:46.738240+00:00" +"CrossStreet": "Located directly opposite downtown St. Catharines across the the Burgoyne Bridge and Twelve Mile Creek." +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:2 [▶ 0 => "Slab" 1 => "Stone" ] +"Inclusions": "All property furnishings and furniture are to be included with the sale: all common area furniture, hotel room furniture, banquet hall chairs and tables, all kitchen fixtures and appliances. ◀All property furnishings and furniture are to be included with the sale: all common area furniture, hotel room furniture, banquet hall chairs and tables, all ki ▶" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-08" +"LotFeatures": array:1 [▶ 0 => "Irregular Lot" ] +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-08-08T13:56:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-08T13:56:50Z" +"OriginalListPrice": 8999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40630641" +"ParcelNumber": "461820105" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-11T14:40:24Z" +"Roof": "Unknown" +"SeatingCapacity": "200" +"SecurityFeatures": array:4 [▶ 0 => "Alarm System" 1 => "Carbon Monoxide Detectors" 2 => "Other" 3 => "Security System" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [▶ 0 => "List Salesperson" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ST. PAUL" +"StreetNumber": "109" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "95000.0" +"TaxAssessedValue": 2739000 +"TaxBookNumber": "262902002014900" +"TaxLegalDescription": "PT LT 2150 CP PL 2 GRANTHAM AS IN RO815029; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "https://109stpaulcrescent.relahq.com/" +"WaterfrontFeatures": "River Front" +"WaterfrontYN": true +"Zoning": "I1-122 & G1 with special provision" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"WaterFrontageFt": "597.0000" +"LotSizeRangeAcres": "5-9.99" +"PropertyUse": "With Property" +"GarageType": "Detached" +"MediaListingKey": "152771505" +"DockingType": array:1 [▶ 0 => "None" ] +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"MediaChangeTimestamp": "2024-12-11T14:40:24Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403376')" +"WaterBodyType": "Creek" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ShorelineAllowance": "None" +"ParkingSpaces": 4 +"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] ] +"ID": "141924" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 ▶ +post_id: "141930" +post_author: 1 +"ListingKey": "X10404406" +"ListingId": "X10404406" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:35:39Z" +"RFModificationTimestamp": "2025-04-29T15:07:47Z" +"ListPrice": 3399000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5522.0 +"City": "Hamilton" +"PostalCode": "L8R 2L1" +"UnparsedAddress": "178 James N Street, Hamilton, On L8r 2l1" +"Coordinates": array:2 [▶ 0 => -79.8668752 1 => 43.2611788 ] +"Latitude": 43.2611788 +"Longitude": -79.8668752 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A true landmark, this stunning mixed-use property offers a fabulous investment with both strong appreciation and cashflow upside. Home to the iconic, well-established Rapscallion Restaurant on the main and basement levels, this building also includes five apartments on the upper floors. The main floor restaurant unit is truly a showpiece; fully renovated into a luxurious fine dining establishment only four years ago. Lavishly finished with fine materials and truly beautiful design, the sprawling restaurant is licensed for 140 guests indoors and offers a huge, partially-covered 30-seat patio behind the building. In addition to the substantial renovations done to the main and lower levels, two of the apartments have been renovated, and additional work has been done two other units. Despite the residential rents being well below market, this exceptional building is being offered at a 5.5% cap rate. Located in the heart of the thriving James North arts and dining district, this building is surrounded by cafes, shops, and thousands of residential units under construction! It is also only a short walk to the financial core, the West Harbour GO station, and the $280 million arena project. It doesn't get better than this: location, cashflow, stability, and upside! ◀A true landmark, this stunning mixed-use property offers a fabulous investment with both strong appreciation and cashflow upside. Home to the iconic, well-estab ▶" +"Basement": array:1 [▶ 0 => "Partial Basement" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Rapscallion Rogue Eatery" +"CityRegion": "Beasley" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:30:14.768715+00:00" +"CrossStreet": "Located on the east side of James St N just north of Cannon St E" +"DirectionFaces": "West" +"Exclusions": "Chattels and fixtures of the restaurant and any/all tenant possessions." +"ExpirationDate": "2025-02-28" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"LotSizeDimensions": "152.65 x 37.42" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-24T12:40:06Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-10-24T12:40:06Z" +"OriginalListPrice": 3399000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653231" +"ParcelNumber": "171610022" +"PhotosChangeTimestamp": "2024-12-11T14:18:50Z" +"Roof": "Unknown" +"SeatingCapacity": "140" +"SecurityFeatures": array:1 [▶ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [▶ 0 => "List Salesperson" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "JAMES" +"StreetNumber": "178" +"StreetSuffix": "Street" +"TaxAnnualAmount": "15730.43" +"TaxAssessedValue": 580000 +"TaxBookNumber": "251802015505510" +"TaxLegalDescription": "PT LT 9 JAMES HUGHSON SURVEY (UNREGISTERED) E/S JAMES ST BTN CANNON & ROBERT STREETS AS IN VM190740, T/W VM190740; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "H - Community Shopping and Commercial" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"UnderContract": array:1 [▶ 0 => "Hot Water Heater" ] +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154303349" +"Exposure": "East" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 37.42 +"MediaChangeTimestamp": "2024-12-11T14:18:50Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404406')" +"HoldoverDays": 90 +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 152.65 +"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] ] +"ID": "141930" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 ▶ +post_id: "141937" +post_author: 1 +"ListingKey": "X9509515" +"ListingId": "X9509515" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:29:14Z" +"RFModificationTimestamp": "2025-04-26T17:13:35Z" +"ListPrice": 1450000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2911.0 +"City": "Huntsville" +"PostalCode": "P1H 1M1" +"UnparsedAddress": "90 West Road, Huntsville, On P1h 1m1" +"Coordinates": array:2 [▶ 0 => -79.2243822 1 => 45.3330462 ] +"Latitude": 45.3330462 +"Longitude": -79.2243822 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "FARIS TEAM REAL ESTATE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Top 5 Reasons You Will Love This Property: 1) Modern, well-maintained commercial building, currently operating as an OMFRA-approved bespoke ice cream manufacturing facility, ideally situated in the Town of Huntsville, offering easy access to Highway 11 and the heart of Muskoka 2) Featuring separate retail/cafe space with customer washrooms and direct access to the manufacturing area, offering versatility for a range of future business uses that can be easily customized to suit the buyer's needs 3) Equipped with a separate loading bay, along with commercial frozen food and cold storage rooms and additional office and food preparation areas 4) Ample off-road parking at both the front and rear of the property ensuring easy access for employees and customers 5) Added benefit of the owner relocating, ensuring vacant possession for the new buyer and zoned MU4 (mixed-use commercial/multiple residential), providing excellent opportunities for future growth and development in a thriving area. Age 10. Visit our website for more detailed information. ◀Top 5 Reasons You Will Love This Property: 1) Modern, well-maintained commercial building, currently operating as an OMFRA-approved bespoke ice cream manufactur ▶" +"BuildingAreaUnits": "Square Feet" +"Cooling": "Yes" +"CountyOrParish": "Muskoka" +"CreationDate": "2024-10-25T08:58:35.896615+00:00" +"CrossStreet": "Centre St N/West Rd" +"Exclusions": "Gelato Machines, Multiple Fridge and Cold Display Units, Stainless-Steel Work Units, Stainless-Steel Storage Units, Stainless-Steel Food Preparation Units." +"ExpirationDate": "2025-01-24" +"Inclusions": "HEPA Filter, HRV System, Walk-in Cold Room, Walk-in Freezer." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"MainOfficeKey": "239900" +"MajorChangeTimestamp": "2024-10-24T16:57:08Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-24T16:57:08Z" +"OriginalListPrice": 1450000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1631440" +"ParcelNumber": "480900109" +"PhotosChangeTimestamp": "2024-12-18T16:28:37Z" +"SecurityFeatures": array:1 [▶ 0 => "No" ] +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "West" +"StreetNumber": "90" +"StreetSuffix": "Road" +"TaxAnnualAmount": "10963.0" +"TaxLegalDescription": "PT LT 13 CON 2 CHAFFEY AS IN DM224501 EXCEPT PT 3 35R20019; HUNTSVILLE; THE DISTRICT MUNICIPALITY OF MUSKOKA" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Utilities": "Yes" +"VirtualTourURLUnbranded": "https://youtu.be/ga R-r ZSE9mk" +"Zoning": "MU4" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Multi-Use" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 128.12 +"Amps": 200 +"HeatType": "Gas Forced Air Closed" +"LotShape": "Irregular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9509515')" +"SalesBrochureUrl": "https://faristeam.ca/listings/90-west-road-huntsville-real-estate" +"HSTApplication": array:1 [▶ 0 => "Yes" ] +"RollNumber": "444202000810901" +"RetailArea": 2911.0 +"provider_name": "TRREB" +"LotDepth": 167.34 +"ParkingSpaces": 30 +"PossessionDetails": "Flexible" +"ShowingAppointments": "TLO" +"GarageType": "None" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2024-12-18T16:28:37Z" +"TaxType": "Annual" +"RentalItems": "None." +"HoldoverDays": 60 +"RetailAreaCode": "Sq Ft" +"Media": array:20 [▶ 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] ] +"ID": "141937" } ] +success: true +page_size: 9 +page_count: 13716 +count: 123440 +after_key: "" } "RF Response Time" => "0.3 seconds" ] "RF Cache Key: aedc4fe4ed3230344775e36191300659bab90fad310440e77b0baa61ba18d220" => array:1 [▶ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14480 ▶ +items: array:9 [▶ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14253 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904793" +"ListingId": "X11904793" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:22:41Z" +"RFModificationTimestamp": "2025-05-06T09:37:10Z" +"ListPrice": 450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 110.0 +"City": "Hamilton" +"PostalCode": "L8H 2W1" +"UnparsedAddress": "#6 - 279 Kenilworth Avenue, Hamilton, On L8h 2w1" +"Coordinates": array:2 [▶ 0 => -79.8113217 1 => 43.2371069 ] +"Latitude": 43.2371069 +"Longitude": -79.8113217 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "NEW AGE REAL ESTATE GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professionally Finished Executive Office Space In A Fully Renovated Office Building @ High Traffic Location. Easy Access-2 Min Drive To QEW & Red Hill Parkway. Walk To The Centre Mall On Barton. Private Parking! Office Amenities Are 24 Hour Office Access, Common Reception, Board Room & Cafeteria. Suitable For Professionals Like Lawyers, Accountants, And Mortgage Brokers! ◀Professionally Finished Executive Office Space In A Fully Renovated Office Building @ High Traffic Location. Easy Access-2 Min Drive To QEW & Red Hill Parkway. ▶" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [▶ 0 => "Professional Office" ] +"CityRegion": "Crown Point" +"CommunityFeatures": array:2 [▶ 0 => "Major Highway" 1 => "Public Transit" ] +"Cooling": array:1 [▶ 0 => "Yes" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T02:44:26.814926+00:00" +"CrossStreet": "Kenilworth/Barton" +"ExpirationDate": "2025-06-30" +"HeatingYN": true +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "61.91 x 95.00 Feet" +"MainOfficeKey": "379800" +"MajorChangeTimestamp": "2025-01-02T21:22:41Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-02T21:22:41Z" +"OriginalListPrice": 450.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1817198" +"PhotosChangeTimestamp": "2025-01-02T21:22:41Z" +"SecurityFeatures": array:1 [▶ 0 => "No" ] +"ShowingRequirements": array:1 [▶ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Kenilworth" +"StreetNumber": "279" +"StreetSuffix": "Avenue" +"TaxYear": "2025" +"TransactionBrokerCompensation": "Half month rent" +"TransactionType": "For Lease" +"UnitNumber": "6" +"Utilities": array:1 [▶ 0 => "Yes" ] +"Zoning": "Commercial" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"LotWidth": 61.91 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904793')" +"MinimumRentalTermMonths": 24 +"RetailArea": 110.0 +"provider_name": "TRREB" +"LotDepth": 95.0 +"ParkingSpaces": 1 +"MaximumRentalMonthsTerm": 60 +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"PriorMlsStatus": "Draft" +"PictureYN": true +"MediaChangeTimestamp": "2025-01-02T21:22:41Z" +"TaxType": "N/A" +"BoardPropertyType": "Com" +"HoldoverDays": 30 +"StreetSuffixCode": "Ave" +"MLSAreaDistrictOldZone": "X14" +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"OfficeApartmentArea": 110.0 +"MLSAreaMunicipalityDistrict": "Hamilton" +"PossessionDate": "2025-02-01" +"short_address": "Hamilton, ON L8H 2W1, CA" +"Media": array:8 [▶ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14216 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9194849" +"ListingId": "X9194849" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:15:32Z" +"RFModificationTimestamp": "2025-01-03T02:51:13Z" +"ListPrice": 180000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 545.0 +"City": "Bayham" +"PostalCode": "N0J 1Z0" +"UnparsedAddress": "6231 PLANK Rd, Bayham, Ontario N0J 1Z0" +"Coordinates": array:2 [▶ 0 => -80.788698 1 => 42.680097 ] +"Latitude": 42.680097 +"Longitude": -80.788698 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A Bright Idea! Act now on this affordable, attractive Commercial opportunity in downtown Vienna! Prime main street exposure guarantees maximum visibility plus its directly across the street from the villages beautiful Memorial Park providing reliable foot traffic. Situated on the scenic banks of the Big Otter Creek, Vienna is a quaint and friendly village with a longstanding/notable history. Its a mere 5 minute drive to Port Burwell & Lake Erie, just 20 minutes to Tillsonburg & offers easy 401 access. Great curb appeal and many recent updates in this low maintenance property with a generous 545+/- sf of bright, open, well-appointed space and on-site parking. The large picture window is ideal for showcasing your business! Currently laid out with a very spacious L-shaped primary retail/business space, a dedicated office/storage/staff room with 2nd entrance, large walk-in cooler/freezer that includes the refrigeration unit and 2-pce washroom with laundry provision. Included are: security cameras, a triple stainless steel sink & live edge front counter. Updates since 2022: exterior paint, heat pump, wall insulation, commercial grade vinyl cladding on walls and ceilings, new flooring, combination washer/dryer, refrigeration unit and LED lighting. The C1 zoning provides an extensive range of permitted uses a perfect fit for aspiring entrepreneurs and/or franchisees! Here you can launch your dream: retail outlet, professional office, specialty store, studio, salon, take-out, bakery or dining establishment! So many possibilities to establish your business in this well-maintained, versatile property in a fantastic location. Imagine the bright ideas you can bring to light here! ◀A Bright Idea! Act now on this affordable, attractive Commercial opportunity in downtown Vienna! Prime main street exposure guarantees maximum visibility plus i ▶" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [▶ 0 => "Retail Store Related" ] +"CityRegion": "Vienna" +"CommunityFeatures": array:1 [▶ 0 => "Recreation/Community Centre" ] +"Cooling": array:1 [▶ 0 => "Yes" ] +"CountyOrParish": "Elgin" +"CreationDate": "2024-07-27T02:40:01.547677+00:00" +"CrossStreet": "EDISON DRIVE" +"Exclusions": "2 Chest Freezers, Upright display Freezer, Display case, Stainless Steel Saw, Storefront signage," +"ExpirationDate": "2025-01-31" +"Inclusions": "Security Camera, Water Heater, triple stainless steel sink, Live edge front counter, Haier Washer/Dryer Combination, Refrigeration unit for the walk-in cooler/freezer, ◀Security Camera, Water Heater, triple stainless steel sink, Live edge front counter, Haier Washer/Dryer Combination, Refrigeration unit for the walk-in cooler/f ▶" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-26" +"MainOfficeKey": "355000" +"MajorChangeTimestamp": "2024-09-20T14:11:49Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-07-26T22:45:30Z" +"OriginalListPrice": 200000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1324634" +"ParcelNumber": "353320236" +"PhotosChangeTimestamp": "2024-07-26T22:45:30Z" +"PreviousListPrice": 200000.0 +"PriceChangeTimestamp": "2024-09-20T14:11:49Z" +"SecurityFeatures": array:1 [▶ 0 => "No" ] +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "PLANK" +"StreetNumber": "6231" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1169.28" +"TaxAssessedValue": 35500 +"TaxLegalDescription": "PT LT 2 W/S MAIN ST, 3 W/S MAIN ST PL 54 BAYHAM PT 1, 5 11R2970; BAYHAM" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [▶ 0 => "Yes" ] +"Zoning": "H-C1" +"TotalAreaCode": "Sq Ft" +"Community Code": "47.08.0008" +"lease": "Sale" +"class_name": "CommercialProperty" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Retail" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 55.25 +"Amps": 100 +"HeatType": "Other" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9194849')" +"HSTApplication": array:1 [▶ 0 => "Yes" ] +"RollNumber": "340100400103200" +"RetailArea": 545.0 +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 84.4 +"PossessionDetails": "FLEXIBLE" +"GarageType": "None" +"PriorMlsStatus": "New" +"MediaChangeTimestamp": "2024-08-22T15:50:50Z" +"TaxType": "Annual" +"RentalItems": "None" +"HoldoverDays": 60 +"RetailAreaCode": "Sq Ft" +"Media": array:23 [▶ 0 => array:11 [ …11] 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 {#14227 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10403858" +"ListingId": "W10403858" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:15:20Z" +"RFModificationTimestamp": "2025-01-03T02:51:32Z" +"ListPrice": 2495000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3720.0 +"City": "Oakville" +"PostalCode": "L6H 6K6" +"UnparsedAddress": "1688 Glenvista Drive, Oakville, On L6h 6k6" +"Coordinates": array:2 [▶ 0 => -79.688523847204 1 => 43.490968124308 ] +"Latitude": 43.490968124308 +"Longitude": -79.688523847204 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Nestled on one of Joshua Creek’s most sought-after streets, this charming family home boasts 3,720 sq ft of elegant living space on a premium, mature pie-shaped lot adjacent to serene greenspace. The backyard is a private oasis featuring a luxurious spa-like ambiance with an inground pool, hot tub, expansive terrace and a charming cedar pool hut. Inside, you'll find a spacious great room, a main floor office and soaring vaulted ceilings. Recent updates include new stainless-steel appliances, a custom front door (2021), roof (2013), windows (2011), furnace (2017), garage doors (2022), pool liner (2018) and driveway (2021). Additional highlights include 9-foot ceilings on the main floor, hardwood flooring and two inviting fireplaces. Ideally situated near top-rated schools, parks, walking trails and transit. This is a must-see! ◀Nestled on one of Joshua Creek’s most sought-after streets, this charming family home boasts 3,720 sq ft of elegant living space on a premium, mature pie-shaped ▶" +"ArchitecturalStyle": array:1 [▶ 0 => "2-Storey" ] +"Basement": array:2 [▶ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1009 - JC Joshua Creek" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:1 [▶ 0 => "Brick" ] +"Cooling": array:1 [▶ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-04T05:39:50.666208+00:00" +"CrossStreet": "Upper Middle Road E/Grand Blvd/Valleybrook/Glenvista" +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": array:1 [▶ 0 => "Hot Tub" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [▶ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Electric Light Fixtures, Window Coverings, GDO + Remotes, Hot Tub, Pool Equipment, CVAC & Attachments, Other ◀Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Electric Light Fixtures, Window Coverings, GDO + Remotes, Hot Tub, Pool Equipment, CVAC & Attachments, Othe ▶" +"InteriorFeatures": array:1 [▶ 0 => "Central Vacuum" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-06" +"LotFeatures": array:1 [▶ 0 => "Irregular Lot" ] +"LotSizeDimensions": "135.89 x 53.67" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-11-11T09:58:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-06T12:29:42Z" +"OriginalListPrice": 2595000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40641901" +"ParcelNumber": "250630508" +"ParkingFeatures": array:1 [▶ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-12-11T14:51:12Z" +"PoolFeatures": array:1 [▶ 0 => "Inground" ] +"PreviousListPrice": 2595000.0 +"PriceChangeTimestamp": "2024-11-11T09:58:37Z" +"PropertyAttachedYN": true +"Roof": array:1 [▶ 0 => "Asphalt Shingle" ] +"RoomsTotal": "15" +"Sewer": array:1 [▶ 0 => "Sewer" ] +"ShowingRequirements": array:2 [▶ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GLENVISTA" +"StreetNumber": "1688" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "10775.0" +"TaxAssessedValue": 1354000 +"TaxBookNumber": "240101002048410" +"TaxLegalDescription": "LOT 80, PLAN 20M636, S/T PT 6, 20R12115, AS IN H641267;OAKVILLE S/T RIGHT UNTIL THE LATER OF 2 YEARS FROM 96 08 26 OR UNTIL COMPLETE ASSUMPTION BY THE CORP OF THE TOWN OF OAKVILLE OF THE ROADS & SERVICES ON PLAN 20M636, AS IN H642731 S/T RT AS IN H695047 ◀LOT 80, PLAN 20M636, S/T PT 6, 20R12115, AS IN H641267;OAKVILLE S/T RIGHT UNTIL THE LATER OF 2 YEARS FROM 96 08 26 OR UNTIL COMPLETE ASSUMPTION BY THE CORP OF T ▶" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/155812626" +"Zoning": "RL5 sp:45" +"Water": "Municipal" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [▶ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 53.67 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403858')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [▶ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [▶ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 135.89 +"ParkingSpaces": 4 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "153491563" +"Exposure": "West" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Builder" +"MediaChangeTimestamp": "2024-12-11T14:51:12Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"LotIrregularities": "53.7x136.12x72.34x135.03'" +"ApproximateAge": "16-30" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"KitchensTotal": 1 +"Media": array:38 [▶ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] …33 ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14226 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10403750" +"ListingId": "W10403750" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:12:11Z" +"RFModificationTimestamp": "2025-01-03T02:56:10Z" +"ListPrice": 2799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3735.0 +"City": "Oakville" +"PostalCode": "L6J 4M5" +"UnparsedAddress": "273 Cairncroft Road, Oakville, On L6j 4m5" +"Coordinates": array:2 [ …2] +"Latitude": 43.4670675 +"Longitude": -79.6559923 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located in the heart of South East Oakville in one of the areas most sought after neighbourhoods, this home offers a gorgeous 100' x 154' lot with towering trees and complete privacy. Situated close to top ranked schools (OTHS, EJ James, Maple Grove, St Mildreds, Linbrook), parks, shopping and easy access to highways. The home offers 4 bedrooms, 3 baths, 2 fireplaces, solarium, hardwood floors, finished basement, double garage and more! Move in, renovate or build your dream home in a prime location. Call for further details on private viewing. ◀Located in the heart of South East Oakville in one of the areas most sought after neighbourhoods, this home offers a gorgeous 100' x 154' lot with towering tree ▶" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1011 - MO Morrison" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T22:16:04.872720+00:00" +"CrossStreet": "Lakeshore Rd E/Cairncroft Rd" +"DirectionFaces": "Unknown" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2025-01-16" +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, stove, dishwasher, washer, dryer, window coverings, electric light fixtures, garage door opener, CVAC (All chattels, fixtures and fireplaces in As Is condition), Other ◀Fridge, stove, dishwasher, washer, dryer, window coverings, electric light fixtures, garage door opener, CVAC (All chattels, fixtures and fireplaces in As Is co ▶" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-24" +"LotSizeDimensions": "154 x 100" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-11-08T15:42:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-24T10:57:22Z" +"OriginalListPrice": 2900000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40648192" +"ParcelNumber": "247970115" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-01-02T21:12:10Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 2900000.0 +"PriceChangeTimestamp": "2024-11-08T15:42:35Z" +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "17" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CAIRNCROFT" +"StreetNumber": "273" +"StreetSuffix": "Road" +"TaxAnnualAmount": "12900.0" +"TaxAssessedValue": 1621000 +"TaxBookNumber": "240104014004300" +"TaxLegalDescription": "LT 23, PL 1322 ; S/T 186027 OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/158738131" +"Zoning": "RL1-0" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ …1] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 3 +"LotWidth": 100.0 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403750')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 154.0 +"ParkingSpaces": 6 +"PossessionDetails": "Immediate" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154029332" +"Exposure": "East" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Plans" +"MediaChangeTimestamp": "2025-01-02T21:12:10Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"ApproximateAge": "51-99" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"KitchensTotal": 1 +"Media": array:40 [ …40] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11416 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10404239" +"ListingId": "W10404239" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:03:22Z" +"RFModificationTimestamp": "2025-01-03T03:04:59Z" +"ListPrice": 8499000.0 +"BathroomsTotalInteger": 8.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10020.0 +"City": "Oakville" +"PostalCode": "L6J 4B6" +"UnparsedAddress": "64 Brentwood Road, Oakville, On L6j 4b6" +"Coordinates": array:2 [ …2] +"Latitude": 43.456071902554 +"Longitude": -79.65474570396 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible custom-built home situated on a beautiful 100 x 162' lot with desirable SW exposure steps from the lake on one of Southeast Oakville's most coveted streets. The house is Michael Pettes designed and PCM built and offers incredible and hard to replicate features including over 10,000 square feet of living space with elegant and luxurious finishings throughout, an elevator, second floor balcony overlooking the back gardens and a triple car garage with soaring ceilings and a car lift. The interior's open concept floor plan and architectural nuances truly make this a one of a kind family home with too many features and finishings to list but includes 10' ceilings on main, a gorgeous central staircase open to all 3 levels, hardwood flooring and detailed millwork through out, custom gourmet kitchen overlooking expansive eat-in area and family room, large separate dining room with butler's servery, main floor office with built-ins and walk-out to covered porch, a peaceful primary retreat complete with a double door walk out to balcony, a sitting area, spectacular walk through closet and a luxurious 6-piece ensuite. The fabulously finished lower level has a double french door walk up, theatre room, exercise room, 5th bedroom, rec room with bar and walk-in wine cellar. The stunning back garden is complete with an inground pool and stone surround, outdoor 3-piece washroom, covered porch areas, outdoor kitchen and wood burning fireplace, cedar fencing and extensive landscaping providing a private oasis to enjoy. “Winco” natural gas powered backup generator. This truly is a one of a kind offering and a detailed feature brochure is available upon request. ◀Incredible custom-built home situated on a beautiful 100 x 162' lot with desirable SW exposure steps from the lake on one of Southeast Oakville's most coveted s ▶" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "1011 - MO Morrison" +"CoListOfficeKey": "540501" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "4.0" +"CreationDate": "2024-11-03T22:10:26.163194+00:00" +"CrossStreet": "Lakeshore Rd E/Brentwood Road" +"DirectionFaces": "Unknown" +"Exclusions": "Kitchen Pendant Lights, Backyard Sculpture, EV Charger." +"ExpirationDate": "2025-02-04" +"ExteriorFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "4" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All Kitchen Appliances, 2 Washers, 2 Dryers, All ELFs, All Window Coverings, Theatre Room TV & Surround Sound, CVAC & Equip, 2 Furnaces, 2 A/C, Irrigation Sys, Control 4 Sys, Pool Equip, Outdoor Kitchen, Garage Door Opener, Car Lift, Generator, Other ◀All Kitchen Appliances, 2 Washers, 2 Dryers, All ELFs, All Window Coverings, Theatre Room TV & Surround Sound, CVAC & Equip, 2 Furnaces, 2 A/C, Irrigation Sys, ▶" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListingContractDate": "2024-10-04" +"LotSizeDimensions": "162 x 100" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2024-10-04T16:13:24Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-04T16:13:24Z" +"OriginalListPrice": 8499000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40656583" +"ParcelNumber": "247820157" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2025-01-02T21:00:44Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "30" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "BRENTWOOD" +"StreetNumber": "64" +"StreetSuffix": "Road" +"TaxAnnualAmount": "35119.0" +"TaxAssessedValue": 4413000 +"TaxBookNumber": "240104011007500" +"TaxLegalDescription": "LT 5, PL 548 TOWN OF OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.helicopix.com/vd/159730596" +"Zoning": "RL1-0" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ …1] +"WashroomsType1": 2 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 5 +"WashroomsType4Pcs": 3 +"LotWidth": 100.0 +"HeatType": "Forced Air" +"WashroomsType4Level": "Second" +"WashroomsType3Pcs": 6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404239')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 162.0 +"ParkingSpaces": 8 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154485107" +"Exposure": "West" +"WashroomsType5Level": "Lower" +"WashroomsType5Pcs": 3 +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Plans" +"MediaChangeTimestamp": "2025-01-02T21:00:44Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"WashroomsType5": 2 +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"WashroomsType4": 1 +"KitchensTotal": 1 +"Media": array:40 [ …40] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14249 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9515967" +"ListingId": "X9515967" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T21:03:18Z" +"RFModificationTimestamp": "2025-01-03T03:04:59Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10560.0 +"City": "Rideau Lakes" +"PostalCode": "K0G 1V0" +"UnparsedAddress": "28 Colborne Street, Rideau Lakes, On K0g 1v0" +"Coordinates": array:2 [ …2] +"Latitude": 44.6982823 +"Longitude": -76.1898633 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER FIRST OTTAWA REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Grocery store with 10,500 sq ft and exposure on three roads. This store is located in the popular tourist destination of Portland Village, on shores of Big Rideau Lake with attractions such as swimming beaches, boat launches, houseboat rentals, Conservation Area and restaurants. The store has high visibility and signage on busy Hwy 15 that is major traffic route. Inside is 4,500sf grocery section plus deli, bakery, offices, loading dock and basement storage areas. Store also has half an acre, to grow your own produce. Fully equipped with all that you need to operate a one-stop shop, with large prep areas and lotto sales. All equipment included. Opportunity to improve profits with modernizing and increasing sales of local crafts, specialties and gourmet items. Electrical panels 1000 amps. Plenty of street parking available. Zoning is Local Commercial which allows for many uses. A gem with immense business potential, especially since nearest grocery store competitor is 15 min drive away. ◀Grocery store with 10,500 sq ft and exposure on three roads. This store is located in the popular tourist destination of Portland Village, on shores of Big Ride ▶" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Portland Foodmarket" +"BusinessType": array:1 [ …1] +"CityRegion": "818 - Rideau Lakes (Bastard) Twp" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Leeds & Grenville" +"CreationDate": "2024-10-29T06:36:46.135943+00:00" +"CrossStreet": "From Ottawa, Hwy 417. Exit Hwy 7. At Carleton Place left on Hwy 15 to Portland. Right Main St. Property fronts Hwy 15, Main St and Colborne St. From Kingston, east Hwy 401. North on Hwy 15. At Portland, property fronts Hwy 15, Main St & Colborne St. ◀From Ottawa, Hwy 417. Exit Hwy 7. At Carleton Place left on Hwy 15 to Portland. Right Main St. Property fronts Hwy 15, Main St and Colborne St. From Kingston, e ▶" +"DirectionFaces": "South" +"ExpirationDate": "2025-04-03" +"FrontageLength": "34.64" +"HoursDaysOfOperationDescription": "Variable" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-04" +"MainOfficeKey": "484400" +"MajorChangeTimestamp": "2024-07-04T10:21:33Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 1 +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-07-04T10:21:33Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "OREB" +"OriginatingSystemKey": "1399892" +"ParcelNumber": "441240180" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-01-02T21:02:53Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "oreb" +"SourceSystemName": "oreb" +"StateOrProvince": "ON" +"StreetName": "COLBORNE" +"StreetNumber": "28" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9150.0" +"TaxLegalDescription": "PT BLK PHILIP WING PL 27 AS IN LR371686; RIDEAU LAKES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://mikeclarkproductions.com/28-colborne-st" +"Zoning": "Local Commercial" +"Water": "Well" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Estimated" +"PropertyUse": "With Property" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"SurveyAvailableYN": true +"PortionPropertyLease": array:1 [ …1] +"LotWidth": 113.64 +"Amps": 1000 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9515967')" +"HSTApplication": array:1 [ …1] +"RollNumber": "083183103649700" +"SpecialDesignation": array:1 [ …1] +"RetailArea": 4410.0 +"ChattelsYN": true +"provider_name": "TRREB" +"LotDepth": 209.2 +"ParkingSpaces": 3 +"PossessionDetails": "TBD" +"GarageType": "Unknown" +"MediaListingKey": "38497700" +"ClearHeightInches": 11 +"MediaChangeTimestamp": "2025-01-02T21:02:54Z" +"TaxType": "Unknown" +"LotIrregularities": "0" +"HoldoverDays": 90 +"ClearHeightFeet": 10 +"RetailAreaCode": "Sq Ft" +"OfficeApartmentArea": 3800.0 +"Media": array:25 [ …25] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14250 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403376" +"ListingId": "X10403376" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:38:53Z" +"RFModificationTimestamp": "2025-01-03T03:31:41Z" +"ListPrice": 8999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 17985.0 +"City": "St. Catharines" +"PostalCode": "L2S 1M3" +"UnparsedAddress": "109 St. Paul Crescent, St. Catharines, On L2s 1m3" +"Coordinates": array:2 [ …2] +"Latitude": 43.14992455 +"Longitude": -79.245954005348 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Every once in a while, an opportunity presents itself to acquire a truly spectacular property; a property so unique and special, that it must be seen to be understood. Rodman Hall is such a property. Originally built in 1857 as a private home, and operated for years as an art gallery, this remarkable estate has been completely rebuilt into a breathtaking boutique hotel and banquet hall/events centre. Situated on a very private lot with over 7 acres overlooking downtown St. Catharines, this stunning facility offers 13 lavish hotel rooms and a variety of exquisite event spaces including meeting rooms, a large bar area, and a banquet hall that can accommodate up to 150+ seated guests. Anchored by a brand new state-of-the-art commercial kitchen, walk-in coolers, and a dock-level loading bay, the event facilities are ideal for banquets, corporate events, weddings, and more! The zoning allows for institutional uses as well. The sprawling grounds include a large parking lot, beautiful lawns, and a botanical forest with an outdoor amphitheatre and paths leading down to Twelve Mile Creek. The current owner recently completed a comprehensive renovation of the property; restoring and updating nearly every aspect of the building including electrical, HVAC, plumbing, roofing, mechanical and building systems as well as all of the bathrooms, surfaces, fixtures and the many opulent heritage elements. Custom high-grade carpet has even been installed on the grand staircase, bearing the crest of the original owner. No expense was spared in the renovation - a legacy project that truly was a labour of love. Now offered for sale, this landmark hold tremendous potential waiting to be realized! ◀Every once in a while, an opportunity presents itself to acquire a truly spectacular property; a property so unique and special, that it must be seen to be unde ▶" +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Rodman Hall" +"CityRegion": "458 - Western Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-04T05:40:46.738240+00:00" +"CrossStreet": "Located directly opposite downtown St. Catharines across the the Burgoyne Bridge and Twelve Mile Creek." +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:2 [ …2] +"Inclusions": "All property furnishings and furniture are to be included with the sale: all common area furniture, hotel room furniture, banquet hall chairs and tables, all kitchen fixtures and appliances. ◀All property furnishings and furniture are to be included with the sale: all common area furniture, hotel room furniture, banquet hall chairs and tables, all ki ▶" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-08" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-08-08T13:56:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-08T13:56:50Z" +"OriginalListPrice": 8999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40630641" +"ParcelNumber": "461820105" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-12-11T14:40:24Z" +"Roof": array:1 [ …1] +"SeatingCapacity": "200" +"SecurityFeatures": array:4 [ …4] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ST. PAUL" +"StreetNumber": "109" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "95000.0" +"TaxAssessedValue": 2739000 +"TaxBookNumber": "262902002014900" +"TaxLegalDescription": "PT LT 2150 CP PL 2 GRANTHAM AS IN RO815029; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://109stpaulcrescent.relahq.com/" +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"Zoning": "I1-122 & G1 with special provision" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"WaterFrontageFt": "597.0000" +"LotSizeRangeAcres": "5-9.99" +"PropertyUse": "With Property" +"GarageType": "Detached" +"MediaListingKey": "152771505" +"DockingType": array:1 [ …1] +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"MediaChangeTimestamp": "2024-12-11T14:40:24Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403376')" +"WaterBodyType": "Creek" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ShorelineAllowance": "None" +"ParkingSpaces": 4 +"Media": array:40 [ …40] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14251 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404406" +"ListingId": "X10404406" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:35:39Z" +"RFModificationTimestamp": "2025-04-29T15:07:47Z" +"ListPrice": 3399000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5522.0 +"City": "Hamilton" +"PostalCode": "L8R 2L1" +"UnparsedAddress": "178 James N Street, Hamilton, On L8r 2l1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2611788 +"Longitude": -79.8668752 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A true landmark, this stunning mixed-use property offers a fabulous investment with both strong appreciation and cashflow upside. Home to the iconic, well-established Rapscallion Restaurant on the main and basement levels, this building also includes five apartments on the upper floors. The main floor restaurant unit is truly a showpiece; fully renovated into a luxurious fine dining establishment only four years ago. Lavishly finished with fine materials and truly beautiful design, the sprawling restaurant is licensed for 140 guests indoors and offers a huge, partially-covered 30-seat patio behind the building. In addition to the substantial renovations done to the main and lower levels, two of the apartments have been renovated, and additional work has been done two other units. Despite the residential rents being well below market, this exceptional building is being offered at a 5.5% cap rate. Located in the heart of the thriving James North arts and dining district, this building is surrounded by cafes, shops, and thousands of residential units under construction! It is also only a short walk to the financial core, the West Harbour GO station, and the $280 million arena project. It doesn't get better than this: location, cashflow, stability, and upside! ◀A true landmark, this stunning mixed-use property offers a fabulous investment with both strong appreciation and cashflow upside. Home to the iconic, well-estab ▶" +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Rapscallion Rogue Eatery" +"CityRegion": "Beasley" +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:30:14.768715+00:00" +"CrossStreet": "Located on the east side of James St N just north of Cannon St E" +"DirectionFaces": "West" +"Exclusions": "Chattels and fixtures of the restaurant and any/all tenant possessions." +"ExpirationDate": "2025-02-28" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"LotSizeDimensions": "152.65 x 37.42" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-24T12:40:06Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-10-24T12:40:06Z" +"OriginalListPrice": 3399000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653231" +"ParcelNumber": "171610022" +"PhotosChangeTimestamp": "2024-12-11T14:18:50Z" +"Roof": array:1 [ …1] +"SeatingCapacity": "140" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "JAMES" +"StreetNumber": "178" +"StreetSuffix": "Street" +"TaxAnnualAmount": "15730.43" +"TaxAssessedValue": 580000 +"TaxBookNumber": "251802015505510" +"TaxLegalDescription": "PT LT 9 JAMES HUGHSON SURVEY (UNREGISTERED) E/S JAMES ST BTN CANNON & ROBERT STREETS AS IN VM190740, T/W VM190740; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "H - Community Shopping and Commercial" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"UnderContract": array:1 [ …1] +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154303349" +"Exposure": "East" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 37.42 +"MediaChangeTimestamp": "2024-12-11T14:18:50Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404406')" +"HoldoverDays": 90 +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 152.65 +"Media": array:17 [ …17] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14252 ▶ +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9509515" +"ListingId": "X9509515" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T20:29:14Z" +"RFModificationTimestamp": "2025-04-26T17:13:35Z" +"ListPrice": 1450000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2911.0 +"City": "Huntsville" +"PostalCode": "P1H 1M1" +"UnparsedAddress": "90 West Road, Huntsville, On P1h 1m1" +"Coordinates": array:2 [ …2] +"Latitude": 45.3330462 +"Longitude": -79.2243822 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "FARIS TEAM REAL ESTATE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Top 5 Reasons You Will Love This Property: 1) Modern, well-maintained commercial building, currently operating as an OMFRA-approved bespoke ice cream manufacturing facility, ideally situated in the Town of Huntsville, offering easy access to Highway 11 and the heart of Muskoka 2) Featuring separate retail/cafe space with customer washrooms and direct access to the manufacturing area, offering versatility for a range of future business uses that can be easily customized to suit the buyer's needs 3) Equipped with a separate loading bay, along with commercial frozen food and cold storage rooms and additional office and food preparation areas 4) Ample off-road parking at both the front and rear of the property ensuring easy access for employees and customers 5) Added benefit of the owner relocating, ensuring vacant possession for the new buyer and zoned MU4 (mixed-use commercial/multiple residential), providing excellent opportunities for future growth and development in a thriving area. Age 10. Visit our website for more detailed information. ◀Top 5 Reasons You Will Love This Property: 1) Modern, well-maintained commercial building, currently operating as an OMFRA-approved bespoke ice cream manufactur ▶" +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ …1] +"CountyOrParish": "Muskoka" +"CreationDate": "2024-10-25T08:58:35.896615+00:00" +"CrossStreet": "Centre St N/West Rd" +"Exclusions": "Gelato Machines, Multiple Fridge and Cold Display Units, Stainless-Steel Work Units, Stainless-Steel Storage Units, Stainless-Steel Food Preparation Units." +"ExpirationDate": "2025-01-24" +"Inclusions": "HEPA Filter, HRV System, Walk-in Cold Room, Walk-in Freezer." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"MainOfficeKey": "239900" +"MajorChangeTimestamp": "2024-10-24T16:57:08Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-24T16:57:08Z" +"OriginalListPrice": 1450000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1631440" +"ParcelNumber": "480900109" +"PhotosChangeTimestamp": "2024-12-18T16:28:37Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "West" +"StreetNumber": "90" +"StreetSuffix": "Road" +"TaxAnnualAmount": "10963.0" +"TaxLegalDescription": "PT LT 13 CON 2 CHAFFEY AS IN DM224501 EXCEPT PT 3 35R20019; HUNTSVILLE; THE DISTRICT MUNICIPALITY OF MUSKOKA" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://youtu.be/ga R-r ZSE9mk" +"Zoning": "MU4" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Multi-Use" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 128.12 +"Amps": 200 +"HeatType": "Gas Forced Air Closed" +"LotShape": "Irregular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9509515')" +"SalesBrochureUrl": "https://faristeam.ca/listings/90-west-road-huntsville-real-estate" +"HSTApplication": array:1 [ …1] +"RollNumber": "444202000810901" +"RetailArea": 2911.0 +"provider_name": "TRREB" +"LotDepth": 167.34 +"ParkingSpaces": 30 +"PossessionDetails": "Flexible" +"ShowingAppointments": "TLO" +"GarageType": "None" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2024-12-18T16:28:37Z" +"TaxType": "Annual" +"RentalItems": "None." +"HoldoverDays": 60 +"RetailAreaCode": "Sq Ft" +"Media": array:20 [ …20] } ] +success: true +page_size: 9 +page_count: 13716 +count: 123440 +after_key: "" } ] ]