array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29941111 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23411
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23413
+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 [
"Order" => 1
"MediaKey" => "29941111_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/28023175f30f770401e87acbfab0d901.webp"
"MediaSize" => 287469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-28023175f30f770401e87acbfab0d901.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29941111_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/74e34722a7adf7714b641c53b5f9eef7.webp"
"MediaSize" => 226018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-74e34722a7adf7714b641c53b5f9eef7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29941111_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/f8ec2651d33a241b12eea66a92c61287.webp"
"MediaSize" => 195967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-f8ec2651d33a241b12eea66a92c61287.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29941111_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/8feae6f41af35b89c35471790fcc423c.webp"
"MediaSize" => 254608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-8feae6f41af35b89c35471790fcc423c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29941111_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/a08d6084c8c385226a508149327cffcd.webp"
"MediaSize" => 233582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-a08d6084c8c385226a508149327cffcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29941111_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/47c69def28ea565569b713854932e6aa.webp"
"MediaSize" => 172890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-47c69def28ea565569b713854932e6aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29941111_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/8375b51f1d2e4e138fb7417923071138.webp"
"MediaSize" => 93183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-8375b51f1d2e4e138fb7417923071138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29941111_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/53fda3f635aae31ba1dbe3fb1f150990.webp"
"MediaSize" => 151436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-53fda3f635aae31ba1dbe3fb1f150990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29941111_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/bc3aa39f6bff3503a6b8e0d703579eaf.webp"
"MediaSize" => 133700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-bc3aa39f6bff3503a6b8e0d703579eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29941111_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/9fa9f5995ba3fe67cc9ca021f6ac5bfb.webp"
"MediaSize" => 230184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-9fa9f5995ba3fe67cc9ca021f6ac5bfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29941111_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/ba428b2f430311e7ae3fb389189c6a5e.webp"
"MediaSize" => 208390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-ba428b2f430311e7ae3fb389189c6a5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29941111_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/8116a025bc34b7c4bc95be6330cc6094.webp"
"MediaSize" => 325103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-8116a025bc34b7c4bc95be6330cc6094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29941111_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/df85d2191e70eaf6d17b847c6a3fcb7c.webp"
"MediaSize" => 164917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-df85d2191e70eaf6d17b847c6a3fcb7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29941111_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/5b5d51f35c22dbc4acbdf2c43d3af4c5.webp"
"MediaSize" => 186605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-5b5d51f35c22dbc4acbdf2c43d3af4c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29941111_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/012dabe4e123d8995c80833facb6401e.webp"
"MediaSize" => 231324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-012dabe4e123d8995c80833facb6401e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29941111_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/f972e1cca17634d31243244ba2ddbb28.webp"
"MediaSize" => 90087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-f972e1cca17634d31243244ba2ddbb28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29941111_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/bfc92c3d5625b3ee87948ce314874ff9.webp"
"MediaSize" => 69729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-bfc92c3d5625b3ee87948ce314874ff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29941111_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/8e119757dbdca5c136917557d6067e9d.webp"
"MediaSize" => 232322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-8e119757dbdca5c136917557d6067e9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29941111_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/44b6a9a4657928969ad546a17b058063.webp"
"MediaSize" => 130656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-44b6a9a4657928969ad546a17b058063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29941111_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/e80100d32d24c23b8de0ed3e8137ae2c.webp"
"MediaSize" => 135631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-e80100d32d24c23b8de0ed3e8137ae2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29941111_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/5d898a7040bfe8342706ed1473ca4b3b.webp"
"MediaSize" => 142852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-5d898a7040bfe8342706ed1473ca4b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29941111_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/213d4b99cac58250549042805d6927ef.webp"
"MediaSize" => 148074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-213d4b99cac58250549042805d6927ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29941111_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/07300d29317430466f91010b2be94a11.webp"
"MediaSize" => 69037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-07300d29317430466f91010b2be94a11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29941111_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29941111/bd4f7ba82adfbd1f29708a8be4493f90.webp"
"MediaSize" => 204404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29941111/thumbnail-bd4f7ba82adfbd1f29708a8be4493f90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13477870"
"ResourceRecordKey" => "29941111"
"ModificationTimestamp" => "2026-06-23T15:07:05.43Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941111')"
+"ID": "1557130"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24789
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2099844" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24798
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29941111'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177
+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 '29941111'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25193
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29941111' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5438043 43.4628115)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25246
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+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"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29943792_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/60f970c016ddb32a22fcee55e789678a.webp"
"MediaSize" => 75391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-60f970c016ddb32a22fcee55e789678a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29943792_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/f16dc7596778efb536000dd9d3b716a8.webp"
"MediaSize" => 78588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-f16dc7596778efb536000dd9d3b716a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29943792_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/e4dd308e6078d6522a254a41227acd08.webp"
"MediaSize" => 75875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-e4dd308e6078d6522a254a41227acd08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29943792_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/42c4b9b8dd55a37d4dc73c814b6ed9b7.webp"
"MediaSize" => 83466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-42c4b9b8dd55a37d4dc73c814b6ed9b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29943792_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/a5f0609810f527c2b5788a29cfa8536f.webp"
"MediaSize" => 86631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-a5f0609810f527c2b5788a29cfa8536f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29943792_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943792/ba52411efb480128c6a920db9fbb7216.webp"
"MediaSize" => 155975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943792/thumbnail-ba52411efb480128c6a920db9fbb7216.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841883"
"ResourceRecordKey" => "29943792"
"ModificationTimestamp" => "2026-06-23T20:31:48.78Z"
]
]
+"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 {#25242
+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 [
"RoomKey" => "1666331854"
"RoomType" => "Dining room"
"ListingId" => "X13481030"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29943950"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:43.75Z"
]
1 => array:11 [
"RoomKey" => "1666331855"
"RoomType" => "Living room"
"ListingId" => "X13481030"
"RoomLevel" => "Main level"
"RoomWidth" => 3.65
"ListingKey" => "29943950"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:43.75Z"
]
2 => array:11 [
"RoomKey" => "1666331856"
"RoomType" => "Kitchen"
"ListingId" => "X13481030"
"RoomLevel" => "Main level"
"RoomWidth" => 2.63
"ListingKey" => "29943950"
"RoomLength" => 3.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:43.76Z"
]
3 => array:11 [
"RoomKey" => "1666331857"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13481030"
"RoomLevel" => "Main level"
"RoomWidth" => 2.72
"ListingKey" => "29943950"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:43.76Z"
]
4 => array:11 [
"RoomKey" => "1666331858"
"RoomType" => "Bedroom 2"
"ListingId" => "X13481030"
"RoomLevel" => "Main level"
"RoomWidth" => 2.61
"ListingKey" => "29943950"
"RoomLength" => 2.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-23T20:53:43.76Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29943950_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/b058522f679fbec8f26bb153637cfd62.webp"
"MediaSize" => 255913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-b058522f679fbec8f26bb153637cfd62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943950_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/75122b8135b420d1affed4e4651ad4ae.webp"
"MediaSize" => 271728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-75122b8135b420d1affed4e4651ad4ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943950_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/8155307a092daa45a03505c076e03779.webp"
"MediaSize" => 110154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-8155307a092daa45a03505c076e03779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943950_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/9f89553354ed109ae1858fb0a5a0b43f.webp"
"MediaSize" => 156280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-9f89553354ed109ae1858fb0a5a0b43f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943950_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/0820688433f1004a209f683777991a2d.webp"
"MediaSize" => 265821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-0820688433f1004a209f683777991a2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943950_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/d0f0d32bbf55caad82b43e773e646f89.webp"
"MediaSize" => 294672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-d0f0d32bbf55caad82b43e773e646f89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943950_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/ff800be1613be12890e0f359b1338de2.webp"
"MediaSize" => 288187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-ff800be1613be12890e0f359b1338de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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 {#25239
+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 {#25243
+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 {#25241
+post_id: "1557981"
+post_author: 1
+"ListingKey": "29941527"
+"ListingId": "40842190"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:00:18Z"
+"RFModificationTimestamp": "2026-06-23T19:45:14Z"
+"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-23T15:51:05Z"
+"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 [ …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/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": "Other"
+"ListAgentNationalAssociationId": "1343007"
+"ListOfficeNationalAssociationId": "1404812"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941527')"
+"ID": "1557981"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23426
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939963')"
+"ID": "1556236"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1556237"
+post_author: 1
+"ListingKey": "29940024"
+"ListingId": "X13477170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:50:00Z"
+"RFModificationTimestamp": "2026-06-23T04:34:23Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "#207 - 300 KEATS WAY, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544516
1 => 43.462144
]
+"Latitude": 43.462144
+"Longitude": -80.544516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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)"
+"AssociationFee": "1037.87"
+"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-23T04:34:17.703271+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135760"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T03:41:02Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T03:41:02Z"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "2260"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29940024/207-300-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TREVARREN PROP MGMT"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-23T03:41:02.41Z"
+"ListAgentNationalAssociationId": "1388108"
+"ListOfficeNationalAssociationId": "1132867"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940024')"
+"ID": "1556237"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+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"
}
]
+success: true
+page_size: 9
+page_count: 42
+count: 374
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]