array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29943950 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "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
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943950_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/6e8de3721759224f11738e2588229f7b.webp"
"MediaSize" => 111436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-6e8de3721759224f11738e2588229f7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29943950_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943950/f7be56bfa243004ddf218abda4f912ce.webp"
"MediaSize" => 230092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943950/thumbnail-f7be56bfa243004ddf218abda4f912ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13481030"
"ResourceRecordKey" => "29943950"
"ModificationTimestamp" => "2026-06-23T20:53:43.73Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943950')"
+"ID": "1559384"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284505" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24763
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1423901" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24772
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29943950'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25136
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29943950'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25152
+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 '29943950' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.531342 43.477165)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25205
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+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 {#25201
+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 [
"RoomKey" => "1666270571"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
1 => array:11 [
"RoomKey" => "1666270572"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
2 => array:11 [
"RoomKey" => "1666270573"
"RoomType" => "Bedroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
3 => array:11 [
"RoomKey" => "1666270574"
"RoomType" => "Bedroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
4 => array:11 [
"RoomKey" => "1666270575"
"RoomType" => "Bedroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
5 => array:11 [
"RoomKey" => "1666270576"
"RoomType" => "Bedroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
6 => array:11 [
"RoomKey" => "1666270577"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
7 => array:11 [
"RoomKey" => "1666270578"
"RoomType" => "Living room"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
8 => array:11 [
"RoomKey" => "1666270579"
"RoomType" => "Dining room"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
9 => array:11 [
"RoomKey" => "1666270580"
"RoomType" => "Kitchen"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.12Z"
]
10 => array:11 [
"RoomKey" => "1666270581"
"RoomType" => "Foyer"
"ListingId" => "40841864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943407"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T19:32:30.13Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29943407_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/d5160ee20ca48f475ee29b6b0ee8f784.webp"
"MediaSize" => 139405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-d5160ee20ca48f475ee29b6b0ee8f784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943407_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/6ae5cda498f69144d62f83a23fbcacec.webp"
"MediaSize" => 112875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-6ae5cda498f69144d62f83a23fbcacec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943407_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/44b305e85cde160e49a67982f24c07c7.webp"
"MediaSize" => 91082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-44b305e85cde160e49a67982f24c07c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943407_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/13c575443cf9fae3e3422cccd607b368.webp"
"MediaSize" => 67593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-13c575443cf9fae3e3422cccd607b368.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943407_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/9eb8e7190f61c83f3bee0a5dee4bbf59.webp"
"MediaSize" => 78571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-9eb8e7190f61c83f3bee0a5dee4bbf59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943407_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/9bde78c96bc53bcf7fd12c876dbd3377.webp"
"MediaSize" => 83634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-9bde78c96bc53bcf7fd12c876dbd3377.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943407_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/ba7ca39d0dffc6a8f7c9fa60a6661850.webp"
"MediaSize" => 63896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-ba7ca39d0dffc6a8f7c9fa60a6661850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943407_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/cd7689d13eb1bfb4aba6aff6e0706006.webp"
"MediaSize" => 82537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-cd7689d13eb1bfb4aba6aff6e0706006.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29943407_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/800fb7778ffb1287fc56782390ad4b23.webp"
"MediaSize" => 78504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-800fb7778ffb1287fc56782390ad4b23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29943407_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/b7af54f576c5eb3e650cd0d6eb588b43.webp"
"MediaSize" => 76314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-b7af54f576c5eb3e650cd0d6eb588b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29943407_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/2f541eb1b0fc8c6d521f28d5a2d8ead3.webp"
"MediaSize" => 85601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-2f541eb1b0fc8c6d521f28d5a2d8ead3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29943407_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/79cb8f97ce5737b50fdc102fa86a4cb5.webp"
"MediaSize" => 75272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-79cb8f97ce5737b50fdc102fa86a4cb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29943407_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/6796c474b68d96f03c3ff7e5f59b02b2.webp"
"MediaSize" => 81006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-6796c474b68d96f03c3ff7e5f59b02b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29943407_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/b83f8c2529e923ce97308feae1c11a52.webp"
"MediaSize" => 83011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-b83f8c2529e923ce97308feae1c11a52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29943407_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/52ee5c3c3381f22b1dd54e717893119b.webp"
"MediaSize" => 83971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-52ee5c3c3381f22b1dd54e717893119b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29943407_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/a5db16a45ea368ea27af45ef0aac4541.webp"
"MediaSize" => 84588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-a5db16a45ea368ea27af45ef0aac4541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841864"
"ResourceRecordKey" => "29943407"
"ModificationTimestamp" => "2026-06-23T19:32:30.08Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29943407_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943407/b1e37a22f6956ff5f7f77f171957f8aa.webp"
"MediaSize" => 77524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943407/thumbnail-b1e37a22f6956ff5f7f77f171957f8aa.webp"
…7
]
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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
+post_id: "1557981"
+post_author: 1
+"ListingKey": "29941527"
+"ListingId": "40842190"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T01:20:31Z"
+"RFModificationTimestamp": "2026-06-24T01:21:42Z"
+"ListPrice": 339999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 642.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "158 KING Street N Unit# 801, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.5232859
1 => 43.4715923
]
+"Latitude": 43.4715923
+"Longitude": -80.5232859
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful, owner-occupied condo at 158 King Street North, Waterloo. This bright, clean and carpet-free home has been lovingly cared for and maintained by the current owner, showing pride of ownership. Inside, you will find newly-installed(2025) flooring throughout, high 9-foot ceilings and big windows that bring in abundance of natural light. Enjoy two generously-sized bedrooms, two full bathrooms including one ensuite, and the convenience of having your own washer and dryer right inside the unit. The outdoor and window views offer a rare, tranquil escape in the middle of the city. You can wake up to a breathtaking sunrise view right from your bedroom window, and then step out onto your spacious balcony to enjoy peaceful vistas over a beautiful green schoolyard. The location also makes your daily life incredibly easy, walking to both Walmart and Sobeys for your groceries or walking to the local trails and the restaurants and shops in Uptown Waterloo. With a transit stop just steps away and both Wilfrid Laurier University and the University of Waterloo close by, getting around town is just a breeze. Call your realtor today before it's gone! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "408.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T19:45:05.301373+00:00"
+"Directions": "TURN EAST TO NOECKER ST FROM KING, BUILDING ENTRANCE FACING NOECKER ST, BUILDING SAYS 158 KING, TOWER 2"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Vinyl siding"
2 => "Other"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067924"
+"ListOfficeKey": "291737"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T15:51:05Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T01:10:01Z"
+"Stories": "21.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3096"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …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": "Owner"
+"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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: "1557130"
+post_author: 1
+"ListingKey": "29941111"
+"ListingId": "X13477870"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:30:10Z"
+"RFModificationTimestamp": "2026-06-23T16:58:32Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "6 - 250 KEATS WAY, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.5438043
1 => 43.4628115
]
+"Latitude": 43.4628115
+"Longitude": -80.5438043
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRIME UNIVERSITY INVESTMENT OPPORTUNITY WITH WALKOUT BASEMENT Exceptional 3-bedroom townhome with garage in the highly sought-after Keats Way complex, perfectly positioned just minutes from the University of Waterloo and Wilfrid Laurier University. This well-maintained property offers a highly desirable layout with 3 bedrooms on the upper level, a finished walkout basement with a full bathroom, and a total of 2.5 bathrooms, creating outstanding flexibility for both investors and end users. Featuring hardwood flooring, a newly renovated upper-level bathroom, and bright, functional living spaces, this home is built for both comfort and long-term durability. The walkout basement adds valuable living space and significantly enhances rental potential. This property delivers positive cash flow when fully occupied, making it a true turn-key investment in one of Waterloo's most reliable and high-demand rental markets. The inclusion of a private garage and additional parking further strengthens tenant appeal and long-term value. Located close to transit, restaurants, shopping, parks, and major commuter routes, this is a rare opportunity to secure a high-performing income property in a proven university corridor. (id:62650)"
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T16:58:28.056663+00:00"
+"Directions": "Cross Streets: University and Keats Way. ** Directions: University to Keats Way."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099844"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:21:21Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:21:21Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4268"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29941111/6-250-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "wilson blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-23T15:07:05.42Z"
+"ListAgentNationalAssociationId": "1370036"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941111')"
+"ID": "1557130"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+post_id: "1556439"
+post_author: 1
+"ListingKey": "29940076"
+"ListingId": "40842185"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T04:55:09Z"
+"RFModificationTimestamp": "2026-06-23T05:10:29Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.258
+"LivingArea": 1856.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4B6"
+"UnparsedAddress": "67 LONGWOOD Drive, Waterloo, Ontario N2L4B6"
+"Coordinates": array:2 [
0 => -80.5383933
1 => 43.4902508
]
+"Latitude": 43.4902508
+"Longitude": -80.5383933
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "THE CALM OF A WOODED ESCAPE, WITHOUT LEAVING WATERLOO. Set on a mature 0.25 acre lot, this serene split-level home is tucked into one of Waterloo’s most established Lakeshore pockets, offering plenty of space, greenery, and a setting that feels removed from the everyday hustle of the city. Inside, the home has been beautifully cared for and thoughtfully updated, blending mid-century lines, warm wood details, and a nostalgic soul. The main floor welcomes you with a generous foyer and an inviting family room anchored by a wood-burning fireplace, with sliding doors that open to a private rear deck surrounded by nature. A few steps up, the main living area offers bright, well-proportioned living and dining spaces alongside an updated eat-in kitchen that brings modern function to the heart of the home. Upstairs, hardwood flooring adds warmth and continuity throughout the bedroom level. The primary bedroom features its own ensuite, while the updated main bathroom serves the additional bedrooms with style and ease. The lower level adds valuable flexibility with an additional bedroom, three-piece bathroom, workshop space, generous storage, and a separate walk-up to the backyard, creating excellent potential for a guest bedroom, hobby room, a home office, or extended family use. Outdoors, the backyard is a true highlight: private, lower-maintenance naturalized yard, with mature trees and space to relax, host, garden, or simply enjoy the sounds of being outdoors. Updates include: Kitchen (2025), 2nd Floor Bathrooms and Hardwood (2023), Humidifier (2023), AC (2020), Furnace and Water Softener (2017), Shingles (2012), most windows (2006). Located close to parks, trails, everyday shopping, transit, Conestoga Parkway access, both universities, and weekend favourites like Waterloo Park, Conestoga Mall, the St. Jacobs Farmers’ Market, and Uptown Waterloo, this is a lovingly cared for Lakeshore home with character, comfort, and lasting appeal. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T05:10:26.729512+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "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": "2091993"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.258"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T04:31:43Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T04:49:55Z"
+"Stories": "2.0"
+"StreetName": "LONGWOOD"
+"StreetNumber": "67"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5141.81"
+"VirtualTourURLUnbranded": "https://youriguide.com/xd8uc_67_longwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940076/67-longwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 1669
+"BelowGradeFinishedArea": 187
+"OriginalEntryTimestamp": "2026-06-23T04:31:43.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364566"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
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]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940076')"
+"ID": "1556439"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1556236"
+post_author: 1
+"ListingKey": "29939963"
+"ListingId": "40842183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:00:04Z"
+"RFModificationTimestamp": "2026-06-23T04:38:39Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "300 KEATS Way Unit# 207, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.5442195
1 => 43.4623301
]
+"Latitude": 43.4623301
+"Longitude": -80.5442195
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207—a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit—this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "1037.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:38:32.452163+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T02:50:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:50:17Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2260"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29939963/300-keats-way-unit-207-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Car Wash"
1 => "Party Room"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-06-23T02:50:16.8Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939963')"
+"ID": "1556236"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940024')"
+"ID": "1556237"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: "1555317"
+post_author: 1
+"ListingKey": "29938299"
+"ListingId": "X13475910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:55:18Z"
+"RFModificationTimestamp": "2026-06-23T18:59:03Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E9"
+"UnparsedAddress": "703 - 128 KING STREET N, Waterloo, Ontario N2J0E9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to One28 Condos, perfectly situated in one of Waterloo's most desirable and vibrant locations. This bright, modern one-bedroom plus den suite features soaring nine-foot ceilings and an open-concept layout that seamlessly integrates the kitchen, dining, and living areas. The versatile and spacious den serves as an ideal home office or study space. Enjoy unobstructed views and plenty of natural light from the private balcony, accessible directly from the main living area. The prime location offers unparalleled convenience, placing you just minutes from Uptown Waterloo, the University of Waterloo, Wilfrid Laurier University, and the Technology Park. With boutique shops, fine dining, and the ION LRT transit system just steps away, commuting and daily living are effortless. Residents enjoy premium indoor and outdoor building amenities, including 24-hour security surveillance, a fully equipped fitness centre, a yoga studio, a steam room, a dedicated party and study room, a green roof, and an outdoor terrace with BBQ facilities.The unit is equipped with stainless steel appliances (stove, fridge, dishwasher, microwave) and an in-suite washer and dryer. One underground parking space and one storage locker are included. This turn-key home is completely move-in ready. Book your private showing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "422"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:12:17.976834+00:00"
+"Directions": "Cross Streets: King st N. ** Directions: East."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239952"
+"ListOfficeKey": "289134"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T18:45:55Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:45:55Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4014.65"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938299/703-128-king-street-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onix property management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MR25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T20:19:37.2Z"
+"ListAgentNationalAssociationId": "1477884"
+"ListOfficeNationalAssociationId": "1374946"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938299')"
+"ID": "1555317"
}
]
+success: true
+page_size: 9
+page_count: 44
+count: 388
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]