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=103788&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=103788&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=103788&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=103788&$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: "165246" +post_author: 1 +"ListingKey": "X9414800" +"ListingId": "X9414800" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:37:25Z" +"RFModificationTimestamp": "2025-04-26T19:26:30.008916+00:00" +"ListPrice": 739900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1260.0 +"City": "St. Catharines" +"PostalCode": "L2M 5R7" +"UnparsedAddress": "43 Cosby Avenue, St. Catharines, On L2m 5r7" +"Coordinates": array:2 [ 0 => -79.2238581 1 => 43.1745053 ] +"Latitude": 43.1745053 +"Longitude": -79.2238581 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "6.5% CAP RATE! Investors, seize the opportunity! This meticulously updated 3-unit building in the bustling heart of St. Catharines generates a 6.5% cap rate with a gross income of $60,000. Fully occupied and boasting ample parking with a detached garage, this property is designed for convenience. Recent upgrades, including a new roof (2018), furnace (2018), 2 x 100 amp panels, and modernized flooring, kitchens, and bathrooms in each unit, make it a contemporary and attractive investment. Situated near major highways, shopping centers, bus routes, and public transit hubs, this property offers unmatched accessibility. Whether expanding your portfolio or starting fresh, secure this prime investment opportunity today!" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "445 - Facer" +"CoListOfficeKey": "344731" +"CoListOfficeName": "REVEL Realty Inc., Brokerage" +"CoListOfficePhone": "905-357-1700" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T16:38:29.785519+00:00" +"CrossStreet": "Dieppe Rd & Welland Ave to Cosby" +"DaysOnMarket": 207 +"ElectricExpense": 2800.0 +"ExpirationDate": "2025-01-01" +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector" +"InsuranceExpense": 1400.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-10-01" +"LotSizeDimensions": "90 x 40" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-10-01T12:05:29Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OperatingExpense": "11400.0" +"OriginalEntryTimestamp": "2024-10-01T12:05:29Z" +"OriginalListPrice": 739900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40655684" +"OtherExpense": 700.0 +"ParcelNumber": "462790051" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T07:37:25Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "COSBY" +"StreetNumber": "43" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2900.0" +"TaxAssessedValue": 180000 +"TaxBookNumber": "262903002210400" +"TaxLegalDescription": "LT 15 CY PL 97 GRANTHAM; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2%+hst" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Expenses": "Estimated" +"HeatType": "Forced Air" +"LotDepth": 90.0 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414800')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"HeatingExpenses": 2100.0 +"MediaListingKey": "154433365" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T07:37:25Z" +"Media": array:30 [ 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] ] +"ID": "165246" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12550 +post_id: "165247" +post_author: 1 +"ListingKey": "X9414745" +"ListingId": "X9414745" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:32:00Z" +"RFModificationTimestamp": "2025-04-26T22:52:59.102290+00:00" +"ListPrice": 1249999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1552.0 +"City": "Niagara Falls" +"PostalCode": "L2G 1Y6" +"UnparsedAddress": "6437 - 6423 Barker Street, Niagara Falls, On L2g 1y6" +"Coordinates": array:2 [ 0 => -79.10198534127 1 => 43.087247792063 ] +"Latitude": 43.087247792063 +"Longitude": -79.10198534127 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Outstanding investment opportunity! Offering two homes on a large lot w/a severable portion and pre-approved drawings for a third home, this property is a dream come true for investors or multi-generational families. The prime location, flexible living arrangements, and development potential make this property an opportunity in today's market. House 1 is a versatile, income-generating powerhouse w/three distinct units, each designed to offer privacy & comfort: Unit 1: 2 beds, 1 bath—ideal for small families or young professionals. Unit 2: 2 beds, 2 baths—perfect for larger families or roommates seeking spacious living.\r\n Unit 3: A cozy studio apartment—great for single occupants. Each is self-sufficient w/its own washer & dryer, providing the convenience of in-unit laundry. There’s also the potential to add a fourth unit in the bsmt, further increasing rental income. Two of the units are already tenanted, offering a steady cash flow, while one remains vacant. House 2 is a spacious single-family home that offers 4 bedrooms, 2½ bathrooms—a large, comfortable living space for growing families A potential in-law suite—perfect for multi-generational living or additional rental income\r\n This house is currently tenanted, offering immediate income. The flexibility of month-to-month leases across both homes gives you the freedom to adjust rental terms as needed or take advantage of the vacancy for personal use. The severable lot comes complete w/approved drawings for a third home. This allows you to either expand your rental portfolio, develop and sell the additional home, or enjoy the flexibility of a custom-built property to meet your future needs. Nestled in a family-friendly neighborhood, the property is within walking distance of some of Niagara Falls' top schools, making it attractive to families seeking long-term rentals. For entertainment and tourism, you're just minutes from the Casino and Clifton Hill. """ +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CoListOfficeKey": "062235" +"CoListOfficeName": "RIGHT AT HOME REALTY, BROKERAGE" +"CoListOfficePhone": "905-637-1700" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "1.0" +"CreationDate": "2024-10-18T13:57:20.516545+00:00" +"CrossStreet": "DRUMMOND RD - BARKER STREET" +"DaysOnMarket": 201 +"Exclusions": "TENANT'S BELONGINGS IN THE OCCUPIED UNITS." +"ExpirationDate": "2024-12-27" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "X4 FRIDGES, X4 STOVES, X4 WASHERS, X4 DRYERS., Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-10-07" +"LotSizeDimensions": "110 x 60" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-10-07T15:43:11Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-07T15:43:11Z" +"OriginalListPrice": 1249999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40654526" +"ParcelNumber": "643550120" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T07:32:00Z" +"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": "BARKER" +"StreetNumber": "6437 - 6423" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3275.0" +"TaxAssessedValue": 211000 +"TaxBookNumber": "272507001302100" +"TaxLegalDescription": """ LT 96 PL 64 STAMFORD; PT LT 95 PL 64 STAMFORD AS IN RO578340 CITY OF NIAGARA FALLS\r\n AND\r\n LT 94 PL 64 STAMFORD; PT LT 95 PL 64 STAMFORD AS IN RO404326 ; NIAGARA FALLS """ +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% PLUS HST. Note: Co-op brokerage commission wi" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "R1E" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotWidth": 60.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414745')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154376782" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T07:32:00Z" +"Media": array:46 [ 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] ] +"ID": "165247" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12547 +post_id: "165249" +post_author: 1 +"ListingKey": "X9414598" +"ListingId": "X9414598" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:17:31Z" +"RFModificationTimestamp": "2025-04-25T17:04:13.341732+00:00" +"ListPrice": 454900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 660.0 +"City": "Welland" +"PostalCode": "L3C 0K1" +"UnparsedAddress": "781 Clare Avenue Unit 114, Welland, On L3c 0k1" +"Coordinates": array:2 [ 0 => -79.2804759 1 => 43.0125431 ] +"Latitude": 43.0125431 +"Longitude": -79.2804759 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this perfectly situated stacked townhome in the heart of Welland. Move-in ready and thoughtfully designed, this 1-bedroom, 1-bathroom condo offers modern living at an unbeatable price. Located just minutes from downtown Welland, Niagara College, Seaway Mall, and Highway 406, you'll have easy access to everything this thriving area has to offer. Step inside and be greeted by high-end finishes throughout. The kitchen boasts sleek quartz countertops and stainless steel appliances, providing a sophisticated touch to this low-maintenance home. Enjoy the convenience of in-suite laundry and the comfort of knowing one parking spot is included. Whether you're a first-time homebuyer or an investor looking for a turnkey property, this stylish, affordable home is the perfect addition to your portfolio. Opportunities like this don't last long—act now!" +"ArchitecturalStyle": "Stacked Townhouse" +"AssociationAmenities": array:1 [ 0 => "Visitor Parking" ] +"AssociationFee": "211.72" +"AssociationFeeIncludes": array:1 [ 0 => "Unknown" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "767 - N. Welland" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T14:44:08.449468+00:00" +"CrossStreet": "From 406, exit Woodland Rd, South on Clare" +"DaysOnMarket": 220 +"ExpirationDate": "2025-02-18" +"Inclusions": "Furniture is negotiable, Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": "On Demand Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-18" +"LotSizeDimensions": "x" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-18T13:52:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-18T13:52:53Z" +"OriginalListPrice": 454900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40649050" +"ParcelNumber": "649880040" +"ParkingFeatures": "Unknown" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-11-17T07:17:31Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "6" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CLARE" +"StreetNumber": "781" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3039.0" +"TaxAssessedValue": 173000 +"TaxBookNumber": "271901000810310" +"TaxLegalDescription": "UNIT 40, LEVEL 1, NIAGARA SOUTH STANDARD CONDOMINIUM PLAN NO. 188 AND ITS APPURTENANT INTEREST SUBJECT TO EASEMENTS AS SET OUT IN SCHEDULE A AS IN SN756493 CITY OF WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "114" +"Zoning": "RL1" +"DDFYN": true +"Water": "Municipal" +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414598')" +"GarageType": "Outside/Surface" +"HeatSource": "Gas" +"BalconyType": "None" +"HoldoverDays": 30 +"LegalStories": "Call LBO" +"ParkingSpot1": "1" +"ParkingType1": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"CondoCorpNumber": 188 +"LivingAreaRange": "600-699" +"MediaListingKey": "154071833" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"SquareFootSource": "Builder" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"AdditionalMonthlyFee": 211.72 +"LegalApartmentNumber": "Call LBO" +"MediaChangeTimestamp": "2024-11-17T07:17:31Z" +"PropertyManagementCompany": "Wilson Blanchard" +"Media": array:21 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] ] +"ID": "165249" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12551 +post_id: "165253" +post_author: 1 +"ListingKey": "X9414404" +"ListingId": "X9414404" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:54:46Z" +"RFModificationTimestamp": "2025-04-25T16:53:49.815847+00:00" +"ListPrice": 4350000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1970.0 +"City": "Niagara-on-the-lake" +"PostalCode": "L0S 1J0" +"UnparsedAddress": "20 Tanbark Road, Niagara-on-the-lake, On L0s 1j0" +"Coordinates": array:2 [ 0 => -79.1089972 1 => 43.1695362 ] +"Latitude": 43.1695362 +"Longitude": -79.1089972 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to a slice of paradise nestled in the picturesque landscape of Niagara On The Lake. Presenting a rare opportunity to own a remarkable 75-acre farm property, boasting TWO spacious homes in good condition - House #1 has 7 bedrooms and 2 baths and House #2 has 4 bedrooms and 2 baths. House #2 is accompanied by an expansive barn - all three buildings have a sturdy metal roof. Escape the hustle and bustle of city life and immerse yourself in nature's tranquility. Explore acres of lush greenery, meandering pathways, and open spaces, perfect for hiking, horseback riding, or simply unwinding amidst the serene surroundings. This property is a haven for agricultural enthusiasts, featuring 24 acres of plums and 13.7 acres of grapes, all meticulously maintained with drip irrigation and underdrained systems. Whether you're a seasoned farmer or aspiring vintner, the fertile land and favorable climate create the perfect conditions for a thriving harvest year after year. For those with a passion for horses, the large barn with a durable metal roof provides ample space for stables, tack rooms, and storage, offering everything you need to indulge in your equestrian pursuits. Whether you're seeking a private sanctuary to call home, a picturesque setting for agricultural endeavors, or a lucrative investment opportunity, this exceptional property delivers on every front. Don't miss your chance to own a piece of paradise in one of Niagara's most coveted locations." +"ArchitecturalStyle": "Bungalow-Raised" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "107 - Glendale" +"ConstructionMaterials": array:1 [ 0 => "Wood" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "1.5" +"CreationDate": "2024-10-19T20:54:59.536051+00:00" +"CrossStreet": "STEELE & TANBARK" +"DaysOnMarket": 239 +"DirectionFaces": "Unknown" +"ExpirationDate": "2024-11-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Other, Stove, Washer, Wine Cooler" +"InteriorFeatures": "Accessory Apartment,None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-30" +"LotSizeDimensions": "x" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-10-01T18:19:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-30T16:47:10Z" +"OriginalListPrice": 4350000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40639951" +"ParcelNumber": "463730042" +"ParkingFeatures": "Front Yard Parking,Private Double" +"ParkingTotal": "11.0" +"PhotosChangeTimestamp": "2024-11-17T06:54:46Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Metal" +"RoomsTotal": "12" +"Sewer": "Septic" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "TANBARK" +"StreetNumber": "20" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5233.07" +"TaxAssessedValue": 959000 +"TaxBookNumber": "262702002417700" +"TaxLegalDescription": "PT TWP LT 93 NIAGARA PT 3, 4 & 5 30R2602; T/W RO230368; S/T NTP15990; NIAGARA-ON-THE-LAKE" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST. Co-operating brokerage commission will b" +"TransactionType": "For Sale" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Zoning": "A" +"DDFYN": true +"Water": "Unknown" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414404')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 10 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"MediaListingKey": "153371163" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 6 +"SquareFootSource": "Other" +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2024-11-17T06:54:46Z" +"Media": array:48 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] +"ID": "165253" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12549 +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": 229 +"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" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12546 +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": 266 +"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" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12545 +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": 303 +"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" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12552 +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": 207 +"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" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12553 +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": 207 +"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" } ] +success: true +page_size: 9 +page_count: 12406 +count: 111654 +after_key: "" } "RF Response Time" => "0.6 seconds" ] "RF Cache Key: b84637a09b32f66733d9f490918a2163ee148903e6ba926e09a429a9707abcd9" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#12808 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12569 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414800" +"ListingId": "X9414800" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:37:25Z" +"RFModificationTimestamp": "2025-04-26T19:26:30.008916+00:00" +"ListPrice": 739900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1260.0 +"City": "St. Catharines" +"PostalCode": "L2M 5R7" +"UnparsedAddress": "43 Cosby Avenue, St. Catharines, On L2m 5r7" +"Coordinates": array:2 [ 0 => -79.2238581 1 => 43.1745053 ] +"Latitude": 43.1745053 +"Longitude": -79.2238581 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REVEL Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "6.5% CAP RATE! Investors, seize the opportunity! This meticulously updated 3-unit building in the bustling heart of St. Catharines generates a 6.5% cap rate with a gross income of $60,000. Fully occupied and boasting ample parking with a detached garage, this property is designed for convenience. Recent upgrades, including a new roof (2018), furnace (2018), 2 x 100 amp panels, and modernized flooring, kitchens, and bathrooms in each unit, make it a contemporary and attractive investment. Situated near major highways, shopping centers, bus routes, and public transit hubs, this property offers unmatched accessibility. Whether expanding your portfolio or starting fresh, secure this prime investment opportunity today!" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "445 - Facer" +"CoListOfficeKey": "344731" +"CoListOfficeName": "REVEL Realty Inc., Brokerage" +"CoListOfficePhone": "905-357-1700" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-19T16:38:29.785519+00:00" +"CrossStreet": "Dieppe Rd & Welland Ave to Cosby" +"DaysOnMarket": 207 +"ElectricExpense": 2800.0 +"ExpirationDate": "2025-01-01" +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector" +"InsuranceExpense": 1400.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "None" ] +"ListingContractDate": "2024-10-01" +"LotSizeDimensions": "90 x 40" +"MainOfficeKey": "344700" +"MajorChangeTimestamp": "2024-10-01T12:05:29Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OperatingExpense": "11400.0" +"OriginalEntryTimestamp": "2024-10-01T12:05:29Z" +"OriginalListPrice": 739900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40655684" +"OtherExpense": 700.0 +"ParcelNumber": "462790051" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T07:37:25Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "COSBY" +"StreetNumber": "43" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2900.0" +"TaxAssessedValue": 180000 +"TaxBookNumber": "262903002210400" +"TaxLegalDescription": "LT 15 CY PL 97 GRANTHAM; ST. CATHARINES" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2%+hst" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Expenses": "Estimated" +"HeatType": "Forced Air" +"LotDepth": 90.0 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414800')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"HeatingExpenses": 2100.0 +"MediaListingKey": "154433365" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T07:37:25Z" +"Media": array:30 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12532 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414745" +"ListingId": "X9414745" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:32:00Z" +"RFModificationTimestamp": "2025-04-26T22:52:59.102290+00:00" +"ListPrice": 1249999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1552.0 +"City": "Niagara Falls" +"PostalCode": "L2G 1Y6" +"UnparsedAddress": "6437 - 6423 Barker Street, Niagara Falls, On L2g 1y6" +"Coordinates": array:2 [ 0 => -79.10198534127 1 => 43.087247792063 ] +"Latitude": 43.087247792063 +"Longitude": -79.10198534127 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Outstanding investment opportunity! Offering two homes on a large lot w/a severable portion and pre-approved drawings for a third home, this property is a dream come true for investors or multi-generational families. The prime location, flexible living arrangements, and development potential make this property an opportunity in today's market. House 1 is a versatile, income-generating powerhouse w/three distinct units, each designed to offer privacy & comfort: Unit 1: 2 beds, 1 bath—ideal for small families or young professionals. Unit 2: 2 beds, 2 baths—perfect for larger families or roommates seeking spacious living.\r\n Unit 3: A cozy studio apartment—great for single occupants. Each is self-sufficient w/its own washer & dryer, providing the convenience of in-unit laundry. There’s also the potential to add a fourth unit in the bsmt, further increasing rental income. Two of the units are already tenanted, offering a steady cash flow, while one remains vacant. House 2 is a spacious single-family home that offers 4 bedrooms, 2½ bathrooms—a large, comfortable living space for growing families A potential in-law suite—perfect for multi-generational living or additional rental income\r\n This house is currently tenanted, offering immediate income. The flexibility of month-to-month leases across both homes gives you the freedom to adjust rental terms as needed or take advantage of the vacancy for personal use. The severable lot comes complete w/approved drawings for a third home. This allows you to either expand your rental portfolio, develop and sell the additional home, or enjoy the flexibility of a custom-built property to meet your future needs. Nestled in a family-friendly neighborhood, the property is within walking distance of some of Niagara Falls' top schools, making it attractive to families seeking long-term rentals. For entertainment and tourism, you're just minutes from the Casino and Clifton Hill. """ +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CoListOfficeKey": "062235" +"CoListOfficeName": "RIGHT AT HOME REALTY, BROKERAGE" +"CoListOfficePhone": "905-637-1700" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "1.0" +"CreationDate": "2024-10-18T13:57:20.516545+00:00" +"CrossStreet": "DRUMMOND RD - BARKER STREET" +"DaysOnMarket": 201 +"Exclusions": "TENANT'S BELONGINGS IN THE OCCUPIED UNITS." +"ExpirationDate": "2024-12-27" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "X4 FRIDGES, X4 STOVES, X4 WASHERS, X4 DRYERS., Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-10-07" +"LotSizeDimensions": "110 x 60" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-10-07T15:43:11Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-07T15:43:11Z" +"OriginalListPrice": 1249999.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40654526" +"ParcelNumber": "643550120" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T07:32:00Z" +"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": "BARKER" +"StreetNumber": "6437 - 6423" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3275.0" +"TaxAssessedValue": 211000 +"TaxBookNumber": "272507001302100" +"TaxLegalDescription": """ LT 96 PL 64 STAMFORD; PT LT 95 PL 64 STAMFORD AS IN RO578340 CITY OF NIAGARA FALLS\r\n AND\r\n LT 94 PL 64 STAMFORD; PT LT 95 PL 64 STAMFORD AS IN RO404326 ; NIAGARA FALLS """ +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% PLUS HST. Note: Co-op brokerage commission wi" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "R1E" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotWidth": 60.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414745')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154376782" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-11-17T07:32:00Z" +"Media": array:46 [ 0 => array:26 [ …26] 1 => array:26 [ …26] …44 ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12543 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414598" +"ListingId": "X9414598" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T07:17:31Z" +"RFModificationTimestamp": "2025-04-25T17:04:13.341732+00:00" +"ListPrice": 454900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 660.0 +"City": "Welland" +"PostalCode": "L3C 0K1" +"UnparsedAddress": "781 Clare Avenue Unit 114, Welland, On L3c 0k1" +"Coordinates": array:2 [ …2] +"Latitude": 43.0125431 +"Longitude": -79.2804759 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this perfectly situated stacked townhome in the heart of Welland. Move-in ready and thoughtfully designed, this 1-bedroom, 1-bathroom condo offers modern living at an unbeatable price. Located just minutes from downtown Welland, Niagara College, Seaway Mall, and Highway 406, you'll have easy access to everything this thriving area has to offer. Step inside and be greeted by high-end finishes throughout. The kitchen boasts sleek quartz countertops and stainless steel appliances, providing a sophisticated touch to this low-maintenance home. Enjoy the convenience of in-suite laundry and the comfort of knowing one parking spot is included. Whether you're a first-time homebuyer or an investor looking for a turnkey property, this stylish, affordable home is the perfect addition to your portfolio. Opportunities like this don't last long—act now!" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:1 [ …1] +"AssociationFee": "211.72" +"AssociationFeeIncludes": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "767 - N. Welland" +"CoListOfficeKey": "285440" +"CoListOfficeName": "EXP Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-18T14:44:08.449468+00:00" +"CrossStreet": "From 406, exit Woodland Rd, South on Clare" +"DaysOnMarket": 220 +"ExpirationDate": "2025-02-18" +"Inclusions": "Furniture is negotiable, Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListingContractDate": "2024-09-18" +"LotSizeDimensions": "x" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2024-09-18T13:52:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-18T13:52:53Z" +"OriginalListPrice": 454900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40649050" +"ParcelNumber": "649880040" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-11-17T07:17:31Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "6" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CLARE" +"StreetNumber": "781" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3039.0" +"TaxAssessedValue": 173000 +"TaxBookNumber": "271901000810310" +"TaxLegalDescription": "UNIT 40, LEVEL 1, NIAGARA SOUTH STANDARD CONDOMINIUM PLAN NO. 188 AND ITS APPURTENANT INTEREST SUBJECT TO EASEMENTS AS SET OUT IN SCHEDULE A AS IN SN756493 CITY OF WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "114" +"Zoning": "RL1" +"DDFYN": true +"Water": "Municipal" +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414598')" +"GarageType": "Outside/Surface" +"HeatSource": "Gas" +"BalconyType": "None" +"HoldoverDays": 30 +"LegalStories": "Call LBO" +"ParkingSpot1": "1" +"ParkingType1": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"WashroomsType1": 1 +"CondoCorpNumber": 188 +"LivingAreaRange": "600-699" +"MediaListingKey": "154071833" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:1 [ …1] +"SquareFootSource": "Builder" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"AdditionalMonthlyFee": 211.72 +"LegalApartmentNumber": "Call LBO" +"MediaChangeTimestamp": "2024-11-17T07:17:31Z" +"PropertyManagementCompany": "Wilson Blanchard" +"Media": array:21 [ …21] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12542 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9414404" +"ListingId": "X9414404" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-17T06:54:46Z" +"RFModificationTimestamp": "2025-04-25T16:53:49.815847+00:00" +"ListPrice": 4350000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1970.0 +"City": "Niagara-on-the-lake" +"PostalCode": "L0S 1J0" +"UnparsedAddress": "20 Tanbark Road, Niagara-on-the-lake, On L0s 1j0" +"Coordinates": array:2 [ …2] +"Latitude": 43.1695362 +"Longitude": -79.1089972 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX NIAGARA REALTY LTD, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to a slice of paradise nestled in the picturesque landscape of Niagara On The Lake. Presenting a rare opportunity to own a remarkable 75-acre farm property, boasting TWO spacious homes in good condition - House #1 has 7 bedrooms and 2 baths and House #2 has 4 bedrooms and 2 baths. House #2 is accompanied by an expansive barn - all three buildings have a sturdy metal roof. Escape the hustle and bustle of city life and immerse yourself in nature's tranquility. Explore acres of lush greenery, meandering pathways, and open spaces, perfect for hiking, horseback riding, or simply unwinding amidst the serene surroundings. This property is a haven for agricultural enthusiasts, featuring 24 acres of plums and 13.7 acres of grapes, all meticulously maintained with drip irrigation and underdrained systems. Whether you're a seasoned farmer or aspiring vintner, the fertile land and favorable climate create the perfect conditions for a thriving harvest year after year. For those with a passion for horses, the large barn with a durable metal roof provides ample space for stables, tack rooms, and storage, offering everything you need to indulge in your equestrian pursuits. Whether you're seeking a private sanctuary to call home, a picturesque setting for agricultural endeavors, or a lucrative investment opportunity, this exceptional property delivers on every front. Don't miss your chance to own a piece of paradise in one of Niagara's most coveted locations." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "107 - Glendale" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "1.5" +"CreationDate": "2024-10-19T20:54:59.536051+00:00" +"CrossStreet": "STEELE & TANBARK" +"DaysOnMarket": 239 +"DirectionFaces": "Unknown" +"ExpirationDate": "2024-11-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Other, Stove, Washer, Wine Cooler" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-30" +"LotSizeDimensions": "x" +"MainOfficeKey": "322300" +"MajorChangeTimestamp": "2024-10-01T18:19:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-30T16:47:10Z" +"OriginalListPrice": 4350000.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40639951" +"ParcelNumber": "463730042" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "11.0" +"PhotosChangeTimestamp": "2024-11-17T06:54:46Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "12" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "TANBARK" +"StreetNumber": "20" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5233.07" +"TaxAssessedValue": 959000 +"TaxBookNumber": "262702002417700" +"TaxLegalDescription": "PT TWP LT 93 NIAGARA PT 3, 4 & 5 30R2602; T/W RO230368; S/T NTP15990; NIAGARA-ON-THE-LAKE" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST. Co-operating brokerage commission will b" +"TransactionType": "For Sale" +"WaterSource": array:1 [ …1] +"Zoning": "A" +"DDFYN": true +"Water": "Unknown" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9414404')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 10 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"MediaListingKey": "153371163" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 6 +"SquareFootSource": "Other" +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2024-11-17T06:54:46Z" +"Media": array:48 [ …48] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12225 +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 [ …2] +"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 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "216 - Dorchester" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"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": 229 +"ExpirationDate": "2024-11-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Other, Smoke Detector, Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"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 [ …1] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2024-11-17T06:52:20Z" +"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": "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 [ …1] +"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 [ …1] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "153235722" +"PropertyFeatures": array:1 [ …1] +"LotIrregularities": "SEE GEOWAREHOUSE" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:52:20Z" +"Media": array:38 [ …38] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12565 +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 [ …2] +"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 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "562 - Hurricane/Merrittville" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T11:51:05.349735+00:00" +"CrossStreet": "off Hansler Road" +"DaysOnMarket": 266 +"DirectionFaces": "Unknown" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2025-04-10" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "None, Hot Water Tank Owned" +"InteriorFeatures": array:1 [ …1] +"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 [ …2] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-11-17T06:43:39Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 1090000.0 +"PriceChangeTimestamp": "2024-09-13T13:12:18Z" +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"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 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "New" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"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 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-11-17T06:43:39Z" +"Media": array:50 [ …50] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12566 +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 [ …2] +"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 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "768 - Welland Downtown" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T16:03:29.329948+00:00" +"CrossStreet": "KING ST SOUTH TO ALBERT NEAR KENT ST" +"DaysOnMarket": 303 +"DirectionFaces": "North" +"ExpirationDate": "2025-01-02" +"ExteriorFeatures": array:2 [ …2] +"FoundationDetails": array:1 [ …1] +"Inclusions": "Microwave, Smoke Detector, Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"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 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-11-17T06:34:29Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 450000.0 +"PriceChangeTimestamp": "2024-11-11T10:43:14Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"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 [ …1] +"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 [ …1] +"MediaListingKey": "152060660" +"PropertyFeatures": array:1 [ …1] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"MediaChangeTimestamp": "2024-11-17T06:34:29Z" +"Media": array:27 [ …27] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12567 +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 [ …2] +"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 [ …1] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "450 - E. Chester" +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T17:28:50.501543+00:00" +"CrossStreet": "On Queenston St between Page and Tasker" +"DaysOnMarket": 207 +"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 [ …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": "302" +"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('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] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12568 +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": 207 +"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] } ] +success: true +page_size: 9 +page_count: 12406 +count: 111654 +after_key: "" } ] ]
