Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=260&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=260&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=260&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=260&$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: "625315" +post_author: 1 +"ListingKey": "X12859372" +"ListingId": "X12859372" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-08T17:15:05Z" +"RFModificationTimestamp": "2026-04-29T06:17:10Z" +"ListPrice": 2160.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 0K8" +"UnparsedAddress": "298 Hemlock Street 618, Waterloo, ON N2L 0K8" +"Coordinates": array:2 [ …2] +"Latitude": 43.478334 +"Longitude": -80.533221 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 Heritage House Ltd." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Unit 618 at 298 Hemlock Street - modern living in the heart of Waterloo's university district. Just steps from Wilfrid Laurier University, the University of Waterloo, transit, dining, and everyday amenities, this location offers unbeatable convenience in a vibrant community. This 709 sq. ft. one-bedroom plus dining suite with two full bathrooms delivers a smart, functional layout designed for comfort and flexibility. The spacious bedroom is complemented by a dedicated dining area, ideal for entertaining, studying, or working from home, while the second bathroom adds rare convenience and privacy. The contemporary kitchen features granite countertops, full wood cabinetry, and sleek LED lighting, flowing seamlessly into the open-concept living space. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy atmosphere throughout. Efficient, modern, and exceptionally located - Unit 618 offers elevated urban living in one of Waterloo's most sought-after buildings." +"ArchitecturalStyle": "Other" +"AssociationAmenities": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-27T15:05:03.021492+00:00" +"CrossStreet": "Hickory and Hemlock" +"Directions": "Hickory and Hemlock" +"ExpirationDate": "2026-08-31" +"Furnished": "Partially" +"InteriorFeatures": "Other" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "36 Plus Months" +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-03-03" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2026-03-08T17:15:05Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-08T17:15:05Z" +"OriginalListPrice": 2160.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3614086" +"ParcelNumber": "223640305" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-08T17:15:05Z" +"PropertyAttachedYN": true +"RentIncludes": array:3 [ …3] +"RoomsTotal": "7" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "HEMLOCK" +"StreetNumber": "298" +"StreetSuffix": "Street" +"TaxBookNumber": "0000" +"TransactionBrokerCompensation": "half month rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "618" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12859372')" +"ElevatorYN": true +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604225001600" +"SurveyType": "None" +"BalconyType": "None" +"LegalStories": "6" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 0K8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-09-01" +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 1 +"RoomsBelowGrade": 1 +"SquareFootSource": "709" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LegalApartmentNumber": "618" +"MediaChangeTimestamp": "2026-03-08T17:15:05Z" +"PortionPropertyLease": array:1 [ …1] +"PropertyManagementCompany": "Prica Management Inc." +"SystemModificationTimestamp": "2026-03-08T17:15:05.538493Z" +"Media": array:23 [ …23] +"ID": "625315" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "453382" +post_author: 1 +"ListingKey": "X12431590" +"ListingId": "X12431590" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-07T17:18:08Z" +"RFModificationTimestamp": "2026-04-29T06:16:43Z" +"ListPrice": 1500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3R2" +"UnparsedAddress": "275 Larch Street 103, Waterloo, ON N2L 3R2" +"Coordinates": array:2 [ …2] +"Latitude": 43.477165 +"Longitude": -80.531342 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to The Block at 275 Larch Street, located right in the heart of Waterloos university district! This stylish and contemporary condo offers the perfect blend of comfort, convenience, and lifestyle. Spacious Layout Thoughtfully designed open-concept living and dining area with plenty of natural light. Modern Finishes Sleek kitchen with stainless steel appliances, quartz countertops, and ample cabinet space. Comfortable Living Bright bedroom(s), modern bathroom, and in-suite laundry for added convenience. Lifestyle Amenities Fitness center, lounge, study spaces, rooftop terrace, and more, all within the building. Prime Location Steps to Wilfrid Laurier University, University of Waterloo, Conestoga College Waterloo campus, public transit, restaurants, cafés, and shopping. This unit is perfect for students, young professionals, or anyone seeking a vibrant urban lifestyle in a prime Waterloo location." +"AccessibilityFeatures": array:3 [ …3] +"ArchitecturalStyle": "Apartment" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-27T15:21:37.499939+00:00" +"CrossStreet": "Hazel St & Hickory St" +"Directions": "Hazel St & Hickory St" +"ExpirationDate": "2026-07-31" +"Furnished": "Furnished" +"InteriorFeatures": "Accessory Apartment,Carpet Free" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-29" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-02-13T22:35:35Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-09-29T13:24:19Z" +"OriginalListPrice": 1750.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3056596" +"ParcelNumber": "236430269" +"ParkingFeatures": "None" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-29T13:24:19Z" +"PreviousListPrice": 1600.0 +"PriceChangeTimestamp": "2026-02-13T22:35:35Z" +"RentIncludes": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Larch" +"StreetNumber": "275" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "103" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12431590')" +"GarageType": "None" +"HeatSource": "Electric" +"RollNumber": "301604270001512" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "1" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3R2, CA" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Extension" +"WashroomsType1": 1 +"CondoCorpNumber": 643 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 3 +"RoomsBelowGrade": 1 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "MPAC" +"PossessionDetails": "ASAP" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ContactAfterExpiryYN": true +"LegalApartmentNumber": "103" +"MediaChangeTimestamp": "2026-03-07T17:18:08Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"ExtensionEntryTimestamp": "2026-01-16T14:31:46Z" +"PropertyManagementCompany": "CONDO PROPERTY MGMT" +"SystemModificationTimestamp": "2026-03-07T17:18:08.417347Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:1 [ …1] +"ID": "453382" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "616392" +post_author: 1 +"ListingKey": "X12729716" +"ListingId": "X12729716" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-26T17:29:48Z" +"RFModificationTimestamp": "2026-03-18T10:51:41Z" +"ListPrice": 340000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "308 Lester Street 619, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 42.5181529 +"Longitude": -92.3309047 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 308 Lester St, Waterloo - a modern 1-bedroom, 1-bath condo perfectly designed for rooftop terrace with stunning city views. A premium covered parking spot on the ground floor appliances and contemporary cabinetry, and in-suite laundry for ultimate convenience. The Located in the heart of Waterloo's university district, this condo is just steps from Wilfrid and parks. Whether you're looking for a comfortable place to live or a smart investment in a spacious bedroom offers ample closet space, while the private balcony provides the perfect near the rear entrance is included, making everyday living seamless. Enjoy access to premium building amenities, including a fitness center, party room, and spot to relax after a busy day. Laurier University, the University of Waterloo, public transit, shopping, restaurants, cafés, students, young professionals, and investors. This bright and stylish unit features an open concept layout with laminate flooring throughout, a sleek kitchen with stainless steel high-demand rental area, this condo checks all the boxes." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:2 [ …2] +"AssociationFee": "371.91" +"AssociationFeeIncludes": array:6 [ …6] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-17T05:16:38.132203+00:00" +"CrossStreet": "Lester/Columbia St W" +"Directions": "on columbia st w. turn south on Lester st." +"ExpirationDate": "2026-07-21" +"InteriorFeatures": "Separate Hydro Meter" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-25" +"LotSizeSource": "MPAC" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2026-01-26T17:29:48Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-26T17:29:48Z" +"OriginalListPrice": 340000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3480890" +"ParcelNumber": "236630202" +"ParkingFeatures": "Covered" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-26T17:29:48Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "308" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2418.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + hst" +"TransactionType": "For Sale" +"UnitNumber": "619" +"DDFYN": true +"Locker": "None" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12729716')" +"ElevatorYN": true +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604280008765" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 120 +"LegalStories": "6" +"ParkingSpot1": "54" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-01-27" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 633 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 1 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "PREVIOUS LISTING" +"PossessionDetails": "TENANTED BUT VACANT POSSESSION POSSIBLE" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "619" +"MediaChangeTimestamp": "2026-01-26T17:29:48Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-01-26T17:29:48.484003Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:25 [ …25] +"ID": "616392" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "455001" +post_author: 1 +"ListingKey": "X12448209" +"ListingId": "X12448209" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-11T15:26:00Z" +"RFModificationTimestamp": "2026-03-17T12:56:30Z" +"ListPrice": 769000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 6912.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 2S2" +"UnparsedAddress": "76 Elgin Crescent, Waterloo, ON N2J 2S2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AIMHOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great Investment Property In Desirable Uptown Waterloo, Steps To Uptown Waterloo, WLU, University of Waterloo, Conestoga College, Shopping, And The LRT. Perfect for Investors, Multi-generational Families, Or Parents Seeking Student Housing. Currently The Main Level Family Room Addition Is Used As The 4 Bedroom. License B With 4 Beds Is Currently Applied For Last 10 Years. If Owner Stay, You Can Apply License A ( Owner Plus 4). The Basement Bedroom Is Legal Bedroom Unit With Egress Window. Most Windows, Roof, Furnace, Ac, Water Softener Were Updated In 2012. Basement Fireplace Sold As It Is." +"ArchitecturalStyle": "Bungalow" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-03-17T12:29:19.531558+00:00" +"CrossStreet": "Brighton St And Noecker St" +"DirectionFaces": "North" +"Directions": "Brighton St" +"ExpirationDate": "2026-04-30" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, Stove, Water Softener, Washer, Dryer, All Windows Coverings, Light Fixtures." +"InteriorFeatures": "Water Softener,Water Heater,Water Meter,Primary Bedroom - Main Floor" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-06" +"LotSizeSource": "MPAC" +"MainOfficeKey": "090900" +"MajorChangeTimestamp": "2026-01-11T15:26:00Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-10-06T22:22:15Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3099524" +"ParcelNumber": "223690005" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-10-06T22:22:16Z" +"PoolFeatures": "None" +"PreviousListPrice": 799000.0 +"PriceChangeTimestamp": "2026-01-11T15:26:00Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Elgin" +"StreetNumber": "76" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "5052.0" +"TaxLegalDescription": "LT 41 PL 878 CITY OF WATERLOO; S/T 143975; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 128.0 +"LotWidth": 54.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12448209')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301601125001400" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2S2, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Extension" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 12 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-10-07T00:45:11Z" +"ExtensionEntryTimestamp": "2025-12-29T22:44:30Z" +"SystemModificationTimestamp": "2026-01-11T15:26:06.173359Z" +"Media": array:18 [ …18] +"ID": "455001" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "523598" +post_author: 1 +"ListingKey": "X12596864" +"ListingId": "X12596864" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-08T23:30:14Z" +"RFModificationTimestamp": "2026-03-18T13:13:31Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "253 Lester Street 101, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 42.5183242 +"Longitude": -92.3318544 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Room #1 - Vacant, #2 - Vacant, #3 Vacant, #4 - $750, Lease Ending 25th Aug, 2028, #5 - Vacant. Incredible turnkey investment in the heart of Waterloo's university district! This purpose-built 5-bedroom, 2-bathroom condo at 253 Lester St has the potential to generate over $49,000/year in gross rental income with positive monthly cash flow. Just steps to Wilfrid Laurier University and the University of Waterloo, this high-demand location ensures consistent tenancy. Features include a spacious open-concept living area, two full baths, included furniture, and professional property management options for a completely hands-off experience. Condo fees include heat and water, and the building offers parking, shared laundry, elevator access, and proximity to transit, shops, and amenities." +"ArchitecturalStyle": "Apartment" +"AssociationFee": "790.49" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"CoListOfficePhone": "905-568-2121" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-03-17T12:55:07.473725+00:00" +"CrossStreet": "University Ave W/Lester St" +"Directions": "University Ave W/Lester St" +"Exclusions": "Tenants Belongings" +"ExpirationDate": "2026-06-30" +"Inclusions": "Fridge, Stove, Hood Fan, B/I Dishwasher. All Elfs & Window Coverings" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-03" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-12-03T14:22:23Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-12-03T14:22:23Z" +"OriginalListPrice": 530000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3323202" +"ParkingFeatures": "Underground" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-12-03T14:22:24Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "253" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3809.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "101" +"DDFYN": true +"Locker": "None" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12596864')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604280005434" +"SurveyType": "Unknown" +"BalconyType": "None" +"RentalItems": "None" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 641 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 8 +"SquareFootSource": "MPAC" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "7" +"MediaChangeTimestamp": "2025-12-03T14:22:24Z" +"PropertyManagementCompany": "CIE Property Management" +"SystemModificationTimestamp": "2026-01-08T23:30:20.366309Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ …34] +"ID": "523598" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2849 +post_id: "537288" +post_author: 1 +"ListingKey": "X12644118" +"ListingId": "X12644118" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-08T23:00:17Z" +"RFModificationTimestamp": "2026-02-06T14:09:33Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 2A4" +"UnparsedAddress": "107 Weber Street S, Waterloo, ON N2J 2A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.4492975 +"Longitude": -80.4820032 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE PRG REAL ESTATE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A MUST SEE, BEAUTIFULLY RENOVATED, ALMOST 1500 SQ FT 4 BEDROOM RAISED BUNGALOW WITH +1 FINISHED BEDROOM ON THE WALKOUT LEVEL. TONS OF ADDITIONAL UNSPOILT SPACE TO FINISH AS A IN-LAW SUITE OR AS A RENTAL UNIT. 2 HUGE GARAGE SPACES AND EXTRA WIDE TRIPLE DRIVEWAY CAN ACCOMODATE 3 MORE CARS. THE FRONT OF THE HOME SITS RAISED MAJESTICALLY OF THE STREET LEVEL. LOTS OF UPGRADES ON THE MAIN FLOOR INCLUDING UPDATED/NEW WASHROOMS, INTERIOR & EXTERIOR POTLIFHTS, NEW LAMINATE COUNTERTOP IN THE KITCHEN, SEVERAL UPGRADED ELF'S FRESH PAINT IN THE KITCHEN & LIVING ROOM. BRILLIAN LOCATION CLOSE TO THE UNIVERSITY OF WATERLOO, WILFRED LAURIER, CONESTOGA. WHY RENT WHEN YOU CAN BE A LANDLOR AND RENT TO STUDENTS (WITH DUE CITY PERMITS) SAVE THOUSANDS $$$ ON ZONING FEES AS THIS HOME IS ZONED RMU(RESIDENTIAL MIXED USE) WHICH MEANS YOU CAN RUN VARIOUS BUSINESS ES FROM THIS LOCATION JUST BY GETTING A BUSINESS LICENCE FROM THE CITY AT A NOMINAL FEE. MANY PERMITTED USES INCL AND NOT LIMTED TO AIR BNB, DRYCLEANERS, HAIR SALON, PET SERVICES, CAFE, LAW OFFICE, DENTAL OFFICE, LAUNDRY SERVICES" +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Other" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-02-04T08:03:40.652079+00:00" +"CrossStreet": "Bristol St to Weber St S" +"DirectionFaces": "East" +"Directions": "Weber St and Bristol" +"Exclusions": "FRIDGES IN THE BASEMENT, CAMERA UNITS INSTALLED OUTSIDE THE HOME." +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "STOVE, FRIDGE, WASHER, DRYER" +"InteriorFeatures": "In-Law Capability,Storage,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "445000" +"MajorChangeTimestamp": "2025-12-19T23:05:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-19T23:05:50Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3371986" +"ParcelNumber": "223460065" +"ParkingFeatures": "Available" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-12-27T20:24:25Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Weber" +"StreetNumber": "107" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4437.96" +"TaxLegalDescription": "Lot 58 PL 783 City of Waterloo" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.16 +"LotWidth": 71.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12644118')" +"GarageType": "Attached" +"HeatSource": "Other" +"RollNumber": "301602155003900" +"SurveyType": "Unknown" +"RentalItems": "HOT WATER TANK, FURNACE, HEAT PUMP, WATER SOFTENER" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2A4, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 1 +"LotIrregularities": "71.60ft 130.22ft 100.16ft 65.11ft" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-12-27T20:24:25Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-01-08T23:00:22.460951Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:32 [ …32] +"ID": "537288" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "566264" +post_author: 1 +"ListingKey": "X12658724" +"ListingId": "X12658724" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-03T18:10:41Z" +"RFModificationTimestamp": "2026-03-01T15:28:04Z" +"ListPrice": 580900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0J3" +"UnparsedAddress": "410 Northfield Drive W E5, Waterloo, ON N2V 0J3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4956785 +"Longitude": -80.549881 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY FAISAL SUSIWALA REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "ARBOUR PARK - MODEL HOME- THE TALK OF THE TOWN! Presenting new stacked townhomes in a prime North Waterloo location, adjacent to the tranquil Laurel Creek Conservation Area. Choose from 8 distinctive designs, including spacious one- and two-bedroom layouts, all enhanced with contemporary finishes. Convenient access to major highways including Highway 85, ensuring quick connectivity to the 401 for effortless commutes. Enjoy proximity to parks, schools, shopping, and dining, catering to your every need. Introducing the Sycamore 2-storey model: experience 1080sqft of thoughtfully designed living space, featuring 2 spacious bedrooms, 2.5 bathrooms with modern finishes including a primary ensuite, and 2 private balconies. Nestled in a prestigious and tranquil mature neighbourhood, Arbour Park is the epitome of desirable living in Waterloo- come see why! ONLY 10% DEPOSIT. CLOSING 2026!" +"ArchitecturalStyle": "Stacked Townhouse" +"AssociationFee": "324.0" +"AssociationFeeIncludes": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Other" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-20T03:30:50.435627+00:00" +"CrossStreet": "WESTMOUNT RD/WEBER ST N" +"Directions": "WESTMOUNT RD/WEBER ST N" +"ExpirationDate": "2026-06-05" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-02" +"MainOfficeKey": "346400" +"MajorChangeTimestamp": "2026-01-03T18:10:41Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-03T18:10:41Z" +"OriginalListPrice": 580900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3393388" +"ParcelNumber": "222620438" +"ParkingFeatures": "Reserved/Assigned" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-03T18:10:41Z" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Northfield" +"StreetNumber": "410" +"StreetSuffix": "Drive" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST ON BASE PRICE NOT INCLUDING HST" +"TransactionType": "For Sale" +"UnitNumber": "e5" +"Zoning": "R8" +"DDFYN": true +"Locker": "None" +"Exposure": "South East" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12658724')" +"GarageType": "None" +"HeatSource": "Other" +"RollNumber": "301604240508702" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "HWT-Electric" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0J3, CA" +"ApproximateAge": "New" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"SquareFootSource": "ATTACHED FLOORPLAN" +"PossessionDetails": "2026" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay or call listing brokerage" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"LegalApartmentNumber": "e5" +"MediaChangeTimestamp": "2026-01-03T18:10:41Z" +"PropertyManagementCompany": "TBD" +"SystemModificationTimestamp": "2026-01-03T18:10:41.327447Z" +"Media": array:24 [ …24] +"ID": "566264" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "546372" +post_author: 1 +"ListingKey": "X12656246" +"ListingId": "X12656246" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-02T18:38:37Z" +"RFModificationTimestamp": "2026-02-20T05:41:14Z" +"ListPrice": 419900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3V9" +"UnparsedAddress": "258b Sunview Street 279, Waterloo, ON N2L 3V9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4745629 +"Longitude": -80.5333202 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Excellent Investment. Completely Furnished Apartment By Builders... Ask For Building Feature, Interior Amenities, Outdoor, Rooftop Amenities, Suit Features Suite Kitchen And Many More Details. Internal And External Bicycle Parking...Private Outdoor Lounge Area. Impress Your Clients. Very Near To University Of Waterloo And Wilfred Laurier University Campuses. Buyer Agent Must Verify Details." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:4 [ …4] +"AssociationFee": "323.75" +"AssociationFeeIncludes": array:4 [ …4] +"AssociationYN": true +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-20T03:41:39.645954+00:00" +"CrossStreet": "Sunview St. / University Ave.W" +"Directions": "Sunview St. / University Ave.W" +"ExpirationDate": "2026-07-31" +"HeatingYN": true +"Inclusions": "Completely Furnished Unit With All Appliances. Furniture Included." +"InteriorFeatures": "Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-01" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-01-02T16:21:39Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-02T16:21:39Z" +"OriginalListPrice": 419900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3389784" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-02T16:21:39Z" +"PropertyAttachedYN": true +"RoomsTotal": "5" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sunview" +"StreetNumber": "258B" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3004.6" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "279" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12656246')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "7" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3V9, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 666 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 5 +"SquareFootSource": "AS PER SELLER" +"StreetSuffixCode": "St" +"BoardPropertyType": "Condo" +"PossessionDetails": "30days" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"LegalApartmentNumber": "9" +"MediaChangeTimestamp": "2026-01-02T16:21:39Z" +"MLSAreaDistrictOldZone": "X11" +"PropertyManagementCompany": "WILSON BLANCHARD" +"MLSAreaMunicipalityDistrict": "Waterloo" +"SystemModificationTimestamp": "2026-01-02T18:38:37.195267Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] +"ID": "546372" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "442023" +post_author: 1 +"ListingKey": "X12309085" +"ListingId": "X12309085" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-30T23:56:11Z" +"RFModificationTimestamp": "2026-02-28T06:33:39Z" +"ListPrice": 9999999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 38000.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1V6" +"UnparsedAddress": "205-209 Erb Street W, Waterloo, ON N2L 1V6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4546815 +"Longitude": -80.5471272 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 B.J. ROTH REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This land assembly, totaling 0.89 acres, presents a compelling development potential opportunity with 3 existing income-generating properties situated in the heart of Waterloos energetic uptown core. In 2024, a development concept was brought forward to the City of Waterloo, outlining a 12-story residential apartment building with 129 units. The plan includes 17 parking spaces located at grade behind the building, complemented by additional underground parking whose quantity has yet to be specified. The project adheres to the area's zoning regulations and complies with both the Official Plan and applicable Zoning By-Laws, including matching the scale and height of surrounding developments. This prime location lies within one of Waterloos most desirable neighborhoods and falls inside the Willis Way Protected Major Transit Station Area (PMTSA), where minimum parking requirements are waived under Bill 185. The vision for the residential development centers around connected urban living, offering future residents immediate access to restaurants, boutiques, entertainment, and cultural attractions. With nearby schools, green spaces, institutions, and modern infrastructure enhancements, this site is exceptionally well-positioned to benefit from long-term growth, sustained demand, and increasing value. The seller and their representative make no guarantees about the property's future use or development potential regardless of any of the favorable information noted. The buyer is fully responsible for investigating all current and future matters related to the property and future development. Image of the 12 story building in the listing is merely a virtual rendering to help give some perspective on what may be possible." +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-26T22:47:09.547263+00:00" +"CrossStreet": "ERB ST W/WESTMOUNT RD S." +"DirectionFaces": "South" +"Directions": "North on Westmount SRd S turn Right on Erb St W" +"ExpirationDate": "2026-07-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-25" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "074700" +"MajorChangeTimestamp": "2025-12-30T23:56:11Z" +"MlsStatus": "Extension" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-26T13:55:45Z" +"OriginalListPrice": 10980000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2701080" +"ParcelNumber": "224080010" +"PhotosChangeTimestamp": "2025-07-26T13:55:46Z" +"PreviousListPrice": 10980000.0 +"PriceChangeTimestamp": "2025-10-01T14:15:10Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "205-209" +"StreetSuffix": "Street" +"TaxAnnualAmount": "15935.7" +"TaxLegalDescription": "PT LT 42 PL 496 CITY OF WATERLOO AS IN 743232 EXCEPT PT 21, 58EX438; S/T 943478; WATERLOO; PT LT 42 PL 496 CITY OF WATERLOO AS IN 743164 EXCEPT PT 19, 58EX438; WATERLOO; PT LT 42 PL 496 CITY OF WATERLOO AS IN 779127 EXCEPT PT 17, 58EX438; S/T 943478; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4% + HST" +"TransactionType": "For Sale" +"Zoning": "RMU-40" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 287.57 +"LotWidth": 130.62 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12309085')" +"RollNumber": "301603080005000" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 60 +"TelephoneYNA": "Available" +"ParcelNumber2": 224080009 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1V6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"LotSizeAreaUnits": "Square Feet" +"LotSizeRangeAcres": "Not Applicable" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-07-26T13:55:46Z" +"ExtensionEntryTimestamp": "2025-12-30T23:56:11Z" +"SystemModificationTimestamp": "2025-12-30T23:56:11.10841Z" +"Media": array:9 [ …9] +"ID": "442023" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "544408" +post_author: 1 +"ListingKey": "X12651498" +"ListingId": "X12651498" +"PropertyType": "Residential" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-30T15:09:58Z" +"RFModificationTimestamp": "2026-03-09T07:17:53Z" +"ListPrice": 438800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 0E9" +"UnparsedAddress": "318 Spruce Street 1601, Waterloo, ON N2L 0E9" +"Coordinates": array:2 [ …2] +"Latitude": 43.478945 +"Longitude": -80.526435 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/FUTURE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible Opportunity to Own a modern and Spacious 1 Bedroom + Den, Unit In One Of Waterloos' Most Sought-After Convenient Locations!. Its A Prime Investment For Student Housing , Small Family or Professionals. Close To Hwy 85, The LRT,steps away from Wilfred Laurier & Minutes to University of Waterloo. Floor to ceiling large windows in Living and Bed room with Long Open Balcony with breath taking City View. Ensuite 4 Pc Washroom and another 1.5 Washroom for added Convenience. Sleek Kitchen with stainless steel Appliances including a B/I Dishwasher and granite Countertop. Lots of Storage Cabinets. Spacious den can be used as a 2nd bedroom or as Office room. One parking space underground. Amenities includes a Nice GYM, Guest Suite, Meeting/Party Room Lounge. Rooftop Deck/Garden, Visitor Parking. Theatre Room, A Guest Suite, Lounge Room Walking Distance to Walmart, No Frills, Many Cafes & Restaurants & Cinema, Public Transit. Conestoga Waterloo Campus, Which Is 1.5 Km From The Building. WHY WAIT, COME BUY AND CALL IT YOUR HOME!! Motivated Seller. Flexible Closing." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:3 [ …3] +"AssociationFee": "483.03" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"BuildingName": "Sage 2" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-09T02:25:26.622009+00:00" +"CrossStreet": "King / University" +"Directions": "King / University" +"ExpirationDate": "2026-05-29" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Carpet Free" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-29" +"MainOfficeKey": "104000" +"MajorChangeTimestamp": "2025-12-29T15:07:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-29T15:07:16Z" +"OriginalListPrice": 438800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3381344" +"ParkingFeatures": "Underground" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-12-29T15:07:17Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Spruce" +"StreetNumber": "318" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3919.05" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.75% + HST" +"TransactionType": "For Sale" +"UnitNumber": "1601" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://sites.sjvirtualtours.ca/318-Spruce-St-unit-1601/idx" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12651498')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "16" +"ParkingSpot1": "B10" +"ParkingType1": "Exclusive" +"ParkingType2": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 0E9, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-02-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 624 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "As Per Seller" +"ParkingLevelUnit1": "2" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "1" +"MediaChangeTimestamp": "2025-12-29T15:07:17Z" +"DevelopmentChargesPaid": array:1 [ …1] +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-12-30T15:10:01.718525Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:24 [ …24] +"ID": "544408" } ] +success: true +page_size: 10 +page_count: 29 +count: 285 +after_key: "" } "RF Response Time" => "0.26 seconds" ] "RF Cache Key: d9c6697307711b6caf465abd062fc70ee5d9f8a69118e301f0922d72fa36ae90" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3093 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4288 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12859372" +"ListingId": "X12859372" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-08T17:15:05Z" +"RFModificationTimestamp": "2026-04-29T06:17:10Z" +"ListPrice": 2160.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 0K8" +"UnparsedAddress": "298 Hemlock Street 618, Waterloo, ON N2L 0K8" +"Coordinates": array:2 [ …2] +"Latitude": 43.478334 +"Longitude": -80.533221 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 Heritage House Ltd." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Unit 618 at 298 Hemlock Street - modern living in the heart of Waterloo's university district. Just steps from Wilfrid Laurier University, the University of Waterloo, transit, dining, and everyday amenities, this location offers unbeatable convenience in a vibrant community. This 709 sq. ft. one-bedroom plus dining suite with two full bathrooms delivers a smart, functional layout designed for comfort and flexibility. The spacious bedroom is complemented by a dedicated dining area, ideal for entertaining, studying, or working from home, while the second bathroom adds rare convenience and privacy. The contemporary kitchen features granite countertops, full wood cabinetry, and sleek LED lighting, flowing seamlessly into the open-concept living space. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy atmosphere throughout. Efficient, modern, and exceptionally located - Unit 618 offers elevated urban living in one of Waterloo's most sought-after buildings." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-27T15:05:03.021492+00:00" +"CrossStreet": "Hickory and Hemlock" +"Directions": "Hickory and Hemlock" +"ExpirationDate": "2026-08-31" +"Furnished": "Partially" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "36 Plus Months" +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2026-03-03" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2026-03-08T17:15:05Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-08T17:15:05Z" +"OriginalListPrice": 2160.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3614086" +"ParcelNumber": "223640305" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-08T17:15:05Z" +"PropertyAttachedYN": true +"RentIncludes": array:3 [ …3] +"RoomsTotal": "7" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "HEMLOCK" +"StreetNumber": "298" +"StreetSuffix": "Street" +"TaxBookNumber": "0000" +"TransactionBrokerCompensation": "half month rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "618" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12859372')" +"ElevatorYN": true +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604225001600" +"SurveyType": "None" +"BalconyType": "None" +"LegalStories": "6" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 0K8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-09-01" +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 1 +"RoomsBelowGrade": 1 +"SquareFootSource": "709" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LegalApartmentNumber": "618" +"MediaChangeTimestamp": "2026-03-08T17:15:05Z" +"PortionPropertyLease": array:1 [ …1] +"PropertyManagementCompany": "Prica Management Inc." +"SystemModificationTimestamp": "2026-03-08T17:15:05.538493Z" +"Media": array:23 [ …23] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4289 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12431590" +"ListingId": "X12431590" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-07T17:18:08Z" +"RFModificationTimestamp": "2026-04-29T06:16:43Z" +"ListPrice": 1500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3R2" +"UnparsedAddress": "275 Larch Street 103, Waterloo, ON N2L 3R2" +"Coordinates": array:2 [ …2] +"Latitude": 43.477165 +"Longitude": -80.531342 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to The Block at 275 Larch Street, located right in the heart of Waterloos university district! This stylish and contemporary condo offers the perfect blend of comfort, convenience, and lifestyle. Spacious Layout Thoughtfully designed open-concept living and dining area with plenty of natural light. Modern Finishes Sleek kitchen with stainless steel appliances, quartz countertops, and ample cabinet space. Comfortable Living Bright bedroom(s), modern bathroom, and in-suite laundry for added convenience. Lifestyle Amenities Fitness center, lounge, study spaces, rooftop terrace, and more, all within the building. Prime Location Steps to Wilfrid Laurier University, University of Waterloo, Conestoga College Waterloo campus, public transit, restaurants, cafés, and shopping. This unit is perfect for students, young professionals, or anyone seeking a vibrant urban lifestyle in a prime Waterloo location." +"AccessibilityFeatures": array:3 [ …3] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-04-27T15:21:37.499939+00:00" +"CrossStreet": "Hazel St & Hickory St" +"Directions": "Hazel St & Hickory St" +"ExpirationDate": "2026-07-31" +"Furnished": "Furnished" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-29" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2026-02-13T22:35:35Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-09-29T13:24:19Z" +"OriginalListPrice": 1750.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3056596" +"ParcelNumber": "236430269" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-09-29T13:24:19Z" +"PreviousListPrice": 1600.0 +"PriceChangeTimestamp": "2026-02-13T22:35:35Z" +"RentIncludes": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Larch" +"StreetNumber": "275" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "103" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12431590')" +"GarageType": "None" +"HeatSource": "Electric" +"RollNumber": "301604270001512" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "1" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3R2, CA" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Extension" +"WashroomsType1": 1 +"CondoCorpNumber": 643 +"DenFamilyroomYN": true +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 3 +"RoomsBelowGrade": 1 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"SquareFootSource": "MPAC" +"PossessionDetails": "ASAP" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"ContactAfterExpiryYN": true +"LegalApartmentNumber": "103" +"MediaChangeTimestamp": "2026-03-07T17:18:08Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"ExtensionEntryTimestamp": "2026-01-16T14:31:46Z" +"PropertyManagementCompany": "CONDO PROPERTY MGMT" +"SystemModificationTimestamp": "2026-03-07T17:18:08.417347Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:1 [ …1] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4292 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12729716" +"ListingId": "X12729716" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-26T17:29:48Z" +"RFModificationTimestamp": "2026-03-18T10:51:41Z" +"ListPrice": 340000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "308 Lester Street 619, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 42.5181529 +"Longitude": -92.3309047 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 308 Lester St, Waterloo - a modern 1-bedroom, 1-bath condo perfectly designed for rooftop terrace with stunning city views. A premium covered parking spot on the ground floor appliances and contemporary cabinetry, and in-suite laundry for ultimate convenience. The Located in the heart of Waterloo's university district, this condo is just steps from Wilfrid and parks. Whether you're looking for a comfortable place to live or a smart investment in a spacious bedroom offers ample closet space, while the private balcony provides the perfect near the rear entrance is included, making everyday living seamless. Enjoy access to premium building amenities, including a fitness center, party room, and spot to relax after a busy day. Laurier University, the University of Waterloo, public transit, shopping, restaurants, cafés, students, young professionals, and investors. This bright and stylish unit features an open concept layout with laminate flooring throughout, a sleek kitchen with stainless steel high-demand rental area, this condo checks all the boxes." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:2 [ …2] +"AssociationFee": "371.91" +"AssociationFeeIncludes": array:6 [ …6] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-17T05:16:38.132203+00:00" +"CrossStreet": "Lester/Columbia St W" +"Directions": "on columbia st w. turn south on Lester st." +"ExpirationDate": "2026-07-21" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-25" +"LotSizeSource": "MPAC" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2026-01-26T17:29:48Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-26T17:29:48Z" +"OriginalListPrice": 340000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3480890" +"ParcelNumber": "236630202" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-26T17:29:48Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "308" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2418.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + hst" +"TransactionType": "For Sale" +"UnitNumber": "619" +"DDFYN": true +"Locker": "None" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12729716')" +"ElevatorYN": true +"GarageType": "Surface" +"HeatSource": "Gas" +"RollNumber": "301604280008765" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 120 +"LegalStories": "6" +"ParkingSpot1": "54" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-01-27" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 633 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 1 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "PREVIOUS LISTING" +"PossessionDetails": "TENANTED BUT VACANT POSSESSION POSSIBLE" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "619" +"MediaChangeTimestamp": "2026-01-26T17:29:48Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2026-01-26T17:29:48.484003Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:25 [ …25] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12448209" +"ListingId": "X12448209" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-11T15:26:00Z" +"RFModificationTimestamp": "2026-03-17T12:56:30Z" +"ListPrice": 769000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 6912.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 2S2" +"UnparsedAddress": "76 Elgin Crescent, Waterloo, ON N2J 2S2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AIMHOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great Investment Property In Desirable Uptown Waterloo, Steps To Uptown Waterloo, WLU, University of Waterloo, Conestoga College, Shopping, And The LRT. Perfect for Investors, Multi-generational Families, Or Parents Seeking Student Housing. Currently The Main Level Family Room Addition Is Used As The 4 Bedroom. License B With 4 Beds Is Currently Applied For Last 10 Years. If Owner Stay, You Can Apply License A ( Owner Plus 4). The Basement Bedroom Is Legal Bedroom Unit With Egress Window. Most Windows, Roof, Furnace, Ac, Water Softener Were Updated In 2012. Basement Fireplace Sold As It Is." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-03-17T12:29:19.531558+00:00" +"CrossStreet": "Brighton St And Noecker St" +"DirectionFaces": "North" +"Directions": "Brighton St" +"ExpirationDate": "2026-04-30" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Fridge, Stove, Water Softener, Washer, Dryer, All Windows Coverings, Light Fixtures." +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-06" +"LotSizeSource": "MPAC" +"MainOfficeKey": "090900" +"MajorChangeTimestamp": "2026-01-11T15:26:00Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-10-06T22:22:15Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3099524" +"ParcelNumber": "223690005" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-10-06T22:22:16Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 799000.0 +"PriceChangeTimestamp": "2026-01-11T15:26:00Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Elgin" +"StreetNumber": "76" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "5052.0" +"TaxLegalDescription": "LT 41 PL 878 CITY OF WATERLOO; S/T 143975; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 128.0 +"LotWidth": 54.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12448209')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301601125001400" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2S2, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-05-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Extension" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 12 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-10-07T00:45:11Z" +"ExtensionEntryTimestamp": "2025-12-29T22:44:30Z" +"SystemModificationTimestamp": "2026-01-11T15:26:06.173359Z" +"Media": array:18 [ …18] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12596864" +"ListingId": "X12596864" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-08T23:30:14Z" +"RFModificationTimestamp": "2026-03-18T13:13:31Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "253 Lester Street 101, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ …2] +"Latitude": 42.5183242 +"Longitude": -92.3318544 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Room #1 - Vacant, #2 - Vacant, #3 Vacant, #4 - $750, Lease Ending 25th Aug, 2028, #5 - Vacant. Incredible turnkey investment in the heart of Waterloo's university district! This purpose-built 5-bedroom, 2-bathroom condo at 253 Lester St has the potential to generate over $49,000/year in gross rental income with positive monthly cash flow. Just steps to Wilfrid Laurier University and the University of Waterloo, this high-demand location ensures consistent tenancy. Features include a spacious open-concept living area, two full baths, included furniture, and professional property management options for a completely hands-off experience. Condo fees include heat and water, and the building offers parking, shared laundry, elevator access, and proximity to transit, shops, and amenities." +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "790.49" +"AssociationFeeIncludes": array:5 [ …5] +"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-03-17T12:55:07.473725+00:00" +"CrossStreet": "University Ave W/Lester St" +"Directions": "University Ave W/Lester St" +"Exclusions": "Tenants Belongings" +"ExpirationDate": "2026-06-30" +"Inclusions": "Fridge, Stove, Hood Fan, B/I Dishwasher. All Elfs & Window Coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-03" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-12-03T14:22:23Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-12-03T14:22:23Z" +"OriginalListPrice": 530000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3323202" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-12-03T14:22:24Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "253" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3809.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "101" +"DDFYN": true +"Locker": "None" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12596864')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604280005434" +"SurveyType": "Unknown" +"BalconyType": "None" +"RentalItems": "None" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 641 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 8 +"SquareFootSource": "MPAC" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "7" +"MediaChangeTimestamp": "2025-12-03T14:22:24Z" +"PropertyManagementCompany": "CIE Property Management" +"SystemModificationTimestamp": "2026-01-08T23:30:20.366309Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ …34] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4287 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12644118" +"ListingId": "X12644118" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-08T23:00:17Z" +"RFModificationTimestamp": "2026-02-06T14:09:33Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 2A4" +"UnparsedAddress": "107 Weber Street S, Waterloo, ON N2J 2A4" +"Coordinates": array:2 [ …2] +"Latitude": 43.4492975 +"Longitude": -80.4820032 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE PRG REAL ESTATE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A MUST SEE, BEAUTIFULLY RENOVATED, ALMOST 1500 SQ FT 4 BEDROOM RAISED BUNGALOW WITH +1 FINISHED BEDROOM ON THE WALKOUT LEVEL. TONS OF ADDITIONAL UNSPOILT SPACE TO FINISH AS A IN-LAW SUITE OR AS A RENTAL UNIT. 2 HUGE GARAGE SPACES AND EXTRA WIDE TRIPLE DRIVEWAY CAN ACCOMODATE 3 MORE CARS. THE FRONT OF THE HOME SITS RAISED MAJESTICALLY OF THE STREET LEVEL. LOTS OF UPGRADES ON THE MAIN FLOOR INCLUDING UPDATED/NEW WASHROOMS, INTERIOR & EXTERIOR POTLIFHTS, NEW LAMINATE COUNTERTOP IN THE KITCHEN, SEVERAL UPGRADED ELF'S FRESH PAINT IN THE KITCHEN & LIVING ROOM. BRILLIAN LOCATION CLOSE TO THE UNIVERSITY OF WATERLOO, WILFRED LAURIER, CONESTOGA. WHY RENT WHEN YOU CAN BE A LANDLOR AND RENT TO STUDENTS (WITH DUE CITY PERMITS) SAVE THOUSANDS $$$ ON ZONING FEES AS THIS HOME IS ZONED RMU(RESIDENTIAL MIXED USE) WHICH MEANS YOU CAN RUN VARIOUS BUSINESS ES FROM THIS LOCATION JUST BY GETTING A BUSINESS LICENCE FROM THE CITY AT A NOMINAL FEE. MANY PERMITTED USES INCL AND NOT LIMTED TO AIR BNB, DRYCLEANERS, HAIR SALON, PET SERVICES, CAFE, LAW OFFICE, DENTAL OFFICE, LAUNDRY SERVICES" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-02-04T08:03:40.652079+00:00" +"CrossStreet": "Bristol St to Weber St S" +"DirectionFaces": "East" +"Directions": "Weber St and Bristol" +"Exclusions": "FRIDGES IN THE BASEMENT, CAMERA UNITS INSTALLED OUTSIDE THE HOME." +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "STOVE, FRIDGE, WASHER, DRYER" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "445000" +"MajorChangeTimestamp": "2025-12-19T23:05:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-19T23:05:50Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3371986" +"ParcelNumber": "223460065" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-12-27T20:24:25Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Weber" +"StreetNumber": "107" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4437.96" +"TaxLegalDescription": "Lot 58 PL 783 City of Waterloo" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.16 +"LotWidth": 71.6 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12644118')" +"GarageType": "Attached" +"HeatSource": "Other" +"RollNumber": "301602155003900" +"SurveyType": "Unknown" +"RentalItems": "HOT WATER TANK, FURNACE, HEAT PUMP, WATER SOFTENER" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 2A4, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 1 +"LotIrregularities": "71.60ft 130.22ft 100.16ft 65.11ft" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-12-27T20:24:25Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-01-08T23:00:22.460951Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:32 [ …32] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4286 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12658724" +"ListingId": "X12658724" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-03T18:10:41Z" +"RFModificationTimestamp": "2026-03-01T15:28:04Z" +"ListPrice": 580900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0J3" +"UnparsedAddress": "410 Northfield Drive W E5, Waterloo, ON N2V 0J3" +"Coordinates": array:2 [ …2] +"Latitude": 43.4956785 +"Longitude": -80.549881 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY FAISAL SUSIWALA REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "ARBOUR PARK - MODEL HOME- THE TALK OF THE TOWN! Presenting new stacked townhomes in a prime North Waterloo location, adjacent to the tranquil Laurel Creek Conservation Area. Choose from 8 distinctive designs, including spacious one- and two-bedroom layouts, all enhanced with contemporary finishes. Convenient access to major highways including Highway 85, ensuring quick connectivity to the 401 for effortless commutes. Enjoy proximity to parks, schools, shopping, and dining, catering to your every need. Introducing the Sycamore 2-storey model: experience 1080sqft of thoughtfully designed living space, featuring 2 spacious bedrooms, 2.5 bathrooms with modern finishes including a primary ensuite, and 2 private balconies. Nestled in a prestigious and tranquil mature neighbourhood, Arbour Park is the epitome of desirable living in Waterloo- come see why! ONLY 10% DEPOSIT. CLOSING 2026!" +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "324.0" +"AssociationFeeIncludes": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-20T03:30:50.435627+00:00" +"CrossStreet": "WESTMOUNT RD/WEBER ST N" +"Directions": "WESTMOUNT RD/WEBER ST N" +"ExpirationDate": "2026-06-05" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-02" +"MainOfficeKey": "346400" +"MajorChangeTimestamp": "2026-01-03T18:10:41Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-03T18:10:41Z" +"OriginalListPrice": 580900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3393388" +"ParcelNumber": "222620438" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-03T18:10:41Z" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Northfield" +"StreetNumber": "410" +"StreetSuffix": "Drive" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST ON BASE PRICE NOT INCLUDING HST" +"TransactionType": "For Sale" +"UnitNumber": "e5" +"Zoning": "R8" +"DDFYN": true +"Locker": "None" +"Exposure": "South East" +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12658724')" +"GarageType": "None" +"HeatSource": "Other" +"RollNumber": "301604240508702" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "HWT-Electric" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2V 0J3, CA" +"ApproximateAge": "New" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"SquareFootSource": "ATTACHED FLOORPLAN" +"PossessionDetails": "2026" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Brokerbay or call listing brokerage" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"LegalApartmentNumber": "e5" +"MediaChangeTimestamp": "2026-01-03T18:10:41Z" +"PropertyManagementCompany": "TBD" +"SystemModificationTimestamp": "2026-01-03T18:10:41.327447Z" +"Media": array:24 [ …24] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4285 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12656246" +"ListingId": "X12656246" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-02T18:38:37Z" +"RFModificationTimestamp": "2026-02-20T05:41:14Z" +"ListPrice": 419900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3V9" +"UnparsedAddress": "258b Sunview Street 279, Waterloo, ON N2L 3V9" +"Coordinates": array:2 [ …2] +"Latitude": 43.4745629 +"Longitude": -80.5333202 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Excellent Investment. Completely Furnished Apartment By Builders... Ask For Building Feature, Interior Amenities, Outdoor, Rooftop Amenities, Suit Features Suite Kitchen And Many More Details. Internal And External Bicycle Parking...Private Outdoor Lounge Area. Impress Your Clients. Very Near To University Of Waterloo And Wilfred Laurier University Campuses. Buyer Agent Must Verify Details." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:4 [ …4] +"AssociationFee": "323.75" +"AssociationFeeIncludes": array:4 [ …4] +"AssociationYN": true +"Basement": array:1 [ …1] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-20T03:41:39.645954+00:00" +"CrossStreet": "Sunview St. / University Ave.W" +"Directions": "Sunview St. / University Ave.W" +"ExpirationDate": "2026-07-31" +"HeatingYN": true +"Inclusions": "Completely Furnished Unit With All Appliances. Furniture Included." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-01" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2026-01-02T16:21:39Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-02T16:21:39Z" +"OriginalListPrice": 419900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3389784" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-01-02T16:21:39Z" +"PropertyAttachedYN": true +"RoomsTotal": "5" +"ShowingRequirements": array:3 [ …3] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sunview" +"StreetNumber": "258B" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3004.6" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "279" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12656246')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "7" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3V9, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 666 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 5 +"SquareFootSource": "AS PER SELLER" +"StreetSuffixCode": "St" +"BoardPropertyType": "Condo" +"PossessionDetails": "30days" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"LegalApartmentNumber": "9" +"MediaChangeTimestamp": "2026-01-02T16:21:39Z" +"MLSAreaDistrictOldZone": "X11" +"PropertyManagementCompany": "WILSON BLANCHARD" +"MLSAreaMunicipalityDistrict": "Waterloo" +"SystemModificationTimestamp": "2026-01-02T18:38:37.195267Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ …13] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4284 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12309085" +"ListingId": "X12309085" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-30T23:56:11Z" +"RFModificationTimestamp": "2026-02-28T06:33:39Z" +"ListPrice": 9999999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 38000.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 1V6" +"UnparsedAddress": "205-209 Erb Street W, Waterloo, ON N2L 1V6" +"Coordinates": array:2 [ …2] +"Latitude": 43.4546815 +"Longitude": -80.5471272 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 B.J. ROTH REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This land assembly, totaling 0.89 acres, presents a compelling development potential opportunity with 3 existing income-generating properties situated in the heart of Waterloos energetic uptown core. In 2024, a development concept was brought forward to the City of Waterloo, outlining a 12-story residential apartment building with 129 units. The plan includes 17 parking spaces located at grade behind the building, complemented by additional underground parking whose quantity has yet to be specified. The project adheres to the area's zoning regulations and complies with both the Official Plan and applicable Zoning By-Laws, including matching the scale and height of surrounding developments. This prime location lies within one of Waterloos most desirable neighborhoods and falls inside the Willis Way Protected Major Transit Station Area (PMTSA), where minimum parking requirements are waived under Bill 185. The vision for the residential development centers around connected urban living, offering future residents immediate access to restaurants, boutiques, entertainment, and cultural attractions. With nearby schools, green spaces, institutions, and modern infrastructure enhancements, this site is exceptionally well-positioned to benefit from long-term growth, sustained demand, and increasing value. The seller and their representative make no guarantees about the property's future use or development potential regardless of any of the favorable information noted. The buyer is fully responsible for investigating all current and future matters related to the property and future development. Image of the 12 story building in the listing is merely a virtual rendering to help give some perspective on what may be possible." +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-26T22:47:09.547263+00:00" +"CrossStreet": "ERB ST W/WESTMOUNT RD S." +"DirectionFaces": "South" +"Directions": "North on Westmount SRd S turn Right on Erb St W" +"ExpirationDate": "2026-07-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-25" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "074700" +"MajorChangeTimestamp": "2025-12-30T23:56:11Z" +"MlsStatus": "Extension" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-26T13:55:45Z" +"OriginalListPrice": 10980000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2701080" +"ParcelNumber": "224080010" +"PhotosChangeTimestamp": "2025-07-26T13:55:46Z" +"PreviousListPrice": 10980000.0 +"PriceChangeTimestamp": "2025-10-01T14:15:10Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Erb" +"StreetNumber": "205-209" +"StreetSuffix": "Street" +"TaxAnnualAmount": "15935.7" +"TaxLegalDescription": "PT LT 42 PL 496 CITY OF WATERLOO AS IN 743232 EXCEPT PT 21, 58EX438; S/T 943478; WATERLOO; PT LT 42 PL 496 CITY OF WATERLOO AS IN 743164 EXCEPT PT 19, 58EX438; WATERLOO; PT LT 42 PL 496 CITY OF WATERLOO AS IN 779127 EXCEPT PT 17, 58EX438; S/T 943478; WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4% + HST" +"TransactionType": "For Sale" +"Zoning": "RMU-40" +"DDFYN": true +"GasYNA": "Available" +"CableYNA": "Available" +"LotDepth": 287.57 +"LotWidth": 130.62 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12309085')" +"RollNumber": "301603080005000" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"ElectricYNA": "Available" +"HoldoverDays": 60 +"TelephoneYNA": "Available" +"ParcelNumber2": 224080009 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 1V6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"LotSizeAreaUnits": "Square Feet" +"LotSizeRangeAcres": "Not Applicable" +"PossessionDetails": "Flexible" +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-07-26T13:55:46Z" +"ExtensionEntryTimestamp": "2025-12-30T23:56:11Z" +"SystemModificationTimestamp": "2025-12-30T23:56:11.10841Z" +"Media": array:9 [ …9] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4283 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12651498" +"ListingId": "X12651498" +"PropertyType": "Residential" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-12-30T15:09:58Z" +"RFModificationTimestamp": "2026-03-09T07:17:53Z" +"ListPrice": 438800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 0E9" +"UnparsedAddress": "318 Spruce Street 1601, Waterloo, ON N2L 0E9" +"Coordinates": array:2 [ …2] +"Latitude": 43.478945 +"Longitude": -80.526435 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/FUTURE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible Opportunity to Own a modern and Spacious 1 Bedroom + Den, Unit In One Of Waterloos' Most Sought-After Convenient Locations!. Its A Prime Investment For Student Housing , Small Family or Professionals. Close To Hwy 85, The LRT,steps away from Wilfred Laurier & Minutes to University of Waterloo. Floor to ceiling large windows in Living and Bed room with Long Open Balcony with breath taking City View. Ensuite 4 Pc Washroom and another 1.5 Washroom for added Convenience. Sleek Kitchen with stainless steel Appliances including a B/I Dishwasher and granite Countertop. Lots of Storage Cabinets. Spacious den can be used as a 2nd bedroom or as Office room. One parking space underground. Amenities includes a Nice GYM, Guest Suite, Meeting/Party Room Lounge. Rooftop Deck/Garden, Visitor Parking. Theatre Room, A Guest Suite, Lounge Room Walking Distance to Walmart, No Frills, Many Cafes & Restaurants & Cinema, Public Transit. Conestoga Waterloo Campus, Which Is 1.5 Km From The Building. WHY WAIT, COME BUY AND CALL IT YOUR HOME!! Motivated Seller. Flexible Closing." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:3 [ …3] +"AssociationFee": "483.03" +"AssociationFeeIncludes": array:4 [ …4] +"Basement": array:1 [ …1] +"BuildingName": "Sage 2" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-03-09T02:25:26.622009+00:00" +"CrossStreet": "King / University" +"Directions": "King / University" +"ExpirationDate": "2026-05-29" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-12-29" +"MainOfficeKey": "104000" +"MajorChangeTimestamp": "2025-12-29T15:07:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-12-29T15:07:16Z" +"OriginalListPrice": 438800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3381344" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-12-29T15:07:17Z" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Spruce" +"StreetNumber": "318" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3919.05" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.75% + HST" +"TransactionType": "For Sale" +"UnitNumber": "1601" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://sites.sjvirtualtours.ca/318-Spruce-St-unit-1601/idx" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12651498')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "16" +"ParkingSpot1": "B10" +"ParkingType1": "Exclusive" +"ParkingType2": "Owned" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 0E9, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-02-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 624 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:4 [ …4] +"SquareFootSource": "As Per Seller" +"ParkingLevelUnit1": "2" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "1" +"MediaChangeTimestamp": "2025-12-29T15:07:17Z" +"DevelopmentChargesPaid": array:1 [ …1] +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-12-30T15:10:01.718525Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:24 [ …24] } ] +success: true +page_size: 10 +page_count: 29 +count: 285 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4254 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4076 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "N13060792" +"ListingId": "N13060792" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-30T07:42:03Z" +"RFModificationTimestamp": "2026-04-30T07:45:43Z" +"ListPrice": 749999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Georgina" +"PostalCode": "L4P 3P7" +"UnparsedAddress": "77 Natanya Boulevard, Georgina, ON L4P 3P7" +"Coordinates": array:2 [ …2] +"Latitude": 44.2398295 +"Longitude": -79.4553662 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "AIMHOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Well-maintained detached home in the sought-after Keswick By The Lake area. Situated on a generous corner lot with a welcoming front yard. Functional layout with a bright and inviting living space. Kitchen offers ample storage and workspace, with a walk-out to a large deck overlooking a private backyard. Ideal setup for everyday living and entertaining. Features 3+1 bedrooms and 2 bathrooms. Open-concept main living and dining areas provide a comfortable flow throughout." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Keswick North" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "York" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-30T01:51:31.471393+00:00" +"CrossStreet": "Woodbine Ave. & Wexford Dr. 90" +"DirectionFaces": "East" +"Directions": "gps" +"ExpirationDate": "2026-07-27" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Washer & Dryer, All Electrical Light Fixtures" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-29" +"MainOfficeKey": "090900" +"MajorChangeTimestamp": "2026-04-30T01:46:08Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-30T01:46:08Z" +"OriginalListPrice": 749999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3894040" +"ParcelNumber": "034800356" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-04-30T07:42:03Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Natanya" +"StreetNumber": "77" +"StreetSuffix": "Boulevard" +"TaxAnnualAmount": "4419.82" +"TaxLegalDescription": "PCL 128-1 SEC 65M2715; LT 128 PL 65M2715; S/T RIGHT LT727005 ; GEORGINA" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 125.0 +"LotWidth": 35.65 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N13060792')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "197000009500846" +"SurveyType": "None" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-29" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 7 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-04-30T07:42:03Z" +"SystemModificationTimestamp": "2026-04-30T07:42:03.791527Z" +"Media": array:35 [ …35] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "C12658156" +"ListingId": "C12658156" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" …114 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4078 …109} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4079 …124} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4080 …131} ] +success: true +page_size: 5 +page_count: 8864 +count: 44317 +after_key: "" } ] ]