array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40&$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: "636322"
+post_author: 1
+"ListingKey": "X12883376"
+"ListingId": "X12883376"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T15:20:43Z"
+"RFModificationTimestamp": "2026-04-28T17:31:27Z"
+"ListPrice": 1850.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0H1"
+"UnparsedAddress": "247 Northfield Drive E 210, Waterloo, ON N2K 0H1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.510865386158
+"Longitude": -80.521632166484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Available MAY 1st! Discover low-maintenance, modern living in the heart of Waterloo. Unit 210at the Blackstone is a bright, airy 1-bedroom, 1-bath condo offering 573 sq ft of comfortable space. Tall ceilings and built-in blinds enhance the open-concept layout. The kitchen is equipped with stainless steel appliances, durable stone countertops and a contemporary tile backsplash, flowing into the cozy living area with walkout to a private balcony - perfect for morning coffee or evening relaxation. The carpeted bedroom includes a roomy walk-in closet and the 4-piece bathroom is well-appointed. Practical conveniences include in-suite laundry, a storage locker and one underground parking space. The building elevates daily living with plentiful amenities: rooftop terrace with BBQs, exercise room, courtyard with BBQ and firepit, party/study room, bike room and visitor parking. Ideally situated close to Conestoga Mall, grocery stores, restaurants (including Browns Socialhouse), St. Jacobs Market, walking trails and public transit. Ideal for professionals or anyone seeking a well-located, amenity-rich rental in Waterloo."
+"ArchitecturalStyle": "1 Storey/Apt"
+"Basement": array:1 [ …1]
+"BuildingName": "BLACKSTONE"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T07:38:54.398006+00:00"
+"CrossStreet": "Bridge"
+"Directions": "Northfield at Bridge"
+"Exclusions": "None"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": "Controlled Entry,Landscaped,Lighting,Patio,Year Round Living"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer, Window Coverings"
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,On Demand Water Heater,Primary Bedroom - Main Floor,Separate Heating Controls,Separate Hydro Meter,Storage Area Lockers,Water Meter"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"LeaseTerm": "12 Months"
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-28T15:20:43Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-14T12:48:59Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3669592"
+"ParcelNumber": "237100561"
+"ParkingFeatures": "Reserved/Assigned,Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-14T12:48:59Z"
+"PreviousListPrice": 1950.0
+"PriceChangeTimestamp": "2026-04-28T15:20:43Z"
+"RentIncludes": array:10 [ …10]
+"Roof": "Tar and Gravel"
+"SecurityFeatures": array:3 [ …3]
+"ShowingRequirements": array:3 [ …3]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "One Half of One month's rent +HST"
+"TransactionType": "For Lease"
+"UnitNumber": "210"
+"View": array:1 [ …1]
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12883376')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"RollNumber": "301601000104588"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "#65"
+"ParkingType1": "Common"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 710
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Including balcony"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Book through Broker Bay / Supra"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "54"
+"MediaChangeTimestamp": "2026-03-14T12:48:59Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Five Rivers PM"
+"SystemModificationTimestamp": "2026-04-28T15:20:49.078232Z"
+"Media": array:20 [ …20]
+"ID": "636322"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "670503"
+post_author: 1
+"ListingKey": "X12881520"
+"ListingId": "X12881520"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T15:05:05Z"
+"RFModificationTimestamp": "2026-04-28T17:49:02Z"
+"ListPrice": 269000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 516, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Sage X Condos, This Turn-Key Investment Offers Fully Furnished Luxurious Condo Living Steps From Both University Of Waterloo And Wilfrid Laurier. This 1 Bedroom Condo Offers En-Suite Laundry W Top Quality Suite Finishes & Swiss Laminate Flooring Throughout. Granite Kitchen Counter top, Including Under Mount Double-Basin S/S Sink."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:3 [ …3]
+"AssociationFee": "340.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-14T19:59:25.660807+00:00"
+"CrossStreet": "University Ave W & Hemlock St"
+"Directions": "University Ave W & Hemlock St"
+"Exclusions": "None"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "All Elfs, Overhead Microwave, Stove, Dishwasher, Washer & Dryer, Bed, Sofa, Table, Dining Set,"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-13"
+"MainOfficeKey": "248500"
+"MajorChangeTimestamp": "2026-04-28T15:05:05Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-13T18:15:03Z"
+"OriginalListPrice": 299000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3662790"
+"ParkingFeatures": "Surface"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-13T18:15:03Z"
+"PreviousListPrice": 280000.0
+"PriceChangeTimestamp": "2026-04-28T15:05:05Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2713.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "516"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12881520')"
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 60
+"LegalStories": "5"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Other"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:3 [ …3]
+"SquareFootSource": "According to builder"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "516"
+"MediaChangeTimestamp": "2026-03-30T18:19:02Z"
+"PropertyManagementCompany": "Lee Management Solutions (1-800-590-8805)"
+"SystemModificationTimestamp": "2026-04-28T15:05:13.186686Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
+"ID": "670503"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "609651"
+post_author: 1
+"ListingKey": "X12697394"
+"ListingId": "X12697394"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T14:09:51Z"
+"RFModificationTimestamp": "2026-04-29T15:20:28Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3B4"
+"UnparsedAddress": "179 Regina Street N, Waterloo, ON N2J 3B4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4734769
+"Longitude": -80.5228207
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Uptown Prime Location with multiple possibilities! Investors and Developers alike, note that tis vacant home sits across the street from WLU and features RMU-81 Zoning for redevelopment, which entails high density residential that allows for complimentary commercial use. This solid 3 bedroom, 2 bathroom home is great opportunity for rental income with its proximity to both Universities, Uptown Waterloo, and public transit. Upgrades include metal roof (2022), electrical panel with 200amp service (2016). Disclosure: Photos staged with furniture are AI generated."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T16:03:01.230037+00:00"
+"CrossStreet": "Lodge St."
+"DirectionFaces": "East"
+"Directions": "University to Regina"
+"Exclusions": "Large carport in backyard to be removed by seller before closing."
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, Stove, Washer, Dryer"
+"InteriorFeatures": "Water Heater,Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-01-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-28T14:09:51Z"
+"MlsStatus": "Extension"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-01-14T21:37:16Z"
+"OriginalListPrice": 875000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3439698"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "223680046"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-03-31T18:40:56Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 875000.0
+"PriceChangeTimestamp": "2026-03-31T17:40:34Z"
+"Roof": "Metal"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Regina"
+"StreetNumber": "179"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5439.0"
+"TaxAssessedValue": 397000
+"TaxLegalDescription": "PT LT 10 PL 494 CITY OF WATERLOO AS IN 1345286; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 116.62
+"LotShape": "Irregular"
+"LotWidth": 50.08
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12697394')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601335007800"
+"SurveyType": "Available"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3B4, CA"
+"ApproximateAge": "100+"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Price Change"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 8
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:4 [ …4]
+"LotIrregularities": "50.08 X 116.62 X 47.55 X 102.10"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-03-31T18:40:56Z"
+"ExtensionEntryTimestamp": "2026-04-28T14:09:51Z"
+"SystemModificationTimestamp": "2026-04-28T14:09:59.329919Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
+"ID": "609651"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "708295"
+post_author: 1
+"ListingKey": "X13051776"
+"ListingId": "X13051776"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:37:58Z"
+"RFModificationTimestamp": "2026-04-28T23:45:52Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3J2"
+"UnparsedAddress": "381 Timlock Place, Waterloo, ON N2K 3J2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.497693
+"Longitude": -80.501728
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "381 Timlock Place is the kind of address people hold onto. Tucked into one of Waterloo's most coveted family neighbourhoods, the street is quiet, the trees are mature, and everything you need is closer than you think. This family home offers a layout that genuinely works. The main floor is fully accessible, with the primary bedroom and beautifully renovated ensuite (2021) all on one level. Two separate living spaces, each with their own fireplace. The living room features a gas fireplace (2021) with a custom mantel, and the family room has a WETT certified wood burning fireplace for the nights that call for it. Three additional bedrooms and a full bath sit upstairs, and the finished basement gives you space to use however you see fit. New family room flooring (2026), reverse osmosis (2026), sump pump (2026), and a deck (2015) with natural gas fire table round out a home that has been genuinely well looked after. Minutes to UW, Wilfrid Laurier, Grey Silo Golf Course, and the Waterloo Rec Complex. A rare find in a neighbourhood that rarely lets go of its best homes."
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:2 [ …2]
+"CoListOfficeName": "EXP REALTY"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.5"
+"CreationDate": "2026-04-28T14:42:02.832191+00:00"
+"CrossStreet": "Dansbury Dr and Forestlawn Rd"
+"DirectionFaces": "South"
+"Directions": "Heading north on Bridge St W, turn right onto Dansbury Dr and left onto Forestlawn Rd"
+"Exclusions": "All accessible features mounted to walls and ceilings."
+"ExpirationDate": "2026-09-30"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings, Pool Table, Gazebo, Gas Fire Table on deck, Attached Shelving."
+"InteriorFeatures": "Auto Garage Door Remote,Primary Bedroom - Main Floor,Sump Pump,Water Heater,Water Purifier,Water Treatment,Workbench"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-28T13:37:58Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T13:37:58Z"
+"OriginalListPrice": 950000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3880152"
+"ParcelNumber": "222950092"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2026-04-28T13:37:58Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Timlock"
+"StreetNumber": "381"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6877.0"
+"TaxAssessedValue": 502000
+"TaxLegalDescription": "LT 22 PL 1611 CITY OF WATERLOO; S/T869595; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/381_timlock_pl_waterloo_on/"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Baseboard"
+"LotDepth": 64.08
+"LotWidth": 111.73
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13051776')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601372501300"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3J2, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 13
+"PropertyFeatures": array:4 [ …4]
+"CoListOfficeName3": "EXP REALTY"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please call if late/ cancelling your showing. Remove shoes, leave card, and turn off lights when finished."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-28T13:37:58Z"
+"SystemModificationTimestamp": "2026-04-28T13:37:59.191138Z"
+"Media": array:48 [ …48]
+"ID": "708295"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "693466"
+post_author: 1
+"ListingKey": "X13028082"
+"ListingId": "X13028082"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:22:00Z"
+"RFModificationTimestamp": "2026-04-28T13:40:29Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4N8"
+"UnparsedAddress": "513 Havelock Drive, Waterloo, ON N2L 4N8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4892463
+"Longitude": -80.5579673
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "MANOR HILL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Lakeshore Village - One of Waterloo's Most Desirable Neighborhoods! This well-maintained 3+2 bedroom, 2 full bathroom home is perfectly situated in a sought-after, family-friendly community. Freshly painted in April 2025, the home features a custom wood kitchen with granite countertops and a functional layout ideal for everyday living. Enjoy the warmth of a wood-burning fireplace and the added versatility of a finished basement with a separate entrance, offering excellent potential for extended family or additional living space. A standout feature is the large detached garage/workshop (18' x 25'), fully electric and on its own breaker, complete with an EV charger-ideal for electric vehicle owners. An additional garden shed provides even more utility. The large driveway offers ample parking. Step outside to a landscaped yard, perfect for relaxing or entertaining. Located just steps from the Laurel Trail system and within walking distance to public and Catholic elementary schools, this home is also minutes from Laurel Creek Conservation Area, Conestoga Mall, St. Jacobs Market, LRT, YMCA, and the expressway. A new hospital is currently being built nearby, adding future value and convenience. Additional features include a camera/security system and public transit just minutes away. A solid opportunity in a prime Waterloo location-book your showing today!"
+"ArchitecturalStyle": "Bungalow-Raised"
+"Basement": array:3 [ …3]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-22T01:41:55.385518+00:00"
+"CrossStreet": "Northfield Dr W & Havelock Dr"
+"DirectionFaces": "South"
+"Directions": "Driving west on Northfield Drive, Turn left on Havelock drive. Property on right side"
+"Exclusions": "None"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": "Deck,Landscaped,Porch"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "All Appliances, EV Charger, Chest freezer in Basement, Reverse Osmosis Water, Gazebo, Shed"
+"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Primary Bedroom - Main Floor,Storage Area Lockers"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-21"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "273700"
+"MajorChangeTimestamp": "2026-04-22T01:36:56Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-22T01:36:56Z"
+"OriginalListPrice": 899000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3846256"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222660135"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2026-04-22T17:08:31Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:2 [ …2]
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Havelock"
+"StreetNumber": "513"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4383.33"
+"TaxLegalDescription": "LT 8 PL 1323 CITY OF WATERLOO; S/T 444510; WATERLOO"
+"TaxYear": "2025"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "%2+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://zhrealestatephotography.com/Media/download2.asp?0E56AC877BA54C8EA8108302EF1E6AAC"
+"WaterSource": array:1 [ …1]
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 57.61
+"LotShape": "Irregular"
+"LotWidth": 43.05
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13028082')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301604214504100"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"ElectricYNA": "Yes"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Yes"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-06-30"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "Treat As Clear"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "Not Applicable"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-22T17:08:31Z"
+"SystemModificationTimestamp": "2026-04-28T13:22:11.879814Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:32 [ …32]
+"ID": "693466"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "570081"
+post_author: 1
+"ListingKey": "X12678422"
+"ListingId": "X12678422"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:05:00Z"
+"RFModificationTimestamp": "2026-04-28T21:08:00Z"
+"ListPrice": 2250.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street E 407a, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious and well-maintained 2 bedroom, 2 bathroom apartment available for immediate rent in the heart of Waterloo. Prime location just a 5-minute drive to the University of Waterloo and Wilfrid Laurier University. Close to shopping, dining, transit, and everyday essentials. Ideal for students or professionals seeking convenience and comfort."
+"ArchitecturalStyle": "Multi-Level"
+"AssociationAmenities": array:3 [ …3]
+"AssociationFee": "200.46"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T13:13:52.364024+00:00"
+"CrossStreet": "Hickory/Hemlock"
+"Directions": "Hickory/Hemlock"
+"ExpirationDate": "2026-09-30"
+"Furnished": "Unfurnished"
+"Inclusions": "Fridge, Stove, Washer & Dryer."
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-08"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-04-28T13:05:00Z"
+"MlsStatus": "Extension"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-01-08T21:43:54Z"
+"OriginalListPrice": 2250.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3418246"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-08T21:43:55Z"
+"RentIncludes": array:5 [ …5]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "407A"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12678422')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "4"
+"ParkingType1": "None"
+"ParkingType2": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 2
+"CondoCorpNumber": 643
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "65"
+"MediaChangeTimestamp": "2026-03-07T19:09:59Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"ExtensionEntryTimestamp": "2026-04-28T13:05:00Z"
+"PropertyManagementCompany": "First Service Residential"
+"SystemModificationTimestamp": "2026-04-28T13:05:00.677546Z"
+"Media": array:16 [ …16]
+"ID": "570081"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "708296"
+post_author: 1
+"ListingKey": "X13050986"
+"ListingId": "X13050986"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T04:13:04Z"
+"RFModificationTimestamp": "2026-04-28T18:22:05Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 6A6"
+"UnparsedAddress": "312 Faraday Court, Waterloo, ON N2L 6A6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4656733
+"Longitude": -80.5595468
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 312 Faraday Court, nestled in the prestigious Beechwood community of Waterloo. Located on a quiet, tree-lined court in the highlydesirable Craigleith neighbourhood, this beautifully renovated 5-bed, 2 full bath home offers exceptional living just minutes from University of Waterloo, Wilfrid Laurier University, Uptown Waterloo, top-rated schools, shopping, and the region's thriving tech hub. Backing onto open greenspace with no rear neighbours, the private backyard is designed for both relaxation and entertaining. Enjoy a recently installed cedar deck with Kawartha stone accents, an extended gas line for BBQ, a low-maintenance hot tub, and a by-law compliant bunky, perfect for guests, a studio, oradditional workspace. Inside, the bright open-concept main level features hardwood floors, upgraded lighting, and modern finishes throughout. The chef-inspired kitchen is complete with custom shaker-style cabinetry, white marble countertops, a large island, and stainless steelappliances, all overlooking the backyard through charming bay windows. The adjoining family room with gas fireplace offers a warm and invitingspace with walkout to a sunken patio. Upstairs, the spacious primary suite provides a private retreat with its own ensuite and dual closets, whilethree additional bedrooms and an updated family bathroom complete the upper level. The finished lower level expands your living space with alarge recreation room, bar, and an additional bedroom, ideal for extended family or entertaining. Residents enjoy exclusive access to the Craigleith Homes Association amenities, including a private pool and tennis/pickleball courts, all within walking distance. Surrounded by parks,playgrounds, and scenic walking and biking trails, this location offers the perfect balance of peaceful suburban living and urban convenience."
+"ArchitecturalStyle": "Sidesplit"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T04:16:37.758700+00:00"
+"CrossStreet": "Columbia & Westmount"
+"DirectionFaces": "North"
+"Directions": "Columbia & Westmount"
+"ExpirationDate": "2026-08-26"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-28T04:13:04Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T04:13:04Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3878588"
+"ParcelNumber": "223800052"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-28T04:13:04Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Faraday"
+"StreetNumber": "312"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "7549.0"
+"TaxAssessedValue": 551000
+"TaxLegalDescription": "LT 88 PL 1435 CITY OF WATERLOO; S/T 607060; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/6u10x_312_faraday_ct_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/6u10x_312_faraday_ct_waterloo_on/"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 103.94
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13050986')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604178002200"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 6A6, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 4
+"PropertyFeatures": array:3 [ …3]
+"LotIrregularities": "106.38 ft x 50.08 ft x 103.94 ftx50.14ft"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE BOOK YOUR SHOWING THROUGH BROKERBAY."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-28T04:13:04Z"
+"SystemModificationTimestamp": "2026-04-28T04:13:05.010304Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "708296"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "702373"
+post_author: 1
+"ListingKey": "X13045936"
+"ListingId": "X13045936"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T04:06:42Z"
+"RFModificationTimestamp": "2026-04-28T04:10:37Z"
+"ListPrice": 309900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 16, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Sage X Modern Living! This Stunning 1 Bedroom Condo. Includes a Rare Premium Covered Parking Spot. Located just Steps From The University of Waterloo and Wilfred Laurier University, Surrounded by Shopping, Restaurants, and Parks, with Easy Access To The Highway.This Move-In-Ready Condo Features an Open Layout That Integrates The Living, Dining, and Kitchen Areas. The Suite Is fully Equipped With Granite Countertops, Built-in Stainless Steel Appliances, and In-Suite Laundry. The Fully Furnished Condo Comes with, Built-in Study Table with Shelves and Office Chair, Bed Frame and Mattress, Sofa and Coffee Table, Dining table and Chairs, TV and TV Console. Residents Can Enjoy Premium Amenities, Including a Gym, Rooftop Deck, Party Room, Lounge area, bike locker, and visitor parking. This is an exceptional opportunity whether you are an investor or an end-user. Just move in and enjoy!"
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "613.44"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"BuildingName": "Sage X"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T18:43:49.285842+00:00"
+"CrossStreet": "University Ave. & Hemlock St."
+"Directions": "University Ave. & Hemlock St."
+"ExpirationDate": "2026-08-31"
+"InteriorFeatures": "Carpet Free,Separate Heating Controls"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-26"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-26T18:26:22Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-26T18:26:22Z"
+"OriginalListPrice": 309900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3871480"
+"ParcelNumber": "236790057"
+"ParkingFeatures": "Private,Covered"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-26T18:26:22Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2699.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "616"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13045936')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004177"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "6"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-09-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "457"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "616"
+"MediaChangeTimestamp": "2026-04-26T18:26:22Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-28T04:06:45.538996Z"
+"Media": array:23 [ …23]
+"ID": "702373"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "708297"
+post_author: 1
+"ListingKey": "X13042298"
+"ListingId": "X13042298"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-27T21:05:46Z"
+"RFModificationTimestamp": "2026-04-27T23:39:46Z"
+"ListPrice": 466000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 500.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0K7"
+"UnparsedAddress": "145 Columbia Street 1736, Waterloo, ON N2L 0K7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REALTY SERVICES INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 145 Society Condos - your search for the perfect turnkey investment ends here! This thoughtfully designed unit features an open-concept layout flooded with natural light, complete with floor-to-ceiling windows, modern light fixtures, and high beamed ceilings.Enjoy a sun-filled bedroom, modern 3-piece bathroom, laminate flooring throughout, barn-style sliding doors, and a media accent wall. The den is generously sized and functions as a true second bedroom, complete with a built-in bed and desk-ideal for a roommate or maximizing rental income. State of the Art Elegant Building Amenities Include: Starbucks On The Main Floor Of The Building, World-Class Fitness Centre, Yoga Studio, Basketball Court, Sauna, Party Room,Multimedia Room, Rooftop Terrace with Panoramic Views, Games Room, 24-hr Security, Key-less Entry, Business, Studying And Networking Lounges and more."
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "311.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T20:29:46.400260+00:00"
+"CrossStreet": "Columbia St @ Philip St"
+"Directions": "Columbia St @ Philip St"
+"Exclusions": "Tenant's Belongings"
+"ExpirationDate": "2026-09-02"
+"GarageYN": true
+"Inclusions": "Stainless Steel Dishwasher, Stainless Steel Microwave Range, Stainless Steel Stove, Stainless Steel Fridge, Stacked Washer & Dryer, All Electrical Light Fixtures."
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-24"
+"LotSizeSource": "Other"
+"MainOfficeKey": "498000"
+"MajorChangeTimestamp": "2026-04-24T18:41:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-24T18:41:33Z"
+"OriginalListPrice": 466000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3868124"
+"ParcelNumber": "237930400"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T18:41:33Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3300.0"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1736"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13042298')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "04125013462"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "N/A"
+"HoldoverDays": 90
+"LegalStories": "17"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 790
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Owner"
+"PossessionDetails": "Tenanted"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "36"
+"MediaChangeTimestamp": "2026-04-24T18:41:33Z"
+"PropertyManagementCompany": "Craft Property Group"
+"SystemModificationTimestamp": "2026-04-27T21:05:49.701103Z"
+"Media": array:39 [ …39]
+"ID": "708297"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "708298"
+post_author: 1
+"ListingKey": "X13048204"
+"ListingId": "X13048204"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-27T19:56:17Z"
+"RFModificationTimestamp": "2026-04-28T22:51:44Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 6L9"
+"UnparsedAddress": "12 Euclid Avenue, Waterloo, ON N2L 6L9"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Prime Uptown Waterloo Location - Rare Freehold End-Unit with In-Law Suite! Welcome to this exceptional 4 bedroom, 3 bath freehold end-unit townhouse located in the heart of prime Uptown Waterloo-just steps from the LRT, top restaurants, and all the amenities that make this area so desirable. Truly a rare find, this bright, spacious, and meticulously maintained home offers unmatched flexibility, charm, and convenience. One of the standout features is the fully separated in-law suite with a private entrance from the side yard-ideal for extended family, guests, or potential rental income. With no monthly fees, this freehold property offers outstanding value in one of Waterloo's most vibrant neighborhoods. The thoughtfully designed layout includes a main floor primary bedroom with a large bathroom featuring a whirlpool tub and separate shower, second bedroom on main floor currently used as dining room, Upstairs, you'll find a generously sized bedroom and a full bath, perfect for family or visitors. Enjoy the comfort of a double-wide driveway with additional street parking, a private backyard, and a vaulted-ceiling family room that brings in an abundance of natural light complimented with a gas fireplace . Additional highlights include a covered front porch, generator rough-in for peace of mind, and timeless architectural details throughout. Don't miss this absolutely one-of-a-kind opportunity to own a versatile and beautifully appointed home in one of the region's most sought-after locations. Roof 2010, Furnace 2016"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T16:13:39.970776+00:00"
+"CrossStreet": "Erb St W"
+"DirectionFaces": "West"
+"Directions": "Erb St W to Euclid Ave"
+"ExpirationDate": "2026-07-27"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Hot Water Tank Owned, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": "Auto Garage Door Remote,Generator - Full,In-Law Capability,In-Law Suite,Sump Pump,Water Purifier,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-27"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-04-27T16:05:28Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-27T16:05:28Z"
+"OriginalListPrice": 850000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3875664"
+"ParcelNumber": "224110102"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-27T16:05:28Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Rolled"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Euclid"
+"StreetNumber": "12"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6014.0"
+"TaxLegalDescription": "PART LOTS 1 AND 2, PLAN 495 DESIGNATED AS PART 16 ON 58R-11625. S/T EASE LT25355 IN FAVOR OF UNION GAS LIMITED OVER ALL. CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "GR"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 89.31
+"LotWidth": 34.97
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13048204')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301603090000200"
+"SurveyType": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 3
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 14
+"RoomsBelowGrade": 6
+"LotSizeAreaUnits": "Acres"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 5
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 2
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Book through Brokerbay"
+"MediaChangeTimestamp": "2026-04-27T16:05:28Z"
+"SystemModificationTimestamp": "2026-04-27T19:56:29.885809Z"
+"Media": array:45 [ …45]
+"ID": "708298"
}
]
+success: true
+page_size: 10
+page_count: 30
+count: 300
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Cache Key: 96d46e2fa0add62852446ae8c384399211aeb34fecae50a3bc58289f12893808" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3102
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4295
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12883376"
+"ListingId": "X12883376"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T15:20:43Z"
+"RFModificationTimestamp": "2026-04-28T17:31:27Z"
+"ListPrice": 1850.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 0H1"
+"UnparsedAddress": "247 Northfield Drive E 210, Waterloo, ON N2K 0H1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.510865386158
+"Longitude": -80.521632166484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Available MAY 1st! Discover low-maintenance, modern living in the heart of Waterloo. Unit 210at the Blackstone is a bright, airy 1-bedroom, 1-bath condo offering 573 sq ft of comfortable space. Tall ceilings and built-in blinds enhance the open-concept layout. The kitchen is equipped with stainless steel appliances, durable stone countertops and a contemporary tile backsplash, flowing into the cozy living area with walkout to a private balcony - perfect for morning coffee or evening relaxation. The carpeted bedroom includes a roomy walk-in closet and the 4-piece bathroom is well-appointed. Practical conveniences include in-suite laundry, a storage locker and one underground parking space. The building elevates daily living with plentiful amenities: rooftop terrace with BBQs, exercise room, courtyard with BBQ and firepit, party/study room, bike room and visitor parking. Ideally situated close to Conestoga Mall, grocery stores, restaurants (including Browns Socialhouse), St. Jacobs Market, walking trails and public transit. Ideal for professionals or anyone seeking a well-located, amenity-rich rental in Waterloo."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"BuildingName": "BLACKSTONE"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T07:38:54.398006+00:00"
+"CrossStreet": "Bridge"
+"Directions": "Northfield at Bridge"
+"Exclusions": "None"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": array:5 [ …5]
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"LeaseTerm": "12 Months"
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-03-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-28T15:20:43Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-03-14T12:48:59Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3669592"
+"ParcelNumber": "237100561"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-14T12:48:59Z"
+"PreviousListPrice": 1950.0
+"PriceChangeTimestamp": "2026-04-28T15:20:43Z"
+"RentIncludes": array:10 [ …10]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:3 [ …3]
+"ShowingRequirements": array:3 [ …3]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "One Half of One month's rent +HST"
+"TransactionType": "For Lease"
+"UnitNumber": "210"
+"View": array:1 [ …1]
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12883376')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"RollNumber": "301601000104588"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "#65"
+"ParkingType1": "Common"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Direct Withdrawal"
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 710
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Including balcony"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Book through Broker Bay / Supra"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "54"
+"MediaChangeTimestamp": "2026-03-14T12:48:59Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Five Rivers PM"
+"SystemModificationTimestamp": "2026-04-28T15:20:49.078232Z"
+"Media": array:20 [ …20]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4296
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12881520"
+"ListingId": "X12881520"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T15:05:05Z"
+"RFModificationTimestamp": "2026-04-28T17:49:02Z"
+"ListPrice": 269000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 516, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.475832
+"Longitude": -80.531973
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Sage X Condos, This Turn-Key Investment Offers Fully Furnished Luxurious Condo Living Steps From Both University Of Waterloo And Wilfrid Laurier. This 1 Bedroom Condo Offers En-Suite Laundry W Top Quality Suite Finishes & Swiss Laminate Flooring Throughout. Granite Kitchen Counter top, Including Under Mount Double-Basin S/S Sink."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:3 [ …3]
+"AssociationFee": "340.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-14T19:59:25.660807+00:00"
+"CrossStreet": "University Ave W & Hemlock St"
+"Directions": "University Ave W & Hemlock St"
+"Exclusions": "None"
+"ExpirationDate": "2026-06-30"
+"Inclusions": "All Elfs, Overhead Microwave, Stove, Dishwasher, Washer & Dryer, Bed, Sofa, Table, Dining Set,"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-03-13"
+"MainOfficeKey": "248500"
+"MajorChangeTimestamp": "2026-04-28T15:05:05Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-13T18:15:03Z"
+"OriginalListPrice": 299000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3662790"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-13T18:15:03Z"
+"PreviousListPrice": 280000.0
+"PriceChangeTimestamp": "2026-04-28T15:05:05Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2713.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "516"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12881520')"
+"GarageType": "Surface"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 60
+"LegalStories": "5"
+"ParkingType1": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Other"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:3 [ …3]
+"SquareFootSource": "According to builder"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "516"
+"MediaChangeTimestamp": "2026-03-30T18:19:02Z"
+"PropertyManagementCompany": "Lee Management Solutions (1-800-590-8805)"
+"SystemModificationTimestamp": "2026-04-28T15:05:13.186686Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:9 [ …9]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4299
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12697394"
+"ListingId": "X12697394"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T14:09:51Z"
+"RFModificationTimestamp": "2026-04-29T15:20:28Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3B4"
+"UnparsedAddress": "179 Regina Street N, Waterloo, ON N2J 3B4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4734769
+"Longitude": -80.5228207
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Uptown Prime Location with multiple possibilities! Investors and Developers alike, note that tis vacant home sits across the street from WLU and features RMU-81 Zoning for redevelopment, which entails high density residential that allows for complimentary commercial use. This solid 3 bedroom, 2 bathroom home is great opportunity for rental income with its proximity to both Universities, Uptown Waterloo, and public transit. Upgrades include metal roof (2022), electrical panel with 200amp service (2016). Disclosure: Photos staged with furniture are AI generated."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T16:03:01.230037+00:00"
+"CrossStreet": "Lodge St."
+"DirectionFaces": "East"
+"Directions": "University to Regina"
+"Exclusions": "Large carport in backyard to be removed by seller before closing."
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, Stove, Washer, Dryer"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-01-14"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-28T14:09:51Z"
+"MlsStatus": "Extension"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-01-14T21:37:16Z"
+"OriginalListPrice": 875000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3439698"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "223680046"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-03-31T18:40:56Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 875000.0
+"PriceChangeTimestamp": "2026-03-31T17:40:34Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "Regina"
+"StreetNumber": "179"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5439.0"
+"TaxAssessedValue": 397000
+"TaxLegalDescription": "PT LT 10 PL 494 CITY OF WATERLOO AS IN 1345286; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 116.62
+"LotShape": "Irregular"
+"LotWidth": 50.08
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12697394')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601335007800"
+"SurveyType": "Available"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3B4, CA"
+"ApproximateAge": "100+"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Price Change"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 8
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:4 [ …4]
+"LotIrregularities": "50.08 X 116.62 X 47.55 X 102.10"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-03-31T18:40:56Z"
+"ExtensionEntryTimestamp": "2026-04-28T14:09:51Z"
+"SystemModificationTimestamp": "2026-04-28T14:09:59.329919Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4298
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13051776"
+"ListingId": "X13051776"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:37:58Z"
+"RFModificationTimestamp": "2026-04-28T23:45:52Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3J2"
+"UnparsedAddress": "381 Timlock Place, Waterloo, ON N2K 3J2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.497693
+"Longitude": -80.501728
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "381 Timlock Place is the kind of address people hold onto. Tucked into one of Waterloo's most coveted family neighbourhoods, the street is quiet, the trees are mature, and everything you need is closer than you think. This family home offers a layout that genuinely works. The main floor is fully accessible, with the primary bedroom and beautifully renovated ensuite (2021) all on one level. Two separate living spaces, each with their own fireplace. The living room features a gas fireplace (2021) with a custom mantel, and the family room has a WETT certified wood burning fireplace for the nights that call for it. Three additional bedrooms and a full bath sit upstairs, and the finished basement gives you space to use however you see fit. New family room flooring (2026), reverse osmosis (2026), sump pump (2026), and a deck (2015) with natural gas fire table round out a home that has been genuinely well looked after. Minutes to UW, Wilfrid Laurier, Grey Silo Golf Course, and the Waterloo Rec Complex. A rare find in a neighbourhood that rarely lets go of its best homes."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CoListOfficeName": "EXP REALTY"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.5"
+"CreationDate": "2026-04-28T14:42:02.832191+00:00"
+"CrossStreet": "Dansbury Dr and Forestlawn Rd"
+"DirectionFaces": "South"
+"Directions": "Heading north on Bridge St W, turn right onto Dansbury Dr and left onto Forestlawn Rd"
+"Exclusions": "All accessible features mounted to walls and ceilings."
+"ExpirationDate": "2026-09-30"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings, Pool Table, Gazebo, Gas Fire Table on deck, Attached Shelving."
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-28T13:37:58Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T13:37:58Z"
+"OriginalListPrice": 950000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3880152"
+"ParcelNumber": "222950092"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2026-04-28T13:37:58Z"
+"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": "Timlock"
+"StreetNumber": "381"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6877.0"
+"TaxAssessedValue": 502000
+"TaxLegalDescription": "LT 22 PL 1611 CITY OF WATERLOO; S/T869595; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/381_timlock_pl_waterloo_on/"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Baseboard"
+"LotDepth": 64.08
+"LotWidth": 111.73
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13051776')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "301601372501300"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"HeatTypeMulti": array:2 [ …2]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2K 3J2, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:3 [ …3]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 13
+"PropertyFeatures": array:4 [ …4]
+"CoListOfficeName3": "EXP REALTY"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please call if late/ cancelling your showing. Remove shoes, leave card, and turn off lights when finished."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-28T13:37:58Z"
+"SystemModificationTimestamp": "2026-04-28T13:37:59.191138Z"
+"Media": array:48 [ …48]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4297
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13028082"
+"ListingId": "X13028082"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:22:00Z"
+"RFModificationTimestamp": "2026-04-28T13:40:29Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4N8"
+"UnparsedAddress": "513 Havelock Drive, Waterloo, ON N2L 4N8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4892463
+"Longitude": -80.5579673
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "MANOR HILL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Lakeshore Village - One of Waterloo's Most Desirable Neighborhoods! This well-maintained 3+2 bedroom, 2 full bathroom home is perfectly situated in a sought-after, family-friendly community. Freshly painted in April 2025, the home features a custom wood kitchen with granite countertops and a functional layout ideal for everyday living. Enjoy the warmth of a wood-burning fireplace and the added versatility of a finished basement with a separate entrance, offering excellent potential for extended family or additional living space. A standout feature is the large detached garage/workshop (18' x 25'), fully electric and on its own breaker, complete with an EV charger-ideal for electric vehicle owners. An additional garden shed provides even more utility. The large driveway offers ample parking. Step outside to a landscaped yard, perfect for relaxing or entertaining. Located just steps from the Laurel Trail system and within walking distance to public and Catholic elementary schools, this home is also minutes from Laurel Creek Conservation Area, Conestoga Mall, St. Jacobs Market, LRT, YMCA, and the expressway. A new hospital is currently being built nearby, adding future value and convenience. Additional features include a camera/security system and public transit just minutes away. A solid opportunity in a prime Waterloo location-book your showing today!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:3 [ …3]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-22T01:41:55.385518+00:00"
+"CrossStreet": "Northfield Dr W & Havelock Dr"
+"DirectionFaces": "South"
+"Directions": "Driving west on Northfield Drive, Turn left on Havelock drive. Property on right side"
+"Exclusions": "None"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": array:3 [ …3]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "All Appliances, EV Charger, Chest freezer in Basement, Reverse Osmosis Water, Gazebo, Shed"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-21"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "273700"
+"MajorChangeTimestamp": "2026-04-22T01:36:56Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-22T01:36:56Z"
+"OriginalListPrice": 899000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3846256"
+"OtherStructures": array:4 [ …4]
+"ParcelNumber": "222660135"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2026-04-22T17:08:31Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Havelock"
+"StreetNumber": "513"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4383.33"
+"TaxLegalDescription": "LT 8 PL 1323 CITY OF WATERLOO; S/T 444510; WATERLOO"
+"TaxYear": "2025"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "%2+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://zhrealestatephotography.com/Media/download2.asp?0E56AC877BA54C8EA8108302EF1E6AAC"
+"WaterSource": array:1 [ …1]
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Yes"
+"HeatType": "Forced Air"
+"LotDepth": 57.61
+"LotShape": "Irregular"
+"LotWidth": 43.05
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13028082')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301604214504100"
+"SurveyType": "Unknown"
+"Winterized": "Fully"
+"ElectricYNA": "Yes"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Yes"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-06-30"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "Treat As Clear"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 3
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "Not Applicable"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-22T17:08:31Z"
+"SystemModificationTimestamp": "2026-04-28T13:22:11.879814Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:32 [ …32]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4294
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12678422"
+"ListingId": "X12678422"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T13:05:00Z"
+"RFModificationTimestamp": "2026-04-28T21:08:00Z"
+"ListPrice": 2250.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "275 Larch Street E 407a, Waterloo, ON N2L 3R2"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious and well-maintained 2 bedroom, 2 bathroom apartment available for immediate rent in the heart of Waterloo. Prime location just a 5-minute drive to the University of Waterloo and Wilfrid Laurier University. Close to shopping, dining, transit, and everyday essentials. Ideal for students or professionals seeking convenience and comfort."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:3 [ …3]
+"AssociationFee": "200.46"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T13:13:52.364024+00:00"
+"CrossStreet": "Hickory/Hemlock"
+"Directions": "Hickory/Hemlock"
+"ExpirationDate": "2026-09-30"
+"Furnished": "Unfurnished"
+"Inclusions": "Fridge, Stove, Washer & Dryer."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-08"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-04-28T13:05:00Z"
+"MlsStatus": "Extension"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-01-08T21:43:54Z"
+"OriginalListPrice": 2250.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3418246"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-08T21:43:55Z"
+"RentIncludes": array:5 [ …5]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "407A"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12678422')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "4"
+"ParkingType1": "None"
+"ParkingType2": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 2
+"CondoCorpNumber": 643
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "65"
+"MediaChangeTimestamp": "2026-03-07T19:09:59Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"ExtensionEntryTimestamp": "2026-04-28T13:05:00Z"
+"PropertyManagementCompany": "First Service Residential"
+"SystemModificationTimestamp": "2026-04-28T13:05:00.677546Z"
+"Media": array:16 [ …16]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4293
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13050986"
+"ListingId": "X13050986"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T04:13:04Z"
+"RFModificationTimestamp": "2026-04-28T18:22:05Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 6A6"
+"UnparsedAddress": "312 Faraday Court, Waterloo, ON N2L 6A6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4656733
+"Longitude": -80.5595468
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 312 Faraday Court, nestled in the prestigious Beechwood community of Waterloo. Located on a quiet, tree-lined court in the highlydesirable Craigleith neighbourhood, this beautifully renovated 5-bed, 2 full bath home offers exceptional living just minutes from University of Waterloo, Wilfrid Laurier University, Uptown Waterloo, top-rated schools, shopping, and the region's thriving tech hub. Backing onto open greenspace with no rear neighbours, the private backyard is designed for both relaxation and entertaining. Enjoy a recently installed cedar deck with Kawartha stone accents, an extended gas line for BBQ, a low-maintenance hot tub, and a by-law compliant bunky, perfect for guests, a studio, oradditional workspace. Inside, the bright open-concept main level features hardwood floors, upgraded lighting, and modern finishes throughout. The chef-inspired kitchen is complete with custom shaker-style cabinetry, white marble countertops, a large island, and stainless steelappliances, all overlooking the backyard through charming bay windows. The adjoining family room with gas fireplace offers a warm and invitingspace with walkout to a sunken patio. Upstairs, the spacious primary suite provides a private retreat with its own ensuite and dual closets, whilethree additional bedrooms and an updated family bathroom complete the upper level. The finished lower level expands your living space with alarge recreation room, bar, and an additional bedroom, ideal for extended family or entertaining. Residents enjoy exclusive access to the Craigleith Homes Association amenities, including a private pool and tennis/pickleball courts, all within walking distance. Surrounded by parks,playgrounds, and scenic walking and biking trails, this location offers the perfect balance of peaceful suburban living and urban convenience."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T04:16:37.758700+00:00"
+"CrossStreet": "Columbia & Westmount"
+"DirectionFaces": "North"
+"Directions": "Columbia & Westmount"
+"ExpirationDate": "2026-08-26"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2026-04-28T04:13:04Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-28T04:13:04Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3878588"
+"ParcelNumber": "223800052"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-04-28T04:13:04Z"
+"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": "Faraday"
+"StreetNumber": "312"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "7549.0"
+"TaxAssessedValue": 551000
+"TaxLegalDescription": "LT 88 PL 1435 CITY OF WATERLOO; S/T 607060; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/6u10x_312_faraday_ct_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/6u10x_312_faraday_ct_waterloo_on/"
+"Zoning": "SR2A"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 103.94
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13050986')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604178002200"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 6A6, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 4
+"PropertyFeatures": array:3 [ …3]
+"LotIrregularities": "106.38 ft x 50.08 ft x 103.94 ftx50.14ft"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE BOOK YOUR SHOWING THROUGH BROKERBAY."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2026-04-28T04:13:04Z"
+"SystemModificationTimestamp": "2026-04-28T04:13:05.010304Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4292
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13045936"
+"ListingId": "X13045936"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-28T04:06:42Z"
+"RFModificationTimestamp": "2026-04-28T04:10:37Z"
+"ListPrice": 309900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R4"
+"UnparsedAddress": "257 Hemlock Street 16, Waterloo, ON N2L 3R4"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Sage X Modern Living! This Stunning 1 Bedroom Condo. Includes a Rare Premium Covered Parking Spot. Located just Steps From The University of Waterloo and Wilfred Laurier University, Surrounded by Shopping, Restaurants, and Parks, with Easy Access To The Highway.This Move-In-Ready Condo Features an Open Layout That Integrates The Living, Dining, and Kitchen Areas. The Suite Is fully Equipped With Granite Countertops, Built-in Stainless Steel Appliances, and In-Suite Laundry. The Fully Furnished Condo Comes with, Built-in Study Table with Shelves and Office Chair, Bed Frame and Mattress, Sofa and Coffee Table, Dining table and Chairs, TV and TV Console. Residents Can Enjoy Premium Amenities, Including a Gym, Rooftop Deck, Party Room, Lounge area, bike locker, and visitor parking. This is an exceptional opportunity whether you are an investor or an end-user. Just move in and enjoy!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:6 [ …6]
+"AssociationFee": "613.44"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"BuildingName": "Sage X"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-27T18:43:49.285842+00:00"
+"CrossStreet": "University Ave. & Hemlock St."
+"Directions": "University Ave. & Hemlock St."
+"ExpirationDate": "2026-08-31"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-26"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2026-04-26T18:26:22Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-26T18:26:22Z"
+"OriginalListPrice": 309900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3871480"
+"ParcelNumber": "236790057"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-26T18:26:22Z"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2699.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "616"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13045936')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604225004177"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "6"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-09-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 679
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "457"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "616"
+"MediaChangeTimestamp": "2026-04-26T18:26:22Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-28T04:06:45.538996Z"
+"Media": array:23 [ …23]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13042298"
+"ListingId": "X13042298"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-27T21:05:46Z"
+"RFModificationTimestamp": "2026-04-27T23:39:46Z"
+"ListPrice": 466000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 500.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0K7"
+"UnparsedAddress": "145 Columbia Street 1736, Waterloo, ON N2L 0K7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REALTY SERVICES INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 145 Society Condos - your search for the perfect turnkey investment ends here! This thoughtfully designed unit features an open-concept layout flooded with natural light, complete with floor-to-ceiling windows, modern light fixtures, and high beamed ceilings.Enjoy a sun-filled bedroom, modern 3-piece bathroom, laminate flooring throughout, barn-style sliding doors, and a media accent wall. The den is generously sized and functions as a true second bedroom, complete with a built-in bed and desk-ideal for a roommate or maximizing rental income. State of the Art Elegant Building Amenities Include: Starbucks On The Main Floor Of The Building, World-Class Fitness Centre, Yoga Studio, Basketball Court, Sauna, Party Room,Multimedia Room, Rooftop Terrace with Panoramic Views, Games Room, 24-hr Security, Key-less Entry, Business, Studying And Networking Lounges and more."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "311.0"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-24T20:29:46.400260+00:00"
+"CrossStreet": "Columbia St @ Philip St"
+"Directions": "Columbia St @ Philip St"
+"Exclusions": "Tenant's Belongings"
+"ExpirationDate": "2026-09-02"
+"GarageYN": true
+"Inclusions": "Stainless Steel Dishwasher, Stainless Steel Microwave Range, Stainless Steel Stove, Stainless Steel Fridge, Stacked Washer & Dryer, All Electrical Light Fixtures."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-24"
+"LotSizeSource": "Other"
+"MainOfficeKey": "498000"
+"MajorChangeTimestamp": "2026-04-24T18:41:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-24T18:41:33Z"
+"OriginalListPrice": 466000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3868124"
+"ParcelNumber": "237930400"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-24T18:41:33Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3300.0"
+"TaxYear": "2026"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "1736"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13042298')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "04125013462"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "N/A"
+"HoldoverDays": 90
+"LegalStories": "17"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 790
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"SquareFootSource": "Owner"
+"PossessionDetails": "Tenanted"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "36"
+"MediaChangeTimestamp": "2026-04-24T18:41:33Z"
+"PropertyManagementCompany": "Craft Property Group"
+"SystemModificationTimestamp": "2026-04-27T21:05:49.701103Z"
+"Media": array:39 [ …39]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13048204"
+"ListingId": "X13048204"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-27T19:56:17Z"
+"RFModificationTimestamp": "2026-04-28T22:51:44Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 6L9"
+"UnparsedAddress": "12 Euclid Avenue, Waterloo, ON N2L 6L9"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Prime Uptown Waterloo Location - Rare Freehold End-Unit with In-Law Suite! Welcome to this exceptional 4 bedroom, 3 bath freehold end-unit townhouse located in the heart of prime Uptown Waterloo-just steps from the LRT, top restaurants, and all the amenities that make this area so desirable. Truly a rare find, this bright, spacious, and meticulously maintained home offers unmatched flexibility, charm, and convenience. One of the standout features is the fully separated in-law suite with a private entrance from the side yard-ideal for extended family, guests, or potential rental income. With no monthly fees, this freehold property offers outstanding value in one of Waterloo's most vibrant neighborhoods. The thoughtfully designed layout includes a main floor primary bedroom with a large bathroom featuring a whirlpool tub and separate shower, second bedroom on main floor currently used as dining room, Upstairs, you'll find a generously sized bedroom and a full bath, perfect for family or visitors. Enjoy the comfort of a double-wide driveway with additional street parking, a private backyard, and a vaulted-ceiling family room that brings in an abundance of natural light complimented with a gas fireplace . Additional highlights include a covered front porch, generator rough-in for peace of mind, and timeless architectural details throughout. Don't miss this absolutely one-of-a-kind opportunity to own a versatile and beautifully appointed home in one of the region's most sought-after locations. Roof 2010, Furnace 2016"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-27T16:13:39.970776+00:00"
+"CrossStreet": "Erb St W"
+"DirectionFaces": "West"
+"Directions": "Erb St W to Euclid Ave"
+"ExpirationDate": "2026-07-27"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Hot Water Tank Owned, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-27"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2026-04-27T16:05:28Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-27T16:05:28Z"
+"OriginalListPrice": 850000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3875664"
+"ParcelNumber": "224110102"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-27T16:05:28Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Euclid"
+"StreetNumber": "12"
+"StreetSuffix": "Avenue"
…46
}
]
+success: true
+page_size: 10
+page_count: 30
+count: 300
+after_key: ""
}
]
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4076
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4078 …121}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4100 …124}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4077 …125}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4101 …115}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4099 …122}
]
+success: true
+page_size: 5
+page_count: 9921
+count: 49603
+after_key: ""
}
"RF Response Time" => "0.39 seconds"
]
]
