array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29928209 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: "1547613"
+post_author: 1
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:50:02Z"
+"RFModificationTimestamp": "2026-06-19T16:49:30Z"
+"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-19T15:32:23Z"
+"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 [
"RoomKey" => "1663017183"
"RoomType" => "Laundry room"
"ListingId" => "40840623"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.11Z"
]
1 => array:11 [
"RoomKey" => "1663017184"
"RoomType" => "Recreation room"
"ListingId" => "40840623"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 28'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
2 => array:11 [
"RoomKey" => "1663017185"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840623"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
3 => array:11 [
"RoomKey" => "1663017186"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840623"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
4 => array:11 [
"RoomKey" => "1663017187"
"RoomType" => "Bedroom"
"ListingId" => "40840623"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
5 => array:11 [
"RoomKey" => "1663017188"
"RoomType" => "Living room"
"ListingId" => "40840623"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
6 => array:11 [
"RoomKey" => "1663017189"
"RoomType" => "Dining room"
"ListingId" => "40840623"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.12Z"
]
7 => array:11 [
"RoomKey" => "1663017190"
"RoomType" => "Kitchen"
"ListingId" => "40840623"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928209"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:23.13Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29928209_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/22e7119eac32fbc37af3e3fed425474e.webp"
"MediaSize" => 148393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-22e7119eac32fbc37af3e3fed425474e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928209_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/285f4e21497001c56c641d9c15970aab.webp"
"MediaSize" => 138878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-285f4e21497001c56c641d9c15970aab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928209_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/0261ddb7e2b55cbdf5c17e48bb724a06.webp"
"MediaSize" => 51750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-0261ddb7e2b55cbdf5c17e48bb724a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928209_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/03703955de9c69dd6407ebd31ee70263.webp"
"MediaSize" => 76393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-03703955de9c69dd6407ebd31ee70263.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928209_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/810767669359cb7d110f095908d40e3f.webp"
"MediaSize" => 78425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-810767669359cb7d110f095908d40e3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928209_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/eae68768241fbb107ac5f7431917b5bc.webp"
"MediaSize" => 85828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-eae68768241fbb107ac5f7431917b5bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928209_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/50f5dea74c41e16bd0cdd8a9435deefa.webp"
"MediaSize" => 86299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-50f5dea74c41e16bd0cdd8a9435deefa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928209_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/3d5592e0586a0cd6a815fa713fc2900c.webp"
"MediaSize" => 168719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-3d5592e0586a0cd6a815fa713fc2900c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928209_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/6ba1a9a99cfb1bb80d7ef6105a950368.webp"
"MediaSize" => 137693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-6ba1a9a99cfb1bb80d7ef6105a950368.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928209_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/3b7d6ff7ff79cb5634c10d633fe17eec.webp"
"MediaSize" => 79072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-3b7d6ff7ff79cb5634c10d633fe17eec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928209_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/4d080a3ce64eaed44862ec061eb28928.webp"
"MediaSize" => 74763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-4d080a3ce64eaed44862ec061eb28928.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928209_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/6f15b54064584eca5c831c322286f201.webp"
"MediaSize" => 77146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-6f15b54064584eca5c831c322286f201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928209_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/03d6eddafcd08fb83c471542d36035ff.webp"
"MediaSize" => 58696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-03d6eddafcd08fb83c471542d36035ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928209_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/986d4d7dbfb99c11c405b3ae731d839c.webp"
"MediaSize" => 78629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-986d4d7dbfb99c11c405b3ae731d839c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928209_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/a72559ce33aaf2ead07a9408f273339d.webp"
"MediaSize" => 56512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-a72559ce33aaf2ead07a9408f273339d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928209_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/69bee76686b4fe7a592c319f7c2a511f.webp"
"MediaSize" => 72905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-69bee76686b4fe7a592c319f7c2a511f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928209_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/e8915d9091ca94e05df34f861e0ab8aa.webp"
"MediaSize" => 47942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-e8915d9091ca94e05df34f861e0ab8aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928209_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/1c2cf987fdd4b1531afccd67d9a2e882.webp"
"MediaSize" => 74852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-1c2cf987fdd4b1531afccd67d9a2e882.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928209_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/36b5349fc521c4849045f5e9d597245e.webp"
"MediaSize" => 71182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-36b5349fc521c4849045f5e9d597245e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29928209_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/a85b50ff0535cc3d404bae33666410bb.webp"
"MediaSize" => 60861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-a85b50ff0535cc3d404bae33666410bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29928209_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/ddd0a33425d18e086cc31699839d70ec.webp"
"MediaSize" => 69637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-ddd0a33425d18e086cc31699839d70ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29928209_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/39417df6478bef26ac10ea655f81906f.webp"
"MediaSize" => 53438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-39417df6478bef26ac10ea655f81906f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29928209_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/bdb5bc8ac95450bef0128333d497b17e.webp"
"MediaSize" => 65541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-bdb5bc8ac95450bef0128333d497b17e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29928209_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/5007a7f4726c73ef25f2fdc58d56a3e4.webp"
"MediaSize" => 52885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-5007a7f4726c73ef25f2fdc58d56a3e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29928209_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/b3c2e65265be5e00420f0023a5b0c9b0.webp"
"MediaSize" => 68979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-b3c2e65265be5e00420f0023a5b0c9b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29928209_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/6c911baae623aa06ae36fe76b1e16f65.webp"
"MediaSize" => 78703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-6c911baae623aa06ae36fe76b1e16f65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29928209_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/10bfac627758d911d9cd195d5553dd9d.webp"
"MediaSize" => 89442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-10bfac627758d911d9cd195d5553dd9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29928209_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/6be490a1922ed045051f01ec2f353c0c.webp"
"MediaSize" => 73008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-6be490a1922ed045051f01ec2f353c0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29928209_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/96e7059b58e6fff63c7bcf14cd3fed13.webp"
"MediaSize" => 75772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-96e7059b58e6fff63c7bcf14cd3fed13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29928209_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/827d50604a6b01c168bbbdef46729c61.webp"
"MediaSize" => 110612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-827d50604a6b01c168bbbdef46729c61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29928209_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/51e932c10802228897fab698c5b1ee16.webp"
"MediaSize" => 131872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-51e932c10802228897fab698c5b1ee16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29928209_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/067665c29c86feb2f6f21d30505f3ed3.webp"
"MediaSize" => 182746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-067665c29c86feb2f6f21d30505f3ed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29928209_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/9b390a6cee395061d0b7510319ded4e7.webp"
"MediaSize" => 153639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-9b390a6cee395061d0b7510319ded4e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29928209_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/3c5914c10b7772e2ad9c9352f11b65cd.webp"
"MediaSize" => 148533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-3c5914c10b7772e2ad9c9352f11b65cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29928209_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/b038f312d38d1130d1e854bbd73bd8d5.webp"
"MediaSize" => 175983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-b038f312d38d1130d1e854bbd73bd8d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29928209_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/0f396d7834ab903e19cda68fac32cb3d.webp"
"MediaSize" => 177005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-0f396d7834ab903e19cda68fac32cb3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29928209_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/a96fbfea431a591012877d37be16abc3.webp"
"MediaSize" => 149589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-a96fbfea431a591012877d37be16abc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29928209_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/22885cd8501a887a777012991e73eb3c.webp"
"MediaSize" => 150798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-22885cd8501a887a777012991e73eb3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29928209_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928209/b57d8b12733fa15099f2575f88906a42.webp"
"MediaSize" => 139140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928209/thumbnail-b57d8b12733fa15099f2575f88906a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840623"
"ResourceRecordKey" => "29928209"
"ModificationTimestamp" => "2026-06-19T15:32:23.09Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928209')"
+"ID": "1547613"
}
]
+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 299554" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24907
+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 1993299" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24880
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29928209'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25218
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29928209'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31550923"
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T12:00:00Z"
+"OpenHouseEndTime": "2026-06-20T13:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T04:40:42Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31550923')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31550922"
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T04:40:42Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31550922')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29928209' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5393879 43.4918568)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25311
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1551131"
+post_author: 1
+"ListingKey": "29932555"
+"ListingId": "X13470380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T04:25:12Z"
+"RFModificationTimestamp": "2026-06-20T05:34:29Z"
+"ListPrice": 760000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "806 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261878
1 => 43.4782103
]
+"Latitude": 43.4782103
+"Longitude": -80.5261878
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great investment opportunity in huge 5 bedrooms and 5 bathrooms luxury suite in high rise condominium building. 8 Hickory Street West is a high-end student condo building located within walking distance to the University of Waterloo, Wilfrid Laurier University, restaurants, shopping &situated right on the LRT route. Unit 806 has a total of 2077 SQFT living space and one underground parking space. It features 5 large bedrooms, 5 full bathrooms, 9 ft ceilings, open concept layout, in-suit laundry, modern kitchen with stainless steel appliances, granite countertops, and central island, and overlooks spacious living room. Amazing unobstructed city view through the balcony. Furnished. Internet is included. (id:62783)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"AssociationFee": "924.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T05:34:17.704632+00:00"
+"Directions": "Cross Streets: King Street to Hickory. ** Directions: Hickory St W/King St N."
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959006"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-20T04:17:51Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T04:17:51Z"
+"StreetDirSuffix": "West"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7604"
+"View": "City view"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1663597932"
"RoomType" => "Living room"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29932555"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
1 => array:11 [
"RoomKey" => "1663597933"
"RoomType" => "Dining room"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29932555"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
2 => array:11 [
"RoomKey" => "1663597934"
"RoomType" => "Kitchen"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 4.44
"ListingKey" => "29932555"
"RoomLength" => 4.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
3 => array:11 [
"RoomKey" => "1663597935"
"RoomType" => "Bedroom"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29932555"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
4 => array:11 [
"RoomKey" => "1663597936"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29932555"
"RoomLength" => 7.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
5 => array:11 [
"RoomKey" => "1663597937"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "29932555"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
6 => array:11 [
"RoomKey" => "1663597938"
"RoomType" => "Bedroom 4"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29932555"
"RoomLength" => 7.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
7 => array:11 [
"RoomKey" => "1663597939"
"RoomType" => "Bedroom 5"
"ListingId" => "X13470380"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29932555"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T04:17:51.66Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932555/806-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-20T04:17:51.62Z"
+"ListAgentNationalAssociationId": "1249681"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932555_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/b1523883d7199d3ef5419334fd1da487.webp"
"MediaSize" => 279932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-b1523883d7199d3ef5419334fd1da487.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932555_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/c3ec9bcbf0e2cc41a5ba06382634d352.webp"
"MediaSize" => 312776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-c3ec9bcbf0e2cc41a5ba06382634d352.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932555_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/dd27a00e0e6b99b4ebab180432135b6d.webp"
"MediaSize" => 205523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-dd27a00e0e6b99b4ebab180432135b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932555_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/da9fd378e966d85e534af05933033f7e.webp"
"MediaSize" => 169009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-da9fd378e966d85e534af05933033f7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932555_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/6ef82bd9caf1bc825fdfd34e075a49de.webp"
"MediaSize" => 103690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-6ef82bd9caf1bc825fdfd34e075a49de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932555_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/5cc3b65954702b24d58398eff40f92a3.webp"
"MediaSize" => 168326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-5cc3b65954702b24d58398eff40f92a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932555_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a4e10fbebde7e3897f362e5177bc189f.webp"
"MediaSize" => 157246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a4e10fbebde7e3897f362e5177bc189f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932555_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a8447ad4c33a590fce686383b9b3a672.webp"
"MediaSize" => 148946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a8447ad4c33a590fce686383b9b3a672.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932555_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/9cc48d8816c682adcfedb3f6ba7fb9b2.webp"
"MediaSize" => 279768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-9cc48d8816c682adcfedb3f6ba7fb9b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932555_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/fa93f8f09e88d1678457c6e52ad51c36.webp"
"MediaSize" => 151126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-fa93f8f09e88d1678457c6e52ad51c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932555_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/a51931232d153723c502d081f3952edd.webp"
"MediaSize" => 148104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-a51931232d153723c502d081f3952edd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932555_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/09ef81a690d2b78e6c40c183797c0441.webp"
"MediaSize" => 229106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-09ef81a690d2b78e6c40c183797c0441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932555_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/ee6e00261847f3b7536fab11dcbbb012.webp"
"MediaSize" => 116742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-ee6e00261847f3b7536fab11dcbbb012.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932555_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/68e8ed5ac633ef6a95aa577c26bf55c2.webp"
"MediaSize" => 221320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-68e8ed5ac633ef6a95aa577c26bf55c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932555_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/cdac809c62f02e004429f0fa23163bb8.webp"
"MediaSize" => 102757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-cdac809c62f02e004429f0fa23163bb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932555_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/0c870780e316bef1220d5a2bad2c7bf3.webp"
"MediaSize" => 115102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-0c870780e316bef1220d5a2bad2c7bf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932555_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/1b02813c60a53518305acd0d89afa9eb.webp"
"MediaSize" => 179873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-1b02813c60a53518305acd0d89afa9eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29932555_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/e2b36fdf48944fc2dc40f92a86eb75fa.webp"
"MediaSize" => 262695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-e2b36fdf48944fc2dc40f92a86eb75fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29932555_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/478f3eed12e6c81393f278f4fe703031.webp"
"MediaSize" => 180915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-478f3eed12e6c81393f278f4fe703031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29932555_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/f6b71c8b82fe621f45c99b1a94121f78.webp"
"MediaSize" => 210157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-f6b71c8b82fe621f45c99b1a94121f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29932555_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932555/16bb7464586dd88601ce0f1cc3337f4b.webp"
"MediaSize" => 224526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932555/thumbnail-16bb7464586dd88601ce0f1cc3337f4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470380"
"ResourceRecordKey" => "29932555"
"ModificationTimestamp" => "2026-06-20T04:17:51.63Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932555')"
+"ID": "1551131"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1549969"
+post_author: 1
+"ListingKey": "29931019"
+"ListingId": "X13468988"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:10:05Z"
+"RFModificationTimestamp": "2026-06-19T22:47:51Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "B02 - 269 SUNVIEW STREET, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.534484
1 => 43.475063
]
+"Latitude": 43.475063
+"Longitude": -80.534484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62650)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:47:41.836982+00:00"
+"Directions": "Cross Streets: University Ave W. ** Directions: University Ave W to Sunview St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1973790"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:55:55Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:55Z"
+"StreetName": "Sunview"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2562"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1663282517"
"RoomType" => "Kitchen"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 1.19
"ListingKey" => "29931019"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
1 => array:11 [
"RoomKey" => "1663282518"
"RoomType" => "Living room"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 7.54
"ListingKey" => "29931019"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
2 => array:11 [
"RoomKey" => "1663282519"
"RoomType" => "Den"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29931019"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
3 => array:11 [
"RoomKey" => "1663282520"
"RoomType" => "Bedroom"
"ListingId" => "X13468988"
"RoomLevel" => "Main level"
"RoomWidth" => 4.04
"ListingKey" => "29931019"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T20:55:55.79Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931019/b02-269-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Millcreek Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T20:55:55.74Z"
+"ListAgentNationalAssociationId": "1260583"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:9 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931019_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/33d424a2aa88fa418529f57e8a068675.webp"
"MediaSize" => 259952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-33d424a2aa88fa418529f57e8a068675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931019_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/08f8bbda8d2d88c3f61a908f654ad24b.webp"
"MediaSize" => 19874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-08f8bbda8d2d88c3f61a908f654ad24b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931019_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/16f41e1fcf07c4b20a7b2c339d6f7840.webp"
"MediaSize" => 19762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-16f41e1fcf07c4b20a7b2c339d6f7840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931019_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/636bdc116826293293fc873b1ac1b02b.webp"
"MediaSize" => 29151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-636bdc116826293293fc873b1ac1b02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931019_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/45f8014d9e62b7e75c02bfb4deb8fb0e.webp"
"MediaSize" => 19641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-45f8014d9e62b7e75c02bfb4deb8fb0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931019_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/d9121a606e90aa99016331d9e060ba6f.webp"
"MediaSize" => 19356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-d9121a606e90aa99016331d9e060ba6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931019_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/77c7df04ae8ebbbf04d7e64655e5c0b3.webp"
"MediaSize" => 21689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-77c7df04ae8ebbbf04d7e64655e5c0b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931019_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/ba428d9fafe697dec8e70a00f284618b.webp"
"MediaSize" => 23291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-ba428d9fafe697dec8e70a00f284618b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931019_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931019/fbeebb6a7cba88cd6b751da7719c933d.webp"
"MediaSize" => 25264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931019/thumbnail-fbeebb6a7cba88cd6b751da7719c933d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468988"
"ResourceRecordKey" => "29931019"
"ModificationTimestamp" => "2026-06-19T20:55:55.75Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931019')"
+"ID": "1549969"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1549411"
+post_author: 1
+"ListingKey": "29930552"
+"ListingId": "40841564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:32:38Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 555.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "269 SUNVIEW Street Unit# B02, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.5339078
1 => 43.4744488
]
+"Latitude": 43.4744488
+"Longitude": -80.5339078
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62783)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:32:32.417467+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:51:09Z"
+"Stories": "6.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2562"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663230729"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841564"
…8
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930552')"
+"ID": "1549411"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930812')"
+"ID": "1549970"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930060')"
+"ID": "1548833"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927265')"
+"ID": "1547614"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1544216"
+post_author: 1
+"ListingKey": "29923621"
+"ListingId": "X13462684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:40:16Z"
+"RFModificationTimestamp": "2026-06-18T20:53:32Z"
+"ListPrice": 389900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "505 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.5358387
1 => 43.4756874
]
+"Latitude": 43.4756874
+"Longitude": -80.5358387
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Vacant, ONE BEDROOM + DEN condo featuring an oversized BALCONY and ONE UNDERGROUND PARKING SPACE! Welcome to the contemporary Sage V Condos, ideally located just steps from both the University of Waterloo and Wilfrid Laurier University, with restaurants, shopping, transit, and everyday amenities right at your doorstep. This beautifully maintained suite offers a spacious open-concept layout designed for comfortable living and entertaining. The modern kitchen features granite countertops, stainless steel appliances, a large island, and plenty of storage space. The bright living area opens onto an oversized private balcony overlooking Hickory Street, offering impressive views of Waterloo. The generous primary bedroom includes ample closet space and its own sliding door with direct balcony access. A separate den provides the perfect space for a home office, study area, or overnight guests, while the updated four-piece bathroom is conveniently located nearby. In-suite laundry adds to the everyday convenience. Included with the unit are the stylish furnishings shown, making this a true turnkey opportunity. Residents enjoy access to excellent building amenities, including a two-storey study lounge, fitness centre, and outdoor terrace. The condo fees even include internet service, water and gas, for added value. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "439.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:29:38.119565+00:00"
+"Directions": "Cross Streets: University Ave. ** Directions: University Ave to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213582"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:10Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:33:19Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3494.71"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LNHnwTjDP5n&mls=1"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923621/505-280-lester-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "RN-8"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T18:33:10.72Z"
+"ListAgentNationalAssociationId": "1459405"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923621')"
+"ID": "1544216"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1543975"
+post_author: 1
+"ListingKey": "29923250"
+"ListingId": "40840457"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:04:46Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 860.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "275 LARCH Street Unit# G105, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.5322577
1 => 43.4767325
]
+"Latitude": 43.4767325
+"Longitude": -80.5322577
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit G105 at 275 Larch Street, a fully furnished 1 bedroom + spacious enclosed den, 2 bathroom condo in the heart of Waterloo's highly sought after University District. Offering 860 sq. ft. of bright, modern living space, this turnkey unit features soaring ceilings, oversized windows, quartz countertops, stainless steel appliances, in suite laundry, and durable flooring throughout. The spacious enclosed den provides exceptional flexibility for a home office, study area, guest space, or additional living area. Thoughtfully furnished with two beds, a sofa, TV, dining set, and storage pieces, this move in ready condo is ideal for first time buyers, parents looking to invest for their student, or investors seeking a low maintenance property in a prime rental location. Building amenities include a fitness centre, yoga studio, rooftop terrace, secure bike storage, and visitor parking. Located just steps from Wilfrid Laurier University, the University of Waterloo, Conestoga College, the ION LRT, restaurants, shopping, and everyday amenities, this property offers unbeatable convenience and long term appeal. Condo fees include water, heat, parking, building insurance, and maintenance, helping to simplify ownership. A fantastic opportunity to own in one of Waterloo's most desirable and consistently in demand neighbourhoods. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "544"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Other, See Remarks"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:04:35.895972+00:00"
+"Directions": "Hickory St/Larch St"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240062"
+"ListOfficeKey": "280721"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-18T17:50:38Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:37Z"
+"Stories": "8.0"
+"StreetName": "LARCH"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2800"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923250/275-larch-street-unit-g105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1941951"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292877"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "NMU6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 860
+"OriginalEntryTimestamp": "2026-06-18T17:50:37.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1477987"
+"ListOfficeNationalAssociationId": "1316887"
+"CoListAgentNationalAssociationId": "1238606"
+"CoListOfficeNationalAssociationId": "1418791"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923250')"
+"ID": "1543975"
}
]
+success: true
+page_size: 9
+page_count: 32
+count: 282
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]