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=109476&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=109476&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=109476&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=109476&$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: "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": 232 +"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" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13063 +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": 191 +"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" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13060 +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": 262 +"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" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13064 +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": 262 +"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" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13062 +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": 561 +"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" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13059 +post_id: "154511" +post_author: 1 +"ListingKey": "X10404306" +"ListingId": "X10404306" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:51Z" +"RFModificationTimestamp": "2024-12-13T02:48:39.216302+00:00" +"ListPrice": 875000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1650.0 +"City": "Hamilton" +"PostalCode": "L8M 3J4" +"UnparsedAddress": "183 Rosslyn S Avenue, Hamilton, On L8m 3j4" +"Coordinates": array:2 [ 0 => -79.825200044444 1 => 43.237326477778 ] +"Latitude": 43.237326477778 +"Longitude": -79.825200044444 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Introducing 183 Rosslyn Ave. S a meticulously maintained LEGAL Duplex in Hamilton’s sought-after Gage Park neighborhood! With a total of 3 Bedrooms and 2 beautifully renovated full bathrooms, this property cannot be missed! The upstairs unit is absolutely adorable featuring a well sized bedroom and 4-piece bath, updated kitchen with ample storage with a walkout onto a stunning cedar deck overlooking the beautifully landscaped backyard with views of the Escarpment; just breathtaking! The main floor unit is ideal as there are NO stairs, it features 2 good sized bedrooms and full renovated bath, as well as updated kitchen! This unit too has a walkout to a cute back yard deck which is fully covered where you can enjoy your morning coffee and company for entertaining! This property boasts significant potential for homeowners and investors alike, offering two separate basements, laundry hookups, and Hydro meters, with ample private backyard space for both units. Recent updates include stamped concrete driveway, kitchen renovations (2021 & 2024), updated bathrooms (2024), freshly painted interior and exterior. The spacious backyard is a landscaped oasis, low maintenance with mature trees, a tranquil koi pond, and two separate decks. With parking for multiple vehicles, a shed with concrete flooring and electrical, this property combines modern amenities with tasteful charm! Located just steps from Gage Park and the trendy shops of Ottawa Street, this home offers the perfect blend of convenience and opportunity!" +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Delta" +"CommunityFeatures": "Public Transit,Park" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Brick" ] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-02T17:37:59.271278+00:00" +"CrossStreet": "North of Lawrence Road, third block west of Ottawa St" +"DaysOnMarket": 232 +"Exclusions": "Owners Belongings" +"ExpirationDate": "2025-02-28" +"ExteriorFeatures": "Deck,Lighting,Porch,Privacy,Private Entrance" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "2 Refrigerators, 2 Stoves, 1 Washer, 1 Dryer, Built-In Microwave, Built-in Microwave, Carbon Monoxide Detector, Smoke Detector, Window Coverings" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2024-10-17" +"LotSizeDimensions": "113.45 x 30" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-11-25T20:44:35Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-17T17:30:51Z" +"OriginalListPrice": 898000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40663111" +"ParcelNumber": "172310074" +"ParkingFeatures": "Private Double,Other,Other" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:51Z" +"PoolFeatures": "None" +"PreviousListPrice": 898000.0 +"PriceChangeTimestamp": "2024-11-25T20:44:35Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "ROSSLYN" +"StreetNumber": "183" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4205.12" +"TaxAssessedValue": 317000 +"TaxBookNumber": "251804029202350" +"TaxLegalDescription": "LT 164, PL 554 , S/T & T/W VM128127 ; HAMILTON" +"TaxYear": "2022" +"TransactionBrokerCompensation": "2% + HST, 1% + HST Reduction to Co-operating Broke" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/183_rosslyn_ave_s_hamilton_on/" +"Zoning": "D- Duplex" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "East" +"HeatType": "Forced Air" +"LotDepth": 113.45 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404306')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 60 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MediaListingKey": "154826575" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "60-89Days" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:38:51Z" +"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": "154511" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13058 +post_id: "154512" +post_author: 1 +"ListingKey": "X10403769" +"ListingId": "X10403769" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:45Z" +"RFModificationTimestamp": "2024-12-13T02:49:01.051895+00:00" +"ListPrice": 58900000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T 5L8" +"UnparsedAddress": "671/673 Powerline Road, Brantford, On N3t 5l8" +"Coordinates": array:2 [ 0 => -80.2287137 1 => 43.1943645 ] +"Latitude": 43.1943645 +"Longitude": -80.2287137 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "124 gross acre, 100% developable, multi generational farm within the Settlement Boundary of Brantford. Fully designated as Employment land and within the City’s target growth area as per the newly adopted Official Plan of August 2021. Strategically located at the intersections of Hwy 2 (Paris Rd.) and Powerline Rd., this property is at the gateway to the burgeoning Oak Park Industrial area. Predominantly flat and well drained and currently cash cropped with 117 acres planted. A combination of Prestige and General Employment designations with a target intensity of 25 jobs per hectare. Absolutely the trophy farm within this fast growing hub between the Hwy 403 interchanges of Hwy 2 and Oak Park Rd. Many high profile companies have put down deep roots in this corridor including Adidas, Procter & Gamble, Hershey’s Chocolate, Ferrero Rocher, Mitsui High-tec and Ford Canada. With a competitive, highly skilled labour pool, Laurier University and Conestoga College campuses, Hwy 403 and rail access as well as an affordable housing market, Brantford is fast becoming the place to be for manufacturing and distribution." +"BuildingAreaUnits": "Square Feet" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Brant" +"CreationDate": "2024-11-02T17:52:29.177003+00:00" +"CrossStreet": "West on Powerline Rd from Hwy 24" +"DaysOnMarket": 214 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-01" +"LotSizeDimensions": "4121 x 1352" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-01T10:08:35Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-10-01T10:08:35Z" +"OriginalListPrice": 58900000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653252" +"ParcelNumber": "322220012" +"PhotosChangeTimestamp": "2024-12-11T14:38:45Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:2 [ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "POWERLINE" +"StreetNumber": "671/673" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13264.0" +"TaxAssessedValue": 2694000 +"TaxBookNumber": "290601004015700" +"TaxLegalDescription": "671/673 Powerline Rd: PT LT 22 CON 1 BRANTFORD AS IN A280602; S/T TB49345; COUNTY OF BRANT" +"TaxYear": "2022" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "1.5" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "A" +"DDFYN": true +"Water": "Well" +"GasYNA": "Available" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"HeatType": "Unknown" +"LotDepth": 4121.0 +"LotWidth": 1352.0 +"SoilTest": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403769')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:1 [ 0 => "Cell Services" ] +"MediaListingKey": "154304133" +"LotSizeRangeAcres": "100 +" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-11T14:38:45Z" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "154512" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13065 +post_id: "154513" +post_author: 1 +"ListingKey": "X10404507" +"ListingId": "X10404507" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:24Z" +"RFModificationTimestamp": "2024-12-13T02:49:26.112888+00:00" +"ListPrice": 3300.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1737.0 +"City": "Hamilton" +"PostalCode": "L8B 1Y5" +"UnparsedAddress": "36 Granite Ridge Trail, Hamilton, On L8b 1y5" +"Coordinates": array:2 [ 0 => -79.8752558 1 => 43.3388983 ] +"Latitude": 43.3388983 +"Longitude": -79.8752558 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Fantastic opportunity to rent 2 year new semi in Waterdown! Featuring 3 spacious bedrooms and 21/2 bathrooms 9 ft Ceiling height on both floors is the perfect place to call home! Boasting a generous and functional layout the main floor of this home features laminate floors and tiles, great room with fireplace, spacious kitchen with breakfast room and inside garage access. The upper level boasts master bedroom with walk in closet and ensuite 2 other good size bedroom, main bath and laundry room. painted in natural tone paint color. Conveniently located close to all major amenities, minutes to the highway 403 / go train. Commuters dream. tenant to pay all utilities including water heater rent and water bill. Pictures were taken when house was vacant." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T23:04:17.109150+00:00" +"CrossStreet": "Dundas to Burke St. to kenesky to Granite Ridge" +"DaysOnMarket": 198 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": "Water Heater,Sump Pump,Air Exchanger" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-10-29" +"LotSizeDimensions": "x 24" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-10-29T14:14:55Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-29T14:14:55Z" +"OriginalListPrice": 3300.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669730" +"ParcelNumber": "175011780" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:24Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Building Insurance" ] +"Roof": "Asphalt Shingle" +"RoomsTotal": "10" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GRANITE RIDGE" +"StreetNumber": "36" +"StreetSuffix": "Trail" +"TaxBookNumber": "251830331010840" +"TaxLegalDescription": "Lot # 139L On Registered Plan # 62M-1266" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half month rent" +"TransactionType": "For Lease" +"Zoning": "Single family" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotWidth": 24.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404507')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "Month" +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PossessionDate": "2024-12-05" +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "155135069" +"RoomsAboveGrade": 10 +"SquareFootSource": "Plans" +"PossessionDetails": "30-59Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-12-11T14:38:24Z" +"PortionPropertyLease": array:1 [ 0 => "Unknown" ] +"Media": array:17 [ 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] ] +"ID": "154513" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13066 +post_id: "154514" +post_author: 1 +"ListingKey": "X10403465" +"ListingId": "X10403465" +"PropertyType": "Commercial" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:00Z" +"RFModificationTimestamp": "2024-12-13T02:50:36.503873+00:00" +"ListPrice": 3995000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3043.0 +"City": "Haldimand County" +"PostalCode": "N3W 1X6" +"UnparsedAddress": "523 Mines Road, Haldimand County, On N3w 1x6" +"Coordinates": array:2 [ 0 => -79.958719103077 1 => 43.118037052308 ] +"Latitude": 43.118037052308 +"Longitude": -79.958719103077 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the beauty of country living on this spectacular 98-acre country estate/farm, boasting a meticulously renovated circa 1862 farmhouse. A long driveway unfolds to a very private setting and a stunning red brick farmhouse with an incredible addition, newer double garage with a glass solarium connecting to the main home, beautiful manicured gardens, and a grand bank barn all surrounded by majestic trees. Step inside the 3,043 square feet of living space to find a seamless blend of historic charm and modern luxury, featuring a traditional centre hall plan, living and dining rooms with fireplaces, wide plank pine flooring, and original trim. The open-concept kitchen and family room addition boasts a massive fireplace and soaring vaulted ceilings, inviting an abundance of natural light and picturesque views from every window. Entertain effortlessly in the large 3-season screened porch overlooking the courtyard and gardens. Upstairs, three spacious bedrooms, 4pc main bathroom, and a loft with spiral staircase down to the family room. Outside, gentle rolling fields, scenic tree lines, with over 70 workable acres, a meadow and forest at the back of the property, perfect for walking trails and outdoor activities. The magnificent large bank barn provides versatile storage options and is ideal for hobbies and entertaining. Conveniently located minutes from Hwy 403 & Hwy 6, and less than an hour from downtown Toronto, this property offers the perfect balance of rural serenity and urban accessibility. Don't miss the opportunity to own this extraordinary property and experience the ultimate country lifestyle." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ 0 => "Partially Finished" 1 => "Partial Basement" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Greenbelt/Conservation" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:24:50.300585+00:00" +"CrossStreet": "Glancaster to Haldibrook to Mines Road" +"DaysOnMarket": 281 +"ExpirationDate": "2025-04-30" +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:2 [ 0 => "Concrete" 1 => "Other" ] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dryer, Garage Door Opener, Refrigerator, Stove, Washer" +"InteriorFeatures": "Propane Tank,Water Treatment,Sump Pump,Air Exchanger,Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-29" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "2728.64 x 1651.99" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "533300" +"MajorChangeTimestamp": "2024-08-29T09:56:22Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-29T09:56:22Z" +"OriginalListPrice": 3995000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40639200" +"OtherStructures": array:1 [ 0 => "Barn" ] +"ParcelNumber": "381530023" +"ParkingTotal": "27.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:00Z" +"PoolFeatures": "None" +"Roof": "Other,Metal" +"RoomsTotal": "14" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ 0 => "Go Direct" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MINES" +"StreetNumber": "523" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13137.32" +"TaxAssessedValue": 1124000 +"TaxBookNumber": "281015200529000" +"TaxLegalDescription": "PT LT 2 RANGE 3 WEST OF PLANK RD SENECA AS IN HC182445; HALDIMAND COUNTY" +"TaxYear": "2023" +"Topography": array:2 [ 0 => "Flat" 1 => "Rolling" ] +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"WaterSource": array:2 [ 0 => "Cistern" 1 => "Drilled Well" ] +"Zoning": "H A1" +"DDFYN": true +"Water": "Unknown" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"FarmType": "Hobby" +"HeatType": "Water" +"LotDepth": 2728.64 +"LotWidth": 1651.99 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403465')" +"GarageType": "Attached" +"HeatSource": "Propane" +"PropertyUse": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 25 +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "153323861" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 2 +"PropertyFeatures": array:1 [ 0 => "Golf" ] +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-12-11T14:38:00Z" +"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": "154514" } ] +success: true +page_size: 9 +page_count: 13325 +count: 119918 +after_key: "" } "RF Response Time" => "0.29 seconds" ] "RF Cache Key: 590fa5a86d20d80b28903d3ba58f9e71537c9c8f31fd5765145d14d9675c63fd" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13270 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13082 +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 [ 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": array:1 [ 0 => "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": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-02T17:49:36.556993+00:00" +"CrossStreet": "Bronte Road/Marine Drive" +"DaysOnMarket": 232 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Lighting" 2 => "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": array:1 [ 0 => "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": array:5 [ 0 => "Other" 1 => "Other" 2 => "Reserved/Assigned" 3 => "Inside Entry" 4 => "Mutual" ] +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-12-11T14:41:49Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:2 [ 0 => "Shake" 1 => "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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13045 +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 [ 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": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "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": 191 +"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": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "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": array:1 [ 0 => "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] …2 ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13056 +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": 262 +"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] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13055 +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": 262 +"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] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#10982 +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": 561 +"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] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13078 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404306" +"ListingId": "X10404306" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:51Z" +"RFModificationTimestamp": "2024-12-13T02:48:39.216302+00:00" +"ListPrice": 875000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1650.0 +"City": "Hamilton" +"PostalCode": "L8M 3J4" +"UnparsedAddress": "183 Rosslyn S Avenue, Hamilton, On L8m 3j4" +"Coordinates": array:2 [ …2] +"Latitude": 43.237326477778 +"Longitude": -79.825200044444 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Introducing 183 Rosslyn Ave. S a meticulously maintained LEGAL Duplex in Hamilton’s sought-after Gage Park neighborhood! With a total of 3 Bedrooms and 2 beautifully renovated full bathrooms, this property cannot be missed! The upstairs unit is absolutely adorable featuring a well sized bedroom and 4-piece bath, updated kitchen with ample storage with a walkout onto a stunning cedar deck overlooking the beautifully landscaped backyard with views of the Escarpment; just breathtaking! The main floor unit is ideal as there are NO stairs, it features 2 good sized bedrooms and full renovated bath, as well as updated kitchen! This unit too has a walkout to a cute back yard deck which is fully covered where you can enjoy your morning coffee and company for entertaining! This property boasts significant potential for homeowners and investors alike, offering two separate basements, laundry hookups, and Hydro meters, with ample private backyard space for both units. Recent updates include stamped concrete driveway, kitchen renovations (2021 & 2024), updated bathrooms (2024), freshly painted interior and exterior. The spacious backyard is a landscaped oasis, low maintenance with mature trees, a tranquil koi pond, and two separate decks. With parking for multiple vehicles, a shed with concrete flooring and electrical, this property combines modern amenities with tasteful charm! Located just steps from Gage Park and the trendy shops of Ottawa Street, this home offers the perfect blend of convenience and opportunity!" +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Delta" +"CommunityFeatures": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-02T17:37:59.271278+00:00" +"CrossStreet": "North of Lawrence Road, third block west of Ottawa St" +"DaysOnMarket": 232 +"Exclusions": "Owners Belongings" +"ExpirationDate": "2025-02-28" +"ExteriorFeatures": array:5 [ …5] +"FoundationDetails": array:1 [ …1] +"Inclusions": "2 Refrigerators, 2 Stoves, 1 Washer, 1 Dryer, Built-In Microwave, Built-in Microwave, Carbon Monoxide Detector, Smoke Detector, Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListingContractDate": "2024-10-17" +"LotSizeDimensions": "113.45 x 30" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-11-25T20:44:35Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-17T17:30:51Z" +"OriginalListPrice": 898000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40663111" +"ParcelNumber": "172310074" +"ParkingFeatures": array:3 [ …3] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:51Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 898000.0 +"PriceChangeTimestamp": "2024-11-25T20:44:35Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "ROSSLYN" +"StreetNumber": "183" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4205.12" +"TaxAssessedValue": 317000 +"TaxBookNumber": "251804029202350" +"TaxLegalDescription": "LT 164, PL 554 , S/T & T/W VM128127 ; HAMILTON" +"TaxYear": "2022" +"TransactionBrokerCompensation": "2% + HST, 1% + HST Reduction to Co-operating Broke" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/183_rosslyn_ave_s_hamilton_on/" +"Zoning": "D- Duplex" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "East" +"HeatType": "Forced Air" +"LotDepth": 113.45 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404306')" +"GarageType": "Unknown" +"HeatSource": "Gas" +"PropertyUse": "Unknown" +"HoldoverDays": 60 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2016 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"MediaListingKey": "154826575" +"PropertyFeatures": array:1 [ …1] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "60-89Days" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:38:51Z" +"Media": array:50 [ …50] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13079 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403769" +"ListingId": "X10403769" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:45Z" +"RFModificationTimestamp": "2024-12-13T02:49:01.051895+00:00" +"ListPrice": 58900000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T 5L8" +"UnparsedAddress": "671/673 Powerline Road, Brantford, On N3t 5l8" +"Coordinates": array:2 [ …2] +"Latitude": 43.1943645 +"Longitude": -80.2287137 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "124 gross acre, 100% developable, multi generational farm within the Settlement Boundary of Brantford. Fully designated as Employment land and within the City’s target growth area as per the newly adopted Official Plan of August 2021. Strategically located at the intersections of Hwy 2 (Paris Rd.) and Powerline Rd., this property is at the gateway to the burgeoning Oak Park Industrial area. Predominantly flat and well drained and currently cash cropped with 117 acres planted. A combination of Prestige and General Employment designations with a target intensity of 25 jobs per hectare. Absolutely the trophy farm within this fast growing hub between the Hwy 403 interchanges of Hwy 2 and Oak Park Rd. Many high profile companies have put down deep roots in this corridor including Adidas, Procter & Gamble, Hershey’s Chocolate, Ferrero Rocher, Mitsui High-tec and Ford Canada. With a competitive, highly skilled labour pool, Laurier University and Conestoga College campuses, Hwy 403 and rail access as well as an affordable housing market, Brantford is fast becoming the place to be for manufacturing and distribution." +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Brant" +"CreationDate": "2024-11-02T17:52:29.177003+00:00" +"CrossStreet": "West on Powerline Rd from Hwy 24" +"DaysOnMarket": 214 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-01" +"LotSizeDimensions": "4121 x 1352" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-01T10:08:35Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-10-01T10:08:35Z" +"OriginalListPrice": 58900000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653252" +"ParcelNumber": "322220012" +"PhotosChangeTimestamp": "2024-12-11T14:38:45Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "POWERLINE" +"StreetNumber": "671/673" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13264.0" +"TaxAssessedValue": 2694000 +"TaxBookNumber": "290601004015700" +"TaxLegalDescription": "671/673 Powerline Rd: PT LT 22 CON 1 BRANTFORD AS IN A280602; S/T TB49345; COUNTY OF BRANT" +"TaxYear": "2022" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "1.5" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "A" +"DDFYN": true +"Water": "Well" +"GasYNA": "Available" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "North" +"HeatType": "Unknown" +"LotDepth": 4121.0 +"LotWidth": 1352.0 +"SoilTest": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403769')" +"GarageType": "Unknown" +"ElectricYNA": "Yes" +"PropertyUse": "Unknown" +"HoldoverDays": 120 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"AssessmentYear": 2022 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"RuralUtilities": array:1 [ …1] +"MediaListingKey": "154304133" +"LotSizeRangeAcres": "100 +" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2024-12-11T14:38:45Z" +"Media": array:14 [ …14] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13080 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404507" +"ListingId": "X10404507" +"PropertyType": "Residential Lease" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:24Z" +"RFModificationTimestamp": "2024-12-13T02:49:26.112888+00:00" +"ListPrice": 3300.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1737.0 +"City": "Hamilton" +"PostalCode": "L8B 1Y5" +"UnparsedAddress": "36 Granite Ridge Trail, Hamilton, On L8b 1y5" +"Coordinates": array:2 [ …2] +"Latitude": 43.3388983 +"Longitude": -79.8752558 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Fantastic opportunity to rent 2 year new semi in Waterdown! Featuring 3 spacious bedrooms and 21/2 bathrooms 9 ft Ceiling height on both floors is the perfect place to call home! Boasting a generous and functional layout the main floor of this home features laminate floors and tiles, great room with fireplace, spacious kitchen with breakfast room and inside garage access. The upper level boasts master bedroom with walk in closet and ensuite 2 other good size bedroom, main bath and laundry room. painted in natural tone paint color. Conveniently located close to all major amenities, minutes to the highway 403 / go train. Commuters dream. tenant to pay all utilities including water heater rent and water bill. Pictures were taken when house was vacant." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T23:04:17.109150+00:00" +"CrossStreet": "Dundas to Burke St. to kenesky to Granite Ridge" +"DaysOnMarket": 198 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-10-29" +"LotSizeDimensions": "x 24" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2024-10-29T14:14:55Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-29T14:14:55Z" +"OriginalListPrice": 3300.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669730" +"ParcelNumber": "175011780" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:24Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"RentIncludes": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GRANITE RIDGE" +"StreetNumber": "36" +"StreetSuffix": "Trail" +"TaxBookNumber": "251830331010840" +"TaxLegalDescription": "Lot # 139L On Registered Plan # 62M-1266" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half month rent" +"TransactionType": "For Lease" +"Zoning": "Single family" +"DDFYN": true +"Water": "Municipal" +"Exposure": "South" +"HeatType": "Forced Air" +"LotWidth": 24.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404507')" +"GarageType": "Attached" +"HeatSource": "Gas" +"KitchensTotal": 1 +"ListPriceUnit": "Month" +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2024-12-05" +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "155135069" +"RoomsAboveGrade": 10 +"SquareFootSource": "Plans" +"PossessionDetails": "30-59Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-12-11T14:38:24Z" +"PortionPropertyLease": array:1 [ …1] +"Media": array:17 [ …17] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13081 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403465" +"ListingId": "X10403465" +"PropertyType": "Commercial Sale" +"PropertySubType": "Farm" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T14:38:00Z" +"RFModificationTimestamp": "2024-12-13T02:50:36.503873+00:00" +"ListPrice": 3995000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3043.0 +"City": "Haldimand County" +"PostalCode": "N3W 1X6" +"UnparsedAddress": "523 Mines Road, Haldimand County, On N3w 1x6" +"Coordinates": array:2 [ …2] +"Latitude": 43.118037052308 +"Longitude": -79.958719103077 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the beauty of country living on this spectacular 98-acre country estate/farm, boasting a meticulously renovated circa 1862 farmhouse. A long driveway unfolds to a very private setting and a stunning red brick farmhouse with an incredible addition, newer double garage with a glass solarium connecting to the main home, beautiful manicured gardens, and a grand bank barn all surrounded by majestic trees. Step inside the 3,043 square feet of living space to find a seamless blend of historic charm and modern luxury, featuring a traditional centre hall plan, living and dining rooms with fireplaces, wide plank pine flooring, and original trim. The open-concept kitchen and family room addition boasts a massive fireplace and soaring vaulted ceilings, inviting an abundance of natural light and picturesque views from every window. Entertain effortlessly in the large 3-season screened porch overlooking the courtyard and gardens. Upstairs, three spacious bedrooms, 4pc main bathroom, and a loft with spiral staircase down to the family room. Outside, gentle rolling fields, scenic tree lines, with over 70 workable acres, a meadow and forest at the back of the property, perfect for walking trails and outdoor activities. The magnificent large bank barn provides versatile storage options and is ideal for hobbies and entertaining. Conveniently located minutes from Hwy 403 & Hwy 6, and less than an hour from downtown Toronto, this property offers the perfect balance of rural serenity and urban accessibility. Don't miss the opportunity to own this extraordinary property and experience the ultimate country lifestyle." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CoveredSpaces": "2.0" +"CreationDate": "2024-11-03T23:24:50.300585+00:00" +"CrossStreet": "Glancaster to Haldibrook to Mines Road" +"DaysOnMarket": 281 +"ExpirationDate": "2025-04-30" +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dryer, Garage Door Opener, Refrigerator, Stove, Washer" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-08-29" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "2728.64 x 1651.99" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "533300" +"MajorChangeTimestamp": "2024-08-29T09:56:22Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-29T09:56:22Z" +"OriginalListPrice": 3995000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40639200" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "381530023" +"ParkingTotal": "27.0" +"PhotosChangeTimestamp": "2024-12-11T14:38:00Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:2 [ …2] +"RoomsTotal": "14" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "MINES" +"StreetNumber": "523" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13137.32" +"TaxAssessedValue": 1124000 +"TaxBookNumber": "281015200529000" +"TaxLegalDescription": "PT LT 2 RANGE 3 WEST OF PLANK RD SENECA AS IN HC182445; HALDIMAND COUNTY" +"TaxYear": "2023" +"Topography": array:2 [ …2] +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"WaterSource": array:2 [ …2] +"Zoning": "H A1" +"DDFYN": true +"Water": "Unknown" +"LotType": "Unknown" +"TaxType": "Unknown" +"Exposure": "West" +"FarmType": "Hobby" +"HeatType": "Water" +"LotDepth": 2728.64 +"LotWidth": 1651.99 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403465')" +"GarageType": "Attached" +"HeatSource": "Propane" +"PropertyUse": "Unknown" +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 25 +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"WashroomsType1": 1 +"WashroomsType2": 1 +"MediaListingKey": "153323861" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 2 +"PropertyFeatures": array:1 [ …1] +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2024-12-11T14:38:00Z" +"Media": array:50 [ …50] } ] +success: true +page_size: 9 +page_count: 13325 +count: 119918 +after_key: "" } ] ]
