Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=920&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=920&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=920&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=920&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2862 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2855 +post_id: "642592" +post_author: 1 +"ListingKey": "X12896672" +"ListingId": "X12896672" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:25:08Z" +"RFModificationTimestamp": "2026-05-03T01:56:59Z" +"ListPrice": 659900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 4Y8" +"UnparsedAddress": "80 Foxborough Drive, Hamilton, ON L9G 4Y8" +"Coordinates": array:2 [ …2] +"Latitude": 43.203794738629 +"Longitude": -79.986208714297 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "LOCATION LOCATION LOCATION!!!!! Check out this spacious over 1400 Sq ft end unit FREEHOLD town with single car garage in the sought after Maple Lane area. This great layout with open concept living room & eat-in kitchen with walk-out to the back deck make this one ideal for entertaining family & friends. The eat-in kitchen was updated in 2025 and offers plenty of modern white cabinets, modern yet classic subway tile backsplash, ample stone counter space including the large peninsula with additional seating. The living room offers plenty of natural light giving a spacious feel. This floor is complete with the convenience of a 2 piece powder rm. Upstairs offers plenty of space for the family with a three spacious beds and a 3 piece bath. The Master retreat offers plenty of space, ensuite privilege and his and her closets. Looking for even more space for the family the finished basement offers, large rec room perfect for family games or movie nights with plenty of space for an office or kids play area & there is still plenty of room for storage. The fully fenced backyard is a great size for a townhome and offers an extra large covered deck for entertaining and meals and a bonus hook up for gas BBQ and a shed for all your outdoor storage. This home has it ALL and close to all conveniences including highway access for commuting." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T06:25:03.457811+00:00" +"CrossStreet": "DERBYSHIRE STREET" +"DirectionFaces": "South" +"Directions": "TURN RIGHT AT THE 1ST CORNER ONTO DERBYSHIRE ST. THEN LEFT ONTO FOXBOROUGH DR" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": "Deck" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "WASHER, DRYER, FRIDGE, STOVE, DISHWASHER & MICROWAVE" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-18" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-16T13:25:08Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-18T18:21:23Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3689686" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "174150795" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-18T18:21:24Z" +"PoolFeatures": "None" +"PreviousListPrice": 699900.0 +"PriceChangeTimestamp": "2026-04-16T13:25:08Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Foxborough" +"StreetNumber": "80" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4259.67" +"TaxLegalDescription": "PT BLK 93 PL 62M800, PART 1 ON 62R14916; S/T LT468671; S/T RIGHT FOR 20 YEARS AS IN LT567625; ANCASTER CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.07 +"LotWidth": 24.61 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12896672')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814022038443" +"SurveyType": "None" +"RentalItems": "Hot water heater" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 4Y8, CA" +"ApproximateAge": "16-30" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:2 [ …2] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "905-297-7777/APPTS@RMXEMAIL.NET OR BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-03-18T22:57:37Z" +"SystemModificationTimestamp": "2026-04-16T13:25:19.8543Z" +"Media": array:16 [ …16] +"ID": "642592" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "679640" +post_author: 1 +"ListingKey": "X13002990" +"ListingId": "X13002990" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:23:55Z" +"RFModificationTimestamp": "2026-05-02T20:21:24Z" +"ListPrice": 1339800.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1V3" +"UnparsedAddress": "28 Celano Drive, Hamilton, ON L8B 1V3" +"Coordinates": array:2 [ …2] +"Latitude": 43.34823 +"Longitude": -79.881775 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CITYSCAPE REAL ESTATE LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 28 Celano Drive - A Stunning Park-Backed Family Home in the Heart of Waterdown! DUE TO STRONG INTEREST, PRICE ADJUSTED! Experience luxury, comfort, and an exceptional lifestyle in this beautifully upgraded and meticulously maintained 4 +1 bedroom, 4-bathroom home offering approximately 3,026 sq. ft. of finished living space. Built in 2017 and perfectly positioned backing directly onto Cranberry Park with private park access, this home offers rare privacy and scenic surroundings. Step inside to a bright and elegant open-concept main level featuring rich hardwood flooring, a designer kitchen with quartz countertops, upgraded cabinetry, premium Kitchen Aid stainless steel appliances, along with a brand-new LG 36" refrigerator and Samsung dishwasher. The spacious Great Room with a cozy fireplace creates the perfect setting for family gatherings, while a separate den provides an ideal space for a home office or study. The second level showcases new flooring throughout, a generously sized primary suite complete with a 3-piece ensuite and walk-in closet, along with three additional bedrooms, convenient second-floor laundry, and a large family room-perfect for relaxation or entertainment. The fully finished basement adds incredible value, featuring an additional bedroom, full bathroom, recreation area, and pantry-ideal for extended family, guests, or multi-generational living. This home is further enhanced with modern LED lighting throughout and elegant marble and stone finishes in the kitchen and all bathrooms, reflecting quality and attention to detail at every turn. Step outside to your private backyard oasis, fully fenced and featuring a spacious deck and an extra-large hot tub that doubles as a swimming pool-perfect for year-round enjoyment while backing onto the tranquility of Cranberry Park. Located in one of Waterdown's most sought-after neighborhood, you are just minutes from top-rated schools, shopping, restaurants, parks, and major highways in" +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Waterdown" +"CoListOfficeName": "CITYSCAPE REAL ESTATE LTD." +"CoListOfficePhone": "905-241-2222" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T06:26:26.198742+00:00" +"CrossStreet": "Spring Creek Dr & Avonsyde Blv" +"DirectionFaces": "East" +"Directions": "Spring Creek Dr & Avonsyde Blv" +"Exclusions": "Staging Furniture, Basement Exercise items." +"ExpirationDate": "2026-07-15" +"ExteriorFeatures": "Deck,Hot Tub,Privacy,Porch,Recreational Area" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Range Hood, Washer, Dryer, All Wdw Covgs, All Light Fixtures" +"InteriorFeatures": "Auto Garage Door Remote,Built-In Oven,Carpet Free,Countertop Range,Water Heater,In-Law Suite,Sump Pump" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"MainOfficeKey": "158700" +"MajorChangeTimestamp": "2026-04-15T18:21:46Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T18:21:46Z" +"OriginalListPrice": 1339800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3821132" +"ParcelNumber": "175031135" +"ParkingFeatures": "Available" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-15T18:21:47Z" +"PoolFeatures": "Above Ground,Outdoor" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:3 [ …3] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Celano" +"StreetNumber": "28" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7951.0" +"TaxLegalDescription": "LOT 113, PLAN 62M1231" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.00% +HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded2": "https://view.spiro.media/28_celano_dr-2779?branding=false" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 89.73 +"LotWidth": 39.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13002990')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830335063313" +"SurveyType": "None" +"RentalItems": "Hot Water Tank & Furnace" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 1V3, CA" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-17" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 13 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "Vacant" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Through Brokerbay (supra)" +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-15T18:21:47Z" +"SystemModificationTimestamp": "2026-04-16T13:24:07.109498Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] +"ID": "679640" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "655396" +post_author: 1 +"ListingKey": "X12920236" +"ListingId": "X12920236" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:19:43Z" +"RFModificationTimestamp": "2026-05-03T05:22:45Z" +"ListPrice": 369900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 1J7" +"UnparsedAddress": "1968 Main Street W 103, Hamilton, ON L8S 1J7" +"Coordinates": array:2 [ …2] +"Latitude": 43.249953 +"Longitude": -79.943989 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "MARTIN GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience the perfect harmony of urban convenience and serene natural beauty in this meticulously renovated West Hamilton gem. As soon as you open the door, you will be mesmerized by breathtaking, unobstructed ravine views of the protected conservation area, allowing you to appreciate the local wildlife and changing seasons right from your living room or private balcony. This move-in-ready home underwent extensive upgrades in 2020, featuring modern kitchen countertops, a stylish backsplash, and premium stainless steel appliances. The entire space is tied together with contemporary laminate flooring, updated trim, and a fresh, neutral palette. Both bathrooms have been completely transformed with easy-care ceramic tiling, offering a spa-like retreat. With oversized windows in every room, the home is flooded with natural light and offers peaceful ravine views from each bedroom. Practicality meets luxury with ample in-unit storage and a custom utility closet. Residents enjoy elite building amenities, including a heated indoor salt water pool, a fully equipped gym with sauna, guest suite, party room and craft room. Located just minutes from the charming hubs of Westdale, Ancaster, and Dundas, and within walking distance to Mc Master University, this property offers a turnkey lifestyle for first-time buyers, young professionals, or those looking to downsize without compromise. *Dining room photos virtually staged." +"ArchitecturalStyle": "1 Storey/Apt" +"AssociationAmenities": array:6 [ …6] +"AssociationFee": "929.27" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"BuildingName": "Forest Glen Condominiums" +"CityRegion": "Ainslie Wood" +"CoListOfficeName": "MARTIN GROUP" +"CoListOfficePhone": "905-338-2083" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T06:27:22.011775+00:00" +"CrossStreet": "MAIN ST W /OSLER DR" +"Directions": "MAIN ST W /OSLER DR" +"Exclusions": "Non" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": "Backs On Green Belt,Landscaped,Lighting,Privacy" +"GarageYN": true +"Inclusions": "Fridge, stove, hood fan, dishwasher, all electrical light fixtures, all window coverings, window AC unit, wall mounted tv brackets, media unit and shelves in living room, desk in 3rd bedroom, fridge in storage room, storage room shelving." +"InteriorFeatures": "Auto Garage Door Remote,Intercom,Primary Bedroom - Main Floor,Sauna,Separate Hydro Meter,Storage,Storage Area Lockers" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-25" +"LotSizeSource": "MPAC" +"MainOfficeKey": "151200" +"MajorChangeTimestamp": "2026-03-25T17:35:27Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-25T17:35:27Z" +"OriginalListPrice": 369900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3678884" +"ParcelNumber": "180090348" +"ParkingFeatures": "Underground,Inside Entry" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T13:19:41Z" +"Roof": "Asphalt Rolled" +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Main" +"StreetNumber": "1968" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3215.0" +"TaxYear": "2025" +"Topography": array:3 [ …3] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "103" +"View": array:3 [ …3] +"Zoning": "A, B-1, E/S-52" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North West" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920236')" +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "39" +"RollNumber": "251801001602410" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "None" +"HoldoverDays": 30 +"LegalStories": "B" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 1J7, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 9 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"MortgageComment": "SELLER TO DISCHARGE" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "MPAC" +"CoListOfficeName3": "MARTIN GROUP" +"ParkingLevelUnit1": "12PB-Lvl B" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay or 905-338-2083" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "12" +"MediaChangeTimestamp": "2026-04-16T13:19:41Z" +"PropertyManagementCompany": "King Condo Management" +"SystemModificationTimestamp": "2026-04-16T13:19:58.231923Z" +"Media": array:27 [ …27] +"ID": "655396" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "577383" +post_author: 1 +"ListingKey": "X12742372" +"ListingId": "X12742372" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:11:03Z" +"RFModificationTimestamp": "2026-05-02T20:20:16Z" +"ListPrice": 1999900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8J 1K4" +"UnparsedAddress": "10 Azalea Court, Hamilton, ON L8J 1K4" +"Coordinates": array:2 [ …2] +"Latitude": 43.2039226 +"Longitude": -79.7942225 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Perched atop the breathtaking Niagara Escarpment, this exceptional home offers seasonal panoramic views of Lake Ontario and the Toronto skyline. Rarely available, it features over 5,100 sq. ft. of beautifully finished living space across three levels, showcasing thoughtful design and custom craftsmanship throughout. Enjoy private access to the Bruce Trail, with waterfalls and scenic hikes just steps from your backyard - a nature lover's dream without sacrificing city convenience. The main floor blends elegance and warmth with new hardwood floors, a custom staircase, and stylish lighting. A formal living room with a wood-burning fireplace flows into a dining room made for entertaining. The chef-inspired kitchen with custom cabinetry opens to a welcoming family room with a new gas fireplace. Upstairs offers four spacious bedrooms, including a luxurious primary suite with a walk-in closet, spa-like ensuite, and private balcony - perfect for peaceful morning views. The bright, fully finished lower level features large windows, custom woodwork, a gas fireplace, bedroom, kitchenette, and separate entrance, ideal for in-law, nanny, or multi-generational living. Explore the potential to sever a second lot or add an auxiliary unit. Outside, your private retreat awaits with a 30 x 60 in-ground pool (16 ft. deep), wrought iron fencing, pool house, and custom shed - perfect for summer entertaining. Recent updates include power blinds, 2023 HVAC systems, refreshed porch, and pool and landscape upgrades. A rare escarpment gem where nature, privacy, and luxury meet." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Stoney Creek Mountain" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-24T22:57:23.122763+00:00" +"CrossStreet": "Audubon St N" +"DirectionFaces": "South" +"Directions": "Mud St W to Paramount Dr - right on Audubon St N - left at Azalea Crt" +"ExpirationDate": "2026-05-31" +"ExteriorFeatures": "Landscaped,Porch,Hot Tub" +"FireplaceFeatures": array:5 [ …5] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Hot Tub, Hot Water Tank Owned, Pool Equipment, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, Chest Freezer, Basement Fridge, Basement Stove" +"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Storage,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-29" +"LotSizeSource": "MPAC" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-01-30T19:49:17Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-30T16:35:39Z" +"OriginalListPrice": 1999900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3498002" +"OtherStructures": array:3 [ …3] +"ParcelNumber": "170970987" +"ParkingFeatures": "Private Double,Inside Entry" +"ParkingTotal": "14.0" +"PhotosChangeTimestamp": "2026-04-16T13:06:19Z" +"PoolFeatures": "Inground" +"PreviousListPrice": 1999900.0 +"PriceChangeTimestamp": "2026-01-30T16:37:35Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Azalea" +"StreetNumber": "10" +"StreetSuffix": "Court" +"TaxAnnualAmount": "10904.54" +"TaxAssessedValue": 887000 +"TaxLegalDescription": "PCL BLK M-1, SEC M181 ; PT BLK M, PL M181 , PART 1 , 62R7533 ; STONEY CREEK CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% to co-op Brokerage" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://media.otbxair.com/10-Azalea-Ct-1/idx" +"Zoning": "R2" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 295.68 +"LotShape": "Irregular" +"LotWidth": 46.59 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12742372')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251800365511280" +"SurveyType": "None" +"RentalItems": "none" +"HoldoverDays": 120 +"LaundryLevel": "Lower Level" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 12 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8J 1K4, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 4 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2026-04-16T13:11:03Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-16T13:11:19.249719Z" +"Media": array:48 [ …48] +"ID": "577383" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "679835" +post_author: 1 +"ListingKey": "X13005504" +"ListingId": "X13005504" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:09:17Z" +"RFModificationTimestamp": "2026-05-02T20:21:28Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 3V1" +"UnparsedAddress": "92 Reid Avenue S, Hamilton, ON L8K 3V1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2327652 +"Longitude": -79.7884287 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER COMMUNITY PROFESSIONALS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "For the first time since 1958, this cherished family home is ready to welcome its next chapter. Lovingly maintained and thoughtfully cared, this is more than just a house-it's a place where memories were made, traditions were built, and life unfolded beautifully. Inside, you'll find the functional kitchen opens to the dining space, creating an easy flow for everyday living and hosting. The living room is filled with natural light thanks to the picture window, offering a warm and inviting place to gather. Upstairs, three comfortable bedrooms provide space for family, while the standout retro-cool bathroom-1950s glam-adds a touch of character and nostalgia. With a separate entrance(s) to the finished lower level, you will find a full bathroom, abundant storage, the workings of a second kitchen, and a space where generation of one family came together to celebrating holidays, sharing meals, and making lasting memories. Outside, the home continues to impress. A long 4-car tandem driveway offers ample parking, while the fenced yard provides room to relax, eat, and grow. Green thumbs will appreciate the space to grow vegetables in the back garden, and the charming front veranda is the perfect spot to sit, unwind, and admire the lovingly tended rose and flower gardens. This is a home that has been deeply loved, and it shows in every corner. A rare opportunity to carry forward a legacy of care, warmth, and connection. RSA" +"ArchitecturalStyle": "Bungalow" +"Basement": array:4 [ …4] +"CityRegion": "Glenview" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-16T13:22:23.139701+00:00" +"CrossStreet": "Main St E/Reid Ave S" +"DirectionFaces": "West" +"Directions": "Main St E, right on to Reid Ave S" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": "Awnings,Landscaped,Patio,Porch" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, gas stove, cook top, dishwasher, washer & dryer, light fixtures, window coverings, all in "AS IS" condition" +"InteriorFeatures": "Carpet Free,In-Law Capability,Primary Bedroom - Main Floor,Water Heater,Water Meter" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "090000" +"MajorChangeTimestamp": "2026-04-16T13:09:17Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T13:09:17Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3812340" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "172780124" +"ParkingFeatures": "Private,Tandem" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-16T13:09:17Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Reid" +"StreetNumber": "92" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4314.48" +"TaxAssessedValue": 303000 +"TaxLegalDescription": "LT 431, PL 574 ; PT LT 430, PL 574, AS IN AB231868 ; HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/241006336" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 92.33 +"LotWidth": 42.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005504')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251805042206890" +"SurveyType": "None" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Available" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8K 3V1, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"MortgageComment": "Clear" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay & LBO" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-16T13:09:17Z" +"SystemModificationTimestamp": "2026-04-16T13:09:18.489886Z" +"Media": array:50 [ …50] +"ID": "679835" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2849 +post_id: "673132" +post_author: 1 +"ListingKey": "X12987252" +"ListingId": "X12987252" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:57:42Z" +"RFModificationTimestamp": "2026-05-03T05:22:47Z" +"ListPrice": 1995.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 3A1" +"UnparsedAddress": "77 Leland Street 108, Hamilton, ON L8S 3A1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2554392 +"Longitude": -79.9229193 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE CERTIFIED REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing Ground Floor Unit, with HUGE Patio....Sparkling clean, Cheerful, Bright & sunny, almost new building!! Granite kitchen countertop with ceramic backsplash! Stainless Steel appliances. Walk to Mc Master University, Mc Master Children's Hospital. Walk to everywhere, Groceries, Bank, Coffee shops, restaurants, transit.....Dedicated surface parking spot. This is designed for lifestyle and functionality, and is perfect for students or professionals! Excellent for investors - low condo fees. Situated right next to the Hamilton Burlington Trail and surrounded by amenities, entertainment, greenspace, shopping, restaurants and public transit, this unit checks all the boxes! Really Quiet & Safe Neighborhood! Additional Building Amenities Include On-Site Laundry, Secure In-Door Bike Storage, 24/7 Emergency Maintenance, Security Cameras + Visitor Parking. COMES WITH 1 PARKING SPOT!! NOT TO BE MISSED...BOOK YOUR SHOWING TODAY!" +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Ainslie Wood" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-05-01T16:47:48.147946+00:00" +"CrossStreet": "Leland and Main Street" +"Directions": "Leland and Main Street" +"Exclusions": "Rent does not include hydro and hot water tank charges" +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"InteriorFeatures": "Primary Bedroom - Main Floor" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-10" +"MainOfficeKey": "060200" +"MajorChangeTimestamp": "2026-04-15T17:01:44Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-11T17:55:17Z" +"OriginalListPrice": 2200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3801128" +"ParcelNumber": "185980008" +"ParkingFeatures": "Surface" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-11T17:55:18Z" +"PreviousListPrice": 2200.0 +"PriceChangeTimestamp": "2026-04-15T17:01:44Z" +"RentIncludes": array:7 [ …7] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Leland" +"StreetNumber": "77" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month rent" +"TransactionType": "For Lease" +"UnitNumber": "108" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12987252')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251801004204359" +"SurveyType": "None" +"BalconyType": "Terrace" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 3A1, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 598 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 2 +"LeaseAgreementYN": true +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "builder plan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "8" +"MediaChangeTimestamp": "2026-04-11T17:55:18Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Cie Property Management" +"SystemModificationTimestamp": "2026-04-16T12:57:44.559305Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:37 [ …37] +"ID": "673132" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "679519" +post_author: 1 +"ListingKey": "X13003672" +"ListingId": "X13003672" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:46:33Z" +"RFModificationTimestamp": "2026-05-03T05:22:49Z" +"ListPrice": 2150.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 0C2" +"UnparsedAddress": "81 Robinson Street 201, Hamilton, ON L8P 0C2" +"Coordinates": array:2 [ …2] +"Latitude": 43.2513117 +"Longitude": -79.8752359 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Large 1 bed plus den for lease in fantastic Durand neighbourhood. Nice and large balcony and modern finishes. Close to hospital, transit, parks, schools & all amenities." +"ArchitecturalStyle": "1 Storey/Apt" +"Basement": array:1 [ …1] +"CityRegion": "Durand" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-01T16:48:43.224773+00:00" +"CrossStreet": "Park" +"Directions": "James to Robinson" +"ExpirationDate": "2026-09-15" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Dishwsher, Dryer, Garage Door Opener, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": "Other" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-04-15T20:00:09Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-15T20:00:09Z" +"OriginalListPrice": 2150.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3819704" +"ParcelNumber": "185300308" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T20:00:10Z" +"RentIncludes": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Robinson" +"StreetNumber": "81" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "201" +"UFFI": "No" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13003672')" +"GarageType": "Underground" +"HeatSource": "Electric" +"RollNumber": "251802013171258" +"SurveyType": "Unknown" +"BalconyType": "Terrace" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"LockerNumber": "201" +"ParkingSpot1": "191" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:2 [ …2] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 0C2, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 530 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "Owner" +"ParkingLevelUnit1": "P3" +"PossessionDetails": "30-59 Days" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "LBO/Brokerbay. 24 Hours notice required" +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "01" +"MediaChangeTimestamp": "2026-04-15T20:00:10Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-16T12:46:37.011584Z" +"Media": array:19 [ …19] +"ID": "679519" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "679836" +post_author: 1 +"ListingKey": "X13005224" +"ListingId": "X13005224" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:13:51Z" +"RFModificationTimestamp": "2026-05-02T20:21:27Z" +"ListPrice": 1749000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 3X3" +"UnparsedAddress": "600 Highvalley Road, Hamilton, ON L9G 3X3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2314526 +"Longitude": -79.9628031 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ACCSELL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Exceptional Family Home in Sought-After Mohawk Meadows. Welcome to this spacious and inviting 4+1 bedroom, 3.5 bathroom home nestled in the heart of the family-friendly Mohawk Meadows community. Designed with comfort and versatility in mind, this property offers ample space for growing families and entertaining guests. The open-concept kitchen features a generous island and overlooks a sunken great room, perfect for hosting or relaxing in style. Step outside to a beautifully landscaped yard complete with a large deck and hot tub, creating the ideal setting for enjoying evenings and weekend gatherings. The fully finished basement adds even more living space, including a large recreation room, an additional bedroom, a 3-piece bath, and a private sauna for ultimate relaxation. Don't miss your chance to own a home in one of the area's most desirable and established neighborhoods." +"ArchitecturalStyle": "2-Storey" +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-24T23:10:10.661506+00:00" +"CrossStreet": "Mohawk Rd & Lime Kiln Road" +"DirectionFaces": "South" +"Directions": "From Mohawk Rd turn North on Green Ravine Dr then Left onto Highvalley Rd" +"ExpirationDate": "2026-07-30" +"ExteriorFeatures": "Hot Tub,Landscaped,Deck,Patio" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"InteriorFeatures": "Central Vacuum,Auto Garage Door Remote,Sauna" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "60.04 x 158.48 Feet" +"MainLevelBathrooms": 1 +"MainOfficeKey": "215200" +"MajorChangeTimestamp": "2026-04-16T12:10:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-16T12:10:22Z" +"OriginalListPrice": 1749000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3816118" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "175640486" +"ParkingFeatures": "Private" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-04-16T12:10:22Z" +"PoolFeatures": "None" +"Roof": "Shingles" +"RoomsTotal": "19" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Highvalley" +"StreetNumber": "600" +"StreetSuffix": "Road" +"TaxAnnualAmount": "8646.49" +"TaxBookNumber": "251814027044651" +"TaxLegalDescription": "Pcl 1-1, Sec M304 ; Lt 1, Pl M304 ; Ancaster City" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/600_highvalley_road_hamilton_on/" +"Zoning": "R3" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 158.48 +"LotWidth": 60.04 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005224')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814027044651" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 3X3, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 14 +"RoomsBelowGrade": 5 +"PropertyFeatures": array:6 [ …6] +"StreetSuffixCode": "Rd" +"BoardPropertyType": "Free" +"PossessionDetails": "must provide notice to tenant for vacant possession" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-16T12:10:22Z" +"MLSAreaDistrictOldZone": "X14" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2026-04-16T12:14:03.3576Z" +"Media": array:33 [ …33] +"ID": "679836" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "685780" +post_author: 1 +"ListingKey": "X13005194" +"ListingId": "X13005194" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:02:00Z" +"RFModificationTimestamp": "2026-05-02T20:21:27Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.1 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 6M8" +"UnparsedAddress": "197 Sherman Avenue N, Hamilton, ON L8L 6M8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing opportunity ! Fully detached all brick building operating as a sports club / bar with a two bedroom rental apartment on the upper level. Premium 20' X 158' pie - shaped lot ( 40' rear ) located in the up and coming " Gibson Community ". This is a fully operational " Sports Club" with a 64 person capacity and is being sold with the " Liquor Sales License " ( see attached ). The new owner is responsible to transfer the license to his / her name. The building is solid but needs cosmetic updating on all three levels, large rear yard with multiple storage buildings and a detached all brick garage fronting onto the rear laneway. All fixtures and chattels are included " as-is ", no financials are available for the Sports Club and there is no guarantee that the Alcohol and Gaming Commission will accept the new applicant. This is a perfect opportunity for the new owner to live / work in the same location and create equity by improving the existing building / property. Second floor apartment has a side entrance as well as a rear stairwell. Hot water gas heat, gas hot water tank ( rental ). Sale price includes the building and operating business." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Gibson" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-01T16:56:01.646867+00:00" +"CrossStreet": "Sherman / Barton" +"DirectionFaces": "West" +"Directions": "Sherman / Barton" +"ExpirationDate": "2027-03-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All electrical light fixtures, all window coverings, fridge, stove, shed, bar fridge." +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "498000" +"MajorChangeTimestamp": "2026-04-16T12:02:00Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2026-04-16T12:02:00Z" +"OriginalListPrice": 549000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3824564" +"ParcelNumber": "171940228" +"ParkingFeatures": "Street Only" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-16T12:02:00Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Sherman" +"StreetNumber": "197" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3667.99" +"TaxLegalDescription": "Plan 245, PT Lot 10" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Water" +"LotDepth": 157.9 +"LotWidth": 20.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005194')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "251803023607890" +"SurveyType": "None" +"RentalItems": "Hot Water Tank ( if rental )" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 6M8, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"MortgageComment": "Treat as clear, please email all offers to info@sandykennedy.com, as per the seller." +"RoomsAboveGrade": 5 +"PropertyFeatures": array:1 [ …1] +"LotIrregularities": "Pie-Shaped Lot ( 40' Rear ) !" +"PossessionDetails": "30-60 Days/ TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-16T12:02:00Z" +"SystemModificationTimestamp": "2026-04-16T12:02:00.904185Z" +"Media": array:22 [ …22] +"ID": "685780" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "690296" +post_author: 1 +"ListingKey": "X13004700" +"ListingId": "X13004700" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T01:13:02Z" +"RFModificationTimestamp": "2026-05-02T20:21:27Z" +"ListPrice": 724900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C 4T3" +"UnparsedAddress": "316 Cranbrook Drive, Hamilton, ON L9C 4T3" +"Coordinates": array:2 [ …2] +"Latitude": 43.218354 +"Longitude": -79.912574 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own a fully updated 3+1 bedroom, 2-bath backsplit in a prime mountain location! Extensively renovated in 2020, this home features a gourmet kitchen with a full stainless steel appliance package: fridge, gas stove, dishwasher, microwave, beverage fridge, and new washer and gas dryer. The functional layout offers hardwood and tile floors throughout for a sleek, carpet-free finish. Enjoy ultimate peace of mind with a new furnace, central air, hot water tank, and updated windows/doors (all 2020). The exterior is equally impressive with a new cement driveway (2020) and a beautifully landscaped, fenced yard with fresh sod. Situated on a quiet street close to schools, buses, parks, and shopping, with quick highway access, this is the move-in-ready family home you've been waiting for!" +"ArchitecturalStyle": "Backsplit 4" +"Basement": array:1 [ …1] +"CityRegion": "Gilkson" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-20T18:01:19.710859+00:00" +"CrossStreet": "STONECHURCH & COURTLAND" +"DirectionFaces": "South" +"Directions": "STONECHURCH & COURTLAND" +"ExpirationDate": "2026-09-14" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-16T01:13:02Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-16T01:13:02Z" +"OriginalListPrice": 724900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3819210" +"ParcelNumber": "169470218" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-16T01:13:02Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "CRANBROOK" +"StreetNumber": "316" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5200.0" +"TaxLegalDescription": "PCL 39-1, SEC M83 ; LT 39, PL M83 ; HAMILTON" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70050" +"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=70050" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 99.12 +"LotWidth": 46.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13004700')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251808103104034" +"SurveyType": "Unknown" +"RentalItems": "HOT WATER TANK" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9C 4T3, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 10 +"PossessionDetails": "30-60 DAYS" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please book through Supra / Broker Bay or call our appointment centre at 905-592-7777." +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-16T01:13:02Z" +"SystemModificationTimestamp": "2026-04-16T01:13:02.937707Z" +"Media": array:43 [ …43] +"ID": "690296" } ] +success: true +page_size: 10 +page_count: 142 +count: 1417 +after_key: "" } "RF Response Time" => "0.3 seconds" ] "RF Cache Key: 643c78afaacbc0f2c0daef1f4b6f8f04b3afba353af6547e4deabe0524405119" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3126 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4313 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12896672" +"ListingId": "X12896672" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:25:08Z" +"RFModificationTimestamp": "2026-05-03T01:56:59Z" +"ListPrice": 659900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 4Y8" +"UnparsedAddress": "80 Foxborough Drive, Hamilton, ON L9G 4Y8" +"Coordinates": array:2 [ …2] +"Latitude": 43.203794738629 +"Longitude": -79.986208714297 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "LOCATION LOCATION LOCATION!!!!! Check out this spacious over 1400 Sq ft end unit FREEHOLD town with single car garage in the sought after Maple Lane area. This great layout with open concept living room & eat-in kitchen with walk-out to the back deck make this one ideal for entertaining family & friends. The eat-in kitchen was updated in 2025 and offers plenty of modern white cabinets, modern yet classic subway tile backsplash, ample stone counter space including the large peninsula with additional seating. The living room offers plenty of natural light giving a spacious feel. This floor is complete with the convenience of a 2 piece powder rm. Upstairs offers plenty of space for the family with a three spacious beds and a 3 piece bath. The Master retreat offers plenty of space, ensuite privilege and his and her closets. Looking for even more space for the family the finished basement offers, large rec room perfect for family games or movie nights with plenty of space for an office or kids play area & there is still plenty of room for storage. The fully fenced backyard is a great size for a townhome and offers an extra large covered deck for entertaining and meals and a bonus hook up for gas BBQ and a shed for all your outdoor storage. This home has it ALL and close to all conveniences including highway access for commuting." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T06:25:03.457811+00:00" +"CrossStreet": "DERBYSHIRE STREET" +"DirectionFaces": "South" +"Directions": "TURN RIGHT AT THE 1ST CORNER ONTO DERBYSHIRE ST. THEN LEFT ONTO FOXBOROUGH DR" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "WASHER, DRYER, FRIDGE, STOVE, DISHWASHER & MICROWAVE" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-18" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-16T13:25:08Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-18T18:21:23Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3689686" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "174150795" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-18T18:21:24Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 699900.0 +"PriceChangeTimestamp": "2026-04-16T13:25:08Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Foxborough" +"StreetNumber": "80" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4259.67" +"TaxLegalDescription": "PT BLK 93 PL 62M800, PART 1 ON 62R14916; S/T LT468671; S/T RIGHT FOR 20 YEARS AS IN LT567625; ANCASTER CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.07 +"LotWidth": 24.61 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12896672')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814022038443" +"SurveyType": "None" +"RentalItems": "Hot water heater" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 4Y8, CA" +"ApproximateAge": "16-30" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:2 [ …2] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "905-297-7777/APPTS@RMXEMAIL.NET OR BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-03-18T22:57:37Z" +"SystemModificationTimestamp": "2026-04-16T13:25:19.8543Z" +"Media": array:16 [ …16] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4314 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13002990" +"ListingId": "X13002990" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:23:55Z" +"RFModificationTimestamp": "2026-05-02T20:21:24Z" +"ListPrice": 1339800.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1V3" +"UnparsedAddress": "28 Celano Drive, Hamilton, ON L8B 1V3" +"Coordinates": array:2 [ …2] +"Latitude": 43.34823 +"Longitude": -79.881775 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CITYSCAPE REAL ESTATE LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 28 Celano Drive - A Stunning Park-Backed Family Home in the Heart of Waterdown! DUE TO STRONG INTEREST, PRICE ADJUSTED! Experience luxury, comfort, and an exceptional lifestyle in this beautifully upgraded and meticulously maintained 4 +1 bedroom, 4-bathroom home offering approximately 3,026 sq. ft. of finished living space. Built in 2017 and perfectly positioned backing directly onto Cranberry Park with private park access, this home offers rare privacy and scenic surroundings. Step inside to a bright and elegant open-concept main level featuring rich hardwood flooring, a designer kitchen with quartz countertops, upgraded cabinetry, premium Kitchen Aid stainless steel appliances, along with a brand-new LG 36" refrigerator and Samsung dishwasher. The spacious Great Room with a cozy fireplace creates the perfect setting for family gatherings, while a separate den provides an ideal space for a home office or study. The second level showcases new flooring throughout, a generously sized primary suite complete with a 3-piece ensuite and walk-in closet, along with three additional bedrooms, convenient second-floor laundry, and a large family room-perfect for relaxation or entertainment. The fully finished basement adds incredible value, featuring an additional bedroom, full bathroom, recreation area, and pantry-ideal for extended family, guests, or multi-generational living. This home is further enhanced with modern LED lighting throughout and elegant marble and stone finishes in the kitchen and all bathrooms, reflecting quality and attention to detail at every turn. Step outside to your private backyard oasis, fully fenced and featuring a spacious deck and an extra-large hot tub that doubles as a swimming pool-perfect for year-round enjoyment while backing onto the tranquility of Cranberry Park. Located in one of Waterdown's most sought-after neighborhood, you are just minutes from top-rated schools, shopping, restaurants, parks, and major highways in" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Waterdown" +"CoListOfficeName": "CITYSCAPE REAL ESTATE LTD." +"CoListOfficePhone": "905-241-2222" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T06:26:26.198742+00:00" +"CrossStreet": "Spring Creek Dr & Avonsyde Blv" +"DirectionFaces": "East" +"Directions": "Spring Creek Dr & Avonsyde Blv" +"Exclusions": "Staging Furniture, Basement Exercise items." +"ExpirationDate": "2026-07-15" +"ExteriorFeatures": array:5 [ …5] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Range Hood, Washer, Dryer, All Wdw Covgs, All Light Fixtures" +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"MainOfficeKey": "158700" +"MajorChangeTimestamp": "2026-04-15T18:21:46Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T18:21:46Z" +"OriginalListPrice": 1339800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3821132" +"ParcelNumber": "175031135" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-15T18:21:47Z" +"PoolFeatures": array:2 [ …2] +"Roof": array:1 [ …1] +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Celano" +"StreetNumber": "28" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7951.0" +"TaxLegalDescription": "LOT 113, PLAN 62M1231" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.00% +HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded2": "https://view.spiro.media/28_celano_dr-2779?branding=false" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 89.73 +"LotWidth": 39.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13002990')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830335063313" +"SurveyType": "None" +"RentalItems": "Hot Water Tank & Furnace" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 1V3, CA" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-17" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 13 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "Vacant" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Through Brokerbay (supra)" +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-15T18:21:47Z" +"SystemModificationTimestamp": "2026-04-16T13:24:07.109498Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4317 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12920236" +"ListingId": "X12920236" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:19:43Z" +"RFModificationTimestamp": "2026-05-03T05:22:45Z" +"ListPrice": 369900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 1J7" +"UnparsedAddress": "1968 Main Street W 103, Hamilton, ON L8S 1J7" +"Coordinates": array:2 [ …2] +"Latitude": 43.249953 +"Longitude": -79.943989 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "MARTIN GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience the perfect harmony of urban convenience and serene natural beauty in this meticulously renovated West Hamilton gem. As soon as you open the door, you will be mesmerized by breathtaking, unobstructed ravine views of the protected conservation area, allowing you to appreciate the local wildlife and changing seasons right from your living room or private balcony. This move-in-ready home underwent extensive upgrades in 2020, featuring modern kitchen countertops, a stylish backsplash, and premium stainless steel appliances. The entire space is tied together with contemporary laminate flooring, updated trim, and a fresh, neutral palette. Both bathrooms have been completely transformed with easy-care ceramic tiling, offering a spa-like retreat. With oversized windows in every room, the home is flooded with natural light and offers peaceful ravine views from each bedroom. Practicality meets luxury with ample in-unit storage and a custom utility closet. Residents enjoy elite building amenities, including a heated indoor salt water pool, a fully equipped gym with sauna, guest suite, party room and craft room. Located just minutes from the charming hubs of Westdale, Ancaster, and Dundas, and within walking distance to Mc Master University, this property offers a turnkey lifestyle for first-time buyers, young professionals, or those looking to downsize without compromise. *Dining room photos virtually staged." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:6 [ …6] +"AssociationFee": "929.27" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"BuildingName": "Forest Glen Condominiums" +"CityRegion": "Ainslie Wood" +"CoListOfficeName": "MARTIN GROUP" +"CoListOfficePhone": "905-338-2083" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T06:27:22.011775+00:00" +"CrossStreet": "MAIN ST W /OSLER DR" +"Directions": "MAIN ST W /OSLER DR" +"Exclusions": "Non" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": array:4 [ …4] +"GarageYN": true +"Inclusions": "Fridge, stove, hood fan, dishwasher, all electrical light fixtures, all window coverings, window AC unit, wall mounted tv brackets, media unit and shelves in living room, desk in 3rd bedroom, fridge in storage room, storage room shelving." +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-25" +"LotSizeSource": "MPAC" +"MainOfficeKey": "151200" +"MajorChangeTimestamp": "2026-03-25T17:35:27Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-25T17:35:27Z" +"OriginalListPrice": 369900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3678884" +"ParcelNumber": "180090348" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T13:19:41Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Main" +"StreetNumber": "1968" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3215.0" +"TaxYear": "2025" +"Topography": array:3 [ …3] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "103" +"View": array:3 [ …3] +"Zoning": "A, B-1, E/S-52" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North West" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920236')" +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "39" +"RollNumber": "251801001602410" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "None" +"HoldoverDays": 30 +"LegalStories": "B" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 1J7, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 9 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"MortgageComment": "SELLER TO DISCHARGE" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "MPAC" +"CoListOfficeName3": "MARTIN GROUP" +"ParkingLevelUnit1": "12PB-Lvl B" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay or 905-338-2083" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "12" +"MediaChangeTimestamp": "2026-04-16T13:19:41Z" +"PropertyManagementCompany": "King Condo Management" +"SystemModificationTimestamp": "2026-04-16T13:19:58.231923Z" +"Media": array:27 [ …27] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4316 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12742372" +"ListingId": "X12742372" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:11:03Z" +"RFModificationTimestamp": "2026-05-02T20:20:16Z" +"ListPrice": 1999900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8J 1K4" +"UnparsedAddress": "10 Azalea Court, Hamilton, ON L8J 1K4" +"Coordinates": array:2 [ …2] +"Latitude": 43.2039226 +"Longitude": -79.7942225 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Perched atop the breathtaking Niagara Escarpment, this exceptional home offers seasonal panoramic views of Lake Ontario and the Toronto skyline. Rarely available, it features over 5,100 sq. ft. of beautifully finished living space across three levels, showcasing thoughtful design and custom craftsmanship throughout. Enjoy private access to the Bruce Trail, with waterfalls and scenic hikes just steps from your backyard - a nature lover's dream without sacrificing city convenience. The main floor blends elegance and warmth with new hardwood floors, a custom staircase, and stylish lighting. A formal living room with a wood-burning fireplace flows into a dining room made for entertaining. The chef-inspired kitchen with custom cabinetry opens to a welcoming family room with a new gas fireplace. Upstairs offers four spacious bedrooms, including a luxurious primary suite with a walk-in closet, spa-like ensuite, and private balcony - perfect for peaceful morning views. The bright, fully finished lower level features large windows, custom woodwork, a gas fireplace, bedroom, kitchenette, and separate entrance, ideal for in-law, nanny, or multi-generational living. Explore the potential to sever a second lot or add an auxiliary unit. Outside, your private retreat awaits with a 30 x 60 in-ground pool (16 ft. deep), wrought iron fencing, pool house, and custom shed - perfect for summer entertaining. Recent updates include power blinds, 2023 HVAC systems, refreshed porch, and pool and landscape upgrades. A rare escarpment gem where nature, privacy, and luxury meet." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Stoney Creek Mountain" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-24T22:57:23.122763+00:00" +"CrossStreet": "Audubon St N" +"DirectionFaces": "South" +"Directions": "Mud St W to Paramount Dr - right on Audubon St N - left at Azalea Crt" +"ExpirationDate": "2026-05-31" +"ExteriorFeatures": array:3 [ …3] +"FireplaceFeatures": array:5 [ …5] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Hot Tub, Hot Water Tank Owned, Pool Equipment, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, Chest Freezer, Basement Fridge, Basement Stove" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-29" +"LotSizeSource": "MPAC" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-01-30T19:49:17Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-30T16:35:39Z" +"OriginalListPrice": 1999900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3498002" +"OtherStructures": array:3 [ …3] +"ParcelNumber": "170970987" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "14.0" +"PhotosChangeTimestamp": "2026-04-16T13:06:19Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 1999900.0 +"PriceChangeTimestamp": "2026-01-30T16:37:35Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Azalea" +"StreetNumber": "10" +"StreetSuffix": "Court" +"TaxAnnualAmount": "10904.54" +"TaxAssessedValue": 887000 +"TaxLegalDescription": "PCL BLK M-1, SEC M181 ; PT BLK M, PL M181 , PART 1 , 62R7533 ; STONEY CREEK CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% to co-op Brokerage" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://media.otbxair.com/10-Azalea-Ct-1/idx" +"Zoning": "R2" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 295.68 +"LotShape": "Irregular" +"LotWidth": 46.59 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12742372')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251800365511280" +"SurveyType": "None" +"RentalItems": "none" +"HoldoverDays": 120 +"LaundryLevel": "Lower Level" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 12 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8J 1K4, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 4 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2026-04-16T13:11:03Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-16T13:11:19.249719Z" +"Media": array:48 [ …48] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4315 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13005504" +"ListingId": "X13005504" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:09:17Z" +"RFModificationTimestamp": "2026-05-02T20:21:28Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 3V1" +"UnparsedAddress": "92 Reid Avenue S, Hamilton, ON L8K 3V1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2327652 +"Longitude": -79.7884287 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER COMMUNITY PROFESSIONALS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "For the first time since 1958, this cherished family home is ready to welcome its next chapter. Lovingly maintained and thoughtfully cared, this is more than just a house-it's a place where memories were made, traditions were built, and life unfolded beautifully. Inside, you'll find the functional kitchen opens to the dining space, creating an easy flow for everyday living and hosting. The living room is filled with natural light thanks to the picture window, offering a warm and inviting place to gather. Upstairs, three comfortable bedrooms provide space for family, while the standout retro-cool bathroom-1950s glam-adds a touch of character and nostalgia. With a separate entrance(s) to the finished lower level, you will find a full bathroom, abundant storage, the workings of a second kitchen, and a space where generation of one family came together to celebrating holidays, sharing meals, and making lasting memories. Outside, the home continues to impress. A long 4-car tandem driveway offers ample parking, while the fenced yard provides room to relax, eat, and grow. Green thumbs will appreciate the space to grow vegetables in the back garden, and the charming front veranda is the perfect spot to sit, unwind, and admire the lovingly tended rose and flower gardens. This is a home that has been deeply loved, and it shows in every corner. A rare opportunity to carry forward a legacy of care, warmth, and connection. RSA" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:4 [ …4] +"CityRegion": "Glenview" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-16T13:22:23.139701+00:00" +"CrossStreet": "Main St E/Reid Ave S" +"DirectionFaces": "West" +"Directions": "Main St E, right on to Reid Ave S" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": array:4 [ …4] +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, gas stove, cook top, dishwasher, washer & dryer, light fixtures, window coverings, all in "AS IS" condition" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "090000" +"MajorChangeTimestamp": "2026-04-16T13:09:17Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T13:09:17Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3812340" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "172780124" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-16T13:09:17Z" +"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" +"StreetDirSuffix": "S" +"StreetName": "Reid" +"StreetNumber": "92" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4314.48" +"TaxAssessedValue": 303000 +"TaxLegalDescription": "LT 431, PL 574 ; PT LT 430, PL 574, AS IN AB231868 ; HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/241006336" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 92.33 +"LotWidth": 42.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005504')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251805042206890" +"SurveyType": "None" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Available" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8K 3V1, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"MortgageComment": "Clear" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay & LBO" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-16T13:09:17Z" +"SystemModificationTimestamp": "2026-04-16T13:09:18.489886Z" +"Media": array:50 [ …50] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4312 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12987252" +"ListingId": "X12987252" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:57:42Z" +"RFModificationTimestamp": "2026-05-03T05:22:47Z" +"ListPrice": 1995.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 3A1" +"UnparsedAddress": "77 Leland Street 108, Hamilton, ON L8S 3A1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2554392 +"Longitude": -79.9229193 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE CERTIFIED REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing Ground Floor Unit, with HUGE Patio....Sparkling clean, Cheerful, Bright & sunny, almost new building!! Granite kitchen countertop with ceramic backsplash! Stainless Steel appliances. Walk to Mc Master University, Mc Master Children's Hospital. Walk to everywhere, Groceries, Bank, Coffee shops, restaurants, transit.....Dedicated surface parking spot. This is designed for lifestyle and functionality, and is perfect for students or professionals! Excellent for investors - low condo fees. Situated right next to the Hamilton Burlington Trail and surrounded by amenities, entertainment, greenspace, shopping, restaurants and public transit, this unit checks all the boxes! Really Quiet & Safe Neighborhood! Additional Building Amenities Include On-Site Laundry, Secure In-Door Bike Storage, 24/7 Emergency Maintenance, Security Cameras + Visitor Parking. COMES WITH 1 PARKING SPOT!! NOT TO BE MISSED...BOOK YOUR SHOWING TODAY!" +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Ainslie Wood" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CreationDate": "2026-05-01T16:47:48.147946+00:00" +"CrossStreet": "Leland and Main Street" +"Directions": "Leland and Main Street" +"Exclusions": "Rent does not include hydro and hot water tank charges" +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-10" +"MainOfficeKey": "060200" +"MajorChangeTimestamp": "2026-04-15T17:01:44Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-11T17:55:17Z" +"OriginalListPrice": 2200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3801128" +"ParcelNumber": "185980008" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-11T17:55:18Z" +"PreviousListPrice": 2200.0 +"PriceChangeTimestamp": "2026-04-15T17:01:44Z" +"RentIncludes": array:7 [ …7] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Leland" +"StreetNumber": "77" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month rent" +"TransactionType": "For Lease" +"UnitNumber": "108" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12987252')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251801004204359" +"SurveyType": "None" +"BalconyType": "Terrace" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 3A1, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 598 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 2 +"LeaseAgreementYN": true +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "builder plan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "8" +"MediaChangeTimestamp": "2026-04-11T17:55:18Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Cie Property Management" +"SystemModificationTimestamp": "2026-04-16T12:57:44.559305Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:37 [ …37] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4311 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13003672" +"ListingId": "X13003672" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:46:33Z" +"RFModificationTimestamp": "2026-05-03T05:22:49Z" +"ListPrice": 2150.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 0C2" +"UnparsedAddress": "81 Robinson Street 201, Hamilton, ON L8P 0C2" +"Coordinates": array:2 [ …2] +"Latitude": 43.2513117 +"Longitude": -79.8752359 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Large 1 bed plus den for lease in fantastic Durand neighbourhood. Nice and large balcony and modern finishes. Close to hospital, transit, parks, schools & all amenities." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Durand" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-01T16:48:43.224773+00:00" +"CrossStreet": "Park" +"Directions": "James to Robinson" +"ExpirationDate": "2026-09-15" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Dishwsher, Dryer, Garage Door Opener, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-04-15T20:00:09Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-15T20:00:09Z" +"OriginalListPrice": 2150.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3819704" +"ParcelNumber": "185300308" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T20:00:10Z" +"RentIncludes": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Robinson" +"StreetNumber": "81" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "201" +"UFFI": "No" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13003672')" +"GarageType": "Underground" +"HeatSource": "Electric" +"RollNumber": "251802013171258" +"SurveyType": "Unknown" +"BalconyType": "Terrace" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"LockerNumber": "201" +"ParkingSpot1": "191" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:2 [ …2] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 0C2, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 530 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "Owner" +"ParkingLevelUnit1": "P3" +"PossessionDetails": "30-59 Days" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "LBO/Brokerbay. 24 Hours notice required" +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "01" +"MediaChangeTimestamp": "2026-04-15T20:00:10Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-16T12:46:37.011584Z" +"Media": array:19 [ …19] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4310 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13005224" +"ListingId": "X13005224" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:13:51Z" +"RFModificationTimestamp": "2026-05-02T20:21:27Z" +"ListPrice": 1749000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 3X3" +"UnparsedAddress": "600 Highvalley Road, Hamilton, ON L9G 3X3" +"Coordinates": array:2 [ …2] +"Latitude": 43.2314526 +"Longitude": -79.9628031 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ACCSELL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Exceptional Family Home in Sought-After Mohawk Meadows. Welcome to this spacious and inviting 4+1 bedroom, 3.5 bathroom home nestled in the heart of the family-friendly Mohawk Meadows community. Designed with comfort and versatility in mind, this property offers ample space for growing families and entertaining guests. The open-concept kitchen features a generous island and overlooks a sunken great room, perfect for hosting or relaxing in style. Step outside to a beautifully landscaped yard complete with a large deck and hot tub, creating the ideal setting for enjoying evenings and weekend gatherings. The fully finished basement adds even more living space, including a large recreation room, an additional bedroom, a 3-piece bath, and a private sauna for ultimate relaxation. Don't miss your chance to own a home in one of the area's most desirable and established neighborhoods." +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-24T23:10:10.661506+00:00" +"CrossStreet": "Mohawk Rd & Lime Kiln Road" +"DirectionFaces": "South" +"Directions": "From Mohawk Rd turn North on Green Ravine Dr then Left onto Highvalley Rd" +"ExpirationDate": "2026-07-30" +"ExteriorFeatures": array:4 [ …4] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "60.04 x 158.48 Feet" +"MainLevelBathrooms": 1 +"MainOfficeKey": "215200" +"MajorChangeTimestamp": "2026-04-16T12:10:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-16T12:10:22Z" +"OriginalListPrice": 1749000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3816118" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "175640486" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-04-16T12:10:22Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "19" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Highvalley" +"StreetNumber": "600" +"StreetSuffix": "Road" +"TaxAnnualAmount": "8646.49" +"TaxBookNumber": "251814027044651" +"TaxLegalDescription": "Pcl 1-1, Sec M304 ; Lt 1, Pl M304 ; Ancaster City" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/600_highvalley_road_hamilton_on/" +"Zoning": "R3" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 158.48 +"LotWidth": 60.04 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005224')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814027044651" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 3X3, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 14 +"RoomsBelowGrade": 5 +"PropertyFeatures": array:6 [ …6] +"StreetSuffixCode": "Rd" +"BoardPropertyType": "Free" +"PossessionDetails": "must provide notice to tenant for vacant possession" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-16T12:10:22Z" +"MLSAreaDistrictOldZone": "X14" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2026-04-16T12:14:03.3576Z" +"Media": array:33 [ …33] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4309 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13005194" +"ListingId": "X13005194" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T12:02:00Z" +"RFModificationTimestamp": "2026-05-02T20:21:27Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.1 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 6M8" +"UnparsedAddress": "197 Sherman Avenue N, Hamilton, ON L8L 6M8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing opportunity ! Fully detached all brick building operating as a sports club / bar with a two bedroom rental apartment on the upper level. Premium 20' X 158' pie - shaped lot ( 40' rear ) located in the up and coming " Gibson Community ". This is a fully operational " Sports Club" with a 64 person capacity and is being sold with the " Liquor Sales License " ( see attached ). The new owner is responsible to transfer the license to his / her name. The building is solid but needs cosmetic updating on all three levels, large rear yard with multiple storage buildings and a detached all brick garage fronting onto the rear laneway. All fixtures and chattels are included " as-is ", no financials are available for the Sports Club and there is no guarantee that the Alcohol and Gaming Commission will accept the new applicant. This is a perfect opportunity for the new owner to live / work in the same location and create equity by improving the existing building / property. Second floor apartment has a side entrance as well as a rear stairwell. Hot water gas heat, gas hot water tank ( rental ). Sale price includes the building and operating business." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Gibson" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-01T16:56:01.646867+00:00" +"CrossStreet": "Sherman / Barton" +"DirectionFaces": "West" +"Directions": "Sherman / Barton" +"ExpirationDate": "2027-03-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All electrical light fixtures, all window coverings, fridge, stove, shed, bar fridge." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "498000" …68 } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4308 …115} ] +success: true +page_size: 10 +page_count: 142 +count: 1417 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4279 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4072 …124} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073 …138} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …126} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …117} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …125} ] +success: true +page_size: 5 +page_count: 8702 +count: 43510 +after_key: "" } ] ]