Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 37154a397cddc69390fb24d613bee046e3e15eb29a6a98c3f507bd06b539e8c8" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4251 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4007 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12732938" +"ListingId": "X12732938" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-27T17:49:44Z" +"RFModificationTimestamp": "2026-03-18T10:51:42Z" +"ListPrice": 2595000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.453 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 4Z2" +"UnparsedAddress": "34 Harrington Place, Hamilton, ON L9G 4Z2" +"Coordinates": array:2 [ 0 => -79.9868134 1 => 43.2249457 ] +"Latitude": 43.2249457 +"Longitude": -79.9868134 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located on a quiet court in Ancaster's prestigious Oakhill neighbourhood, 34 Harrington Place is a one-of-a-kind bungaloft designed for elegant living and unforgettable entertaining. Set on a pie-shaped, nearly half-acre lot with an impressive 217 ft across the rear, this custom-built Atherton home is surrounded by estate properties and award-winning Trillium gardens that elevate the curb appeal and outdoor experience. Boasting almost 5,000 sqft of impeccably finished living space, this home offers 3+1 bedrooms, 4 full baths, and a layout that perfectly blends everyday comfort with timeless sophistication. The main floor features a gourmet eat-in kitchen with custom cabinetry, cathedral ceiling, and access to a covered porch, flowing into a striking 12-ft great room with gas fireplace and floor-to-ceiling windows overlooking the oasis backyard. A formal dining room provides the ideal setting for hosting family gatherings and elegant dinner parties. The luxurious main-floor primary suite includes a cozy gas fireplace, an oversized walk-in dressing room, and a 5-pc spa-inspired ensuite. Also on the main level: a large private office, a full laundry room, and a stylish guest bath with direct outdoor access-perfect for rinsing off after a dip in the custom-designed hot and cold soaker pool spa or post-garden clean-up. Upstairs, two well-appointed bedrooms, a full bath, and a versatile loft area offer space for teens, guests, or a second home office. The bright walk-out basement features a 3-sided gas fireplace, spacious recreation room, kitchenette/bar, 4th bedroom, full spa bath, gym area, and abundant storage-ideal for in-laws or extended family. The backyard is a showstopper: private, lush, and tailored for gatherings large or small. Multiple seating and dining areas, a covered porch, and the signature pool spa create an outdoor sanctuary you'll enjoy in every season. This is more than a home-it's a statement of lifestyle in one of Ancaster's most exclusive enclaves." +"ArchitecturalStyle": array:1 [ 0 => "Bungaloft" ] +"Basement": array:2 [ 0 => "Finished with Walk-Out" 1 => "Separate Entrance" ] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "3.0" +"CreationDate": "2026-03-17T04:45:40.722961+00:00" +"CrossStreet": "Lovers Lane" +"DirectionFaces": "East" +"Directions": "Jerseyville Rd or Sulphur Springs to Lovers Lane - to Harrington Place (Court)" +"Exclusions": "Mounted televisions" +"ExpirationDate": "2026-05-26" +"ExteriorFeatures": array:7 [ 0 => "Hot Tub" 1 => "Landscape Lighting" 2 => "Landscaped" 3 => "Lawn Sprinkler System" 4 => "Patio" 5 => "Privacy" 6 => "Porch" ] +"FireplaceFeatures": array:3 [ 0 => "Family Room" 1 => "Natural Gas" 2 => "Rec Room" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "All appliances. Window coverings. Central vacuum. Bathroom vanity mirrors. Soaker pool spa equipment." +"InteriorFeatures": array:7 [ 0 => "Bar Fridge" 1 => "Central Vacuum" 2 => "Countertop Range" 3 => "Primary Bedroom - Main Floor" 4 => "Storage" 5 => "Sump Pump" 6 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-27" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-01-27T17:49:00Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-27T17:49:00Z" +"OriginalListPrice": 2595000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3475100" +"OtherStructures": array:2 [ 0 => "Fence - Full" 1 => "Shed" ] +"ParcelNumber": "174450163" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2026-01-27T17:49:00Z" +"PoolFeatures": array:1 [ 0 => "Other" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:3 [ 0 => "Alarm System" 1 => "Carbon Monoxide Detectors" 2 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Harrington" +"StreetNumber": "34" +"StreetSuffix": "Place" +"TaxAnnualAmount": "14407.78" +"TaxLegalDescription": "LOT 7, PLAN 62M821, ANCASTER. CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=k-05d HKUcxw" +"VirtualTourURLUnbranded": "http://www.34Harrington.ca" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 207.21 +"LotShape": "Pie" +"LotWidth": 59.15 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12732938')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814024024555" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Water heater" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 4Z2, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CentralVacuumYN": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 5 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ 0 => "Cul de Sac/Dead End" 1 => "Golf" 2 => "Hospital" 3 => "Library" 4 => "Place Of Worship" 5 => "Rec./Commun.Centre" ] +"LotIrregularities": "216.99 ft x 141.59 ft x 59.15ftx207.21ft" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Upper" +"MediaChangeTimestamp": "2026-01-27T17:49:00Z" +"SystemModificationTimestamp": "2026-01-27T17:49:58.450771Z" +"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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4006 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12534998" +"ListingId": "X12534998" +"PropertyType": "Residential Lease" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-27T17:35:59Z" +"RFModificationTimestamp": "2026-03-18T10:46:41Z" +"ListPrice": 4500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1Z4" +"UnparsedAddress": "38 Silver Meadow Gardens, Hamilton, ON L8B 1Z4" +"Coordinates": array:2 [ 0 => -79.873145 1 => 43.341598 ] +"Latitude": 43.341598 +"Longitude": -79.873145 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning Fully Furnished Semi-Detached Home for Lease in Mountainview Heights, Waterdown. Welcome to this beautifully appointed, fully furnished semi-detached home in the desirable new community of Mountainview Heights, Waterdown. Nestled on a premium lot, this brand-new home is being offered for lease for the very first time an exceptional opportunity you won't want to miss. Offering approximately 2,000 sq ft of thoughtfully designed living space, this 4-bedroom, 4-bathroom residence showcases a spacious open-concept layout, 9-foot ceilings on both the main and upper levels. . The main level features elegant hardwood stairs, stylish coffered ceilings, and a bright living area with an electric fireplace. Enjoy the convenience of main-floor laundry with direct access to the garage. Upstairs, you are welcomed by a generous landing area leading to four spacious, fully furnished bedrooms and three full bathrooms, ideal for families or guests seeking comfort and privacy. Additional Features Include: Modern light fixtures and upgraded finishes High-efficiency HVAC system3-car parking (1-car garage + 2-car driveway) Smart home features including a doorbell camera and driveway security camera Perfectly located just minutes from the scenic Bruce Trail and Great Falls, and offering quick access to Aldershot GO Station, QEW, 407, local restaurants, parks, shopping, and more" +"AccessibilityFeatures": array:1 [ 0 => "Open Floor Plan" ] +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-17T04:45:49.471741+00:00" +"CrossStreet": "Dundas Street E/Skinner Rd" +"DirectionFaces": "North" +"Directions": "Hager Creek/Silver Meadow Gdns" +"ExpirationDate": "2026-04-30" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FireplaceFeatures": array:1 [ 0 => "Electric" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Building" ] +"LeaseTerm": "Short Term Lease" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-11-11" +"MainOfficeKey": "264100" +"MajorChangeTimestamp": "2026-01-27T17:35:59Z" +"MlsStatus": "Extension" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-11-11T22:16:37Z" +"OriginalListPrice": 4500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3251128" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T22:16:38Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "All Inclusive" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Silver Meadow" +"StreetNumber": "38" +"StreetSuffix": "Gardens" +"TransactionBrokerCompensation": "Half Month Rent plus HST" +"TransactionType": "For Lease" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "No" +"CableYNA": "No" +"HeatType": "Forced Air" +"SewerYNA": "Yes" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12534998')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"ElectricYNA": "No" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "No" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 1Z4, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2025-11-11" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DepositRequired": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"LeaseAgreementYN": true +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Other" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-11-11T22:16:38Z" +"PortionPropertyLease": array:2 [ 0 => "Main" 1 => "2nd Floor" ] +"ReferencesRequiredYN": true +"ExtensionEntryTimestamp": "2026-01-27T17:35:59Z" +"SystemModificationTimestamp": "2026-01-27T17:36:04.094485Z" +"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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4000 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12430097" +"ListingId": "X12430097" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-27T15:12:08Z" +"RFModificationTimestamp": "2026-03-12T10:52:55Z" +"ListPrice": 4590000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1A3" +"UnparsedAddress": "437 6th Concession Road E, Hamilton, ON L8B 1A3" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare Offering in Flamborough - 96 Acres. Welcome to 437 Concession Road East, a legacy estate that blends historic charm, modern luxury, and exceptional potential. The original 1893 farmhouse offers approx 2,162 sq. ft. of timeless character, while the custom ranch-style bungalow, built in 2015, spans over 5,600 sq. ft. of open-concept living with soaring ceilings and a two-storey garage with loft. A 3,556 sq. ft. workshop provides unmatched space for trades, hobbies, or storage, and a powerful 100 k W generator ensures reliable energy and peace of mind across the entire estate. Adding to its uniqueness, the property features a saloon straight out of a country western film perfect for unforgettable gatherings, private celebrations, or simply enjoying the charm of old-world character. The property includes 10 acres of manicured grounds, while the remaining acreage is zoned A-1 with P-7 and P-8 designations. A winding driveway leads to this private retreat, offering peace, privacy, and endless possibilities just minutes from Burlington, Waterdown, and major highways. This is more than a property its a lifestyle. From quiet morning walks to wide-open space where you can run free, create, entertain, or simply breathe, 437 Concession Road East invites you to experience country living without compromise. Rarely does an estate of this scale, beauty, and multi-use opportunity come to market. Luxury Certified." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Crawl Space" ] +"CityRegion": "Rural Flamborough" +"CoListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"CoListOfficePhone": "905-573-1188" +"ConstructionMaterials": array:2 [ 0 => "Board & Batten" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "4.0" +"CreationDate": "2026-03-12T09:43:12.587267+00:00" +"CrossStreet": "Highway 6" +"DirectionFaces": "North" +"Directions": "Highway 6 to Concession 6 Road East" +"ExpirationDate": "2026-05-29" +"FireplaceFeatures": array:1 [ 0 => "Wood Stove" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Freezer, Garage Door Opener, Gas Stove, Hot Water Tank Owned, Range Hood, Refrigerator, Smoke Detector, Washer, Window Coverings" +"InteriorFeatures": array:5 [ 0 => "Auto Garage Door Remote" 1 => "Bar Fridge" 2 => "Built-In Oven" 3 => "In-Law Suite" 4 => "Water Softener" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-26" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-01-27T15:12:08Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-09-27T00:21:39Z" +"OriginalListPrice": 5299000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3054232" +"OtherStructures": array:2 [ 0 => "Additional Garage(s)" 1 => "Workshop" ] +"ParcelNumber": "175160047" +"ParkingFeatures": array:2 [ 0 => "Circular Drive" 1 => "Front Yard Parking" ] +"ParkingTotal": "34.0" +"PhotosChangeTimestamp": "2025-09-27T00:21:39Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 4750000.0 +"PriceChangeTimestamp": "2026-01-27T15:12:08Z" +"Roof": array:1 [ 0 => "Metal" ] +"SecurityFeatures": array:1 [ 0 => "Alarm System" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "6th Concession" +"StreetNumber": "437" +"StreetSuffix": "Road" +"TaxAnnualAmount": "4308.0" +"TaxLegalDescription": "PT LOT 4, CONCESSION 6 EAST FLAMBOROUGH , AS IN VM212037; S/T EF28861, HL10188 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:2 [ 0 => "Flat" 1 => "Wooded/Treed" ] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://437concession6theast.marketingrmx.com" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/01998687-7dd1-713b-83ed-7d0752c7ecb3?v=188" +"VirtualTourURLUnbranded2": "https://storybookviewer.com/3268-3731" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Zoning": "A1 , P7, P8" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 2817.39 +"LotShape": "Rectangular" +"LotWidth": 1484.9 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12430097')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830361005200" +"SurveyType": "None" +"HoldoverDays": 120 +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 30 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 1A3, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "5000 +" +"RoomsAboveGrade": 8 +"PropertyFeatures": array:3 [ 0 => "Greenbelt/Conservation" 1 => "Ravine" 2 => "Wooded/Treed" ] +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2025-10-06T15:38:35Z" +"SystemModificationTimestamp": "2026-01-27T15:12:14.375995Z" +"Media": array:37 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4003 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12658974" +"ListingId": "X12658974" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-27T02:50:03Z" +"RFModificationTimestamp": "2026-03-17T06:49:35Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9B 2G7" +"UnparsedAddress": "111 Wilson Street E 2, Hamilton, ON L9B 2G7" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ATRIUM HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 111 Wilson St E, Unit 2 - a beautifully upgraded three-storey townhouse featuring 3 bedrooms and 4 bathrooms, with a bathroom on every level for maximum comfort and convenience. The home showcases a modern kitchen with brand-new electric stove and range hood, upgraded countertops, sink, cabinets, custom closets, and many other detailed improvements that enhance both function and style. Ideally located in a highly convenient area, it offers easy access to shops, restaurants, schools, and major highways. Perfect for self-use or investment, this move-in ready home combines modern living with thoughtful upgrades throughout." +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"AssociationFee": "403.2" +"AssociationFeeIncludes": array:1 [ 0 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Ancaster" +"CoListOfficeName": "RE/MAX ATRIUM HOME REALTY" +"CoListOfficePhone": "905-513-0808" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-17T05:02:19.097604+00:00" +"CrossStreet": "JERSEYVILLE RD E" +"Directions": "Jerseyville Rd E" +"ExpirationDate": "2026-04-02" +"FireplaceYN": true +"GarageYN": true +"Inclusions": "All Appliances, All Electrical Light Fixtures, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-02" +"MainOfficeKey": "371200" +"MajorChangeTimestamp": "2026-01-03T20:26:39Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-03T20:26:39Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3393294" +"ParcelNumber": "185820002" +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ 0 => "No" ] +"PhotosChangeTimestamp": "2026-01-03T20:49:45Z" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Wilson" +"StreetNumber": "111" +"StreetSuffix": "Street" +"TaxAnnualAmount": "6015.17" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "2" +"DDFYN": true +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12658974')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814024044404" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "HWT" +"HoldoverDays": 30 +"LegalStories": "1" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9B 2G7, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CondoCorpNumber": 582 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1800-1999" +"RoomsAboveGrade": 7 +"SquareFootSource": "Estimated" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Third" +"WashroomsType4Level": "Third" +"LegalApartmentNumber": "2" +"MediaChangeTimestamp": "2026-01-03T20:49:45Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-01-27T02:50:05.656336Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:37 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12322732" +"ListingId": "X12322732" +"PropertyType": "Residential" +"PropertySubType": "Triplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-26T19:33:21Z" +"RFModificationTimestamp": "2026-03-01T08:00:49Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.06 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 2V8" +"UnparsedAddress": "9 Tisdale Street S, Hamilton, ON L8N 2V8" +"Coordinates": array:2 [ 0 => -79.8521665 1 => 43.2547154 ] +"Latitude": 43.2547154 +"Longitude": -79.8521665 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Edge Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Legal triplex in Central Hamilton offering nearly 2,500 square feet of finished space, with potential for a 4th Unit. This cash-flowing asset generates over $5,170 in monthly income and is set up for efficient management with 3 hydro meters, 3 gas meters, 2 furnaces, and 3 hot water tanks. All units feature in-suite laundry, and tenants pay their own gas and hydro, keeping operating expenses low. Unit 1 features a main-floor two-bedroom with basement storage, tenanted for $1,950 plus utilities. Unit 2 is a second-floor 2-bedrooam rented at $1,520 plus utilities. Unit 3 is a Vacant third floor 2-bed, currently vacant with a market rate of $1,700 + utilities. Additional value lies in 2-car driveway parking and TOC zoning, which allows for the opportunity to unlock further income through a 4th basement Unit. Located between Main and King streets along the future LRT plans, this property is positioned for long-term growth with proximity to Jackson Square, Hamilton GO Centre, and Hamilton General Hospital. This is an ideal opportunity for investors seeking stable income and future upside." +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "Landsdale" +"ConstructionMaterials": array:1 [ 0 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Window Unit(s)" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-09T09:07:26.659079+00:00" +"CrossStreet": "King St E / Tisdale" +"DirectionFaces": "East" +"Directions": "Main St E to Tisdale St S" +"Exclusions": "Tenants belongings" +"ExpirationDate": "2026-05-31" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Inclusions": "3x Stove, 3x Fridge, 3x Washer, 3x Dryer, 2x Dishwaher" +"InteriorFeatures": array:2 [ 0 => "Separate Hydro Meter" 1 => "Separate Heating Controls" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-08-02" +"LotSizeSource": "MPAC" +"MainOfficeKey": "578200" +"MajorChangeTimestamp": "2025-11-19T15:53:54Z" +"MlsStatus": "Extension" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-08-03T20:32:24Z" +"OriginalListPrice": 849000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2799376" +"ParcelNumber": "171800164" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-09-12T17:00:31Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 839900.0 +"PriceChangeTimestamp": "2025-10-01T20:42:27Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Tisdale" +"StreetNumber": "9" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4785.0" +"TaxAssessedValue": 336000 +"TaxLegalDescription": "PT LTS 10 & 11, PL 224 , AS IN CD505451, EXCEPT THE T/W THEREIN ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/9_tisdale_st_s_hamilton_on/" +"Zoning": "T0C1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Other" +"LotDepth": 75.0 +"LotWidth": 33.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12322732')" +"GarageType": "None" +"HeatSource": "Other" +"RollNumber": "251803021107130" +"SurveyType": "None" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ 0 => "Other" ] +"KitchensTotal": 3 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8N 2V8, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ 0 => "Other" ] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 15 +"PropertyFeatures": array:2 [ 0 => "Hospital" 1 => "Public Transit" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 6 +"KitchensAboveGrade": 3 +"SpecialDesignation": array:1 [ 0 => "Other" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Third" +"MediaChangeTimestamp": "2025-09-12T17:00:31Z" +"ExtensionEntryTimestamp": "2025-11-19T15:53:53Z" +"SystemModificationTimestamp": "2026-01-26T19:33:21.848183Z" +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4029 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12729418" +"ListingId": "X12729418" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-26T16:34:12Z" +"RFModificationTimestamp": "2026-03-02T12:03:45Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H 5A4" +"UnparsedAddress": "15 Hauser Place, Hamilton, ON L9H 5A4" +"Coordinates": array:2 [ 0 => -80.0011882 1 => 43.2718185 ] +"Latitude": 43.2718185 +"Longitude": -80.0011882 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Land Price only, subject to HST. Requirement to custom build with project builder Thomas Cochren Homes. Only 1 Lot remaining in The Greystones at Webster's Falls! One of a kind custom residence to be built to suit your specifications. Majestic 1.1 Acre property on quiet court. Existing plan available for a luxury bungaloft by John Williams Architect can still be customized or completely redesigned. 3532 SF above-grade plus 3 car garage and outdoor entrance to lower level. Fabulous 30'0 Great Room with 13'0 ceilings and stone fireplace open to fabulous kitchen by Gravelle featuring oversized island with natural Quartzite stone counters. Professional Thermador Appliance Package. Walk in Pantry. Main Floor Laundry and Mud Rooms. Luxury Main Floor Mater Suite with Ante rooms, Dressing Room, Adjacent Office and so much more. Second Floor features two Ensuite Bedrooms and a private Family Room. Attached 2 car Garage and an additional detached 3rd Garage. Great Room walks out to 35' x 12.5' covered porch at the back with large skylights as well as 35' covered porch to catch the morning sun at the front. Incredible design, incredible craftsmanship. Loads of space for sports court and pool on this magnificent property. Be part of the Greystones at Webster's Falls community built by renowned custom home builder Thomas Cochren Homes." +"ArchitecturalStyle": array:1 [ 0 => "Bungaloft" ] +"CityRegion": "Greensville" +"CoListOfficeName": "Royal Le Page Real Estate Services Ltd., Brokerage" +"CoListOfficePhone": "905-845-4267" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "3.0" +"CreationDate": "2026-03-02T11:13:42.024658+00:00" +"CrossStreet": "Hwy 8, Herbert Place, Hauser Place" +"DirectionFaces": "North" +"Directions": "Mashboro Ave, Herbert Pl, Hauser Pl" +"Disclosures": array:1 [ 0 => "Subdivision Covenants" ] +"ExpirationDate": "2026-07-26" +"GarageYN": true +"Inclusions": "Air Exchanger, Auto Garage Door Remote(s), Built-In Appliances, Central Vacuum Roughed-in, Sump Pump, Water Heater, Water Meter, Water Treatment" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2026-01-26" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "298.33 x 123.85" +"MainOfficeKey": "540500" +"MajorChangeTimestamp": "2026-01-26T16:34:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-26T16:34:12Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3346924" +"ParcelNumber": "251830211" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2026-01-26T16:34:12Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "HAUSER" +"StreetNumber": "15" +"StreetSuffix": "Place" +"TaxAnnualAmount": "4872.0" +"TaxAssessedValue": 365000 +"TaxBookNumber": "251830211061125" +"TaxLegalDescription": "Plan 62M1162 Lot 5, City of Hamilton" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% +HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://youtube.com/shorts/JMv5Ko7JQ74?si=YNf YNBpf9AWa Bf Mj" +"Zoning": "S1 Exception: 76" +"DDFYN": true +"Water": "Other" +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 298.33 +"LotWidth": 123.85 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12729418')" +"GarageType": "Attached" +"RollNumber": "251830211061125" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"ElectricYNA": "Available" +"HoldoverDays": 60 +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9H 5A4, CA" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 7 +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "90 + Days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-01-26T16:34:12Z" +"SystemModificationTimestamp": "2026-01-26T16:34:12.786126Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:5 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4030 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12728856" +"ListingId": "X12728856" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-26T15:21:52Z" +"RFModificationTimestamp": "2026-02-26T22:47:06Z" +"ListPrice": 1130000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1P0" +"UnparsedAddress": "51 Showcase Drive, Hamilton, ON L0R 1P0" +"Coordinates": array:2 [ 0 => -79.8052092 1 => 43.1755742 ] +"Latitude": 43.1755742 +"Longitude": -79.8052092 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Location! Location! Prepare to be impressed with the beautiful family home in Summit Park, backing ontoschool playground areas (no rear neighbours!), this sought-after home is expertly finished top-to-bottominside and out. Crafted by De Santis Multi-Area Developments in 2011, this spacious home features newlysurfaced double car drive, excellent curb appeal and a shiny steel roof! Step in to the home majestic frontporch entry accented with exposed aggregate to experience soaring ceilings, central staircase and openconcept main level. Main level presents is open concept with soaring ceilings, generous rooms, gasfireplace in Family Room and huge windows to experience the greenspace beyond. Chefs kitchen boastscentre island, stainless appliances, ample counter space and more. Lovely family-sized deck is accessedfrom the dinette area. completing this level are laundry room, powder room and access to garage. Upperlevel features 4 large bedrooms with oversized Primary Bedroom complete with 4 piece bath (soaker tub)and walk-in closet. 3 other bedrooms share the main 4-pc bath. Basement is fully finished with Family Room, 3-pc bath, bedroom, Storage and utility areas. Home is fenced and borders community walk-wayto school/park areas. An ideal blend of luxury, style and functionality for the discerning buyer family. Justminutes to schools, shops, dining, and the Red Hill Expressway. It has it all - ready for you!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Hannon" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-02-26T09:30:52.560024+00:00" +"CrossStreet": "Fletcher" +"DirectionFaces": "North" +"Directions": "Rymal Rd East to Fletcher to Showcase Fletcher" +"Exclusions": "none" +"ExpirationDate": "2026-07-26" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Landscaped" 2 => "Privacy" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "SS Fridge, Cookstove, Built in Dishwasher, Micro Oven, Washer, Dryer" +"InteriorFeatures": array:2 [ 0 => "Water Heater" 1 => "Water Meter" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-26" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-01-26T15:14:10Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-26T15:14:10Z" +"OriginalListPrice": 1130000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3479768" +"ParcelNumber": "173851240" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-01-26T15:14:11Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Metal" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Showcase" +"StreetNumber": "51" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7234.0" +"TaxLegalDescription": "LOT 20, PLAN 62M1114, T/W AS IN BN7613 & BN8111; S/T EASEMENT IN GROSS OVER LOT 20, PLAN 62M1114 AS IN WE577349; CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Clear" ] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/51_showcase_dr_hamilton_on" +"Zoning": "R4" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 98.43 +"LotShape": "Rectangular" +"LotWidth": 45.38 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12728856')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251890113007622" +"SurveyType": "None" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Hot water tank" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L0R 1P0, CA" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:4 [ 0 => "Fenced Yard" 1 => "Park" 2 => "Place Of Worship" 3 => "School" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-01-26T15:14:11Z" +"SystemModificationTimestamp": "2026-01-26T15:22:05.018969Z" +"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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4031 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12643726" +"ListingId": "X12643726" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-25T18:41:45Z" +"RFModificationTimestamp": "2026-03-12T10:53:00Z" +"ListPrice": 498000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8V 1A1" +"UnparsedAddress": "166 Mountain Park Avenue 201, Hamilton, ON L8V 1A1" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Unit 201 at 166 Mountain Park Avenue, a spacious 1,414 sq. ft. residence located in an exclusive, well-maintained, smoke-free 12-unit building. This three-bedroom, two-bathroom condo offers an ideal blend of comfort, space, and location. The open-concept living and dining area is bright and inviting, recently refreshed with fresh paint and professional cleaning. The generous kitchen features granite countertops and ample cabinetry, making everyday living and entertaining easy. A lovely solarium provides valuable additional space-perfect for a home office, reading area, or relaxing retreat. This second-floor unit features a spacious primary bedroom with ensuite bath, well sized 2nd and 3rd bedrooms parking & locker. Residents enjoy the rooftop garden patio with BBQ, a small gym & a meeting room. Just steps from the Mountain Brow Promenade and the Wentworth Stairs, this home is perfectly suited for those who appreciate an active lifestyle in a sought-after neighbourhood. Plus, it's within walking distance to Concession Street's vibrant shops, restaurants, Juravinski Hospital, and the Zoetic Theatre. (Virtually staged photos depict how the rooms would look with wood flooring and furniture)." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:5 [ 0 => "Visitor Parking" 1 => "Rooftop Deck/Garden" 2 => "Party Room/Meeting Room" 3 => "Gym" 4 => "BBQs Allowed" ] +"AssociationFee": "760.15" +"AssociationFeeIncludes": array:4 [ 0 => "Water Included" 1 => "Common Elements Included" 2 => "Parking Included" 3 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Incline Place" +"CityRegion": "Eastmount" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Wall Unit(s)" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-12T10:27:40.171508+00:00" +"CrossStreet": "Mountain Prk A/Upper Wentworth" +"Directions": "Turn north from Concession St onto Upper Wentworth St. Building is located on the Northeast corner of Upper Wentworth and Mountain Park Ave." +"ExpirationDate": "2026-12-31" +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, All Light fixtures." +"InteriorFeatures": array:2 [ 0 => "Storage" 1 => "Water Heater Owned" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "In-Suite Laundry" 1 => "Ensuite" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-18" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-12-19T20:06:57Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-12-19T20:06:57Z" +"OriginalListPrice": 498000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3372566" +"ParcelNumber": "180990002" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-12-19T20:07:39Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mountain Park" +"StreetNumber": "166" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4281.82" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"UnitNumber": "201" +"View": array:2 [ 0 => "Downtown" 1 => "Lake" ] +"VirtualTourURLBranded": "https://mediatours.ca/property/201-166-mountain-park-avenue-hamilton/" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/201-166-mountain-park-avenue-hamilton/" +"Zoning": "E" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12643726')" +"ElevatorYN": true +"GarageType": "Surface" +"HeatSource": "Electric" +"RollNumber": "251807067100650" +"SurveyType": "Unknown" +"BalconyType": "Enclosed" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ 0 => "Radiant" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8V 1A1, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 99 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ 0 => "Electric" ] +"LivingAreaRange": "1400-1599" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:4 [ 0 => "School" 1 => "Ravine" 2 => "Public Transit" 3 => "Hospital" ] +"SquareFootSource": "Measured" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "1" +"MediaChangeTimestamp": "2026-01-07T17:32:42Z" +"PropertyManagementCompany": "Arthrex 905-340-0622" +"SystemModificationTimestamp": "2026-01-25T18:41:49.532631Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:31 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4032 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12726756" +"ListingId": "X12726756" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-24T12:58:37Z" +"RFModificationTimestamp": "2026-03-12T10:53:04Z" +"ListPrice": 1800.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2048.0 +"City": "Hamilton" +"PostalCode": "L8P 4V1" +"UnparsedAddress": "180 James Street S 200, Hamilton, ON L8P 4V1" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "2,048 Square Feet of turn-key professional office space in Hamilton's sought-after Durand neighbourhood, prominently located on James Street South. Surrounded by new residential developments, established office buildings, and a strong mix of restaurants and cafés, this location offers excellent exposure and everyday convenience for both staff and clients. Just one block from St. Joseph's Hospital and minutes to the heart of Downtown Hamilton. Public transit is at your doorstep, with the GO Station only two blocks away. Recently renovated common areas throughout the building. Estimated 2026 TMI: $9.95/Sq Ft" +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Durand" +"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"CoListOfficePhone": "905-845-0024" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-12T10:35:24.879088+00:00" +"CrossStreet": "James Street South and Duke Street" +"Directions": "Southwest corner of James Street South and Duke Street" +"ExpirationDate": "2026-07-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2026-01-23" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2026-01-24T12:58:37Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-24T12:58:37Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3449940" +"ParcelNumber": "171710055" +"PhotosChangeTimestamp": "2026-01-24T12:58:37Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "James" +"StreetNumber": "180" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.95" +"TaxYear": "2026" +"TransactionBrokerCompensation": "4%Yr1 Net Rent, 2% Rem Term , 5Yr Cap" +"TransactionType": "For Lease" +"UnitNumber": "200" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "D1- Downtown Central Business District" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "TMI" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 90.0 +"LotWidth": 197.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12726756')" +"GarageType": "Other" +"RollNumber": "251802013905580" +"PropertyUse": "Office" +"ElevatorType": "Public" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ 0 => "Gas Forced Air Closed" ] +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 4V1, CA" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"PossessionDetails": "Immediate" +"OfficeApartmentArea": 2048.0 +"MediaChangeTimestamp": "2026-01-24T12:58:37Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 24 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2026-01-24T12:58:37.941297Z" +"Media": array:20 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4033 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12726566" +"ListingId": "X12726566" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-24T02:36:53Z" +"RFModificationTimestamp": "2026-03-03T10:10:15Z" +"ListPrice": 1299900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9B 0K4" +"UnparsedAddress": "114 Chaumont Drive, Hamilton, ON L9B 0K4" +"Coordinates": array:2 [ 0 => -79.7807941 1 => 43.1857934 ] +"Latitude": 43.1857934 +"Longitude": -79.7807941 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 114 Chaumont Dr and step into refined living in this beautifully appointed Stoney Creek Mountain home, offering soaring 9-foot ceilings, and impressive grand foyer, main-floor laundry, and a convenient separate entrance for In-Law Potential. Rich hardwood floors, California shutters, and in-ceiling speakers complement the thoughtfully designed layout, featuring separate living and dining spaces, a gas fireplace, and a bright open-concept kitchen with a breakfast bar, quartz countertops, designer stone backsplash, premium appliances, and a French door walkout to the backyard, all filled with an abundance of natural light. The second level offers four generously sized bedrooms and two full bathrooms, including a Jack-and-Jill layout, while the spacious primary suite features a walk-in closet and a luxurious five-piece ensuite. The finished basement, complete with a separate entrance, is designed for entertaining and relaxation, showcasing a large recreation area, custom stone wet bar with built-in wine cooler, sleek quartz countertops, a striking stone feature wall, an electric fireplace, and pot lighting throughout. Outside, enjoy an expertly crafted composite deck with gas BBQ hookup, a custom cabana, and a stunning illuminated hot tub for year-round hosting and enjoyment. Ideally located in the heart of Stoney Creek Mountain, just minutes from top-rated schools, parks, shopping, and quick highway access, this exceptional home is a must-see!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Stoney Creek Mountain" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-03-02T12:27:46.532984+00:00" +"CrossStreet": "Highland Rd" +"DirectionFaces": "North" +"Directions": "Upper Centennial Pkwy to Highland Rd to Chaumont Dr" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Hot Tub" 2 => "Paved Yard" ] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Gas Oven/Range, Hot Tub, Refrigerator, Washer, Window Coverings, Wine Cooler, Billiard Table" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-23" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-01-24T02:36:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-24T02:36:53Z" +"OriginalListPrice": 1299900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3476548" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "170900669" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-01-24T02:36:53Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Chaumont" +"StreetNumber": "114" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "6396.58" +"TaxLegalDescription": "LOT 50, PLAN 62M1219 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1064262 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1078116 SUBJECT TO AN EASEMENT OVER PART 2, 62R20289 IN FAVOUR OF LOT 51, PLAN 62M1219 AS IN WE1159705 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/bk2n0_114_chaumont_dr_hamilton_on/" +"Zoning": "R4" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 109.91 +"LotShape": "Rectangular" +"LotWidth": 35.1 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12726566')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251800365036253" +"SurveyType": "None" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9B 0K4, CA" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 1 +"PropertyFeatures": array:2 [ …2] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "-" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please book through Broker Bay or call our appointment centre at 905-592-7777." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2026-01-24T02:36:53Z" +"SystemModificationTimestamp": "2026-01-24T02:36:54.136338Z" +"Media": array:50 [ …50] } ] +success: true +page_size: 10 +page_count: 61 +count: 607 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4133 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4034 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "E12920780" +"ListingId": "E12920780" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T11:16:47Z" +"RFModificationTimestamp": "2026-03-29T11:21:32Z" +"ListPrice": 1025000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Clarington" +"PostalCode": "L1B 1J3" +"UnparsedAddress": "247 Beaver Street N, Clarington, ON L1B 1J3" +"Coordinates": array:2 [ …2] +"Latitude": 43.920774 +"Longitude": -78.5887655 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ROUGE RIVER REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this beautifully updated 3+1 bedroom, 2 full bath fully renovated and modern raised bungalow, perfectly situated on a large sun-filled lot, with a stream running along the north side offering a sense of tranquility. Parking for up to five vehicles, a generous backyard, greenhouse, spacious shed with electrical power, and a newly renovated deck (2024). This property is designed for both relaxation and functionality. Step inside to discover a thoughtfully designed open-concept main floor where style meets comfort. The custom open concept kitchen is a true showstopper, featuring luxurious finishes, quartz countertops, crown molding, gas range, pot filler, bar fridge, built-in wine rack, and a large island with an integrated breakfast bar-ideal for casual meals or entertaining guests. The seamless flow into the dining and living areas is accented by engineered hardwood flooring throughout creating a warm and inviting atmosphere. Unwind in the spa-inspired modern 3-piece bathroom complete with heated floors, dual sinks, and a spacious walk-in shower-your personal retreat at the end of the day! The professionally finished lower level offers incredible versatility with a separate ground-level entrance, high ceilings, and above-grade windows that flood the space with natural light. This level includes a large recreation room, an additional bedroom, 3 piece bathroom, and a modern kitchen with updated stainless steel appliances, making it perfect for multi-generational living or excellent income potential. A rare opportunity to own a home that truly combines comfort, elegance, and flexibility in a serene natural setting." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Newcastle" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Durham" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-29T03:02:07.262478+00:00" +"CrossStreet": "Beaver St. N / King Ave E" +"DirectionFaces": "East" +"Directions": "Beaver St. N / King Ave E" +"Exclusions": "All Televisions/T.V Brackets, Basement Shoe Cabinet, Mirrors, Window Drapes, Portable Sauna, Generlink Generator Transfer Switch, Basement Standup Freezer and Bar Fridge Beside it. kitchen water filter system" +"ExpirationDate": "2026-09-26" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All Window Zebra Blinds, Central Vacuum System, Garage Door Opener and 1 Remote, Stainless Kitchen Appliances: Main Floor: High End Side By Side Fridge, Gas Range, Built In Dishwasher, Bar Fridge; Basement: Fridge, Electric Smooth Top Stove, Built In Dishwasher, Microwave Range Hood. Gas Furnace, Central Air Conditioning, All Electric Light Fixtures, All Bathroom Mirrors." +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-24" +"MainOfficeKey": "498600" +"MajorChangeTimestamp": "2026-03-25T19:01:09Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-25T19:01:09Z" +"OriginalListPrice": 1025000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3708768" +"OtherStructures": array:3 [ …3] +"ParcelNumber": "266570034" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-03-25T19:01:09Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Beaver" +"StreetNumber": "247" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4845.82" +"TaxLegalDescription": "PT LT 8 BLK L PL VILLAGE OF NEWCASTLE HANNINGS PL UNDATED NEWCASTLE; PT LT 9 BLK L PL VILLAGE OF NEWCASTLE HANNINGS PL UNDATED NEWCASTLE PT 2 10R2124; CLARINGTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.winsold.com/tour/449396" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 125.4 +"LotWidth": 76.86 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12920780')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "181703013003814" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Yes" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 5 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-30" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:4 [ …4] +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-03-25T19:01:09Z" +"SystemModificationTimestamp": "2026-03-29T11:16:56.213352Z" +"VendorPropertyInfoStatement": true +"Media": array:50 [ …50] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4093 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12927926" +"ListingId": "X12927926" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T10:45:20Z" +"RFModificationTimestamp": "2026-03-29T10:47:44Z" +"ListPrice": 674900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Clarence-rockland" +"PostalCode": "K4K 0M5" +"UnparsedAddress": "433 Sterling Avenue, Clarence-rockland, ON K4K 0M5" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK REALTY GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Newly built bungalow in the Morris Village community of Rockland! Offering 1,530 sq. ft. of beautifully designed living space, this 2-bedroom, 2-bathroom home, with main floor laundry showcases modern finishes and exceptional functionality throughout!! The chef-inspired kitchen features granite countertops, stainless steel appliances, breakfast bar, undermount double sink, pots and pans drawer, and stylish two-tone cabinetry. The open-concept great room offers vaulted ceilings, hardwood flooring, and a gas fireplace, creating a bright and inviting living space. Upgraded ceramic tile flooring in the main entrance, kitchen, hallway, and bathrooms. Bedrooms feature plush carpeting. Spacious primary suite includes walk-in closet and ensuite with custom glass shower and upgraded 5' x 3' ceramic tile. Super clean, more-than-partially finished basement with two egress windows offers excellent potential for additional bedrooms, home gym, or recreation space.Additional features include quality lighting, modern paint tones, window blinds throughout, forced-air gas heating, central air conditioning, double garage, and automatic garage door opener. Ideally located close to schools, parks, restaurants, and shopping. Approximately 35 minutes to downtown Ottawa. Enjoy abundant recreation nearby including YMCA, arenas, golf clubs, Larose Forest trails (hiking, biking, cross-country skiing), and Ottawa River access for boating and fishing. Close to local shops, restaurants, farmers' markets, Calypso Water Park, and community centres. Move-in ready in one of Rockland's most desirable communities!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "607 - Clarence/Rockland Twp" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Prescott and Russell" +"CoveredSpaces": "2.0" +"CreationDate": "2026-03-28T05:20:07.606034+00:00" +"CrossStreet": "Dolomie Way & Sterling Ave" +"DirectionFaces": "West" +"Directions": "East on Docteur Corbeil to south on Sterling" +"ExpirationDate": "2026-06-26" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "fridge, stove, microwave, dishwasher, hood-fan, washer, dryer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "MPAC" +"MainOfficeKey": "504300" +"MajorChangeTimestamp": "2026-03-27T13:41:25Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-27T13:41:25Z" +"OriginalListPrice": 674900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3726170" +"ParcelNumber": "690602015" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-03-27T13:41:26Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sterling" +"StreetNumber": "433" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "5430.0" +"TaxLegalDescription": "LOT 4, PLAN 50M349 CITY OF CLARENCE-ROCKLAND" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 103.23 +"LotWidth": 41.14 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12927926')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "031601602201928" +"SurveyType": "Unknown" +"RentalItems": "HWT" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 10 +"LotSizeAreaUnits": "Square Meters" +"PossessionDetails": "June/July" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"MediaChangeTimestamp": "2026-03-27T13:41:26Z" +"SystemModificationTimestamp": "2026-03-29T10:45:20.568694Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:22 [ …22] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4091 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12638546" +"ListingId": "X12638546" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T10:39:01Z" +"RFModificationTimestamp": "2026-03-29T10:43:39Z" +"ListPrice": 479000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 1.662 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "North Dundas" +"PostalCode": "K0E 1S0" +"UnparsedAddress": "11441 Levere Road, North Dundas, ON K0E 1S0" +"Coordinates": array:2 [ …2] +"Latitude": 45.0581402 +"Longitude": -75.4147463 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "WHEELER SMART CHOICE REALTY BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Unique rural ranch-style bungalow complete with a wooded area at the back, just under 2 acres. Modest from the curb but spectacular inside - this artisinally crafted home-built by the owners-features insulated concrete form (ICF) construction inside and out, delivering a solid R-50 envelope for exceptional comfort and efficiency. You will impressed with the expansive main room and immediately feel the scale and thoughtful detailing: soaring sightlines, natural textures, wooden cathedral ceiling and an open layout perfect for everyday living and entertaining. Acid-rubbed, textured concrete walls create a warm, pueblo-inspired atmosphere, while poured terracotta-tone concrete floors lend an earthy, quiet, and durable foundation to the living spaces.The home offers four bedrooms, a main bathroom, and a large, front-facing exercise/fitness room off the foyer -offering multi-use options.The master bedroom is a work in progress but poised to become an exceptional retreat: large and bright with a patio door to the backyard, rough-in plumbing for a corner shower, tub and double sink, and a large walk-in closet/bonus area - excellent for a dressing room or private office.Set on a generously sized lot with mature trees in the back and room for outdoor living or future landscaping projects, this unique bungalow blends modern performance with artisanal character. Perfect for buyers seeking a home with distinctive architectural charm and plenty of potential. Located near Winchester-a historic village within the township of North Dundas, about 50 km south of Ottawa, known for its agricultural roots and charming small-town feel and offering a mix of quiet country life with nearby small town conveniences. Seller is in contact with the township with regards to outstanding occupancy permit issues and interested parties to enquire with township for status. House is being sold as is and buyer must include as-is provision in any offer. Please ask listing agent for more information." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "708 - North Dundas (Mountain) Twp" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Stormont, Dundas and Glengarry" +"CreationDate": "2026-02-07T09:06:28.345808+00:00" +"CrossStreet": "Highway 43 and County Rd 3" +"DirectionFaces": "North" +"Directions": "Highway 31 onto County Rd 43 Turn left onto County Rd 3, Turn right onto Levere Rd Destination will be on the left" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Inclusions": "built in stove top, fireplace," +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Cornwall and District Real Estate Board" +"ListingContractDate": "2025-12-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "479800" +"MajorChangeTimestamp": "2026-03-24T22:27:34Z" +"MlsStatus": "Extension" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-17T16:05:19Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3150418" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "661030083" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-12-17T16:05:19Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 499000.0 +"PriceChangeTimestamp": "2026-03-24T22:26:34Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Levere" +"StreetNumber": "11441" +"StreetSuffix": "Road" +"TaxAnnualAmount": "6416.0" +"TaxAssessedValue": 451000 +"TaxLegalDescription": "PT LT 18 CON 6 MOUNTAIN PT 2, 8R3428; NORTH DUNDAS" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"Zoning": "Rural" +"UFFI": "No" +"DDFYN": true +"Water": "Well" +"HeatType": "Other" +"LotDepth": 349.3 +"LotShape": "Irregular" +"LotWidth": 198.0 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12638546')" +"GarageType": "None" +"HeatSource": "Wood" +"RollNumber": "51101100767400" +"SurveyType": "Unknown" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 12 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"PossessionDetails": "to be determined" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 1 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"ContactAfterExpiryYN": true +"MediaChangeTimestamp": "2025-12-17T16:05:19Z" +"ExtensionEntryTimestamp": "2026-03-24T22:27:34Z" +"SystemModificationTimestamp": "2026-03-29T10:39:09.885969Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:46 [ …46] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4089 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12863074" +"ListingId": "X12863074" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T10:32:01Z" +"RFModificationTimestamp": "2026-03-29T10:35:07Z" +"ListPrice": 665000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "London North" +"PostalCode": "N6G 1L9" +"UnparsedAddress": "35 Rollscourt Gardens, London North, ON N6G 1L9" +"Coordinates": array:2 [ …2] +"Latitude": 43.572112 +"Longitude": -80.248328 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BLUE FOREST REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Chesham Heights, a sought-after, quiet, family-friendly neighbourhood in north London, ideally located near Western University, University Hospital, excellent schools, parks, transit, restaurants and everyday amenities. This well-maintained four-level side-split offers a versatile layout with strong rental potential, appealing to a wide range of buyers, including growing families, investors, parents of Western students or those seeking multi-generational living. From the moment you arrive, you are welcomed by a mature front yard framed by trees and a spacious 4-car driveway. Inside, the entry opens into a bright living room featuring a large bay window overlooking the front garden. The layout flows into the formal dining area, creating a great space for everyday living and entertaining. The updated kitchen features new cabinetry, white subway tile backsplash and stainless steel appliances. Upstairs, you will find three well-proportioned bedrooms and a 4-piece bathroom with ensuite access from the primary bedroom. A separate vanity area adds convenience for busy families. The finished lower level adds valuable living space, including a bright family room with above-grade windows and a decorative fireplace, an additional bedroom and a 3-piece bathroom. The family room could also function as another bedroom, providing flexibility for guests or extended family. The partially finished basement offers versatility, including a recreation room or gym area, a second kitchen and a combined furnace/laundry room, ideal for extended family, guests, or potential rental opportunities. The basement has been professionally waterproofed, providing added peace of mind. Outside, enjoy a fully fenced backyard providing space for relaxing and entertaining. Rental opportunity: This five-bedroom home (3+2) with 2 full bathrooms has a flexible multi-level layout. Estimated market rent potential: approximately $4,000/month." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "North K" +"CoListOfficeName": "BLUE FOREST REALTY INC." +"CoListOfficePhone": "519-649-1888" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Middlesex" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-09T19:16:25.675335+00:00" +"CrossStreet": "ROLLSCOURT & CITATION" +"DirectionFaces": "South" +"Directions": "OXFORD ST E; RIGHT ON WHARNCLIFFE RD N; CONTINUE ON WESTERN RD; TURN LEFT ON SARNIA RD; LEFT ON RIPPLETON; LEFT ON CITATION" +"Exclusions": "TENANT'S BELONGINGS" +"ExpirationDate": "2026-06-04" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "3 REFRIGERATORS; STOVE; DISHWASHER; MICROWAVE; FURNITURE IN LIVING ROOM, DINING ROOM, PRIMARY BEDROOM FURNITURE (BEDROOM, DESK, CHAIR); ADDITIONAL DESK & CHAIR, VIDEO DOORBELL" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "London and St. Thomas Association of REALTORS" +"ListingContractDate": "2026-03-09" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "411000" +"MajorChangeTimestamp": "2026-03-09T19:06:09Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-09T19:06:09Z" +"OriginalListPrice": 665000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3608548" +"ParcelNumber": "080730193" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-03-28T18:54:35Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rollscourt" +"StreetNumber": "35" +"StreetSuffix": "Gardens" +"TaxAnnualAmount": "4426.0" +"TaxLegalDescription": "LOT 193, PLAN 966, SUBJECT TO 268886 LONDON/LONDON TOWNSHIP" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://youtube.com/shorts/rm Fx-Upl5SI" +"Zoning": "R1-6" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 101.73 +"LotShape": "Irregular" +"LotWidth": 55.9 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12863074')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "393601045015900" +"SurveyType": "Unknown" +"RentalItems": "HOT WATER HEATER" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:4 [ …4] +"PossessionDetails": "Vacant / Tenanted" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-03-29T10:32:01Z" +"SystemModificationTimestamp": "2026-03-29T10:32:01.842306Z" +"Media": array:33 [ …33] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4067 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12927594" +"ListingId": "X12927594" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T10:11:38Z" +"RFModificationTimestamp": "2026-03-29T10:18:15Z" +"ListPrice": 1780000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Quinte West" +"PostalCode": "K8V 5P5" +"UnparsedAddress": "630 Old Highway 2 N/a, Quinte West, ON K8V 5P5" +"Coordinates": array:2 [ …2] +"Latitude": 44.0988246 +"Longitude": -77.5748551 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE PROALLIANCE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This is a rare opportunity to own a legacy property in one of the Bay of Quinte's most prestigious corridors. Whether you're hosting a summer soiree by the pool or enjoying a quiet morning watching the sunrise over the water, this estate offers a caliber of living that is truly second to none. This meticulously maintained 3,500+ sq.ft. masterpiece sits on a rare 2.08 acre lot on the south shore of the Bay of Quinte. Custom-built in 1998 by a premier local builder, this estate offers a seamless blend of luxury, privacy, and functional design, all located just minutes from the heart of Trenton and CFB Trenton. Designed for Multi-generational living or sophisticated entertaining, the main home features a flexible floor plan including a main floor primary suite plus a dedicated home office/guest room. The bright kitchen stretches from front to back, offering sweeping views of the estate including the custom inground pool and landscaping. Upstairs you'll find two generous bedrooms which share a bathroom. The bright, fully finished walk-out basement features a second kitchen, 3 piece bath, and large separate sitting rooms and recreational areas. Ideal for an in-law suite or seamless poolside entertaining. The detached garage is a dream, offering expansive storage for vehicles and water toys. Above, you'll find a fully self-contained studio suite, perfect for a private guest house, long-term rental, or a quiet professional workspace. On your way to the waterfront, you'll see that the property is a true outdoor sanctuary, professionally landscaped to highlight the natural beauty of the Bay. The private shoreline features a dock with boat lift for effortless access to the region's best sailing and fishing. You'll know you've 'arrived' when you arrive at 630 Old Highway 2." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Sidney Ward" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hastings" +"CoveredSpaces": "4.0" +"CreationDate": "2026-03-27T13:02:49.193822+00:00" +"CrossStreet": "White's Rd." +"DirectionFaces": "South" +"Directions": "GPS" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-06-26" +"ExteriorFeatures": array:3 [ …3] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "179000" +"MajorChangeTimestamp": "2026-03-27T12:55:18Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-27T12:55:18Z" +"OriginalListPrice": 1780000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3728432" +"OtherStructures": array:1 [ …1] +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "19.0" +"PhotosChangeTimestamp": "2026-03-29T10:11:35Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Old Highway 2" +"StreetNumber": "630" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "9372.81" +"TaxLegalDescription": "PT LT 23 RCP 2190 BEING PT 1 21R23963; SIDNEY; QUINTE WEST; COUNTY OF HASTINGS" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0%" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1m Gin Hb Dvy K7Tu43Xf Dw N6BVcd XUluhm1/view?usp=sharing" +"WaterBodyName": "Bay of Quinte" +"WaterfrontFeatures": array:2 [ …2] +"WaterfrontYN": true +"Zoning": "RRE" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 848.38 +"LotWidth": 114.02 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12927594')" +"Shoreline": array:2 [ …2] +"WaterView": array:1 [ …1] +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "120421103508700" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"DockingType": array:1 [ …1] +"RentalItems": "None" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 3 +"ParkingSpaces": 15 +"WaterBodyType": "Bay" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 6 +"WaterFrontageFt": "134.22" +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"PropertyFeatures": array:3 [ …3] +"PossessionDetails": "90+ Days" +"ShorelineExposure": "North" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 3 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 2 +"KitchensBelowGrade": 1 +"ShorelineAllowance": "Owned" +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Main" +"WashroomsType4Level": "Basement" +"WashroomsType5Level": "Upper" +"WaterfrontAccessory": array:1 [ …1] +"MediaChangeTimestamp": "2026-03-29T10:11:35Z" +"ShorelineExposureMulti": array:1 [ …1] +"SystemModificationTimestamp": "2026-03-29T10:11:50.993532Z" +"Media": array:50 [ …50] } ] +success: true +page_size: 5 +page_count: 4027 +count: 20131 +after_key: "" } ] ]