array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30076768 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1656848"
+post_author: 1
+"ListingKey": "30076768"
+"ListingId": "X13603310"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:07Z"
+"RFModificationTimestamp": "2026-07-24T19:48:32Z"
+"ListPrice": 553000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G9"
+"UnparsedAddress": "113 - 288 ALBERT STREET, Waterloo, Ontario N2L0G9"
+"Coordinates": array:2 [
0 => -80.533768
1 => 43.477153
]
+"Latitude": 43.477153
+"Longitude": -80.533768
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARELY VACANT, Fully Furnished, Freshly Painted Turn Key Investment Steps from University of Waterloo, and Laurier University! Potential Positive Cashflow with Rent and Low Vacancy Rate due to student housing demand for Universities. COMES WITH 1 PARKING SPOT! Main Floor, Corner unit, with Three Bedrooms, Three FULL Washrooms, Large Main Floor Den, along with another lower level study Area, with 1 Surface Level Parking, Ensuite Laundry. Each Bedroom comes Fully Equipped with Bed Frame, Mattress, Side Table, and Study Desk. Open Concept Living, and Dinning with TV, Sofas and Dinning Table Set. Large U-Shaped Kitchen with stainless steel appliances, Quarts Counter Tops/Backsplash and Bar Stool Seating. Main Floor Den Also Comes with Sofas, TV, and Storage Cabinet. Must See, Everything in the Unit comes with it! Perfect for if you or a loved one will be attending University or if you are looking to build your Investment Portfolio. (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Washer"
2 => "Dryer"
3 => "Furniture"
4 => "Window Coverings"
]
+"AssociationFee": "582.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:48:23.436678+00:00"
+"Directions": "Cross Streets: University Ave & Albert St. ** Directions: Turn East into Complex from Albert St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087935"
+"ListOfficeKey": "292212"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:36Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:35Z"
+"StreetName": "Albert"
+"StreetNumber": "288"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4779.34"
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1692606147"
"RoomType" => "Living room"
"ListingId" => "X13603310"
"RoomLevel" => "Main level"
"RoomWidth" => 2.99
"ListingKey" => "30076768"
"RoomLength" => 4.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.79Z"
]
1 => array:11 [
"RoomKey" => "1692606148"
"RoomType" => "Bathroom"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "30076768"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.79Z"
]
2 => array:11 [
"RoomKey" => "1692606149"
"RoomType" => "Dining room"
"ListingId" => "X13603310"
"RoomLevel" => "Main level"
"RoomWidth" => 2.99
"ListingKey" => "30076768"
"RoomLength" => 3.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.8Z"
]
3 => array:11 [
"RoomKey" => "1692606150"
"RoomType" => "Kitchen"
"ListingId" => "X13603310"
"RoomLevel" => "Main level"
"RoomWidth" => 4.45
"ListingKey" => "30076768"
"RoomLength" => 3.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.81Z"
]
4 => array:11 [
"RoomKey" => "1692606151"
"RoomType" => "Den"
"ListingId" => "X13603310"
"RoomLevel" => "Main level"
"RoomWidth" => 2.99
"ListingKey" => "30076768"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.82Z"
]
5 => array:11 [
"RoomKey" => "1692606152"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.93
"ListingKey" => "30076768"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.83Z"
]
6 => array:11 [
"RoomKey" => "1692606153"
"RoomType" => "Bedroom 2"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.93
"ListingKey" => "30076768"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.84Z"
]
7 => array:11 [
"RoomKey" => "1692606154"
"RoomType" => "Bedroom 3"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.93
"ListingKey" => "30076768"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.85Z"
]
8 => array:11 [
"RoomKey" => "1692606155"
"RoomType" => "Study"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.93
"ListingKey" => "30076768"
"RoomLength" => 3.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.86Z"
]
9 => array:11 [
"RoomKey" => "1692606156"
"RoomType" => "Bathroom"
"ListingId" => "X13603310"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30076768"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.87Z"
]
10 => array:11 [
"RoomKey" => "1692606157"
"RoomType" => "Bathroom"
"ListingId" => "X13603310"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "30076768"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T18:39:35.88Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076768/113-288-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-07-24T18:39:35.65Z"
+"ListAgentNationalAssociationId": "1361256"
+"ListOfficeNationalAssociationId": "1409372"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30076768_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/9ecd07e968b33e6e879502739120b075.webp"
"MediaSize" => 244075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-9ecd07e968b33e6e879502739120b075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30076768_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/16e0dac6154d719dcda44afa63d58fea.webp"
"MediaSize" => 124752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-16e0dac6154d719dcda44afa63d58fea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30076768_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/0ae89ff38164af984dd95f0d314e836b.webp"
"MediaSize" => 127296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-0ae89ff38164af984dd95f0d314e836b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30076768_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/5d5b083f627011d33f7816b8a5324d73.webp"
"MediaSize" => 137856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-5d5b083f627011d33f7816b8a5324d73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30076768_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/48c5c18ac7d4edb4a5e5afa8ecb0b0f7.webp"
"MediaSize" => 158185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-48c5c18ac7d4edb4a5e5afa8ecb0b0f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30076768_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/45859f7cd1b7c248735f974f33d42867.webp"
"MediaSize" => 154047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-45859f7cd1b7c248735f974f33d42867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30076768_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/d75aab7c0675912385e7d6875446267f.webp"
"MediaSize" => 127188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-d75aab7c0675912385e7d6875446267f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30076768_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/9cbf2d9939c9fe74152d66dd845e759b.webp"
"MediaSize" => 141420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-9cbf2d9939c9fe74152d66dd845e759b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30076768_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/704a3f1cd6f2d50257701f336bce45bf.webp"
"MediaSize" => 132705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-704a3f1cd6f2d50257701f336bce45bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30076768_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/6fe57336b5195314cda9fdef1d8ff0ac.webp"
"MediaSize" => 141694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-6fe57336b5195314cda9fdef1d8ff0ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30076768_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/6c2aab0f0498d36b88becbfe53f6886e.webp"
"MediaSize" => 138133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-6c2aab0f0498d36b88becbfe53f6886e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30076768_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/3f47438ffa80f2dbe9363b9e6f7f5f06.webp"
"MediaSize" => 141288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-3f47438ffa80f2dbe9363b9e6f7f5f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30076768_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/d45dd6c3d5622f6cce2826db612da6e3.webp"
"MediaSize" => 147310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-d45dd6c3d5622f6cce2826db612da6e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30076768_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/c647ae6b4b8f9b226dd4c6ebea63a06b.webp"
"MediaSize" => 138555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-c647ae6b4b8f9b226dd4c6ebea63a06b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30076768_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/abf253f5b7c2e7a1134776387813dd75.webp"
"MediaSize" => 171151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-abf253f5b7c2e7a1134776387813dd75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30076768_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/bbe60c8bc0ce06382a961435b43b3033.webp"
"MediaSize" => 112872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-bbe60c8bc0ce06382a961435b43b3033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30076768_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/3697f2de51bdc36ae9555a409ba6a0b6.webp"
"MediaSize" => 147545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-3697f2de51bdc36ae9555a409ba6a0b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30076768_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/4a60050689fc84bb677b8d8aa2eed811.webp"
"MediaSize" => 132666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-4a60050689fc84bb677b8d8aa2eed811.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30076768_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/5a2b9ac15d28a616347055ebb3c8b86f.webp"
"MediaSize" => 101463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-5a2b9ac15d28a616347055ebb3c8b86f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30076768_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/fdf75a0141c6c8648d2eeccf8df1d6ed.webp"
"MediaSize" => 122380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-fdf75a0141c6c8648d2eeccf8df1d6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30076768_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/0954ab6a550054168e9fbbd0eedeff9e.webp"
"MediaSize" => 122917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-0954ab6a550054168e9fbbd0eedeff9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30076768_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/ae9d2fbfc2aafeae702c79935cb448c5.webp"
"MediaSize" => 111239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-ae9d2fbfc2aafeae702c79935cb448c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30076768_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/a426156cab4ea504f40401ab2b66eba0.webp"
"MediaSize" => 129882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-a426156cab4ea504f40401ab2b66eba0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30076768_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/d03fb276c5e6436eacf7bbcb4e02c4c7.webp"
"MediaSize" => 67851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-d03fb276c5e6436eacf7bbcb4e02c4c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30076768_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/8f173a36eded0eecc738156bcd494459.webp"
"MediaSize" => 173260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-8f173a36eded0eecc738156bcd494459.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30076768_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/854c88d5c255bb5f5db9100790a79eec.webp"
"MediaSize" => 274746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-854c88d5c255bb5f5db9100790a79eec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30076768_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/5e91a56699735f365f405d8230af3c2e.webp"
"MediaSize" => 448641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-5e91a56699735f365f405d8230af3c2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30076768_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30076768/4274b630cf4265f2b5e5855a074b99fd.webp"
"MediaSize" => 38742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30076768/thumbnail-4274b630cf4265f2b5e5855a074b99fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13603310"
"ResourceRecordKey" => "30076768"
"ModificationTimestamp" => "2026-07-24T18:39:35.66Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076768')"
+"ID": "1656848"
}
]
+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=OfficeKey eq 292212" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25002
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24945
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "REALTY WEALTH GROUP INC."
+"OfficeEmail": null
+"OfficePhone": "905-247-5000"
+"OfficeMlsId": "408800"
+"ModificationTimestamp": "2025-06-12T18:46:29Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292212"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1135 STELLAR DRIVE UNIT 3"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "NEWMARKET"
+"OfficePostalCode": "L3Y7B"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1409372"
+"OriginalEntryTimestamp": "2022-02-16T22:56:00Z"
+"OfficeFax": "905-326-5037"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "326682"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "292212"
"SocialMediaUrlOrId" => "http://www.soldbyrwg.com/"
"ModificationTimestamp" => "2025-06-11T21:29:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1212944"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('292212')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2087935" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25025
+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 '30076768'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30076768' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30076768' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.533768 43.477153)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25385
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1657897"
+post_author: 1
+"ListingKey": "29750999"
+"ListingId": "X13126502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T03:15:02Z"
+"RFModificationTimestamp": "2026-07-24T23:02:12Z"
+"ListPrice": 365000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V9"
+"UnparsedAddress": "1103 - 258A SUNVIEW STREET, Waterloo, Ontario N2L3V9"
+"Coordinates": array:2 [
0 => -80.532991
1 => 43.474108
]
+"Latitude": 43.474108
+"Longitude": -80.532991
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright & Spacious Sun-Filled Corner Unit Offering Stunning Views And Fully Furnished Convenience. Ideally Located In The Highly Sought-After Waterloo School District, Just Steps From The University of Waterloo, Wilfrid Laurier University, Conestoga College, And The Thriving Tech Hub. An Excellent Opportunity For First-Time Home Buyers, Investors, Or Students Seeking A Prime Central Location. This Well-Appointed Unit Features Two Spacious Bedrooms, A Full Bathroom, And An Open-Concept Living Area Filled With Natural Light. Enjoy A Modern Eat-In Kitchen Complete With Stainless Steel Appliances, Stylish Countertops, And Ample Cabinetry. Includes Ensuite Laundry And Wireless Internet For Added Convenience. Minutes To Major Highways With Easy Access To ION/LRT/GO Transit, Restaurants, Shopping, And Everyday Amenities. A Must See Property Offering Exceptional Value And Location. Don't Miss This Opportunity. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "343.07"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T23:02:08.721530+00:00"
+"Directions": "Cross Streets: University Ave & Sunview St. ** Directions: University ave w and hemlock st."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803950"
+"ListOfficeKey": "283484"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-14T14:18:09Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T03:07:45Z"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3192"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29750999/1103-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1499050"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WA"
+"CoListOfficeKey": "283484"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "NMU-12"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-05-14T14:18:09.47Z"
+"ListAgentNationalAssociationId": "1191010"
+"ListOfficeNationalAssociationId": "1330562"
+"CoListAgentNationalAssociationId": "1134677"
+"CoListOfficeNationalAssociationId": "1330562"
+"Media": array:7 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29750999_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/9ea97cd08f45f13ee03a0a502e9dd81f.webp"
"MediaSize" => 290840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-9ea97cd08f45f13ee03a0a502e9dd81f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29750999_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/d76dde175bf7beb7cad3b29a8ae05c4a.webp"
"MediaSize" => 100833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-d76dde175bf7beb7cad3b29a8ae05c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29750999_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/7c0bcf48ac0c157cf512206d1a1a68fe.webp"
"MediaSize" => 119727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-7c0bcf48ac0c157cf512206d1a1a68fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29750999_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/f75215aa5af6efa3490e0bfe73b6aa21.webp"
"MediaSize" => 134799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-f75215aa5af6efa3490e0bfe73b6aa21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29750999_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/fae5cba85045595ce0cf18281e30eecf.webp"
"MediaSize" => 134210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-fae5cba85045595ce0cf18281e30eecf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29750999_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/ebb57baf0b152219d125235e66a6e5f1.webp"
"MediaSize" => 128874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-ebb57baf0b152219d125235e66a6e5f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29750999_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29750999/93ec3a031ada8f06f921b3f3d6cc6ef6.webp"
"MediaSize" => 250898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29750999/thumbnail-93ec3a031ada8f06f921b3f3d6cc6ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13126502"
"ResourceRecordKey" => "29750999"
"ModificationTimestamp" => "2026-05-14T14:18:09.47Z"
]
]
+"DaysOnMarket": 71
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750999')"
+"ID": "1657897"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1657615"
+post_author: 1
+"ListingKey": "30077951"
+"ListingId": "X13604388"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T21:45:06Z"
+"RFModificationTimestamp": "2026-07-24T22:43:34Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4T3"
+"UnparsedAddress": "A - 185 CEDARVALE CRESCENT, Waterloo, Ontario N2L4T3"
+"Coordinates": array:2 [
0 => -80.547015
1 => 43.488981
]
+"Latitude": 43.488981
+"Longitude": -80.547015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Looking for an updated home with 4 bedrooms & 2 full baths? This Semi maybe the home for you! North end of University of Waterloo & new Hospital to be built, Conestoga Mall & LRT, this 3+1 bedroom, 2 full bath move-in condition semi on quiet Cedarvale Crescent! Freshly painted throughout, carpet free home with a huge fully fenced backyard is perfectly located on a quiet street with lots of beautiful mature tall trees. The main floor features a large Living room with plenty of natural light from the very large front window as well as the brand new ceiling potlights, Dining area with beautiful contemporary chandelier and large window, open to the brand new modern white shaker style kitchen with quartz counters and white fridge and stove. Take the hardwood stairs to the second storey featureing 3 very good size bedrooms and a modern 4 piece main bathroom. The basement features a large bonus room with a good size window and a closet that can be used as a bedroom or a Recroom, a full 3 piece bathroom, Laundry and Utility room with walk up to the backyard. To access the basement, you have 3 options: from the kitchen inside the house, or the separate enterance (exterior side door) from the drive way, or the stairs from the backyard going to the back door (please don't use the back stairs - they haven't been used recently). Updates include but are not limited to: fresh paint throughout 2026, Brand new kitchen with quarz counters 2026, Fridge & Stove 2025, Pot Lights in Living room 2026, LVP flooring in basement & on stairs going to basement 2026, Main water shut-offs 2026, Dryer 2024, Furnace 2020, Roof 2018, Laminate flooring on main and second floors 2018, Hardwood stairs going to second floor 2018, All plumbing replaced on main & second floors 2018. Close to schools, shopping, busses. Shows very well! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T22:43:26.088070+00:00"
+"Directions": "Cross Streets: Cedarbrae Av. & Parkside Dr. ** Directions: Parkside Dr. to Cedarbrae Av to Cedarvale Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160875"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.5 x 116.8 FT ; x 31.63ft. x 122.08ft."
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T21:36:29Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T21:36:28Z"
+"Stories": "2.0"
+"StreetName": "Cedarvale"
+"StreetNumber": "185"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3423"
+"VirtualTourURLUnbranded": "https://youriguide.com/185_a_cedarvale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1692738131"
"RoomType" => "Living room"
"ListingId" => "X13604388"
"RoomLevel" => "Main level"
"RoomWidth" => 4.12
"ListingKey" => "30077951"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
1 => array:11 [
"RoomKey" => "1692738132"
"RoomType" => "Dining room"
"ListingId" => "X13604388"
"RoomLevel" => "Main level"
"RoomWidth" => 2.68
"ListingKey" => "30077951"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
2 => array:11 [
"RoomKey" => "1692738133"
"RoomType" => "Kitchen"
"ListingId" => "X13604388"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "30077951"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
3 => array:11 [
"RoomKey" => "1692738134"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13604388"
"RoomLevel" => "Second level"
"RoomWidth" => 3.14
"ListingKey" => "30077951"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
4 => array:11 [
"RoomKey" => "1692738135"
"RoomType" => "Bedroom 2"
"ListingId" => "X13604388"
"RoomLevel" => "Second level"
"RoomWidth" => 3.15
"ListingKey" => "30077951"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
5 => array:11 [
"RoomKey" => "1692738136"
"RoomType" => "Bedroom 3"
"ListingId" => "X13604388"
"RoomLevel" => "Second level"
"RoomWidth" => 2.76
"ListingKey" => "30077951"
"RoomLength" => 3.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
6 => array:11 [
"RoomKey" => "1692738137"
"RoomType" => "Bathroom"
"ListingId" => "X13604388"
"RoomLevel" => "Second level"
"RoomWidth" => 2.05
"ListingKey" => "30077951"
"RoomLength" => 2.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
7 => array:11 [
"RoomKey" => "1692738138"
"RoomType" => "Bedroom 4"
"ListingId" => "X13604388"
"RoomLevel" => "Basement"
"RoomWidth" => 3.23
"ListingKey" => "30077951"
"RoomLength" => 4.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.94Z"
]
8 => array:11 [
"RoomKey" => "1692738139"
"RoomType" => "Bathroom"
"ListingId" => "X13604388"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "30077951"
"RoomLength" => 2.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.95Z"
]
9 => array:11 [
"RoomKey" => "1692738140"
"RoomType" => "Furnace"
"ListingId" => "X13604388"
"RoomLevel" => "Basement"
"RoomWidth" => 2.32
"ListingKey" => "30077951"
"RoomLength" => 3.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T21:36:28.95Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30077951/a-185-cedarvale-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.6
+"OriginalEntryTimestamp": "2026-07-24T21:36:28.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1411969"
+"ListOfficeNationalAssociationId": "1390130"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30077951_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/37e01dcaf68dca0029f1fdfb6bf7ac9d.webp"
"MediaSize" => 198505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-37e01dcaf68dca0029f1fdfb6bf7ac9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30077951_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/17bfee87c87edff776840e840b5119fe.webp"
"MediaSize" => 216971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-17bfee87c87edff776840e840b5119fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30077951_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/d0ef3976bfd01db0e1cb2fe2c3951e55.webp"
"MediaSize" => 100342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-d0ef3976bfd01db0e1cb2fe2c3951e55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30077951_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/6f18ed3f60f974f84304e566d4508a8a.webp"
"MediaSize" => 104732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-6f18ed3f60f974f84304e566d4508a8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30077951_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/d9cf484f5dae51562709d4302e5cbefb.webp"
"MediaSize" => 107677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-d9cf484f5dae51562709d4302e5cbefb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30077951_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/c9fb880de0d006e1ff46012b8d6d89dd.webp"
"MediaSize" => 105331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-c9fb880de0d006e1ff46012b8d6d89dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30077951_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/faff0f086b3901d37025ffd3ca3d5e7c.webp"
"MediaSize" => 88052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-faff0f086b3901d37025ffd3ca3d5e7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30077951_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/13b9dd7e17b0cef3624842fe76b61438.webp"
"MediaSize" => 91243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-13b9dd7e17b0cef3624842fe76b61438.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30077951_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/eb05ee189adcebe87da0f313c254f3cf.webp"
"MediaSize" => 76093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-eb05ee189adcebe87da0f313c254f3cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30077951_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/f46f26e5d042edf00caa00f416239d14.webp"
"MediaSize" => 99188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-f46f26e5d042edf00caa00f416239d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30077951_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/f1678b3cba83b302f7200ffa31b2dc0a.webp"
"MediaSize" => 90240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-f1678b3cba83b302f7200ffa31b2dc0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30077951_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/d25daf4628766c7d250742b26244e28b.webp"
"MediaSize" => 90173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-d25daf4628766c7d250742b26244e28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30077951_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/3ce3a469f384fd9d2ff0a72980ccf059.webp"
"MediaSize" => 77845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-3ce3a469f384fd9d2ff0a72980ccf059.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30077951_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/b72070a0c9dc3b0a4cbb807489131adf.webp"
"MediaSize" => 77199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-b72070a0c9dc3b0a4cbb807489131adf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30077951_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/2a55da9e71a17615d0b1a1993bb73ca1.webp"
"MediaSize" => 70286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-2a55da9e71a17615d0b1a1993bb73ca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30077951_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/95cfe583093975c0d4ab45234f1c3f95.webp"
"MediaSize" => 64513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-95cfe583093975c0d4ab45234f1c3f95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30077951_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/f2bd5d340507f6728259b2d560a43106.webp"
"MediaSize" => 74211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-f2bd5d340507f6728259b2d560a43106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30077951_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/e217b4f27395e8ff08b1ccc7c8fa4e3c.webp"
"MediaSize" => 80613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-e217b4f27395e8ff08b1ccc7c8fa4e3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30077951_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30077951/bc598b087b7bd6cc1cd0e76991d839c7.webp"
"MediaSize" => 78456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30077951/thumbnail-bc598b087b7bd6cc1cd0e76991d839c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13604388"
"ResourceRecordKey" => "30077951"
"ModificationTimestamp" => "2026-07-24T21:36:28.82Z"
]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077951')"
+"ID": "1657615"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1656367"
+post_author: 1
+"ListingKey": "30076062"
+"ListingId": "40850502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:40:04Z"
+"RFModificationTimestamp": "2026-07-24T18:44:07Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1605.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4T3"
+"UnparsedAddress": "185 CEDARVALE Crescent Unit# A, Waterloo, Ontario N2L4T3"
+"Coordinates": array:2 [
0 => -80.5470388
1 => 43.4889802
]
+"Latitude": 43.4889802
+"Longitude": -80.5470388
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for an updated home with 4 bedrooms & 2 full baths? This Semi maybe the home for you! North end of University of Waterloo & new Hospital to be built, Conestoga Mall & LRT, this 3+1 bedroom, 2 full bath move-in condition semi on quiet Cedarvale Crescent! Freshly painted throughout, carpet free home with a huge fully fenced backyard is perfectly located on a quiet street with lots of beautiful mature tall trees. The main floor features a large Living room with plenty of natural light from the very large front window as well as the brand new ceiling potlights, Dining area with beautiful contemporary chandelier and large window, open to the brand new modern white shaker style kitchen with quartz counters and white fridge and stove. Take the hardwood stairs to the second storey featureing 3 very good size bedrooms and a modern 4 piece main bathroom. The basement features a large bonus room with a good size window and a closet that can be used as a bedroom or a Recroom, a full 3 piece bathroom, Laundry and Utility room with walk up to the backyard. To access the basement, you have 3 options: from the kitchen inside the house, or the separate enterance (exterior side door) from the drive way, or the stairs from the backyard going to the back door (please don't use the back stairs - they haven't been used recently). Updates include but are not limited to: fresh paint throughout 2026, Brand new kitchen with quarz counters 2026, Fridge & Stove 2025, Pot Lights in Living room 2026, LVP flooring in basement & on stairs going to basement 2026, Main water shut-offs 2026, Dryer 2024, Furnace 2020, Roof 2018, Laminate flooring on main and second floors 2018, Hardwood stairs going to second floor 2018, All plumbing replaced on main & second floors 2018. Close to schools, shopping, busses. Shows very well! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T18:14:38.397112+00:00"
+"Directions": "Parkside Dr/Cedarbrae Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564444"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-24T18:33:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:33:27Z"
+"Stories": "2.0"
+"StreetName": "CEDARVALE"
+"StreetNumber": "185"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3423.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/185_a_cedarvale_crescent_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/30076062/185-cedarvale-crescent-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2070594"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1600658"
+"CoListAgentKey3": "1630441"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "290620"
+"CoListOfficeKey3": "76826"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 539
+"OriginalEntryTimestamp": "2026-07-24T17:08:29.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1122502"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1345744"
+"CoListAgentNationalAssociationId2": "1153962"
+"CoListAgentNationalAssociationId3": "1162058"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1389824"
+"CoListOfficeNationalAssociationId3": "1004387"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076062')"
+"ID": "1656367"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+post_id: "1655998"
+post_author: 1
+"ListingKey": "30075412"
+"ListingId": "X13602180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T15:50:06Z"
+"RFModificationTimestamp": "2026-07-24T16:46:27Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3E5"
+"UnparsedAddress": "34 MOORE AVENUE N, Waterloo, Ontario N2J3E5"
+"Coordinates": array:2 [
0 => -80.515934
1 => 43.467934
]
+"Latitude": 43.467934
+"Longitude": -80.515934
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare offering in a prime Uptown Waterloo location, 34 Moore Ave N blends timeless character with a brand-new, top-to-bottom transformation. Completely flipped by the new owners, this home now feels like a contemporary showpiece-everything updated and finished with premium details, plus all-new stainless steel appliances. Step inside to find hardwood flooring throughout, complemented by beautifully renovated living spaces designed for modern comfort. The inviting foyer flows into a bright living room with an elegant layout and large windows, while the dining area connects seamlessly to a fully updated kitchen featuring sleek finishes, abundant counter space, and brand-new stainless steel appliances. At the rear of the home, enjoy a spacious family room perfect for relaxing or entertaining, with space to suit every lifestyle. Upstairs, the primary bedroom has been thoughtfully redesigned with a walk-in closet and a luxury ensuite, creating a private retreat. Two additional well-sized bedrooms offer flexible space for family, guests, or work-from-home needs, and a fourth room-ideal as an office or easily converted back to bedroom use-adds even more versatility. A renovated additional full bath completes the upper level. The basement provides a comfortable rec space along with practical storage and laundry areas. Outside, enjoy a fully upgraded, move-in-ready home on a large lot with outdoor space made for entertaining and everyday enjoyment. With its Uptown Waterloo address just steps to parks, transit, schools, trails, cafés, and shops, while still keeping quick access to the highway and nearby universities, 34 Moore Ave N is truly one of a kind-a stunning home you can enjoy from day one. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T16:46:12.884349+00:00"
+"Directions": "Cross Streets: Bridgeport Road East. ** Directions: Bridgeport to Erb."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213356"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "44 x 154.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T15:41:05Z"
+"PhotosCount": 29
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T15:41:05Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Moore"
+"StreetNumber": "34"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5233"
+"VirtualTourURLUnbranded": "https://youtube.com/watch?v=_nKm4mt_DQw"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30075412/34-moore-avenue-n-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-07-24T15:41:05.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459149"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075412')"
+"ID": "1655998"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1655619"
+post_author: 1
+"ListingKey": "30075265"
+"ListingId": "40848352"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T17:00:06Z"
+"RFModificationTimestamp": "2026-07-24T17:02:21Z"
+"ListPrice": 279800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 397.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H5"
+"UnparsedAddress": "250 ALBERT Street Unit# 311, Waterloo, Ontario N2L0H5"
+"Coordinates": array:2 [
0 => -80.5326714
1 => 43.4753591
]
+"Latitude": 43.4753591
+"Longitude": -80.5326714
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic investment opportunity in Waterloo's vibrant University District! This modern studio condominium is ideally located just steps from Wilfrid Laurier University, the University of Waterloo, Conestoga College Waterloo Campus, the ION LRT, restaurants, shopping, and Waterloo's renowned technology hub. Purpose-built for today's investor, this low-maintenance suite offers the opportunity to own real estate in one of Ontario's strongest and most resilient rental markets. Professional property management is available, making ownership simple and convenient for both local and out-of-town investors. The thoughtfully designed open-concept layout features contemporary finishes, in-suite laundry, and an efficient use of space. Residents enjoy modern amenities and a location that consistently attracts students, faculty, and young professionals year after year. Whether you're expanding your investment portfolio, purchasing for a university student, or entering the real estate market for the first time, this turnkey condominium offers outstanding value in one of Waterloo's most sought-after locations. (id:62650)"
+"AssociationFee": "310.64"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T16:16:49.144495+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239107"
+"ListOfficeKey": "295206"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-24T16:53:11Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:59:48Z"
+"Stories": "6.0"
+"StreetName": "ALBERT"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2320.26"
+"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/30075265/250-albert-street-unit-311-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1526952"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "295206"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RN-6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 397
+"OriginalEntryTimestamp": "2026-07-24T15:30:10.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476987"
+"ListOfficeNationalAssociationId": "1447908"
+"CoListAgentNationalAssociationId": "1139331"
+"CoListOfficeNationalAssociationId": "1447908"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075265')"
+"ID": "1655619"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1655297"
+post_author: 1
+"ListingKey": "30074384"
+"ListingId": "40850568"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T13:30:02Z"
+"RFModificationTimestamp": "2026-07-24T13:35:32Z"
+"ListPrice": 564900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1349.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "265 WESTCOURT Place Unit# PH04, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.5405568
1 => 43.4605745
]
+"Latitude": 43.4605745
+"Longitude": -80.5405568
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Beechmont, where comfort, convenience, and an exceptional location come together. This desirable penthouse suite is ideally situated just steps from Uptown Waterloo, the YMCA, shopping, grocery stores, restaurants, parks, and walking trails, with the expressway only five minutes away for easy commuting. Inside, you'll find a bright and spacious two-bedroom layout featuring an open concept living and dining area designed for both everyday living and entertaining. The modern kitchen offers a stylish and functional space, while the enclosed solarium provides the perfect spot to enjoy your morning coffee, unwind with a book, or take in the views year-round. The primary bedroom includes its own private ensuite, complemented by a second full bathroom for guests or family. Beechmont is a beautifully maintained condominium community offering an impressive selection of amenities, including a fitness centre, games room, library, guest suite, and meticulously landscaped grounds that create a welcoming atmosphere. Whether you're downsizing, seeking a low maintenance lifestyle, or looking for a premium Uptown Waterloo location, this penthouse is an outstanding opportunity. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "831"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T13:35:22.998871+00:00"
+"Directions": "Westmount/Father David Bauer"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "No Pet Home"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-24T13:21:30Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T13:21:30Z"
+"Stories": "1.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4123.36"
+"VirtualTourURLUnbranded": "https://youriguide.com/265_westcourt_pl_ph04_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30074384/265-westcourt-place-unit-ph04-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"CoListOfficeKey2": "76826"
+"ZoningDescription": "MR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1349
+"OriginalEntryTimestamp": "2026-07-24T12:59:01.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30074384')"
+"ID": "1655297"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1651897"
+post_author: 1
+"ListingKey": "30071322"
+"ListingId": "40849888"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T16:35:20Z"
+"RFModificationTimestamp": "2026-07-24T16:39:27Z"
+"ListPrice": 414900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2242.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "121 UNIVERSITY Avenue E Unit# 11, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.5145945
1 => 43.4778187
]
+"Latitude": 43.4778187
+"Longitude": -80.5145945
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this spacious end-unit townhouse in the Village on the Green! Where else can you find over 2,200 sqft of finished living space with 4+1 bedrooms and 3.5 baths at such an affordable price? The main floor features a large eat-in kitchen with updated cabinetry and walk-out to the enclosed yard, a family room, bedroom and 2pc bath. Upstairs you will find an oversized primary bedroom with 3pc ensuite and walk-in closet, two additional bedrooms and a 4pc main bath. The basement has been recently updated to include a fifth bedroom, rec room, 3 pc bath, kitchenette and laundry. This is an excellent opportunity for a turn-key investment, or for families looking for more space they can own vs rent. Enjoy low maintenance living surrounded by mature trees, maintained grounds and a very private backyard. Condo fees cover outside maintenance, lawn/snow, water usage, parking, roof and windows. Additional parking is also available for a low monthly rate. Not that you'll need it...the location is just steps from public transit, directly across from the Conestoga College Waterloo campus, walking distance to both the University of Waterloo and Wilfred Laurier campuses, and Moses Springer Community Centre. Not to mention the quick access you'll enjoy to Hwy 85, as well as numerous shopping, dining, trails and other amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "766.77"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T18:07:11.411915+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067629"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-23T19:38:23Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:30:14Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3709.55"
+"VirtualTourURLUnbranded": "https://youriguide.com/121_university_ave_e_unit_11_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30071322/121-university-avenue-e-unit-11-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1547
+"BelowGradeFinishedArea": 695
+"OriginalEntryTimestamp": "2026-07-23T17:38:25.48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342685"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071322')"
+"ID": "1651897"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: "1649008"
+post_author: 1
+"ListingKey": "30066914"
+"ListingId": "40850253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T00:45:38Z"
+"RFModificationTimestamp": "2026-07-23T00:48:59Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.16
+"LivingArea": 1661.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3E5"
+"UnparsedAddress": "34 MOORE Avenue N, Waterloo, Ontario N2J3E5"
+"Coordinates": array:2 [
0 => -80.5159395
1 => 43.4679327
]
+"Latitude": 43.4679327
+"Longitude": -80.5159395
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in a prime Uptown Waterloo location, 34 Moore Ave N blends timeless character with a brand-new, top-to-bottom transformation. Completely flipped by the new owners, this home now feels like a contemporary showpiece—everything updated and finished with premium details, plus all-new stainless steel appliances. Step inside to find hardwood flooring throughout, complemented by beautifully renovated living spaces designed for modern comfort. The inviting foyer flows into a bright living room with an elegant layout and large windows, while the dining area connects seamlessly to a fully updated kitchen featuring sleek finishes, abundant counter space, and brand-new stainless steel appliances. At the rear of the home, enjoy a spacious family room perfect for relaxing or entertaining, with space to suit every lifestyle. Upstairs, the primary bedroom has been thoughtfully redesigned with a walk-in closet and a luxury ensuite, creating a private retreat. Two additional well-sized bedrooms offer flexible space for family, guests, or work-from-home needs, and a fourth room—ideal as an office or easily converted back to bedroom use—adds even more versatility. A renovated additional full bath completes the upper level. The basement provides a comfortable rec space along with practical storage and laundry areas. Outside, enjoy a fully upgraded, move-in-ready home on a large lot with outdoor space made for entertaining and everyday enjoyment. With its Uptown Waterloo address just steps to parks, transit, schools, trails, cafés, and shops, while still keeping quick access to the highway and nearby universities, 34 Moore Ave N is truly one of a kind—a stunning home you can enjoy from day one. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:37:59.159974+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987695"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T19:08:26Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T00:38:02Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "MOORE"
+"StreetNumber": "34"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5471"
+"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/30066914/34-moore-avenue-n-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-07-22T19:08:26.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1271935"
+"ListOfficeNationalAssociationId": "1458684"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066914')"
+"ID": "1649008"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+post_id: "1649009"
+post_author: 1
+"ListingKey": "30066046"
+"ListingId": "X13593770"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:30:05Z"
+"RFModificationTimestamp": "2026-07-22T19:17:19Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "133 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538447
1 => 43.476844
]
+"Latitude": 43.476844
+"Longitude": -80.538447
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to Society145, a modern, fully furnished ground-floor condominium in one of Waterloo's most sought after student and investor friendly communities. This well designed 2 bedroom , 1-bathroom suite features two spacious bedrooms, each complete with a large window, built-in desk, chair, bed with mattress, and generous closet space, creating a comfortable and functional living environment. The open concept kitchen is beautifully appointed with granite countertops, a stylish backsplash, stainless steel appliances, a built-in microwave, dishwasher, ample cabinetry and a centre island with seating for two. The bright and inviting living area comes fully furnished with a sofa, coffee table, TV, and more, and features a walk-out to a private ground level entrance with direct exterior access-a rare feature that provides added convenience, privacy, and seamless indoor-outdoor living without the need to use the building lobby or elevator. Residents enjoy access to exceptional amenities, including a fully equipped fitness centre, yoga studio, business lounge, media room, multimedia theatre, games room with billiards, ping pong and arcade games, and a rooftop terrace with panoramic city views. Ideally located in the heart of Waterloo. Society145 is within walking distance of the University, close to shopping, restaurants, public transit, an offers convenient access to major highways. Whether you're an investor seeking a turnkey, fully finished rental property or a buyer looking for a stylish, low-maintenance home, this ground floor unit presents a rare opportunity to own a move-in ready suite with direct exterior access, exceptional amenities, and a prime Waterloo location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "337.94"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:17:15.149174+00:00"
+"Directions": "Cross Streets: Columbia St & Philip St. ** Directions: Columbia St & Philip St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2250087"
+"ListOfficeKey": "75381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T17:23:35Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T17:23:35Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3288"
+"View": "View"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/30066046/133-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 => "Separate Electricity Meters"
3 => "Security/Concierge"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Monitored Alarm"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MU25"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-22T17:23:35.36Z"
+"ListAgentNationalAssociationId": "1488976"
+"ListOfficeNationalAssociationId": "1004013"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066046')"
+"ID": "1649009"
}
]
+success: true
+page_size: 9
+page_count: 35
+count: 314
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]