array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=240&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=240&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=240&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=240&$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: "464825"
+post_author: 1
+"ListingKey": "X12415455"
+"ListingId": "X12415455"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:33:48Z"
+"RFModificationTimestamp": "2026-04-29T03:29:34Z"
+"ListPrice": 4500.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2X1"
+"UnparsedAddress": "619 Wild Ginger Avenue C15, Waterloo, ON N2V 2X1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4694105
+"Longitude": -80.5945734
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX METROPOLIS REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Completely renovted 3 Bedroom Executive Town House Available For Rent. The Unit Has 3 And A Half Bath And Is Approximately 2100 Square Feet Big. The Unit Has Finished Basement, Main Floor and basement are Zoned Commercial, Central Heating/Ac, Central Vacuum, Water Softener **EXTRAS** Fridge, Stove, Washer & Dryer, Dishwasher And Microwave, Window Coverings Throughout And 1 Car Garage With total of 3 Parking Spaces."
+"ArchitecturalStyle": "3-Storey"
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T23:30:58.155211+00:00"
+"CrossStreet": "Laurelwood &Erbsville"
+"DirectionFaces": "West"
+"Directions": "Laurelwood &Erbsville"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Fridge, stove, washer & dryer, dishwasher and microwave, window coverings throughout the suite. central vacuum, garage remote openerand water softener"
+"InteriorFeatures": "Central Vacuum"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-09-19"
+"MainOfficeKey": "302700"
+"MajorChangeTimestamp": "2026-03-24T19:33:48Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-09-19T17:06:35Z"
+"OriginalListPrice": 4950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3018016"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-09-19T17:06:35Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 4950.0
+"PriceChangeTimestamp": "2026-03-24T19:33:48Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:2 [ …2]
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "7"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wild Ginger"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "Half a month's Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "C15"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c15_619_wild_ginger_ave_waterloo_on/"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12415455')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BuyOptionYN": true
+"HoldoverDays": 90
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2X1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"StreetSuffixCode": "Ave"
+"BoardPropertyType": "Free"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Third"
+"WashroomsType2Level": "Third"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-09-19T17:06:35Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Prudential Property Management Ltd."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-24T19:33:54.128848Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:34 [ …34]
+"ID": "464825"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "490799"
+post_author: 1
+"ListingKey": "X12437866"
+"ListingId": "X12437866"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:33:08Z"
+"RFModificationTimestamp": "2026-04-29T03:29:35Z"
+"ListPrice": 4500.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2X1"
+"UnparsedAddress": "619 Wild Ginger Avenue C16, Waterloo, ON N2V 2X1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4694105
+"Longitude": -80.5945734
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX METROPOLIS REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Completely renovated 3 Bedroom Executive Town House Available For Rent. The Unit Has 3 And A Half Bath And Is Approximately 2100 Square Feet Big. The Unit Has Finished Basement, Main Floor and basement are Zoned Commercial, Central Heating/Ac, Central Vacuum, Water Softener **EXTRAS** Fridge, Stove, Washer & Dryer, Dishwasher And Microwave, Window Coverings Throughout And 1 Car Garage With total of 3 Parking Spaces."
+"ArchitecturalStyle": "3-Storey"
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T23:32:16.878051+00:00"
+"CrossStreet": "Laurelwood &Erbsville"
+"DirectionFaces": "West"
+"Directions": "Laurelwood &Erbsville"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Fridge, stove, washer & dryer, dishwasher and microwave, window coverings throughout the suite. central vacuum, garage remote openerand water softener"
+"InteriorFeatures": "Central Vacuum"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-01"
+"MainOfficeKey": "302700"
+"MajorChangeTimestamp": "2026-03-24T19:33:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-01T18:10:06Z"
+"OriginalListPrice": 4950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3074460"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-10-01T18:10:07Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 4950.0
+"PriceChangeTimestamp": "2026-03-24T19:33:08Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:3 [ …3]
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "7"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wild Ginger"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "Half a month's rent"
+"TransactionType": "For Lease"
+"UnitNumber": "C16"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c16_619_wild_ginger_ave_waterloo_on/"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12437866')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"HoldoverDays": 90
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2X1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"StreetSuffixCode": "Ave"
+"BoardPropertyType": "Free"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Third"
+"WashroomsType2Level": "Third"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-10-01T18:25:04Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Prudential Property Management Ltd."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-24T19:33:14.876159Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
+"ID": "490799"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "664964"
+post_author: 1
+"ListingKey": "X12913666"
+"ListingId": "X12913666"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T18:47:12Z"
+"RFModificationTimestamp": "2026-04-30T02:15:08Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3L5"
+"UnparsedAddress": "601 Sandringham Drive, Waterloo, ON N2K 3L5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5031629
+"Longitude": -80.5227681
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "BOSLEY REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "SANDRINGHAM SHOWSTOPPER! Welcome to 601 Sandringham Drive in Waterloo-an impressive two-storey family home offering space, style, and a backyard designed for entertaining. The heart of the home is the beautifully updated open-concept kitchen and living area, featuring quartz countertops, a convenient pot filler above the stove, walk-in pantry, and a stylish coffee bar complete with wine cooler-perfect for both everyday living and entertaining. The kitchen flows seamlessly into the bright living room and into a sunroom overlooking the backyard, creating a warm and inviting space filled with natural light. Downstairs, the fully finished basement has been completely updated and is truly turn-key, offering additional living space along with bonus room and a separate exterior entrance at the rear of the home-ideal for extended family or future in-law potential (kitchen rough-in). Step outside to your own private backyard retreat, highlighted by a saltwater pool with stunning waterfall features, surrounded by interlocking stone patio and enclosed by a newer high privacy fence, creating the perfect setting for summer relaxation and entertaining. Ideally located in a highly desirable Waterloo neighbourhood, you're just minutes to Conestoga Mall, a 6-minute drive to RIM Park featuring ice pads, indoor soccer and basketball courts, outdoor sports fields and scenic walking trails, and close to the renowned Grey Silo Golf Course. A rare opportunity to own a spacious, move-in ready home with resort-style backyard living in Waterloo."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-19T23:45:23.515337+00:00"
+"CrossStreet": "Sandringham Drive & Old Abbey Rd."
+"DirectionFaces": "South"
+"Directions": "Northfield Dr East, turn right on Wissler Rd, turn right on Sandringham Dr"
+"Exclusions": "All Gym Equipment and Weights Attached to Walls in Garage."
+"ExpirationDate": "2026-07-31"
+"FireplaceFeatures": array:4 [ …4]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Gas Stove, Microwave, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings, Wine Cooler, Gazebo, TV Wall Mount Brackets, All Mirrors Above Bathroom Vanities."
+"InteriorFeatures": "Carpet Free,In-Law Capability,Sump Pump,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "063500"
+"MajorChangeTimestamp": "2026-03-24T18:47:12Z"
+"MlsStatus": "Extension"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-24T13:47:36Z"
+"OriginalListPrice": 1449900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3704876"
+"ParcelNumber": "222840082"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-13T16:10:50Z"
+"PoolFeatures": "Salt,Inground"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sandringham"
+"StreetNumber": "601"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "9138.0"
+"TaxLegalDescription": "LT 29 PL 1644 CITY OF WATERLOO S/T INTEREST IN 952094; S/T 886423; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + hst"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/v33mh_601_sandringham_dr_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 113.37
+"LotWidth": 58.96
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913666')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601355302100"
+"SurveyType": "Unknown"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3L5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-06-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 7
+"LotSizeAreaUnits": "Square Feet"
+"PossessionDetails": "60-89 days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2026-04-13T16:10:50Z"
+"ExtensionEntryTimestamp": "2026-03-24T18:47:12Z"
+"SystemModificationTimestamp": "2026-04-13T16:10:50.009637Z"
+"Media": array:43 [ …43]
+"ID": "664964"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "695362"
+post_author: 1
+"ListingKey": "X12915552"
+"ListingId": "X12915552"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T17:43:58Z"
+"RFModificationTimestamp": "2026-04-28T16:36:08Z"
+"ListPrice": 445000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "251 Hemlock Street 502, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4751797
+"Longitude": -80.5317287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "LANDPOWER REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stop renting and start investing or self use! This spacious 2-bedroom, 2-bathroom unit is the ultimate "worry-free" property. Perfectly situated in the Centre of Waterloo's Growth District, it's designed specifically for the modern student lifestyle. Minutes away from the University of Waterloo, Wilfrid Laurier, and the Technology Park. This East facing Unit is flooded with natural light and offers a generous 800 sq. ft. of living space. Designed with a modern aesthetic and functionality in mind, features include: Layout: 2 Bedrooms and 2 Full Bathrooms with a spacious open-concept design. Finishes: High ceilings, sleek laminate flooring throughout, and granite kitchen countertops with an undermounted sink.Appliances: Stainless steel kitchen appliances and convenient in-suite laundry.Views: Massive floor-to-ceiling windows in both bedrooms, offering bright, airy vibes.Turnkey: The unit comes fully furnished, specifically curated for student life."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "499.16"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "LANDPOWER REAL ESTATE LTD."
+"CoListOfficePhone": "905-305-9669"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-20T00:00:07.319687+00:00"
+"CrossStreet": "University and Hemlock"
+"Directions": "Besides St. Michael's Roman Catholic Church"
+"ExpirationDate": "2026-08-31"
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "020200"
+"MajorChangeTimestamp": "2026-03-24T17:34:44Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T17:34:44Z"
+"OriginalListPrice": 445000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3713668"
+"ParcelNumber": "236420130"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T17:34:45Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3086.08"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "502"
+"Zoning": "Residential"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12915552')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004070"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "4"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 642
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Builder"
+"PossessionDetails": "30 days/TBA"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-24T17:43:58Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-03-24T17:44:02.505361Z"
+"Media": array:7 [ …7]
+"ID": "695362"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "648812"
+post_author: 1
+"ListingKey": "X12911676"
+"ListingId": "X12911676"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:50:17Z"
+"RFModificationTimestamp": "2026-04-29T03:30:41Z"
+"ListPrice": 1895000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.41
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1Z1"
+"UnparsedAddress": "370 Green Acres Drive, Waterloo, ON N2K 1Z1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5029001
+"Longitude": -80.5114107
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This is the home you have been waiting for. A rare & iconic offering in Old Colonial Acres, one of Waterloo's most prestigious & established neighbourhoods. Set on an expansive, mature, tree-lined lot of approx. acre, this timeless Tudor-style home offers 4,300+ SF of beautifully finished living space with 5 bedrms, 4 bathrms, extensive updates, exceptional privacy, & a backyard that feels like a private resort. Tucked away on a quiet court & surrounded by mature trees, this home offers a level of tranquility rarely found-true cottage-style living in the city, just mins to universities, major employers, & everyday amenities. Designed for both entertaining & everyday living, the bright & spacious layout features a grand 2-storey foyer, impressive great rm with gas FP & bay window, & a formal dining rm. The updated Country Lane kitchen is the heart of the home, complete with heated slate flrs, premium appliances, & oversized island with seating for 6, with direct backyard access for seamless indoor-outdoor living. A functional mudrm with built-ins, garage access, & a well-placed powder rm with backyard entry add convenience. The upper level offers 5 generous bedrms, highlighted by a hotel-inspired primary retreat, with custom feature wall with electric FP, sitting area, walk-in dressing rm with built-ins & laundry area, & a beautifully updated spa-like ensuite with double floating vanities & oversized glass walk-in shower. 4 additional bedrms (3 with balcony access), an updated 5-pc main bath, & 361 SF attic complete the upper level. The finished lower level adds valuable additional living space complete with a rec rm with gas FP, exercise area, games rm, & 2-pc bathrm. Outdoors, the private backyard features an inground pool, expansive patio, covered seating area, & multiple outdoor living spaces-creating a true oasis. This home blends privacy, timeless architecture, & a resort-like lifestyle just mins to universities, Conestoga Mall, parks, trails, & major routes."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-20T01:04:55.578929+00:00"
+"CrossStreet": "LEE AVENUE"
+"DirectionFaces": "North"
+"Directions": "LEE AVENUE TO GREEN ACRES DRIVE"
+"Exclusions": "Hot Tub, Basement TV."
+"ExpirationDate": "2026-08-23"
+"ExteriorFeatures": "Awnings,Deck,Landscaped,Porch,Privacy"
+"FireplaceFeatures": array:4 [ …4]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings, Beverage Fridge, Gas Cooktop, Wall Oven, Sonos System with the sound bar and outdoor speakers, all TV's (except basement TV)."
+"InteriorFeatures": "Auto Garage Door Remote,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-03-23T20:24:34Z"
+"MlsStatus": "Extension"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-23T20:11:08Z"
+"OriginalListPrice": 1895000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707228"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "222870243"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-23T20:11:08Z"
+"PoolFeatures": "Inground"
+"Roof": "Asphalt Shingle"
+"Sewer": "Septic"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Green Acres"
+"StreetNumber": "370"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10692.06"
+"TaxAssessedValue": 783000
+"TaxLegalDescription": "LT 38 PL 1164 CITY OF WATERLOO; S/T 291782; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST (SEE REMARKS)"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://youriguide.com/aw7jt_370_green_acres_dr_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/aw7jt_370_green_acres_dr_waterloo_on/"
+"VirtualTourURLUnbranded2": "https://youtu.be/J8y OBv Mco Eo"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 147.17
+"LotWidth": 135.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12911676')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601165001000"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1Z1, CA"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "FLEXIBLE"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-03-23T20:11:08Z"
+"ExtensionEntryTimestamp": "2026-03-23T20:24:34Z"
+"SystemModificationTimestamp": "2026-03-24T13:50:29.423752Z"
+"Media": array:50 [ …50]
+"ID": "648812"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "705197"
+post_author: 1
+"ListingKey": "X12910602"
+"ListingId": "X12910602"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:29:46Z"
+"RFModificationTimestamp": "2026-04-28T16:36:06Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E7"
+"UnparsedAddress": "181 King Street S 1602, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4604
+"Longitude": -80.5202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CORCORAN HORIZON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "An exceptional turnkey investment opportunity in one of Uptown Waterloo's most sought-after buildings. This unit offers a truly hands-off ownership experience, featuring a secure, long-term lease in place for 5+ years, ensuring stable and predictable income from day one. What distinguishes this property is its fully managed structure. The tenant-an established and reputable company-not only occupies the unit but also assumes all property management responsibilities. This comprehensive arrangement is seamlessly integrated into the monthly rental income, providing investors with a completely passive, worry-free investment. Ideal for those seeking long-term stability, minimal involvement, and consistent returns in a prime urban location, this is a rare opportunity to acquire a secure, low-maintenance asset in a high-demand market."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "745.69"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"BuildingName": "CIRCA 1877"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-26T20:13:56.692558+00:00"
+"CrossStreet": "ALLEN STREET WEST"
+"Directions": "ON THE INTERSECTION OF KING STREET SOUTH AND ALLENSTREET WEST"
+"ExpirationDate": "2026-10-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "247700"
+"MajorChangeTimestamp": "2026-03-23T17:24:05Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-23T17:24:05Z"
+"OriginalListPrice": 399900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707916"
+"ParcelNumber": "237140071"
+"ParkingFeatures": "None"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-23T17:24:05Z"
+"Roof": "Flat"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4535.0"
+"TaxAssessedValue": 331000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1602"
+"View": array:1 [ …1]
+"Zoning": "U2-81"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12910602')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301603120002440"
+"SurveyType": "None"
+"BalconyType": "Enclosed"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "16"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 714
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Other"
+"ParkingLevelUnit1": "A/7/1"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Agents use Broker Bay. Please allow a minimum of 48 hours' notice for all showings."
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "02"
+"MediaChangeTimestamp": "2026-03-23T17:24:05Z"
+"PropertyManagementCompany": "KING CONDO MGMT"
+"SystemModificationTimestamp": "2026-03-24T13:29:48.773636Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:29 [ …29]
+"ID": "705197"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "649317"
+post_author: 1
+"ListingKey": "X12913090"
+"ListingId": "X12913090"
+"PropertyType": "Residential"
+"PropertySubType": "Co-op Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T12:34:34Z"
+"RFModificationTimestamp": "2026-04-28T16:36:07Z"
+"ListPrice": 578000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3H6"
+"UnparsedAddress": "8 Hickory Street #1002, Waterloo, ON N2L 3H6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.478204
+"Longitude": -80.5251752
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Huge Investment opportunity, monthly rent 3400 with signed agreement. 7.05% return. Stable Income, student tenants. HIGH END STUDENT LIVING - SAGE BUILT! This Stunning Condo is located within Walking Distance to UW, Laurier, Restaurants, Shopping & situated right on the LRT! This Spacious Layout is almost 1400 sqft with 3 Large bedrooms & 2 Full bathrooms, as well as In-suite Laundry. This is an extremely rare TOP FLOOR UNIT with 10 FOOT CEILINGS and a Balcony! You will love the Stunning Kitchen with Large Island & Stainless Appliances - Separate Dinette & Family room. The Unit Comes Fully furnished (3 x bedrooms, dinette, living room furniture & Big Screen TV, etc.) You will be impressed from the moment you walk up to the Buildings' Modern Exterior & Enter through the Spacious Foyer with Towering 20 ft Ceilings. Building also has fabulous bright lounge & newly renovated exercise room."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "562.63"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"BuildingName": "Sage 1"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-26T20:20:56.792082+00:00"
+"CrossStreet": "KING STREET TO HICKORY STREET"
+"Directions": "KING STREET TO HICKORY STREET"
+"Exclusions": "tenants belongings"
+"ExpirationDate": "2026-08-31"
+"Inclusions": "dishwasher, dryer, range hood, refrigerator, stove, washer"
+"InteriorFeatures": "Carpet Free,Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-03-24T12:34:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T12:34:34Z"
+"OriginalListPrice": 578000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3712560"
+"ParcelNumber": "235600069"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T12:34:34Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5521.0"
+"TaxAssessedValue": 403000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "#1002"
+"Zoning": "GR"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913090')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301640423500045"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "hot water heater"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "10"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3H6, CA"
+"ApproximateAge": "11-15"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 560
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"NumberSharesPercent": "100"
+"ShowingAppointments": "tenants might be home, please knock"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-24T12:34:34Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-24T12:34:34.682405Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
+"ID": "649317"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "648599"
+post_author: 1
+"ListingKey": "X12912006"
+"ListingId": "X12912006"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-23T21:07:30Z"
+"RFModificationTimestamp": "2026-04-29T21:40:34Z"
+"ListPrice": 5250.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3A1"
+"UnparsedAddress": "30 Regina Street N, Waterloo, ON N2J 3A1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4669304
+"Longitude": -80.521382
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious and incredibly-located student rental in the heart of Waterloo! This 7 bed, 3 full bath home offers a functional layout, on-site laundry, and available parking - perfect for student living.Ideally situated just 800m from Wilfrid Laurier University and 2km from the University of Waterloo. Enjoy unbeatable convenience with shopping, grocery, ION Station and Waterloo Public Square just 500m away from your door!A fantastic opportunity to live in a highly connected and convenient location."
+"ArchitecturalStyle": "2 1/2 Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Wall Unit(s)"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-20T01:58:46.996374+00:00"
+"CrossStreet": "Princess St / Regina St"
+"DirectionFaces": "West"
+"Directions": "Princess St / Regina St"
+"ExpirationDate": "2026-09-18"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Partially"
+"Inclusions": "furniture, stove, fridges, washer, dryer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-23T21:07:30Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-23T21:07:30Z"
+"OriginalListPrice": 5250.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3709232"
+"ParcelNumber": "223740061"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-03-31T17:54:01Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [ …1]
+"Roof": "Asphalt Shingle"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Regina"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "half months rent plus hst"
+"TransactionType": "For Lease"
+"DDFYN": true
+"HeatType": "Radiant"
+"LotDepth": 75.0
+"LotWidth": 37.5
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12912006')"
+"GarageType": "None"
+"HeatSource": "Other"
+"RollNumber": "301601335000900"
+"SurveyType": "Unknown"
+"RentalItems": "Hot water tank"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3A1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 3
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 6
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Square Feet"
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"RentalApplicationYN": true
+"MediaChangeTimestamp": "2026-03-31T17:54:01Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-31T17:54:01.120425Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:25 [ …25]
+"ID": "648599"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "644701"
+post_author: 1
+"ListingKey": "X12896366"
+"ListingId": "X12896366"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-23T20:27:57Z"
+"RFModificationTimestamp": "2026-04-29T03:30:36Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0.5
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2A 0J8"
+"UnparsedAddress": "72 Grand Flats Trail, Waterloo, ON N2A 0J8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.452306
+"Longitude": -80.3991691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This exquisite two-story family residence, located at 72 Grand Flats Trail in Lackner Woods at Explorers, features four plus two bedrooms. The property immediately impresses with its distinguished stone pillars and inviting covered porch. Upon entering, the bright foyer and nine-foot ceilings establish an open and expansive atmosphere throughout the carpet-free main floor. This level includes a formal dining room, bathed in natural light, and a conveniently located laundry room. The kitchen is a highlight, boasting quartz countertops, stainless steel appliances, ample storage, a custom backsplash, white cabinetry with additional pantry space, and a generous quartz island with a breakfast bar.The upper level is enhanced by California shutters and a versatile landing area, ideal for a sitting room or home office. This floor comprises four spacious bedrooms, including a primary suite with a walk-in closet and a five-piece ensuite bathroom. Two additional bedrooms also benefit from walk-in closets. The fully finished basement expands the living space with two further bedrooms, a recreation room perfect for entertaining, and a fourth bathroom appointed with granite countertops.Strategically situated, this home offers exceptional accessibility to the Grand River, walking trails, Waterloo Airport, parks, and schools. Furthermore, it is merely a seven-minute drive to Highway 401, making this property a truly comprehensive offering."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T20:41:50.306908+00:00"
+"CrossStreet": "Eden Oak Trail / Fairway Rd N"
+"DirectionFaces": "North"
+"Directions": "Eden Oak Trail / Fairway Rd N"
+"Exclusions": "TV mounts in living"
+"ExpirationDate": "2026-06-04"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Etc"
+"InteriorFeatures": "Water Meter,Sump Pump,Storage"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-03-18T17:20:57Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-18T17:20:57Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3628966"
+"ParcelNumber": "227136214"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-18T17:20:57Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Grand Flats"
+"StreetNumber": "72"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6661.0"
+"TaxLegalDescription": "LOT 125, PLAN 58M597 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.50 % Plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://house.sf-photography-photographer.com/72-grand-flats-trail-kitchener-ontario-n2a-0j8?branded=1"
+"VirtualTourURLUnbranded": "https://house.sf-photography-photographer.com/72-grand-flats-trail-kitchener-ontario-n2a-0j8?branded=0"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 101.71
+"LotShape": "Rectangular"
+"LotWidth": 36.09
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12896366')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001707217"
+"SurveyType": "None"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2A 0J8, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-28"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:3 [ …3]
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-03-18T17:20:57Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-03-23T20:28:08.348513Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:39 [ …39]
+"ID": "644701"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "644698"
+post_author: 1
+"ListingKey": "X12879958"
+"ListingId": "X12879958"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-19T20:49:13Z"
+"RFModificationTimestamp": "2026-04-29T06:17:36Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4S8"
+"UnparsedAddress": "249 Cedarbrae Avenue 18, Waterloo, ON N2L 4S8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4853844
+"Longitude": -80.5507378
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY FAISAL SUSIWALA REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "FANTASTIC STARTER HOME OR INVESTMENT IN A PRIME WATERLOO LOCATION. Welcome to #18 -249 Cedarbrae Avenue, Waterloo, an excellent opportunity to enter the real estate market as a first-time buyer or investor. The main floor features a spacious living room and an updated galley-style kitchen with plenty of freshly refreshed cabinetry, open to the dinette for easy everyday living. Upstairs, you'll appreciate the generous primary bedroom with a walk-in closet, along with a 2nd spacious bedroom and a beautiful 4pc bathroom completing the upper level. The partly finished basement offers additional space ready for your personal finishing touches, with a rough-in for a bathroom, and a separate entrance to a common hallway provides direct access to the basement, a unique and valuable bonus. Ideally located close to both universities, Sobeys, Conestoga Mall, public transit, and the LRT, with easy access to the Expressway. The public library, Columbia Lake, Laurel Creek Conservation Area, parks, shopping, and restaurants are all nearby, making this an incredibly convenient and desirable location. Perfect for a first home or investment property, this condo townhouse also includes exterior maintenance in the condo fees and one dedicated parking space. Virtually staged."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "471.4"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T00:55:06.142692+00:00"
+"CrossStreet": "NORTHFIELD DR W/WEBER/GLEN FORREST"
+"Directions": "GLEN FOREST BLVD"
+"ExpirationDate": "2026-05-30"
+"FoundationDetails": array:1 [ …1]
+"InteriorFeatures": "Water Heater Owned"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-11"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "346400"
+"MajorChangeTimestamp": "2026-03-13T14:18:40Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-13T14:18:40Z"
+"OriginalListPrice": 349900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3667684"
+"ParcelNumber": "230500018"
+"ParkingFeatures": "Reserved/Assigned"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-13T14:20:58Z"
+"Roof": "Asphalt Shingle"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Cedarbrae"
+"StreetNumber": "249"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2260.0"
+"TaxAssessedValue": 165000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "18"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/18_249_cedarbrae_avenue_waterloo_on/"
+"Zoning": "RMU-20"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12879958')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301604095006117"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4S8, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 50
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 1
+"SquareFootSource": "floorplan attached"
+"ParkingLevelUnit1": "18"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Brokerbay or call listing brokerage."
+"WashroomsType1Level": "Upper"
+"LegalApartmentNumber": "18"
+"MediaChangeTimestamp": "2026-03-19T20:49:13Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-19T20:49:13.234998Z"
+"Media": array:21 [ …21]
+"ID": "644698"
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Cache Key: 9980d47576a736d129caddfad5d2398ec6b299a2c18b6ba35047f772fcc282d0" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3111
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4303
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12415455"
+"ListingId": "X12415455"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:33:48Z"
+"RFModificationTimestamp": "2026-04-29T03:29:34Z"
+"ListPrice": 4500.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2X1"
+"UnparsedAddress": "619 Wild Ginger Avenue C15, Waterloo, ON N2V 2X1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4694105
+"Longitude": -80.5945734
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX METROPOLIS REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Completely renovted 3 Bedroom Executive Town House Available For Rent. The Unit Has 3 And A Half Bath And Is Approximately 2100 Square Feet Big. The Unit Has Finished Basement, Main Floor and basement are Zoned Commercial, Central Heating/Ac, Central Vacuum, Water Softener **EXTRAS** Fridge, Stove, Washer & Dryer, Dishwasher And Microwave, Window Coverings Throughout And 1 Car Garage With total of 3 Parking Spaces."
+"ArchitecturalStyle": array:1 [ …1]
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T23:30:58.155211+00:00"
+"CrossStreet": "Laurelwood &Erbsville"
+"DirectionFaces": "West"
+"Directions": "Laurelwood &Erbsville"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Fridge, stove, washer & dryer, dishwasher and microwave, window coverings throughout the suite. central vacuum, garage remote openerand water softener"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-09-19"
+"MainOfficeKey": "302700"
+"MajorChangeTimestamp": "2026-03-24T19:33:48Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-09-19T17:06:35Z"
+"OriginalListPrice": 4950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3018016"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-09-19T17:06:35Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 4950.0
+"PriceChangeTimestamp": "2026-03-24T19:33:48Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:2 [ …2]
+"Roof": array:1 [ …1]
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wild Ginger"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "Half a month's Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "C15"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c15_619_wild_ginger_ave_waterloo_on/"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12415455')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BuyOptionYN": true
+"HoldoverDays": 90
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2X1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"StreetSuffixCode": "Ave"
+"BoardPropertyType": "Free"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Third"
+"WashroomsType2Level": "Third"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-09-19T17:06:35Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Prudential Property Management Ltd."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-24T19:33:54.128848Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:34 [ …34]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4304
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12437866"
+"ListingId": "X12437866"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:33:08Z"
+"RFModificationTimestamp": "2026-04-29T03:29:35Z"
+"ListPrice": 4500.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2X1"
+"UnparsedAddress": "619 Wild Ginger Avenue C16, Waterloo, ON N2V 2X1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4694105
+"Longitude": -80.5945734
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX METROPOLIS REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Completely renovated 3 Bedroom Executive Town House Available For Rent. The Unit Has 3 And A Half Bath And Is Approximately 2100 Square Feet Big. The Unit Has Finished Basement, Main Floor and basement are Zoned Commercial, Central Heating/Ac, Central Vacuum, Water Softener **EXTRAS** Fridge, Stove, Washer & Dryer, Dishwasher And Microwave, Window Coverings Throughout And 1 Car Garage With total of 3 Parking Spaces."
+"ArchitecturalStyle": array:1 [ …1]
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T23:32:16.878051+00:00"
+"CrossStreet": "Laurelwood &Erbsville"
+"DirectionFaces": "West"
+"Directions": "Laurelwood &Erbsville"
+"ExpirationDate": "2026-09-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "Fridge, stove, washer & dryer, dishwasher and microwave, window coverings throughout the suite. central vacuum, garage remote openerand water softener"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-01"
+"MainOfficeKey": "302700"
+"MajorChangeTimestamp": "2026-03-24T19:33:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-01T18:10:06Z"
+"OriginalListPrice": 4950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3074460"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-10-01T18:10:07Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 4950.0
+"PriceChangeTimestamp": "2026-03-24T19:33:08Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:3 [ …3]
+"Roof": array:1 [ …1]
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wild Ginger"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "Half a month's rent"
+"TransactionType": "For Lease"
+"UnitNumber": "C16"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c16_619_wild_ginger_ave_waterloo_on/"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12437866')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"HoldoverDays": 90
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2X1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"StreetSuffixCode": "Ave"
+"BoardPropertyType": "Free"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Third"
+"WashroomsType2Level": "Third"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-10-01T18:25:04Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Prudential Property Management Ltd."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-24T19:33:14.876159Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4307
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12913666"
+"ListingId": "X12913666"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T18:47:12Z"
+"RFModificationTimestamp": "2026-04-30T02:15:08Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3L5"
+"UnparsedAddress": "601 Sandringham Drive, Waterloo, ON N2K 3L5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5031629
+"Longitude": -80.5227681
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "BOSLEY REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "SANDRINGHAM SHOWSTOPPER! Welcome to 601 Sandringham Drive in Waterloo-an impressive two-storey family home offering space, style, and a backyard designed for entertaining. The heart of the home is the beautifully updated open-concept kitchen and living area, featuring quartz countertops, a convenient pot filler above the stove, walk-in pantry, and a stylish coffee bar complete with wine cooler-perfect for both everyday living and entertaining. The kitchen flows seamlessly into the bright living room and into a sunroom overlooking the backyard, creating a warm and inviting space filled with natural light. Downstairs, the fully finished basement has been completely updated and is truly turn-key, offering additional living space along with bonus room and a separate exterior entrance at the rear of the home-ideal for extended family or future in-law potential (kitchen rough-in). Step outside to your own private backyard retreat, highlighted by a saltwater pool with stunning waterfall features, surrounded by interlocking stone patio and enclosed by a newer high privacy fence, creating the perfect setting for summer relaxation and entertaining. Ideally located in a highly desirable Waterloo neighbourhood, you're just minutes to Conestoga Mall, a 6-minute drive to RIM Park featuring ice pads, indoor soccer and basketball courts, outdoor sports fields and scenic walking trails, and close to the renowned Grey Silo Golf Course. A rare opportunity to own a spacious, move-in ready home with resort-style backyard living in Waterloo."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-19T23:45:23.515337+00:00"
+"CrossStreet": "Sandringham Drive & Old Abbey Rd."
+"DirectionFaces": "South"
+"Directions": "Northfield Dr East, turn right on Wissler Rd, turn right on Sandringham Dr"
+"Exclusions": "All Gym Equipment and Weights Attached to Walls in Garage."
+"ExpirationDate": "2026-07-31"
+"FireplaceFeatures": array:4 [ …4]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Gas Stove, Microwave, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings, Wine Cooler, Gazebo, TV Wall Mount Brackets, All Mirrors Above Bathroom Vanities."
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "063500"
+"MajorChangeTimestamp": "2026-03-24T18:47:12Z"
+"MlsStatus": "Extension"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-24T13:47:36Z"
+"OriginalListPrice": 1449900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3704876"
+"ParcelNumber": "222840082"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-13T16:10:50Z"
+"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": "Sandringham"
+"StreetNumber": "601"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "9138.0"
+"TaxLegalDescription": "LT 29 PL 1644 CITY OF WATERLOO S/T INTEREST IN 952094; S/T 886423; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + hst"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/v33mh_601_sandringham_dr_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 113.37
+"LotWidth": 58.96
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913666')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601355302100"
+"SurveyType": "Unknown"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3L5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-06-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 7
+"LotSizeAreaUnits": "Square Feet"
+"PossessionDetails": "60-89 days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2026-04-13T16:10:50Z"
+"ExtensionEntryTimestamp": "2026-03-24T18:47:12Z"
+"SystemModificationTimestamp": "2026-04-13T16:10:50.009637Z"
+"Media": array:43 [ …43]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4306
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12915552"
+"ListingId": "X12915552"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T17:43:58Z"
+"RFModificationTimestamp": "2026-04-28T16:36:08Z"
+"ListPrice": 445000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "251 Hemlock Street 502, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4751797
+"Longitude": -80.5317287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "LANDPOWER REAL ESTATE LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stop renting and start investing or self use! This spacious 2-bedroom, 2-bathroom unit is the ultimate "worry-free" property. Perfectly situated in the Centre of Waterloo's Growth District, it's designed specifically for the modern student lifestyle. Minutes away from the University of Waterloo, Wilfrid Laurier, and the Technology Park. This East facing Unit is flooded with natural light and offers a generous 800 sq. ft. of living space. Designed with a modern aesthetic and functionality in mind, features include: Layout: 2 Bedrooms and 2 Full Bathrooms with a spacious open-concept design. Finishes: High ceilings, sleek laminate flooring throughout, and granite kitchen countertops with an undermounted sink.Appliances: Stainless steel kitchen appliances and convenient in-suite laundry.Views: Massive floor-to-ceiling windows in both bedrooms, offering bright, airy vibes.Turnkey: The unit comes fully furnished, specifically curated for student life."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "499.16"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "LANDPOWER REAL ESTATE LTD."
+"CoListOfficePhone": "905-305-9669"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-20T00:00:07.319687+00:00"
+"CrossStreet": "University and Hemlock"
+"Directions": "Besides St. Michael's Roman Catholic Church"
+"ExpirationDate": "2026-08-31"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "020200"
+"MajorChangeTimestamp": "2026-03-24T17:34:44Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T17:34:44Z"
+"OriginalListPrice": 445000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3713668"
+"ParcelNumber": "236420130"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T17:34:45Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3086.08"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "502"
+"Zoning": "Residential"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12915552')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004070"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "4"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 642
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Builder"
+"PossessionDetails": "30 days/TBA"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-24T17:43:58Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-03-24T17:44:02.505361Z"
+"Media": array:7 [ …7]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4305
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12911676"
+"ListingId": "X12911676"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:50:17Z"
+"RFModificationTimestamp": "2026-04-29T03:30:41Z"
+"ListPrice": 1895000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.41
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1Z1"
+"UnparsedAddress": "370 Green Acres Drive, Waterloo, ON N2K 1Z1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5029001
+"Longitude": -80.5114107
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This is the home you have been waiting for. A rare & iconic offering in Old Colonial Acres, one of Waterloo's most prestigious & established neighbourhoods. Set on an expansive, mature, tree-lined lot of approx. acre, this timeless Tudor-style home offers 4,300+ SF of beautifully finished living space with 5 bedrms, 4 bathrms, extensive updates, exceptional privacy, & a backyard that feels like a private resort. Tucked away on a quiet court & surrounded by mature trees, this home offers a level of tranquility rarely found-true cottage-style living in the city, just mins to universities, major employers, & everyday amenities. Designed for both entertaining & everyday living, the bright & spacious layout features a grand 2-storey foyer, impressive great rm with gas FP & bay window, & a formal dining rm. The updated Country Lane kitchen is the heart of the home, complete with heated slate flrs, premium appliances, & oversized island with seating for 6, with direct backyard access for seamless indoor-outdoor living. A functional mudrm with built-ins, garage access, & a well-placed powder rm with backyard entry add convenience. The upper level offers 5 generous bedrms, highlighted by a hotel-inspired primary retreat, with custom feature wall with electric FP, sitting area, walk-in dressing rm with built-ins & laundry area, & a beautifully updated spa-like ensuite with double floating vanities & oversized glass walk-in shower. 4 additional bedrms (3 with balcony access), an updated 5-pc main bath, & 361 SF attic complete the upper level. The finished lower level adds valuable additional living space complete with a rec rm with gas FP, exercise area, games rm, & 2-pc bathrm. Outdoors, the private backyard features an inground pool, expansive patio, covered seating area, & multiple outdoor living spaces-creating a true oasis. This home blends privacy, timeless architecture, & a resort-like lifestyle just mins to universities, Conestoga Mall, parks, trails, & major routes."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-20T01:04:55.578929+00:00"
+"CrossStreet": "LEE AVENUE"
+"DirectionFaces": "North"
+"Directions": "LEE AVENUE TO GREEN ACRES DRIVE"
+"Exclusions": "Hot Tub, Basement TV."
+"ExpirationDate": "2026-08-23"
+"ExteriorFeatures": array:5 [ …5]
+"FireplaceFeatures": array:4 [ …4]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Range Hood, Refrigerator, Washer, Window Coverings, Beverage Fridge, Gas Cooktop, Wall Oven, Sonos System with the sound bar and outdoor speakers, all TV's (except basement TV)."
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-03-23T20:24:34Z"
+"MlsStatus": "Extension"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-23T20:11:08Z"
+"OriginalListPrice": 1895000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707228"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "222870243"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-23T20:11:08Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Green Acres"
+"StreetNumber": "370"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10692.06"
+"TaxAssessedValue": 783000
+"TaxLegalDescription": "LT 38 PL 1164 CITY OF WATERLOO; S/T 291782; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST (SEE REMARKS)"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://youriguide.com/aw7jt_370_green_acres_dr_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/aw7jt_370_green_acres_dr_waterloo_on/"
+"VirtualTourURLUnbranded2": "https://youtu.be/J8y OBv Mco Eo"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 147.17
+"LotWidth": 135.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12911676')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601165001000"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1Z1, CA"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "FLEXIBLE"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-03-23T20:11:08Z"
+"ExtensionEntryTimestamp": "2026-03-23T20:24:34Z"
+"SystemModificationTimestamp": "2026-03-24T13:50:29.423752Z"
+"Media": array:50 [ …50]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4302
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12910602"
+"ListingId": "X12910602"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T13:29:46Z"
+"RFModificationTimestamp": "2026-04-28T16:36:06Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E7"
+"UnparsedAddress": "181 King Street S 1602, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4604
+"Longitude": -80.5202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CORCORAN HORIZON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "An exceptional turnkey investment opportunity in one of Uptown Waterloo's most sought-after buildings. This unit offers a truly hands-off ownership experience, featuring a secure, long-term lease in place for 5+ years, ensuring stable and predictable income from day one. What distinguishes this property is its fully managed structure. The tenant-an established and reputable company-not only occupies the unit but also assumes all property management responsibilities. This comprehensive arrangement is seamlessly integrated into the monthly rental income, providing investors with a completely passive, worry-free investment. Ideal for those seeking long-term stability, minimal involvement, and consistent returns in a prime urban location, this is a rare opportunity to acquire a secure, low-maintenance asset in a high-demand market."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "745.69"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"BuildingName": "CIRCA 1877"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-26T20:13:56.692558+00:00"
+"CrossStreet": "ALLEN STREET WEST"
+"Directions": "ON THE INTERSECTION OF KING STREET SOUTH AND ALLENSTREET WEST"
+"ExpirationDate": "2026-10-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "247700"
+"MajorChangeTimestamp": "2026-03-23T17:24:05Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-23T17:24:05Z"
+"OriginalListPrice": 399900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707916"
+"ParcelNumber": "237140071"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-23T17:24:05Z"
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4535.0"
+"TaxAssessedValue": 331000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1602"
+"View": array:1 [ …1]
+"Zoning": "U2-81"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12910602')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301603120002440"
+"SurveyType": "None"
+"BalconyType": "Enclosed"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "16"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 714
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Other"
+"ParkingLevelUnit1": "A/7/1"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Agents use Broker Bay. Please allow a minimum of 48 hours' notice for all showings."
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "02"
+"MediaChangeTimestamp": "2026-03-23T17:24:05Z"
+"PropertyManagementCompany": "KING CONDO MGMT"
+"SystemModificationTimestamp": "2026-03-24T13:29:48.773636Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:29 [ …29]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4301
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12913090"
+"ListingId": "X12913090"
+"PropertyType": "Residential"
+"PropertySubType": "Co-op Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T12:34:34Z"
+"RFModificationTimestamp": "2026-04-28T16:36:07Z"
+"ListPrice": 578000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3H6"
+"UnparsedAddress": "8 Hickory Street #1002, Waterloo, ON N2L 3H6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.478204
+"Longitude": -80.5251752
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Huge Investment opportunity, monthly rent 3400 with signed agreement. 7.05% return. Stable Income, student tenants. HIGH END STUDENT LIVING - SAGE BUILT! This Stunning Condo is located within Walking Distance to UW, Laurier, Restaurants, Shopping & situated right on the LRT! This Spacious Layout is almost 1400 sqft with 3 Large bedrooms & 2 Full bathrooms, as well as In-suite Laundry. This is an extremely rare TOP FLOOR UNIT with 10 FOOT CEILINGS and a Balcony! You will love the Stunning Kitchen with Large Island & Stainless Appliances - Separate Dinette & Family room. The Unit Comes Fully furnished (3 x bedrooms, dinette, living room furniture & Big Screen TV, etc.) You will be impressed from the moment you walk up to the Buildings' Modern Exterior & Enter through the Spacious Foyer with Towering 20 ft Ceilings. Building also has fabulous bright lounge & newly renovated exercise room."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "562.63"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"BuildingName": "Sage 1"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-26T20:20:56.792082+00:00"
+"CrossStreet": "KING STREET TO HICKORY STREET"
+"Directions": "KING STREET TO HICKORY STREET"
+"Exclusions": "tenants belongings"
+"ExpirationDate": "2026-08-31"
+"Inclusions": "dishwasher, dryer, range hood, refrigerator, stove, washer"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-03-24T12:34:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T12:34:34Z"
+"OriginalListPrice": 578000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3712560"
+"ParcelNumber": "235600069"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T12:34:34Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5521.0"
+"TaxAssessedValue": 403000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "#1002"
+"Zoning": "GR"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913090')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301640423500045"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "hot water heater"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "10"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3H6, CA"
+"ApproximateAge": "11-15"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 560
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"NumberSharesPercent": "100"
+"ShowingAppointments": "tenants might be home, please knock"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-24T12:34:34Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-24T12:34:34.682405Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4300
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12912006"
+"ListingId": "X12912006"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-23T21:07:30Z"
+"RFModificationTimestamp": "2026-04-29T21:40:34Z"
+"ListPrice": 5250.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3A1"
+"UnparsedAddress": "30 Regina Street N, Waterloo, ON N2J 3A1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4669304
+"Longitude": -80.521382
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious and incredibly-located student rental in the heart of Waterloo! This 7 bed, 3 full bath home offers a functional layout, on-site laundry, and available parking - perfect for student living.Ideally situated just 800m from Wilfrid Laurier University and 2km from the University of Waterloo. Enjoy unbeatable convenience with shopping, grocery, ION Station and Waterloo Public Square just 500m away from your door!A fantastic opportunity to live in a highly connected and convenient location."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-20T01:58:46.996374+00:00"
+"CrossStreet": "Princess St / Regina St"
+"DirectionFaces": "West"
+"Directions": "Princess St / Regina St"
+"ExpirationDate": "2026-09-18"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Partially"
+"Inclusions": "furniture, stove, fridges, washer, dryer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-23T21:07:30Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-23T21:07:30Z"
+"OriginalListPrice": 5250.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3709232"
+"ParcelNumber": "223740061"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-03-31T17:54:01Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Regina"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "half months rent plus hst"
+"TransactionType": "For Lease"
+"DDFYN": true
+"HeatType": "Radiant"
+"LotDepth": 75.0
+"LotWidth": 37.5
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12912006')"
+"GarageType": "None"
+"HeatSource": "Other"
+"RollNumber": "301601335000900"
+"SurveyType": "Unknown"
+"RentalItems": "Hot water tank"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3A1, CA"
+"ContractStatus": "Available"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 3
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 6
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Square Feet"
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"RentalApplicationYN": true
+"MediaChangeTimestamp": "2026-03-31T17:54:01Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-31T17:54:01.120425Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:25 [ …25]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4299
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12896366"
+"ListingId": "X12896366"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-23T20:27:57Z"
+"RFModificationTimestamp": "2026-04-29T03:30:36Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0.5
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2A 0J8"
+"UnparsedAddress": "72 Grand Flats Trail, Waterloo, ON N2A 0J8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.452306
+"Longitude": -80.3991691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This exquisite two-story family residence, located at 72 Grand Flats Trail in Lackner Woods at Explorers, features four plus two bedrooms. The property immediately impresses with its distinguished stone pillars and inviting covered porch. Upon entering, the bright foyer and nine-foot ceilings establish an open and expansive atmosphere throughout the carpet-free main floor. This level includes a formal dining room, bathed in natural light, and a conveniently located laundry room. The kitchen is a highlight, boasting quartz countertops, stainless steel appliances, ample storage, a custom backsplash, white cabinetry with additional pantry space, and a generous quartz island with a breakfast bar.The upper level is enhanced by California shutters and a versatile landing area, ideal for a sitting room or home office. This floor comprises four spacious bedrooms, including a primary suite with a walk-in closet and a five-piece ensuite bathroom. Two additional bedrooms also benefit from walk-in closets. The fully finished basement expands the living space with two further bedrooms, a recreation room perfect for entertaining, and a fourth bathroom appointed with granite countertops.Strategically situated, this home offers exceptional accessibility to the Grand River, walking trails, Waterloo Airport, parks, and schools. Furthermore, it is merely a seven-minute drive to Highway 401, making this property a truly comprehensive offering."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T20:41:50.306908+00:00"
+"CrossStreet": "Eden Oak Trail / Fairway Rd N"
+"DirectionFaces": "North"
+"Directions": "Eden Oak Trail / Fairway Rd N"
+"Exclusions": "TV mounts in living"
+"ExpirationDate": "2026-06-04"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Etc"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-03-18T17:20:57Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-18T17:20:57Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3628966"
+"ParcelNumber": "227136214"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-18T17:20:57Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Grand Flats"
+"StreetNumber": "72"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6661.0"
+"TaxLegalDescription": "LOT 125, PLAN 58M597 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.50 % Plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://house.sf-photography-photographer.com/72-grand-flats-trail-kitchener-ontario-n2a-0j8?branded=1"
+"VirtualTourURLUnbranded": "https://house.sf-photography-photographer.com/72-grand-flats-trail-kitchener-ontario-n2a-0j8?branded=0"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 101.71
+"LotShape": "Rectangular"
+"LotWidth": 36.09
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12896366')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001707217"
+"SurveyType": "None"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2A 0J8, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-28"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:3 [ …3]
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-03-18T17:20:57Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-03-23T20:28:08.348513Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:39 [ …39]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4298
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12879958"
+"ListingId": "X12879958"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-19T20:49:13Z"
…111
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4269
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …144}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …110}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …121}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …109}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4078 …124}
]
+success: true
+page_size: 5
+page_count: 8864
+count: 44316
+after_key: ""
}
]
]
