Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114723&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114723&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114723&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114723&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14222 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14216 +post_id: "165352" +post_author: 1 +"ListingKey": "X9412016" +"ListingId": "X9412016" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:34:07Z" +"RFModificationTimestamp": "2024-12-21T00:22:14Z" +"ListPrice": 639900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3063.0 +"City": "St. Catharines" +"PostalCode": "L2R 7J2" +"UnparsedAddress": "243 Ontario Street, St. Catharines, On L2r 7j2" +"Coordinates": array:2 [ 0 => -79.2599619 1 => 43.163927 ] +"Latitude": 43.163927 +"Longitude": -79.2599619 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GARDEN CITY REALTY INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Four-plex, with major potential upside. 5 hydro meters. Ample parking spots. 5 bathrooms. New shingled roof 2021. All water heaters are owned. Apprx 3000+ sq ft of finished living space. Income from the billboard. Close proximity to former General Motor Lands. Close proximity to proposed large condominium site on Pleasant avenue. Bachelor. Two 1 bedrooms+dens. One 2 bedroom + den with a finished basement with living room and full bathroom, with entrance to the basement at the front of the house. Legal non confirming currently rented as 4 units, CITY RECOGNIZES BUILDING AS 5 UNITS." +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "451 - Downtown" +"CommunityFeatures": "Public Transit,Park" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T15:26:19.614795+00:00" +"CrossStreet": "ONTARIO STREET & BEECH STREET" +"DaysOnMarket": 364 +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:5 [ 0 => "Slab" 1 => "Block" 2 => "Other" 3 => "Concrete Block" 4 => "Poured Concrete" ] +"Inclusions": "None" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-07-09" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "75.1 x 128.74" +"MainOfficeKey": "056500" +"MajorChangeTimestamp": "2024-07-10T11:35:26Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-07-10T11:35:26Z" +"OriginalListPrice": 639900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40617842" +"ParcelNumber": "461870121" +"ParkingFeatures": "Other,Other" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T02:34:07Z" +"PoolFeatures": "None" +"Roof": "Other,Flat,Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ONTARIO" +"StreetNumber": "243" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5808.0" +"TaxAssessedValue": 396000 +"TaxBookNumber": "262904003004800" +"TaxLegalDescription": "PT LT 20 CON 5 GRANTHAM AS IN RO392047; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "E2" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 128.74 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9412016')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2023 +"provider_name": "TRREB" +"LotDepth": 75.1 +"ParkingSpaces": 4 +"PossessionDetails": "Other" +"LotSizeRangeAcres": "< .50" +"GarageType": "None" +"MediaListingKey": "151964399" +"Exposure": "West" +"MediaChangeTimestamp": "2024-11-17T02:34:07Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"Media": array:29 [ 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] ] +"ID": "165352" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14218 +post_id: "165354" +post_author: 1 +"ListingKey": "X9411990" +"ListingId": "X9411990" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:32:28Z" +"RFModificationTimestamp": "2025-04-26T23:01:54Z" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "K7L 4V4" +"UnparsedAddress": "0 Sunnyside Road, Kingston, On K7l 4v4" +"Coordinates": array:2 [ 0 => -76.5492464 1 => 44.2803847 ] +"Latitude": 44.2803847 +"Longitude": -76.5492464 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Rockwell Commercial Real Estate, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ 102.25 acres of rural land situated on the north side of Sunnyside Road just west of Sydenham Road and only ± 450 meters north of Highway 401. This location provides for a quiet rural setting with the convenience of being minutes away from all the amenities \r\n available in Kingston’s vibrant and growing west end. Approximately 25% of the property at the south end is cleared and presently being farmed. Buyer must assume and permit the current tenant (farmer) to continue using the land for the remainder of this crop season. """ +"BuildingAreaUnits": "Square Feet" +"CityRegion": "City North of 401" +"CoListOfficeKey": "470500" +"CoListOfficeName": "Rockwell Commercial Real Estate, Brokerage" +"CoListOfficePhone": "(613) 542-2724" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Frontenac" +"CreationDate": "2024-10-18T14:14:52.633463+00:00" +"CrossStreet": "Turn west off Sydenham Road" +"DaysOnMarket": 398 +"Exclusions": "Farmer's crops" +"ExpirationDate": "2024-11-26" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-10" +"LotSizeDimensions": "x 199" +"MainOfficeKey": "470500" +"MajorChangeTimestamp": "2024-10-08T00:10:33Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-06-10T14:49:13Z" +"OriginalListPrice": 1200000.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40603256" +"ParcelNumber": "361300239" +"PhotosChangeTimestamp": "2024-11-17T02:32:28Z" +"PoolFeatures": "None" +"PreviousListPrice": 1200000.0 +"PriceChangeTimestamp": "2024-08-08T16:50:27Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "None" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "SUNNYSIDE" +"StreetNumber": "0" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1639.94" +"TaxAssessedValue": 117000 +"TaxBookNumber": "101108025024700" +"TaxLegalDescription": "PT LT 16 CON 4 KINGSTON AS IN FR324717; DESCRIPTION MAY NOT BE ACCEPTABLE IN FUTURE AS IN FR324717; S/T TKY17286; KINGSTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.00%" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "https://tinyurl.com/sunnysidekingston" +"Zoning": "RU" +"Water": "None" +"PossessionDetails": "Other" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "100 +" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"Exposure": "North" +"ElectricYNA": "Available" +"ContractStatus": "Available" +"PriorMlsStatus": "New" +"ListPriceUnit": "For Sale" +"LotWidth": 199.0 +"MediaChangeTimestamp": "2024-11-17T02:32:28Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411990')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"Media": array:2 [ 0 => array:26 [ …26] 1 => array:26 [ …26] ] +"ID": "165354" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +post_id: "165357" +post_author: 1 +"ListingKey": "X9411923" +"ListingId": "X9411923" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:26:45Z" +"RFModificationTimestamp": "2025-04-25T16:48:34Z" +"ListPrice": 12.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5000.0 +"City": "St. Catharines" +"PostalCode": "L2M 6K4" +"UnparsedAddress": "9 Keefer Road Unit 2, St. Catharines, On L2m 6k4" +"Coordinates": array:2 [ 0 => -79.2050825 1 => 43.2226901 ] +"Latitude": 43.2226901 +"Longitude": -79.2050825 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Excellent Opportunity- 5,000 sq feet of warehouse and office space for lease in the low-vacancy Port Weller Industrial Park in North St. Catharines. Extremely clean warehouse/light industrial unit. Concrete block and steel construction. Warehouse features 13'-21' clear heights and 3 grade level shipping doors. Ample parking, multiple bathrooms and bonus Mezzanine space not included in the building square footage. Zoned E2 General Employment offering wide range of uses. Many recent capital upgrades have been made to the lot and building." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "436 - Port Weller" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T06:37:22.230776+00:00" +"CrossStreet": "Lakeshore Rd to Seaway Haulage Rd, turn north then east on Keefer Rd." +"DaysOnMarket": 381 +"ExpirationDate": "2024-11-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-19" +"LotSizeDimensions": "x 181" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-07-15T00:30:13Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-06-19T18:17:23Z" +"OriginalListPrice": 12.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40608682" +"ParcelNumber": "463010158" +"PhotosChangeTimestamp": "2024-11-17T02:26:45Z" +"PoolFeatures": "None" +"RentIncludes": array:3 [ 0 => "Building Insurance" 1 => "Parking" 2 => "Water" ] +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "KEEFER" +"StreetNumber": "9" +"StreetSuffix": "Road" +"TaxLegalDescription": "PT LT 31 CP PL 5 GRANTHAM PT 3, 30R1788 & PT 1, 30R2214; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5 + 2" +"TransactionType": "For Lease" +"UnitNumber": "2" +"Utilities": "Unknown" +"Zoning": "E2" +"Water": "Municipal" +"PossessionDetails": "90+Days" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": ".50-1.99" +"PropertyUse": "Unknown" +"IndustrialArea": 5000.0 +"GarageType": "Unknown" +"MediaListingKey": "151169449" +"ContractStatus": "Available" +"PriorMlsStatus": "Suspended" +"ListPriceUnit": "Other" +"LotWidth": 181.0 +"MediaChangeTimestamp": "2024-11-17T02:26:45Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411923')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"ContactAfterExpiryYN": true +"Media": array:21 [ 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] ] +"ID": "165357" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14219 +post_id: "165358" +post_author: 1 +"ListingKey": "X9411873" +"ListingId": "X9411873" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:22:34Z" +"RFModificationTimestamp": "2024-11-17T07:11:41Z" +"ListPrice": 3500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2468.0 +"City": "Niagara Falls" +"PostalCode": "L2G 5Z9" +"UnparsedAddress": "6032 Main Street, Niagara Falls, On L2g 5z9" +"Coordinates": array:2 [ 0 => -79.091718183333 1 => 43.087272638095 ] +"Latitude": 43.087272638095 +"Longitude": -79.091718183333 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Approximately 2468 sq ft of leasing space available in the heart of Niagara Falls. Surrounded by restaurants, shops, bus stops and around the corner from the farmers market that operates between May 14-October 29.This location brings high traffic count as well as tourism traffic. $3500/ month plus utilities. Ideal for retail or offices such as storefronts, clothing store, animal grooming, florist, fitness, gift shop, convenience store etc." +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T15:37:01.571941+00:00" +"CrossStreet": "Main Street" +"DaysOnMarket": 377 +"ExpirationDate": "2024-11-26" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-26" +"LotSizeDimensions": "101 x 57" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-06-28T10:20:28Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-06-28T10:20:28Z" +"OriginalListPrice": 3500.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40612265" +"ParcelNumber": "643490027" +"PhotosChangeTimestamp": "2024-11-17T02:22:34Z" +"PoolFeatures": "None" +"RentIncludes": array:3 [ 0 => "Heat" 1 => "Hydro" 2 => "Water" ] +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MAIN" +"StreetNumber": "6032" +"StreetSuffix": "Street" +"TaxAssessedValue": 378000 +"TaxBookNumber": "272507000203600" +"TaxLegalDescription": "PT LT 14 E/S PORTAGE RD, S OF PEER PL 653 ABSTRACTED AS BLK 14 VILLAGE OF NIAGARA FALLS AS IN NF28682, S/T NF28682 ; NIAGARA FALLS" +"TaxYear": "2022" +"TransactionBrokerCompensation": "1 months rent plus HST" +"TransactionType": "For Lease" +"Utilities": "Unknown" +"Zoning": "GC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "151407161" +"ContractStatus": "Available" +"ListPriceUnit": "Net Lease" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 57.0 +"MediaChangeTimestamp": "2024-11-17T02:22:34Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411873')" +"HoldoverDays": 90 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 12 +"AssessmentYear": 2022 +"provider_name": "TRREB" +"LotDepth": 101.0 +"Media": array:14 [ 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] ] +"ID": "165358" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14217 +post_id: "165359" +post_author: 1 +"ListingKey": "X9411825" +"ListingId": "X9411825" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:18:16Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 369000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Port Colborne" +"PostalCode": "L0S 1R0" +"UnparsedAddress": "3705 Hwy 3, R.r. #1 N/a" +"Coordinates": array:2 [ 0 => -79.159035 1 => 42.891453 ] +"Latitude": 42.891453 +"Longitude": -79.159035 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this one-acre rectangular piece of land located in close proximity to the beach, Centennial Park, and the Friendship Trail just off Silver Bay Rd. This property offers an ideal location for those seeking tranquility and privacy. With its generous size, this parcel presents endless possibilities for building your dream home or vacation retreat." +"ArchitecturalStyle": "Unknown" +"Basement": array:1 [ 0 => "Unknown" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "874 - Sherkston" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:1 [ 0 => "Unknown" ] +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T13:05:44.124517+00:00" +"CrossStreet": "Hwy 3 and Silver Bay Rd" +"DaysOnMarket": 384 +"DirectionFaces": "Unknown" +"ExpirationDate": "2024-11-30" +"InteriorFeatures": "Unknown" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-19" +"LotSizeDimensions": "308 x 130" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-06-19T08:21:28Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-06-19T08:21:28Z" +"OriginalListPrice": 369000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40604054" +"ParcelNumber": "644090064" +"ParkingFeatures": "Unknown" +"PhotosChangeTimestamp": "2024-11-17T02:18:16Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"Sewer": "None" +"ShowingRequirements": array:1 [ 0 => "Go Direct" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "HWY 3, R.R. #1" +"StreetNumber": "3705" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "1136.0" +"TaxAssessedValue": 62000 +"TaxBookNumber": "271104000204100" +"TaxLegalDescription": "PT LT 9 CON 1 HUMBERSTONE AS IN RO381297 ; PORT COLBORNE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% plus hst" +"TransactionType": "For Sale" +"Utilities": "None" +"Zoning": "RU1" +"Water": "None" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotSizeRangeAcres": ".50-1.99" +"GarageType": "Unknown" +"MediaListingKey": "150860545" +"Exposure": "North" +"HeatSource": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 130.0 +"MediaChangeTimestamp": "2024-11-17T02:18:16Z" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411825')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 308.0 +"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": "165359" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14214 +post_id: "165360" +post_author: 1 +"ListingKey": "X9411812" +"ListingId": "X9411812" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:17:09Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 8.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2198.0 +"City": "Kingston" +"PostalCode": "K7K 4H7" +"UnparsedAddress": "392 Alfred Street, Kingston, On K7k 4h7" +"Coordinates": array:2 [ 0 => -76.4978679 1 => 44.236978 ] +"Latitude": 44.236978 +"Longitude": -76.4978679 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Service First Realty Inc, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Dive into Kingston's thriving real estate market with this exceptional investment opportunity at 392 Alfred Street. Located in the sought-after Williamsville neighborhood, just steps from Princess Street, this two unit duplex with 8 total bedrooms, offers unbeatable proximity to Queen's University, Kingston transit, and local amenities. With two fully rented units, Unit 1 at $3,900/month inclusive and Unit 2 at $3,480/month inclusive, both leased until 2025, you'll enjoy guaranteed income and a solid ROI from day one. All rooms are spacious, and the property has been meticulously maintained, making this a smart and hassle-free addition to your portfolio." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "East of Sir John A. Blvd" +"CoListOfficeKey": "470200" +"CoListOfficeName": "RE/MAX Service First Realty Inc, Brokerage" +"CoListOfficePhone": "(613) 766-7650" +"CommunityFeatures": "Public Transit,Recreation/Community Centre" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Frontenac" +"CreationDate": "2024-10-19T21:48:58.422248+00:00" +"CrossStreet": "Princess St. to Alfred St." +"Exclusions": "tenant belongings" +"ExpirationDate": "2024-12-31" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Inclusions": "Carbon Monoxide Detector, Smoke Detector" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Ensuite" 1 => "Other" ] +"ListingContractDate": "2024-09-24" +"LotSizeDimensions": "132.05 x 33.01" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "470200" +"MajorChangeTimestamp": "2024-09-24T09:34:08Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-24T09:34:08Z" +"OriginalListPrice": 1250000.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40651738" +"ParcelNumber": "360720138" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T02:17:09Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALFRED" +"StreetNumber": "392" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5750.67" +"TaxBookNumber": "101105002004700" +"TaxLegalDescription": "PT LT 619 PL A12 KINGSTON CITY PT 1 & 2, 13R11726; S/T FR681537; T/W FR681537; KINGSTON ; THE COUNTY OF FRONTENAC" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% OF THE PURCHASE PRICE PLUS HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "URM7" +"Water": "Municipal" +"PossessionDetails": "Other" +"FreestandingYN": true +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Apartment" +"GarageType": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 33.01 +"MediaChangeTimestamp": "2024-11-17T02:17:09Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411812')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"LotDepth": 132.05 +"ParkingSpaces": 4 +"Media": array:48 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] +"ID": "165360" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14213 +post_id: "165362" +post_author: 1 +"ListingKey": "X9411801" +"ListingId": "X9411801" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:16:03Z" +"RFModificationTimestamp": "2024-11-17T07:13:07Z" +"ListPrice": 479900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2N 4R5" +"UnparsedAddress": "214 Lakeport Road, St. Catharines, On L2n 4r5" +"Coordinates": array:2 [ 0 => -79.2600511 1 => 43.1958735 ] +"Latitude": 43.1958735 +"Longitude": -79.2600511 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BOSLEY REAL ESTATE LTD., BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Since 1983, Preston Pies has been a beloved institution in St. Catharines' North End, and a destination for those seeking delicious British baked goods throughout the region. Their legacy spans over four decades, making them a true staple.\r\n \r\n They've built a loyal following by offering a delightful combination of tradition and taste. Freshly baked from scratch, their pies – both sweet and savory – are renowned for their quality ingredients and generous fillings. Whether you're craving a classic steak and kidney pie or a comforting chicken pot pie, Preston Pies delivers authentic British flavors with a local touch.\r\n \r\n But their offerings go beyond pies. They also boast a tempting selection of other British treats, from sausage rolls to biscuits and everything in between. It is now time for the family to move on, creating a great opportunity for the right investor to carry on this well loved family business. """ +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Lakeport Square" +"BusinessName": "Preston Pies" +"BusinessType": array:1 [ 0 => "Bakery" ] +"CityRegion": "443 - Lakeport" +"CoListOfficeKey": "063515" +"CoListOfficeName": "BOSLEY REAL ESTATE LTD., BROKERAGE" +"CoListOfficePhone": "905-397-0747" +"CommunityFeatures": "Recreation/Community Centre,Public Transit" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T13:09:26.758722+00:00" +"CrossStreet": "Plaza located at the corner of Linwell and Lakeport Roads." +"Exclusions": "Any landlord belongings." +"ExpirationDate": "2025-02-28" +"HoursDaysOfOperation": array:1 [ 0 => "Open 5 Days" ] +"HoursDaysOfOperationDescription": "40" +"Inclusions": "Any existing supplies, all equipment. Property is leased." +"InsuranceExpense": 1546.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-26" +"LotSizeDimensions": "x" +"MainOfficeKey": "063500" +"MaintenanceExpense": 7781.0 +"MajorChangeTimestamp": "2024-06-26T08:32:16Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 5 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-06-26T08:32:16Z" +"OriginalListPrice": 479900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40599768" +"OtherExpense": 164608.0 +"PhotosChangeTimestamp": "2024-11-17T02:16:03Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LAKEPORT" +"StreetNumber": "214" +"StreetSuffix": "Road" +"TaxLegalDescription": "CON 2 PT LOT 19" +"TransactionBrokerCompensation": "2.0%+hst" +"Utilities": "Unknown" +"Zoning": "C2" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Actual" +"PropertyUse": "Without Property" +"GarageType": "Unknown" +"MediaListingKey": "150584135" +"ContractStatus": "Available" +"MediaChangeTimestamp": "2024-11-17T02:16:03Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411801')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"FinancialStatementAvailableYN": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 500.0 +"RetailAreaCode": "Sq Ft" +"ChattelsYN": true +"provider_name": "TRREB" +"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": "165362" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14220 +post_id: "165363" +post_author: 1 +"ListingKey": "X9411781" +"ListingId": "X9411781" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:14:35Z" +"RFModificationTimestamp": "2024-11-17T07:13:09Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 9.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5768.0 +"City": "Thorold" +"PostalCode": "L2V 3N3" +"UnparsedAddress": "52 Queen S Street, Thorold, On L2v 3n3" +"Coordinates": array:2 [ 0 => -79.20486468 1 => 43.1217124 ] +"Latitude": 43.1217124 +"Longitude": -79.20486468 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "One of the best investment opportunities may be located at 52 Queen Street South in Thorold.\u{A0} This property has the potential for the owner to live in an\u{A0} immaculately kept 3200 square foot home while renting out two apartments along with a 3 car garage for storage.\u{A0}\u{A0}The main house boasts a large kitchen with breakfast table, a formal dining room, bright living room and a cozy family room with a dramatic stone fireplace.\u{A0} The main level also has a powder room, main floor laundry, and beautiful hardwood flooring.\u{A0} The second level consists of 4 bedrooms along with a 6 piece bathroom.\u{A0} The basement of the main house could easily be converted into a separate unit.\u{A0} This space includes a full kitchen, bedroom, bathroom and living space. Attached to the main house are two income units.\u{A0} These units are in excellent condition with fresh finishes.\u{A0} Each unit includes 2 bedrooms, 1 bathroom, private laundry within each unit, kitchen and living room.\u{A0} They each also have space for two parking spots, giving them the potential of easy, valuable rental units.\u{A0} This property also includes a 3 car deep garage, perfect for personal storage or the ability to rent this space for seasonal car storage.\u{A0} With the ability to earn rental income from a number of units, 52 Queen Street South is a great opportunity for long time property investors or first time home owners alike...the potential is unlimited." +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "557 - Thorold Downtown" +"CommunityFeatures": "Park" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": "Wall Unit(s)" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "3.0" +"CreationDate": "2024-10-30T13:13:10.668464+00:00" +"CrossStreet": "Sullivan Avenue to Queen Street South" +"DaysOnMarket": 399 +"Exclusions": "2 HWT's are rentals AND 1 HWT is owned." +"ExpirationDate": "2024-12-04" +"FoundationDetails": array:2 [ 0 => "Block" 1 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Built-in Microwave x4, Dishwasher x2, Dryer x3, Washer x3, Refrigerator x4, Stove x4,, Smoke Detector, Hot Water Tank Owned" +"InteriorFeatures": "Separate Heating Controls,Accessory Apartment" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-06-04" +"LotSizeDimensions": "132 x 77" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-06-04T06:34:07Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-06-04T06:34:07Z" +"OriginalListPrice": 1250000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40596367" +"ParcelNumber": "643940026" +"ParkingFeatures": "Other,Other" +"ParkingTotal": "15.0" +"PhotosChangeTimestamp": "2024-11-17T02:14:35Z" +"PoolFeatures": "None" +"Roof": "Asphalt Rolled,Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "QUEEN" +"StreetNumber": "52" +"StreetSuffix": "Street" +"TaxAnnualAmount": "8070.01" +"TaxAssessedValue": 510000 +"TaxBookNumber": "273100000811400" +"TaxLegalDescription": "PT LTS 16 & 17, BLK B, PL 892 AS IN RO705249 AS AMENDED BY RO705566 ; THOROLD" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST - Cooperating brokerage commission will b" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "R3" +"Water": "Municipal" +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"LotWidth": 77.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411781')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 132.0 +"ParkingSpaces": 12 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "150357140" +"Exposure": "East" +"MediaChangeTimestamp": "2024-11-17T02:14:35Z" +"TaxType": "Unknown" +"ApproximateAge": "31-50" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] +"ID": "165363" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14221 +post_id: "165364" +post_author: 1 +"ListingKey": "X9411737" +"ListingId": "X9411737" +"PropertyType": "Commercial" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:10:32Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 1998888.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1585.0 +"City": "Niagara-on-the-lake" +"PostalCode": "L0S 1J0" +"UnparsedAddress": "657 Concession 6 Road, Niagara-on-the-lake, On L0s 1j0" +"Coordinates": array:2 [ 0 => -79.134758 1 => 43.177635 ] +"Latitude": 43.177635 +"Longitude": -79.134758 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A truly exceptional rural property that stands out from the rest! Perfect for those seeking ample acreage, this property boasts an excellent location with convenient access to Niagara Falls, NOTL Old Town, and St. Catharines. The stunning rural setting includes a total of 10 acres of land, approximately 2 acres of lush grass, with the remaining 8 acres of land being flat and farmable. This property is truly unique with a 2 bedroom home allowing you to live on site and own the thriving Niagara Pet Resort, which is a successful business with historical sales in excess of $1 million. The resort offers a wide range of services including daycare, grooming, boarding, training, and an online store. Additionally, it features a 3,600 sq ft barn/workshop and a swimming pond for the dogs, making it an ideal setup for pet care and recreation. Don't miss out on this incredible opportunity to own a beautiful property and a lucrative business in a stunning rural setting!" +"ArchitecturalStyle": "Bungalow-Raised" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "105 - St. Davids" +"CoListOfficeKey": "292610" +"CoListOfficeName": "ROYAL LEPAGE NRC REALTY" +"CoListOfficePhone": "905-688-4561" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T16:46:29.475120+00:00" +"CrossStreet": "LINE 7 TO CONCESSION 6" +"DaysOnMarket": 406 +"ExpirationDate": "2024-12-31" +"Inclusions": "Other" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-05-28" +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-05-29T10:24:58Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-05-29T10:24:58Z" +"OriginalListPrice": 1998888.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40596465" +"ParcelNumber": "463720069" +"PhotosChangeTimestamp": "2024-11-17T02:10:32Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"RoomsTotal": "7" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Septic" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CONCESSION 6" +"StreetNumber": "657" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7431.91" +"TaxAssessedValue": 496000 +"TaxBookNumber": "262702001901600" +"TaxLegalDescription": "PT TWP LT 130 NIAGARA AS IN RO185403; NIAGARA-ON-THE-LAKE" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.0% PLUS HST. Note: Co-op brokerage commission wi" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Zoning": "A" +"Water": "Unknown" +"RoomsAboveGrade": 6 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Oil" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 1 +"FarmType": "Hobby" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411737')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"PossessionDetails": "30-59Days" +"LotSizeRangeAcres": "10-24.99" +"GarageType": "Unknown" +"MediaListingKey": "150362808" +"Exposure": "East" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2024-11-17T02:10:32Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"KitchensTotal": 1 +"Media": array:37 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] ] +"ID": "165364" } ] +success: true +page_size: 9 +page_count: 13599 +count: 122383 +after_key: "" } "RF Response Time" => "0.35 seconds" ] "RF Cache Key: 3fa10e65632138246e17e7fcc8cf83d27cf08c5c0c76b6cb374c6ec355b6b918" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14422 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9412016" +"ListingId": "X9412016" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:34:07Z" +"RFModificationTimestamp": "2024-12-21T00:22:14Z" +"ListPrice": 639900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3063.0 +"City": "St. Catharines" +"PostalCode": "L2R 7J2" +"UnparsedAddress": "243 Ontario Street, St. Catharines, On L2r 7j2" +"Coordinates": array:2 [ 0 => -79.2599619 1 => 43.163927 ] +"Latitude": 43.163927 +"Longitude": -79.2599619 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GARDEN CITY REALTY INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Four-plex, with major potential upside. 5 hydro meters. Ample parking spots. 5 bathrooms. New shingled roof 2021. All water heaters are owned. Apprx 3000+ sq ft of finished living space. Income from the billboard. Close proximity to former General Motor Lands. Close proximity to proposed large condominium site on Pleasant avenue. Bachelor. Two 1 bedrooms+dens. One 2 bedroom + den with a finished basement with living room and full bathroom, with entrance to the basement at the front of the house. Legal non confirming currently rented as 4 units, CITY RECOGNIZES BUILDING AS 5 UNITS." +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "451 - Downtown" +"CommunityFeatures": array:2 [ 0 => "Public Transit" 1 => "Park" ] +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T15:26:19.614795+00:00" +"CrossStreet": "ONTARIO STREET & BEECH STREET" +"DaysOnMarket": 364 +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:5 [ 0 => "Slab" 1 => "Block" 2 => "Other" 3 => "Concrete Block" 4 => "Poured Concrete" ] +"Inclusions": "None" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-07-09" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "75.1 x 128.74" +"MainOfficeKey": "056500" +"MajorChangeTimestamp": "2024-07-10T11:35:26Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-07-10T11:35:26Z" +"OriginalListPrice": 639900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40617842" +"ParcelNumber": "461870121" +"ParkingFeatures": array:2 [ 0 => "Other" 1 => "Other" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T02:34:07Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:3 [ 0 => "Other" 1 => "Flat" 2 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ONTARIO" +"StreetNumber": "243" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5808.0" +"TaxAssessedValue": 396000 +"TaxBookNumber": "262904003004800" +"TaxLegalDescription": "PT LT 20 CON 5 GRANTHAM AS IN RO392047; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "E2" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 128.74 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9412016')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2023 +"provider_name": "TRREB" +"LotDepth": 75.1 +"ParkingSpaces": 4 +"PossessionDetails": "Other" +"LotSizeRangeAcres": "< .50" +"GarageType": "None" +"MediaListingKey": "151964399" +"Exposure": "West" +"MediaChangeTimestamp": "2024-11-17T02:34:07Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"Media": array:29 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14200 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411990" +"ListingId": "X9411990" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:32:28Z" +"RFModificationTimestamp": "2025-04-26T23:01:54Z" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "K7L 4V4" +"UnparsedAddress": "0 Sunnyside Road, Kingston, On K7l 4v4" +"Coordinates": array:2 [ 0 => -76.5492464 1 => 44.2803847 ] +"Latitude": 44.2803847 +"Longitude": -76.5492464 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Rockwell Commercial Real Estate, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ 102.25 acres of rural land situated on the north side of Sunnyside Road just west of Sydenham Road and only ± 450 meters north of Highway 401. This location provides for a quiet rural setting with the convenience of being minutes away from all the amenities \r\n available in Kingston’s vibrant and growing west end. Approximately 25% of the property at the south end is cleared and presently being farmed. Buyer must assume and permit the current tenant (farmer) to continue using the land for the remainder of this crop season. """ +"BuildingAreaUnits": "Square Feet" +"CityRegion": "City North of 401" +"CoListOfficeKey": "470500" +"CoListOfficeName": "Rockwell Commercial Real Estate, Brokerage" +"CoListOfficePhone": "(613) 542-2724" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Frontenac" +"CreationDate": "2024-10-18T14:14:52.633463+00:00" +"CrossStreet": "Turn west off Sydenham Road" +"DaysOnMarket": 398 +"Exclusions": "Farmer's crops" +"ExpirationDate": "2024-11-26" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-10" +"LotSizeDimensions": "x 199" +"MainOfficeKey": "470500" +"MajorChangeTimestamp": "2024-10-08T00:10:33Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-06-10T14:49:13Z" +"OriginalListPrice": 1200000.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40603256" +"ParcelNumber": "361300239" +"PhotosChangeTimestamp": "2024-11-17T02:32:28Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 1200000.0 +"PriceChangeTimestamp": "2024-08-08T16:50:27Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "SUNNYSIDE" +"StreetNumber": "0" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1639.94" +"TaxAssessedValue": 117000 +"TaxBookNumber": "101108025024700" +"TaxLegalDescription": "PT LT 16 CON 4 KINGSTON AS IN FR324717; DESCRIPTION MAY NOT BE ACCEPTABLE IN FUTURE AS IN FR324717; S/T TKY17286; KINGSTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.00%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"VirtualTourURLUnbranded": "https://tinyurl.com/sunnysidekingston" +"Zoning": "RU" +"Water": "None" +"PossessionDetails": "Other" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "100 +" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"Exposure": "North" +"ElectricYNA": "Available" +"ContractStatus": "Available" +"PriorMlsStatus": "New" +"ListPriceUnit": "For Sale" +"LotWidth": 199.0 +"MediaChangeTimestamp": "2024-11-17T02:32:28Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411990')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"Media": array:2 [ 0 => array:26 [ …26] 1 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14211 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411923" +"ListingId": "X9411923" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:26:45Z" +"RFModificationTimestamp": "2025-04-25T16:48:34Z" +"ListPrice": 12.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5000.0 +"City": "St. Catharines" +"PostalCode": "L2M 6K4" +"UnparsedAddress": "9 Keefer Road Unit 2, St. Catharines, On L2m 6k4" +"Coordinates": array:2 [ 0 => -79.2050825 1 => 43.2226901 ] +"Latitude": 43.2226901 +"Longitude": -79.2050825 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Excellent Opportunity- 5,000 sq feet of warehouse and office space for lease in the low-vacancy Port Weller Industrial Park in North St. Catharines. Extremely clean warehouse/light industrial unit. Concrete block and steel construction. Warehouse features 13'-21' clear heights and 3 grade level shipping doors. Ample parking, multiple bathrooms and bonus Mezzanine space not included in the building square footage. Zoned E2 General Employment offering wide range of uses. Many recent capital upgrades have been made to the lot and building." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "436 - Port Weller" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T06:37:22.230776+00:00" +"CrossStreet": "Lakeshore Rd to Seaway Haulage Rd, turn north then east on Keefer Rd." +"DaysOnMarket": 381 +"ExpirationDate": "2024-11-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-19" +"LotSizeDimensions": "x 181" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-07-15T00:30:13Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-06-19T18:17:23Z" +"OriginalListPrice": 12.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40608682" +"ParcelNumber": "463010158" +"PhotosChangeTimestamp": "2024-11-17T02:26:45Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:3 [ 0 => "Building Insurance" 1 => "Parking" 2 => "Water" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "KEEFER" +"StreetNumber": "9" +"StreetSuffix": "Road" +"TaxLegalDescription": "PT LT 31 CP PL 5 GRANTHAM PT 3, 30R1788 & PT 1, 30R2214; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5 + 2" +"TransactionType": "For Lease" +"UnitNumber": "2" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "E2" +"Water": "Municipal" +"PossessionDetails": "90+Days" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": ".50-1.99" +"PropertyUse": "Unknown" +"IndustrialArea": 5000.0 +"GarageType": "Unknown" +"MediaListingKey": "151169449" +"ContractStatus": "Available" +"PriorMlsStatus": "Suspended" +"ListPriceUnit": "Other" +"LotWidth": 181.0 +"MediaChangeTimestamp": "2024-11-17T02:26:45Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411923')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"ContactAfterExpiryYN": true +"Media": array:21 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411873" +"ListingId": "X9411873" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:22:34Z" +"RFModificationTimestamp": "2024-11-17T07:11:41Z" +"ListPrice": 3500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2468.0 +"City": "Niagara Falls" +"PostalCode": "L2G 5Z9" +"UnparsedAddress": "6032 Main Street, Niagara Falls, On L2g 5z9" +"Coordinates": array:2 [ 0 => -79.091718183333 1 => 43.087272638095 ] +"Latitude": 43.087272638095 +"Longitude": -79.091718183333 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Approximately 2468 sq ft of leasing space available in the heart of Niagara Falls. Surrounded by restaurants, shops, bus stops and around the corner from the farmers market that operates between May 14-October 29.This location brings high traffic count as well as tourism traffic. $3500/ month plus utilities. Ideal for retail or offices such as storefronts, clothing store, animal grooming, florist, fitness, gift shop, convenience store etc." +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T15:37:01.571941+00:00" +"CrossStreet": "Main Street" +"DaysOnMarket": 377 +"ExpirationDate": "2024-11-26" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-26" +"LotSizeDimensions": "101 x 57" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-06-28T10:20:28Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-06-28T10:20:28Z" +"OriginalListPrice": 3500.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40612265" +"ParcelNumber": "643490027" +"PhotosChangeTimestamp": "2024-11-17T02:22:34Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:3 [ 0 => "Heat" 1 => "Hydro" 2 => "Water" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MAIN" +"StreetNumber": "6032" +"StreetSuffix": "Street" +"TaxAssessedValue": 378000 +"TaxBookNumber": "272507000203600" +"TaxLegalDescription": "PT LT 14 E/S PORTAGE RD, S OF PEER PL 653 ABSTRACTED AS BLK 14 VILLAGE OF NIAGARA FALLS AS IN NF28682, S/T NF28682 ; NIAGARA FALLS" +"TaxYear": "2022" +"TransactionBrokerCompensation": "1 months rent plus HST" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "GC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "151407161" +"ContractStatus": "Available" +"ListPriceUnit": "Net Lease" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 57.0 +"MediaChangeTimestamp": "2024-11-17T02:22:34Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411873')" +"HoldoverDays": 90 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 12 +"AssessmentYear": 2022 +"provider_name": "TRREB" +"LotDepth": 101.0 +"Media": array:14 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11409 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411825" +"ListingId": "X9411825" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:18:16Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 369000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Port Colborne" +"PostalCode": "L0S 1R0" +"UnparsedAddress": "3705 Hwy 3, R.r. #1 N/a" +"Coordinates": array:2 [ 0 => -79.159035 1 => 42.891453 ] +"Latitude": 42.891453 +"Longitude": -79.159035 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this one-acre rectangular piece of land located in close proximity to the beach, Centennial Park, and the Friendship Trail just off Silver Bay Rd. This property offers an ideal location for those seeking tranquility and privacy. With its generous size, this parcel presents endless possibilities for building your dream home or vacation retreat." +"ArchitecturalStyle": array:1 [ 0 => "Unknown" ] +"Basement": array:1 [ 0 => "Unknown" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "874 - Sherkston" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:1 [ 0 => "Unknown" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T13:05:44.124517+00:00" +"CrossStreet": "Hwy 3 and Silver Bay Rd" +"DaysOnMarket": 384 +"DirectionFaces": "Unknown" +"ExpirationDate": "2024-11-30" +"InteriorFeatures": array:1 [ 0 => "Unknown" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-19" +"LotSizeDimensions": "308 x 130" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-06-19T08:21:28Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-06-19T08:21:28Z" +"OriginalListPrice": 369000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40604054" +"ParcelNumber": "644090064" +"ParkingFeatures": array:1 [ 0 => "Unknown" ] +"PhotosChangeTimestamp": "2024-11-17T02:18:16Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:1 [ 0 => "Go Direct" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "HWY 3, R.R. #1" +"StreetNumber": "3705" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "1136.0" +"TaxAssessedValue": 62000 +"TaxBookNumber": "271104000204100" +"TaxLegalDescription": "PT LT 9 CON 1 HUMBERSTONE AS IN RO381297 ; PORT COLBORNE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% plus hst" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "None" ] +"Zoning": "RU1" +"Water": "None" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotSizeRangeAcres": ".50-1.99" +"GarageType": "Unknown" +"MediaListingKey": "150860545" +"Exposure": "North" +"HeatSource": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 130.0 +"MediaChangeTimestamp": "2024-11-17T02:18:16Z" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411825')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 308.0 +"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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14233 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411812" +"ListingId": "X9411812" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:17:09Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 8.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2198.0 +"City": "Kingston" +"PostalCode": "K7K 4H7" +"UnparsedAddress": "392 Alfred Street, Kingston, On K7k 4h7" +"Coordinates": array:2 [ 0 => -76.4978679 1 => 44.236978 ] +"Latitude": 44.236978 +"Longitude": -76.4978679 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Service First Realty Inc, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Dive into Kingston's thriving real estate market with this exceptional investment opportunity at 392 Alfred Street. Located in the sought-after Williamsville neighborhood, just steps from Princess Street, this two unit duplex with 8 total bedrooms, offers unbeatable proximity to Queen's University, Kingston transit, and local amenities. With two fully rented units, Unit 1 at $3,900/month inclusive and Unit 2 at $3,480/month inclusive, both leased until 2025, you'll enjoy guaranteed income and a solid ROI from day one. All rooms are spacious, and the property has been meticulously maintained, making this a smart and hassle-free addition to your portfolio." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "East of Sir John A. Blvd" +"CoListOfficeKey": "470200" +"CoListOfficeName": "RE/MAX Service First Realty Inc, Brokerage" +"CoListOfficePhone": "(613) 766-7650" +"CommunityFeatures": array:2 [ 0 => "Public Transit" 1 => "Recreation/Community Centre" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Frontenac" +"CreationDate": "2024-10-19T21:48:58.422248+00:00" +"CrossStreet": "Princess St. to Alfred St." +"Exclusions": "tenant belongings" +"ExpirationDate": "2024-12-31" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Inclusions": "Carbon Monoxide Detector, Smoke Detector" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Ensuite" 1 => "Other" ] +"ListingContractDate": "2024-09-24" +"LotSizeDimensions": "132.05 x 33.01" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "470200" +"MajorChangeTimestamp": "2024-09-24T09:34:08Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-24T09:34:08Z" +"OriginalListPrice": 1250000.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40651738" +"ParcelNumber": "360720138" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T02:17:09Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sanitary+Storm" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALFRED" +"StreetNumber": "392" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5750.67" +"TaxBookNumber": "101105002004700" +"TaxLegalDescription": "PT LT 619 PL A12 KINGSTON CITY PT 1 & 2, 13R11726; S/T FR681537; T/W FR681537; KINGSTON ; THE COUNTY OF FRONTENAC" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% OF THE PURCHASE PRICE PLUS HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "URM7" +"Water": "Municipal" +"PossessionDetails": "Other" +"FreestandingYN": true +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Apartment" +"GarageType": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 33.01 +"MediaChangeTimestamp": "2024-11-17T02:17:09Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411812')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"LotDepth": 132.05 +"ParkingSpaces": 4 +"Media": array:48 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411801" +"ListingId": "X9411801" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:16:03Z" +"RFModificationTimestamp": "2024-11-17T07:13:07Z" +"ListPrice": 479900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2N 4R5" +"UnparsedAddress": "214 Lakeport Road, St. Catharines, On L2n 4r5" +"Coordinates": array:2 [ 0 => -79.2600511 1 => 43.1958735 ] +"Latitude": 43.1958735 +"Longitude": -79.2600511 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BOSLEY REAL ESTATE LTD., BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Since 1983, Preston Pies has been a beloved institution in St. Catharines' North End, and a destination for those seeking delicious British baked goods throughout the region. Their legacy spans over four decades, making them a true staple.\r\n \r\n They've built a loyal following by offering a delightful combination of tradition and taste. Freshly baked from scratch, their pies – both sweet and savory – are renowned for their quality ingredients and generous fillings. Whether you're craving a classic steak and kidney pie or a comforting chicken pot pie, Preston Pies delivers authentic British flavors with a local touch.\r\n \r\n But their offerings go beyond pies. They also boast a tempting selection of other British treats, from sausage rolls to biscuits and everything in between. It is now time for the family to move on, creating a great opportunity for the right investor to carry on this well loved family business. """ +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Lakeport Square" +"BusinessName": "Preston Pies" +"BusinessType": array:1 [ 0 => "Bakery" ] +"CityRegion": "443 - Lakeport" +"CoListOfficeKey": "063515" +"CoListOfficeName": "BOSLEY REAL ESTATE LTD., BROKERAGE" +"CoListOfficePhone": "905-397-0747" +"CommunityFeatures": array:2 [ 0 => "Recreation/Community Centre" 1 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-30T13:09:26.758722+00:00" +"CrossStreet": "Plaza located at the corner of Linwell and Lakeport Roads." +"Exclusions": "Any landlord belongings." +"ExpirationDate": "2025-02-28" +"HoursDaysOfOperation": array:1 [ 0 => "Open 5 Days" ] +"HoursDaysOfOperationDescription": "40" +"Inclusions": "Any existing supplies, all equipment. Property is leased." +"InsuranceExpense": 1546.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-06-26" +"LotSizeDimensions": "x" +"MainOfficeKey": "063500" +"MaintenanceExpense": 7781.0 +"MajorChangeTimestamp": "2024-06-26T08:32:16Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 5 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-06-26T08:32:16Z" +"OriginalListPrice": 479900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40599768" +"OtherExpense": 164608.0 +"PhotosChangeTimestamp": "2024-11-17T02:16:03Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Unknown" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LAKEPORT" +"StreetNumber": "214" +"StreetSuffix": "Road" +"TaxLegalDescription": "CON 2 PT LOT 19" +"TransactionBrokerCompensation": "2.0%+hst" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "C2" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Actual" +"PropertyUse": "Without Property" +"GarageType": "Unknown" +"MediaListingKey": "150584135" +"ContractStatus": "Available" +"MediaChangeTimestamp": "2024-11-17T02:16:03Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411801')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"FinancialStatementAvailableYN": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 500.0 +"RetailAreaCode": "Sq Ft" +"ChattelsYN": true +"provider_name": "TRREB" +"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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411781" +"ListingId": "X9411781" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:14:35Z" +"RFModificationTimestamp": "2024-11-17T07:13:09Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 9.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5768.0 +"City": "Thorold" +"PostalCode": "L2V 3N3" +"UnparsedAddress": "52 Queen S Street, Thorold, On L2v 3n3" +"Coordinates": array:2 [ 0 => -79.20486468 1 => 43.1217124 ] +"Latitude": 43.1217124 +"Longitude": -79.20486468 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "One of the best investment opportunities may be located at 52 Queen Street South in Thorold.\u{A0} This property has the potential for the owner to live in an\u{A0} immaculately kept 3200 square foot home while renting out two apartments along with a 3 car garage for storage.\u{A0}\u{A0}The main house boasts a large kitchen with breakfast table, a formal dining room, bright living room and a cozy family room with a dramatic stone fireplace.\u{A0} The main level also has a powder room, main floor laundry, and beautiful hardwood flooring.\u{A0} The second level consists of 4 bedrooms along with a 6 piece bathroom.\u{A0} The basement of the main house could easily be converted into a separate unit.\u{A0} This space includes a full kitchen, bedroom, bathroom and living space. Attached to the main house are two income units.\u{A0} These units are in excellent condition with fresh finishes.\u{A0} Each unit includes 2 bedrooms, 1 bathroom, private laundry within each unit, kitchen and living room.\u{A0} They each also have space for two parking spots, giving them the potential of easy, valuable rental units.\u{A0} This property also includes a 3 car deep garage, perfect for personal storage or the ability to rent this space for seasonal car storage.\u{A0} With the ability to earn rental income from a number of units, 52 Queen Street South is a great opportunity for long time property investors or first time home owners alike...the potential is unlimited." +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "557 - Thorold Downtown" +"CommunityFeatures": array:1 [ 0 => "Park" ] +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Wall Unit(s)" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "3.0" +"CreationDate": "2024-10-30T13:13:10.668464+00:00" +"CrossStreet": "Sullivan Avenue to Queen Street South" +"DaysOnMarket": 399 +"Exclusions": "2 HWT's are rentals AND 1 HWT is owned." +"ExpirationDate": "2024-12-04" +"FoundationDetails": array:2 [ 0 => "Block" 1 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Built-in Microwave x4, Dishwasher x2, Dryer x3, Washer x3, Refrigerator x4, Stove x4,, Smoke Detector, Hot Water Tank Owned" +"InteriorFeatures": array:2 [ 0 => "Separate Heating Controls" 1 => "Accessory Apartment" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-06-04" +"LotSizeDimensions": "132 x 77" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-06-04T06:34:07Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-06-04T06:34:07Z" +"OriginalListPrice": 1250000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40596367" +"ParcelNumber": "643940026" +"ParkingFeatures": array:2 [ 0 => "Other" 1 => "Other" ] +"ParkingTotal": "15.0" +"PhotosChangeTimestamp": "2024-11-17T02:14:35Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:2 [ 0 => "Asphalt Rolled" 1 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "QUEEN" +"StreetNumber": "52" +"StreetSuffix": "Street" +"TaxAnnualAmount": "8070.01" +"TaxAssessedValue": 510000 +"TaxBookNumber": "273100000811400" +"TaxLegalDescription": "PT LTS 16 & 17, BLK B, PL 892 AS IN RO705249 AS AMENDED BY RO705566 ; THOROLD" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST - Cooperating brokerage commission will b" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "R3" +"Water": "Municipal" +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"LotWidth": 77.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411781')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 132.0 +"ParkingSpaces": 12 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "150357140" +"Exposure": "East" +"MediaChangeTimestamp": "2024-11-17T02:14:35Z" +"TaxType": "Unknown" +"ApproximateAge": "31-50" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] …44 ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9411737" +"ListingId": "X9411737" +"PropertyType": "Commercial Sale" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T02:10:32Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 1998888.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1585.0 +"City": "Niagara-on-the-lake" +"PostalCode": "L0S 1J0" +"UnparsedAddress": "657 Concession 6 Road, Niagara-on-the-lake, On L0s 1j0" +"Coordinates": array:2 [ …2] +"Latitude": 43.177635 +"Longitude": -79.134758 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A truly exceptional rural property that stands out from the rest! Perfect for those seeking ample acreage, this property boasts an excellent location with convenient access to Niagara Falls, NOTL Old Town, and St. Catharines. The stunning rural setting includes a total of 10 acres of land, approximately 2 acres of lush grass, with the remaining 8 acres of land being flat and farmable. This property is truly unique with a 2 bedroom home allowing you to live on site and own the thriving Niagara Pet Resort, which is a successful business with historical sales in excess of $1 million. The resort offers a wide range of services including daycare, grooming, boarding, training, and an online store. Additionally, it features a 3,600 sq ft barn/workshop and a swimming pond for the dogs, making it an ideal setup for pet care and recreation. Don't miss out on this incredible opportunity to own a beautiful property and a lucrative business in a stunning rural setting!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "105 - St. Davids" +"CoListOfficeKey": "292610" +"CoListOfficeName": "ROYAL LEPAGE NRC REALTY" +"CoListOfficePhone": "905-688-4561" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T16:46:29.475120+00:00" +"CrossStreet": "LINE 7 TO CONCESSION 6" +"DaysOnMarket": 406 +"ExpirationDate": "2024-12-31" +"Inclusions": "Other" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-05-28" +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-05-29T10:24:58Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-05-29T10:24:58Z" +"OriginalListPrice": 1998888.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40596465" +"ParcelNumber": "463720069" +"PhotosChangeTimestamp": "2024-11-17T02:10:32Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "7" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CONCESSION 6" +"StreetNumber": "657" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7431.91" +"TaxAssessedValue": 496000 +"TaxBookNumber": "262702001901600" +"TaxLegalDescription": "PT TWP LT 130 NIAGARA AS IN RO185403; NIAGARA-ON-THE-LAKE" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.0% PLUS HST. Note: Co-op brokerage commission wi" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"WaterSource": array:1 [ …1] +"Zoning": "A" +"Water": "Unknown" +"RoomsAboveGrade": 6 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Oil" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 1 +"FarmType": "Hobby" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9411737')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"PossessionDetails": "30-59Days" +"LotSizeRangeAcres": "10-24.99" +"GarageType": "Unknown" +"MediaListingKey": "150362808" +"Exposure": "East" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2024-11-17T02:10:32Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"KitchensTotal": 1 +"Media": array:37 [ …37] } ] +success: true +page_size: 9 +page_count: 13599 +count: 122383 +after_key: "" } ] ]