array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29932677 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: "1551442"
+post_author: 1
+"ListingKey": "29932677"
+"ListingId": "X13470514"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T12:05:06Z"
+"RFModificationTimestamp": "2026-06-20T15:01:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2M4"
+"UnparsedAddress": "179 MURDOCK AVENUE, Waterloo, Ontario N2J2M4"
+"Coordinates": array:2 [
0 => -80.5068727
1 => 43.4733821
]
+"Latitude": 43.4733821
+"Longitude": -80.5068727
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 179 Murdock! This beautifully maintained 4 bedroom home is the perfect blend of space, comfort and convenience for growing families. With a bright and functional interior, you've got lots of room to spread out! Keep the kids toys downstairs with a fully finished basement and oversized family room! Outside you have a detached garage and your own private backyard. A fantastic opportunity for a move in ready home in a great community. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater - Tankless"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T15:01:23.675165+00:00"
+"Directions": "Cross Streets: Bridgeport Rd E & Weber St N. ** Directions: Bridgeport to Ellis to Murdock."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154620"
+"ListOfficeKey": "283840"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T11:55:39Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T11:55:39Z"
+"Stories": "1.5"
+"StreetName": "Murdock"
+"StreetNumber": "179"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4055"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/179_murdock_ave_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Niagara"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29932677/179-murdock-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-20T11:55:38.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406092"
+"ListOfficeNationalAssociationId": "1335712"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932677_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/9a3a36c34aeb7a983fea7b4e6db115a7.webp"
"MediaSize" => 442990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-9a3a36c34aeb7a983fea7b4e6db115a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932677_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/049747c5518859b4e3f4cfe8971c298a.webp"
"MediaSize" => 419188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-049747c5518859b4e3f4cfe8971c298a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932677_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/208a1f219d6da30d79b52b6fbdd242c2.webp"
"MediaSize" => 188143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-208a1f219d6da30d79b52b6fbdd242c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932677_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/f0fc51e7bc2199f5ce9f91f4616e0109.webp"
"MediaSize" => 187886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-f0fc51e7bc2199f5ce9f91f4616e0109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932677_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/2a24ae350a9c5ad8a6e586f406df50ab.webp"
"MediaSize" => 152100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-2a24ae350a9c5ad8a6e586f406df50ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932677_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/abb032e38da2a932640c59ca7824573a.webp"
"MediaSize" => 105759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-abb032e38da2a932640c59ca7824573a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932677_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/a360d615abf2cfa9ae3d1c1ab19f554e.webp"
"MediaSize" => 89329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-a360d615abf2cfa9ae3d1c1ab19f554e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932677_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/8a294926c50ea8c1da3ecf221c421b7a.webp"
"MediaSize" => 136207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-8a294926c50ea8c1da3ecf221c421b7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932677_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/419a7b8a57bd2c9136b00c5de304e156.webp"
"MediaSize" => 127774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-419a7b8a57bd2c9136b00c5de304e156.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932677_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/f6b809848a5caf44928433494d1fc0c5.webp"
"MediaSize" => 107159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-f6b809848a5caf44928433494d1fc0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932677_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/48db84681f71ecc2a273b5d29df50b28.webp"
"MediaSize" => 187888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-48db84681f71ecc2a273b5d29df50b28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932677_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/c8f07c48128d7119d59ec16fb2efd960.webp"
"MediaSize" => 188589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-c8f07c48128d7119d59ec16fb2efd960.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932677_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/883bc25cccc07d72ebc28c3cde7c78b0.webp"
"MediaSize" => 170221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-883bc25cccc07d72ebc28c3cde7c78b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932677_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/3292fede3fd480b62ca2bae16eb7c726.webp"
"MediaSize" => 195510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-3292fede3fd480b62ca2bae16eb7c726.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932677_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/22daf1dce17ca6ee2c1e2c13f450448c.webp"
"MediaSize" => 94145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-22daf1dce17ca6ee2c1e2c13f450448c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932677_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/d807ffd622c6b814cb184f6800c2035c.webp"
"MediaSize" => 75249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-d807ffd622c6b814cb184f6800c2035c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932677_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/5175ee33da302e6fecb39907bd492b0a.webp"
"MediaSize" => 101973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-5175ee33da302e6fecb39907bd492b0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29932677_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/3bc97debad81fdac1c3b43a9056a5e1c.webp"
"MediaSize" => 87699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-3bc97debad81fdac1c3b43a9056a5e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29932677_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/7e22529c064598cd61b440ff68917080.webp"
"MediaSize" => 114112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-7e22529c064598cd61b440ff68917080.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29932677_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/a70032829e8bec48cf41bf331def8578.webp"
"MediaSize" => 88238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-a70032829e8bec48cf41bf331def8578.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29932677_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/0ea76ef4171c68d6283cdd9b2b922bfe.webp"
"MediaSize" => 109926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-0ea76ef4171c68d6283cdd9b2b922bfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29932677_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/6a7d941596a58fd80cc536833587f901.webp"
"MediaSize" => 87929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-6a7d941596a58fd80cc536833587f901.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29932677_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/39262de8f4d87f421a33b163bb04d088.webp"
"MediaSize" => 99532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-39262de8f4d87f421a33b163bb04d088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29932677_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/11bfe5fe18e877283decf049c51fbd28.webp"
"MediaSize" => 91988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-11bfe5fe18e877283decf049c51fbd28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29932677_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/44cf4dfc16e16270ab7ea47c5cc0d351.webp"
"MediaSize" => 104451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-44cf4dfc16e16270ab7ea47c5cc0d351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29932677_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/4042bc473dfdd7430e9af38d0efa452e.webp"
"MediaSize" => 93304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-4042bc473dfdd7430e9af38d0efa452e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29932677_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/00d65bcafe7c45b656c5fae6e68b263d.webp"
"MediaSize" => 93852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-00d65bcafe7c45b656c5fae6e68b263d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29932677_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/d08538e5da44632379896adea579377e.webp"
"MediaSize" => 456806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-d08538e5da44632379896adea579377e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29932677_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/72c9ca5dd316168ca3b22da6bdfe5daa.webp"
"MediaSize" => 341145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-72c9ca5dd316168ca3b22da6bdfe5daa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29932677_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/2f2de597ebc9b8da4577b80e3329ee49.webp"
"MediaSize" => 473594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-2f2de597ebc9b8da4577b80e3329ee49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29932677_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/e44cf707db15d87367357afab1c8b709.webp"
"MediaSize" => 483510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-e44cf707db15d87367357afab1c8b709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29932677_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/b4a782837266ee435f59a456f9a7c3d3.webp"
"MediaSize" => 461611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-b4a782837266ee435f59a456f9a7c3d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29932677_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/52db5f6db077b47c3629b35905ee4f6e.webp"
"MediaSize" => 366851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-52db5f6db077b47c3629b35905ee4f6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29932677_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/370141e0163eadc2edab55a2ed0b830a.webp"
"MediaSize" => 463988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-370141e0163eadc2edab55a2ed0b830a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29932677_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/2d5fb18fbb76ee403aa6007f5095eea9.webp"
"MediaSize" => 450077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-2d5fb18fbb76ee403aa6007f5095eea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29932677_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/4040a4bb2f076fdb97eb4e457513d246.webp"
"MediaSize" => 500738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-4040a4bb2f076fdb97eb4e457513d246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29932677_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/913beb6cafe019451e5e12a9681b2d40.webp"
"MediaSize" => 504456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-913beb6cafe019451e5e12a9681b2d40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29932677_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/9f1687df470b5df91c0623d2e55856b9.webp"
"MediaSize" => 431866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-9f1687df470b5df91c0623d2e55856b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29932677_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/d72d2203a59ee744903326b16eed4f4e.webp"
"MediaSize" => 448579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-d72d2203a59ee744903326b16eed4f4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29932677_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/d683a6e1e8d7d3dc061428c3f144eaca.webp"
"MediaSize" => 443460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-d683a6e1e8d7d3dc061428c3f144eaca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29932677_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/e5078c3b03a02836c4d3a68fed97866f.webp"
"MediaSize" => 401998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-e5078c3b03a02836c4d3a68fed97866f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29932677_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/5ae850527c457c152cdac1f7c2101ba1.webp"
"MediaSize" => 109715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-5ae850527c457c152cdac1f7c2101ba1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29932677_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/9f483b5df849edbc29885b0b8a444a2b.webp"
"MediaSize" => 100528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-9f483b5df849edbc29885b0b8a444a2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29932677_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932677/aaeb623c8d6d869e699aefeeff698fd8.webp"
"MediaSize" => 100759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932677/thumbnail-aaeb623c8d6d869e699aefeeff698fd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470514"
"ResourceRecordKey" => "29932677"
"ModificationTimestamp" => "2026-06-20T11:55:39.02Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932677')"
+"ID": "1551442"
}
]
+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 283840" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913
+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 2154620" => 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.19 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29932677'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29932677'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29932677' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5068727 43.4733821)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25362
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1551131"
+post_author: 1
+"ListingKey": "29932555"
+"ListingId": "X13470380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T04:25:12Z"
+"RFModificationTimestamp": "2026-06-20T05:34:29Z"
+"ListPrice": 760000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "806 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261878
1 => 43.4782103
]
+"Latitude": 43.4782103
+"Longitude": -80.5261878
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great investment opportunity in huge 5 bedrooms and 5 bathrooms luxury suite in high rise condominium building. 8 Hickory Street West is a high-end student condo building located within walking distance to the University of Waterloo, Wilfrid Laurier University, restaurants, shopping &situated right on the LRT route. Unit 806 has a total of 2077 SQFT living space and one underground parking space. It features 5 large bedrooms, 5 full bathrooms, 9 ft ceilings, open concept layout, in-suit laundry, modern kitchen with stainless steel appliances, granite countertops, and central island, and overlooks spacious living room. Amazing unobstructed city view through the balcony. Furnished. Internet is included. (id:62783)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"AssociationFee": "924.57"
+"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-20T05:34:17.704632+00:00"
+"Directions": "Cross Streets: King Street to Hickory. ** Directions: Hickory St W/King St N."
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959006"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-20T04:17:51Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T04:17:51Z"
+"StreetDirSuffix": "West"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7604"
+"View": "City view"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1663597932"
"RoomType" => "Living room"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29932555"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
1 => array:11 [
"RoomKey" => "1663597933"
"RoomType" => "Dining room"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29932555"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
2 => array:11 [
"RoomKey" => "1663597934"
"RoomType" => "Kitchen"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.44
"ListingKey" => "29932555"
"RoomLength" => 4.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
3 => array:11 [
"RoomKey" => "1663597935"
"RoomType" => "Bedroom"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29932555"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
4 => array:11 [
"RoomKey" => "1663597936"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29932555"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
5 => array:11 [
"RoomKey" => "1663597937"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29932555"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
6 => array:11 [
"RoomKey" => "1663597938"
"RoomType" => "Bedroom 4"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29932555"
"RoomLength" => 7.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
7 => array:11 [
"RoomKey" => "1663597939"
"RoomType" => "Bedroom 5"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29932555"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932555/806-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-20T04:17:51.62Z"
+"ListAgentNationalAssociationId": "1249681"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932555_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/b1523883d7199d3ef5419334fd1da487.webp"
"MediaSize" => 279932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-b1523883d7199d3ef5419334fd1da487.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932555_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/c3ec9bcbf0e2cc41a5ba06382634d352.webp"
"MediaSize" => 312776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-c3ec9bcbf0e2cc41a5ba06382634d352.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932555_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/dd27a00e0e6b99b4ebab180432135b6d.webp"
"MediaSize" => 205523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-dd27a00e0e6b99b4ebab180432135b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932555_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/da9fd378e966d85e534af05933033f7e.webp"
"MediaSize" => 169009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-da9fd378e966d85e534af05933033f7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932555_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/6ef82bd9caf1bc825fdfd34e075a49de.webp"
"MediaSize" => 103690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-6ef82bd9caf1bc825fdfd34e075a49de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932555_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/5cc3b65954702b24d58398eff40f92a3.webp"
"MediaSize" => 168326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-5cc3b65954702b24d58398eff40f92a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932555_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a4e10fbebde7e3897f362e5177bc189f.webp"
"MediaSize" => 157246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a4e10fbebde7e3897f362e5177bc189f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932555_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a8447ad4c33a590fce686383b9b3a672.webp"
"MediaSize" => 148946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a8447ad4c33a590fce686383b9b3a672.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932555_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/9cc48d8816c682adcfedb3f6ba7fb9b2.webp"
"MediaSize" => 279768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-9cc48d8816c682adcfedb3f6ba7fb9b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932555_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/fa93f8f09e88d1678457c6e52ad51c36.webp"
"MediaSize" => 151126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-fa93f8f09e88d1678457c6e52ad51c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932555_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a51931232d153723c502d081f3952edd.webp"
"MediaSize" => 148104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a51931232d153723c502d081f3952edd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932555_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/09ef81a690d2b78e6c40c183797c0441.webp"
"MediaSize" => 229106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-09ef81a690d2b78e6c40c183797c0441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932555_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/ee6e00261847f3b7536fab11dcbbb012.webp"
"MediaSize" => 116742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-ee6e00261847f3b7536fab11dcbbb012.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932555_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/68e8ed5ac633ef6a95aa577c26bf55c2.webp"
"MediaSize" => 221320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-68e8ed5ac633ef6a95aa577c26bf55c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932555_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/cdac809c62f02e004429f0fa23163bb8.webp"
"MediaSize" => 102757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-cdac809c62f02e004429f0fa23163bb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932555_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/0c870780e316bef1220d5a2bad2c7bf3.webp"
"MediaSize" => 115102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-0c870780e316bef1220d5a2bad2c7bf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932555_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/1b02813c60a53518305acd0d89afa9eb.webp"
"MediaSize" => 179873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-1b02813c60a53518305acd0d89afa9eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29932555_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/e2b36fdf48944fc2dc40f92a86eb75fa.webp"
"MediaSize" => 262695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-e2b36fdf48944fc2dc40f92a86eb75fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29932555_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/478f3eed12e6c81393f278f4fe703031.webp"
"MediaSize" => 180915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-478f3eed12e6c81393f278f4fe703031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29932555_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/f6b71c8b82fe621f45c99b1a94121f78.webp"
"MediaSize" => 210157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-f6b71c8b82fe621f45c99b1a94121f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29932555_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/16bb7464586dd88601ce0f1cc3337f4b.webp"
"MediaSize" => 224526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-16bb7464586dd88601ce0f1cc3337f4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932555')"
+"ID": "1551131"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+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 [ …11]
5 => array:11 [ …11]
]
+"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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932529')"
+"ID": "1550984"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928222')"
+"ID": "1547671"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1547625"
+post_author: 1
+"ListingKey": "29927069"
+"ListingId": "X13465556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T12:35:09Z"
+"RFModificationTimestamp": "2026-06-19T16:22:39Z"
+"ListPrice": 439000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H4V1"
+"UnparsedAddress": "238 LANCASTER STREET W, Kitchener, Ontario N2H4V1"
+"Coordinates": array:2 [
0 => -80.4839792
1 => 43.4674724
]
+"Latitude": 43.4674724
+"Longitude": -80.4839792
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A detached 1.5-storey on Lancaster Street West, offered at a price that makes the numbers work. This is a project property in a central Kitchener location - the structure is sound, the footprint is generous, & the neighbourhood has continued to attract buyers willing to put in the work. Whether the plan is a gut reno, a flip, or a long-term rental hold, the fundamentals here support the investment. A buyer with a clear vision will understand what this address is worth once the work is done. (MAIN LEVEL) Living room at the front with a wood-burning fireplace & large windows overlooking the yard - a natural centrepiece that will read well to future buyers once the space is refreshed. Dining room connects through to the kitchen, currently equipped with stove & fridge. Den at the rear walks out directly to the deck & backyard - practical as a mudroom entry, home office, or part of a reconfigured rear layout depending on your plans for the space. Powder room under the stairs. (UPPER LEVEL) Two bedrooms, each with a closet. 4pc main bathroom on this level. A clean, straightforward floor plan that functions well as-is or opens up nicely with the right renovation approach.(BASEMENT)The basement runs the full footprint of the home & is completely unfinished - two sections: a utility area & a large laundry space. No prior development work to undo. The scale of this lower level makes it a strong candidate for a future basement suite, added rec room, or expanded living area, subject to applicable permits. (LOCATION) Steps to the Iron Horse Trail - 5.5km of paved multi-use trail linking downtown Kitchener to Waterloo Park & the iON LRT. Victoria Park, Kitchener's oldest park, is minutes away. Hwys 7 & 8 connect you to Guelph & the broader region. Grand River Hospital is in the neighbourhood. Downtown Kitchener restaurants, shops & daily amenities are all within walking distance. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Stove"
2 => "Dryer"
3 => "Freezer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-19T16:22:26.087497+00:00"
+"Directions": "Cross Streets: Lancaster St W & Victoris St N. ** Directions: At Victoria St N & Lancaster St W, Head North on Lancaster St W; Destination will be on the right approx 1km."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922276"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 129 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T12:16:10Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T12:16:10Z"
+"Stories": "1.5"
+"StreetDirSuffix": "West"
+"StreetName": "Lancaster"
+"StreetNumber": "238"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3650"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29927069/238-lancaster-street-w-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-19T12:16:10.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227436"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927069')"
+"ID": "1547625"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1547626"
+post_author: 1
+"ListingKey": "29927481"
+"ListingId": "40841394"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:25:31Z"
+"RFModificationTimestamp": "2026-06-19T21:30:26Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1509.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H4T9"
+"UnparsedAddress": "219 W LANCASTER Street W, Kitchener, Ontario N2H4T9"
+"Coordinates": array:2 [
0 => -80.4844965
1 => 43.4665688
]
+"Latitude": 43.4665688
+"Longitude": -80.4844965
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A beautifully updated 1.5 storey home offering plenty of finished living space, 3 bedrooms and 3 bathrooms in a convenient location close to schools, parks, transit and all major amenities. The bright and inviting open concept main floor is designed for comfortable everyday living and effortless entertaining. Enjoy a spacious living room, separate dining area and a versatile den with walk-out access to the backyard, providing the perfect space for a home office, playroom or sitting area. The kitchen is both stylish and functional, featuring stainless steel appliances, butcher block countertops and ample cupboard space for all your storage needs. A main floor bedroom and a full 4-piece bathroom add convenience and flexibility for guests or multi-generational living. Upstairs, you'll find two additional bedrooms along with a convenient 2-piece bathroom. The finished basement, complete with a separate entrance, offers even more living space with a large rec room, an additional 2-piece bathroom and endless possibilities for a home gym, media room, in-law suite or recreation area. Step outside to a fully fenced backyard designed for relaxing and entertaining, featuring a deck, patio area and storage shed. Parking is never an issue with a three-car driveway and covered carport. This move-in ready home combines character, functionality and modern updates in an ideal family-friendly location. A fantastic opportunity for first-time buyers, growing families or anyone looking for a home with plenty of space inside and out. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T15:55:49.914171+00:00"
+"Directions": "Lancaster & Guelph"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879566"
+"ListOfficeKey": "294054"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-19T14:12:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:50:56Z"
+"Stories": "1.5"
+"StreetDirSuffix": "West"
+"StreetName": "LANCASTER"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"SubdivisionName": "212 - Downtown Kitchener/East Ward"
+"TaxAnnualAmount": "3744.38"
+"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/29927481/219-lancaster-street-w-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1182
+"BelowGradeFinishedArea": 327
+"OriginalEntryTimestamp": "2026-06-19T14:11:11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1205653"
+"ListOfficeNationalAssociationId": "1434831"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927481')"
+"ID": "1547626"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1547627"
+post_author: 1
+"ListingKey": "29927967"
+"ListingId": "X13466218"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:10:04Z"
+"RFModificationTimestamp": "2026-06-19T15:54:21Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H4T9"
+"UnparsedAddress": "219 LANCASTER STREET W, Kitchener, Ontario N2H4T9"
+"Coordinates": array:2 [
0 => -80.484518
1 => 43.466551
]
+"Latitude": 43.466551
+"Longitude": -80.484518
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A beautifully updated 1.5 storey home offering plenty of finished living space, 3 bedrooms and 3 bathrooms in a convenient location close to schools, parks, transit and all major amenities. The bright and inviting open concept main floor is designed for comfortable everyday living and effortless entertaining. Enjoy a spacious living room, separate dining area and a versatile den with walk-out access to the backyard, providing the perfect space for a home office, playroom or sitting area. The kitchen is both stylish and functional, featuring stainless steel appliances, butcher block countertops and ample cupboard space for all your storage needs. A main floor bedroom and a full 4-piece bathroom add convenience and flexibility for guests or multi-generational living. Upstairs, you'll find two additional bedrooms along with a convenient 2-piece bathroom. The finished basement, complete with a separate entrance, offers even more living space with a large rec room, an additional 2-piece bathroom and endless possibilities for a home gym, media room, in-law suite or recreation area. Step outside to a fully fenced backyard designed for relaxing and entertaining, featuring a deck, patio area and storage shed. Parking is never an issue with a three-car driveway and covered carport. This move-in ready home combines character, functionality and modern updates in an ideal family-friendly location. A fantastic opportunity for first-time buyers, growing families or anyone looking for a home with plenty of space inside and out. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T15:54:10.689264+00:00"
+"Directions": "Lancaster & Guelph"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023978"
+"ListOfficeKey": "285897"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-19T15:01:39Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:01:39Z"
+"Stories": "1.5"
+"StreetDirSuffix": "West"
+"StreetName": "Lancaster"
+"StreetNumber": "219"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3744.38"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29927967/219-lancaster-street-w-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-19T15:01:39.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1303719"
+"ListOfficeNationalAssociationId": "1356034"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927967')"
+"ID": "1547627"
}
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924889')"
+"ID": "1545599"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925506')"
+"ID": "1545600"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924270')"
+"ID": "1545601"
}
]
+success: true
+page_size: 9
+page_count: 29
+count: 257
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]