array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29941527 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1557981"
+post_author: 1
+"ListingKey": "29941527"
+"ListingId": "40842190"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T01:20:31Z"
+"RFModificationTimestamp": "2026-06-24T01:21:42Z"
+"ListPrice": 339999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 642.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "158 KING Street N Unit# 801, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.5232859
1 => 43.4715923
]
+"Latitude": 43.4715923
+"Longitude": -80.5232859
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful, owner-occupied condo at 158 King Street North, Waterloo. This bright, clean and carpet-free home has been lovingly cared for and maintained by the current owner, showing pride of ownership. Inside, you will find newly-installed(2025) flooring throughout, high 9-foot ceilings and big windows that bring in abundance of natural light. Enjoy two generously-sized bedrooms, two full bathrooms including one ensuite, and the convenience of having your own washer and dryer right inside the unit. The outdoor and window views offer a rare, tranquil escape in the middle of the city. You can wake up to a breathtaking sunrise view right from your bedroom window, and then step out onto your spacious balcony to enjoy peaceful vistas over a beautiful green schoolyard. The location also makes your daily life incredibly easy, walking to both Walmart and Sobeys for your groceries or walking to the local trails and the restaurants and shops in Uptown Waterloo. With a transit stop just steps away and both Wilfrid Laurier University and the University of Waterloo close by, getting around town is just a breeze. Call your realtor today before it's gone! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "408.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T19:45:05.301373+00:00"
+"Directions": "TURN EAST TO NOECKER ST FROM KING, BUILDING ENTRANCE FACING NOECKER ST, BUILDING SAYS 158 KING, TOWER 2"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Vinyl siding"
2 => "Other"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067924"
+"ListOfficeKey": "291737"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T15:51:05Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T01:10:01Z"
+"Stories": "21.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3096"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1666523348"
"RoomType" => "Foyer"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
1 => array:11 [
"RoomKey" => "1666523349"
"RoomType" => "Laundry room"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
2 => array:11 [
"RoomKey" => "1666523350"
"RoomType" => "Living room"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
3 => array:11 [
"RoomKey" => "1666523351"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
4 => array:11 [
"RoomKey" => "1666523352"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
5 => array:11 [
"RoomKey" => "1666523353"
"RoomType" => "Bedroom"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
6 => array:11 [
"RoomKey" => "1666523354"
"RoomType" => "Full bathroom"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "6'1'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
7 => array:11 [
"RoomKey" => "1666523355"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842190"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29941527"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T01:10:01.7Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29941527/158-king-street-n-unit-801-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 642
+"OriginalEntryTimestamp": "2026-06-23T15:51:05.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1343007"
+"ListOfficeNationalAssociationId": "1404812"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29941527_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/fbf0912125d6cb519374d91eac046d5c.webp"
"MediaSize" => 108780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-fbf0912125d6cb519374d91eac046d5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary high-rise building featuring a clean white facade and extensive window lines"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29941527_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/49ed0a6cad1fb20f54c6027c08da46ab.webp"
"MediaSize" => 109813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-49ed0a6cad1fb20f54c6027c08da46ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Urban streetscape featuring modern high-rise buildings and a brick structure with a golden dome"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29941527_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/b97fb0f079e66d7c0089966740c21aff.webp"
"MediaSize" => 140571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-b97fb0f079e66d7c0089966740c21aff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building featuring a light-colored facade with dark-framed windows and multiple private balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29941527_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/ddde34aa099d9d9a204e75c1bd4d4793.webp"
"MediaSize" => 159303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-ddde34aa099d9d9a204e75c1bd4d4793.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29941527_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/9c37966a1808d1aa020727ec3fb32a76.webp"
"MediaSize" => 123051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-9c37966a1808d1aa020727ec3fb32a76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29941527_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/3932ec691a98af03bbd9b46cb37d6cfa.webp"
"MediaSize" => 59324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-3932ec691a98af03bbd9b46cb37d6cfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern building entrance canopy featuring metallic paneling and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29941527_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/e066dd308f8c388790c0d49550327346.webp"
"MediaSize" => 92926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-e066dd308f8c388790c0d49550327346.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness facility featuring rubberized flooring, exposed ceiling ducts, linear lighting fixtures, mounted flat-screen displays, and expansive windows with roller shades"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29941527_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/63ada1e1d23fd09a6b5e29e92cd6528f.webp"
"MediaSize" => 93901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-63ada1e1d23fd09a6b5e29e92cd6528f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fitness facility featuring rubberized flooring and exposed ceiling ducts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29941527_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/59d4d4c912a9e992f1685ecc47c2b59d.webp"
"MediaSize" => 71980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-59d4d4c912a9e992f1685ecc47c2b59d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29941527_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/674907365f05c3962f8b09c15efab860.webp"
"MediaSize" => 75444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-674907365f05c3962f8b09c15efab860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29941527_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/e34a0dfd6dfe72d79e927102d5072481.webp"
"MediaSize" => 58326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-e34a0dfd6dfe72d79e927102d5072481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29941527_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/6b9f6b61349a00739c0952c0d5fecc23.webp"
"MediaSize" => 60910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-6b9f6b61349a00739c0952c0d5fecc23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area with wood-finish flooring and light wood cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29941527_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/56e3d4ffb688cd6d93b614f7291c290a.webp"
"MediaSize" => 56465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-56e3d4ffb688cd6d93b614f7291c290a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring stainless steel appliances, light wood-finish cabinetry, a white subway tile backsplash, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29941527_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/599ee6582d5971ec28dc55f9857bcb29.webp"
"MediaSize" => 84060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-599ee6582d5971ec28dc55f9857bcb29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring light wood-finish cabinetry, stainless steel appliances, a white tile backsplash, and light-tone countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29941527_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/923ee978deea6922a3c6658d78fbb2f6.webp"
"MediaSize" => 76096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-923ee978deea6922a3c6658d78fbb2f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29941527_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/ddc7c007359d93b5b1c034b278b3611f.webp"
"MediaSize" => 61169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-ddc7c007359d93b5b1c034b278b3611f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29941527_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/b7e50c3e141f8ffb3074344cde155f6e.webp"
"MediaSize" => 62516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-b7e50c3e141f8ffb3074344cde155f6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring light wood-finish cabinetry and light-toned countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29941527_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/4f82daa4c16673693d90a55cfc967ea9.webp"
"MediaSize" => 64251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-4f82daa4c16673693d90a55cfc967ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29941527_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/e6fdb64592e94a69343c0d93aa3696d6.webp"
"MediaSize" => 63025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-e6fdb64592e94a69343c0d93aa3696d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29941527_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/c9232922d8d4cb5f194033843037d782.webp"
"MediaSize" => 73850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-c9232922d8d4cb5f194033843037d782.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring light wood-finish flooring, white walls, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29941527_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/413759dac00370d6b6a4f66d21019fe9.webp"
"MediaSize" => 60641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-413759dac00370d6b6a4f66d21019fe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen with light wood cabinetry and stainless steel appliances, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29941527_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/333b9db195182e843660c3b55cb7ebf0.webp"
"MediaSize" => 64181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-333b9db195182e843660c3b55cb7ebf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive window wall with city views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29941527_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/78b28009aec5004ba6480ee1467b777a.webp"
"MediaSize" => 79373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-78b28009aec5004ba6480ee1467b777a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Panoramic window wall with urban and green space scenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29941527_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/ca5e728ba9057a9e5449bb598dc08383.webp"
"MediaSize" => 81008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-ca5e728ba9057a9e5449bb598dc08383.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring expansive glass doors to a private balcony, wood-finish flooring, and a contemporary open-concept layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29941527_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/a8da5e34f74eaa12977c4fa86824e635.webp"
"MediaSize" => 49771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-a8da5e34f74eaa12977c4fa86824e635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed corner shower, toilet, and vanity with a white basin sink and dark-finish cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29941527_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/eb0ff322a8d18f12060f2f67d9f359bf.webp"
"MediaSize" => 80190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-eb0ff322a8d18f12060f2f67d9f359bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor-to-ceiling windows with expansive city and treeline scenery, light wood-finish flooring, and crisp white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29941527_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/c39f215722aa16cc2a5f0189b1148718.webp"
"MediaSize" => 74711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-c39f215722aa16cc2a5f0189b1148718.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring a large window, light wood-finish flooring, white walls, and a mirrored sliding closet door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29941527_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/5629ac3d0e5e5f642a576fdac15236f7.webp"
"MediaSize" => 81898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-5629ac3d0e5e5f642a576fdac15236f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior room with wood-finish flooring, featuring a large window with white framing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29941527_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/52e95f719d6a2780c00a96501e000a48.webp"
"MediaSize" => 29141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-52e95f719d6a2780c00a96501e000a48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a corner glass-enclosed shower, a dark wood-finish vanity with an integrated sink, a wall-mounted mirror, and neutral-toned floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29941527_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/cf1fcd84d03a5ac84f22a59963e7f834.webp"
"MediaSize" => 58161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-cf1fcd84d03a5ac84f22a59963e7f834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In-unit stacked washer and dryer within a dedicated closet, featuring a white paneled door with brushed nickel hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29941527_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/8c2291b7965fa9bc62298a4caeb47fff.webp"
"MediaSize" => 98523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-8c2291b7965fa9bc62298a4caeb47fff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private balcony featuring modular tile flooring and a glass railing system"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29941527_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941527/0fdc24eadcad5366618c3a549b5f94b3.webp"
"MediaSize" => 91035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941527/thumbnail-0fdc24eadcad5366618c3a549b5f94b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor balcony featuring gray tile flooring and a glass railing system"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842190"
"ResourceRecordKey" => "29941527"
"ModificationTimestamp" => "2026-06-23T15:51:05.11Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941527')"
+"ID": "1557981"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291737" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24810
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2067924" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24911
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2067924"
+"ModificationTimestamp": "2024-07-08T05:15:08Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2067924"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2067924')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29941527'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25207
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29941527'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25225
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31615925"
+"ListingKey": "29941527"
+"ListingId": "40842190"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-24T00:43:06Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31615925')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29941527' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5232859 43.4715923)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1559241"
+post_author: 1
+"ListingKey": "29943792"
+"ListingId": "40841883"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T20:40:40Z"
+"RFModificationTimestamp": "2026-06-23T22:54:23Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1272.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "271 LESTER Street Unit# 203, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.5358226
1 => 43.4749829
]
+"Latitude": 43.4749829
+"Longitude": -80.5358226
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PARENTS LOOKING FOR AN INVESTMENT While your child attends UofW or Laurier this Fall? Prime Investment Opportunity – Fully Furnished 5-Bedroom Unit Near Universities. Potential Monthly Rental Income: $4,300+/mth | Low Condo Fees | Parking Included This turn-key 5-bedroom, 2-bathroom condo offers an exceptional investment opportunity in a highly sought-after building, steps from University of Waterloo and Wilfrid Laurier University. Designed to maximize rental income, this unit comes fully furnished with zero property management fees, ensuring hassle-free cash flow from day one.Key Features include: Spacious Living Area: Open-concept living, dining, and kitchen, fully furnished with modern finishes. Five Bedrooms: Each bedroom features large windows and under-bed storage, dresser drawers, providing functional and comfortable living spaces for tenants. Secure Building: 24-hour security and a well-managed building ensure a safe environment and high tenant retention. Prime Location: Walk to campus, shopping, restaurants, and other local amenities. Parking: Rarely available in this building, included with the unit. Included Furnishings & Appliances: Refrigerator, stove, dishwasher, microwave, hood fan, beds with mattresses, desks with chairs, under-bed storage cabinets, dining table with chairs, couch, chairs, coffee table, window coverings, and lighting fixtures. Perfect for investors seeking a reliable, high-demand rental property, OR A parent looking for a solid investment while their child attends UofW or Laurier! Can be available for your child looking to attend University in the fall. You can't beat the location - hurry before it's gone! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "696.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:54:17.992562+00:00"
+"Directions": "University to Lester"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564059"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Recreational"
3 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T20:31:48Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:31:48Z"
+"Stories": "1.0"
+"StreetName": "LESTER"
+"StreetNumber": "271"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3713"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1666313453"
"RoomType" => "Family room"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "17'11'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
1 => array:11 [
"RoomKey" => "1666313454"
"RoomType" => "Kitchen"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
2 => array:11 [
"RoomKey" => "1666313455"
"RoomType" => "Dining room"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
3 => array:11 [
"RoomKey" => "1666313456"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
4 => array:11 [
"RoomKey" => "1666313457"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "4'9'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
5 => array:11 [
"RoomKey" => "1666313458"
"RoomType" => "Bedroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
6 => array:11 [
"RoomKey" => "1666313459"
"RoomType" => "Bedroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
7 => array:11 [
"RoomKey" => "1666313460"
"RoomType" => "Bedroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
8 => array:11 [
"RoomKey" => "1666313461"
"RoomType" => "Bedroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
9 => array:11 [
"RoomKey" => "1666313462"
"RoomType" => "Bedroom"
"ListingId" => "40841883"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943792"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:48.81Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29943792/271-lester-street-unit-203-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "(H) RN-12"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 106.0
+"AboveGradeFinishedArea": 1272
+"OriginalEntryTimestamp": "2026-06-23T20:31:48.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1141403"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29943792_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/783c2e27bc2cb93c33a2e3caff413096.webp"
"MediaSize" => 139405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-783c2e27bc2cb93c33a2e3caff413096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943792_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/701d67100c9202509996be2b4127765c.webp"
"MediaSize" => 122649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-701d67100c9202509996be2b4127765c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943792_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/6e216e3f07c960574460632935d35084.webp"
"MediaSize" => 112875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-6e216e3f07c960574460632935d35084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943792_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/a347f63e3c19b39822336ef5ba52443c.webp"
"MediaSize" => 91082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-a347f63e3c19b39822336ef5ba52443c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943792_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/cbcd8596e9519c4db992b1f66317bd4e.webp"
"MediaSize" => 67593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-cbcd8596e9519c4db992b1f66317bd4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943792_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/d91ca9864b6f5411b684cb91d7715eb3.webp"
"MediaSize" => 58709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-d91ca9864b6f5411b684cb91d7715eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943792_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/ed8f035b2ed8f0cfb33f7da687090813.webp"
"MediaSize" => 78571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-ed8f035b2ed8f0cfb33f7da687090813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943792_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/df362249d1280cb51a4f64ec27a16203.webp"
"MediaSize" => 66308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-df362249d1280cb51a4f64ec27a16203.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29943792_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/5ff34252afac9d6658e6544be7578b2c.webp"
"MediaSize" => 63738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-5ff34252afac9d6658e6544be7578b2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29943792_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/af144a7c236cfb09b22ea0d2e18175e2.webp"
"MediaSize" => 63096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-af144a7c236cfb09b22ea0d2e18175e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29943792_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/16fbce150d35d22d25019e9dd3672f8c.webp"
"MediaSize" => 67559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-16fbce150d35d22d25019e9dd3672f8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29943792_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/56e9f9f970fa69c7974fce35aa1f18b1.webp"
"MediaSize" => 82546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-56e9f9f970fa69c7974fce35aa1f18b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29943792_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/570d729cd84d8e690cd2161f3dc9f7dd.webp"
"MediaSize" => 76041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-570d729cd84d8e690cd2161f3dc9f7dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29943792_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/68d81489e8f37e72cebf0fa88fa06d89.webp"
"MediaSize" => 74851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-68d81489e8f37e72cebf0fa88fa06d89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29943792_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/c2ed2c8b9387c0df5aa7ea660c4e535c.webp"
"MediaSize" => 57392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-c2ed2c8b9387c0df5aa7ea660c4e535c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29943792_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/2171b319386de9bfc432d3047336dae8.webp"
"MediaSize" => 76504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-2171b319386de9bfc432d3047336dae8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29943792_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/85f7b2741c3da018c3626d216f4d9aad.webp"
"MediaSize" => 56311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-85f7b2741c3da018c3626d216f4d9aad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29943792_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/b4dc154f254ad5f4afc3232627022b4f.webp"
"MediaSize" => 80102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-b4dc154f254ad5f4afc3232627022b4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29943792_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/6ad100bf79f41cedf7b620a6df7e8469.webp"
"MediaSize" => 72471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-6ad100bf79f41cedf7b620a6df7e8469.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29943792_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/c4e608a1d696c8065f2b698c514853e5.webp"
"MediaSize" => 82617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-c4e608a1d696c8065f2b698c514853e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29943792_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/f80034ccc1708a72a31605584181656d.webp"
"MediaSize" => 83899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-f80034ccc1708a72a31605584181656d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29943792_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/fb1f2eb43ccc6043f20e65b8a11ec5b6.webp"
"MediaSize" => 82537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-fb1f2eb43ccc6043f20e65b8a11ec5b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29943792_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/0ee93ab5dc3c0f6586c4fc2a3b8e9180.webp"
"MediaSize" => 70134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-0ee93ab5dc3c0f6586c4fc2a3b8e9180.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29943792_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/3e8eeae78ab4827e86361991f96c6161.webp"
"MediaSize" => 85601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-3e8eeae78ab4827e86361991f96c6161.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29943792_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/babdc55ce2cb86d61ce18d700fb2cd52.webp"
"MediaSize" => 82761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-babdc55ce2cb86d61ce18d700fb2cd52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29943792_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/c94b2c87180555bff2c30c3888cb8c6d.webp"
"MediaSize" => 75272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-c94b2c87180555bff2c30c3888cb8c6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943792')"
+"ID": "1559241"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1559384"
+post_author: 1
+"ListingKey": "29943950"
+"ListingId": "X13481030"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T21:00:17Z"
+"RFModificationTimestamp": "2026-06-23T22:21:18Z"
+"ListPrice": 414900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "H404 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.531342
1 => 43.477165
]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish, Sun-Filled Condo in the Heart of the University District. Welcome to modern urban living! This bright and spacious 762 sq ft condo features 2 bedrooms and 2 full bathrooms, offering a functional layout perfect for comfortable everyday living. Ideally located in Waterloo's vibrant University District, this unit sits just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an exceptional opportunity for students, professionals, and investors alike. The condo comes fully furnished, making it a true turnkey opportunity-simply move in or start renting immediately. Enjoy unbeatable convenience with restaurants, shopping, the library, and major bus routes all within walking distance. Highlights:762 Sq Ft of bright, open living space2 spacious bedrooms 2 full bathrooms Fully furnished Prime University District location Ideal for students, professionals, investors, or first-time buyers. Don't miss this incredible opportunity to own in one of Waterloo's most desirable locations. Schedule your private viewing today! (id:62783)"
+"Appliances": array:2 [
0 => "All"
1 => "Furniture"
]
+"AssociationFee": "397"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:21:11.885834+00:00"
+"Directions": "Larch St /Hickory St W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423901"
+"ListOfficeKey": "284505"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T20:53:43Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:53:43Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2775"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29943950/h404-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2130897"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc"
+"CoListOfficeKey": "284505"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-23T20:53:43.72Z"
+"ListAgentNationalAssociationId": "1119532"
+"ListOfficeNationalAssociationId": "1342135"
+"CoListAgentNationalAssociationId": "1383711"
+"CoListOfficeNationalAssociationId": "1342135"
+"Media": array:9 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943950')"
+"ID": "1559384"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1558774"
+post_author: 1
+"ListingKey": "29943407"
+"ListingId": "40841864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T19:40:17Z"
+"RFModificationTimestamp": "2026-06-23T21:29:45Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1307.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "271 LESTER Street Unit# 102, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.5357218
1 => 43.474777
]
+"Latitude": 43.474777
+"Longitude": -80.5357218
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime Investment Opportunity – Fully Furnished 5-Bedroom Unit Near Universities. Monthly Rental Income: $4,300 | Low Condo Fees | Covered Parking Included This turn-key 5-bedroom, 2-bathroom condo offers an exceptional investment opportunity in a highly sought-after building, steps from University of Waterloo and Wilfrid Laurier University. Designed to maximize rental income, this unit comes fully furnished with zero property management fees, ensuring hassle-free cash flow from day one.Key Features include: Spacious Living Area: Open-concept living, dining, and kitchen, fully furnished with modern finishes. Five Bedrooms: Each bedroom features large windows and under-bed storage, dresser drawers, providing functional and comfortable living spaces for tenants. Secure Building: 24-hour security and a well-managed building ensure a safe environment and high tenant retention. Prime Location: Walk to campus, shopping, restaurants, and other local amenities. Parking: Rarely available in this building, included with the unit. Included Furnishings & Appliances: Refrigerator, stove, dishwasher, microwave, hood fan, beds with mattresses, desks with chairs, under-bed storage cabinets, dining table with chairs, couch, chairs, coffee table, window coverings, and lighting fixtures. Perfect for investors seeking a reliable, high-demand rental property, this unit offers immediate possession and consistent income with a 6.23% Cap Rate. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"AssociationFee": "696.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T21:29:35.045839+00:00"
+"Directions": "University to Lester"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564059"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Recreational"
3 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T19:32:30Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T19:32:30Z"
+"Stories": "1.0"
+"StreetName": "LESTER"
+"StreetNumber": "271"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3726"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"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/29943407/271-lester-street-unit-102-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "(H) RN-12"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 106.0
+"AboveGradeFinishedArea": 1307
+"OriginalEntryTimestamp": "2026-06-23T19:32:30.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1141403"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943407')"
+"ID": "1558774"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1557990"
+post_author: 1
+"ListingKey": "29941357"
+"ListingId": "40841788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:40:12Z"
+"RFModificationTimestamp": "2026-06-23T19:52:03Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2258.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6H5"
+"UnparsedAddress": "60 ALLEN Street W Unit# 7, Waterloo, Ontario N2L6H5"
+"Coordinates": array:2 [
0 => -80.5229071
1 => 43.4582469
]
+"Latitude": 43.4582469
+"Longitude": -80.5229071
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Location! Location! Beautifully Refreshed End-Unit Condo in Highly Sought-After Chippendal Commons, located in the heart of Old Westmount. Turn-key living...Welcome to this beautifully refreshed end-unit condo, ideally located in one of the area's most desirable neighbourhoods. Offering an exceptional combination of comfort, style, and privacy, this move-in-ready home has been thoughtfully updated with fresh paint throughout, brand new carpeting, and a full suite of new stainless steel kitchen appliances. The bright and inviting main floor features a well-appointed kitchen with brand new countertops and a walkout to a private patio and garden—perfect for enjoying your morning coffee or relaxing outdoors. The spacious living and dining room is highlighted by soaring cathedral ceilings, hardwood floors, a cozy wood-burning fireplace, and an abundance of natural light, creating an open and welcoming atmosphere. Convenient main floor laundry and a powder room complete this level. The upper levels offer an ideal layout for families, professionals, or guests. The first upper level features a generous bedroom with its own 4-piece ensuite, while the second upper level is dedicated to an oversized primary retreat complete with another private 4-piece ensuite, providing comfort and privacy. The finished lower level adds valuable living space, offering endless possibilities for a family room, home office, fitness area, or recreation room. The Chippendale Pool & Party Room offer additional entertaining options. This exceptional end-unit offers the perfect blend of low-maintenance living and spacious comfort in a coveted location close to Uptown Waterloo, Vincenzo's, restaurants & shopping, schools, and everyday amenities. Simply move in and enjoy everything this wonderful home has to offer. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "522"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T19:51:52.505703+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105122"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:32:04Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:32:03Z"
+"Stories": "3.0"
+"StreetDirSuffix": "West"
+"StreetName": "ALLEN"
+"StreetNumber": "60"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "7032.39"
+"VirtualTourURLUnbranded": "https://youriguide.com/7_60_allen_st_w_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/29941357/60-allen-street-w-unit-7-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1574
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-23T15:32:03.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1374379"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941357')"
+"ID": "1557990"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1557129"
+post_author: 1
+"ListingKey": "29940575"
+"ListingId": "40842072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:00:14Z"
+"RFModificationTimestamp": "2026-06-23T17:17:04Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1912.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "250 KEATS Way Unit# 6, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.5436086
1 => 43.4626712
]
+"Latitude": 43.4626712
+"Longitude": -80.5436086
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRIME UNIVERSITY INVESTMENT OPPORTUNITY WITH WALKOUT BASEMENT Exceptional 3-bedroom townhome with garage in the highly sought-after Keats Way complex, perfectly positioned just minutes from the University of Waterloo and Wilfrid Laurier University. This well-maintained property offers a highly desirable layout with 3 bedrooms on the upper level, a finished walkout basement with a full bathroom, and a total of 2.5 bathrooms, creating outstanding flexibility for both investors and end users. Featuring hardwood flooring, a newly renovated upper-level bathroom, and bright, functional living spaces, this home is built for both comfort and long-term durability. The walkout basement adds valuable living space and significantly enhances rental potential. This property delivers positive cash flow when fully occupied, making it a true turn-key investment in one of Waterloo's most reliable and high-demand rental markets. The inclusion of a private garage and additional parking further strengthens tenant appeal and long-term value. Located close to transit, restaurants, shopping, parks, and major commuter routes, this is a rare opportunity to secure a high-performing income property in a proven university corridor. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:16:42.888639+00:00"
+"Directions": "SHAKESPEARE DR"
+"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": "1936827"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T13:52:48Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T13:52:48Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4268"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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/29940575/250-keats-way-unit-6-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1312
+"BelowGradeFinishedArea": 600
+"OriginalEntryTimestamp": "2026-06-23T13:52:47.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1235438"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940575')"
+"ID": "1557129"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1557130"
+post_author: 1
+"ListingKey": "29941111"
+"ListingId": "X13477870"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:30:10Z"
+"RFModificationTimestamp": "2026-06-23T16:58:32Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "6 - 250 KEATS WAY, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.5438043
1 => 43.4628115
]
+"Latitude": 43.4628115
+"Longitude": -80.5438043
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRIME UNIVERSITY INVESTMENT OPPORTUNITY WITH WALKOUT BASEMENT Exceptional 3-bedroom townhome with garage in the highly sought-after Keats Way complex, perfectly positioned just minutes from the University of Waterloo and Wilfrid Laurier University. This well-maintained property offers a highly desirable layout with 3 bedrooms on the upper level, a finished walkout basement with a full bathroom, and a total of 2.5 bathrooms, creating outstanding flexibility for both investors and end users. Featuring hardwood flooring, a newly renovated upper-level bathroom, and bright, functional living spaces, this home is built for both comfort and long-term durability. The walkout basement adds valuable living space and significantly enhances rental potential. This property delivers positive cash flow when fully occupied, making it a true turn-key investment in one of Waterloo's most reliable and high-demand rental markets. The inclusion of a private garage and additional parking further strengthens tenant appeal and long-term value. Located close to transit, restaurants, shopping, parks, and major commuter routes, this is a rare opportunity to secure a high-performing income property in a proven university corridor. (id:62650)"
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"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-06-23T16:58:28.056663+00:00"
+"Directions": "Cross Streets: University and Keats Way. ** Directions: University to Keats Way."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099844"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:21:21Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:21:21Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4268"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29941111/6-250-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "wilson blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-23T15:07:05.42Z"
+"ListAgentNationalAssociationId": "1370036"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941111')"
+"ID": "1557130"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1556236"
+post_author: 1
+"ListingKey": "29939963"
+"ListingId": "40842183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:00:04Z"
+"RFModificationTimestamp": "2026-06-23T04:38:39Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "300 KEATS Way Unit# 207, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.5442195
1 => 43.4623301
]
+"Latitude": 43.4623301
+"Longitude": -80.5442195
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207—a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit—this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "1037.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:38:32.452163+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T02:50:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:50:17Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2260"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29939963/300-keats-way-unit-207-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Car Wash"
1 => "Party Room"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-06-23T02:50:16.8Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939963')"
+"ID": "1556236"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1555462"
+post_author: 1
+"ListingKey": "29938659"
+"ListingId": "40841508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T19:00:24Z"
+"RFModificationTimestamp": "2026-06-23T19:06:51Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1262.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B6"
+"UnparsedAddress": "144 PARK Street Unit# 1807, Waterloo, Ontario N2L0B6"
+"Coordinates": array:2 [
0 => -80.520222
1 => 43.458871
]
+"Latitude": 43.458871
+"Longitude": -80.520222
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "For more info on this property, please click the Brochure button. This rare 18th floor penthouse suite provides the perfect balance of condo living and outdoor lifestyle in the Bauer District of Uptown Waterloo. The spacious unit features 1262 sq feet of interior living space. 10 foot ceilings throughout, Two glass wrapped balconies with a combined 189 sq feet of exterior entertaining space, Two large bedrooms with walk in closets. Two full bathrooms with quartz countertops and tiled flooring and tub area. (Master ensuite also has a fully tiled glassed shower), and a private balcony with sliding glass doors. Spacious Den / Dining room Upgraded gourmet kitchen featuring quartz countertops with double stainless sinks, ceiling height cabinets with self closing doors and drawers, under counter lighting and stainless steel appliances. Hardwood flooring throughout living area and bedrooms. In house laundry complete with separate stacked washer and dryer. The unit is complete with over $30,000 in luxury upgrades. Private 2nd level parking spot next to entrance doors Extra large storage locker Luxury Living Life at 144 Park is grand and easy featuring a mix of modern high rise condominium suites, penthouses, and luxury street level brownstones. 144 Park was designed to define luxury condominiums in Waterloo. Enjoy southern views of Uptown Waterloo and Belmont Village with floor to 10 foot high ceiling windows providing abundant natural light. 144 Park is complete with an unmatched host of amenities including on-site superintendents provide timely assistance, a dedicated concierge service, fitness studio, theatre room, guest suite, residence lounge and 4th floor 30,000 square foot terrace complete with putting green. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFee": "1152"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:51:25.282942+00:00"
+"Directions": "Corner of Park and Allen St"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220194"
+"ListOfficeKey": "296937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Visual exposure"
2 => "Conservation/green belt"
3 => "Balcony"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T18:52:34Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:52:34Z"
+"Stories": "1.0"
+"StreetName": "PARK"
+"StreetNumber": "144"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "6187"
+"Utilities": array:2 [
0 => "Cable"
1 => "Telephone"
]
+"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/29938659/144-park-street-unit-1807-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:4 [
0 => "Car Wash"
1 => "Exercise Centre"
2 => "Guest Suite"
3 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1262
+"OriginalEntryTimestamp": "2026-06-22T21:32:10.48Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1464325"
+"ListOfficeNationalAssociationId": "1464303"
+"Media": array:48 [
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]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938659')"
+"ID": "1555462"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1555317"
+post_author: 1
+"ListingKey": "29938299"
+"ListingId": "X13475910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:55:18Z"
+"RFModificationTimestamp": "2026-06-23T18:59:03Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E9"
+"UnparsedAddress": "703 - 128 KING STREET N, Waterloo, Ontario N2J0E9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to One28 Condos, perfectly situated in one of Waterloo's most desirable and vibrant locations. This bright, modern one-bedroom plus den suite features soaring nine-foot ceilings and an open-concept layout that seamlessly integrates the kitchen, dining, and living areas. The versatile and spacious den serves as an ideal home office or study space. Enjoy unobstructed views and plenty of natural light from the private balcony, accessible directly from the main living area. The prime location offers unparalleled convenience, placing you just minutes from Uptown Waterloo, the University of Waterloo, Wilfrid Laurier University, and the Technology Park. With boutique shops, fine dining, and the ION LRT transit system just steps away, commuting and daily living are effortless. Residents enjoy premium indoor and outdoor building amenities, including 24-hour security surveillance, a fully equipped fitness centre, a yoga studio, a steam room, a dedicated party and study room, a green roof, and an outdoor terrace with BBQ facilities.The unit is equipped with stainless steel appliances (stove, fridge, dishwasher, microwave) and an in-suite washer and dryer. One underground parking space and one storage locker are included. This turn-key home is completely move-in ready. Book your private showing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "422"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:12:17.976834+00:00"
+"Directions": "Cross Streets: King st N. ** Directions: East."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239952"
+"ListOfficeKey": "289134"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T18:45:55Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:45:55Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4014.65"
+"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/29938299/703-128-king-street-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onix property management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MR25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T20:19:37.2Z"
+"ListAgentNationalAssociationId": "1477884"
+"ListOfficeNationalAssociationId": "1374946"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938299')"
+"ID": "1555317"
}
]
+success: true
+page_size: 9
+page_count: 50
+count: 445
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]