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=101430&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=101430&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=101430&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=101430&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#12554 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12548 +post_id: "165254" +post_author: 1 +"ListingKey": "X9414368" +"ListingId": "X9414368" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:52:20Z" +"RFModificationTimestamp": "2025-04-25T16:59:05.146549+00:00" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2300.0 +"City": "Niagara Falls" +"PostalCode": "L2G 2B7" +"UnparsedAddress": "6042 Culp Street, Niagara Falls, On L2g 2b7" +"Coordinates": array:2 [ 0 => -79.0946203 1 => 43.0860586 ] +"Latitude": 43.0860586 +"Longitude": -79.0946203 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 TODAY REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "STANDOUT, 3 UNIT, FULLY FURNISHED INVESTMENT OPPORTUNITY near the heart of the Fallsview Tourist district, just a short stroll from the Casino. Legal duplex with non-conforming basement unit. Lower unit is 75% above ground, ensuring plenty of natural light. All units come fully furnished! The property also boasts a spacious 4 car detached, insulated garage with hydro. Recent upgrades include two A/C units, most windows and a maintenance free metal roof with lifetime warranty. With 200-amp electrical service on breakers, two furnaces, two A/Cs, one hydro meter, and two gas meters, managing utilities is straightforward. Main floor unit is currently rented to a long term, amazing tenant wanting to stay. Lower unit with walk out and upper unit are both currently vacant. Set your own rents or live in one unit for yourself! This well-maintained property, in a prime location with strong rental potential, is sure to impress!" +"Basement": array:2 [ 0 => "Walk-Out" 1 => "Separate Entrance" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Metal/Steel Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T14:15:12.675994+00:00" +"CrossStreet": "Culp Street between Pine Grove and Orchard" +"DaysOnMarket": 227 +"ExpirationDate": "2024-11-30" +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Other, Smoke Detector, Window Coverings" +"InteriorFeatures": "Accessory Apartment" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-09" +"LotSizeDimensions": "x 63" +"MainOfficeKey": "461600" +"MajorChangeTimestamp": "2024-09-09T11:00:24Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-09T11:00:24Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40637665" +"ParcelNumber": "643530004" +"ParkingFeatures": "Private" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2024-11-17T06:52:20Z" +"PoolFeatures": "None" +"Roof": "Metal" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CULP" +"StreetNumber": "6042" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4654.7" +"TaxAssessedValue": 296000 +"TaxBookNumber": "272507000600500" +"TaxLegalDescription": "PT LT 16 W/S MAIN ST, S OF LUNDY'S LANE PL 653 ABSTRACTED AS BLK 15 VILLAGE OF NIAGARA FALLS AS IN RO389962 CITY OF NIAGARA FALLS" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Forced Air" +"LotWidth": 63.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414368')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 3 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "153235722" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotIrregularities": "SEE GEOWAREHOUSE" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:52:20Z" +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] ] +"ID": "165254" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12550 +post_id: "165255" +post_author: 1 +"ListingKey": "X9414280" +"ListingId": "X9414280" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:43:39Z" +"RFModificationTimestamp": "2025-04-26T21:20:09.763441+00:00" +"ListPrice": 999000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2567.0 +"City": "Thorold" +"PostalCode": "L2V 0M1" +"UnparsedAddress": "39 Alicia Crescent, Thorold, On L2v 0m1" +"Coordinates": array:2 [ 0 => -79.2368071 1 => 43.0271091 ] +"Latitude": 43.0271091 +"Longitude": -79.2368071 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "The model home is ready, and it's a must-see! This trendy 2,567 square-foot, two-story home has been meticulously crafted by one of Niagara's most hands-on and outstanding builders and comes with a host of high-end features that are often considered expensive upgrades. 10-foot ceilings on the main floor and 9-foot ceilings on the second floor, paired with 8-foot doors on the main level that add to the spacious, open feel of the home. The flooring throughout the house is beautiful, with an oak staircases, not a single carpet in sight. Elegant rod iron spindles and a striking modern exterior add to the home's curb appeal. Designed with families in mind, this home boasts 3 spacious bedrooms plus a loft on the upper floor. With 2 full bathrooms and a convenient half bath, along with a second-floor laundry room, this home truly marries style with functionality. The basement offers future potential with an egress window and a separate entrance, making it easy to add an accessory apartment down the line. The home also includes an array of luxurious upgrades such as crown molding, pot lights, upgraded black windows, quartz countertops, and high gloss white kitchen cabinets with soft-closing doors. The attention to detail continues with large, modern baseboards and many more thoughtful touches throughout the home. Outside, the property is fully ready for you to move in and enjoy, with a concrete driveway that's just been sealed, a back concrete patio, a new deck, and a sealed garage floor. The yard is fully sodded, creating a lush, green space for you and your family to enjoy. Located in a well-established new subdivision, this home is centrally situated on the Thorold/Welland border, providing easy access to the highway and all the shopping amenities you could need. Whether you're looking for a forever home or a smart investment, this property offers it all. Don't miss the opportunity to own a piece of modern luxury in one of Niagara's most sought-after locations!" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "562 - Hurricane/Merrittville" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T11:51:05.349735+00:00" +"CrossStreet": "off Hansler Road" +"DaysOnMarket": 264 +"DirectionFaces": "Unknown" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2025-04-10" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "None, Hot Water Tank Owned" +"InteriorFeatures": "Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-12" +"LotSizeDimensions": "107.78 x 39.7" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-13T13:12:18Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-08-12T19:55:53Z" +"OriginalListPrice": 1090000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40631862" +"ParcelNumber": "644270918" +"ParkingFeatures": "Private Double,Other" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T06:43:39Z" +"PoolFeatures": "None" +"PreviousListPrice": 1090000.0 +"PriceChangeTimestamp": "2024-09-13T13:12:18Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "11" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALICIA" +"StreetNumber": "39" +"StreetSuffix": "Crescent" +"TaxBookNumber": "273100003016317" +"TaxLegalDescription": "LOT 12, PLAN 59M502 CITY OF THOROLD" +"TaxYear": "2023" +"TransactionBrokerCompensation": "3% NET OF HST" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 107.78 +"LotWidth": 39.7 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414280')" +"GarageType": "Attached" +"HeatSource": "Gas" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "None" ] +"provider_name": "TRREB" +"ApproximateAge": "New" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "152854066" +"RoomsAboveGrade": 11 +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-11-17T06:43:39Z" +"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": "165255" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12547 +post_id: "165256" +post_author: 1 +"ListingKey": "X9414176" +"ListingId": "X9414176" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:34:29Z" +"RFModificationTimestamp": "2025-04-30T05:57:21.612712+00:00" +"ListPrice": 435000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1550.0 +"City": "Welland" +"PostalCode": "L3B 4L1" +"UnparsedAddress": "41 Albert Street, Welland, On L3b 4l1" +"Coordinates": array:2 [ 0 => -79.249528 1 => 42.9857951 ] +"Latitude": 42.9857951 +"Longitude": -79.249528 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "INVESTORS WELCOME. A fully tenanted duplex, with consistent rental income. Rental income is approximately $3,220/month, with a yearly total of $38,640. Both upper and lower unit have been updates and meticulously maintained. Floors, trim, walls, cabinets, countertops and bathroom fixtures are all in great shape. AC, heating, electrical and plumbing all updated and in great working order. Turnkey opportunity for consistent and predictable cash flow. Book your showing, it won't last long!" +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "768 - Welland Downtown" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T16:03:29.329948+00:00" +"CrossStreet": "KING ST SOUTH TO ALBERT NEAR KENT ST" +"DaysOnMarket": 301 +"DirectionFaces": "North" +"ExpirationDate": "2025-01-02" +"ExteriorFeatures": "Deck,Porch" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Inclusions": "Microwave, Smoke Detector, Window Coverings" +"InteriorFeatures": "On Demand Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-07-11" +"LotSizeDimensions": "80.5 x 26" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-11-11T10:43:14Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-07-11T20:00:51Z" +"OriginalListPrice": 465000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40619384" +"ParcelNumber": "641080087" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-11-17T06:34:29Z" +"PoolFeatures": "None" +"PreviousListPrice": 450000.0 +"PriceChangeTimestamp": "2024-11-11T10:43:14Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "41" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2337.0" +"TaxAssessedValue": 133000 +"TaxBookNumber": "271903000909400" +"TaxLegalDescription": "PT LT 32 PL 555 AS IN R0625121 CITY OF WELLAND" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST; Cooperating brokerage commission will" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "RL2" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 80.5 +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414176')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "152060660" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"MediaChangeTimestamp": "2024-11-17T06:34:29Z" +"Media": array:27 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] ] +"ID": "165256" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12551 +post_id: "165259" +post_author: 1 +"ListingKey": "X9414020" +"ListingId": "X9414020" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:18:14Z" +"RFModificationTimestamp": "2024-11-17T07:06:37.310225+00:00" +"ListPrice": 999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 502.0 +"City": "St. Catharines" +"PostalCode": "L2R 2Z4" +"UnparsedAddress": "112 Queenston Street Unit 302, St. Catharines, On L2r 2z4" +"Coordinates": array:2 [ 0 => -79.2331386 1 => 43.1633196 ] +"Latitude": 43.1633196 +"Longitude": -79.2331386 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a medical building with multiple units designed to meet your specific professional needs. Each office suite enhances your professional image while helping you save on costs. The property features onsite professional property management and an advanced security system, equipped with state-of-the-art cameras for both interior and exterior safety. You'll enjoy ample free parking, including a 38-space lot and additional front parking for convenience. Accessibility is made easy with an onsite elevator, and all-inclusive lease rates simplify budgeting. For medical professionals, the presence of a pharmacy on the main floor adds to the convenience. Located in a central city area, the property offers easy access to various amenities and highways, making it an ideal choice for your practice." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "450 - E. Chester" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:28:50.501543+00:00" +"CrossStreet": "On Queenston St between Page and Tasker" +"DaysOnMarket": 205 +"ExpirationDate": "2025-09-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-09-25T08:14:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T08:14:12Z" +"OriginalListPrice": 999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40652220" +"ParcelNumber": "462670009" +"PhotosChangeTimestamp": "2024-11-17T06:18:14Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "QUEENSTON" +"StreetNumber": "112" +"StreetSuffix": "Street" +"TaxLegalDescription": "LT 3581 CP PL 2 GRANTHAM; PT LT 3580 CP PL 2 GRANTHAM AS IN RO544546; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5% yr. 1 and 2% for the remaining initial lease" +"TransactionType": "For Lease" +"UnitNumber": "302" +"Utilities": "Unknown" +"Zoning": "M1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414020')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154251515" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:18:14Z" +"MinimumRentalTermMonths": 12 +"Media": array:15 [ 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] ] +"ID": "165259" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12549 +post_id: "165260" +post_author: 1 +"ListingKey": "X9414018" +"ListingId": "X9414018" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:17:45Z" +"RFModificationTimestamp": "2025-04-25T16:53:49.815847+00:00" +"ListPrice": 2400.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1211.0 +"City": "St. Catharines" +"PostalCode": "L2R 2Z4" +"UnparsedAddress": "112 Queenston Street Unit 203a&b, St. Catharines, On L2r 2z4" +"Coordinates": array:2 [ 0 => -79.233288 1 => 43.1633934 ] +"Latitude": 43.1633934 +"Longitude": -79.233288 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a medical building with multiple units designed to meet your specific professional needs. Each office suite enhances your professional image while helping you save on costs. The property features onsite professional property management and an advanced security system, equipped with state-of-the-art cameras for both interior and exterior safety. You'll enjoy ample free parking, including a 38-space lot and additional front parking for convenience. Accessibility is made easy with an onsite elevator, and all-inclusive lease rates simplify budgeting. For medical professionals, the presence of a pharmacy on the main floor adds to the convenience. Located in a central city area, the property offers easy access to various amenities and highways, making it an ideal choice for your practice." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "450 - E. Chester" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:29:19.375126+00:00" +"CrossStreet": "On Queenston St between Page and Tasker" +"DaysOnMarket": 205 +"ExpirationDate": "2025-09-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-09-25T08:13:56Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T08:13:56Z" +"OriginalListPrice": 2400.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40652159" +"ParcelNumber": "462670009" +"PhotosChangeTimestamp": "2024-11-17T06:17:45Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "QUEENSTON" +"StreetNumber": "112" +"StreetSuffix": "Street" +"TaxLegalDescription": "LT 3581 CP PL 2 GRANTHAM; PT LT 3580 CP PL 2 GRANTHAM AS IN RO544546; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5% yr. 1 and 2% for the remaining initial lease" +"TransactionType": "For Lease" +"UnitNumber": "203A&B" +"Utilities": "Unknown" +"Zoning": "M1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414018')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154248922" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:17:45Z" +"MinimumRentalTermMonths": 12 +"Media": array:20 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] ] +"ID": "165260" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12546 +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:23.385290+00:00" +"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": 220 +"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" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"LotWidth": 20.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413969')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154190037" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:12:23Z" +"MinimumRentalTermMonths": 36 +"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" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12545 +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:49.815847+00:00" +"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": 219 +"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" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"CableYNA": "Yes" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 165.0 +"LotWidth": 99.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413961')" +"GarageType": "Unknown" +"DockingType": array:1 [ 0 => "None" ] +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"WaterBodyType": "Canal" +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:1 [ 0 => "Street Lights" ] +"MediaListingKey": "154175558" +"WaterFrontageFt": "0.0000" +"AccessToProperty": array:1 [ 0 => "Year Round Municipal Road" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:11:34Z" +"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" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12552 +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:33.038251+00:00" +"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": 212 +"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" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 73.0 +"LotWidth": 31.4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413891')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 3 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154057012" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "60-89Days" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:02:32Z" +"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" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12553 +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:44.041601+00:00" +"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": 212 +"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" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 112.25 +"LotWidth": 47.49 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413859')" +"GarageType": "Attached" +"HeatSource": "Gas" +"HoldoverDays": 30 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:2 [ 0 => "Alarm System" 1 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 2 +"WashroomsType3": 1 +"MediaListingKey": "154019757" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 5 +"PropertyFeatures": array:3 [ 0 => "Other" 1 => "Golf" 2 => "Fenced Yard" ] +"SquareFootSource": "LBO Provided" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "1-29Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2024-11-17T05:57:34Z" +"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" } ] +success: true +page_size: 9 +page_count: 12144 +count: 109294 +after_key: "" } "RF Response Time" => "0.32 seconds" ] "RF Cache Key: 6809560597fa858e4985fe7615dcf4b025b56bd92d2d170dac85d72847578ac2" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#12805 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12569 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414368" +"ListingId": "X9414368" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:52:20Z" +"RFModificationTimestamp": "2025-04-25T16:59:05.146549+00:00" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2300.0 +"City": "Niagara Falls" +"PostalCode": "L2G 2B7" +"UnparsedAddress": "6042 Culp Street, Niagara Falls, On L2g 2b7" +"Coordinates": array:2 [ 0 => -79.0946203 1 => 43.0860586 ] +"Latitude": 43.0860586 +"Longitude": -79.0946203 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 TODAY REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "STANDOUT, 3 UNIT, FULLY FURNISHED INVESTMENT OPPORTUNITY near the heart of the Fallsview Tourist district, just a short stroll from the Casino. Legal duplex with non-conforming basement unit. Lower unit is 75% above ground, ensuring plenty of natural light. All units come fully furnished! The property also boasts a spacious 4 car detached, insulated garage with hydro. Recent upgrades include two A/C units, most windows and a maintenance free metal roof with lifetime warranty. With 200-amp electrical service on breakers, two furnaces, two A/Cs, one hydro meter, and two gas meters, managing utilities is straightforward. Main floor unit is currently rented to a long term, amazing tenant wanting to stay. Lower unit with walk out and upper unit are both currently vacant. Set your own rents or live in one unit for yourself! This well-maintained property, in a prime location with strong rental potential, is sure to impress!" +"Basement": array:2 [ 0 => "Walk-Out" 1 => "Separate Entrance" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Metal/Steel Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T14:15:12.675994+00:00" +"CrossStreet": "Culp Street between Pine Grove and Orchard" +"DaysOnMarket": 227 +"ExpirationDate": "2024-11-30" +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Other, Smoke Detector, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Accessory Apartment" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-09" +"LotSizeDimensions": "x 63" +"MainOfficeKey": "461600" +"MajorChangeTimestamp": "2024-09-09T11:00:24Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-09T11:00:24Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40637665" +"ParcelNumber": "643530004" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2024-11-17T06:52:20Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Metal" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CULP" +"StreetNumber": "6042" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4654.7" +"TaxAssessedValue": 296000 +"TaxBookNumber": "272507000600500" +"TaxLegalDescription": "PT LT 16 W/S MAIN ST, S OF LUNDY'S LANE PL 653 ABSTRACTED AS BLK 15 VILLAGE OF NIAGARA FALLS AS IN RO389962 CITY OF NIAGARA FALLS" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Forced Air" +"LotWidth": 63.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414368')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 3 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "153235722" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotIrregularities": "SEE GEOWAREHOUSE" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T06:52:20Z" +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12532 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414280" +"ListingId": "X9414280" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:43:39Z" +"RFModificationTimestamp": "2025-04-26T21:20:09.763441+00:00" +"ListPrice": 999000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2567.0 +"City": "Thorold" +"PostalCode": "L2V 0M1" +"UnparsedAddress": "39 Alicia Crescent, Thorold, On L2v 0m1" +"Coordinates": array:2 [ 0 => -79.2368071 1 => 43.0271091 ] +"Latitude": 43.0271091 +"Longitude": -79.2368071 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "The model home is ready, and it's a must-see! This trendy 2,567 square-foot, two-story home has been meticulously crafted by one of Niagara's most hands-on and outstanding builders and comes with a host of high-end features that are often considered expensive upgrades. 10-foot ceilings on the main floor and 9-foot ceilings on the second floor, paired with 8-foot doors on the main level that add to the spacious, open feel of the home. The flooring throughout the house is beautiful, with an oak staircases, not a single carpet in sight. Elegant rod iron spindles and a striking modern exterior add to the home's curb appeal. Designed with families in mind, this home boasts 3 spacious bedrooms plus a loft on the upper floor. With 2 full bathrooms and a convenient half bath, along with a second-floor laundry room, this home truly marries style with functionality. The basement offers future potential with an egress window and a separate entrance, making it easy to add an accessory apartment down the line. The home also includes an array of luxurious upgrades such as crown molding, pot lights, upgraded black windows, quartz countertops, and high gloss white kitchen cabinets with soft-closing doors. The attention to detail continues with large, modern baseboards and many more thoughtful touches throughout the home. Outside, the property is fully ready for you to move in and enjoy, with a concrete driveway that's just been sealed, a back concrete patio, a new deck, and a sealed garage floor. The yard is fully sodded, creating a lush, green space for you and your family to enjoy. Located in a well-established new subdivision, this home is centrally situated on the Thorold/Welland border, providing easy access to the highway and all the shopping amenities you could need. Whether you're looking for a forever home or a smart investment, this property offers it all. Don't miss the opportunity to own a piece of modern luxury in one of Niagara's most sought-after locations!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "562 - Hurricane/Merrittville" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T11:51:05.349735+00:00" +"CrossStreet": "off Hansler Road" +"DaysOnMarket": 264 +"DirectionFaces": "Unknown" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2025-04-10" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "None, Hot Water Tank Owned" +"InteriorFeatures": array:1 [ 0 => "Water Heater Owned" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-12" +"LotSizeDimensions": "107.78 x 39.7" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-13T13:12:18Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-08-12T19:55:53Z" +"OriginalListPrice": 1090000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40631862" +"ParcelNumber": "644270918" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Other" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T06:43:39Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 1090000.0 +"PriceChangeTimestamp": "2024-09-13T13:12:18Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "11" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALICIA" +"StreetNumber": "39" +"StreetSuffix": "Crescent" +"TaxBookNumber": "273100003016317" +"TaxLegalDescription": "LOT 12, PLAN 59M502 CITY OF THOROLD" +"TaxYear": "2023" +"TransactionBrokerCompensation": "3% NET OF HST" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 107.78 +"LotWidth": 39.7 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414280')" +"GarageType": "Attached" +"HeatSource": "Gas" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "None" ] +"provider_name": "TRREB" +"ApproximateAge": "New" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "152854066" +"RoomsAboveGrade": 11 +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-11-17T06:43:39Z" +"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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12543 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414176" +"ListingId": "X9414176" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:34:29Z" +"RFModificationTimestamp": "2025-04-30T05:57:21.612712+00:00" +"ListPrice": 435000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1550.0 +"City": "Welland" +"PostalCode": "L3B 4L1" +"UnparsedAddress": "41 Albert Street, Welland, On L3b 4l1" +"Coordinates": array:2 [ 0 => -79.249528 1 => 42.9857951 ] +"Latitude": 42.9857951 +"Longitude": -79.249528 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "INVESTORS WELCOME. A fully tenanted duplex, with consistent rental income. Rental income is approximately $3,220/month, with a yearly total of $38,640. Both upper and lower unit have been updates and meticulously maintained. Floors, trim, walls, cabinets, countertops and bathroom fixtures are all in great shape. AC, heating, electrical and plumbing all updated and in great working order. Turnkey opportunity for consistent and predictable cash flow. Book your showing, it won't last long!" +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "768 - Welland Downtown" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T16:03:29.329948+00:00" +"CrossStreet": "KING ST SOUTH TO ALBERT NEAR KENT ST" +"DaysOnMarket": 301 +"DirectionFaces": "North" +"ExpirationDate": "2025-01-02" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Inclusions": "Microwave, Smoke Detector, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "On Demand Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-07-11" +"LotSizeDimensions": "80.5 x 26" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-11-11T10:43:14Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-07-11T20:00:51Z" +"OriginalListPrice": 465000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40619384" +"ParcelNumber": "641080087" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-11-17T06:34:29Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 450000.0 +"PriceChangeTimestamp": "2024-11-11T10:43:14Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "41" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2337.0" +"TaxAssessedValue": 133000 +"TaxBookNumber": "271903000909400" +"TaxLegalDescription": "PT LT 32 PL 555 AS IN R0625121 CITY OF WELLAND" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% PLUS HST; Cooperating brokerage commission will" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RL2" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 80.5 +"LotWidth": 26.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414176')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "152060660" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"MediaChangeTimestamp": "2024-11-17T06:34:29Z" +"Media": array:27 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12542 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414020" +"ListingId": "X9414020" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:18:14Z" +"RFModificationTimestamp": "2024-11-17T07:06:37.310225+00:00" +"ListPrice": 999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 502.0 +"City": "St. Catharines" +"PostalCode": "L2R 2Z4" +"UnparsedAddress": "112 Queenston Street Unit 302, St. Catharines, On L2r 2z4" +"Coordinates": array:2 [ 0 => -79.2331386 1 => 43.1633196 ] +"Latitude": 43.1633196 +"Longitude": -79.2331386 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a medical building with multiple units designed to meet your specific professional needs. Each office suite enhances your professional image while helping you save on costs. The property features onsite professional property management and an advanced security system, equipped with state-of-the-art cameras for both interior and exterior safety. You'll enjoy ample free parking, including a 38-space lot and additional front parking for convenience. Accessibility is made easy with an onsite elevator, and all-inclusive lease rates simplify budgeting. For medical professionals, the presence of a pharmacy on the main floor adds to the convenience. Located in a central city area, the property offers easy access to various amenities and highways, making it an ideal choice for your practice." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "450 - E. Chester" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:28:50.501543+00:00" +"CrossStreet": "On Queenston St between Page and Tasker" +"DaysOnMarket": 205 +"ExpirationDate": "2025-09-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-09-25T08:14:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T08:14:12Z" +"OriginalListPrice": 999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40652220" +"ParcelNumber": "462670009" +"PhotosChangeTimestamp": "2024-11-17T06:18:14Z" +"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": "QUEENSTON" +"StreetNumber": "112" +"StreetSuffix": "Street" +"TaxLegalDescription": "LT 3581 CP PL 2 GRANTHAM; PT LT 3580 CP PL 2 GRANTHAM AS IN RO544546; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5% yr. 1 and 2% for the remaining initial lease" +"TransactionType": "For Lease" +"UnitNumber": "302" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "M1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414020')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "154251515" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:18:14Z" +"MinimumRentalTermMonths": 12 +"Media": array:15 [ …15] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12225 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414018" +"ListingId": "X9414018" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:17:45Z" +"RFModificationTimestamp": "2025-04-25T16:53:49.815847+00:00" +"ListPrice": 2400.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1211.0 +"City": "St. Catharines" +"PostalCode": "L2R 2Z4" +"UnparsedAddress": "112 Queenston Street Unit 203a&b, St. Catharines, On L2r 2z4" +"Coordinates": array:2 [ …2] +"Latitude": 43.1633934 +"Longitude": -79.233288 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a medical building with multiple units designed to meet your specific professional needs. Each office suite enhances your professional image while helping you save on costs. The property features onsite professional property management and an advanced security system, equipped with state-of-the-art cameras for both interior and exterior safety. You'll enjoy ample free parking, including a 38-space lot and additional front parking for convenience. Accessibility is made easy with an onsite elevator, and all-inclusive lease rates simplify budgeting. For medical professionals, the presence of a pharmacy on the main floor adds to the convenience. Located in a central city area, the property offers easy access to various amenities and highways, making it an ideal choice for your practice." +"Basement": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "450 - E. Chester" +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:29:19.375126+00:00" +"CrossStreet": "On Queenston St between Page and Tasker" +"DaysOnMarket": 205 +"ExpirationDate": "2025-09-25" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-25" +"LotSizeDimensions": "x" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-09-25T08:13:56Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-25T08:13:56Z" +"OriginalListPrice": 2400.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40652159" +"ParcelNumber": "462670009" +"PhotosChangeTimestamp": "2024-11-17T06:17:45Z" +"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": "QUEENSTON" +"StreetNumber": "112" +"StreetSuffix": "Street" +"TaxLegalDescription": "LT 3581 CP PL 2 GRANTHAM; PT LT 3580 CP PL 2 GRANTHAM AS IN RO544546; ST. CATHARINES" +"TransactionBrokerCompensation": "3.5% yr. 1 and 2% for the remaining initial lease" +"TransactionType": "For Lease" +"UnitNumber": "203A&B" +"Utilities": array:1 [ …1] +"Zoning": "M1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414018')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "154248922" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:17:45Z" +"MinimumRentalTermMonths": 12 +"Media": array:20 [ …20] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12565 +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:23.385290+00:00" +"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 [ …2] +"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 [ …1] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "878 - Sugarloaf" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:30:59.904376+00:00" +"CrossStreet": "Clarence Street to West Street" +"DaysOnMarket": 220 +"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 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"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 [ …1] +"Zoning": "DC" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Unknown" +"LotWidth": 20.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413969')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "154190037" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:12:23Z" +"MinimumRentalTermMonths": 36 +"Media": array:11 [ …11] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12566 +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:49.815847+00:00" +"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 [ …2] +"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 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:11:35.075925+00:00" +"CrossStreet": "Corner of West St. and Sugarloaf St. facing canal" +"DaysOnMarket": 219 +"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 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"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 [ …1] +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"Zoning": "DC" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"CableYNA": "Yes" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 165.0 +"LotWidth": 99.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413961')" +"GarageType": "Unknown" +"DockingType": array:1 [ …1] +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"WaterBodyType": "Canal" +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"RuralUtilities": array:1 [ …1] +"MediaListingKey": "154175558" +"WaterFrontageFt": "0.0000" +"AccessToProperty": array:1 [ …1] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:11:34Z" +"Media": array:16 [ …16] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12567 +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:33.038251+00:00" +"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 [ …2] +"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 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "210 - Downtown" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T18:32:07.704133+00:00" +"CrossStreet": "CORNER MORRISON ST & ONTARIO AVE" +"DaysOnMarket": 212 +"Exclusions": "Tenants Belongings." +"ExpirationDate": "2025-01-23" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Inclusions": "Built-in Microwave, Window Coverings" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ …1] +"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 [ …2] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-11-17T06:02:32Z" +"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": "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 [ …1] +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=BNGWi M5uu BE&ab_channel=Need Media" +"Zoning": "R2" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 73.0 +"LotWidth": 31.4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413891')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 3 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "154057012" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "60-89Days" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:02:32Z" +"Media": array:32 [ …32] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12568 +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:44.041601+00:00" +"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 [ …2] +"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 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "558 - Confederation Heights" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T18:34:00.246627+00:00" +"CrossStreet": "From Richmond to Winterberry to Tuliptree" +"DaysOnMarket": 212 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-18" +"LotFeatures": array:1 [ …1] +"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 [ …2] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T05:57:34Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "16" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"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" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 112.25 +"LotWidth": 47.49 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413859')" +"GarageType": "Attached" +"HeatSource": "Gas" +"HoldoverDays": 30 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:2 [ …2] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"WashroomsType1": 1 +"WashroomsType2": 2 +"WashroomsType3": 1 +"MediaListingKey": "154019757" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 5 +"PropertyFeatures": array:3 [ …3] +"SquareFootSource": "LBO Provided" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "1-29Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2024-11-17T05:57:34Z" +"Media": array:49 [ …49] } ] +success: true +page_size: 9 +page_count: 12144 +count: 109294 +after_key: "" } ] ]
