array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=220&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=220&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=220&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=220&$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: "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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "619276"
+post_author: 1
+"ListingKey": "X12845890"
+"ListingId": "X12845890"
+"PropertyType": "Residential"
+"PropertySubType": "Duplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T22:47:03Z"
+"RFModificationTimestamp": "2026-04-28T18:20:18Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1X6"
+"UnparsedAddress": "255 Normandy Avenue, Waterloo, ON N2K 1X6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4957011
+"Longitude": -80.5128403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Royal City Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "| Colonial Acres Multigenerational Home with Legal Accessory Suite & Heated Saltwater Pool | Located in Waterloo's highly sought-after Colonial Acres neighbourhood, this beautifully designed multigenerational home with legal accessory suite offers exceptional flexibility for extended family living or rental income. Built in 2013 and offering nearly 3,000 sq ft above grade, the main home features an open-concept kitchen with breakfast bar, coffee station and pantry, a dining area with soaring ceilings, spacious living room with gas fireplace, family room or flex space, separate office, and convenient main floor laundry. Upstairs you'll find three spacious bedrooms including a primary retreat with walk-in closet and spa-like 5-piece ensuite. The fully finished legal accessory apartment features its own kitchen, living and dining areas, bedroom, bathroom, ensuite laundry, and a private walk-up entrance, while still allowing for multiple options to re-establish interior access from the main floor should a future owner wish to integrate the space. Step outside to a private, landscaped backyard oasis featuring a heated in-ground saltwater pool, patio, gas bbq hookup, gazebo, and plenty of space to entertain. Energy-conscious buyers will appreciate the 24 panel solar system generating approximately 8600k Wh annually, significantly offsetting the home's energy consumption, two separate heat pumps (one per unit), and fire and sound separation insulation between units. Situated on a generous 66 x 171 ft lot with double garage, and parking for six vehicles, this is a rare opportunity to own a versatile family home in one of Waterloo's most established and desirable communities."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:5 [ …5]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air,Wall Unit(s)"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-27T05:28:34.082601+00:00"
+"CrossStreet": "Lexington/Anndale"
+"DirectionFaces": "South"
+"Directions": "Lexington > Anndale > Normandy"
+"Exclusions": "freezer in garage, Eufy camera system (5 mounted cameras on exterior of house), mounted TVs but mounts staying"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": "Deck,Landscape Lighting,Landscaped,Patio,Porch"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "PRIMARY SUITE - LG fridge, stove, dishwasher, washer, dryer, wall mount kitchen fan. Ecobee thermostat. All existing pool equipment (cover, skimmer, vacuum, pump, filter). Pergola and chiminea, solar lighting on pergola and shed, outdoor cushion storage box, small shed at rear of property near fence, bike rack and ski rack in garage. AUXILIARY SUITE - Whirlpool fridge, stove, dishwasher, range hood microwave, GE stacked washer/dryer. Wardrobe in hallway, and wardrobe in bedroom."
+"InteriorFeatures": "Accessory Apartment,Auto Garage Door Remote,ERV/HRV,Separate Heating Controls,Storage,Sump Pump,Upgraded Insulation,Water Heater Owned,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "558500"
+"MajorChangeTimestamp": "2026-03-04T20:17:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-04T20:17:48Z"
+"OriginalListPrice": 1699999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3622276"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222870481"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-14T16:21:48Z"
+"PoolFeatures": "Salt,Inground"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Normandy"
+"StreetNumber": "255"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10344.0"
+"TaxAssessedValue": 755000
+"TaxLegalDescription": "PT LT 94 PL 921 CITY OF WATERLOO PT 5, 58R1553; S/T 176235; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% of purchase price plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/255_normandy_ave_waterloo_on"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/255_normandy_ave_waterloo_on"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 171.26
+"LotWidth": 66.8
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12845890')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601285001400"
+"SurveyType": "Unknown"
+"RentalItems": "solar PV system - to be paid out by Seller before closing"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 2
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1X6, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 14
+"RoomsBelowGrade": 7
+"SalesBrochureUrl": "https://royalcity.com/listing/X12845890"
+"EnergyCertificate": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "2 hour notice for showings"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-16T22:47:03Z"
+"SystemModificationTimestamp": "2026-03-16T22:47:16.060674Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
+"ID": "619276"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2846
+post_id: "620315"
+post_author: 1
+"ListingKey": "X12847034"
+"ListingId": "X12847034"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T22:45:53Z"
+"RFModificationTimestamp": "2026-04-28T18:20:18Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1X6"
+"UnparsedAddress": "255 Normandy Avenue, Waterloo, ON N2K 1X6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4957011
+"Longitude": -80.5128403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Royal City Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "| Colonial Acres Multigenerational Home with Legal Accessory Suite & Heated Saltwater Pool | Located in Waterloo's highly sought-after Colonial Acres neighbourhood, this beautifully designed multigenerational home with legal accessory suite offers exceptional flexibility for extended family living or rental income. Built in 2013 and offering nearly 3,000 sq ft above grade, the main home features an open-concept kitchen with breakfast bar, coffee station and pantry, a dining area with soaring ceilings, spacious living room with gas fireplace, family room or flex space, separate office, and convenient main floor laundry. Upstairs you'll find three spacious bedrooms including a primary retreat with walk-in closet and spa-like 5-piece ensuite. The fully finished legal accessory apartment features its own kitchen, living and dining areas, bedroom, bathroom, ensuite laundry, and a private walk-up entrance, while still allowing for multiple options to re-establish interior access from the main floor should a future owner wish to integrate the space. Step outside to a private, landscaped backyard oasis featuring a heated in-ground saltwater pool, patio, gas bbq hookup, gazebo, and plenty of space to entertain. Energy-conscious buyers will appreciate the 24 panel solar system generating approximately 8600k Wh annually, significantly offsetting the home's energy consumption, two separate heat pumps (one per unit), and fire and sound separation insulation between units. Situated on a generous 66 x 171 ft lot with double garage and parking for six vehicles, this is a rare opportunity to own a versatile family home in one of Waterloo's most established and desirable communities."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:5 [ …5]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air,Wall Unit(s)"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-27T05:29:04.154106+00:00"
+"CrossStreet": "Lexington/Anndale"
+"DirectionFaces": "South"
+"Directions": "Lexington>Anndale>Normandy"
+"Exclusions": "freezer in garage, Eufy camera system (5 mounted cameras on exterior of house), mounted TVs but mounts staying"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": "Deck,Landscape Lighting,Landscaped,Patio,Porch"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "PRIMARY SUITE - LG fridge, stove, dishwasher, washer, dryer, wall mount kitchen fan. Ecobee thermostat. All existing pool equipment (cover,skimmer, vacuum, pump, filter). Pergola and chiminea, solar lighting on pergola and shed, outdoor cushion storage box, small shed at rear ofproperty near fence, bike rack and ski rack in garage. AUXILIARY SUITE - Whirlpool fridge, stove, dishwasher, range hood microwave, GE stackedwasher/dryer. Wardrobe in hallway, and wardrobe in bedroom."
+"InteriorFeatures": "Accessory Apartment,Auto Garage Door Remote,ERV/HRV,Separate Heating Controls,Storage,Sump Pump,Upgraded Insulation,Water Heater Owned,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "558500"
+"MajorChangeTimestamp": "2026-03-05T02:35:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-05T02:35:48Z"
+"OriginalListPrice": 1699999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3628932"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222870481"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-05T02:35:48Z"
+"PoolFeatures": "Salt,Inground"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Normandy"
+"StreetNumber": "255"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10344.0"
+"TaxLegalDescription": "PT LT 94 PL 921 CITY OF WATERLOO PT 5, 58R1553; S/T 176235; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/255_normandy_ave_waterloo_on"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/255_normandy_ave_waterloo_on"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 171.26
+"LotWidth": 66.8
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12847034')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601285001400"
+"SurveyType": "Unknown"
+"RentalItems": "solar PV system - to be paid out by Seller before closing"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 2
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1X6, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 14
+"RoomsBelowGrade": 7
+"PropertyFeatures": array:4 [ …4]
+"EnergyCertificate": true
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-16T22:45:54Z"
+"SystemModificationTimestamp": "2026-03-16T22:46:06.877947Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "620315"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "708677"
+post_author: 1
+"ListingKey": "X12888548"
+"ListingId": "X12888548"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Duplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T19:21:21Z"
+"RFModificationTimestamp": "2026-04-28T18:20:40Z"
+"ListPrice": 1875.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4T3"
+"UnparsedAddress": "197a Cedarvale Crescent B, Waterloo, ON N2L 4T3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488568
+"Longitude": -80.548007
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "$1000 MOVE-IN CREDIT! UTILITIES INCLUDED! Nestled in one of Waterloo's most desirable neighbourhoods, this meticulously maintained lower level unit features three spacious bedrooms, a three piece bathroom, and a welcoming living room with a kitchen and dining area. The unit offers convenient amenities including in unit laundry and central air conditioning, providing comfort and practicality for everyday living. One designated parking space is included, and rent covers essential utilities including heat, hydro, and water, creating a truly hassle free living experience. Ideally located just minutes from shopping centres, restaurants, Wilfrid Laurier University, the University of Waterloo, Conestoga College's Waterloo campus, St. Jacobs Farmers' Market, and Highway 85, this property offers an excellent balance of comfort and convenience."
+"ArchitecturalStyle": "Apartment"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T05:48:58.264404+00:00"
+"CrossStreet": "Cedarbrae Ave"
+"DirectionFaces": "South"
+"Directions": "Cedarbrae Ave & Cedarvale Cres"
+"ExpirationDate": "2026-05-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "355000"
+"MajorChangeTimestamp": "2026-03-16T19:21:21Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-16T19:21:21Z"
+"OriginalListPrice": 1875.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3677886"
+"ParcelNumber": "222680059"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-03-16T19:21:21Z"
+"PoolFeatures": "None"
+"RentIncludes": array:5 [ …5]
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Cedarvale"
+"StreetNumber": "197A"
+"StreetSuffix": "Crescent"
+"TransactionBrokerCompensation": "Half of One Month's Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "B"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12888548')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "30160410002401"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Other"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4T3, CA"
+"ContractStatus": "Available"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "May 1 or after"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "24 hours notice"
+"WashroomsType1Level": "Main"
+"MediaChangeTimestamp": "2026-03-16T19:21:21Z"
+"PortionLeaseComments": "Basement Apartment"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-16T19:21:21.778689Z"
+"Media": array:8 [ …8]
+"ID": "708677"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "638803"
+post_author: 1
+"ListingKey": "X12885550"
+"ListingId": "X12885550"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T11:17:20Z"
+"RFModificationTimestamp": "2026-04-28T18:20:38Z"
+"ListPrice": 805.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2T2"
+"UnparsedAddress": "16 Marshall Street B, Waterloo, ON N2J 2T2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.473061
+"Longitude": -80.523139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "4 BEDROOMS AVAILABLE AT $805 PER ROOM! Highly Desired location just steps from Wilfrid Laurier University! This rear unit offers quality student living with modern updates. Unit B features 4 spacious bedrooms and 2 full bathrooms, with bright living and dining areas highlighted by large windows and tiled flooring throughout. The property has been well maintained with updated plumbing, electrical, ductwork, and foam insulation, and includes air conditioning for added comfort. The bathrooms are nicely finished and the unit offers a shared kitchen and living area, making it ideal for student living. This home also features two separate entrances at the side and rear of the property, along with two parking spaces. Rooms are available for rent on a room-by-room basis at $805 per room, with three rooms available immediately and one room available at the end of April."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"CoListOfficeName": "e Xp Realty"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T06:54:25.795564+00:00"
+"CrossStreet": "King St N & Marshall St"
+"DirectionFaces": "South"
+"Directions": "King St N to Marshall St"
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"Inclusions": "Dryer, Microwave, Refrigerator, Stove, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-16"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-16T11:17:20Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-16T11:17:20Z"
+"OriginalListPrice": 805.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3674534"
+"ParcelNumber": "223680041"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-03-16T11:17:20Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [ …1]
+"Roof": "Asphalt Shingle"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Marshall"
+"StreetNumber": "16"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month Rent+HST"
+"TransactionType": "For Lease"
+"UnitNumber": "B"
+"DDFYN": true
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotWidth": 42.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12885550')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601240000800"
+"SurveyType": "None"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2T2, CA"
+"ApproximateAge": "100+"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 3
+"RoomsBelowGrade": 3
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"RentalApplicationYN": true
+"ShowingAppointments": "Please book all showings via Brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-03-16T11:17:20Z"
+"PortionLeaseComments": "$805 Per Room"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-16T11:17:21.426595Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [ …24]
+"ID": "638803"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "613484"
+post_author: 1
+"ListingKey": "X12829140"
+"ListingId": "X12829140"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-11T14:54:26Z"
+"RFModificationTimestamp": "2026-04-28T18:20:15Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3Y7"
+"UnparsedAddress": "7 Cardill Crescent, Waterloo, ON N2L 3Y7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4810844
+"Longitude": -80.5353894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Turn-Key Legal Duplex !!, Investor's dream in the heart of Waterloo! This fully renovated 7-bedroom, 2-bathroom legal duplex sits on a massive 53.67 ft x 153.87 ft lot, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Thousands have been recently spent on top-to-bottom renovations including two kitchens, upgraded bathrooms, flooring, lighting, and more. Each unit is thoughtfully designed, making it move-in ready and ideal for rentals or multi-generational living. With the rental potential of more than $5,500/month , this is a turn-key investment with strong cash flow from day one. Builders and developers-take a note! The oversized lot holds massive potential for future development. The neighboring property at 5 Cardill Crescent has already been successfully converted into a multiplex, demonstrating what's possible here. Whether you're looking to invest, house-hack, or redevelop, this property offers the perfect blend of location, income, and long-term potential. An outstanding opportunity to build multi-generational wealth in one of Waterloo's most desirable rental corridors."
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T11:32:08.016880+00:00"
+"CrossStreet": "Albert St. and Columbia St. W"
+"DirectionFaces": "West"
+"Directions": "Albert St. and Columbia St. W"
+"Exclusions": "Tenant Items"
+"ExpirationDate": "2026-06-05"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "2 SS Stove, 2 SS Fridge, 2 Washer & Drier, SS B/I Dish Washer, All ELF's, AC & Furnace"
+"InteriorFeatures": "Carpet Free,In-Law Suite"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-27"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-02-28T01:00:53Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-28T01:00:53Z"
+"OriginalListPrice": 799000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3605588"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-02-28T01:00:54Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Cardill"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6349.69"
+"TaxLegalDescription": "LT 44 PL 1144 CITY OF WATERLOO; S/T 278254; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% - $ 50 mkt fee + HST"
+"TransactionType": "For Sale"
+"View": array:1 [ …1]
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 153.87
+"LotWidth": 53.67
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12829140')"
+"GarageType": "Carport"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 5
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3Y7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 7
+"PropertyFeatures": array:2 [ …2]
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 3
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-02-28T01:00:54Z"
+"SystemModificationTimestamp": "2026-03-11T14:54:33.663829Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:37 [ …37]
+"ID": "613484"
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
"RF Response Time" => "0.43 seconds"
]
"RF Cache Key: 4d2ad5ff5f05a20206b56a16900b2465472942ed4e2e5eb5bda9b7355ca9ff73" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3107
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4293
+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]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4294
+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]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4297
+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]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4296
+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]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4295
+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]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4292
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12845890"
+"ListingId": "X12845890"
+"PropertyType": "Residential"
+"PropertySubType": "Duplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T22:47:03Z"
+"RFModificationTimestamp": "2026-04-28T18:20:18Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1X6"
+"UnparsedAddress": "255 Normandy Avenue, Waterloo, ON N2K 1X6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4957011
+"Longitude": -80.5128403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Royal City Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "| Colonial Acres Multigenerational Home with Legal Accessory Suite & Heated Saltwater Pool | Located in Waterloo's highly sought-after Colonial Acres neighbourhood, this beautifully designed multigenerational home with legal accessory suite offers exceptional flexibility for extended family living or rental income. Built in 2013 and offering nearly 3,000 sq ft above grade, the main home features an open-concept kitchen with breakfast bar, coffee station and pantry, a dining area with soaring ceilings, spacious living room with gas fireplace, family room or flex space, separate office, and convenient main floor laundry. Upstairs you'll find three spacious bedrooms including a primary retreat with walk-in closet and spa-like 5-piece ensuite. The fully finished legal accessory apartment features its own kitchen, living and dining areas, bedroom, bathroom, ensuite laundry, and a private walk-up entrance, while still allowing for multiple options to re-establish interior access from the main floor should a future owner wish to integrate the space. Step outside to a private, landscaped backyard oasis featuring a heated in-ground saltwater pool, patio, gas bbq hookup, gazebo, and plenty of space to entertain. Energy-conscious buyers will appreciate the 24 panel solar system generating approximately 8600k Wh annually, significantly offsetting the home's energy consumption, two separate heat pumps (one per unit), and fire and sound separation insulation between units. Situated on a generous 66 x 171 ft lot with double garage, and parking for six vehicles, this is a rare opportunity to own a versatile family home in one of Waterloo's most established and desirable communities."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:5 [ …5]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:2 [ …2]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-27T05:28:34.082601+00:00"
+"CrossStreet": "Lexington/Anndale"
+"DirectionFaces": "South"
+"Directions": "Lexington > Anndale > Normandy"
+"Exclusions": "freezer in garage, Eufy camera system (5 mounted cameras on exterior of house), mounted TVs but mounts staying"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": array:5 [ …5]
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "PRIMARY SUITE - LG fridge, stove, dishwasher, washer, dryer, wall mount kitchen fan. Ecobee thermostat. All existing pool equipment (cover, skimmer, vacuum, pump, filter). Pergola and chiminea, solar lighting on pergola and shed, outdoor cushion storage box, small shed at rear of property near fence, bike rack and ski rack in garage. AUXILIARY SUITE - Whirlpool fridge, stove, dishwasher, range hood microwave, GE stacked washer/dryer. Wardrobe in hallway, and wardrobe in bedroom."
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "558500"
+"MajorChangeTimestamp": "2026-03-04T20:17:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-04T20:17:48Z"
+"OriginalListPrice": 1699999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3622276"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222870481"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-14T16:21:48Z"
+"PoolFeatures": array:2 [ …2]
+"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": "Normandy"
+"StreetNumber": "255"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10344.0"
+"TaxAssessedValue": 755000
+"TaxLegalDescription": "PT LT 94 PL 921 CITY OF WATERLOO PT 5, 58R1553; S/T 176235; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% of purchase price plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/255_normandy_ave_waterloo_on"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/255_normandy_ave_waterloo_on"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 171.26
+"LotWidth": 66.8
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12845890')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601285001400"
+"SurveyType": "Unknown"
+"RentalItems": "solar PV system - to be paid out by Seller before closing"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 2
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1X6, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 14
+"RoomsBelowGrade": 7
+"SalesBrochureUrl": "https://royalcity.com/listing/X12845890"
+"EnergyCertificate": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "2 hour notice for showings"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-16T22:47:03Z"
+"SystemModificationTimestamp": "2026-03-16T22:47:16.060674Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12847034"
+"ListingId": "X12847034"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T22:45:53Z"
+"RFModificationTimestamp": "2026-04-28T18:20:18Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 1X6"
+"UnparsedAddress": "255 Normandy Avenue, Waterloo, ON N2K 1X6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4957011
+"Longitude": -80.5128403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Royal City Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "| Colonial Acres Multigenerational Home with Legal Accessory Suite & Heated Saltwater Pool | Located in Waterloo's highly sought-after Colonial Acres neighbourhood, this beautifully designed multigenerational home with legal accessory suite offers exceptional flexibility for extended family living or rental income. Built in 2013 and offering nearly 3,000 sq ft above grade, the main home features an open-concept kitchen with breakfast bar, coffee station and pantry, a dining area with soaring ceilings, spacious living room with gas fireplace, family room or flex space, separate office, and convenient main floor laundry. Upstairs you'll find three spacious bedrooms including a primary retreat with walk-in closet and spa-like 5-piece ensuite. The fully finished legal accessory apartment features its own kitchen, living and dining areas, bedroom, bathroom, ensuite laundry, and a private walk-up entrance, while still allowing for multiple options to re-establish interior access from the main floor should a future owner wish to integrate the space. Step outside to a private, landscaped backyard oasis featuring a heated in-ground saltwater pool, patio, gas bbq hookup, gazebo, and plenty of space to entertain. Energy-conscious buyers will appreciate the 24 panel solar system generating approximately 8600k Wh annually, significantly offsetting the home's energy consumption, two separate heat pumps (one per unit), and fire and sound separation insulation between units. Situated on a generous 66 x 171 ft lot with double garage and parking for six vehicles, this is a rare opportunity to own a versatile family home in one of Waterloo's most established and desirable communities."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:5 [ …5]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:2 [ …2]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-27T05:29:04.154106+00:00"
+"CrossStreet": "Lexington/Anndale"
+"DirectionFaces": "South"
+"Directions": "Lexington>Anndale>Normandy"
+"Exclusions": "freezer in garage, Eufy camera system (5 mounted cameras on exterior of house), mounted TVs but mounts staying"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": array:5 [ …5]
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "PRIMARY SUITE - LG fridge, stove, dishwasher, washer, dryer, wall mount kitchen fan. Ecobee thermostat. All existing pool equipment (cover,skimmer, vacuum, pump, filter). Pergola and chiminea, solar lighting on pergola and shed, outdoor cushion storage box, small shed at rear ofproperty near fence, bike rack and ski rack in garage. AUXILIARY SUITE - Whirlpool fridge, stove, dishwasher, range hood microwave, GE stackedwasher/dryer. Wardrobe in hallway, and wardrobe in bedroom."
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "558500"
+"MajorChangeTimestamp": "2026-03-05T02:35:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-05T02:35:48Z"
+"OriginalListPrice": 1699999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3628932"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222870481"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2026-03-05T02:35:48Z"
+"PoolFeatures": array:2 [ …2]
+"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": "Normandy"
+"StreetNumber": "255"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10344.0"
+"TaxLegalDescription": "PT LT 94 PL 921 CITY OF WATERLOO PT 5, 58R1553; S/T 176235; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/255_normandy_ave_waterloo_on"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/255_normandy_ave_waterloo_on"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 171.26
+"LotWidth": 66.8
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12847034')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601285001400"
+"SurveyType": "Unknown"
+"RentalItems": "solar PV system - to be paid out by Seller before closing"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 2
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 1X6, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 14
+"RoomsBelowGrade": 7
+"PropertyFeatures": array:4 [ …4]
+"EnergyCertificate": true
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-16T22:45:54Z"
+"SystemModificationTimestamp": "2026-03-16T22:46:06.877947Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12888548"
+"ListingId": "X12888548"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Duplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T19:21:21Z"
+"RFModificationTimestamp": "2026-04-28T18:20:40Z"
+"ListPrice": 1875.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4T3"
+"UnparsedAddress": "197a Cedarvale Crescent B, Waterloo, ON N2L 4T3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488568
+"Longitude": -80.548007
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "$1000 MOVE-IN CREDIT! UTILITIES INCLUDED! Nestled in one of Waterloo's most desirable neighbourhoods, this meticulously maintained lower level unit features three spacious bedrooms, a three piece bathroom, and a welcoming living room with a kitchen and dining area. The unit offers convenient amenities including in unit laundry and central air conditioning, providing comfort and practicality for everyday living. One designated parking space is included, and rent covers essential utilities including heat, hydro, and water, creating a truly hassle free living experience. Ideally located just minutes from shopping centres, restaurants, Wilfrid Laurier University, the University of Waterloo, Conestoga College's Waterloo campus, St. Jacobs Farmers' Market, and Highway 85, this property offers an excellent balance of comfort and convenience."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T05:48:58.264404+00:00"
+"CrossStreet": "Cedarbrae Ave"
+"DirectionFaces": "South"
+"Directions": "Cedarbrae Ave & Cedarvale Cres"
+"ExpirationDate": "2026-05-31"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "355000"
+"MajorChangeTimestamp": "2026-03-16T19:21:21Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-16T19:21:21Z"
+"OriginalListPrice": 1875.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3677886"
+"ParcelNumber": "222680059"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-03-16T19:21:21Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:5 [ …5]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Cedarvale"
+"StreetNumber": "197A"
+"StreetSuffix": "Crescent"
+"TransactionBrokerCompensation": "Half of One Month's Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "B"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12888548')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "30160410002401"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Other"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4T3, CA"
+"ContractStatus": "Available"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 7
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "May 1 or after"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "24 hours notice"
+"WashroomsType1Level": "Main"
+"MediaChangeTimestamp": "2026-03-16T19:21:21Z"
+"PortionLeaseComments": "Basement Apartment"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-16T19:21:21.778689Z"
+"Media": array:8 [ …8]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4289
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12885550"
+"ListingId": "X12885550"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T11:17:20Z"
+"RFModificationTimestamp": "2026-04-28T18:20:38Z"
+"ListPrice": 805.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2T2"
+"UnparsedAddress": "16 Marshall Street B, Waterloo, ON N2J 2T2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.473061
+"Longitude": -80.523139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "4 BEDROOMS AVAILABLE AT $805 PER ROOM! Highly Desired location just steps from Wilfrid Laurier University! This rear unit offers quality student living with modern updates. Unit B features 4 spacious bedrooms and 2 full bathrooms, with bright living and dining areas highlighted by large windows and tiled flooring throughout. The property has been well maintained with updated plumbing, electrical, ductwork, and foam insulation, and includes air conditioning for added comfort. The bathrooms are nicely finished and the unit offers a shared kitchen and living area, making it ideal for student living. This home also features two separate entrances at the side and rear of the property, along with two parking spaces. Rooms are available for rent on a room-by-room basis at $805 per room, with three rooms available immediately and one room available at the end of April."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CoListOfficeName": "e Xp Realty"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T06:54:25.795564+00:00"
+"CrossStreet": "King St N & Marshall St"
+"DirectionFaces": "South"
+"Directions": "King St N to Marshall St"
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"Inclusions": "Dryer, Microwave, Refrigerator, Stove, Washer"
+"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-16"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-16T11:17:20Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-16T11:17:20Z"
+"OriginalListPrice": 805.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3674534"
+"ParcelNumber": "223680041"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-03-16T11:17:20Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Marshall"
+"StreetNumber": "16"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month Rent+HST"
+"TransactionType": "For Lease"
+"UnitNumber": "B"
+"DDFYN": true
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotWidth": 42.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12885550')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601240000800"
+"SurveyType": "None"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2T2, CA"
+"ApproximateAge": "100+"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 3
+"RoomsBelowGrade": 3
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"RentalApplicationYN": true
+"ShowingAppointments": "Please book all showings via Brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-03-16T11:17:20Z"
+"PortionLeaseComments": "$805 Per Room"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2026-03-16T11:17:21.426595Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [ …24]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4288
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12829140"
+"ListingId": "X12829140"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-11T14:54:26Z"
+"RFModificationTimestamp": "2026-04-28T18:20:15Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3Y7"
+"UnparsedAddress": "7 Cardill Crescent, Waterloo, ON N2L 3Y7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4810844
+"Longitude": -80.5353894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Turn-Key Legal Duplex !!, Investor's dream in the heart of Waterloo! This fully renovated 7-bedroom, 2-bathroom legal duplex sits on a massive 53.67 ft x 153.87 ft lot, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Thousands have been recently spent on top-to-bottom renovations including two kitchens, upgraded bathrooms, flooring, lighting, and more. Each unit is thoughtfully designed, making it move-in ready and ideal for rentals or multi-generational living. With the rental potential of more than $5,500/month , this is a turn-key investment with strong cash flow from day one. Builders and developers-take a note! The oversized lot holds massive potential for future development. The neighboring property at 5 Cardill Crescent has already been successfully converted into a multiplex, demonstrating what's possible here. Whether you're looking to invest, house-hack, or redevelop, this property offers the perfect blend of location, income, and long-term potential. An outstanding opportunity to build multi-generational wealth in one of Waterloo's most desirable rental corridors."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
…81
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4281
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4067 …120}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4068 …138}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4069 …122}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4070 …125}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4091 …134}
]
+success: true
+page_size: 5
+page_count: 8226
+count: 41129
+after_key: ""
}
]
]
