array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=100&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=100&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=100&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=100&$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: "623703"
+post_author: 1
+"ListingKey": "X12857472"
+"ListingId": "X12857472"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-21T13:27:55Z"
+"RFModificationTimestamp": "2026-04-29T12:32:20Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3W7"
+"UnparsedAddress": "333 Rosette Drive, Waterloo, ON N2K 3W7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.491207
+"Longitude": -80.48954
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PERCY FULTON LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "OFFERS WELCOME ANY TIME! A stunning spacious open concept 3bed, 2.5bath family home in great location of Waterloo. The welcoming fo yer with ceramic tile floors open to views of the great room, kitchen and dinette. The two storey home features gorgeous new hardwood flooring, beautiful bright kitchen with shaker style cabinets, Silestone counter tops, lantern tile backsplash and stainless steel appliances. The generous dinette has patio doors that lead to the large deck, fully fenced backyard and Arctic Spa hot tub. Upstairs you will find more of the hardwood in all three bedrooms and landing, carpet free except for the stairs. The Master Bedroom is large enough for a king size bed and features a walk-in closet. Two additional good size bedrooms one with a walk-in closet. The main 4pcs family bath has been completely renovated, beautiful tiled floors and tub\shower. The basement features fully finished cozy rec room with brand new luxury vinyl plank flooring matches the hardwood upstairs perfectly. This space is rounded off with a 3pcs bath. Recent updates include: Gas, Over Hood, Dishwasher (2024), Water Purifier (2023), Heat Pump (2022), Water Heater Tankless (2023), 200amp electricity, Garage Auto Opener with app (2025). Freshco, Public transport, Highway, Schools, Banks, Restaurants within 5 min drive. Seller Does not guarantee the functionality of hot water tub in backyard."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T03:56:54.507557+00:00"
+"CrossStreet": "University Ave E & Bridge St W"
+"DirectionFaces": "South"
+"Directions": "Pastern Trail and University Avenue East"
+"ExpirationDate": "2026-12-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "The following will be included :- Lawn Mower, Leaf Blower, Almira In The Garage, Ring Security System , Ring Door Bell,"
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Water Heater,Water Purifier,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "222500"
+"MajorChangeTimestamp": "2026-04-21T13:27:55Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-07T04:59:27Z"
+"OriginalListPrice": 825000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3629182"
+"ParcelNumber": "222980010"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-03-07T04:59:28Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 825000.0
+"PriceChangeTimestamp": "2026-03-28T13:07:51Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Rosette"
+"StreetNumber": "333"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4451.61"
+"TaxLegalDescription": "LT 92 PL 1804 CITY OF WATERLOO; S/T 1241130; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 102.98
+"LotWidth": 31.9
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12857472')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601344506400"
+"SurveyType": "None"
+"RentalItems": "Water heater $ 22.59, Water softener $ 28.24"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3W7, CA"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Sold Conditional"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:2 [ …2]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-03-07T04:59:28Z"
+"SystemModificationTimestamp": "2026-04-21T13:27:55.923069Z"
+"SoldConditionalEntryTimestamp": "2026-04-14T17:52:04Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
+"ID": "623703"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "659328"
+post_author: 1
+"ListingKey": "X12942838"
+"ListingId": "X12942838"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-21T04:06:08Z"
+"RFModificationTimestamp": "2026-04-25T05:05:57Z"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0G2"
+"UnparsedAddress": "103 Roger Street 201, Waterloo, ON N2J 0G2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.460111
+"Longitude": -80.5101515
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stunning 2-bedroom corner unit condo facing a peaceful children's park in the heart of Waterloo! This bright and spacious unit features an open-concept layout with luxury vinyl plank flooring, 9-foot ceilings, and large windows that flood the space with natural light. Enjoy a modern kitchen with quartz countertops, stainless steel appliances, and ample cabinet space, along with two generous bedrooms featuring walk-in closets. The large balcony offers serene park views, and underground parking is included. Ideally located just minutes from the GO Station, Google office, University of Waterloo, Wilfrid Laurier University, Grand River Hospital, and all major amenities."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-21T04:14:20.464399+00:00"
+"CrossStreet": "Rogers St. & Moore Ave."
+"Directions": "Rogers St. & Moore Ave."
+"ExpirationDate": "2026-05-31"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-21T04:06:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-01T12:28:18Z"
+"OriginalListPrice": 2100.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3750696"
+"ParcelNumber": "237730079"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-01T12:28:18Z"
+"PreviousListPrice": 2100.0
+"PriceChangeTimestamp": "2026-04-21T04:06:08Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "201"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12942838')"
+"GarageType": "Other"
+"HeatSource": "Gas"
+"RollNumber": "301602135004729"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"RentalItems": "HWT Rental at $20 per mth"
+"HoldoverDays": 30
+"LegalStories": "2"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0G2, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 773
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "mpac"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "201"
+"MediaChangeTimestamp": "2026-04-01T12:28:18Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Duka Property Management"
+"SystemModificationTimestamp": "2026-04-21T04:06:08.231051Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:20 [ …20]
+"ID": "659328"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "677055"
+post_author: 1
+"ListingKey": "X12997880"
+"ListingId": "X12997880"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T22:47:59Z"
+"RFModificationTimestamp": "2026-04-29T03:31:45Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2R 0R5"
+"UnparsedAddress": "150 Rochefort Street F, Waterloo, ON N2R 0R5"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "FLUX REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "SOPHISTICATED SINGLE-LEVEL LIVING IN HURON GARDENS. Skip the stairs and embrace the rare " Unit F" Layout-a meticulously designed 1,133 sq. ft. bungalow-style flat by the award winning Activa Group. This isn't just a townhome; it's an effortless lifestyle move in Kitchener's premier growth corridor. The interior Excellence begins with a sprawling, open-concept gallery bathed in natural light thanks to a premium Southeast exposure. The chef-inspired kitchen features high-end stainless steel appliances, an oversized social island/breakfast bar, and upgraded, carpet-free flooring throughout for a sleek, modern finish. Retreat to the true king-sized primary sanctuary featuring a private 3-piece ensuite and ample storage. As an Energy Star certified build, you will enjoy superior comfort and lower utility costs with triple-pane windows and high-efficiency systems - a hallmark of Activa quality. Experience one of the lowest carrying costs in the Waterloo Region with ultra-low condo fee ($229/mo), making this a high-yield asset for investors or an affordable luxury for first-time buyers. Perfectly positioned for connectivity, you are just 2 minutes from Longo's, Starbucks and major retail hubs, while being steps from the 250-acre Huron Natural Area trails and minutes from the 401. Don't settle for vertical living; experience the scale and convenience of 150 Rochefort."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "229.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T17:38:58.396293+00:00"
+"CrossStreet": "Huron Rd & Fischer-Hallman Rd"
+"Directions": "Huron Rd to Fischer-Hallman Rd, turn onto Huron Rd, then onto Rochefort St."
+"Exclusions": "Shelving unit in secondary bedroom, refrigerator in secondary bedroom, portable pantry in Kitchen"
+"ExpirationDate": "2026-07-31"
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Carpet Free,Primary Bedroom - Main Floor"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-04-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "458200"
+"MajorChangeTimestamp": "2026-04-14T19:23:16Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-14T19:23:16Z"
+"OriginalListPrice": 449900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3807966"
+"ParcelNumber": "236940114"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-18T12:55:03Z"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Rochefort"
+"StreetNumber": "150"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3202.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "F"
+"VirtualTourURLBranded": "https://youtube.com/shorts/5OBk Ls T3Ays?feature=share"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12997880')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301206001114174"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2R 0R5, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-14"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 694
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "Measurements from status certificate and/or third-party sources"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please ensure the box is securely closed before leaving. Remove shoes at entrance. Turn off all lights, ensure the patio door is locked, and leave your business card on the Kitchen counted. Affixed to the front door handle."
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "F"
+"MediaChangeTimestamp": "2026-04-18T12:55:03Z"
+"PropertyManagementCompany": "Fiver Rivers Property Management"
+"SystemModificationTimestamp": "2026-04-20T22:48:07.50337Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:26 [ …26]
+"ID": "677055"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "697478"
+post_author: 1
+"ListingKey": "X13021972"
+"ListingId": "X13021972"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T20:15:16Z"
+"RFModificationTimestamp": "2026-04-29T12:33:49Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2J7"
+"UnparsedAddress": "579 Paradise Crescent, Waterloo, ON N2T 2J7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.452119
+"Longitude": -80.569055
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 579 Paradise Cres, a stunning executive home where space meets luxury on an impressive 76 x 111 ft premium lot-rarely found in this sought-after Waterloo neighbourhood.Boasting over 4,500 sqft of finished living space above and below grade, this home is designed for the largest of families. Featuring a versatile 4+2 bedroom layout, this property is truly all about space. Completely carpet-free throughout-enjoy easy maintenance. Step into the heart of the home-a completely modern kitchen featuring sleek quartz countertops and stainless steel kitchen appliances . Recent upgrades ensure a move-in-ready experience with high-end finishes throughout. Situated in the catchment of Laurel Heights Secondary School, one of Waterloo Region's highest-ranked high schools with an impressive 8.4/10 rating from the Fraser Institute . This location offers exceptional educational opportunities for your family. Enjoy the ultimate convenience of living just minutes from Boardwalk Shopping Centre, home to premier brands and everyday essentials such as Walmart, Home Sense, Marshalls, Sport Check and nearby amenities include restaurants, banks, coffee shops, medical centres and professional services-everything you need is right around the corner. Stock up in bulk and save at Costco Wholesale Just Minutes Away. Don't miss this rare opportunity to own a spacious, carpet-free, sprawling home in one of Waterloo's most convenient and family-friendly locations. (Virtual staging photos are included in this listing)"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T18:18:58.487637+00:00"
+"CrossStreet": "Erbsville Crt & Paradise Cres"
+"DirectionFaces": "South"
+"Directions": "Erbsville Crt & Paradise Cres"
+"ExpirationDate": "2026-09-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Stove, Washer, Microwave"
+"InteriorFeatures": "Auto Garage Door Remote,Sump Pump,Water Heater,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-20T20:15:16Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-20T20:15:16Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3839712"
+"ParcelNumber": "226850558"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-04-20T20:15:16Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:3 [ …3]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "PARADISE"
+"StreetNumber": "579"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9097.0"
+"TaxAssessedValue": 664000
+"TaxLegalDescription": "LT 3 PL 1691 CITY OF WATERLOO; S/T 986964; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://my.matterport.com/show/?m=Jfhf F8De KAv&play=1"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Jfhf F8De KAv&play=1"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.55
+"LotWidth": 76.12
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13021972')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604332704200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 2J7, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 9
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "shoes off, lights off"
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-04-20T20:15:16Z"
+"SystemModificationTimestamp": "2026-04-20T20:15:16.853213Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [ …46]
+"ID": "697478"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "651867"
+post_author: 1
+"ListingKey": "X12922076"
+"ListingId": "X12922076"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:48:44Z"
+"RFModificationTimestamp": "2026-04-30T05:00:49Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0J8"
+"UnparsedAddress": "155 Caroline Street 1302, Waterloo, ON N2L 0J8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Immaculate corner unit at the prestigious 155 Caroline Street Private Residences. This bright 2-bedroom, 2-bathroom suite offers a well-designed open-concept layout with a modern kitchen featuring quartz countertops, stainless steel appliances, and a breakfast bar, flowing into the spacious living and dining area. Sliding doors from both the living room and primary bedroom lead to a large balcony with beautiful views of Uptown and the Mary Allen neighbourhood. The unit comes with underground parking and a locker. Enjoy premium building amenities including a concierge, fitness centre, party room, theatre room, outdoor terrace, guest suite, and bike room. Ideally located steps to Vincenzo's, cafés, restaurants, boutique shopping, the LRT, and with quick access to both universities. Property is virtually staged."
+"AccessibilityFeatures": array:1 [ …1]
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "649.52"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T18:36:07.892686+00:00"
+"CrossStreet": "CAROLINE ST.S."
+"Directions": "Caroline St. & Allen St."
+"ExpirationDate": "2026-07-17"
+"ExteriorFeatures": "Year Round Living"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Built in microwave, Built in dishwasher, Washer, Dryer"
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Guest Accommodations,Intercom"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-25"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-03-26T01:39:42Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-26T01:39:42Z"
+"OriginalListPrice": 539900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707236"
+"ParcelNumber": "236770383"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T01:39:43Z"
+"Roof": "Flat"
+"SecurityFeatures": array:3 [ …3]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Caroline"
+"StreetNumber": "155"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4956.86"
+"TaxAssessedValue": 363000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1302"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://youriguide.com/1502_155_caroline_st_s_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1502_155_caroline_st_s_waterloo_on/"
+"Zoning": "MR-25"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12922076')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301603045002332"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Fan coil"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "13"
+"LockerNumber": "113"
+"ParkingSpot1": "23"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0J8, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 677
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "other"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "BROKERBAY"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-26T01:39:43Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"PropertyManagementCompany": "Weigel Propr Mng"
+"SystemModificationTimestamp": "2026-04-20T19:48:53.729003Z"
+"Media": array:43 [ …43]
+"ID": "651867"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "709313"
+post_author: 1
+"ListingKey": "X13014842"
+"ListingId": "X13014842"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:18:41Z"
+"RFModificationTimestamp": "2026-04-30T05:01:49Z"
+"ListPrice": 589000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W6"
+"UnparsedAddress": "261 Lester Street 203, Waterloo, ON N2L 3W6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REALTY SPECIALISTS INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Attn Investors: $4325.00 Monthly Income From This Fully Tenanted Student Rental (On Signed Lease With A++ Tenant Group). Can be provided Vacant. Walking Distance To Waterloo U. Five Separate Rooms With A Shared Kitchen, And Two Shared Baths. Safe Building W/Security, Attracts The Best Students. No Vacancies! Option For Hands Off Investment With On-Site Property Management For 6% Monthly Fee Or Can Self-Manage. Act Now, This Won't Last!"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "941.24"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T18:48:40.545675+00:00"
+"CrossStreet": "University/ Lester"
+"Directions": "University/ Lester"
+"ExpirationDate": "2026-09-30"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"MainOfficeKey": "495300"
+"MajorChangeTimestamp": "2026-04-17T21:58:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-17T21:58:34Z"
+"OriginalListPrice": 589000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3834816"
+"ParkingFeatures": "Covered"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T21:58:35Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "261"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3837.12"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "203"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014842')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"LegalStories": "2"
+"ParkingType1": "Common"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 630
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 6
+"SquareFootSource": "Owner - 1349 sq ft"
+"PossessionDetails": "IMMED"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "3"
+"MediaChangeTimestamp": "2026-04-20T19:18:41Z"
+"PropertyManagementCompany": "Rent Corp."
+"SystemModificationTimestamp": "2026-04-20T19:18:41.575979Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
+"ID": "709313"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "697886"
+post_author: 1
+"ListingKey": "X13021556"
+"ListingId": "X13021556"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:12:51Z"
+"RFModificationTimestamp": "2026-04-30T05:01:55Z"
+"ListPrice": 1875.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H6"
+"UnparsedAddress": "258a Sunview Street 111, Waterloo, ON N2L 0H6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE IGNITE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this well-located ground-level condo at 258A Sunview Street in the heart of Waterloo, just steps from the University of Waterloo and Wilfrid Laurier University, with quick access to major highways, transit, shopping, and everyday amenities. This unique unit stands out with its convenient ground-floor location, offering direct main-level entry, no waiting for elevators, and an additional private egress from the living room to the street, providing enhanced accessibility and added peace of mind in case of emergencies. The functional layout includes a den that is currently utilized as a full bedroom, making it an ideal setup for students, young professionals, or working couples seeking flexible living space. Bright and practical, this unit combines comfort with convenience in a highly sought- after rental area. A rare opportunity in a competitive leasing market-don't miss out on this accessible and thoughtfully designed unit."
+"ArchitecturalStyle": "Apartment"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T18:51:27.178926+00:00"
+"CrossStreet": "Sunview St & University Ave"
+"Directions": "Sunview St & University Ave"
+"ExpirationDate": "2026-09-30"
+"Furnished": "Partially"
+"Inclusions": "Stainless Steel Freezer/Fridge, Stove, Range Hood, Microwave, Dishwasher, Washer and Dryer, 2 Beds w/ Mattress, 1 Wardrobe, 2 Desks with Chairs, Dining Table and 2 Chairs, Living Room Sofa Chair, 1 Coffee Table."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "265900"
+"MajorChangeTimestamp": "2026-04-20T19:12:51Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-20T19:12:51Z"
+"OriginalListPrice": 1875.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3836588"
+"ParcelNumber": "236660003"
+"ParkingFeatures": "Street Only,Unreserved"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-20T19:12:51Z"
+"RentIncludes": array:4 [ …4]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half month rent + hst"
+"TransactionType": "For Lease"
+"UnitNumber": "111"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13021556')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604435004203"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H6, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 4
+"RoomsBelowGrade": 1
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PropertyFeatures": array:1 [ …1]
+"SquareFootSource": "PREVIOUS LISTING"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "3"
+"MediaChangeTimestamp": "2026-04-20T19:12:51Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-20T19:12:51.945711Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:8 [ …8]
+"ID": "697886"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "636051"
+post_author: 1
+"ListingKey": "X12789520"
+"ListingId": "X12789520"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T16:50:44Z"
+"RFModificationTimestamp": "2026-04-30T05:00:29Z"
+"ListPrice": 529000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5G5"
+"UnparsedAddress": "109 Westmount Road N, Waterloo, ON N2L 5G5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4636733
+"Longitude": -80.540795
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "AIMHOME REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Location! Location! This 4 Bedroom Condo Unit is steps away from The University of Waterloo and the property is great for students, professionals, and families. This Condo Unit is Available at 109 Westmount Road North. Vacant Possession from April 30 2026. Renovated in 2020 with 2 bathrooms, 6 appliances, and an open-concept kitchen with cabinetry/storage and in-suite laundry. Invest in this great condo or move in. Vacant May 1, 2026. This building has a garage with secure storage and parking. Surrounded by schools, transit, shopping, and Waterloo Park. The closest major intersection is University Ave West and Westmount Rd N."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "594.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-20T17:06:26.303566+00:00"
+"CrossStreet": "Westmount Rd N/ University Ave"
+"Directions": "Westmount Rd N/ University Ave"
+"ExpirationDate": "2026-05-13"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer, Dryer, Dishwasher, Window Coverings, All Existing Light Fixtures. It's Great For Family With Kids Go To University. Live In One Room And Rent Out Other Three Rooms. Rent Covers Cost!"
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-13"
+"MainOfficeKey": "090900"
+"MajorChangeTimestamp": "2026-04-20T16:50:17Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-14T16:16:03Z"
+"OriginalListPrice": 549000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3555762"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-02-14T16:16:03Z"
+"PreviousListPrice": 549000.0
+"PriceChangeTimestamp": "2026-04-20T16:50:17Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Westmount"
+"StreetNumber": "109"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3850.78"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12789520')"
+"GarageType": "Built-In"
+"HeatSource": "Electric"
+"SurveyType": "Unknown"
+"BalconyType": "Terrace"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 5G5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 683
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Owner"
+"PossessionDetails": "tdb"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-02-14T16:16:03Z"
+"PropertyManagementCompany": "Weigel Property Management"
+"SystemModificationTimestamp": "2026-04-20T16:50:44.036473Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:11 [ …11]
+"ID": "636051"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: 712137
+post_author: 1
+"ListingKey": "X13019654"
+"ListingId": "X13019654"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T15:19:47Z"
+"RFModificationTimestamp": "2026-04-30T05:01:53Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0H2"
+"UnparsedAddress": "243 Northfield Drive E #208, Waterloo, ON N2K 0H2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.50911
+"Longitude": -80.523155
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Blackstone Condominiums, where modern design meets convenient lifestyle living. Owner Occupied, CARPET FREE one-bedroom suite offering an oversized four-piece bathroom and the convenience of an in-suite stackable washer and dryer, and REMOTE CUSTOM BLINDS. This impeccably tidy home features a contemporary open layout with views of the tranquil courtyard from both the living room and the bedroom. A sliding PATIO DOOR leading to your private balcony, over 62 square feet, perfect for enjoying your morning coffee. The bright white kitchen is thoughtfully designed with UP-GRAGED QUARTZ countertops, stainless steel appliances, a classic subway TILE BACKSPLASH, a LARGE ISLAND with extra storage, and hanging PENDANT LIGHTS over the island for your convenience. The bathroom is generously sized and includes a modern tub and shower combination, with plenty of space for comfort. This suite also includes an exclusively owned UNDERGROUND PARKING space and private STORAGE LOCKER for added value. Residents of Blackstone enjoy a wide range of shared amenities designed for a modern lifestyle, including a pet washing station, secure bike storage, a fully equipped gym, a co-working lounge, a spacious party room, a rooftop terrace in building 255, and beautifully designed outdoor gathering spaces between buildings 247 and 243. High-speed Rogers internet is included in the condo fees, offering even more convenience. Ideally located just steps from Brown's Social House and other local shops and services, this community is minutes from Conestoga Mall, the ION light rail transit line, and scenic walking trails. With quick access to St.Jacobs, RIM Park, Grey Silo Golf Course, Wilfrid Laurier University, University of Waterloo, and Conestoga College, this condo is perfectly situated for anyone looking to enjoy the convenience of Waterloo. Perfect for the professional, downsizer, investor or first-time buyer."
+"AccessibilityFeatures": array:4 [ …4]
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "494.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-20T16:51:47.752843+00:00"
+"CrossStreet": "Bridge Street"
+"Directions": "Corner of Northfield Dr. E & Bridge St."
+"Exclusions": "Bedroom ceiling fan (will be replaces with a ceiling light) Free standing Fireplace."
+"ExpirationDate": "2026-07-31"
+"GarageYN": true
+"Inclusions": "Custom Island, Storage Locker, TV brackets, floating shelve in washroom, pendant island light."
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Storage Area Lockers,Wheelchair Access"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-20T15:19:47Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-20T15:19:47Z"
+"OriginalListPrice": 345000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3837428"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-20T15:19:47Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2990.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "#208"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=_DMy APWdm K0&t=4s"
+"Zoning": "RMU-20"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13019654')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"LockerUnit": "L1#56"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "L1"
+"HoldoverDays": 60
+"LegalStories": "level 2"
+"LockerNumber": "56"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 0H2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 710
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "builder plan"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-04-20T15:19:47Z"
+"PropertyManagementCompany": "Five Rivers Property Management"
+"SystemModificationTimestamp": "2026-04-20T15:19:48.159266Z"
+"Media": array:37 [ …37]
+"ID": 712137
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "709182"
+post_author: 1
+"ListingKey": "X13010006"
+"ListingId": "X13010006"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T15:03:10Z"
+"RFModificationTimestamp": "2026-04-30T05:01:47Z"
+"ListPrice": 448900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0K7"
+"UnparsedAddress": "145 Columbia Street W 1135, Waterloo, ON N2L 0K7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.47745
+"Longitude": -80.538415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Society 145, a brand-new luxury condominium in the heart of Waterloo, just steps from Wilfrid Laurier University and the University of Waterloo. This bright and thoughtfully designed 2-bedroom, 1-bathroom suite is ideal for student living or a savvy investment. Featuring Laminate floors, quartz countertops, stainless steel appliances, and stylish finishes throughout, the open-concept layout offers a modern and functional living space filled with natural light. The spacious den easily serves as a second bedroom, private study, or workspace. Offered fully furnished with Beds, Couch, Table, TV & more (see attached list). Residents enjoy premium amenities including a fitness centre, yoga studio, indoor basketball court, study rooms, business lounge, theatre, and games room. A perfect blend of luxury, convenience, and strong rental potential in one of Waterloo's most sought-after university locations. Pics are virtually staged to protect tenant's privacy."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "324.5"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"CoListOfficePhone": "905-568-2121"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T00:07:11.003219+00:00"
+"CrossStreet": "Columba St W/Phillip St"
+"Directions": "Columba St W/Phillip St"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "Stainless steel stove & fridge, B/I Dishwasher, OTR Microwave, Clothes Washer & Dryer, furniture, TV."
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-16T23:07:15Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-16T23:07:15Z"
+"OriginalListPrice": 448900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3829606"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-16T23:07:16Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3140.71"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.00% of the sale price"
+"TransactionType": "For Sale"
+"UnitNumber": "1135"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13010006')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 30
+"LegalStories": "3"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 790
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"SquareFootSource": "546 sqft - MPAC"
+"PossessionDetails": "90 Days / TBA"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2026-04-16T23:07:16Z"
+"PropertyManagementCompany": "Craft Property Group"
+"SystemModificationTimestamp": "2026-04-20T15:03:13.880302Z"
+"Media": array:16 [ …16]
+"ID": "709182"
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
"RF Response Time" => "0.42 seconds"
]
"RF Cache Key: d136a5e49dc489600e717adf2eff7bb5d841d7afe19092e8ed69919ccd06097d" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3098
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4292
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12857472"
+"ListingId": "X12857472"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-21T13:27:55Z"
+"RFModificationTimestamp": "2026-04-29T12:32:20Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3W7"
+"UnparsedAddress": "333 Rosette Drive, Waterloo, ON N2K 3W7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.491207
+"Longitude": -80.48954
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PERCY FULTON LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "OFFERS WELCOME ANY TIME! A stunning spacious open concept 3bed, 2.5bath family home in great location of Waterloo. The welcoming fo yer with ceramic tile floors open to views of the great room, kitchen and dinette. The two storey home features gorgeous new hardwood flooring, beautiful bright kitchen with shaker style cabinets, Silestone counter tops, lantern tile backsplash and stainless steel appliances. The generous dinette has patio doors that lead to the large deck, fully fenced backyard and Arctic Spa hot tub. Upstairs you will find more of the hardwood in all three bedrooms and landing, carpet free except for the stairs. The Master Bedroom is large enough for a king size bed and features a walk-in closet. Two additional good size bedrooms one with a walk-in closet. The main 4pcs family bath has been completely renovated, beautiful tiled floors and tub\shower. The basement features fully finished cozy rec room with brand new luxury vinyl plank flooring matches the hardwood upstairs perfectly. This space is rounded off with a 3pcs bath. Recent updates include: Gas, Over Hood, Dishwasher (2024), Water Purifier (2023), Heat Pump (2022), Water Heater Tankless (2023), 200amp electricity, Garage Auto Opener with app (2025). Freshco, Public transport, Highway, Schools, Banks, Restaurants within 5 min drive. Seller Does not guarantee the functionality of hot water tub in backyard."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T03:56:54.507557+00:00"
+"CrossStreet": "University Ave E & Bridge St W"
+"DirectionFaces": "South"
+"Directions": "Pastern Trail and University Avenue East"
+"ExpirationDate": "2026-12-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "The following will be included :- Lawn Mower, Leaf Blower, Almira In The Garage, Ring Security System , Ring Door Bell,"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "222500"
+"MajorChangeTimestamp": "2026-04-21T13:27:55Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-03-07T04:59:27Z"
+"OriginalListPrice": 825000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3629182"
+"ParcelNumber": "222980010"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-03-07T04:59:28Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 825000.0
+"PriceChangeTimestamp": "2026-03-28T13:07:51Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Rosette"
+"StreetNumber": "333"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4451.61"
+"TaxLegalDescription": "LT 92 PL 1804 CITY OF WATERLOO; S/T 1241130; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 102.98
+"LotWidth": 31.9
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12857472')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601344506400"
+"SurveyType": "None"
+"RentalItems": "Water heater $ 22.59, Water softener $ 28.24"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3W7, CA"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Sold Conditional"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:2 [ …2]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-03-07T04:59:28Z"
+"SystemModificationTimestamp": "2026-04-21T13:27:55.923069Z"
+"SoldConditionalEntryTimestamp": "2026-04-14T17:52:04Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4293
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12942838"
+"ListingId": "X12942838"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-21T04:06:08Z"
+"RFModificationTimestamp": "2026-04-25T05:05:57Z"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0G2"
+"UnparsedAddress": "103 Roger Street 201, Waterloo, ON N2J 0G2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.460111
+"Longitude": -80.5101515
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stunning 2-bedroom corner unit condo facing a peaceful children's park in the heart of Waterloo! This bright and spacious unit features an open-concept layout with luxury vinyl plank flooring, 9-foot ceilings, and large windows that flood the space with natural light. Enjoy a modern kitchen with quartz countertops, stainless steel appliances, and ample cabinet space, along with two generous bedrooms featuring walk-in closets. The large balcony offers serene park views, and underground parking is included. Ideally located just minutes from the GO Station, Google office, University of Waterloo, Wilfrid Laurier University, Grand River Hospital, and all major amenities."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-21T04:14:20.464399+00:00"
+"CrossStreet": "Rogers St. & Moore Ave."
+"Directions": "Rogers St. & Moore Ave."
+"ExpirationDate": "2026-05-31"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-21T04:06:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-01T12:28:18Z"
+"OriginalListPrice": 2100.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3750696"
+"ParcelNumber": "237730079"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-01T12:28:18Z"
+"PreviousListPrice": 2100.0
+"PriceChangeTimestamp": "2026-04-21T04:06:08Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "201"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12942838')"
+"GarageType": "Other"
+"HeatSource": "Gas"
+"RollNumber": "301602135004729"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"RentalItems": "HWT Rental at $20 per mth"
+"HoldoverDays": 30
+"LegalStories": "2"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0G2, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 773
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "mpac"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ContactAfterExpiryYN": true
+"LegalApartmentNumber": "201"
+"MediaChangeTimestamp": "2026-04-01T12:28:18Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Duka Property Management"
+"SystemModificationTimestamp": "2026-04-21T04:06:08.231051Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:20 [ …20]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4296
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12997880"
+"ListingId": "X12997880"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T22:47:59Z"
+"RFModificationTimestamp": "2026-04-29T03:31:45Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2R 0R5"
+"UnparsedAddress": "150 Rochefort Street F, Waterloo, ON N2R 0R5"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "FLUX REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "SOPHISTICATED SINGLE-LEVEL LIVING IN HURON GARDENS. Skip the stairs and embrace the rare " Unit F" Layout-a meticulously designed 1,133 sq. ft. bungalow-style flat by the award winning Activa Group. This isn't just a townhome; it's an effortless lifestyle move in Kitchener's premier growth corridor. The interior Excellence begins with a sprawling, open-concept gallery bathed in natural light thanks to a premium Southeast exposure. The chef-inspired kitchen features high-end stainless steel appliances, an oversized social island/breakfast bar, and upgraded, carpet-free flooring throughout for a sleek, modern finish. Retreat to the true king-sized primary sanctuary featuring a private 3-piece ensuite and ample storage. As an Energy Star certified build, you will enjoy superior comfort and lower utility costs with triple-pane windows and high-efficiency systems - a hallmark of Activa quality. Experience one of the lowest carrying costs in the Waterloo Region with ultra-low condo fee ($229/mo), making this a high-yield asset for investors or an affordable luxury for first-time buyers. Perfectly positioned for connectivity, you are just 2 minutes from Longo's, Starbucks and major retail hubs, while being steps from the 250-acre Huron Natural Area trails and minutes from the 401. Don't settle for vertical living; experience the scale and convenience of 150 Rochefort."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "229.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T17:38:58.396293+00:00"
+"CrossStreet": "Huron Rd & Fischer-Hallman Rd"
+"Directions": "Huron Rd to Fischer-Hallman Rd, turn onto Huron Rd, then onto Rochefort St."
+"Exclusions": "Shelving unit in secondary bedroom, refrigerator in secondary bedroom, portable pantry in Kitchen"
+"ExpirationDate": "2026-07-31"
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-04-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "458200"
+"MajorChangeTimestamp": "2026-04-14T19:23:16Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-14T19:23:16Z"
+"OriginalListPrice": 449900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3807966"
+"ParcelNumber": "236940114"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-18T12:55:03Z"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Rochefort"
+"StreetNumber": "150"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3202.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "F"
+"VirtualTourURLBranded": "https://youtube.com/shorts/5OBk Ls T3Ays?feature=share"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12997880')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301206001114174"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2R 0R5, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-14"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 694
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"SquareFootSource": "Measurements from status certificate and/or third-party sources"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please ensure the box is securely closed before leaving. Remove shoes at entrance. Turn off all lights, ensure the patio door is locked, and leave your business card on the Kitchen counted. Affixed to the front door handle."
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "F"
+"MediaChangeTimestamp": "2026-04-18T12:55:03Z"
+"PropertyManagementCompany": "Fiver Rivers Property Management"
+"SystemModificationTimestamp": "2026-04-20T22:48:07.50337Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:26 [ …26]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4295
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13021972"
+"ListingId": "X13021972"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T20:15:16Z"
+"RFModificationTimestamp": "2026-04-29T12:33:49Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2J7"
+"UnparsedAddress": "579 Paradise Crescent, Waterloo, ON N2T 2J7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.452119
+"Longitude": -80.569055
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 579 Paradise Cres, a stunning executive home where space meets luxury on an impressive 76 x 111 ft premium lot-rarely found in this sought-after Waterloo neighbourhood.Boasting over 4,500 sqft of finished living space above and below grade, this home is designed for the largest of families. Featuring a versatile 4+2 bedroom layout, this property is truly all about space. Completely carpet-free throughout-enjoy easy maintenance. Step into the heart of the home-a completely modern kitchen featuring sleek quartz countertops and stainless steel kitchen appliances . Recent upgrades ensure a move-in-ready experience with high-end finishes throughout. Situated in the catchment of Laurel Heights Secondary School, one of Waterloo Region's highest-ranked high schools with an impressive 8.4/10 rating from the Fraser Institute . This location offers exceptional educational opportunities for your family. Enjoy the ultimate convenience of living just minutes from Boardwalk Shopping Centre, home to premier brands and everyday essentials such as Walmart, Home Sense, Marshalls, Sport Check and nearby amenities include restaurants, banks, coffee shops, medical centres and professional services-everything you need is right around the corner. Stock up in bulk and save at Costco Wholesale Just Minutes Away. Don't miss this rare opportunity to own a spacious, carpet-free, sprawling home in one of Waterloo's most convenient and family-friendly locations. (Virtual staging photos are included in this listing)"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T18:18:58.487637+00:00"
+"CrossStreet": "Erbsville Crt & Paradise Cres"
+"DirectionFaces": "South"
+"Directions": "Erbsville Crt & Paradise Cres"
+"ExpirationDate": "2026-09-30"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Stove, Washer, Microwave"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-20T20:15:16Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-20T20:15:16Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3839712"
+"ParcelNumber": "226850558"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-04-20T20:15:16Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "PARADISE"
+"StreetNumber": "579"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9097.0"
+"TaxAssessedValue": 664000
+"TaxLegalDescription": "LT 3 PL 1691 CITY OF WATERLOO; S/T 986964; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://my.matterport.com/show/?m=Jfhf F8De KAv&play=1"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Jfhf F8De KAv&play=1"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.55
+"LotWidth": 76.12
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13021972')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301604332704200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 2J7, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 9
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "shoes off, lights off"
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-04-20T20:15:16Z"
+"SystemModificationTimestamp": "2026-04-20T20:15:16.853213Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [ …46]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4294
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12922076"
+"ListingId": "X12922076"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:48:44Z"
+"RFModificationTimestamp": "2026-04-30T05:00:49Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0J8"
+"UnparsedAddress": "155 Caroline Street 1302, Waterloo, ON N2L 0J8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Immaculate corner unit at the prestigious 155 Caroline Street Private Residences. This bright 2-bedroom, 2-bathroom suite offers a well-designed open-concept layout with a modern kitchen featuring quartz countertops, stainless steel appliances, and a breakfast bar, flowing into the spacious living and dining area. Sliding doors from both the living room and primary bedroom lead to a large balcony with beautiful views of Uptown and the Mary Allen neighbourhood. The unit comes with underground parking and a locker. Enjoy premium building amenities including a concierge, fitness centre, party room, theatre room, outdoor terrace, guest suite, and bike room. Ideally located steps to Vincenzo's, cafés, restaurants, boutique shopping, the LRT, and with quick access to both universities. Property is virtually staged."
+"AccessibilityFeatures": array:1 [ …1]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "649.52"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T18:36:07.892686+00:00"
+"CrossStreet": "CAROLINE ST.S."
+"Directions": "Caroline St. & Allen St."
+"ExpirationDate": "2026-07-17"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Built in microwave, Built in dishwasher, Washer, Dryer"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-25"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-03-26T01:39:42Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-26T01:39:42Z"
+"OriginalListPrice": 539900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3707236"
+"ParcelNumber": "236770383"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T01:39:43Z"
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:3 [ …3]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Caroline"
+"StreetNumber": "155"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4956.86"
+"TaxAssessedValue": 363000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1302"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://youriguide.com/1502_155_caroline_st_s_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1502_155_caroline_st_s_waterloo_on/"
+"Zoning": "MR-25"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12922076')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301603045002332"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Fan coil"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "13"
+"LockerNumber": "113"
+"ParkingSpot1": "23"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0J8, CA"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 677
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "other"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "BROKERBAY"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-03-26T01:39:43Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"PropertyManagementCompany": "Weigel Propr Mng"
+"SystemModificationTimestamp": "2026-04-20T19:48:53.729003Z"
+"Media": array:43 [ …43]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13014842"
+"ListingId": "X13014842"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:18:41Z"
+"RFModificationTimestamp": "2026-04-30T05:01:49Z"
+"ListPrice": 589000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W6"
+"UnparsedAddress": "261 Lester Street 203, Waterloo, ON N2L 3W6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REALTY SPECIALISTS INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Attn Investors: $4325.00 Monthly Income From This Fully Tenanted Student Rental (On Signed Lease With A++ Tenant Group). Can be provided Vacant. Walking Distance To Waterloo U. Five Separate Rooms With A Shared Kitchen, And Two Shared Baths. Safe Building W/Security, Attracts The Best Students. No Vacancies! Option For Hands Off Investment With On-Site Property Management For 6% Monthly Fee Or Can Self-Manage. Act Now, This Won't Last!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "941.24"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T18:48:40.545675+00:00"
+"CrossStreet": "University/ Lester"
+"Directions": "University/ Lester"
+"ExpirationDate": "2026-09-30"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"MainOfficeKey": "495300"
+"MajorChangeTimestamp": "2026-04-17T21:58:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-17T21:58:34Z"
+"OriginalListPrice": 589000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3834816"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T21:58:35Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Lester"
+"StreetNumber": "261"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3837.12"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "203"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014842')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"LegalStories": "2"
+"ParkingType1": "Common"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W6, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 630
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 6
+"SquareFootSource": "Owner - 1349 sq ft"
+"PossessionDetails": "IMMED"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "3"
+"MediaChangeTimestamp": "2026-04-20T19:18:41Z"
+"PropertyManagementCompany": "Rent Corp."
+"SystemModificationTimestamp": "2026-04-20T19:18:41.575979Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13021556"
+"ListingId": "X13021556"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T19:12:51Z"
+"RFModificationTimestamp": "2026-04-30T05:01:55Z"
+"ListPrice": 1875.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H6"
+"UnparsedAddress": "258a Sunview Street 111, Waterloo, ON N2L 0H6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE IGNITE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this well-located ground-level condo at 258A Sunview Street in the heart of Waterloo, just steps from the University of Waterloo and Wilfrid Laurier University, with quick access to major highways, transit, shopping, and everyday amenities. This unique unit stands out with its convenient ground-floor location, offering direct main-level entry, no waiting for elevators, and an additional private egress from the living room to the street, providing enhanced accessibility and added peace of mind in case of emergencies. The functional layout includes a den that is currently utilized as a full bedroom, making it an ideal setup for students, young professionals, or working couples seeking flexible living space. Bright and practical, this unit combines comfort with convenience in a highly sought- after rental area. A rare opportunity in a competitive leasing market-don't miss out on this accessible and thoughtfully designed unit."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T18:51:27.178926+00:00"
+"CrossStreet": "Sunview St & University Ave"
+"Directions": "Sunview St & University Ave"
+"ExpirationDate": "2026-09-30"
+"Furnished": "Partially"
+"Inclusions": "Stainless Steel Freezer/Fridge, Stove, Range Hood, Microwave, Dishwasher, Washer and Dryer, 2 Beds w/ Mattress, 1 Wardrobe, 2 Desks with Chairs, Dining Table and 2 Chairs, Living Room Sofa Chair, 1 Coffee Table."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "265900"
+"MajorChangeTimestamp": "2026-04-20T19:12:51Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-20T19:12:51Z"
+"OriginalListPrice": 1875.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3836588"
+"ParcelNumber": "236660003"
+"ParkingFeatures": array:2 [ …2]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-20T19:12:51Z"
+"RentIncludes": array:4 [ …4]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half month rent + hst"
+"TransactionType": "For Lease"
+"UnitNumber": "111"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13021556')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604435004203"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0H6, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 4
+"RoomsBelowGrade": 1
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PropertyFeatures": array:1 [ …1]
+"SquareFootSource": "PREVIOUS LISTING"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "3"
+"MediaChangeTimestamp": "2026-04-20T19:12:51Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-20T19:12:51.945711Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:8 [ …8]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4289
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12789520"
+"ListingId": "X12789520"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T16:50:44Z"
+"RFModificationTimestamp": "2026-04-30T05:00:29Z"
+"ListPrice": 529000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5G5"
+"UnparsedAddress": "109 Westmount Road N, Waterloo, ON N2L 5G5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4636733
+"Longitude": -80.540795
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "AIMHOME REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Location! Location! This 4 Bedroom Condo Unit is steps away from The University of Waterloo and the property is great for students, professionals, and families. This Condo Unit is Available at 109 Westmount Road North. Vacant Possession from April 30 2026. Renovated in 2020 with 2 bathrooms, 6 appliances, and an open-concept kitchen with cabinetry/storage and in-suite laundry. Invest in this great condo or move in. Vacant May 1, 2026. This building has a garage with secure storage and parking. Surrounded by schools, transit, shopping, and Waterloo Park. The closest major intersection is University Ave West and Westmount Rd N."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "594.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-20T17:06:26.303566+00:00"
+"CrossStreet": "Westmount Rd N/ University Ave"
+"Directions": "Westmount Rd N/ University Ave"
+"ExpirationDate": "2026-05-13"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer, Dryer, Dishwasher, Window Coverings, All Existing Light Fixtures. It's Great For Family With Kids Go To University. Live In One Room And Rent Out Other Three Rooms. Rent Covers Cost!"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-02-13"
+"MainOfficeKey": "090900"
+"MajorChangeTimestamp": "2026-04-20T16:50:17Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-02-14T16:16:03Z"
+"OriginalListPrice": 549000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3555762"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-02-14T16:16:03Z"
+"PreviousListPrice": 549000.0
+"PriceChangeTimestamp": "2026-04-20T16:50:17Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Westmount"
+"StreetNumber": "109"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3850.78"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12789520')"
+"GarageType": "Built-In"
+"HeatSource": "Electric"
+"SurveyType": "Unknown"
+"BalconyType": "Terrace"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 5G5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 683
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 8
+"SquareFootSource": "Owner"
+"PossessionDetails": "tdb"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-02-14T16:16:03Z"
+"PropertyManagementCompany": "Weigel Property Management"
+"SystemModificationTimestamp": "2026-04-20T16:50:44.036473Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:11 [ …11]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4288
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13019654"
+"ListingId": "X13019654"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T15:19:47Z"
+"RFModificationTimestamp": "2026-04-30T05:01:53Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0H2"
+"UnparsedAddress": "243 Northfield Drive E #208, Waterloo, ON N2K 0H2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.50911
+"Longitude": -80.523155
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Blackstone Condominiums, where modern design meets convenient lifestyle living. Owner Occupied, CARPET FREE one-bedroom suite offering an oversized four-piece bathroom and the convenience of an in-suite stackable washer and dryer, and REMOTE CUSTOM BLINDS. This impeccably tidy home features a contemporary open layout with views of the tranquil courtyard from both the living room and the bedroom. A sliding PATIO DOOR leading to your private balcony, over 62 square feet, perfect for enjoying your morning coffee. The bright white kitchen is thoughtfully designed with UP-GRAGED QUARTZ countertops, stainless steel appliances, a classic subway TILE BACKSPLASH, a LARGE ISLAND with extra storage, and hanging PENDANT LIGHTS over the island for your convenience. The bathroom is generously sized and includes a modern tub and shower combination, with plenty of space for comfort. This suite also includes an exclusively owned UNDERGROUND PARKING space and private STORAGE LOCKER for added value. Residents of Blackstone enjoy a wide range of shared amenities designed for a modern lifestyle, including a pet washing station, secure bike storage, a fully equipped gym, a co-working lounge, a spacious party room, a rooftop terrace in building 255, and beautifully designed outdoor gathering spaces between buildings 247 and 243. High-speed Rogers internet is included in the condo fees, offering even more convenience. Ideally located just steps from Brown's Social House and other local shops and services, this community is minutes from Conestoga Mall, the ION light rail transit line, and scenic walking trails. With quick access to St.Jacobs, RIM Park, Grey Silo Golf Course, Wilfrid Laurier University, University of Waterloo, and Conestoga College, this condo is perfectly situated for anyone looking to enjoy the convenience of Waterloo. Perfect for the professional, downsizer, investor or first-time buyer."
+"AccessibilityFeatures": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "494.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-20T16:51:47.752843+00:00"
+"CrossStreet": "Bridge Street"
+"Directions": "Corner of Northfield Dr. E & Bridge St."
+"Exclusions": "Bedroom ceiling fan (will be replaces with a ceiling light) Free standing Fireplace."
+"ExpirationDate": "2026-07-31"
+"GarageYN": true
+"Inclusions": "Custom Island, Storage Locker, TV brackets, floating shelve in washroom, pendant island light."
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-20"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-20T15:19:47Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-20T15:19:47Z"
+"OriginalListPrice": 345000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3837428"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-20T15:19:47Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2990.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "#208"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=_DMy APWdm K0&t=4s"
+"Zoning": "RMU-20"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13019654')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"LockerUnit": "L1#56"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "L1"
+"HoldoverDays": 60
+"LegalStories": "level 2"
+"LockerNumber": "56"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 0H2, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 710
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "builder plan"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-04-20T15:19:47Z"
+"PropertyManagementCompany": "Five Rivers Property Management"
+"SystemModificationTimestamp": "2026-04-20T15:19:48.159266Z"
+"Media": array:37 [ …37]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4287
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13010006"
+"ListingId": "X13010006"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T15:03:10Z"
+"RFModificationTimestamp": "2026-04-30T05:01:47Z"
+"ListPrice": 448900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0K7"
+"UnparsedAddress": "145 Columbia Street W 1135, Waterloo, ON N2L 0K7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.47745
+"Longitude": -80.538415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Society 145, a brand-new luxury condominium in the heart of Waterloo, just steps from Wilfrid Laurier University and the University of Waterloo. This bright and thoughtfully designed 2-bedroom, 1-bathroom suite is ideal for student living or a savvy investment. Featuring Laminate floors, quartz countertops, stainless steel appliances, and stylish finishes throughout, the open-concept layout offers a modern and functional living space filled with natural light. The spacious den easily serves as a second bedroom, private study, or workspace. Offered fully furnished with Beds, Couch, Table, TV & more (see attached list). Residents enjoy premium amenities including a fitness centre, yoga studio, indoor basketball court, study rooms, business lounge, theatre, and games room. A perfect blend of luxury, convenience, and strong rental potential in one of Waterloo's most sought-after university locations. Pics are virtually staged to protect tenant's privacy."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "324.5"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"CoListOfficePhone": "905-568-2121"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-17T00:07:11.003219+00:00"
+"CrossStreet": "Columba St W/Phillip St"
+"Directions": "Columba St W/Phillip St"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "Stainless steel stove & fridge, B/I Dishwasher, OTR Microwave, Clothes Washer & Dryer, furniture, TV."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-16T23:07:15Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-16T23:07:15Z"
+"OriginalListPrice": 448900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3829606"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-16T23:07:16Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3140.71"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.00% of the sale price"
+"TransactionType": "For Sale"
+"UnitNumber": "1135"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13010006')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 30
+"LegalStories": "3"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 790
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"SquareFootSource": "546 sqft - MPAC"
+"PossessionDetails": "90 Days / TBA"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2026-04-16T23:07:16Z"
+"PropertyManagementCompany": "Craft Property Group"
+"SystemModificationTimestamp": "2026-04-20T15:03:13.880302Z"
+"Media": array:16 [ …16]
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4258
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4072
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12817032"
+"ListingId": "X12817032"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-30T10:46:14Z"
+"RFModificationTimestamp": "2026-04-30T10:50:04Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Ottawa Centre"
+"PostalCode": "K1R 0G1"
+"UnparsedAddress": "340 Queen Street 1101, Ottawa Centre, ON K1R 0G1"
+"Coordinates": array:2 [ …2]
+"Latitude": 53.067264
+"Longitude": -93.3321024
+"YearBuilt": 0
…102
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073 …128}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …129}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …123}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 …148}
]
+success: true
+page_size: 5
+page_count: 8226
+count: 41128
+after_key: ""
}
]
]
