array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$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: "689786"
+post_author: 1
+"ListingKey": "X12913496"
+"ListingId": "X12913496"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:53:45Z"
+"RFModificationTimestamp": "2026-04-29T17:56:49Z"
+"ListPrice": 580000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0G6"
+"UnparsedAddress": "245 Grey Silo Road 302, Waterloo, ON N2K 0G6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.52174
+"Longitude": -80.49558
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Red And White Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautiful 2-bedroom, 2-bath executive condo located in the highly sought-after Carriage Crossing neighbourhood. This bright corner unit, just 4 years old, enjoys west-facing exposure with no direct neighbouring views, allowing for plenty of natural light throughout the day. The modern open-concept kitchen features quartz countertops, a stylish herringbone backsplash, under-cabinet lighting, a large island, stainless steel appliances, and plenty of storage-perfect for everyday cooking or entertaining guests. The sun-filled living area offers engineered hardwood flooring, upgraded lighting, and direct access to an expansive wraparound balcony. With two separate seating areas and wide open panoramic views, it's an ideal spot to unwind with a drink after a long day. The spacious primary bedroom includes two closets and a private ensuite featuring a spa-inspired glass shower with built-in bench. The second bedroom is generously sized and filled with natural light, making it perfect for guests, a home office, or additional living space. Both bathrooms are finished with granite countertops and upgraded fixtures. This unit also includes a convenient drive-in underground parking space with a large private storage locker located directly in front, making access simple and practical. Additional features include in-suite laundry, water heater, and water softener. Residents enjoy access to an incredible rooftop terrace complete with planter gardens, comfortable seating areas, a fire table, communal BBQ, and stunning views-a wonderful place to gather with friends or relax outdoors. Fantastic location close to Rim Park, Grey Silo Golf Club, Black Berry, scenic walking and biking trails, Brown's Social House, Conestoga Mall, and the St. Jacobs Farmers' Market. Experience the ease and comfort of condo living in one of Waterloo's most desirable communities."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "522.63"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-26T20:13:42.229923+00:00"
+"CrossStreet": "Millennium Blvd and Oak Park Drive"
+"Directions": "University Ave to Millennium Blvd to Oak Park Drive to Grey Silo Road."
+"ExpirationDate": "2026-12-24"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "575000"
+"MajorChangeTimestamp": "2026-04-29T17:53:45Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T13:28:50Z"
+"OriginalListPrice": 619000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3711868"
+"ParcelNumber": "237120043"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T13:28:51Z"
+"PreviousListPrice": 619000.0
+"PriceChangeTimestamp": "2026-04-29T17:53:45Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Grey Silo"
+"StreetNumber": "245"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4394.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "302"
+"Zoning": "R9"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913496')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"LockerUnit": "1010"
+"RollNumber": "301601000107740"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LegalStories": "3"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 712
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "i-Guide"
+"PossessionDetails": "Flexible. Tenat has given notice"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please use Showing Time or call +1 833-322-9934. Lock box is located on the railing to the right of visitor parking. Tenat requires 24HR notice for showings."
+"LegalApartmentNumber": "302"
+"MediaChangeTimestamp": "2026-03-24T13:28:51Z"
+"PropertyManagementCompany": "King Condo Management In"
+"SystemModificationTimestamp": "2026-04-29T17:53:45.130069Z"
+"VendorPropertyInfoStatement": true
+"Media": array:34 [ …34]
+"ID": "689786"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "686748"
+post_author: 1
+"ListingKey": "X13014582"
+"ListingId": "X13014582"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:50:42Z"
+"RFModificationTimestamp": "2026-04-29T17:59:48Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0C6"
+"UnparsedAddress": "188 King Street S 207, Waterloo, ON N2J 0C6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this spacious and thoughtfully designed 1-bedroom suite offering approximately 820 sq ft of comfortable living in the heart of Uptown Waterloo. Located in one of the area's most desirable mid-rise buildings, this unit provides a great balance of space, style, and convenience. The open-concept layout is ideal for everyday living, featuring a modern kitchen with abundance cabinetry, over sized island , stainless steel appliances complimented with granite counter-top. The living area is bright and inviting, with large windows that bring in plenty of natural light and a Juliet balcony with views of King St The primary bedroom offers double closet. The bathroom is well-appointed with sleek fixtures and a practical layout. Enjoy amenities including the gym, party room, and your private storage locker. Parking is located in the above-ground garage . RECENT UPDATES include : Updated bathroom , Washer, Dryer and Bosch dishwasher , backsplash. Step outside and you're just minutes from Vincenzo's, Mary-Allen Park, and the vibrant shops and restaurants of Uptown Waterloo. With the LRT at your doorstep, commuting across the city is quick and easy. This well-maintained building offers a quiet, community-oriented lifestyle while keeping you close to everything. A great opportunity for first-time buyers, professionals, or investors alike."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "410.87"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T00:50:58.131419+00:00"
+"CrossStreet": "Allen"
+"Directions": "King St S. & Allen St. W."
+"ExpirationDate": "2026-07-17"
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-04-17T20:55:38Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-17T20:55:38Z"
+"OriginalListPrice": 350000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3813482"
+"ParcelNumber": "235620007"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T20:55:39Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "188"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4096.0"
+"TaxAssessedValue": 299000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "207"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014582')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301602090004112"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "207"
+"ParkingType1": "Common"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 562
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Other"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Book Through Brokerbay. The lock box is located on the railing on the back entrance of our office . Coming down King towards Waterloo , turn right on Willis way and make first right into the alley way , it will be the first entrance to your right ."
+"LegalApartmentNumber": "4"
+"MediaChangeTimestamp": "2026-04-29T17:50:42Z"
+"PropertyManagementCompany": "Prudential Propt. Mgmt"
+"SystemModificationTimestamp": "2026-04-29T17:50:46.406337Z"
+"Media": array:43 [ …43]
+"ID": "686748"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "625009"
+post_author: 1
+"ListingKey": "X12858490"
+"ListingId": "X12858490"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:41:36Z"
+"RFModificationTimestamp": "2026-04-29T19:52:26Z"
+"ListPrice": 599800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T8"
+"UnparsedAddress": "338 Albert Street 219, Waterloo, ON N2L 3T8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort and exceptional investment value in this spacious upper-level stacked condo at Ivy Towns 3 by IN8 Developments. Offering 1,777 sq. ft. across two thoughtfully designed levels, this 3-bedroom, 3-bathroom home features durable porcelain and laminate flooring, a bright open-concept living and dining area, and a stylish kitchen with stainless steel appliances and granite countertops. A versatile den-easily used as a fourth bedroom-adds valuable flexibility, while two main-floor balconies provide inviting outdoor spaces to relax and unwind. The upper level includes three generously sized bedrooms and two full four-piece bathrooms, creating an ideal layout for students, professionals, or investors seeking strong rental appeal. Additional conveniences include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot just steps from the entrance. Built in 2018 and exceptionally well maintained, this fully furnished unit offers a true turnkey opportunity for buyers or investors. Perfectly located within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, and close to Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this property delivers unmatched accessibility and long-term value."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:52:12.123476+00:00"
+"CrossStreet": "Columbia St West/ Albert St/ University Ave"
+"Directions": "Columbia St W/ Albert St/ University"
+"ExpirationDate": "2026-05-31"
+"HeatingYN": true
+"Inclusions": "All Electric Fixtures, All window Coverings, All furniture that belongs to the Seller. Washer, Dryer, Fridge, Stove"
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-07"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-01T22:09:49Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-07T19:47:04Z"
+"OriginalListPrice": 619900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3640918"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-09T17:21:01Z"
+"PreviousListPrice": 619900.0
+"PriceChangeTimestamp": "2026-04-01T22:09:49Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "8"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% + HST + 1000 Bonus"
+"TransactionType": "For Sale"
+"UnitNumber": "219"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12858490')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"ParkingSpot1": "67"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "19"
+"MediaChangeTimestamp": "2026-03-09T17:21:01Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-29T17:41:43.099237Z"
+"Media": array:24 [ …24]
+"ID": "625009"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "627169"
+post_author: 1
+"ListingKey": "X12862846"
+"ListingId": "X12862846"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:37:31Z"
+"RFModificationTimestamp": "2026-04-29T18:15:10Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0G8"
+"UnparsedAddress": "338 Albert Street 217, Waterloo, ON N2L 0G8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4781765
+"Longitude": -80.5339477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort and exceptional investment potential in this spacious upper-level stacked condo, offering 1,777 sq. ft. of well-designed living across two levels. This 3-bedroom, 3-bathroom home features a bright open-concept main floor with a generous living and dining area and a stylish kitchen finished with granite countertops. A versatile den-easily used as a fourth bedroom-adds valuable flexibility, while a private balcony provides a relaxing outdoor retreat. The upper level includes three generously sized bedrooms and two full four-piece bathrooms, creating an ideal layout for students, professionals, or investors seeking strong rental appeal. Additional conveniences include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot. Fully furnished and exceptionally well maintained, this turnkey property is move-in ready. Located within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, and close to Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this home offers unmatched accessibility and long-term value."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T07:08:05.673699+00:00"
+"CrossStreet": "Columbia St W/Albert St/University"
+"Directions": "Columbia St W/Albert St/University"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "All Electric Fixtures, All Window Coverings, All Furniture That Belongs To The Seller, Washer & Dryer, Fridge, Stove."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-27T16:01:06Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-09T18:26:12Z"
+"OriginalListPrice": 649900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3646868"
+"ParcelNumber": "236470089"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-10T16:58:32Z"
+"PreviousListPrice": 649900.0
+"PriceChangeTimestamp": "2026-04-27T16:01:06Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "217"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862846')"
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"RollNumber": "301604225000440"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LegalStories": "2"
+"ParkingSpot1": "65"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "builder"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "17"
+"MediaChangeTimestamp": "2026-03-10T16:58:32Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-29T17:37:38.317501Z"
+"Media": array:12 [ …12]
+"ID": "627169"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "624383"
+post_author: 1
+"ListingKey": "X12858400"
+"ListingId": "X12858400"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:35:58Z"
+"RFModificationTimestamp": "2026-04-29T19:52:26Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T8"
+"UnparsedAddress": "338 Albert Street 216, Waterloo, ON N2L 3T8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort, convenience, and investment potential in this spacious upper-level stacked condo at Ivy Towns 3 by IN8 Developments. Offering 1,777 sq. ft. across two thoughtfully designed levels, this 3-bedroom, 3-bathroom home-complete with a versatile den that can easily serve as a fourth bedroom-caters beautifully to investors, students, and professionals alike. The main floor features durable porcelain and laminate flooring, a bright open-concept living and dining area, and a stylish kitchen with stainless steel appliances and granite countertops, complemented by two private balconies for added outdoor enjoyment. Upstairs, you'll find three generously sized bedrooms and two full four-piece bathrooms, providing ample space and comfort. Additional perks include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot conveniently located near the entrance. Built in 2018 and exceptionally well maintained, this fully furnished unit offers a true turnkey opportunity with strong rental appeal. Ideally situated within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this property delivers unmatched accessibility and lifestyle convenience."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:51:27.564219+00:00"
+"CrossStreet": "Columbia St West/ Albert St/ University Ave"
+"Directions": "Columbia St W / Albert St./University Ave"
+"ExpirationDate": "2026-05-31"
+"HeatingYN": true
+"Inclusions": "Furniture that belongs to the Seller, All window coverings, all electric light fixtures, washer, dryer, fridge, stove, microwave, surface parking"
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-07"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-01T22:10:22Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-07T19:08:04Z"
+"OriginalListPrice": 618800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3640800"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-10T16:48:19Z"
+"PreviousListPrice": 618800.0
+"PriceChangeTimestamp": "2026-04-01T22:10:22Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "8"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% + HST + 1000 Bonus"
+"TransactionType": "For Sale"
+"UnitNumber": "216"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12858400')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"ParkingSpot1": "64"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2026-03-10T16:48:19Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-29T17:36:06.322501Z"
+"Media": array:20 [ …20]
+"ID": "624383"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "710968"
+post_author: 1
+"ListingKey": "X13058480"
+"ListingId": "X13058480"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T16:44:06Z"
+"RFModificationTimestamp": "2026-04-30T05:02:06Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2T4"
+"UnparsedAddress": "366 Havendale Crescent, Waterloo, ON N2T 2T4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.470787
+"Longitude": -80.581756
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Top school district alert! 366 Havendale Cres is perfectly situated in a quiet, family-friendly neighbourhood with no sidewalk - no winter shoveling and extra parking. Freshly renovated throughout! The home features new paint, new flooring, and a carpet-free design throughout. The kitchen shines with a brand new quartz countertop. This 3-bedroom, 3-bathroom home includes a primary bedroom with private ensuite - ideal for a young family to call HOME. The fully finished basement offers an extra room and abundant fun and storage space. Enjoy a spacious fenced backyard - perfect for summer BBQs and carefree entertaining with family and friends. Despite having a single garage, no-sidewalk creates an additional parking space on the driveway. Walk to top schools (Laurelwood PS, Laurel Heights SS, St. Nicholas CC), library, grocery stores (Sobey's, Food Basics), and Bus 13 to UW/WLU/shopping. YMCA within walking distance - enjoy swimming, full basketball court, fitness programs, childcare, and family activities year-round. Laurel Creek Conservation Area just steps away - offering scenic trails, birdwatching, canoeing, fishing, and peaceful nature escapes right outside your door. Perfect for active families and nature lovers alike. No sidewalk, no carpet, no hassle - just easy, modern family living with nature and recreation at your doorstep!"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T19:16:58.867259+00:00"
+"CrossStreet": "Laurelwood Dr & Beaver Creek Rd"
+"DirectionFaces": "South"
+"Directions": "Laurelwood Dr & Beaver Creek Rd"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": "Carpet Free,Sump Pump,Water Meter,Water Heater,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-29"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-29T16:44:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-29T16:44:06Z"
+"OriginalListPrice": 729000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3890100"
+"ParcelNumber": "226810954"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-29T16:44:06Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:4 [ …4]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "HAVENDALE"
+"StreetNumber": "366"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4932.0"
+"TaxAssessedValue": 360000
+"TaxLegalDescription": "PT BLK 4 PLAN 58M-47 BEING PTS 54 & 127 ON 58R-11405. S/T EASE #LT13490 IN FAVOUR OF THE CORPORATION OF THE CITY OF WATERLOO & UNION GAS LIMITED OVER PT 127 ON 58R-11405. SUBJECT TO RIGHT OF ENTRY UNTIL THE LATER OF 5 YEARS FROM 1998.12.15 OR THE ASSUMPTION OF THE SUBDIVISION BY THE MUNICIPALITY AS IN LT24665. S/T RIGHT OF ENTRY AS IN LT27805 UNTIL 10 YRS FROM APR.23, 1999. CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://tours.reelsparrow.com/e/Xpmsq2T"
+"VirtualTourURLUnbranded": "https://tours.reelsparrow.com/e/Xpmsq2T"
+"Zoning": "SD"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.08
+"LotShape": "Rectangular"
+"LotWidth": 30.16
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13058480')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604218019600"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 2T4, CA"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "shoes off, lights off."
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Main"
+"MediaChangeTimestamp": "2026-04-29T16:44:06Z"
+"SystemModificationTimestamp": "2026-04-29T16:44:07.080091Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:34 [ …34]
+"ID": "710968"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "706509"
+post_author: 1
+"ListingKey": "X13054780"
+"ListingId": "X13054780"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T15:56:17Z"
+"RFModificationTimestamp": "2026-04-30T05:02:00Z"
+"ListPrice": 5998000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 21.56
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4G8"
+"UnparsedAddress": "742 Country Squire Road, Waterloo, ON N2J 4G8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5277909
+"Longitude": -80.4908089
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "French Château-inspired country estate set on 22 private acres, offering nearly 8,400 sq. ft. of finished living space blending timeless craftsmanship with modern luxury. The residence features a hand-laid stone exterior, steeply pitched rooflines, symmetrical façade, and soaring chimneys. A long private drive leads to a circular gravel courtyard, while oversized windows capture panoramic views from sunrise to sunset. Ideally located in a quiet Waterloo enclave, with the Grand River at one end and Canada's tech hub at the other, this is a rare offering on prestigious Country Squire-known for estate living, acreage, and exceptional privacy. A custom 9-ft mahogany door opens to an interior defined by scale: 10-ft ceilings, wide-plank oak floors, vaulted tongue-and-groove ceilings, exposed Douglas Fir beams, and iron accents. The dining room is ideal for entertaining, filled with natural light. The gourmet kitchen features double islands, quartz counters, beverage fridge, and Thermador appliances including gas range, double ovens, and full-size fridge/freezer, plus pot filler and farmhouse sink. The home offers 5 bedrooms and 6 bathrooms, including 4 ensuites with heated floors. The main-floor primary suite features vaulted ceilings, fireplace, hidden sunroom, and a spa-like ensuite with walnut vanity, glass shower, and soaker tub. A loft leads to a private suite and lounge.The finished walkout basement includes a fireplace, gym, sauna rough-in, 3 ensuite bedrooms, and a large rec room. A secondary staircase connects to the 6-car garage with EV rough-in. Premium systems include 600-amp service, Viessmann boiler, natural gas, and 4-zone HVAC. In-floor heating extends through key areas. With 4 fireplaces and a timber-framed rear porch, this estate offers seamless indoor-outdoor living. The grounds are a blank canvas for a luxury landscape or private retreat. A detached 3-bay garage adds space for 6 more vehicles. A rare opportunity in a highly desirable community."
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "3.0"
+"CreationDate": "2026-04-28T20:23:50.412139+00:00"
+"CrossStreet": "University Ave E / Millenium Drive"
+"DirectionFaces": "East"
+"Directions": "University Ave E to Millenium Drive to Country Squire Rd"
+"ExpirationDate": "2026-08-24"
+"FireplaceFeatures": array:5 [ …5]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Gas Stove, Hot Water Tank Owned, Refrigerator, Washer. See ist of inclusions & features on addendum on listing."
+"InteriorFeatures": "Air Exchanger,Auto Garage Door Remote,Bar Fridge,Built-In Oven,Separate Heating Controls,Water Heater Owned,Water Softener,Water Purifier"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-28T19:58:39Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T19:58:39Z"
+"OriginalListPrice": 5998000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3877788"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "227100045"
+"ParkingFeatures": "Circular Drive,Private Triple"
+"ParkingTotal": "20.0"
+"PhotosChangeTimestamp": "2026-04-28T19:58:39Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": "Septic"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Country Squire"
+"StreetNumber": "742"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "11787.96"
+"TaxLegalDescription": "PT LOT 1 GERMAN COMPANY TRACT WOOLWICH AS IN 1025663 (THIRDLY) ; S/T F20402; WOOLWICH"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://iguidephotos.com/742_country_squire_rd_conestogo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/742_country_squire_rd_conestogo_on/"
+"VirtualTourURLUnbranded2": "https://vid.us/k7f9o5"
+"WaterSource": array:2 [ …2]
+"DDFYN": true
+"Water": "Well"
+"HeatType": "Forced Air"
+"LotDepth": 1970.0
+"LotShape": "Irregular"
+"LotWidth": 79.92
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13054780')"
+"WellDepth": 134.0
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "302902000224500"
+"SurveyType": "Available"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"SoundBiteUrl": "hthttps://vid.us/k7f9o5"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 10
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 2
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "5000 +"
+"RoomsAboveGrade": 12
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:4 [ …4]
+"LotIrregularities": "481x1778.32x398.83x200.3x89.82x1970"
+"LotSizeRangeAcres": "10-24.99"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"WashroomsType4Pcs": 2
+"WashroomsType5Pcs": 3
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay. Listing Realtor to be present for showings - No lockbox. Give enough notice please."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Basement"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Second"
+"MediaChangeTimestamp": "2026-04-29T15:56:17Z"
+"SystemModificationTimestamp": "2026-04-29T15:56:32.84697Z"
+"Media": array:49 [ …49]
+"ID": "706509"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: 711814
+post_author: 1
+"ListingKey": "X13057916"
+"ListingId": "X13057916"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T15:36:51Z"
+"RFModificationTimestamp": "2026-04-30T05:02:05Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4Z6"
+"UnparsedAddress": "402 Lakeview Drive, Waterloo, ON N2L 4Z6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.487368
+"Longitude": -80.5667965
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 402 Lakeview Drive, a stunning home nestled in the highly coveted Lakeshore neighbourhood of Waterloo. Beautifully upgraded and completely move-in ready, this exceptional 3+1 bedroom raised bungalow offers an elevated living. Set on a premium lot with no rear neighbours, this property delivers rare privacy and a peaceful setting. Step inside the bright, open-concept living spaces, enhanced by newly installed pot lights and stylish designer fixtures. The expansive living and dining areas are ideal for both everyday living and elegant entertaining. Fully renovated kitchen (2026) shines with brand-new stainless steel appliances contemporary finishes and abundant space for hosting and gathering with loved ones. Every detail has been thoughtfully updated, including beautifully renovated bathrooms, a new furnace and air conditioning system and carpet-free flooring that flows throughout the entire home. The main level features 3 generously sized bedrooms, each filled with natural light, along with a tastefully updated bathroom. The fully finished walkout basement, featuring an additional bedroom, a modern 3pc bathroom and a large recreation room with direct access to a bright, inviting sunroom. This lower level is ideal for extended family living, guests or even the potential for a private in-law or granny suite. Step out onto the spacious private backyard with upper deck, complete with plenty of room for children to play and families to gather. A single-car garage with direct access to the basement adds everyday practicality. Location truly sets this property apart, with close proximity to top-tier amenities including the University of Waterloo, Laurel Creek Conservation Area, Grey Silo Golf Club, Stork Family YMCA and walking and biking trails right from your backyard and quick access to schools and the thriving tech hub. Rarely offered in one of Waterloo's most desirable communities, this home is the complete package. Book your private showing today."
+"ArchitecturalStyle": "Bungalow-Raised"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:54:55.808598+00:00"
+"CrossStreet": "Northfield Dr W"
+"DirectionFaces": "North"
+"Directions": "Pineridge Road To Lakeview Dr"
+"ExpirationDate": "2026-08-31"
+"ExteriorFeatures": "Porch Enclosed"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": "In-Law Capability,Water Heater Owned,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-29"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-29T15:36:51Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-29T15:36:51Z"
+"OriginalListPrice": 775000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3889016"
+"ParcelNumber": "222650037"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-29T15:36:51Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lakeview"
+"StreetNumber": "402"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4548.0"
+"TaxLegalDescription": "LT 23 FL 1371 City of Waterloo; S/T 529950; Waterloo"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/402_lakeview_dr_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 150.0
+"LotWidth": 45.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057916')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604268502610"
+"SurveyType": "None"
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4Z6, CA"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 2
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-29T15:36:51Z"
+"SystemModificationTimestamp": "2026-04-29T15:36:52.497225Z"
+"Media": array:49 [ …49]
+"ID": 711814
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "665940"
+post_author: 1
+"ListingKey": "X12944490"
+"ListingId": "X12944490"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T14:24:10Z"
+"RFModificationTimestamp": "2026-04-29T17:04:14Z"
+"ListPrice": 188000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1800.0
+"City": "Waterloo"
+"PostalCode": "N2J 2W6"
+"UnparsedAddress": "8 Erb Street W, Waterloo, ON N2J 2W6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3970564
+"Longitude": -80.3479215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REON HOMES REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Rare opportunity to secure a beautifully finished, turnkey restaurant space on a prime corner in the heart of downtown Waterloo. This high visibility location features massive wrap around windows, flooding the modern interior with natural light. The open and versatile layout includes high quality fixtures and commercial equipment, making it easily adaptable for almost any food concept without a major renovation. A clean, professional, and high traffic set up ready for a new operator to step in and start business immediately. 15 ft hood. 55 indoor seats and 20 patio seats. Basement included. 2 walk in coolers and 1 walk-in freezer. Rent $9,910 (TMI & HST included). 2 years remaining plus a 5-year option to renew."
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"Cooling": "Yes"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-29T15:47:11.387518+00:00"
+"CrossStreet": "Erb St & King St W"
+"Directions": "-"
+"ExpirationDate": "2026-08-31"
+"HoursDaysOfOperation": array:1 [ …1]
+"HoursDaysOfOperationDescription": "11 am - 9 pm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"MainOfficeKey": "273400"
+"MajorChangeTimestamp": "2026-04-29T14:24:10Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 4
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-01T14:45:39Z"
+"OriginalListPrice": 188000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3750908"
+"PhotosChangeTimestamp": "2026-04-01T14:45:40Z"
+"SeatingCapacity": "75"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Erb"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "4%"
+"TransactionType": "For Sale"
+"Utilities": "Available"
+"Zoning": "Commercial"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Closed"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12944490')"
+"ChattelsYN": true
+"GarageType": "Street"
+"RetailArea": 100.0
+"PropertyUse": "Without Property"
+"HoldoverDays": 120
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2W6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Sold Conditional"
+"RetailAreaCode": "Sq Ft"
+"WashroomsType1": 2
+"PossessionDetails": "TBD"
+"MediaChangeTimestamp": "2026-04-01T14:45:40Z"
+"SystemModificationTimestamp": "2026-04-29T14:24:10.584229Z"
+"SoldConditionalEntryTimestamp": "2026-04-13T14:05:34Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:17 [ …17]
+"ID": "665940"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "630638"
+post_author: 1
+"ListingKey": "X12873782"
+"ListingId": "X12873782"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T14:21:36Z"
+"RFModificationTimestamp": "2026-04-30T05:00:39Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1Z3"
+"UnparsedAddress": "225 Benjamin Road 61, Waterloo, ON N2V 1Z3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5021122
+"Longitude": -80.562986
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Treetops, one of Waterloo's most desirable condominium communities-an established enclave known for its mature trees, peaceful surroundings, and exceptional sense of community. Tucked just off Benjamin Road, this location offers the perfect balance of nature and convenience, with shopping, restaurants, St. Jacobs Farmers' Market, and expressway access all just minutes away. Unit 61 offers a beautifully updated multilevel back-split that was completely renovated in 2018, blending timeless design with modern comfort. The bright and inviting living room features luxury vinyl plank flooring and cozy gas fireplace. Multiple skylights and big windows fill the home with natural light. The dining area is accented with elegant California shutters, while the eat-in kitchen showcases quartz countertops, classic white cabinetry, a stainless steel range hood, and a walkout to a generous private deck-ideal for morning coffee, summer BBQs, or quiet evenings outdoors.Thoughtful features throughout the home include a water softener, central vacuum, reverse osmosis water system, mirrored closet doors, and a distinctive octagonal window that adds architectural character. The main level also offers a convenient two-piece powder room, while the finished lower level provides flexible living space perfect for a home office, media room, or guest bedroom. A single garage with additional driveway parking adds everyday convenience. Residents of Treetops enjoy a welcoming community atmosphere along with access to excellent amenities, including an outdoor heated pool, tennis and pickleball courts, and a community centre for private gatherings. Outdoor enthusiasts will appreciate nearby walking and cycling trails, while the St. Jacobs Market, Conestoga Mall, and Uptown Waterloo's vibrant dining and shopping scene are minutes away. At Treetops you're not just buying a home-you're embracing a lifestyle defined by comfort, community, and convenience. Book your showing today."
+"ArchitecturalStyle": "Multi-Level"
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "845.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"BuildingName": "Treetops"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T15:50:00.575447+00:00"
+"CrossStreet": "Weber St. N."
+"Directions": "West off Weber St onto Benjamin, first entrance on left."
+"ExpirationDate": "2026-08-31"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, TV Mount in primary bedroom. Appliances working at time of listing, but will be sold in "as is, where is" condition"
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-03-12T00:34:14Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-12T00:34:14Z"
+"OriginalListPrice": 649900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3661464"
+"ParcelNumber": "231640037"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-12T00:34:15Z"
+"Roof": "Shingles"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Benjamin"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4041.95"
+"TaxAssessedValue": 296000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "3"
+"TransactionType": "For Sale"
+"UnitNumber": "61"
+"View": array:2 [ …2]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/61_225_benjamin_rd_waterloo_on/"
+"VirtualTourURLUnbranded2": "https://youriguide.com/61_225_benjamin_rd_waterloo_on/"
+"Zoning": "R8"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12873782')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604052600461"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 1Z3, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 164
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 2
+"SquareFootSource": "i Guide"
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:1 [ …1]
+"ShowingAppointments": "Broker Bay/Supra"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Third"
+"WashroomsType3Level": "Third"
+"LegalApartmentNumber": "37"
+"MediaChangeTimestamp": "2026-03-12T00:34:15Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-29T14:21:43.135639Z"
+"Media": array:42 [ …42]
+"ID": "630638"
}
]
+success: true
+page_size: 10
+page_count: 28
+count: 276
+after_key: ""
}
"RF Response Time" => "0.32 seconds"
]
"RF Cache Key: 5d358a8bb6dd0ac7946520a26328ed68e3e4970f428522983cf6e3c0f7c9c105" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3126
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4314
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12913496"
+"ListingId": "X12913496"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:53:45Z"
+"RFModificationTimestamp": "2026-04-29T17:56:49Z"
+"ListPrice": 580000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0G6"
+"UnparsedAddress": "245 Grey Silo Road 302, Waterloo, ON N2K 0G6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.52174
+"Longitude": -80.49558
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Red And White Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautiful 2-bedroom, 2-bath executive condo located in the highly sought-after Carriage Crossing neighbourhood. This bright corner unit, just 4 years old, enjoys west-facing exposure with no direct neighbouring views, allowing for plenty of natural light throughout the day. The modern open-concept kitchen features quartz countertops, a stylish herringbone backsplash, under-cabinet lighting, a large island, stainless steel appliances, and plenty of storage-perfect for everyday cooking or entertaining guests. The sun-filled living area offers engineered hardwood flooring, upgraded lighting, and direct access to an expansive wraparound balcony. With two separate seating areas and wide open panoramic views, it's an ideal spot to unwind with a drink after a long day. The spacious primary bedroom includes two closets and a private ensuite featuring a spa-inspired glass shower with built-in bench. The second bedroom is generously sized and filled with natural light, making it perfect for guests, a home office, or additional living space. Both bathrooms are finished with granite countertops and upgraded fixtures. This unit also includes a convenient drive-in underground parking space with a large private storage locker located directly in front, making access simple and practical. Additional features include in-suite laundry, water heater, and water softener. Residents enjoy access to an incredible rooftop terrace complete with planter gardens, comfortable seating areas, a fire table, communal BBQ, and stunning views-a wonderful place to gather with friends or relax outdoors. Fantastic location close to Rim Park, Grey Silo Golf Club, Black Berry, scenic walking and biking trails, Brown's Social House, Conestoga Mall, and the St. Jacobs Farmers' Market. Experience the ease and comfort of condo living in one of Waterloo's most desirable communities."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "522.63"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-26T20:13:42.229923+00:00"
+"CrossStreet": "Millennium Blvd and Oak Park Drive"
+"Directions": "University Ave to Millennium Blvd to Oak Park Drive to Grey Silo Road."
+"ExpirationDate": "2026-12-24"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "575000"
+"MajorChangeTimestamp": "2026-04-29T17:53:45Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T13:28:50Z"
+"OriginalListPrice": 619000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3711868"
+"ParcelNumber": "237120043"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T13:28:51Z"
+"PreviousListPrice": 619000.0
+"PriceChangeTimestamp": "2026-04-29T17:53:45Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Grey Silo"
+"StreetNumber": "245"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4394.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "302"
+"Zoning": "R9"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913496')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"LockerUnit": "1010"
+"RollNumber": "301601000107740"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LegalStories": "3"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 712
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "i-Guide"
+"PossessionDetails": "Flexible. Tenat has given notice"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please use Showing Time or call +1 833-322-9934. Lock box is located on the railing to the right of visitor parking. Tenat requires 24HR notice for showings."
+"LegalApartmentNumber": "302"
+"MediaChangeTimestamp": "2026-03-24T13:28:51Z"
+"PropertyManagementCompany": "King Condo Management In"
+"SystemModificationTimestamp": "2026-04-29T17:53:45.130069Z"
+"VendorPropertyInfoStatement": true
+"Media": array:34 [ …34]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4315
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13014582"
+"ListingId": "X13014582"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:50:42Z"
+"RFModificationTimestamp": "2026-04-29T17:59:48Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0C6"
+"UnparsedAddress": "188 King Street S 207, Waterloo, ON N2J 0C6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this spacious and thoughtfully designed 1-bedroom suite offering approximately 820 sq ft of comfortable living in the heart of Uptown Waterloo. Located in one of the area's most desirable mid-rise buildings, this unit provides a great balance of space, style, and convenience. The open-concept layout is ideal for everyday living, featuring a modern kitchen with abundance cabinetry, over sized island , stainless steel appliances complimented with granite counter-top. The living area is bright and inviting, with large windows that bring in plenty of natural light and a Juliet balcony with views of King St The primary bedroom offers double closet. The bathroom is well-appointed with sleek fixtures and a practical layout. Enjoy amenities including the gym, party room, and your private storage locker. Parking is located in the above-ground garage . RECENT UPDATES include : Updated bathroom , Washer, Dryer and Bosch dishwasher , backsplash. Step outside and you're just minutes from Vincenzo's, Mary-Allen Park, and the vibrant shops and restaurants of Uptown Waterloo. With the LRT at your doorstep, commuting across the city is quick and easy. This well-maintained building offers a quiet, community-oriented lifestyle while keeping you close to everything. A great opportunity for first-time buyers, professionals, or investors alike."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "410.87"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T00:50:58.131419+00:00"
+"CrossStreet": "Allen"
+"Directions": "King St S. & Allen St. W."
+"ExpirationDate": "2026-07-17"
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-04-17T20:55:38Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-17T20:55:38Z"
+"OriginalListPrice": 350000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3813482"
+"ParcelNumber": "235620007"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T20:55:39Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "188"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4096.0"
+"TaxAssessedValue": 299000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "207"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014582')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301602090004112"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "207"
+"ParkingType1": "Common"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 562
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Other"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Book Through Brokerbay. The lock box is located on the railing on the back entrance of our office . Coming down King towards Waterloo , turn right on Willis way and make first right into the alley way , it will be the first entrance to your right ."
+"LegalApartmentNumber": "4"
+"MediaChangeTimestamp": "2026-04-29T17:50:42Z"
+"PropertyManagementCompany": "Prudential Propt. Mgmt"
+"SystemModificationTimestamp": "2026-04-29T17:50:46.406337Z"
+"Media": array:43 [ …43]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4318
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12858490"
+"ListingId": "X12858490"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:41:36Z"
+"RFModificationTimestamp": "2026-04-29T19:52:26Z"
+"ListPrice": 599800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T8"
+"UnparsedAddress": "338 Albert Street 219, Waterloo, ON N2L 3T8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort and exceptional investment value in this spacious upper-level stacked condo at Ivy Towns 3 by IN8 Developments. Offering 1,777 sq. ft. across two thoughtfully designed levels, this 3-bedroom, 3-bathroom home features durable porcelain and laminate flooring, a bright open-concept living and dining area, and a stylish kitchen with stainless steel appliances and granite countertops. A versatile den-easily used as a fourth bedroom-adds valuable flexibility, while two main-floor balconies provide inviting outdoor spaces to relax and unwind. The upper level includes three generously sized bedrooms and two full four-piece bathrooms, creating an ideal layout for students, professionals, or investors seeking strong rental appeal. Additional conveniences include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot just steps from the entrance. Built in 2018 and exceptionally well maintained, this fully furnished unit offers a true turnkey opportunity for buyers or investors. Perfectly located within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, and close to Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this property delivers unmatched accessibility and long-term value."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:52:12.123476+00:00"
+"CrossStreet": "Columbia St West/ Albert St/ University Ave"
+"Directions": "Columbia St W/ Albert St/ University"
+"ExpirationDate": "2026-05-31"
+"HeatingYN": true
+"Inclusions": "All Electric Fixtures, All window Coverings, All furniture that belongs to the Seller. Washer, Dryer, Fridge, Stove"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-07"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-01T22:09:49Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-07T19:47:04Z"
+"OriginalListPrice": 619900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3640918"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-09T17:21:01Z"
+"PreviousListPrice": 619900.0
+"PriceChangeTimestamp": "2026-04-01T22:09:49Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "8"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% + HST + 1000 Bonus"
+"TransactionType": "For Sale"
+"UnitNumber": "219"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12858490')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"ParkingSpot1": "67"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "19"
+"MediaChangeTimestamp": "2026-03-09T17:21:01Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-29T17:41:43.099237Z"
+"Media": array:24 [ …24]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4317
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12862846"
+"ListingId": "X12862846"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:37:31Z"
+"RFModificationTimestamp": "2026-04-29T18:15:10Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0G8"
+"UnparsedAddress": "338 Albert Street 217, Waterloo, ON N2L 0G8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4781765
+"Longitude": -80.5339477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort and exceptional investment potential in this spacious upper-level stacked condo, offering 1,777 sq. ft. of well-designed living across two levels. This 3-bedroom, 3-bathroom home features a bright open-concept main floor with a generous living and dining area and a stylish kitchen finished with granite countertops. A versatile den-easily used as a fourth bedroom-adds valuable flexibility, while a private balcony provides a relaxing outdoor retreat. The upper level includes three generously sized bedrooms and two full four-piece bathrooms, creating an ideal layout for students, professionals, or investors seeking strong rental appeal. Additional conveniences include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot. Fully furnished and exceptionally well maintained, this turnkey property is move-in ready. Located within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, and close to Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this home offers unmatched accessibility and long-term value."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T07:08:05.673699+00:00"
+"CrossStreet": "Columbia St W/Albert St/University"
+"Directions": "Columbia St W/Albert St/University"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "All Electric Fixtures, All Window Coverings, All Furniture That Belongs To The Seller, Washer & Dryer, Fridge, Stove."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-27T16:01:06Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-09T18:26:12Z"
+"OriginalListPrice": 649900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3646868"
+"ParcelNumber": "236470089"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-10T16:58:32Z"
+"PreviousListPrice": 649900.0
+"PriceChangeTimestamp": "2026-04-27T16:01:06Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "217"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862846')"
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"RollNumber": "301604225000440"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LegalStories": "2"
+"ParkingSpot1": "65"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "builder"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "17"
+"MediaChangeTimestamp": "2026-03-10T16:58:32Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-29T17:37:38.317501Z"
+"Media": array:12 [ …12]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4316
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12858400"
+"ListingId": "X12858400"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T17:35:58Z"
+"RFModificationTimestamp": "2026-04-29T19:52:26Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T8"
+"UnparsedAddress": "338 Albert Street 216, Waterloo, ON N2L 3T8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ALL-STARS REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of modern comfort, convenience, and investment potential in this spacious upper-level stacked condo at Ivy Towns 3 by IN8 Developments. Offering 1,777 sq. ft. across two thoughtfully designed levels, this 3-bedroom, 3-bathroom home-complete with a versatile den that can easily serve as a fourth bedroom-caters beautifully to investors, students, and professionals alike. The main floor features durable porcelain and laminate flooring, a bright open-concept living and dining area, and a stylish kitchen with stainless steel appliances and granite countertops, complemented by two private balconies for added outdoor enjoyment. Upstairs, you'll find three generously sized bedrooms and two full four-piece bathrooms, providing ample space and comfort. Additional perks include in-suite laundry, 9 ft ceilings, and an exclusive surface parking spot conveniently located near the entrance. Built in 2018 and exceptionally well maintained, this fully furnished unit offers a true turnkey opportunity with strong rental appeal. Ideally situated within a 10-minute walk to Wilfrid Laurier University, the University of Waterloo, Conestoga College's Waterloo campus, Uptown Waterloo, Waterloo Park, Conestoga Mall, and the LRT at UW Station, this property delivers unmatched accessibility and lifestyle convenience."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "617.54"
+"AssociationFeeIncludes": array:4 [ …4]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:51:27.564219+00:00"
+"CrossStreet": "Columbia St West/ Albert St/ University Ave"
+"Directions": "Columbia St W / Albert St./University Ave"
+"ExpirationDate": "2026-05-31"
+"HeatingYN": true
+"Inclusions": "Furniture that belongs to the Seller, All window coverings, all electric light fixtures, washer, dryer, fridge, stove, microwave, surface parking"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-07"
+"MainOfficeKey": "142000"
+"MajorChangeTimestamp": "2026-04-01T22:10:22Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-07T19:08:04Z"
+"OriginalListPrice": 618800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3640800"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-10T16:48:19Z"
+"PreviousListPrice": 618800.0
+"PriceChangeTimestamp": "2026-04-01T22:10:22Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "8"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "338"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5024.44"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2.5% + HST + 1000 Bonus"
+"TransactionType": "For Sale"
+"UnitNumber": "216"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12858400')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"ParkingSpot1": "64"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"CondoCorpNumber": 647
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"ParkingLevelUnit1": "1"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2026-03-10T16:48:19Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-29T17:36:06.322501Z"
+"Media": array:20 [ …20]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4313
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13058480"
+"ListingId": "X13058480"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T16:44:06Z"
+"RFModificationTimestamp": "2026-04-30T05:02:06Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2T4"
+"UnparsedAddress": "366 Havendale Crescent, Waterloo, ON N2T 2T4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.470787
+"Longitude": -80.581756
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Top school district alert! 366 Havendale Cres is perfectly situated in a quiet, family-friendly neighbourhood with no sidewalk - no winter shoveling and extra parking. Freshly renovated throughout! The home features new paint, new flooring, and a carpet-free design throughout. The kitchen shines with a brand new quartz countertop. This 3-bedroom, 3-bathroom home includes a primary bedroom with private ensuite - ideal for a young family to call HOME. The fully finished basement offers an extra room and abundant fun and storage space. Enjoy a spacious fenced backyard - perfect for summer BBQs and carefree entertaining with family and friends. Despite having a single garage, no-sidewalk creates an additional parking space on the driveway. Walk to top schools (Laurelwood PS, Laurel Heights SS, St. Nicholas CC), library, grocery stores (Sobey's, Food Basics), and Bus 13 to UW/WLU/shopping. YMCA within walking distance - enjoy swimming, full basketball court, fitness programs, childcare, and family activities year-round. Laurel Creek Conservation Area just steps away - offering scenic trails, birdwatching, canoeing, fishing, and peaceful nature escapes right outside your door. Perfect for active families and nature lovers alike. No sidewalk, no carpet, no hassle - just easy, modern family living with nature and recreation at your doorstep!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T19:16:58.867259+00:00"
+"CrossStreet": "Laurelwood Dr & Beaver Creek Rd"
+"DirectionFaces": "South"
+"Directions": "Laurelwood Dr & Beaver Creek Rd"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-29"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-29T16:44:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-29T16:44:06Z"
+"OriginalListPrice": 729000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3890100"
+"ParcelNumber": "226810954"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-29T16:44:06Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:4 [ …4]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "HAVENDALE"
+"StreetNumber": "366"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4932.0"
+"TaxAssessedValue": 360000
+"TaxLegalDescription": "PT BLK 4 PLAN 58M-47 BEING PTS 54 & 127 ON 58R-11405. S/T EASE #LT13490 IN FAVOUR OF THE CORPORATION OF THE CITY OF WATERLOO & UNION GAS LIMITED OVER PT 127 ON 58R-11405. SUBJECT TO RIGHT OF ENTRY UNTIL THE LATER OF 5 YEARS FROM 1998.12.15 OR THE ASSUMPTION OF THE SUBDIVISION BY THE MUNICIPALITY AS IN LT24665. S/T RIGHT OF ENTRY AS IN LT27805 UNTIL 10 YRS FROM APR.23, 1999. CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://tours.reelsparrow.com/e/Xpmsq2T"
+"VirtualTourURLUnbranded": "https://tours.reelsparrow.com/e/Xpmsq2T"
+"Zoning": "SD"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.08
+"LotShape": "Rectangular"
+"LotWidth": 30.16
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13058480')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604218019600"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 2T4, CA"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "shoes off, lights off."
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Main"
+"MediaChangeTimestamp": "2026-04-29T16:44:06Z"
+"SystemModificationTimestamp": "2026-04-29T16:44:07.080091Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:34 [ …34]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4312
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13054780"
+"ListingId": "X13054780"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T15:56:17Z"
+"RFModificationTimestamp": "2026-04-30T05:02:00Z"
+"ListPrice": 5998000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 21.56
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4G8"
+"UnparsedAddress": "742 Country Squire Road, Waterloo, ON N2J 4G8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5277909
+"Longitude": -80.4908089
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "French Château-inspired country estate set on 22 private acres, offering nearly 8,400 sq. ft. of finished living space blending timeless craftsmanship with modern luxury. The residence features a hand-laid stone exterior, steeply pitched rooflines, symmetrical façade, and soaring chimneys. A long private drive leads to a circular gravel courtyard, while oversized windows capture panoramic views from sunrise to sunset. Ideally located in a quiet Waterloo enclave, with the Grand River at one end and Canada's tech hub at the other, this is a rare offering on prestigious Country Squire-known for estate living, acreage, and exceptional privacy. A custom 9-ft mahogany door opens to an interior defined by scale: 10-ft ceilings, wide-plank oak floors, vaulted tongue-and-groove ceilings, exposed Douglas Fir beams, and iron accents. The dining room is ideal for entertaining, filled with natural light. The gourmet kitchen features double islands, quartz counters, beverage fridge, and Thermador appliances including gas range, double ovens, and full-size fridge/freezer, plus pot filler and farmhouse sink. The home offers 5 bedrooms and 6 bathrooms, including 4 ensuites with heated floors. The main-floor primary suite features vaulted ceilings, fireplace, hidden sunroom, and a spa-like ensuite with walnut vanity, glass shower, and soaker tub. A loft leads to a private suite and lounge.The finished walkout basement includes a fireplace, gym, sauna rough-in, 3 ensuite bedrooms, and a large rec room. A secondary staircase connects to the 6-car garage with EV rough-in. Premium systems include 600-amp service, Viessmann boiler, natural gas, and 4-zone HVAC. In-floor heating extends through key areas. With 4 fireplaces and a timber-framed rear porch, this estate offers seamless indoor-outdoor living. The grounds are a blank canvas for a luxury landscape or private retreat. A detached 3-bay garage adds space for 6 more vehicles. A rare opportunity in a highly desirable community."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "3.0"
+"CreationDate": "2026-04-28T20:23:50.412139+00:00"
+"CrossStreet": "University Ave E / Millenium Drive"
+"DirectionFaces": "East"
+"Directions": "University Ave E to Millenium Drive to Country Squire Rd"
+"ExpirationDate": "2026-08-24"
+"FireplaceFeatures": array:5 [ …5]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Gas Stove, Hot Water Tank Owned, Refrigerator, Washer. See ist of inclusions & features on addendum on listing."
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-28T19:58:39Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T19:58:39Z"
+"OriginalListPrice": 5998000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3877788"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "227100045"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "20.0"
+"PhotosChangeTimestamp": "2026-04-28T19:58:39Z"
+"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": "Country Squire"
+"StreetNumber": "742"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "11787.96"
+"TaxLegalDescription": "PT LOT 1 GERMAN COMPANY TRACT WOOLWICH AS IN 1025663 (THIRDLY) ; S/T F20402; WOOLWICH"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://iguidephotos.com/742_country_squire_rd_conestogo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/742_country_squire_rd_conestogo_on/"
+"VirtualTourURLUnbranded2": "https://vid.us/k7f9o5"
+"WaterSource": array:2 [ …2]
+"DDFYN": true
+"Water": "Well"
+"HeatType": "Forced Air"
+"LotDepth": 1970.0
+"LotShape": "Irregular"
+"LotWidth": 79.92
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13054780')"
+"WellDepth": 134.0
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "302902000224500"
+"SurveyType": "Available"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"SoundBiteUrl": "hthttps://vid.us/k7f9o5"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 10
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 2
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "5000 +"
+"RoomsAboveGrade": 12
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:4 [ …4]
+"LotIrregularities": "481x1778.32x398.83x200.3x89.82x1970"
+"LotSizeRangeAcres": "10-24.99"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"WashroomsType4Pcs": 2
+"WashroomsType5Pcs": 3
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay. Listing Realtor to be present for showings - No lockbox. Give enough notice please."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Basement"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Second"
+"MediaChangeTimestamp": "2026-04-29T15:56:17Z"
+"SystemModificationTimestamp": "2026-04-29T15:56:32.84697Z"
+"Media": array:49 [ …49]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4311
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13057916"
+"ListingId": "X13057916"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T15:36:51Z"
+"RFModificationTimestamp": "2026-04-30T05:02:05Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4Z6"
+"UnparsedAddress": "402 Lakeview Drive, Waterloo, ON N2L 4Z6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.487368
+"Longitude": -80.5667965
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 402 Lakeview Drive, a stunning home nestled in the highly coveted Lakeshore neighbourhood of Waterloo. Beautifully upgraded and completely move-in ready, this exceptional 3+1 bedroom raised bungalow offers an elevated living. Set on a premium lot with no rear neighbours, this property delivers rare privacy and a peaceful setting. Step inside the bright, open-concept living spaces, enhanced by newly installed pot lights and stylish designer fixtures. The expansive living and dining areas are ideal for both everyday living and elegant entertaining. Fully renovated kitchen (2026) shines with brand-new stainless steel appliances contemporary finishes and abundant space for hosting and gathering with loved ones. Every detail has been thoughtfully updated, including beautifully renovated bathrooms, a new furnace and air conditioning system and carpet-free flooring that flows throughout the entire home. The main level features 3 generously sized bedrooms, each filled with natural light, along with a tastefully updated bathroom. The fully finished walkout basement, featuring an additional bedroom, a modern 3pc bathroom and a large recreation room with direct access to a bright, inviting sunroom. This lower level is ideal for extended family living, guests or even the potential for a private in-law or granny suite. Step out onto the spacious private backyard with upper deck, complete with plenty of room for children to play and families to gather. A single-car garage with direct access to the basement adds everyday practicality. Location truly sets this property apart, with close proximity to top-tier amenities including the University of Waterloo, Laurel Creek Conservation Area, Grey Silo Golf Club, Stork Family YMCA and walking and biking trails right from your backyard and quick access to schools and the thriving tech hub. Rarely offered in one of Waterloo's most desirable communities, this home is the complete package. Book your private showing today."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T16:54:55.808598+00:00"
+"CrossStreet": "Northfield Dr W"
+"DirectionFaces": "North"
+"Directions": "Pineridge Road To Lakeview Dr"
+"ExpirationDate": "2026-08-31"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-29"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-29T15:36:51Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-29T15:36:51Z"
+"OriginalListPrice": 775000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3889016"
+"ParcelNumber": "222650037"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-29T15:36:51Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lakeview"
+"StreetNumber": "402"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4548.0"
+"TaxLegalDescription": "LT 23 FL 1371 City of Waterloo; S/T 529950; Waterloo"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/402_lakeview_dr_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 150.0
+"LotWidth": 45.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13057916')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604268502610"
+"SurveyType": "None"
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4Z6, CA"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 2
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-29T15:36:51Z"
+"SystemModificationTimestamp": "2026-04-29T15:36:52.497225Z"
+"Media": array:49 [ …49]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4310
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12944490"
+"ListingId": "X12944490"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T14:24:10Z"
+"RFModificationTimestamp": "2026-04-29T17:04:14Z"
+"ListPrice": 188000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1800.0
+"City": "Waterloo"
+"PostalCode": "N2J 2W6"
+"UnparsedAddress": "8 Erb Street W, Waterloo, ON N2J 2W6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3970564
+"Longitude": -80.3479215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REON HOMES REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Rare opportunity to secure a beautifully finished, turnkey restaurant space on a prime corner in the heart of downtown Waterloo. This high visibility location features massive wrap around windows, flooding the modern interior with natural light. The open and versatile layout includes high quality fixtures and commercial equipment, making it easily adaptable for almost any food concept without a major renovation. A clean, professional, and high traffic set up ready for a new operator to step in and start business immediately. 15 ft hood. 55 indoor seats and 20 patio seats. Basement included. 2 walk in coolers and 1 walk-in freezer. Rent $9,910 (TMI & HST included). 2 years remaining plus a 5-year option to renew."
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-29T15:47:11.387518+00:00"
+"CrossStreet": "Erb St & King St W"
+"Directions": "-"
+"ExpirationDate": "2026-08-31"
+"HoursDaysOfOperation": array:1 [ …1]
+"HoursDaysOfOperationDescription": "11 am - 9 pm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"MainOfficeKey": "273400"
+"MajorChangeTimestamp": "2026-04-29T14:24:10Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 4
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-01T14:45:39Z"
+"OriginalListPrice": 188000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3750908"
+"PhotosChangeTimestamp": "2026-04-01T14:45:40Z"
+"SeatingCapacity": "75"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Erb"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "4%"
+"TransactionType": "For Sale"
+"Utilities": array:1 [ …1]
+"Zoning": "Commercial"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Closed"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12944490')"
+"ChattelsYN": true
+"GarageType": "Street"
+"RetailArea": 100.0
+"PropertyUse": "Without Property"
+"HoldoverDays": 120
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2W6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Sold Conditional"
+"RetailAreaCode": "Sq Ft"
+"WashroomsType1": 2
+"PossessionDetails": "TBD"
+"MediaChangeTimestamp": "2026-04-01T14:45:40Z"
+"SystemModificationTimestamp": "2026-04-29T14:24:10.584229Z"
+"SoldConditionalEntryTimestamp": "2026-04-13T14:05:34Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:17 [ …17]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4309
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12873782"
+"ListingId": "X12873782"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-29T14:21:36Z"
+"RFModificationTimestamp": "2026-04-30T05:00:39Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1Z3"
+"UnparsedAddress": "225 Benjamin Road 61, Waterloo, ON N2V 1Z3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5021122
+"Longitude": -80.562986
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Treetops, one of Waterloo's most desirable condominium communities-an established enclave known for its mature trees, peaceful surroundings, and exceptional sense of community. Tucked just off Benjamin Road, this location offers the perfect balance of nature and convenience, with shopping, restaurants, St. Jacobs Farmers' Market, and expressway access all just minutes away. Unit 61 offers a beautifully updated multilevel back-split that was completely renovated in 2018, blending timeless design with modern comfort. The bright and inviting living room features luxury vinyl plank flooring and cozy gas fireplace. Multiple skylights and big windows fill the home with natural light. The dining area is accented with elegant California shutters, while the eat-in kitchen showcases quartz countertops, classic white cabinetry, a stainless steel range hood, and a walkout to a generous private deck-ideal for morning coffee, summer BBQs, or quiet evenings outdoors.Thoughtful features throughout the home include a water softener, central vacuum, reverse osmosis water system, mirrored closet doors, and a distinctive octagonal window that adds architectural character. The main level also offers a convenient two-piece powder room, while the finished lower level provides flexible living space perfect for a home office, media room, or guest bedroom. A single garage with additional driveway parking adds everyday convenience. Residents of Treetops enjoy a welcoming community atmosphere along with access to excellent amenities, including an outdoor heated pool, tennis and pickleball courts, and a community centre for private gatherings. Outdoor enthusiasts will appreciate nearby walking and cycling trails, while the St. Jacobs Market, Conestoga Mall, and Uptown Waterloo's vibrant dining and shopping scene are minutes away. At Treetops you're not just buying a home-you're embracing a lifestyle defined by comfort, community, and convenience. Book your showing today."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "845.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"BuildingName": "Treetops"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T15:50:00.575447+00:00"
+"CrossStreet": "Weber St. N."
+"Directions": "West off Weber St onto Benjamin, first entrance on left."
+"ExpirationDate": "2026-08-31"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, TV Mount in primary bedroom. Appliances working at time of listing, but will be sold in "as is, where is" condition"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-03-12T00:34:14Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-12T00:34:14Z"
+"OriginalListPrice": 649900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3661464"
+"ParcelNumber": "231640037"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-12T00:34:15Z"
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Benjamin"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4041.95"
+"TaxAssessedValue": 296000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "3"
+"TransactionType": "For Sale"
+"UnitNumber": "61"
+"View": array:2 [ …2]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/61_225_benjamin_rd_waterloo_on/"
+"VirtualTourURLUnbranded2": "https://youriguide.com/61_225_benjamin_rd_waterloo_on/"
+"Zoning": "R8"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12873782')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604052600461"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"LegalStories": "1"
…39
}
]
+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 {#4280
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073 …115}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …111}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …117}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …117}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …125}
]
+success: true
+page_size: 5
+page_count: 9455
+count: 47272
+after_key: ""
}
]
]
