array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29971291 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1579629"
+post_author: 1
+"ListingKey": "29971291"
+"ListingId": "X13505422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:26Z"
+"RFModificationTimestamp": "2026-06-30T18:22:53Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G104 - 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": "Discover exceptional value in this beautifully maintained 2-bedroom, 1-bathroom condominium located in Waterloo's highly desirable University District. Offering approximately 762 sq. ft. of thoughtfully designed living space, this bright and inviting unit features a practical layout that is ideal for both owner-occupiers and investors.Positioned within walking distance of the University of Waterloo, Wilfrid Laurier University, Conestoga College, the ION LRT, shopping, dining, parks, and everyday amenities, this location provides unmatched convenience and strong rental demand.Being sold fully furnished, the condo is ready for immediate use with minimal effort. The property is currently occupied by long-term tenants, presenting an excellent opportunity for buyers looking to generate rental income from day one while benefiting from continued leasing potential. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "344"
+"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-30T18:20:48.259501+00:00"
+"Directions": "Hickory St W & Hemlock St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141272"
+"ListOfficeKey": "296550"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T17:16:20Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:16:20Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2581.45"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1672010417"
"RoomType" => "Living room"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.83
"ListingKey" => "29971291"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
1 => array:11 [
"RoomKey" => "1672010418"
"RoomType" => "Kitchen"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.83
"ListingKey" => "29971291"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
2 => array:11 [
"RoomKey" => "1672010419"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.76
"ListingKey" => "29971291"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
3 => array:11 [
"RoomKey" => "1672010420"
"RoomType" => "Bedroom 2"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.94
"ListingKey" => "29971291"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
4 => array:11 [
"RoomKey" => "1672010421"
"RoomType" => "Bathroom"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29971291"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29971291/g104-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blackline Management Services"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-30T17:16:20.88Z"
+"ListAgentNationalAssociationId": "1393034"
+"ListOfficeNationalAssociationId": "1459693"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29971291_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/2b8d4ab1fa4874a5a42c527c967a41e6.webp"
"MediaSize" => 302661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-2b8d4ab1fa4874a5a42c527c967a41e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29971291_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/c0b88b1d4de5851965535d8a9837f47d.webp"
"MediaSize" => 316881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-c0b88b1d4de5851965535d8a9837f47d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29971291_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/fdfb8963afe89fc576ed3fb5e0a8acdc.webp"
"MediaSize" => 330308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-fdfb8963afe89fc576ed3fb5e0a8acdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29971291_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/371ffb4ffd7de985ab199f1b3b6aa4a5.webp"
"MediaSize" => 323199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-371ffb4ffd7de985ab199f1b3b6aa4a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29971291_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d54bf654c6013e76bed5e6c26ecb9284.webp"
"MediaSize" => 360141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d54bf654c6013e76bed5e6c26ecb9284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29971291_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/e3fe501484562c589d0e6e602f9144f0.webp"
"MediaSize" => 326822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-e3fe501484562c589d0e6e602f9144f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29971291_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/9e80c178ebd352c11d2f98673c771501.webp"
"MediaSize" => 321851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-9e80c178ebd352c11d2f98673c771501.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29971291_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/8b22c8763036b6ba75dc8a79f2e5e126.webp"
"MediaSize" => 329729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-8b22c8763036b6ba75dc8a79f2e5e126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29971291_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/e83866530dfdb35466e0f1025d7ae7ad.webp"
"MediaSize" => 337196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-e83866530dfdb35466e0f1025d7ae7ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29971291_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/1b9cb35c00cdfb8cc77c98de2d99ab45.webp"
"MediaSize" => 349380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-1b9cb35c00cdfb8cc77c98de2d99ab45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29971291_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/74faf7aec952ec386ba09bf8732f9332.webp"
"MediaSize" => 350550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-74faf7aec952ec386ba09bf8732f9332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29971291_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/f3f2f77c4607d6318e1a071c20057367.webp"
"MediaSize" => 362306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-f3f2f77c4607d6318e1a071c20057367.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29971291_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/96d5139bd09ed5179d65e03163eb5bc6.webp"
"MediaSize" => 360813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-96d5139bd09ed5179d65e03163eb5bc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29971291_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/0e21c952665bd689bcd3f75490b91d4e.webp"
"MediaSize" => 346535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-0e21c952665bd689bcd3f75490b91d4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29971291_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/607aa6fc4fea41c5243a333056d5b7a0.webp"
"MediaSize" => 93803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-607aa6fc4fea41c5243a333056d5b7a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29971291_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/90fa8d1e663c6953c0a2159bc338f47a.webp"
"MediaSize" => 64599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-90fa8d1e663c6953c0a2159bc338f47a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29971291_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d1267444d691a7e46206b32da5b4f1fa.webp"
"MediaSize" => 113348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d1267444d691a7e46206b32da5b4f1fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29971291_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/2caf3d3a923e0d4f7ad6e086e81ea7c4.webp"
"MediaSize" => 102207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-2caf3d3a923e0d4f7ad6e086e81ea7c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29971291_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d3fe63d3efd8d86f8b8f4f9953f8c1ee.webp"
"MediaSize" => 122085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d3fe63d3efd8d86f8b8f4f9953f8c1ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29971291_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/5e4e0d5d738d319746eee4aeb8386a33.webp"
"MediaSize" => 117290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-5e4e0d5d738d319746eee4aeb8386a33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29971291_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/5d01057332ee710011136fe531f47cd2.webp"
"MediaSize" => 137628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-5d01057332ee710011136fe531f47cd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29971291_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/4d7df7d8a9896967f8ea1992b06352a8.webp"
"MediaSize" => 148573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-4d7df7d8a9896967f8ea1992b06352a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29971291_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/a927c801ba052dd9ec801c1b20c8ef16.webp"
"MediaSize" => 141891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-a927c801ba052dd9ec801c1b20c8ef16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29971291_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/82069a4a8d17635b1002dc57dcd53733.webp"
"MediaSize" => 112055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-82069a4a8d17635b1002dc57dcd53733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29971291_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/b44b503d63f75255da851423005b8b01.webp"
"MediaSize" => 141331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-b44b503d63f75255da851423005b8b01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29971291_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/ce7f06482fcd557930ad4668fb6bdb5c.webp"
"MediaSize" => 109332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-ce7f06482fcd557930ad4668fb6bdb5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29971291_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/30c7f47a3466cf272000211cbeb2e743.webp"
"MediaSize" => 162696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-30c7f47a3466cf272000211cbeb2e743.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29971291_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/9184001b668824cfb78871fed244ab81.webp"
"MediaSize" => 155766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-9184001b668824cfb78871fed244ab81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29971291_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/c778e5d5f35969d4ebb5085e0cdf5beb.webp"
"MediaSize" => 130801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-c778e5d5f35969d4ebb5085e0cdf5beb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29971291_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/b2dcb63db3c6eb2061c8dc789c6bd40f.webp"
"MediaSize" => 116583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-b2dcb63db3c6eb2061c8dc789c6bd40f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29971291_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/a5f90cf4d39148d9a0c11434251c2134.webp"
"MediaSize" => 116666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-a5f90cf4d39148d9a0c11434251c2134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29971291_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/1359aaec471e446fd30bab050cf02341.webp"
"MediaSize" => 131190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-1359aaec471e446fd30bab050cf02341.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29971291_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/47118cbee9e67d131681764b5018d0a1.webp"
"MediaSize" => 71559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-47118cbee9e67d131681764b5018d0a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29971291_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/694a632d2a70518639ed48cdbdb14ea7.webp"
"MediaSize" => 189048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-694a632d2a70518639ed48cdbdb14ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29971291_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/339bffd816a5b7f3867088aa551df582.webp"
"MediaSize" => 123231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-339bffd816a5b7f3867088aa551df582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29971291_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/77ed0b7832b181f7a8232ffbbe078bc0.webp"
"MediaSize" => 386477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-77ed0b7832b181f7a8232ffbbe078bc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29971291_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/c714031667a46253e05c5ceb2cd19191.webp"
"MediaSize" => 382644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-c714031667a46253e05c5ceb2cd19191.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29971291_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/53a32586a54e6b0b5169c9ca3af12bf5.webp"
"MediaSize" => 386972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-53a32586a54e6b0b5169c9ca3af12bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29971291_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/f7976f22dd14e5447de0596b793d87a9.webp"
"MediaSize" => 379777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-f7976f22dd14e5447de0596b793d87a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29971291_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/bd7a246a89a5e372dec78fb75b243adf.webp"
"MediaSize" => 362119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-bd7a246a89a5e372dec78fb75b243adf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29971291_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/0e00ac8e112e5444d077d1b2b3e2d604.webp"
"MediaSize" => 292681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-0e00ac8e112e5444d077d1b2b3e2d604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971291')"
+"ID": "1579629"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 296550" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24902
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2141272" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24964
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24860
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2141272"
+"ModificationTimestamp": "2025-02-09T13:30:07Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2141272"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2141272')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29971291'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29971291'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29971291' 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 {#25348
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1578689"
+post_author: 1
+"ListingKey": "29970323"
+"ListingId": "X13504430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3 Bdr Unit Offers Large Windows, Lots Of Natural Light,9 Ft Ceilings, Custom Kitchen Cabinetry, Fully furnished Appliance, Ensuite Laundry (brand new),3 Great Size Bdrms & 2 FullBaths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "812.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.712374+00:00"
+"Directions": "King St N/ University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:26Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:26Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5127.5"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671906563"
"RoomType" => "Dining room"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970323"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.89Z"
]
1 => array:11 [
"RoomKey" => "1671906564"
"RoomType" => "Living room"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970323"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.89Z"
]
2 => array:11 [
"RoomKey" => "1671906565"
"RoomType" => "Kitchen"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29970323"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.89Z"
]
3 => array:11 [
"RoomKey" => "1671906566"
"RoomType" => "Bedroom"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970323"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.9Z"
]
4 => array:11 [
"RoomKey" => "1671906567"
"RoomType" => "Bedroom 2"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970323"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.9Z"
]
5 => array:11 [
"RoomKey" => "1671906568"
"RoomType" => "Bedroom 3"
"ListingId" => "X13504430"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29970323"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T15:16:26.9Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970323/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-30T15:16:26.76Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29970323_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/94ae1466c7f7bdfa9443f0dc8ad00f22.webp"
"MediaSize" => 186888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-94ae1466c7f7bdfa9443f0dc8ad00f22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29970323_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/7b3694c7a2deb025f40c4cfa6fd6f7d0.webp"
"MediaSize" => 104335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-7b3694c7a2deb025f40c4cfa6fd6f7d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29970323_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/eac6b281e50d7704f2c81d65b8a78652.webp"
"MediaSize" => 163632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-eac6b281e50d7704f2c81d65b8a78652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29970323_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/c66b4ac90c1704ac81bc3a48985b47b1.webp"
"MediaSize" => 153957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-c66b4ac90c1704ac81bc3a48985b47b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29970323_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/a05ea1f8193df4e59a7f061e332769db.webp"
"MediaSize" => 190934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-a05ea1f8193df4e59a7f061e332769db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29970323_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/f1af85cf635a30c9a6dcc13b8580849b.webp"
"MediaSize" => 158242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-f1af85cf635a30c9a6dcc13b8580849b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29970323_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/99a29c1b028d1f12a85c7a7f655b0d9e.webp"
"MediaSize" => 161431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-99a29c1b028d1f12a85c7a7f655b0d9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29970323_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/b7ecbfee0830d07aa14e03143e9b53f9.webp"
"MediaSize" => 181868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-b7ecbfee0830d07aa14e03143e9b53f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29970323_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/f4ee3fa92cc0a00218969499166939b4.webp"
"MediaSize" => 78051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-f4ee3fa92cc0a00218969499166939b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29970323_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/3ea5bffe23f8328538f6280923600390.webp"
"MediaSize" => 72377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-3ea5bffe23f8328538f6280923600390.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29970323_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/89ec2ec92521a3cec70f6035245951a6.webp"
"MediaSize" => 205003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-89ec2ec92521a3cec70f6035245951a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29970323_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/5c06a42e5426dc08d19964bf138fd5ac.webp"
"MediaSize" => 192855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-5c06a42e5426dc08d19964bf138fd5ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29970323_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/3fec49d309b933bd9635212996357343.webp"
"MediaSize" => 123845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-3fec49d309b933bd9635212996357343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29970323_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/fdb873dd92c9360019c1885284175840.webp"
"MediaSize" => 42480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-fdb873dd92c9360019c1885284175840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29970323_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/6cb785285900bdfe84bbb9082fa8fa22.webp"
"MediaSize" => 232599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-6cb785285900bdfe84bbb9082fa8fa22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29970323_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29970323/1322b3af4d4f54da3328cfd91d3cac28.webp"
"MediaSize" => 251775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29970323/thumbnail-1322b3af4d4f54da3328cfd91d3cac28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13504430"
"ResourceRecordKey" => "29970323"
"ModificationTimestamp" => "2026-06-30T15:16:26.77Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970323')"
+"ID": "1578689"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1576482"
+post_author: 1
+"ListingKey": "29967867"
+"ListingId": "40843784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T20:40:14Z"
+"RFModificationTimestamp": "2026-06-30T20:41:58Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2088.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K7"
+"UnparsedAddress": "223 CARTER Avenue, Waterloo, Ontario N2J3K7"
+"Coordinates": array:2 [
0 => -80.5143455
1 => 43.4790622
]
+"Latitude": 43.4790622
+"Longitude": -80.5143455
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover Mid-Century Charm Re-imagined with Modern Luxury. Perfectly positioned and completely transformed, this 4-bedroom, 2-bathroom residence offers an unparalleled turnkey lifestyle. From the curb this home commands immediate attention with the poured concrete walkway, immaculate lawn, and a striking front porch overhang featuring a warm cedar ceiling—a prelude to the architectural details within. Step inside to an open-concept living space unified by rich engineered hardwood flooring and a spectacular custom cedar ceiling that radiates organic warmth. The heart of the home is the bespoke chef’s kitchen, thoughtfully designed with custom Eucalyptus green cabinetry, a sprawling island, quartz counter-tops, airy exposed shelving, and an integrated hideaway bar cabinet to elevate your hosting game. Down the hall, the main bath has been re-imagined into a spa-like oasis, boasting custom cabinetry, quartz counters, refined gold trim, heated flooring, and a heated towel rack. The finished lower level maximizes both utility and leisure. Gather for movie nights anchored by a sleek gas fireplace, or entertain at the custom bar with seating. This versatile level also hosts a spacious fourth bedroom—that could double as a home gym or office—a beautifully appointed 3-piece bathroom, and a streamlined laundry and large storage area. The sophistication extends into a private backyard sanctuary. Designed for effortless enjoyment, the yard features a custom-poured concrete patio accented with detailed architectural ledges and finishes. Surrounded by professional, low-maintenance landscaping, it is the ultimate setting for alfresco dining. A premium steel storage shed completes the outdoor space. Situated in a highly desirable, family-friendly Waterloo neighbourhood, this home is moments from top-tier schools and parks. Every detail of 223 Carter Avenue has been meticulously executed, offering a rare blend of custom craftsmanship and move-in-ready living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T21:54:15.108716+00:00"
+"Directions": "Lincoln Rd, to Marshall, to Carter Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953837"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Crushed stone driveway"
]
+"PhotosChangeTimestamp": "2026-06-29T22:11:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T20:31:29Z"
+"Stories": "1.0"
+"StreetName": "CARTER"
+"StreetNumber": "223"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4081.94"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/223-carter-ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1672156898"
"RoomType" => "Storage"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.4Z"
]
1 => array:11 [
"RoomKey" => "1672156899"
"RoomType" => "Workshop"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.4Z"
]
2 => array:11 [
"RoomKey" => "1672156900"
"RoomType" => "Laundry room"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
3 => array:11 [
"RoomKey" => "1672156901"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
4 => array:11 [
"RoomKey" => "1672156902"
"RoomType" => "Bedroom"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
5 => array:11 [
"RoomKey" => "1672156903"
"RoomType" => "Recreation room"
"ListingId" => "40843784"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 27'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
6 => array:11 [
"RoomKey" => "1672156904"
"RoomType" => "Bedroom"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
7 => array:11 [
"RoomKey" => "1672156905"
"RoomType" => "Bedroom"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
8 => array:11 [
"RoomKey" => "1672156906"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
9 => array:11 [
"RoomKey" => "1672156907"
"RoomType" => "Full bathroom"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
10 => array:11 [
"RoomKey" => "1672156908"
"RoomType" => "Kitchen"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 18'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
11 => array:11 [
"RoomKey" => "1672156909"
"RoomType" => "Living room"
"ListingId" => "40843784"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967867"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T20:31:29.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967867/223-carter-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 1038
+"OriginalEntryTimestamp": "2026-06-29T20:51:49.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1247007"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29967867_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29967867/dc2e1a8f22d90893e00eaa809c84f51c.webp"
"MediaSize" => 114103
"MediaType" => "webp"
…8
]
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]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967867')"
+"ID": "1576482"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1575808"
+post_author: 1
+"ListingKey": "29966422"
+"ListingId": "40842592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:29Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1004, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.5264715
1 => 43.4789254
]
+"Latitude": 43.4789254
+"Longitude": -80.5264715
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 318 Spruce Street, where comfort, convenience, and thoughtful design come together in a well-maintained building. This pristine, fully furnished turnkey suite offers a functional layout and is vacant for immediate occupancy, making it an ideal opportunity for students, working professionals, or investors. The modern kitchen features granite countertops, a breakfast bar, stylish backsplash, and stainless steel appliances. Enjoy the convenience of in-suite laundry, a private balcony, and one secure underground parking space. Residents have access to excellent building amenities, including a fitness centre, outdoor terrace, study area, guest suite, and social room. Low condo fees add to the value and affordability of this well-managed building. Ideally located within walking distance to both universities and Conestoga College, the condo is also close to restaurants, shopping, transit, parks, and a wide range of everyday amenities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "429.68"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:49:24.358366+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1910159"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-29T17:31:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:31:53Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3552.01"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=z3iR41awfNp"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966422/318-spruce-street-unit-1004-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-06-29T17:31:52.88Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1222261"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966422')"
+"ID": "1575808"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1576317"
+post_author: 1
+"ListingKey": "29966442"
+"ListingId": "40836179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:17Z"
+"ListPrice": 1470000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2663.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2S8"
+"UnparsedAddress": "294 ALGONQUIN Drive, Waterloo, Ontario N2L2S8"
+"Coordinates": array:2 [
0 => -80.5462881
1 => 43.4644504
]
+"Latitude": 43.4644504
+"Longitude": -80.5462881
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Architecturally Distinct Mid-Century Bungalow in Prestigious Beechwood. A rare opportunity to own a truly unique home in one of Waterloo's most sought-after neighbourhoods. Nestled within a private wooded enclave, this architecturally significant mid-century executive bungalow offers over 2,650 sq. ft. of thoughtfully designed living space and an exceptional connection to nature. Step inside and be captivated by soaring floor-to-ceiling windows that frame private views and fill the home with natural light. The spacious main level is designed for both everyday living and entertaining, featuring expansive principal rooms, a welcoming living and dining area with a striking double-sided fireplace, and multiple spaces to gather with family and friends. The lower level offers incredible flexibility with a walkout to the backyard, a large family room, two additional bedrooms or office, a full bathroom, and direct access to the garage—ideal for multi-generational living, guests, or a future in-law setup. Outside, enjoy your own private backyard retreat surrounded by mature trees, offering peace, privacy, and endless potential to create your dream outdoor oasis. Updates include windows, roof, hot water tank and boiler, electrical service, extensive landscaping. While some cosmetic updating may be desired, the home presents an outstanding opportunity to personalize a property with exceptional character in an unbeatable location. Virtual staging has been provided to show decorating potential. Situated just minutes from the University of Waterloo, top-rated schools, parks, trails, shopping, and amenities, this is a location rarely offered and highly coveted. Bring your vision and imagination or just move in—this remarkable Beechwood property is ready to become your forever home. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Sauna"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-06-29T18:49:12.869016+00:00"
+"Directions": "Westmount Rd to Longfellow Dr. to Iroquois Pl. to Algonquin Dr."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Boiler"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996603"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Ravine"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:33:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:33:05Z"
+"Stories": "1.0"
+"StreetName": "ALGONQUIN"
+"StreetNumber": "294"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7014"
+"VirtualTourURLUnbranded": "https://youriguide.com/7ypyq_294_algonquin_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966442/294-algonquin-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 1011
+"OriginalEntryTimestamp": "2026-06-29T17:33:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279276"
+"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('29966442')"
+"ID": "1576317"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1573197"
+post_author: 1
+"ListingKey": "29962363"
+"ListingId": "X13497274"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T14:20:02Z"
+"RFModificationTimestamp": "2026-06-27T14:36:18Z"
+"ListPrice": 405000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "810 - 318 SPRUCE ST STREET, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Sage ll - a 23-storey tower designed as a "recreational retreat" for students and young professionals in Waterloo's university district. This suite features 2 bedrooms / 2 washrooms with laminate flooring throughout and a sleek kitchen equipped with granite countertops, stainless steel appliances (including a built-in dishwasher), and ample storage. Enjoy a large open balcony with breathtaking city views, accessible via a walk-out from the main living area. Floor-to-ceiling windows in the bedrooms and living areas ensure the space is bright and inviting with natural light. Its also an Education Hub located within walking distance of Wilfrid Laurier University and just a 6-minute drive to the University of Waterloo. The Conestoga Waterloo Campus is also just 1.5 km away. Steps away from essential shopping like Walmart and No Frills, as well as numerous cafes, restaurants, and a cinema. Close to Express Hwy 85 and the LRT, with multiple bus routes (7 King, 31 Columbia, 201 iXpress) easily accessible for commuting across the Tri-Cities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
]
+"AssociationFee": "588.67"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T14:36:14.306704+00:00"
+"Directions": "Cross Streets: King St N & University Ave W. ** Directions: North on King St N, Left on Hickory St W then right on Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1409777"
+"ListOfficeKey": "275778"
+"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-27T14:12:55Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T14:12:55Z"
+"StreetName": "Spruce St"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4521"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29962363/810-318-spruce-st-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-27T14:12:55.49Z"
+"ListAgentNationalAssociationId": "1047557"
+"ListOfficeNationalAssociationId": "1268116"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29962363')"
+"ID": "1573197"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1571971"
+post_author: 1
+"ListingKey": "29961135"
+"ListingId": "X13496232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T22:25:18Z"
+"RFModificationTimestamp": "2026-06-26T23:39:42Z"
+"ListPrice": 354000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "618 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 618 at Sage 5, a rare opportunity to own a bright 1-bedroom, 1-bathroom suite featuring floor-to-ceiling windows, unobstructed green views, and abundant natural light throughout. Occupied by only two residents since construction and exceptionally well maintained, this carpet-free home offers a functional layout with a spacious bedroom, large granite kitchen island, stainless steel appliances, and ensuite laundry. Enjoy the spacious balcony, accessible from both the living room and bedroom, overlooking peaceful greenery. Offered fully furnished, this move-in ready unit provides added convenience for both end-users and investors. Residents enjoy excellent amenities including a rooftop terrace, theatre room, fitness centre, student lounge, and study spaces. Ideally located in the heart of Waterloo's university district, just steps from the University of Waterloo, Wilfrid Laurier University, Waterloo Collegiate Institute, shopping, restaurants, and public transit. Condo fees include heat, , A/C, water, and high-speed internet. Ideal for parents, first-time buyers, and investors. Book your showing today! (id:62783)"
+"AssociationFee": "399.02"
+"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-26T23:39:32.064487+00:00"
+"Directions": "Cross Streets: Lester St & Hickory St. ** Directions: University Ave West to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T22:20:07Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T22:20:07Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961135/618-280-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Mgmt"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-26T22:20:07.24Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961135')"
+"ID": "1571971"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1570278"
+post_author: 1
+"ListingKey": "29958902"
+"ListingId": "X13494404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:35:48Z"
+"RFModificationTimestamp": "2026-06-26T18:22:55Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "103 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Furniture"
5 => "Water Heater"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:22:49.894189+00:00"
+"Directions": "Cross Streets: Albert And Hickory. ** Directions: Bridgeport Rd E To Albert Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T17:20:42Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:20:42Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958902/103-253-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T17:20:42.81Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958902')"
+"ID": "1570278"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1570279"
+post_author: 1
+"ListingKey": "29958394"
+"ListingId": "40843131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:40:10Z"
+"RFModificationTimestamp": "2026-06-26T18:12:38Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 734.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G3"
+"UnparsedAddress": "253 ALBERT Street Unit# 103, Waterloo, Ontario N2L0G3"
+"Coordinates": array:2 [
0 => -80.5334114
1 => 43.4754303
]
+"Latitude": 43.4754303
+"Longitude": -80.5334114
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:12:19.049966+00:00"
+"Directions": "Bridgeport Rd E To Albert Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-26T16:32:51Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:32:51Z"
+"Stories": "1.0"
+"StreetName": "ALBERT"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29958394/253-albert-street-unit-103-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 734
+"OriginalEntryTimestamp": "2026-06-26T16:32:51.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958394')"
+"ID": "1570279"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: "1567144"
+post_author: 1
+"ListingKey": "29945896"
+"ListingId": "40842567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T13:40:03Z"
+"RFModificationTimestamp": "2026-06-26T03:52:45Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1174.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H5"
+"UnparsedAddress": "58 BRIDGEPORT Road E Unit# 806, Waterloo, Ontario N2J4H5"
+"Coordinates": array:2 [
0 => -80.5178587
1 => 43.4687759
]
+"Latitude": 43.4687759
+"Longitude": -80.5178587
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "With almost 1200 sq ft of l living space, this large 3 bedroom, 2 bathroom condo has many updates including newer kitchen and bathrooms, flooring and neutral decor. There is a large balcony overlooking Waterloo where you can enjoy evening sunsets. The location is just steps to Bridgeport Plaza and a short ride to the Universities. If you are looking for a spacious 3 bedroom condo at an affordable price that is in a great location, this unit checks all the boxes. The covered parking spot is conveniently located at the back of the building. Call today for a viewing. (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFee": "879.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-26T03:51:57.627637+00:00"
+"Directions": "Take Bridgeport Rd E. past Weber St and turn right into Black Willow Condominiums"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T13:30:38Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T13:30:38Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "58"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2609"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945896/58-bridgeport-road-e-unit-806-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1944830"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1174
+"OriginalEntryTimestamp": "2026-06-24T13:30:38.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1240421"
+"CoListOfficeNationalAssociationId": "1004387"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945896')"
+"ID": "1567144"
}
]
+success: true
+page_size: 9
+page_count: 42
+count: 373
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]