Fullscreen
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=114687&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114687&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114687&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=114687&$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: "165261" +post_author: 1 +"ListingKey": "X9413969" +"ListingId": "X9413969" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:12:23Z" +"RFModificationTimestamp": "2025-04-27T02:41:23Z" +"ListPrice": 1000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 500.0 +"City": "Port Colborne" +"PostalCode": "L3K 4E2" +"UnparsedAddress": "174 West Street, Port Colborne, On L3k 4e2" +"Coordinates": array:2 [ 0 => -79.2500475 1 => 42.8844636 ] +"Latitude": 42.8844636 +"Longitude": -79.2500475 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover an exceptional opportunity to establish your business in the heart of Port Colborne, right on bustling West Street. This prime location boasts unparalleled visibility and foot traffic, making it an ideal destination for both locals and tourists alike. Nestled near the picturesque Clarence Street bridge overlooking the canal, your establishment will benefit from stunning views of ships gracefully passing by, creating a unique and inviting atmosphere. This site is not only strategically positioned within a vibrant community but also surrounded by complementary businesses, enhancing its appeal as a go-to destination. With ample street parking and easy access, your business will attract a diverse clientele, from families enjoying a day out to tourists exploring the charm of Port Colborne. Whether you envision a cozy café, a trendy retail shop, or an engaging entertainment venue, this location offers endless possibilities. Capitalize on the scenic backdrop and dynamic environment to create an unforgettable experience for your customers. Don’t miss your chance to be part of this thriving locale! Landlord offering 3 months FREE rent to help with Tenant's improvements. Call for details." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:30:59.904376+00:00" +"CrossStreet": "Clarence Street to West Street" +"DaysOnMarket": 300 +"ExpirationDate": "2025-03-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x 20.5" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-25T13:34:10Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T13:34:10Z" +"OriginalListPrice": 1000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40651012" +"ParcelNumber": "641630091" +"PhotosChangeTimestamp": "2024-11-17T06:12:23Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "WEST" +"StreetNumber": "174" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 16 W/S WEST ST PL 987-989 PORT COLBORNE AS IN RO655552, S/T RO655552 CITY OF PORT COLBORNE" +"TransactionBrokerCompensation": "1/2 month's rent plus HST" +"TransactionType": "For Lease" +"Utilities": "Unknown" +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "154190037" +"ContractStatus": "Available" +"ListPriceUnit": "Gross Lease" +"LotWidth": 20.5 +"MediaChangeTimestamp": "2024-11-17T06:12:23Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413969')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:11 [ 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] ] +"ID": "165261" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14218 +post_id: "165262" +post_author: 1 +"ListingKey": "X9413961" +"ListingId": "X9413961" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:11:34Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 3700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Port Colborne" +"PostalCode": "L3K 4C8" +"UnparsedAddress": "56 & 62 West Street, Port Colborne, On L3k 4c8" +"Coordinates": array:2 [ 0 => -79.2496574 1 => 42.8798365 ] +"Latitude": 42.8798365 +"Longitude": -79.2496574 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention developers and builders! See this unique and spectacular waterfront opportunity and 'one of a kind' location along the canal Promenade of quaint downtown Port Colborne. Watch the ships passing by your doorstep from around the world through the Welland Canal to the Great Lakes! Walking distance to shops and restaurants; fabulous sandy beaches; marina; plus nearby to exciting Niagara Falls and the many Niagara on the Lake wineries. Buffalo and Hamilton airport are only an hour away! Well suited for townhouses, condo development or a boutique waterfront hotel. Presently has 2 existing buildings with a double detached garage." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:11:35.075925+00:00" +"CrossStreet": "Corner of West St. and Sugarloaf St. facing canal" +"DaysOnMarket": 299 +"ExpirationDate": "2024-12-31" +"Inclusions": "Call listing agent for inclusions." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-20" +"LotSizeDimensions": "165 x 99" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-20T14:36:51Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-09-20T14:36:51Z" +"OriginalListPrice": 3700000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40650764" +"ParcelNumber": "641630278" +"PhotosChangeTimestamp": "2024-11-17T06:11:34Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "WEST" +"StreetNumber": "56 & 62" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10852.0" +"TaxAssessedValue": 515000 +"TaxBookNumber": "271101001807300" +"TaxLegalDescription": "PT LT 1 W/S WEST ST PL 987-989 PORT COLBORNE AS IN RO506571 ; PORT COLBORNE and PT LTS 1 & 2 WEST SIDE OF WEST ST., PLAN 987-989, PT 1 PL 59R5984 CITY OF PORT COLBORNE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"WaterfrontFeatures": "Canal Front" +"WaterfrontYN": true +"Zoning": "DC" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"WaterFrontageFt": "0.0000" +"AccessToProperty": array:1 [ 0 => "Year Round Municipal Road" ] +"PropertyUse": "Unknown" +"GasYNA": "Yes" +"CableYNA": "Yes" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 99.0 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413961')" +"WaterBodyType": "Canal" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ShorelineAllowance": "None" +"LotDepth": 165.0 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154175558" +"Exposure": "West" +"DockingType": array:1 [ 0 => "None" ] +"ElectricYNA": "Yes" +"MediaChangeTimestamp": "2024-11-17T06:11:34Z" +"TaxType": "Unknown" +"RuralUtilities": array:1 [ 0 => "Street Lights" ] +"Media": array:16 [ 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] ] +"ID": "165262" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +post_id: "165263" +post_author: 1 +"ListingKey": "X9413891" +"ListingId": "X9413891" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:02:32Z" +"RFModificationTimestamp": "2025-04-25T23:06:33Z" +"ListPrice": 639000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Niagara Falls" +"PostalCode": "L2E 2B3" +"UnparsedAddress": "4394 Morrison Street, Niagara Falls, On L2e 2b3" +"Coordinates": array:2 [ 0 => -79.0654213 1 => 43.1046173 ] +"Latitude": 43.1046173 +"Longitude": -79.0654213 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "WISDOMAX REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Center Location in City of Niagara Falls. Near to the Niagara River, The City Hall, The Queen Street Business Center, The new grand opened Niagara University.... This is a very unique updated Duplex Up two story house. The main floor unit has a 2 bedrooms, 1 bathroom, 1 living room, 1 kitchen unit, occupants by the owner. The basement is fully finished with 1 bedroom, 1 bathroom, 1 large living room and the laundry room, occupants by the owner's son. The upper unit is a large 2 bedroom, 1 bathroom, 1 kitchen dining room , 1 living room, and 1 laundry room, separated hydro meet with the main floor unit, now occupants by the tenants. The tenants can stay, or move out by the closing day. Rental income is a great potential ! 3 parking spots on the side. Street parking is available, too. Must see!" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "210 - Downtown" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": "Other" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:32:07.704133+00:00" +"CrossStreet": "CORNER MORRISON ST & ONTARIO AVE" +"DaysOnMarket": 292 +"Exclusions": "Tenants Belongings." +"ExpirationDate": "2025-01-23" +"ExteriorFeatures": "Porch" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "Built-in Microwave, Window Coverings" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "73 x 31.4" +"MainOfficeKey": "471600" +"MajorChangeTimestamp": "2024-09-18T07:23:04Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-09-18T07:23:04Z" +"OriginalListPrice": 639000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40648790" +"ParcelNumber": "644450087" +"ParkingFeatures": "Private Double,Other" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-11-17T06:02:32Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MORRISON" +"StreetNumber": "4394" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3515.17" +"TaxAssessedValue": 206000 +"TaxBookNumber": "2725020001069000000" +"TaxLegalDescription": "PTL 15, PLAN 283, TOWN OF NIAGARA FALLS, AS IN RO757917; NIAGARA FALLS" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=BNGWi M5uu BE&ab_channel=Need Media" +"Zoning": "R2" +"Water": "Municipal" +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 31.4 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413891')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 73.0 +"ParkingSpaces": 3 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154057012" +"Exposure": "South" +"MediaChangeTimestamp": "2024-11-17T06:02:32Z" +"TaxType": "Unknown" +"UFFI": "No" +"HoldoverDays": 90 +"Media": array:32 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] ] +"ID": "165263" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14219 +post_id: "165265" +post_author: 1 +"ListingKey": "X9413859" +"ListingId": "X9413859" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:57:34Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 1089999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3708.0 +"City": "Thorold" +"PostalCode": "L2V 0A4" +"UnparsedAddress": "199 Tuliptree Road, Thorold, On L2v 0a4" +"Coordinates": array:2 [ 0 => -79.2334403 1 => 43.1123895 ] +"Latitude": 43.1123895 +"Longitude": -79.2334403 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 199 Tuliptree Rd. This beautiful home has over 3,700 square feet of living space, with every detail thoughtfully designed. The master bedroom has a luxurious ensuite and a large walk-in closet. The main floor layout is perfect, featuring a spacious family room and a large kitchen that both overlook the backyard. Relax under the covered deck while watching the kids swim in the saltwater pool. This home includes 4+1 bedrooms and 4 bathrooms. The fully finished basement has a big rec room, 5th bedroom, 4-piece bathroom, and cold cellar. All rooms are generous in size and nicely finished. Other features include a double car garage, gas fireplace, oversized windows for great backyard views, and main floor laundry. Don't miss out on this great property. Come see why it should be your next home!" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "558 - Confederation Heights" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T18:34:00.246627+00:00" +"CrossStreet": "From Richmond to Winterberry to Tuliptree" +"DaysOnMarket": 292 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"FireplaceFeatures": array:1 [ 0 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": "Unknown" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "112.25 x 47.49" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-18T12:05:34Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-18T12:05:34Z" +"OriginalListPrice": 1089999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40648068" +"ParcelNumber": "640430398" +"ParkingFeatures": "Private Double,Other" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T05:57:34Z" +"PoolFeatures": "Inground" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "16" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "TULIPTREE" +"StreetNumber": "199" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5800.0" +"TaxAssessedValue": 494000 +"TaxBookNumber": "273100002306208" +"TaxLegalDescription": "LOT 50, PLAN 59M353, THOROLD; S/T EASEMENT FOR ENTRY AS IN SN143310" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST" +"TransactionType": "For Sale" +"Zoning": "A" +"Water": "Municipal" +"RoomsAboveGrade": 11 +"KitchensAboveGrade": 1 +"UnderContract": array:2 [ 0 => "Alarm System" 1 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 5 +"PropertyFeatures": array:3 [ 0 => "Other" 1 => "Golf" 2 => "Fenced Yard" ] +"LotWidth": 47.49 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413859')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 112.25 +"ParkingSpaces": 2 +"PossessionDetails": "1-29Days" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154019757" +"Exposure": "South" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "LBO Provided" +"MediaChangeTimestamp": "2024-11-17T05:57:34Z" +"WashroomsType2Pcs": 4 +"ApproximateAge": "16-30" +"HoldoverDays": 30 +"WashroomsType3": 1 +"WashroomsType3Level": "Lower" +"KitchensTotal": 1 +"Media": array:49 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] ] +"ID": "165265" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14217 +post_id: "165267" +post_author: 1 +"ListingKey": "X9413842" +"ListingId": "X9413842" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:55:32Z" +"RFModificationTimestamp": "2025-04-26T17:40:04Z" +"ListPrice": 439900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2634.0 +"City": "St. Catharines" +"PostalCode": "L2R 2T3" +"UnparsedAddress": "23 Raymond Street, St. Catharines, On L2r 2t3" +"Coordinates": array:2 [ 0 => -79.2475724 1 => 43.1621912 ] +"Latitude": 43.1621912 +"Longitude": -79.2475724 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THE AGENCY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Existing Tri-plex for major renovation or demo for new building on this wanted R3 zoned lot in Downtown St. Catharine's. Many uses permitted." +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "451 - Downtown" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T12:35:34.031174+00:00" +"CrossStreet": "Welland Ave to Beecher St to Raymond St" +"DaysOnMarket": 303 +"ExpirationDate": "2025-02-28" +"ExteriorFeatures": "Porch,Private Entrance" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-09-16" +"LotSizeDimensions": "121 x 65" +"MainOfficeKey": "364200" +"MajorChangeTimestamp": "2024-10-15T12:30:04Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-17T14:18:15Z" +"OriginalListPrice": 449900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647776" +"ParcelNumber": "462210034" +"ParkingFeatures": "Private" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2024-11-17T05:55:32Z" +"PoolFeatures": "None" +"PreviousListPrice": 449900.0 +"PriceChangeTimestamp": "2024-10-15T12:30:04Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "RAYMOND" +"StreetNumber": "23" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3865.0" +"TaxAssessedValue": 220000 +"TaxBookNumber": "262904001008800" +"TaxLegalDescription": "LT 542 CP PL 2 GRANTHAM; ST. CATHARINES" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"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" +"LotWidth": 65.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413842')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 121.0 +"ParkingSpaces": 1 +"PossessionDetails": "Vacant/Imme..." +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154003915" +"Exposure": "North" +"MediaChangeTimestamp": "2024-11-17T05:55:32Z" +"TaxType": "Unknown" +"HoldoverDays": 90 +"Media": array:4 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] ] +"ID": "165267" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14214 +post_id: "165269" +post_author: 1 +"ListingKey": "X9413822" +"ListingId": "X9413822" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:52:49Z" +"RFModificationTimestamp": "2025-04-25T15:01:57Z" +"ListPrice": 99000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Niagara Falls" +"PostalCode": "L2H 1H1" +"UnparsedAddress": "8040 Lundys Lane Unit 2, Niagara Falls, On L2h 1h1" +"Coordinates": array:2 [ 0 => -79.1325893 1 => 43.0887821 ] +"Latitude": 43.0887821 +"Longitude": -79.1325893 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step into a premier opportunity to own a stunning, turn-key hair salon in the heart of the vibrant Niagara Falls community. This beautifully renovated salon offers a perfect blend of modern elegance and functional design, making it an ideal choice for both seasoned professionals and aspiring salon owners. With it’s contemporary design, enjoy a fresh, inviting atmosphere with chic finishes and high-end fixtures. The salon features sleek cabinetry, stylish lighting, and comfortable, contemporary furnishings that create a welcoming environment for both clients and staff. Fully equipped with top-of-the-line tools and appliances, including luxury styling chairs, professional-grade hair dryers, and cutting-edge color stations. The facility includes a fully functional washroom, staff break room, and ample storage space. Situated in a high-traffic area of Niagara Falls, the salon benefits from excellent visibility and foot traffic. Its proximity to popular attractions, shopping areas, and residential neighborhoods ensures a steady flow of potential clients." +"BuildingAreaUnits": "Square Feet" +"BuildingName": "SPIGI D'ORO PLAZA" +"BusinessName": "Lush & Lavished Hair Studio" +"CityRegion": "218 - West Wood" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:02:37.963461+00:00" +"CrossStreet": "Between Kalar and Montrose Rd" +"DaysOnMarket": 295 +"DirectionFaces": "North" +"ExpirationDate": "2025-01-31" +"HoursDaysOfOperationDescription": """ Monday Closed\r\n Tuesday Closed\r\n Wednesday 10a.m.–3p.m.\r\n Thursday 10a.m.–8p.m.\r\n Friday 10a.m.–5p.m.\r\n Saturday 10a.m.–4:30p.m.\r\n Sunday Closed """ +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-15" +"LotSizeDimensions": "x" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-09-15T14:43:31Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-15T14:43:31Z" +"OriginalListPrice": 99000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647327" +"PhotosChangeTimestamp": "2024-11-17T05:52:49Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LUNDYS" +"StreetNumber": "8040" +"StreetSuffix": "Lane" +"TransactionBrokerCompensation": "2.0% + HST - Cooperating brokerage commission will" +"UnitNumber": "2" +"Utilities": "Unknown" +"Zoning": "R1D, TC" +"Water": "Unknown" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "153977690" +"Exposure": "South" +"ContractStatus": "Available" +"MediaChangeTimestamp": "2024-11-17T05:52:49Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413822')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"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": "165269" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14213 +post_id: "165271" +post_author: 1 +"ListingKey": "X9413732" +"ListingId": "X9413732" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:43:07Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2661.0 +"City": "Welland" +"PostalCode": "L3B 1Y7" +"UnparsedAddress": "87 Southworth Street, Welland, On L3b 1y7" +"Coordinates": array:2 [ 0 => -79.2358404 1 => 42.9801597 ] +"Latitude": 42.9801597 +"Longitude": -79.2358404 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This exceptional property features a spacious duplex with a potential third unit already equipped with a third kitchen and bathroom, offering versatile living arrangements or rental opportunities. Each level has its own washer and dryer hookups, enhancing convenience for all residents. Additional highlights include a 2-car garage and ample parking space, ensuring easy access and accommodation for multiple vehicles. With its prime location and flexible layout, this property presents an outstanding investment opportunity you won’t want to miss. Act quickly to secure this unique find!" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Partially Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "773 - Lincoln/Crowland" +"CommunityFeatures": "Public Transit,Park" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Metal/Steel Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T19:18:40.077876+00:00" +"CrossStreet": "LINCOLN TO SOUTHWORTH" +"DaysOnMarket": 307 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ElectricExpense": 1512.0 +"ExpirationDate": "2024-12-31" +"ExteriorFeatures": "Awnings,Deck,Lighting,Private Entrance" +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Smoke Detector" +"InteriorFeatures": "Accessory Apartment,Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-12" +"LotSizeDimensions": "108 x 50" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-09-12T11:30:58Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OperatingExpense": "9120.0" +"OriginalEntryTimestamp": "2024-09-12T11:30:58Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40645335" +"ParcelNumber": "641190366" +"ParkingFeatures": "Private Double,Other" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T05:43:07Z" +"PoolFeatures": "None" +"Roof": "Asphalt Rolled" +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "SOUTHWORTH" +"StreetNumber": "87" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3162.0" +"TaxAssessedValue": 180000 +"TaxBookNumber": "271905001200900" +"TaxLegalDescription": "LT 612 PL 951; PT LTS 611 & 613 PL 951 AS IN RO664527 ; WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "RL2" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Estimated" +"PropertyUse": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 50.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413732')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 108.0 +"ParkingSpaces": 4 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Detached" +"MediaListingKey": "153831740" +"Exposure": "East" +"LeaseToOwnEquipment": array:3 [ 0 => "Air Conditioner" 1 => "Furnace" 2 => "Water Heater" ] +"MediaChangeTimestamp": "2024-11-17T05:43:07Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"HoldoverDays": 60 +"HeatingExpenses": 2553.0 +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] +"ID": "165271" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14220 +post_id: "165273" +post_author: 1 +"ListingKey": "X9413651" +"ListingId": "X9413651" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:36:52Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 2875.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1561.0 +"City": "Port Colborne" +"PostalCode": "L3K 4G3" +"UnparsedAddress": "149 King Street, Port Colborne, On L3k 4g3" +"Coordinates": array:2 [ 0 => -79.2509483 1 => 42.8837401 ] +"Latitude": 42.8837401 +"Longitude": -79.2509483 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Property in Port Colborne Welcome to 149 King Street, Port Colborne. A solid standalone building offering an impressive 2,760 sqft of versatile space. This property features a spacious ground floor of 1,540 sqft and a 1,200 sqft basement, ideal for a variety of business needs. **Key Features:** - **Exceptional Structure:** Well-built standalone building with abundant natural light from numerous windows. - **Prime Location:** Situated on a corner lot, providing excellent visibility and prime opportunities for signage. - **Versatile Usage:** Perfect for franchises or a variety of business types. - **Proximity to Amenities:** Just steps away from the Welland Canal and the bustling downtown core. - **Growing Community:** Surrounded by residential housing and newly developed condos. - **Tourist Hub:** Located in the heart of Port Colborne’s tourism, shopping, and restaurant district. - **Future Developments:** Close to the upcoming Waterfront revitalization and planned cruise ship terminal. **Zoning and Permitted Uses:** This property is located in a Downtown Commercial Zone (DC), which allows for diverse business opportunities, including: - Animal Care Establishment - Public Brew Pub - Day Care - Medical Clinic - Office Spaces - Personal Service Business - Banquet Hall - Place of Worship - Private Club - Public Use - Recreation Facility - Restaurants (Fast Food, Full-Service, Take-Out) - Retail Stores - Service Commercial - Social Service Facility - Studio - Veterinary Clinic Whether you're looking to establish a new business or expand an existing one, 149 King Street offers a unique opportunity in a vibrant and growing community. Don’t miss out on this prime commercial property in the heart of Port Colborne." +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:50:43.752340+00:00" +"CrossStreet": "MAIN STREET TO KING STREET" +"DaysOnMarket": 311 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-09" +"LotSizeDimensions": "x 49" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-09-09T11:38:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-09T11:38:58Z" +"OriginalListPrice": 2875.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40643807" +"ParcelNumber": "641630140" +"PhotosChangeTimestamp": "2024-11-17T05:36:52Z" +"PoolFeatures": "None" +"RentIncludes": array:1 [ 0 => "Building Insurance" ] +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "KING" +"StreetNumber": "149" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 2 S/S KENT ST PL 987-989 PORT COLBORNE AS IN RO724480 ; PORT COLBORNE" +"TransactionBrokerCompensation": "HALF A MONTHS RENT" +"TransactionType": "For Lease" +"Utilities": "Unknown" +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "153739661" +"ContractStatus": "Available" +"ListPriceUnit": "Gross Lease" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 49.0 +"MediaChangeTimestamp": "2024-11-17T05:36:52Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413651')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 12 +"provider_name": "TRREB" +"Media": array:23 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] ] +"ID": "165273" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14221 +post_id: "165276" +post_author: 1 +"ListingKey": "X9413615" +"ListingId": "X9413615" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:34:01Z" +"RFModificationTimestamp": "2025-04-26T19:12:25Z" +"ListPrice": 1700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2100.0 +"City": "Pelham" +"PostalCode": "L0S 1E4" +"UnparsedAddress": "156 Hwy 20 W N/a, Pelham, On L0s 1e4" +"Coordinates": array:2 [ 0 => -79.297919 1 => 43.043487 ] +"Latitude": 43.043487 +"Longitude": -79.297919 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Rare opportunity to invest in one of the fastest growing areas of the Niagara Region.\r\n \r\n This versatile Downtown Commercial building with just over 2000 sq ft and ample parking , currently operating as a professional office, offers a unique development opportunity.\r\n Located in a bustling area with high visibility and easy access, this property is perfect for attracting a steady stream of clients. Whether you want to continue the existing configuration, expand or bring your professional vision to life, this building offers endless possibilities in a prime location.\r\n Property must be purchased along with 1410 Haist Street ( adjacent property). Architectural image for illustration purpose only. Environmental, Archeological, Traffic Triangle and Noise , and preconstruction meeting completed.\r\n Call today for more details. Please do not visit the property without confirmed appointment. """ +"Basement": array:1 [ 0 => "Partial Basement" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "662 - Fonthill" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:58:09.878864+00:00" +"CrossStreet": "Highway 20 west at Haist Street" +"DaysOnMarket": 303 +"ExpirationDate": "2025-02-07" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-08" +"LotSizeDimensions": "344.29 x 56.13" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-10T13:08:50Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-10T13:08:50Z" +"OriginalListPrice": 1700000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40643165" +"ParcelNumber": "640340087" +"PhotosChangeTimestamp": "2024-11-17T05:34:01Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "HWY 20 W" +"StreetNumber": "156" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "13708.86" +"TaxAssessedValue": 424000 +"TaxBookNumber": "273202000105701" +"TaxLegalDescription": "PT LT 116 PL 717 FONTHILL PT 1 59R3555; PELHAM" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "153702046" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 56.13 +"MediaChangeTimestamp": "2024-11-17T05:34:01Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413615')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 344.29 +"Media": array:6 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] +"ID": "165276" } ] +success: true +page_size: 9 +page_count: 13598 +count: 122382 +after_key: "" } "RF Response Time" => "0.48 seconds" ] "RF Cache Key: f16037ffcc0037a24a5e713dbd39dec281abfae3306a58532747eaabff67019c" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14421 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413969" +"ListingId": "X9413969" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:12:23Z" +"RFModificationTimestamp": "2025-04-27T02:41:23Z" +"ListPrice": 1000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 500.0 +"City": "Port Colborne" +"PostalCode": "L3K 4E2" +"UnparsedAddress": "174 West Street, Port Colborne, On L3k 4e2" +"Coordinates": array:2 [ 0 => -79.2500475 1 => 42.8844636 ] +"Latitude": 42.8844636 +"Longitude": -79.2500475 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover an exceptional opportunity to establish your business in the heart of Port Colborne, right on bustling West Street. This prime location boasts unparalleled visibility and foot traffic, making it an ideal destination for both locals and tourists alike. Nestled near the picturesque Clarence Street bridge overlooking the canal, your establishment will benefit from stunning views of ships gracefully passing by, creating a unique and inviting atmosphere. This site is not only strategically positioned within a vibrant community but also surrounded by complementary businesses, enhancing its appeal as a go-to destination. With ample street parking and easy access, your business will attract a diverse clientele, from families enjoying a day out to tourists exploring the charm of Port Colborne. Whether you envision a cozy café, a trendy retail shop, or an engaging entertainment venue, this location offers endless possibilities. Capitalize on the scenic backdrop and dynamic environment to create an unforgettable experience for your customers. Don’t miss your chance to be part of this thriving locale! Landlord offering 3 months FREE rent to help with Tenant's improvements. Call for details." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:30:59.904376+00:00" +"CrossStreet": "Clarence Street to West Street" +"DaysOnMarket": 300 +"ExpirationDate": "2025-03-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x 20.5" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-25T13:34:10Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T13:34:10Z" +"OriginalListPrice": 1000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40651012" +"ParcelNumber": "641630091" +"PhotosChangeTimestamp": "2024-11-17T06:12:23Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"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": "WEST" +"StreetNumber": "174" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 16 W/S WEST ST PL 987-989 PORT COLBORNE AS IN RO655552, S/T RO655552 CITY OF PORT COLBORNE" +"TransactionBrokerCompensation": "1/2 month's rent plus HST" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "154190037" +"ContractStatus": "Available" +"ListPriceUnit": "Gross Lease" +"LotWidth": 20.5 +"MediaChangeTimestamp": "2024-11-17T06:12:23Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413969')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:11 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14200 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413961" +"ListingId": "X9413961" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:11:34Z" +"RFModificationTimestamp": "2025-04-25T16:53:49Z" +"ListPrice": 3700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Port Colborne" +"PostalCode": "L3K 4C8" +"UnparsedAddress": "56 & 62 West Street, Port Colborne, On L3k 4c8" +"Coordinates": array:2 [ 0 => -79.2496574 1 => 42.8798365 ] +"Latitude": 42.8798365 +"Longitude": -79.2496574 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention developers and builders! See this unique and spectacular waterfront opportunity and 'one of a kind' location along the canal Promenade of quaint downtown Port Colborne. Watch the ships passing by your doorstep from around the world through the Welland Canal to the Great Lakes! Walking distance to shops and restaurants; fabulous sandy beaches; marina; plus nearby to exciting Niagara Falls and the many Niagara on the Lake wineries. Buffalo and Hamilton airport are only an hour away! Well suited for townhouses, condo development or a boutique waterfront hotel. Presently has 2 existing buildings with a double detached garage." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:11:35.075925+00:00" +"CrossStreet": "Corner of West St. and Sugarloaf St. facing canal" +"DaysOnMarket": 299 +"ExpirationDate": "2024-12-31" +"Inclusions": "Call listing agent for inclusions." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-20" +"LotSizeDimensions": "165 x 99" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-20T14:36:51Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-09-20T14:36:51Z" +"OriginalListPrice": 3700000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40650764" +"ParcelNumber": "641630278" +"PhotosChangeTimestamp": "2024-11-17T06:11:34Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "WEST" +"StreetNumber": "56 & 62" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10852.0" +"TaxAssessedValue": 515000 +"TaxBookNumber": "271101001807300" +"TaxLegalDescription": "PT LT 1 W/S WEST ST PL 987-989 PORT COLBORNE AS IN RO506571 ; PORT COLBORNE and PT LTS 1 & 2 WEST SIDE OF WEST ST., PLAN 987-989, PT 1 PL 59R5984 CITY OF PORT COLBORNE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"WaterfrontFeatures": array:1 [ 0 => "Canal Front" ] +"WaterfrontYN": true +"Zoning": "DC" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"WaterFrontageFt": "0.0000" +"AccessToProperty": array:1 [ 0 => "Year Round Municipal Road" ] +"PropertyUse": "Unknown" +"GasYNA": "Yes" +"CableYNA": "Yes" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 99.0 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413961')" +"WaterBodyType": "Canal" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ShorelineAllowance": "None" +"LotDepth": 165.0 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154175558" +"Exposure": "West" +"DockingType": array:1 [ 0 => "None" ] +"ElectricYNA": "Yes" +"MediaChangeTimestamp": "2024-11-17T06:11:34Z" +"TaxType": "Unknown" +"RuralUtilities": array:1 [ 0 => "Street Lights" ] +"Media": array:16 [ 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14211 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413891" +"ListingId": "X9413891" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:02:32Z" +"RFModificationTimestamp": "2025-04-25T23:06:33Z" +"ListPrice": 639000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Niagara Falls" +"PostalCode": "L2E 2B3" +"UnparsedAddress": "4394 Morrison Street, Niagara Falls, On L2e 2b3" +"Coordinates": array:2 [ 0 => -79.0654213 1 => 43.1046173 ] +"Latitude": 43.1046173 +"Longitude": -79.0654213 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "WISDOMAX REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Center Location in City of Niagara Falls. Near to the Niagara River, The City Hall, The Queen Street Business Center, The new grand opened Niagara University.... This is a very unique updated Duplex Up two story house. The main floor unit has a 2 bedrooms, 1 bathroom, 1 living room, 1 kitchen unit, occupants by the owner. The basement is fully finished with 1 bedroom, 1 bathroom, 1 large living room and the laundry room, occupants by the owner's son. The upper unit is a large 2 bedroom, 1 bathroom, 1 kitchen dining room , 1 living room, and 1 laundry room, separated hydro meet with the main floor unit, now occupants by the tenants. The tenants can stay, or move out by the closing day. Rental income is a great potential ! 3 parking spots on the side. Street parking is available, too. Must see!" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "210 - Downtown" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Other" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:32:07.704133+00:00" +"CrossStreet": "CORNER MORRISON ST & ONTARIO AVE" +"DaysOnMarket": 292 +"Exclusions": "Tenants Belongings." +"ExpirationDate": "2025-01-23" +"ExteriorFeatures": array:1 [ 0 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "Built-in Microwave, Window Coverings" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "73 x 31.4" +"MainOfficeKey": "471600" +"MajorChangeTimestamp": "2024-09-18T07:23:04Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2024-09-18T07:23:04Z" +"OriginalListPrice": 639000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40648790" +"ParcelNumber": "644450087" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Other" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-11-17T06:02:32Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "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": "MORRISON" +"StreetNumber": "4394" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3515.17" +"TaxAssessedValue": 206000 +"TaxBookNumber": "2725020001069000000" +"TaxLegalDescription": "PTL 15, PLAN 283, TOWN OF NIAGARA FALLS, AS IN RO757917; NIAGARA FALLS" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=BNGWi M5uu BE&ab_channel=Need Media" +"Zoning": "R2" +"Water": "Municipal" +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 31.4 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413891')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 73.0 +"ParkingSpaces": 3 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154057012" +"Exposure": "South" +"MediaChangeTimestamp": "2024-11-17T06:02:32Z" +"TaxType": "Unknown" +"UFFI": "No" +"HoldoverDays": 90 +"Media": array:32 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413859" +"ListingId": "X9413859" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:57:34Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 1089999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3708.0 +"City": "Thorold" +"PostalCode": "L2V 0A4" +"UnparsedAddress": "199 Tuliptree Road, Thorold, On L2v 0a4" +"Coordinates": array:2 [ 0 => -79.2334403 1 => 43.1123895 ] +"Latitude": 43.1123895 +"Longitude": -79.2334403 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 199 Tuliptree Rd. This beautiful home has over 3,700 square feet of living space, with every detail thoughtfully designed. The master bedroom has a luxurious ensuite and a large walk-in closet. The main floor layout is perfect, featuring a spacious family room and a large kitchen that both overlook the backyard. Relax under the covered deck while watching the kids swim in the saltwater pool. This home includes 4+1 bedrooms and 4 bathrooms. The fully finished basement has a big rec room, 5th bedroom, 4-piece bathroom, and cold cellar. All rooms are generous in size and nicely finished. Other features include a double car garage, gas fireplace, oversized windows for great backyard views, and main floor laundry. Don't miss out on this great property. Come see why it should be your next home!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "558 - Confederation Heights" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T18:34:00.246627+00:00" +"CrossStreet": "From Richmond to Winterberry to Tuliptree" +"DaysOnMarket": 292 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"FireplaceFeatures": array:1 [ 0 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Unknown" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "112.25 x 47.49" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-18T12:05:34Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-18T12:05:34Z" +"OriginalListPrice": 1089999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40648068" +"ParcelNumber": "640430398" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Other" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T05:57:34Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "16" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "TULIPTREE" +"StreetNumber": "199" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5800.0" +"TaxAssessedValue": 494000 +"TaxBookNumber": "273100002306208" +"TaxLegalDescription": "LOT 50, PLAN 59M353, THOROLD; S/T EASEMENT FOR ENTRY AS IN SN143310" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST" +"TransactionType": "For Sale" +"Zoning": "A" +"Water": "Municipal" +"RoomsAboveGrade": 11 +"KitchensAboveGrade": 1 +"UnderContract": array:2 [ 0 => "Alarm System" 1 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 5 +"PropertyFeatures": array:3 [ 0 => "Other" 1 => "Golf" 2 => "Fenced Yard" ] +"LotWidth": 47.49 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413859')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 112.25 +"ParkingSpaces": 2 +"PossessionDetails": "1-29Days" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"MediaListingKey": "154019757" +"Exposure": "South" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "LBO Provided" +"MediaChangeTimestamp": "2024-11-17T05:57:34Z" +"WashroomsType2Pcs": 4 +"ApproximateAge": "16-30" +"HoldoverDays": 30 +"WashroomsType3": 1 +"WashroomsType3Level": "Lower" +"KitchensTotal": 1 +"Media": array:49 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11409 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413842" +"ListingId": "X9413842" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:55:32Z" +"RFModificationTimestamp": "2025-04-26T17:40:04Z" +"ListPrice": 439900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2634.0 +"City": "St. Catharines" +"PostalCode": "L2R 2T3" +"UnparsedAddress": "23 Raymond Street, St. Catharines, On L2r 2t3" +"Coordinates": array:2 [ 0 => -79.2475724 1 => 43.1621912 ] +"Latitude": 43.1621912 +"Longitude": -79.2475724 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THE AGENCY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Existing Tri-plex for major renovation or demo for new building on this wanted R3 zoned lot in Downtown St. Catharine's. Many uses permitted." +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "451 - Downtown" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T12:35:34.031174+00:00" +"CrossStreet": "Welland Ave to Beecher St to Raymond St" +"DaysOnMarket": 303 +"ExpirationDate": "2025-02-28" +"ExteriorFeatures": array:2 [ 0 => "Porch" 1 => "Private Entrance" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-09-16" +"LotSizeDimensions": "121 x 65" +"MainOfficeKey": "364200" +"MajorChangeTimestamp": "2024-10-15T12:30:04Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-17T14:18:15Z" +"OriginalListPrice": 449900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647776" +"ParcelNumber": "462210034" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2024-11-17T05:55:32Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 449900.0 +"PriceChangeTimestamp": "2024-10-15T12:30:04Z" +"Roof": array:1 [ 0 => "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": "RAYMOND" +"StreetNumber": "23" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3865.0" +"TaxAssessedValue": 220000 +"TaxBookNumber": "262904001008800" +"TaxLegalDescription": "LT 542 CP PL 2 GRANTHAM; ST. CATHARINES" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"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" +"LotWidth": 65.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413842')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 121.0 +"ParkingSpaces": 1 +"PossessionDetails": "Vacant/Imme..." +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154003915" +"Exposure": "North" +"MediaChangeTimestamp": "2024-11-17T05:55:32Z" +"TaxType": "Unknown" +"HoldoverDays": 90 +"Media": array:4 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14233 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413822" +"ListingId": "X9413822" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:52:49Z" +"RFModificationTimestamp": "2025-04-25T15:01:57Z" +"ListPrice": 99000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Niagara Falls" +"PostalCode": "L2H 1H1" +"UnparsedAddress": "8040 Lundys Lane Unit 2, Niagara Falls, On L2h 1h1" +"Coordinates": array:2 [ 0 => -79.1325893 1 => 43.0887821 ] +"Latitude": 43.0887821 +"Longitude": -79.1325893 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step into a premier opportunity to own a stunning, turn-key hair salon in the heart of the vibrant Niagara Falls community. This beautifully renovated salon offers a perfect blend of modern elegance and functional design, making it an ideal choice for both seasoned professionals and aspiring salon owners. With it’s contemporary design, enjoy a fresh, inviting atmosphere with chic finishes and high-end fixtures. The salon features sleek cabinetry, stylish lighting, and comfortable, contemporary furnishings that create a welcoming environment for both clients and staff. Fully equipped with top-of-the-line tools and appliances, including luxury styling chairs, professional-grade hair dryers, and cutting-edge color stations. The facility includes a fully functional washroom, staff break room, and ample storage space. Situated in a high-traffic area of Niagara Falls, the salon benefits from excellent visibility and foot traffic. Its proximity to popular attractions, shopping areas, and residential neighborhoods ensures a steady flow of potential clients." +"BuildingAreaUnits": "Square Feet" +"BuildingName": "SPIGI D'ORO PLAZA" +"BusinessName": "Lush & Lavished Hair Studio" +"CityRegion": "218 - West Wood" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:02:37.963461+00:00" +"CrossStreet": "Between Kalar and Montrose Rd" +"DaysOnMarket": 295 +"DirectionFaces": "North" +"ExpirationDate": "2025-01-31" +"HoursDaysOfOperationDescription": """ Monday Closed\r\n Tuesday Closed\r\n Wednesday 10a.m.–3p.m.\r\n Thursday 10a.m.–8p.m.\r\n Friday 10a.m.–5p.m.\r\n Saturday 10a.m.–4:30p.m.\r\n Sunday Closed """ +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-15" +"LotSizeDimensions": "x" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-09-15T14:43:31Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-15T14:43:31Z" +"OriginalListPrice": 99000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647327" +"PhotosChangeTimestamp": "2024-11-17T05:52:49Z" +"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": "LUNDYS" +"StreetNumber": "8040" +"StreetSuffix": "Lane" +"TransactionBrokerCompensation": "2.0% + HST - Cooperating brokerage commission will" +"UnitNumber": "2" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "R1D, TC" +"Water": "Unknown" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "153977690" +"Exposure": "South" +"ContractStatus": "Available" +"MediaChangeTimestamp": "2024-11-17T05:52:49Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413822')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413732" +"ListingId": "X9413732" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:43:07Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2661.0 +"City": "Welland" +"PostalCode": "L3B 1Y7" +"UnparsedAddress": "87 Southworth Street, Welland, On L3b 1y7" +"Coordinates": array:2 [ 0 => -79.2358404 1 => 42.9801597 ] +"Latitude": 42.9801597 +"Longitude": -79.2358404 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This exceptional property features a spacious duplex with a potential third unit already equipped with a third kitchen and bathroom, offering versatile living arrangements or rental opportunities. Each level has its own washer and dryer hookups, enhancing convenience for all residents. Additional highlights include a 2-car garage and ample parking space, ensuring easy access and accommodation for multiple vehicles. With its prime location and flexible layout, this property presents an outstanding investment opportunity you won’t want to miss. Act quickly to secure this unique find!" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Partially Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "773 - Lincoln/Crowland" +"CommunityFeatures": array:2 [ 0 => "Public Transit" 1 => "Park" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Metal/Steel Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T19:18:40.077876+00:00" +"CrossStreet": "LINCOLN TO SOUTHWORTH" +"DaysOnMarket": 307 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ElectricExpense": 1512.0 +"ExpirationDate": "2024-12-31" +"ExteriorFeatures": array:4 [ 0 => "Awnings" 1 => "Deck" 2 => "Lighting" 3 => "Private Entrance" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Smoke Detector" +"InteriorFeatures": array:2 [ 0 => "Accessory Apartment" 1 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-12" +"LotSizeDimensions": "108 x 50" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-09-12T11:30:58Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OperatingExpense": "9120.0" +"OriginalEntryTimestamp": "2024-09-12T11:30:58Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40645335" +"ParcelNumber": "641190366" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Other" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T05:43:07Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Rolled" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "SOUTHWORTH" +"StreetNumber": "87" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3162.0" +"TaxAssessedValue": 180000 +"TaxBookNumber": "271905001200900" +"TaxLegalDescription": "LT 612 PL 951; PT LTS 611 & 613 PL 951 AS IN RO664527 ; WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RL2" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"Expenses": "Estimated" +"PropertyUse": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 50.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413732')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 108.0 +"ParkingSpaces": 4 +"PossessionDetails": "Flexible" +"LotSizeRangeAcres": "< .50" +"GarageType": "Detached" +"MediaListingKey": "153831740" +"Exposure": "East" +"LeaseToOwnEquipment": array:3 [ 0 => "Air Conditioner" 1 => "Furnace" 2 => "Water Heater" ] +"MediaChangeTimestamp": "2024-11-17T05:43:07Z" +"TaxType": "Unknown" +"ApproximateAge": "51-99" +"HoldoverDays": 60 +"HeatingExpenses": 2553.0 +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413651" +"ListingId": "X9413651" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:36:52Z" +"RFModificationTimestamp": "2025-04-25T16:43:44Z" +"ListPrice": 2875.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1561.0 +"City": "Port Colborne" +"PostalCode": "L3K 4G3" +"UnparsedAddress": "149 King Street, Port Colborne, On L3k 4g3" +"Coordinates": array:2 [ 0 => -79.2509483 …1 ] +"Latitude": 42.8837401 +"Longitude": -79.2509483 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Property in Port Colborne Welcome to 149 King Street, Port Colborne. A solid standalone building offering an impressive 2,760 sqft of versatile space. This property features a spacious ground floor of 1,540 sqft and a 1,200 sqft basement, ideal for a variety of business needs. **Key Features:** - **Exceptional Structure:** Well-built standalone building with abundant natural light from numerous windows. - **Prime Location:** Situated on a corner lot, providing excellent visibility and prime opportunities for signage. - **Versatile Usage:** Perfect for franchises or a variety of business types. - **Proximity to Amenities:** Just steps away from the Welland Canal and the bustling downtown core. - **Growing Community:** Surrounded by residential housing and newly developed condos. - **Tourist Hub:** Located in the heart of Port Colborne’s tourism, shopping, and restaurant district. - **Future Developments:** Close to the upcoming Waterfront revitalization and planned cruise ship terminal. **Zoning and Permitted Uses:** This property is located in a Downtown Commercial Zone (DC), which allows for diverse business opportunities, including: - Animal Care Establishment - Public Brew Pub - Day Care - Medical Clinic - Office Spaces - Personal Service Business - Banquet Hall - Place of Worship - Private Club - Public Use - Recreation Facility - Restaurants (Fast Food, Full-Service, Take-Out) - Retail Stores - Service Commercial - Social Service Facility - Studio - Veterinary Clinic Whether you're looking to establish a new business or expand an existing one, 149 King Street offers a unique opportunity in a vibrant and growing community. Don’t miss out on this prime commercial property in the heart of Port Colborne." +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:50:43.752340+00:00" +"CrossStreet": "MAIN STREET TO KING STREET" +"DaysOnMarket": 311 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-09" +"LotSizeDimensions": "x 49" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-09-09T11:38:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-09T11:38:58Z" +"OriginalListPrice": 2875.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40643807" +"ParcelNumber": "641630140" +"PhotosChangeTimestamp": "2024-11-17T05:36:52Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "KING" +"StreetNumber": "149" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 2 S/S KENT ST PL 987-989 PORT COLBORNE AS IN RO724480 ; PORT COLBORNE" +"TransactionBrokerCompensation": "HALF A MONTHS RENT" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "153739661" +"ContractStatus": "Available" +"ListPriceUnit": "Gross Lease" +"PropertyFeatures": array:1 [ …1] +"LotWidth": 49.0 +"MediaChangeTimestamp": "2024-11-17T05:36:52Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413651')" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"MinimumRentalTermMonths": 12 +"provider_name": "TRREB" +"Media": array:23 [ …23] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413615" +"ListingId": "X9413615" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T05:34:01Z" +"RFModificationTimestamp": "2025-04-26T19:12:25Z" +"ListPrice": 1700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2100.0 +"City": "Pelham" +"PostalCode": "L0S 1E4" +"UnparsedAddress": "156 Hwy 20 W N/a, Pelham, On L0s 1e4" +"Coordinates": array:2 [ …2] +"Latitude": 43.043487 +"Longitude": -79.297919 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Rare opportunity to invest in one of the fastest growing areas of the Niagara Region.\r\n \r\n This versatile Downtown Commercial building with just over 2000 sq ft and ample parking , currently operating as a professional office, offers a unique development opportunity.\r\n Located in a bustling area with high visibility and easy access, this property is perfect for attracting a steady stream of clients. Whether you want to continue the existing configuration, expand or bring your professional vision to life, this building offers endless possibilities in a prime location.\r\n Property must be purchased along with 1410 Haist Street ( adjacent property). Architectural image for illustration purpose only. Environmental, Archeological, Traffic Triangle and Noise , and preconstruction meeting completed.\r\n Call today for more details. Please do not visit the property without confirmed appointment. """ +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "662 - Fonthill" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:58:09.878864+00:00" +"CrossStreet": "Highway 20 west at Haist Street" +"DaysOnMarket": 303 +"ExpirationDate": "2025-02-07" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-08" +"LotSizeDimensions": "344.29 x 56.13" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2024-09-10T13:08:50Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-10T13:08:50Z" +"OriginalListPrice": 1700000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40643165" +"ParcelNumber": "640340087" +"PhotosChangeTimestamp": "2024-11-17T05:34:01Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "HWY 20 W" +"StreetNumber": "156" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "13708.86" +"TaxAssessedValue": 424000 +"TaxBookNumber": "273202000105701" +"TaxLegalDescription": "PT LT 116 PL 717 FONTHILL PT 1 59R3555; PELHAM" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "DC" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "153702046" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 56.13 +"MediaChangeTimestamp": "2024-11-17T05:34:01Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413615')" +"HSTApplication": array:1 [ …1] +"SpecialDesignation": array:1 [ …1] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 344.29 +"Media": array:6 [ …6] } ] +success: true +page_size: 9 +page_count: 13598 +count: 122382 +after_key: "" } ] ]
