array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=180&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=180&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=180&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=180&$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: "677233"
+post_author: 1
+"ListingKey": "X12941490"
+"ListingId": "X12941490"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T18:54:10Z"
+"RFModificationTimestamp": "2026-04-30T02:15:15Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 3773.39
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0C2"
+"UnparsedAddress": "321 Carriage Way, Waterloo, ON N2K 0C2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your dream home near prestigious Kiwanis Park! Built in 2018 and located in one of Waterloo's most desirable neighborhoods, this impeccably maintained residence by the original owner offers 4 bedrooms, 3 bathrooms, a double-car garage, and a LEGAL ONE-BEDROOM BASEMENT APARTMENT WITH PRIVATE ENTRANCE. The main floor features an inviting open-concept layout with a gourmet kitchen boasting quartz countertops, stainless steel appliances, and a walk-in pantry. The kitchen flows seamlessly into a bright and spacious dining and living room with a gas fireplace perfect for family living and entertaining. Upstairs, discover four bright bedrooms and a convenient laundry room. The spacious primary suite includes a walk-in closet and a private ensuite with a walk-in shower, freestanding tub, and private toilet room. The three additional bedrooms are generously sized, each with ample closet space, and they share a stylish family bath. All windows on the main and second floors are finished with elegant California shutters, blending function with timeless design. The fully legal basement apartment is a highlight, offering its own entrance, full kitchen, large bedroom, full bathroom with walk-in shower, and a versatile den/home office. With over-ground windows, the space enjoys excellent natural light and full privacy, ideal for in-laws, extended family, or rental income. Beyond the home, the location provides unmatched convenience close to Great schools, parks, shopping, and quick access to Highway 85. A rare opportunity for multi-generational living or smart investing in one of Waterloo's most desirable communities."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T17:15:48.243174+00:00"
+"CrossStreet": "UNIVERSITY AVE. E. TO WOOLWICH ST."
+"DirectionFaces": "North"
+"Directions": "UNIVERSITY AVE. E. TO WOOLWICH ST."
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": "Deck"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Ss Fridg/ Ss Stove/Ss Dishwasher/Ss Microwave/Washer and Dryer/ Mini Fridge in the Laundry room, Garage Door Opener, All ELF and All California Chatters."
+"InteriorFeatures": "Accessory Apartment,Auto Garage Door Remote,ERV/HRV,Storage,Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-31T20:56:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-31T20:56:48Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3733440"
+"ParcelNumber": "227211017"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-31T20:56:49Z"
+"PoolFeatures": "None"
+"Roof": "Shingles"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Carriage"
+"StreetNumber": "321"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "7824.46"
+"TaxLegalDescription": "LOT 77, PLAN 58M540 SUBJECT TO AN EASEMENT IN GROSS OVER PT 77 ON 58R-17489 AS IN WR693229 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST :)"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.27
+"LotWidth": 34.85
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12941490')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601000220232"
+"SurveyType": "Available"
+"RentalItems": "The water heater."
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 0C2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"PossessionDetails": "TBA(Flexible)"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Ground"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-04-10T18:58:56Z"
+"SystemModificationTimestamp": "2026-04-10T18:58:56.464659Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "677233"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "689007"
+post_author: 1
+"ListingKey": "X12984076"
+"ListingId": "X12984076"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T18:30:33Z"
+"RFModificationTimestamp": "2026-04-27T06:14:32Z"
+"ListPrice": 1650.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 504, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Lepage Real Estate Associates"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Check this out if you want to have the smartest neighbours. Close to major Universities and Colleges. Modestly furnished.Stainless steel appliances, Granite Counters and ensuite laundry. Balcony is refurbished and opens to the morning sun. Not all units have a balcony. Ameneties include exercise and study rooms, Bike locker room on ground floor."
+"AccessibilityFeatures": array:3 [ …3]
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:6 [ …6]
+"Basement": array:1 [ …1]
+"BuildingName": "SAGE 10"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-18T10:49:38.395891+00:00"
+"CrossStreet": "University and Hemlock"
+"Directions": "University and Hemlock"
+"ExpirationDate": "2026-09-30"
+"ExteriorFeatures": "Controlled Entry,Recreational Area"
+"FoundationDetails": array:4 [ …4]
+"Furnished": "Furnished"
+"Inclusions": "Couch and table in living room, bed frame and matress in bedroom"
+"InteriorFeatures": "Carpet Free,Intercom,Primary Bedroom - Main Floor"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-10"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "101200"
+"MajorChangeTimestamp": "2026-04-10T18:30:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-10T18:30:33Z"
+"OriginalListPrice": 1650.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3797464"
+"ParcelNumber": "236790123"
+"ParkingFeatures": "Street Only"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-10T18:30:33Z"
+"RentIncludes": array:10 [ …10]
+"Roof": "Flat,Membrane"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 month's rent"
+"TransactionType": "For Lease"
+"UnitNumber": "504"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Common"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12984076')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004243"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "5"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "It appears bigger with the large balcony"
+"PossessionDetails": "May 1 negotiable"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:3 [ …3]
+"RentalApplicationYN": true
+"ShowingAppointments": "24 hours' notice. Tenanted."
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "04"
+"MediaChangeTimestamp": "2026-04-10T18:30:33Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Lee Management Solutions"
+"SystemModificationTimestamp": "2026-04-10T18:30:33.994954Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:14 [ …14]
+"ID": "689007"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "669725"
+post_author: 1
+"ListingKey": "X12980024"
+"ListingId": "X12980024"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T23:01:46Z"
+"RFModificationTimestamp": "2026-04-30T02:16:04Z"
+"ListPrice": 2800000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0A6"
+"UnparsedAddress": "685 Meadowsweet Avenue, Waterloo, ON N2V 0A6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4710794
+"Longitude": -80.6043836
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ICON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of luxury, space, and lifestyle in this custom-built 2020 residence, offering over 6,400SF of beautifully finished living space on a premium 10,000+SF lot in coveted Waterloo West. Surrounded by approx. 700acres of conservation lands and hundreds of km of trails, this exceptional home is filled with natural light and offers a rare sense of openness and serenity.A grand 19ft foyer welcomes you with a striking staircase and glass railing, setting the tone for the elegance throughout. The main floor features a bright private office, a formal dining room for memorable gatherings, and a welcoming living room anchored by a gas fireplace covered in 5'x10' floor-to-ceiling porcelain tile feature from Spanish-renowned Porcelanosa. Expansive windows and ambient lighting create a sophisticated yet inviting atmosphere. At the heart of the home is a chef-inspired kitchen with floor-to-ceiling cabinetry, built-in appliances, a walk-in pantry, and 2 oversized quartz islands with waterfall edges and breakfast bar seating.Upstairs, 4 spacious bedrooms each have a walk-in closet. The primary suite spans approx. 400SF and includes a 250SF ensuite plus separate his-and-hers walk-in closets. 2 bedrooms share a Jack & Jill bath with a bathtub and built-in shower, while the remaining bathrooms offer glass-enclosed showers. A second-floor office adds flexibility as a potential 6th bedroom.The finished basement (1,600+SF) offers a warm rec room with an electric fireplace, an additional bedroom with walk-in-closet, a full bath with shower, 2 finished cold rooms, and 2 generous storage spaces. Outside, the fenced backyard lined with evergreens provides for a peaceful retreat with room for a pool, while the exposed concrete patio supports seamless indoor/outdoor living. A double-car garage in addition to driveway parking for 6 vehicles completes this remarkable home near schools, University of Waterloo, Boardwalk, tech hub, medical clinics, & more too."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-11T07:35:29.928907+00:00"
+"CrossStreet": "Laurelwood / Erbsville"
+"DirectionFaces": "West"
+"Directions": "Turn right off of White Cedar"
+"ExpirationDate": "2026-12-31"
+"ExteriorFeatures": "Landscaped"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Built-In Oven,Countertop Range,Central Vacuum,Sump Pump,Ventilation System,Water Heater,Water Meter,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-09"
+"MainOfficeKey": "322400"
+"MajorChangeTimestamp": "2026-04-09T23:01:46Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-09T23:01:46Z"
+"OriginalListPrice": 2800000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3793666"
+"ParcelNumber": "226844146"
+"ParkingFeatures": "Available"
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2026-04-09T23:01:46Z"
+"PoolFeatures": "None"
+"Roof": "Shingles"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Meadowsweet"
+"StreetNumber": "685"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "16754.99"
+"TaxLegalDescription": "LOT 2, PLAN 58M534 SUBJECT TO AN EASEMENT IN GROSS OVER PT 21 ON 58R-17362 AS IN WR665641 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 150.11
+"LotWidth": 63.78
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12980024')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000105707"
+"SurveyType": "Available"
+"ElectricYNA": "Yes"
+"RentalItems": "Tankless Water Heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0A6, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-09"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 5
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3500-5000"
+"RoomsAboveGrade": 12
+"PropertyFeatures": array:2 [ …2]
+"WashroomsType1Pcs": 5
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ContactAfterExpiryYN": true
+"MediaChangeTimestamp": "2026-04-09T23:01:46Z"
+"SystemModificationTimestamp": "2026-04-09T23:01:47.565321Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:44 [ …44]
+"ID": "669725"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "687349"
+post_author: 1
+"ListingKey": "X12978078"
+"ListingId": "X12978078"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T17:35:59Z"
+"RFModificationTimestamp": "2026-04-30T02:16:02Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2A 0C7"
+"UnparsedAddress": "414 Zeller Drive, Waterloo, ON N2A 0C7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this beautifully maintained home in the highly sought-after Lackner Woods community, offering 2,555 sq. ft. of thoughtfully designed above-ground living space-located in an area known for some of the region's top-rated schools. Freshly painted throughout, this home features brand new carpet on the upper level and a carpet-free main floor finished with rich hardwood and ceramic tile. The stunning great room boasts soaring 17-foot ceilings, while 9-foot ceilings enhance the sense of space throughout the rest of this level. The main floor is perfectly suited for both everyday living and entertaining. The chef's kitchen is a standout, complete with granite countertops, stainless steel appliances, and a large island ideal for casual dining. From the kitchen, step out onto a spacious elevated deck-perfect for hosting guests or relaxing while overlooking the backyard and pool below. The layout offers an open-concept feel while still maintaining a distinct dining area, along with a separate office/den, and a convenient main floor laundry/mudroom. Upstairs, you'll find four generously sized bedrooms. The primary suite is a true retreat, featuring not one but two walk-in closets and a spa-like ensuite. A second large 4-piece bathroom completes the upper level. The backyard is designed for low maintenance and maximum enjoyment, showcasing beautiful armour stone and stamped concrete surrounding a large saltwater pool. With the home backing onto the side of a neighboring property, you'll appreciate the added privacy this unique lot provides. The unfinished basement offers excellent potential to create additional living space tailored to your needs. This is an exceptional opportunity to own a move-in-ready home in a fantastic family-friendly neighbourhood close to excellent schools, parks, and amenities."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T21:25:57.559299+00:00"
+"CrossStreet": "Lackner Blvd and Zeller, Fairway Rd and Zeller"
+"DirectionFaces": "East"
+"Directions": "Lackner Blvd to Zeller"
+"ExpirationDate": "2026-08-25"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Upright Freezer in Basement"
+"InteriorFeatures": "Auto Garage Door Remote"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-09T17:35:59Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-09T17:35:59Z"
+"OriginalListPrice": 1150000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3789434"
+"ParcelNumber": "227134668"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-09T17:35:59Z"
+"PoolFeatures": "Inground,Salt"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Zeller"
+"StreetNumber": "414"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7787.0"
+"TaxLegalDescription": "PART BLOCK 10 PLAN 58M-367, BEING PT 17 ON 58R-16593 CITY OF KITCHENER"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/eolyr_414_zeller_dr_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/eolyr_414_zeller_dr_kitchener_on/"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotDepth": 111.94
+"LotWidth": 45.14
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12978078')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001626989"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2A 0C7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Square Meters"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-09T17:35:59Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-09T17:35:59.752364Z"
+"VendorPropertyInfoStatement": true
+"Media": array:41 [ …41]
+"ID": "687349"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "644190"
+post_author: 1
+"ListingKey": "X12900182"
+"ListingId": "X12900182"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T15:47:45Z"
+"RFModificationTimestamp": "2026-04-30T02:15:05Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0B9"
+"UnparsedAddress": "565 Sundew Drive, Waterloo, ON N2V 0B9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4583258
+"Longitude": -80.5978809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SUTTON GROUP REALTY SYSTEMS INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this bright, large and impressive custom designed home, with 4 bathrooms and over 4,200 sq. ft. of beautifully finished living space including a cozy professionally finished basement (2,937 sqft above grade area). Located in the newer family-friendly Vista Hills community, this home features a highly desirable open-concept layout, abundant oversized windows, with an incredible flow of natural light throughout. Entering the main floor, you are overwhelmed by the feeling of expansiveness with the huge living room, family room and kitchen. The renovated modern kitchen is a true centerpiece, featuring shaker style cabinets, quartz countertops, stainless steel appliances and a spacious pantry. Garden patio doors invite you to a backyard oasis with a private deck, pergola, louvered privacy screens, interlock patio, and mature landscaping - an ideal setting for outdoor dining, relaxation, and hosting guests. Upstairs, double doors open to a large master bedroom with ensuite bath, walk-in closet and a private balcony. Two additional oversized bedrooms and a main bathroom with rough-in for a future sauna, 3rd upstairs bathroom or upper-level laundry. The professionally finished basement provides two additional rooms ideal for bedrooms, office, or guest space, along with a lavish spa-like bathroom featuring a stylish soaker tub and heated towel rack. A perfect opportunity for professional families seeking a modern home in one of Waterloo's most desirable neighbourhoods."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-14T20:50:09.719250+00:00"
+"CrossStreet": "Columbia Street W"
+"DirectionFaces": "East"
+"Directions": "Columbia turns into Sundew. Stay on Sundew and unit is on the left."
+"ExpirationDate": "2026-09-30"
+"ExteriorFeatures": "Deck,Landscaped,Porch,Patio,Year Round Living"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Auto Garage Door Remote,In-Law Capability,In-Law Suite,Water Heater,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-19"
+"MainOfficeKey": "601400"
+"MajorChangeTimestamp": "2026-04-09T15:47:45Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-19T16:39:57Z"
+"OriginalListPrice": 1115000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3694322"
+"ParcelNumber": "226844579"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-19T16:39:57Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 1115000.0
+"PriceChangeTimestamp": "2026-04-09T15:47:45Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sundew"
+"StreetNumber": "565"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7537.69"
+"TaxLegalDescription": "LOT 15, PLAN 58M549 SUBJECT TO AN EASEMENT IN GROSS OVER PT 15 ON 58R-17656 AS IN WR727990 SUBJECT TO AN EASEMENT IN GROSS OVER PT 15 ON 58R-17656 AS IN WR728022 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/565-sundew-drive-waterloo-s/"
+"Zoning": "R6"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 98.43
+"LotWidth": 37.97
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12900182')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000121641"
+"SurveyType": "None"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0B9, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 9
+"PropertyFeatures": array:5 [ …5]
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-27T19:23:48Z"
+"SystemModificationTimestamp": "2026-04-09T15:47:53.820295Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:35 [ …35]
+"ID": "644190"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "676068"
+post_author: 1
+"ListingKey": "X12966566"
+"ListingId": "X12966566"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-08T13:11:08Z"
+"RFModificationTimestamp": "2026-04-30T02:15:25Z"
+"ListPrice": 1698.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4G6"
+"UnparsedAddress": "406 Tamarack Drive Main, Waterloo, ON N2L 4G6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "legal, licensed student housing. entire main floor for rent , 1 bedroom with living room/ used as 2nd bedroom .Separate entrance, kitchen, bathroom & laundry, furnished detached raised bungalow, located in a highly sought-after neighbourhood within all universities district, new stove, Very bright large living rm with wall to wall window, Walking Distance to all Universities. It's a Perfect House for young couple or 1 person who enjoy big living space or University student to share with other friends or as your family home. Security Camera, Smoke Detector. Carbon Monoxide detector. students are welcome. Parking included, fully furnished. 2 single Beds + Mattress, 2 Desks, sofa, Dining Table and Chairs. Fridge, Stove, Washer, Dryer. microwave, All existing Window coverings and All Elfs . Tenant Pays 40% utilities. A month of free rent if you move in on or before May 1. Assignment is allowed."
+"ArchitecturalStyle": "Bungalow-Raised"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-30T01:51:20.792928+00:00"
+"CrossStreet": "Albert St / Columbia St W"
+"DirectionFaces": "South"
+"Directions": "Albert St / Columbia St W"
+"Exclusions": "tenant belongs"
+"ExpirationDate": "2026-08-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Furnished"
+"Inclusions": "1 parking is included"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-07T18:03:53Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-07T18:03:53Z"
+"OriginalListPrice": 1698.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3778094"
+"ParcelNumber": "222760016"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-04-07T18:03:53Z"
+"PoolFeatures": "None"
+"RentIncludes": array:2 [ …2]
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Tamarack"
+"StreetNumber": "406"
+"StreetSuffix": "Drive"
+"TransactionBrokerCompensation": "1/2 Month Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "Main"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 125.0
+"LotWidth": 57.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12966566')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604440001500"
+"SurveyType": "Unknown"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4G6, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 4
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "VACANT"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "vacant, easy showing. Please call for delay or cancel; lock box located at the 1st stair railing. Entrance is beside the garage door."
+"WashroomsType1Level": "Ground"
+"MediaChangeTimestamp": "2026-04-07T18:03:53Z"
+"PortionPropertyLease": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-08T13:11:12.584441Z"
+"VendorPropertyInfoStatement": true
+"Media": array:21 [ …21]
+"ID": "676068"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "666773"
+post_author: 1
+"ListingKey": "X12913812"
+"ListingId": "X12913812"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-08T05:21:53Z"
+"RFModificationTimestamp": "2026-04-30T02:15:08Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0E4"
+"UnparsedAddress": "723 Wood Lily Street, Waterloo, ON N2V 0E4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4612175
+"Longitude": -80.5996057
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this stunning Activa-built Timbercrest model in the highly desirable Vista Hills community, offering almost 2,800 sq ft of thoughtfully crafted living space, 4 bedrooms, 3.5 bathrooms, 55' frontage and two car garage. This beautifully designed home exudes modern sophistication, featuring light hardwood flooring, contemporary fixtures, and tasteful accents throughout, with impressive 9 ft ceilings on the basement, main, and upper levels enhancing the sense of space and light. The chef-inspired kitchen is equipped with premium appliances, a gas range, Cambria Annicca quartz countertops, and an expansive island, and flows seamlessly into the dining area. From here, sliding doors open to a landscaped backyard with an inviting patio - perfect for entertaining and outdoor enjoyment. The adjoining living room offers a warm and comfortable atmosphere with a cozy fireplace, ideal for relaxing or hosting guests. The main floor also features a convenient laundry area. Upstairs, an additional family room provides the perfect space for unwinding or gathering. The spacious primary suite offers an oversized walk-in closet and a luxurious ensuite complete with a glass shower and a freestanding soaker tub. All bathrooms are finished with quality granite or quartz countertops, adding both style and durability. Additional features include ceramic tile in all wet areas, enlarged basement windows, a 3-piece rough-in for future customization, an HRV system, and a high-efficiency furnace. Set within a peaceful, nature-oriented neighbourhood, residents can enjoy access to a forested greenbelt, offering beautiful natural scenery year-round. At the same time, the home is just minutes from everyday conveniences, including shopping, Costco, healthcare services, and major retailers, ensuring a perfect balance of serenity and accessibility. With its striking brick and vinyl exterior and high-quality finishes throughout, this home delivers exceptional comfort, style, and practicality."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"CoListOfficeName": "e Xp Realty"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-14T18:00:10.557157+00:00"
+"CrossStreet": "Sundew Drive and Mayapple"
+"DirectionFaces": "East"
+"Directions": "Sundew Drive and Mayapple"
+"Exclusions": "T.V's - wall mounts to remain. Two bookshelves secured for safety to bedroom walls. Basement carpet."
+"ExpirationDate": "2026-06-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Gas Stove, Washer. The built-in walk-in closet in the primary bedroom will remain. Smart switches to remain. Garden Planters."
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-08T05:21:53Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-24T14:00:59Z"
+"OriginalListPrice": 1087911.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707996"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "226845087"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-24T14:01:00Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 1179777.0
+"PriceChangeTimestamp": "2026-04-08T05:21:53Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wood Lily"
+"StreetNumber": "723"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8275.0"
+"TaxAssessedValue": 604000
+"TaxLegalDescription": "LOT 52, PLAN 58M601 SUBJECT TO AN EASEMENT IN GROSS OVER PART 52 ON 58R19762 AS IN WR1032711 SUBJECT TO AN EASEMENT IN GROSS OVER PART 52 ON 58R19762 AS IN WR1032890 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://realsee.ai/p8EEZVAW"
+"VirtualTourURLUnbranded": "https://realsee.ai/p8EEZVAW"
+"Zoning": "NR"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 102.84
+"LotWidth": 55.74
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913812')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000118065"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Water Softener"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0E4, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Square Meters"
+"PropertyFeatures": array:4 [ …4]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please book all showings via Brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"MediaChangeTimestamp": "2026-03-24T14:01:00Z"
+"SystemModificationTimestamp": "2026-04-08T05:22:05.07049Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
+"ID": "666773"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "666306"
+post_author: 1
+"ListingKey": "X12967806"
+"ListingId": "X12967806"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T21:04:11Z"
+"RFModificationTimestamp": "2026-04-30T05:01:32Z"
+"ListPrice": 1975.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0B7"
+"UnparsedAddress": "456 Twin Leaf Street Bsmt, Waterloo, ON N2V 0B7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome To A Beautiful Legal Basement Two Bedrooms Unit. Corner Lot, With Plenty Of Sunlight, large Windows and 9 feet ceilings. Located Minutes Away From Sought After Schools (Vista Hills Public School Till Secondary And Laurelwood Public For High School), Right Across Small Park, Close To Major Stores And Shopping Plaza (Boardwalk, Costco). Sep walk up Entrance with One Car Park on the Driveway. Massive Living/Dining Area, Luxury Bath With Standing Shower, Large Windows In Both Bedrooms. Pot Lights, Carpet Free Main Area, Kitchen With Quartz Countertops, Lots Of Storage, Separate Laundry Room and plenty of storage in kitchen. Located In Very Desirable, And Family-Oriented Neighborhood Of Vista Hills."
+"ArchitecturalStyle": "2-Storey"
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-30T02:39:19.081983+00:00"
+"CrossStreet": "Sundrew Dr & Wild Cala St"
+"DirectionFaces": "North"
+"Directions": "Sundrew Dr & Wild Cala St"
+"ExpirationDate": "2026-08-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Existing SS Fridge, Stove, Exhaust, white Washer & Dryer, Spacious Laundry Room With Storage Area, Water Filter & Softener."
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-04"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "43.42 x 107.88 Feet"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-04-07T21:04:11Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-07T21:04:11Z"
+"OriginalListPrice": 1975.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3779796"
+"ParcelNumber": "226844704"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-04-07T21:04:11Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [ …1]
+"Roof": "Other"
+"RoomsTotal": "8"
+"Sewer": "Sewer"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Twin Leaf"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month's Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "Bsmt"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 107.88
+"LotWidth": 43.42
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12967806')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000118683"
+"SurveyType": "None"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0B7, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Free"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Basement"
+"MediaChangeTimestamp": "2026-04-07T21:04:11Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-07T21:04:11.678072Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
+"ID": "666306"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "592970"
+post_author: 1
+"ListingKey": "X12709768"
+"ListingId": "X12709768"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T20:51:54Z"
+"RFModificationTimestamp": "2026-04-30T02:14:41Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0B 1M0"
+"UnparsedAddress": "21 West Tree Drive, Waterloo, ON N0B 1M0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488288
+"Longitude": -80.411813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Great for a large or multi generational family, this 4 bedroom home has plenty of living space! Soaring entryway and living room opens on a grand staircase. Expansive dining room allows for large family gatherings. The kitchen has new gleaming white quartz countertops and ample space for storage and room for 2 chefs in the kitchen. Main floor family room is visible from the kitchen and the dinette has a slider to fenced back yard oasis with salt water in-ground pool with overflow hot tub for summer entertaining. Fully finished basement has oodles of more space, a bathroom, huge rec room and another large space. Upstairs features a large primary suite with a walk in closet and an ensuite with separate shower and soaker tub, plus 3 additional bedrooms, main bath and an airy sitting area or office space. Be sure to book your private showing. New furnace and AC in 2022."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-22T18:05:33.072665+00:00"
+"CrossStreet": "Townsend"
+"DirectionFaces": "East"
+"Directions": "Fountain to Townsend to West Tree"
+"Exclusions": "security camera system, most tvs, curtains in basement and boys bedroom"
+"ExpirationDate": "2026-05-30"
+"ExteriorFeatures": "Patio"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:2 [ …2]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Carbon Monoxide Detector, Dishwasher, Dryer, Gas Oven/Range, Gas Stove, Pool Equipment, Range Hood, Refrigerator, Smoke Detector, Washer, rec room TV play center"
+"InteriorFeatures": "In-Law Capability,Water Softener,Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-19"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-01-19T18:00:02Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-01-19T18:00:02Z"
+"OriginalListPrice": 1200000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3456608"
+"ParcelNumber": "222510522"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-01-19T18:00:02Z"
+"PoolFeatures": "Inground,Salt"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "West Tree"
+"StreetNumber": "21"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6393.0"
+"TaxAssessedValue": 553000
+"TaxLegalDescription": "LOT 62, PLAN 58M-356, TWP OF WOOLWICH; T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 415."
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/21_w_tree_dr_breslau_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/21_w_tree_dr_breslau_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.19
+"LotWidth": 48.26
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12709768')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "302903000528122"
+"SurveyType": "Unknown"
+"RentalItems": "Water heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N0B 1M0, CA"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 4
+"RoomsBelowGrade": 1
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 2
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Some notice pls"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-04-07T20:51:54Z"
+"SystemModificationTimestamp": "2026-04-07T20:51:54.440123Z"
+"VendorPropertyInfoStatement": true
+"Media": array:50 [ …50]
+"ID": "592970"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "622259"
+post_author: 1
+"ListingKey": "X12845546"
+"ListingId": "X12845546"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T18:55:59Z"
+"RFModificationTimestamp": "2026-04-30T05:00:35Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street G612, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/YORKLAND REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Excellent Location For This Freshly Painted, Very Spacious, 771 Sq Ft, Bright, Fully Furnished 2-Bed, 2-Bath Unit Plus An Oversized 108 Sq Ft Balcony, 1 Parking & Clear Views! Close To Wilfrid Laurier University, University Of Waterloo, Restaurants, Groceries, Parks, Theaters +++ Low Maintenance Fees, Includes Internet, Water, Heat. Amenities Incl A Fully Equipped Gym, A Yoga & Meditation Room, Study Lounge, Theatre & Games Room & Outdoor Terrace. Excellent Clean & Quiet Neighborhood. Super Investment Opportunity, Or For University Parents, Or First-Time Buyers! This Condo Comes With A Coveted Parking Spot Too!.... Very Rarely Offered!"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "570.39"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"BuildingName": "URL Condos Building G"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-30T03:05:58.816995+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-08-15"
+"Inclusions": "Fridge, Stove, Range Hood, Dishwasher, Stacked Washer/Dryer, 2 Double Beds, 2 Double Mattresses, 2 Night Tables, 1 Large Armoire, 2 Desks W 2 Chairs, 1 Media Unit, 1 Coffee Table, 1 3-Seater Leather Sofa, 1 Dining Table W 4 Chairs, Parking."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "658500"
+"MajorChangeTimestamp": "2026-04-07T18:55:58Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-04T19:23:57Z"
+"OriginalListPrice": 459900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3540110"
+"ParcelNumber": "236430555"
+"ParkingFeatures": "Surface"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-04T19:23:57Z"
+"PreviousListPrice": 459900.0
+"PriceChangeTimestamp": "2026-04-07T18:55:58Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3041.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "G612"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12845546')"
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"RollNumber": "301604270001407"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "7"
+"ParkingSpot1": "114"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 643
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 6
+"SquareFootSource": "771 + 108 Balcony"
+"ParkingLevelUnit1": "Gound Level"
+"PossessionDetails": "Flex/Immed"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "22"
+"MediaChangeTimestamp": "2026-03-04T19:23:57Z"
+"PropertyManagementCompany": "CMC Condo Management Co. 519 804 0700 ext. 503"
+"SystemModificationTimestamp": "2026-04-07T18:55:59.052691Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:21 [ …21]
+"ID": "622259"
}
]
+success: true
+page_size: 10
+page_count: 28
+count: 276
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Cache Key: 241c9f13c804b956f688d057d5c592597a7f409ee1a23ceb247f6b83c0311494" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3124
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4311
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12941490"
+"ListingId": "X12941490"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T18:54:10Z"
+"RFModificationTimestamp": "2026-04-30T02:15:15Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 3773.39
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0C2"
+"UnparsedAddress": "321 Carriage Way, Waterloo, ON N2K 0C2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your dream home near prestigious Kiwanis Park! Built in 2018 and located in one of Waterloo's most desirable neighborhoods, this impeccably maintained residence by the original owner offers 4 bedrooms, 3 bathrooms, a double-car garage, and a LEGAL ONE-BEDROOM BASEMENT APARTMENT WITH PRIVATE ENTRANCE. The main floor features an inviting open-concept layout with a gourmet kitchen boasting quartz countertops, stainless steel appliances, and a walk-in pantry. The kitchen flows seamlessly into a bright and spacious dining and living room with a gas fireplace perfect for family living and entertaining. Upstairs, discover four bright bedrooms and a convenient laundry room. The spacious primary suite includes a walk-in closet and a private ensuite with a walk-in shower, freestanding tub, and private toilet room. The three additional bedrooms are generously sized, each with ample closet space, and they share a stylish family bath. All windows on the main and second floors are finished with elegant California shutters, blending function with timeless design. The fully legal basement apartment is a highlight, offering its own entrance, full kitchen, large bedroom, full bathroom with walk-in shower, and a versatile den/home office. With over-ground windows, the space enjoys excellent natural light and full privacy, ideal for in-laws, extended family, or rental income. Beyond the home, the location provides unmatched convenience close to Great schools, parks, shopping, and quick access to Highway 85. A rare opportunity for multi-generational living or smart investing in one of Waterloo's most desirable communities."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T17:15:48.243174+00:00"
+"CrossStreet": "UNIVERSITY AVE. E. TO WOOLWICH ST."
+"DirectionFaces": "North"
+"Directions": "UNIVERSITY AVE. E. TO WOOLWICH ST."
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Ss Fridg/ Ss Stove/Ss Dishwasher/Ss Microwave/Washer and Dryer/ Mini Fridge in the Laundry room, Garage Door Opener, All ELF and All California Chatters."
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-31T20:56:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-31T20:56:48Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3733440"
+"ParcelNumber": "227211017"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-31T20:56:49Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Carriage"
+"StreetNumber": "321"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "7824.46"
+"TaxLegalDescription": "LOT 77, PLAN 58M540 SUBJECT TO AN EASEMENT IN GROSS OVER PT 77 ON 58R-17489 AS IN WR693229 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST :)"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.27
+"LotWidth": 34.85
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12941490')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601000220232"
+"SurveyType": "Available"
+"RentalItems": "The water heater."
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 0C2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"PossessionDetails": "TBA(Flexible)"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Ground"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-04-10T18:58:56Z"
+"SystemModificationTimestamp": "2026-04-10T18:58:56.464659Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4312
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12984076"
+"ListingId": "X12984076"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T18:30:33Z"
+"RFModificationTimestamp": "2026-04-27T06:14:32Z"
+"ListPrice": 1650.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 504, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Lepage Real Estate Associates"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Check this out if you want to have the smartest neighbours. Close to major Universities and Colleges. Modestly furnished.Stainless steel appliances, Granite Counters and ensuite laundry. Balcony is refurbished and opens to the morning sun. Not all units have a balcony. Ameneties include exercise and study rooms, Bike locker room on ground floor."
+"AccessibilityFeatures": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:6 [ …6]
+"Basement": array:1 [ …1]
+"BuildingName": "SAGE 10"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-18T10:49:38.395891+00:00"
+"CrossStreet": "University and Hemlock"
+"Directions": "University and Hemlock"
+"ExpirationDate": "2026-09-30"
+"ExteriorFeatures": array:2 [ …2]
+"FoundationDetails": array:4 [ …4]
+"Furnished": "Furnished"
+"Inclusions": "Couch and table in living room, bed frame and matress in bedroom"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-10"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "101200"
+"MajorChangeTimestamp": "2026-04-10T18:30:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-10T18:30:33Z"
+"OriginalListPrice": 1650.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3797464"
+"ParcelNumber": "236790123"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-10T18:30:33Z"
+"RentIncludes": array:10 [ …10]
+"Roof": array:2 [ …2]
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 month's rent"
+"TransactionType": "For Lease"
+"UnitNumber": "504"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Common"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12984076')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004243"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "5"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "It appears bigger with the large balcony"
+"PossessionDetails": "May 1 negotiable"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:3 [ …3]
+"RentalApplicationYN": true
+"ShowingAppointments": "24 hours' notice. Tenanted."
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "04"
+"MediaChangeTimestamp": "2026-04-10T18:30:33Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Lee Management Solutions"
+"SystemModificationTimestamp": "2026-04-10T18:30:33.994954Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:14 [ …14]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4315
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12980024"
+"ListingId": "X12980024"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T23:01:46Z"
+"RFModificationTimestamp": "2026-04-30T02:16:04Z"
+"ListPrice": 2800000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0A6"
+"UnparsedAddress": "685 Meadowsweet Avenue, Waterloo, ON N2V 0A6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4710794
+"Longitude": -80.6043836
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ICON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience the perfect blend of luxury, space, and lifestyle in this custom-built 2020 residence, offering over 6,400SF of beautifully finished living space on a premium 10,000+SF lot in coveted Waterloo West. Surrounded by approx. 700acres of conservation lands and hundreds of km of trails, this exceptional home is filled with natural light and offers a rare sense of openness and serenity.A grand 19ft foyer welcomes you with a striking staircase and glass railing, setting the tone for the elegance throughout. The main floor features a bright private office, a formal dining room for memorable gatherings, and a welcoming living room anchored by a gas fireplace covered in 5'x10' floor-to-ceiling porcelain tile feature from Spanish-renowned Porcelanosa. Expansive windows and ambient lighting create a sophisticated yet inviting atmosphere. At the heart of the home is a chef-inspired kitchen with floor-to-ceiling cabinetry, built-in appliances, a walk-in pantry, and 2 oversized quartz islands with waterfall edges and breakfast bar seating.Upstairs, 4 spacious bedrooms each have a walk-in closet. The primary suite spans approx. 400SF and includes a 250SF ensuite plus separate his-and-hers walk-in closets. 2 bedrooms share a Jack & Jill bath with a bathtub and built-in shower, while the remaining bathrooms offer glass-enclosed showers. A second-floor office adds flexibility as a potential 6th bedroom.The finished basement (1,600+SF) offers a warm rec room with an electric fireplace, an additional bedroom with walk-in-closet, a full bath with shower, 2 finished cold rooms, and 2 generous storage spaces. Outside, the fenced backyard lined with evergreens provides for a peaceful retreat with room for a pool, while the exposed concrete patio supports seamless indoor/outdoor living. A double-car garage in addition to driveway parking for 6 vehicles completes this remarkable home near schools, University of Waterloo, Boardwalk, tech hub, medical clinics, & more too."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-11T07:35:29.928907+00:00"
+"CrossStreet": "Laurelwood / Erbsville"
+"DirectionFaces": "West"
+"Directions": "Turn right off of White Cedar"
+"ExpirationDate": "2026-12-31"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:10 [ …10]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-09"
+"MainOfficeKey": "322400"
+"MajorChangeTimestamp": "2026-04-09T23:01:46Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-09T23:01:46Z"
+"OriginalListPrice": 2800000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3793666"
+"ParcelNumber": "226844146"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2026-04-09T23:01:46Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Meadowsweet"
+"StreetNumber": "685"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "16754.99"
+"TaxLegalDescription": "LOT 2, PLAN 58M534 SUBJECT TO AN EASEMENT IN GROSS OVER PT 21 ON 58R-17362 AS IN WR665641 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 150.11
+"LotWidth": 63.78
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12980024')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000105707"
+"SurveyType": "Available"
+"ElectricYNA": "Yes"
+"RentalItems": "Tankless Water Heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0A6, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-09"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 5
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3500-5000"
+"RoomsAboveGrade": 12
+"PropertyFeatures": array:2 [ …2]
+"WashroomsType1Pcs": 5
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ContactAfterExpiryYN": true
+"MediaChangeTimestamp": "2026-04-09T23:01:46Z"
+"SystemModificationTimestamp": "2026-04-09T23:01:47.565321Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:44 [ …44]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4314
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12978078"
+"ListingId": "X12978078"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T17:35:59Z"
+"RFModificationTimestamp": "2026-04-30T02:16:02Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2A 0C7"
+"UnparsedAddress": "414 Zeller Drive, Waterloo, ON N2A 0C7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this beautifully maintained home in the highly sought-after Lackner Woods community, offering 2,555 sq. ft. of thoughtfully designed above-ground living space-located in an area known for some of the region's top-rated schools. Freshly painted throughout, this home features brand new carpet on the upper level and a carpet-free main floor finished with rich hardwood and ceramic tile. The stunning great room boasts soaring 17-foot ceilings, while 9-foot ceilings enhance the sense of space throughout the rest of this level. The main floor is perfectly suited for both everyday living and entertaining. The chef's kitchen is a standout, complete with granite countertops, stainless steel appliances, and a large island ideal for casual dining. From the kitchen, step out onto a spacious elevated deck-perfect for hosting guests or relaxing while overlooking the backyard and pool below. The layout offers an open-concept feel while still maintaining a distinct dining area, along with a separate office/den, and a convenient main floor laundry/mudroom. Upstairs, you'll find four generously sized bedrooms. The primary suite is a true retreat, featuring not one but two walk-in closets and a spa-like ensuite. A second large 4-piece bathroom completes the upper level. The backyard is designed for low maintenance and maximum enjoyment, showcasing beautiful armour stone and stamped concrete surrounding a large saltwater pool. With the home backing onto the side of a neighboring property, you'll appreciate the added privacy this unique lot provides. The unfinished basement offers excellent potential to create additional living space tailored to your needs. This is an exceptional opportunity to own a move-in-ready home in a fantastic family-friendly neighbourhood close to excellent schools, parks, and amenities."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T21:25:57.559299+00:00"
+"CrossStreet": "Lackner Blvd and Zeller, Fairway Rd and Zeller"
+"DirectionFaces": "East"
+"Directions": "Lackner Blvd to Zeller"
+"ExpirationDate": "2026-08-25"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Upright Freezer in Basement"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-09"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-09T17:35:59Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-09T17:35:59Z"
+"OriginalListPrice": 1150000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3789434"
+"ParcelNumber": "227134668"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-09T17:35:59Z"
+"PoolFeatures": array:2 [ …2]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Zeller"
+"StreetNumber": "414"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7787.0"
+"TaxLegalDescription": "PART BLOCK 10 PLAN 58M-367, BEING PT 17 ON 58R-16593 CITY OF KITCHENER"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/eolyr_414_zeller_dr_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/eolyr_414_zeller_dr_kitchener_on/"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotDepth": 111.94
+"LotWidth": 45.14
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12978078')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001626989"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2A 0C7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Square Meters"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-09T17:35:59Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-09T17:35:59.752364Z"
+"VendorPropertyInfoStatement": true
+"Media": array:41 [ …41]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4313
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12900182"
+"ListingId": "X12900182"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-09T15:47:45Z"
+"RFModificationTimestamp": "2026-04-30T02:15:05Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0B9"
+"UnparsedAddress": "565 Sundew Drive, Waterloo, ON N2V 0B9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4583258
+"Longitude": -80.5978809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SUTTON GROUP REALTY SYSTEMS INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this bright, large and impressive custom designed home, with 4 bathrooms and over 4,200 sq. ft. of beautifully finished living space including a cozy professionally finished basement (2,937 sqft above grade area). Located in the newer family-friendly Vista Hills community, this home features a highly desirable open-concept layout, abundant oversized windows, with an incredible flow of natural light throughout. Entering the main floor, you are overwhelmed by the feeling of expansiveness with the huge living room, family room and kitchen. The renovated modern kitchen is a true centerpiece, featuring shaker style cabinets, quartz countertops, stainless steel appliances and a spacious pantry. Garden patio doors invite you to a backyard oasis with a private deck, pergola, louvered privacy screens, interlock patio, and mature landscaping - an ideal setting for outdoor dining, relaxation, and hosting guests. Upstairs, double doors open to a large master bedroom with ensuite bath, walk-in closet and a private balcony. Two additional oversized bedrooms and a main bathroom with rough-in for a future sauna, 3rd upstairs bathroom or upper-level laundry. The professionally finished basement provides two additional rooms ideal for bedrooms, office, or guest space, along with a lavish spa-like bathroom featuring a stylish soaker tub and heated towel rack. A perfect opportunity for professional families seeking a modern home in one of Waterloo's most desirable neighbourhoods."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-14T20:50:09.719250+00:00"
+"CrossStreet": "Columbia Street W"
+"DirectionFaces": "East"
+"Directions": "Columbia turns into Sundew. Stay on Sundew and unit is on the left."
+"ExpirationDate": "2026-09-30"
+"ExteriorFeatures": array:5 [ …5]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-19"
+"MainOfficeKey": "601400"
+"MajorChangeTimestamp": "2026-04-09T15:47:45Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-19T16:39:57Z"
+"OriginalListPrice": 1115000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3694322"
+"ParcelNumber": "226844579"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-19T16:39:57Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 1115000.0
+"PriceChangeTimestamp": "2026-04-09T15:47:45Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sundew"
+"StreetNumber": "565"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7537.69"
+"TaxLegalDescription": "LOT 15, PLAN 58M549 SUBJECT TO AN EASEMENT IN GROSS OVER PT 15 ON 58R-17656 AS IN WR727990 SUBJECT TO AN EASEMENT IN GROSS OVER PT 15 ON 58R-17656 AS IN WR728022 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/565-sundew-drive-waterloo-s/"
+"Zoning": "R6"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 98.43
+"LotWidth": 37.97
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12900182')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000121641"
+"SurveyType": "None"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0B9, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 9
+"PropertyFeatures": array:5 [ …5]
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-27T19:23:48Z"
+"SystemModificationTimestamp": "2026-04-09T15:47:53.820295Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:35 [ …35]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4310
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12966566"
+"ListingId": "X12966566"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-08T13:11:08Z"
+"RFModificationTimestamp": "2026-04-30T02:15:25Z"
+"ListPrice": 1698.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4G6"
+"UnparsedAddress": "406 Tamarack Drive Main, Waterloo, ON N2L 4G6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "legal, licensed student housing. entire main floor for rent , 1 bedroom with living room/ used as 2nd bedroom .Separate entrance, kitchen, bathroom & laundry, furnished detached raised bungalow, located in a highly sought-after neighbourhood within all universities district, new stove, Very bright large living rm with wall to wall window, Walking Distance to all Universities. It's a Perfect House for young couple or 1 person who enjoy big living space or University student to share with other friends or as your family home. Security Camera, Smoke Detector. Carbon Monoxide detector. students are welcome. Parking included, fully furnished. 2 single Beds + Mattress, 2 Desks, sofa, Dining Table and Chairs. Fridge, Stove, Washer, Dryer. microwave, All existing Window coverings and All Elfs . Tenant Pays 40% utilities. A month of free rent if you move in on or before May 1. Assignment is allowed."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-30T01:51:20.792928+00:00"
+"CrossStreet": "Albert St / Columbia St W"
+"DirectionFaces": "South"
+"Directions": "Albert St / Columbia St W"
+"Exclusions": "tenant belongs"
+"ExpirationDate": "2026-08-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Furnished"
+"Inclusions": "1 parking is included"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-07T18:03:53Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-07T18:03:53Z"
+"OriginalListPrice": 1698.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3778094"
+"ParcelNumber": "222760016"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-04-07T18:03:53Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:2 [ …2]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Tamarack"
+"StreetNumber": "406"
+"StreetSuffix": "Drive"
+"TransactionBrokerCompensation": "1/2 Month Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "Main"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 125.0
+"LotWidth": 57.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12966566')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604440001500"
+"SurveyType": "Unknown"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4G6, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 4
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "VACANT"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "vacant, easy showing. Please call for delay or cancel; lock box located at the 1st stair railing. Entrance is beside the garage door."
+"WashroomsType1Level": "Ground"
+"MediaChangeTimestamp": "2026-04-07T18:03:53Z"
+"PortionPropertyLease": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-08T13:11:12.584441Z"
+"VendorPropertyInfoStatement": true
+"Media": array:21 [ …21]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4309
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12913812"
+"ListingId": "X12913812"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-08T05:21:53Z"
+"RFModificationTimestamp": "2026-04-30T02:15:08Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0E4"
+"UnparsedAddress": "723 Wood Lily Street, Waterloo, ON N2V 0E4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4612175
+"Longitude": -80.5996057
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this stunning Activa-built Timbercrest model in the highly desirable Vista Hills community, offering almost 2,800 sq ft of thoughtfully crafted living space, 4 bedrooms, 3.5 bathrooms, 55' frontage and two car garage. This beautifully designed home exudes modern sophistication, featuring light hardwood flooring, contemporary fixtures, and tasteful accents throughout, with impressive 9 ft ceilings on the basement, main, and upper levels enhancing the sense of space and light. The chef-inspired kitchen is equipped with premium appliances, a gas range, Cambria Annicca quartz countertops, and an expansive island, and flows seamlessly into the dining area. From here, sliding doors open to a landscaped backyard with an inviting patio - perfect for entertaining and outdoor enjoyment. The adjoining living room offers a warm and comfortable atmosphere with a cozy fireplace, ideal for relaxing or hosting guests. The main floor also features a convenient laundry area. Upstairs, an additional family room provides the perfect space for unwinding or gathering. The spacious primary suite offers an oversized walk-in closet and a luxurious ensuite complete with a glass shower and a freestanding soaker tub. All bathrooms are finished with quality granite or quartz countertops, adding both style and durability. Additional features include ceramic tile in all wet areas, enlarged basement windows, a 3-piece rough-in for future customization, an HRV system, and a high-efficiency furnace. Set within a peaceful, nature-oriented neighbourhood, residents can enjoy access to a forested greenbelt, offering beautiful natural scenery year-round. At the same time, the home is just minutes from everyday conveniences, including shopping, Costco, healthcare services, and major retailers, ensuring a perfect balance of serenity and accessibility. With its striking brick and vinyl exterior and high-quality finishes throughout, this home delivers exceptional comfort, style, and practicality."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CoListOfficeName": "e Xp Realty"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-14T18:00:10.557157+00:00"
+"CrossStreet": "Sundew Drive and Mayapple"
+"DirectionFaces": "East"
+"Directions": "Sundew Drive and Mayapple"
+"Exclusions": "T.V's - wall mounts to remain. Two bookshelves secured for safety to bedroom walls. Basement carpet."
+"ExpirationDate": "2026-06-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Gas Stove, Washer. The built-in walk-in closet in the primary bedroom will remain. Smart switches to remain. Garden Planters."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-08T05:21:53Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-24T14:00:59Z"
+"OriginalListPrice": 1087911.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707996"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "226845087"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-24T14:01:00Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 1179777.0
+"PriceChangeTimestamp": "2026-04-08T05:21:53Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wood Lily"
+"StreetNumber": "723"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8275.0"
+"TaxAssessedValue": 604000
+"TaxLegalDescription": "LOT 52, PLAN 58M601 SUBJECT TO AN EASEMENT IN GROSS OVER PART 52 ON 58R19762 AS IN WR1032711 SUBJECT TO AN EASEMENT IN GROSS OVER PART 52 ON 58R19762 AS IN WR1032890 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://realsee.ai/p8EEZVAW"
+"VirtualTourURLUnbranded": "https://realsee.ai/p8EEZVAW"
+"Zoning": "NR"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 102.84
+"LotWidth": 55.74
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913812')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000118065"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Water Softener"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0E4, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Square Meters"
+"PropertyFeatures": array:4 [ …4]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please book all showings via Brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"MediaChangeTimestamp": "2026-03-24T14:01:00Z"
+"SystemModificationTimestamp": "2026-04-08T05:22:05.07049Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4308
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12967806"
+"ListingId": "X12967806"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T21:04:11Z"
+"RFModificationTimestamp": "2026-04-30T05:01:32Z"
+"ListPrice": 1975.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0B7"
+"UnparsedAddress": "456 Twin Leaf Street Bsmt, Waterloo, ON N2V 0B7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome To A Beautiful Legal Basement Two Bedrooms Unit. Corner Lot, With Plenty Of Sunlight, large Windows and 9 feet ceilings. Located Minutes Away From Sought After Schools (Vista Hills Public School Till Secondary And Laurelwood Public For High School), Right Across Small Park, Close To Major Stores And Shopping Plaza (Boardwalk, Costco). Sep walk up Entrance with One Car Park on the Driveway. Massive Living/Dining Area, Luxury Bath With Standing Shower, Large Windows In Both Bedrooms. Pot Lights, Carpet Free Main Area, Kitchen With Quartz Countertops, Lots Of Storage, Separate Laundry Room and plenty of storage in kitchen. Located In Very Desirable, And Family-Oriented Neighborhood Of Vista Hills."
+"ArchitecturalStyle": array:1 [ …1]
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-30T02:39:19.081983+00:00"
+"CrossStreet": "Sundrew Dr & Wild Cala St"
+"DirectionFaces": "North"
+"Directions": "Sundrew Dr & Wild Cala St"
+"ExpirationDate": "2026-08-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Existing SS Fridge, Stove, Exhaust, white Washer & Dryer, Spacious Laundry Room With Storage Area, Water Filter & Softener."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-04"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "43.42 x 107.88 Feet"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-04-07T21:04:11Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-07T21:04:11Z"
+"OriginalListPrice": 1975.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3779796"
+"ParcelNumber": "226844704"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-04-07T21:04:11Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Twin Leaf"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month's Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "Bsmt"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 107.88
+"LotWidth": 43.42
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12967806')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000118683"
+"SurveyType": "None"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0B7, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Free"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Basement"
+"MediaChangeTimestamp": "2026-04-07T21:04:11Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-07T21:04:11.678072Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4307
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12709768"
+"ListingId": "X12709768"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T20:51:54Z"
+"RFModificationTimestamp": "2026-04-30T02:14:41Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0B 1M0"
+"UnparsedAddress": "21 West Tree Drive, Waterloo, ON N0B 1M0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488288
+"Longitude": -80.411813
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Great for a large or multi generational family, this 4 bedroom home has plenty of living space! Soaring entryway and living room opens on a grand staircase. Expansive dining room allows for large family gatherings. The kitchen has new gleaming white quartz countertops and ample space for storage and room for 2 chefs in the kitchen. Main floor family room is visible from the kitchen and the dinette has a slider to fenced back yard oasis with salt water in-ground pool with overflow hot tub for summer entertaining. Fully finished basement has oodles of more space, a bathroom, huge rec room and another large space. Upstairs features a large primary suite with a walk in closet and an ensuite with separate shower and soaker tub, plus 3 additional bedrooms, main bath and an airy sitting area or office space. Be sure to book your private showing. New furnace and AC in 2022."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-22T18:05:33.072665+00:00"
+"CrossStreet": "Townsend"
+"DirectionFaces": "East"
+"Directions": "Fountain to Townsend to West Tree"
+"Exclusions": "security camera system, most tvs, curtains in basement and boys bedroom"
+"ExpirationDate": "2026-05-30"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:2 [ …2]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Carbon Monoxide Detector, Dishwasher, Dryer, Gas Oven/Range, Gas Stove, Pool Equipment, Range Hood, Refrigerator, Smoke Detector, Washer, rec room TV play center"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-19"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-01-19T18:00:02Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-01-19T18:00:02Z"
+"OriginalListPrice": 1200000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3456608"
+"ParcelNumber": "222510522"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-01-19T18:00:02Z"
+"PoolFeatures": array:2 [ …2]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "West Tree"
+"StreetNumber": "21"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6393.0"
+"TaxAssessedValue": 553000
+"TaxLegalDescription": "LOT 62, PLAN 58M-356, TWP OF WOOLWICH; T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 415."
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/21_w_tree_dr_breslau_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/21_w_tree_dr_breslau_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.19
+"LotWidth": 48.26
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12709768')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "302903000528122"
+"SurveyType": "Unknown"
+"RentalItems": "Water heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N0B 1M0, CA"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 4
+"RoomsBelowGrade": 1
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 2
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Some notice pls"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-04-07T20:51:54Z"
+"SystemModificationTimestamp": "2026-04-07T20:51:54.440123Z"
+"VendorPropertyInfoStatement": true
+"Media": array:50 [ …50]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4306
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12845546"
+"ListingId": "X12845546"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-07T18:55:59Z"
+"RFModificationTimestamp": "2026-04-30T05:00:35Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street G612, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/YORKLAND REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Excellent Location For This Freshly Painted, Very Spacious, 771 Sq Ft, Bright, Fully Furnished 2-Bed, 2-Bath Unit Plus An Oversized 108 Sq Ft Balcony, 1 Parking & Clear Views! Close To Wilfrid Laurier University, University Of Waterloo, Restaurants, Groceries, Parks, Theaters +++ Low Maintenance Fees, Includes Internet, Water, Heat. Amenities Incl A Fully Equipped Gym, A Yoga & Meditation Room, Study Lounge, Theatre & Games Room & Outdoor Terrace. Excellent Clean & Quiet Neighborhood. Super Investment Opportunity, Or For University Parents, Or First-Time Buyers! This Condo Comes With A Coveted Parking Spot Too!.... Very Rarely Offered!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "570.39"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"BuildingName": "URL Condos Building G"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-30T03:05:58.816995+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-08-15"
+"Inclusions": "Fridge, Stove, Range Hood, Dishwasher, Stacked Washer/Dryer, 2 Double Beds, 2 Double Mattresses, 2 Night Tables, 1 Large Armoire, 2 Desks W 2 Chairs, 1 Media Unit, 1 Coffee Table, 1 3-Seater Leather Sofa, 1 Dining Table W 4 Chairs, Parking."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "658500"
+"MajorChangeTimestamp": "2026-04-07T18:55:58Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-04T19:23:57Z"
+"OriginalListPrice": 459900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3540110"
+"ParcelNumber": "236430555"
+"ParkingFeatures": array:1 [ …1]
…61
}
]
+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 {#4277
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4071 …121}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4072 …142}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073 …138}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …139}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …112}
]
+success: true
+page_size: 5
+page_count: 9455
+count: 47271
+after_key: ""
}
]
]
