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=108828&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=108828&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=108828&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=108828&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13067 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13061 +post_id: "154493" +post_author: 1 +"ListingKey": "X10403442" +"ListingId": "X10403442" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:45:39Z" +"RFModificationTimestamp": "2024-12-13T02:30:53.355463+00:00" +"ListPrice": 949500.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3025.55 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "123 Coulas Crescent, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ 0 => -80.282205355592 1 => 42.92206687865 ] +"Latitude": 42.92206687865 +"Longitude": -80.282205355592 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Spacious Detached bungalow on a lrg lot in the quaint Waterford. ~100K in upgrades. Lrg windows lets in natural sunlight on both levels. Wood flrs throughout, no carpet. 2 separate living spaces w/ dedicated bdrms, kitchens & laundry rms. The main flr boasts a lrg open concept living space w/ recessed ceilings, 3 spacious bdrms, 2 full baths. The main kitchen features S/S appliances, quartz countertops and walk-in pantry. Eat-in kitchen features a walkout to the backyard. The fully finished basement boasts a separate entrance from the front foyer leading to the granny suite with open concept living/dining space, kitchen, 3 spacious bdrms and 1.5 baths. Perfect for housing an additional family or potential for a possible extra income venture. Dbl Garage features an auto garage door opener, a man door to the side yard and accesses the house via the laundry/mudroom. The backyard showcases a gazebo, lrg shed, rustic fire pit and enough space for possibly a family pool oasis in the future." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ 0 => "Walk-Up" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:29:32.157357+00:00" +"CrossStreet": "Thompson Rd E / Old Hwy 24" +"DaysOnMarket": 260 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-02-26" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Garage Door Opener, Window Coverings" +"InteriorFeatures": "Accessory Apartment,Water Heater Owned,Sump Pump" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-27" +"LotSizeDimensions": "147.1 x 63.92" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-10-31T09:37:18Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-08-27T13:21:32Z" +"OriginalListPrice": 980000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40638394" +"ParcelNumber": "502830448" +"ParkingFeatures": "Private Double,Other,Other" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-12-11T14:45:39Z" +"PoolFeatures": "None" +"PreviousListPrice": 980000.0 +"PriceChangeTimestamp": "2024-10-31T09:37:18Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "16" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "COULAS" +"StreetNumber": "123" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "5884.38" +"TaxAssessedValue": 390000 +"TaxBookNumber": "331033605035016" +"TaxLegalDescription": "LOT 16, PLAN 37M-45, NORFOLK COUNTY." +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/123_coulas_crescent_waterford_on/" +"Zoning": "A" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 147.1 +"LotWidth": 63.92 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403442')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 2 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"MediaListingKey": "153275444" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 8 +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"WashroomsType4Level": "Lower" +"MediaChangeTimestamp": "2024-12-11T14:45:39Z" +"Media": array:23 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] ] +"ID": "154493" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13063 +post_id: "154495" +post_author: 1 +"ListingKey": "X10403419" +"ListingId": "X10403419" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:44:23Z" +"RFModificationTimestamp": "2024-12-13T02:34:06.191960+00:00" +"ListPrice": 2199998.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1W0" +"UnparsedAddress": "1119 Glancaster Road, Hamilton, On L0r 1w0" +"Coordinates": array:2 [ 0 => -79.938791399258 1 => 43.184404865726 ] +"Latitude": 43.184404865726 +"Longitude": -79.938791399258 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "FULLY RENOVATED INDEPENDENT 3 UNITS. (1.48 Acres) Land Industrial M11 Airport Prestigious Business Zoned. Recently Fully renovated Raised Bungalow with Separate 3 Units situated near YHM Hamilton Airport and Amazon Fulfillment Centre. Please check pictures / supplements and watch the 3D matterport for all 3 units prior to booking showing. Lots of potlights, New appliances, REPLACED Rental Furnace/AC, MOST Windows, Roof Soffits, Doors, Vinyl Siding, Landscaping 200 AMPS and much more....." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Airport Employment Area" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-04T05:30:36.831233+00:00" +"CrossStreet": "TAKE GARNER / RYMAL RD W TURN ON GLANCASTER RD" +"DaysOnMarket": 548 +"Exclusions": "None" +"ExpirationDate": "2024-12-12" +"Inclusions": "3 FRIDGE, 3 STOVE, 3 WASHER DRYER, 1 DISH WASHER." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2023-11-01" +"LotSizeDimensions": "571 x 112" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-08-27T22:42:41Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2023-11-01T21:33:43Z" +"OriginalListPrice": 2199999.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40505723" +"ParcelNumber": "173990068" +"PhotosChangeTimestamp": "2024-12-11T14:44:23Z" +"PoolFeatures": "None" +"PreviousListPrice": 2199999.0 +"PriceChangeTimestamp": "2024-08-27T22:42:41Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GLANCASTER" +"StreetNumber": "1119" +"StreetSuffix": "Road" +"TaxAnnualAmount": "4778.0" +"TaxAssessedValue": 431000 +"TaxBookNumber": "251890231008400" +"TaxLegalDescription": "PT LT 1, CON 3 GLANFORD , AS IN VM63393 ; HAMILTON" +"TaxYear": "2023" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "http://www.myvisuallistings.com/cvtnb/342195" +"Zoning": "M11" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"CableYNA": "Yes" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 571.0 +"LotWidth": 112.0 +"SoilTest": "No" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403419')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"TelephoneYNA": "Available" +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:2 [ 0 => "Cell Services" 1 => "Other" ] +"MediaListingKey": "144848934" +"SalesBrochureUrl": "https://hoodq.com/imtiaz-kiani/explore/hamilton-on/airport-employment-area" +"LotIrregularities": "112.70 ft x 572.22 ft x 113.17 ft x 572.05 ft" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:44:23Z" +"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": "154495" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13060 +post_id: "154496" +post_author: 1 +"ListingKey": "X10404510" +"ListingId": "X10404510" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:43:29Z" +"RFModificationTimestamp": "2025-04-29T15:02:51.021445+00:00" +"ListPrice": 999999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2385.0 +"City": "Hamilton" +"PostalCode": "L8M 2K1" +"UnparsedAddress": "49 Fairleigh S Avenue, Hamilton, On L8m 2k1" +"Coordinates": array:2 [ 0 => -79.8431303 1 => 43.2498255 ] +"Latitude": 43.2498255 +"Longitude": -79.8431303 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Aboutowne Realty Corp., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own this FULLY VACANT, newly renovated three unit home in Hamilton Centre with potential for a large fourth unit in the basement! Buyer to set their own rent at market value. The house comes equipped with 3 units. Unit 1 is a vacant two-bedroom suite with the income potential of $2,400+ (Also great for Airbnb), Unit 2 is a newly renovated vacant two-bedroom unit ($2,300), and unit 3 features a really cool bachelor loft space on the 3rd floor, with the income potential of $1,550+. The Gross Annual income is $78,600.00. This is a Rare offering and huge opportunity to increase your annual income by finishing the basement which could bring an additional income of $1,500+ per month. The property features a large Double lot (43 x 105) ft lot, a massive driveway with 5+ parking spots and an oversized two-car garage with forecasted rent of ($400+). Perfect for a savvy investor or purchaser looking to supplement their mortgage payment. Huge income opportunity to be had, do not miss out on this rare offering. Seller in the works of obtaining permit to finish basement legally, and turning home into legal 4plex. steps to downtown, Go Station and highways, the property is located in a desirable family-friendly neighbourhood." +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Gibson" +"CoListOfficeKey": "542900" +"CoListOfficeName": "RE/MAX Aboutowne Realty Corp., Brokerage" +"CoListOfficePhone": "905-842-7000" +"CommunityFeatures": "Park" +"ConstructionMaterials": array:2 [ 0 => "Shingle" 1 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:02:34.575856+00:00" +"CrossStreet": "Queen to Fairleigh South" +"DaysOnMarket": 198 +"ElectricExpense": 1080.0 +"ExpirationDate": "2025-02-28" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Garage Door Opener, Window Coverings" +"InsuranceExpense": 1733.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Common Area" 1 => "Shared" ] +"ListingContractDate": "2024-10-28" +"LotSizeDimensions": "105.05 x 43.09" +"MainOfficeKey": "542900" +"MaintenanceExpense": 1800.0 +"MajorChangeTimestamp": "2024-10-28T07:45:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-28T07:45:58Z" +"OriginalListPrice": 999999.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669802" +"ParcelNumber": "172020067" +"ParkingFeatures": "Private Double" +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2024-12-11T14:43:29Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "FAIRLEIGH" +"StreetNumber": "49" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4930.0" +"TaxAssessedValue": 396000 +"TaxBookNumber": "251803023156480" +"TaxLegalDescription": "PT LT 34, PL 399 ; PT RESIDENCE RESERVE, PL 399 , AS IN AB103026 ; HAMILTON" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Expenses": "Actual" +"HeatType": "Unknown" +"LotDepth": 105.05 +"LotWidth": 43.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404510')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 5 +"provider_name": "TRREB" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PossessionDate": "2024-12-01" +"HeatingExpenses": 2040.0 +"MediaListingKey": "155138687" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate P..." +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:43:29Z" +"Media": array:35 [ 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] ] +"ID": "154496" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13064 +post_id: "154499" +post_author: 1 +"ListingKey": "X10403433" +"ListingId": "X10403433" +"PropertyType": "Commercial" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:57Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Welland" +"PostalCode": "L3B 5N4" +"UnparsedAddress": "826 Lyons Creek N/a, Welland, On L3b 5n4" +"Coordinates": array:2 [ 0 => -79.17838 1 => 42.996702 ] +"Latitude": 42.996702 +"Longitude": -79.17838 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Re/Max Hallmark Alliance Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "20 acres flat farm land to build your dream home or lots of potential, blocks away from new home development. NOT IN GREENBELT, 4km to HWY 406/QEW access, 5 minutes away from Welland shopping center, 15 minutes away from Niagara Falls, minutes away from new proposed Niagara Falls hospital site. With access to hydro, natural gas and water at the road. Entrance on Lyons Creek and Guest Road. Please book appointment prior to visiting property." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "765 - Cooks Mills" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-11-04T05:23:19.312194+00:00" +"CrossStreet": "Moyer to Lyons Creek to Guest Rd. Enter property from Guest Rd." +"DaysOnMarket": 275 +"Disclosures": array:2 [ 0 => "Conservation Regulations" 1 => "Easement" ] +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-31" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "1720.91 x 588.86" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "211500" +"MajorChangeTimestamp": "2024-07-31T09:31:29Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-07-31T09:31:29Z" +"OriginalListPrice": 1199000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40627544" +"ParcelNumber": "642490046" +"PhotosChangeTimestamp": "2024-12-11T14:41:57Z" +"PoolFeatures": "None" +"PriceChangeTimestamp": "2024-07-31T09:31:29Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:3 [ 0 => "List Salesperson" 1 => "Showing System" 2 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LYONS CREEK" +"StreetNumber": "826" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "2163.22" +"TaxAssessedValue": 145000 +"TaxBookNumber": "271904000118800" +"TaxLegalDescription": "PT LT 11 CON 4 CROWLAND AS IN RO651360 LYING S OF RO648296 DESCRIPTION MAY NOT BE ACCEPTABLE IN FUTURE AS IN RO651360 ; S/T CR28233 WELLAND" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "A1,O2,RR" +"DDFYN": true +"Water": "None" +"GasYNA": "Available" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"FarmType": "Hobby" +"HeatType": "Unknown" +"LotDepth": 1720.91 +"LotWidth": 588.86 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403433')" +"GarageType": "Unknown" +"ElectricYNA": "Available" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "152578158" +"LotIrregularities": "1721x132x9.54x102x331x102x333x201x52x1461x512ft" +"LotSizeRangeAcres": "10-24.99" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:41:57Z" +"Media": array:11 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] ] +"ID": "154499" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13062 +post_id: "154500" +post_author: 1 +"ListingKey": "W10403776" +"ListingId": "W10403776" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:49Z" +"RFModificationTimestamp": "2024-12-13T02:41:13.455922+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2352.0 +"City": "Oakville" +"PostalCode": "L6L 1C4" +"UnparsedAddress": "2378 Marine Drive, Oakville, On L6l 1a6" +"Coordinates": array:2 [ 0 => -79.708171666667 1 => 43.395553566667 ] +"Latitude": 43.395553566667 +"Longitude": -79.708171666667 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sutton Group Quantum Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own a private executive end unit at the prestigious Harbour Club in the heart of Bronte Village! Spectacular open concept Cape Cod style townhouse with 2352 SF just steps to Bronte Harbour waterfront park and trails. Fabulous restaurants and shops are just one block away! Beautifully upgraded open concept living/dining design is perfect for entertaining and boasts stunning 9 foot ceilings, hardwood flooring, crown moulding, and a limestone gas fireplace.The gourmet kitchen features a centre island, granite countertops, travertine floors, and built-in stainless steel appliances. Double French Doors open to massive 350 SF sun-drenched terrace. Spacious primary bedroom with 16 foot vaulted ceiling, his and her closets, and french doors to a private balcony. Large 5-piece ensuite bath has double sinks, granite countertop, glass shower, and a corner jetted tub.Huge second bedroom has 16 foot ceilings and french doors leading to another balcony. The laundry room is conveniently located between the two bedrooms.The lower level features a family room/3rd bedroom with 3-piece bath and inside access to the 2-car garage. Parking for 4 cars plus Visitors Parking! Don’t miss this opportunity to enjoy luxury lakeside living at its finest!" +"ArchitecturalStyle": "2-Storey" +"AssociationAmenities": array:1 [ 0 => "Visitor Parking" ] +"AssociationFee": "1244.45" +"AssociationFeeIncludes": array:3 [ 0 => "Building Insurance Included" 1 => "Common Elements Included" 2 => "Parking Included" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Harbour Club" +"CityRegion": "1001 - BR Bronte" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Stone" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-02T17:49:36.556993+00:00" +"CrossStreet": "Bronte Road/Marine Drive" +"DaysOnMarket": 231 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": "Deck,Lighting,Lawn Sprinkler System" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Built-in Microwave, Central Vacuum, Dishwasher, Dryer, Gas Stove, Garage Door Opener, Range Hood, Refrigerator, Smoke Detector, Washer" +"InteriorFeatures": "Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-09-27" +"LotSizeDimensions": "x" +"MainOfficeKey": "540900" +"MajorChangeTimestamp": "2024-09-27T08:14:06Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-27T08:14:06Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653869" +"ParcelNumber": "258200001" +"ParkingFeatures": "Other,Other,Reserved/Assigned,Inside Entry,Mutual" +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-12-11T14:41:49Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Shake,Cedar" +"RoomsTotal": "12" +"SecurityFeatures": array:1 [ 0 => "Alarm System" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MARINE" +"StreetNumber": "2378" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7871.0" +"TaxAssessedValue": 1035000 +"TaxBookNumber": "240102022010011" +"TaxLegalDescription": "UNIT 1, LEVEL 1, HALTON STANDARD CONDOMINIUM PLAN NO. 518 AND ITS APPURTENANT INTEREST." +"TaxYear": "2023" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Zoning": "RM1 sp:248" +"DDFYN": true +"Water": "Municipal" +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403776')" +"GarageType": "Attached" +"HeatSource": "Gas" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "Call LBO" +"ParkingType1": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"LivingAreaRange": "2250-2499" +"MediaListingKey": "154338527" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 3 +"SquareFootSource": "Plans" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "Call LBO" +"MediaChangeTimestamp": "2024-12-11T14:41:49Z" +"PropertyManagementCompany": "Central Erin Property" +"Media": array:41 [ 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] ] +"ID": "154500" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13059 +post_id: "154501" +post_author: 1 +"ListingKey": "X10404465" +"ListingId": "X10404465" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:36Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 774.0 +"City": "Hamilton" +"PostalCode": "L8R 1M7" +"UnparsedAddress": "15 Wellington N Street Unit 202, Hamilton, On L8r 1m7" +"Coordinates": array:2 [ 0 => -79.8593934 1 => 43.2541064 ] +"Latitude": 43.2541064 +"Longitude": -79.8593934 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to the home of your next business! Located on the intersection of two high-traffic corridors and at the entry to Hamilton's downtown core and International Village, 15 Wellington boasts significant visual exposure and potential for substantial foot traffic. Neighbouring tenants that include F45 Training, Red Rockets BBQ, Door Dash, and existing residential tenants mean plenty of secondary traffic. Walking distance to numerous recently-completed or under construction developments, such as Ki Wi Condos, 1 Jarvis, King William Rentals, and myriad existing retail, grocery, and restaurant businesses. With exposed brick and beautiful post and beam construction, this second floor office unit offers a large open concept area with two private rooms and washroom. With a highly flexible Downtown Central Business District D1 Zoning, the permitted uses are varied and plentiful. Rent includes TMI and is subject to separately metered or proportionate utilities. Parking available onsite for tenants at additional cost, ample area parking (street and off-site lots) available for customers. Square footage provided by Landlord." +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CoListOfficeKey": "541005" +"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"CoListOfficePhone": "905-296-3930" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:12:58.001699+00:00" +"CrossStreet": "On the west side of Wellington Street North between King Street East and King William Street." +"DaysOnMarket": 190 +"DirectionFaces": "East" +"ExpirationDate": "2025-01-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "177.38 x 132.27" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-24T14:16:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-24T14:16:14Z" +"OriginalListPrice": 1450.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40668793" +"ParcelNumber": "171680144" +"PhotosChangeTimestamp": "2024-12-11T14:41:36Z" +"PoolFeatures": "None" +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "WELLINGTON" +"StreetNumber": "15" +"StreetSuffix": "Street" +"TaxBookNumber": "251802018107000" +"TaxLegalDescription": "LT 11-13 PL 214; PT LT 14 PL 214; PT LT 16-18 PL 38 AS IN CD324982; CITY OF HAMILTON" +"TransactionBrokerCompensation": "4% year 1, 2% of remaining term" +"TransactionType": "For Lease" +"UnitNumber": "202" +"Utilities": "Unknown" +"Zoning": "D1 - Downtown Central Business District" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 177.38 +"LotWidth": 132.27 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404465')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 60 +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "155081100" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"OfficeApartmentArea": 774.0 +"MediaChangeTimestamp": "2024-12-11T14:41:36Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 36 +"Media": array:5 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] ] +"ID": "154501" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13058 +post_id: "154502" +post_author: 1 +"ListingKey": "X10403399" +"ListingId": "X10403399" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:22Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1065.0 +"City": "Sundridge" +"PostalCode": "P0A 1Z0" +"UnparsedAddress": "88 Main St Street, Sundridge, On P0a 1z0" +"Coordinates": array:2 [ 0 => -79.3913735 1 => 45.7709397 ] +"Latitude": 45.7709397 +"Longitude": -79.3913735 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "GREAT RETAIL PROPERTY SITUATED ON THE MAIN STREET OF SUNDRIDGE" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Parry Sound" +"CreationDate": "2024-11-04T05:36:00.135563+00:00" +"CrossStreet": "88 MAIN ST SUNDRIDGE" +"DaysOnMarket": 261 +"ExpirationDate": "2025-07-13" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-14" +"LotSizeDimensions": "140 x 92.98" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2024-08-14T15:14:59Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-08-14T15:14:59Z" +"OriginalListPrice": 1500.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40633676" +"ParcelNumber": "520720206" +"PhotosChangeTimestamp": "2024-12-11T14:41:22Z" +"PoolFeatures": "None" +"RentIncludes": array:1 [ 0 => "Building Insurance" ] +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MAIN ST" +"StreetNumber": "88" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 1 N/S MAIN ST, 2 N/S MAIN ST PL 28 PT 1 & 2 42R5554; SUNDRIDGE" +"TransactionBrokerCompensation": "4% FIRST YEAR AND 2% REMAINING YEARS OF TERM" +"TransactionType": "For Lease" +"Utilities": "Unknown" +"Zoning": "C1" +"DDFYN": true +"Water": "Well" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 140.0 +"LotWidth": 92.98 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403399')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "152962165" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:41:22Z" +"MaximumRentalMonthsTerm": 36 +"MinimumRentalTermMonths": 36 +"Media": array:2 [ 0 => array:26 [ …26] 1 => array:26 [ …26] ] +"ID": "154502" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13065 +post_id: "154504" +post_author: 1 +"ListingKey": "X10403550" +"ListingId": "X10403550" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:40:53Z" +"RFModificationTimestamp": "2024-12-13T02:43:05.348788+00:00" +"ListPrice": 549500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 884.0 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "17b Lingwood Drive, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ 0 => -80.2879326 1 => 42.9357327 ] +"Latitude": 42.9357327 +"Longitude": -80.2879326 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "3 Bedroom 2 bath upgraded and well kept semi detached home on a quiet street in a lovely family oriented neighbor in quaint Waterford. Main floor has an open layout between the kitchen and living area. Very well maintained with many updated through out , the house, including new flooring. no carpet. Recently renovated kitchen with quartz countertops, stainless steep appliances. Two newly renovated bathrooms. Fully finished basement with large rec room that has a walkout to a deck, pool and shed. A large fenced backyard, backing onto rail trail and green space. Other upgrades include; newer furnace approx. 7 yrs old, shingles and attic insulation upgrade approx. 4 yrs. ago. Close to schools, parks, grocery and waterfront activities." +"ArchitecturalStyle": "Bungalow-Raised" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-03T23:04:42.271293+00:00" +"CrossStreet": "Concession 8 & Old Hwy 24" +"DaysOnMarket": 261 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Pool Equipment, Refrigerator, Stove, Washer" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-14" +"LotSizeDimensions": "162.56 x 38.66" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-09-13T18:53:23Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-14T18:44:37Z" +"OriginalListPrice": 579900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40633601" +"ParcelNumber": "502620143" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:40:53Z" +"PoolFeatures": "None" +"PreviousListPrice": 579900.0 +"PriceChangeTimestamp": "2024-09-13T18:53:23Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "9" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LINGWOOD" +"StreetNumber": "17B" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2851.66" +"TaxAssessedValue": 189000 +"TaxBookNumber": "331033504001950" +"TaxLegalDescription": "PT LT 10 PL 1006 PT 37R5395 NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17b_lingwood_dr_waterford_on/" +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 162.56 +"LotWidth": 38.66 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403550')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "152958335" +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 4 +"SquareFootSource": "Other" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2024-12-11T14:40:53Z" +"Media": array:25 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] ] +"ID": "154504" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13066 +post_id: "154505" +post_author: 1 +"ListingKey": "X10403263" +"ListingId": "X10403263" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:40:38Z" +"RFModificationTimestamp": "2024-12-13T02:43:30.247679+00:00" +"ListPrice": 2049000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 8800.0 +"City": "Brant" +"PostalCode": "N0E 1N0" +"UnparsedAddress": "41 Main S Street, Brant, On N0e 1n0" +"Coordinates": array:2 [ 0 => -80.3792963 1 => 43.1879108 ] +"Latitude": 43.1879108 +"Longitude": -80.3792963 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RCB Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Unique fully leased commercial investment opportunity in the heart of St. George. This century old former mill has been lovingly modernized while keeping many of the original finishes. Home to many local businesses, with approximately 8500sq.ft. of usable space featuring rustic finishes spread over four floors offers endless potential. The ground level features 2 storefront units. The second level is home to the St. George Mill Animal Hospital. The third level houses 5 professional offices featuring rustic beams and exposed stone, a waiting area, kitchenette and two wheelchair accessible washrooms. The fourth level, is open loft style, filled with natural light and exposed timbers. All levels of the building are accessible with interior stairs exterior stairs and exterior elevator. All levels have in-floor radiant heating with shared boiler, separate central air, and separate hydro meters. The asphalt circular driveway has parking spaces for approx 20 vehicles. With a steel roof and many updates this building is sure to provide a low maintenance investment for years to come." +"Basement": array:1 [ 0 => "Crawl Space" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Brant" +"CreationDate": "2024-11-02T17:59:36.191871+00:00" +"CrossStreet": "Main street south from Hwy 5. St George Rd north from Governors Rd" +"DaysOnMarket": 560 +"Exclusions": "Any items belonging to tenants." +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2023-10-20" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "x 146" +"LotSizeSource": "MPAC" +"MainOfficeKey": "071900" +"MajorChangeTimestamp": "2023-10-20T16:09:33Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2023-10-20T16:09:33Z" +"OriginalListPrice": 2049000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40488939" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-11T14:40:38Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detectors" 1 => "Other" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "MAIN" +"StreetNumber": "41" +"StreetSuffix": "Street" +"TaxAnnualAmount": "24233.0" +"TaxAssessedValue": 935000 +"TaxBookNumber": "292001603025800" +"TaxLegalDescription": "PLAN 81 BLK K PT LOT 1,2&3 RP 2R3488 PART 2 PART 3" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% Plus HST. 50% reduction in commission will be" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "C4-7" +"Rail": "No" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotWidth": 146.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403263')" +"ElevatorYN": true +"GarageType": "Unknown" +"PropertyUse": "With Property" +"ElevatorType": "Public" +"ListPriceUnit": "For Sale" +"UnderContract": array:2 [ 0 => "Other" 1 => "Hot Water Heater" ] +"provider_name": "TRREB" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "143777014" +"LotIrregularities": "See Survey in Supplements" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:40:38Z" +"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": "154505" } ] +success: true +page_size: 9 +page_count: 13253 +count: 119275 +after_key: "" } "RF Response Time" => "0.29 seconds" ] "RF Cache Key: 5f9ccdb82e6544bcca2540d432744acfb7c39bc24de151037e3521a3114ba5c2" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13267 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13082 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403442" +"ListingId": "X10403442" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:45:39Z" +"RFModificationTimestamp": "2024-12-13T02:30:53.355463+00:00" +"ListPrice": 949500.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3025.55 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "123 Coulas Crescent, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ 0 => -80.282205355592 1 => 42.92206687865 ] +"Latitude": 42.92206687865 +"Longitude": -80.282205355592 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Spacious Detached bungalow on a lrg lot in the quaint Waterford. ~100K in upgrades. Lrg windows lets in natural sunlight on both levels. Wood flrs throughout, no carpet. 2 separate living spaces w/ dedicated bdrms, kitchens & laundry rms. The main flr boasts a lrg open concept living space w/ recessed ceilings, 3 spacious bdrms, 2 full baths. The main kitchen features S/S appliances, quartz countertops and walk-in pantry. Eat-in kitchen features a walkout to the backyard. The fully finished basement boasts a separate entrance from the front foyer leading to the granny suite with open concept living/dining space, kitchen, 3 spacious bdrms and 1.5 baths. Perfect for housing an additional family or potential for a possible extra income venture. Dbl Garage features an auto garage door opener, a man door to the side yard and accesses the house via the laundry/mudroom. The backyard showcases a gazebo, lrg shed, rustic fire pit and enough space for possibly a family pool oasis in the future." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Walk-Up" 1 => "Finished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:29:32.157357+00:00" +"CrossStreet": "Thompson Rd E / Old Hwy 24" +"DaysOnMarket": 260 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-02-26" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Garage Door Opener, Window Coverings" +"InteriorFeatures": array:3 [ 0 => "Accessory Apartment" 1 => "Water Heater Owned" 2 => "Sump Pump" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-27" +"LotSizeDimensions": "147.1 x 63.92" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-10-31T09:37:18Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-08-27T13:21:32Z" +"OriginalListPrice": 980000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40638394" +"ParcelNumber": "502830448" +"ParkingFeatures": array:3 [ 0 => "Private Double" 1 => "Other" 2 => "Other" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2024-12-11T14:45:39Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 980000.0 +"PriceChangeTimestamp": "2024-10-31T09:37:18Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "16" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "COULAS" +"StreetNumber": "123" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "5884.38" +"TaxAssessedValue": 390000 +"TaxBookNumber": "331033605035016" +"TaxLegalDescription": "LOT 16, PLAN 37M-45, NORFOLK COUNTY." +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/123_coulas_crescent_waterford_on/" +"Zoning": "A" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotDepth": 147.1 +"LotWidth": 63.92 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403442')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 2 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"MediaListingKey": "153275444" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 8 +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"WashroomsType4Level": "Lower" +"MediaChangeTimestamp": "2024-12-11T14:45:39Z" +"Media": array:23 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13045 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403419" +"ListingId": "X10403419" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:44:23Z" +"RFModificationTimestamp": "2024-12-13T02:34:06.191960+00:00" +"ListPrice": 2199998.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1W0" +"UnparsedAddress": "1119 Glancaster Road, Hamilton, On L0r 1w0" +"Coordinates": array:2 [ 0 => -79.938791399258 1 => 43.184404865726 ] +"Latitude": 43.184404865726 +"Longitude": -79.938791399258 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "FULLY RENOVATED INDEPENDENT 3 UNITS. (1.48 Acres) Land Industrial M11 Airport Prestigious Business Zoned. Recently Fully renovated Raised Bungalow with Separate 3 Units situated near YHM Hamilton Airport and Amazon Fulfillment Centre. Please check pictures / supplements and watch the 3D matterport for all 3 units prior to booking showing. Lots of potlights, New appliances, REPLACED Rental Furnace/AC, MOST Windows, Roof Soffits, Doors, Vinyl Siding, Landscaping 200 AMPS and much more....." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Airport Employment Area" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-04T05:30:36.831233+00:00" +"CrossStreet": "TAKE GARNER / RYMAL RD W TURN ON GLANCASTER RD" +"DaysOnMarket": 548 +"Exclusions": "None" +"ExpirationDate": "2024-12-12" +"Inclusions": "3 FRIDGE, 3 STOVE, 3 WASHER DRYER, 1 DISH WASHER." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2023-11-01" +"LotSizeDimensions": "571 x 112" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-08-27T22:42:41Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2023-11-01T21:33:43Z" +"OriginalListPrice": 2199999.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40505723" +"ParcelNumber": "173990068" +"PhotosChangeTimestamp": "2024-12-11T14:44:23Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 2199999.0 +"PriceChangeTimestamp": "2024-08-27T22:42:41Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GLANCASTER" +"StreetNumber": "1119" +"StreetSuffix": "Road" +"TaxAnnualAmount": "4778.0" +"TaxAssessedValue": 431000 +"TaxBookNumber": "251890231008400" +"TaxLegalDescription": "PT LT 1, CON 3 GLANFORD , AS IN VM63393 ; HAMILTON" +"TaxYear": "2023" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"VirtualTourURLUnbranded": "http://www.myvisuallistings.com/cvtnb/342195" +"Zoning": "M11" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"CableYNA": "Yes" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 571.0 +"LotWidth": 112.0 +"SoilTest": "No" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403419')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"TelephoneYNA": "Available" +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:2 [ 0 => "Cell Services" 1 => "Other" ] +"MediaListingKey": "144848934" +"SalesBrochureUrl": "https://hoodq.com/imtiaz-kiani/explore/hamilton-on/airport-employment-area" +"LotIrregularities": "112.70 ft x 572.22 ft x 113.17 ft x 572.05 ft" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:44:23Z" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13056 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404510" +"ListingId": "X10404510" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:43:29Z" +"RFModificationTimestamp": "2025-04-29T15:02:51.021445+00:00" +"ListPrice": 999999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2385.0 +"City": "Hamilton" +"PostalCode": "L8M 2K1" +"UnparsedAddress": "49 Fairleigh S Avenue, Hamilton, On L8m 2k1" +"Coordinates": array:2 [ 0 => -79.8431303 1 => 43.2498255 ] +"Latitude": 43.2498255 +"Longitude": -79.8431303 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Aboutowne Realty Corp., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own this FULLY VACANT, newly renovated three unit home in Hamilton Centre with potential for a large fourth unit in the basement! Buyer to set their own rent at market value. The house comes equipped with 3 units. Unit 1 is a vacant two-bedroom suite with the income potential of $2,400+ (Also great for Airbnb), Unit 2 is a newly renovated vacant two-bedroom unit ($2,300), and unit 3 features a really cool bachelor loft space on the 3rd floor, with the income potential of $1,550+. The Gross Annual income is $78,600.00. This is a Rare offering and huge opportunity to increase your annual income by finishing the basement which could bring an additional income of $1,500+ per month. The property features a large Double lot (43 x 105) ft lot, a massive driveway with 5+ parking spots and an oversized two-car garage with forecasted rent of ($400+). Perfect for a savvy investor or purchaser looking to supplement their mortgage payment. Huge income opportunity to be had, do not miss out on this rare offering. Seller in the works of obtaining permit to finish basement legally, and turning home into legal 4plex. steps to downtown, Go Station and highways, the property is located in a desirable family-friendly neighbourhood." +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Gibson" +"CoListOfficeKey": "542900" +"CoListOfficeName": "RE/MAX Aboutowne Realty Corp., Brokerage" +"CoListOfficePhone": "905-842-7000" +"CommunityFeatures": array:1 [ 0 => "Park" ] +"ConstructionMaterials": array:2 [ 0 => "Shingle" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:02:34.575856+00:00" +"CrossStreet": "Queen to Fairleigh South" +"DaysOnMarket": 198 +"ElectricExpense": 1080.0 +"ExpirationDate": "2025-02-28" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Garage Door Opener, Window Coverings" +"InsuranceExpense": 1733.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListingContractDate": "2024-10-28" +"LotSizeDimensions": "105.05 x 43.09" +"MainOfficeKey": "542900" +"MaintenanceExpense": 1800.0 +"MajorChangeTimestamp": "2024-10-28T07:45:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-28T07:45:58Z" +"OriginalListPrice": 999999.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669802" +"ParcelNumber": "172020067" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2024-12-11T14:43:29Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "FAIRLEIGH" +"StreetNumber": "49" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4930.0" +"TaxAssessedValue": 396000 +"TaxBookNumber": "251803023156480" +"TaxLegalDescription": "PT LT 34, PL 399 ; PT RESIDENCE RESERVE, PL 399 , AS IN AB103026 ; HAMILTON" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Expenses": "Actual" +"HeatType": "Unknown" +"LotDepth": 105.05 +"LotWidth": 43.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404510')" +"GarageType": "Detached" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"ListPriceUnit": "For Sale" +"ParkingSpaces": 5 +"provider_name": "TRREB" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2024-12-01" +"HeatingExpenses": 2040.0 +"MediaListingKey": "155138687" +"PropertyFeatures": array:1 [ …1] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate P..." +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:43:29Z" +"Media": array:35 [ …35] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13055 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403433" +"ListingId": "X10403433" +"PropertyType": "Commercial Sale" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:57Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Welland" +"PostalCode": "L3B 5N4" +"UnparsedAddress": "826 Lyons Creek N/a, Welland, On L3b 5n4" +"Coordinates": array:2 [ …2] +"Latitude": 42.996702 +"Longitude": -79.17838 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Re/Max Hallmark Alliance Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "20 acres flat farm land to build your dream home or lots of potential, blocks away from new home development. NOT IN GREENBELT, 4km to HWY 406/QEW access, 5 minutes away from Welland shopping center, 15 minutes away from Niagara Falls, minutes away from new proposed Niagara Falls hospital site. With access to hydro, natural gas and water at the road. Entrance on Lyons Creek and Guest Road. Please book appointment prior to visiting property." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "765 - Cooks Mills" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-11-04T05:23:19.312194+00:00" +"CrossStreet": "Moyer to Lyons Creek to Guest Rd. Enter property from Guest Rd." +"DaysOnMarket": 275 +"Disclosures": array:2 [ …2] +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-07-31" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "1720.91 x 588.86" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "211500" +"MajorChangeTimestamp": "2024-07-31T09:31:29Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-07-31T09:31:29Z" +"OriginalListPrice": 1199000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40627544" +"ParcelNumber": "642490046" +"PhotosChangeTimestamp": "2024-12-11T14:41:57Z" +"PoolFeatures": array:1 [ …1] +"PriceChangeTimestamp": "2024-07-31T09:31:29Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LYONS CREEK" +"StreetNumber": "826" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "2163.22" +"TaxAssessedValue": 145000 +"TaxBookNumber": "271904000118800" +"TaxLegalDescription": "PT LT 11 CON 4 CROWLAND AS IN RO651360 LYING S OF RO648296 DESCRIPTION MAY NOT BE ACCEPTABLE IN FUTURE AS IN RO651360 ; S/T CR28233 WELLAND" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "A1,O2,RR" +"DDFYN": true +"Water": "None" +"GasYNA": "Available" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"FarmType": "Hobby" +"HeatType": "Unknown" +"LotDepth": 1720.91 +"LotWidth": 588.86 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403433')" +"GarageType": "Unknown" +"ElectricYNA": "Available" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "152578158" +"LotIrregularities": "1721x132x9.54x102x331x102x333x201x52x1461x512ft" +"LotSizeRangeAcres": "10-24.99" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:41:57Z" +"Media": array:11 [ …11] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#10982 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10403776" +"ListingId": "W10403776" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:49Z" +"RFModificationTimestamp": "2024-12-13T02:41:13.455922+00:00" +"ListPrice": 1750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2352.0 +"City": "Oakville" +"PostalCode": "L6L 1C4" +"UnparsedAddress": "2378 Marine Drive, Oakville, On L6l 1a6" +"Coordinates": array:2 [ …2] +"Latitude": 43.395553566667 +"Longitude": -79.708171666667 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sutton Group Quantum Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own a private executive end unit at the prestigious Harbour Club in the heart of Bronte Village! Spectacular open concept Cape Cod style townhouse with 2352 SF just steps to Bronte Harbour waterfront park and trails. Fabulous restaurants and shops are just one block away! Beautifully upgraded open concept living/dining design is perfect for entertaining and boasts stunning 9 foot ceilings, hardwood flooring, crown moulding, and a limestone gas fireplace.The gourmet kitchen features a centre island, granite countertops, travertine floors, and built-in stainless steel appliances. Double French Doors open to massive 350 SF sun-drenched terrace. Spacious primary bedroom with 16 foot vaulted ceiling, his and her closets, and french doors to a private balcony. Large 5-piece ensuite bath has double sinks, granite countertop, glass shower, and a corner jetted tub.Huge second bedroom has 16 foot ceilings and french doors leading to another balcony. The laundry room is conveniently located between the two bedrooms.The lower level features a family room/3rd bedroom with 3-piece bath and inside access to the 2-car garage. Parking for 4 cars plus Visitors Parking! Don’t miss this opportunity to enjoy luxury lakeside living at its finest!" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:1 [ …1] +"AssociationFee": "1244.45" +"AssociationFeeIncludes": array:3 [ …3] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BuildingName": "Harbour Club" +"CityRegion": "1001 - BR Bronte" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-02T17:49:36.556993+00:00" +"CrossStreet": "Bronte Road/Marine Drive" +"DaysOnMarket": 231 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Central Vacuum, Dishwasher, Dryer, Gas Stove, Garage Door Opener, Range Hood, Refrigerator, Smoke Detector, Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListingContractDate": "2024-09-27" +"LotSizeDimensions": "x" +"MainOfficeKey": "540900" +"MajorChangeTimestamp": "2024-09-27T08:14:06Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-27T08:14:06Z" +"OriginalListPrice": 1750000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653869" +"ParcelNumber": "258200001" +"ParkingFeatures": array:5 [ …5] +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2024-12-11T14:41:49Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:2 [ …2] +"RoomsTotal": "12" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MARINE" +"StreetNumber": "2378" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7871.0" +"TaxAssessedValue": 1035000 +"TaxBookNumber": "240102022010011" +"TaxLegalDescription": "UNIT 1, LEVEL 1, HALTON STANDARD CONDOMINIUM PLAN NO. 518 AND ITS APPURTENANT INTEREST." +"TaxYear": "2023" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Zoning": "RM1 sp:248" +"DDFYN": true +"Water": "Municipal" +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10403776')" +"GarageType": "Attached" +"HeatSource": "Gas" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "Call LBO" +"ParkingType1": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"LivingAreaRange": "2250-2499" +"MediaListingKey": "154338527" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 3 +"SquareFootSource": "Plans" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "Call LBO" +"MediaChangeTimestamp": "2024-12-11T14:41:49Z" +"PropertyManagementCompany": "Central Erin Property" +"Media": array:41 [ …41] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13078 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404465" +"ListingId": "X10404465" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:36Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 774.0 +"City": "Hamilton" +"PostalCode": "L8R 1M7" +"UnparsedAddress": "15 Wellington N Street Unit 202, Hamilton, On L8r 1m7" +"Coordinates": array:2 [ …2] +"Latitude": 43.2541064 +"Longitude": -79.8593934 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to the home of your next business! Located on the intersection of two high-traffic corridors and at the entry to Hamilton's downtown core and International Village, 15 Wellington boasts significant visual exposure and potential for substantial foot traffic. Neighbouring tenants that include F45 Training, Red Rockets BBQ, Door Dash, and existing residential tenants mean plenty of secondary traffic. Walking distance to numerous recently-completed or under construction developments, such as Ki Wi Condos, 1 Jarvis, King William Rentals, and myriad existing retail, grocery, and restaurant businesses. With exposed brick and beautiful post and beam construction, this second floor office unit offers a large open concept area with two private rooms and washroom. With a highly flexible Downtown Central Business District D1 Zoning, the permitted uses are varied and plentiful. Rent includes TMI and is subject to separately metered or proportionate utilities. Parking available onsite for tenants at additional cost, ample area parking (street and off-site lots) available for customers. Square footage provided by Landlord." +"Basement": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CoListOfficeKey": "541005" +"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"CoListOfficePhone": "905-296-3930" +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:12:58.001699+00:00" +"CrossStreet": "On the west side of Wellington Street North between King Street East and King William Street." +"DaysOnMarket": 190 +"DirectionFaces": "East" +"ExpirationDate": "2025-01-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-24" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "177.38 x 132.27" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-24T14:16:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-24T14:16:14Z" +"OriginalListPrice": 1450.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40668793" +"ParcelNumber": "171680144" +"PhotosChangeTimestamp": "2024-12-11T14:41:36Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "WELLINGTON" +"StreetNumber": "15" +"StreetSuffix": "Street" +"TaxBookNumber": "251802018107000" +"TaxLegalDescription": "LT 11-13 PL 214; PT LT 14 PL 214; PT LT 16-18 PL 38 AS IN CD324982; CITY OF HAMILTON" +"TransactionBrokerCompensation": "4% year 1, 2% of remaining term" +"TransactionType": "For Lease" +"UnitNumber": "202" +"Utilities": array:1 [ …1] +"Zoning": "D1 - Downtown Central Business District" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 177.38 +"LotWidth": 132.27 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404465')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 60 +"ListPriceUnit": "Gross Lease" +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "155081100" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"OfficeApartmentArea": 774.0 +"MediaChangeTimestamp": "2024-12-11T14:41:36Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 36 +"Media": array:5 [ …5] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13079 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403399" +"ListingId": "X10403399" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:41:22Z" +"RFModificationTimestamp": "2025-04-28T07:56:16.870417+00:00" +"ListPrice": 1500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1065.0 +"City": "Sundridge" +"PostalCode": "P0A 1Z0" +"UnparsedAddress": "88 Main St Street, Sundridge, On P0a 1z0" +"Coordinates": array:2 [ …2] +"Latitude": 45.7709397 +"Longitude": -79.3913735 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "GREAT RETAIL PROPERTY SITUATED ON THE MAIN STREET OF SUNDRIDGE" +"Basement": array:1 [ …1] +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Parry Sound" +"CreationDate": "2024-11-04T05:36:00.135563+00:00" +"CrossStreet": "88 MAIN ST SUNDRIDGE" +"DaysOnMarket": 261 +"ExpirationDate": "2025-07-13" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-14" +"LotSizeDimensions": "140 x 92.98" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2024-08-14T15:14:59Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-08-14T15:14:59Z" +"OriginalListPrice": 1500.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40633676" +"ParcelNumber": "520720206" +"PhotosChangeTimestamp": "2024-12-11T14:41:22Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MAIN ST" +"StreetNumber": "88" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LT 1 N/S MAIN ST, 2 N/S MAIN ST PL 28 PT 1 & 2 42R5554; SUNDRIDGE" +"TransactionBrokerCompensation": "4% FIRST YEAR AND 2% REMAINING YEARS OF TERM" +"TransactionType": "For Lease" +"Utilities": array:1 [ …1] +"Zoning": "C1" +"DDFYN": true +"Water": "Well" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotDepth": 140.0 +"LotWidth": 92.98 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403399')" +"GarageType": "Unknown" +"PropertyUse": "Unknown" +"HoldoverDays": 90 +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "152962165" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:41:22Z" +"MaximumRentalMonthsTerm": 36 +"MinimumRentalTermMonths": 36 +"Media": array:2 [ …2] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13080 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403550" +"ListingId": "X10403550" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:40:53Z" +"RFModificationTimestamp": "2024-12-13T02:43:05.348788+00:00" +"ListPrice": 549500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 884.0 +"City": "Norfolk County" +"PostalCode": "N0E 1Y0" +"UnparsedAddress": "17b Lingwood Drive, Norfolk County, On N0e 1y0" +"Coordinates": array:2 [ …2] +"Latitude": 42.9357327 +"Longitude": -80.2879326 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Credit Valley Real Estate Inc., Broke" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "3 Bedroom 2 bath upgraded and well kept semi detached home on a quiet street in a lovely family oriented neighbor in quaint Waterford. Main floor has an open layout between the kitchen and living area. Very well maintained with many updated through out , the house, including new flooring. no carpet. Recently renovated kitchen with quartz countertops, stainless steep appliances. Two newly renovated bathrooms. Fully finished basement with large rec room that has a walkout to a deck, pool and shed. A large fenced backyard, backing onto rail trail and green space. Other upgrades include; newer furnace approx. 7 yrs old, shingles and attic insulation upgrade approx. 4 yrs. ago. Close to schools, parks, grocery and waterfront activities." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-03T23:04:42.271293+00:00" +"CrossStreet": "Concession 8 & Old Hwy 24" +"DaysOnMarket": 261 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Pool Equipment, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-14" +"LotSizeDimensions": "162.56 x 38.66" +"MainOfficeKey": "009700" +"MajorChangeTimestamp": "2024-09-13T18:53:23Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-14T18:44:37Z" +"OriginalListPrice": 579900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40633601" +"ParcelNumber": "502620143" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:40:53Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 579900.0 +"PriceChangeTimestamp": "2024-09-13T18:53:23Z" +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "9" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "LINGWOOD" +"StreetNumber": "17B" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2851.66" +"TaxAssessedValue": 189000 +"TaxBookNumber": "331033504001950" +"TaxLegalDescription": "PT LT 10 PL 1006 PT 37R5395 NORFOLK COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/17b_lingwood_dr_waterford_on/" +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"Exposure": "North" +"HeatType": "Forced Air" +"LotDepth": 162.56 +"LotWidth": 38.66 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403550')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "152958335" +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 4 +"SquareFootSource": "Other" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2024-12-11T14:40:53Z" +"Media": array:25 [ …25] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13081 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403263" +"ListingId": "X10403263" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:40:38Z" +"RFModificationTimestamp": "2024-12-13T02:43:30.247679+00:00" +"ListPrice": 2049000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 8800.0 +"City": "Brant" +"PostalCode": "N0E 1N0" +"UnparsedAddress": "41 Main S Street, Brant, On N0e 1n0" +"Coordinates": array:2 [ …2] +"Latitude": 43.1879108 +"Longitude": -80.3792963 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RCB Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Unique fully leased commercial investment opportunity in the heart of St. George. This century old former mill has been lovingly modernized while keeping many of the original finishes. Home to many local businesses, with approximately 8500sq.ft. of usable space featuring rustic finishes spread over four floors offers endless potential. The ground level features 2 storefront units. The second level is home to the St. George Mill Animal Hospital. The third level houses 5 professional offices featuring rustic beams and exposed stone, a waiting area, kitchenette and two wheelchair accessible washrooms. The fourth level, is open loft style, filled with natural light and exposed timbers. All levels of the building are accessible with interior stairs exterior stairs and exterior elevator. All levels have in-floor radiant heating with shared boiler, separate central air, and separate hydro meters. The asphalt circular driveway has parking spaces for approx 20 vehicles. With a steel roof and many updates this building is sure to provide a low maintenance investment for years to come." +"Basement": array:1 [ …1] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Brant" +"CreationDate": "2024-11-02T17:59:36.191871+00:00" +"CrossStreet": "Main street south from Hwy 5. St George Rd north from Governors Rd" +"DaysOnMarket": 560 +"Exclusions": "Any items belonging to tenants." +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2023-10-20" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "x 146" +"LotSizeSource": "MPAC" +"MainOfficeKey": "071900" +"MajorChangeTimestamp": "2023-10-20T16:09:33Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2023-10-20T16:09:33Z" +"OriginalListPrice": 2049000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40488939" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2024-12-11T14:40:38Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "MAIN" +"StreetNumber": "41" +"StreetSuffix": "Street" +"TaxAnnualAmount": "24233.0" +"TaxAssessedValue": 935000 +"TaxBookNumber": "292001603025800" +"TaxLegalDescription": "PLAN 81 BLK K PT LOT 1,2&3 RP 2R3488 PART 2 PART 3" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2% Plus HST. 50% reduction in commission will be" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "C4-7" +"Rail": "No" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"HeatType": "Unknown" +"LotWidth": 146.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403263')" +"ElevatorYN": true +"GarageType": "Unknown" +"PropertyUse": "With Property" +"ElevatorType": "Public" +"ListPriceUnit": "For Sale" +"UnderContract": array:2 [ …2] +"provider_name": "TRREB" +"AssessmentYear": 2023 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "143777014" +"LotIrregularities": "See Survey in Supplements" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:40:38Z" +"Media": array:21 [ …21] } ] +success: true +page_size: 9 +page_count: 13253 +count: 119275 +after_key: "" } ] ]
