array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29928222 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1547671"
+post_author: 1
+"ListingKey": "29928222"
+"ListingId": "X13466612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:50:02Z"
+"RFModificationTimestamp": "2026-06-19T16:48:11Z"
+"ListPrice": 410000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "806 - 181 KING STREET S, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.520205
1 => 43.460368
]
+"Latitude": 43.460368
+"Longitude": -80.520205
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the prestigious Circa 1877 residences in Uptown Waterloo, this spacious suite offers an exceptional opportunity in one of Canada's fastest-growing tech and education hubs. Featuring over 700 sq. ft. of interior living space plus a rare 183 sq. ft. private balcony, the unit offers a highly desirable layout with bright open-concept living and floor-to-ceiling windows.The generous balcony provides valuable outdoor space rarely found in condominium living, while the modern kitchen and living area create an ideal setup for comfortable living or strong rental appeal.Circa 1877 is known for its premium lifestyle amenities including a rooftop saltwater pool with cabanas, fitness centre, indoor and outdoor yoga studios, co-working spaces, guest suites, and an impressive sky terrace with fire tables and BBQ areas.Situated steps from the ION Light Rail and surrounded by Uptown Waterloo's restaurants, cafes, and shops, the building is also minutes from University of Waterloo and Wilfrid Laurier University. With major employers such as Google located nearby in Waterloo's thriving technology corridor, the area continues to attract strong rental demand from professionals and students alike, or great for professional end users. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "610.08"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:48:04.043305+00:00"
+"Directions": "King and Allen"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915573"
+"ListOfficeKey": "269704"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:33:18Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:33:18Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3868.8"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663019083"
"RoomType" => "Kitchen"
"ListingId" => "X13466612"
"RoomLevel" => "Main level"
"RoomWidth" => 5.33
"ListingKey" => "29928222"
"RoomLength" => 5.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:33:18.13Z"
]
1 => array:11 [
"RoomKey" => "1663019084"
"RoomType" => "Dining room"
"ListingId" => "X13466612"
"RoomLevel" => "Main level"
"RoomWidth" => 5.33
"ListingKey" => "29928222"
"RoomLength" => 5.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:33:18.13Z"
]
2 => array:11 [
"RoomKey" => "1663019085"
"RoomType" => "Living room"
"ListingId" => "X13466612"
"RoomLevel" => "Main level"
"RoomWidth" => 5.33
"ListingKey" => "29928222"
"RoomLength" => 5.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:33:18.13Z"
]
3 => array:11 [
"RoomKey" => "1663019086"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13466612"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29928222"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:33:18.13Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928222/806-181-king-street-s-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T15:33:18.1Z"
+"ListAgentNationalAssociationId": "1224527"
+"ListOfficeNationalAssociationId": "1233633"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29928222_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/db2fd7df45d816e0d99e8678107cc769.webp"
"MediaSize" => 228648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-db2fd7df45d816e0d99e8678107cc769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928222_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/1b18110ef3a07f04e374291b6850df6e.webp"
"MediaSize" => 238690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-1b18110ef3a07f04e374291b6850df6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928222_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/d4e2677cf7f5b663db0ababf2edb7b5a.webp"
"MediaSize" => 247193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-d4e2677cf7f5b663db0ababf2edb7b5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928222_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/c848df5dbbef06ae4c0282b8fffb3b81.webp"
"MediaSize" => 216056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-c848df5dbbef06ae4c0282b8fffb3b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928222_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/7a5b0c769d8f0a76a313560ba376b977.webp"
"MediaSize" => 114713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-7a5b0c769d8f0a76a313560ba376b977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928222_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/e116f1e308241074e153b90256ba8ef6.webp"
"MediaSize" => 190500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-e116f1e308241074e153b90256ba8ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928222_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/815e67ebba3a6d1a3938bf7df5e3baec.webp"
"MediaSize" => 163924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-815e67ebba3a6d1a3938bf7df5e3baec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928222_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/ddfee81426c7ac416cb6dd0952c1d6a5.webp"
"MediaSize" => 172636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-ddfee81426c7ac416cb6dd0952c1d6a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928222_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/1b204b020610038790db3e82f1184079.webp"
"MediaSize" => 203966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-1b204b020610038790db3e82f1184079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928222_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/9376981093edafbc29eb6ef15be14dd1.webp"
"MediaSize" => 223291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-9376981093edafbc29eb6ef15be14dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928222_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/497de9fcc4413e1d8e214780fa091838.webp"
"MediaSize" => 212934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-497de9fcc4413e1d8e214780fa091838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928222_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/8adb2dba5f91f034b9513b8828c80867.webp"
"MediaSize" => 231411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-8adb2dba5f91f034b9513b8828c80867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928222_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/a871b6784fc340d3ce5926bd9a30da5c.webp"
"MediaSize" => 117040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-a871b6784fc340d3ce5926bd9a30da5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928222_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/91140211221ed635c077a6369c1d4846.webp"
"MediaSize" => 173094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-91140211221ed635c077a6369c1d4846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928222_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/81e9c982760b6f257afa3fedc1f276c2.webp"
"MediaSize" => 160500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-81e9c982760b6f257afa3fedc1f276c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928222_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/ce5564c5a502c089ec329e9b2838db7b.webp"
"MediaSize" => 167727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-ce5564c5a502c089ec329e9b2838db7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928222_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/5e501c65af982de4cc405b6b32e54382.webp"
"MediaSize" => 256012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-5e501c65af982de4cc405b6b32e54382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928222_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/48514628847419211f163ec1cf34bb73.webp"
"MediaSize" => 330481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-48514628847419211f163ec1cf34bb73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928222_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/def313690adf5611bc1a9cd20a7673ab.webp"
"MediaSize" => 315860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-def313690adf5611bc1a9cd20a7673ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29928222_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/74076f440878ac462986f16ea5c1a220.webp"
"MediaSize" => 243319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-74076f440878ac462986f16ea5c1a220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29928222_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/13ba74bf967f43601290d91dba0ee0f5.webp"
"MediaSize" => 177770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-13ba74bf967f43601290d91dba0ee0f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29928222_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/217fef3e0fd5a241364433d3249bbc09.webp"
"MediaSize" => 224456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-217fef3e0fd5a241364433d3249bbc09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29928222_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/b77229defd1158ee1697ab60ae80e9c6.webp"
"MediaSize" => 273283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-b77229defd1158ee1697ab60ae80e9c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29928222_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/9be1252505fcced64548bb96458174f6.webp"
"MediaSize" => 239769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-9be1252505fcced64548bb96458174f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29928222_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/285eb7dc3d8c6306e8cd4e59845078e7.webp"
"MediaSize" => 216459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-285eb7dc3d8c6306e8cd4e59845078e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29928222_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/93e6405aa96789c947639134d181c6c9.webp"
"MediaSize" => 286875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-93e6405aa96789c947639134d181c6c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29928222_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/81e10d70d42cba29cf0d9fb54523cf15.webp"
"MediaSize" => 147188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-81e10d70d42cba29cf0d9fb54523cf15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29928222_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/e6201605785ead68de637e2f3a9810ec.webp"
"MediaSize" => 352844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-e6201605785ead68de637e2f3a9810ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29928222_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/2bd96299638dfbe085e0bf2e7a2c6840.webp"
"MediaSize" => 481287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-2bd96299638dfbe085e0bf2e7a2c6840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29928222_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928222/5b805020fea0472823a23709b014cc77.webp"
"MediaSize" => 427886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928222/thumbnail-5b805020fea0472823a23709b014cc77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466612"
"ResourceRecordKey" => "29928222"
"ModificationTimestamp" => "2026-06-19T15:33:18.11Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928222')"
+"ID": "1547671"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269704" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24886
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1915573" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24859
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29928222'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25188
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29928222'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25204
+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 '29928222' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.520205 43.460368)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
+post_id: "1550984"
+post_author: 1
+"ListingKey": "29932529"
+"ListingId": "X13470358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T03:55:21Z"
+"RFModificationTimestamp": "2026-06-20T04:33:11Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "304 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Motivated Seller! Welcome to 158 King Street North, ideally situated in the heart of uptownWaterloo-one of the most vibrant and rapidly growing areas in the region. This prime locationoffers unmatched convenience, with immediate access to everything you need for comfortableurban living.This spacious three-bedroom corner unit is designed to impress, featuring an abundance ofnatural light thanks to its oversized windows and desirable layout. The open-concept livingand dining area is enhanced by soaring 9-foot ceilings, creating a bright and airy atmosphereperfect for both relaxing and entertaining.The modern kitchen is equipped with custom cabinetry and sleek stainless steel appliances,combining style and functionality for everyday living. The unit also includes ensuite laundryfor added convenience, generously sized bedrooms that provide comfort and privacy, and twofull bathrooms designed with contemporary finishes.Located just steps away from Wilfrid Laurier University, the University of Waterloo, and theUniversity of Waterloo Technology Park, this property is perfectly positioned for students,professionals, and investors alike. You'll also enjoy close proximity to a wide variety ofshops, restaurants, and essential amenities, all within walking distance.This is a rare opportunity to own or invest in one of Canada's fastest-growing communities,making it an excellent choice for both long-term value and immediate lifestyle appeal. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "793.42"
+"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-20T04:33:09.123982+00:00"
+"Directions": "KingStN/UniversityAve"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240165"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-20T03:46:10Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T03:46:10Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4301.4"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1663571058"
"RoomType" => "Dining room"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
1 => array:11 [
"RoomKey" => "1663571059"
"RoomType" => "Living room"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
2 => array:11 [
"RoomKey" => "1663571060"
"RoomType" => "Kitchen"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
3 => array:11 [
"RoomKey" => "1663571061"
"RoomType" => "Bedroom"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
4 => array:11 [
"RoomKey" => "1663571062"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
5 => array:11 [
"RoomKey" => "1663571063"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 2.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932529/304-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc."
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-20T03:46:10.46Z"
+"ListAgentNationalAssociationId": "1478211"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932529_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/787c71ba126a21354a3b14d12b7fd1f0.webp"
"MediaSize" => 122511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-787c71ba126a21354a3b14d12b7fd1f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932529_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/c588a2819617b647a00076991e16016a.webp"
"MediaSize" => 131658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-c588a2819617b647a00076991e16016a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932529_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/155e6e86294be2bc593cd0ba8d5a4c05.webp"
"MediaSize" => 131278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-155e6e86294be2bc593cd0ba8d5a4c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932529_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/b4e84befb216d5f9129e4d9812094243.webp"
"MediaSize" => 148206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-b4e84befb216d5f9129e4d9812094243.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932529_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/d775b9801f7c19953f06318cf4edbfe2.webp"
"MediaSize" => 139840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-d775b9801f7c19953f06318cf4edbfe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932529_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/80f8ea8719004f7066a607447eb97daf.webp"
"MediaSize" => 91472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-80f8ea8719004f7066a607447eb97daf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932529_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/48774b9410ae83c1b512f931de6c2b5f.webp"
"MediaSize" => 86805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-48774b9410ae83c1b512f931de6c2b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932529_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/4e3b2e6ee4fe758d1b19e4935bc2d6df.webp"
"MediaSize" => 102091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-4e3b2e6ee4fe758d1b19e4935bc2d6df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932529_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/9a0cefa5f2004a5172166b6c66e691a3.webp"
"MediaSize" => 95234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-9a0cefa5f2004a5172166b6c66e691a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932529_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/60ccce7a7600ec1cc4d0de35dd8dc4e2.webp"
"MediaSize" => 85203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-60ccce7a7600ec1cc4d0de35dd8dc4e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932529_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/94f52455ce1649e257256eaf72803555.webp"
"MediaSize" => 149489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-94f52455ce1649e257256eaf72803555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932529_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/2120c2f9125d2baa0cdc8af4e4507597.webp"
"MediaSize" => 139496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-2120c2f9125d2baa0cdc8af4e4507597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932529_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/bfe07e83e5eaf8519abd578b7ab0a7c7.webp"
"MediaSize" => 145734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-bfe07e83e5eaf8519abd578b7ab0a7c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932529_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/92638f35227bb02c7e4d408690eea3a0.webp"
"MediaSize" => 99066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-92638f35227bb02c7e4d408690eea3a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932529_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/6acd53fcfe4d92216237257d6b9bee7f.webp"
"MediaSize" => 88625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-6acd53fcfe4d92216237257d6b9bee7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932529_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/8fe1e6567159720def954fc545d22ca0.webp"
"MediaSize" => 87679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-8fe1e6567159720def954fc545d22ca0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932529_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/6ab45ddb9cf2cee7b28ef3896d6e9d7a.webp"
"MediaSize" => 85570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-6ab45ddb9cf2cee7b28ef3896d6e9d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932529')"
+"ID": "1550984"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1549969"
+post_author: 1
+"ListingKey": "29931019"
+"ListingId": "X13468988"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:10:05Z"
+"RFModificationTimestamp": "2026-06-19T22:47:51Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "B02 - 269 SUNVIEW STREET, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.534484
1 => 43.475063
]
+"Latitude": 43.475063
+"Longitude": -80.534484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62650)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:47:41.836982+00:00"
+"Directions": "Cross Streets: University Ave W. ** Directions: University Ave W to Sunview St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1973790"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:55:55Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:55Z"
+"StreetName": "Sunview"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2562"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663282517"
"RoomType" => "Kitchen"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 1.19
"ListingKey" => "29931019"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
1 => array:11 [
"RoomKey" => "1663282518"
"RoomType" => "Living room"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 7.54
"ListingKey" => "29931019"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
2 => array:11 [
"RoomKey" => "1663282519"
"RoomType" => "Den"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29931019"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
3 => array:11 [
"RoomKey" => "1663282520"
"RoomType" => "Bedroom"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 4.04
"ListingKey" => "29931019"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931019/b02-269-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Millcreek Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T20:55:55.74Z"
+"ListAgentNationalAssociationId": "1260583"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:9 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931019_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/33d424a2aa88fa418529f57e8a068675.webp"
"MediaSize" => 259952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-33d424a2aa88fa418529f57e8a068675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931019_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/08f8bbda8d2d88c3f61a908f654ad24b.webp"
"MediaSize" => 19874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-08f8bbda8d2d88c3f61a908f654ad24b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931019_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/16f41e1fcf07c4b20a7b2c339d6f7840.webp"
"MediaSize" => 19762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-16f41e1fcf07c4b20a7b2c339d6f7840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931019_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/636bdc116826293293fc873b1ac1b02b.webp"
"MediaSize" => 29151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-636bdc116826293293fc873b1ac1b02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931019_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/45f8014d9e62b7e75c02bfb4deb8fb0e.webp"
"MediaSize" => 19641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-45f8014d9e62b7e75c02bfb4deb8fb0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931019_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/d9121a606e90aa99016331d9e060ba6f.webp"
"MediaSize" => 19356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-d9121a606e90aa99016331d9e060ba6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931019_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/77c7df04ae8ebbbf04d7e64655e5c0b3.webp"
"MediaSize" => 21689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-77c7df04ae8ebbbf04d7e64655e5c0b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931019_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/ba428d9fafe697dec8e70a00f284618b.webp"
"MediaSize" => 23291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-ba428d9fafe697dec8e70a00f284618b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931019_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/fbeebb6a7cba88cd6b751da7719c933d.webp"
"MediaSize" => 25264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-fbeebb6a7cba88cd6b751da7719c933d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931019')"
+"ID": "1549969"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1549411"
+post_author: 1
+"ListingKey": "29930552"
+"ListingId": "40841564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:32:38Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 555.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "269 SUNVIEW Street Unit# B02, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.5339078
1 => 43.4744488
]
+"Latitude": 43.4744488
+"Longitude": -80.5339078
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62783)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:32:32.417467+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:51:09Z"
+"Stories": "6.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2562"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663230729"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
1 => array:11 [
"RoomKey" => "1663230730"
"RoomType" => "Bedroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
2 => array:11 [
"RoomKey" => "1663230731"
"RoomType" => "Den"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
3 => array:11 [
"RoomKey" => "1663230732"
"RoomType" => "Living room"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "24'9'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
4 => array:11 [
"RoomKey" => "1663230733"
"RoomType" => "Kitchen"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930552/269-sunview-street-unit-b02-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 555
+"OriginalEntryTimestamp": "2026-06-19T19:51:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1066259"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:9 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930552_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/e718aeaf1b5fa5ddbf5c6e289fe545cf.webp"
"MediaSize" => 110811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-e718aeaf1b5fa5ddbf5c6e289fe545cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930552_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/64069cd2637e7dae5486f26c468f726e.webp"
"MediaSize" => 19244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-64069cd2637e7dae5486f26c468f726e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930552_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/14ed3d875bd7267febcacb96a937c98e.webp"
"MediaSize" => 18881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-14ed3d875bd7267febcacb96a937c98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930552_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/3680e514921d5afa459febc2b8a19b0c.webp"
"MediaSize" => 17837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-3680e514921d5afa459febc2b8a19b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930552_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/f5b7aab25daa15cab20440c108035927.webp"
"MediaSize" => 28184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-f5b7aab25daa15cab20440c108035927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930552_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/82e37d182d2a4330fcfe24d23d02aed1.webp"
"MediaSize" => 18141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-82e37d182d2a4330fcfe24d23d02aed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930552_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/25795d4f5a2248071d7a91c413e5b8c8.webp"
"MediaSize" => 17688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-25795d4f5a2248071d7a91c413e5b8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930552_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/54af6580d242acf121ffda211871ee63.webp"
"MediaSize" => 21969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-54af6580d242acf121ffda211871ee63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29930552_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/574af7ac55282d6b3ab5155743777356.webp"
"MediaSize" => 23983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-574af7ac55282d6b3ab5155743777356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930552')"
+"ID": "1549411"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1548833"
+post_author: 1
+"ListingKey": "29930060"
+"ListingId": "40841513"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:10:08Z"
+"RFModificationTimestamp": "2026-06-19T20:32:53Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 349.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "257 HEMLOCK Street Unit# 215, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.5321025
1 => 43.4757935
]
+"Latitude": 43.4757935
+"Longitude": -80.5321025
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The smartest dorm room alternative in Waterloo. Whether you’re a parent looking for a secure, four-year housing solution for your student or an investor seeking a turnkey asset in Waterloo’s university core, Unit 215 at Sage X makes the math simple. Located literally steps from both Wilfrid Laurier University and the University of Waterloo, this modern bachelor-style suite was designed for student life. The layout is compact, highly functional, and completely move-in ready. It features an open-concept living space with floor-to-ceiling windows, a galley kitchen with quartz countertops and stainless steel appliances, and the ultimate student luxury: in-suite laundry. Beyond the unit, the building operates like a modern campus hub. Students have access to a dedicated fitness centre, study lounges, and a rooftop terrace. Better yet, the condo fees are highly inclusive, covering heat, water, central A/C, and high-speed fibre internet. You only pay for hydro. For investors and parents, the financials are just as attractive. It’s secure, it’s modern, and it’s exactly where students want to be. Secure their housing for the next four years and build equity while they study, with the option to keep it as a performing rental later. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "309.82"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:32:45.784486+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T18:50:44Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T18:50:44Z"
+"Stories": "1.0"
+"StreetName": "HEMLOCK"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2206"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/215_257_hemlock_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663184361"
"RoomType" => "Living room"
"ListingId" => "40841513"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930060"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'1''"
"RoomDescription" => null
…2
]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930060/257-hemlock-street-unit-215-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "NMU6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 349
+"OriginalEntryTimestamp": "2026-06-19T18:50:44.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930060')"
+"ID": "1548833"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25252
+post_id: "1547672"
+post_author: 1
+"ListingKey": "29928206"
+"ListingId": "40841235"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:55:23Z"
+"RFModificationTimestamp": "2026-06-19T18:00:18Z"
+"ListPrice": 465000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2R7"
+"UnparsedAddress": "178 WESTCOURT Place, Waterloo, Ontario N2L2R7"
+"Coordinates": array:2 [
0 => -80.5413477
1 => 43.4633325
]
+"Latitude": 43.4633325
+"Longitude": -80.5413477
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention First-Time Homebuyers, Parent Investors, and Landlords! This beautifully updated, spacious end-unit townhouse offers an unbeatable turnkey opportunity right in the heart of Waterloo. Just steps from Waterloo Park, the University of Waterloo, and Wilfrid Laurier University, and directly across the street from Westmount Mall, T&T Grocery Store, and major transit routes, its prime location boasts an incredible walk score. Inside, the bright main floor features fresh paint, attractive flooring, an attractive kitchen with modern cabinetry. The main floor features a highly flexible layout that can easily accommodate a formal dining space. Upstairs holds two large bedrooms and a fully renovated 4-piece bathroom with a sleek glass shower and granite counter, while the partially finished basement is a versatile space for a third bedroom or a family room with a cozy wood fireplace (as-is). Perfect for outdoor entertaining, the living area walks out to a private patio with no rear neighbors, backing onto a serene, park-like setting. Complete with low condo fees, a well-run condo corporation for absolute peace of mind, and one assigned parking space, this highly desirable property is the ultimate choice for a family home or a premium student rental. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "350"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Property Management"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-19T16:34:18.303552+00:00"
+"Directions": "Westmount Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563429"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-19T15:32:16Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:10:40Z"
+"Stories": "2.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "178"
+"StreetSuffix": "Place"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "3594.97"
+"VirtualTourURLUnbranded": "https://youriguide.com/p474x_178_westcourt_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928206/178-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1080
+"OriginalEntryTimestamp": "2026-06-19T15:32:16.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1126015"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928206')"
+"ID": "1547672"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1546332"
+post_author: 1
+"ListingKey": "29917850"
+"ListingId": "40840597"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:00:30Z"
+"RFModificationTimestamp": "2026-06-19T19:07:34Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1779.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2B2"
+"UnparsedAddress": "101 TALBOT Street, Kitchener, Ontario N2M2B2"
+"Coordinates": array:2 [
0 => -80.512917
1 => 43.4435062
]
+"Latitude": 43.4435062
+"Longitude": -80.512917
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 101 Talbot Street, a beautifully renovated all-brick home nestled on a quiet, tree-lined street just minutes from downtown and within walking distance to Belmont Village. This impeccably maintained 3-bedroom, 2-bathroom home has been updated from top to bottom and showcases exceptional pride of ownership. The bright open-concept main floor features a stunning kitchen with quartz countertops, stainless steel appliances, abundant cabinetry, and a large island perfect for informal gatherings, while the separate dining room is ideal for entertaining and hosting family dinners. The inviting living room offers a striking fireplace feature wall and oversized picture window that fills the home with natural light. The main floor bathroom has been updated featuring heated tile floors. The adjacent sun room offers additional storage and provides access to the backyard, a great area for the kids to put their coats and backpacks after school. Upstairs you'll find three spacious bedrooms, including a primary big enough for a King size bed with a walk-in closet and custom built-ins. The finished basement provides a cozy rec room with fireplace, a 3-piece bath, laundry, and plenty of storage. Outside, enjoy a private backyard with plenty of space for the kids to play and features a new concrete patio with multiple seating areas and firepit to unwind and entertain around during the warmer months. The detached garage has recently been insulated and drywalled and is currently being enjoyed as a home gym, offering endless possibilities for future use. Additional updates providing peace of mind, include a new furnace and air conditioner (2024) and water softener (2022). As an added bonus, the home's solar panels generate additional income to help offset monthly expenses. Simply unpack and enjoy! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:46:16.353881+00:00"
+"Directions": "Victoria to Belmont to Talbot"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1739185"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T19:20:59Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T18:33:08Z"
+"Stories": "2.0"
+"StreetName": "TALBOT"
+"StreetNumber": "101"
+"StreetSuffix": "Street"
+"SubdivisionName": "323 - Victoria Hills"
+"TaxAnnualAmount": "3880.55"
+"VirtualTourURLUnbranded": "https://youriguide.com/101_talbot_street_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917850/101-talbot-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 1125
+"BelowGradeFinishedArea": 654
+"OriginalEntryTimestamp": "2026-06-17T19:20:59.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1178528"
+"ListOfficeNationalAssociationId": "1004415"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917850')"
+"ID": "1546332"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1545599"
+post_author: 1
+"ListingKey": "29924889"
+"ListingId": "40841106"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:50:35Z"
+"RFModificationTimestamp": "2026-06-19T16:56:41Z"
+"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:62783)"
+"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-19T16:11:30Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924889')"
+"ID": "1545599"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1545600"
+post_author: 1
+"ListingKey": "29925506"
+"ListingId": "X13464128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:00:49Z"
+"RFModificationTimestamp": "2026-06-19T18:23:57Z"
+"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-19T17:29:59Z"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925506')"
+"ID": "1545600"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1545601"
+post_author: 1
+"ListingKey": "29924270"
+"ListingId": "40840744"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:40:12Z"
+"RFModificationTimestamp": "2026-06-18T22:41:09Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 997.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1R1"
+"UnparsedAddress": "191 KING Street S Unit# 506, Waterloo, Ontario N2J1R1"
+"Coordinates": array:2 [
0 => -80.5187715
1 => 43.4595457
]
+"Latitude": 43.4595457
+"Longitude": -80.5187715
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Suite 506 at the Bauer Lofts! Offering something virtually unheard of in Uptown condo living: TWO OWNED UNDERGROUND PARKING SPACES. In a highly coveted building like the Bauer Lofts, a second parking spot is an absolute game-changer and a true rarity. Featuring soaring ceilings and iconic loft-style windows, there is no shortage of natural sunlight inside this beautiful suite. The large kitchen provides plenty of space to cook and entertain, with ample cupboard and counter space, opening seamlessly to a living room that easily accommodates a dining area or a dedicated work-from-home desk setup. Step outside to your sizeable private balcony to relax and enjoy vibrant views of Uptown Waterloo. The primary bedroom features double closets, plenty of space for a king bed, and a luxurious 5-piece ensuite with double sinks, a soaker tub, a standup shower, and a linen closet. The second bedroom is also large and bright, serving perfectly as a bedroom, study, or office to flexibly meet your needs. An in-suite laundry room with a stackable washer/dryer, extra storage, and a second full bath complete this flawless layout. A storage locker is included for added convenience. The Bauer Lofts premium building amenities include a Fitness Centre, a Rooftop Patio and BBQ Terrace, and a Party Room with a full Kitchen. Located in the vibrant Bauer district, you can enjoy all that Uptown Waterloo has to offer, including exclusive underground access to Vincenzo's and the Bauer Kitchen, while stepping right outside to the Allen St. ION LRT Station. With condo fees including all utilities, this building makes upsizing, downsizing, or first-time buying incredibly affordable, especially with the added value of two rare parking spaces. Come see how great condo living can be today. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "754.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:40:58.247930+00:00"
+"Directions": "King St S and John St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167367"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-18T19:31:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:31:17Z"
+"Stories": "5.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5299.37"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=S1pxx3SNs49"
+"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/29924270/191-king-street-s-unit-506-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "C2-25"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 997
+"OriginalEntryTimestamp": "2026-06-18T19:31:17.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1418165"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924270')"
+"ID": "1545601"
}
]
+success: true
+page_size: 9
+page_count: 45
+count: 399
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]