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=20&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$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: 711817 +post_author: 1 +"ListingKey": "X13057102" +"ListingId": "X13057102" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:13:21Z" +"RFModificationTimestamp": "2026-04-29T17:04:40Z" +"ListPrice": 1800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W9" +"UnparsedAddress": "330 N Phillip Street W S109, Waterloo, ON N2L 3W9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AIMHOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Iconic building in University of Waterloo, the most desirable area for students, walking distance to all amenities and schools, full furnished condo to rent, included beds, chairs, closets, TVs, and Sofa, coffee table. AAA tenants, No smoking, No pets" +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:4 [ …4] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T15:54:17.116202+00:00" +"CrossStreet": "Columbia" +"Directions": "Phillip and Columbia" +"ExpirationDate": "2026-08-29" +"ExteriorFeatures": "Landscaped" +"FoundationDetails": array:1 [ …1] +"Furnished": "Furnished" +"Inclusions": "Utilities , Disk washer, stove, fridge, washer and dryer, 2 beds, computer desks, Tvs, couch, coffee table, and bar stools." +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "090900" +"MajorChangeTimestamp": "2026-04-29T14:13:21Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-29T14:13:21Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3888236" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T14:13:21Z" +"RentIncludes": array:6 [ …6] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirPrefix": "N" +"StreetDirSuffix": "W" +"StreetName": "Phillip" +"StreetNumber": "330" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 mth" +"TransactionType": "For Lease" +"UnitNumber": "s109" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057102')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Other" +"SurveyType": "Unknown" +"BalconyType": "None" +"LockerLevel": "A" +"HoldoverDays": 90 +"LegalStories": "01" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W9, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 627 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "as per Landlord" +"PossessionDetails": "Tba" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "s109" +"MediaChangeTimestamp": "2026-04-29T14:13:21Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Abode Student Life Inc." +"SystemModificationTimestamp": "2026-04-29T14:13:21.559743Z" +"Media": array:5 [ …5] +"ID": 711817 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "701399" +post_author: 1 +"ListingKey": "X13037378" +"ListingId": "X13037378" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:08:28Z" +"RFModificationTimestamp": "2026-04-30T05:01:56Z" +"ListPrice": 598900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2L9" +"UnparsedAddress": "636 Grange Crescent, Waterloo, ON N2T 2L9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4389229 +"Longitude": -80.5594752 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "FREEHOLD TOWNHOME located in the highly sought after neighbourhood in Waterloo West within walking distance to a vibrant Boardwalk shopping, medical center, restaurants and transit, close to hi-tech employment centres. Immaculate and beautifully maintained 3 bedroom & 2 bathroom unit featuring bright & airy open concept Living/Dining room flooded with sunlight, spacious eat-in Kitchen with sliding doors to upper deck, patio & fenced yard. Two piece Powder room & Laundry room with built-in storage completes the main floor. The second floor offers 3 spacious bedrooms & updated 4 piece Bathroom. The lower level offers finished Recroom/Office and inside access to the garage and walk-up to backyard. Updates include hi-efficiency furnace & AC (2018), water heater owned (2017), 2 updated bathrooms & flooring. Carpet-free throughout and ready to move-in and enjoy, perfect for a growing family or downsizers. Steps away from schools, parks, bus routes and short drive to both universities, Costco, YMCA and library. Short drive to Highway 7/8." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-23T19:58:59.586213+00:00" +"CrossStreet": "Baker Street" +"DirectionFaces": "West" +"Directions": "University Avenue West to Baker Street to Grange Crescent" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Carbon monoxide detectors, dishwasher, dryer, garage door opener, hot water tank, microwave, range hood, refrigerator, smoke detector, stove, washer, window coverings" +"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Floor Drain,Water Heater Owned,Water Meter" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-23" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T19:13:49Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-23T19:13:49Z" +"OriginalListPrice": 598900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3861688" +"ParcelNumber": "226920455" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-24T14:09:52Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Grange" +"StreetNumber": "636" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "3411.0" +"TaxAssessedValue": 249000 +"TaxLegalDescription": "Part Block 6 Plan 1726 City of Waterloo Part 4, 58R7772 S/T right in 1125736; S/T 1080503; Waterloo" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST." +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://milkmanmedia.hd.pics/636-Grange-Crescent" +"VirtualTourURLUnbranded": "https://milkmanmedia.hd.pics/636-Grange-Crescent/idx" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 94.36 +"LotWidth": 24.91 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13037378')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301603101000700" +"SurveyType": "Unknown" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-04-24T14:09:52Z" +"SystemModificationTimestamp": "2026-04-29T14:08:37.368676Z" +"Media": array:48 [ …48] +"ID": "701399" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: 711818 +post_author: 1 +"ListingKey": "X13057000" +"ListingId": "X13057000" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:03:34Z" +"RFModificationTimestamp": "2026-04-30T05:02:03Z" +"ListPrice": 1499900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 0B5" +"UnparsedAddress": "829 Copper Ridge Drive, Waterloo, ON N2K 0B5" +"Coordinates": array:2 [ …2] +"Latitude": 43.521424 +"Longitude": -80.493209 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX OPTIMUM REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "829 Copper Ridge Drive where timeless design meets everyday luxury in the heart of Carriage Crossing, one of Waterloo's most coveted communities.This exceptional former model home showcases refined upgrades, a thoughtfully designed layout, and a barely lived-in feel that truly sets it apart. From the moment you enter, you're welcomed by a sense of elegance that flows throughout. The main floor features separate living, dining, and family rooms, offering both privacy and functionality for everyday living and entertaining. A striking see-through fireplace connects the dining and family rooms, creating warmth and a seamless visual connection between the spaces.The kitchen is beautifully appointed with custom countertops, high-end appliances, and a spacious walk-in pantry-perfectly balancing style and practicality. Every detail reflects the craftsmanship and vision of a model home. Step outside to enjoy direct backyard access to a park, offering a rare blend of privacy, greenery, and an extended outdoor living experience.Upstairs, a versatile loft provides the ideal space for a home office, lounge, or study area, complemented by the convenience of upper-level laundry. All bedrooms are generously sized with direct bathroom access, while the primary and secondary bedrooms feature luxurious ensuite bathrooms, including double vanities in two, designed for both comfort and convenience.Impeccably maintained and lightly lived in, this home still feels like new.The location is truly unbeatable, with kilometres of scenic walking trails at your doorstep and close proximity to RIM Park, Grey Silo Golf Club, the Farmers' Market, and the Walter Bean Grand River Trail. Situated within the desirable Millen Woods Public School district and offering quick access to highways, universities, major employers, parks, and everyday amenities.A rare opportunity to own a move-in-ready home that blends style, function, and location-where every space feels right, and every moment feels like home." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CoListOfficeName": "RE/MAX OPTIMUM REALTY" +"CoListOfficePhone": "905-488-1260" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T14:14:06.480274+00:00" +"CrossStreet": "Millennium Blvd/ University Ave E" +"DirectionFaces": "East" +"Directions": "From Millennium Blvd & University Ave E, Waterloo, head toward Park Rd, turn right onto Crossgate Blvd, turn right onto Grey Silo Rd, turn left onto Deerfoot Trail, then turn right onto Copper Ridge Dr- 829 Copper Ridge Dr will be on the left." +"ExpirationDate": "2026-09-28" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All Elf's , S/S Appliances , Fridge , Stove, Washer and Dryer, Water Softner , Security System Equipment (Owned) + subscription monthly charge , Central Vacuum System." +"InteriorFeatures": "Other,Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "357900" +"MajorChangeTimestamp": "2026-04-29T14:03:34Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-29T14:03:34Z" +"OriginalListPrice": 1499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3888182" +"ParcelNumber": "227090507" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-29T14:03:34Z" +"PoolFeatures": "None" +"Roof": "Shingles" +"SecurityFeatures": array:1 [ …1] +"Sewer": "None" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "COPPER RIDGE" +"StreetNumber": "829" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "11248.0" +"TaxLegalDescription": "LOT 80, PLAN 58M506 ;T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 537 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574133 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574226 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://house.sf-photography-photographer.com/829-copper-ridge-dr-waterloo-ontario-n2j-4g8?branded=0" +"Zoning": "SR1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 109.91 +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057000')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601000107059" +"SurveyType": "None" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 0B5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 9 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-04-29T14:03:34Z" +"SystemModificationTimestamp": "2026-04-29T14:03:35.44974Z" +"Media": array:50 [ …50] +"ID": 711818 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "650949" +post_author: 1 +"ListingKey": "X12913032" +"ListingId": "X12913032" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:56:27Z" +"RFModificationTimestamp": "2026-04-29T14:27:19Z" +"ListPrice": 447900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 4T3" +"UnparsedAddress": "55 Blue Springs Drive Ph2, Waterloo, ON N2J 4T3" +"Coordinates": array:2 [ …2] +"Latitude": 43.488434 +"Longitude": -80.523064 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "M1 Real Estate Brokerage Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to penthouse living at its finest in the heart of Waterloo. This sophisticated two-bedroom, two-bathroom residence features a sleek, carpet-free interior and dramatic floor-to-ceiling windows with sweeping views of both serene green space and the vibrant cityscape. Enjoy exclusive access to exceptional building amenities, including a penthouse rooftop terrace, penthouse lounge, main party space, workshop, and private library. Complete with a storage locker, covered parking and ample visitor parking, this residence offers a refined urban lifestyle without compromise." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationFee": "709.0" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"CoListOfficeName": "M1 Real Estate Brokerage Ltd" +"CoListOfficePhone": "226-783-0811" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-23T11:10:57.052118+00:00" +"CrossStreet": "King St" +"Directions": "King St N to Blue Springs Dr" +"Exclusions": "Stand up freezer in kitchen, mirror in living room" +"ExpirationDate": "2026-06-26" +"Inclusions": "Fridge (2021), Stove (2021), Dishwasher, Washer (2024), Dryer - all appliances considered as is (everything is working)" +"InteriorFeatures": "Carpet Free,Storage,Storage Area Lockers" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-03-24" +"MainOfficeKey": "563400" +"MajorChangeTimestamp": "2026-04-29T13:56:27Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-24T12:07:09Z" +"OriginalListPrice": 459900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3681174" +"ParcelNumber": "231870424" +"ParkingFeatures": "Covered" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-24T12:07:09Z" +"PreviousListPrice": 459900.0 +"PriceChangeTimestamp": "2026-04-29T13:56:27Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Blue Springs" +"StreetNumber": "55" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2895.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "PH2" +"View": array:4 [ …4] +"VirtualTourURLBranded": "https://youriguide.com/ph_2_55_blue_springs_dr_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ph_2_55_blue_springs_dr_waterloo_on/" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913032')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Electric" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 60 +"LegalStories": "10" +"LockerNumber": "95" +"ParkingSpot1": "256" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-26" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 2 +"CondoCorpNumber": 187 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"SquareFootSource": "iguide" +"CoListOfficeName3": "M1 Real Estate Brokerage Ltd" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"LegalApartmentNumber": "PH2" +"MediaChangeTimestamp": "2026-03-31T14:38:48Z" +"PropertyManagementCompany": "CE PROPERTY MANAGEMENT AND CONSULTING INC." +"SystemModificationTimestamp": "2026-04-29T13:56:27.663676Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] +"ID": "650949" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "626738" +post_author: 1 +"ListingKey": "X12863610" +"ListingId": "X12863610" +"PropertyType": "Residential Lease" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:15:20Z" +"RFModificationTimestamp": "2026-04-29T14:06:27Z" +"ListPrice": 2000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3R2" +"UnparsedAddress": "275 Larch Street 216, Waterloo, ON N2L 3R2" +"Coordinates": array:2 [ …2] +"Latitude": 43.477165 +"Longitude": -80.531342 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RED APPLE REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located in the heart of waterloo close to Wilfrid Laurier and Waterloo Universities and Conestoga Mall. Very clean and safe building. 2 bedroom condo, fully furnished, includes internet" +"ArchitecturalStyle": "Apartment" +"Basement": array:1 [ …1] +"CoListOfficeName": "RED APPLE REAL ESTATE INC." +"CoListOfficePhone": "905-853-5955" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T13:43:52.017512+00:00" +"CrossStreet": "Columbia St W & Albert St" +"Directions": "Albert St to Hickory St to Larch St" +"ExpirationDate": "2026-05-11" +"Furnished": "Furnished" +"Inclusions": "All appliances.(stove, fridge ,oven)" +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-09" +"MainOfficeKey": "434600" +"MajorChangeTimestamp": "2026-04-21T20:38:57Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-09T20:27:51Z" +"OriginalListPrice": 2000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3583582" +"ParcelNumber": "236430295" +"ParkingFeatures": "None" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-09T20:27:51Z" +"PreviousListPrice": 1700.0 +"PriceChangeTimestamp": "2026-04-21T20:38:57Z" +"RentIncludes": array:5 [ …5] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Larch" +"StreetNumber": "275" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "216" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12863610')" +"GarageType": "None" +"HeatSource": "Electric" +"RollNumber": "301604270001249" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"HoldoverDays": 60 +"LegalStories": "2" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 643 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "owner" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "28" +"MediaChangeTimestamp": "2026-04-08T15:35:52Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Wilson Blanchard Management Co" +"SystemModificationTimestamp": "2026-04-29T13:15:27.18982Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:12 [ …12] +"ID": "626738" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853 +post_id: 711819 +post_author: 1 +"ListingKey": "X13056494" +"ListingId": "X13056494" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:12:09Z" +"RFModificationTimestamp": "2026-04-29T21:41:54Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 3K9" +"UnparsedAddress": "350 Auburn Drive, Waterloo, ON N2K 3K9" +"Coordinates": array:2 [ …2] +"Latitude": 43.49568 +"Longitude": -80.496532 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Mc Intyre Real Estate Services Inc." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully Updated Raised Bungalow in Desirable Waterloo! Welcome home to this stunning raised bungalow, thoughtfully updated and exceptionally maintained throughout. Featuring 2 + 2 bedrooms and 3 full bathrooms, including a private ensuite, this home offers both style and functionality for today's modern family. The main level showcases custom kitchen cabinetry, quartz countertops, and tasteful décor that creates a warm, inviting atmosphere. The fully finished basement adds even more living space with a spacious rec room, full bathroom, dedicated laundry room, and a convenient walk-up to the backyard. Step outside to your private, fully fenced yard, complete with attractive landscaping, a patio area perfect for entertaining, and a handy storage shed. A large single-car attached garage and double-wide driveway provide ample parking. Located in a fantastic family-friendly neighbourhood with quick highway access and close proximity to all amenities, this home truly checks all the boxes. Shows AAA+. Book your showing today!" +"ArchitecturalStyle": "Bungalow-Raised" +"Basement": array:3 [ …3] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T13:15:58.245097+00:00" +"CrossStreet": "Canterbury" +"DirectionFaces": "East" +"Directions": "University or Bridge to Auburn Drive" +"Exclusions": "Laundry Cabinets" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": "Patio" +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Washer, Dryer, Dishwasher, Window Coverings" +"InteriorFeatures": "Auto Garage Door Remote,Sump Pump,Water Softener,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "576700" +"MajorChangeTimestamp": "2026-04-29T13:12:09Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-29T13:12:09Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3881536" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "227200077" +"ParkingFeatures": "Private Double" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-29T13:12:09Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Auburn" +"StreetNumber": "350" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4342.0" +"TaxAssessedValue": 318000 +"TaxLegalDescription": "LT 52 PL 1626 CITY OF WATERLOO; S/T 883032; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+hst" +"TransactionType": "For Sale" +"Zoning": "SR1A" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 101.06 +"LotWidth": 54.21 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056494')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601016001325" +"SurveyType": "None" +"RentalItems": "None" +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 3K9, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 4 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Showingtime" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-29T13:12:09Z" +"SystemModificationTimestamp": "2026-04-29T13:12:10.163836Z" +"Media": array:48 [ …48] +"ID": 711819 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: 711820 +post_author: 1 +"ListingKey": "X13056462" +"ListingId": "X13056462" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:08:52Z" +"RFModificationTimestamp": "2026-04-29T15:22:30Z" +"ListPrice": 59900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 444.0 +"City": "Waterloo" +"PostalCode": "N2J 2Z3" +"UnparsedAddress": "380 King Street N 6a, Waterloo, ON N2J 2Z3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Home Life Power Realty Inc" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great opportunity to own a well-established nail & beauty business in a prime Waterloo location! Luna Nail & Beauty is situated at 380 King St N with excellent exposure and steady foot traffic. This turnkey operation offers 444 sq ft of efficiently designed space, operating 7 days a week (9:30 AM - 7:30 PM) with a loyal and stable client base. Strong online presence with an impressive 4.8-star average rating. Lease recently renewed for a 5-year term until March 31, 2031 at an attractive rent of only $2,500/month all inclusive including TMI and utilities . Ideal for owner-operators or investors looking to step into a profitable and growing business." +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Luna Nail & Beauty" +"BusinessType": array:1 [ …1] +"CommunityFeatures": "Public Transit" +"Cooling": "Yes" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T13:18:19.387008+00:00" +"CrossStreet": "Columbia St" +"Directions": "Off Columbia St W & Columbia St E" +"ExpirationDate": "2026-10-31" +"HoursDaysOfOperation": array:1 [ …1] +"HoursDaysOfOperationDescription": "Monday to Friday 9:30am-7:30pm; Saturday 9:30am-6pm; Sunday 11am-5pm." +"Inclusions": "See schedule C in online attachments" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-29" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "558800" +"MajorChangeTimestamp": "2026-04-29T13:08:52Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 2 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-29T13:08:52Z" +"OriginalListPrice": 59900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3885264" +"ParcelNumber": "222780131" +"PhotosChangeTimestamp": "2026-04-29T13:08:52Z" +"SeatingCapacity": "5" +"Sewer": "Storm" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "King" +"StreetNumber": "380" +"StreetSuffix": "Street" +"TaxAnnualAmount": "83786.0" +"TaxLegalDescription": "PT LT 1 PL 717 CITY OF WATERLOO; PT LT 7 GERMANY COMPANY TRACT TWP OF WATERLOO; PT LT 12 GERMAN COMPANY TRACT TWP OF WATERLOO AS IN 481370 &568758 EXCEPT PT 9 58R13661 ; WATERLOO" +"TaxYear": "2026" +"TransactionBrokerCompensation": "5%" +"TransactionType": "For Sale" +"UnitNumber": "6A" +"Zoning": "AC" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"LotWidth": 198.89 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056462')" +"ChattelsYN": true +"GarageType": "Outside/Surface" +"RetailArea": 444.0 +"RollNumber": "301601185008900" +"PropertyUse": "Without Property" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2Z3, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"WashroomsType1": 1 +"PossessionDetails": "Flexible" +"ShowingAppointments": "All showings must be booked through Broker Bay. Showing hours are as follows: Monday to Friday, 9:30 AM to 7:30 PM; Saturday, 9:30 AM to 6:00 PM; Sunday, 11:00 AM to 5:00 PM." +"MediaChangeTimestamp": "2026-04-29T13:08:52Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-29T13:08:52.62858Z" +"FinancialStatementAvailableYN": true +"Media": array:21 [ …21] +"ID": 711820 } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: 711821 +post_author: 1 +"ListingKey": "X13056400" +"ListingId": "X13056400" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:00:33Z" +"RFModificationTimestamp": "2026-04-29T15:22:30Z" +"ListPrice": 2400.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1A4" +"UnparsedAddress": "107 Roger Street 502, Waterloo, ON N2J 1A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.46019 +"Longitude": -80.5091859 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience modern luxury with this 969 sq. ft. corner-unit condo available for lease in Uptown Waterloo. This spacious home features 2 bedrooms, 2 bathrooms, and an open-concept layout, complete with luxury vinyl plank flooring, quartz countertops, and stainless steel appliances. Enjoy your private balcony with stunning views, and relax in the master suite that includes an ensuite bathroom and generous closet space. Residents also have access to amenities such as a BBQ area, party room, and gym. Ideally situated near shopping, dining, and transit, this condo offers both style and convenience for your next home." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:3 [ …3] +"Basement": array:1 [ …1] +"BuildingName": "Spur Line Common Building 2" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T13:04:49.034628+00:00" +"CrossStreet": "Moore Ave S - Roger St" +"Directions": "Moore Ave S - Roger St" +"ExpirationDate": "2026-07-29" +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer & Dryer." +"InteriorFeatures": "Water Heater" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-29T13:00:33Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-29T13:00:33Z" +"OriginalListPrice": 2400.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3886596" +"ParcelNumber": "237730359" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T13:00:33Z" +"RentIncludes": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Roger" +"StreetNumber": "107" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "502" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056400')" +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301602135005180" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "5" +"ParkingSpot1": "60" +"ParkingType1": "Owned" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1A4, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 773 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 5 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "MPAC" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "30" +"MediaChangeTimestamp": "2026-04-29T13:00:33Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Duka Property Management" +"SystemModificationTimestamp": "2026-04-29T13:00:33.374805Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:21 [ …21] +"ID": 711821 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "652354" +post_author: 1 +"ListingKey": "X12926274" +"ListingId": "X12926274" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T10:51:51Z" +"RFModificationTimestamp": "2026-04-29T10:56:27Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0G3" +"UnparsedAddress": "778 Laurelwood Drive 206, Waterloo, ON N2V 0G3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4712239 +"Longitude": -80.5987334 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THRIVE REALTY GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "THE BUNGALOW ALTERNATIVE | 1,000+ SQ. FT. OF EFFORTLESS LUXURY Stop compromising. Start living. If you've been searching for the privacy and space of a bungalow without the time consuming yard work or steep $900k price tag, Unit 206 at 778 Laurelwood Drive is your answer. This isn't just a condo; it's a masterclass in functional, high-end design. Situated in the heart of Waterloo's most prestigious Westside community, this sprawling 1000+ sq. ft. main floor layout offers the scale of a detached home with the "lock-and-leave" security of an executive residence. You will be impressed with the layout that highlights a private second floor balcony in a ground floor, 9 ft ceilings and clean functional finishes throughout. THE CHEF'S QUARTERS: Forget "apartment-sized" appliances. This massive open-concept kitchen features a literal wall of cabinetry, premium quartz counters, and a breakfast bar designed for Sunday morning coffee or evening wine with friends. SPACE TO BREATHE: The expansive living area is flooded with natural light, flowing seamlessly into a private balcony with views of the sunset-not a parking lot. THE PRIMARY RETREAT: A true King-sized suite featuring ample closet space and a spa-inspired 4-piece ensuite. ACCESSIBILITY FIRST: No stairs, no carpet, and a wide-entry layout that makes this the perfect "forever home" for those looking to downsize without downgrading. THE LIFESTYLE: Steps from Laurel Creek Conservation Area, the YMCA, and the Boardwalk's elite shopping and dining. You are surrounded by nature trails while being minutes from the University and Uptown. BETTER THAN NEW: Move-in ready with premium flooring, modern lighting, and a layout that rivals other building's penthouse suites. Private parking, a storage locker and amenities round out this complete package. Book your private tour today and see the true first class executive life style that is only found here at Reflections At Laurelwood." +"AccessibilityFeatures": array:7 [ …7] +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "424.22" +"AssociationFeeIncludes": array:3 [ …3] +"Basement": array:1 [ …1] +"BuildingName": "Reflections at Laurelwood" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T17:51:26.925116+00:00" +"CrossStreet": "Laurelwood Rd/Erbsville Rd" +"Directions": "Laurelwood Rd/Erbsville Rd" +"Exclusions": "None" +"ExpirationDate": "2026-09-17" +"ExteriorFeatures": "Controlled Entry" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Range Hood." +"InteriorFeatures": "Carpet Free,Water Heater,Storage,Storage Area Lockers" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "London and St. Thomas Association of REALTORS" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "396200" +"MajorChangeTimestamp": "2026-03-26T20:25:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-26T20:25:40Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3678214" +"ParcelNumber": "235520514" +"ParkingFeatures": "Reserved/Assigned,Surface" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T10:20:37Z" +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Laurelwood" +"StreetNumber": "778" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "3822.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0%" +"TransactionType": "For Sale" +"UnitNumber": "206" +"Zoning": "M100" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12926274')" +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604000126433" +"SurveyType": "None" +"BalconyType": "Terrace" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "A" +"LockerNumber": "13" +"ParkingSpot1": "147" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "6-10" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-27" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 552 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:1 [ …1] +"SquareFootSource": "Other" +"ParkingLevelUnit1": "Surface" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "83" +"MediaChangeTimestamp": "2026-04-29T10:20:37Z" +"HandicappedEquippedYN": true +"PropertyManagementCompany": "King Property Managment" +"SystemModificationTimestamp": "2026-04-29T10:51:57.048183Z" +"Media": array:29 [ …29] +"ID": "652354" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "707538" +post_author: 1 +"ListingKey": "X13054264" +"ListingId": "X13054264" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-28T22:23:00Z" +"RFModificationTimestamp": "2026-04-29T19:53:20Z" +"ListPrice": 2275000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N0B 2L0" +"UnparsedAddress": "1078 Berletts Road, Waterloo, ON N0B 2L0" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EASY LIST REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "*** Visit the REALTOR website for further information about this Listing *** Welcome to 1078 Berlett's Road-a truly one-of-a-kind property. This custom two-storey raised bungalow, built in 1967, offers 3,028 sq ft of beautifully renovated living space across two levels. With only two owners in its lifetime, it's easy to understand why once you arrive. The 3 + 1 bedroom, 2 bathroom layout charms immediately, set on 6.3 acres of wooded property just minutes from city conveniences. Located only 5 minutes from Costco and the Waterloo Boardwalk, yet steps from Schneider's Bush Conservation Area, you'll enjoy nature walks, bird watching, and cross-country skiing right at your doorstep. Inside, the home features a custom Acorn kitchen with granite countertops, hardwood flooring, and river-rock accents throughout. The inviting living room boasts 9' ceilings, double skylights, and built-in cabinetry framing a rustic lodge-style river-rock fireplace-an instant showpiece. Outdoor living is equally impressive, with two concrete patios (one covered, one open for fires) and two raised decks with glass railings, offering space to entertain, work, and relax. A highlight of the property is the 1,316 sq. ft. two-storey finished detached garage, built in 2013. With 11' ceilings, two overhead doors, heated floor, a wood stove, pellet stove, kitchen cabinetry, and a full home theatre, it's a dream workspace and retreat. Ascend the custom staircase-crafted from wood harvested directly from the property-to a spectacular games room complete with a fireplace and custom-built bar. Outfitted with a 12-foot projection screen, Bose surround sound, fridge, and stove, this cozy hideaway makes the perfect "dog house" or entertainment hub for any occasion." +"ArchitecturalStyle": "Backsplit 3" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "4.0" +"CreationDate": "2026-04-28T21:34:20.118408+00:00" +"CrossStreet": "Wilmot Line" +"DirectionFaces": "South" +"Directions": "ERBSVILLE TO WIDEMAN, WIDEMAN TO WILMOT, WILMOT TO BERLETTS, LEFT ON BERLETTS" +"ExpirationDate": "2026-07-27" +"ExteriorFeatures": "Deck,Landscape Lighting,Landscaped,Patio,Privacy,Porch,Recreational Area,Year Round Living" +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "4" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"Inclusions": "In detached garage: all appliances, theatre screen, Sony projector, Bose surround sound, wood rack, upper level Bose, smart TV, air hockey table, bar stools & dartboard. In solarium: Sauna, Bose surround & TV with cabinet." +"InteriorFeatures": "Auto Garage Door Remote,Bar Fridge,Built-In Oven,Carpet Free,Countertop Range,On Demand Water Heater,Primary Bedroom - Main Floor,Propane Tank,Sauna,Solar Tube,Storage,Upgraded Insulation,Water Heater Owned,Water Purifier,Water Softener,Water Treatment" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-28" +"MainOfficeKey": "461300" +"MajorChangeTimestamp": "2026-04-28T18:50:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-28T18:50:16Z" +"OriginalListPrice": 2275000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3885336" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "221730053" +"ParkingFeatures": "Circular Drive" +"ParkingTotal": "19.0" +"PhotosChangeTimestamp": "2026-04-28T18:50:16Z" +"PoolFeatures": "None" +"Roof": "Metal" +"SecurityFeatures": array:3 [ …3] +"Sewer": "Septic" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Berletts" +"StreetNumber": "1078" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7827.0" +"TaxLegalDescription": "PT LT 1 BLK B CON 3 WILMOT AS IN 1287468; WILMOT" +"TaxYear": "2025" +"Topography": array:5 [ …5] +"TransactionBrokerCompensation": "2% Seller Direct; $2 Listing Brokerage" +"TransactionType": "For Sale" +"View": array:3 [ …3] +"VirtualTourURLBranded": "https://unbranded.youriguide.com/1078_berlett_s_rd_st_agatha_on/" +"WaterSource": array:1 [ …1] +"DDFYN": true +"Water": "Well" +"GasYNA": "No" +"CableYNA": "No" +"HeatType": "Forced Air" +"LotDepth": 1092.0 +"LotWidth": 277.0 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13054264')" +"GarageType": "Attached" +"HeatSource": "Propane" +"RollNumber": "301808000812900" +"SurveyType": "Unknown" +"ElectricYNA": "Yes" +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 15 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:3 [ …3] +"SalesBrochureUrl": "https://www.forsalebyowner.ca/listing/house-for-sale-st-agatha-ON/784799" +"PossessionDetails": "Felxible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "519-572-1809" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2026-04-28T18:50:16Z" +"SystemModificationTimestamp": "2026-04-28T22:23:08.549586Z" +"Media": array:39 [ …39] +"ID": "707538" } ] +success: true +page_size: 10 +page_count: 28 +count: 276 +after_key: "" } "RF Response Time" => "0.28 seconds" ] "RF Cache Key: 2743e80d2b75f1bb3ca730a9ea8343cb8dd91afd70bb99829661259e1a5b2721" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3105 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4298 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13057102" +"ListingId": "X13057102" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:13:21Z" +"RFModificationTimestamp": "2026-04-29T17:04:40Z" +"ListPrice": 1800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W9" +"UnparsedAddress": "330 N Phillip Street W S109, Waterloo, ON N2L 3W9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AIMHOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Iconic building in University of Waterloo, the most desirable area for students, walking distance to all amenities and schools, full furnished condo to rent, included beds, chairs, closets, TVs, and Sofa, coffee table. AAA tenants, No smoking, No pets" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:4 [ …4] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T15:54:17.116202+00:00" +"CrossStreet": "Columbia" +"Directions": "Phillip and Columbia" +"ExpirationDate": "2026-08-29" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Furnished": "Furnished" +"Inclusions": "Utilities , Disk washer, stove, fridge, washer and dryer, 2 beds, computer desks, Tvs, couch, coffee table, and bar stools." +"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-29" +"MainOfficeKey": "090900" +"MajorChangeTimestamp": "2026-04-29T14:13:21Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-29T14:13:21Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3888236" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T14:13:21Z" +"RentIncludes": array:6 [ …6] +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirPrefix": "N" +"StreetDirSuffix": "W" +"StreetName": "Phillip" +"StreetNumber": "330" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 mth" +"TransactionType": "For Lease" +"UnitNumber": "s109" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057102')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Other" +"SurveyType": "Unknown" +"BalconyType": "None" +"LockerLevel": "A" +"HoldoverDays": 90 +"LegalStories": "01" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W9, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 627 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "as per Landlord" +"PossessionDetails": "Tba" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "s109" +"MediaChangeTimestamp": "2026-04-29T14:13:21Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Abode Student Life Inc." +"SystemModificationTimestamp": "2026-04-29T14:13:21.559743Z" +"Media": array:5 [ …5] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4299 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13037378" +"ListingId": "X13037378" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:08:28Z" +"RFModificationTimestamp": "2026-04-30T05:01:56Z" +"ListPrice": 598900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T 2L9" +"UnparsedAddress": "636 Grange Crescent, Waterloo, ON N2T 2L9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4389229 +"Longitude": -80.5594752 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "FREEHOLD TOWNHOME located in the highly sought after neighbourhood in Waterloo West within walking distance to a vibrant Boardwalk shopping, medical center, restaurants and transit, close to hi-tech employment centres. Immaculate and beautifully maintained 3 bedroom & 2 bathroom unit featuring bright & airy open concept Living/Dining room flooded with sunlight, spacious eat-in Kitchen with sliding doors to upper deck, patio & fenced yard. Two piece Powder room & Laundry room with built-in storage completes the main floor. The second floor offers 3 spacious bedrooms & updated 4 piece Bathroom. The lower level offers finished Recroom/Office and inside access to the garage and walk-up to backyard. Updates include hi-efficiency furnace & AC (2018), water heater owned (2017), 2 updated bathrooms & flooring. Carpet-free throughout and ready to move-in and enjoy, perfect for a growing family or downsizers. Steps away from schools, parks, bus routes and short drive to both universities, Costco, YMCA and library. Short drive to Highway 7/8." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-23T19:58:59.586213+00:00" +"CrossStreet": "Baker Street" +"DirectionFaces": "West" +"Directions": "University Avenue West to Baker Street to Grange Crescent" +"ExpirationDate": "2026-07-31" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Carbon monoxide detectors, dishwasher, dryer, garage door opener, hot water tank, microwave, range hood, refrigerator, smoke detector, stove, washer, window coverings" +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-23" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T19:13:49Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-23T19:13:49Z" +"OriginalListPrice": 598900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3861688" +"ParcelNumber": "226920455" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-24T14:09:52Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Grange" +"StreetNumber": "636" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "3411.0" +"TaxAssessedValue": 249000 +"TaxLegalDescription": "Part Block 6 Plan 1726 City of Waterloo Part 4, 58R7772 S/T right in 1125736; S/T 1080503; Waterloo" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST." +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://milkmanmedia.hd.pics/636-Grange-Crescent" +"VirtualTourURLUnbranded": "https://milkmanmedia.hd.pics/636-Grange-Crescent/idx" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 94.36 +"LotWidth": 24.91 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13037378')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301603101000700" +"SurveyType": "Unknown" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-04-24T14:09:52Z" +"SystemModificationTimestamp": "2026-04-29T14:08:37.368676Z" +"Media": array:48 [ …48] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4302 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13057000" +"ListingId": "X13057000" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T14:03:34Z" +"RFModificationTimestamp": "2026-04-30T05:02:03Z" +"ListPrice": 1499900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 0B5" +"UnparsedAddress": "829 Copper Ridge Drive, Waterloo, ON N2K 0B5" +"Coordinates": array:2 [ …2] +"Latitude": 43.521424 +"Longitude": -80.493209 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX OPTIMUM REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "829 Copper Ridge Drive where timeless design meets everyday luxury in the heart of Carriage Crossing, one of Waterloo's most coveted communities.This exceptional former model home showcases refined upgrades, a thoughtfully designed layout, and a barely lived-in feel that truly sets it apart. From the moment you enter, you're welcomed by a sense of elegance that flows throughout. The main floor features separate living, dining, and family rooms, offering both privacy and functionality for everyday living and entertaining. A striking see-through fireplace connects the dining and family rooms, creating warmth and a seamless visual connection between the spaces.The kitchen is beautifully appointed with custom countertops, high-end appliances, and a spacious walk-in pantry-perfectly balancing style and practicality. Every detail reflects the craftsmanship and vision of a model home. Step outside to enjoy direct backyard access to a park, offering a rare blend of privacy, greenery, and an extended outdoor living experience.Upstairs, a versatile loft provides the ideal space for a home office, lounge, or study area, complemented by the convenience of upper-level laundry. All bedrooms are generously sized with direct bathroom access, while the primary and secondary bedrooms feature luxurious ensuite bathrooms, including double vanities in two, designed for both comfort and convenience.Impeccably maintained and lightly lived in, this home still feels like new.The location is truly unbeatable, with kilometres of scenic walking trails at your doorstep and close proximity to RIM Park, Grey Silo Golf Club, the Farmers' Market, and the Walter Bean Grand River Trail. Situated within the desirable Millen Woods Public School district and offering quick access to highways, universities, major employers, parks, and everyday amenities.A rare opportunity to own a move-in-ready home that blends style, function, and location-where every space feels right, and every moment feels like home." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CoListOfficeName": "RE/MAX OPTIMUM REALTY" +"CoListOfficePhone": "905-488-1260" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-29T14:14:06.480274+00:00" +"CrossStreet": "Millennium Blvd/ University Ave E" +"DirectionFaces": "East" +"Directions": "From Millennium Blvd & University Ave E, Waterloo, head toward Park Rd, turn right onto Crossgate Blvd, turn right onto Grey Silo Rd, turn left onto Deerfoot Trail, then turn right onto Copper Ridge Dr- 829 Copper Ridge Dr will be on the left." +"ExpirationDate": "2026-09-28" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All Elf's , S/S Appliances , Fridge , Stove, Washer and Dryer, Water Softner , Security System Equipment (Owned) + subscription monthly charge , Central Vacuum System." +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "357900" +"MajorChangeTimestamp": "2026-04-29T14:03:34Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-29T14:03:34Z" +"OriginalListPrice": 1499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3888182" +"ParcelNumber": "227090507" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-29T14:03:34Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "COPPER RIDGE" +"StreetNumber": "829" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "11248.0" +"TaxLegalDescription": "LOT 80, PLAN 58M506 ;T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 537 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574133 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574226 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://house.sf-photography-photographer.com/829-copper-ridge-dr-waterloo-ontario-n2j-4g8?branded=0" +"Zoning": "SR1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 109.91 +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057000')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601000107059" +"SurveyType": "None" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 0B5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 9 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-04-29T14:03:34Z" +"SystemModificationTimestamp": "2026-04-29T14:03:35.44974Z" +"Media": array:50 [ …50] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4301 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12913032" +"ListingId": "X12913032" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:56:27Z" +"RFModificationTimestamp": "2026-04-29T14:27:19Z" +"ListPrice": 447900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 4T3" +"UnparsedAddress": "55 Blue Springs Drive Ph2, Waterloo, ON N2J 4T3" +"Coordinates": array:2 [ …2] +"Latitude": 43.488434 +"Longitude": -80.523064 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "M1 Real Estate Brokerage Ltd" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to penthouse living at its finest in the heart of Waterloo. This sophisticated two-bedroom, two-bathroom residence features a sleek, carpet-free interior and dramatic floor-to-ceiling windows with sweeping views of both serene green space and the vibrant cityscape. Enjoy exclusive access to exceptional building amenities, including a penthouse rooftop terrace, penthouse lounge, main party space, workshop, and private library. Complete with a storage locker, covered parking and ample visitor parking, this residence offers a refined urban lifestyle without compromise." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "709.0" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"CoListOfficeName": "M1 Real Estate Brokerage Ltd" +"CoListOfficePhone": "226-783-0811" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-23T11:10:57.052118+00:00" +"CrossStreet": "King St" +"Directions": "King St N to Blue Springs Dr" +"Exclusions": "Stand up freezer in kitchen, mirror in living room" +"ExpirationDate": "2026-06-26" +"Inclusions": "Fridge (2021), Stove (2021), Dishwasher, Washer (2024), Dryer - all appliances considered as is (everything is working)" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-03-24" +"MainOfficeKey": "563400" +"MajorChangeTimestamp": "2026-04-29T13:56:27Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-24T12:07:09Z" +"OriginalListPrice": 459900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3681174" +"ParcelNumber": "231870424" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-24T12:07:09Z" +"PreviousListPrice": 459900.0 +"PriceChangeTimestamp": "2026-04-29T13:56:27Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Blue Springs" +"StreetNumber": "55" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2895.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "PH2" +"View": array:4 [ …4] +"VirtualTourURLBranded": "https://youriguide.com/ph_2_55_blue_springs_dr_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ph_2_55_blue_springs_dr_waterloo_on/" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913032')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Electric" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 60 +"LegalStories": "10" +"LockerNumber": "95" +"ParkingSpot1": "256" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-06-26" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 2 +"CondoCorpNumber": 187 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"SquareFootSource": "iguide" +"CoListOfficeName3": "M1 Real Estate Brokerage Ltd" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"LegalApartmentNumber": "PH2" +"MediaChangeTimestamp": "2026-03-31T14:38:48Z" +"PropertyManagementCompany": "CE PROPERTY MANAGEMENT AND CONSULTING INC." +"SystemModificationTimestamp": "2026-04-29T13:56:27.663676Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ …48] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4300 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12863610" +"ListingId": "X12863610" +"PropertyType": "Residential Lease" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:15:20Z" +"RFModificationTimestamp": "2026-04-29T14:06:27Z" +"ListPrice": 2000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3R2" +"UnparsedAddress": "275 Larch Street 216, Waterloo, ON N2L 3R2" +"Coordinates": array:2 [ …2] +"Latitude": 43.477165 +"Longitude": -80.531342 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RED APPLE REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located in the heart of waterloo close to Wilfrid Laurier and Waterloo Universities and Conestoga Mall. Very clean and safe building. 2 bedroom condo, fully furnished, includes internet" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CoListOfficeName": "RED APPLE REAL ESTATE INC." +"CoListOfficePhone": "905-853-5955" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T13:43:52.017512+00:00" +"CrossStreet": "Columbia St W & Albert St" +"Directions": "Albert St to Hickory St to Larch St" +"ExpirationDate": "2026-05-11" +"Furnished": "Furnished" +"Inclusions": "All appliances.(stove, fridge ,oven)" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-09" +"MainOfficeKey": "434600" +"MajorChangeTimestamp": "2026-04-21T20:38:57Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-09T20:27:51Z" +"OriginalListPrice": 2000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3583582" +"ParcelNumber": "236430295" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-09T20:27:51Z" +"PreviousListPrice": 1700.0 +"PriceChangeTimestamp": "2026-04-21T20:38:57Z" +"RentIncludes": array:5 [ …5] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Larch" +"StreetNumber": "275" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "216" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12863610')" +"GarageType": "None" +"HeatSource": "Electric" +"RollNumber": "301604270001249" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"BalconyType": "Open" +"HoldoverDays": 60 +"LegalStories": "2" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2026-05-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 643 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "owner" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "28" +"MediaChangeTimestamp": "2026-04-08T15:35:52Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Wilson Blanchard Management Co" +"SystemModificationTimestamp": "2026-04-29T13:15:27.18982Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:12 [ …12] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4297 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13056494" +"ListingId": "X13056494" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:12:09Z" +"RFModificationTimestamp": "2026-04-29T21:41:54Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 3K9" +"UnparsedAddress": "350 Auburn Drive, Waterloo, ON N2K 3K9" +"Coordinates": array:2 [ …2] +"Latitude": 43.49568 +"Longitude": -80.496532 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Mc Intyre Real Estate Services Inc." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully Updated Raised Bungalow in Desirable Waterloo! Welcome home to this stunning raised bungalow, thoughtfully updated and exceptionally maintained throughout. Featuring 2 + 2 bedrooms and 3 full bathrooms, including a private ensuite, this home offers both style and functionality for today's modern family. The main level showcases custom kitchen cabinetry, quartz countertops, and tasteful décor that creates a warm, inviting atmosphere. The fully finished basement adds even more living space with a spacious rec room, full bathroom, dedicated laundry room, and a convenient walk-up to the backyard. Step outside to your private, fully fenced yard, complete with attractive landscaping, a patio area perfect for entertaining, and a handy storage shed. A large single-car attached garage and double-wide driveway provide ample parking. Located in a fantastic family-friendly neighbourhood with quick highway access and close proximity to all amenities, this home truly checks all the boxes. Shows AAA+. Book your showing today!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:3 [ …3] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T13:15:58.245097+00:00" +"CrossStreet": "Canterbury" +"DirectionFaces": "East" +"Directions": "University or Bridge to Auburn Drive" +"Exclusions": "Laundry Cabinets" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Washer, Dryer, Dishwasher, Window Coverings" +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "576700" +"MajorChangeTimestamp": "2026-04-29T13:12:09Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-29T13:12:09Z" +"OriginalListPrice": 699900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3881536" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "227200077" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-29T13:12:09Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Auburn" +"StreetNumber": "350" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4342.0" +"TaxAssessedValue": 318000 +"TaxLegalDescription": "LT 52 PL 1626 CITY OF WATERLOO; S/T 883032; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+hst" +"TransactionType": "For Sale" +"Zoning": "SR1A" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 101.06 +"LotWidth": 54.21 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056494')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601016001325" +"SurveyType": "None" +"RentalItems": "None" +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 3K9, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 4 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Showingtime" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-29T13:12:09Z" +"SystemModificationTimestamp": "2026-04-29T13:12:10.163836Z" +"Media": array:48 [ …48] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4296 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13056462" +"ListingId": "X13056462" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:08:52Z" +"RFModificationTimestamp": "2026-04-29T15:22:30Z" +"ListPrice": 59900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 444.0 +"City": "Waterloo" +"PostalCode": "N2J 2Z3" +"UnparsedAddress": "380 King Street N 6a, Waterloo, ON N2J 2Z3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Home Life Power Realty Inc" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great opportunity to own a well-established nail & beauty business in a prime Waterloo location! Luna Nail & Beauty is situated at 380 King St N with excellent exposure and steady foot traffic. This turnkey operation offers 444 sq ft of efficiently designed space, operating 7 days a week (9:30 AM - 7:30 PM) with a loyal and stable client base. Strong online presence with an impressive 4.8-star average rating. Lease recently renewed for a 5-year term until March 31, 2031 at an attractive rent of only $2,500/month all inclusive including TMI and utilities . Ideal for owner-operators or investors looking to step into a profitable and growing business." +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Luna Nail & Beauty" +"BusinessType": array:1 [ …1] +"CommunityFeatures": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-29T13:18:19.387008+00:00" +"CrossStreet": "Columbia St" +"Directions": "Off Columbia St W & Columbia St E" +"ExpirationDate": "2026-10-31" +"HoursDaysOfOperation": array:1 [ …1] +"HoursDaysOfOperationDescription": "Monday to Friday 9:30am-7:30pm; Saturday 9:30am-6pm; Sunday 11am-5pm." +"Inclusions": "See schedule C in online attachments" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-04-29" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "558800" +"MajorChangeTimestamp": "2026-04-29T13:08:52Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 2 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-04-29T13:08:52Z" +"OriginalListPrice": 59900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3885264" +"ParcelNumber": "222780131" +"PhotosChangeTimestamp": "2026-04-29T13:08:52Z" +"SeatingCapacity": "5" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "King" +"StreetNumber": "380" +"StreetSuffix": "Street" +"TaxAnnualAmount": "83786.0" +"TaxLegalDescription": "PT LT 1 PL 717 CITY OF WATERLOO; PT LT 7 GERMANY COMPANY TRACT TWP OF WATERLOO; PT LT 12 GERMAN COMPANY TRACT TWP OF WATERLOO AS IN 481370 &568758 EXCEPT PT 9 58R13661 ; WATERLOO" +"TaxYear": "2026" +"TransactionBrokerCompensation": "5%" +"TransactionType": "For Sale" +"UnitNumber": "6A" +"Zoning": "AC" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"LotWidth": 198.89 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056462')" +"ChattelsYN": true +"GarageType": "Outside/Surface" +"RetailArea": 444.0 +"RollNumber": "301601185008900" +"PropertyUse": "Without Property" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2Z3, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"WashroomsType1": 1 +"PossessionDetails": "Flexible" +"ShowingAppointments": "All showings must be booked through Broker Bay. Showing hours are as follows: Monday to Friday, 9:30 AM to 7:30 PM; Saturday, 9:30 AM to 6:00 PM; Sunday, 11:00 AM to 5:00 PM." +"MediaChangeTimestamp": "2026-04-29T13:08:52Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-29T13:08:52.62858Z" +"FinancialStatementAvailableYN": true +"Media": array:21 [ …21] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4295 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13056400" +"ListingId": "X13056400" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T13:00:33Z" +"RFModificationTimestamp": "2026-04-29T15:22:30Z" +"ListPrice": 2400.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1A4" +"UnparsedAddress": "107 Roger Street 502, Waterloo, ON N2J 1A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.46019 +"Longitude": -80.5091859 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience modern luxury with this 969 sq. ft. corner-unit condo available for lease in Uptown Waterloo. This spacious home features 2 bedrooms, 2 bathrooms, and an open-concept layout, complete with luxury vinyl plank flooring, quartz countertops, and stainless steel appliances. Enjoy your private balcony with stunning views, and relax in the master suite that includes an ensuite bathroom and generous closet space. Residents also have access to amenities such as a BBQ area, party room, and gym. Ideally situated near shopping, dining, and transit, this condo offers both style and convenience for your next home." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:3 [ …3] +"Basement": array:1 [ …1] +"BuildingName": "Spur Line Common Building 2" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-29T13:04:49.034628+00:00" +"CrossStreet": "Moore Ave S - Roger St" +"Directions": "Moore Ave S - Roger St" +"ExpirationDate": "2026-07-29" +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer & Dryer." +"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-29" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-04-29T13:00:33Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-04-29T13:00:33Z" +"OriginalListPrice": 2400.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3886596" +"ParcelNumber": "237730359" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T13:00:33Z" +"RentIncludes": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Roger" +"StreetNumber": "107" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "502" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13056400')" +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301602135005180" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "5" +"ParkingSpot1": "60" +"ParkingType1": "Owned" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1A4, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 773 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 5 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "MPAC" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "30" +"MediaChangeTimestamp": "2026-04-29T13:00:33Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Duka Property Management" +"SystemModificationTimestamp": "2026-04-29T13:00:33.374805Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:21 [ …21] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4294 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12926274" +"ListingId": "X12926274" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T10:51:51Z" +"RFModificationTimestamp": "2026-04-29T10:56:27Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0G3" +"UnparsedAddress": "778 Laurelwood Drive 206, Waterloo, ON N2V 0G3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4712239 +"Longitude": -80.5987334 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THRIVE REALTY GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "THE BUNGALOW ALTERNATIVE | 1,000+ SQ. FT. OF EFFORTLESS LUXURY Stop compromising. Start living. If you've been searching for the privacy and space of a bungalow without the time consuming yard work or steep $900k price tag, Unit 206 at 778 Laurelwood Drive is your answer. This isn't just a condo; it's a masterclass in functional, high-end design. Situated in the heart of Waterloo's most prestigious Westside community, this sprawling 1000+ sq. ft. main floor layout offers the scale of a detached home with the "lock-and-leave" security of an executive residence. You will be impressed with the layout that highlights a private second floor balcony in a ground floor, 9 ft ceilings and clean functional finishes throughout. THE CHEF'S QUARTERS: Forget "apartment-sized" appliances. This massive open-concept kitchen features a literal wall of cabinetry, premium quartz counters, and a breakfast bar designed for Sunday morning coffee or evening wine with friends. SPACE TO BREATHE: The expansive living area is flooded with natural light, flowing seamlessly into a private balcony with views of the sunset-not a parking lot. THE PRIMARY RETREAT: A true King-sized suite featuring ample closet space and a spa-inspired 4-piece ensuite. ACCESSIBILITY FIRST: No stairs, no carpet, and a wide-entry layout that makes this the perfect "forever home" for those looking to downsize without downgrading. THE LIFESTYLE: Steps from Laurel Creek Conservation Area, the YMCA, and the Boardwalk's elite shopping and dining. You are surrounded by nature trails while being minutes from the University and Uptown. BETTER THAN NEW: Move-in ready with premium flooring, modern lighting, and a layout that rivals other building's penthouse suites. Private parking, a storage locker and amenities round out this complete package. Book your private tour today and see the true first class executive life style that is only found here at Reflections At Laurelwood." +"AccessibilityFeatures": array:7 [ …7] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:5 [ …5] +"AssociationFee": "424.22" +"AssociationFeeIncludes": array:3 [ …3] +"Basement": array:1 [ …1] +"BuildingName": "Reflections at Laurelwood" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-28T17:51:26.925116+00:00" +"CrossStreet": "Laurelwood Rd/Erbsville Rd" +"Directions": "Laurelwood Rd/Erbsville Rd" +"Exclusions": "None" +"ExpirationDate": "2026-09-17" +"ExteriorFeatures": array:1 [ …1] +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer, Dryer, Range Hood." +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "London and St. Thomas Association of REALTORS" +"ListingContractDate": "2026-03-26" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "396200" +"MajorChangeTimestamp": "2026-03-26T20:25:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-26T20:25:40Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3678214" +"ParcelNumber": "235520514" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-04-29T10:20:37Z" +"SecurityFeatures": array:2 [ …2] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Laurelwood" +"StreetNumber": "778" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "3822.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0%" +"TransactionType": "For Sale" +"UnitNumber": "206" +"Zoning": "M100" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12926274')" +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604000126433" +"SurveyType": "None" +"BalconyType": "Terrace" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "A" +"LockerNumber": "13" +"ParkingSpot1": "147" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "6-10" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-27" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 552 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:1 [ …1] +"SquareFootSource": "Other" +"ParkingLevelUnit1": "Surface" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "83" +"MediaChangeTimestamp": "2026-04-29T10:20:37Z" +"HandicappedEquippedYN": true +"PropertyManagementCompany": "King Property Managment" +"SystemModificationTimestamp": "2026-04-29T10:51:57.048183Z" +"Media": array:29 [ …29] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4293 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13054264" +"ListingId": "X13054264" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-28T22:23:00Z" +"RFModificationTimestamp": "2026-04-29T19:53:20Z" +"ListPrice": 2275000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N0B 2L0" +"UnparsedAddress": "1078 Berletts Road, Waterloo, ON N0B 2L0" +"Coordinates": array:2 [ …2] +"Latitude": 43.4652699 +"Longitude": -80.5222961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EASY LIST REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "*** Visit the REALTOR website for further information about this Listing *** Welcome to 1078 Berlett's Road-a truly one-of-a-kind property. This custom two-storey raised bungalow, built in 1967, offers 3,028 sq ft of beautifully renovated living space across two levels. With only two owners in its lifetime, it's easy to understand why once you arrive. The 3 + 1 bedroom, 2 bathroom layout charms immediately, set on 6.3 acres of wooded property just minutes from city conveniences. Located only 5 minutes from Costco and the Waterloo Boardwalk, yet steps from Schneider's Bush Conservation Area, you'll enjoy nature walks, bird watching, and cross-country skiing right at your doorstep. Inside, the home features a custom Acorn kitchen with granite countertops, hardwood flooring, and river-rock accents throughout. The inviting living room boasts 9' ceilings, double skylights, and built-in cabinetry framing a rustic lodge-style river-rock fireplace-an instant showpiece. Outdoor living is equally impressive, with two concrete patios (one covered, one open for fires) and two raised decks with glass railings, offering space to entertain, work, and relax. A highlight of the property is the 1,316 sq. ft. two-storey finished detached garage, built in 2013. With 11' ceilings, two overhead doors, heated floor, a wood stove, pellet stove, kitchen cabinetry, and a full home theatre, it's a dream workspace and retreat. Ascend the custom staircase-crafted from wood harvested directly from the property-to a spectacular games room complete with a fireplace and custom-built bar. Outfitted with a 12-foot projection screen, Bose surround sound, fridge, and stove, this cozy hideaway makes the perfect "dog house" or entertainment hub for any occasion." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "4.0" +"CreationDate": "2026-04-28T21:34:20.118408+00:00" +"CrossStreet": "Wilmot Line" +"DirectionFaces": "South" +"Directions": "ERBSVILLE TO WIDEMAN, WIDEMAN TO WILMOT, WILMOT TO BERLETTS, LEFT ON BERLETTS" +"ExpirationDate": "2026-07-27" +"ExteriorFeatures": array:8 [ …8] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "4" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"Inclusions": "In detached garage: all appliances, theatre screen, Sony projector, Bose surround sound, wood rack, upper level Bose, smart TV, air hockey table, bar stools & dartboard. In solarium: Sauna, Bose surround & TV with cabinet." +"InteriorFeatures": array:16 [ …16] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-28" +"MainOfficeKey": "461300" +"MajorChangeTimestamp": "2026-04-28T18:50:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-28T18:50:16Z" +"OriginalListPrice": 2275000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3885336" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "221730053" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "19.0" +"PhotosChangeTimestamp": "2026-04-28T18:50:16Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Berletts" +"StreetNumber": "1078" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7827.0" +"TaxLegalDescription": "PT LT 1 BLK B CON 3 WILMOT AS IN 1287468; WILMOT" +"TaxYear": "2025" +"Topography": array:5 [ …5] +"TransactionBrokerCompensation": "2% Seller Direct; $2 Listing Brokerage" +"TransactionType": "For Sale" +"View": array:3 [ …3] +"VirtualTourURLBranded": "https://unbranded.youriguide.com/1078_berlett_s_rd_st_agatha_on/" +"WaterSource": array:1 [ …1] +"DDFYN": true +"Water": "Well" +"GasYNA": "No" +"CableYNA": "No" +"HeatType": "Forced Air" +"LotDepth": 1092.0 +"LotWidth": 277.0 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13054264')" +"GarageType": "Attached" +"HeatSource": "Propane" +"RollNumber": "301808000812900" +"SurveyType": "Unknown" +"ElectricYNA": "Yes" +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 15 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" …23 } ] +success: true +page_size: 10 +page_count: 28 +count: 276 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4283 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …115} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …111} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …117} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4078 …117} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4079 …125} ] +success: true +page_size: 5 +page_count: 9455 +count: 47272 +after_key: "" } ] ]