array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29951014 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1562594"
+post_author: 1
+"ListingKey": "29951014"
+"ListingId": "X13487184"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T03:25:01Z"
+"RFModificationTimestamp": "2026-06-26T04:38:16Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S6"
+"UnparsedAddress": "217 MAYFIELD AVENUE, Waterloo, Ontario N2J3S6"
+"Coordinates": array:2 [
0 => -80.510872
1 => 43.480402
]
+"Latitude": 43.480402
+"Longitude": -80.510872
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Find! Highly auspicious North-facing VASTU-compliant home; Fully Renovated LEGAL DUPLEX - Turnkey & Positive Cash Flow. Minutes from 3 universities 3+2 Bedrooms 2 Full Baths, 2 Kitchens. Detached bungalow on a large lot in a quiet, family-friendly avenue in the desirable Lincoln Heights / Glenridge neighbourhood - within the boundary of top-rated schools. MAIN FLOOR: Spacious layout with a Large primary bedroom and walk-out to a private deck overlooking the backyard, plus two additional regular bedrooms. LEGAL BASEMENT: 2 Large bedrooms + Office room. Highlights: Over 2,000 sq ft of finished living space; Detached oversized garage + long driveway with ample parking; Currently rented to respectful, responsible university students who pay on time and care for the property; POSITIVE CASH FLOW from day one; Bonus upside - BUILD BIG LATER: This large lot qualifies as-of-right for up to a 4-unit, 4-storey building under Waterloo's December 2024 "FOUR Units, FOUR Storeys" bylaw - no rezoning, no variances. A complete conceptual fourplex design (3D model + floor plans) is available for serious buyers. A standout opportunity for homeowners & investors alike. No gimmicks. NO offer date. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
7 => "Water Heater"
8 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:21:57.875346+00:00"
+"Directions": "Cross Streets: University Ave / Conestoga Pkwy. ** Directions: University Ave To Mayfield Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "60.1 x 120.7 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T13:13:58Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T03:17:35Z"
+"Stories": "1.0"
+"StreetName": "Mayfield"
+"StreetNumber": "217"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4451.61"
+"View": "View"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/48PjWV?branded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1668295410"
"RoomType" => "Bedroom 2"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
1 => array:11 [
"RoomKey" => "1668295411"
"RoomType" => "Office"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 4.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
2 => array:11 [
"RoomKey" => "1668295412"
"RoomType" => "Living room"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29951014"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
3 => array:11 [
"RoomKey" => "1668295413"
"RoomType" => "Bathroom"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 1.4
"ListingKey" => "29951014"
"RoomLength" => 1.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
4 => array:11 [
"RoomKey" => "1668295414"
"RoomType" => "Living room"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 4.0
"ListingKey" => "29951014"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
5 => array:11 [
"RoomKey" => "1668295415"
"RoomType" => "Dining room"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29951014"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
6 => array:11 [
"RoomKey" => "1668295416"
"RoomType" => "Kitchen"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29951014"
"RoomLength" => 5.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
7 => array:11 [
"RoomKey" => "1668295417"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.97
"ListingKey" => "29951014"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
8 => array:11 [
"RoomKey" => "1668295418"
"RoomType" => "Bedroom 2"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29951014"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
9 => array:11 [
"RoomKey" => "1668295419"
"RoomType" => "Bedroom 3"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29951014"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
10 => array:11 [
"RoomKey" => "1668295420"
"RoomType" => "Bathroom"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29951014"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
11 => array:11 [
"RoomKey" => "1668295421"
"RoomType" => "Kitchen"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 4.0
"ListingKey" => "29951014"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
12 => array:11 [
"RoomKey" => "1668295422"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.69Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29951014/217-mayfield-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.1
+"OriginalEntryTimestamp": "2026-06-25T13:13:58.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1299556"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:19 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29951014_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/b0f18832d6aea2a94358417abd4246e3.webp"
"MediaSize" => 147646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-b0f18832d6aea2a94358417abd4246e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29951014_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/613ddab0d7bfb304922811a680d05c61.webp"
"MediaSize" => 470853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-613ddab0d7bfb304922811a680d05c61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29951014_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/fcbc4731c66c0165020781d697b6637e.webp"
"MediaSize" => 87491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-fcbc4731c66c0165020781d697b6637e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29951014_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/3939c99ba1844fef603a5a83ea85e1e9.webp"
"MediaSize" => 151766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-3939c99ba1844fef603a5a83ea85e1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29951014_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/5b589f6a536d85a313e9b5b961f8dd19.webp"
"MediaSize" => 120448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-5b589f6a536d85a313e9b5b961f8dd19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29951014_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/74a601e1c2feb9ed39bef1dcd998d38d.webp"
"MediaSize" => 67383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-74a601e1c2feb9ed39bef1dcd998d38d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29951014_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/5b294d45028152c1572e85201ddbbfe9.webp"
"MediaSize" => 64509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-5b294d45028152c1572e85201ddbbfe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29951014_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/f916b4acb32f194d8fed6eac74dafa27.webp"
"MediaSize" => 87827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-f916b4acb32f194d8fed6eac74dafa27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29951014_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/08d7ec5eee86b5982502252766289ee5.webp"
"MediaSize" => 155243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-08d7ec5eee86b5982502252766289ee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29951014_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/fa898ff2798ecce5af4c7dbac9f2439e.webp"
"MediaSize" => 110672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-fa898ff2798ecce5af4c7dbac9f2439e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29951014_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/fdc364324aa9a2759fda1dc8cba50e74.webp"
"MediaSize" => 84627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-fdc364324aa9a2759fda1dc8cba50e74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29951014_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/f21320a49a37edf874bcb23060964095.webp"
"MediaSize" => 236047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-f21320a49a37edf874bcb23060964095.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29951014_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/400db77c17f0b3bcc462defdb5fb2033.webp"
"MediaSize" => 188377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-400db77c17f0b3bcc462defdb5fb2033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29951014_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/d4a26f09b899a1e5ca40f5ceb8fed083.webp"
"MediaSize" => 95532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-d4a26f09b899a1e5ca40f5ceb8fed083.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29951014_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/8a8e3a158dc1a2bd7337b6c84200b455.webp"
"MediaSize" => 147893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-8a8e3a158dc1a2bd7337b6c84200b455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29951014_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/c9070626c6382e70c075f9ca06a7629a.webp"
"MediaSize" => 216540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-c9070626c6382e70c075f9ca06a7629a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29951014_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/783553d486d127058b34948d8fba9e88.webp"
"MediaSize" => 45764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-783553d486d127058b34948d8fba9e88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29951014_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/a9a7a99e647cdf5666104bda3873a1fc.webp"
"MediaSize" => 428482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-a9a7a99e647cdf5666104bda3873a1fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29951014_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/8fbbb136c01e5cf464af84c986620269.webp"
"MediaSize" => 410112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-8fbbb136c01e5cf464af84c986620269.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951014')"
+"ID": "1562594"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 164016" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24791
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2019588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29951014'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+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 '29951014'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25183
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29951014' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.510872 43.480402)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25236
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1567144"
+post_author: 1
+"ListingKey": "29945896"
+"ListingId": "40842567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T13:40:03Z"
+"RFModificationTimestamp": "2026-06-26T03:52:45Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1174.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H5"
+"UnparsedAddress": "58 BRIDGEPORT Road E Unit# 806, Waterloo, Ontario N2J4H5"
+"Coordinates": array:2 [
0 => -80.5178587
1 => 43.4687759
]
+"Latitude": 43.4687759
+"Longitude": -80.5178587
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "With almost 1200 sq ft of l living space, this large 3 bedroom, 2 bathroom condo has many updates including newer kitchen and bathrooms, flooring and neutral decor. There is a large balcony overlooking Waterloo where you can enjoy evening sunsets. The location is just steps to Bridgeport Plaza and a short ride to the Universities. If you are looking for a spacious 3 bedroom condo at an affordable price that is in a great location, this unit checks all the boxes. The covered parking spot is conveniently located at the back of the building. Call today for a viewing. (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFee": "879.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-26T03:51:57.627637+00:00"
+"Directions": "Take Bridgeport Rd E. past Weber St and turn right into Black Willow Condominiums"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T13:30:38Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T13:30:38Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "58"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2609"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1666816618"
"RoomType" => "Storage"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
1 => array:11 [
"RoomKey" => "1666816619"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
2 => array:11 [
"RoomKey" => "1666816620"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
3 => array:11 [
"RoomKey" => "1666816621"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
4 => array:11 [
"RoomKey" => "1666816622"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
5 => array:11 [
"RoomKey" => "1666816623"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
6 => array:11 [
"RoomKey" => "1666816624"
"RoomType" => "Dining room"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
7 => array:11 [
"RoomKey" => "1666816625"
"RoomType" => "Living room"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 21'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
8 => array:11 [
"RoomKey" => "1666816626"
"RoomType" => "Kitchen"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.51Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945896/58-bridgeport-road-e-unit-806-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1944830"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1174
+"OriginalEntryTimestamp": "2026-06-24T13:30:38.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1240421"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29945896_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/9b483e4367c6e76c560e62b20be90673.webp"
"MediaSize" => 177598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-9b483e4367c6e76c560e62b20be90673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29945896_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3c87c9b502b5073c48570cfd33658049.webp"
"MediaSize" => 82507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3c87c9b502b5073c48570cfd33658049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29945896_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/dc8507aa117a884e74dabdb51bf666c1.webp"
"MediaSize" => 82777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-dc8507aa117a884e74dabdb51bf666c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building Foyer - ALternate Biew"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29945896_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/1c1f1a8d6cb1c21ef9d0ee0478ac9d72.webp"
"MediaSize" => 76568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-1c1f1a8d6cb1c21ef9d0ee0478ac9d72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29945896_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/9c4223fdc1e3b375400ac95e661053c1.webp"
"MediaSize" => 73239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-9c4223fdc1e3b375400ac95e661053c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area showing walkout to Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29945896_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/6440bbbf11b7923bd4f7c2b9ada0c472.webp"
"MediaSize" => 72210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-6440bbbf11b7923bd4f7c2b9ada0c472.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29945896_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/4b668b686f5537182e7a1be10c0ea7be.webp"
"MediaSize" => 69285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-4b668b686f5537182e7a1be10c0ea7be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Updated Kitchen with Granite Countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29945896_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/c5bc2c97d2a8ac418e523d3b79b7a5b8.webp"
"MediaSize" => 63089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-c5bc2c97d2a8ac418e523d3b79b7a5b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen - Alternat View 1"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29945896_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/14da8bec0678b90aa4b00c32807dde2e.webp"
"MediaSize" => 57429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-14da8bec0678b90aa4b00c32807dde2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen - ALternate View 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29945896_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/779b56dcac86f6670ac5a8a67d856ea1.webp"
"MediaSize" => 66603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-779b56dcac86f6670ac5a8a67d856ea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29945896_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/0ac3ef2ad9af2930070eb54f3e76a0bf.webp"
"MediaSize" => 65358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-0ac3ef2ad9af2930070eb54f3e76a0bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29945896_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/c3e390ca11f0f3ed0347fe087bdae62c.webp"
"MediaSize" => 69637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-c3e390ca11f0f3ed0347fe087bdae62c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29945896_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/ce04f8d9d7d0cfd0985cfde1052243d6.webp"
"MediaSize" => 63008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-ce04f8d9d7d0cfd0985cfde1052243d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29945896_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/e7ca33025530d5f9ae20bd5a80b7f4db.webp"
"MediaSize" => 70335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-e7ca33025530d5f9ae20bd5a80b7f4db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29945896_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3f578157bbdbe04df676e9d85d5c95f7.webp"
"MediaSize" => 47158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3f578157bbdbe04df676e9d85d5c95f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29945896_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/00a2cf9f400db1a9a48299a2f4872303.webp"
"MediaSize" => 68753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-00a2cf9f400db1a9a48299a2f4872303.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View from Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29945896_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/210079f4d03bbccde6af9ae254fc9784.webp"
"MediaSize" => 74824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-210079f4d03bbccde6af9ae254fc9784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive Balcony with view of Waterloo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29945896_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/a0d2b31869d2877d938f056be354bbef.webp"
"MediaSize" => 127962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-a0d2b31869d2877d938f056be354bbef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Library"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29945896_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/e28acf8a48e8ac571a7d4bc49c89fb67.webp"
"MediaSize" => 80886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-e28acf8a48e8ac571a7d4bc49c89fb67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Party Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29945896_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/87aafe6673ffba1f9297345f4cb9bfd6.webp"
"MediaSize" => 50763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-87aafe6673ffba1f9297345f4cb9bfd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Party Room - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29945896_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/00f83f2f2f80ba4981f29674a4f626db.webp"
"MediaSize" => 78657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-00f83f2f2f80ba4981f29674a4f626db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mail Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29945896_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/410d9025e611de4b3b3e4fee5eec043a.webp"
"MediaSize" => 76719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-410d9025e611de4b3b3e4fee5eec043a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercixe Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29945896_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/277a6ae97ea8c4c77eed2fcaddb342da.webp"
"MediaSize" => 77952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-277a6ae97ea8c4c77eed2fcaddb342da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29945896_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3ebcf10ee37fa77a202245500ccbddfe.webp"
"MediaSize" => 49144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3ebcf10ee37fa77a202245500ccbddfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945896')"
+"ID": "1567144"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1567515"
+post_author: 1
+"ListingKey": "29946102"
+"ListingId": "X13482722"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T14:20:04Z"
+"RFModificationTimestamp": "2026-06-26T03:43:39Z"
+"ListPrice": 709990.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "703 - 8 HICKORY STREET, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible Turn Key Luxury Student Investment. Newly painted, New fridge. This Condo Is Fully Rented Until The End Of August 2026 With Options To Renew. Huge rental demand throughout the year. Recession proof income potential. Currently Rented for $4250/mth. AAA 3 working tenants continuing for last 3 years. Minutes Away From University Of Waterloo & Wilfred Laurier. Bike Lanes Run Right Up To Condo. Amenities, Shops, Restaurants & Transit Steps Away. Highway Is Only A Few Minutes Away. A Great Investment For Any Type Of Investor. 5 Bedrooms All 5 With Their Own Washrooms. Shared Common Space With Laundry, Living and huge balcony.Seller can hand over fully vacated unit if required. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Intercom"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"AssociationFee": "810.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:37:22.370040+00:00"
+"Directions": "University/King"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085449"
+"ListOfficeKey": "272995"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Wheelchair access"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T14:12:55Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:12:55Z"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3652.79"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946102/703-8-hickory-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Separate Electricity Meters"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-24T14:12:55.8Z"
+"ListAgentNationalAssociationId": "1358847"
+"ListOfficeNationalAssociationId": "1247661"
+"Media": array:11 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946102_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/094c5b0e13e4a59e4bdfd30259dee816.webp"
"MediaSize" => 158050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-094c5b0e13e4a59e4bdfd30259dee816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946102_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/6ae606865d57351b7c4ca102815b4b84.webp"
"MediaSize" => 86087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-6ae606865d57351b7c4ca102815b4b84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946102_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/91c1bbb5246a8caa7ffb0a36481caa99.webp"
"MediaSize" => 77943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-91c1bbb5246a8caa7ffb0a36481caa99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946102_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/8aef06dd489cf8d284ef9890ffeab4a7.webp"
"MediaSize" => 77518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-8aef06dd489cf8d284ef9890ffeab4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946102_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/9e67b905a61895f08e8b460c27a44b14.webp"
"MediaSize" => 91986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-9e67b905a61895f08e8b460c27a44b14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946102_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/08b2264df8cf7a79891751eeb77d14db.webp"
"MediaSize" => 61696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-08b2264df8cf7a79891751eeb77d14db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946102_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/be4f5b3fc2e7d43ca4fa1db4f9fc2b28.webp"
"MediaSize" => 108636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-be4f5b3fc2e7d43ca4fa1db4f9fc2b28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946102_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/f49c6028439e7e5fdc7fc1b5ca4832ae.webp"
"MediaSize" => 59031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-f49c6028439e7e5fdc7fc1b5ca4832ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946102_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/c01f9f975d369af75ecb27ccd0fd4e98.webp"
"MediaSize" => 98829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-c01f9f975d369af75ecb27ccd0fd4e98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946102_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/b1eec81084aa21c745b0bc68ccf018ab.webp"
"MediaSize" => 137100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-b1eec81084aa21c745b0bc68ccf018ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946102_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/057b6b3c68152c2001e57f48929ca6c3.webp"
"MediaSize" => 91176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-057b6b3c68152c2001e57f48929ca6c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946102')"
+"ID": "1567515"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1563891"
+post_author: 1
+"ListingKey": "29949445"
+"ListingId": "X13485512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:00:21Z"
+"RFModificationTimestamp": "2026-06-25T23:26:01Z"
+"ListPrice": 509000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "114 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Desirable And Accommodating Off Campus Residency. A 5 Minute Walk To Wilfrid Laurier University And University Of Waterloo. Spacious 2 Bedrooms With 2 Baths. Opening To A Large Private Terrace. Floor To Ceiling Windows. Including Granite Countertops, In-Suite Laundry Facility, Ensuite Bath And Roomy Walk-In Closet. Has An Assigned Parking Spot. Fully Furnished Unit In "As Is" Condition. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "804.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:25:50.900110+00:00"
+"Directions": "University/Albert"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1416090"
+"ListOfficeKey": "275703"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Elevator"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:53:03Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:53:03Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4826.72"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949445/114-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-24T21:53:03.64Z"
+"ListAgentNationalAssociationId": "1047244"
+"ListOfficeNationalAssociationId": "1267442"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29949445_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949445/247d18a73759d2ac980ffa0475dd6d6f.webp"
"MediaSize" => 281748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949445/thumbnail-247d18a73759d2ac980ffa0475dd6d6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13485512"
"ResourceRecordKey" => "29949445"
"ModificationTimestamp" => "2026-06-24T21:53:03.66Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949445')"
+"ID": "1563891"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1562848"
+post_author: 1
+"ListingKey": "29950717"
+"ListingId": "40842585"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T11:55:06Z"
+"RFModificationTimestamp": "2026-06-25T21:45:11Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z5"
+"UnparsedAddress": "139 BRIGHTON Street Unit# 3C, Waterloo, Ontario N2J4Z5"
+"Coordinates": array:2 [
0 => -80.51881
1 => 43.4715074
]
+"Latitude": 43.4715074
+"Longitude": -80.51881
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well maintained 2-bedroom, 1-bathroom stacked townhouse-style condo is perfect for first-time buyers, downsizers, or investors. Features an updated kitchen with stainless steel appliances, quartz counters and tiled backsplash, main floor in-suite laundry adds everyday convenience, along with main floor bedroom with generous closet space. An updated 4-piece bathroom complete the main level. Second bedroom is located on upper level. Just minutes from Wilfrid Laurier University, the University of Waterloo, major transit routes, 10min walk to uptown Waterloo, and all essential amenities, this home offers unbeatable convenience. Move-in ready and waiting for its new owner. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "377.41"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:44:23.146754+00:00"
+"Directions": "Noecker Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-25T11:49:57Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T11:49:57Z"
+"Stories": "2.0"
+"StreetName": "BRIGHTON"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2547.19"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/139-Brighton-St-3c/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1667597734"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842585"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
1 => array:11 [
"RoomKey" => "1667597735"
"RoomType" => "Laundry room"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
2 => array:11 [
"RoomKey" => "1667597736"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
3 => array:11 [
"RoomKey" => "1667597737"
"RoomType" => "Bedroom"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
4 => array:11 [
"RoomKey" => "1667597738"
"RoomType" => "Kitchen"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
5 => array:11 [
"RoomKey" => "1667597739"
"RoomType" => "Living room"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
…4
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29950717/139-brighton-street-unit-3c-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-25T11:49:57.18Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950717')"
+"ID": "1562848"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: "1562849"
+post_author: 1
+"ListingKey": "29950838"
+"ListingId": "X13486974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T00:20:08Z"
+"RFModificationTimestamp": "2026-06-26T01:06:17Z"
+"ListPrice": 709000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "203 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling All Investors! Welcome to 8 Hickory Street W, Unit 203, Waterloo - the ultimate income-generating investment property in a prime student rental location within walking distance to the University of Waterloo and Wilfrid Laurier University. This renovated condo offers over 2,000 sq. ft. of functional living space with laminate flooring throughout, 5 spacious bedrooms, 5 bathrooms, an open-concept living and dining area, and a walk-out to a spacious open balcony with room for outdoor furniture and enjoyment. The modern kitchen features stainless steel appliances, granite countertops, ceramic backsplash, a centre island, 2 stainless steel fridges, lots of cabinetry/pantry space and in-suite laundry for everyday convenience. All 5 rooms are fully rented from September 2026 to August 2027, generating a gross monthly income of $4,875 (covers 5 rooms $950/each monthly & parking $125/month), with the 1 owned underground parking space providing an additional $125 per month starting Sept. 2026. Monthly condo fees include unlimited Bell high-speed internet, water, parking, common elements, building insurance, and central air conditioning. The suite comes fully furnished with 5 double-sized bed frames, 5 desks, 5 side tables, washer and dryer, 3-seater couch, 2-seater couch, TV, barstools, dining chairs, window coverings, and electrical light fixtures. Building amenities include an exercise room, party/meeting room, games room, visitor parking, secure bike storage, elevator, and controlled entry. Ideally surrounded by parks and recreation including Kevin Strauss Football Field, Ansley Alumni Field, Hillside Park, Forwell Trail & Creek, Sugarbush Park, and Waterloo Park, with nearby access to University of Waterloo, Wilfrid Laurier University, Conestoga College. Steps to Grand River Transit, and the nearby Conestoga Parkway for easy travel throughout Waterloo Region, Ontario, and the GTA. (id:62650)"
+"Appliances": array:9 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "889.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:35:35.727452+00:00"
+"Directions": "Cross Streets: King St. N. & University Ave. W. ** Directions: Exit Conestoga Pkwy West on University, North on King, West on Hickory."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1743624"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Elevator"
1 => "Lighting"
2 => "Balcony"
3 => "Carpet Free"
4 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-25T12:16:59Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T00:14:33Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7483.08"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204656519?fl=ml&fe=ec"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950838/203-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2193944"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 519-620-8778"
+"CoListOfficeKey": "271789"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Smoke Detectors"
1 => "Controlled entry"
2 => "Monitored Alarm"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-25T12:16:58.91Z"
+"ListAgentNationalAssociationId": "1179823"
+"ListOfficeNationalAssociationId": "1243258"
+"CoListAgentNationalAssociationId": "1442810"
+"CoListOfficeNationalAssociationId": "1243258"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950838')"
+"ID": "1562849"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1563097"
+post_author: 1
+"ListingKey": "29953493"
+"ListingId": "40842924"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:40:16Z"
+"RFModificationTimestamp": "2026-06-25T21:14:57Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1488.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3G1"
+"UnparsedAddress": "255 CAMELOT Court Unit# 2, Waterloo, Ontario N2K3G1"
+"Coordinates": array:2 [
0 => -80.5079629
1 => 43.4921833
]
+"Latitude": 43.4921833
+"Longitude": -80.5079629
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2-255 Camelot Court, a charming 2-storey freehold townhome in Waterloo’s sought-after Lincoln Village. Offering 3 bedrooms and 1full bathroom, this home is an excellent opportunity for first-time buyers, young families, or investors looking to get into a well-established neighbourhood. The main floor features a bright, functional layout with spacious living areas and plenty of natural light, creating a warm and inviting atmosphere. Upstairs, you’ll find three comfortable bedrooms and a full bathroom—perfect for everyday family living. One of the standout features of this home is the backyard setting. Backing directly onto Sandowne Public School, you’ll enjoy added privacy with no rear neighbours. A deck off the living room provides the perfect space to relax or entertain outdoors. Additional highlights include an attached garage and private driveway with parking for two vehicles. Ideally located close to shopping, parks, schools, and with quick access to Highway 7/8, thishome offers both convenience and community. A great opportunity to own a freehold townhome in a desirable Waterloo neighbourhood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:14:49.632234+00:00"
+"Directions": "Hwy 8 E/ON-7, Take the University Ave East exit, Turn left onto Braemore Ave, Turn left onto Sandowne Dr, Turn right onto Dunvegan Dr, Turn left onto Bairstow Crescent, Turn left onto Camelot Ct, Property will be on the left"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099819"
+"ListOfficeKey": "292918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:33:04Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:33:04Z"
+"Stories": "2.0"
+"StreetName": "CAMELOT"
+"StreetNumber": "255"
+"StreetSuffix": "Court"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3186.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/255_camelot_ct_2_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29953493/255-camelot-court-unit-2-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1138
+"BelowGradeFinishedArea": 350
+"OriginalEntryTimestamp": "2026-06-25T18:33:04.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1369903"
+"ListOfficeNationalAssociationId": "1419429"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953493')"
+"ID": "1563097"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1562014"
+post_author: 1
+"ListingKey": "29953652"
+"ListingId": "X13489360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:24Z"
+"RFModificationTimestamp": "2026-06-25T20:30:46Z"
+"ListPrice": 414999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "32 - 121 UNIVERSITY AVENUE E, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.515579
1 => 43.477294
]
+"Latitude": 43.477294
+"Longitude": -80.515579
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all INVESTORS , FIRST TIME HOME BUYERS AND FAMILIES ALIKE ! This exceptional 5 bedroom townhouse has the potential of $3,500 to$4,000 per month rent !, For families and first time home buyers the square footage offers incredible value. The spacious layout seamlessly flows from room to room, creating an inviting atmosphere for both relaxation and entertainment. Enjoy preparing meals with ease as there is noshortage of counter space in the kitchen. Morning coffee or barbecues with friends on your patio. Each bedroom offering plenty of space, natural light, and closet storage. The master bedroom features an ensuite bath & walk in closet . Downstairs, is a rec room for movie nights and entertaining. There is an abundance of storage in the basement for all of your extra belongings. Take advantage of the proximity to excellent schools, Wilfred Laurier University, Waterloo University as well as the Conestoga College campus, Miles of scenic walking trails for outdoor enthusiasts to explore the natural beauty of the surrounding area. For those who enjoy shopping and dining, you're in luck! This property is conveniently located within walking distance to great shopping destinations and local eateries, providing endless opportunities for leisure! No scraping your car this upcoming winter as there is a underground parking space included. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "766"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:27:11.755530+00:00"
+"Directions": "Cross Streets: Marsland. ** Directions: University Ave East to Marsland drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193931"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:48Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:48Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "University"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3304"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_121_university_ave_e_waterloo_on/"
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953652/32-121-university-avenue-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247230"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "ONYX"
+"CoListOfficeKey": "286835"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-25T18:36:48.32Z"
+"ListAgentNationalAssociationId": "1443150"
+"ListOfficeNationalAssociationId": "1364242"
+"CoListAgentNationalAssociationId": "1486102"
+"CoListOfficeNationalAssociationId": "1364242"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953652')"
+"ID": "1562014"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1561308"
+post_author: 1
+"ListingKey": "29952188"
+"ListingId": "40842768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T17:00:12Z"
+"RFModificationTimestamp": "2026-06-25T19:26:50Z"
+"ListPrice": 414999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1886.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "121 UNIVERSITY Avenue E Unit# 32, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.5156713
1 => 43.4772121
]
+"Latitude": 43.4772121
+"Longitude": -80.5156713
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Calling all INVESTORS , FIRST TIME HOME BUYERS AND FAMILIES ALIKE ! This exceptional 5 bedroom townhouse has the potential of $3,500 to $4,000 per month rent !, For families and first time home buyers the square footage offers incredible value. The spacious layout seamlessly flows from room to room, creating an inviting atmosphere for both relaxation and entertainment. Enjoy preparing meals with ease as there is no shortage of counter space in the kitchen. Morning coffee or barbecues with friends on your patio. Each bedroom offering plenty of space, natural light, and closet storage. The master bedroom features an ensuite bath & walk in closet . Downstairs, is a rec room for movie nights and entertaining. There is an abundance of storage in the basement for all of your extra belongings. Take advantage of the proximity to excellent schools, Wilfred Laurier University, Waterloo University as well as the Conestoga College campus, Miles of scenic walking trails for outdoor enthusiasts to explore the natural beauty of the surrounding area. For those who enjoy shopping and dining, you're in luck! This property is conveniently located within walking distance to great shopping destinations and local eateries, providing endless opportunities for leisure! No scraping your car this upcoming winter as there is a underground parking space included. (id:62650)"
+"AssociationFee": "766"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:26:41.683405+00:00"
+"Directions": "University Ave East to Marsland drive"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2034139"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-25T16:50:25Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T16:50:25Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3304"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_121_university_ave_e_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29952188/121-university-avenue-e-unit-32-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1800304"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289848"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1568
+"BelowGradeFinishedArea": 318
+"OriginalEntryTimestamp": "2026-06-25T16:50:25.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1310837"
+"ListOfficeNationalAssociationId": "1381908"
+"CoListAgentNationalAssociationId": "1190449"
+"CoListOfficeNationalAssociationId": "1381908"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952188')"
+"ID": "1561308"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1559384"
+post_author: 1
+"ListingKey": "29943950"
+"ListingId": "X13481030"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T21:00:17Z"
+"RFModificationTimestamp": "2026-06-23T22:21:18Z"
+"ListPrice": 414900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "H404 - 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": "Stylish, Sun-Filled Condo in the Heart of the University District. Welcome to modern urban living! This bright and spacious 762 sq ft condo features 2 bedrooms and 2 full bathrooms, offering a functional layout perfect for comfortable everyday living. Ideally located in Waterloo's vibrant University District, this unit sits just steps from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, making it an exceptional opportunity for students, professionals, and investors alike. The condo comes fully furnished, making it a true turnkey opportunity-simply move in or start renting immediately. Enjoy unbeatable convenience with restaurants, shopping, the library, and major bus routes all within walking distance. Highlights:762 Sq Ft of bright, open living space2 spacious bedrooms 2 full bathrooms Fully furnished Prime University District location Ideal for students, professionals, investors, or first-time buyers. Don't miss this incredible opportunity to own in one of Waterloo's most desirable locations. Schedule your private viewing today! (id:62783)"
+"Appliances": array:2 [
0 => "All"
1 => "Furniture"
]
+"AssociationFee": "397"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T22:21:11.885834+00:00"
+"Directions": "Larch St /Hickory St W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423901"
+"ListOfficeKey": "284505"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T20:53:43Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:53:43Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2775"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29943950/h404-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2130897"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc"
+"CoListOfficeKey": "284505"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-23T20:53:43.72Z"
+"ListAgentNationalAssociationId": "1119532"
+"ListOfficeNationalAssociationId": "1342135"
+"CoListAgentNationalAssociationId": "1383711"
+"CoListOfficeNationalAssociationId": "1342135"
+"Media": array:9 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943950')"
+"ID": "1559384"
}
]
+success: true
+page_size: 9
+page_count: 34
+count: 299
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]