array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29798965 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: "1455925"
+post_author: 1
+"ListingKey": "29798965"
+"ListingId": "X13168594"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T12:31:10Z"
+"RFModificationTimestamp": "2026-06-07T12:56:39Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V5"
+"UnparsedAddress": "K - 653 ALBERT STREET, Waterloo, Ontario N2L3V5"
+"Coordinates": array:2 [
0 => -80.538958
1 => 43.491159
]
+"Latitude": 43.491159
+"Longitude": -80.538958
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Space, style, and comfort come together in this beautifully maintained 3-bedroom, 2-bathroom, 2-storey townhome condo offering over 1,300 sq. ft. above grade. The finished basement with exposed ceilings adds a modern industrial touch and creates the perfect bonus living space for a rec room, office, or gym. Thoughtfully designed with spacious principal rooms and a functional layout, this home is ideal for growing families or anyone looking for extra room to live and entertain. Enjoy the added perks of condo living, including access to a community pool and low-maintenance convenience. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "538.05"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T14:52:30.857779+00:00"
+"Directions": "Cross Streets: WEBER ST N AND ALBERT. ** Directions: WEBER ST N TO ALBERT."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2164017"
+"ListOfficeKey": "285730"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-25T14:16:37Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T12:20:29Z"
+"Stories": "2.0"
+"StreetName": "Albert"
+"StreetNumber": "653"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2826.63"
+"VirtualTourURLUnbranded": "https://dl.dropboxusercontent.com/scl/fi/2lf2m8pkycsv4xe7f6gyd/Video-Reel-653-Albert-St-Waterloo-ON.mp4?rlkey=jh6yjxd0obh1kybkzhe85kzk2&raw=1"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1653992240"
"RoomType" => "Living room"
"ListingId" => "X13168594"
"RoomLevel" => "Main level"
"RoomWidth" => 5.2
"ListingKey" => "29798965"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
1 => array:11 [
"RoomKey" => "1653992241"
"RoomType" => "Dining room"
"ListingId" => "X13168594"
"RoomLevel" => "Main level"
"RoomWidth" => 2.47
"ListingKey" => "29798965"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
2 => array:11 [
"RoomKey" => "1653992242"
"RoomType" => "Kitchen"
"ListingId" => "X13168594"
"RoomLevel" => "Main level"
"RoomWidth" => 2.2
"ListingKey" => "29798965"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
3 => array:11 [
"RoomKey" => "1653992243"
"RoomType" => "Bathroom"
"ListingId" => "X13168594"
"RoomLevel" => "Main level"
"RoomWidth" => 1.84
"ListingKey" => "29798965"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
4 => array:11 [
"RoomKey" => "1653992244"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13168594"
"RoomLevel" => "Second level"
"RoomWidth" => 3.97
"ListingKey" => "29798965"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
5 => array:11 [
"RoomKey" => "1653992245"
"RoomType" => "Bedroom 2"
"ListingId" => "X13168594"
"RoomLevel" => "Second level"
"RoomWidth" => 2.47
"ListingKey" => "29798965"
"RoomLength" => 3.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
6 => array:11 [
"RoomKey" => "1653992246"
"RoomType" => "Bedroom 3"
"ListingId" => "X13168594"
"RoomLevel" => "Second level"
"RoomWidth" => 2.46
"ListingKey" => "29798965"
"RoomLength" => 5.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.33Z"
]
7 => array:11 [
"RoomKey" => "1653992247"
"RoomType" => "Bathroom"
"ListingId" => "X13168594"
"RoomLevel" => "Second level"
"RoomWidth" => 1.84
"ListingKey" => "29798965"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.34Z"
]
8 => array:11 [
"RoomKey" => "1653992248"
"RoomType" => "Media"
"ListingId" => "X13168594"
"RoomLevel" => "Basement"
"RoomWidth" => 5.19
"ListingKey" => "29798965"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T12:20:29.34Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29798965/k-653-albert-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1924158"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Reed Condo Managment"
+"CoListAgentKey2": "1566957"
+"CoListOfficeKey": "271450"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "271450"
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-05-25T14:16:37.84Z"
+"ListAgentNationalAssociationId": "1414955"
+"ListOfficeNationalAssociationId": "1353943"
+"CoListAgentNationalAssociationId": "1228389"
+"CoListAgentNationalAssociationId2": "1149406"
+"CoListOfficeNationalAssociationId": "1239071"
+"CoListOfficeNationalAssociationId2": "1239071"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29798965_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/c74ebd0155196e8922155bfb6fa64d97.webp"
"MediaSize" => 212304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-c74ebd0155196e8922155bfb6fa64d97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29798965_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/4387c45649e8fd4315bc531c7d24e9b8.webp"
"MediaSize" => 284976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-4387c45649e8fd4315bc531c7d24e9b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29798965_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/105f1b5adb93b0989011950da32e93c6.webp"
"MediaSize" => 126235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-105f1b5adb93b0989011950da32e93c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29798965_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/df7c48f00505f0142810c3ce140ca449.webp"
"MediaSize" => 141278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-df7c48f00505f0142810c3ce140ca449.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29798965_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/039c05f6c6a562cbf71c356503e17489.webp"
"MediaSize" => 150599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-039c05f6c6a562cbf71c356503e17489.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29798965_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/d359f3f7d9ebf22c5d6b829163fd3d6b.webp"
"MediaSize" => 157524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-d359f3f7d9ebf22c5d6b829163fd3d6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29798965_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/12273bb02bcf4d6fe52c785b092ab522.webp"
"MediaSize" => 129454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-12273bb02bcf4d6fe52c785b092ab522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29798965_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/be02c1e296eaad612811621a6f6d3d7c.webp"
"MediaSize" => 101780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-be02c1e296eaad612811621a6f6d3d7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "main floor 2 piece"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29798965_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/ec75ccde81cdacd6b9967ad71810f998.webp"
"MediaSize" => 122156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-ec75ccde81cdacd6b9967ad71810f998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29798965_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/ad5327539f1d9dbd727ac9ece88898e8.webp"
"MediaSize" => 123855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-ad5327539f1d9dbd727ac9ece88898e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29798965_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/9920dfa29e1d9ff1f56cb91e6c119b6d.webp"
"MediaSize" => 138445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-9920dfa29e1d9ff1f56cb91e6c119b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29798965_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/2e3ec64592514fb4f2d458bd8cb9f38d.webp"
"MediaSize" => 174399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-2e3ec64592514fb4f2d458bd8cb9f38d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29798965_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/3b643037dc56befd1cbbae3499e78917.webp"
"MediaSize" => 198465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-3b643037dc56befd1cbbae3499e78917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29798965_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/34041b2c756453a829c1bec0454e5426.webp"
"MediaSize" => 158859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-34041b2c756453a829c1bec0454e5426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29798965_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/581a5350a86f8ab468c217f319265253.webp"
"MediaSize" => 168147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-581a5350a86f8ab468c217f319265253.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29798965_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/10b82b65d5afae813abf42caf239a918.webp"
"MediaSize" => 114699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-10b82b65d5afae813abf42caf239a918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29798965_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/1e41951e389766d1182022cdfa37433e.webp"
"MediaSize" => 83476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-1e41951e389766d1182022cdfa37433e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29798965_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/84f9c36313776aba2291aab80bee49cf.webp"
"MediaSize" => 97542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-84f9c36313776aba2291aab80bee49cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "primary"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29798965_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/cd45cf5c954f7f9201df9d8368360ff5.webp"
"MediaSize" => 131790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-cd45cf5c954f7f9201df9d8368360ff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29798965_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/8743844255f608d7f8c9cff8eeaa78a5.webp"
"MediaSize" => 102808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-8743844255f608d7f8c9cff8eeaa78a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29798965_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/0de00bea91885498ec37876fdacd1cf9.webp"
"MediaSize" => 124096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-0de00bea91885498ec37876fdacd1cf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29798965_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/9310a030e943c9901aad273cbe89262c.webp"
"MediaSize" => 111721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-9310a030e943c9901aad273cbe89262c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29798965_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/0d41a30348d45966c81fe33e09c64a3a.webp"
"MediaSize" => 119503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-0d41a30348d45966c81fe33e09c64a3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29798965_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/3b0f8aae63abad71068fa21ad08be239.webp"
"MediaSize" => 153556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-3b0f8aae63abad71068fa21ad08be239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29798965_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/5819777d4b6c2b3977afce2215fa47de.webp"
"MediaSize" => 146317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-5819777d4b6c2b3977afce2215fa47de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29798965_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/99af1d164531f6d25cda06472fa20eb7.webp"
"MediaSize" => 185227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-99af1d164531f6d25cda06472fa20eb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29798965_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/48b9a565c545fab44735cc87a0b37ddb.webp"
"MediaSize" => 170992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-48b9a565c545fab44735cc87a0b37ddb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29798965_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/7986b92e0e4a825b43c0c2ebf25c1e44.webp"
"MediaSize" => 338230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-7986b92e0e4a825b43c0c2ebf25c1e44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29798965_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/9726d8fc189397f4452f579607090768.webp"
"MediaSize" => 347470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-9726d8fc189397f4452f579607090768.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29798965_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/719212cbc530a25fca7665a63ae58dd5.webp"
"MediaSize" => 326094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-719212cbc530a25fca7665a63ae58dd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29798965_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/4802e512b1d55973e7ddff0156beafd9.webp"
"MediaSize" => 351004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-4802e512b1d55973e7ddff0156beafd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29798965_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29798965/db69de5355b0133d1a639561fb0bc6f9.webp"
"MediaSize" => 328763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29798965/thumbnail-db69de5355b0133d1a639561fb0bc6f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13168594"
"ResourceRecordKey" => "29798965"
"ModificationTimestamp" => "2026-05-25T14:16:37.85Z"
]
]
+"DaysOnMarket": 27
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29798965')"
+"ID": "1455925"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285730" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24889
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2164017" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29798965'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25193
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29798965'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25211
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31272591"
+"ListingKey": "29798965"
+"ListingId": "X13168594"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T05:15:03Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31272591')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29798965' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.538958 43.491159)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1551552"
+post_author: 1
+"ListingKey": "29932856"
+"ListingId": "X13470720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T14:25:13Z"
+"RFModificationTimestamp": "2026-06-20T16:53:32Z"
+"ListPrice": 498999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "206 - 251 LESTER STREET, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.534834
1 => 43.473527
]
+"Latitude": 43.473527
+"Longitude": -80.534834
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible Turnkey Investment In The Heart Of Waterloo's University District! This Purpose-Built 5-Bedroom, 2-Bathroom Condo At 253 Lester St Has The Potential To Generate Positive Monthly Cash Flow. Just Steps To Wilfrid Laurier University And The University Of Waterloo, This High-Demand Location Ensures Consistent Tenancy. Features Include A Spacious Open-Concept Living Area, Two Full Baths, Included Furniture, And Professional Property Management Options For A Completely Hands-Off Experience. Condo Fees Include Heat And Water, And The Building Offers Parking, Shared Laundry, Elevator Access, And Proximity To Transit, Shops, And Amenities. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"AssociationFee": "790.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:53:26.043009+00:00"
+"Directions": "University Ave W / Lester St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045015"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T14:17:13Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T14:17:13Z"
+"StreetName": "Lester"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4059"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1663846392"
"RoomType" => "Living room"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 2.82
"ListingKey" => "29932856"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.6Z"
]
1 => array:11 [
"RoomKey" => "1663846393"
"RoomType" => "Dining room"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 8.43
"ListingKey" => "29932856"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.6Z"
]
2 => array:11 [
"RoomKey" => "1663846394"
"RoomType" => "Kitchen"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 8.43
"ListingKey" => "29932856"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
3 => array:11 [
"RoomKey" => "1663846395"
"RoomType" => "Foyer"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 8.43
"ListingKey" => "29932856"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
4 => array:11 [
"RoomKey" => "1663846396"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "29932856"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
5 => array:11 [
"RoomKey" => "1663846397"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29932856"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
6 => array:11 [
"RoomKey" => "1663846398"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29932856"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
7 => array:11 [
"RoomKey" => "1663846399"
"RoomType" => "Bedroom 4"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "29932856"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
8 => array:11 [
"RoomKey" => "1663846400"
"RoomType" => "Bedroom 5"
"ListingId" => "X13470720"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29932856"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:17:13.61Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932856/206-251-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2022731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "278195"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-20T14:17:13.57Z"
+"ListAgentNationalAssociationId": "1320619"
+"ListOfficeNationalAssociationId": "1268183"
+"CoListAgentNationalAssociationId": "1302336"
+"CoListOfficeNationalAssociationId": "1290805"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932856_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/4cc663010c16d0dce468df5c351651bc.webp"
"MediaSize" => 374819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-4cc663010c16d0dce468df5c351651bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932856_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/adac9cfaa035027268879624aec61e4c.webp"
"MediaSize" => 463475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-adac9cfaa035027268879624aec61e4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932856_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/c8c717badf0bc23befd3a74a48901162.webp"
"MediaSize" => 334827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-c8c717badf0bc23befd3a74a48901162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932856_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/51fc07e4a021d028fa071008f4f1a705.webp"
"MediaSize" => 462466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-51fc07e4a021d028fa071008f4f1a705.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932856_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/069ad06d17a4301ebaa06d0c68b0d497.webp"
"MediaSize" => 283745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-069ad06d17a4301ebaa06d0c68b0d497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932856_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/6acdd41a3cfb453b6bcca5868a425fd0.webp"
"MediaSize" => 225934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-6acdd41a3cfb453b6bcca5868a425fd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932856_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/243662630e9e482b5f7bcbe0b480fcb3.webp"
"MediaSize" => 134544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-243662630e9e482b5f7bcbe0b480fcb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932856_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/b824dc61012fdb672f6bb99ffc159034.webp"
"MediaSize" => 158237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-b824dc61012fdb672f6bb99ffc159034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932856_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/0b523b20c6a98be014e420790400fa58.webp"
"MediaSize" => 205402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-0b523b20c6a98be014e420790400fa58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932856_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/e337bd71c3026c6b5a8fc78700d72861.webp"
"MediaSize" => 128466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-e337bd71c3026c6b5a8fc78700d72861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932856_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/0aff06f34a6403e960bf84e575b43693.webp"
"MediaSize" => 171152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-0aff06f34a6403e960bf84e575b43693.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932856_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/69500ef8d875a0adcffe93f5ad46debb.webp"
"MediaSize" => 117885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-69500ef8d875a0adcffe93f5ad46debb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932856_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/c67212e28f61519b96c89e5f4589a35f.webp"
"MediaSize" => 153136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-c67212e28f61519b96c89e5f4589a35f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932856_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/0f0db7cb7573c46b0a50909ba727d61c.webp"
"MediaSize" => 197899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-0f0db7cb7573c46b0a50909ba727d61c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932856_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/267bcf920c1ede9324377d195263a38a.webp"
"MediaSize" => 178302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-267bcf920c1ede9324377d195263a38a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932856_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/d642dc6dd3ea61bed21dc8309e30ecdf.webp"
"MediaSize" => 153740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-d642dc6dd3ea61bed21dc8309e30ecdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932856_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/415ebb70b5657cebb1baee9761fb7d7e.webp"
"MediaSize" => 112505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-415ebb70b5657cebb1baee9761fb7d7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29932856_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/9c1d43c23e701d47d6d8cb7773024c71.webp"
"MediaSize" => 88135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-9c1d43c23e701d47d6d8cb7773024c71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29932856_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/689298d5ef9face1fd4d8db161f70ddd.webp"
"MediaSize" => 82777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-689298d5ef9face1fd4d8db161f70ddd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29932856_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/e003017e830d6f7e79aa0ea1b6cbea01.webp"
"MediaSize" => 89629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-e003017e830d6f7e79aa0ea1b6cbea01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29932856_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/c8c5b85f01c19d6c9126d4580be2d82f.webp"
"MediaSize" => 310693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-c8c5b85f01c19d6c9126d4580be2d82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29932856_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/4dce15aadc7c1d9bc8a6538f1f48f96b.webp"
"MediaSize" => 297283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-4dce15aadc7c1d9bc8a6538f1f48f96b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29932856_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/c93904b30b2e340ba1c1726cd943b78d.webp"
"MediaSize" => 305496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-c93904b30b2e340ba1c1726cd943b78d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29932856_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/f8b2caef6672d9860cc2259a252676ef.webp"
"MediaSize" => 277631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-f8b2caef6672d9860cc2259a252676ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29932856_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/0387afd5b595aef9e8121ea9880e65df.webp"
"MediaSize" => 268935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-0387afd5b595aef9e8121ea9880e65df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29932856_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/4b3d34016a8d6feee712201c026bc30a.webp"
"MediaSize" => 250528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-4b3d34016a8d6feee712201c026bc30a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29932856_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/130584186ae238dc6250a553a91af636.webp"
"MediaSize" => 291383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-130584186ae238dc6250a553a91af636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29932856_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/d8e7f8efc8282a1a68d3103b80884444.webp"
"MediaSize" => 285692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-d8e7f8efc8282a1a68d3103b80884444.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29932856_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/7693b4d56d37eedac14b3fb1f79b7109.webp"
"MediaSize" => 288017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-7693b4d56d37eedac14b3fb1f79b7109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29932856_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/41a3f68e0f609e945f634253c8163060.webp"
"MediaSize" => 229146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-41a3f68e0f609e945f634253c8163060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29932856_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/af3c1249c80dd0c2394c4ceced75f906.webp"
"MediaSize" => 192774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-af3c1249c80dd0c2394c4ceced75f906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29932856_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/8fa6280a70f72d58224293500181a9f1.webp"
"MediaSize" => 178831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-8fa6280a70f72d58224293500181a9f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29932856_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/6e1def500ecf093273674136df2e6c47.webp"
"MediaSize" => 243468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-6e1def500ecf093273674136df2e6c47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29932856_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/9aba2c238d5fd9e7092c2bc560e134e7.webp"
"MediaSize" => 255080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-9aba2c238d5fd9e7092c2bc560e134e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29932856_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/841f3416d94d0ff0a15c6916593dd06e.webp"
"MediaSize" => 266057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-841f3416d94d0ff0a15c6916593dd06e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29932856_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932856/37384ce99295296c3d1754574cc0e2fc.webp"
"MediaSize" => 315618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932856/thumbnail-37384ce99295296c3d1754574cc0e2fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470720"
"ResourceRecordKey" => "29932856"
"ModificationTimestamp" => "2026-06-20T14:17:13.58Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932856')"
+"ID": "1551552"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+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"
…5
]
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/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 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932555')"
+"ID": "1551131"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1549969"
+post_author: 1
+"ListingKey": "29931019"
+"ListingId": "X13468988"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:10:05Z"
+"RFModificationTimestamp": "2026-06-19T22:47:51Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "B02 - 269 SUNVIEW STREET, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.534484
1 => 43.475063
]
+"Latitude": 43.475063
+"Longitude": -80.534484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62650)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:47:41.836982+00:00"
+"Directions": "Cross Streets: University Ave W. ** Directions: University Ave W to Sunview St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1973790"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:55:55Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:55Z"
+"StreetName": "Sunview"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2562"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931019/b02-269-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Millcreek Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T20:55:55.74Z"
+"ListAgentNationalAssociationId": "1260583"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:9 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931019')"
+"ID": "1549969"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1549411"
+post_author: 1
+"ListingKey": "29930552"
+"ListingId": "40841564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:32:38Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 555.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "269 SUNVIEW Street Unit# B02, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.5339078
1 => 43.4744488
]
+"Latitude": 43.4744488
+"Longitude": -80.5339078
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62783)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:32:32.417467+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:51:09Z"
+"Stories": "6.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2562"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930552/269-sunview-street-unit-b02-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 555
+"OriginalEntryTimestamp": "2026-06-19T19:51:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1066259"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:9 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930552')"
+"ID": "1549411"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1549970"
+post_author: 1
+"ListingKey": "29930812"
+"ListingId": "X13468830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:55:03Z"
+"RFModificationTimestamp": "2026-06-19T21:21:35Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "F 103 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.531342
1 => 43.477165
]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and exceptionally well-maintained 1-bedroom, 1-bathroom main floor condo, offering convenience, comfort, and investment potential! This fully furnished unit features stainless steel appliances, ensuite laundry, high ceilings, new light fixtures, and a spacious, bright layout. The primary bedroom comes complete with a **bed, mattress, nightstand, study desk, and chair**, while the living area includes a **sofa, coffee table, TV with TV stand, and a dining table with 2 chairs** - making it truly move-in or rental ready. Enjoy the added convenience of a second exit door from the living room, visitor parking, and a vacant unit with immediate occupancy available. The unit has been professionally deep cleaned and is ready for its next owner. Located within walking distance to Wilfrid Laurier University, University of Waterloo, Conestoga College(Waterloo Campus) with shops, bus stops, and everyday amenities nearby, this property is ideal for students, young professionals, or investors. A full-service property management option is available, offering assistance with tenant placement and complete property management for a hassle-free investment experience. A fantastic opportunity for investors or end-users alike! Few pictures virtually staged. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
]
+"AssociationFee": "265.91"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:21:23.615114+00:00"
+"Directions": "Cross Streets: University Ave E & Albert St. ** Directions: From University Avenue, head north on Hemlock Street. Continue past Balsam Street; the building will be on your Right."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982697"
+"ListOfficeKey": "293626"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:27:05Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:27:05Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2041"
+"VirtualTourURLUnbranded": "https://propertyvision.ca/tour/17311"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29930812/f-103-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Management Corporation"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T20:27:05.03Z"
+"ListAgentNationalAssociationId": "1267765"
+"ListOfficeNationalAssociationId": "1429393"
+"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('29930812')"
+"ID": "1549970"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1548833"
+post_author: 1
+"ListingKey": "29930060"
+"ListingId": "40841513"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:10:08Z"
+"RFModificationTimestamp": "2026-06-19T20:32:53Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 349.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "257 HEMLOCK Street Unit# 215, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.5321025
1 => 43.4757935
]
+"Latitude": 43.4757935
+"Longitude": -80.5321025
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The smartest dorm room alternative in Waterloo. Whether you’re a parent looking for a secure, four-year housing solution for your student or an investor seeking a turnkey asset in Waterloo’s university core, Unit 215 at Sage X makes the math simple. Located literally steps from both Wilfrid Laurier University and the University of Waterloo, this modern bachelor-style suite was designed for student life. The layout is compact, highly functional, and completely move-in ready. It features an open-concept living space with floor-to-ceiling windows, a galley kitchen with quartz countertops and stainless steel appliances, and the ultimate student luxury: in-suite laundry. Beyond the unit, the building operates like a modern campus hub. Students have access to a dedicated fitness centre, study lounges, and a rooftop terrace. Better yet, the condo fees are highly inclusive, covering heat, water, central A/C, and high-speed fibre internet. You only pay for hydro. For investors and parents, the financials are just as attractive. It’s secure, it’s modern, and it’s exactly where students want to be. Secure their housing for the next four years and build equity while they study, with the option to keep it as a performing rental later. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "309.82"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:32:45.784486+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T18:50:44Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T18:50:44Z"
+"Stories": "1.0"
+"StreetName": "HEMLOCK"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2206"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/215_257_hemlock_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930060/257-hemlock-street-unit-215-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "NMU6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 349
+"OriginalEntryTimestamp": "2026-06-19T18:50:44.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930060')"
+"ID": "1548833"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1548416"
+post_author: 1
+"ListingKey": "29929082"
+"ListingId": "X13467464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:45:04Z"
+"RFModificationTimestamp": "2026-06-19T19:34:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L2"
+"UnparsedAddress": "285 THORNCREST DRIVE, Waterloo, Ontario N2L4L2"
+"Coordinates": array:2 [
0 => -80.5537455
1 => 43.4829243
]
+"Latitude": 43.4829243
+"Longitude": -80.5537455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Investors dream and ideal family home in a highly sought-after, family-friendly Waterloo neighborhood! Welcome to 285 Thorncrest Drive a spacious side-split situated on a deep lot with tranquil curb appeal and parking for up to 8 vehicles. This versatile home offers 6 bedrooms and 2 full bathrooms, making it perfect for large families, multigenerational living, or investors seeking strong rental income potential. The main level features hardwood flooring, a spacious open-concept living and dining area, and a walkout to the private backyard. A bright and functional kitchen serves as the heart of the home. You'll also find 3 well-sized bedrooms, a 4-piece bathroom, laundry on the main floor, and plenty of natural light throughout. The finished basement with a separate walk-up entrance offers 3 additional Rooms, a cozy living area, a second full bath, dedicated laundry, and a flexible layout that lends itself perfectly to an in-law suite or future legal duplex (buyer to verify with the city).Enjoy a private, fully fenced backyard with mature trees, perfect for outdoor relaxation and entertaining. All of this in a quiet, family-oriented neighborhood close to top-rated schools, the University of Waterloo, Wilfrid Laurier University, Conestoga College, shopping, public transit, and Laurel Creek Conservation Area. Don't miss this unique opportunity to own a turn-key property in one of Waterloos most desirable locations! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:34:14.923364+00:00"
+"Directions": "Canewood cres./thorncrest dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027523"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Wooded area"
]
+"LotSizeDimensions": "60 x 111 FT ; 59.98 ft x 111.48 ft x 93.67ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T16:59:21Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:59:21Z"
+"StreetName": "Thorncrest"
+"StreetNumber": "285"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4685"
+"VirtualTourURLUnbranded": "https://youtu.be/lBZKGuyQ3ig"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Cistern"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929082/285-thorncrest-drive-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2016236"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283291"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-19T16:59:21.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306909"
+"ListOfficeNationalAssociationId": "1326174"
+"CoListAgentNationalAssociationId": "1297487"
+"CoListOfficeNationalAssociationId": "1326174"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1547613"
+post_author: 1
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T17:50:02Z"
+"RFModificationTimestamp": "2026-06-20T17:54:43Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4G1"
+"UnparsedAddress": "513 WEBER Street N Unit# B, Waterloo, Ontario N2L4G1"
+"Coordinates": array:2 [
0 => -80.5393879
1 => 43.4918568
]
+"Latitude": 43.4918568
+"Longitude": -80.5393879
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful condo townhome in an ideal location. This 2 story, one bathroom home features an open concept dining / living room with a sliding glass door to your brick patio and walking trail along the creek and park. The outdoor pool is fantastic for families to cool off in the summer! Upstairs you'll find 2 bedrooms, with a very spacious primary room and a 4 piece bath. The finished basement is great extra space with a rec room and home gym, office or crafts area. The wall split heating/cooling units offer consistent heating and cooling throughout the home plus a cozy gas fireplace in the living room when you want some extra ambiance. Located close to universities, shopping, public transit and the expressway, this is a great opportunity for young families to get into the housing market or for investors looking to add to their portfolio. Call today for a private showing! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "419.79"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:2 [
0 => "Wall unit"
1 => "Ductless"
]
+"CreationDate": "2026-06-19T16:49:27.120667+00:00"
+"Directions": "Turn south off Weber St N"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993299"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T15:32:23Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T17:40:19Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "WEBER"
+"StreetNumber": "513"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2606.72"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/b_513_weber_st_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928209/513-weber-street-n-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1110
+"BelowGradeFinishedArea": 298
+"OriginalEntryTimestamp": "2026-06-19T15:32:23.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1276434"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928209')"
+"ID": "1547613"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1547614"
+post_author: 1
+"ListingKey": "29927265"
+"ListingId": "X13465672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T13:45:08Z"
+"RFModificationTimestamp": "2026-06-19T16:29:19Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "201 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 145 Society Condos, an exceptional opportunity in the heart of Waterloo's vibrant University District. This beautifully appointed, fully furnished 1+1 bedroom, 1 bathroom suite offers turnkey living for first-time buyers, students, professionals, and savvy investors alike. Perfectly positioned on the same floor as the building's impressive amenity level, this sought-after suite boasts rare 10-foot ceilings-a feature not found in most other units within the building. The added ceiling height creates an airy, open feel while providing unparalleled convenience with premium amenities just steps from your door. Designed for modern living, the sun-filled open-concept layout showcases floor-to-ceiling windows, a sleek contemporary kitchen with Energy Star appliances, granite countertops and backsplash, soft-close cabinetry, custom millwork, and LED lighting throughout. Residents enjoy access to an outstanding collection of amenities, including a state-of-the-art fitness centre, basketball court, sauna, yoga studio, media and games rooms, party lounge, rooftop terrace, 24-hour security, and even an on-site Starbucks. Ideally located directly across from the University of Waterloo and just minutes from Wilfrid Laurier University, Uptown Waterloo, shopping, restaurants, and the ION LRT, this is urban condo living at its finest in one of Waterloo's most desirable locations. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "275"
+"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:29:17.032906+00:00"
+"Directions": "Phillips St & Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129982"
+"ListOfficeKey": "279541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T13:15:16Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T13:15:16Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3294.2"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29927265/201-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T13:15:16.29Z"
+"ListAgentNationalAssociationId": "1383017"
+"ListOfficeNationalAssociationId": "1305599"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927265')"
+"ID": "1547614"
}
]
+success: true
+page_size: 9
+page_count: 34
+count: 303
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]