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=150&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=150&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=150&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=150&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$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: "691310" +post_author: 1 +"ListingKey": "X13008360" +"ListingId": "X13008360" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T18:04:14Z" +"RFModificationTimestamp": "2026-04-30T05:01:47Z" +"ListPrice": 2045.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N1S 2M8" +"UnparsedAddress": "30 George Street S 208, Waterloo, ON N1S 2M8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "PEAK REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 30 George St. S, situated perfectly in the Gaslight District of Cambridge, steps away from Historical Old Galt, The Grand River & all amenities! Stylish, open concept unit with over 650 square feet of living space, with luxury vinyl planks, quartz countertops, in-suite laundry and a 300 square foot terrace. Features included in rent are one parking spot, water, heat, A/C, secure bike storage and 24/7 building security monitoring. This fantastic location in The West Galt neighbourhood is a perfect blend of modern and historic, with industrial buildings converted into chic spaces that house some of the most charming local businesses in Waterloo Region; it's easy to see why this is considered the Heart of Cambridge. The building is within walking distance to the Gaslight District, supermarkets, library, lush parks, bakeries, coffee shops, restaurants, a fitness center, public transit, schools and much more. Book your showing before these units are leased!" +"ArchitecturalStyle": "1 Storey/Apt" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T04:43:25.897353+00:00" +"CrossStreet": "St. Andrews" +"Directions": "Fountain to Blair to George" +"ExpirationDate": "2026-07-31" +"Furnished": "Unfurnished" +"InteriorFeatures": "Carpet Free,Air Exchanger,Water Softener,Water Heater" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "232800" +"MajorChangeTimestamp": "2026-04-16T18:04:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T18:04:14Z" +"OriginalListPrice": 2045.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3823496" +"ParcelNumber": "038060478" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T18:04:14Z" +"RentIncludes": array:10 [ …10] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "George" +"StreetNumber": "30" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Month" +"TransactionType": "For Lease" +"UnitNumber": "208" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13008360')" +"GarageType": "Carport" +"HeatSource": "Electric" +"RollNumber": "300604004503000" +"SurveyType": "Unknown" +"BalconyType": "Terrace" +"LegalStories": "2" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N1S 2M8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"LotSizeAreaUnits": "Square Feet" +"PaymentFrequency": "Monthly" +"SquareFootSource": "Builder" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "Please use street parking for showings. Lockbox located in the carport at the Bike Storage. Buzz 500 or 600 for building access." +"LegalApartmentNumber": "208" +"MediaChangeTimestamp": "2026-04-16T18:04:14Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "DNK Development Corp." +"SystemModificationTimestamp": "2026-04-16T18:04:14.727537Z" +"Media": array:21 [ …21] +"ID": "691310" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "701826" +post_author: 1 +"ListingKey": "X13007864" +"ListingId": "X13007864" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T17:04:34Z" +"RFModificationTimestamp": "2026-04-30T05:01:46Z" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 1K9" +"UnparsedAddress": "132 Bridge Street W, Waterloo, ON N2K 1K9" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Large 55x187 Foot Lot with Detached Double car plus garage/workshop along with 3 bed, 2 bath house. If you have been looking for a project, this is the Handyman special for you. Please note that property is being sold 'As is, where is". Please note garage photo is an older photo, provided to show size of garage only." +"ArchitecturalStyle": "1 1/2 Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T05:02:18.544706+00:00" +"CrossStreet": "University" +"DirectionFaces": "West" +"Directions": "University to Bridge" +"ExpirationDate": "2026-07-16" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-04-16T17:04:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T17:04:34Z" +"OriginalListPrice": 499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3827010" +"ParcelNumber": "222990019" +"ParkingFeatures": "Front Yard Parking" +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2026-04-16T17:04:34Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Bridge" +"StreetNumber": "132" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4747.2" +"TaxAssessedValue": 333000 +"TaxLegalDescription": "PLAN 256 PT LOTS 20 & 21" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 187.0 +"LotWidth": 55.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007864')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301601040000320" +"SurveyType": "None" +"HoldoverDays": 180 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 1K9, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-04-16T17:04:34Z" +"SystemModificationTimestamp": "2026-04-16T17:04:34.420775Z" +"Media": array:4 [ …4] +"ID": "701826" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "584462" +post_author: 1 +"ListingKey": "X12759028" +"ListingId": "X12759028" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T16:44:37Z" +"RFModificationTimestamp": "2026-04-30T05:00:27Z" +"ListPrice": 485000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 6J5" +"UnparsedAddress": "250 Keats Way 24, Waterloo, ON N2L 6J5" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "***Welcome to Unit 24 at 250 Keats Way***This beautifully maintained 3 bedrooms, 2.5 bathrooms townhome offers over 1,300 square feet of bright, functional living space on main and second floors, in one of Waterloo's most sought-after neighborhoods. The main floor welcomes you with an inviting eat-in kitchen and a spacious living room centered around a cozy gas fireplace, perfect for relaxing evenings. Step through the sliding glass doors onto your private elevated deck, an ideal spot for morning coffee overlooking the mature greenery. Upstairs, you'll find three generous bedrooms, including a primary suite with a cheater ensuite access to a modern 5-piece bathroom. The standout feature is the fully finished walkout basement, providing seamless access to a private lower patio. Whether you're looking for a peaceful family home or a high-performing investment near the University of Waterloo and Wilfrid Laurier, this turn-key property delivers. With an attached garage, and a location minutes from T&T Supermarket and Waterloo Park, this is an opportunity you don't want to miss." +"ArchitecturalStyle": "2-Storey" +"AssociationAmenities": array:2 [ …2] +"AssociationFee": "720.0" +"AssociationFeeIncludes": array:3 [ …3] +"Basement": array:3 [ …3] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T05:09:54.160048+00:00" +"CrossStreet": "University Ave. W." +"Directions": "University Ave. W. to Keats Way" +"ExpirationDate": "2026-04-30" +"ExteriorFeatures": "Year Round Living,Deck" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-04" +"MainOfficeKey": "399200" +"MajorChangeTimestamp": "2026-02-04T19:58:02Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-04T19:58:02Z" +"OriginalListPrice": 485000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3518778" +"ParkingFeatures": "Surface" +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T16:44:37Z" +"Roof": "Asphalt Shingle" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Keats" +"StreetNumber": "250" +"StreetSuffix": "Way" +"TaxAnnualAmount": "4151.2" +"TaxAssessedValue": 304000 +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"UnitNumber": "24" +"VirtualTourURLBranded": "https://youriguide.com/unit_24_250_keats_way_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/unit_24_250_keats_way_waterloo_on/" +"Zoning": "R8" +"DDFYN": true +"Locker": "None" +"Exposure": "South East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12759028')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Hot water heater." +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 6J5, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 180 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:3 [ …3] +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "PLEASE REMOVE SHOES, LEAVE A BUSINESS CARD, TURN OFF LIGHTS AND LOCK DOORS." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "24" +"MediaChangeTimestamp": "2026-04-16T16:44:37Z" +"PropertyManagementCompany": "WILSON BLANCHARD" +"SystemModificationTimestamp": "2026-04-16T16:44:46.156536Z" +"Media": array:45 [ …45] +"ID": "584462" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "690356" +post_author: 1 +"ListingKey": "X13007430" +"ListingId": "X13007430" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T16:15:29Z" +"RFModificationTimestamp": "2026-04-25T09:22:01Z" +"ListPrice": 3288000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1W3" +"UnparsedAddress": "282 Erb Street W, Waterloo, ON N2L 1W3" +"Coordinates": array:2 [ …2] +"Latitude": 43.457355 +"Longitude": -80.540799 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK YORK GROUP REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Previously approved site plan for a 35-unit rental/condominium development, zoned RMU-20 (Residential Mixed Use)-a compelling opportunity tailored for small to mid-sized developers targeting a proven, high-demand rental corridor.Positioned just steps from the University of Waterloo and Wilfrid Laurier University, the property is ideally suited for student housing as well as potential senior/retirement-oriented rental concepts. The location offers consistent, year-round rental demand driven by a strong academic and local community base. Walking distance to both campuses, combined with a direct bus stop at the doorstep, ensures exceptional accessibility and enduring tenant appeal.Offered at land value with existing building permits in place (subject to amendment for updated plans), this is a rare, near shovel-ready development opportunity-allowing investors to accelerate timelines and unlock value with minimal upfront entitlement risk." +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-24T21:23:28.597461+00:00" +"CrossStreet": "University" +"DirectionFaces": "South" +"Directions": "Driving through Bridgeport Rd E to Erb St. W" +"ExpirationDate": "2026-08-15" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "73.77 x 172.49 Feet" +"MainOfficeKey": "058300" +"MajorChangeTimestamp": "2026-04-16T16:15:29Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T16:15:29Z" +"OriginalListPrice": 3288000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3826232" +"ParcelNumber": "223920389" +"PhotosChangeTimestamp": "2026-04-16T16:15:29Z" +"Sewer": "None" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "282" +"StreetSuffix": "Street" +"TaxAnnualAmount": "30385.3" +"TaxLegalDescription": "Plan 496 Part Lot 31, City Of Waterloo" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Zoning": "Rmu-20 Residential Mixed-Use Zone" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 172.49 +"LotWidth": 73.77 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007430')" +"PictureYN": true +"SurveyType": "Available" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1W3, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"StreetSuffixCode": "St" +"BoardPropertyType": "Com" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-17T16:18:06Z" +"MLSAreaDistrictOldZone": "X11" +"MLSAreaMunicipalityDistrict": "Waterloo" +"SystemModificationTimestamp": "2026-04-17T16:18:06.692792Z" +"Media": array:3 [ …3] +"ID": "690356" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "665781" +post_author: 1 +"ListingKey": "X12963316" +"ListingId": "X12963316" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:15:52Z" +"RFModificationTimestamp": "2026-04-25T12:21:48Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2H 2G1" +"UnparsedAddress": "390 Dumfries Avenue, Waterloo, ON N2H 2G1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4523776 +"Longitude": -80.467378 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "NOT HOLDING OFFERS! Charming, Immaculate Brick Bungalow in Desirable Rosemount! Welcome to this lovingly maintained 3-bedroom, 2-bath brick bungalow nestled in the heart of the highly sought-after Rosemount neighbourhood. Meticulously cared for and truly move-in ready, this home offers incredible curb appeal with a welcoming front porch, professionally landscaped gardens, and hundreds of stunning roses creating a picturesque setting. The bright main level features beautiful hardwood flooring, custom window blinds throughout, and a thoughtfully updated kitchen (2019) complete with all appliances included. The spacious layout offers three well-appointed bedrooms, while the updated basement (2020) adds valuable additional living space, including a generous lower-level bedroom and a dedicated workshop - perfect for hobbyists, DIY enthusiasts, or additional storage. Enjoy the comfort of central vac and a luxurious upstairs bath featuring a relaxing Jacuzzi tub. Step outside to your private, fully fenced backyard oasis with a large deck, mature trees, and a shed with electricity-ideal for projects or extra storage. The detached garage and concrete driveway provide ample parking. Additional updates include furnace and A/C (2016. 10 years), Waymar windows (approx. 12 years), roof (approx. 20 years), and brand-new washer and dryer (2025). Situated on a generous 51.69 x 135.22 ft lot, this exceptional property is walkable to downtown Kitchener, surrounded by parks, trails, and green space, and conveniently located near shopping with easy access to the expressway. A rare opportunity in a prime location-don't miss it!" +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-24T22:52:44.207447+00:00" +"CrossStreet": "Krug St to Dumfries Ave" +"DirectionFaces": "East" +"Directions": "Krug St to Dumfries Ave" +"Exclusions": "Stand Up Freezer in Bsmt, Dyson vacuums x 3" +"ExpirationDate": "2026-07-07" +"ExteriorFeatures": "Awnings,Deck,Patio,Porch" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Central Vacuum,In-Law Capability,Primary Bedroom - Main Floor,Storage,Water Heater,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-07" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "549200" +"MajorChangeTimestamp": "2026-04-16T13:15:52Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-07T13:12:02Z" +"OriginalListPrice": 750000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3773178" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "225200016" +"ParkingFeatures": "Private,Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-08T18:55:19Z" +"PoolFeatures": "None" +"PreviousListPrice": 750000.0 +"PriceChangeTimestamp": "2026-04-16T13:15:52Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dumfries" +"StreetNumber": "390" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3799.0" +"TaxAssessedValue": 280000 +"TaxLegalDescription": "LT 177 PL 768 KITCHENER; KITCHENER" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/390-Dumfries-Ave" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/390-Dumfries-Ave/idx" +"WaterSource": array:1 [ …1] +"Zoning": "R2A" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 135.22 +"LotShape": "Rectangular" +"LotWidth": 51.6 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12963316')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301203001403200" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2H 2G1, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"MortgageComment": "TREAT AS CLEAR" +"RoomsAboveGrade": 3 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Showings via Supra online booking system or call listing office." +"WashroomsType1Level": "Main" +"MediaChangeTimestamp": "2026-04-08T18:55:19Z" +"SystemModificationTimestamp": "2026-04-16T13:16:03.949142Z" +"Media": array:45 [ …45] +"ID": "665781" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853 +post_id: "692717" +post_author: 1 +"ListingKey": "X13003178" +"ListingId": "X13003178" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T18:52:06Z" +"RFModificationTimestamp": "2026-04-29T10:47:23Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2B 2N2" +"UnparsedAddress": "120 Lorraine Avenue, Waterloo, ON N2B 2N2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4593114 +"Longitude": -80.444503 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "PEAK REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful bungalow with ensuite and attached garage! This well-maintained 3 bed, 3 bath home offers a bright, open-concept layout with hardwood floors and a functional kitchen with backsplash, corian countertops and appliances included which flows seamlessly into the sun-filled dining and living areas. A generous primary suite with a luxurious ensuite boasting heated floors, a walk-in shower, and double sinks. A second bedroom with a built-in Murphy bed (included), a 4-piece bath, and convenient main floor laundry complete the main level. The finished lower level adds great additional living space with a games room (pool table included), a cozy rec room with built-in gas fireplace, a third bedroom, and a full bathroom as well as storage and utility rooms. Step outside and enjoy a private backyard with patio, plus an attached garage with workshop space. Additional highlights include a steel roof, no rented equipment, and a fantastic location close to all amenities in a desirable neighbourhood. A move-in ready home you won't want to miss." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T08:06:56.720950+00:00" +"CrossStreet": "River Rd & Lackner Blvd" +"DirectionFaces": "East" +"Directions": "River RD to Lorraine" +"ExpirationDate": "2026-08-10" +"ExteriorFeatures": "Porch,Patio" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Auto Garage Door Remote,Primary Bedroom - Main Floor,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-10" +"MainOfficeKey": "232800" +"MajorChangeTimestamp": "2026-04-15T18:47:19Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T18:47:19Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3821810" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "225400026" +"ParkingFeatures": "Private Double" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-15T18:47:20Z" +"PoolFeatures": "None" +"Roof": "Metal,Shingles" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lorraine" +"StreetNumber": "120" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4327.74" +"TaxAssessedValue": 319000 +"TaxLegalDescription": "PLAN 1177 LOT 5" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/120_lorraine_ave_kitchener_on/" +"Zoning": "RES-2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotShape": "Rectangular" +"LotWidth": 55.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13003178')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301203002217400" +"SurveyType": "Unknown" +"RentalItems": "NONE" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2B 2N2, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 12 +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-15T18:47:20Z" +"SystemModificationTimestamp": "2026-04-15T18:52:16.722148Z" +"Media": array:40 [ …40] +"ID": "692717" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "701413" +post_author: 1 +"ListingKey": "X13002302" +"ListingId": "X13002302" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T16:47:16Z" +"RFModificationTimestamp": "2026-04-29T12:33:28Z" +"ListPrice": 385000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2G 0C3" +"UnparsedAddress": "100 Garment Street 216, Waterloo, ON N2G 0C3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4504001 +"Longitude": -80.5010657 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step into LOFT-STYLE LIVING in the vibrant heart of downtown Kitchener, where STYLE, SPACE, AND CONVENIENCE come together in this beautifully designed 900+ sq. ft. condo. From the moment you enter, you're greeted by SOARING 13-FOOT CEILINGS and EXPANSIVE FLOOR-TO-CEILING WINDOWS that flood the space with natural light. The result is a BRIGHT, AIRY, AND MODERN RETREAT that feels both spacious and inviting-perfect for relaxing or entertaining. The thoughtfully designed layout offers WIDER HALLWAYS and a WHEELCHAIR-ACCESSIBLE WASHROOM, blending COMFORT WITH PRACTICALITY. You'll also love the ABUNDANT STORAGE, featuring four closets, including a GENEROUS WALK-IN CLOSET that makes staying organized effortless, and can also be used as an in-suite locker. Step outside and embrace a TRUE URBAN LIFESTYLE. Enjoy being just steps from TRENDY RESTAURANTS, CAFÉS, PARKS, AND YEAR-ROUND EVENTS-everything you love about downtown living, right at your doorstep. Commuting is seamless with EASY ACCESS TO THE LRT, GO TRAIN, AND FUTURE TRANSIT HUB, making this an ideal home base for busy professionals. Inside the building, convenience continues. Enjoy having the FITNESS AND THEATRE ROOMS ONYOUR FLOOR, while the PROFESSIONAL CO-WORKING SPACE-complete with private offices, meeting rooms, and a full kitchen-offers the perfect setup for working from home or hosting clients. When it's time to unwind, head up to the ROOFTOP PATIO WITH BBQs, where you can relax, entertain, and take in the city atmosphere. This unit also includes UNDERGROUND PARKING WITH EV CHARGING AVAILABLE, and the condo fees cover INTERNET, HEATING, WATER, AND MORE-providing EFFORTLESS, almost ALL-INCLUSIVE LIVING with predictable monthly costs. MODERN, SPACIOUS, AND PERFECTLY LOCATED - THIS IS THE LIFESTYLE YOU'VE BEEN WAITING FOR." +"ArchitecturalStyle": "Apartment" +"AssociationFee": "702.79" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-25T01:33:21.125067+00:00" +"CrossStreet": "Victoria St/ King St." +"Directions": "Victoria St between King St and Park St." +"Exclusions": "Owner's belongings" +"ExpirationDate": "2026-08-31" +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": "Wheelchair Access" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-14" +"LotSizeSource": "MPAC" +"MainOfficeKey": "356100" +"MajorChangeTimestamp": "2026-04-15T16:47:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-15T16:47:16Z" +"OriginalListPrice": 385000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3804134" +"ParcelNumber": "236700021" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T16:47:16Z" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Garment" +"StreetNumber": "100" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3988.58" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "216" +"VirtualTourURLBranded": "https://youriguide.com/216_100_garment_st_kitchener_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/216_100_garment_st_kitchener_on/" +"Zoning": "M2" +"DDFYN": true +"Locker": "Ensuite" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13002302')" +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301205000814030" +"SurveyType": "None" +"BalconyType": "None" +"RentalItems": "None" +"HoldoverDays": 30 +"LegalStories": "2" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2G 0C3, CA" +"ApproximateAge": "11-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 670 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"SquareFootSource": "915" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please use Showing Time or book your showing by calling 519-578-7300" +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "16" +"MediaChangeTimestamp": "2026-04-15T16:47:16Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-15T16:47:17.119618Z" +"Media": array:43 [ …43] +"ID": "701413" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "684014" +post_author: 1 +"ListingKey": "X12999624" +"ListingId": "X12999624" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T11:04:26Z" +"RFModificationTimestamp": "2026-04-29T12:33:25Z" +"ListPrice": 2695.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 1Z2" +"UnparsedAddress": "255 Northlake Drive 6, Waterloo, ON N2V 1Z2" +"Coordinates": array:2 [ …2] +"Latitude": 43.49715 +"Longitude": -80.55196 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Looking for a home that checks every box? This vibrant townhouse delivers comfort, convenience, and style all in one package. Enjoy 1,600+ sq. ft. of thoughtfully finished living space. The bright, spacious kitchen offers generous cabinetry and counter space, perfect for cooking and entertaining. A convenient main-floor powder room and an oversized front entry closet add everyday practicality. The open-concept living and dining area is ideal for hosting or relaxing, with direct access to your own private deck. Upstairs, you'll find three comfortable bedrooms along with a well-appointed 4-piece bathroom, perfect for families or those needing extra space for a home office or guests. The fully finished basement adds even more living space, complete with a gas fireplace. There's no shortage of storage, thanks to roomy closets and a largw laundry/utility area. Enjoy the bonus of private tandem parking for two under a carport, plus plenty of visitor parking. Commuting is a breeze with quick highway access. You're just minutes from St. Jacobs Market, Conestoga Mall, and the Ion train station. Daily essentials like groceries, banking, fitness, dining, and public transit are practically at your doorstep." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CoListOfficeName": "e Xp Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-25T03:54:24.491332+00:00" +"CrossStreet": "Northfield Dr W & Weber St N" +"Directions": "Northfield Dr W & Weber St N to Skylard Rd to Northlake Dr" +"ExpirationDate": "2026-07-17" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": "Water Softener,Water Heater" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2026-04-15T11:04:26Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T11:04:26Z" +"OriginalListPrice": 2695.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3801604" +"ParcelNumber": "231670006" +"ParkingFeatures": "Covered,Tandem" +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T11:04:26Z" +"RentIncludes": array:4 [ …4] +"Roof": "Asphalt Shingle" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Northlake" +"StreetNumber": "255" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "1/2 Month Rent +HST" +"TransactionType": "For Lease" +"UnitNumber": "6" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12999624')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604330333506" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 30 +"LegalStories": "1" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 1Z2, CA" +"ContractStatus": "Available" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 167 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 2 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "Please book all showings via Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2026-04-15T11:04:26Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Mill Creek Management" +"SystemModificationTimestamp": "2026-04-15T11:04:26.196208Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] +"ID": "684014" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "684890" +post_author: 1 +"ListingKey": "X12934384" +"ListingId": "X12934384" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T01:35:31Z" +"RFModificationTimestamp": "2026-04-29T12:32:35Z" +"ListPrice": 674900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2G9" +"UnparsedAddress": "524 Beechwood Drive 10, Waterloo, ON N2T 2G9" +"Coordinates": array:2 [ …2] +"Latitude": 43.450904 +"Longitude": -80.562117 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful end unit in a prime, private location within Waterloo's Beechwood community. This well-maintained executive townhome offers 2,337 sqft of finished living space, featuring a fully fenced yard and a beautiful private garden. This secluded sanctuary is perfect for families and privacy. Enjoy immediate access to Mc Crae Park and the scenic forest trails of the Beechwood South trail system. The interior offers 2 oversized bedrooms and 3 bathrooms, including a primary suite with heated floors, a soaker tub, and dual vanities. The main floor features a modern white shaker kitchen with granite counters, a pantry, and soft-close cabinetry. A rare double car garage and double driveway provide parking for 4 vehicles. Enjoy a low-maintenance lifestyle as condo fees include water, snow removal, and exterior maintenance. Complete with a fully finished basement, private patio, and exclusive resident-only pool access. This freshly painted home is steps from top-tier schools and premium amenities." +"ArchitecturalStyle": "2-Storey" +"AssociationAmenities": array:3 [ …3] +"AssociationFee": "785.0" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:2 [ …2] +"CoListOfficeName": "RIGHT AT HOME REALTY" +"CoListOfficePhone": "905-565-9200" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T10:02:12.104940+00:00" +"CrossStreet": "Erb St. W & Erbsville Road / Fisher-Hallman Road & Erb St. W" +"Directions": "FROM FISCHER HALLMAN, TURN ONTO BEECHWOOD DRIVE AND THIS COMPLEX WILL BE ON YOUR RIGHT HAND SIDE" +"Exclusions": "Curtains in Main Floor, Furniture, Artworks, Mirrors and other personal belongings" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": "Landscaped,Patio" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Refrigerator in the basement" +"InteriorFeatures": "Auto Garage Door Remote,Water Heater,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2026-04-15T01:35:31Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T13:39:32Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3735900" +"ParcelNumber": "231360010" +"ParkingFeatures": "Private" +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T13:39:33Z" +"PreviousListPrice": 599900.0 +"PriceChangeTimestamp": "2026-04-15T01:35:31Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Beechwood" +"StreetNumber": "524" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "3795.0" +"TaxAssessedValue": 277000 +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "10" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/10_524_beechwood_dr_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/10_524_beechwood_dr_waterloo_on/" +"Zoning": "MD" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12934384')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301604051503210" +"SurveyType": "Unknown" +"BalconyType": "None" +"RentalItems": "Air Conditioner, Furnace, Hot Water Heater (Furnace and A/C will be paid off)" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"LegalStories": "1" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:3 [ …3] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2T 2G9, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 136 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1600-1799" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 2 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "[WFH] A man is working at home (2nd floor room). Please don't bother and surprise. Please allow 2 hours notice for showings. Please remove shoes & ensure door is locked before leaving. Please leave lights on. Lockbox is on the main entrance door." +"StatusCertificateYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"LegalApartmentNumber": "10" +"MediaChangeTimestamp": "2026-04-15T01:35:24Z" +"PropertyManagementCompany": "Harbour Concepts Inc" +"SystemModificationTimestamp": "2026-04-15T01:35:38.291067Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] +"ID": "684890" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "692117" +post_author: 1 +"ListingKey": "X12998926" +"ListingId": "X12998926" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-14T23:29:48Z" +"RFModificationTimestamp": "2026-04-30T02:16:25Z" +"ListPrice": 1064900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0G1" +"UnparsedAddress": "643 Wild Rye Street, Waterloo, ON N2V 0G1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4594367 +"Longitude": -80.6002261 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Vista Hills! Steps from scenic walking and cycling trails surrounded by forested greenbelt. Easy access to Vista Hills Public School along with other highly rated schools in the area, not to mention nearby world-renowned universities. Close to "The Boardwalk" shopping centre and medical centre, Costco, Movati, endless restaurants, and public transit. Striking curb appeal for this "Summerpeak" model built in 2019. Style and sophistication, with premium upgrades and design for perfect family living. The open-concept main floor-with 9 ft ceilings and the perfect blend of tile and engineered hardwood flooring, California shutters, and pot lighting-is surpassed by a stunning chef's delight kitchen. The kitchen features endless sleek white cabinetry and quartz counters along with a beautiful backsplash, under-cabinet lighting, a stylish range hood, stainless appliances, and a massive pendant-lit island with a breakfast bar. The spacious dining and living area can accommodate the largest of family gatherings and is perfect for entertaining. The upgraded 8 ft patio door with transoms leads to a fully fenced yard and patio where you can watch the kids play. The rest of the main floor includes a two-piece powder room and a convenient mudroom/laundry room. The upper level is highlighted by a primary bedroom suite with a luxury ensuite bathroom, which features an expansive quartz-topped vanity with double sinks, a walk-in glass shower, and a walk-in closet with organizers; you can even enjoy morning coffee on the balcony. The rest of the upper level consists of a main four-piece bath with a separate water closet and tub/shower area, and two great-sized bedrooms, one with a huge walk-in closet. There's also an upper-level family room which gives multiple use options, including a home office, den, or playroom for the kids. The wide-open basement, with a bathroom rough-in, awaits your future living needs. An EV charger is also included. Note: some photos are virtually staged." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-25T04:36:31.474206+00:00" +"CrossStreet": "Wood Lily" +"DirectionFaces": "East" +"Directions": "Sundew to Wood Lily to Wild Rye" +"Exclusions": "None" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": "Deck" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, EV car charger" +"InteriorFeatures": "Auto Garage Door Remote" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-14" +"MainOfficeKey": "356100" +"MajorChangeTimestamp": "2026-04-14T23:29:48Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-14T23:29:48Z" +"OriginalListPrice": 1064900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3813268" +"ParcelNumber": "226845142" +"ParkingFeatures": "Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-14T23:29:48Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Wild Rye" +"StreetNumber": "643" +"StreetSuffix": "Street" +"TaxAnnualAmount": "7278.0" +"TaxAssessedValue": 533000 +"TaxLegalDescription": "PLAN 58M601 LOT 107" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% of the sale price plus HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/643_wild_rye_st_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/643_wild_rye_st_waterloo_on/" +"Zoning": "NR" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 99.25 +"LotWidth": 36.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12998926')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301604000118120" +"SurveyType": "None" +"RentalItems": "HWT-Gas, Water Softener" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0G1, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 8 +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-04-14T23:29:48Z" +"SystemModificationTimestamp": "2026-04-14T23:29:48.739629Z" +"Media": array:45 [ …45] +"ID": "692117" } ] +success: true +page_size: 10 +page_count: 28 +count: 276 +after_key: "" } "RF Response Time" => "0.32 seconds" ] "RF Cache Key: eb1a4763fa37a60f3d850de55c109d30ea173c307ed5014af21de517234d4111" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3075 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4279 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13008360" +"ListingId": "X13008360" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T18:04:14Z" +"RFModificationTimestamp": "2026-04-30T05:01:47Z" +"ListPrice": 2045.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N1S 2M8" +"UnparsedAddress": "30 George Street S 208, Waterloo, ON N1S 2M8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "PEAK REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 30 George St. S, situated perfectly in the Gaslight District of Cambridge, steps away from Historical Old Galt, The Grand River & all amenities! Stylish, open concept unit with over 650 square feet of living space, with luxury vinyl planks, quartz countertops, in-suite laundry and a 300 square foot terrace. Features included in rent are one parking spot, water, heat, A/C, secure bike storage and 24/7 building security monitoring. This fantastic location in The West Galt neighbourhood is a perfect blend of modern and historic, with industrial buildings converted into chic spaces that house some of the most charming local businesses in Waterloo Region; it's easy to see why this is considered the Heart of Cambridge. The building is within walking distance to the Gaslight District, supermarkets, library, lush parks, bakeries, coffee shops, restaurants, a fitness center, public transit, schools and much more. Book your showing before these units are leased!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T04:43:25.897353+00:00" +"CrossStreet": "St. Andrews" +"Directions": "Fountain to Blair to George" +"ExpirationDate": "2026-07-31" +"Furnished": "Unfurnished" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "232800" +"MajorChangeTimestamp": "2026-04-16T18:04:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T18:04:14Z" +"OriginalListPrice": 2045.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3823496" +"ParcelNumber": "038060478" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T18:04:14Z" +"RentIncludes": array:10 [ …10] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "George" +"StreetNumber": "30" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Month" +"TransactionType": "For Lease" +"UnitNumber": "208" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13008360')" +"GarageType": "Carport" +"HeatSource": "Electric" +"RollNumber": "300604004503000" +"SurveyType": "Unknown" +"BalconyType": "Terrace" +"LegalStories": "2" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N1S 2M8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"LotSizeAreaUnits": "Square Feet" +"PaymentFrequency": "Monthly" +"SquareFootSource": "Builder" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "Please use street parking for showings. Lockbox located in the carport at the Bike Storage. Buzz 500 or 600 for building access." +"LegalApartmentNumber": "208" +"MediaChangeTimestamp": "2026-04-16T18:04:14Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "DNK Development Corp." +"SystemModificationTimestamp": "2026-04-16T18:04:14.727537Z" +"Media": array:21 [ …21] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4280 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13007864" +"ListingId": "X13007864" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T17:04:34Z" +"RFModificationTimestamp": "2026-04-30T05:01:46Z" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 1K9" +"UnparsedAddress": "132 Bridge Street W, Waterloo, ON N2K 1K9" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Large 55x187 Foot Lot with Detached Double car plus garage/workshop along with 3 bed, 2 bath house. If you have been looking for a project, this is the Handyman special for you. Please note that property is being sold 'As is, where is". Please note garage photo is an older photo, provided to show size of garage only." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T05:02:18.544706+00:00" +"CrossStreet": "University" +"DirectionFaces": "West" +"Directions": "University to Bridge" +"ExpirationDate": "2026-07-16" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-04-16T17:04:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T17:04:34Z" +"OriginalListPrice": 499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3827010" +"ParcelNumber": "222990019" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2026-04-16T17:04:34Z" +"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": "W" +"StreetName": "Bridge" +"StreetNumber": "132" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4747.2" +"TaxAssessedValue": 333000 +"TaxLegalDescription": "PLAN 256 PT LOTS 20 & 21" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 187.0 +"LotWidth": 55.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007864')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301601040000320" +"SurveyType": "None" +"HoldoverDays": 180 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 1K9, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-04-16T17:04:34Z" +"SystemModificationTimestamp": "2026-04-16T17:04:34.420775Z" +"Media": array:4 [ …4] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4283 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12759028" +"ListingId": "X12759028" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T16:44:37Z" +"RFModificationTimestamp": "2026-04-30T05:00:27Z" +"ListPrice": 485000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 6J5" +"UnparsedAddress": "250 Keats Way 24, Waterloo, ON N2L 6J5" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "***Welcome to Unit 24 at 250 Keats Way***This beautifully maintained 3 bedrooms, 2.5 bathrooms townhome offers over 1,300 square feet of bright, functional living space on main and second floors, in one of Waterloo's most sought-after neighborhoods. The main floor welcomes you with an inviting eat-in kitchen and a spacious living room centered around a cozy gas fireplace, perfect for relaxing evenings. Step through the sliding glass doors onto your private elevated deck, an ideal spot for morning coffee overlooking the mature greenery. Upstairs, you'll find three generous bedrooms, including a primary suite with a cheater ensuite access to a modern 5-piece bathroom. The standout feature is the fully finished walkout basement, providing seamless access to a private lower patio. Whether you're looking for a peaceful family home or a high-performing investment near the University of Waterloo and Wilfrid Laurier, this turn-key property delivers. With an attached garage, and a location minutes from T&T Supermarket and Waterloo Park, this is an opportunity you don't want to miss." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:2 [ …2] +"AssociationFee": "720.0" +"AssociationFeeIncludes": array:3 [ …3] +"Basement": array:3 [ …3] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T05:09:54.160048+00:00" +"CrossStreet": "University Ave. W." +"Directions": "University Ave. W. to Keats Way" +"ExpirationDate": "2026-04-30" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-04" +"MainOfficeKey": "399200" +"MajorChangeTimestamp": "2026-02-04T19:58:02Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-04T19:58:02Z" +"OriginalListPrice": 485000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3518778" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-16T16:44:37Z" +"Roof": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Keats" +"StreetNumber": "250" +"StreetSuffix": "Way" +"TaxAnnualAmount": "4151.2" +"TaxAssessedValue": 304000 +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"UnitNumber": "24" +"VirtualTourURLBranded": "https://youriguide.com/unit_24_250_keats_way_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/unit_24_250_keats_way_waterloo_on/" +"Zoning": "R8" +"DDFYN": true +"Locker": "None" +"Exposure": "South East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12759028')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Hot water heater." +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 6J5, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 180 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:3 [ …3] +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "PLEASE REMOVE SHOES, LEAVE A BUSINESS CARD, TURN OFF LIGHTS AND LOCK DOORS." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "24" +"MediaChangeTimestamp": "2026-04-16T16:44:37Z" +"PropertyManagementCompany": "WILSON BLANCHARD" +"SystemModificationTimestamp": "2026-04-16T16:44:46.156536Z" +"Media": array:45 [ …45] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4282 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13007430" +"ListingId": "X13007430" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T16:15:29Z" +"RFModificationTimestamp": "2026-04-25T09:22:01Z" +"ListPrice": 3288000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1W3" +"UnparsedAddress": "282 Erb Street W, Waterloo, ON N2L 1W3" +"Coordinates": array:2 [ …2] +"Latitude": 43.457355 +"Longitude": -80.540799 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK YORK GROUP REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Previously approved site plan for a 35-unit rental/condominium development, zoned RMU-20 (Residential Mixed Use)-a compelling opportunity tailored for small to mid-sized developers targeting a proven, high-demand rental corridor.Positioned just steps from the University of Waterloo and Wilfrid Laurier University, the property is ideally suited for student housing as well as potential senior/retirement-oriented rental concepts. The location offers consistent, year-round rental demand driven by a strong academic and local community base. Walking distance to both campuses, combined with a direct bus stop at the doorstep, ensures exceptional accessibility and enduring tenant appeal.Offered at land value with existing building permits in place (subject to amendment for updated plans), this is a rare, near shovel-ready development opportunity-allowing investors to accelerate timelines and unlock value with minimal upfront entitlement risk." +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-24T21:23:28.597461+00:00" +"CrossStreet": "University" +"DirectionFaces": "South" +"Directions": "Driving through Bridgeport Rd E to Erb St. W" +"ExpirationDate": "2026-08-15" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-16" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "73.77 x 172.49 Feet" +"MainOfficeKey": "058300" +"MajorChangeTimestamp": "2026-04-16T16:15:29Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-16T16:15:29Z" +"OriginalListPrice": 3288000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3826232" +"ParcelNumber": "223920389" +"PhotosChangeTimestamp": "2026-04-16T16:15:29Z" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "282" +"StreetSuffix": "Street" +"TaxAnnualAmount": "30385.3" +"TaxLegalDescription": "Plan 496 Part Lot 31, City Of Waterloo" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Zoning": "Rmu-20 Residential Mixed-Use Zone" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 172.49 +"LotWidth": 73.77 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007430')" +"PictureYN": true +"SurveyType": "Available" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 90 +"TelephoneYNA": "Available" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1W3, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"StreetSuffixCode": "St" +"BoardPropertyType": "Com" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-17T16:18:06Z" +"MLSAreaDistrictOldZone": "X11" +"MLSAreaMunicipalityDistrict": "Waterloo" +"SystemModificationTimestamp": "2026-04-17T16:18:06.692792Z" +"Media": array:3 [ …3] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4281 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12963316" +"ListingId": "X12963316" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T13:15:52Z" +"RFModificationTimestamp": "2026-04-25T12:21:48Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2H 2G1" +"UnparsedAddress": "390 Dumfries Avenue, Waterloo, ON N2H 2G1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4523776 +"Longitude": -80.467378 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "NOT HOLDING OFFERS! Charming, Immaculate Brick Bungalow in Desirable Rosemount! Welcome to this lovingly maintained 3-bedroom, 2-bath brick bungalow nestled in the heart of the highly sought-after Rosemount neighbourhood. Meticulously cared for and truly move-in ready, this home offers incredible curb appeal with a welcoming front porch, professionally landscaped gardens, and hundreds of stunning roses creating a picturesque setting. The bright main level features beautiful hardwood flooring, custom window blinds throughout, and a thoughtfully updated kitchen (2019) complete with all appliances included. The spacious layout offers three well-appointed bedrooms, while the updated basement (2020) adds valuable additional living space, including a generous lower-level bedroom and a dedicated workshop - perfect for hobbyists, DIY enthusiasts, or additional storage. Enjoy the comfort of central vac and a luxurious upstairs bath featuring a relaxing Jacuzzi tub. Step outside to your private, fully fenced backyard oasis with a large deck, mature trees, and a shed with electricity-ideal for projects or extra storage. The detached garage and concrete driveway provide ample parking. Additional updates include furnace and A/C (2016. 10 years), Waymar windows (approx. 12 years), roof (approx. 20 years), and brand-new washer and dryer (2025). Situated on a generous 51.69 x 135.22 ft lot, this exceptional property is walkable to downtown Kitchener, surrounded by parks, trails, and green space, and conveniently located near shopping with easy access to the expressway. A rare opportunity in a prime location-don't miss it!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-24T22:52:44.207447+00:00" +"CrossStreet": "Krug St to Dumfries Ave" +"DirectionFaces": "East" +"Directions": "Krug St to Dumfries Ave" +"Exclusions": "Stand Up Freezer in Bsmt, Dyson vacuums x 3" +"ExpirationDate": "2026-07-07" +"ExteriorFeatures": array:4 [ …4] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-07" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "549200" +"MajorChangeTimestamp": "2026-04-16T13:15:52Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-07T13:12:02Z" +"OriginalListPrice": 750000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3773178" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "225200016" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-08T18:55:19Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 750000.0 +"PriceChangeTimestamp": "2026-04-16T13:15:52Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Dumfries" +"StreetNumber": "390" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3799.0" +"TaxAssessedValue": 280000 +"TaxLegalDescription": "LT 177 PL 768 KITCHENER; KITCHENER" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/390-Dumfries-Ave" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/390-Dumfries-Ave/idx" +"WaterSource": array:1 [ …1] +"Zoning": "R2A" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 135.22 +"LotShape": "Rectangular" +"LotWidth": 51.6 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12963316')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301203001403200" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "Fully" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2H 2G1, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"MortgageComment": "TREAT AS CLEAR" +"RoomsAboveGrade": 3 +"RoomsBelowGrade": 4 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Showings via Supra online booking system or call listing office." +"WashroomsType1Level": "Main" +"MediaChangeTimestamp": "2026-04-08T18:55:19Z" +"SystemModificationTimestamp": "2026-04-16T13:16:03.949142Z" +"Media": array:45 [ …45] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4278 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13003178" +"ListingId": "X13003178" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T18:52:06Z" +"RFModificationTimestamp": "2026-04-29T10:47:23Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2B 2N2" +"UnparsedAddress": "120 Lorraine Avenue, Waterloo, ON N2B 2N2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4593114 +"Longitude": -80.444503 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "PEAK REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful bungalow with ensuite and attached garage! This well-maintained 3 bed, 3 bath home offers a bright, open-concept layout with hardwood floors and a functional kitchen with backsplash, corian countertops and appliances included which flows seamlessly into the sun-filled dining and living areas. A generous primary suite with a luxurious ensuite boasting heated floors, a walk-in shower, and double sinks. A second bedroom with a built-in Murphy bed (included), a 4-piece bath, and convenient main floor laundry complete the main level. The finished lower level adds great additional living space with a games room (pool table included), a cozy rec room with built-in gas fireplace, a third bedroom, and a full bathroom as well as storage and utility rooms. Step outside and enjoy a private backyard with patio, plus an attached garage with workshop space. Additional highlights include a steel roof, no rented equipment, and a fantastic location close to all amenities in a desirable neighbourhood. A move-in ready home you won't want to miss." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T08:06:56.720950+00:00" +"CrossStreet": "River Rd & Lackner Blvd" +"DirectionFaces": "East" +"Directions": "River RD to Lorraine" +"ExpirationDate": "2026-08-10" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-10" +"MainOfficeKey": "232800" +"MajorChangeTimestamp": "2026-04-15T18:47:19Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T18:47:19Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3821810" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "225400026" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-15T18:47:20Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lorraine" +"StreetNumber": "120" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4327.74" +"TaxAssessedValue": 319000 +"TaxLegalDescription": "PLAN 1177 LOT 5" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/120_lorraine_ave_kitchener_on/" +"Zoning": "RES-2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotShape": "Rectangular" +"LotWidth": 55.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13003178')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301203002217400" +"SurveyType": "Unknown" +"RentalItems": "NONE" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2B 2N2, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 12 +"PropertyFeatures": array:5 [ …5] +"PossessionDetails": "flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-15T18:47:20Z" +"SystemModificationTimestamp": "2026-04-15T18:52:16.722148Z" +"Media": array:40 [ …40] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4277 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13002302" +"ListingId": "X13002302" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T16:47:16Z" +"RFModificationTimestamp": "2026-04-29T12:33:28Z" +"ListPrice": 385000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2G 0C3" +"UnparsedAddress": "100 Garment Street 216, Waterloo, ON N2G 0C3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4504001 +"Longitude": -80.5010657 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Step into LOFT-STYLE LIVING in the vibrant heart of downtown Kitchener, where STYLE, SPACE, AND CONVENIENCE come together in this beautifully designed 900+ sq. ft. condo. From the moment you enter, you're greeted by SOARING 13-FOOT CEILINGS and EXPANSIVE FLOOR-TO-CEILING WINDOWS that flood the space with natural light. The result is a BRIGHT, AIRY, AND MODERN RETREAT that feels both spacious and inviting-perfect for relaxing or entertaining. The thoughtfully designed layout offers WIDER HALLWAYS and a WHEELCHAIR-ACCESSIBLE WASHROOM, blending COMFORT WITH PRACTICALITY. You'll also love the ABUNDANT STORAGE, featuring four closets, including a GENEROUS WALK-IN CLOSET that makes staying organized effortless, and can also be used as an in-suite locker. Step outside and embrace a TRUE URBAN LIFESTYLE. Enjoy being just steps from TRENDY RESTAURANTS, CAFÉS, PARKS, AND YEAR-ROUND EVENTS-everything you love about downtown living, right at your doorstep. Commuting is seamless with EASY ACCESS TO THE LRT, GO TRAIN, AND FUTURE TRANSIT HUB, making this an ideal home base for busy professionals. Inside the building, convenience continues. Enjoy having the FITNESS AND THEATRE ROOMS ONYOUR FLOOR, while the PROFESSIONAL CO-WORKING SPACE-complete with private offices, meeting rooms, and a full kitchen-offers the perfect setup for working from home or hosting clients. When it's time to unwind, head up to the ROOFTOP PATIO WITH BBQs, where you can relax, entertain, and take in the city atmosphere. This unit also includes UNDERGROUND PARKING WITH EV CHARGING AVAILABLE, and the condo fees cover INTERNET, HEATING, WATER, AND MORE-providing EFFORTLESS, almost ALL-INCLUSIVE LIVING with predictable monthly costs. MODERN, SPACIOUS, AND PERFECTLY LOCATED - THIS IS THE LIFESTYLE YOU'VE BEEN WAITING FOR." +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "702.79" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-25T01:33:21.125067+00:00" +"CrossStreet": "Victoria St/ King St." +"Directions": "Victoria St between King St and Park St." +"Exclusions": "Owner's belongings" +"ExpirationDate": "2026-08-31" +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-14" +"LotSizeSource": "MPAC" +"MainOfficeKey": "356100" +"MajorChangeTimestamp": "2026-04-15T16:47:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-15T16:47:16Z" +"OriginalListPrice": 385000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3804134" +"ParcelNumber": "236700021" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T16:47:16Z" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Garment" +"StreetNumber": "100" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3988.58" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "216" +"VirtualTourURLBranded": "https://youriguide.com/216_100_garment_st_kitchener_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/216_100_garment_st_kitchener_on/" +"Zoning": "M2" +"DDFYN": true +"Locker": "Ensuite" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13002302')" +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301205000814030" +"SurveyType": "None" +"BalconyType": "None" +"RentalItems": "None" +"HoldoverDays": 30 +"LegalStories": "2" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2G 0C3, CA" +"ApproximateAge": "11-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 670 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"SquareFootSource": "915" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Please use Showing Time or book your showing by calling 519-578-7300" +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "16" +"MediaChangeTimestamp": "2026-04-15T16:47:16Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-15T16:47:17.119618Z" +"Media": array:43 [ …43] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4276 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12999624" +"ListingId": "X12999624" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T11:04:26Z" +"RFModificationTimestamp": "2026-04-29T12:33:25Z" +"ListPrice": 2695.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 1Z2" +"UnparsedAddress": "255 Northlake Drive 6, Waterloo, ON N2V 1Z2" +"Coordinates": array:2 [ …2] +"Latitude": 43.49715 +"Longitude": -80.55196 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Looking for a home that checks every box? This vibrant townhouse delivers comfort, convenience, and style all in one package. Enjoy 1,600+ sq. ft. of thoughtfully finished living space. The bright, spacious kitchen offers generous cabinetry and counter space, perfect for cooking and entertaining. A convenient main-floor powder room and an oversized front entry closet add everyday practicality. The open-concept living and dining area is ideal for hosting or relaxing, with direct access to your own private deck. Upstairs, you'll find three comfortable bedrooms along with a well-appointed 4-piece bathroom, perfect for families or those needing extra space for a home office or guests. The fully finished basement adds even more living space, complete with a gas fireplace. There's no shortage of storage, thanks to roomy closets and a largw laundry/utility area. Enjoy the bonus of private tandem parking for two under a carport, plus plenty of visitor parking. Commuting is a breeze with quick highway access. You're just minutes from St. Jacobs Market, Conestoga Mall, and the Ion train station. Daily essentials like groceries, banking, fitness, dining, and public transit are practically at your doorstep." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CoListOfficeName": "e Xp Realty" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-25T03:54:24.491332+00:00" +"CrossStreet": "Northfield Dr W & Weber St N" +"Directions": "Northfield Dr W & Weber St N to Skylard Rd to Northlake Dr" +"ExpirationDate": "2026-07-17" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2026-04-15T11:04:26Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-15T11:04:26Z" +"OriginalListPrice": 2695.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3801604" +"ParcelNumber": "231670006" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-15T11:04:26Z" +"RentIncludes": array:4 [ …4] +"Roof": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Northlake" +"StreetNumber": "255" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "1/2 Month Rent +HST" +"TransactionType": "For Lease" +"UnitNumber": "6" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12999624')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604330333506" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 30 +"LegalStories": "1" +"ParkingType1": "Exclusive" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 1Z2, CA" +"ContractStatus": "Available" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 167 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 2 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ShowingAppointments": "Please book all showings via Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2026-04-15T11:04:26Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Mill Creek Management" +"SystemModificationTimestamp": "2026-04-15T11:04:26.196208Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4275 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12934384" +"ListingId": "X12934384" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T01:35:31Z" +"RFModificationTimestamp": "2026-04-29T12:32:35Z" +"ListPrice": 674900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2G9" +"UnparsedAddress": "524 Beechwood Drive 10, Waterloo, ON N2T 2G9" +"Coordinates": array:2 [ …2] +"Latitude": 43.450904 +"Longitude": -80.562117 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful end unit in a prime, private location within Waterloo's Beechwood community. This well-maintained executive townhome offers 2,337 sqft of finished living space, featuring a fully fenced yard and a beautiful private garden. This secluded sanctuary is perfect for families and privacy. Enjoy immediate access to Mc Crae Park and the scenic forest trails of the Beechwood South trail system. The interior offers 2 oversized bedrooms and 3 bathrooms, including a primary suite with heated floors, a soaker tub, and dual vanities. The main floor features a modern white shaker kitchen with granite counters, a pantry, and soft-close cabinetry. A rare double car garage and double driveway provide parking for 4 vehicles. Enjoy a low-maintenance lifestyle as condo fees include water, snow removal, and exterior maintenance. Complete with a fully finished basement, private patio, and exclusive resident-only pool access. This freshly painted home is steps from top-tier schools and premium amenities." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:3 [ …3] +"AssociationFee": "785.0" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:2 [ …2] +"CoListOfficeName": "RIGHT AT HOME REALTY" +"CoListOfficePhone": "905-565-9200" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T10:02:12.104940+00:00" +"CrossStreet": "Erb St. W & Erbsville Road / Fisher-Hallman Road & Erb St. W" +"Directions": "FROM FISCHER HALLMAN, TURN ONTO BEECHWOOD DRIVE AND THIS COMPLEX WILL BE ON YOUR RIGHT HAND SIDE" +"Exclusions": "Curtains in Main Floor, Furniture, Artworks, Mirrors and other personal belongings" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Refrigerator in the basement" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2026-04-15T01:35:31Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T13:39:32Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3735900" +"ParcelNumber": "231360010" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T13:39:33Z" +"PreviousListPrice": 599900.0 +"PriceChangeTimestamp": "2026-04-15T01:35:31Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Beechwood" +"StreetNumber": "524" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "3795.0" +"TaxAssessedValue": 277000 +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "10" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/10_524_beechwood_dr_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/10_524_beechwood_dr_waterloo_on/" +"Zoning": "MD" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12934384')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301604051503210" +"SurveyType": "Unknown" +"BalconyType": "None" +"RentalItems": "Air Conditioner, Furnace, Hot Water Heater (Furnace and A/C will be paid off)" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"LegalStories": "1" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:3 [ …3] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2T 2G9, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 136 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1600-1799" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 2 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "MPAC" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "[WFH] A man is working at home (2nd floor room). Please don't bother and surprise. Please allow 2 hours notice for showings. Please remove shoes & ensure door is locked before leaving. Please leave lights on. Lockbox is on the main entrance door." +"StatusCertificateYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"LegalApartmentNumber": "10" +"MediaChangeTimestamp": "2026-04-15T01:35:24Z" +"PropertyManagementCompany": "Harbour Concepts Inc" +"SystemModificationTimestamp": "2026-04-15T01:35:38.291067Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4274 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12998926" +"ListingId": "X12998926" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-14T23:29:48Z" +"RFModificationTimestamp": "2026-04-30T02:16:25Z" +"ListPrice": 1064900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0G1" +"UnparsedAddress": "643 Wild Rye Street, Waterloo, ON N2V 0G1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4594367 +"Longitude": -80.6002261 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Vista Hills! Steps from scenic walking and cycling trails surrounded by forested greenbelt. Easy access to Vista Hills Public School along with other highly rated schools in the area, not to mention nearby world-renowned universities. Close to "The Boardwalk" shopping centre and medical centre, Costco, Movati, endless restaurants, and public transit. Striking curb appeal for this "Summerpeak" model built in 2019. Style and sophistication, with premium upgrades and design for perfect family living. The open-concept main floor-with 9 ft ceilings and the perfect blend of tile and engineered hardwood flooring, California shutters, and pot lighting-is surpassed by a stunning chef's delight kitchen. The kitchen features endless sleek white cabinetry and quartz counters along with a beautiful backsplash, under-cabinet lighting, a stylish range hood, stainless appliances, and a massive pendant-lit island with a breakfast bar. The spacious dining and living area can accommodate the largest of family gatherings and is perfect for entertaining. The upgraded 8 ft patio door with transoms leads to a fully fenced yard and patio where you can watch the kids play. The rest of the main floor includes a two-piece powder room and a convenient mudroom/laundry room. The upper level is highlighted by a primary bedroom suite with a luxury ensuite bathroom, which features an expansive quartz-topped vanity with double sinks, a walk-in glass shower, and a walk-in closet with organizers; you can even enjoy morning coffee on the balcony. The rest of the upper level consists of a main four-piece bath with a separate water closet and tub/shower area, and two great-sized bedrooms, one with a huge walk-in closet. There's also an upper-level family room which gives multiple use options, including a home office, den, or playroom for the kids. The wide-open basement, with a bathroom rough-in, awaits your future living needs. An EV charger is also included. Note: some photos are virtually staged." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-25T04:36:31.474206+00:00" +"CrossStreet": "Wood Lily" +"DirectionFaces": "East" +"Directions": "Sundew to Wood Lily to Wild Rye" +"Exclusions": "None" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, EV car charger" +"InteriorFeatures": array:1 [ …1] …75 } ] +success: true +page_size: 10 +page_count: 28 +count: 276 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4245 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4083 …121} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4084 …142} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4085 …138} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4086 …139} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4087 …112} ] +success: true +page_size: 5 +page_count: 9455 +count: 47271 +after_key: "" } ] ]