array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29232199/Property?$select=ALL&$top=20&$filter=ListingKey eq 29232199&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29232199/Property?$select=ALL&$top=20&$filter=ListingKey eq 29232199&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23445
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23447
+post_id: "521503"
+post_author: 1
+"ListingKey": "29232199"
+"ListingId": "40796948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T01:40:09Z"
+"RFModificationTimestamp": "2026-01-09T01:42:28Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1285.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "433 KEATS Way Unit# 2, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5570764
1 => 43.4580334
]
+"Latitude": 43.4580334
+"Longitude": -80.5570764
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing opportunity to lease in the highly sought-after Beechwood area, offering exceptional access to shopping, transit, and the University of Waterloo campus. This spacious 3-bedroom home checks all the boxes and showcases numerous upgrades, including bamboo hardwood flooring on the main and second levels, tasteful kitchen finishes, and a wet bar/summer kitchen in the finished basement. The exterior features a dedicated parking space and a large, fully fenced, landscaped backyard-perfect for outdoor enjoyment. A fantastic leasing opportunity in a prime location at excellent value in today's market. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T01:35:40.295606+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224068"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-01-09T01:29:14Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T01:29:14Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2281"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1558137152"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796948"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29232199"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T01:29:14.75Z"
]
1 => array:11 [
"RoomKey" => "1558137153"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796948"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29232199"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T01:29:14.75Z"
]
2 => array:11 [
"RoomKey" => "1558137154"
"RoomType" => "Bedroom"
"ListingId" => "40796948"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29232199"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T01:29:14.75Z"
]
3 => array:11 [
"RoomKey" => "1558137155"
"RoomType" => "Bedroom"
"ListingId" => "40796948"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29232199"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T01:29:14.75Z"
]
4 => array:11 [
"RoomKey" => "1558137156"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796948"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29232199"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T01:29:14.76Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29232199/433-keats-way-unit-2-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2095641"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "284587"
+"GeocodeManualYN": true
+"TotalActualRent": 2400
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1285
+"OriginalEntryTimestamp": "2026-01-09T01:00:24.82Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6397442859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/69f6058aa20f9e6db783abce7a958f34.webp"
"MediaSize" => 65132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-69f6058aa20f9e6db783abce7a958f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6397442874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/5c26411b19241e374f3ed1e40fe8b239.webp"
"MediaSize" => 68291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-5c26411b19241e374f3ed1e40fe8b239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.8Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6397442910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/3e8c062025a21877ffd9cb6f2de702fe.webp"
"MediaSize" => 72309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-3e8c062025a21877ffd9cb6f2de702fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6397442988"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/5dc70fff84314e5f67bc333530fc242d.webp"
"MediaSize" => 41549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-5dc70fff84314e5f67bc333530fc242d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.8Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6397443090"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/0ba60f28531e8e64981b1b4231ca6497.webp"
"MediaSize" => 51156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-0ba60f28531e8e64981b1b4231ca6497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6397443174"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/0207c3fffe2595735b7783bfdb4488ec.webp"
"MediaSize" => 48203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-0207c3fffe2595735b7783bfdb4488ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.8Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6397443248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/68e9a16323427fde4be8fd3d8d39132e.webp"
"MediaSize" => 59700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-68e9a16323427fde4be8fd3d8d39132e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6397443316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/56adfdc0ed726fd1db0638888adba6c0.webp"
"MediaSize" => 83035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-56adfdc0ed726fd1db0638888adba6c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.85Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6397443387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/b3ce73eaf2feaf19a9f70cf964e5f6fe.webp"
"MediaSize" => 59620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-b3ce73eaf2feaf19a9f70cf964e5f6fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.77Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6397443474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/11fe645c11cacf2ff71b25ba8ec87f32.webp"
"MediaSize" => 61044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-11fe645c11cacf2ff71b25ba8ec87f32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6397443524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/c1c31f20b8eeb7346f85525e9f689d26.webp"
"MediaSize" => 61290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-c1c31f20b8eeb7346f85525e9f689d26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.77Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6397443581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232199/c5cd25e92716a979943d9d8351177a5f.webp"
"MediaSize" => 64583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232199/thumbnail-c5cd25e92716a979943d9d8351177a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796948"
"ResourceRecordKey" => "29232199"
"ModificationTimestamp" => "2026-01-09T01:20:55.79Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Jasmine Kaur"
"MemberFirstName" => "Jasmine"
"MemberLastName" => "Kaur"
"MemberMlsId" => "MI7712"
"OriginatingSystemName" => 26
"MemberKey" => "2224068"
"ModificationTimestamp" => "2025-10-28T23:35:05Z"
"MemberStatus" => "Active"
"OfficeKey" => "289628"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberCity" => "Mississauga"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "647-335-6449"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-08-12T16:18:00Z"
"MemberNationalAssociationId" => "1467479"
"OfficeNationalAssociationId" => "1379702"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "HOMELIFE MIRACLE REALTY MISSISSAUGA"
"OfficePhone" => "905-624-5678"
"OfficeMlsId" => "MIB194"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289628"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "1339 A Matheson Blvd E"
"OfficeCity" => "Mississauga"
"OfficePostalCode" => "L4W1R"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "905-624-5677"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-02-23T16:11:00Z"
"OfficeNationalAssociationId" => "1379702"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1351906"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232199')"
+"ID": "521503"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289628/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289628&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289628/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289628&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE MIRACLE REALTY MISSISSAUGA"
+"OfficeEmail": null
+"OfficePhone": "905-624-5678"
+"OfficeMlsId": "MIB194"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289628"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1339 A Matheson Blvd E"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Mississauga"
+"OfficePostalCode": "L4W1R"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1379702"
+"OriginalEntryTimestamp": "2021-02-23T16:11:00Z"
+"OfficeFax": "905-624-5677"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "302618"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "289628"
"SocialMediaUrlOrId" => "http://www.homelifemiracle.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1351906"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289628')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2224068/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2224068&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2224068/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2224068&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29232199" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24875
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29232199/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29232199&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29232199/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29232199&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29232199 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5570764 43.4580334)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29232199 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5570764 43.4580334)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29232199 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5570764 43.4580334)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29232199 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5570764 43.4580334)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25094
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24810
+post_id: "521600"
+post_author: 1
+"ListingKey": "29232281"
+"ListingId": "X12678880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T02:25:09Z"
+"RFModificationTimestamp": "2026-01-09T02:26:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "2 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to lease in the highly sought-after Beechwood area, offering exceptional access to shopping, transit, and the University of Waterloo campus. This spacious 3-bedroom home checks all the boxes and showcases numerous upgrades, including bamboo hardwood flooring on the main and second levels, tasteful kitchen finishes, and a wet bar/summer kitchen in the finished basement. The exterior features a dedicated parking space and a large, fully fenced, landscaped backyard-perfect for outdoor enjoyment. A fantastic leasing opportunity in a prime location at excellent value in today's market. (id:62650)"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T02:26:19.781275+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906649"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T02:12:00Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T02:12:00Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1558146850"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12678880"
"RoomLevel" => "Second level"
"RoomWidth" => 2.82
"ListingKey" => "29232281"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T02:12:00.25Z"
]
1 => array:11 [
"RoomKey" => "1558146851"
"RoomType" => "Bedroom 2"
"ListingId" => "X12678880"
"RoomLevel" => "Second level"
"RoomWidth" => 2.59
"ListingKey" => "29232281"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T02:12:00.25Z"
]
2 => array:11 [
"RoomKey" => "1558146852"
"RoomType" => "Bedroom 3"
"ListingId" => "X12678880"
"RoomLevel" => "Second level"
"RoomWidth" => 3.25
"ListingKey" => "29232281"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T02:12:00.25Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232281/2-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Prop Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2400
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-09T01:40:13.15Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6397477629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/61f7b10862d015e9169feeeee2f9b76e.webp"
"MediaSize" => 218571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-61f7b10862d015e9169feeeee2f9b76e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6397477634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/4b0fed1689decba7cb865bd0e563033f.webp"
"MediaSize" => 143590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-4b0fed1689decba7cb865bd0e563033f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6397477642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/4ea8a9b6402a36079e9e63428c160e88.webp"
"MediaSize" => 150460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-4ea8a9b6402a36079e9e63428c160e88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6397477650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/ead94503dae1e3f250eded6f32a24738.webp"
"MediaSize" => 161838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-ead94503dae1e3f250eded6f32a24738.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6397477658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/4c544df5e1a59764fa83c7a3ebf4ba27.webp"
"MediaSize" => 90335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-4c544df5e1a59764fa83c7a3ebf4ba27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6397477667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/bd3415a8e593de5177f7394ec107e648.webp"
"MediaSize" => 110527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-bd3415a8e593de5177f7394ec107e648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6397477676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/7eb3af9d86d40d14d7309e817f3f6c59.webp"
"MediaSize" => 102225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-7eb3af9d86d40d14d7309e817f3f6c59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6397477687"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/f32755464e4ad478751be7ff15adfb74.webp"
"MediaSize" => 127196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-f32755464e4ad478751be7ff15adfb74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6397477697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/a59d8ba2ed23992178d2aac4a4ef7e13.webp"
"MediaSize" => 176770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-a59d8ba2ed23992178d2aac4a4ef7e13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6397477709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/9b5c91b6314395a4c7ea5e5d2f858673.webp"
"MediaSize" => 130374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-9b5c91b6314395a4c7ea5e5d2f858673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6397477719"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/05f32aae15ae9733d3d3b03bac72e83d.webp"
"MediaSize" => 138068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-05f32aae15ae9733d3d3b03bac72e83d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6397477730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/f2f2cb94a08258406eae10563c5e9725.webp"
"MediaSize" => 132998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-f2f2cb94a08258406eae10563c5e9725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6397477739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29232281/3f99c4099974b52e5dcdf9dd7b0d8f24.webp"
"MediaSize" => 144139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29232281/thumbnail-3f99c4099974b52e5dcdf9dd7b0d8f24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12678880"
"ResourceRecordKey" => "29232281"
"ModificationTimestamp" => "2026-01-09T01:40:13.16Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "GURPREET SINGH MULTANI"
"MemberFirstName" => "GURPREET SINGH"
"MemberLastName" => "MULTANI"
"MemberMlsId" => "9542188"
"OriginatingSystemName" => 26
"MemberKey" => "1906649"
"ModificationTimestamp" => "2025-12-15T06:24:15Z"
"MemberStatus" => "Active"
"OfficeKey" => "146431"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:3 [ …3]
"MemberOfficePhone" => "416-844-5380"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2011-02-16T20:51:00Z"
"MemberNationalAssociationId" => "1220268"
"OfficeNationalAssociationId" => "1201577"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "HOMELIFE/MIRACLE REALTY LTD"
"OfficePhone" => "905-454-4000"
"OfficeMlsId" => "406001"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "146431"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "20-470 CHRYSLER DRIVE"
"OfficeCity" => "BRAMPTON"
"OfficePostalCode" => "L6S0C1"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-463-0811"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2007-11-16T03:44:00Z"
"OfficeNationalAssociationId" => "1201577"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1051469"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232281')"
+"ID": "521600"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25081
+post_id: "520683"
+post_author: 1
+"ListingKey": "29229388"
+"ListingId": "40796757"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T00:40:42Z"
+"RFModificationTimestamp": "2026-01-09T00:43:32Z"
+"ListPrice": 1224900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2297.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A4"
+"UnparsedAddress": "452 WESTHAVEN Street, Waterloo, Ontario N2T0A4"
+"Coordinates": array:2 [
0 => -80.566851
1 => 43.4451782
]
+"Latitude": 43.4451782
+"Longitude": -80.566851
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience thoughtful design and quality finishes in this 2,297 sq. ft. new build. This home features 4 spacious bedrooms, 2.5 modern bathrooms, 9 ft ceilings, and a double car garage, providing practical space for everyday living. The custom kitchen includes quartz countertops, included appliances, and a functional butler’s kitchen separated by a stylish glass partition. A custom fireplace with textured tile and wood-tone paneling creates a warm focal point in the main living area, while a second fireplace with a Micro cement finish adds character to the upper-level flex space. Upgrades continue throughout the home, with engineered hardwood on the main floor, carpet-free laminate upstairs, and premium fixtures and hardware throughout. A convenient side entrance opens into a thoughtfully designed mudroom with custom built-in bench seating, hooks, and integrated storage, creating an organized and welcoming transition into the home. The primary suite includes a balcony, perfect for a quiet morning coffee, and a spa-inspired ensuite with elevated finishes. The basement features 9 ft ceilings, providing excellent potential for a bright future living space, recreation area, or home gym. Large windows invite natural light into every corner, and the landscaped exterior with a concrete pad creates a ready-to-enjoy outdoor space. Conveniently located near Ira Needles and The Boardwalk shopping area, this home offers easy access to cafés, shops, and more. This home delivers thoughtful upgrades, functionality, and a modern feel across every level. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T18:22:25.412096+00:00"
+"Directions": "Erb Street W to Westhaven Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1942381"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T17:09:02Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T00:29:25Z"
+"Stories": "2.0"
+"StreetName": "WESTHAVEN"
+"StreetNumber": "452"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1558120078"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.49Z"
]
1 => array:11 [
"RoomKey" => "1558120079"
"RoomType" => "Bedroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
2 => array:11 [
"RoomKey" => "1558120080"
"RoomType" => "Bedroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
3 => array:11 [
"RoomKey" => "1558120081"
"RoomType" => "Bedroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
4 => array:11 [
"RoomKey" => "1558120082"
"RoomType" => "Full bathroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
5 => array:11 [
"RoomKey" => "1558120083"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796757"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
6 => array:11 [
"RoomKey" => "1558120084"
"RoomType" => "Other"
"ListingId" => "40796757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
7 => array:11 [
"RoomKey" => "1558120085"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
8 => array:11 [
"RoomKey" => "1558120086"
"RoomType" => "Kitchen"
"ListingId" => "40796757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
9 => array:11 [
"RoomKey" => "1558120087"
"RoomType" => "Dining room"
"ListingId" => "40796757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
10 => array:11 [
"RoomKey" => "1558120088"
"RoomType" => "Great room"
"ListingId" => "40796757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229388"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T00:29:25.5Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29229388/452-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "277572"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2297
+"OriginalEntryTimestamp": "2026-01-08T17:09:02.55Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:44 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6396852144"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/3beaa38dbcc3deca5a6ed1a48b2571fe.webp"
"MediaSize" => 72456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-3beaa38dbcc3deca5a6ed1a48b2571fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a chandelier and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6396852227"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/31d5114c2f6c19bb39ffe8bf66c1a559.webp"
"MediaSize" => 56398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-31d5114c2f6c19bb39ffe8bf66c1a559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom with independent washer and dryer, cabinet space, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6396852309"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/2c99f7b62cba8c21728ba94e77d2a44e.webp"
"MediaSize" => 68606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-2c99f7b62cba8c21728ba94e77d2a44e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood finished floors and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6396852362"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/305404e24161e640587b7222222897f9.webp"
"MediaSize" => 81207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-305404e24161e640587b7222222897f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light stone countertops, stainless steel microwave, light brown cabinets, and open shelves"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6396852416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/73bcfb9b4bb9dd8a273a10a2f2fae094.webp"
"MediaSize" => 60231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-73bcfb9b4bb9dd8a273a10a2f2fae094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood finished floors, recessed lighting, and an accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6396852477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/cb0aba108fb4feffb6aa2892e3e634f3.webp"
"MediaSize" => 62994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-cb0aba108fb4feffb6aa2892e3e634f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with double vanity and tile walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6396852482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/7b21313dd8bc0442ce90e9f061b6ad42.webp"
"MediaSize" => 91827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-7b21313dd8bc0442ce90e9f061b6ad42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with light wood-style flooring and a glass covered fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6396852544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/6668d7fdcd46425ee2f434399355acb3.webp"
"MediaSize" => 84013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-6668d7fdcd46425ee2f434399355acb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with light wood-type flooring, a glass covered fireplace, recessed lighting, and beam ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6396852675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/4487db551eb08b8e5f2d28d5891fbefc.webp"
"MediaSize" => 74368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-4487db551eb08b8e5f2d28d5891fbefc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring modern cabinets, premium appliances, light brown cabinets, light stone counters, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6396852685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/22f5570b7cbb206917e8612be596a4fb.webp"
"MediaSize" => 65517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-22f5570b7cbb206917e8612be596a4fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with open shelves, a breakfast bar, light countertops, light wood-type flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6396852734"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/a5e4c97c66f6b15625c930d56d4afa8f.webp"
"MediaSize" => 101847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-a5e4c97c66f6b15625c930d56d4afa8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of below grade area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6396852817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/30b271d15736b70827a0aa4f895f3a4d.webp"
"MediaSize" => 133410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-30b271d15736b70827a0aa4f895f3a4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard with a patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6396852852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/a53675a166042cb8e650ae846026bc13.webp"
"MediaSize" => 36920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-a53675a166042cb8e650ae846026bc13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of basement layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6396852880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/913222af1868507d306c130d6f733e57.webp"
"MediaSize" => 70759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-913222af1868507d306c130d6f733e57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with built in features, a chandelier, and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6396852885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/7c740f61f279f4603c8e755917688b32.webp"
"MediaSize" => 63450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-7c740f61f279f4603c8e755917688b32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and shower / bath combination with glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6396852915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/361ebb9d68bb2ad91c7baf4f0f736659.webp"
"MediaSize" => 64903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-361ebb9d68bb2ad91c7baf4f0f736659.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with a glass covered fireplace, wood finished floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6396853008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/a8ae118709f4fe4568d9d57bea21bf71.webp"
"MediaSize" => 53583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-a8ae118709f4fe4568d9d57bea21bf71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall with light wood-style flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6396853032"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/6883e413affacfdc39078430e2fb4081.webp"
"MediaSize" => 66943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-6883e413affacfdc39078430e2fb4081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room with baseboards and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6396853077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/84370a2ed20abcf6da83df846b4bab4d.webp"
"MediaSize" => 50181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-84370a2ed20abcf6da83df846b4bab4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with vanity, a freestanding bath, recessed lighting, tile patterned flooring, and a shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6396853097"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/20fbe31f3b2b5e7cf598d035a2079d3e.webp"
"MediaSize" => 34653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-20fbe31f3b2b5e7cf598d035a2079d3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet featuring light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6396853176"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/18d1d45079db568a55c60990c4b2c0af.webp"
"MediaSize" => 48730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-18d1d45079db568a55c60990c4b2c0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mudroom featuring baseboards and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6396853186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/4dce9987c4dccff95661bfe15729ec23.webp"
"MediaSize" => 144435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-4dce9987c4dccff95661bfe15729ec23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring brick siding, a lawn, a patio area, and entry steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6396853219"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/883646503e350fee8fb2e3a07afb1961.webp"
"MediaSize" => 101243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-883646503e350fee8fb2e3a07afb1961.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property featuring stucco siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6396853278"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/234510c26324fbadfa6476d8ac4d8ede.webp"
"MediaSize" => 83894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-234510c26324fbadfa6476d8ac4d8ede.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with light wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6396853325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/d5628bf760b975f32020b292581f0f72.webp"
"MediaSize" => 69658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-d5628bf760b975f32020b292581f0f72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a chandelier, light wood-type flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6396853391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/1fe42a58f2f4bf3bad5816221d45fadf.webp"
"MediaSize" => 70896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-1fe42a58f2f4bf3bad5816221d45fadf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with appliances with stainless steel finishes, modern cabinets, light brown cabinetry, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6396853418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/92111e9d1cdb8b2722ce134f48163372.webp"
"MediaSize" => 37784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-92111e9d1cdb8b2722ce134f48163372.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6396853524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/6b69d20abb3d9dc400135bdc02d3f1fe.webp"
"MediaSize" => 65664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-6b69d20abb3d9dc400135bdc02d3f1fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space featuring a chandelier and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6396853562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/75f4876bbb4aa9abdaf07edab0ce87ad.webp"
"MediaSize" => 49239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-75f4876bbb4aa9abdaf07edab0ce87ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-type flooring and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6396853606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/ea47e89789373c9c6e30c423276bb4d5.webp"
"MediaSize" => 21561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-ea47e89789373c9c6e30c423276bb4d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6396853620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/42588d14ebb1ef7506dd6701b35bb316.webp"
"MediaSize" => 43017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-42588d14ebb1ef7506dd6701b35bb316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet with light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6396853654"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/5d2964c21946ea25ea1392d071cac78e.webp"
"MediaSize" => 101473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-5d2964c21946ea25ea1392d071cac78e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement with heating unit and water heater"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796757"
"ResourceRecordKey" => "29229388"
"ModificationTimestamp" => "2026-01-08T17:09:02.56Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6396853711"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229388/502f61f082e0faf7a4871ea4665894cc.webp"
"MediaSize" => 138493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229388/thumbnail-502f61f082e0faf7a4871ea4665894cc.webp"
…7
]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29229388')"
+"ID": "520683"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24811
+post_id: "519413"
+post_author: 1
+"ListingKey": "29228867"
+"ListingId": "40796720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T16:10:28Z"
+"RFModificationTimestamp": "2026-01-08T16:49:54Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1192.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W2"
+"UnparsedAddress": "360 ERBSVILLE Road Unit# 7, Waterloo, Ontario N2T2W2"
+"Coordinates": array:2 [
0 => -80.5800942
1 => 43.4617129
]
+"Latitude": 43.4617129
+"Longitude": -80.5800942
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to effortless, turnkey living in one of Waterloo’s most desirable communities. This immaculate bungalow townhouse is thoughtfully designed for comfort, ease, and everyday enjoyment—ideal for downsizers, professionals, or anyone seeking a low-maintenance lifestyle without compromise. From the moment you step inside, the home feels bright, calm, and impeccably cared for. A sun-filled bedroom at the front of the home offers flexibility as a guest room, office, or cozy retreat. The heart of the home unfolds into a beautifully updated, open-concept kitchen, dining, and living area—perfect for both quiet mornings and relaxed entertaining. The kitchen features stainless steel appliances, modern finishes, and a seamless connection to the outdoors, with views over a lush, green backyard. Step out onto the newer deck and imagine summer evenings spent BBQ’ing, hosting friends, or simply enjoying the peaceful backdrop of mature greenery—your own private escape. The spacious primary bedroom offers comfort and privacy, complete with its own ensuite bathroom. A convenient additional two-piece bathroom is located on the main floor, along with a laundry rough-in for future flexibility. Accessibility has been thoughtfully considered throughout the home, including a chair lift providing easy access to the fully finished basement. Downstairs, you’ll find a large, versatile living space, an additional full bathroom, and a substantial storage/workroom—ideal for hobbies, organization, or extra living needs. Immaculately maintained, move-in ready, and set within a sought-after Waterloo location close to amenities, trails, and everyday conveniences, this home offers the perfect balance of simplicity, comfort, and quality. A rare opportunity to enjoy bungalow living at its very best. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "756.43"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T16:49:30.858726+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T16:01:07Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T16:01:07Z"
+"Stories": "1.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "360"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4678.09"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/unit_7_360_erbsville_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29228867/360-erbsville-road-unit-7-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1192
+"OriginalEntryTimestamp": "2026-01-08T16:01:07.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228867')"
+"ID": "519413"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24747
+post_id: "517639"
+post_author: 1
+"ListingKey": "29227215"
+"ListingId": "40796371"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T23:15:11Z"
+"RFModificationTimestamp": "2026-01-07T23:38:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 2104.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1V3"
+"UnparsedAddress": "691 KARLSFELD Road Unit# Lower, Waterloo, Ontario N2T1V3"
+"Coordinates": array:2 [
0 => -80.5791305
1 => 43.4579317
]
+"Latitude": 43.4579317
+"Longitude": -80.5791305
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and well-maintained 1 Bedroom, 1 Bathroom basement apartment. Functional layout with a comfortable living area, practical kitchen, spacious bedroom, and a full bathroom. Convenient Waterloo location close to public transit, shopping, parks, and commuter routes, making day-to-day life (unfortunately) very easy. Ideal for a single professional or couple. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T23:38:13.317527+00:00"
+"Directions": "Brandenburg"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060007"
+"ListOfficeKey": "152170"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T23:08:47Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T23:08:47Z"
+"Stories": "2.0"
+"StreetName": "KARLSFELD"
+"StreetNumber": "691"
+"StreetSuffix": "Road"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29227215/691-karlsfeld-road-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2169792"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "152170"
+"GeocodeManualYN": true
+"TotalActualRent": 1400
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1483
+"BelowGradeFinishedArea": 621
+"OriginalEntryTimestamp": "2026-01-07T23:08:47.08Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:11 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29227215')"
+"ID": "517639"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24705
+post_id: "516229"
+post_author: 1
+"ListingKey": "29225484"
+"ListingId": "X12672586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T18:50:15Z"
+"RFModificationTimestamp": "2026-01-07T19:13:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2T6"
+"UnparsedAddress": "234 SHAKESPEARE DRIVE, Waterloo, Ontario N2L2T6"
+"Coordinates": array:2 [
0 => -80.5454291
1 => 43.4635767
]
+"Latitude": 43.4635767
+"Longitude": -80.5454291
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 4-bedroom (3+1), 3-bath home in the prestigious Beechwood area. Just minutes from the University of Waterloo, parks, and a top recreation center. Enjoy an open-concept main floor with crown molding, granite island kitchen, and two fireplaces. Bathrooms feature heated floors for extra comfort. The finished basement offers aoffice,perfect rec room, office, or guest space. Step out to a large private deck overlooking peaceful green space-ideal for entertaining or relaxing. A rare rental opportunity in an A+ location! (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:13:12.035993+00:00"
+"Directions": "University Ave W & Westmount N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1927235"
+"ListOfficeKey": "51307"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sloping"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
]
+"LotSizeDimensions": "70.9 x 179.3 FT ; Irregular"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T18:41:33Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T18:41:33Z"
+"Stories": "1.0"
+"StreetName": "Shakespeare"
+"StreetNumber": "234"
+"StreetSuffix": "Drive"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29225484/234-shakespeare-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 4500
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 70.1
+"OriginalEntryTimestamp": "2026-01-07T18:41:33.67Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29225484')"
+"ID": "516229"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24814
+post_id: "515123"
+post_author: 1
+"ListingKey": "29223084"
+"ListingId": "X12670346"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T02:20:28Z"
+"RFModificationTimestamp": "2026-01-07T03:33:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K9"
+"UnparsedAddress": "202 - 312 ERB STREET W, Waterloo, Ontario N2L0K9"
+"Coordinates": array:2 [
0 => -80.543394
1 => 43.456293
]
+"Latitude": 43.456293
+"Longitude": -80.543394
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Where style meets substance in this brand-new, never-lived-in two-bedroom, two-bathroom residence. Thoughtfully designed, this modern unit features luxury vinyl plank flooring, in-suite laundry, sleek designer lighting, and secure underground parking. Ideally located just 3 minutes from the University of Waterloo and within close proximity to Uptown Waterloo, Wilfrid Laurier University, the Waterloo Rec Complex, and the Hydrocut trail system, offering an exceptional urban lifestyle. Designed for active living, the building offers easy access to bike routes, secure bike storage, and an on-site bike maintenance station. Premium amenities include a curated co-working lounge with coffee bar and meeting pods, pet wash station, EV-ready parking, secure parcel room, and optional storage lockers. Experience modern convenience, community, and design. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T03:33:31.512633+00:00"
+"Directions": "On Erb St between McDougall & Amos"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413436"
+"ListOfficeKey": "50892"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-07T02:12:08Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T02:12:08Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29223084/202-312-erb-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-07T02:12:07.99Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:14 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223084')"
+"ID": "515123"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23459
+post_id: "514917"
+post_author: 1
+"ListingKey": "29222971"
+"ListingId": "40796614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T02:20:28Z"
+"RFModificationTimestamp": "2026-01-07T02:24:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 750.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K9"
+"UnparsedAddress": "312 ERB Street Unit# 202, Waterloo, Ontario N2L0K9"
+"Coordinates": array:2 [
0 => -80.5431746
1 => 43.4561115
]
+"Latitude": 43.4561115
+"Longitude": -80.5431746
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Where style meets substance in this brand-new, never-lived-in two-bedroom, two-bathroom residence. Thoughtfully designed, this modern unit features luxury vinyl plank flooring, in-suite laundry, sleek designer lighting, and secure underground parking. Ideally located just 3 minutes from the University of Waterloo and within close proximity to Uptown Waterloo, Wilfrid Laurier University, the Waterloo Rec Complex, and the Hydro cut trail system, offering an exceptional urban lifestyle. Designed for active living, the building offers easy access to bike routes, secure bike storage, and an on-site bike maintenance station. Premium amenities include a curated co-working lounge with coffee bar and meeting pods, pet wash station, EV-ready parking, secure parcel room, and optional storage lockers. Experience modern convenience, community, and design (id:62650)"
+"AssociationFeeIncludes": array:1 [
0 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T02:24:30.085139+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224068"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-01-07T01:38:27Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T02:08:23Z"
+"Stories": "1.0"
+"StreetName": "ERB"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"WaterSource": array:1 [
0 => "None"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29222971/312-erb-street-unit-202-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2300
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2026-01-07T01:38:27.44Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:14 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29222971')"
+"ID": "514917"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24763
+post_id: "509286"
+post_author: 1
+"ListingKey": "29215383"
+"ListingId": "X12661836"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-05T17:50:47Z"
+"RFModificationTimestamp": "2026-01-05T18:06:10Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "706 - 223 ERB STREET W, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.536312
1 => 43.459038
]
+"Latitude": 43.459038
+"Longitude": -80.536312
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience upscale condo living at the Westmount Grand, one of Waterloo's most prestigious addresses! This impressive west-facing 1-bedroom + den, 2-bathroom suite combines luxury, comfort, and convenience in the heart of Uptown Waterloo. Inside, you'll find 9' ceilings, a spacious open-concept kitchen with island, granite counters, stainless steel appliances, under-cabinet lighting, and a stylish backsplash. The expansive living and dining areas are framed by large windows, filling the space with natural light and showcasing panoramic city views. A bonus flex space offers the perfect spot for a home office. Hardwood flooring flows seamlessly throughout the main living area, adding warmth and elegance. The oversized primary bedroom is a true retreat, featuring a large window, dual closets, and a 5-piece spa-inspired ensuite. Additional highlights include a second full bathroom, in-suite laundry, and a storage room. Step out to the spacious covered balcony to take in spectacular sunsets! This unit also includes one underground parking space and one locker. Residents of Westmount Grand enjoy an array of first-class amenities: a rooftop terrace, library, fitness centre, sauna, entertainment room, and secure underground parking. Perfectly located, you'll be steps from Uptown Waterloo's restaurants, shops, and parks, and just minutes from the University of Waterloo and Wilfrid Laurier University. Luxury, lifestyle, and location-this condo has it all! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"AssociationFee": "1111.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-05T18:06:01.564329+00:00"
+"Directions": "Cross Streets: WESTMOUNT ROAD S. ** Directions: WESTMOUNT ROAD S TO ERB STREET W."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-05T17:44:05Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-05T17:44:05Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4164.85"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/706_223_erb_st_w_waterloo_on/"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29215383/706-223-erb-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-05T17:44:05.47Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29215383')"
+"ID": "509286"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24770
+post_id: "509011"
+post_author: 1
+"ListingKey": "29214350"
+"ListingId": "40795854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-05T15:45:35Z"
+"RFModificationTimestamp": "2026-01-05T17:11:42Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 926.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "223 ERB Street W Unit# 706, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.5363516
1 => 43.4591661
]
+"Latitude": 43.4591661
+"Longitude": -80.5363516
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience upscale condo living at the Westmount Grand, one of Waterloo’s most prestigious addresses! This impressive west-facing 1-bedroom + den, 2-bathroom suite combines luxury, comfort, and convenience in the heart of Uptown Waterloo. Inside, you’ll find 9’ ceilings, a spacious open-concept kitchen with island, granite counters, stainless steel appliances, under-cabinet lighting, and a stylish backsplash. The expansive living and dining areas are framed by large windows, filling the space with natural light and showcasing panoramic city views. A bonus flex space offers the perfect spot for a home office. Hardwood flooring flows seamlessly throughout the main living area, adding warmth and elegance. The oversized primary bedroom is a true retreat, featuring a large window, dual closets, and a 5-piece spa-inspired ensuite. Additional highlights include a second full bathroom, in-suite laundry, and a storage room. Step out to the spacious covered balcony to take in spectacular sunsets! This unit also includes one underground parking space and one locker. Residents of Westmount Grand enjoy an array of first-class amenities: a rooftop terrace, library, fitness centre, sauna, entertainment room, and secure underground parking. Perfectly located, you’ll be steps from Uptown Waterloo’s restaurants, shops, and parks, and just minutes from the University of Waterloo and Wilfrid Laurier University. Luxury, lifestyle, and location—this condo has it all! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "1111.95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-05T17:11:25.688240+00:00"
+"Directions": "WESTMOUNT ROAD S TO ERB STREET W"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-05T15:39:23Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-05T15:39:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4164.85"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/706_223_erb_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29214350/223-erb-street-w-unit-706-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 926
+"OriginalEntryTimestamp": "2026-01-05T15:39:23.75Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29214350')"
+"ID": "509011"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 102
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]