Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: cf41ffaa19583c40c93d60d2855f18b95658dced55fa452a5d17f01ac696776b" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4264 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4002 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12680432" +"ListingId": "X12680432" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-23T00:43:16Z" +"RFModificationTimestamp": "2026-03-18T19:24:14Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 9.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C 3K5" +"UnparsedAddress": "100 West 3rd Street, Hamilton, ON L9C 3K5" +"Coordinates": array:2 [ 0 => -79.8834673 1 => 43.2323823 ] +"Latitude": 43.2323823 +"Longitude": -79.8834673 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime investment opportunity just steps from Mohawk College. Potential of Over $86,000 estimated annual income. This recently renovated property delivers exceptional versatility, making it ideal for student housing or multi-family use. Thoughtfully updated main and basement levels provide a well-maintained, low-maintenance investment with strong future cash flow potential. The spacious main floor features 5 generous bedrooms, along with one 3-piece washroom and one2-piece washroom, designed for comfortable shared living. The fully finished basement includes4 additional bedrooms, a full kitchen, one 3-piece washroom, and a separate entrance, allowing for flexible and optimized rental configurations. The property benefits from consistently strong demand due to its prime, high-traffic location. Additional highlights include a large double-car garage with excellent attic storage, ample parking, and an easy-care exterior. Located in a sought-after area close to schools, transit, shopping, and amenities, this is a turnkey income property with outstanding long-term value and upside potential." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:3 [ 0 => "Separate Entrance" 1 => "Full" 2 => "Finished" ] +"CityRegion": "Bonnington" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-03-02T13:18:24.209021+00:00" +"CrossStreet": "South Bend/West 3rd" +"DirectionFaces": "West" +"Directions": "South Bend/West 3rd" +"Exclusions": "None" +"ExpirationDate": "2026-06-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "2 Refrigerator, Washer, Dryer, 2 Stoves" +"InteriorFeatures": array:1 [ 0 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-09" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-01-09T15:58:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-09T15:58:22Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3413230" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-01-09T15:58:22Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "West 3rd" +"StreetNumber": "100" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5165.8" +"TaxLegalDescription": "PT LT 27, PL 765, AS IN HL143165 ; LT 28, PL 765 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2 % - $50 Marketing Fees + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 102.75 +"LotShape": "Square" +"LotWidth": 43.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12680432')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "251808092105880" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9C 3K5, CA" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 14 +"LotIrregularities": "43.09 ft x 102.96 ft x 43.09 ft x 102.96" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 4 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"WashroomsType3Level": "Main" +"MediaChangeTimestamp": "2026-01-09T15:58:22Z" +"SystemModificationTimestamp": "2026-01-23T00:43:16.092832Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4001 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12722864" +"ListingId": "X12722864" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-23T00:20:00Z" +"RFModificationTimestamp": "2026-03-18T10:46:42Z" +"ListPrice": 399900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 1A9" +"UnparsedAddress": "121 King Street E 408, Hamilton, ON L8N 1A9" +"Coordinates": array:2 [ 0 => -79.857243 1 => 43.252988 ] +"Latitude": 43.252988 +"Longitude": -79.857243 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ROUGE RIVER REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Exceptional downtown loft conversion, providing a nice blend of heritage features and modern touches in this beautifully appointed two-bedroom suite at Gore Park Lofts. The carefully restored historic building features exposed brick walls, huge windows and soaring ceilings. Kitchen is finished with quartz countertops, stainless steel appliances, custom cabinets, and peninsula breakfast bar. Built-in microwave and dishwasher are also included. Open-concept layout from kitchen to living area. Juliet balcony with great city/ skyline views. The suite includes in-suite laundry for added convenience plus a secure owned storage locker. Prime downtown location with easy access to scenic walking and biking trails plus key amenities including Hamilton General Hospital; Hamilton GO Centre; Jackson Square shopping mall; TD Coliseum; farmers' markets, independent cafes, top-rated restaurants and much more!" +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationFee": "581.25" +"AssociationFeeIncludes": array:4 [ 0 => "Heat Included" 1 => "Water Included" 2 => "Common Elements Included" 3 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Gore Park Lofts" +"CityRegion": "Beasley" +"CoListOfficeName": "RE/MAX ROUGE RIVER REALTY LTD." +"CoListOfficePhone": "416-286-3993" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-17T05:42:28.066905+00:00" +"CrossStreet": "King St E & Catherine" +"Directions": "King St E, west of Catherine" +"Exclusions": "Window coverings are tenant property." +"ExpirationDate": "2026-04-20" +"Inclusions": "Fridge, stove, built-in microwave, built-in dishwasher, washer, dryer, all light fixtures." +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "Storage Area Lockers" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-20" +"MainOfficeKey": "498600" +"MajorChangeTimestamp": "2026-01-23T00:20:00Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-23T00:20:00Z" +"OriginalListPrice": 399900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3451958" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2026-01-23T00:20:00Z" +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "King" +"StreetNumber": "121" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4686.02" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"UnitNumber": "408" +"View": array:2 [ 0 => "City" 1 => "Skyline" ] +"DDFYN": true +"Locker": "Owned" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12722864')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"LockerUnit": "2" +"SurveyType": "None" +"BalconyType": "None" +"LockerLevel": "A" +"RentalItems": "None" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "4" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8N 1A9, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 651 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 5 +"PropertyFeatures": array:4 [ 0 => "Hospital" 1 => "Place Of Worship" 2 => "Public Transit" 3 => "Rec./Commun.Centre" ] +"SquareFootSource": "Builder plans" +"PossessionDetails": "60-90 days/ TBA" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"ShowingAppointments": "Online/ Broker Bay" +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "8" +"MediaChangeTimestamp": "2026-01-23T14:40:20Z" +"PropertyManagementCompany": "Property Management Guild Inc." +"SystemModificationTimestamp": "2026-01-23T14:40:20.637064Z" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3995 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12631510" +"ListingId": "X12631510" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-20T19:45:36Z" +"RFModificationTimestamp": "2026-02-23T12:37:35Z" +"ListPrice": 624900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.04 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 5L3" +"UnparsedAddress": "336 Emerald Street N, Hamilton, ON L8L 5L3" +"Coordinates": array:2 [ 0 => -79.8499655 1 => 43.2622254 ] +"Latitude": 43.2622254 +"Longitude": -79.8499655 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step inside this stunning, oversized, double brick Victorian and prepare to be absolutely shocked. Steps from the lively heartbeat of Barton Village and a short stroll to James North Arts District and West Harbour GO, this home is perfectly positioned between two of Hamilton's fastest-emerging, culture-rich business corridors. Enjoy local cafés, indie boutiques, vibrant restaurants and markets all within reach. But the real magic happens the moment you walk through the front door. Completely renovated from top to bottom this home stuns with jaw-dropping open concept main floor that seamlessly blends Victorian character with modern luxury. Show stopping chef's kitchen features oversized island that can double as another dining table and storage hub perfect for bakers, entertainers, and families. Real maple cabinetry with crown molding, granite countertops, floor-to-ceiling pantry, mosaic backsplash, stainless steel appliances and a pot filler, this kitchen is the crown jewel of the home. Off of the kitchen, you'll find a cozy family room with walkout to a low-maintenance backyard, complete with a stone fireplace that doubles as a pizza oven, the ultimate setup for laid-back evenings or weekend gatherings. Upstairs offers three generous bedrooms with beautiful parquet flooring in fantastic condition that adds a vintage touch and renovated spa-like bath with jacuzzi tub. Fully finished basement adds even more versatility with two finished rooms. One ideal as a second living area, family room, movie room, gym, or work-from-home space. There's also a stylish three-piece bath with an oversized glass shower offering comfort and convenience. Lovingly cared for and thoughtfully updated by the same family for nearly four decades, this home is a testament to the strength and vibrancy of the neighbourhood and the kind of life that's been lived and loved within these walls. A rare opportunity to carry forward a beautiful legacy in one of Hamilton's most established communities." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Landsdale" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-01-07T21:48:10.379446+00:00" +"CrossStreet": "Birge Street" +"DirectionFaces": "East" +"Directions": "Birge St. or Barton St. E. to Emerald St. N." +"Exclusions": "None." +"ExpirationDate": "2026-05-31" +"ExteriorFeatures": array:3 [ 0 => "Deck" 1 => "Patio" 2 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Inclusions": "Fridge, stove, dishwasher, washer, dryer." +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-12" +"LotSizeSource": "MPAC" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2026-01-20T19:45:36Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-13T01:59:38Z" +"OriginalListPrice": 644900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3357488" +"OtherStructures": array:1 [ 0 => "Shed" ] +"ParcelNumber": "171860002" +"ParkingFeatures": array:1 [ 0 => "Front Yard Parking" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-12-13T01:59:38Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 644900.0 +"PriceChangeTimestamp": "2026-01-20T19:45:36Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Emerald" +"StreetNumber": "336" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2370.5" +"TaxLegalDescription": "PT LTS 23 & 24, PL 283 , AS IN CD464190 ; S/T & T/W CD464190 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://iframe.videodelivery.net/fa7bf18f6f43304dfe197d0d4e1764a0" +"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=Av Vz7a HBBh E" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Av Vz7a HBBh E" +"VirtualTourURLUnbranded2": "https://iframe.videodelivery.net/fa7bf18f6f43304dfe197d0d4e1764a0" +"Zoning": "D" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 92.87 +"LotShape": "Rectangular" +"LotWidth": 20.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12631510')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803021653020" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "None" ] +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Water heater." +"HoldoverDays": 120 +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-12-12" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1100-1500" +"MortgageComment": "Seller to discharge mortgage." +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 2 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Park" 3 => "Place Of Worship" 4 => "Public Transit" 5 => "Rec./Commun.Centre" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate/Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Other" ] +"ShowingAppointments": "Broker Bay/LBO. Please remove shoes, leave card, turn off lights, lock all doors." +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-12-13T01:59:38Z" +"SystemModificationTimestamp": "2026-01-20T19:45:44.912451Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3998 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12703096" +"ListingId": "X12703096" +"PropertyType": "Residential" +"PropertySubType": "Duplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-20T17:05:05Z" +"RFModificationTimestamp": "2026-02-24T13:20:48Z" +"ListPrice": 849000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9A 2Y6" +"UnparsedAddress": "30 Terrace Drive, Hamilton, ON L9A 2Y6" +"Coordinates": array:2 [ 0 => -79.8754679 1 => 43.2358335 ] +"Latitude": 43.2358335 +"Longitude": -79.8754679 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 30 Terrace Drive. One of the most sought after streets in Dundas. Unique floor plan,elevated bungalow with lower level at grade level. This home could easily accommodate an in-lawset up. Same owners for 46 years. Spacious principle rooms, 2 full bathrooms, rec room withwood burning fire place, formal dining room, Double car garage with access to the lower level.Flexible Possession" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:1 [ 0 => "Finished with Walk-Out" ] +"CityRegion": "Dundas" +"ConstructionMaterials": array:2 [ 0 => "Cedar" 1 => "Brick Front" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-24T10:46:21.540425+00:00" +"CrossStreet": "TURNBULL DR" +"DirectionFaces": "North" +"Directions": "OFF OLD ANCASTER RD, TO TURNBULL RD TO TERRACE DR" +"Exclusions": "NONE" +"ExpirationDate": "2026-05-31" +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Block" ] +"GarageYN": true +"Inclusions": "Dishwasher, Freezer, Microwave, Refrigerator, Fridge, stove, microwave, freezer, all windowcoverings + light fixtures, garden hand tool" +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "In-Law Capability" 2 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-16" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2026-01-16T15:59:59Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2026-01-16T15:59:59Z" +"OriginalListPrice": 849000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3447826" +"ParcelNumber": "174530216" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-01-16T16:00:52Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "TERRACE" +"StreetNumber": "30" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5791.0" +"TaxLegalDescription": "LT 60, PL 1389 ; DUNDAS CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=69309" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 108.87 +"LotWidth": 85.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12703096')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251826003040800" +"SurveyType": "None" +"RentalItems": "NONE" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 2 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9A 2Y6, CA" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 5 +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-297-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2026-01-16T16:00:52Z" +"SystemModificationTimestamp": "2026-01-20T17:05:12.578494Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4003 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12709694" +"ListingId": "X12709694" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-20T15:57:09Z" +"RFModificationTimestamp": "2026-02-24T13:20:53Z" +"ListPrice": 668900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.11 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H 5N1" +"UnparsedAddress": "233 Normanhurst Avenue, Hamilton, ON L8H 5N1" +"Coordinates": array:2 [ 0 => -79.7962194 1 => 43.2446616 ] +"Latitude": 43.2446616 +"Longitude": -79.7962194 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "YOUR HOME SOLD GUARANTEED REALTY ELITE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "AWESOME Spacious & Updated Home with In Law Suite and Detached Garage. Welcome to this beautifully updated and oversized detached home with nearly 1,800 square feet above grade plus a fully finished in law suite with a separate entrance. This property blends space, flexibility, and comfort, making it perfect for growing families, multi generational living, or investors looking to reduce the cost of ownership. Inside, you will discover a bright and inviting open concept layout with a main floor office designed for easy family living and entertaining. The updated kitchen and dining area flow naturally together with plenty of counter space and modern finishes. A sliding glass door opens directly to the backyard, creating the perfect spot for morning coffee, summer barbecues, or watching children and pets play outdoors. Upstairs, there are three generous bedrooms filled with natural light and a convenient second floor laundry, keeping daily life simple and organized. This upper level provides more than enough room for a family to live comfortably, while the separate lower suite provides flexibility for extended family, guests, or rental income potential. The exterior has been tastefully refreshed with a modern stucco finish and features a detached garage with hydro, ideal for parking, storage, or even a potential accessory dwelling unit (ADU). The lower level includes its own kitchen, laundry, and private entrance, making it a functional and welcoming space for family members or tenants alike. Located in a quiet and convenient pocket of Hamilton, this home is just minutes from The LINC and Red Hill Parkway, quick access for commuters while staying close to schools, shopping, parks, and everyday amenities. A truly turn key property that combines size, style, and practicality, ready for you to move in, spread out, and enjoy." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:3 [ 0 => "Separate Entrance" 1 => "Finished" 2 => "Full" ] +"CityRegion": "Normanhurst" +"ConstructionMaterials": array:1 [ 0 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-24T10:58:14.001295+00:00" +"CrossStreet": "Barton St E & Stratherne Ave" +"DirectionFaces": "West" +"Directions": "North on Normanhurst from Barton St E" +"Exclusions": "None" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:1 [ 0 => "Landscaped" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Refrigerator X2, Stove, Dishwasher, Washer & Dryer X2" +"InteriorFeatures": array:1 [ 0 => "In-Law Suite" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "353100" +"MajorChangeTimestamp": "2026-01-19T17:44:24Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-19T17:44:24Z" +"OriginalListPrice": 668900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3455856" +"OtherStructures": array:1 [ 0 => "None" ] +"ParcelNumber": "172570148" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-01-19T17:44:24Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Alarm System" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Normanhurst" +"StreetNumber": "233" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4820.74" +"TaxLegalDescription": "LT 380, PL 640 ; LT 379, PL 640 , EXCEPT NS119462 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "$1.00" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/233_normanhurst_ave_hamilton_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/233_normanhurst_ave_hamilton_on/" +"Zoning": "C" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotShape": "Rectangular" +"LotWidth": 45.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12709694')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251805038404380" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "None" ] +"RentalItems": "On-Demand Water Heater" +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8H 5N1, CA" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 9 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:5 [ 0 => "Hospital" 1 => "Park" 2 => "Place Of Worship" 3 => "School Bus Route" 4 => "School" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Book through Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2026-01-19T17:44:24Z" +"SystemModificationTimestamp": "2026-01-20T15:57:20.399805Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:36 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4024 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12700534" +"ListingId": "X12700534" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-19T13:50:54Z" +"RFModificationTimestamp": "2026-03-02T19:13:33Z" +"ListPrice": 2500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 970.0 +"City": "Hamilton" +"PostalCode": "L8H 3Z3" +"UnparsedAddress": "148 N Ottawa Street N 2, Hamilton, ON L8H 3Z3" +"Coordinates": array:2 [ 0 => -79.8215098 1 => 43.2385825 ] +"Latitude": 43.2385825 +"Longitude": -79.8215098 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "STONEMILL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Space for Lease in High-Traffic Trendy District.Approximately 970 sq ft second-floor commercial unit located above a popular restaurant with the same landlord. Zoning allows for multiple uses including medical, dental, hair & beauty, wellness, and professional services. In excellent condition with abundant natural light. Features large central open workspace, two private rooms with windows, full kitchen, on-site laundry cupboard, and spacious 4-piece bathroom with tub and storage. Adjacent dedicated parking lot with one exclusive parking space. Tenant pays all utilities. Outstanding visibility and pedestrian exposure in one of the city's most desirable retail corridors." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Crown Point" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-02T16:52:35.808207+00:00" +"CrossStreet": "Roxborough/Ottawa N" +"Directions": "Ottawa N/North of Roxborough" +"ExpirationDate": "2026-06-01" +"Inclusions": "fridge, stove" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-13" +"MainOfficeKey": "039200" +"MajorChangeTimestamp": "2026-01-15T19:10:46Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-15T19:10:46Z" +"OriginalListPrice": 2500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3435662" +"ParcelNumber": "172460047" +"PhotosChangeTimestamp": "2026-01-19T16:36:11Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirPrefix": "N" +"StreetDirSuffix": "N" +"StreetName": "Ottawa" +"StreetNumber": "148" +"StreetSuffix": "Street" +"TaxYear": "2026" +"TransactionBrokerCompensation": "1/2 Months Rent" +"TransactionType": "For Lease" +"UnitNumber": "2" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "C5a" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12700534')" +"GarageType": "None" +"RollNumber": "251804031100190" +"PropertyUse": "Office" +"ElevatorType": "None" +"HoldoverDays": 120 +"HeatTypeMulti": array:1 [ 0 => "Gas Forced Air Open" ] +"ListPriceUnit": "Month" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8H 3Z3, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2026-02-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"PossessionDetails": "vacant possession" +"OfficeApartmentArea": 970.0 +"ShowingAppointments": "LA must be present" +"MediaChangeTimestamp": "2026-01-19T16:36:11Z" +"MaximumRentalMonthsTerm": 12 +"MinimumRentalTermMonths": 12 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2026-01-19T16:36:11.473496Z" +"Media": array:19 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4025 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12427633" +"ListingId": "X12427633" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-16T15:37:20Z" +"RFModificationTimestamp": "2026-03-21T03:01:49Z" +"ListPrice": 3350.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 3S1" +"UnparsedAddress": "118 Queen Street S, Hamilton, ON L8P 3S1" +"Coordinates": array:2 [ 0 => -79.8804339 1 => 43.2557972 ] +"Latitude": 43.2557972 +"Longitude": -79.8804339 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 118 Queen Street South. A beautifully maintained character home in Hamilton's sought-after Kirkendall neighbourhood. Just steps from Locke Street, Hess Village, boutique shops, cafes, top-rated schools, the GO Station, hospitals, parks, and transit everything is at your doorstep. This 3-bedroom + loft, 2-bath home features a private backyard, 3-car driveway, and two separate entrances (Queen St. S and Hunter St. W). A rare find in one of Hamilton's most vibrant and walkable communities." +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:1 [ 0 => "Partial Basement" ] +"CityRegion": "Kirkendall" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-17T09:29:06.764747+00:00" +"CrossStreet": "Hunter St West" +"DirectionFaces": "West" +"Directions": "Main St to Queen St, parking on Hunter." +"Exclusions": "N/A" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:4 [ 0 => "Deck" 1 => "Privacy" 2 => "Porch" 3 => "Porch Enclosed" ] +"FireplaceFeatures": array:1 [ 0 => "Electric" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Furnished": "Unfurnished" +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": array:2 [ 0 => "Bar Fridge" 1 => "In-Law Capability" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-23" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2026-01-16T15:37:20Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-09-25T22:56:35Z" +"OriginalListPrice": 3600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3050846" +"ParcelNumber": "171400260" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-09-29T17:32:56Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 3600.0 +"PriceChangeTimestamp": "2026-01-16T15:37:20Z" +"RentIncludes": array:3 [ 0 => "Other" 1 => "Parking" 2 => "Water Heater" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Queen" +"StreetNumber": "118" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Months Rent + HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12427633')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251801009500220" +"SurveyType": "None" +"RentalItems": "N/A" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 3S1, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"PossessionType": "30-59 days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 7 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Golf" 2 => "Greenbelt/Conservation" 3 => "Hospital" 4 => "Library" 5 => "Public Transit" ] +"PossessionDetails": "Available Nov 1st." +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2025-09-29T17:32:56Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-01-16T15:37:26.735637Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:24 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4026 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12702076" +"ListingId": "X12702076" +"PropertyType": "Residential Lease" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-16T13:11:47Z" +"RFModificationTimestamp": "2026-03-17T20:06:41Z" +"ListPrice": 3200.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1W3" +"UnparsedAddress": "137 Borers Creek Circle, Hamilton, ON L8B 1W3" +"Coordinates": array:2 [ 0 => -79.9185999 1 => 43.3322041 ] +"Latitude": 43.3322041 +"Longitude": -79.9185999 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This bright, clean, and beautifully maintained home boasts modern upgrades throughout, including a renovated kitchen, stylish bathrooms, and second-floor laundry. Nestled in a highly sought-after neighborhood, it falls within the top-rated school districts of John Fraser SS, St. Aloysius Gonzaga SS, and Credit Valley PS. Enjoy the convenience of easy access to Highways 403 & 407, with Credit Valley Hospital, Erin Mills Town Centre, restaurants, grocery stores, and public transit just a short walk away. Backing onto a play area, the home offers stunning southwest-facing views and abundant natural light. With an interlock driveway and walkway, this is a fantastic opportunity to live in a prime location, perfect for families !" +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"AttachedGarageYN": true +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-17T09:40:42.868672+00:00" +"CrossStreet": "Parkside Dr / Mosaic Dr" +"DirectionFaces": "South" +"Directions": "Parkside Dr / Mosaic Dr" +"Exclusions": "None" +"ExpirationDate": "2026-04-15" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"HeatingYN": true +"Inclusions": "Existing stainless steel fridge, stove, dishwasher. Washer, dryer, all window coverings, all ceiling light fixtures, and garage door opener." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-15" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "18.01 x 77.76 Feet" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-01-16T12:28:17Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-16T12:28:17Z" +"OriginalListPrice": 3200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3445086" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-01-16T12:28:18Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "9" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Borers Creek" +"StreetNumber": "137" +"StreetSuffix": "Circle" +"TaxBookNumber": "251830342004903" +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 77.76 +"LotWidth": 18.01 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12702076')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "210504015861500" +"SurveyType": "None" +"RentalItems": "Hot water tank" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8B 1W3, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-02-02" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 3 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"StreetSuffixCode": "Cres" +"BoardPropertyType": "Free" +"PossessionDetails": "TBA" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2026-01-16T12:28:18Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"MLSAreaDistrictOldZone": "X14" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2026-01-16T13:11:51.256023Z" +"Media": array:30 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4027 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12701548" +"ListingId": "X12701548" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-15T23:17:12Z" +"RFModificationTimestamp": "2026-03-18T12:21:30Z" +"ListPrice": 569900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8M 2E8" +"UnparsedAddress": "49 Myrtle Avenue, Hamilton, ON L8M 2E8" +"Coordinates": array:2 [ 0 => -79.848616 1 => 43.24827 ] +"Latitude": 43.24827 +"Longitude": -79.848616 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Charming 2.5-Storey Solid Brick Home in Central Hamilton! Welcome to this spacious family home featuring 4 bedrooms and 3 bathrooms. Enjoy a bright, inviting layout with plenty of character throughout. The partially finished basement offers extra living or storage space, while the fully fenced yard provides privacy and a safe play area for children or pets. Relax on the covered front porch overlooking the park-perfect for morning coffee or evening sunsets. Located in a desirable neighbourhood across from a beautiful park, close to schools, shopping, churches, and public transit, with quick access to major highways. Ideal for families or commuters looking for comfort, convenience, and classic charm in the heart of Hamilton!" +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Partially Finished" ] +"CityRegion": "St. Clair" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-03-17T09:47:08.931302+00:00" +"CrossStreet": "Main St E / Myrtle Avenue" +"DirectionFaces": "East" +"Directions": "-" +"ExpirationDate": "2026-04-15" +"ExteriorFeatures": array:1 [ 0 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "Dryer, Refrigerator, Stove, Washer, All Electrical Light Fixtures" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-15" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2026-01-15T23:17:12Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-15T23:17:12Z" +"OriginalListPrice": 569900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3446516" +"ParcelNumber": "172040053" +"PhotosChangeTimestamp": "2026-01-15T23:17:12Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Myrtle" +"StreetNumber": "49" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3757.8" +"TaxLegalDescription": "PT LTS 23 & 24, PL 221 , AS IN CD37624, S/T & T/W NS70028 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 95.0 +"LotShape": "Rectangular" +"LotWidth": 23.17 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12701548')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803024203770" +"SurveyType": "None" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8M 2E8, CA" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 1 +"PropertyFeatures": array:5 [ 0 => "Fenced Yard" 1 => "Park" 2 => "Place Of Worship" 3 => "Public Transit" 4 => "School" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "-" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-01-15T23:17:12Z" +"SystemModificationTimestamp": "2026-01-15T23:17:12.486782Z" +"Media": array:24 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4028 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12616938" +"ListingId": "X12616938" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-15T18:55:52Z" +"RFModificationTimestamp": "2026-02-28T03:02:06Z" +"ListPrice": 479900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 6V8" +"UnparsedAddress": "207 Lottridge Street, Hamilton, ON L8L 6V8" +"Coordinates": array:2 [ 0 => -79.8307787 1 => 43.2565663 ] +"Latitude": 43.2565663 +"Longitude": -79.8307787 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome home to the perfect blend of elegance and comfort in this 3 bedroom, 1 bathroom, two-story residence, recently renovated home with finished basement. From the moment you enter, you'll be captivated by the open-concept design, seamlessly connecting a modern kitchen to a spacious dining and living area. Step out onto a private deck, cleverly shielded for utmost privacy, perfect for serene mornings or evening gatherings. The primary bedroom is impressively spacious, offering ample room for your personal touches and relaxation. This residence comes turn key and move in ready." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Walk-Out" ] +"CityRegion": "Stipley" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Concrete Block" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2026-02-24T15:19:37.233233+00:00" +"CrossStreet": "Barton St E / Sherman Ave N" +"DirectionFaces": "West" +"Directions": "Barton St E / Sherman Ave N" +"ExpirationDate": "2026-05-29" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Inclusions": "All existing light fixtures, curtains, blinds. All existing appliances, washer/dryer." +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-10" +"LotSizeSource": "MPAC" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2026-01-15T18:55:52Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-10T21:18:56Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3348724" +"ParcelNumber": "172170184" +"PhotosChangeTimestamp": "2026-01-26T15:16:13Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 499000.0 +"PriceChangeTimestamp": "2026-01-15T18:55:52Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lottridge" +"StreetNumber": "207" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3175.0" +"TaxLegalDescription": "PT LT 12, BLK 10, PL 220 , PT LT 13, BLK 10, PL 220 , AS IN VM183621; S/T & T/W VM183621 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://propertyspaces.aryeo.com/sites/qnaqnep/unbranded" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 90.0 +"LotWidth": 20.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12616938')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803026607850" +"SurveyType": "Unknown" +"ElectricYNA": "Available" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 6V8, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2026-02-27" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 1 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Upper" +"MediaChangeTimestamp": "2026-01-26T15:16:13Z" +"SystemModificationTimestamp": "2026-01-26T15:16:13.290841Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:31 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 63 +count: 626 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4120 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4029 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12923572" +"ListingId": "X12923572" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T08:26:36Z" +"RFModificationTimestamp": "2026-03-29T08:31:48Z" +"ListPrice": 2800.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2P 3J8" +"UnparsedAddress": "16 Melbourne Avenue, St. Catharines, ON L2P 3J8" +"Coordinates": array:2 [ 0 => -79.2324452 1 => 43.1570025 ] +"Latitude": 43.1570025 +"Longitude": -79.2324452 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Absolutely Stunning! offering comfort, convenience, and modern living. This well built, move-in ready 3-bedroom, 3-bathroom, including a primary suite with a four piece ensuite and second bedroom with balcony.. offering comfort, convenience, and modern townhouse Located In The Highly Desired Area Of St. Catharines, bright, open-concept layout that invites natural light throughout. Modern Kitchen with soft-close cabinetry, and brand-new appliances. Pot lights illuminate every corner,The highlight of this home is the impressive 388-square-foot rooftop terrace, offering the perfect space for relaxation, Close to all amenities, Public Transit, Brock University, Hwy 406" +"ArchitecturalStyle": array:1 [ 0 => "Stacked Townhouse" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "450 - E. Chester" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2026-03-26T14:55:43.228589+00:00" +"CrossStreet": "Oakdale Avenue and Melbourne Avenue" +"Directions": "Oakdale Avenue and Melbourne Avenue" +"ExpirationDate": "2026-08-31" +"ExteriorFeatures": array:2 [ 0 => "Backs On Green Belt" 1 => "Patio" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"InteriorFeatures": array:1 [ 0 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-03-26T14:27:11Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-26T14:27:11Z" +"OriginalListPrice": 2800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3724758" +"ParcelNumber": "463351109" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2026-03-26T14:27:11Z" +"RentIncludes": array:1 [ 0 => "Building Insurance" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"ShowingRequirements": array:3 [ 0 => "Showing System" 1 => "List Brokerage" 2 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Melbourne" +"StreetNumber": "16" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "Half Month Rent" +"TransactionType": "For Lease" +"UnitNumber": "Suite 334 (302C)" +"DDFYN": true +"Locker": "None" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12923572')" +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "262901001704300" +"SurveyType": "Unknown" +"BalconyType": "Juliette" +"HoldoverDays": 90 +"LegalStories": "Second" +"ParkingType1": "Owned" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"ApproximateAge": "New" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 6 +"LeaseAgreementYN": true +"LotSizeAreaUnits": "Acres" +"PaymentFrequency": "Monthly" +"SquareFootSource": "Builder Dawings" +"PossessionDetails": "TBA" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Third" +"WashroomsType2Level": "Second" +"LegalApartmentNumber": "302C" +"MediaChangeTimestamp": "2026-03-26T14:27:11Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "n/a" +"SystemModificationTimestamp": "2026-03-29T08:26:42.097038Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:19 [ …19] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4088 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "N12932892" +"ListingId": "N12932892" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T07:08:13Z" +"RFModificationTimestamp": "2026-03-29T07:25:02Z" +"ListPrice": 1900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "New Tecumseth" +"PostalCode": "L9R 0M4" +"UnparsedAddress": "11 Treetops Boulevard, New Tecumseth, ON L9R 0M4" +"Coordinates": array:2 [ …2] +"Latitude": 44.1590953 +"Longitude": -79.7930955 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Bright 1-bedroom basement apartment in Alliston's Treetops community. Features a private walk-out with pond view, modern kitchen with stainless-steel appliances and quartz counters, full 4-piece bath, and a spacious bedroom with 2 mirrored closets and above-grade window. All-inclusive." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Rural New Tecumseth" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Simcoe" +"CreationDate": "2026-03-29T07:08:42.388770+00:00" +"CrossStreet": "10th Sdrd & Treetops Blvd." +"DirectionFaces": "South" +"Directions": "10th Sdrd & Treetops Blvd." +"ExpirationDate": "2026-06-30" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Includes the use of the stove, double-door fridge/freezer, O.T.R. microwave, and a stacked washer and dryer that is tucked into the corner of the bedroom. One parking space is provided in the driveway." +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-29" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2026-03-29T07:05:59Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-29T07:05:59Z" +"OriginalListPrice": 1900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3735904" +"ParcelNumber": "581440099" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-29T07:05:59Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": 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": "Treetops" +"StreetNumber": "11" +"StreetSuffix": "Boulevard" +"TransactionBrokerCompensation": "One half of one month's rent + H.S.T." +"TransactionType": "For Lease" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12932892')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "432404000535554" +"SurveyType": "None" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"WaterBodyType": "Pond" +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"PossessionDate": "2026-04-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 3 +"AccessToProperty": array:1 [ …1] +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Immediate" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Flat" +"MediaChangeTimestamp": "2026-03-29T07:05:59Z" +"PortionLeaseComments": "One BR basement apartment" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-03-29T07:08:15.22803Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:8 [ …8] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4086 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12831910" +"ListingId": "X12831910" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T07:05:46Z" +"RFModificationTimestamp": "2026-03-29T07:25:08Z" +"ListPrice": 1434700.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Huron-kinloss" +"PostalCode": "N2Z 0B3" +"UnparsedAddress": "44 Blairs Trail N, Huron-kinloss, ON N2Z 0B3" +"Coordinates": array:2 [ …2] +"Latitude": 44.0993357 +"Longitude": -81.7235164 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Exchange Realty Co." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 44 Blairs Trail serene retreat in the coveted lakeside community of Blairs Grove, where sandy shores and breathtaking sunsets over Lake Huron are just steps from your door. This 2021 custom-built bungalow, offers more than 3,400 sq. ft. of finished living space with 2,050 sq. ft. on the main floor and another 1,350 sq. ft. in the finished lower level. Set on a private half-acre, this home is a rare blend of luxury, craftsmanship, and comfort. Inside, soaring 9-foot ceilings on the main floor and oversized windows create a bright, open atmosphere. At the heart of the home, the chef-inspired kitchen boasts quartz countertops throughout, a 10-foot waterfall island, custom cabinetry, and a spacious walk-in pantry. The space flows seamlessly into the dining area and inviting great room with a cozy gas fireplace, then out to the covered rear deck (19 26)where a stone wood-burning fireplace and natural gas BBQ hookup invite year-round entertaining. The primary suite offers privacy and tranquility, while two additional bedrooms and a 4-piece bath create a separate guest wing. The lower level expands the living space with a recreation room, gas fireplace, billiards area, full bath, and two framed bedrooms allowing for up to six bedrooms in total. Every detail reflects superior construction: 9-inch poured concrete foundation walls, 2x6 framing with insulated sheathing for true thermal break, R-27 insulated walls, R-60 ceiling insulation, and 50-year Timberline shingles. The exterior shines with LP Smart Side maintenance-free Board and Batten siding accented by stone, and a fully fenced backyard with custom wrought iron railings. Just minutes from Kincardines amenities, dining, trails, and shops but tucked into a peaceful, tree-lined neighbourhood this home offers the perfect balance of modern functionality and lakeside serenity.44 Blairs Trail is more than a home its a lifestyle where quality, comfort, and coastal beauty come together." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Huron-Kinloss" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Bruce" +"CoveredSpaces": "3.0" +"CreationDate": "2026-03-29T07:09:01.050986+00:00" +"CrossStreet": "Bell" +"DirectionFaces": "East" +"Directions": "Bell Dr, North on Blairs Trail" +"Exclusions": "pizza oven" +"ExpirationDate": "2026-06-30" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "all apliances" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-03-01" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "572600" +"MajorChangeTimestamp": "2026-03-09T14:48:19Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-02T00:25:42Z" +"OriginalListPrice": 1484700.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3609598" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "333270200" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2026-03-02T00:25:43Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 1484700.0 +"PriceChangeTimestamp": "2026-03-09T14:48:19Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Blairs" +"StreetNumber": "44" +"StreetSuffix": "Trail" +"TaxAnnualAmount": "7413.54" +"TaxAssessedValue": 516000 +"TaxLegalDescription": "PCL 95-1 SEC M90; LT 95 PL M90; HURON-KINLOSS" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus hst" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://show.tours/v/9h2c Nqx" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 196.25 +"LotShape": "Rectangular" +"LotWidth": 126.89 +"SewerYNA": "No" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12831910')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "410716000714995" +"SurveyType": "Available" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "none" +"HoldoverDays": 30 +"TelephoneYNA": "Yes" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 12 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Huron-kinloss, ON N2Z 0B3, CA" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-30" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 7 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:2 [ …2] +"LotSizeRangeAcres": "Not Applicable" +"PossessionDetails": "tba" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2026-03-02T00:25:43Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-03-29T07:05:54.662354Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4084 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12883936" +"ListingId": "X12883936" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T07:00:07Z" +"RFModificationTimestamp": "2026-03-29T07:25:08Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Barrhaven" +"PostalCode": "K2J 4L2" +"UnparsedAddress": "161 Longshire Circle, Barrhaven, ON K2J 4L2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE INTEGRITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Look no further-this home has it all. It is a rare, well-maintained single bungalow located on a beautiful, established street in the heart of Barrhaven. The property features excellent curb appeal with a brick front, interlock details, and a widened driveway that accommodates two cars. interior is deceptively large and very clean, featuring:- Main Floor: A spacious entryway leads to hardwood floors, a bright living room with double French doors, and a separate dining room.- Kitchen: Recently renovated with quartz countertops, a double sink, stainless steel appliances, ample cabinetry, and a large island for storage and casual dining.- Living Spaces: A cozy family room with a fireplace.- Bedrooms & Baths: The primary suite includes a large, newly renovated bathroom with a standalone tub and modern finishes. The second bedroom and second bathroom (including laundry) have also been recently updated.- Basement: A spacious finished area with large windows, currently used as a bedroom and family room combo. It includes an oversized walk-in closet with built-ins and a recently installed bathroom. There is also a room with kitchen cupboards that could easily be converted into a full secondary suite (no separate entry).- Storage: The basement offers a huge storage area, a separate utility room, and a workshop. The backyard features a beautiful patio with a gazebo and a storage shed. This is a perfect home for either empty nesters or a young family. Please let me know if you would like to schedule a viewing." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "7706 - Barrhaven - Longfields" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-29T06:44:25.489382+00:00" +"CrossStreet": "Woodroffe and Queensbury" +"DirectionFaces": "West" +"Directions": "Woodroffe south, west on Queensbury, right on Doulton, left on Longshire." +"Exclusions": "BBQ, Patio furniture" +"ExpirationDate": "2026-06-14" +"ExteriorFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, stove, washer, dryer, dishwasher, hood fan, microwave, garage door opener, all televisions and wall mounts, all blinds and drapery, all shelving including walk in closet on lower level, gazebo on patio. Double and Queen mattresses are available if wanted." +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-14" +"MainOfficeKey": "493500" +"MajorChangeTimestamp": "2026-03-29T06:40:24Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-14T17:14:05Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3671822" +"ParcelNumber": "045962821" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-03-14T17:14:05Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Longshire" +"StreetNumber": "161" +"StreetSuffix": "Circle" +"TaxAnnualAmount": "4992.0" +"TaxLegalDescription": "PART OF LOT 23 ON PLAN 4M851, PART 2 ON PLAN 4R11677, NEPEAN." +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.myvisuallistings.com/vt/362331" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/362331" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 118.37 +"LotWidth": 36.87 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12883936')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "061412069602300" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"RentalItems": "Hot Water Tank" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Sold Conditional" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 5 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2026-03-14T19:11:39Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-03-29T07:00:26.241401Z" +"SoldConditionalEntryTimestamp": "2026-03-17T02:16:56Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:46 [ …46] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4062 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12932616" +"ListingId": "X12932616" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-29T06:29:54Z" +"RFModificationTimestamp": "2026-03-29T06:36:03Z" +"ListPrice": 455000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2G 0C4" +"UnparsedAddress": "399 Queen Street S 211, Kitchener, ON N2G 0C4" +"Coordinates": array:2 [ …2] +"Latitude": 43.4449669 +"Longitude": -80.4931806 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "INTERNATIONAL REALTY FIRM, INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Barra on Queen located on the historic grounds of the former Barra Castle in the vibrant heart of downtown Kitchener. Just steps from Victoria Park, top-rated restaurants, entertainment, DTK and the LRT; this prime location offers the perfect blend of convenience and lifestyle.The stunning suite features soaring ceilings and expansive windows that flood the space with natural light, along with a private walkout balcony-perfect for enjoying your morning coffee or unwinding at the end of the day. The modern kitchen is designed to impress, showcasing quartz countertops, stainless steel appliances, and a spacious island with seating for five-ideal for entertaining and everyday living.Residents at Barra enjoy an exceptional range of amenities right at their doorstep, including a fully equipped fitness center, stylish party room, and an outdoor BBQ/lounge area-perfect for relaxing or hosting guests.Experience urban living at its finest in one of Kitchener's most sought-after communities." +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "667.0" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-28T21:30:00.439420+00:00" +"CrossStreet": "Courtland Ave. and Queen St. S" +"Directions": "Queen St. S" +"ExpirationDate": "2026-06-24" +"GarageYN": true +"Inclusions": "Fridge, stove, microwave, dishwasher, washer, dryer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "MPAC" +"MainOfficeKey": "306300" +"MajorChangeTimestamp": "2026-03-28T21:24:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-28T21:24:37Z" +"OriginalListPrice": 455000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3726124" +"ParcelNumber": "236990039" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-28T21:24:38Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Queen" +"StreetNumber": "399" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2979.65" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "211" +"VirtualTourURLBranded": "https://mediatours.ca/property/211-399-queen-street-south-kitchener/" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/211-399-queen-street-south-kitchener/" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12932616')" +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301204000307029" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 699 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"SquareFootSource": "Owner" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"LegalApartmentNumber": "11" +"MediaChangeTimestamp": "2026-03-29T06:29:52Z" +"PropertyManagementCompany": "King Management" +"SystemModificationTimestamp": "2026-03-29T06:29:59.074565Z" +"Media": array:23 [ …23] } ] +success: true +page_size: 5 +page_count: 4200 +count: 20996 +after_key: "" } ] ]