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=90&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=90&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=90&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=90&$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: "693542" +post_author: 1 +"ListingKey": "X13030270" +"ListingId": "X13030270" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T17:53:10Z" +"RFModificationTimestamp": "2026-04-30T02:16:29Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 2R7" +"UnparsedAddress": "228 Westcourt Place, Waterloo, ON N2L 2R7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4619847 +"Longitude": -80.5395789 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BAY STREET INTEGRITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Super prime location in Waterloo! Bright and well-maintained townhouse with a rare all floors above-grade layout, offering abundant natural light throughout. Features 5 spacious bedrooms, including a main floor bedroom with walk-out to a private balcony, ideal for added flexibility and comfortable shared living. Functional layout with generous living space, suitable for students, young professionals, or families. Located in the highly desirable University/Westmount area, just a short walk to the University of Waterloo and minutes to Wilfrid Laurier University. Directly across from T&T Supermarket and Westmount Place Plaza, with steps to GRT bus routes #202 and #12 for easy transit access. Close to parks, restaurants, shopping, and all amenities-an excellent opportunity to lease a spacious home in a high-demand, convenient location." +"ArchitecturalStyle": "3-Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "None" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-22T16:45:28.955027+00:00" +"CrossStreet": "University Av W and Westmount Rd" +"Directions": "Turn to Westcourt Pl on Westmount" +"ExpirationDate": "2026-10-21" +"FireplaceYN": true +"Furnished": "Partially" +"GarageYN": true +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"MainOfficeKey": "380200" +"MajorChangeTimestamp": "2026-04-22T15:13:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T15:13:34Z" +"OriginalListPrice": 2950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850718" +"ParcelNumber": "236030006" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T17:53:10Z" +"RentIncludes": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Westcourt" +"StreetNumber": "228" +"StreetSuffix": "Place" +"TransactionBrokerCompensation": "Half Month Rent + HST + Thanks" +"TransactionType": "For Lease" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030270')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604480000306" +"SurveyType": "None" +"BalconyType": "Open" +"LegalStories": "1" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 603 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 9 +"SquareFootSource": "Sq Ft Source MPAC" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Upper" +"WashroomsType3Level": "Lower" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2026-04-22T17:53:10Z" +"PortionPropertyLease": array:1 [ …1] +"PropertyManagementCompany": "WSCC 603 Board" +"SystemModificationTimestamp": "2026-04-22T17:53:10.047659Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:19 [ …19] +"ID": "693542" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "707790" +post_author: 1 +"ListingKey": "X13031438" +"ListingId": "X13031438" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T17:40:27Z" +"RFModificationTimestamp": "2026-04-30T02:16:30Z" +"ListPrice": 499950.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1A4" +"UnparsedAddress": "103 Rogers Street 204, Waterloo, ON N2J 1A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.458456 +"Longitude": -80.533537 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Location Location Location! Presenting a spacious luxury condominium in the heart of Waterloo.This prime location offers proximity to Wilfrid Laurier University, University of Waterloo, Hospital, Spur line trail, LTR, and Highway 85, Close proximity to All the bars and Restaurants. 2 Bed 2 Bathrooms, 1 parking, 932sqft Modern Kitchen W/Stainless Steel Appliances, Quartz Countertop, built-in microwave & vinyl flooring throughout. Master W/Walk in closet, 2nd bedroom w/closet, Highly upgraded with amazing layout, an-suite laundry, dedicated furnace & water heater. Open concept living & dining, walk out to open balcony. Abundant natural light close to great schools, the Go train, public transit, shopping, dining, hospitals, and parks, bike rack.Must view this beautiful upgraded unit." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationFee": "502.4" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-22T19:57:49.648377+00:00" +"CrossStreet": "Union St E & Moore Ave" +"Directions": "Union St E & Moore Ave" +"ExpirationDate": "2026-12-31" +"Inclusions": "Fridge, stove washer, Dryer, all electric fixers and window coverings." +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-22T17:40:27Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-22T17:40:27Z" +"OriginalListPrice": 499950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850804" +"ParcelNumber": "237730082" +"ParkingFeatures": "Underground" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T17:40:27Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rogers" +"StreetNumber": "103" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4492.51" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2% -$50 marketing fee" +"TransactionType": "For Sale" +"UnitNumber": "204" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13031438')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301602135004732" +"SurveyType": "None" +"BalconyType": "Enclosed" +"RentalItems": "Hot water tank" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1A4, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 773 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:3 [ …3] +"SquareFootSource": "Builder" +"ParkingLevelUnit1": "P8" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "24 hrs notice" +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "4" +"MediaChangeTimestamp": "2026-04-22T17:40:27Z" +"PropertyManagementCompany": "Duka Property Management Inc." +"SystemModificationTimestamp": "2026-04-22T17:40:27.934272Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:10 [ …10] +"ID": "707790" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "700287" +post_author: 1 +"ListingKey": "X13030464" +"ListingId": "X13030464" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T15:35:07Z" +"RFModificationTimestamp": "2026-04-29T15:22:16Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2A6" +"UnparsedAddress": "237b Thistleglen Place, Waterloo, ON N2T 2A6" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful single detached located in one of the most desirable areas in Waterloo, Westvale area is surrounded by mature trees, parks and trails. This 4 bedrooms and 2.5 bathrooms is awaiting for families looking to enjoy of this tranquility neighbourhood. The Main Floor: Carpet free throughout, open concept main floor, modern Kitchen, island with breakfast bar, backsplash, main floor laundry room. Second Floor: 3 very good size bedrooms and a main 4 pc bathroom. Basement: finished rec room with gas fireplace, bedrooms/office , 3 pc bathroom and Kitchener/ wet bar area. What about the Backyard? it is huge! And rare to find nowadays. The driveway can accommodate up to 4 cars. Location: walking distances to schools, minutes to the Boardwalk, Costco, Banks, restaurants and universities." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T09:13:16.469837+00:00" +"CrossStreet": "Thorndale Dr" +"DirectionFaces": "North" +"Directions": "Fisher Hallman to Thorndale Dr" +"ExpirationDate": "2026-07-22" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Auto Garage Door Remote,Water Heater,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-22T15:35:07Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-22T15:35:07Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3852754" +"ParcelNumber": "223950057" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-04-22T15:35:07Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Thistleglen" +"StreetNumber": "237B" +"StreetSuffix": "Place" +"TaxAnnualAmount": "3919.0" +"TaxAssessedValue": 287000 +"TaxLegalDescription": "PT LT 54 PL 1602 CITY OF WATERLOO PTS 1 & 124, 58R5256; S/T 863236; WATERLOO" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/237_b_thistleglen_pl_waterloo_on/" +"DDFYN": true +"Water": "Municipal" +"LinkYN": true +"HeatType": "Forced Air" +"LotDepth": 158.0 +"LotWidth": 30.22 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030464')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301603202000900" +"SurveyType": "None" +"RentalItems": "NONE" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2T 2A6, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:4 [ …4] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-22T15:35:07Z" +"SystemModificationTimestamp": "2026-04-22T15:35:08.865895Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:41 [ …41] +"ID": "700287" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "700288" +post_author: 1 +"ListingKey": "X13030426" +"ListingId": "X13030426" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T15:30:45Z" +"RFModificationTimestamp": "2026-04-29T15:22:16Z" +"ListPrice": 849990.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0B6" +"UnparsedAddress": "445 Avens Street, Waterloo, ON N2V 0B6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4539653 +"Longitude": -80.5963799 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BAY STREET GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "445 Avens Street is a rare offering in the heart of Vista Hills-an address that captures the essence of modern Waterloo living with confidence, style, and undeniable potential. Thoughtfully designed and effortlessly livable, this residence balances clean architectural lines with warm, inviting spaces that feel as good as they look. Natural light pours through the home, animating every corner and enhancing a layout created for both connection and quiet retreat. The main level unfolds with ease-an open, contemporary setting where daily life and entertaining exist in perfect harmony. At its centre, a refined kitchen anchors the space, equal parts function and design, ready to host everything from casual mornings to unforgettable evenings. Above, three well-appointed bedrooms offers comfort without compromise. The primary suite is a calm and elevated escape, complete with its own ensuite and walk-in closet-a space designed to recharge and reset. Beyond the interiors, the home continues to impress. Set against a quiet residential backdrop, the outdoor space offers a sense of calm rarely found at this price point-an everyday luxury that enhances how the home is lived and experienced. The lower level remains untouched-a canvas of opportunity, inviting future owners to expand, create, and add lasting value. Positioned just moments from The Boardwalk, Costco Wholesale, and the academic and cultural energy of University of Waterloo and Wilfrid Laurier University, this is a location defined by convenience, growth, and community. This is more than a home-it's a smart, stylish foothold in one of Waterloo's most desirable neighbourhoods. A place to grow, invest, and thrive.445 Avens Street is not just an opportunity. It's a move forward." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T09:16:22.622490+00:00" +"CrossStreet": "SUNDEW DR / Wild Calla St" +"DirectionFaces": "West" +"Directions": "SUNDEW DR / Wild Calla St" +"Exclusions": "none" +"ExpirationDate": "2026-08-31" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All chattels (dishwasher, washer, dryer, fridge, & stove) and ELFs" +"InteriorFeatures": "Sump Pump,Water Heater,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "294900" +"MajorChangeTimestamp": "2026-04-22T15:30:45Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T15:30:45Z" +"OriginalListPrice": 849990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3835030" +"ParcelNumber": "226844747" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-22T15:30:45Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Avens" +"StreetNumber": "445" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5288.0" +"TaxLegalDescription": "LOT 61, PLAN 58M548 SUBJECT TO AN EASEMENT IN GROSS OVER PT.61, 133 ON 58R-17664 AS IN WR727955 SUBJECT TO AN EASEMENT IN GROSS OVER PT. 61, 133 ON 58R-17664 AS IN WR727982 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1022706 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"Zoning": "NR-SL" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 119.79 +"LotShape": "Rectangular" +"LotWidth": 28.71 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030426')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301604000118812" +"SurveyType": "None" +"RentalItems": "hot water tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0B6, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"ContactAfterExpiryYN": true +"MediaChangeTimestamp": "2026-04-22T15:30:45Z" +"SystemModificationTimestamp": "2026-04-22T15:30:47.391543Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:38 [ …38] +"ID": "700288" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "709440" +post_author: 1 +"ListingKey": "X13028158" +"ListingId": "X13028158" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T02:43:43Z" +"RFModificationTimestamp": "2026-04-30T02:16:29Z" +"ListPrice": 495000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1R1" +"UnparsedAddress": "191 King Street S 703, Waterloo, ON N2J 1R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4595858 +"Longitude": -80.5186714 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL ONE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully maintained 1 bed plus den condo at The Bauer lofts. This unit offers 827 sq. ft. of stylish, open-concept living in one of Uptown Waterloos most sought-after locations. Overlooking the peaceful courtyard, enjoy views of The Bauer Kitchen and Vincenzos Marketplace right from your private balcony. Boasting a Walk Score of 93, this prime location places you steps from top-tier shopping, dining, and entertainment, with immediate access to the LRT station and the Iron Horse Trail for effortless commuting and recreation. This carpet-free unit features soaring ceilings, exposed concrete accents, granite countertops throughout, two full bathrooms, and in-suite laundry. Included are underground parking (space 146) and storage locker (U250) for added convenience. The Bauer Lofts offer premium amenities, including: A fitness room (3rd floor, A rooftop patio (4th floor) An upscale party room (4th floor) Dont miss your chance to live in this modern, vibrant community schedule your viewing today!" +"ArchitecturalStyle": "1 Storey/Apt" +"AssociationAmenities": array:4 [ …4] +"AssociationFee": "579.13" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T12:14:19.463162+00:00" +"CrossStreet": "king/allen" +"Directions": "King/Union" +"Exclusions": "Decorations" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": "Year Round Living" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All existing appliances. Parking Spot underground #146 Storage Locker # U250." +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "112800" +"MajorChangeTimestamp": "2026-04-22T02:43:43Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T02:43:43Z" +"OriginalListPrice": 495000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3853106" +"ParcelNumber": "234950123" +"ParkingFeatures": "Underground" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T02:43:43Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "king" +"StreetNumber": "191" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4275.62" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "703" +"View": array:1 [ …1] +"Zoning": "CONDO" +"DDFYN": true +"Locker": "Ensuite+Owned" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13028158')" +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "250" +"RollNumber": "301603120000575" +"SurveyType": "None" +"BalconyType": "Open" +"LockerLevel": "B" +"HoldoverDays": 60 +"LegalStories": "7" +"ParkingSpot1": "146" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1R1, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 495 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "OWNER" +"ParkingLevelUnit1": "B" +"PossessionDetails": "flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "3" +"MediaChangeTimestamp": "2026-04-22T02:43:43Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-22T02:43:43.524218Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:27 [ …27] +"ID": "709440" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853 +post_id: "697264" +post_author: 1 +"ListingKey": "X13026494" +"ListingId": "X13026494" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T18:36:12Z" +"RFModificationTimestamp": "2026-04-29T12:33:56Z" +"ListPrice": 3500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0H1" +"UnparsedAddress": "295 Chokecherry Crescent, Waterloo, ON N2V 0H1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4528991 +"Longitude": -80.5922731 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE LANDMARK REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "295 Chokecherry cres , a 3 years old house, Offers 4 bedrooms, 3 bathrooms, 2 car garage, and a double driveway fitting 4 cars in total. Main floor features a good size living room open to dining area with grand windows providing plenty of natural lighting, eat in kitchen with an oversized island and plenty of cabinets, backsplash, all hardwood and ceramic flooring. Second floor offers a huge master bedroom with a balcony, walk-in closet, and 5 pc bathroom, plus three additional bedrooms. This house is located close to Costco, Vista Hills Public School, the bus route to University of Waterloo, and more." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-28T14:30:36.074050+00:00" +"CrossStreet": "SUNDEW & CHOKECHERRY" +"DirectionFaces": "West" +"Directions": "SUNDEW & CHOKECHERRY" +"Exclusions": "tenant's belongings" +"ExpirationDate": "2026-09-30" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"InteriorFeatures": "Water Heater,Water Softener" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "063000" +"MajorChangeTimestamp": "2026-04-21T18:36:12Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-21T18:36:12Z" +"OriginalListPrice": 3500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850700" +"ParcelNumber": "226845631" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-21T18:36:12Z" +"PoolFeatures": "None" +"RentIncludes": array:1 [ …1] +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Chokecherry" +"StreetNumber": "295" +"StreetSuffix": "Crescent" +"TransactionBrokerCompensation": "half month rent +hst" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 98.59 +"LotShape": "Rectangular" +"LotWidth": 36.15 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13026494')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604000115537" +"SurveyType": "None" +"RentalItems": "Hot Water Heater, Water Softener" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0H1, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 6 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 4 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"MediaChangeTimestamp": "2026-04-21T18:36:12Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-04-21T18:36:12.903243Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:11 [ …11] +"ID": "697264" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "690880" +post_author: 1 +"ListingKey": "X13007556" +"ListingId": "X13007556" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T17:54:41Z" +"RFModificationTimestamp": "2026-04-29T12:33:32Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 3778.13 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 3G7" +"UnparsedAddress": "423 Cadbury Court A, Waterloo, ON N2K 3G7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4924469 +"Longitude": -80.5104204 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this charming and affordable freehold semi-detached home located in a highly desirable Waterloo neighbourhood. Situated on an extra-deep, beautifully landscaped lot, this well-maintained home offers exceptional value for first-time buyers, young families, or investors alike. The property features three spacious bedrooms, 2 full renovated bathrooms, a spacious floorplan which includes a bright family room & dining area, modern laminate flooring, and fresh, modern paint throughout. The updated kitchen is thoughtfully designed, offering both functionality and contemporary appeal. Step outside to a covered deck-perfect for outdoor dining and entertaining. Conveniently located within walking distance to top-rated schools, public transit with direct routes to local universities, Conestoga Mall, and numerous parks, this home delivers both comfort and accessibility. Easy highway access further enhances its appeal for commuters. The lower-level walkout basement provides excellent in-law suite potential or the opportunity to create additional rental income, adding flexibility and long-term value. Attached garage with remote entry, parking for up to 3 vehicles.Recent updates include: roof, attic insulation, renovated bathrooms, rebuilt deck, and fresh paint, Updated Windows, Brand New Furnace & A/C This is a wonderful opportunity to own a well-cared-for home in a prime location-one you'll be proud to call your own." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-16T17:19:27.178183+00:00" +"CrossStreet": "Lexington/Dunvegan" +"DirectionFaces": "West" +"Directions": "Lexington to Dunvegan to Bairstow to Cadbury Ct" +"ExpirationDate": "2026-07-16" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, Window Coverings" +"InteriorFeatures": "Carpet Free,Suspended Ceilings,Upgraded Insulation,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "549200" +"MajorChangeTimestamp": "2026-04-21T14:50:12Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-16T16:28:23Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3805872" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "222910077" +"ParkingFeatures": "Private" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-20T19:45:39Z" +"PoolFeatures": "None" +"PreviousListPrice": 649900.0 +"PriceChangeTimestamp": "2026-04-21T14:50:12Z" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cadbury" +"StreetNumber": "423" +"StreetSuffix": "Court" +"TaxAnnualAmount": "3113.4" +"TaxAssessedValue": 228000 +"TaxLegalDescription": "LT 2 PL 1590 CITY OF WATERLOO; S/T 439202, 834211; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "A" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/423_cadbury_ct_waterloo_on/" +"VirtualTourURLUnbranded2": "https://youriguide.com/423_cadbury_ct_waterloo_on/" +"Zoning": "R4" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 105.0 +"LotShape": "Pie" +"LotWidth": 28.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007556')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601054001500" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "No" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"MortgageComment": "TREAT AS CLEAR" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 2 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"LotIrregularities": "27.79 ft x 111.32 ft x 43.44 ft x 105.17" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Supra Showing system or call 519-888-7110" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-21T14:49:32Z" +"SystemModificationTimestamp": "2026-04-21T17:54:48.666326Z" +"Media": array:50 [ …50] +"ID": "690880" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "600143" +post_author: 1 +"ListingKey": "X12793294" +"ListingId": "X12793294" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T16:30:06Z" +"RFModificationTimestamp": "2026-04-28T23:10:02Z" +"ListPrice": 289000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2500.0 +"City": "Waterloo" +"PostalCode": "N2J 2W6" +"UnparsedAddress": "23 King Street N, Waterloo, ON N2J 2W6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4657126 +"Longitude": -80.5226987 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE FRONTIER REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Positioned at the prime intersection of King St and Erb St - widely recognized as one of the most desirable commercial corridors in Waterloo - this is a truly turnkey restaurant opportunity ready for immediate operation. The space is fully equipped with brand-new commercial equipment, including a 10-foot hood, two deep fryers, 8-burner stove range, commercial coolers and freezers, 3-compartment sink, stainless steel prep tables, and a professionally built above-ground grease trap. A recently approved LLBO license allows for up to 72 seats, including a patio, offering excellent revenue potential. The dining area is thoughtfully designed with a modern and refined aesthetic, and the business is already operating successfully. Currently home to a well-known and profitable franchise brand, the buyer has the flexibility to either take over the existing franchise and continue its proven model or introduce their own original concept in this high-demand location. The lease is highly attractive, with reasonable rent secured until November 30, 2030, plus a 5-year renewal option - providing long-term stability in one of Waterloo's busiest and most sought-after areas. After touring other available restaurant listings in Waterloo, the value of this fully prepared and income-generating opportunity becomes clear. A rare chance to step into a thriving location with infrastructure, licensing, and momentum already in place - though it may not remain available for long." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"Cooling": "Yes" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T14:48:21.474214+00:00" +"CrossStreet": "Erb and Bridgeport on King st Uptown Waterloo" +"Directions": "Located northwest of Erb Street and Bridgeport Road on King Street in Uptown Waterloo" +"ExpirationDate": "2026-05-15" +"HoursDaysOfOperation": array:1 [ …1] +"HoursDaysOfOperationDescription": "12:00-10:00pm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-16" +"MainOfficeKey": "099000" +"MajorChangeTimestamp": "2026-02-17T16:00:22Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 8 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-02-17T16:00:22Z" +"OriginalListPrice": 289000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3560470" +"PhotosChangeTimestamp": "2026-02-18T00:36:23Z" +"SeatingCapacity": "38" +"SecurityFeatures": array:1 [ …1] +"Sewer": "None" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "King" +"StreetNumber": "23" +"StreetSuffix": "Street" +"TaxLegalDescription": "0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4%+Hst" +"TransactionType": "For Sale" +"Utilities": "Available" +"Zoning": "N/A" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "Annual" +"Expenses": "Estimated" +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12793294')" +"ChattelsYN": true +"GarageType": "None" +"FranchiseYN": true +"PropertyUse": "Without Property" +"ElevatorType": "None" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"LiquorLicenseYN": true +"PossessionDetails": "Flexible" +"IndustrialAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2026-04-02T20:08:03Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2026-04-21T16:30:06.789772Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:22 [ …22] +"ID": "600143" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "711850" +post_author: 1 +"ListingKey": "X13024970" +"ListingId": "X13024970" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T15:10:31Z" +"RFModificationTimestamp": "2026-04-28T16:37:27Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1W3" +"UnparsedAddress": "312 Erb Street W 416, Waterloo, ON N2L 1W3" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE PARADISE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover living at at 312 Erb Street W, Waterloo, Ontario (Moda)! This upgraded 2 bedroom, 2 bathroom (Dona Model) newer,corner unit offers a perfect blend of comfort and convenience in a prime location. The unit has lot of natural light ,living space features large windows , and the open-concept layout seamlessly connects the living, dining, and kitchen areas, making it ideal for both relaxation and entertaining. The upgraded kitchen boasts modern stainless steel appliances and ample cabinetry, while the spacious bedrooms provides a peaceful retreat with a generous closet for all your storage needs. The sleek full bathrooms, featuring with a stylish design, is perfect for unwinding after a long day. This condo includes in-suite laundry for your convenience and a dedicated surface parking spot. Located in the heart of Waterloo, this home is just minutes away from the University of Waterloo, Wilfred Laurier University, shopping centres, restaurants, and public transit.Easy access to parks and recreational facilities.Upgrades in Kitchen,flooring and washrooms for more than $20K.One surface parking and a locker storage included.Internet covered in condo fee.The unit has a nice open balcony of 45 sqft as well" +"ArchitecturalStyle": "Apartment" +"AssociationFee": "581.01" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T15:27:28.863853+00:00" +"CrossStreet": "Erb St W/University Ave" +"Directions": "Fischer Hallman and University to Erb St W" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-08-31" +"Inclusions": "Stainless Kitchen Appliances , White Dryer/Washer" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "167500" +"MajorChangeTimestamp": "2026-04-21T15:09:52Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-21T15:09:52Z" +"OriginalListPrice": 530000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3836526" +"ParkingFeatures": "Other,Surface" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T15:09:53Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "312" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3535.71" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"UnitNumber": "416" +"UFFI": "No" +"DDFYN": true +"Locker": "Owned" +"Sewage": array:1 [ …1] +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13024970')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "4" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1W3, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-01" +"PossessionType": "1-29 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 789 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 6 +"AlternativePower": array:1 [ …1] +"SquareFootSource": "Seller" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "16" +"MediaChangeTimestamp": "2026-04-21T15:09:53Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-21T15:10:36.577022Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:44 [ …44] +"ID": "711850" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "696192" +post_author: 1 +"ListingKey": "X13024614" +"ListingId": "X13024614" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T15:05:09Z" +"RFModificationTimestamp": "2026-04-27T06:14:39Z" +"ListPrice": 2000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3H2" +"UnparsedAddress": "62 Balsam Street B207, Waterloo, ON N2L 3H2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4764213 +"Longitude": -80.5299914 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "UNION CAPITAL REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Sage 3 Unit B207 a stylish and meticulously maintained 1+1 bedroom, 1.5-bath condo located in the heart of Waterloo's thriving university district. Perfect for both end-users and investors, this 777 sq. ft. furnished suite offers modern open-concept living with granite countertops, stainless steel appliances, and ample kitchen storage. The spacious den provides flexibility to be used as a home office, guest space, or second bedroom offering the functionality of a two-bedroom unit without the extra cost. Enjoy in-suite laundry, and a large balcony with access from the living room. Just steps from Wilfrid Laurier University and the University of Waterloo, this unit is ideal for students, young professionals, or savvy investors. With its prime location, thoughtful layout, and strong rental appeal, Unit B207 is a smart and versatile investment opportunity." +"ArchitecturalStyle": "1 Storey/Apt" +"AssociationAmenities": array:2 [ …2] +"Basement": array:1 [ …1] +"BuildingName": "Sage 3" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-21T16:23:52.560938+00:00" +"CrossStreet": "University Ave W & King St N" +"Directions": "University Ave W & King St N" +"Exclusions": "Hydro" +"ExpirationDate": "2026-10-01" +"Furnished": "Partially" +"GarageYN": true +"Inclusions": "Furniture included in the Unit: 1 x Bed + Mattress, 2 x Desk + Desk Chair. 1 x Night Stand, 2 x Loveseat, 1 x Armchair, 1 x Media Unit, 1 x 50" Flat Screen TV, 1 x Dining Table, 4 x Dining Chair, 1 x Coffee Table" +"InteriorFeatures": "Built-In Oven,Countertop Range,Primary Bedroom - Main Floor,Separate Heating Controls,Water Heater" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"LotSizeSource": "MPAC" +"MainOfficeKey": "337000" +"MajorChangeTimestamp": "2026-04-21T14:31:43Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-21T14:31:43Z" +"OriginalListPrice": 2000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3847588" +"ParcelNumber": "235940060" +"ParkingFeatures": "None" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T14:31:43Z" +"RentIncludes": array:6 [ …6] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Balsam" +"StreetNumber": "62" +"StreetSuffix": "Street" +"Topography": array:2 [ …2] +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "B207" +"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1Lvjm WNY1q6Yr TBs F1cy2ZYIyixas Mtgw/view?usp=drive_link" +"DDFYN": true +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13024614')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301604030001114" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 10 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3H2, CA" +"ApproximateAge": "11-15" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 594 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 1 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "MPAC" +"PossessionDetails": "Tenanted" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "B207" +"MediaChangeTimestamp": "2026-04-21T14:31:43Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Wilson Blanchard Management" +"SystemModificationTimestamp": "2026-04-21T15:05:09.417736Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ …15] +"ID": "696192" } ] +success: true +page_size: 10 +page_count: 26 +count: 253 +after_key: "" } "RF Response Time" => "0.31 seconds" ] "RF Cache Key: c0e584645dd293f241022225c99b892c5c7e4790e0ed6430cac0c898ce68e168" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3117 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4306 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13030270" +"ListingId": "X13030270" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T17:53:10Z" +"RFModificationTimestamp": "2026-04-30T02:16:29Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 2R7" +"UnparsedAddress": "228 Westcourt Place, Waterloo, ON N2L 2R7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4619847 +"Longitude": -80.5395789 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BAY STREET INTEGRITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Super prime location in Waterloo! Bright and well-maintained townhouse with a rare all floors above-grade layout, offering abundant natural light throughout. Features 5 spacious bedrooms, including a main floor bedroom with walk-out to a private balcony, ideal for added flexibility and comfortable shared living. Functional layout with generous living space, suitable for students, young professionals, or families. Located in the highly desirable University/Westmount area, just a short walk to the University of Waterloo and minutes to Wilfrid Laurier University. Directly across from T&T Supermarket and Westmount Place Plaza, with steps to GRT bus routes #202 and #12 for easy transit access. Close to parks, restaurants, shopping, and all amenities-an excellent opportunity to lease a spacious home in a high-demand, convenient location." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-22T16:45:28.955027+00:00" +"CrossStreet": "University Av W and Westmount Rd" +"Directions": "Turn to Westcourt Pl on Westmount" +"ExpirationDate": "2026-10-21" +"FireplaceYN": true +"Furnished": "Partially" +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"MainOfficeKey": "380200" +"MajorChangeTimestamp": "2026-04-22T15:13:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T15:13:34Z" +"OriginalListPrice": 2950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850718" +"ParcelNumber": "236030006" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T17:53:10Z" +"RentIncludes": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Westcourt" +"StreetNumber": "228" +"StreetSuffix": "Place" +"TransactionBrokerCompensation": "Half Month Rent + HST + Thanks" +"TransactionType": "For Lease" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030270')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604480000306" +"SurveyType": "None" +"BalconyType": "Open" +"LegalStories": "1" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 603 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 9 +"SquareFootSource": "Sq Ft Source MPAC" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Upper" +"WashroomsType3Level": "Lower" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2026-04-22T17:53:10Z" +"PortionPropertyLease": array:1 [ …1] +"PropertyManagementCompany": "WSCC 603 Board" +"SystemModificationTimestamp": "2026-04-22T17:53:10.047659Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:19 [ …19] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4307 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13031438" +"ListingId": "X13031438" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T17:40:27Z" +"RFModificationTimestamp": "2026-04-30T02:16:30Z" +"ListPrice": 499950.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1A4" +"UnparsedAddress": "103 Rogers Street 204, Waterloo, ON N2J 1A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.458456 +"Longitude": -80.533537 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Location Location Location! Presenting a spacious luxury condominium in the heart of Waterloo.This prime location offers proximity to Wilfrid Laurier University, University of Waterloo, Hospital, Spur line trail, LTR, and Highway 85, Close proximity to All the bars and Restaurants. 2 Bed 2 Bathrooms, 1 parking, 932sqft Modern Kitchen W/Stainless Steel Appliances, Quartz Countertop, built-in microwave & vinyl flooring throughout. Master W/Walk in closet, 2nd bedroom w/closet, Highly upgraded with amazing layout, an-suite laundry, dedicated furnace & water heater. Open concept living & dining, walk out to open balcony. Abundant natural light close to great schools, the Go train, public transit, shopping, dining, hospitals, and parks, bike rack.Must view this beautiful upgraded unit." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "502.4" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-22T19:57:49.648377+00:00" +"CrossStreet": "Union St E & Moore Ave" +"Directions": "Union St E & Moore Ave" +"ExpirationDate": "2026-12-31" +"Inclusions": "Fridge, stove washer, Dryer, all electric fixers and window coverings." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-22T17:40:27Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-22T17:40:27Z" +"OriginalListPrice": 499950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850804" +"ParcelNumber": "237730082" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T17:40:27Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rogers" +"StreetNumber": "103" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4492.51" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2% -$50 marketing fee" +"TransactionType": "For Sale" +"UnitNumber": "204" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13031438')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301602135004732" +"SurveyType": "None" +"BalconyType": "Enclosed" +"RentalItems": "Hot water tank" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1A4, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 773 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:3 [ …3] +"SquareFootSource": "Builder" +"ParkingLevelUnit1": "P8" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "24 hrs notice" +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "4" +"MediaChangeTimestamp": "2026-04-22T17:40:27Z" +"PropertyManagementCompany": "Duka Property Management Inc." +"SystemModificationTimestamp": "2026-04-22T17:40:27.934272Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:10 [ …10] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4310 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13030464" +"ListingId": "X13030464" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T15:35:07Z" +"RFModificationTimestamp": "2026-04-29T15:22:16Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2A6" +"UnparsedAddress": "237b Thistleglen Place, Waterloo, ON N2T 2A6" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful single detached located in one of the most desirable areas in Waterloo, Westvale area is surrounded by mature trees, parks and trails. This 4 bedrooms and 2.5 bathrooms is awaiting for families looking to enjoy of this tranquility neighbourhood. The Main Floor: Carpet free throughout, open concept main floor, modern Kitchen, island with breakfast bar, backsplash, main floor laundry room. Second Floor: 3 very good size bedrooms and a main 4 pc bathroom. Basement: finished rec room with gas fireplace, bedrooms/office , 3 pc bathroom and Kitchener/ wet bar area. What about the Backyard? it is huge! And rare to find nowadays. The driveway can accommodate up to 4 cars. Location: walking distances to schools, minutes to the Boardwalk, Costco, Banks, restaurants and universities." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T09:13:16.469837+00:00" +"CrossStreet": "Thorndale Dr" +"DirectionFaces": "North" +"Directions": "Fisher Hallman to Thorndale Dr" +"ExpirationDate": "2026-07-22" +"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-22" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-22T15:35:07Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-22T15:35:07Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3852754" +"ParcelNumber": "223950057" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-04-22T15:35:07Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Thistleglen" +"StreetNumber": "237B" +"StreetSuffix": "Place" +"TaxAnnualAmount": "3919.0" +"TaxAssessedValue": 287000 +"TaxLegalDescription": "PT LT 54 PL 1602 CITY OF WATERLOO PTS 1 & 124, 58R5256; S/T 863236; WATERLOO" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/237_b_thistleglen_pl_waterloo_on/" +"DDFYN": true +"Water": "Municipal" +"LinkYN": true +"HeatType": "Forced Air" +"LotDepth": 158.0 +"LotWidth": 30.22 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030464')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "301603202000900" +"SurveyType": "None" +"RentalItems": "NONE" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2T 2A6, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:4 [ …4] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-22T15:35:07Z" +"SystemModificationTimestamp": "2026-04-22T15:35:08.865895Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:41 [ …41] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4309 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13030426" +"ListingId": "X13030426" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T15:30:45Z" +"RFModificationTimestamp": "2026-04-29T15:22:16Z" +"ListPrice": 849990.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0B6" +"UnparsedAddress": "445 Avens Street, Waterloo, ON N2V 0B6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4539653 +"Longitude": -80.5963799 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BAY STREET GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "445 Avens Street is a rare offering in the heart of Vista Hills-an address that captures the essence of modern Waterloo living with confidence, style, and undeniable potential. Thoughtfully designed and effortlessly livable, this residence balances clean architectural lines with warm, inviting spaces that feel as good as they look. Natural light pours through the home, animating every corner and enhancing a layout created for both connection and quiet retreat. The main level unfolds with ease-an open, contemporary setting where daily life and entertaining exist in perfect harmony. At its centre, a refined kitchen anchors the space, equal parts function and design, ready to host everything from casual mornings to unforgettable evenings. Above, three well-appointed bedrooms offers comfort without compromise. The primary suite is a calm and elevated escape, complete with its own ensuite and walk-in closet-a space designed to recharge and reset. Beyond the interiors, the home continues to impress. Set against a quiet residential backdrop, the outdoor space offers a sense of calm rarely found at this price point-an everyday luxury that enhances how the home is lived and experienced. The lower level remains untouched-a canvas of opportunity, inviting future owners to expand, create, and add lasting value. Positioned just moments from The Boardwalk, Costco Wholesale, and the academic and cultural energy of University of Waterloo and Wilfrid Laurier University, this is a location defined by convenience, growth, and community. This is more than a home-it's a smart, stylish foothold in one of Waterloo's most desirable neighbourhoods. A place to grow, invest, and thrive.445 Avens Street is not just an opportunity. It's a move forward." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T09:16:22.622490+00:00" +"CrossStreet": "SUNDEW DR / Wild Calla St" +"DirectionFaces": "West" +"Directions": "SUNDEW DR / Wild Calla St" +"Exclusions": "none" +"ExpirationDate": "2026-08-31" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All chattels (dishwasher, washer, dryer, fridge, & stove) and ELFs" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "294900" +"MajorChangeTimestamp": "2026-04-22T15:30:45Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T15:30:45Z" +"OriginalListPrice": 849990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3835030" +"ParcelNumber": "226844747" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-22T15:30:45Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Avens" +"StreetNumber": "445" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5288.0" +"TaxLegalDescription": "LOT 61, PLAN 58M548 SUBJECT TO AN EASEMENT IN GROSS OVER PT.61, 133 ON 58R-17664 AS IN WR727955 SUBJECT TO AN EASEMENT IN GROSS OVER PT. 61, 133 ON 58R-17664 AS IN WR727982 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1022706 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"Zoning": "NR-SL" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 119.79 +"LotShape": "Rectangular" +"LotWidth": 28.71 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13030426')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301604000118812" +"SurveyType": "None" +"RentalItems": "hot water tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0B6, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"ContactAfterExpiryYN": true +"MediaChangeTimestamp": "2026-04-22T15:30:45Z" +"SystemModificationTimestamp": "2026-04-22T15:30:47.391543Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:38 [ …38] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4308 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13028158" +"ListingId": "X13028158" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T02:43:43Z" +"RFModificationTimestamp": "2026-04-30T02:16:29Z" +"ListPrice": 495000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1R1" +"UnparsedAddress": "191 King Street S 703, Waterloo, ON N2J 1R1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4595858 +"Longitude": -80.5186714 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL ONE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully maintained 1 bed plus den condo at The Bauer lofts. This unit offers 827 sq. ft. of stylish, open-concept living in one of Uptown Waterloos most sought-after locations. Overlooking the peaceful courtyard, enjoy views of The Bauer Kitchen and Vincenzos Marketplace right from your private balcony. Boasting a Walk Score of 93, this prime location places you steps from top-tier shopping, dining, and entertainment, with immediate access to the LRT station and the Iron Horse Trail for effortless commuting and recreation. This carpet-free unit features soaring ceilings, exposed concrete accents, granite countertops throughout, two full bathrooms, and in-suite laundry. Included are underground parking (space 146) and storage locker (U250) for added convenience. The Bauer Lofts offer premium amenities, including: A fitness room (3rd floor, A rooftop patio (4th floor) An upscale party room (4th floor) Dont miss your chance to live in this modern, vibrant community schedule your viewing today!" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:4 [ …4] +"AssociationFee": "579.13" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T12:14:19.463162+00:00" +"CrossStreet": "king/allen" +"Directions": "King/Union" +"Exclusions": "Decorations" +"ExpirationDate": "2026-09-30" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All existing appliances. Parking Spot underground #146 Storage Locker # U250." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "112800" +"MajorChangeTimestamp": "2026-04-22T02:43:43Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-22T02:43:43Z" +"OriginalListPrice": 495000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3853106" +"ParcelNumber": "234950123" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-22T02:43:43Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "king" +"StreetNumber": "191" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4275.62" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "703" +"View": array:1 [ …1] +"Zoning": "CONDO" +"DDFYN": true +"Locker": "Ensuite+Owned" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13028158')" +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "250" +"RollNumber": "301603120000575" +"SurveyType": "None" +"BalconyType": "Open" +"LockerLevel": "B" +"HoldoverDays": 60 +"LegalStories": "7" +"ParkingSpot1": "146" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1R1, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 495 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "OWNER" +"ParkingLevelUnit1": "B" +"PossessionDetails": "flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "3" +"MediaChangeTimestamp": "2026-04-22T02:43:43Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-22T02:43:43.524218Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:27 [ …27] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4305 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13026494" +"ListingId": "X13026494" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T18:36:12Z" +"RFModificationTimestamp": "2026-04-29T12:33:56Z" +"ListPrice": 3500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0H1" +"UnparsedAddress": "295 Chokecherry Crescent, Waterloo, ON N2V 0H1" +"Coordinates": array:2 [ …2] +"Latitude": 43.4528991 +"Longitude": -80.5922731 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE LANDMARK REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "295 Chokecherry cres , a 3 years old house, Offers 4 bedrooms, 3 bathrooms, 2 car garage, and a double driveway fitting 4 cars in total. Main floor features a good size living room open to dining area with grand windows providing plenty of natural lighting, eat in kitchen with an oversized island and plenty of cabinets, backsplash, all hardwood and ceramic flooring. Second floor offers a huge master bedroom with a balcony, walk-in closet, and 5 pc bathroom, plus three additional bedrooms. This house is located close to Costco, Vista Hills Public School, the bus route to University of Waterloo, and more." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-28T14:30:36.074050+00:00" +"CrossStreet": "SUNDEW & CHOKECHERRY" +"DirectionFaces": "West" +"Directions": "SUNDEW & CHOKECHERRY" +"Exclusions": "tenant's belongings" +"ExpirationDate": "2026-09-30" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"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-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "063000" +"MajorChangeTimestamp": "2026-04-21T18:36:12Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-21T18:36:12Z" +"OriginalListPrice": 3500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3850700" +"ParcelNumber": "226845631" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-21T18:36:12Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Chokecherry" +"StreetNumber": "295" +"StreetSuffix": "Crescent" +"TransactionBrokerCompensation": "half month rent +hst" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 98.59 +"LotShape": "Rectangular" +"LotWidth": 36.15 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13026494')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604000115537" +"SurveyType": "None" +"RentalItems": "Hot Water Heater, Water Softener" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0H1, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 6 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 4 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"MediaChangeTimestamp": "2026-04-21T18:36:12Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-04-21T18:36:12.903243Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:11 [ …11] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4304 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13007556" +"ListingId": "X13007556" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T17:54:41Z" +"RFModificationTimestamp": "2026-04-29T12:33:32Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 3778.13 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 3G7" +"UnparsedAddress": "423 Cadbury Court A, Waterloo, ON N2K 3G7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4924469 +"Longitude": -80.5104204 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this charming and affordable freehold semi-detached home located in a highly desirable Waterloo neighbourhood. Situated on an extra-deep, beautifully landscaped lot, this well-maintained home offers exceptional value for first-time buyers, young families, or investors alike. The property features three spacious bedrooms, 2 full renovated bathrooms, a spacious floorplan which includes a bright family room & dining area, modern laminate flooring, and fresh, modern paint throughout. The updated kitchen is thoughtfully designed, offering both functionality and contemporary appeal. Step outside to a covered deck-perfect for outdoor dining and entertaining. Conveniently located within walking distance to top-rated schools, public transit with direct routes to local universities, Conestoga Mall, and numerous parks, this home delivers both comfort and accessibility. Easy highway access further enhances its appeal for commuters. The lower-level walkout basement provides excellent in-law suite potential or the opportunity to create additional rental income, adding flexibility and long-term value. Attached garage with remote entry, parking for up to 3 vehicles.Recent updates include: roof, attic insulation, renovated bathrooms, rebuilt deck, and fresh paint, Updated Windows, Brand New Furnace & A/C This is a wonderful opportunity to own a well-cared-for home in a prime location-one you'll be proud to call your own." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-16T17:19:27.178183+00:00" +"CrossStreet": "Lexington/Dunvegan" +"DirectionFaces": "West" +"Directions": "Lexington to Dunvegan to Bairstow to Cadbury Ct" +"ExpirationDate": "2026-07-16" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, Window Coverings" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-16" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "549200" +"MajorChangeTimestamp": "2026-04-21T14:50:12Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-16T16:28:23Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3805872" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "222910077" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-20T19:45:39Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 649900.0 +"PriceChangeTimestamp": "2026-04-21T14:50:12Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cadbury" +"StreetNumber": "423" +"StreetSuffix": "Court" +"TaxAnnualAmount": "3113.4" +"TaxAssessedValue": 228000 +"TaxLegalDescription": "LT 2 PL 1590 CITY OF WATERLOO; S/T 439202, 834211; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "A" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/423_cadbury_ct_waterloo_on/" +"VirtualTourURLUnbranded2": "https://youriguide.com/423_cadbury_ct_waterloo_on/" +"Zoning": "R4" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 105.0 +"LotShape": "Pie" +"LotWidth": 28.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13007556')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601054001500" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"Winterized": "No" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"MortgageComment": "TREAT AS CLEAR" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 2 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:6 [ …6] +"LotIrregularities": "27.79 ft x 111.32 ft x 43.44 ft x 105.17" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Supra Showing system or call 519-888-7110" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-21T14:49:32Z" +"SystemModificationTimestamp": "2026-04-21T17:54:48.666326Z" +"Media": array:50 [ …50] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4303 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12793294" +"ListingId": "X12793294" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T16:30:06Z" +"RFModificationTimestamp": "2026-04-28T23:10:02Z" +"ListPrice": 289000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2500.0 +"City": "Waterloo" +"PostalCode": "N2J 2W6" +"UnparsedAddress": "23 King Street N, Waterloo, ON N2J 2W6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4657126 +"Longitude": -80.5226987 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE FRONTIER REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Positioned at the prime intersection of King St and Erb St - widely recognized as one of the most desirable commercial corridors in Waterloo - this is a truly turnkey restaurant opportunity ready for immediate operation. The space is fully equipped with brand-new commercial equipment, including a 10-foot hood, two deep fryers, 8-burner stove range, commercial coolers and freezers, 3-compartment sink, stainless steel prep tables, and a professionally built above-ground grease trap. A recently approved LLBO license allows for up to 72 seats, including a patio, offering excellent revenue potential. The dining area is thoughtfully designed with a modern and refined aesthetic, and the business is already operating successfully. Currently home to a well-known and profitable franchise brand, the buyer has the flexibility to either take over the existing franchise and continue its proven model or introduce their own original concept in this high-demand location. The lease is highly attractive, with reasonable rent secured until November 30, 2030, plus a 5-year renewal option - providing long-term stability in one of Waterloo's busiest and most sought-after areas. After touring other available restaurant listings in Waterloo, the value of this fully prepared and income-generating opportunity becomes clear. A rare chance to step into a thriving location with infrastructure, licensing, and momentum already in place - though it may not remain available for long." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T14:48:21.474214+00:00" +"CrossStreet": "Erb and Bridgeport on King st Uptown Waterloo" +"Directions": "Located northwest of Erb Street and Bridgeport Road on King Street in Uptown Waterloo" +"ExpirationDate": "2026-05-15" +"HoursDaysOfOperation": array:1 [ …1] +"HoursDaysOfOperationDescription": "12:00-10:00pm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-16" +"MainOfficeKey": "099000" +"MajorChangeTimestamp": "2026-02-17T16:00:22Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 8 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-02-17T16:00:22Z" +"OriginalListPrice": 289000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3560470" +"PhotosChangeTimestamp": "2026-02-18T00:36:23Z" +"SeatingCapacity": "38" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "King" +"StreetNumber": "23" +"StreetSuffix": "Street" +"TaxLegalDescription": "0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4%+Hst" +"TransactionType": "For Sale" +"Utilities": array:1 [ …1] +"Zoning": "N/A" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "Annual" +"Expenses": "Estimated" +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12793294')" +"ChattelsYN": true +"GarageType": "None" +"FranchiseYN": true +"PropertyUse": "Without Property" +"ElevatorType": "None" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"LiquorLicenseYN": true +"PossessionDetails": "Flexible" +"IndustrialAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2026-04-02T20:08:03Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2026-04-21T16:30:06.789772Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:22 [ …22] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4302 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13024970" +"ListingId": "X13024970" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T15:10:31Z" +"RFModificationTimestamp": "2026-04-28T16:37:27Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1W3" +"UnparsedAddress": "312 Erb Street W 416, Waterloo, ON N2L 1W3" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE PARADISE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover living at at 312 Erb Street W, Waterloo, Ontario (Moda)! This upgraded 2 bedroom, 2 bathroom (Dona Model) newer,corner unit offers a perfect blend of comfort and convenience in a prime location. The unit has lot of natural light ,living space features large windows , and the open-concept layout seamlessly connects the living, dining, and kitchen areas, making it ideal for both relaxation and entertaining. The upgraded kitchen boasts modern stainless steel appliances and ample cabinetry, while the spacious bedrooms provides a peaceful retreat with a generous closet for all your storage needs. The sleek full bathrooms, featuring with a stylish design, is perfect for unwinding after a long day. This condo includes in-suite laundry for your convenience and a dedicated surface parking spot. Located in the heart of Waterloo, this home is just minutes away from the University of Waterloo, Wilfred Laurier University, shopping centres, restaurants, and public transit.Easy access to parks and recreational facilities.Upgrades in Kitchen,flooring and washrooms for more than $20K.One surface parking and a locker storage included.Internet covered in condo fee.The unit has a nice open balcony of 45 sqft as well" +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "581.01" +"AssociationFeeIncludes": array:2 [ …2] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-28T15:27:28.863853+00:00" +"CrossStreet": "Erb St W/University Ave" +"Directions": "Fischer Hallman and University to Erb St W" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-08-31" +"Inclusions": "Stainless Kitchen Appliances , White Dryer/Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"MainOfficeKey": "167500" +"MajorChangeTimestamp": "2026-04-21T15:09:52Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-21T15:09:52Z" +"OriginalListPrice": 530000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3836526" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T15:09:53Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "312" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3535.71" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"UnitNumber": "416" +"UFFI": "No" +"DDFYN": true +"Locker": "Owned" +"Sewage": array:1 [ …1] +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13024970')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "4" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1W3, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-01" +"PossessionType": "1-29 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 789 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 6 +"AlternativePower": array:1 [ …1] +"SquareFootSource": "Seller" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "16" +"MediaChangeTimestamp": "2026-04-21T15:09:53Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-04-21T15:10:36.577022Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:44 [ …44] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4301 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13024614" +"ListingId": "X13024614" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-21T15:05:09Z" +"RFModificationTimestamp": "2026-04-27T06:14:39Z" +"ListPrice": 2000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3H2" +"UnparsedAddress": "62 Balsam Street B207, Waterloo, ON N2L 3H2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4764213 +"Longitude": -80.5299914 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "UNION CAPITAL REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Sage 3 Unit B207 a stylish and meticulously maintained 1+1 bedroom, 1.5-bath condo located in the heart of Waterloo's thriving university district. Perfect for both end-users and investors, this 777 sq. ft. furnished suite offers modern open-concept living with granite countertops, stainless steel appliances, and ample kitchen storage. The spacious den provides flexibility to be used as a home office, guest space, or second bedroom offering the functionality of a two-bedroom unit without the extra cost. Enjoy in-suite laundry, and a large balcony with access from the living room. Just steps from Wilfrid Laurier University and the University of Waterloo, this unit is ideal for students, young professionals, or savvy investors. With its prime location, thoughtful layout, and strong rental appeal, Unit B207 is a smart and versatile investment opportunity." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:2 [ …2] +"Basement": array:1 [ …1] +"BuildingName": "Sage 3" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-21T16:23:52.560938+00:00" +"CrossStreet": "University Ave W & King St N" +"Directions": "University Ave W & King St N" +"Exclusions": "Hydro" +"ExpirationDate": "2026-10-01" +"Furnished": "Partially" +"GarageYN": true +"Inclusions": "Furniture included in the Unit: 1 x Bed + Mattress, 2 x Desk + Desk Chair. 1 x Night Stand, 2 x Loveseat, 1 x Armchair, 1 x Media Unit, 1 x 50" Flat Screen TV, 1 x Dining Table, 4 x Dining Chair, 1 x Coffee Table" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"LotSizeSource": "MPAC" +"MainOfficeKey": "337000" +"MajorChangeTimestamp": "2026-04-21T14:31:43Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-21T14:31:43Z" +"OriginalListPrice": 2000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3847588" +"ParcelNumber": "235940060" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-21T14:31:43Z" +"RentIncludes": array:6 [ …6] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Balsam" +"StreetNumber": "62" +"StreetSuffix": "Street" +"Topography": array:2 [ …2] +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "B207" +"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1Lvjm WNY1q6Yr TBs F1cy2ZYIyixas Mtgw/view?usp=drive_link" +"DDFYN": true +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13024614')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301604030001114" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 10 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3H2, CA" +"ApproximateAge": "11-15" +"ContractStatus": "Available" …35 } ] +success: true +page_size: 10 +page_count: 26 +count: 253 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4272 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4068 …125} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4069 …128} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4070 …129} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4071 …123} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4072 …148} ] +success: true +page_size: 5 +page_count: 8226 +count: 41128 +after_key: "" } ] ]
