array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=250&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=250&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=250&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=250&$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: "615867"
+post_author: 1
+"ListingKey": "X12827094"
+"ListingId": "X12827094"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-19T17:53:35Z"
+"RFModificationTimestamp": "2026-04-29T06:17:04Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H7"
+"UnparsedAddress": "258b Sunview Street 2151, Waterloo, ON N2L 0H7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4745629
+"Longitude": -80.5333202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover Unit 2151 at 258B Sunview Street - a fully furnished 2-bedroom, 1-bath residence in one of Waterloo's most in-demand rental corridors. Designed with efficiency and comfort in mind, the suite features a practical floor plan, expansive windows for natural light, a contemporary kitchen, and a combined living and dining space suited for both study and relaxation. The turn key furnishing package makes this an ideal option for investors targeting the student market or buyers seeking immediate usability. Positioned steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, and within easy reach of the ION LRT, residents benefit from seamless access across the city. Daily conveniences, including restaurants, cafés, retail, and major tech employers, are all nearby, reinforcing the property's strong rental appeal. Additional highlights include in-suite laundry, a generous private balcony that extends the living space outdoors, a terrace in the building to use and a parking lot located behind the building, where visitor and monthly rental parking are available. Currently leased at $2,600 per month until August 31, 2026, this unit presents a compelling income-generating opportunity with future end-user potential. Possession is flexible: if the buyer wants to acquire and benefit from rental income, they may do so starting May 1, 2026. If not, vacant possession is guaranteed for September 1, 2026."
+"AccessibilityFeatures": array:5 [ …5]
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "367.95"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T01:19:17.197971+00:00"
+"CrossStreet": "Sunview Street & University Avenue West"
+"Directions": "From University Ave W, head north on Sunview St. Property is located on the right-hand side."
+"ExpirationDate": "2026-08-27"
+"Inclusions": "SS Fridge, SS Stove, SS Dishwasher, Microwave, Stacked Washer/Dryer. Elfs And Window Coverings. Furniture is also included, which includes of 3 Tables, 2 Chairs, a 3 Person Sofa, 2 Double Beds and Mattresses, 2 Study Desks & Study Chairs."
+"InteriorFeatures": "Carpet Free,Separate Heating Controls,Separate Hydro Meter"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-27"
+"MainOfficeKey": "428100"
+"MajorChangeTimestamp": "2026-02-27T16:46:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-27T16:46:33Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3602554"
+"ParkingFeatures": "Other"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-19T17:44:18Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3263.31"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+ HST"
+"TransactionType": "For Sale"
+"UnitNumber": "2151"
+"View": array:2 [ …2]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12827094')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Electric"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"RentalItems": "Rental Water Heater and Heat Pump."
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "12"
+"ParkingType1": "Rental"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H7, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "Floorplan"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "9"
+"MediaChangeTimestamp": "2026-03-19T17:44:18Z"
+"PropertyManagementCompany": "Wilson Blanchard Management Inc."
+"SystemModificationTimestamp": "2026-03-19T17:53:38.598683Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:13 [ …13]
+"ID": "615867"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "705563"
+post_author: 1
+"ListingKey": "X12886798"
+"ListingId": "X12886798"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T16:43:23Z"
+"RFModificationTimestamp": "2026-04-29T06:17:38Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4T2"
+"UnparsedAddress": "30 Blue Springs Drive 706, Waterloo, ON N2J 4T2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488758
+"Longitude": -80.526054
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully maintained condominium located in a quiet and highly desirable area of North Waterloo. This spacious two-bedroom suite features southeast-facing windows overlooking Four Well Lake/pond and lush green space, offering picturesque views and an abundance of natural light throughout the day. The open-concept living and dining area is bright and inviting, with sliding doors leading to a generously sized private balcony-perfect for relaxing or enjoying the scenic surroundings. The well-appointed kitchen offers ample cabinetry and is conveniently situated beside a sun-filled breakfast area with large windows. The unit includes two generously sized bedrooms and two beautifully renovated full bathrooms, both featuring in-floor heating for added comfort. Additional highlights include in-suite laundry and laminate flooring throughout, creating a clean and modern living space. This unit comes complete with one underground parking space and an exclusive-use storage locker. Residents enjoy excellent building amenities, including a party room with kitchen, guest suite, library, bike storage, intercom-controlled entry, ample visitor parking, and a rooftop patio with gas BBQ-perfect for social gatherings and relaxation. Blue Springs is surrounded by an exceptional network of scenic walking and cycling trails, including Forwell Trail, located just steps from the building, connecting you to miles of peaceful forested paths. Ideally located close to all amenities, including the LRT, public transit, Conestoga Mall, supermarkets, restaurants, and the University of Waterloo, with quick access to major highways for convenient commuting."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "881.46"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T06:16:02.386495+00:00"
+"CrossStreet": "KING ST. N."
+"Directions": "KING ST. N. TO BLUE SPRINGS DR."
+"Exclusions": "Curtains."
+"ExpirationDate": "2026-05-15"
+"ExteriorFeatures": "Controlled Entry,Landscaped,Year Round Living,Backs On Green Belt,Privacy"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Intercom"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-03-16T15:03:40Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-16T15:03:40Z"
+"OriginalListPrice": 435000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3675158"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-16T15:03:41Z"
+"Roof": "Tar and Gravel"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2567.19"
+"TaxAssessedValue": 188000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "706"
+"View": array:8 [ …8]
+"VirtualTourURLBranded": "https://youriguide.com/706_30_blue_springs_dr_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/706_30_blue_springs_dr_waterloo_on/"
+"WaterBodyName": "Four Wells Lake"
+"Zoning": "RMU-40"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12886798')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"LockerUnit": "004"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"RentalItems": "None."
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "7"
+"LockerNumber": "105"
+"ParkingSpot1": "224"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"WaterBodyType": "Lake"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4T2, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 169
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 9
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"ParkingLevelUnit1": "UNDERGROUND"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE REMOVE SHOES, LEAVE A BUSINESS CARD, AND LOCK DOORS."
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "6"
+"MediaChangeTimestamp": "2026-03-16T15:03:41Z"
+"PropertyManagementCompany": "SANDERSON PROPERTY MANAGEMENT"
+"SystemModificationTimestamp": "2026-03-16T16:43:29.111709Z"
+"Media": array:50 [ …50]
+"ID": "705563"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "632568"
+post_author: 1
+"ListingKey": "X12878712"
+"ListingId": "X12878712"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-13T15:03:41Z"
+"RFModificationTimestamp": "2026-04-29T06:17:35Z"
+"ListPrice": 2200.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street 308h, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Unit In The Heart Of Waterloo. Few Blocks From Waterloo University & Laurier University. Walking Distance To Waterloo Ion Transit. Mins To Waterloo Downtown, Conestoga Mall And Highway. Fully Finished Approx. 670 Sq Ft. With One Master Bed, Second smaller bedroom And Two Full 3Pc Bathrooms And In-Suite Laundry. Unit Comes With Its Own Exclusive Surface Parking Spot. Building Features Game Room. Theatre Room, Business Center, Yoga Room, Fitness Room, Terrace Bbq (All Features Located In Another Building Within The Complex) Each Building's Amenities Vary But Community Members Have Access To All Amenities"
+"ArchitecturalStyle": "Apartment"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T08:41:37.631516+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-07-31"
+"Furnished": "Furnished"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-11"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-03-13T00:41:32Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-13T00:41:32Z"
+"OriginalListPrice": 2200.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3661408"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-13T15:03:41Z"
+"RentIncludes": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "308H"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12878712')"
+"ElevatorYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "3"
+"ParkingType1": "Common"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 634
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Previous Listing"
+"PossessionDetails": "TBA"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "58"
+"MediaChangeTimestamp": "2026-03-13T15:03:41Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Condo Management Corporation"
+"SystemModificationTimestamp": "2026-03-13T15:03:45.744622Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:2 [ …2]
+"ID": "632568"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "632152"
+post_author: 1
+"ListingKey": "X12853670"
+"ListingId": "X12853670"
+"PropertyType": "Residential"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-12T22:45:04Z"
+"RFModificationTimestamp": "2026-04-29T06:17:09Z"
+"ListPrice": 447900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street H404, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ALEKSIC REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stylish, Sun-Filled Condo in the Heart of the University District. Welcome to modern urban living! This bright and spacious 762 sq ft condo features 2 bedrooms and 2 full bathrooms, offering a functional layout perfect for comfortable everyday living. Ideally located in Waterloo's vibrant University District, this unit sits just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an exceptional opportunity for students, professionals, and investors alike. The condo comes fully furnished, making it a true turnkey opportunity-simply move in or start renting immediately. Enjoy unbeatable convenience with restaurants, shopping, the library, and major bus routes all within walking distance. Highlights:762 Sq Ft of bright, open living space2 spacious bedrooms 2 full bathrooms Fully furnished Prime University District location Ideal for students, professionals, investors, or first-time buyers. Don't miss this incredible opportunity to own in one of Waterloo's most desirable locations. Schedule your private viewing today!"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "397.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ALEKSIC REALTY INC."
+"CoListOfficePhone": "905-824-0221"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T09:11:13.643060+00:00"
+"CrossStreet": "Larch St /Hickory St W"
+"Directions": "Hickory/Larch"
+"ExpirationDate": "2026-07-30"
+"Inclusions": "All Appliances and Furniture Belonging to the Owner is Included in the Sale. Electrical Light Fixtures."
+"InteriorFeatures": "Carpet Free,Primary Bedroom - Main Floor"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-06"
+"MainOfficeKey": "325800"
+"MajorChangeTimestamp": "2026-03-12T22:45:04Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-06T14:54:14Z"
+"OriginalListPrice": 500000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3616046"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-06T14:54:14Z"
+"PreviousListPrice": 500000.0
+"PriceChangeTimestamp": "2026-03-12T22:45:04Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2775.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% plus H.S.T"
+"TransactionType": "For Sale"
+"UnitNumber": "H404"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12853670')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604270001436"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "04"
+"ParkingType1": "None"
+"ParkingType2": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 643
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Floor Plan"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "62"
+"MediaChangeTimestamp": "2026-03-06T14:54:14Z"
+"PropertyManagementCompany": "Sanderson Management Inc"
+"SystemModificationTimestamp": "2026-03-12T22:45:07.841448Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
+"ID": "632152"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+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"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "709101"
+post_author: 1
+"ListingKey": "X12862716"
+"ListingId": "X12862716"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-09T18:06:50Z"
+"RFModificationTimestamp": "2026-04-29T06:17:10Z"
+"ListPrice": 420000.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 806, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479755
+"Longitude": -80.526359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Located in the prestigious Circa 1877 residences in Uptown Waterloo, this spacious suite offers an exceptional opportunity in one of Canada's fastest-growing tech and education hubs. Featuring over 700 sq. ft. of interior living space plus a rare 183 sq. ft. private balcony, the unit offers a highly desirable layout with bright open-concept living and floor-to-ceiling windows.The generous balcony provides valuable outdoor space rarely found in condominium living, while the modern kitchen and living area create an ideal setup for comfortable living or strong rental appeal.Circa 1877 is known for its premium lifestyle amenities including a rooftop saltwater pool with cabanas, fitness centre, indoor and outdoor yoga studios, co-working spaces, guest suites, and an impressive sky terrace with fire tables and BBQ areas.Situated steps from the ION Light Rail and surrounded by Uptown Waterloo's restaurants, cafés, and shops, the building is also minutes from University of Waterloo and Wilfrid Laurier University. With major employers such as Google located nearby in Waterloo's thriving technology corridor, the area continues to attract strong rental demand from professionals and students alike, or great for professional end users."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "610.08"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T13:53:27.189540+00:00"
+"CrossStreet": "King and Allen"
+"Directions": "King and Allen"
+"Exclusions": "Tenant belongings"
+"ExpirationDate": "2026-06-09"
+"FireplaceYN": true
+"Inclusions": "Fridge, stove, dishwasher, washer and dryer. All ELFS"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-09"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-09T18:06:50Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-09T18:06:50Z"
+"OriginalListPrice": 420000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3478942"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-09T18:06:50Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3868.8"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0"
+"TransactionType": "For Sale"
+"UnitNumber": "806"
+"VirtualTourURLUnbranded": "https://listing.orelus.ca/181-King-St-S/idx"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862716')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot water Pump"
+"HoldoverDays": 90
+"LegalStories": "8"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 714
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 4
+"SquareFootSource": "Builder"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "12"
+"MediaChangeTimestamp": "2026-03-09T18:06:50Z"
+"PropertyManagementCompany": "King Condo Management"
+"SystemModificationTimestamp": "2026-03-09T18:06:51.042938Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:31 [ …31]
+"ID": "709101"
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
"RF Response Time" => "0.42 seconds"
]
"RF Cache Key: 7e64a3d1facb96da5fc90c62135f91ca8c63b1f5fbb58036360a079d6a505822" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3081
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4276
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12827094"
+"ListingId": "X12827094"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-19T17:53:35Z"
+"RFModificationTimestamp": "2026-04-29T06:17:04Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H7"
+"UnparsedAddress": "258b Sunview Street 2151, Waterloo, ON N2L 0H7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4745629
+"Longitude": -80.5333202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover Unit 2151 at 258B Sunview Street - a fully furnished 2-bedroom, 1-bath residence in one of Waterloo's most in-demand rental corridors. Designed with efficiency and comfort in mind, the suite features a practical floor plan, expansive windows for natural light, a contemporary kitchen, and a combined living and dining space suited for both study and relaxation. The turn key furnishing package makes this an ideal option for investors targeting the student market or buyers seeking immediate usability. Positioned steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, and within easy reach of the ION LRT, residents benefit from seamless access across the city. Daily conveniences, including restaurants, cafés, retail, and major tech employers, are all nearby, reinforcing the property's strong rental appeal. Additional highlights include in-suite laundry, a generous private balcony that extends the living space outdoors, a terrace in the building to use and a parking lot located behind the building, where visitor and monthly rental parking are available. Currently leased at $2,600 per month until August 31, 2026, this unit presents a compelling income-generating opportunity with future end-user potential. Possession is flexible: if the buyer wants to acquire and benefit from rental income, they may do so starting May 1, 2026. If not, vacant possession is guaranteed for September 1, 2026."
+"AccessibilityFeatures": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "367.95"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T01:19:17.197971+00:00"
+"CrossStreet": "Sunview Street & University Avenue West"
+"Directions": "From University Ave W, head north on Sunview St. Property is located on the right-hand side."
+"ExpirationDate": "2026-08-27"
+"Inclusions": "SS Fridge, SS Stove, SS Dishwasher, Microwave, Stacked Washer/Dryer. Elfs And Window Coverings. Furniture is also included, which includes of 3 Tables, 2 Chairs, a 3 Person Sofa, 2 Double Beds and Mattresses, 2 Study Desks & Study Chairs."
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-27"
+"MainOfficeKey": "428100"
+"MajorChangeTimestamp": "2026-02-27T16:46:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-27T16:46:33Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3602554"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-19T17:44:18Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3263.31"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+ HST"
+"TransactionType": "For Sale"
+"UnitNumber": "2151"
+"View": array:2 [ …2]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12827094')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Electric"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"RentalItems": "Rental Water Heater and Heat Pump."
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "12"
+"ParkingType1": "Rental"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H7, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "Floorplan"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "9"
+"MediaChangeTimestamp": "2026-03-19T17:44:18Z"
+"PropertyManagementCompany": "Wilson Blanchard Management Inc."
+"SystemModificationTimestamp": "2026-03-19T17:53:38.598683Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:13 [ …13]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4277
+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]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4280
+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]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4279
+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]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4278
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12886798"
+"ListingId": "X12886798"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-16T16:43:23Z"
+"RFModificationTimestamp": "2026-04-29T06:17:38Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4T2"
+"UnparsedAddress": "30 Blue Springs Drive 706, Waterloo, ON N2J 4T2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.488758
+"Longitude": -80.526054
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully maintained condominium located in a quiet and highly desirable area of North Waterloo. This spacious two-bedroom suite features southeast-facing windows overlooking Four Well Lake/pond and lush green space, offering picturesque views and an abundance of natural light throughout the day. The open-concept living and dining area is bright and inviting, with sliding doors leading to a generously sized private balcony-perfect for relaxing or enjoying the scenic surroundings. The well-appointed kitchen offers ample cabinetry and is conveniently situated beside a sun-filled breakfast area with large windows. The unit includes two generously sized bedrooms and two beautifully renovated full bathrooms, both featuring in-floor heating for added comfort. Additional highlights include in-suite laundry and laminate flooring throughout, creating a clean and modern living space. This unit comes complete with one underground parking space and an exclusive-use storage locker. Residents enjoy excellent building amenities, including a party room with kitchen, guest suite, library, bike storage, intercom-controlled entry, ample visitor parking, and a rooftop patio with gas BBQ-perfect for social gatherings and relaxation. Blue Springs is surrounded by an exceptional network of scenic walking and cycling trails, including Forwell Trail, located just steps from the building, connecting you to miles of peaceful forested paths. Ideally located close to all amenities, including the LRT, public transit, Conestoga Mall, supermarkets, restaurants, and the University of Waterloo, with quick access to major highways for convenient commuting."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "881.46"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T06:16:02.386495+00:00"
+"CrossStreet": "KING ST. N."
+"Directions": "KING ST. N. TO BLUE SPRINGS DR."
+"Exclusions": "Curtains."
+"ExpirationDate": "2026-05-15"
+"ExteriorFeatures": array:5 [ …5]
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-03-16T15:03:40Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-16T15:03:40Z"
+"OriginalListPrice": 435000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3675158"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-16T15:03:41Z"
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2567.19"
+"TaxAssessedValue": 188000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "706"
+"View": array:8 [ …8]
+"VirtualTourURLBranded": "https://youriguide.com/706_30_blue_springs_dr_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/706_30_blue_springs_dr_waterloo_on/"
+"WaterBodyName": "Four Wells Lake"
+"Zoning": "RMU-40"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12886798')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"LockerUnit": "004"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"RentalItems": "None."
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "7"
+"LockerNumber": "105"
+"ParkingSpot1": "224"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"WaterBodyType": "Lake"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4T2, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 169
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 9
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"ParkingLevelUnit1": "UNDERGROUND"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE REMOVE SHOES, LEAVE A BUSINESS CARD, AND LOCK DOORS."
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "6"
+"MediaChangeTimestamp": "2026-03-16T15:03:41Z"
+"PropertyManagementCompany": "SANDERSON PROPERTY MANAGEMENT"
+"SystemModificationTimestamp": "2026-03-16T16:43:29.111709Z"
+"Media": array:50 [ …50]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4275
+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]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4274
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12878712"
+"ListingId": "X12878712"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-13T15:03:41Z"
+"RFModificationTimestamp": "2026-04-29T06:17:35Z"
+"ListPrice": 2200.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street 308h, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Unit In The Heart Of Waterloo. Few Blocks From Waterloo University & Laurier University. Walking Distance To Waterloo Ion Transit. Mins To Waterloo Downtown, Conestoga Mall And Highway. Fully Finished Approx. 670 Sq Ft. With One Master Bed, Second smaller bedroom And Two Full 3Pc Bathrooms And In-Suite Laundry. Unit Comes With Its Own Exclusive Surface Parking Spot. Building Features Game Room. Theatre Room, Business Center, Yoga Room, Fitness Room, Terrace Bbq (All Features Located In Another Building Within The Complex) Each Building's Amenities Vary But Community Members Have Access To All Amenities"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T08:41:37.631516+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-07-31"
+"Furnished": "Furnished"
+"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-11"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-03-13T00:41:32Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-13T00:41:32Z"
+"OriginalListPrice": 2200.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3661408"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-13T15:03:41Z"
+"RentIncludes": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "308H"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12878712')"
+"ElevatorYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "3"
+"ParkingType1": "Common"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 634
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Previous Listing"
+"PossessionDetails": "TBA"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "58"
+"MediaChangeTimestamp": "2026-03-13T15:03:41Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Condo Management Corporation"
+"SystemModificationTimestamp": "2026-03-13T15:03:45.744622Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:2 [ …2]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4273
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12853670"
+"ListingId": "X12853670"
+"PropertyType": "Residential"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-12T22:45:04Z"
+"RFModificationTimestamp": "2026-04-29T06:17:09Z"
+"ListPrice": 447900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street H404, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ALEKSIC REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stylish, Sun-Filled Condo in the Heart of the University District. Welcome to modern urban living! This bright and spacious 762 sq ft condo features 2 bedrooms and 2 full bathrooms, offering a functional layout perfect for comfortable everyday living. Ideally located in Waterloo's vibrant University District, this unit sits just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an exceptional opportunity for students, professionals, and investors alike. The condo comes fully furnished, making it a true turnkey opportunity-simply move in or start renting immediately. Enjoy unbeatable convenience with restaurants, shopping, the library, and major bus routes all within walking distance. Highlights:762 Sq Ft of bright, open living space2 spacious bedrooms 2 full bathrooms Fully furnished Prime University District location Ideal for students, professionals, investors, or first-time buyers. Don't miss this incredible opportunity to own in one of Waterloo's most desirable locations. Schedule your private viewing today!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "397.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ALEKSIC REALTY INC."
+"CoListOfficePhone": "905-824-0221"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T09:11:13.643060+00:00"
+"CrossStreet": "Larch St /Hickory St W"
+"Directions": "Hickory/Larch"
+"ExpirationDate": "2026-07-30"
+"Inclusions": "All Appliances and Furniture Belonging to the Owner is Included in the Sale. Electrical Light Fixtures."
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-06"
+"MainOfficeKey": "325800"
+"MajorChangeTimestamp": "2026-03-12T22:45:04Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-06T14:54:14Z"
+"OriginalListPrice": 500000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3616046"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-06T14:54:14Z"
+"PreviousListPrice": 500000.0
+"PriceChangeTimestamp": "2026-03-12T22:45:04Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2775.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% plus H.S.T"
+"TransactionType": "For Sale"
+"UnitNumber": "H404"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12853670')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604270001436"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "04"
+"ParkingType1": "None"
+"ParkingType2": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 643
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Floor Plan"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "62"
+"MediaChangeTimestamp": "2026-03-06T14:54:14Z"
+"PropertyManagementCompany": "Sanderson Management Inc"
+"SystemModificationTimestamp": "2026-03-12T22:45:07.841448Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4272
+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"
+"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": array:2 [ …2]
+"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": 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": "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]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4271
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12862716"
+"ListingId": "X12862716"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-09T18:06:50Z"
+"RFModificationTimestamp": "2026-04-29T06:17:10Z"
+"ListPrice": 420000.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 806, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479755
+"Longitude": -80.526359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Located in the prestigious Circa 1877 residences in Uptown Waterloo, this spacious suite offers an exceptional opportunity in one of Canada's fastest-growing tech and education hubs. Featuring over 700 sq. ft. of interior living space plus a rare 183 sq. ft. private balcony, the unit offers a highly desirable layout with bright open-concept living and floor-to-ceiling windows.The generous balcony provides valuable outdoor space rarely found in condominium living, while the modern kitchen and living area create an ideal setup for comfortable living or strong rental appeal.Circa 1877 is known for its premium lifestyle amenities including a rooftop saltwater pool with cabanas, fitness centre, indoor and outdoor yoga studios, co-working spaces, guest suites, and an impressive sky terrace with fire tables and BBQ areas.Situated steps from the ION Light Rail and surrounded by Uptown Waterloo's restaurants, cafés, and shops, the building is also minutes from University of Waterloo and Wilfrid Laurier University. With major employers such as Google located nearby in Waterloo's thriving technology corridor, the area continues to attract strong rental demand from professionals and students alike, or great for professional end users."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "610.08"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T13:53:27.189540+00:00"
+"CrossStreet": "King and Allen"
+"Directions": "King and Allen"
+"Exclusions": "Tenant belongings"
+"ExpirationDate": "2026-06-09"
+"FireplaceYN": true
+"Inclusions": "Fridge, stove, dishwasher, washer and dryer. All ELFS"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-09"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-09T18:06:50Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-09T18:06:50Z"
+"OriginalListPrice": 420000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3478942"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-09T18:06:50Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3868.8"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0"
+"TransactionType": "For Sale"
+"UnitNumber": "806"
+"VirtualTourURLUnbranded": "https://listing.orelus.ca/181-King-St-S/idx"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12862716')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot water Pump"
+"HoldoverDays": 90
+"LegalStories": "8"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
…19
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4242
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073 …110}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …121}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …109}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …124}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …131}
]
+success: true
+page_size: 5
+page_count: 8864
+count: 44317
+after_key: ""
}
]
]
