array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29923313 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1543976"
+post_author: 1
+"ListingKey": "29923313"
+"ListingId": "X13462260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:05Z"
+"RFModificationTimestamp": "2026-06-18T21:10:54Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G105 - 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": "Welcome to Unit G105 at 275 Larch Street, a fully furnished 1 bedroom + spacious enclosed den, 2 bathroom condo in the heart of Waterloo's highly sought after University District. Offering 860 sq. ft. of bright, modern living space, this turnkey unit features soaring ceilings, oversized windows, quartz countertops, stainless steel appliances, in suite laundry, and durable flooring throughout. The spacious enclosed den provides exceptional flexibility for a home office, study area, guest space, or additional living area. Thoughtfully furnished with two beds, a sofa, TV, dining set, and storage pieces, this move in ready condo is ideal for first time buyers, parents looking to invest for their student, or investors seeking a low maintenance property in a prime rental location. Building amenities include a fitness centre, yoga studio, rooftop terrace, secure bike storage, and visitor parking. Located just steps from Wilfrid Laurier University, the University of Waterloo, Conestoga College, the ION LRT, restaurants, shopping, and everyday amenities, this property offers unbeatable convenience and long term appeal. Condo fees include water, heat, parking, building insurance, and maintenance, helping to simplify ownership. A fantastic opportunity to own in one of Waterloo's most desirable and consistently in demand neighbourhoods. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
]
+"AssociationFee": "544"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:58:21.424816+00:00"
+"Directions": "Hickory St/Larch St"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235642"
+"ListOfficeKey": "285286"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:57:18Z"
+"PhotosCount": 23
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:18Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2800"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1662429009"
"RoomType" => "Bathroom"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 1.68
"ListingKey" => "29923313"
"RoomLength" => 1.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.45Z"
]
1 => array:11 [
"RoomKey" => "1662429010"
"RoomType" => "Bathroom"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.13
"ListingKey" => "29923313"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
2 => array:11 [
"RoomKey" => "1662429011"
"RoomType" => "Den"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29923313"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
3 => array:11 [
"RoomKey" => "1662429012"
"RoomType" => "Dining room"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29923313"
"RoomLength" => 2.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
4 => array:11 [
"RoomKey" => "1662429013"
"RoomType" => "Kitchen"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "29923313"
"RoomLength" => 5.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
5 => array:11 [
"RoomKey" => "1662429014"
"RoomType" => "Living room"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29923313"
"RoomLength" => 5.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
6 => array:11 [
"RoomKey" => "1662429015"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13462260"
"RoomLevel" => "Main level"
"RoomWidth" => 5.21
"ListingKey" => "29923313"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:18.46Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923313/g105-275-larch-street-waterloo"
+"ParkingTotal": 1
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T17:57:18.14Z"
+"ListAgentNationalAssociationId": "1473542"
+"ListOfficeNationalAssociationId": "1349912"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29923313_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/941dce5510bca7d948127878ccc3ad9d.webp"
"MediaSize" => 243110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-941dce5510bca7d948127878ccc3ad9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29923313_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/e1230b2e0f29056c851f6be537970331.webp"
"MediaSize" => 243815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-e1230b2e0f29056c851f6be537970331.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29923313_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/fedf37164b6760f57dc9ee010a714c74.webp"
"MediaSize" => 139057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-fedf37164b6760f57dc9ee010a714c74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29923313_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/ba2574a4447a17f1970f3f6bf1561fae.webp"
"MediaSize" => 209465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-ba2574a4447a17f1970f3f6bf1561fae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29923313_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/205cdcb7aa50b228b9bea767993cb223.webp"
"MediaSize" => 180657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-205cdcb7aa50b228b9bea767993cb223.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29923313_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/0f5a250f8d367fa2cdf8fe3da0649840.webp"
"MediaSize" => 182162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-0f5a250f8d367fa2cdf8fe3da0649840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29923313_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/46e9788421f242cc02d1d9d61720784c.webp"
"MediaSize" => 130139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-46e9788421f242cc02d1d9d61720784c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29923313_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/5492b45fe4880e8d96703103a17b5ca6.webp"
"MediaSize" => 196625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-5492b45fe4880e8d96703103a17b5ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Digital Staging"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29923313_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/052907e60d0a00b517ad3b8f4a42219e.webp"
"MediaSize" => 156582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-052907e60d0a00b517ad3b8f4a42219e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29923313_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/2392d5b5aa33389fe604be4628060eab.webp"
"MediaSize" => 129624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-2392d5b5aa33389fe604be4628060eab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29923313_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/7726b9f1d77d103087daa6fe21d2dd8d.webp"
"MediaSize" => 179865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-7726b9f1d77d103087daa6fe21d2dd8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Digital Staging"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29923313_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/66efd29f6b23afdb2f2250471aae350e.webp"
"MediaSize" => 133711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-66efd29f6b23afdb2f2250471aae350e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29923313_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/4c2bf0c9c2fec2cfef619e3c76a20349.webp"
"MediaSize" => 111842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-4c2bf0c9c2fec2cfef619e3c76a20349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29923313_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/784930f56c67ec23c3020f7984118d76.webp"
"MediaSize" => 113043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-784930f56c67ec23c3020f7984118d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29923313_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/189d54b34f20f020ae1e49c0fa9a0a0b.webp"
"MediaSize" => 197743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-189d54b34f20f020ae1e49c0fa9a0a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Digital Staging"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29923313_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/c467f1de36bcef4bba9397f18f113d55.webp"
"MediaSize" => 165194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-c467f1de36bcef4bba9397f18f113d55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29923313_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/9fbeec3696b7d2e7c1f00b66a94ca76a.webp"
"MediaSize" => 130122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-9fbeec3696b7d2e7c1f00b66a94ca76a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29923313_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/8cb2d07af73164b80d69d5f914f35fd1.webp"
"MediaSize" => 115344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-8cb2d07af73164b80d69d5f914f35fd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29923313_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/c04b518dc4a4f9ab4980ce3a6f118b4e.webp"
"MediaSize" => 118370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-c04b518dc4a4f9ab4980ce3a6f118b4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29923313_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/52b6877b2d0229668603a859be2cae4b.webp"
"MediaSize" => 187532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-52b6877b2d0229668603a859be2cae4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29923313_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/3d1eb4195bfb3c59bc3aec9b98c32ae0.webp"
"MediaSize" => 172794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-3d1eb4195bfb3c59bc3aec9b98c32ae0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29923313_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/ca016c62d3c89908e96f8113fd65eeac.webp"
"MediaSize" => 156370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-ca016c62d3c89908e96f8113fd65eeac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29923313_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29923313/2bbeeebb0efd75fff3825eefae7505c0.webp"
"MediaSize" => 101182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29923313/thumbnail-2bbeeebb0efd75fff3825eefae7505c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13462260"
"ResourceRecordKey" => "29923313"
"ModificationTimestamp" => "2026-06-18T17:57:18.15Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923313')"
+"ID": "1543976"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285286" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24827
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235642" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24800
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29923313'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25122
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29923313'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25138
+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 '29923313' 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 {#25191
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1545599"
+post_author: 1
+"ListingKey": "29924889"
+"ListingId": "40841106"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:00:18Z"
+"RFModificationTimestamp": "2026-06-18T23:10:44Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2024.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K4"
+"UnparsedAddress": "154 BRIDGEPORT Road E, Waterloo, Ontario N2J2K4"
+"Coordinates": array:2 [
0 => -80.5087041
1 => 43.4716521
]
+"Latitude": 43.4716521
+"Longitude": -80.5087041
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A 50 x 150 ft lot two blocks from Uptown Waterloo — and the market hasn't priced it as it should. This updated all-brick 2-bed, 2.5-bath home with a private 3-season sunroom puts you within walking distance of every major festival, patio, and coffee shop in the city — with updated windows (2018) that make it completely whisper-quiet the moment you close the door. To get this lot size and these finishings, two blocks deeper into the Uptown core would cost you $50–70K more. You're trading a bit of front-facing visibility for immense equity and a lifestyle where your car stays in the driveway all weekend. Mornings: Walk to Midnight Run Cafe or Poppy's Bagels, then through Waterloo Park. Evenings: Minutes from the best patios on King Street, craft breweries, and cultural draws like the Waterloo Jazz Festival, Cruising King, and Ribfest & Craft Beer Show. Saturdays: 7 minutes north to the world-famous St. Jacobs Farmers' Market, then along the Walter Bean Grand River Trail. Walk, cycle, drive, or hop on transit — this home covers every mode. A GRT bus stop is steps from your front door with a direct connection to the ION rapid transit line. Quick drive to U of W & Laurier, Highway 85, and the 401. Inside: quartz kitchen with tile backsplash, living room with office nook, 2pc main floor bath, sunroom walkout to backyard, 2 large bedrooms with walk-in closets, 4pc upper bath, and a bright finished basement with a stunning 4pc bath and glass shower. The detached garage is a blank canvas — creative studio, workshop, or home gym. If you live here, you walk to everything that matters. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T23:10:39.011285+00:00"
+"Directions": "From Weber Street N, head east onto Bridgeport Road E and continue to 154 Bridgeport Road E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056335"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T20:51:06Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:51:06Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "154"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4110.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/154BridgeportRdEWaterloo"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1662422023"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841106"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.43Z"
]
1 => array:11 [
"RoomKey" => "1662422024"
"RoomType" => "Recreation room"
"ListingId" => "40841106"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 21'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.43Z"
]
2 => array:11 [
"RoomKey" => "1662422025"
"RoomType" => "Laundry room"
"ListingId" => "40841106"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.44Z"
]
3 => array:11 [
"RoomKey" => "1662422026"
"RoomType" => "Storage"
"ListingId" => "40841106"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "2'3'' x 2'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.44Z"
]
4 => array:11 [
"RoomKey" => "1662422027"
"RoomType" => "Storage"
"ListingId" => "40841106"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "2'10'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.44Z"
]
5 => array:11 [
"RoomKey" => "1662422028"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841106"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.45Z"
]
6 => array:11 [
"RoomKey" => "1662422029"
"RoomType" => "Bedroom"
"ListingId" => "40841106"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.45Z"
]
7 => array:11 [
"RoomKey" => "1662422030"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841106"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.46Z"
]
8 => array:11 [
"RoomKey" => "1662422031"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841106"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 3'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.46Z"
]
9 => array:11 [
"RoomKey" => "1662422032"
"RoomType" => "Sunroom"
"ListingId" => "40841106"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.46Z"
]
10 => array:11 [
"RoomKey" => "1662422033"
"RoomType" => "Kitchen"
"ListingId" => "40841106"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.46Z"
]
11 => array:11 [
"RoomKey" => "1662422034"
"RoomType" => "Dining room"
"ListingId" => "40841106"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.47Z"
]
12 => array:11 [
"RoomKey" => "1662422035"
"RoomType" => "Living room"
"ListingId" => "40841106"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924889"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 22'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:51:06.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924889/154-bridgeport-road-e-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1894210"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1375
+"BelowGradeFinishedArea": 649
+"OriginalEntryTimestamp": "2026-06-18T20:51:06.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1331680"
+"ListOfficeNationalAssociationId": "1349002"
+"CoListAgentNationalAssociationId": "1213379"
+"CoListOfficeNationalAssociationId": "1112493"
+"Media": array:46 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924889_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/09e1fbd556fd33f0f3b77058cc43ec51.webp"
"MediaSize" => 74811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-09e1fbd556fd33f0f3b77058cc43ec51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924889_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/294839bd57d2a18abdc9118c625110e0.webp"
"MediaSize" => 81368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-294839bd57d2a18abdc9118c625110e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924889_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/d6d934739a292c9478e0c03559bcb0b2.webp"
"MediaSize" => 134381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-d6d934739a292c9478e0c03559bcb0b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924889_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/9c38c297845229257a3f9050633bbc3a.webp"
"MediaSize" => 168122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-9c38c297845229257a3f9050633bbc3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924889_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/b788d6ae53924d7611803542b8e8d996.webp"
"MediaSize" => 167644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-b788d6ae53924d7611803542b8e8d996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924889_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/108c65251fc3c95842a6f2b89faa5ce7.webp"
"MediaSize" => 77133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-108c65251fc3c95842a6f2b89faa5ce7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924889_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/d7a0dff256c00bf37ce972d7ee2ade42.webp"
"MediaSize" => 86476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-d7a0dff256c00bf37ce972d7ee2ade42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924889_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/ca34efc64470868ad7e129d1949f2495.webp"
"MediaSize" => 61909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-ca34efc64470868ad7e129d1949f2495.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924889_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/5922b4c459152facceddf6897caa4b88.webp"
"MediaSize" => 79717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-5922b4c459152facceddf6897caa4b88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924889_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/c9da70cbf0027b5c8ea87d6cdc590628.webp"
"MediaSize" => 74811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-c9da70cbf0027b5c8ea87d6cdc590628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924889_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/ad76c2448622a3e4fc3fb4c4dc147b4b.webp"
"MediaSize" => 70104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-ad76c2448622a3e4fc3fb4c4dc147b4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924889_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/c9a13ae4a5c68ed24571926e6f904a33.webp"
"MediaSize" => 81368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-c9a13ae4a5c68ed24571926e6f904a33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924889_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/2c62fefb04753c8d210f610dc31f75c1.webp"
"MediaSize" => 88552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-2c62fefb04753c8d210f610dc31f75c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924889_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/a040d57b991d4b3ff177df015cc92078.webp"
"MediaSize" => 85378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-a040d57b991d4b3ff177df015cc92078.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924889_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/485f41ab1c0be01ee07ba41d09202881.webp"
"MediaSize" => 77034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-485f41ab1c0be01ee07ba41d09202881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924889_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/f870f96812a8e32b0c811525545f984f.webp"
"MediaSize" => 134381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-f870f96812a8e32b0c811525545f984f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924889_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/3841a207c57bad66608aced42ec5ac02.webp"
"MediaSize" => 108473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-3841a207c57bad66608aced42ec5ac02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924889_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/37ca557ad3d1921c8b393525fbd5af38.webp"
"MediaSize" => 51022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-37ca557ad3d1921c8b393525fbd5af38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924889_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/61df8f0f34e2969e19698344ed0006a5.webp"
"MediaSize" => 76008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-61df8f0f34e2969e19698344ed0006a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924889_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/c56abc0329eff4fe1b178a25a06b61d7.webp"
"MediaSize" => 76171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-c56abc0329eff4fe1b178a25a06b61d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924889_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/65f5dc02bfb6d04d8da896724b4af226.webp"
"MediaSize" => 67065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-65f5dc02bfb6d04d8da896724b4af226.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924889_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/2fcf31368b30d310e1ab57d77fc58eb7.webp"
"MediaSize" => 63528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-2fcf31368b30d310e1ab57d77fc58eb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29924889_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/727022cfac21d28b9dd687156a9205e3.webp"
"MediaSize" => 66572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-727022cfac21d28b9dd687156a9205e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29924889_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/728566d2e6109b85c46d75fa9d2cf5d5.webp"
"MediaSize" => 64922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-728566d2e6109b85c46d75fa9d2cf5d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29924889_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/1de8a30745f287ac7fd7c76ce9bff754.webp"
"MediaSize" => 79186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-1de8a30745f287ac7fd7c76ce9bff754.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29924889_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/c9de08ef7004a922e1d313a83fe7c6cc.webp"
"MediaSize" => 71238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-c9de08ef7004a922e1d313a83fe7c6cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29924889_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/a527c5392b6573db58d47b38b18cba98.webp"
"MediaSize" => 71169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-a527c5392b6573db58d47b38b18cba98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29924889_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/9dfcf5b6d725b01277f706959a8cfec6.webp"
"MediaSize" => 58143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-9dfcf5b6d725b01277f706959a8cfec6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29924889_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/1e7b17333020ad5bd38e5d39dfd249df.webp"
"MediaSize" => 62913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-1e7b17333020ad5bd38e5d39dfd249df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29924889_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/978d6c31f69a116dbc9a2137ba5e69f7.webp"
"MediaSize" => 70914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-978d6c31f69a116dbc9a2137ba5e69f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29924889_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/b92cabb147bef110d8864ecd6d2078b8.webp"
"MediaSize" => 187581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-b92cabb147bef110d8864ecd6d2078b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29924889_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/2f7032e57bb1de94a0fc04ecbcd45d0f.webp"
"MediaSize" => 193360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-2f7032e57bb1de94a0fc04ecbcd45d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29924889_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/4de37c7ba608a44b76a2ead3c42d949c.webp"
"MediaSize" => 223265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-4de37c7ba608a44b76a2ead3c42d949c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29924889_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/d4aa43e9f0e5474837effcb67e9059b0.webp"
"MediaSize" => 209789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-d4aa43e9f0e5474837effcb67e9059b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29924889_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/8e01f7a441bdb0684e05fea6f6dfb75a.webp"
"MediaSize" => 216052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-8e01f7a441bdb0684e05fea6f6dfb75a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29924889_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/f822f0cfe2bbd7e0278d8ddcdc42a6b0.webp"
"MediaSize" => 216935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-f822f0cfe2bbd7e0278d8ddcdc42a6b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29924889_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/2a3e01752cefa42eb2efcd9288f34287.webp"
"MediaSize" => 216324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-2a3e01752cefa42eb2efcd9288f34287.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29924889_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/5b12d15ec3133615fea870da1c928c0e.webp"
"MediaSize" => 157855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-5b12d15ec3133615fea870da1c928c0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29924889_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/ce5c39a5ef86989d66c89e714de16bfd.webp"
"MediaSize" => 187644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-ce5c39a5ef86989d66c89e714de16bfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29924889_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924889/3762825805ed7c44464c0e5f1e2cf321.webp"
"MediaSize" => 185156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924889/thumbnail-3762825805ed7c44464c0e5f1e2cf321.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841106"
"ResourceRecordKey" => "29924889"
"ModificationTimestamp" => "2026-06-18T20:51:06.24Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29924889_4890_41"
…11
]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924889')"
+"ID": "1545599"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1545600"
+post_author: 1
+"ListingKey": "29925506"
+"ListingId": "X13464128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:48:31Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K4"
+"UnparsedAddress": "154 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2K4"
+"Coordinates": array:2 [
0 => -80.5087037
1 => 43.471648
]
+"Latitude": 43.471648
+"Longitude": -80.5087037
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A 50 x 150 ft lot two blocks from Uptown Waterloo - and the market hasn't priced it as it should. This updated all-brick 2-bed, 2.5-bath home with a private 3-season sunroom puts you within walking distance of every major festival, patio, and coffee shop in the city - with updated windows (2018) that make it completely whisper-quiet the moment you close the door. To get this lot size and these finishings, two blocks deeper into the Uptown core would cost you $50-70K more. You're trading a bit of front-facing visibility for immense equity and a lifestyle where your car stays in the driveway all weekend. Mornings: Walk to Midnight Run Cafe or Poppy's Bagels, then through Waterloo Park. Evenings: Minutes from the best patios on King Street, craft breweries, and cultural draws like the Waterloo Jazz Festival, Cruising King, and Ribfest & Craft Beer Show. Saturdays: 7 minutes north to the world-famous St. Jacobs Farmers' Market, then along the Walter Bean Grand River Trail. Walk, cycle, drive, or hop on transit - this home covers every mode. A GRT bus stop is steps from your front door with a direct connection to the ION rapid transit line. Quick drive to U of W & Laurier, Highway 85, and the 401. Inside: quartz kitchen with tile backsplash, living room with office nook, 2pc main floor bath, sunroom walkout to backyard, 2 large bedrooms with walk-in closets, 4pc upper bath, and a bright finished basement with a stunning 4pc bath and glass shower. The detached garage is a blank canvas - creative studio, workshop, or home gym. If you live here, you walk to everything that matters. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:48:21.437587+00:00"
+"Directions": "Cross Streets: Ellis Crescent N and Bridgeport Road E. ** Directions: From Weber Street N, head east onto Bridgeport Road E and continue to 154 Bridgeport Road E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056387"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50.1 x 151.4 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:13Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:13Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "154"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4110.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/154BridgeportRdEWaterloo/"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925506/154-bridgeport-road-e-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-06-18T21:59:13.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1331642"
+"ListOfficeNationalAssociationId": "1336772"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925506')"
+"ID": "1545600"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1544216"
+post_author: 1
+"ListingKey": "29923621"
+"ListingId": "X13462684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:40:16Z"
+"RFModificationTimestamp": "2026-06-18T20:53:32Z"
+"ListPrice": 389900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "505 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.5358387
1 => 43.4756874
]
+"Latitude": 43.4756874
+"Longitude": -80.5358387
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Vacant, ONE BEDROOM + DEN condo featuring an oversized BALCONY and ONE UNDERGROUND PARKING SPACE! Welcome to the contemporary Sage V Condos, ideally located just steps from both the University of Waterloo and Wilfrid Laurier University, with restaurants, shopping, transit, and everyday amenities right at your doorstep. This beautifully maintained suite offers a spacious open-concept layout designed for comfortable living and entertaining. The modern kitchen features granite countertops, stainless steel appliances, a large island, and plenty of storage space. The bright living area opens onto an oversized private balcony overlooking Hickory Street, offering impressive views of Waterloo. The generous primary bedroom includes ample closet space and its own sliding door with direct balcony access. A separate den provides the perfect space for a home office, study area, or overnight guests, while the updated four-piece bathroom is conveniently located nearby. In-suite laundry adds to the everyday convenience. Included with the unit are the stylish furnishings shown, making this a true turnkey opportunity. Residents enjoy access to excellent building amenities, including a two-storey study lounge, fitness centre, and outdoor terrace. The condo fees even include internet service, water and gas, for added value. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "439.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:29:38.119565+00:00"
+"Directions": "Cross Streets: University Ave. ** Directions: University Ave to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213582"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:10Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:33:19Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3494.71"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LNHnwTjDP5n&mls=1"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923621/505-280-lester-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "RN-8"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T18:33:10.72Z"
+"ListAgentNationalAssociationId": "1459405"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923621')"
+"ID": "1544216"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1543975"
+post_author: 1
+"ListingKey": "29923250"
+"ListingId": "40840457"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:04:46Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 860.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "275 LARCH Street Unit# G105, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.5322577
1 => 43.4767325
]
+"Latitude": 43.4767325
+"Longitude": -80.5322577
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit G105 at 275 Larch Street, a fully furnished 1 bedroom + spacious enclosed den, 2 bathroom condo in the heart of Waterloo's highly sought after University District. Offering 860 sq. ft. of bright, modern living space, this turnkey unit features soaring ceilings, oversized windows, quartz countertops, stainless steel appliances, in suite laundry, and durable flooring throughout. The spacious enclosed den provides exceptional flexibility for a home office, study area, guest space, or additional living area. Thoughtfully furnished with two beds, a sofa, TV, dining set, and storage pieces, this move in ready condo is ideal for first time buyers, parents looking to invest for their student, or investors seeking a low maintenance property in a prime rental location. Building amenities include a fitness centre, yoga studio, rooftop terrace, secure bike storage, and visitor parking. Located just steps from Wilfrid Laurier University, the University of Waterloo, Conestoga College, the ION LRT, restaurants, shopping, and everyday amenities, this property offers unbeatable convenience and long term appeal. Condo fees include water, heat, parking, building insurance, and maintenance, helping to simplify ownership. A fantastic opportunity to own in one of Waterloo's most desirable and consistently in demand neighbourhoods. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "544"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Other, See Remarks"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:04:35.895972+00:00"
+"Directions": "Hickory St/Larch St"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240062"
+"ListOfficeKey": "280721"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-18T17:50:38Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:37Z"
+"Stories": "8.0"
+"StreetName": "LARCH"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2800"
+"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/29923250/275-larch-street-unit-g105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1941951"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292877"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "NMU6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 860
+"OriginalEntryTimestamp": "2026-06-18T17:50:37.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1477987"
+"ListOfficeNationalAssociationId": "1316887"
+"CoListAgentNationalAssociationId": "1238606"
+"CoListOfficeNationalAssociationId": "1418791"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923250')"
+"ID": "1543975"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1544217"
+post_author: 1
+"ListingKey": "29923026"
+"ListingId": "40840144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:00:17Z"
+"RFModificationTimestamp": "2026-06-18T19:15:56Z"
+"ListPrice": 389900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 578.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "280 LESTER Street Unit# 505, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.5357622
1 => 43.4756732
]
+"Latitude": 43.4756732
+"Longitude": -80.5357622
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Vacant, ONE BEDROOM + DEN condo featuring an oversized BALCONY and ONE UNDERGROUND PARKING SPACE! Welcome to the contemporary Sage V Condos, ideally located just steps from both the University of Waterloo and Wilfrid Laurier University, with restaurants, shopping, transit, and everyday amenities right at your doorstep. This beautifully maintained suite offers a spacious open-concept layout designed for comfortable living and entertaining. The modern kitchen features granite countertops, stainless steel appliances, a large island, and plenty of storage space. The bright living area opens onto an oversized private balcony overlooking Hickory Street, offering impressive views of Waterloo. The generous primary bedroom includes ample closet space and its own sliding door with direct balcony access. A separate den provides the perfect space for a home office, study area, or overnight guests, while the updated four-piece bathroom is conveniently located nearby. In-suite laundry adds to the everyday convenience. Included with the unit are the stylish furnishings shown, making this a true turnkey opportunity. Residents enjoy access to excellent building amenities, including a two-storey study lounge, fitness centre, and outdoor terrace. The condo fees even include internet service, water and gas, for added value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "439.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:19:55.336781+00:00"
+"Directions": "University Avenue to Lester Street"
+"ExteriorFeatures": array:2 [
0 => "Other"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-18T17:32:56Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:52:38Z"
+"Stories": "1.0"
+"StreetName": "LESTER"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3494.71"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LNHnwTjDP5n"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923026/280-lester-street-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2082150"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "296447"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RN-8"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 578
+"OriginalEntryTimestamp": "2026-06-18T17:32:55.97Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"CoListAgentNationalAssociationId": "1356952"
+"CoListOfficeNationalAssociationId": "1458684"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923026')"
+"ID": "1544217"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: "1541125"
+post_author: 1
+"ListingKey": "29919010"
+"ListingId": "X13458736"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:55:06Z"
+"RFModificationTimestamp": "2026-06-18T15:05:50Z"
+"ListPrice": 538888.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "901 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Highly Sought After Investment Opportunity. Located In Waterloo's Ideal And Luxurious Residential Pocket. Walking Distance To University Of Waterloo & Wilfred Laurier University. Public Transportation At Your Finger Tips. This Functional Suites Boosts Approx 1400sqft, Featuring 3 Full Size Bedrooms With Full Closet & Windows. 1 With Ensuite & Walk In Closet, 2 Full Bathrooms, In-suite Laundry, Open Concept Kitchen And Large Dining Island, Separate Living Space With Balcony Walk Out Access. Full Size Kitchen Appliances, Laminate Flooring Throughout, Soaring 9ft Ceilings, South And East Facing Views, In-suite Thermostat, HVAC & Water Tank, Ample Amount Of Storage And Closet Space. Ideal For Contemporary Student Living, Well-Maintained Building With Amenities And Features Including But Not Limited To; Gym, Secure Bike Storage, & Meeting Room / Common Lounge Space Equipped With High Speed Internet. Safe And. Secured Fob Entry With Buzzer, Condo Is Equipped With CCTV To Offer Parents Of Residents A Peace Of Mind. Currently Tenanted With 3 Great Laurier Students On First Year Lease Agreement And Moving Out End Of August 2026. (id:62783)"
+"Appliances": array:1 [
0 => "Furniture"
]
+"AssociationFee": "673.24"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:39:39.661326+00:00"
+"Directions": "Cross Streets: University / King. ** Directions: As Per Google."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2037204"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T14:48:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:48:53Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5864"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919010/901-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T21:55:09.9Z"
+"ListAgentNationalAssociationId": "1313612"
+"ListOfficeNationalAssociationId": "1132867"
+"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('29919010')"
+"ID": "1541125"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1540111"
+post_author: 1
+"ListingKey": "29917252"
+"ListingId": "X13457062"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:30:07Z"
+"RFModificationTimestamp": "2026-06-17T19:44:07Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3M3"
+"UnparsedAddress": "221 WILLOWDALE AVENUE, Waterloo, Ontario N2J3M3"
+"Coordinates": array:2 [
0 => -80.512148
1 => 43.47866
]
+"Latitude": 43.47866
+"Longitude": -80.512148
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Same owner for close to 60 years, this well-loved home is ready for its next chapter. Offering 3 bedroom and 1 bath, its sits on a large lot and features oversized drive-thru garage. Conveniently located close to schools, universities, shopping and the expressway, this property is a great opportunity to make it your own. (id:62783)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:44:04.198916+00:00"
+"Directions": "Cross Streets: Carter and Willowdale. ** Directions: University to Carter to Willowdale."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138809"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65 x 110 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T18:21:36Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:21:36Z"
+"Stories": "1.0"
+"StreetName": "Willowdale"
+"StreetNumber": "221"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4507"
+"VirtualTourURLUnbranded": "https://youriguide.com/221_willowdale_ave_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917252/221-willowdale-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 65.0
+"OriginalEntryTimestamp": "2026-06-17T18:21:36.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390648"
+"ListOfficeNationalAssociationId": "1369645"
+"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('29917252')"
+"ID": "1540111"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1539914"
+post_author: 1
+"ListingKey": "29917046"
+"ListingId": "40840083"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:10:06Z"
+"RFModificationTimestamp": "2026-06-17T18:54:12Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1009, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526452
1 => 43.4787911
]
+"Latitude": 43.4787911
+"Longitude": -80.526452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Low condo fee!!! This stylish and convenient condo is in excellent condition, featuring a 1-bedroom layout with 1 bathrooms. The unit is carpetfree, offering a modern and clean living space. It boasts a spacious 9 ft ceiling that creates an open and airy atmosphere. The balcony seamlessly connects the living room, providing easy access to fresh air and outdoor relaxation. The built-in laundry room adds to the convenience, making everyday living effortless. The condo is ideally located with shopping plazas and restaurants just steps away, ensuring you have everything you need at your fingertips. It is adjacent to the prestigious Waterloo Collegiate Institute (WCI) and offers close proximity to Laurier University, the University of Waterloo, and Conestoga College (Waterloo Campus), making it an excellent choice for families, professionals, or students. Don't miss the opportunity to own this bright and functional condo that perfectly balances comfort, style, and location. Contact us today for more details or to schedule a viewing! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "337.21"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T18:54:02.414253+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T18:01:29Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:01:29Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3220"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917046/318-spruce-street-unit-1009-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Guest Suite"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-06-17T18:01:29.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:14 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917046')"
+"ID": "1539914"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1539270"
+post_author: 1
+"ListingKey": "29914698"
+"ListingId": "40838131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:40:09Z"
+"RFModificationTimestamp": "2026-06-17T17:16:57Z"
+"ListPrice": 489888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1807, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5174295
1 => 43.4655213
]
+"Latitude": 43.4655213
+"Longitude": -80.5174295
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo’s most sought-after condo developments, offering BREATHTAKING VIEWS of the city skyline and a remarkable array of amenities designed to enhance your lifestyle. As you step into the building, you’re greeted by a warm, INVITING LOBBY. This stunning 2-bedroom, 1-bathroom features an impressive 1,100 sq. ft. of living space with southern exposure. The spacious living and dining areas offer new vinyl flooring and are anchored by the renovated kitchen that boasts ample cabinetry, quartz countertops, a stylish backsplash, and stainless appliances with built-in oven, making it a true chef’s delight. Sliders open to your PRIVATE BALCONY, where you can take in exceptional views of the Waterloo landscape. The primary bedroom is located at one end of the unit with a FULLY RENOVATED 4-PIECE main bathroom complete with a glass-enclosed walk-in shower, & quartz vanity. The 2nd bedroom provides additional space & comfort along with a convenient in-suite laundry. This unit includes 1 UNDERGROUND PARKING SPACE, and Waterpark Place offers an outstanding range of amenities designed for every lifestyle. Stay active with the ON-SITE GYM, enjoy leisurely games in the billiards room, relax by the POOL OR SAUNA, or host gatherings in the party room, which opens to an outdoor patio with a BBQ area. For quiet moments, the library area provides a peaceful retreat. Located in the heart of Uptown Waterloo, Waterpark Place sits on nearly 4 acres of beautifully landscaped grounds, making it a Walker’s and Biker’s Paradise. Enjoy easy access to local boutiques, a variety of dining options, Waterloo Park, and the nearby universities. With convenient access to the LRT and local highways, this location truly offers the best of urban living. Don’t miss the opportunity to own this corner unit in Waterpark Place and experience luxurious living in one of Waterloo’s most vibrant communities. Interior photos have been virtually staged inside unit. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"AssociationFee": "737"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:16:51.087563+00:00"
+"Directions": "Willow Street / Erb Street"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T13:31:33Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:31:33Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4153.56"
+"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/29914698/6-willow-street-unit-1807-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": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-06-17T13:31:32.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914698')"
+"ID": "1539270"
}
]
+success: true
+page_size: 9
+page_count: 43
+count: 383
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]