array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=230&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=230&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=230&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=230&$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: "688992"
+post_author: 1
+"ListingKey": "X12926372"
+"ListingId": "X12926372"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T20:40:58Z"
+"RFModificationTimestamp": "2026-04-30T05:00:54Z"
+"ListPrice": 299999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H9"
+"UnparsedAddress": "308 Lester Street 317, Waterloo, ON N2L 0H9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4762523
+"Longitude": -80.536151
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "IQI GLOBAL REAL ESTATE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize the chance to own this modern and impeccably maintained condo. Located in a highly sought-after area, this property is only minutes away from the University of Waterloo, Wilfrid Laurier University, GO Transit, and the new LRT, offering unparalleled convenience for students and professionals. This stylish condo features a contemporary design with high-end finishes, including a stainless-steel stove, microwave and recently upgraded dishwasher as well as the convenience of ensuite laundry. All lights have been upgraded to LEDs with an upgraded light fixture in the washroom. Internet is also included. Its prime location and modern amenities make it an attractive option for both residents and investors. Lock box for easy showings."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "266.56"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T05:51:08.997383+00:00"
+"CrossStreet": "University/Philip Street"
+"Directions": "University/Philip Street"
+"ExpirationDate": "2026-09-26"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-26"
+"MainOfficeKey": "314700"
+"MajorChangeTimestamp": "2026-03-26T20:40:58Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-26T20:40:58Z"
+"OriginalListPrice": 299999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3728274"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T20:40:58Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2411.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5"
+"TransactionType": "For Sale"
+"UnitNumber": "317"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12926372')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Enclosed"
+"HoldoverDays": 90
+"LegalStories": "3"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H9, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-02"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 663
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"SquareFootSource": "Builder"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "317"
+"MediaChangeTimestamp": "2026-04-16T17:24:48Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-16T17:24:48.070145Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
+"ID": "688992"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "695092"
+post_author: 1
+"ListingKey": "X12912726"
+"ListingId": "X12912726"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T19:56:40Z"
+"RFModificationTimestamp": "2026-04-30T05:00:46Z"
+"ListPrice": 335000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W7"
+"UnparsedAddress": "308 Lester Street 516, Waterloo, ON N2L 3W7"
+"Coordinates": array:2 [ …2]
+"Latitude": 42.5181529
+"Longitude": -92.3309047
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/GTA REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Amazing Investment Opportunity OR Great for the end users. That Offers Luxurious And Prestigious Living. Six Year Old Fully Furnished 1 Bed Room/1 Bath With One Parking In A Newer Development Situated In A Very Desirable Area In Waterloo, Steps To Waterloo And Winfred Laurie Universities. You Can Assume The Existing Tenant @ $1600.00/Month Or Vacant Property, Furniture Included."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "446.97"
+"AssociationFeeIncludes": array:5 [ …5]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"CoListOfficeName": "HOMELIFE/GTA REALTY INC."
+"CoListOfficePhone": "416-321-6969"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T19:27:17.977658+00:00"
+"CrossStreet": "Lester And Columbia"
+"Directions": "Lester And Columbia"
+"ExpirationDate": "2026-09-30"
+"HeatingYN": true
+"Inclusions": "Stainless Steel Refrigerator, Microwave, Built-In Dishwasher, Front Load Stacked Washer & Dryer, Electric Cook Top & Oven All Existing Furniture."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "042700"
+"MajorChangeTimestamp": "2026-03-24T03:24:13Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T03:24:13Z"
+"OriginalListPrice": 335000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3712552"
+"ParkingFeatures": "Private"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T03:24:14Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "4"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2635.47"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% Plus HST"
+"TransactionType": "For Sale"
+"UnitNumber": "516"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12912726')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "5"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-09-01"
+"PossessionType": "90+ days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 663
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2026-03-26T19:56:41Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-26T19:56:44.350888Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
+"ID": "695092"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "610267"
+post_author: 1
+"ListingKey": "X12803056"
+"ListingId": "X12803056"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T18:12:08Z"
+"RFModificationTimestamp": "2026-04-30T05:00:30Z"
+"ListPrice": 379000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H6"
+"UnparsedAddress": "258a Sunview Street 162, Waterloo, ON N2L 0H6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4740834
+"Longitude": -80.5330278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PROPERTY ZONE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this bright and beautifully designed two-bedroom condominium located at 258A Sunview Street, positioned on the 6th floor with a modern, open-concept layout. The spacious living and dining area extends to a large private balcony, offering open views of University Avenue and nearby green spaces, ideal for everyday living.This well-maintained unit is situated in an exceptional, highly walkable location, just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an excellent option for homeowners, professionals, and investors alike. Enjoy convenient access to ION LRT, GO Transit, and a wide range of nearby shops, restaurants, and amenities.Additional features include in-suite laundry, secure fob entry, and a functional layout designed for comfortable condo living. A fantastic opportunity to own in one of Waterloo's most sought-after neighborhoods."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "361.36"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-26T17:11:07.820568+00:00"
+"CrossStreet": "Sunview St / University Ave"
+"Directions": "Sunview St / University Ave"
+"ExpirationDate": "2026-09-30"
+"Inclusions": "S/S Fridge, S/S Microwave Oven, S/S Dishwasher, Stacked Washer and Dryer, Curtains and All Existing Light Fixtures (ELFs)."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-18"
+"MainOfficeKey": "420400"
+"MajorChangeTimestamp": "2026-03-26T18:12:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-19T19:08:08Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3572734"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-02-19T19:08:09Z"
+"PreviousListPrice": 399000.0
+"PriceChangeTimestamp": "2026-03-26T18:12:08Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3003.11"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "162"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12803056')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "5"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Owner"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-02-19T19:08:09Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-03-26T18:12:12.397445Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
+"ID": "610267"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "600144"
+post_author: 1
+"ListingKey": "X12795602"
+"ListingId": "X12795602"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T17:00:46Z"
+"RFModificationTimestamp": "2026-04-30T05:00:30Z"
+"ListPrice": 789000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4Y1"
+"UnparsedAddress": "591 Dogwood Lane, Waterloo, ON N2L 4Y1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4867967
+"Longitude": -80.5608818
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Dogwood Lane! This Bungalow is on a Family Oriented, Quiet Street. Living & Dining Room has Hardwood Floors and Natural Lighting. Kitchen Features Ceramic Floors, Quartz Countertop and Backsplash. Primary Bedroom has Parquet Floors and Closet. 2nd & 3rd Bedrooms Have parquet floors and closets & separate laundry on main floor. 2022 Renovated 2 bedroom basement features separate entrance & separate laundry, Vinyl Floors, pot lighs and fireplace making it the perfect place to watch movies with the family. Bathroom features ceramic floors, vanity, and gorgeous claw foot soaker tub. The large backyard is the perfect place for entertaining and is beautifully landscaped. A/C Heat Pump Aug 2023, tankless water heater Aug 2023, furnace aug 2023, roof insultation Aug 2023, Water purifier June 2023, water filter June 2023, leaffilter aug 2023, Clsoe to 401, schools, shopping, walking distance to university of waterloo. Nothing to do here but move in and enjoy!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T19:50:16.594610+00:00"
+"CrossStreet": "Bearinger Road / Toll Gate/Dogwood"
+"DirectionFaces": "East"
+"Directions": "Bearinger Road / Toll Gate/Dogwood"
+"ExpirationDate": "2026-05-17"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Stove, 2 microwave, range hood, dishwasher, 2 fridge, washer & dryer."
+"InteriorFeatures": "Auto Garage Door Remote,Water Heater,Water Purifier"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2026-02-17T22:09:25Z"
+"MlsStatus": "New"
+"OccupantType": "Owner+Tenant"
+"OriginalEntryTimestamp": "2026-02-17T22:09:25Z"
+"OriginalListPrice": 789000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3562346"
+"ParcelNumber": "222650274"
+"ParkingFeatures": "Available"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-02-18T18:11:50Z"
+"PoolFeatures": "None"
+"Roof": "Shingles"
+"SecurityFeatures": array:2 [ …2]
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316.0"
+"TaxLegalDescription": "Lt 156 Pl 1328 City of Waterloo; S/T 451862; Waterloo"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"WaterSource": array:1 [ …1]
+"Zoning": "Residential"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"CableYNA": "No"
+"HeatType": "Forced Air"
+"LotDepth": 114.0
+"LotWidth": 45.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12795602')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604142503500"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"ElectricYNA": "Yes"
+"RentalItems": "Water heater, water purifier & water filter."
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:3 [ …3]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4Y1, CA"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "TAC"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Acres"
+"PossessionDetails": "60-90 Days"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-02-18T18:11:50Z"
+"SystemModificationTimestamp": "2026-03-26T17:00:52.406629Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:37 [ …37]
+"ID": "600144"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "651976"
+post_author: 1
+"ListingKey": "X12923900"
+"ListingId": "X12923900"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T15:04:45Z"
+"RFModificationTimestamp": "2026-04-30T05:00:51Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 0B7"
+"UnparsedAddress": "435 Winchester Drive 10, Waterloo, ON N2T 0B7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ICI SOURCE REAL ASSET SERVICES INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully appointed two storey townhouse in desirable Beechwood Village West. Three bedrooms, three bathrooms, fully finished basement with numerous add-ons and extras that make this home a must see. Extras and add-ons include: -- Redesigned Kitchen with built in wall oven & microwave, large island and electric stovetop.- Built in TV entertainment and shelving Unit.- Specialist Window blinds and drapes.- Hardwood Floors on main and second floors.- Upgraded lighting fixtures in dining room and open foyer.- Upgraded ceiling fans in master and second bedrooms.- Upgraded walk-in closets in master and main 2nd bedroom.- Retractable awning on back patio.- Upgraded high efficiency furnace.- Finished basement with bedroom and full bathroom.- Reverse osmosis water system.- Soft water system.- Exterior patio gas line for BBQ. *For Additional Property Details Click The Brochure Icon Below*"
+"ArchitecturalStyle": "2-Storey"
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "581.2"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T17:27:27.240050+00:00"
+"CrossStreet": "Fisher Hallman Dr. & Erb St."
+"Directions": "Go past Erb St on Fisher Hallman Rd. Turn next left into Winchester Dr until you come to Beechwood Village West. Use 2nd entrance. Unit 10 is next to the first visitors car park."
+"ExpirationDate": "2026-05-27"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "All blinds and drapes.All kitchen Appliances.All laundry appliances. Soft water system. Reverse Osmosis System.Heater & Ac Systems.All ceiling lighting"
+"InteriorFeatures": "Built-In Oven,Carpet Free,Countertop Range,Primary Bedroom - Main Floor,Water Softener,Water Treatment"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-26"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "209900"
+"MajorChangeTimestamp": "2026-03-26T15:00:39Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-26T15:00:39Z"
+"OriginalListPrice": 1150000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3714546"
+"ParcelNumber": "235610046"
+"ParkingFeatures": "Surface"
+"ParkingTotal": "4.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T15:00:40Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7578.68"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% Paid Directly By Seller. $0.01 By Brokerage"
+"TransactionType": "For Sale"
+"UnitNumber": "10"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12923900')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604494000415"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"ParkingType2": "Exclusive"
+"SoundBiteUrl": "https://listedbyseller-listings.ca/435-winchester-drive-unit-10-waterloo-on-landing/"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 0B7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"WashroomsType3": 1
+"CondoCorpNumber": 561
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1800-1999"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 4
+"SalesBrochureUrl": "https://listedbyseller-listings.ca/435-winchester-drive-unit-10-waterloo-on-landing/"
+"SquareFootSource": "MPAC"
+"PossessionDetails": "After 7th June 2026"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "46"
+"MediaChangeTimestamp": "2026-03-26T15:00:40Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-26T15:04:52.731248Z"
+"Media": array:22 [ …22]
+"ID": "651976"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "650832"
+post_author: 1
+"ListingKey": "X12916976"
+"ListingId": "X12916976"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T21:10:18Z"
+"RFModificationTimestamp": "2026-04-29T07:59:44Z"
+"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 2126, Waterloo, ON N2L 0H7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4745629
+"Longitude": -80.5333202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Great investment opportunity. Sunview suites in the heart of Waterloo. Just minutes from Wilfrid Laurier University and the university of Waterloo. ION LRT station steps from Sunview suites. This modern luxury condo will surely impress investors and first-time buyers. This is your chance to get this special condo before it's too late"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "329.19"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T21:07:05.714700+00:00"
+"CrossStreet": "Sunview st and University Ave"
+"Directions": "Sunview st and University Ave"
+"ExpirationDate": "2026-12-31"
+"Inclusions": "Dishwasher, Dryer, Furniture, Refrigerator, Stove, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-03-24T21:58:30Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T21:58:30Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3705364"
+"ParcelNumber": "301604435"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-25T21:10:18Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3099.74"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5 % -50 Marketing Fee + hst"
+"TransactionType": "For Sale"
+"UnitNumber": "2126"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Heat Pump"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12916976')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301604435004450"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "11"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:2 [ …2]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "12"
+"MediaChangeTimestamp": "2026-03-25T21:10:18Z"
+"PropertyManagementCompany": "Wilson Blanchard Mgmnt"
+"SystemModificationTimestamp": "2026-03-25T21:10:21.037129Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
+"ID": "650832"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "693317"
+post_author: 1
+"ListingKey": "X12920550"
+"ListingId": "X12920550"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T18:26:48Z"
+"RFModificationTimestamp": "2026-04-29T08:00:05Z"
+"ListPrice": 1749.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.391
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1Y6"
+"UnparsedAddress": "11 Devitt Avenue S 201, Waterloo, ON N2J 1Y6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4669353
+"Longitude": -80.5138378
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious 2-Bedroom Apartment for Rent in Prime Waterloo Location! Welcome to 11 Devitt Ave South - A bright, large unit located in a quiet, well-established neighbourhood. This unit offers comfortable living with ample space, making it ideal for professionals, couples, or small families. This building is steps to public transit with easy access to major bus routes and the ION Light Rail, and is minutes from Conestoga Mall. Nearby you'll find grocery stores, cafes, restaurants, parks, trails, and recreational spaces. Convenient access to the University of Waterloo & Laurier University. Don't miss this opportunity!"
+"ArchitecturalStyle": "3-Storey"
+"Basement": array:1 [ …1]
+"BuildingName": "11 Devitt South"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Window Unit(s)"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T09:56:38.728873+00:00"
+"CrossStreet": "Allen St. East/Erb St. E"
+"Directions": "Allen St. East to Devitt Ave South"
+"ExpirationDate": "2026-06-25"
+"ExteriorFeatures": "Controlled Entry"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-25"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-25T18:24:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-25T18:24:55Z"
+"OriginalListPrice": 1749.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3721614"
+"ParcelNumber": "224130037"
+"ParkingFeatures": "Reserved/Assigned"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-25T18:26:48Z"
+"RentIncludes": array:7 [ …7]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Devitt"
+"StreetNumber": "11"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "1/2 months rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "201"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South East"
+"HeatType": "Baseboard"
+"LotShape": "Rectangular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920550')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301602045001400"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"LegalStories": "2"
+"ParkingType1": "Exclusive"
+"CreditCheckYN": true
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 1Y6, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2026-04-15"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Acres"
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "owner"
+"PossessionDetails": "0-30"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Book via brokerbay"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-03-25T18:26:48Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "EIWO Canadian Management Ltd."
+"SystemModificationTimestamp": "2026-03-25T18:26:52.257005Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
+"ID": "693317"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "708849"
+post_author: 1
+"ListingKey": "X12920376"
+"ListingId": "X12920376"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T17:59:54Z"
+"RFModificationTimestamp": "2026-04-29T03:30:48Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2Y1"
+"UnparsedAddress": "504 Wood Nettle Way, Waterloo, ON N2V 2Y1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4721159
+"Longitude": -80.6035943
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome home to this spacious detached 2 storey home in the highly sought after area of Waterloo with its top-rated schools. Over 3,700 square feet of living space makes this a perfect home for the large or growing family. With a double car garage & double car driveway, parking is a breeze. Upon entering, you're welcomed by an inviting ambiance created by the spacious layout & 9-foot ceilings on the main floor. This home is carpet free featuring a mix of hardwood, ceramic & laminate flooring & was recently painted on the first & second floors. The kitchen boasts ample cupboard space with granite countertops & stainless steel appliances. The formal dining room & large family room with gas fireplace is perfect for gatherings with family & friends. The main floor includes the convenience of a laundry room & a 2-piece bathroom. A wooden staircase leads to the second floor, where you'll find 4 spacious bedrooms plus an office, ideal for those working from home. The primary bedroom includes a walk-in closet & a ensuite bathroom with double sinks, a separate tub & shower. The secondary bedrooms are all spacious & share a 5 piece bathroom. The recently finished lower level offers a large rec room perfect for family games or movie nights. For those looking for a possible in law set up there is a secondary kitchen complete with stainless steel appliances. There are also 2 additional bedrooms (making up to 6 bedrooms for the entire home) & a 3-piece bathroom. A good sized storage room, cold cellar & a washer & dryer hookup completes this level. The fenced backyard features a stamped concrete patio with gazebo, perfect for relaxing with family & friends. Additional features of this home include central air conditioning & water softener. Located in a AAA location, this home is close to top-rated schools, Laurel Creek Conservation Area, parks, walking trails, universities (U of W & WLU), YMCA, library and more, schedule your private showing today"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T18:01:40.126505+00:00"
+"CrossStreet": "laurelwood"
+"DirectionFaces": "North"
+"Directions": "laurelwood to wood nettle"
+"ExpirationDate": "2026-06-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "In-Law Capability"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-25"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-03-25T17:59:54Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-25T17:59:54Z"
+"OriginalListPrice": 1199900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3716800"
+"ParcelNumber": "226843724"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-25T17:59:54Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wood Nettle"
+"StreetNumber": "504"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "7537.69"
+"TaxAssessedValue": 552000
+"TaxLegalDescription": "LOT 68, PLAN 58M376, CITY OF WATERLOO. S/T EASEMENT IN GROSS OVER PT. 111 PL 58R15114 AS IN WR169659.S/T EASEMENT IN GROSS AS IN WR169801, OVER PT 111, 58R15114"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/504_wood_nettle_way_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.28
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920376')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000119436"
+"SurveyType": "None"
+"RentalItems": "none"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2Y1, CA"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 15
+"LotSizeAreaUnits": "Square Feet"
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 6
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-25T17:59:54Z"
+"SystemModificationTimestamp": "2026-03-25T17:59:54.980926Z"
+"Media": array:43 [ …43]
+"ID": "708849"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "695345"
+post_author: 1
+"ListingKey": "X12913138"
+"ListingId": "X12913138"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T20:24:42Z"
+"RFModificationTimestamp": "2026-04-28T21:08:43Z"
+"ListPrice": 299999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 607, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to urban sophistication at its finest! This stunning 1 bedroom, 1 bathroom condo nestled in the heart of Waterloo is walking distance to University of Waterloo and Wilfred Laurier University. The unit offers the epitome of modern living combined with convenience and comfort. As you step inside, you'll be greeted with floor-to-ceiling windows, which flood the space with natural light. The layout seamlessly integrates the living, dining, and kitchen areas, perfect for both relaxing evenings and entertaining guests. One of the highlights of this condo is the in-suite laundry, ensuring convenience and efficiency in your daily routine. The unit comes fully equipped with granite counter tops, stainless steel appliances, as well as existing furniture, including a full bed frame with mattress, a sofa, a coffee table, a built-in study table with shelves, an office chair, a dining table with four chairs, and a TV with TV console. Move-in ready, this condo offers a hassle-free transition. Moreover, residents of this building are granted access to an array of amenities designed to enhance their lifestyle. Keep up with your fitness goals in the exercise room, host memorable gatherings in the party room, or unwind and soak in panoramic views from the rooftop deck/garden and visitor parking for your guests. This condo presents an exceptional opportunity for investors as well as end-users. Book a showing today and experience everything that has to offer. - Property has been virtually staged."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "393.24"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T23:18:21.015896+00:00"
+"CrossStreet": "University Avenue to Hemlock Street."
+"Directions": "University Avenue to Hemlock Street."
+"Exclusions": "ALL TENANTS BELONGINGS"
+"ExpirationDate": "2026-08-31"
+"ExteriorFeatures": "Controlled Entry"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, full bed frame with mattress, a sofa, a coffee table, a built-in study table with shelves, an office chair, a dining table with four chairs, and a TV with TV console"
+"InteriorFeatures": "Separate Heating Controls"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-24T12:46:58Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T12:46:58Z"
+"OriginalListPrice": 299999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3682830"
+"ParcelNumber": "236790150"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T12:46:58Z"
+"Roof": "Other"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2594.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "607"
+"VirtualTourURLBranded": "https://youtu.be/J85SMIOnf Xk?si=X4x KIa9f3L8b Xufi"
+"VirtualTourURLBranded2": "https://youriguide.com/607_257_hemlock_st_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/607_257_hemlock_st_waterloo_on/"
+"Zoning": "NMU6"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913138')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004270"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "6"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"MortgageComment": "Seller To Discharge"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "Iguide"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lock box on rear of the building attached to the A/C unit. lockbox has a mail stamp on the side to distinguish easily. 24 HOUR NOTICE PRIOR TO SHOWINGS. TENANT MAY BE PRESENT FOR SHOWINGS. Leave card, shut off lights and lock doors when complete."
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "7"
+"MediaChangeTimestamp": "2026-03-24T12:46:58Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-24T20:24:44.9529Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:22 [ …22]
+"ID": "695345"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "629505"
+post_author: 1
+"ListingKey": "X12870416"
+"ListingId": "X12870416"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:54:32Z"
+"RFModificationTimestamp": "2026-04-28T21:08:29Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street F411, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL STAR REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Excellent Location Step Away From Laurier University. Very Close To Waterloo University. Very Neat & Clean. 2 Bedroom, 2 Washroom Condo Apartment. Kitchen Has Marble Counter Top. Very Large Vanities. It's A Furnished Condo Unit With TV, 2 Beds, 2 Matterss, Dining Table With 4 Chairs, Sofas. Wi-Fi Building, All 5 Appliances Included. Open Concept And Washer & Dryer Inside Condo Unit. Open Wide Balcony. Finishes With Plank Laminate Wood Floor. Must Must See The Unit For Future Investment Or For Own Use You Will Not Be Disappointed."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "429.84"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ROYAL STAR REALTY INC."
+"CoListOfficePhone": "905-793-1111"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T23:25:28.443311+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-07-10"
+"Inclusions": "All Appliances: Fridge, Stove, Washer & Dryer, Dishwasher, TV, Mattress, Sofas, Dining Table With Chairs, Bed Sets For Both Room, 2 Small Laptop Table Comes With 2 Chairs, Range Hood Fan In Kitchen. All Included, Fully Furnished Condo Apartment."
+"InteriorFeatures": "Brick & Beam,Built-In Oven,Carpet Free,Countertop Range,In-Law Suite,Intercom,Ventilation System"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-11"
+"MainOfficeKey": "159800"
+"MajorChangeTimestamp": "2026-03-24T19:54:32Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-11T14:28:11Z"
+"OriginalListPrice": 445000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3651482"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-11T14:28:11Z"
+"PreviousListPrice": 445000.0
+"PriceChangeTimestamp": "2026-03-24T19:54:32Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2976.85"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.50%"
+"TransactionType": "For Sale"
+"UnitNumber": "F411"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12870416')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301604270001276"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 30
+"LegalStories": "4"
+"ParkingType1": "Rental"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 634
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Owner"
+"PossessionDetails": "Immediately"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-03-11T14:28:11Z"
+"PropertyManagementCompany": "Condo Management Corporation"
+"SystemModificationTimestamp": "2026-03-24T19:54:36.171466Z"
+"Media": array:25 [ …25]
+"ID": "629505"
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
"RF Response Time" => "0.37 seconds"
]
"RF Cache Key: 0620b5ddaf823d6cd8e33b86c1fd710d2e8ed4f6f6247a05acfbe509fa400e53" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3078
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4281
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12926372"
+"ListingId": "X12926372"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T20:40:58Z"
+"RFModificationTimestamp": "2026-04-30T05:00:54Z"
+"ListPrice": 299999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H9"
+"UnparsedAddress": "308 Lester Street 317, Waterloo, ON N2L 0H9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4762523
+"Longitude": -80.536151
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "IQI GLOBAL REAL ESTATE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize the chance to own this modern and impeccably maintained condo. Located in a highly sought-after area, this property is only minutes away from the University of Waterloo, Wilfrid Laurier University, GO Transit, and the new LRT, offering unparalleled convenience for students and professionals. This stylish condo features a contemporary design with high-end finishes, including a stainless-steel stove, microwave and recently upgraded dishwasher as well as the convenience of ensuite laundry. All lights have been upgraded to LEDs with an upgraded light fixture in the washroom. Internet is also included. Its prime location and modern amenities make it an attractive option for both residents and investors. Lock box for easy showings."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "266.56"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T05:51:08.997383+00:00"
+"CrossStreet": "University/Philip Street"
+"Directions": "University/Philip Street"
+"ExpirationDate": "2026-09-26"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-26"
+"MainOfficeKey": "314700"
+"MajorChangeTimestamp": "2026-03-26T20:40:58Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-26T20:40:58Z"
+"OriginalListPrice": 299999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3728274"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T20:40:58Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2411.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5"
+"TransactionType": "For Sale"
+"UnitNumber": "317"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12926372')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Enclosed"
+"HoldoverDays": 90
+"LegalStories": "3"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H9, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-02"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 663
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"SquareFootSource": "Builder"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "317"
+"MediaChangeTimestamp": "2026-04-16T17:24:48Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-16T17:24:48.070145Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4282
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12912726"
+"ListingId": "X12912726"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T19:56:40Z"
+"RFModificationTimestamp": "2026-04-30T05:00:46Z"
+"ListPrice": 335000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W7"
+"UnparsedAddress": "308 Lester Street 516, Waterloo, ON N2L 3W7"
+"Coordinates": array:2 [ …2]
+"Latitude": 42.5181529
+"Longitude": -92.3309047
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/GTA REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Amazing Investment Opportunity OR Great for the end users. That Offers Luxurious And Prestigious Living. Six Year Old Fully Furnished 1 Bed Room/1 Bath With One Parking In A Newer Development Situated In A Very Desirable Area In Waterloo, Steps To Waterloo And Winfred Laurie Universities. You Can Assume The Existing Tenant @ $1600.00/Month Or Vacant Property, Furniture Included."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "446.97"
+"AssociationFeeIncludes": array:5 [ …5]
+"AssociationYN": true
+"Basement": array:1 [ …1]
+"CoListOfficeName": "HOMELIFE/GTA REALTY INC."
+"CoListOfficePhone": "416-321-6969"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T19:27:17.977658+00:00"
+"CrossStreet": "Lester And Columbia"
+"Directions": "Lester And Columbia"
+"ExpirationDate": "2026-09-30"
+"HeatingYN": true
+"Inclusions": "Stainless Steel Refrigerator, Microwave, Built-In Dishwasher, Front Load Stacked Washer & Dryer, Electric Cook Top & Oven All Existing Furniture."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-23"
+"MainOfficeKey": "042700"
+"MajorChangeTimestamp": "2026-03-24T03:24:13Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T03:24:13Z"
+"OriginalListPrice": 335000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3712552"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T03:24:14Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "4"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "308"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2635.47"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% Plus HST"
+"TransactionType": "For Sale"
+"UnitNumber": "516"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12912726')"
+"PictureYN": true
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "5"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-09-01"
+"PossessionType": "90+ days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 663
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2026-03-26T19:56:41Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-03-26T19:56:44.350888Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4285
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12803056"
+"ListingId": "X12803056"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T18:12:08Z"
+"RFModificationTimestamp": "2026-04-30T05:00:30Z"
+"ListPrice": 379000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H6"
+"UnparsedAddress": "258a Sunview Street 162, Waterloo, ON N2L 0H6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4740834
+"Longitude": -80.5330278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PROPERTY ZONE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this bright and beautifully designed two-bedroom condominium located at 258A Sunview Street, positioned on the 6th floor with a modern, open-concept layout. The spacious living and dining area extends to a large private balcony, offering open views of University Avenue and nearby green spaces, ideal for everyday living.This well-maintained unit is situated in an exceptional, highly walkable location, just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an excellent option for homeowners, professionals, and investors alike. Enjoy convenient access to ION LRT, GO Transit, and a wide range of nearby shops, restaurants, and amenities.Additional features include in-suite laundry, secure fob entry, and a functional layout designed for comfortable condo living. A fantastic opportunity to own in one of Waterloo's most sought-after neighborhoods."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "361.36"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-26T17:11:07.820568+00:00"
+"CrossStreet": "Sunview St / University Ave"
+"Directions": "Sunview St / University Ave"
+"ExpirationDate": "2026-09-30"
+"Inclusions": "S/S Fridge, S/S Microwave Oven, S/S Dishwasher, Stacked Washer and Dryer, Curtains and All Existing Light Fixtures (ELFs)."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-18"
+"MainOfficeKey": "420400"
+"MajorChangeTimestamp": "2026-03-26T18:12:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-19T19:08:08Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3572734"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-02-19T19:08:09Z"
+"PreviousListPrice": 399000.0
+"PriceChangeTimestamp": "2026-03-26T18:12:08Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3003.11"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "162"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12803056')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "5"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Owner"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-02-19T19:08:09Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-03-26T18:12:12.397445Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4284
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12795602"
+"ListingId": "X12795602"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T17:00:46Z"
+"RFModificationTimestamp": "2026-04-30T05:00:30Z"
+"ListPrice": 789000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4Y1"
+"UnparsedAddress": "591 Dogwood Lane, Waterloo, ON N2L 4Y1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4867967
+"Longitude": -80.5608818
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Dogwood Lane! This Bungalow is on a Family Oriented, Quiet Street. Living & Dining Room has Hardwood Floors and Natural Lighting. Kitchen Features Ceramic Floors, Quartz Countertop and Backsplash. Primary Bedroom has Parquet Floors and Closet. 2nd & 3rd Bedrooms Have parquet floors and closets & separate laundry on main floor. 2022 Renovated 2 bedroom basement features separate entrance & separate laundry, Vinyl Floors, pot lighs and fireplace making it the perfect place to watch movies with the family. Bathroom features ceramic floors, vanity, and gorgeous claw foot soaker tub. The large backyard is the perfect place for entertaining and is beautifully landscaped. A/C Heat Pump Aug 2023, tankless water heater Aug 2023, furnace aug 2023, roof insultation Aug 2023, Water purifier June 2023, water filter June 2023, leaffilter aug 2023, Clsoe to 401, schools, shopping, walking distance to university of waterloo. Nothing to do here but move in and enjoy!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T19:50:16.594610+00:00"
+"CrossStreet": "Bearinger Road / Toll Gate/Dogwood"
+"DirectionFaces": "East"
+"Directions": "Bearinger Road / Toll Gate/Dogwood"
+"ExpirationDate": "2026-05-17"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Stove, 2 microwave, range hood, dishwasher, 2 fridge, washer & dryer."
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2026-02-17T22:09:25Z"
+"MlsStatus": "New"
+"OccupantType": "Owner+Tenant"
+"OriginalEntryTimestamp": "2026-02-17T22:09:25Z"
+"OriginalListPrice": 789000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3562346"
+"ParcelNumber": "222650274"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-02-18T18:11:50Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316.0"
+"TaxLegalDescription": "Lt 156 Pl 1328 City of Waterloo; S/T 451862; Waterloo"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"WaterSource": array:1 [ …1]
+"Zoning": "Residential"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"CableYNA": "No"
+"HeatType": "Forced Air"
+"LotDepth": 114.0
+"LotWidth": 45.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12795602')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604142503500"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"ElectricYNA": "Yes"
+"RentalItems": "Water heater, water purifier & water filter."
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:3 [ …3]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4Y1, CA"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "TAC"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Acres"
+"PossessionDetails": "60-90 Days"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-02-18T18:11:50Z"
+"SystemModificationTimestamp": "2026-03-26T17:00:52.406629Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:37 [ …37]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4283
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12923900"
+"ListingId": "X12923900"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-26T15:04:45Z"
+"RFModificationTimestamp": "2026-04-30T05:00:51Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 0B7"
+"UnparsedAddress": "435 Winchester Drive 10, Waterloo, ON N2T 0B7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ICI SOURCE REAL ASSET SERVICES INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully appointed two storey townhouse in desirable Beechwood Village West. Three bedrooms, three bathrooms, fully finished basement with numerous add-ons and extras that make this home a must see. Extras and add-ons include: -- Redesigned Kitchen with built in wall oven & microwave, large island and electric stovetop.- Built in TV entertainment and shelving Unit.- Specialist Window blinds and drapes.- Hardwood Floors on main and second floors.- Upgraded lighting fixtures in dining room and open foyer.- Upgraded ceiling fans in master and second bedrooms.- Upgraded walk-in closets in master and main 2nd bedroom.- Retractable awning on back patio.- Upgraded high efficiency furnace.- Finished basement with bedroom and full bathroom.- Reverse osmosis water system.- Soft water system.- Exterior patio gas line for BBQ. *For Additional Property Details Click The Brochure Icon Below*"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "581.2"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T17:27:27.240050+00:00"
+"CrossStreet": "Fisher Hallman Dr. & Erb St."
+"Directions": "Go past Erb St on Fisher Hallman Rd. Turn next left into Winchester Dr until you come to Beechwood Village West. Use 2nd entrance. Unit 10 is next to the first visitors car park."
+"ExpirationDate": "2026-05-27"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "All blinds and drapes.All kitchen Appliances.All laundry appliances. Soft water system. Reverse Osmosis System.Heater & Ac Systems.All ceiling lighting"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-26"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "209900"
+"MajorChangeTimestamp": "2026-03-26T15:00:39Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-26T15:00:39Z"
+"OriginalListPrice": 1150000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3714546"
+"ParcelNumber": "235610046"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T15:00:40Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7578.68"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% Paid Directly By Seller. $0.01 By Brokerage"
+"TransactionType": "For Sale"
+"UnitNumber": "10"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12923900')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604494000415"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"ParkingType2": "Exclusive"
+"SoundBiteUrl": "https://listedbyseller-listings.ca/435-winchester-drive-unit-10-waterloo-on-landing/"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 0B7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"WashroomsType3": 1
+"CondoCorpNumber": 561
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1800-1999"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 4
+"SalesBrochureUrl": "https://listedbyseller-listings.ca/435-winchester-drive-unit-10-waterloo-on-landing/"
+"SquareFootSource": "MPAC"
+"PossessionDetails": "After 7th June 2026"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "46"
+"MediaChangeTimestamp": "2026-03-26T15:00:40Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-26T15:04:52.731248Z"
+"Media": array:22 [ …22]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4280
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12916976"
+"ListingId": "X12916976"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T21:10:18Z"
+"RFModificationTimestamp": "2026-04-29T07:59:44Z"
+"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 2126, Waterloo, ON N2L 0H7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4745629
+"Longitude": -80.5333202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Great investment opportunity. Sunview suites in the heart of Waterloo. Just minutes from Wilfrid Laurier University and the university of Waterloo. ION LRT station steps from Sunview suites. This modern luxury condo will surely impress investors and first-time buyers. This is your chance to get this special condo before it's too late"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "329.19"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T21:07:05.714700+00:00"
+"CrossStreet": "Sunview st and University Ave"
+"Directions": "Sunview st and University Ave"
+"ExpirationDate": "2026-12-31"
+"Inclusions": "Dishwasher, Dryer, Furniture, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-03-24T21:58:30Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T21:58:30Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3705364"
+"ParcelNumber": "301604435"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-25T21:10:18Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3099.74"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5 % -50 Marketing Fee + hst"
+"TransactionType": "For Sale"
+"UnitNumber": "2126"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Heat Pump"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12916976')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301604435004450"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "11"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H7, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"HeatSourceMulti": array:2 [ …2]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "12"
+"MediaChangeTimestamp": "2026-03-25T21:10:18Z"
+"PropertyManagementCompany": "Wilson Blanchard Mgmnt"
+"SystemModificationTimestamp": "2026-03-25T21:10:21.037129Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4279
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12920550"
+"ListingId": "X12920550"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T18:26:48Z"
+"RFModificationTimestamp": "2026-04-29T08:00:05Z"
+"ListPrice": 1749.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.391
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1Y6"
+"UnparsedAddress": "11 Devitt Avenue S 201, Waterloo, ON N2J 1Y6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4669353
+"Longitude": -80.5138378
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious 2-Bedroom Apartment for Rent in Prime Waterloo Location! Welcome to 11 Devitt Ave South - A bright, large unit located in a quiet, well-established neighbourhood. This unit offers comfortable living with ample space, making it ideal for professionals, couples, or small families. This building is steps to public transit with easy access to major bus routes and the ION Light Rail, and is minutes from Conestoga Mall. Nearby you'll find grocery stores, cafes, restaurants, parks, trails, and recreational spaces. Convenient access to the University of Waterloo & Laurier University. Don't miss this opportunity!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"BuildingName": "11 Devitt South"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T09:56:38.728873+00:00"
+"CrossStreet": "Allen St. East/Erb St. E"
+"Directions": "Allen St. East to Devitt Ave South"
+"ExpirationDate": "2026-06-25"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"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-25"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2026-03-25T18:24:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-25T18:24:55Z"
+"OriginalListPrice": 1749.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3721614"
+"ParcelNumber": "224130037"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-25T18:26:48Z"
+"RentIncludes": array:7 [ …7]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Devitt"
+"StreetNumber": "11"
+"StreetSuffix": "Avenue"
+"TransactionBrokerCompensation": "1/2 months rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "201"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South East"
+"HeatType": "Baseboard"
+"LotShape": "Rectangular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920550')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301602045001400"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"LegalStories": "2"
+"ParkingType1": "Exclusive"
+"CreditCheckYN": true
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 1Y6, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2026-04-15"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"LotSizeAreaUnits": "Acres"
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "owner"
+"PossessionDetails": "0-30"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Book via brokerbay"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-03-25T18:26:48Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "EIWO Canadian Management Ltd."
+"SystemModificationTimestamp": "2026-03-25T18:26:52.257005Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4278
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12920376"
+"ListingId": "X12920376"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-25T17:59:54Z"
+"RFModificationTimestamp": "2026-04-29T03:30:48Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 2Y1"
+"UnparsedAddress": "504 Wood Nettle Way, Waterloo, ON N2V 2Y1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4721159
+"Longitude": -80.6035943
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome home to this spacious detached 2 storey home in the highly sought after area of Waterloo with its top-rated schools. Over 3,700 square feet of living space makes this a perfect home for the large or growing family. With a double car garage & double car driveway, parking is a breeze. Upon entering, you're welcomed by an inviting ambiance created by the spacious layout & 9-foot ceilings on the main floor. This home is carpet free featuring a mix of hardwood, ceramic & laminate flooring & was recently painted on the first & second floors. The kitchen boasts ample cupboard space with granite countertops & stainless steel appliances. The formal dining room & large family room with gas fireplace is perfect for gatherings with family & friends. The main floor includes the convenience of a laundry room & a 2-piece bathroom. A wooden staircase leads to the second floor, where you'll find 4 spacious bedrooms plus an office, ideal for those working from home. The primary bedroom includes a walk-in closet & a ensuite bathroom with double sinks, a separate tub & shower. The secondary bedrooms are all spacious & share a 5 piece bathroom. The recently finished lower level offers a large rec room perfect for family games or movie nights. For those looking for a possible in law set up there is a secondary kitchen complete with stainless steel appliances. There are also 2 additional bedrooms (making up to 6 bedrooms for the entire home) & a 3-piece bathroom. A good sized storage room, cold cellar & a washer & dryer hookup completes this level. The fenced backyard features a stamped concrete patio with gazebo, perfect for relaxing with family & friends. Additional features of this home include central air conditioning & water softener. Located in a AAA location, this home is close to top-rated schools, Laurel Creek Conservation Area, parks, walking trails, universities (U of W & WLU), YMCA, library and more, schedule your private showing today"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-26T18:01:40.126505+00:00"
+"CrossStreet": "laurelwood"
+"DirectionFaces": "North"
+"Directions": "laurelwood to wood nettle"
+"ExpirationDate": "2026-06-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-25"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-03-25T17:59:54Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-25T17:59:54Z"
+"OriginalListPrice": 1199900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3716800"
+"ParcelNumber": "226843724"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-25T17:59:54Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Wood Nettle"
+"StreetNumber": "504"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "7537.69"
+"TaxAssessedValue": 552000
+"TaxLegalDescription": "LOT 68, PLAN 58M376, CITY OF WATERLOO. S/T EASEMENT IN GROSS OVER PT. 111 PL 58R15114 AS IN WR169659.S/T EASEMENT IN GROSS AS IN WR169801, OVER PT 111, 58R15114"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/504_wood_nettle_way_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.28
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12920376')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604000119436"
+"SurveyType": "None"
+"RentalItems": "none"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 2Y1, CA"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 15
+"LotSizeAreaUnits": "Square Feet"
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 6
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Lower"
+"MediaChangeTimestamp": "2026-03-25T17:59:54Z"
+"SystemModificationTimestamp": "2026-03-25T17:59:54.980926Z"
+"Media": array:43 [ …43]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4277
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12913138"
+"ListingId": "X12913138"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T20:24:42Z"
+"RFModificationTimestamp": "2026-04-28T21:08:43Z"
+"ListPrice": 299999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 607, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to urban sophistication at its finest! This stunning 1 bedroom, 1 bathroom condo nestled in the heart of Waterloo is walking distance to University of Waterloo and Wilfred Laurier University. The unit offers the epitome of modern living combined with convenience and comfort. As you step inside, you'll be greeted with floor-to-ceiling windows, which flood the space with natural light. The layout seamlessly integrates the living, dining, and kitchen areas, perfect for both relaxing evenings and entertaining guests. One of the highlights of this condo is the in-suite laundry, ensuring convenience and efficiency in your daily routine. The unit comes fully equipped with granite counter tops, stainless steel appliances, as well as existing furniture, including a full bed frame with mattress, a sofa, a coffee table, a built-in study table with shelves, an office chair, a dining table with four chairs, and a TV with TV console. Move-in ready, this condo offers a hassle-free transition. Moreover, residents of this building are granted access to an array of amenities designed to enhance their lifestyle. Keep up with your fitness goals in the exercise room, host memorable gatherings in the party room, or unwind and soak in panoramic views from the rooftop deck/garden and visitor parking for your guests. This condo presents an exceptional opportunity for investors as well as end-users. Book a showing today and experience everything that has to offer. - Property has been virtually staged."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "393.24"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T23:18:21.015896+00:00"
+"CrossStreet": "University Avenue to Hemlock Street."
+"Directions": "University Avenue to Hemlock Street."
+"Exclusions": "ALL TENANTS BELONGINGS"
+"ExpirationDate": "2026-08-31"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, full bed frame with mattress, a sofa, a coffee table, a built-in study table with shelves, an office chair, a dining table with four chairs, and a TV with TV console"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-24"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-03-24T12:46:58Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-24T12:46:58Z"
+"OriginalListPrice": 299999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3682830"
+"ParcelNumber": "236790150"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-24T12:46:58Z"
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2594.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "607"
+"VirtualTourURLBranded": "https://youtu.be/J85SMIOnf Xk?si=X4x KIa9f3L8b Xufi"
+"VirtualTourURLBranded2": "https://youriguide.com/607_257_hemlock_st_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/607_257_hemlock_st_waterloo_on/"
+"Zoning": "NMU6"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12913138')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004270"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "6"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"MortgageComment": "Seller To Discharge"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "Iguide"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lock box on rear of the building attached to the A/C unit. lockbox has a mail stamp on the side to distinguish easily. 24 HOUR NOTICE PRIOR TO SHOWINGS. TENANT MAY BE PRESENT FOR SHOWINGS. Leave card, shut off lights and lock doors when complete."
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "7"
+"MediaChangeTimestamp": "2026-03-24T12:46:58Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-03-24T20:24:44.9529Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:22 [ …22]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4276
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12870416"
+"ListingId": "X12870416"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-24T19:54:32Z"
+"RFModificationTimestamp": "2026-04-28T21:08:29Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street F411, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL STAR REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Excellent Location Step Away From Laurier University. Very Close To Waterloo University. Very Neat & Clean. 2 Bedroom, 2 Washroom Condo Apartment. Kitchen Has Marble Counter Top. Very Large Vanities. It's A Furnished Condo Unit With TV, 2 Beds, 2 Matterss, Dining Table With 4 Chairs, Sofas. Wi-Fi Building, All 5 Appliances Included. Open Concept And Washer & Dryer Inside Condo Unit. Open Wide Balcony. Finishes With Plank Laminate Wood Floor. Must Must See The Unit For Future Investment Or For Own Use You Will Not Be Disappointed."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "429.84"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ROYAL STAR REALTY INC."
+"CoListOfficePhone": "905-793-1111"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-19T23:25:28.443311+00:00"
+"CrossStreet": "Hickory St & Hemlock St"
+"Directions": "Hickory St & Hemlock St"
+"ExpirationDate": "2026-07-10"
+"Inclusions": "All Appliances: Fridge, Stove, Washer & Dryer, Dishwasher, TV, Mattress, Sofas, Dining Table With Chairs, Bed Sets For Both Room, 2 Small Laptop Table Comes With 2 Chairs, Range Hood Fan In Kitchen. All Included, Fully Furnished Condo Apartment."
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-11"
+"MainOfficeKey": "159800"
+"MajorChangeTimestamp": "2026-03-24T19:54:32Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-11T14:28:11Z"
+"OriginalListPrice": 445000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3651482"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-11T14:28:11Z"
+"PreviousListPrice": 445000.0
+"PriceChangeTimestamp": "2026-03-24T19:54:32Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2976.85"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.50%"
+"TransactionType": "For Sale"
+"UnitNumber": "F411"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12870416')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301604270001276"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 30
+"LegalStories": "4"
+"ParkingType1": "Rental"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 634
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Owner"
+"PossessionDetails": "Immediately"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-03-11T14:28:11Z"
+"PropertyManagementCompany": "Condo Management Corporation"
+"SystemModificationTimestamp": "2026-03-24T19:54:36.171466Z"
+"Media": array:25 [ …25]
}
]
+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 {#4249
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13056632"
+"ListingId": "X13056632"
+"PropertyType": "Residential"
+"PropertySubType": "Triplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-30T09:17:27Z"
+"RFModificationTimestamp": "2026-04-30T09:21:58Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 8.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Alta Vista And Area"
…108
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …144}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …110}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …121}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …109}
]
+success: true
+page_size: 5
+page_count: 8864
+count: 44316
+after_key: ""
}
]
]
