array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29909411 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: "1534882"
+post_author: 1
+"ListingKey": "29909411"
+"ListingId": "X13449876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:29Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2J3"
+"UnparsedAddress": "9 - 12 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2J3"
+"Coordinates": array:2 [
0 => -80.522235
1 => 43.467941
]
+"Latitude": 43.467941
+"Longitude": -80.522235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FULLY VACANT!! Exceptional investment opportunity with strong rental appeal. This unique property offers a spacious multi-level layout featuring 4 bedrooms, a bathroom on each level, and a shared kitchen configuration ideal for student housing or multi-tenant occupancy. Freshly painted throughout and enhanced with new waterproof vinyl flooring on the upper level, the unit combines modern updates with character-rich design. Originally a 1900s industrial building converted to residential use in 2002, the property showcases soaring ceilings, exposed beams, exposed brick, and stone accents that create a distinctive urban loft aesthetic. Residents enjoy access to secured bike storage, a media lounge/hangout area, and onsite laundry facilities in the building. Ideally situated within walking distance to University of Waterloo, Wilfred Laurier University, public transit including the ION LRT, grocery stores, restaurants, and everyday amenities, with an impressive Walk Score of 94. A proven income-generating property with a strong rental history and consistently high occupancy. Book your private showing today! (id:62650)"
+"AssociationFee": "571.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-16T17:21:55.045353+00:00"
+"Directions": "Bridgeport Rd E And King St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036658"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:21Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:21Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3099.74"
+"VirtualTourURLUnbranded": "https://youtu.be/NT8oDHOsHqU"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1660488830"
"RoomType" => "Living room"
"ListingId" => "X13449876"
"RoomLevel" => "Main level"
"RoomWidth" => 3.68
"ListingKey" => "29909411"
"RoomLength" => 2.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.69Z"
]
1 => array:11 [
"RoomKey" => "1660488831"
"RoomType" => "Kitchen"
"ListingId" => "X13449876"
"RoomLevel" => "Main level"
"RoomWidth" => 3.67
"ListingKey" => "29909411"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
2 => array:11 [
"RoomKey" => "1660488832"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13449876"
"RoomLevel" => "Main level"
"RoomWidth" => 4.32
"ListingKey" => "29909411"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
3 => array:11 [
"RoomKey" => "1660488833"
"RoomType" => "Bedroom 2"
"ListingId" => "X13449876"
"RoomLevel" => "Main level"
"RoomWidth" => 4.05
"ListingKey" => "29909411"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
4 => array:11 [
"RoomKey" => "1660488834"
"RoomType" => "Bedroom 3"
"ListingId" => "X13449876"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.88
"ListingKey" => "29909411"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
5 => array:11 [
"RoomKey" => "1660488835"
"RoomType" => "Bedroom 4"
"ListingId" => "X13449876"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.88
"ListingKey" => "29909411"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
6 => array:11 [
"RoomKey" => "1660488836"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13449876"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.84
"ListingKey" => "29909411"
"RoomLength" => 5.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
7 => array:11 [
"RoomKey" => "1660488837"
"RoomType" => "Utility room"
"ListingId" => "X13449876"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.78
"ListingKey" => "29909411"
"RoomLength" => 0.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T15:02:21.7Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909411/9-12-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2145943"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "293284"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-06-16T15:02:21.67Z"
+"ListAgentNationalAssociationId": "1313160"
+"ListOfficeNationalAssociationId": "1469475"
+"CoListAgentNationalAssociationId": "1397346"
+"CoListOfficeNationalAssociationId": "1469475"
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909411')"
+"ID": "1534882"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293284" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24823
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2036658" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+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 '29909411'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25095
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29909411'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25111
+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 '29909411' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.522235 43.467941)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25164
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+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 {#25160
+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 {#25157
+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 {#25161
+post_id: "1549411"
+post_author: 1
+"ListingKey": "29930552"
+"ListingId": "40841564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:32:38Z"
+"ListPrice": 229900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 555.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V8"
+"UnparsedAddress": "269 SUNVIEW Street Unit# B02, Waterloo, Ontario N2L3V8"
+"Coordinates": array:2 [
0 => -80.5339078
1 => 43.4744488
]
+"Latitude": 43.4744488
+"Longitude": -80.5339078
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this modern 1-bedroom plus den condo in the heart of Waterloo. Perfect for students, professionals, first-time buyers, or investors, this carpet-free unit offers stylish, low-maintenance living in an unbeatable location. Just steps from the University of Waterloo and close to Wilfrid Laurier University, Conestoga College, shopping, restaurants, public transit, and the Technology Park providing excellent value and convenience. Don't miss this opportunity to own in one of Waterloo's most sought-after locations. Book your showing today! (id:62783)"
+"AssociationFee": "520"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:32:32.417467+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750657"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:51:09Z"
+"Stories": "6.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "269"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2562"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1663230729"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
1 => array:11 [
"RoomKey" => "1663230730"
"RoomType" => "Bedroom"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
2 => array:11 [
"RoomKey" => "1663230731"
"RoomType" => "Den"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
3 => array:11 [
"RoomKey" => "1663230732"
"RoomType" => "Living room"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "24'9'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
4 => array:11 [
"RoomKey" => "1663230733"
"RoomType" => "Kitchen"
"ListingId" => "40841564"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930552"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:09.72Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930552/269-sunview-street-unit-b02-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 555
+"OriginalEntryTimestamp": "2026-06-19T19:51:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1066259"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:9 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930552_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/e718aeaf1b5fa5ddbf5c6e289fe545cf.webp"
"MediaSize" => 110811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-e718aeaf1b5fa5ddbf5c6e289fe545cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930552_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/64069cd2637e7dae5486f26c468f726e.webp"
"MediaSize" => 19244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-64069cd2637e7dae5486f26c468f726e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930552_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/14ed3d875bd7267febcacb96a937c98e.webp"
"MediaSize" => 18881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-14ed3d875bd7267febcacb96a937c98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930552_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/3680e514921d5afa459febc2b8a19b0c.webp"
"MediaSize" => 17837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-3680e514921d5afa459febc2b8a19b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930552_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/f5b7aab25daa15cab20440c108035927.webp"
"MediaSize" => 28184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-f5b7aab25daa15cab20440c108035927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930552_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/82e37d182d2a4330fcfe24d23d02aed1.webp"
"MediaSize" => 18141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-82e37d182d2a4330fcfe24d23d02aed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930552_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/25795d4f5a2248071d7a91c413e5b8c8.webp"
"MediaSize" => 17688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-25795d4f5a2248071d7a91c413e5b8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930552_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/54af6580d242acf121ffda211871ee63.webp"
"MediaSize" => 21969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-54af6580d242acf121ffda211871ee63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29930552_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930552/574af7ac55282d6b3ab5155743777356.webp"
"MediaSize" => 23983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930552/thumbnail-574af7ac55282d6b3ab5155743777356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841564"
"ResourceRecordKey" => "29930552"
"ModificationTimestamp" => "2026-06-19T19:51:09.7Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930552')"
+"ID": "1549411"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+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 [
"Order" => 1
"MediaKey" => "29930812_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/83c5e1cead23723277ea71b2ddf494b1.webp"
"MediaSize" => 318094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-83c5e1cead23723277ea71b2ddf494b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930812_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/0bd3f881cb5d5769c7c54885094cad79.webp"
"MediaSize" => 264197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-0bd3f881cb5d5769c7c54885094cad79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930812_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/0798b267b413b7fea652a8b0d2ea4e3f.webp"
"MediaSize" => 275182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-0798b267b413b7fea652a8b0d2ea4e3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930812_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/af6045932d23cfd0a1c7cbf3e3a4a82c.webp"
"MediaSize" => 303975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-af6045932d23cfd0a1c7cbf3e3a4a82c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930812_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/8e82727234c7ccfc12579ab8ca22c227.webp"
"MediaSize" => 333112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-8e82727234c7ccfc12579ab8ca22c227.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930812_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/02b813579710aae0203c1a118ea914ef.webp"
"MediaSize" => 340086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-02b813579710aae0203c1a118ea914ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930812_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/cb5548a682c0665a44ae014d089295df.webp"
"MediaSize" => 139666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-cb5548a682c0665a44ae014d089295df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930812_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/c90f677e12991b4e05f19ebd35f50d75.webp"
"MediaSize" => 260931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-c90f677e12991b4e05f19ebd35f50d75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29930812_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/93edbd965ed1b0db96f8ac8a95bb86d8.webp"
"MediaSize" => 399307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-93edbd965ed1b0db96f8ac8a95bb86d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29930812_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/9db47603ea5ec562c432ff1ca581d022.webp"
"MediaSize" => 91454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-9db47603ea5ec562c432ff1ca581d022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29930812_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/756fcd904fcb716aecf906597c86ef0b.webp"
"MediaSize" => 112342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-756fcd904fcb716aecf906597c86ef0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29930812_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/708006fdc6f0a7a0eb2bd1f176df9cd2.webp"
"MediaSize" => 108349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-708006fdc6f0a7a0eb2bd1f176df9cd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13468830"
"ResourceRecordKey" => "29930812"
"ModificationTimestamp" => "2026-06-19T20:27:05.04Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29930812_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930812/59ad642113400c56fbc913c2f2205391.webp"
"MediaSize" => 102657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930812/thumbnail-59ad642113400c56fbc913c2f2205391.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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 {#25154
+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: "1547671"
+post_author: 1
+"ListingKey": "29928222"
+"ListingId": "X13466612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:50:02Z"
+"RFModificationTimestamp": "2026-06-19T16:48:11Z"
+"ListPrice": 410000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "806 - 181 KING STREET S, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.520205
1 => 43.460368
]
+"Latitude": 43.460368
+"Longitude": -80.520205
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the prestigious Circa 1877 residences in Uptown Waterloo, this spacious suite offers an exceptional opportunity in one of Canada's fastest-growing tech and education hubs. Featuring over 700 sq. ft. of interior living space plus a rare 183 sq. ft. private balcony, the unit offers a highly desirable layout with bright open-concept living and floor-to-ceiling windows.The generous balcony provides valuable outdoor space rarely found in condominium living, while the modern kitchen and living area create an ideal setup for comfortable living or strong rental appeal.Circa 1877 is known for its premium lifestyle amenities including a rooftop saltwater pool with cabanas, fitness centre, indoor and outdoor yoga studios, co-working spaces, guest suites, and an impressive sky terrace with fire tables and BBQ areas.Situated steps from the ION Light Rail and surrounded by Uptown Waterloo's restaurants, cafes, and shops, the building is also minutes from University of Waterloo and Wilfrid Laurier University. With major employers such as Google located nearby in Waterloo's thriving technology corridor, the area continues to attract strong rental demand from professionals and students alike, or great for professional end users. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "610.08"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:48:04.043305+00:00"
+"Directions": "King and Allen"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915573"
+"ListOfficeKey": "269704"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:33:18Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:33:18Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3868.8"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928222/806-181-king-street-s-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T15:33:18.1Z"
+"ListAgentNationalAssociationId": "1224527"
+"ListOfficeNationalAssociationId": "1233633"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928222')"
+"ID": "1547671"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1547614"
+post_author: 1
+"ListingKey": "29927265"
+"ListingId": "X13465672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T13:45:08Z"
+"RFModificationTimestamp": "2026-06-19T16:29:19Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "201 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 145 Society Condos, an exceptional opportunity in the heart of Waterloo's vibrant University District. This beautifully appointed, fully furnished 1+1 bedroom, 1 bathroom suite offers turnkey living for first-time buyers, students, professionals, and savvy investors alike. Perfectly positioned on the same floor as the building's impressive amenity level, this sought-after suite boasts rare 10-foot ceilings-a feature not found in most other units within the building. The added ceiling height creates an airy, open feel while providing unparalleled convenience with premium amenities just steps from your door. Designed for modern living, the sun-filled open-concept layout showcases floor-to-ceiling windows, a sleek contemporary kitchen with Energy Star appliances, granite countertops and backsplash, soft-close cabinetry, custom millwork, and LED lighting throughout. Residents enjoy access to an outstanding collection of amenities, including a state-of-the-art fitness centre, basketball court, sauna, yoga studio, media and games rooms, party lounge, rooftop terrace, 24-hour security, and even an on-site Starbucks. Ideally located directly across from the University of Waterloo and just minutes from Wilfrid Laurier University, Uptown Waterloo, shopping, restaurants, and the ION LRT, this is urban condo living at its finest in one of Waterloo's most desirable locations. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "275"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:29:17.032906+00:00"
+"Directions": "Phillips St & Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129982"
+"ListOfficeKey": "279541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T13:15:16Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T13:15:16Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3294.2"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29927265/201-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T13:15:16.29Z"
+"ListAgentNationalAssociationId": "1383017"
+"ListOfficeNationalAssociationId": "1305599"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927265')"
+"ID": "1547614"
}
]
+success: true
+page_size: 9
+page_count: 53
+count: 472
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]