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=780&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=780&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=780&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=780&$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: "699431" +post_author: 1 +"ListingKey": "X13023122" +"ListingId": "X13023122" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T02:58:50Z" +"RFModificationTimestamp": "2026-05-01T15:49:30Z" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.06 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H 4L1" +"UnparsedAddress": "133 Frederick Avenue, Hamilton, ON L8H 4L1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2497706 +"Longitude": -79.8111355 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This stunning 2-storey residence blends modern style with everyday comfort, offering 3 spacious bedrooms and 1.5 beautifully updated bathrooms. Every inch of this home has been upgraded from top to bottom - featuring a sleek new kitchen with quartz countertops, luxury flooring throughout, and a freshly updated powder room. Enjoy peace of mind with major upgrades already done for you: a new roof and shingles (2022), owned tankless water heater (2022), and new washer/dryer (2023). The dry basement adds valuable storage or potential for future living space. Step outside and unwind on your two covered porches, or entertain in the fenced backyard surrounded by a refreshed perennial garden. Private parking adds convenience in this prime location - just steps from shopping, dining, and transit, and minutes from major highways. Move right in and start living - this turnkey home checks every box!" +"ArchitecturalStyle": "1 1/2 Storey" +"Basement": array:1 [ …1] +"CityRegion": "Crown Point" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-01T10:52:04.634724+00:00" +"CrossStreet": "Barton St E" +"DirectionFaces": "West" +"Directions": "Frederick and barton" +"ExpirationDate": "2026-06-20" +"FoundationDetails": array:1 [ …1] +"Inclusions": "FRIDGE, STOVE, DISHWASHER, WASHER, DRYER" +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-21T02:58:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T02:58:50Z" +"OriginalListPrice": 499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3842770" +"ParcelNumber": "172470216" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-04-21T02:58:50Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Frederick" +"StreetNumber": "133" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2568.0" +"TaxLegalDescription": "LT 25, BLK B, PL 395 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+ hst" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 90.0 +"LotWidth": 25.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13023122')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251804031403320" +"SurveyType": "None" +"RentalItems": "HOT WATER TANK" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8H 4L1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 8 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-04-21T02:58:50Z" +"SystemModificationTimestamp": "2026-04-21T02:58:50.893315Z" +"Media": array:35 [ …35] +"ID": "699431" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "690261" +post_author: 1 +"ListingKey": "X13023100" +"ListingId": "X13023100" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T02:42:55Z" +"RFModificationTimestamp": "2026-04-27T06:14:39Z" +"ListPrice": 490000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0L2" +"UnparsedAddress": "600 North Service Road 602, Hamilton, ON L8E 0L2" +"Coordinates": array:2 [ …2] +"Latitude": 43.234121 +"Longitude": -79.696439 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER REAL ESTATE PROFESSIONALS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience luxury living in this top-floor penthouse suite with 10-foot ceilings offering breathtaking views. This spacious 1+1 bedroom, 1 bathroom condo features large windows, flooding the space with natural light. 1 Underground parking and Same Level Locker! Enjoy over $16,800 in premium upgrades, including Hunter Douglas automatic blinds, designer lighting, a modern glass shower, and a fully upgraded kitchen with a quartz countertop and backsplash. Step onto your private balcony with composite decking, perfect for relaxing or entertaining guests. Located in a boutique lakeside building, residents enjoy access to a pet spa, media room, event room, and a rooftop terrace with BBQs, dining areas, and lounge seating - your perfect urban oasis. Conveniently situated near shops, dining, and with quick access to the QEW, this home blends modern comfort, luxury finishes, and effortless convenience. **Option to buy fully furnished**" +"ArchitecturalStyle": "Apartment" +"AssociationFee": "342.0" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"CityRegion": "Stoney Creek" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-21T02:47:29.462836+00:00" +"CrossStreet": "Fruitland/North Service" +"Directions": "Fruitland/North Service" +"ExpirationDate": "2026-06-19" +"GarageYN": true +"Inclusions": "All Appliances" +"InteriorFeatures": "Separate Heating Controls,Storage,Intercom,Built-In Oven" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "418500" +"MajorChangeTimestamp": "2026-04-21T02:42:55Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T02:42:55Z" +"OriginalListPrice": 490000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3846600" +"ParkingFeatures": "Underground" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T02:42:55Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "North Service" +"StreetNumber": "600" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3513.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"UnitNumber": "602" +"VirtualTourURLUnbranded": "https://real.vision/600-north-service-road-602?o=u" +"WaterBodyName": "Lake Ontario" +"DDFYN": true +"Locker": "Owned" +"Exposure": "North" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13023100')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Electric" +"LockerUnit": "26" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"LockerLevel": "6" +"RentalItems": "Heat Pump Rental" +"HoldoverDays": 90 +"LegalStories": "6" +"LockerNumber": "626" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 0L2, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 642 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 4 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:2 [ …2] +"SquareFootSource": "All Sq ft to be verified by buyers" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Easy showing almost anytime with 2 hour notice." +"StatusCertificateYN": true +"LegalApartmentNumber": "2" +"MediaChangeTimestamp": "2026-04-21T02:42:55Z" +"PropertyManagementCompany": "Shabri Property Ltd" +"SystemModificationTimestamp": "2026-04-21T02:42:55.51163Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:14 [ …14] +"ID": "690261" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "709561" +post_author: 1 +"ListingKey": "X12870394" +"ListingId": "X12870394" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T01:27:17Z" +"RFModificationTimestamp": "2026-04-29T12:32:22Z" +"ListPrice": 579900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 3W6" +"UnparsedAddress": "160 Picton Street E, Hamilton, ON L8L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 43.2681401 +"Longitude": -79.85651 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CAPITAL HILL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this Absolutely Stunning Fully Renovated From Top To Bottom***$$$$ Spent***Look No Further** Modern Kitchen with Extended Cabinets** Lots of Pot Lights & Upgraded Light Fixture**Stainless Steel Appliances*New 2 Full Washrooms**New Flooring**New Paint** New Doors**New Deck with private fenced back yard oasis **Perfect backdrop for kids to play, Summer Barbecues For Relaxation Or Entertaining*Oversized 159 Ft Deep Lot*Located In The Booming North End Of Hamilton. Thriving Family-Friendly Community Minutes Away From The West Harbor Go Station And Within Walking Distance To Bayfront Park** Separate entrance to finished basement with 2 rooms & Full washroom**Potential Rental Income**Property Offers Convenience & Easy Access To Transportation And Recreational Amenities**New High Eff Furnace & CAC **Move-in Ready home in a convenient neighbourhood**" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "North End" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:21:03.078981+00:00" +"CrossStreet": "North On John, East On Picton" +"DirectionFaces": "South" +"Directions": "North On John, East On Picton" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Stainless Steel Appliances, Fridge,Stove, Clothes washer & dryer, All Light Fixtures" +"InteriorFeatures": "Water Meter" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-11" +"LotSizeSource": "MPAC" +"MainOfficeKey": "341300" +"MajorChangeTimestamp": "2026-04-21T01:27:17Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-11T14:25:29Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3651252" +"ParcelNumber": "171570184" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-11T14:25:30Z" +"PoolFeatures": "None" +"PreviousListPrice": 599900.0 +"PriceChangeTimestamp": "2026-04-21T01:27:17Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Picton" +"StreetNumber": "160" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4206.95" +"TaxLegalDescription": "PT LT 17-18 PL 61 S/S PICTON ST BTN MARY ST & FERGUSON AV" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.winsold.com/tour/422381/branded/56173" +"VirtualTourURLUnbranded": "https://www.winsold.com/tour/422381" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 159.0 +"LotWidth": 35.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12870394')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251802016208430" +"SurveyType": "None" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 3W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 2 +"PossessionDetails": "30-60 days" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Upper" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2026-03-11T14:25:30Z" +"SystemModificationTimestamp": "2026-04-21T01:27:25.612634Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] +"ID": "709561" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "711519" +post_author: 1 +"ListingKey": "X13022930" +"ListingId": "X13022930" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:42:42Z" +"RFModificationTimestamp": "2026-04-28T18:21:35Z" +"ListPrice": 2700.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 1W7" +"UnparsedAddress": "66 Cline Avenue S Basement, Hamilton, ON L8S 1W7" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "LOCATION! LOCATION! LOCATION! FOR LEASE! shared home offering 3 bedrooms in basement for rent ideal for students! Conveniently located near Mc Master University, this well-maintained property features a shared living room, and 1 full bathroom. Kitchen is shared with main floor tenants. Enjoy the convenience of on-site laundry and access to outdoor space. The home is within walking distance to Mc Master University and Mc Master University Medical Centre, with easy access to public transit, highways, and everyday amenities. Tenant responsible for: Hydro, Gas, Heat, Water & Internet. Perfect for students seeking a comfortable and conveniently located home in a high-demand area. Current tenant's lease ends on April 30th 2026" +"ArchitecturalStyle": "1 Storey/Apt" +"Basement": array:1 [ …1] +"CityRegion": "Westdale" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:24:45.989698+00:00" +"CrossStreet": "Main and Arkell" +"DirectionFaces": "West" +"Directions": "Main and Arkell" +"ExpirationDate": "2026-08-31" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"InteriorFeatures": "Water Heater" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-21T00:42:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-21T00:42:22Z" +"OriginalListPrice": 2700.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3844862" +"PhotosChangeTimestamp": "2026-04-21T00:42:22Z" +"PoolFeatures": "None" +"RentIncludes": array:2 [ …2] +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Cline" +"StreetNumber": "66" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "Half Month" +"TransactionType": "For Lease" +"UnitNumber": "Basement" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022930')" +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 1W7, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "1-29 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "< 700" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"MediaChangeTimestamp": "2026-04-21T00:42:22Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-04-21T00:42:45.384099Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:1 [ …1] +"ID": "711519" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "588036" +post_author: 1 +"ListingKey": "X12766668" +"ListingId": "X12766668" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:32:55Z" +"RFModificationTimestamp": "2026-04-28T21:08:08Z" +"ListPrice": 2595000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 1V3" +"UnparsedAddress": "102 Cumming Court, Hamilton, ON L9G 1V3" +"Coordinates": array:2 [ …2] +"Latitude": 43.211598 +"Longitude": -79.9902954 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Crafted with exceptional attention to detail and completed in 2025 (Tarion warranty), this custom two-storey luxury home offers nearly 6,000 sqft. of finished living, 5+1 bedrooms, 6 total baths, and a contemporary transitional design blending sophistication with family-friendly functionality. Situated on a 75 x 105 ft lot in Ancaster's Nakoma neighbourhood, it features striking curb appeal with a stone-and-stucco exterior and a 2.5-car triple tandem garage. Inside, soaring 9 ft ceilings on all three levels, wide-plank white oak hardwood, 8 ft solid core doors, 9 baseboards, and oversized windows create a sense of grandeur. The 19-ft great room showcases floor-to-ceiling windows and a 42 gas fireplace flanked by custom cabinetry. A main-floor office with built-ins, formal dining room, and powder room provide elegant, purposeful spaces, while the dining table converts into a pool table for dual-purpose entertaining. The gourmet kitchen features black cabinetry, a 9' x 5' waterfall quartz island, full-slab quartz backsplash, champagne and honey bronze fixtures, Bertazzoni appliances, and a walk-in pantry and servery with black stainless-steel sink. Adjacent are the mudroom/laundry with garage entry and a main-level bedroom with ensuite. Upstairs, four bedrooms each have ensuite access, including a primary retreat with 10 ft tray ceiling, oversized walk-in closet, linear fireplace, and spa-inspired 5-piece ensuite with heated floors. The finished lower level offers 9 ft ceilings, oversized windows, sixth bedroom, full bathroom, linear fireplace, and endless possibilities. Additional features include radon mitigation, 200-amp service, hardwired security system, and Dry Core subfloor. Outside, the back patio provides a starting point for a dream outdoor space, with a pre-approved building permit for an in-ground pool and gas lines for BBQ. Centrally located, this home offers walkability to schools, parks, shops, and quick access to Hwy 403. (See full list of features.)" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.5" +"CreationDate": "2026-04-24T04:58:29.320221+00:00" +"CrossStreet": "Fiddlers Green" +"DirectionFaces": "West" +"Directions": "Fiddlers Green to Cumming Court" +"ExpirationDate": "2026-05-18" +"ExteriorFeatures": "Patio" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Frigidaire Professional: Fridge, Freezer, Dishwasher, Microwave. Bertazzoni: 48" Gas Range Top, Steam Oven, Wall Oven. Electrolux: Beverage Fridge, Washer, Dryer. All Electric Light Fixtures. All Bathroom Vanity Mirrors. Security System with Cameras & Door Bell Camarea. Navien Water Heater" +"InteriorFeatures": "Auto Garage Door Remote,Air Exchanger,Central Vacuum,Sump Pump,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-06" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-04-21T00:32:55Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-06T18:17:36Z" +"OriginalListPrice": 2595000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3527314" +"ParcelNumber": "174330287" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.5" +"PhotosChangeTimestamp": "2026-02-06T18:17:36Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:3 [ …3] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cumming" +"StreetNumber": "102" +"StreetSuffix": "Court" +"TaxAnnualAmount": "15399.32" +"TaxAssessedValue": 1223000 +"TaxLegalDescription": "LT 23, PL 927 ; ANCASTER CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=Gi Cf Jab Nnr M" +"VirtualTourURLUnbranded": "http://www.102Cumming.ca" +"Zoning": "ER" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 104.61 +"LotShape": "Rectangular" +"LotWidth": 75.33 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12766668')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814034025600" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 1V3, CA" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Sold Conditional Escape" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 2 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 18 +"RoomsBelowGrade": 5 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ …6] +"SalesBrochureUrl": "http://www.102Cumming.ca" +"LotIrregularities": "75.49 ft x 105.35 ft x 75.16 x 102.82 ft" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2026-02-06T18:17:36Z" +"SystemModificationTimestamp": "2026-04-21T00:33:10.765488Z" +"SoldConditionalEntryTimestamp": "2026-03-24T14:18:48Z" +"Media": array:50 [ …50] +"ID": "588036" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2849 +post_id: "689766" +post_author: 1 +"ListingKey": "X13022888" +"ListingId": "X13022888" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:26:43Z" +"RFModificationTimestamp": "2026-04-28T16:37:23Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8V 1K7" +"UnparsedAddress": "507 Queensdale Avenue E, Hamilton, ON L8V 1K7" +"Coordinates": array:2 [ …2] +"Latitude": 43.2365671 +"Longitude": -79.8552482 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS COMPLETE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 507 Queensdale Avenue East, a well-maintained 2-storey detached home in Hamilton's desirable Eastmount neighbourhood on the North Central Mountain. Sitting on a prominent corner lot, this property offers exceptional flexibility for buyers looking to get into the market, settle into a family-friendly area, or explore future investment potential.Featuring over 1,200 square feet of finished living space, this home offers 3 bedrooms and 2 bathrooms. The bright, freshly painted interior is complemented by new carpeting as well laminate floors. While the main floor boasts a functional, flowing layout and a solid wood open-concept kitchen that serves as the heart of the home.The unfinished basement provides excellent storage today, with clear potential for future development to suit your needs. Whether you're looking to expand your living space or explore additional income opportunities down the road, the possibilities here are strong.Outside, the corner lot adds extra space and privacy, with rear parking for up to 3 vehicles and a large, detached shed for additional storage or workspace. Ideally located with quick highway access and close to schools, parks, the Juravinski Hospital, and everyday amenities, this is a location that continues to attract attention for both lifestyle and long-term value.A fantastic opportunity to own in one of Hamilton Mountain's most established and convenient communities. Book your private showing today!" +"ArchitecturalStyle": "1 1/2 Storey" +"Basement": array:2 [ …2] +"CityRegion": "Inch Park" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-24T04:59:50.183303+00:00" +"CrossStreet": "Upper Wellington Avenue E" +"DirectionFaces": "North" +"Directions": "Upper Wellington Street to Queensdale Avenue E" +"ExpirationDate": "2026-08-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Inclusions": "All appliances, light fixtures, window coverings, basement dehumidifier, gas lawnmower in shed, dining room oak table, chairs, buffet, hutch,coat hanger in the mud room, oak coffee tables." +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "270600" +"MajorChangeTimestamp": "2026-04-21T00:26:43Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T00:26:43Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3826270" +"ParcelNumber": "170540304" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-21T00:26:43Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Queensdale" +"StreetNumber": "507" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3548.21" +"TaxLegalDescription": "LT 13, PL 590 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.507queensdaleavee.com/" +"VirtualTourURLUnbranded2": "https://www.507queensdaleavee.com/" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 102.91 +"LotWidth": 31.13 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022888')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251807067308710" +"SurveyType": "Unknown" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8V 1K7, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 1 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please book through Broker Bay." +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-21T00:26:43Z" +"SystemModificationTimestamp": "2026-04-21T00:26:44.201593Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] +"ID": "689766" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "690197" +post_author: 1 +"ListingKey": "X13022742" +"ListingId": "X13022742" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T23:22:40Z" +"RFModificationTimestamp": "2026-05-03T11:37:09Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5694.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 2R1" +"UnparsedAddress": "290 Dewitt Road Part 2, Hamilton, ON L8E 2R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.223574 +"Longitude": -79.709354 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Builders, Investors And Homeowner A Rare Opportunity To Own An Excellent Building Lot To Build Your Own Custom Home In Stoney Creek Community. This Premium 35.6 x 160 Ft Lot Is Already Approved For Two Story Home With Double Car Garage. An Approved Lot Servicing Plan Is Available And A Building Permit Of Your Design & Vision Is Required. The Zoning Of The Property Is "Low Density Residential" (R1) Zone In Zoning By-law No. 05-200. Located On A Street With Other Neighboring Custom-Built Homes In The Area On Similar Type Of Lot. This Lot Is Near Parks, Great Schools, Mohawk College Stoney Creek Campus, Saltfleet Arena, Various Shops & Services, Close Access To Public Transportation, Local Farms, Wineries, Major Highways, Major Shopping Centers, Hospital, Quick Access To Niagara Region. Survey Completed And Available for Buyer. Create Your Design, Apply For Permits, Pay Applicable Permit Fees & Start Building Your Vision Today!! Great Investment, Location & Opportunity!There Is A Consent Agreement In place With The City Of Hamilton To Complete Servicing Of The Newly Severed Lots With Water, Sanitary, Storm Service Line And Catch Basin With A Refundable Cash Deposit Held By The City To Be Released Once The Servicing Is Complete. Also Available Are The Servicing Plan, Topography Survey, Grading Plan And Site Plan For The Two Story Home With Double Car Garage. Full Details Will Be Shared With The Interested Buyers." +"CityRegion": "Stoney Creek" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:30:35.305159+00:00" +"CrossStreet": "Barton and Dewitt" +"DirectionFaces": "North" +"Directions": "Barton and Dewitt" +"ExpirationDate": "2026-10-19" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"LotSizeSource": "Survey" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-20T23:22:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-20T23:22:40Z" +"OriginalListPrice": 499999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3844780" +"ParcelNumber": "173490554" +"PhotosChangeTimestamp": "2026-04-20T23:22:40Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dewitt" +"StreetNumber": "290" +"StreetSuffix": "Road" +"TaxLegalDescription": "PART LOT 9 PLAN 864, PART 2, 62R22420; STONEY CREEK SUBJECT TO AN EASEMENT IN GROSS AS IN WE1829484 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%- $50 Marketing fees + hst" +"TransactionType": "For Sale" +"UnitNumber": "Part 2" +"Zoning": "R1" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 160.33 +"LotShape": "Rectangular" +"LotWidth": 35.52 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022742')" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"Winterized": "No" +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 2R1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MortgageComment": "cleared" +"LotSizeAreaUnits": "Square Feet" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-20T23:22:40Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-20T23:22:40.799927Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:14 [ …14] +"ID": "690197" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "690198" +post_author: 1 +"ListingKey": "X13022738" +"ListingId": "X13022738" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T23:22:03Z" +"RFModificationTimestamp": "2026-05-03T11:37:09Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 2R1" +"UnparsedAddress": "290 Dewitt Road Part 1, Hamilton, ON L8E 2R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2439161 +"Longitude": -79.7620853 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Builders, Investors And Homeowner A Rare Opportunity To Own An Excellent Building Lot To Build Your Own Custom Home In Stoney Creek Community. This Premium 35.6 x 160 Ft Lot Is Already Approved For Two Story Home With Double Car Garage. An Approved Lot Servicing Plan Is Available And A Building Permit Of Your Design & Vision Is Required. The Zoning Of The Property Is "Low Density Residential" (R1) Zone In Zoning By-law No. 05-200. Located On A Street With Other Neighboring Custom-Built Homes In The Area On Similar Type Of Lot. This Lot Is Near Parks, Great Schools, Mohawk College Stoney Creek Campus, Saltfleet Arena, Various Shops & Services, Close Access To Public Transportation, Local Farms, Wineries, Major Highways, Major Shopping Centers, Hospital, Quick Access To Niagara Region. Survey Completed And Available for Buyer. Create Your Design, Apply For Permits, Pay Applicable Permit Fees & Start Building Your Vision Today!! Great Investment, Location & Opportunity!There Is A Consent Agreement In place With The City Of Hamilton To Complete Servicing Of The Newly Severed Lots With Water, Sanitary, Storm Service Line And Catch Basin With A Refundable Cash Deposit Held By The City To Be Released Once The Servicing Is Complete. Also Available Are The Servicing Plan, Topography Survey, Grading Plan And Site Plan For The Two Story Home With Double Car Garage. Full Details Will Be Shared With The Interested Buyers." +"CityRegion": "Stoney Creek" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-24T05:09:04.612186+00:00" +"CrossStreet": "Barton and Dewitt" +"DirectionFaces": "North" +"Directions": "Barton and Dewitt" +"ExpirationDate": "2026-10-19" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-20T23:22:03Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-20T23:22:03Z" +"OriginalListPrice": 499999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3845608" +"ParcelNumber": "173490553" +"PhotosChangeTimestamp": "2026-04-20T23:22:03Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dewitt" +"StreetNumber": "290" +"StreetSuffix": "Road" +"TaxLegalDescription": "PART LOT 9 PLAN 864, PART 1 62R22420; STONEY CREEK CITY OF HAMILTON,SUBJECT TO AN EASEMENT IN GROSS AS IN WE1829484" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%-$50mkt fee + hst" +"TransactionType": "For Sale" +"UnitNumber": "Part 1" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 160.33 +"LotShape": "Rectangular" +"LotWidth": 35.52 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022738')" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 2R1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MortgageComment": "cleared" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-20T23:22:03Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-20T23:22:03.417969Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] +"ID": "690198" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "658519" +post_author: 1 +"ListingKey": "X12941944" +"ListingId": "X12941944" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T22:57:10Z" +"RFModificationTimestamp": "2026-05-02T20:21:03Z" +"ListPrice": 1099900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 0J9" +"UnparsedAddress": "68 Rockhaven Lane, Hamilton, ON L8B 0J9" +"Coordinates": array:2 [ …2] +"Latitude": 43.3323086 +"Longitude": -79.9054418 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this beautifully maintained detached home featuring a classic brick exterior, double-car garage, and inviting covered front porch with aggregate concrete detailing that creates excellent curb appeal. Step inside to a bright and welcoming foyer highlighted by an elegant staircase and beautiful hardwood floors that extend throughout the main level. A thoughtfully designed layout makes this home ideal for both everyday living and entertaining, complemented by custom California shutters throughout. The open-concept living and dining area is filled with natural light and offers the perfect setting for family gatherings and special occasions. The updated kitchen serves as the heart of the home, showcasing quartz countertops, high-end appliances, soft-close cabinetry, and a large centre island with seating and convenient pull-out drawers on both sides, providing exceptional prep space and functionality. The kitchen flows seamlessly into the cozy family room and large windows overlooking the backyard, creating a warm and inviting space to relax or entertain. Upstairs, you'll find spacious bedrooms with beautiful architectural details, including vaulted ceilings and large arched windows that bring in abundant natural light. The primary bedroom features a large walk-in closet and private ensuite, while the additional bedrooms offer flexibility for family living, guests, or a home office. The finished basement adds valuable additional living space, complete with new flooring and a crawl space that provides extra storage. Enjoy the private backyard featuring a deck ideal for outdoor dining and entertaining, along with a low-maintenance yard designed for easy upkeep. Located in a desirable family-friendly Waterdown neighbourhood, this home is close to parks, trails, schools, shopping, and everyday amenities, with convenient access to Highway 403, 407, Aldershot GO Station, Burlington, Hamilton, and the GTA." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-01T10:59:16.030036+00:00" +"CrossStreet": "Segwun Rd & Rockhaven Ln" +"DirectionFaces": "South" +"Directions": "Hamilton St - Rockhaven Lane" +"ExpirationDate": "2026-06-30" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Microwave, Range Hood, Refrigerator, Stove, Window Coverings, Thermostat, garage door opener remote, entertainment centre on main floor, all electrical light fixtures, basement freezer, shed" +"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-31" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2026-03-31T23:50:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-31T23:50:16Z" +"OriginalListPrice": 1099900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3749818" +"ParcelNumber": "175100460" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-20T22:57:10Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rockhaven" +"StreetNumber": "68" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "6167.75" +"TaxLegalDescription": "PCL 40-1, SEC 62M782 ; LT 40, PL 62M782 , S/T LT385450 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% Plus hst" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=e Zpfh7j2Erw" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=pt Jl8S0afn8" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 106.14 +"LotWidth": 55.54 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12941944')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830339040192" +"SurveyType": "None" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 0J9, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-20T22:57:10Z" +"SystemModificationTimestamp": "2026-04-20T22:57:21.789202Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:44 [ …44] +"ID": "658519" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "713727" +post_author: 1 +"ListingKey": "X12862954" +"ListingId": "X12862954" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T21:47:05Z" +"RFModificationTimestamp": "2026-05-03T11:36:14Z" +"ListPrice": 1369900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 1P5" +"UnparsedAddress": "132 Canada Street, Hamilton, ON L8P 1P5" +"Coordinates": array:2 [ …2] +"Latitude": 43.2576169 +"Longitude": -79.8854863 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning brand new TO BE BUILT detached home built by the reputable Westpark Inc. in one of Hamilton's most sought-after neighbourhoods, just off vibrant Locke Street. Perfectly positioned in the heart of downtown, you're steps to trendy bars, top-rated restaurants, boutique shopping, transit, and nightlife, with easy access to universities, schools, and major routes. Offering just over 1,800 sq ft of thoughtfully designed living space, this modern home features4 spacious bedrooms- and 2.5 beautifully appointed bathrooms. The open-concept main floor is bright and airy, designed for both everyday living and effortless entertaining, with sleek contemporary finishes throughout. Enjoy the convenience of a private garage and driveway parking, a rare find in this prime urban location. Brand new from top to bottom, this home delivers the perfect blend of modern style, function, and downtown lifestyle. An exceptional opportunity to own a brand new turnkey property in the heart of Hamilton. All plans and renderings have been made, current home on the property will be knocked down and newbuild will be built on the lot. Home is being sold with Tarion Warranty under the builder." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Kirkendall" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T17:49:11.735267+00:00" +"CrossStreet": "Locke St & Canada St" +"DirectionFaces": "North" +"Directions": "Locke St & Canada St" +"ExpirationDate": "2026-09-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-09" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-20T21:47:05Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-09T18:45:15Z" +"OriginalListPrice": 1499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3647430" +"ParcelNumber": "171390094" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-10T19:33:22Z" +"PoolFeatures": "None" +"PreviousListPrice": 1499900.0 +"PriceChangeTimestamp": "2026-04-20T21:47:05Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Canada" +"StreetNumber": "132" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5424.67" +"TaxLegalDescription": "PT LT 57, PL 244 , AS IN VM153878 ; S/T VM153878 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% Net of HST" +"TransactionType": "For Sale" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 93.0 +"LotWidth": 28.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862954')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "251801009456360" +"SurveyType": "Available" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 1P5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 3 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "October Closing" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "No on site showings....Purchasing off builder plans" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-03-10T19:33:22Z" +"SystemModificationTimestamp": "2026-04-20T21:47:13.461799Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:4 [ …4] +"ID": "713727" } ] +success: true +page_size: 10 +page_count: 159 +count: 1587 +after_key: "" } "RF Response Time" => "0.4 seconds" ] "RF Cache Key: 2291f39eb2730c1ba1a96742ab14a18ea9cf5f052bd277e397ecce869c4cd103" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3088 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4278 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13023122" +"ListingId": "X13023122" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T02:58:50Z" +"RFModificationTimestamp": "2026-05-01T15:49:30Z" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.06 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H 4L1" +"UnparsedAddress": "133 Frederick Avenue, Hamilton, ON L8H 4L1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2497706 +"Longitude": -79.8111355 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This stunning 2-storey residence blends modern style with everyday comfort, offering 3 spacious bedrooms and 1.5 beautifully updated bathrooms. Every inch of this home has been upgraded from top to bottom - featuring a sleek new kitchen with quartz countertops, luxury flooring throughout, and a freshly updated powder room. Enjoy peace of mind with major upgrades already done for you: a new roof and shingles (2022), owned tankless water heater (2022), and new washer/dryer (2023). The dry basement adds valuable storage or potential for future living space. Step outside and unwind on your two covered porches, or entertain in the fenced backyard surrounded by a refreshed perennial garden. Private parking adds convenience in this prime location - just steps from shopping, dining, and transit, and minutes from major highways. Move right in and start living - this turnkey home checks every box!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Crown Point" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-01T10:52:04.634724+00:00" +"CrossStreet": "Barton St E" +"DirectionFaces": "West" +"Directions": "Frederick and barton" +"ExpirationDate": "2026-06-20" +"FoundationDetails": array:1 [ …1] +"Inclusions": "FRIDGE, STOVE, DISHWASHER, WASHER, DRYER" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-21T02:58:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T02:58:50Z" +"OriginalListPrice": 499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3842770" +"ParcelNumber": "172470216" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-04-21T02:58:50Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Frederick" +"StreetNumber": "133" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2568.0" +"TaxLegalDescription": "LT 25, BLK B, PL 395 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+ hst" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 90.0 +"LotWidth": 25.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13023122')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251804031403320" +"SurveyType": "None" +"RentalItems": "HOT WATER TANK" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8H 4L1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 8 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-04-21T02:58:50Z" +"SystemModificationTimestamp": "2026-04-21T02:58:50.893315Z" +"Media": array:35 [ …35] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4279 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13023100" +"ListingId": "X13023100" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T02:42:55Z" +"RFModificationTimestamp": "2026-04-27T06:14:39Z" +"ListPrice": 490000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0L2" +"UnparsedAddress": "600 North Service Road 602, Hamilton, ON L8E 0L2" +"Coordinates": array:2 [ …2] +"Latitude": 43.234121 +"Longitude": -79.696439 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER REAL ESTATE PROFESSIONALS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience luxury living in this top-floor penthouse suite with 10-foot ceilings offering breathtaking views. This spacious 1+1 bedroom, 1 bathroom condo features large windows, flooding the space with natural light. 1 Underground parking and Same Level Locker! Enjoy over $16,800 in premium upgrades, including Hunter Douglas automatic blinds, designer lighting, a modern glass shower, and a fully upgraded kitchen with a quartz countertop and backsplash. Step onto your private balcony with composite decking, perfect for relaxing or entertaining guests. Located in a boutique lakeside building, residents enjoy access to a pet spa, media room, event room, and a rooftop terrace with BBQs, dining areas, and lounge seating - your perfect urban oasis. Conveniently situated near shops, dining, and with quick access to the QEW, this home blends modern comfort, luxury finishes, and effortless convenience. **Option to buy fully furnished**" +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "342.0" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"CityRegion": "Stoney Creek" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-21T02:47:29.462836+00:00" +"CrossStreet": "Fruitland/North Service" +"Directions": "Fruitland/North Service" +"ExpirationDate": "2026-06-19" +"GarageYN": true +"Inclusions": "All Appliances" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "418500" +"MajorChangeTimestamp": "2026-04-21T02:42:55Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T02:42:55Z" +"OriginalListPrice": 490000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3846600" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T02:42:55Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "North Service" +"StreetNumber": "600" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3513.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"UnitNumber": "602" +"VirtualTourURLUnbranded": "https://real.vision/600-north-service-road-602?o=u" +"WaterBodyName": "Lake Ontario" +"DDFYN": true +"Locker": "Owned" +"Exposure": "North" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13023100')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Electric" +"LockerUnit": "26" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"LockerLevel": "6" +"RentalItems": "Heat Pump Rental" +"HoldoverDays": 90 +"LegalStories": "6" +"LockerNumber": "626" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 0L2, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 642 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 4 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:2 [ …2] +"SquareFootSource": "All Sq ft to be verified by buyers" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Easy showing almost anytime with 2 hour notice." +"StatusCertificateYN": true +"LegalApartmentNumber": "2" +"MediaChangeTimestamp": "2026-04-21T02:42:55Z" +"PropertyManagementCompany": "Shabri Property Ltd" +"SystemModificationTimestamp": "2026-04-21T02:42:55.51163Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:14 [ …14] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4282 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12870394" +"ListingId": "X12870394" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T01:27:17Z" +"RFModificationTimestamp": "2026-04-29T12:32:22Z" +"ListPrice": 579900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 3W6" +"UnparsedAddress": "160 Picton Street E, Hamilton, ON L8L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 43.2681401 +"Longitude": -79.85651 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CAPITAL HILL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this Absolutely Stunning Fully Renovated From Top To Bottom***$$$$ Spent***Look No Further** Modern Kitchen with Extended Cabinets** Lots of Pot Lights & Upgraded Light Fixture**Stainless Steel Appliances*New 2 Full Washrooms**New Flooring**New Paint** New Doors**New Deck with private fenced back yard oasis **Perfect backdrop for kids to play, Summer Barbecues For Relaxation Or Entertaining*Oversized 159 Ft Deep Lot*Located In The Booming North End Of Hamilton. Thriving Family-Friendly Community Minutes Away From The West Harbor Go Station And Within Walking Distance To Bayfront Park** Separate entrance to finished basement with 2 rooms & Full washroom**Potential Rental Income**Property Offers Convenience & Easy Access To Transportation And Recreational Amenities**New High Eff Furnace & CAC **Move-in Ready home in a convenient neighbourhood**" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "North End" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:21:03.078981+00:00" +"CrossStreet": "North On John, East On Picton" +"DirectionFaces": "South" +"Directions": "North On John, East On Picton" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Stainless Steel Appliances, Fridge,Stove, Clothes washer & dryer, All Light Fixtures" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-11" +"LotSizeSource": "MPAC" +"MainOfficeKey": "341300" +"MajorChangeTimestamp": "2026-04-21T01:27:17Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-11T14:25:29Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3651252" +"ParcelNumber": "171570184" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-11T14:25:30Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 599900.0 +"PriceChangeTimestamp": "2026-04-21T01:27:17Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Picton" +"StreetNumber": "160" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4206.95" +"TaxLegalDescription": "PT LT 17-18 PL 61 S/S PICTON ST BTN MARY ST & FERGUSON AV" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.winsold.com/tour/422381/branded/56173" +"VirtualTourURLUnbranded": "https://www.winsold.com/tour/422381" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 159.0 +"LotWidth": 35.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12870394')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251802016208430" +"SurveyType": "None" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 3W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 2 +"PossessionDetails": "30-60 days" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Upper" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2026-03-11T14:25:30Z" +"SystemModificationTimestamp": "2026-04-21T01:27:25.612634Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4281 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13022930" +"ListingId": "X13022930" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:42:42Z" +"RFModificationTimestamp": "2026-04-28T18:21:35Z" +"ListPrice": 2700.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S 1W7" +"UnparsedAddress": "66 Cline Avenue S Basement, Hamilton, ON L8S 1W7" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "LOCATION! LOCATION! LOCATION! FOR LEASE! shared home offering 3 bedrooms in basement for rent ideal for students! Conveniently located near Mc Master University, this well-maintained property features a shared living room, and 1 full bathroom. Kitchen is shared with main floor tenants. Enjoy the convenience of on-site laundry and access to outdoor space. The home is within walking distance to Mc Master University and Mc Master University Medical Centre, with easy access to public transit, highways, and everyday amenities. Tenant responsible for: Hydro, Gas, Heat, Water & Internet. Perfect for students seeking a comfortable and conveniently located home in a high-demand area. Current tenant's lease ends on April 30th 2026" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Westdale" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:24:45.989698+00:00" +"CrossStreet": "Main and Arkell" +"DirectionFaces": "West" +"Directions": "Main and Arkell" +"ExpirationDate": "2026-08-31" +"FoundationDetails": array:1 [ …1] +"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-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-21T00:42:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-21T00:42:22Z" +"OriginalListPrice": 2700.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3844862" +"PhotosChangeTimestamp": "2026-04-21T00:42:22Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:2 [ …2] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Cline" +"StreetNumber": "66" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "Half Month" +"TransactionType": "For Lease" +"UnitNumber": "Basement" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022930')" +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8S 1W7, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "1-29 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "< 700" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"MediaChangeTimestamp": "2026-04-21T00:42:22Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-04-21T00:42:45.384099Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:1 [ …1] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4280 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12766668" +"ListingId": "X12766668" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:32:55Z" +"RFModificationTimestamp": "2026-04-28T21:08:08Z" +"ListPrice": 2595000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 1V3" +"UnparsedAddress": "102 Cumming Court, Hamilton, ON L9G 1V3" +"Coordinates": array:2 [ …2] +"Latitude": 43.211598 +"Longitude": -79.9902954 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Crafted with exceptional attention to detail and completed in 2025 (Tarion warranty), this custom two-storey luxury home offers nearly 6,000 sqft. of finished living, 5+1 bedrooms, 6 total baths, and a contemporary transitional design blending sophistication with family-friendly functionality. Situated on a 75 x 105 ft lot in Ancaster's Nakoma neighbourhood, it features striking curb appeal with a stone-and-stucco exterior and a 2.5-car triple tandem garage. Inside, soaring 9 ft ceilings on all three levels, wide-plank white oak hardwood, 8 ft solid core doors, 9 baseboards, and oversized windows create a sense of grandeur. The 19-ft great room showcases floor-to-ceiling windows and a 42 gas fireplace flanked by custom cabinetry. A main-floor office with built-ins, formal dining room, and powder room provide elegant, purposeful spaces, while the dining table converts into a pool table for dual-purpose entertaining. The gourmet kitchen features black cabinetry, a 9' x 5' waterfall quartz island, full-slab quartz backsplash, champagne and honey bronze fixtures, Bertazzoni appliances, and a walk-in pantry and servery with black stainless-steel sink. Adjacent are the mudroom/laundry with garage entry and a main-level bedroom with ensuite. Upstairs, four bedrooms each have ensuite access, including a primary retreat with 10 ft tray ceiling, oversized walk-in closet, linear fireplace, and spa-inspired 5-piece ensuite with heated floors. The finished lower level offers 9 ft ceilings, oversized windows, sixth bedroom, full bathroom, linear fireplace, and endless possibilities. Additional features include radon mitigation, 200-amp service, hardwired security system, and Dry Core subfloor. Outside, the back patio provides a starting point for a dream outdoor space, with a pre-approved building permit for an in-ground pool and gas lines for BBQ. Centrally located, this home offers walkability to schools, parks, shops, and quick access to Hwy 403. (See full list of features.)" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.5" +"CreationDate": "2026-04-24T04:58:29.320221+00:00" +"CrossStreet": "Fiddlers Green" +"DirectionFaces": "West" +"Directions": "Fiddlers Green to Cumming Court" +"ExpirationDate": "2026-05-18" +"ExteriorFeatures": array:1 [ …1] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Frigidaire Professional: Fridge, Freezer, Dishwasher, Microwave. Bertazzoni: 48" Gas Range Top, Steam Oven, Wall Oven. Electrolux: Beverage Fridge, Washer, Dryer. All Electric Light Fixtures. All Bathroom Vanity Mirrors. Security System with Cameras & Door Bell Camarea. Navien Water Heater" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-06" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2026-04-21T00:32:55Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-06T18:17:36Z" +"OriginalListPrice": 2595000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3527314" +"ParcelNumber": "174330287" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.5" +"PhotosChangeTimestamp": "2026-02-06T18:17:36Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cumming" +"StreetNumber": "102" +"StreetSuffix": "Court" +"TaxAnnualAmount": "15399.32" +"TaxAssessedValue": 1223000 +"TaxLegalDescription": "LT 23, PL 927 ; ANCASTER CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=Gi Cf Jab Nnr M" +"VirtualTourURLUnbranded": "http://www.102Cumming.ca" +"Zoning": "ER" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 104.61 +"LotShape": "Rectangular" +"LotWidth": 75.33 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12766668')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814034025600" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9G 1V3, CA" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Sold Conditional Escape" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 2 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 18 +"RoomsBelowGrade": 5 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ …6] +"SalesBrochureUrl": "http://www.102Cumming.ca" +"LotIrregularities": "75.49 ft x 105.35 ft x 75.16 x 102.82 ft" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2026-02-06T18:17:36Z" +"SystemModificationTimestamp": "2026-04-21T00:33:10.765488Z" +"SoldConditionalEntryTimestamp": "2026-03-24T14:18:48Z" +"Media": array:50 [ …50] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4277 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13022888" +"ListingId": "X13022888" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T00:26:43Z" +"RFModificationTimestamp": "2026-04-28T16:37:23Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8V 1K7" +"UnparsedAddress": "507 Queensdale Avenue E, Hamilton, ON L8V 1K7" +"Coordinates": array:2 [ …2] +"Latitude": 43.2365671 +"Longitude": -79.8552482 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS COMPLETE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 507 Queensdale Avenue East, a well-maintained 2-storey detached home in Hamilton's desirable Eastmount neighbourhood on the North Central Mountain. Sitting on a prominent corner lot, this property offers exceptional flexibility for buyers looking to get into the market, settle into a family-friendly area, or explore future investment potential.Featuring over 1,200 square feet of finished living space, this home offers 3 bedrooms and 2 bathrooms. The bright, freshly painted interior is complemented by new carpeting as well laminate floors. While the main floor boasts a functional, flowing layout and a solid wood open-concept kitchen that serves as the heart of the home.The unfinished basement provides excellent storage today, with clear potential for future development to suit your needs. Whether you're looking to expand your living space or explore additional income opportunities down the road, the possibilities here are strong.Outside, the corner lot adds extra space and privacy, with rear parking for up to 3 vehicles and a large, detached shed for additional storage or workspace. Ideally located with quick highway access and close to schools, parks, the Juravinski Hospital, and everyday amenities, this is a location that continues to attract attention for both lifestyle and long-term value.A fantastic opportunity to own in one of Hamilton Mountain's most established and convenient communities. Book your private showing today!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Inch Park" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-24T04:59:50.183303+00:00" +"CrossStreet": "Upper Wellington Avenue E" +"DirectionFaces": "North" +"Directions": "Upper Wellington Street to Queensdale Avenue E" +"ExpirationDate": "2026-08-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Inclusions": "All appliances, light fixtures, window coverings, basement dehumidifier, gas lawnmower in shed, dining room oak table, chairs, buffet, hutch,coat hanger in the mud room, oak coffee tables." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "270600" +"MajorChangeTimestamp": "2026-04-21T00:26:43Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T00:26:43Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3826270" +"ParcelNumber": "170540304" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-21T00:26:43Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Queensdale" +"StreetNumber": "507" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3548.21" +"TaxLegalDescription": "LT 13, PL 590 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.507queensdaleavee.com/" +"VirtualTourURLUnbranded2": "https://www.507queensdaleavee.com/" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 102.91 +"LotWidth": 31.13 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022888')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251807067308710" +"SurveyType": "Unknown" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8V 1K7, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 1 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please book through Broker Bay." +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-21T00:26:43Z" +"SystemModificationTimestamp": "2026-04-21T00:26:44.201593Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4276 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13022742" +"ListingId": "X13022742" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T23:22:40Z" +"RFModificationTimestamp": "2026-05-03T11:37:09Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5694.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 2R1" +"UnparsedAddress": "290 Dewitt Road Part 2, Hamilton, ON L8E 2R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.223574 +"Longitude": -79.709354 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Builders, Investors And Homeowner A Rare Opportunity To Own An Excellent Building Lot To Build Your Own Custom Home In Stoney Creek Community. This Premium 35.6 x 160 Ft Lot Is Already Approved For Two Story Home With Double Car Garage. An Approved Lot Servicing Plan Is Available And A Building Permit Of Your Design & Vision Is Required. The Zoning Of The Property Is "Low Density Residential" (R1) Zone In Zoning By-law No. 05-200. Located On A Street With Other Neighboring Custom-Built Homes In The Area On Similar Type Of Lot. This Lot Is Near Parks, Great Schools, Mohawk College Stoney Creek Campus, Saltfleet Arena, Various Shops & Services, Close Access To Public Transportation, Local Farms, Wineries, Major Highways, Major Shopping Centers, Hospital, Quick Access To Niagara Region. Survey Completed And Available for Buyer. Create Your Design, Apply For Permits, Pay Applicable Permit Fees & Start Building Your Vision Today!! Great Investment, Location & Opportunity!There Is A Consent Agreement In place With The City Of Hamilton To Complete Servicing Of The Newly Severed Lots With Water, Sanitary, Storm Service Line And Catch Basin With A Refundable Cash Deposit Held By The City To Be Released Once The Servicing Is Complete. Also Available Are The Servicing Plan, Topography Survey, Grading Plan And Site Plan For The Two Story Home With Double Car Garage. Full Details Will Be Shared With The Interested Buyers." +"CityRegion": "Stoney Creek" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-28T17:30:35.305159+00:00" +"CrossStreet": "Barton and Dewitt" +"DirectionFaces": "North" +"Directions": "Barton and Dewitt" +"ExpirationDate": "2026-10-19" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"LotSizeSource": "Survey" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-20T23:22:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-20T23:22:40Z" +"OriginalListPrice": 499999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3844780" +"ParcelNumber": "173490554" +"PhotosChangeTimestamp": "2026-04-20T23:22:40Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dewitt" +"StreetNumber": "290" +"StreetSuffix": "Road" +"TaxLegalDescription": "PART LOT 9 PLAN 864, PART 2, 62R22420; STONEY CREEK SUBJECT TO AN EASEMENT IN GROSS AS IN WE1829484 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%- $50 Marketing fees + hst" +"TransactionType": "For Sale" +"UnitNumber": "Part 2" +"Zoning": "R1" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 160.33 +"LotShape": "Rectangular" +"LotWidth": 35.52 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022742')" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"Winterized": "No" +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 2R1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MortgageComment": "cleared" +"LotSizeAreaUnits": "Square Feet" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-20T23:22:40Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-20T23:22:40.799927Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:14 [ …14] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4275 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13022738" +"ListingId": "X13022738" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T23:22:03Z" +"RFModificationTimestamp": "2026-05-03T11:37:09Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 2R1" +"UnparsedAddress": "290 Dewitt Road Part 1, Hamilton, ON L8E 2R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.2439161 +"Longitude": -79.7620853 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Builders, Investors And Homeowner A Rare Opportunity To Own An Excellent Building Lot To Build Your Own Custom Home In Stoney Creek Community. This Premium 35.6 x 160 Ft Lot Is Already Approved For Two Story Home With Double Car Garage. An Approved Lot Servicing Plan Is Available And A Building Permit Of Your Design & Vision Is Required. The Zoning Of The Property Is "Low Density Residential" (R1) Zone In Zoning By-law No. 05-200. Located On A Street With Other Neighboring Custom-Built Homes In The Area On Similar Type Of Lot. This Lot Is Near Parks, Great Schools, Mohawk College Stoney Creek Campus, Saltfleet Arena, Various Shops & Services, Close Access To Public Transportation, Local Farms, Wineries, Major Highways, Major Shopping Centers, Hospital, Quick Access To Niagara Region. Survey Completed And Available for Buyer. Create Your Design, Apply For Permits, Pay Applicable Permit Fees & Start Building Your Vision Today!! Great Investment, Location & Opportunity!There Is A Consent Agreement In place With The City Of Hamilton To Complete Servicing Of The Newly Severed Lots With Water, Sanitary, Storm Service Line And Catch Basin With A Refundable Cash Deposit Held By The City To Be Released Once The Servicing Is Complete. Also Available Are The Servicing Plan, Topography Survey, Grading Plan And Site Plan For The Two Story Home With Double Car Garage. Full Details Will Be Shared With The Interested Buyers." +"CityRegion": "Stoney Creek" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-04-24T05:09:04.612186+00:00" +"CrossStreet": "Barton and Dewitt" +"DirectionFaces": "North" +"Directions": "Barton and Dewitt" +"ExpirationDate": "2026-10-19" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-20T23:22:03Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-20T23:22:03Z" +"OriginalListPrice": 499999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3845608" +"ParcelNumber": "173490553" +"PhotosChangeTimestamp": "2026-04-20T23:22:03Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dewitt" +"StreetNumber": "290" +"StreetSuffix": "Road" +"TaxLegalDescription": "PART LOT 9 PLAN 864, PART 1 62R22420; STONEY CREEK CITY OF HAMILTON,SUBJECT TO AN EASEMENT IN GROSS AS IN WE1829484" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%-$50mkt fee + hst" +"TransactionType": "For Sale" +"UnitNumber": "Part 1" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 160.33 +"LotShape": "Rectangular" +"LotWidth": 35.52 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13022738')" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 2R1, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MortgageComment": "cleared" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Immediate" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-20T23:22:03Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-20T23:22:03.417969Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4274 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12941944" +"ListingId": "X12941944" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T22:57:10Z" +"RFModificationTimestamp": "2026-05-02T20:21:03Z" +"ListPrice": 1099900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 0J9" +"UnparsedAddress": "68 Rockhaven Lane, Hamilton, ON L8B 0J9" +"Coordinates": array:2 [ …2] +"Latitude": 43.3323086 +"Longitude": -79.9054418 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this beautifully maintained detached home featuring a classic brick exterior, double-car garage, and inviting covered front porch with aggregate concrete detailing that creates excellent curb appeal. Step inside to a bright and welcoming foyer highlighted by an elegant staircase and beautiful hardwood floors that extend throughout the main level. A thoughtfully designed layout makes this home ideal for both everyday living and entertaining, complemented by custom California shutters throughout. The open-concept living and dining area is filled with natural light and offers the perfect setting for family gatherings and special occasions. The updated kitchen serves as the heart of the home, showcasing quartz countertops, high-end appliances, soft-close cabinetry, and a large centre island with seating and convenient pull-out drawers on both sides, providing exceptional prep space and functionality. The kitchen flows seamlessly into the cozy family room and large windows overlooking the backyard, creating a warm and inviting space to relax or entertain. Upstairs, you'll find spacious bedrooms with beautiful architectural details, including vaulted ceilings and large arched windows that bring in abundant natural light. The primary bedroom features a large walk-in closet and private ensuite, while the additional bedrooms offer flexibility for family living, guests, or a home office. The finished basement adds valuable additional living space, complete with new flooring and a crawl space that provides extra storage. Enjoy the private backyard featuring a deck ideal for outdoor dining and entertaining, along with a low-maintenance yard designed for easy upkeep. Located in a desirable family-friendly Waterdown neighbourhood, this home is close to parks, trails, schools, shopping, and everyday amenities, with convenient access to Highway 403, 407, Aldershot GO Station, Burlington, Hamilton, and the GTA." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-01T10:59:16.030036+00:00" +"CrossStreet": "Segwun Rd & Rockhaven Ln" +"DirectionFaces": "South" +"Directions": "Hamilton St - Rockhaven Lane" +"ExpirationDate": "2026-06-30" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Microwave, Range Hood, Refrigerator, Stove, Window Coverings, Thermostat, garage door opener remote, entertainment centre on main floor, all electrical light fixtures, basement freezer, shed" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-31" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2026-03-31T23:50:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-31T23:50:16Z" +"OriginalListPrice": 1099900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3749818" +"ParcelNumber": "175100460" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-20T22:57:10Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rockhaven" +"StreetNumber": "68" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "6167.75" +"TaxLegalDescription": "PCL 40-1, SEC 62M782 ; LT 40, PL 62M782 , S/T LT385450 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% Plus hst" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=e Zpfh7j2Erw" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=pt Jl8S0afn8" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 106.14 +"LotWidth": 55.54 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12941944')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830339040192" +"SurveyType": "None" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 0J9, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-04-20T22:57:10Z" +"SystemModificationTimestamp": "2026-04-20T22:57:21.789202Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:44 [ …44] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4273 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12862954" +"ListingId": "X12862954" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-20T21:47:05Z" +"RFModificationTimestamp": "2026-05-03T11:36:14Z" +"ListPrice": 1369900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 1P5" +"UnparsedAddress": "132 Canada Street, Hamilton, ON L8P 1P5" +"Coordinates": array:2 [ …2] +"Latitude": 43.2576169 +"Longitude": -79.8854863 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning brand new TO BE BUILT detached home built by the reputable Westpark Inc. in one of Hamilton's most sought-after neighbourhoods, just off vibrant Locke Street. Perfectly positioned in the heart of downtown, you're steps to trendy bars, top-rated restaurants, boutique shopping, transit, and nightlife, with easy access to universities, schools, and major routes. Offering just over 1,800 sq ft of thoughtfully designed living space, this modern home features4 spacious bedrooms- and 2.5 beautifully appointed bathrooms. The open-concept main floor is bright and airy, designed for both everyday living and effortless entertaining, with sleek contemporary finishes throughout. Enjoy the convenience of a private garage and driveway parking, a rare find in this prime urban location. Brand new from top to bottom, this home delivers the perfect blend of modern style, function, and downtown lifestyle. An exceptional opportunity to own a brand new turnkey property in the heart of Hamilton. All plans and renderings have been made, current home on the property will be knocked down and newbuild will be built on the lot. Home is being sold with Tarion Warranty under the builder." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Kirkendall" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T17:49:11.735267+00:00" +"CrossStreet": "Locke St & Canada St" +"DirectionFaces": "North" +"Directions": "Locke St & Canada St" +"ExpirationDate": "2026-09-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-09" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-04-20T21:47:05Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-09T18:45:15Z" +"OriginalListPrice": 1499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3647430" +"ParcelNumber": "171390094" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-10T19:33:22Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 1499900.0 +"PriceChangeTimestamp": "2026-04-20T21:47:05Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Canada" +"StreetNumber": "132" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5424.67" +"TaxLegalDescription": "PT LT 57, PL 244 , AS IN VM153878 ; S/T VM153878 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% Net of HST" +"TransactionType": "For Sale" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 93.0 +"LotWidth": 28.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862954')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "251801009456360" +"SurveyType": "Available" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 1P5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 3 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "October Closing" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "No on site showings....Purchasing off builder plans" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-03-10T19:33:22Z" +"SystemModificationTimestamp": "2026-04-20T21:47:13.461799Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:4 [ …4] } ] +success: true +page_size: 10 +page_count: 159 +count: 1587 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4091 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4092 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "S13046148" +"ListingId": "S13046148" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-03T16:19:55Z" +"RFModificationTimestamp": "2026-05-03T16:23:14Z" +"ListPrice": 2800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Barrie" +"PostalCode": "L4N 4V4" +"UnparsedAddress": "45 Austen Lane, Barrie, ON L4N 4V4" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ELIXIR REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 45 Austen Lane, Barrie - a beautifully updated fully detached home offered for lease (entire property), featuring approximately 1,800 sq. ft. of well-designed living space, ideal for families seeking comfort, privacy, and convenience.Located in a desirable family-friendly neighbourhood with quick access to Highway 400, this home is minutes from schools, parks, shopping, dining, and transit.The main level offers a bright and inviting living space with a cozy wood-burning fireplace, perfect for everyday living and entertaining. The renovated kitchen features modern cabinetry, sleek countertops, and stainless steel appliances, combining style with functionality.Upstairs, you'll find generously sized bedrooms including a primary with a walk-in closet, along with a fully updated bathroom. The lower level provides additional living space with two extra bedrooms and another updated bathroom-ideal for extended family, guests, or a home office. The finished basement adds excellent versatility with a kitchenette and separate laundry area.Recent upgrades include new flooring, fresh paint, modern pot lights, glass entry door, newer windows, updated gutters and fascia, durable metal roof, and owned furnace & A/C.Includes exclusive use of the entire property and parking for up to 4 vehicles. A rare opportunity to lease a fully upgraded detached home in a prime Barrie location-perfect for families, Professional looking for space and flexibility." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Letitia Heights" +"CoListOfficeName": "ELIXIR REAL ESTATE INC." +"CoListOfficePhone": "416-816-6001" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Simcoe" +"CreationDate": "2026-04-30T16:03:47.511677+00:00" +"CrossStreet": "ANNE ST N., LEFT ON AUSTEN" +"DirectionFaces": "South" +"Directions": "ANNE ST N., LEFT ON AUSTEN" +"ExpirationDate": "2026-07-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"Inclusions": "All Elfs, Washer, Dryer, AC, Furnace, Appliances" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-26" +"LotSizeDimensions": "110 x 39.99" +"MainOfficeKey": "361500" +"MajorChangeTimestamp": "2026-04-26T22:07:20Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-26T22:07:20Z" +"OriginalListPrice": 2800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3822996" +"ParcelNumber": "587760015" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-26T22:07:21Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:2 [ …2] +"Roof": array:1 [ …1] +"RoomsTotal": "10" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "AUSTEN" +"StreetNumber": "45" +"StreetSuffix": "Lane" +"TaxBookNumber": "434203102158200" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"VirtualTourURLBranded": "https://tourwizard.net/45-austen-lane-barrie/" +"VirtualTourURLBranded2": "https://youtu.be/fe8WUBQ7E1o" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('S13046148')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "434203102158200" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"RentalItems": "HWT (R), $24/month" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 …26 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4093 …129} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4094 …119} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4095 …134} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4096 …135} ] +success: true +page_size: 5 +page_count: 9684 +count: 48416 +after_key: "" } ] ]