array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=80&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=80&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=80&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=80&$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: "639706"
+post_author: 1
+"ListingKey": "X12888822"
+"ListingId": "X12888822"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T15:46:03Z"
+"RFModificationTimestamp": "2026-04-25T14:00:01Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E9"
+"UnparsedAddress": "128 King Street N Street 601, Waterloo, ON N2J 0E9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479755
+"Longitude": -80.526359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX HALLMARK REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to One28 King - ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, right on the vibrant King Street corridor. This modern, high-end building offers exceptional convenience with shops, dining, transit, and amenities at your doorstep. This bright suite features 9-ft ceilings, a spacious living and dining area, and a private balcony. The large den offers flexible use as a home office or potential second bedroom. Modern finishes throughout provide a contemporary lifestyle in a premium setting. Building amenities include a yoga studio, outdoor terrace with BBQs, secure bike parking, party room, and study spaces. Ideal for students and/or professionals"
+"ArchitecturalStyle": "Apartment"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T17:25:54.520775+00:00"
+"CrossStreet": "King Street and Elgin Street"
+"Directions": "East of King Street and North of Elgin Street"
+"ExpirationDate": "2026-07-31"
+"Furnished": "Unfurnished"
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "259000"
+"MajorChangeTimestamp": "2026-04-24T15:46:03Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-16T20:10:08Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3677634"
+"ParcelNumber": "237470127"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-16T20:10:09Z"
+"PreviousListPrice": 1950.0
+"PriceChangeTimestamp": "2026-04-24T15:46:03Z"
+"RentIncludes": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "King Street N"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half of Months Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "601"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12888822')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601185003014"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "6"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E9, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"RoomsBelowGrade": 1
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder Plan"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-03-16T23:16:52Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Onyx Condo Mangement Inc."
+"SystemModificationTimestamp": "2026-04-24T15:46:07.649427Z"
+"Media": array:9 [ …9]
+"ID": "639706"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "695901"
+post_author: 1
+"ListingKey": "X13005694"
+"ListingId": "X13005694"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T15:19:14Z"
+"RFModificationTimestamp": "2026-04-29T17:04:21Z"
+"ListPrice": 599888.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2M 1V1"
+"UnparsedAddress": "87 Ralgreen Crescent, Waterloo, ON N2M 1V1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4331996
+"Longitude": -80.5194643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 87 Ralgreen Crescent-a METICULOUSLY MAINTAINED, ONE-OWNER FREEHOLD TOWNHOME nestled in a sought-after, family-friendly neighborhood & built by Savic Homes in 2004. From the moment you enter, you are greeted by a BRIGHT AND INVITING MAIN FLOOR that seamlessly blends everyday comfort with effortless entertaining. The SPACIOUS LIVING ROOM FLOWS INTO A WELL-APPOINTED KITCHEN featuring an island peninsula, ample cabinetry, and a pantry, all overlooking the dining area set on durable ceramic tile. Sliding doors extend your living space outdoors to a PRIVATE BACKYARD RETREAT complete with a large deck and gas BBQ hookup-perfect for hosting summer gatherings or enjoying quiet evenings. Upstairs, the home continues to impress with a GENEROUS PRIMARY BEDROOM offering a walk-in closet and CONVENIENT CHEATER ACCESS TO A WELL-DESIGNED 5-PIECE BATHROOM. Two additional bedrooms provide flexibility for a growing family, guests, or a dedicated home office space. The FULLY FINISHED LOWER LEVEL adds tremendous value, featuring a large recreation room ideal for movie nights or relaxation, a versatile bonus room, a 2-piece bathroom, and AMPLE STORAGE OPTIONS to keep everything organized. Significant updates throughout the home provide peace of mind, including a newer roof (2021), updated windows in the front bedrooms (2019), a brand-new furnace and A/C (2025), freshly cleaned air ducts (2026), modern light fixtures (2026), and a full interior repaint in stylish, neutral tones (2026). Complete with convenient garage access and a two-car driveway, THIS HOME IS IDEALLY SITUATED JUST MINUTES FROM SCHOOLS, shopping, The Boardwalk, restaurants, gyms, banks, the library, movie theatre, and all essential amenities-making it the perfect blend of location and lifestyle. This is a rare opportunity to own a turnkey freehold townhome that truly checks all the boxes."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-16T13:44:00.571744+00:00"
+"CrossStreet": "Highland Rd/Eagen Dr"
+"DirectionFaces": "North"
+"Directions": "Highland turn onto Eagen onto Ralgreen"
+"Exclusions": "Deep Freezer in Basement; All staging furniture & decorations"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": "Deck,Patio,Landscaped,Year Round Living"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer & Dryer"
+"InteriorFeatures": "Auto Garage Door Remote,Storage,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-16T13:24:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-16T13:24:06Z"
+"OriginalListPrice": 599888.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3824096"
+"ParcelNumber": "224780026"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-16T16:27:45Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Ralgreen"
+"StreetNumber": "87"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3419.0"
+"TaxAssessedValue": 252000
+"TaxLegalDescription": "LT 68 PL 1248 KITCHENER S/T & T/W INTEREST IN 1189932 AS AMENDED BY WR39365; S/T 373819; KITCHENER ; T/W EASE WR100516 ON PT LT 67 PL 1248 PT 1 58R14709. T/W EASE WR104302 ON PT 5 58R14709. T/W EASE WR104318 ON PT 6 58R14709. T/W EASE WR104359 PT 3 58R14709. T/W EASE WR104372 ON PT 2 58R14709. T/W EASE WR114871 ON PT 4 58R-14709; KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST reduced if shown by LA"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://sites.ground2airmedia.com/sites/87-ralgreen-crescent-kitchener-on-n2m-1v1-23765889/branded"
+"VirtualTourURLBranded2": "https://youtube.com/shorts/c1h Yw WRqg T0"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/egbnjdpp/unbranded"
+"VirtualTourURLUnbranded2": "https://youtu.be/uudt QDGCvpo"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.0
+"LotWidth": 20.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005694')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301204003911200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Furnace & AC"
+"HoldoverDays": 120
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:5 [ …5]
+"SalesBrochureUrl": "https://bit.ly/87Ralgreen Brochure"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "ONLY SHOWINGTIME"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2026-04-16T16:27:45Z"
+"SystemModificationTimestamp": "2026-04-24T15:19:16.196808Z"
+"Media": array:37 [ …37]
+"ID": "695901"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "705094"
+post_author: 1
+"ListingKey": "X13039940"
+"ListingId": "X13039940"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T14:59:31Z"
+"RFModificationTimestamp": "2026-04-29T17:04:29Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5V6"
+"UnparsedAddress": "405 Clairbrook Crescent, Waterloo, ON N2L 5V6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Wellington Realty Brokerage Inc."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "RARE OPPORTUNITY!!!!! 2 storey 4 bedroom 2.5 Bath home is just right for you. Walk into a large entrance/foyer area. With a formal dining room, living room, large updated kitchen with solid surface countertops, farm style sink, stainless-steel appliances and breakfast nook solarium. To finish off the main level features a family room with wood burning fireplace, patio area and access to backyard hardwood floors and 2 piece bath with laundry area. Upstairs features Primary bedroom with 4 piece ensuite, plus 3 large additional bedrooms and another 4 piece bath. Basement features 2 large finished areas, storage room, unity room and a cold storage area. Double attached garage. High Efficiency furnace with Central Air in 2021."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-24T14:19:49.467296+00:00"
+"CrossStreet": "Fischer-Hallman Road N"
+"DirectionFaces": "East"
+"Directions": "Fischer-Hallman Road to Beechlawn Drive to Clairbrook Crescent"
+"Exclusions": "Seller Personal Items"
+"ExpirationDate": "2026-07-24"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Water Softener,Water Heater,Suspended Ceilings"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "561300"
+"MajorChangeTimestamp": "2026-04-24T13:54:28Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-24T13:54:28Z"
+"OriginalListPrice": 995000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3842886"
+"ParcelNumber": "223820150"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-24T13:54:28Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Clairbrook"
+"StreetNumber": "405"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6768.0"
+"TaxAssessedValue": 494000
+"TaxLegalDescription": "LT 13 PL 1421 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 103.0
+"LotShape": "Rectangular"
+"LotWidth": 60.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039940')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604113002900"
+"SurveyType": "Available"
+"ElectricYNA": "Yes"
+"RentalItems": "Natural Gas Hot Water Heater"
+"TelephoneYNA": "Yes"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 2
+"ParcelOfTiedLand": "No"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"MediaChangeTimestamp": "2026-04-24T13:54:28Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-24T14:59:48.506704Z"
+"Media": array:26 [ …26]
+"ID": "705094"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "692178"
+post_author: 1
+"ListingKey": "X12962948"
+"ListingId": "X12962948"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T14:04:52Z"
+"RFModificationTimestamp": "2026-04-29T17:04:16Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1V5"
+"UnparsedAddress": "489 Northlake Drive, Waterloo, ON N2V 1V5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4958263
+"Longitude": -80.5663077
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Your search is over, your next home awaits in Desirable Lakeshore North! Welcome to 489 Northlake Drive - a spacious 4-level backsplit nestled in one of Waterloo's most sought-after, family-friendly neighborhoods. Offering over 2,000 sq/ft of finished living space, this home combines comfort, functionality, and incredible opportunity. Featuring 4 bedrooms, 2 full bathrooms, a double-car garage, and parking for 2 additional vehicles, this home is perfect for growing families or anyone looking for flexible living space. Step inside to a bright and inviting main floor, where a sun-filled living room with a large bay window creates a warm and welcoming atmosphere. The adjoining dining area is ideal for family meals and entertaining. The eat-in kitchen offers ample cabinet and counter space, along with a walkout to a large deck complete with a hot tub - perfect for summer BBQs, relaxing evenings, and outdoor gatherings. Upstairs, you'll find three generously sized bedrooms and a 4-piece bathroom. The lower level features a spacious yet cozy family room with a gas fireplace, along with a convenient 3-piece bathroom. The basement adds even more versatility with a rec room, a fourth bedroom, and plenty of storage space. With just a few cosmetic updates this property offers a fantastic opportunity to customize and truly make it your forever home. Ideally located near top-rated schools, parks, walking trails, shopping, universities, public transit, the Farmers Market and Laurel Creek Conservation Area, all the amenities that make Lakeshore North one of the most sought-after communities in the area including easy access to major highways. Don't miss your chance to own a great family home in a highly desirable community - book your private showing today!"
+"ArchitecturalStyle": "Backsplit 4"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-21T21:19:11.861182+00:00"
+"CrossStreet": "Conservation Drive"
+"DirectionFaces": "North"
+"Directions": "Conservation Drive to Northlake"
+"ExpirationDate": "2026-06-07"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Sump Pump,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-24T14:04:52Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-07T12:25:44Z"
+"OriginalListPrice": 725000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3774478"
+"ParcelNumber": "222580229"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-07T12:25:45Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 725000.0
+"PriceChangeTimestamp": "2026-04-24T14:04:52Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Northlake"
+"StreetNumber": "489"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4973.0"
+"TaxLegalDescription": "LT 40 PL 1631 CITY OF WATERLOO; S/T 885978; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/489_northlake_drive_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/489_northlake_drive_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12962948')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604330343600"
+"SurveyType": "Unknown"
+"RentalItems": "Water Heater"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 1
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay, sentri connect App required"
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Lower"
+"MediaChangeTimestamp": "2026-04-07T12:25:45Z"
+"SystemModificationTimestamp": "2026-04-24T14:05:05.316122Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
+"ID": "692178"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "707616"
+post_author: 1
+"ListingKey": "X13039506"
+"ListingId": "X13039506"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T13:09:17Z"
+"RFModificationTimestamp": "2026-04-27T15:07:04Z"
+"ListPrice": 2400.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "251 Hemlock Street 314, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4751797
+"Longitude": -80.5317287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 314-251 Hemlock. This fully furnished 2-bedroom, 2-bathroom unit, ideal for students and young professionals looking for a comfortable and convenient place to call home. This suite offers Modern finishes and a spacious, functional layout in the heart of Waterloo. The kitchen features granite countertops, tile backsplash, stainless steel appliances, along with a dedicated dinette area that's perfect for meals or a quiet study space. Both bedrooms are spacious and well-suited for studying or working from home. The unit features a 4-piece main bathroom and a 4-piece ensuite for added convenience. In-suite laundry and a private balcony further enhance the ease of living. The building features top tier amenities, including a gym, games room and rooftop patio. Located just minutes from universities, shopping, and public transportation, this unit offers excellent access to everything you need. A fully furnished, move-in-ready option in a highly convenient location."
+"ArchitecturalStyle": "1 Storey/Apt"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T13:12:52.883198+00:00"
+"CrossStreet": "University Ave and Hemlock St"
+"Directions": "University Avenue to Hemlock Street"
+"ExpirationDate": "2026-06-24"
+"Furnished": "Furnished"
+"Inclusions": "Dishwasher, Dryer, Furniture, Microwave, Smoke Detector, Stove, Washer, Window Coverings, Desks x2, Desk chairs x2,dining table, Dining table chairs x4, TV, TV stand, Sofa, Coffee Table, Bed x2, Nightstand x2"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-24"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-24T13:09:17Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T13:09:17Z"
+"OriginalListPrice": 2400.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864256"
+"ParcelNumber": "236420116"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T13:09:17Z"
+"RentIncludes": array:3 [ …3]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half month rent"
+"TransactionType": "For Lease"
+"UnitNumber": "314"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039506')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004056"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LegalStories": "3"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 642
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 7
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Owner"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "314"
+"MediaChangeTimestamp": "2026-04-24T13:09:17Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-24T13:09:17.952162Z"
+"Media": array:14 [ …14]
+"ID": "707616"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "709899"
+post_author: 1
+"ListingKey": "X13039316"
+"ListingId": "X13039316"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T12:37:43Z"
+"RFModificationTimestamp": "2026-04-27T15:07:04Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E7"
+"UnparsedAddress": "181 King Street S 1812, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4604
+"Longitude": -80.5202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Circa 1877 in the heart of vibrant Uptown Waterloo! This stunning 1-bedroom, 1-bathroom "Jefferson" model offers modern urban living with low condo fees and an unbeatable location-adjacent to the Allen LRT Station for effortless commuting. Perched on the 18th floor, this unit boasts breathtaking, unobstructed south-east views and features a rare oversized 157 sq ft private balcony-an exceptional outdoor space not offered with every unit. Inside, the open-concept layout is bright and functional, complete with in-suite laundry, a well-designed kitchen, and efficient forced air heating and cooling via a hybrid heat pump system. An owned locker provides valuable additional storage. Please note: this unit does not include a parking space. Residents enjoy access to an impressive suite of amenities, including a 5,000 sq ft 6th-floor outdoor retreat with a saltwater pool, terrace, cabanas, BBQs, fire table, and lounge areas. Additional features include an indoor/outdoor yoga studio, fully equipped fitness centre, library, entertainment lounge with indoor-outdoor bar, co-working office space, and bookable boardrooms. The building also offers secure underground parking, bike storage, and a guest suite for visitors. Condo fees are exceptionally well-rounded, covering building insurance, heat, central air conditioning, high-speed fibre internet with unlimited data, private garbage removal, common elements, and landscaping-delivering both value and convenience. Just steps from Uptown Waterloo's vibrant mix of cafés, restaurants, shopping, and parks, this is an incredible opportunity for professionals, first-time buyers, or investors seeking the best of location, lifestyle, and modern condo living."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "488.03"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T12:42:02.709885+00:00"
+"CrossStreet": "Allen Street W and William Street W"
+"Directions": "King Street South, Waterloo"
+"Exclusions": "All tenants possessions; Kitchen Island"
+"ExpirationDate": "2026-11-20"
+"GarageYN": true
+"Inclusions": "Built in wardrobe in bedroom; Blinds; Programmable Thermostat, Washer and Dryer, Dishwasher, Built in fridge and freezer, Ceramic top stove range"
+"InteriorFeatures": "Primary Bedroom - Main Floor,Carpet Free,Guest Accommodations,Storage Area Lockers"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-24T12:37:43Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-24T12:37:43Z"
+"OriginalListPrice": 369900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3860534"
+"ParcelNumber": "237140128"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T12:37:43Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3726.0"
+"TaxAssessedValue": 272000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "1812"
+"Zoning": "I"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039316')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"RollNumber": "301603120002478"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Heat pump"
+"HoldoverDays": 60
+"LegalStories": "0"
+"ParkingType1": "None"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-07-03"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 714
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 1
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate with tenant"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "0"
+"MediaChangeTimestamp": "2026-04-24T12:37:43Z"
+"PropertyManagementCompany": "King Condo Management"
+"SystemModificationTimestamp": "2026-04-24T12:37:43.858065Z"
+"Media": array:27 [ …27]
+"ID": "709899"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "696925"
+post_author: 1
+"ListingKey": "X13038848"
+"ListingId": "X13038848"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T03:08:55Z"
+"RFModificationTimestamp": "2026-04-27T15:07:03Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0G9"
+"UnparsedAddress": "142 Foamflower Place C 41, Waterloo, ON N2V 0G9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.449642
+"Longitude": -80.5885223
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOUSESIGMA INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover modern, spacious living at 142 Foamflower Place, Unit #41, Building C, Waterloo! This beautifully designed 1,100 sq. ft. Dahlia Garden condo offers three generously sized bedrooms, including a primary suite with a walk-in closet and private ensuite, along with two full bathrooms. Enjoy a bright open-concept layout filled with natural light and freshly painted interiors, complemented by a brand-new kitchen backsplash. The home features upgraded finishes throughout, including granite countertops, ceramic tile in key areas, stainless steel appliances, and a pre- installed RO water filtration system. Additional highlights include 9' ceilings, carpet-free flooring, and a private patio, perfect for relaxing or entertaining. The unit comes with one parking space (option for a second Parking for $100 Extra) and includes a ROGERS 1 GB Internet Plan for added convenience. Located in the highly sought-after Vista Hills community, you are just minutes from parks, scenic trails, shopping, top-rated schools, and public transit. This home offers the perfect blend of comfort, style, and location - ideal for families, professionals, or investors."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "304.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T03:11:16.091015+00:00"
+"CrossStreet": "Ira Needles Blvd & Erb St W"
+"Directions": "From Ira Needles Blvd turn onto University Ave W, right on Sundew Dr, then left onto Foamflower Place to Building C, Unit 41."
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Carbon Monoxide Detector, Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": "Air Exchanger,Built-In Oven,Countertop Range,Water Heater,Water Softener,ERV/HRV"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "319500"
+"MajorChangeTimestamp": "2026-04-24T03:08:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T03:08:55Z"
+"OriginalListPrice": 549900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3865032"
+"ParcelNumber": "238000081"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T03:08:55Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Foamflower"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3737.45"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"UnitNumber": "C 41"
+"VirtualTourURLBranded": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/"
+"VirtualTourURLBranded2": "https://virtualtours.jarts360view.com/cp/142-foamflower-place-c-41-waterloo/"
+"VirtualTourURLUnbranded2": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/nb/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038848')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604000126852"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater, Water Softener."
+"HoldoverDays": 30
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0G9, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 797
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 3
+"SalesBrochureUrl": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/brochure/?1774356225"
+"SquareFootSource": "1100"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "81"
+"MediaChangeTimestamp": "2026-04-24T03:08:55Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-24T03:08:56.238796Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:23 [ …23]
+"ID": "696925"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "709242"
+post_author: 1
+"ListingKey": "X13038824"
+"ListingId": "X13038824"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T02:50:34Z"
+"RFModificationTimestamp": "2026-04-27T15:07:03Z"
+"ListPrice": 519000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0B3"
+"UnparsedAddress": "223 Erb Street W 501, Waterloo, ON N2L 0B3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4590766
+"Longitude": -80.5363379
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience sophisticated living in the luxurious building in the heart of Waterloo. This rarely offered corner unit features 2 bedrooms, 2 bathrooms, and an office space across 1,351 sq. ft. of thoughtfully designed space with 9-foot ceilings. Flooded with natural light, the home showcases modern finishes, oversized windows, and panoramic city views from every room. Enjoy a spacious kitchen with granite countertops, a large island, and abundant cabinet and counter space-perfect for entertaining. The primary suite includes generous closets and a spa-inspired ensuite with a glass shower, double sinks, and a smart toilet. Step onto your covered balcony, large enough for outdoor dining or lounging. Located just steps from T&T Supermarket, bus stops, and the Waterloo Public Library & Community Centre, with easy access to restaurants, cafes, and universities, this home offers the ultimate in urban convenience. Vacant property. Show with confidence. Photos are from the previous listing."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "1112.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"CoListOfficePhone": "905-305-1600"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T02:56:02.797334+00:00"
+"CrossStreet": "Erb St W / Westmount Rd S"
+"Directions": "Erb St W / Westmount Rd S"
+"ExpirationDate": "2026-07-23"
+"GarageYN": true
+"Inclusions": "Top notch amenities including an opulent communal lounge/ library with a grand piano, fitness studio, sauna, an rooftop terrace equipped with BBQ and an indoor party room. 1 Parking and 1 locker included"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-24T02:50:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T02:50:34Z"
+"OriginalListPrice": 519000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864992"
+"ParcelNumber": "000"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T02:50:34Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Erb"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5257.27"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "501"
+"VirtualTourURLUnbranded": "https://youtu.be/d Yje ORJt Gk0"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038824')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "000"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 30
+"LegalStories": "5"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0B3, CA"
+"ApproximateAge": "11-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 541
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 7
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "1351"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-04-24T02:50:34Z"
+"PropertyManagementCompany": "Wilson"
+"SystemModificationTimestamp": "2026-04-24T02:50:35.225016Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:25 [ …25]
+"ID": "709242"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "696601"
+post_author: 1
+"ListingKey": "X13038290"
+"ListingId": "X13038290"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T00:22:23Z"
+"RFModificationTimestamp": "2026-04-24T00:43:17Z"
+"ListPrice": 2700.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3V5"
+"UnparsedAddress": "649 Albert Street 5, Waterloo, ON N2L 3V5"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "AXIS REALTY BROKERAGE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover a beautiful and well-maintained 3-level townhouse that perfectly balances comfort, space, and location. This inviting home features a newly installed fridge in a functional kitchen, offering a fresh and modern touch for everyday living. With generous living space spread across three levels, there's plenty of room for families, professionals, or students who want extra privacy. The layout is both practical and welcoming, making it easy to relax, work, or entertain. Step outside to enjoy a spacious backyard-ideal for gatherings, outdoor dining, or simply unwinding in your own private space. Located in a prime area close to major universities, schools, and everyday amenities, this home offers unmatched convenience while still being tucked away from the busy student zones-giving you the best of both worlds: desirable location. accessibility and peace. A perfect place to call home, combining space, comfort, and a highly desirable location."
+"ArchitecturalStyle": "2-Storey"
+"AssociationYN": true
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "None"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-23T23:04:07.534020+00:00"
+"CrossStreet": "Albert St/ Weber St"
+"Directions": "Albert St/ Weber St"
+"ExpirationDate": "2026-09-01"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "All Appliances"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-22"
+"MainOfficeKey": "392300"
+"MajorChangeTimestamp": "2026-04-23T22:16:31Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-23T22:16:31Z"
+"OriginalListPrice": 2700.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864228"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-23T22:16:32Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:1 [ …1]
+"RoomsTotal": "7"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "649"
+"StreetSuffix": "Street"
+"TaxBookNumber": "301604005018476"
+"TransactionBrokerCompensation": "Half Month rent"
+"TransactionType": "For Lease"
+"UnitNumber": "5"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Water"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038290')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Other"
+"RollNumber": "301604005018476"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 44
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1400-1599"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "owner"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"LegalApartmentNumber": "5"
+"MediaChangeTimestamp": "2026-04-23T22:16:32Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Krall Property Management Inc."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-24T00:22:23.677355Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:15 [ …15]
+"ID": "696601"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "695188"
+post_author: 1
+"ListingKey": "X13033698"
+"ListingId": "X13033698"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-23T10:31:29Z"
+"RFModificationTimestamp": "2026-04-29T10:47:36Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4L4"
+"UnparsedAddress": "30 Hickory Street 111, Waterloo, ON N2J 4L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479306
+"Longitude": -80.5231564
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your perfect opportunity in the heart of Waterloo! Ideal for first-time home buyers, investors, or parents, this 2-storey, 3-bedroom condo apartment is just minutes from Wilfrid Laurier University, University of Waterloo, and Conestoga College, with easy access to restaurants, gyms, shopping, and transit. This spacious, carpet-free unit features a bright living room with walk-out to a private balcony, a functional kitchen, and a main floor primary bedroom. An interior staircase leads to the lower level, offering two generously sized bedrooms and a full bathroom-perfect for families or student living. Located in a well-maintained building with controlled entry, this property offers excellent layout, convenience, and strong rental potential in a highly sought-after location."
+"ArchitecturalStyle": "2-Storey"
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "459.86"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Window Unit(s)"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T05:14:37.227587+00:00"
+"CrossStreet": "Weber St N/ University Ave E"
+"Directions": "Weber St N/ University Ave E"
+"ExpirationDate": "2026-09-30"
+"Inclusions": "Refrigerator, Stove"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-04-23T10:31:29Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-23T10:31:29Z"
+"OriginalListPrice": 375000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3806928"
+"ParcelNumber": "231210011"
+"ParkingFeatures": "Surface"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-23T10:31:29Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hickory"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2667.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "111"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13033698')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301601175000411"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4L4, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 121
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:5 [ …5]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Lower"
+"LegalApartmentNumber": "11"
+"MediaChangeTimestamp": "2026-04-23T10:31:29Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-23T10:31:29.571649Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:2 [ …2]
+"ID": "695188"
}
]
+success: true
+page_size: 10
+page_count: 29
+count: 285
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Cache Key: 24aee9ce3e7aeca030485d20428c542a9fbdabcdf0251948cf9c32365f4c7d6f" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3085
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4287
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12888822"
+"ListingId": "X12888822"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T15:46:03Z"
+"RFModificationTimestamp": "2026-04-25T14:00:01Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E9"
+"UnparsedAddress": "128 King Street N Street 601, Waterloo, ON N2J 0E9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479755
+"Longitude": -80.526359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX HALLMARK REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to One28 King - ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, right on the vibrant King Street corridor. This modern, high-end building offers exceptional convenience with shops, dining, transit, and amenities at your doorstep. This bright suite features 9-ft ceilings, a spacious living and dining area, and a private balcony. The large den offers flexible use as a home office or potential second bedroom. Modern finishes throughout provide a contemporary lifestyle in a premium setting. Building amenities include a yoga studio, outdoor terrace with BBQs, secure bike parking, party room, and study spaces. Ideal for students and/or professionals"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T17:25:54.520775+00:00"
+"CrossStreet": "King Street and Elgin Street"
+"Directions": "East of King Street and North of Elgin Street"
+"ExpirationDate": "2026-07-31"
+"Furnished": "Unfurnished"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-16"
+"MainOfficeKey": "259000"
+"MajorChangeTimestamp": "2026-04-24T15:46:03Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-16T20:10:08Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3677634"
+"ParcelNumber": "237470127"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-16T20:10:09Z"
+"PreviousListPrice": 1950.0
+"PriceChangeTimestamp": "2026-04-24T15:46:03Z"
+"RentIncludes": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "King Street N"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half of Months Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "601"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12888822')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601185003014"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "6"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E9, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"RoomsBelowGrade": 1
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder Plan"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-03-16T23:16:52Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Onyx Condo Mangement Inc."
+"SystemModificationTimestamp": "2026-04-24T15:46:07.649427Z"
+"Media": array:9 [ …9]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4288
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13005694"
+"ListingId": "X13005694"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T15:19:14Z"
+"RFModificationTimestamp": "2026-04-29T17:04:21Z"
+"ListPrice": 599888.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2M 1V1"
+"UnparsedAddress": "87 Ralgreen Crescent, Waterloo, ON N2M 1V1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4331996
+"Longitude": -80.5194643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 87 Ralgreen Crescent-a METICULOUSLY MAINTAINED, ONE-OWNER FREEHOLD TOWNHOME nestled in a sought-after, family-friendly neighborhood & built by Savic Homes in 2004. From the moment you enter, you are greeted by a BRIGHT AND INVITING MAIN FLOOR that seamlessly blends everyday comfort with effortless entertaining. The SPACIOUS LIVING ROOM FLOWS INTO A WELL-APPOINTED KITCHEN featuring an island peninsula, ample cabinetry, and a pantry, all overlooking the dining area set on durable ceramic tile. Sliding doors extend your living space outdoors to a PRIVATE BACKYARD RETREAT complete with a large deck and gas BBQ hookup-perfect for hosting summer gatherings or enjoying quiet evenings. Upstairs, the home continues to impress with a GENEROUS PRIMARY BEDROOM offering a walk-in closet and CONVENIENT CHEATER ACCESS TO A WELL-DESIGNED 5-PIECE BATHROOM. Two additional bedrooms provide flexibility for a growing family, guests, or a dedicated home office space. The FULLY FINISHED LOWER LEVEL adds tremendous value, featuring a large recreation room ideal for movie nights or relaxation, a versatile bonus room, a 2-piece bathroom, and AMPLE STORAGE OPTIONS to keep everything organized. Significant updates throughout the home provide peace of mind, including a newer roof (2021), updated windows in the front bedrooms (2019), a brand-new furnace and A/C (2025), freshly cleaned air ducts (2026), modern light fixtures (2026), and a full interior repaint in stylish, neutral tones (2026). Complete with convenient garage access and a two-car driveway, THIS HOME IS IDEALLY SITUATED JUST MINUTES FROM SCHOOLS, shopping, The Boardwalk, restaurants, gyms, banks, the library, movie theatre, and all essential amenities-making it the perfect blend of location and lifestyle. This is a rare opportunity to own a turnkey freehold townhome that truly checks all the boxes."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-16T13:44:00.571744+00:00"
+"CrossStreet": "Highland Rd/Eagen Dr"
+"DirectionFaces": "North"
+"Directions": "Highland turn onto Eagen onto Ralgreen"
+"Exclusions": "Deep Freezer in Basement; All staging furniture & decorations"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": array:4 [ …4]
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer & Dryer"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-16"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-16T13:24:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-16T13:24:06Z"
+"OriginalListPrice": 599888.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3824096"
+"ParcelNumber": "224780026"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-16T16:27:45Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Ralgreen"
+"StreetNumber": "87"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3419.0"
+"TaxAssessedValue": 252000
+"TaxLegalDescription": "LT 68 PL 1248 KITCHENER S/T & T/W INTEREST IN 1189932 AS AMENDED BY WR39365; S/T 373819; KITCHENER ; T/W EASE WR100516 ON PT LT 67 PL 1248 PT 1 58R14709. T/W EASE WR104302 ON PT 5 58R14709. T/W EASE WR104318 ON PT 6 58R14709. T/W EASE WR104359 PT 3 58R14709. T/W EASE WR104372 ON PT 2 58R14709. T/W EASE WR114871 ON PT 4 58R-14709; KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST reduced if shown by LA"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://sites.ground2airmedia.com/sites/87-ralgreen-crescent-kitchener-on-n2m-1v1-23765889/branded"
+"VirtualTourURLBranded2": "https://youtube.com/shorts/c1h Yw WRqg T0"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/egbnjdpp/unbranded"
+"VirtualTourURLUnbranded2": "https://youtu.be/uudt QDGCvpo"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.0
+"LotWidth": 20.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13005694')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301204003911200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Furnace & AC"
+"HoldoverDays": 120
+"LaundryLevel": "Lower Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"ApproximateAge": "16-30"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:5 [ …5]
+"SalesBrochureUrl": "https://bit.ly/87Ralgreen Brochure"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "ONLY SHOWINGTIME"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2026-04-16T16:27:45Z"
+"SystemModificationTimestamp": "2026-04-24T15:19:16.196808Z"
+"Media": array:37 [ …37]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13039940"
+"ListingId": "X13039940"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T14:59:31Z"
+"RFModificationTimestamp": "2026-04-29T17:04:29Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5V6"
+"UnparsedAddress": "405 Clairbrook Crescent, Waterloo, ON N2L 5V6"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Wellington Realty Brokerage Inc."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "RARE OPPORTUNITY!!!!! 2 storey 4 bedroom 2.5 Bath home is just right for you. Walk into a large entrance/foyer area. With a formal dining room, living room, large updated kitchen with solid surface countertops, farm style sink, stainless-steel appliances and breakfast nook solarium. To finish off the main level features a family room with wood burning fireplace, patio area and access to backyard hardwood floors and 2 piece bath with laundry area. Upstairs features Primary bedroom with 4 piece ensuite, plus 3 large additional bedrooms and another 4 piece bath. Basement features 2 large finished areas, storage room, unity room and a cold storage area. Double attached garage. High Efficiency furnace with Central Air in 2021."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-24T14:19:49.467296+00:00"
+"CrossStreet": "Fischer-Hallman Road N"
+"DirectionFaces": "East"
+"Directions": "Fischer-Hallman Road to Beechlawn Drive to Clairbrook Crescent"
+"Exclusions": "Seller Personal Items"
+"ExpirationDate": "2026-07-24"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-24"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "561300"
+"MajorChangeTimestamp": "2026-04-24T13:54:28Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-24T13:54:28Z"
+"OriginalListPrice": 995000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3842886"
+"ParcelNumber": "223820150"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-24T13:54:28Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Clairbrook"
+"StreetNumber": "405"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6768.0"
+"TaxAssessedValue": 494000
+"TaxLegalDescription": "LT 13 PL 1421 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 103.0
+"LotShape": "Rectangular"
+"LotWidth": 60.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039940')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604113002900"
+"SurveyType": "Available"
+"ElectricYNA": "Yes"
+"RentalItems": "Natural Gas Hot Water Heater"
+"TelephoneYNA": "Yes"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 8
+"RoomsBelowGrade": 2
+"ParcelOfTiedLand": "No"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"MediaChangeTimestamp": "2026-04-24T13:54:28Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-24T14:59:48.506704Z"
+"Media": array:26 [ …26]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12962948"
+"ListingId": "X12962948"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T14:04:52Z"
+"RFModificationTimestamp": "2026-04-29T17:04:16Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1V5"
+"UnparsedAddress": "489 Northlake Drive, Waterloo, ON N2V 1V5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4958263
+"Longitude": -80.5663077
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Your search is over, your next home awaits in Desirable Lakeshore North! Welcome to 489 Northlake Drive - a spacious 4-level backsplit nestled in one of Waterloo's most sought-after, family-friendly neighborhoods. Offering over 2,000 sq/ft of finished living space, this home combines comfort, functionality, and incredible opportunity. Featuring 4 bedrooms, 2 full bathrooms, a double-car garage, and parking for 2 additional vehicles, this home is perfect for growing families or anyone looking for flexible living space. Step inside to a bright and inviting main floor, where a sun-filled living room with a large bay window creates a warm and welcoming atmosphere. The adjoining dining area is ideal for family meals and entertaining. The eat-in kitchen offers ample cabinet and counter space, along with a walkout to a large deck complete with a hot tub - perfect for summer BBQs, relaxing evenings, and outdoor gatherings. Upstairs, you'll find three generously sized bedrooms and a 4-piece bathroom. The lower level features a spacious yet cozy family room with a gas fireplace, along with a convenient 3-piece bathroom. The basement adds even more versatility with a rec room, a fourth bedroom, and plenty of storage space. With just a few cosmetic updates this property offers a fantastic opportunity to customize and truly make it your forever home. Ideally located near top-rated schools, parks, walking trails, shopping, universities, public transit, the Farmers Market and Laurel Creek Conservation Area, all the amenities that make Lakeshore North one of the most sought-after communities in the area including easy access to major highways. Don't miss your chance to own a great family home in a highly desirable community - book your private showing today!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-21T21:19:11.861182+00:00"
+"CrossStreet": "Conservation Drive"
+"DirectionFaces": "North"
+"Directions": "Conservation Drive to Northlake"
+"ExpirationDate": "2026-06-07"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-24T14:04:52Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-07T12:25:44Z"
+"OriginalListPrice": 725000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3774478"
+"ParcelNumber": "222580229"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-07T12:25:45Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 725000.0
+"PriceChangeTimestamp": "2026-04-24T14:04:52Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Northlake"
+"StreetNumber": "489"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4973.0"
+"TaxLegalDescription": "LT 40 PL 1631 CITY OF WATERLOO; S/T 885978; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/489_northlake_drive_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/489_northlake_drive_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12962948')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604330343600"
+"SurveyType": "Unknown"
+"RentalItems": "Water Heater"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 1
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay, sentri connect App required"
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Lower"
+"MediaChangeTimestamp": "2026-04-07T12:25:45Z"
+"SystemModificationTimestamp": "2026-04-24T14:05:05.316122Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4289
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13039506"
+"ListingId": "X13039506"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T13:09:17Z"
+"RFModificationTimestamp": "2026-04-27T15:07:04Z"
+"ListPrice": 2400.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "251 Hemlock Street 314, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4751797
+"Longitude": -80.5317287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 314-251 Hemlock. This fully furnished 2-bedroom, 2-bathroom unit, ideal for students and young professionals looking for a comfortable and convenient place to call home. This suite offers Modern finishes and a spacious, functional layout in the heart of Waterloo. The kitchen features granite countertops, tile backsplash, stainless steel appliances, along with a dedicated dinette area that's perfect for meals or a quiet study space. Both bedrooms are spacious and well-suited for studying or working from home. The unit features a 4-piece main bathroom and a 4-piece ensuite for added convenience. In-suite laundry and a private balcony further enhance the ease of living. The building features top tier amenities, including a gym, games room and rooftop patio. Located just minutes from universities, shopping, and public transportation, this unit offers excellent access to everything you need. A fully furnished, move-in-ready option in a highly convenient location."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T13:12:52.883198+00:00"
+"CrossStreet": "University Ave and Hemlock St"
+"Directions": "University Avenue to Hemlock Street"
+"ExpirationDate": "2026-06-24"
+"Furnished": "Furnished"
+"Inclusions": "Dishwasher, Dryer, Furniture, Microwave, Smoke Detector, Stove, Washer, Window Coverings, Desks x2, Desk chairs x2,dining table, Dining table chairs x4, TV, TV stand, Sofa, Coffee Table, Bed x2, Nightstand x2"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-24"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-24T13:09:17Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T13:09:17Z"
+"OriginalListPrice": 2400.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864256"
+"ParcelNumber": "236420116"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T13:09:17Z"
+"RentIncludes": array:3 [ …3]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half month rent"
+"TransactionType": "For Lease"
+"UnitNumber": "314"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039506')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004056"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 60
+"LegalStories": "3"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R4, CA"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 642
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 7
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Owner"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "314"
+"MediaChangeTimestamp": "2026-04-24T13:09:17Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-24T13:09:17.952162Z"
+"Media": array:14 [ …14]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4286
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13039316"
+"ListingId": "X13039316"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T12:37:43Z"
+"RFModificationTimestamp": "2026-04-27T15:07:04Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E7"
+"UnparsedAddress": "181 King Street S 1812, Waterloo, ON N2J 0E7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4604
+"Longitude": -80.5202
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Circa 1877 in the heart of vibrant Uptown Waterloo! This stunning 1-bedroom, 1-bathroom "Jefferson" model offers modern urban living with low condo fees and an unbeatable location-adjacent to the Allen LRT Station for effortless commuting. Perched on the 18th floor, this unit boasts breathtaking, unobstructed south-east views and features a rare oversized 157 sq ft private balcony-an exceptional outdoor space not offered with every unit. Inside, the open-concept layout is bright and functional, complete with in-suite laundry, a well-designed kitchen, and efficient forced air heating and cooling via a hybrid heat pump system. An owned locker provides valuable additional storage. Please note: this unit does not include a parking space. Residents enjoy access to an impressive suite of amenities, including a 5,000 sq ft 6th-floor outdoor retreat with a saltwater pool, terrace, cabanas, BBQs, fire table, and lounge areas. Additional features include an indoor/outdoor yoga studio, fully equipped fitness centre, library, entertainment lounge with indoor-outdoor bar, co-working office space, and bookable boardrooms. The building also offers secure underground parking, bike storage, and a guest suite for visitors. Condo fees are exceptionally well-rounded, covering building insurance, heat, central air conditioning, high-speed fibre internet with unlimited data, private garbage removal, common elements, and landscaping-delivering both value and convenience. Just steps from Uptown Waterloo's vibrant mix of cafés, restaurants, shopping, and parks, this is an incredible opportunity for professionals, first-time buyers, or investors seeking the best of location, lifestyle, and modern condo living."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "488.03"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T12:42:02.709885+00:00"
+"CrossStreet": "Allen Street W and William Street W"
+"Directions": "King Street South, Waterloo"
+"Exclusions": "All tenants possessions; Kitchen Island"
+"ExpirationDate": "2026-11-20"
+"GarageYN": true
+"Inclusions": "Built in wardrobe in bedroom; Blinds; Programmable Thermostat, Washer and Dryer, Dishwasher, Built in fridge and freezer, Ceramic top stove range"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2026-04-24T12:37:43Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-24T12:37:43Z"
+"OriginalListPrice": 369900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3860534"
+"ParcelNumber": "237140128"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T12:37:43Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3726.0"
+"TaxAssessedValue": 272000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "1812"
+"Zoning": "I"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13039316')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"RollNumber": "301603120002478"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Heat pump"
+"HoldoverDays": 60
+"LegalStories": "0"
+"ParkingType1": "None"
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0E7, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-07-03"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 714
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 1
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate with tenant"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LegalApartmentNumber": "0"
+"MediaChangeTimestamp": "2026-04-24T12:37:43Z"
+"PropertyManagementCompany": "King Condo Management"
+"SystemModificationTimestamp": "2026-04-24T12:37:43.858065Z"
+"Media": array:27 [ …27]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4285
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13038848"
+"ListingId": "X13038848"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T03:08:55Z"
+"RFModificationTimestamp": "2026-04-27T15:07:03Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 0G9"
+"UnparsedAddress": "142 Foamflower Place C 41, Waterloo, ON N2V 0G9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.449642
+"Longitude": -80.5885223
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOUSESIGMA INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover modern, spacious living at 142 Foamflower Place, Unit #41, Building C, Waterloo! This beautifully designed 1,100 sq. ft. Dahlia Garden condo offers three generously sized bedrooms, including a primary suite with a walk-in closet and private ensuite, along with two full bathrooms. Enjoy a bright open-concept layout filled with natural light and freshly painted interiors, complemented by a brand-new kitchen backsplash. The home features upgraded finishes throughout, including granite countertops, ceramic tile in key areas, stainless steel appliances, and a pre- installed RO water filtration system. Additional highlights include 9' ceilings, carpet-free flooring, and a private patio, perfect for relaxing or entertaining. The unit comes with one parking space (option for a second Parking for $100 Extra) and includes a ROGERS 1 GB Internet Plan for added convenience. Located in the highly sought-after Vista Hills community, you are just minutes from parks, scenic trails, shopping, top-rated schools, and public transit. This home offers the perfect blend of comfort, style, and location - ideal for families, professionals, or investors."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "304.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-24T03:11:16.091015+00:00"
+"CrossStreet": "Ira Needles Blvd & Erb St W"
+"Directions": "From Ira Needles Blvd turn onto University Ave W, right on Sundew Dr, then left onto Foamflower Place to Building C, Unit 41."
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Carbon Monoxide Detector, Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "319500"
+"MajorChangeTimestamp": "2026-04-24T03:08:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T03:08:55Z"
+"OriginalListPrice": 549900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3865032"
+"ParcelNumber": "238000081"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T03:08:55Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Foamflower"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3737.45"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"UnitNumber": "C 41"
+"VirtualTourURLBranded": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/"
+"VirtualTourURLBranded2": "https://virtualtours.jarts360view.com/cp/142-foamflower-place-c-41-waterloo/"
+"VirtualTourURLUnbranded2": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/nb/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038848')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604000126852"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater, Water Softener."
+"HoldoverDays": 30
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2V 0G9, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 797
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 3
+"SalesBrochureUrl": "https://virtualtours.jarts360view.com/142-foamflower-place-c-41-waterloo/brochure/?1774356225"
+"SquareFootSource": "1100"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "81"
+"MediaChangeTimestamp": "2026-04-24T03:08:55Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-24T03:08:56.238796Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:23 [ …23]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4284
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13038824"
+"ListingId": "X13038824"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T02:50:34Z"
+"RFModificationTimestamp": "2026-04-27T15:07:03Z"
+"ListPrice": 519000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0B3"
+"UnparsedAddress": "223 Erb Street W 501, Waterloo, ON N2L 0B3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4590766
+"Longitude": -80.5363379
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience sophisticated living in the luxurious building in the heart of Waterloo. This rarely offered corner unit features 2 bedrooms, 2 bathrooms, and an office space across 1,351 sq. ft. of thoughtfully designed space with 9-foot ceilings. Flooded with natural light, the home showcases modern finishes, oversized windows, and panoramic city views from every room. Enjoy a spacious kitchen with granite countertops, a large island, and abundant cabinet and counter space-perfect for entertaining. The primary suite includes generous closets and a spa-inspired ensuite with a glass shower, double sinks, and a smart toilet. Step onto your covered balcony, large enough for outdoor dining or lounging. Located just steps from T&T Supermarket, bus stops, and the Waterloo Public Library & Community Centre, with easy access to restaurants, cafes, and universities, this home offers the ultimate in urban convenience. Vacant property. Show with confidence. Photos are from the previous listing."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "1112.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "HOMELIFE LANDMARK REALTY INC."
+"CoListOfficePhone": "905-305-1600"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T02:56:02.797334+00:00"
+"CrossStreet": "Erb St W / Westmount Rd S"
+"Directions": "Erb St W / Westmount Rd S"
+"ExpirationDate": "2026-07-23"
+"GarageYN": true
+"Inclusions": "Top notch amenities including an opulent communal lounge/ library with a grand piano, fitness studio, sauna, an rooftop terrace equipped with BBQ and an indoor party room. 1 Parking and 1 locker included"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"MainOfficeKey": "063000"
+"MajorChangeTimestamp": "2026-04-24T02:50:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-24T02:50:34Z"
+"OriginalListPrice": 519000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864992"
+"ParcelNumber": "000"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T02:50:34Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Erb"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5257.27"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "501"
+"VirtualTourURLUnbranded": "https://youtu.be/d Yje ORJt Gk0"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038824')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "000"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 30
+"LegalStories": "5"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 0B3, CA"
+"ApproximateAge": "11-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 541
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 7
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "1351"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "1"
+"MediaChangeTimestamp": "2026-04-24T02:50:34Z"
+"PropertyManagementCompany": "Wilson"
+"SystemModificationTimestamp": "2026-04-24T02:50:35.225016Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:25 [ …25]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4283
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13038290"
+"ListingId": "X13038290"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-24T00:22:23Z"
+"RFModificationTimestamp": "2026-04-24T00:43:17Z"
+"ListPrice": 2700.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3V5"
+"UnparsedAddress": "649 Albert Street 5, Waterloo, ON N2L 3V5"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "AXIS REALTY BROKERAGE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover a beautiful and well-maintained 3-level townhouse that perfectly balances comfort, space, and location. This inviting home features a newly installed fridge in a functional kitchen, offering a fresh and modern touch for everyday living. With generous living space spread across three levels, there's plenty of room for families, professionals, or students who want extra privacy. The layout is both practical and welcoming, making it easy to relax, work, or entertain. Step outside to enjoy a spacious backyard-ideal for gatherings, outdoor dining, or simply unwinding in your own private space. Located in a prime area close to major universities, schools, and everyday amenities, this home offers unmatched convenience while still being tucked away from the busy student zones-giving you the best of both worlds: desirable location. accessibility and peace. A perfect place to call home, combining space, comfort, and a highly desirable location."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationYN": true
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-23T23:04:07.534020+00:00"
+"CrossStreet": "Albert St/ Weber St"
+"Directions": "Albert St/ Weber St"
+"ExpirationDate": "2026-09-01"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "All Appliances"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-22"
+"MainOfficeKey": "392300"
+"MajorChangeTimestamp": "2026-04-23T22:16:31Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-23T22:16:31Z"
+"OriginalListPrice": 2700.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3864228"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-23T22:16:32Z"
+"PropertyAttachedYN": true
+"RentIncludes": array:1 [ …1]
+"RoomsTotal": "7"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "649"
+"StreetSuffix": "Street"
+"TaxBookNumber": "301604005018476"
+"TransactionBrokerCompensation": "Half Month rent"
+"TransactionType": "For Lease"
+"UnitNumber": "5"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South West"
+"HeatType": "Water"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13038290')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Other"
+"RollNumber": "301604005018476"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 44
+"DenFamilyroomYN": true
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1400-1599"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "owner"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"LegalApartmentNumber": "5"
+"MediaChangeTimestamp": "2026-04-23T22:16:32Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "Krall Property Management Inc."
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2026-04-24T00:22:23.677355Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:15 [ …15]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4282
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13033698"
+"ListingId": "X13033698"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-23T10:31:29Z"
+"RFModificationTimestamp": "2026-04-29T10:47:36Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4L4"
+"UnparsedAddress": "30 Hickory Street 111, Waterloo, ON N2J 4L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479306
+"Longitude": -80.5231564
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 PEOPLE`S CHOICE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your perfect opportunity in the heart of Waterloo! Ideal for first-time home buyers, investors, or parents, this 2-storey, 3-bedroom condo apartment is just minutes from Wilfrid Laurier University, University of Waterloo, and Conestoga College, with easy access to restaurants, gyms, shopping, and transit. This spacious, carpet-free unit features a bright living room with walk-out to a private balcony, a functional kitchen, and a main floor primary bedroom. An interior staircase leads to the lower level, offering two generously sized bedrooms and a full bathroom-perfect for families or student living. Located in a well-maintained building with controlled entry, this property offers excellent layout, convenience, and strong rental potential in a highly sought-after location."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "459.86"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T05:14:37.227587+00:00"
+"CrossStreet": "Weber St N/ University Ave E"
+"Directions": "Weber St N/ University Ave E"
+"ExpirationDate": "2026-09-30"
+"Inclusions": "Refrigerator, Stove"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-23"
+"MainOfficeKey": "059500"
+"MajorChangeTimestamp": "2026-04-23T10:31:29Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-23T10:31:29Z"
+"OriginalListPrice": 375000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3806928"
+"ParcelNumber": "231210011"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-23T10:31:29Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hickory"
+"StreetNumber": "30"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2667.5"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "111"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13033698')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301601175000411"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4L4, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 121
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:5 [ …5]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Lower"
+"LegalApartmentNumber": "11"
+"MediaChangeTimestamp": "2026-04-23T10:31:29Z"
+"PropertyManagementCompany": "Wilson Blanchard Management"
+"SystemModificationTimestamp": "2026-04-23T10:31:29.571649Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:2 [ …2]
}
]
+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 {#4255
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4081
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13056632"
…122
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4082 …144}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4083 …110}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4084 …121}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4085 …109}
]
+success: true
+page_size: 5
+page_count: 8864
+count: 44316
+after_key: ""
}
]
]
