array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29927265 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: "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 [
"Order" => 1
"MediaKey" => "29927265_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/6eca24248805c92f5e5a6d1404f1aed7.webp"
"MediaSize" => 114047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-6eca24248805c92f5e5a6d1404f1aed7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29927265_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/0ea9f855eaac7b68ef5ba4cb378b30ec.webp"
"MediaSize" => 114919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-0ea9f855eaac7b68ef5ba4cb378b30ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29927265_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/783c4443f8127beb1248fb38b5cd0823.webp"
"MediaSize" => 107335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-783c4443f8127beb1248fb38b5cd0823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29927265_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/43ad3a9bc221876fe310d50f9562c55e.webp"
"MediaSize" => 93073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-43ad3a9bc221876fe310d50f9562c55e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29927265_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/e0ddf02d5ae7a3398dc5c837b153602f.webp"
"MediaSize" => 85545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-e0ddf02d5ae7a3398dc5c837b153602f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29927265_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/af95b963ae36b3363bc0c06bbfcec988.webp"
"MediaSize" => 115163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-af95b963ae36b3363bc0c06bbfcec988.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29927265_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/83268e384f35a9f8c1e77898a5a7c923.webp"
"MediaSize" => 111571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-83268e384f35a9f8c1e77898a5a7c923.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29927265_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/c47eaede3536d06701a093efaf1984dd.webp"
"MediaSize" => 113395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-c47eaede3536d06701a093efaf1984dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29927265_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/277036f624e2766c795996d16782d2c8.webp"
"MediaSize" => 84512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-277036f624e2766c795996d16782d2c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29927265_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/0041b6dd873b2fdee27c091bfd26b0e5.webp"
"MediaSize" => 101802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-0041b6dd873b2fdee27c091bfd26b0e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29927265_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/964abbfa7fdf653874d04f69fdacf60b.webp"
"MediaSize" => 73482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-964abbfa7fdf653874d04f69fdacf60b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29927265_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/04595236248d492a075a182f08664b7a.webp"
"MediaSize" => 98861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-04595236248d492a075a182f08664b7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29927265_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/6ecc60a6e3a4f385b947c5384fbe92ed.webp"
"MediaSize" => 84116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-6ecc60a6e3a4f385b947c5384fbe92ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29927265_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/04ccd22b7ddc97e92e497acd08cdeb5b.webp"
"MediaSize" => 133664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-04ccd22b7ddc97e92e497acd08cdeb5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29927265_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/577aa0d8fe28cfe7be0bb6dbc5c03f56.webp"
"MediaSize" => 132006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-577aa0d8fe28cfe7be0bb6dbc5c03f56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29927265_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/46ad1d19cb00f5be232f5f9aaaddc29c.webp"
"MediaSize" => 175123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-46ad1d19cb00f5be232f5f9aaaddc29c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29927265_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/348ddf5a754fa569d9f353afe8e44cf8.webp"
"MediaSize" => 117343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-348ddf5a754fa569d9f353afe8e44cf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29927265_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/7dde2ff474572ec3c999e05045f121b9.webp"
"MediaSize" => 120886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-7dde2ff474572ec3c999e05045f121b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29927265_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/98ce83e3b7d8697c27f2ad38897bc204.webp"
"MediaSize" => 127431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-98ce83e3b7d8697c27f2ad38897bc204.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29927265_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/6ee0c1b2ed4ec07131b298f7657f129b.webp"
"MediaSize" => 136925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-6ee0c1b2ed4ec07131b298f7657f129b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29927265_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927265/585da4c1aa87cb29498b2991ce990f71.webp"
"MediaSize" => 149961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927265/thumbnail-585da4c1aa87cb29498b2991ce990f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13465672"
"ResourceRecordKey" => "29927265"
"ModificationTimestamp" => "2026-06-19T13:15:16.29Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927265')"
+"ID": "1547614"
}
]
+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 279541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24866
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24867
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "279541"
+"ModificationTimestamp": "2025-12-08T22:53:45Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "279541"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('279541')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2129982" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24864
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29927265'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25161
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29927265'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29927265' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.538414 43.476791)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+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 {#25226
+post_id: "1550984"
+post_author: 1
+"ListingKey": "29932529"
+"ListingId": "X13470358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T03:55:21Z"
+"RFModificationTimestamp": "2026-06-20T04:33:11Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "304 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Motivated Seller! Welcome to 158 King Street North, ideally situated in the heart of uptownWaterloo-one of the most vibrant and rapidly growing areas in the region. This prime locationoffers unmatched convenience, with immediate access to everything you need for comfortableurban living.This spacious three-bedroom corner unit is designed to impress, featuring an abundance ofnatural light thanks to its oversized windows and desirable layout. The open-concept livingand dining area is enhanced by soaring 9-foot ceilings, creating a bright and airy atmosphereperfect for both relaxing and entertaining.The modern kitchen is equipped with custom cabinetry and sleek stainless steel appliances,combining style and functionality for everyday living. The unit also includes ensuite laundryfor added convenience, generously sized bedrooms that provide comfort and privacy, and twofull bathrooms designed with contemporary finishes.Located just steps away from Wilfrid Laurier University, the University of Waterloo, and theUniversity of Waterloo Technology Park, this property is perfectly positioned for students,professionals, and investors alike. You'll also enjoy close proximity to a wide variety ofshops, restaurants, and essential amenities, all within walking distance.This is a rare opportunity to own or invest in one of Canada's fastest-growing communities,making it an excellent choice for both long-term value and immediate lifestyle appeal. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "793.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T04:33:09.123982+00:00"
+"Directions": "KingStN/UniversityAve"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240165"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-20T03:46:10Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T03:46:10Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4301.4"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1663571058"
"RoomType" => "Dining room"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
1 => array:11 [
"RoomKey" => "1663571059"
"RoomType" => "Living room"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
2 => array:11 [
"RoomKey" => "1663571060"
"RoomType" => "Kitchen"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 5.49
"ListingKey" => "29932529"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
3 => array:11 [
"RoomKey" => "1663571061"
"RoomType" => "Bedroom"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
4 => array:11 [
"RoomKey" => "1663571062"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
5 => array:11 [
"RoomKey" => "1663571063"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470358"
"RoomLevel" => "Flat"
"RoomWidth" => 2.97
"ListingKey" => "29932529"
"RoomLength" => 2.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T03:46:10.49Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932529/304-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc."
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-20T03:46:10.46Z"
+"ListAgentNationalAssociationId": "1478211"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932529_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/787c71ba126a21354a3b14d12b7fd1f0.webp"
"MediaSize" => 122511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-787c71ba126a21354a3b14d12b7fd1f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932529_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/c588a2819617b647a00076991e16016a.webp"
"MediaSize" => 131658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-c588a2819617b647a00076991e16016a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932529_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/155e6e86294be2bc593cd0ba8d5a4c05.webp"
"MediaSize" => 131278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-155e6e86294be2bc593cd0ba8d5a4c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932529_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/b4e84befb216d5f9129e4d9812094243.webp"
"MediaSize" => 148206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-b4e84befb216d5f9129e4d9812094243.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932529_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/d775b9801f7c19953f06318cf4edbfe2.webp"
"MediaSize" => 139840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-d775b9801f7c19953f06318cf4edbfe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932529_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/80f8ea8719004f7066a607447eb97daf.webp"
"MediaSize" => 91472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-80f8ea8719004f7066a607447eb97daf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932529_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/48774b9410ae83c1b512f931de6c2b5f.webp"
"MediaSize" => 86805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-48774b9410ae83c1b512f931de6c2b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29932529_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/4e3b2e6ee4fe758d1b19e4935bc2d6df.webp"
"MediaSize" => 102091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-4e3b2e6ee4fe758d1b19e4935bc2d6df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29932529_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/9a0cefa5f2004a5172166b6c66e691a3.webp"
"MediaSize" => 95234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-9a0cefa5f2004a5172166b6c66e691a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29932529_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/60ccce7a7600ec1cc4d0de35dd8dc4e2.webp"
"MediaSize" => 85203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-60ccce7a7600ec1cc4d0de35dd8dc4e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29932529_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/94f52455ce1649e257256eaf72803555.webp"
"MediaSize" => 149489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-94f52455ce1649e257256eaf72803555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29932529_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/2120c2f9125d2baa0cdc8af4e4507597.webp"
"MediaSize" => 139496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-2120c2f9125d2baa0cdc8af4e4507597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29932529_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/bfe07e83e5eaf8519abd578b7ab0a7c7.webp"
"MediaSize" => 145734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-bfe07e83e5eaf8519abd578b7ab0a7c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29932529_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/92638f35227bb02c7e4d408690eea3a0.webp"
"MediaSize" => 99066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-92638f35227bb02c7e4d408690eea3a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29932529_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/6acd53fcfe4d92216237257d6b9bee7f.webp"
"MediaSize" => 88625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-6acd53fcfe4d92216237257d6b9bee7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29932529_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/8fe1e6567159720def954fc545d22ca0.webp"
"MediaSize" => 87679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-8fe1e6567159720def954fc545d22ca0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29932529_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932529/6ab45ddb9cf2cee7b28ef3896d6e9d7a.webp"
"MediaSize" => 85570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932529/thumbnail-6ab45ddb9cf2cee7b28ef3896d6e9d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470358"
"ResourceRecordKey" => "29932529"
"ModificationTimestamp" => "2026-06-20T03:46:10.47Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932529')"
+"ID": "1550984"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1549411"
+post_author: 1
+"ListingKey": "29930552"
+"ListingId": "40841564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:32:38Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 555.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "269 SUNVIEW Street Unit# B02, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.5339078
1 => 43.4744488
]
+"Latitude": 43.4744488
+"Longitude": -80.5339078
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62783)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:32:32.417467+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:51:09Z"
+"Stories": "6.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2562"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663230729"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
1 => array:11 [
"RoomKey" => "1663230730"
"RoomType" => "Bedroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
2 => array:11 [
"RoomKey" => "1663230731"
"RoomType" => "Den"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
3 => array:11 [
"RoomKey" => "1663230732"
"RoomType" => "Living room"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
…5
]
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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1548416"
+post_author: 1
+"ListingKey": "29929082"
+"ListingId": "X13467464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:45:04Z"
+"RFModificationTimestamp": "2026-06-19T19:34:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L2"
+"UnparsedAddress": "285 THORNCREST DRIVE, Waterloo, Ontario N2L4L2"
+"Coordinates": array:2 [
0 => -80.5537455
1 => 43.4829243
]
+"Latitude": 43.4829243
+"Longitude": -80.5537455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Investors dream and ideal family home in a highly sought-after, family-friendly Waterloo neighborhood! Welcome to 285 Thorncrest Drive a spacious side-split situated on a deep lot with tranquil curb appeal and parking for up to 8 vehicles. This versatile home offers 6 bedrooms and 2 full bathrooms, making it perfect for large families, multigenerational living, or investors seeking strong rental income potential. The main level features hardwood flooring, a spacious open-concept living and dining area, and a walkout to the private backyard. A bright and functional kitchen serves as the heart of the home. You'll also find 3 well-sized bedrooms, a 4-piece bathroom, laundry on the main floor, and plenty of natural light throughout. The finished basement with a separate walk-up entrance offers 3 additional Rooms, a cozy living area, a second full bath, dedicated laundry, and a flexible layout that lends itself perfectly to an in-law suite or future legal duplex (buyer to verify with the city).Enjoy a private, fully fenced backyard with mature trees, perfect for outdoor relaxation and entertaining. All of this in a quiet, family-oriented neighborhood close to top-rated schools, the University of Waterloo, Wilfrid Laurier University, Conestoga College, shopping, public transit, and Laurel Creek Conservation Area. Don't miss this unique opportunity to own a turn-key property in one of Waterloos most desirable locations! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:34:14.923364+00:00"
+"Directions": "Canewood cres./thorncrest dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027523"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Wooded area"
]
+"LotSizeDimensions": "60 x 111 FT ; 59.98 ft x 111.48 ft x 93.67ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T16:59:21Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:59:21Z"
+"StreetName": "Thorncrest"
+"StreetNumber": "285"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4685"
+"VirtualTourURLUnbranded": "https://youtu.be/lBZKGuyQ3ig"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Cistern"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929082/285-thorncrest-drive-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2016236"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283291"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-19T16:59:21.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306909"
+"ListOfficeNationalAssociationId": "1326174"
+"CoListAgentNationalAssociationId": "1297487"
+"CoListOfficeNationalAssociationId": "1326174"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928209/513-weber-street-n-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1110
+"BelowGradeFinishedArea": 298
+"OriginalEntryTimestamp": "2026-06-19T15:32:23.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1276434"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928209')"
+"ID": "1547613"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1547672"
+post_author: 1
+"ListingKey": "29928206"
+"ListingId": "40841235"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:55:23Z"
+"RFModificationTimestamp": "2026-06-19T18:00:18Z"
+"ListPrice": 465000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2R7"
+"UnparsedAddress": "178 WESTCOURT Place, Waterloo, Ontario N2L2R7"
+"Coordinates": array:2 [
0 => -80.5413477
1 => 43.4633325
]
+"Latitude": 43.4633325
+"Longitude": -80.5413477
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention First-Time Homebuyers, Parent Investors, and Landlords! This beautifully updated, spacious end-unit townhouse offers an unbeatable turnkey opportunity right in the heart of Waterloo. Just steps from Waterloo Park, the University of Waterloo, and Wilfrid Laurier University, and directly across the street from Westmount Mall, T&T Grocery Store, and major transit routes, its prime location boasts an incredible walk score. Inside, the bright main floor features fresh paint, attractive flooring, an attractive kitchen with modern cabinetry. The main floor features a highly flexible layout that can easily accommodate a formal dining space. Upstairs holds two large bedrooms and a fully renovated 4-piece bathroom with a sleek glass shower and granite counter, while the partially finished basement is a versatile space for a third bedroom or a family room with a cozy wood fireplace (as-is). Perfect for outdoor entertaining, the living area walks out to a private patio with no rear neighbors, backing onto a serene, park-like setting. Complete with low condo fees, a well-run condo corporation for absolute peace of mind, and one assigned parking space, this highly desirable property is the ultimate choice for a family home or a premium student rental. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "350"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Property Management"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-19T16:34:18.303552+00:00"
+"Directions": "Westmount Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563429"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-19T15:32:16Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:10:40Z"
+"Stories": "2.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "178"
+"StreetSuffix": "Place"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "3594.97"
+"VirtualTourURLUnbranded": "https://youriguide.com/p474x_178_westcourt_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928206/178-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1080
+"OriginalEntryTimestamp": "2026-06-19T15:32:16.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1126015"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928206')"
+"ID": "1547672"
}
]
+success: true
+page_size: 9
+page_count: 43
+count: 380
+after_key: ""
}
"RF Response Time" => "0.34 seconds"
]
]