array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30035744 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1637039"
+post_author: 1
+"ListingKey": "30035744"
+"ListingId": "40848279"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:07Z"
+"RFModificationTimestamp": "2026-07-17T20:41:24Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 602.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "258A SUNVIEW Street Unit# 198, Waterloo, Ontario N2L0H6"
+"Coordinates": array:2 [
0 => -80.5339417
1 => 43.474243
]
+"Latitude": 43.474243
+"Longitude": -80.5339417
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to #198-258A Sunview Street, a fantastic opportunity to own a beautifully maintained, fully furnished two bedroom condo in one of Waterloo’s most sought after locations. Ideally situated just steps from Wilfrid Laurier University and only minutes to the University of Waterloo, this property is perfect for students, university staff, professionals, or investors seeking strong rental appeal and exceptional convenience. Lovingly maintained and occupied by only one owner, this bright and inviting unit offers a functional layout with two spacious bedrooms and modern finishes throughout. Move in with ease or start generating rental income immediately, as all furnishings are included. The location truly sets this property apart. Enjoy being within walking distance to restaurants, cafe's, shopping, public transit, and the ION LRT, with Conestoga Mall, Uptown Waterloo, major tech hubs, and Highway 7/8 all just minutes away. Whether you are commuting, studying, shopping, or enjoying the vibrant local amenities, everything you need is right at your doorstep. Offering unbeatable convenience, excellent investment potential, and a central Waterloo address, this turnkey condo is an exceptional opportunity you will not want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "367.37"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:41:15.780591+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-15T21:23:17Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:37Z"
+"Stories": "1.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3263.61"
+"VirtualTourURLUnbranded": "https://youriguide.com/198_258a_sunview_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1686994268"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
1 => array:11 [
"RoomKey" => "1686994269"
"RoomType" => "Living room"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
2 => array:11 [
"RoomKey" => "1686994270"
"RoomType" => "Kitchen"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
3 => array:11 [
"RoomKey" => "1686994271"
"RoomType" => "Dining room"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
4 => array:11 [
"RoomKey" => "1686994272"
"RoomType" => "Bedroom"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
5 => array:11 [
"RoomKey" => "1686994273"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848279"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035744"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:37.93Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30035744/258a-sunview-street-unit-198-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2041614"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "NMU-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 602
+"OriginalEntryTimestamp": "2026-07-15T15:18:28.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1317527"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30035744_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/4591a528dc69cf6562567760936ed576.webp"
"MediaSize" => 184445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-4591a528dc69cf6562567760936ed576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30035744_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/422c568fefdd38788bf9a52cbe5c20ff.webp"
"MediaSize" => 127651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-422c568fefdd38788bf9a52cbe5c20ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.77Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30035744_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/c3092afd9bd9ca3b60cb08258763ef78.webp"
"MediaSize" => 35839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-c3092afd9bd9ca3b60cb08258763ef78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30035744_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/c7dbfca83c68a32e651f303009491e7f.webp"
"MediaSize" => 72058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-c7dbfca83c68a32e651f303009491e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30035744_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/2e80ce62b848bf53eb0eb0efba4e4233.webp"
"MediaSize" => 64644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-2e80ce62b848bf53eb0eb0efba4e4233.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30035744_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/e3157f46adabb42200d0a685719b733c.webp"
"MediaSize" => 71621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-e3157f46adabb42200d0a685719b733c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30035744_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/3cb9d4c6eeb237fc55a41949c8e4687b.webp"
"MediaSize" => 66134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-3cb9d4c6eeb237fc55a41949c8e4687b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:12.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30035744_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/03c0135dda061994877a89fa801d5e71.webp"
"MediaSize" => 67459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-03c0135dda061994877a89fa801d5e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30035744_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/36dc2f5f2ce9f5309bb172f2723eaa64.webp"
"MediaSize" => 67365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-36dc2f5f2ce9f5309bb172f2723eaa64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:15.38Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30035744_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/f4ff5aa860390d64d1ba7b7dac3b0734.webp"
"MediaSize" => 61641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-f4ff5aa860390d64d1ba7b7dac3b0734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.35Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30035744_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/474b19106cc8a0927e3d0a42bb59a673.webp"
"MediaSize" => 53515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-474b19106cc8a0927e3d0a42bb59a673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:15.38Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30035744_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/d3bd78bb86e0e7b0480e6eccc9968454.webp"
"MediaSize" => 65049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-d3bd78bb86e0e7b0480e6eccc9968454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:12.62Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30035744_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/03f98d1acc09898e8106741a543ff0c5.webp"
"MediaSize" => 64140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-03f98d1acc09898e8106741a543ff0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:12.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30035744_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/dfc89f002603a4a5ac805db45a18c968.webp"
"MediaSize" => 49058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-dfc89f002603a4a5ac805db45a18c968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30035744_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/158b5cf39bc20d49a805f520b29041f7.webp"
"MediaSize" => 45882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-158b5cf39bc20d49a805f520b29041f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:13.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30035744_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/e63bd5a6e6e3c26cbe07d9c775dd7460.webp"
"MediaSize" => 61460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-e63bd5a6e6e3c26cbe07d9c775dd7460.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30035744_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/eec659d598c7aff58617db563df58ff9.webp"
"MediaSize" => 44111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-eec659d598c7aff58617db563df58ff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30035744_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/450f1cb63a8577267a7ba030826c0b61.webp"
"MediaSize" => 57788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-450f1cb63a8577267a7ba030826c0b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:13.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30035744_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/b12a8637a672ca098f31f2f13651cbc4.webp"
"MediaSize" => 57191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-b12a8637a672ca098f31f2f13651cbc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30035744_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/c39ab915ce40b9219a3a5432d33218fa.webp"
"MediaSize" => 72258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-c39ab915ce40b9219a3a5432d33218fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30035744_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/bdadef768f7d30dcedcb395dd603a982.webp"
"MediaSize" => 61501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-bdadef768f7d30dcedcb395dd603a982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30035744_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/1e792edf234d394d85ac8d8884934dda.webp"
"MediaSize" => 83955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-1e792edf234d394d85ac8d8884934dda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.02Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30035744_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/cb9401631c1acde98d88c1b7c4962008.webp"
"MediaSize" => 76743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-cb9401631c1acde98d88c1b7c4962008.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.77Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30035744_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/4b4967e3257b7c93e389a8c5aad9ab31.webp"
"MediaSize" => 110925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-4b4967e3257b7c93e389a8c5aad9ab31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.02Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30035744_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/b05605724b263a8560cff2ac35942406.webp"
"MediaSize" => 110122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-b05605724b263a8560cff2ac35942406.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:14.42Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30035744_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/97e337f3e84e7c08a8bde9a3457dc6e8.webp"
"MediaSize" => 149956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-97e337f3e84e7c08a8bde9a3457dc6e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.76Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30035744_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/124d5305287bd961d3a562aaeabce9ea.webp"
"MediaSize" => 171636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-124d5305287bd961d3a562aaeabce9ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.77Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30035744_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/adf8db2d09ed30ea43b80647db23dfc7.webp"
"MediaSize" => 181284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-adf8db2d09ed30ea43b80647db23dfc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:12.56Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30035744_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/0cce2e62c07f65c99ce572a77a947e68.webp"
"MediaSize" => 197953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-0cce2e62c07f65c99ce572a77a947e68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:13.75Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30035744_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/89c5b2c0ecfddde4c6a5736dd8fa856e.webp"
"MediaSize" => 174967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-89c5b2c0ecfddde4c6a5736dd8fa856e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.77Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30035744_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035744/a036d831b6c973fee6c0f9c64c63760f.webp"
"MediaSize" => 41727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035744/thumbnail-a036d831b6c973fee6c0f9c64c63760f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848279"
"ResourceRecordKey" => "30035744"
"ModificationTimestamp" => "2026-07-15T21:23:17.78Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035744')"
+"ID": "1637039"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289792" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24975
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24919
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-740-3690"
+"OfficeMlsId": "CA724"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289792"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1400 BISHOP ST. N, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N1R6W"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1381240"
+"OriginalEntryTimestamp": "2021-03-11T15:35:00Z"
+"OfficeFax": "519-740-7230"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "433716"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "289792"
"SocialMediaUrlOrId" => "https://www.remaxtwincity.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('289792')"
}
]
+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 1750682" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24929
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30035744'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25266
+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 '30035744' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25282
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30035744' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5339417 43.474243)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25335
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1638246"
+post_author: 1
+"ListingKey": "30051129"
+"ListingId": "40848498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:25:17Z"
+"RFModificationTimestamp": "2026-07-18T00:46:09Z"
+"ListPrice": 339900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 792.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "181 KING Street S Unit# 1002, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5200051
1 => 43.4605065
]
+"Latitude": 43.4605065
+"Longitude": -80.5200051
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Elevated Urban Living at Circa 1877 - Welcome to one of Uptown Waterloo's most desirable condominium communities. Situated in the prestigious Bauer District, this beautifully finished 1-bedroom, 1-bathroom suite combines contemporary design, exceptional amenities, and an unbeatable walkable location. The bright open-concept layout is enhanced by floor-to-ceiling windows that fill the space with natural light, while the oversized private terrace provides the perfect place to enjoy your morning coffee or unwind at the end of the day. Inside, you'll find wide-plank flooring, soaring ceilings, quartz countertops, and a stylish 3-piece bathroom designed for modern living. Circa 1877 offers an exceptional collection of resort-inspired amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, yoga studios, a 24/7 fitness centre, co-working lounges, an elegant party room with a wet bar, and guest suites for visiting family and friends. LaLa Social House, located within the building, completes the boutique hotel-style experience. Step outside and enjoy everything Uptown Waterloo has to offer. You're just moments from Vincenzo's, boutique shopping, cafés, restaurants, Grand River Hospital, and scenic walking trails. Both the University of Waterloo and Wilfrid Laurier University are nearby, along with Waterloo's thriving innovation district, home to leading employers including Google, Deloitte, and Sun Life. With the ION LRT right outside the door, commuting throughout Waterloo Region is effortless. Whether you're a first-time buyer, professional, downsizer, or investor, this exceptional home offers the perfect combination of luxury, convenience, and low-maintenance living in one of the region's most sought-after addresses. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Oven - Built-In"
5 => "Hood Fan"
]
+"AssociationFee": "661"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T00:46:08.071284+00:00"
+"Directions": "Caroline x Allen X King"
+"ExteriorFeatures": array:4 [
0 => "Steel"
1 => "Concrete"
2 => "Brick"
3 => "Metal"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750629"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-18T00:18:17Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:18:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4357"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1687220179"
"RoomType" => "Kitchen"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
1 => array:11 [
"RoomKey" => "1687220180"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
2 => array:11 [
"RoomKey" => "1687220181"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30051129/181-king-street-s-unit-1002-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1750669"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1750626"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"CoListOfficeKey2": "156288"
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 792
+"OriginalEntryTimestamp": "2026-07-18T00:18:17.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1066267"
+"ListOfficeNationalAssociationId": "1112493"
+"CoListAgentNationalAssociationId": "1066273"
+"CoListAgentNationalAssociationId2": "1140202"
+"CoListOfficeNationalAssociationId": "1112493"
+"CoListOfficeNationalAssociationId2": "1112493"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051129_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/c74abd44035566c475f0e6bd3a402e87.webp"
"MediaSize" => 133513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-c74abd44035566c475f0e6bd3a402e87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051129_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/3c631527d4c67825e4280f0bdf49cef8.webp"
"MediaSize" => 135563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-3c631527d4c67825e4280f0bdf49cef8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051129_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/0c2205ecbfe4ed80f247e377e7dac3b2.webp"
"MediaSize" => 136170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-0c2205ecbfe4ed80f247e377e7dac3b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051129_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/df33f999ae6f05d6c711670421b1a719.webp"
"MediaSize" => 52419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-df33f999ae6f05d6c711670421b1a719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051129_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/d4fcc7fdd9e9de6ab36df0ab1c9c9453.webp"
"MediaSize" => 89849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-d4fcc7fdd9e9de6ab36df0ab1c9c9453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051129_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/bd53696b328c570bb4f88cabcbe6f154.webp"
"MediaSize" => 74612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-bd53696b328c570bb4f88cabcbe6f154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051129_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/05402a5c39e211009c964919beba386f.webp"
"MediaSize" => 115697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-05402a5c39e211009c964919beba386f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30051129_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a43699ef4e38985ba2b8e0b59ecda74f.webp"
"MediaSize" => 136267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a43699ef4e38985ba2b8e0b59ecda74f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30051129_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a2d73e14016062a5a2a08b0814fda5ef.webp"
"MediaSize" => 144628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a2d73e14016062a5a2a08b0814fda5ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30051129_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/b867cf4d7ba07f75a0d8f5140df45f01.webp"
"MediaSize" => 147331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-b867cf4d7ba07f75a0d8f5140df45f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30051129_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/739bdd67c8b2548e0692174989b8ac21.webp"
"MediaSize" => 66469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-739bdd67c8b2548e0692174989b8ac21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30051129_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a06df3231cadf3dc3eaa8e55ae9d1047.webp"
"MediaSize" => 55335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a06df3231cadf3dc3eaa8e55ae9d1047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051129')"
+"ID": "1638246"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1638247"
+post_author: 1
+"ListingKey": "30051132"
+"ListingId": "X13579662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:30:00Z"
+"RFModificationTimestamp": "2026-07-18T00:45:34Z"
+"ListPrice": 339900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "1002 - 181 KING STREET S, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5200073
1 => 43.4605955
]
+"Latitude": 43.4605955
+"Longitude": -80.5200073
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Elevated Urban Living at Circa 1877 - Welcome to one of Uptown Waterloo's most desirable condominium communities. Situated in the prestigious Bauer District, this beautifully finished 1-bedroom, 1-bathroom suite combines contemporary design, exceptional amenities, and an unbeatable walkable location. The bright open-concept layout is enhanced by floor-to-ceiling windows that fill the space with natural light, while the oversized private terrace provides the perfect place to enjoy your morning coffee or unwind at the end of the day. Inside, you'll find wide-plank flooring, soaring ceilings, quartz countertops, and a stylish 3-piece bathroom designed for modern living. Circa 1877 offers an exceptional collection of resort-inspired amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, yoga studios, a 24/7 fitness centre, co-working lounges, an elegant party room with a wet bar, and guest suites for visiting family and friends. LaLa Social House, located within the building, completes the boutique hotel-style experience. Step outside and enjoy everything Uptown Waterloo has to offer. You're just moments from Vincenzo's, boutique shopping, cafés, restaurants, Grand River Hospital, and scenic walking trails. Both the University of Waterloo and Wilfrid Laurier University are nearby, along with Waterloo's thriving innovation district, home to leading employers including Google, Deloitte, and Sun Life. With the ION LRT right outside the door, commuting throughout Waterloo Region is effortless. Whether you're a first-time buyer, professional, downsizer, or investor, this exceptional home offers the perfect combination of luxury, convenience, and low-maintenance living in one of the region's most sought-after addresses. (id:62650)"
+"Appliances": array:1 [
0 => "Intercom"
]
+"AssociationFee": "661"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T00:45:27.038371+00:00"
+"Directions": "Cross Streets: King St S and Allen St W. ** Directions: between Allen St W and George St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241047"
+"ListOfficeKey": "217401"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T00:28:14Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:28:14Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4357"
+"ListAOR": "London and St. Thomas"
+"TaxYear": 2026
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30051132/1002-181-king-street-s-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2004386"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "KING CONDO MANAGEMENT"
+"CoListOfficeKey": "217401"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-18T00:20:34.3Z"
+"ListAgentNationalAssociationId": "1479201"
+"ListOfficeNationalAssociationId": "1316773"
+"CoListAgentNationalAssociationId": "1318742"
+"CoListOfficeNationalAssociationId": "1316773"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051132_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/fb5f2da9c48747bd0278737755bd6da0.webp"
"MediaSize" => 304200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-fb5f2da9c48747bd0278737755bd6da0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051132_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/776352ee982bbc95fe6ea1ad38b33bd7.webp"
"MediaSize" => 311186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-776352ee982bbc95fe6ea1ad38b33bd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:13.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051132_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/38cdfffc690030a7fa3b95474253b0a0.webp"
"MediaSize" => 307368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-38cdfffc690030a7fa3b95474253b0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051132_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/170019943700d188dfa56a11f5dca75f.webp"
"MediaSize" => 133418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-170019943700d188dfa56a11f5dca75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051132_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/117bdc1fa5a6947cf89503d2eba858ba.webp"
"MediaSize" => 206746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-117bdc1fa5a6947cf89503d2eba858ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051132_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/e9e6353dd8999a2afa7a33aad920c9c0.webp"
"MediaSize" => 176747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-e9e6353dd8999a2afa7a33aad920c9c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051132_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/f8c7b47b2e066f2bdf7b863c7dacce38.webp"
"MediaSize" => 263805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-f8c7b47b2e066f2bdf7b863c7dacce38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30051132_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/d72c3568aba5de80895a5968fd738990.webp"
"MediaSize" => 373175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-d72c3568aba5de80895a5968fd738990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30051132_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/e30ff5a8b191181b5f235c9bafcb8423.webp"
"MediaSize" => 151339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-e30ff5a8b191181b5f235c9bafcb8423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:20:34.3Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30051132_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/3c69bbfaaf91a836edeff6f848dbe893.webp"
"MediaSize" => 125818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-3c69bbfaaf91a836edeff6f848dbe893.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:20:34.3Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051132')"
+"ID": "1638247"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1637877"
+post_author: 1
+"ListingKey": "30034574"
+"ListingId": "40848343"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:07Z"
+"RFModificationTimestamp": "2026-07-17T23:39:09Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1072.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4L6"
+"UnparsedAddress": "375 KING Street N Unit# 1608, Waterloo, Ontario N2J4L6"
+"Coordinates": array:2 [
0 => -80.527067
1 => 43.4824701
]
+"Latitude": 43.4824701
+"Longitude": -80.527067
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this bright and generously sized 2-bedroom, 1-bathroom condo in the heart of Waterloo! Featuring over 1,000 sq. ft. of living space, this unit offers a functional layout with a large living/dining area, a well-appointed kitchen, and spacious bedrooms. Panoramic view from your private balcony. Conveniently located near shopping, transit, universities, and major highways, this unit is perfect for First Time home buyers, investors, or move up buyers looking to live in heart of Waterloo. Building amenities include a large gym, conference room, arts & crafts room, party room, ample visitor parking, indoor rooftop swimming pool, workshop, library , billiards table & a ping pong table. Also there is a free car wash in parking level for building residents. Book your showing today! ( Locker available & 1 covered parking available underground.) Also note that all utilities are included in the condo fees. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "900.76"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
6 => "Other, See Remarks"
7 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:38:57.068795+00:00"
+"Directions": "Columbia Street West & King Street North"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073879"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-15T11:49:34Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "375"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2110"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1686993902"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
1 => array:11 [
"RoomKey" => "1686993903"
"RoomType" => "Bedroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
2 => array:11 [
"RoomKey" => "1686993904"
"RoomType" => "Bedroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
3 => array:11 [
"RoomKey" => "1686993905"
"RoomType" => "Kitchen"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
4 => array:11 [
"RoomKey" => "1686993906"
"RoomType" => "Dining room"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
5 => array:11 [
"RoomKey" => "1686993907"
"RoomType" => "Living room"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034574/375-king-street-n-unit-1608-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1072
+"OriginalEntryTimestamp": "2026-07-15T11:49:34.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1355211"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30034574_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/c7c73c70f992fbef15d9be6e13389cfb.webp"
"MediaSize" => 154301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-c7c73c70f992fbef15d9be6e13389cfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise residential building featuring multiple private balconies, a flat roofline, and a prominent blue and yellow facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30034574_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/1db92dd01fd803404c304bde8078a221.webp"
"MediaSize" => 160532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-1db92dd01fd803404c304bde8078a221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building with multiple balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30034574_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/94cc92555e8e061c08653342195d469c.webp"
"MediaSize" => 156260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-94cc92555e8e061c08653342195d469c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a covered entryway with structural columns and a glass-enclosed entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30034574_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/1e611d02fd1b49577da63acb73d3f42f.webp"
"MediaSize" => 127885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-1e611d02fd1b49577da63acb73d3f42f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lobby featuring large windows, patterned carpet flooring, mirrored wall accents, and an arched entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30034574_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/edcb4f34203b505819f42f12e010721f.webp"
"MediaSize" => 122478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-edcb4f34203b505819f42f12e010721f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lobby with patterned carpet flooring, dual chandeliers, and an arched entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
…2
]
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034574')"
+"ID": "1637877"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1637579"
+post_author: 1
+"ListingKey": "30050486"
+"ListingId": "X13579042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T21:45:05Z"
+"RFModificationTimestamp": "2026-07-17T22:43:55Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "125 - 258A SUNVIEW STREET, Waterloo, Ontario N2L0H6"
+"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": "Welcome to this turnkey, fully furnished 2-bedroom condominium offering modern, low-maintenance living in one of Waterloo's most desirable communities. The thoughtfully designed open-concept layout features two spacious bedrooms, a modern kitchen, in-suite laundry and contemporary finishes throughout. This suite presents an exceptional opportunity for investors looking to generate strong rental income, parents purchasing for a university student, or first-time buyers seeking an affordable entry into Waterloo's thriving real estate market. With strong demand from students and professionals alike, this property offers excellent rental potential and long-term value. Condo fees include high-speed Internet, heat, water, air conditioning, building insurance and common elements. Residents enjoy an impressive selection of building amenities including a rooftop terrace, study lounges, secure key fob entry, elevator access, bike storage and visitor parking. Ideally situated near the University of Waterloo, Wilfrid Laurier University, Conestoga College Waterloo Campus, the ION LRT and everyday amenities, this location also offers convenient access to Uptown Waterloo, major highways and the Region's renowned technology corridor, including Google, OpenText, Shopify and Deloitte. An exceptional opportunity to own a move-in ready property, don't miss your chance to make this sought-after location your next investment! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
]
+"AssociationFee": "323.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
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-17T22:43:47.899937+00:00"
+"Directions": "Cross Streets: King St N and University Ave W. ** Directions: NW of Sunview St and University Ave W."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076954"
+"ListOfficeKey": "275987"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T21:39:28Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T21:39:28Z"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30050486/125-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-17T21:39:28.8Z"
+"ListAgentNationalAssociationId": "1352117"
+"ListOfficeNationalAssociationId": "1269835"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050486')"
+"ID": "1637579"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1637038"
+post_author: 1
+"ListingKey": "30031718"
+"ListingId": "40847893"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:06Z"
+"RFModificationTimestamp": "2026-07-17T20:45:54Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1043.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4S8"
+"UnparsedAddress": "249 CEDARBRAE Avenue Unit# 1, Waterloo, Ontario N2L4S8"
+"Coordinates": array:2 [
0 => -80.5506971
1 => 43.4854032
]
+"Latitude": 43.4854032
+"Longitude": -80.5506971
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Wonderful Property in Desirable Waterloo Location with a rental license for 5!!!! Great Investment opportunity! The carpet-free house is on a quiet street, a short walk to the Universities, Shopping stores, and bus routes (bus line 9 just at the corner). 3 Bedrooms on the second floor and two bedrooms in the basement, each bedroom is spacious. The Living Room is Sunny - very bright, and has a hardwood floor. The Kitchen is wide open, has Abundance Cabinets, the common areas are airy, with good-sized windows, and the whole house has a good layout and is well-maintained. Two full baths - one on the second floor, one in the basement. Beautiful front yard, 1 parking spot included at the back of the unit. Updates include a new kitchen with Quartz Countertops (2021), a new bathroom with Quartz Countertops on the 2nd floor (Dec 2024), a Hot Water Heater (2025), and new painting in the basement (2026. Walking Distance To University Of Waterloo! A MUST-SEE house. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "493.47"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-17T20:45:42.164166+00:00"
+"Directions": "GLEN FORREST BLVD Complex Parking Lot Is Off Glen Forrest Boulevard..."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-14T18:18:04Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:08Z"
+"Stories": "2.0"
+"StreetName": "CEDARBRAE"
+"StreetNumber": "249"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2498.91"
+"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/30031718/249-cedarbrae-avenue-unit-1-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1043
+"OriginalEntryTimestamp": "2026-07-14T18:18:03.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031718')"
+"ID": "1637038"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1637099"
+post_author: 1
+"ListingKey": "30038060"
+"ListingId": "40848404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:08Z"
+"RFModificationTimestamp": "2026-07-17T20:40:34Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.272
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE Drive, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.5513334
1 => 43.4621325
]
+"Latitude": 43.4621325
+"Longitude": -80.5513334
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is the Beechwood home you’ve been waiting for. Tucked beneath mature trees & set on an exceptional 78’ x 181’ lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo’s most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:40:23.159836+00:00"
+"Directions": "KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.272"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:03:30Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:21Z"
+"Stories": "2.0"
+"StreetName": "MARLOWE"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30038060/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 2064
+"BelowGradeFinishedArea": 802
+"OriginalEntryTimestamp": "2026-07-15T19:48:18.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"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('30038060')"
+"ID": "1637099"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1635569"
+post_author: 1
+"ListingKey": "30046734"
+"ListingId": "X13575452"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T13:45:03Z"
+"RFModificationTimestamp": "2026-07-17T17:39:00Z"
+"ListPrice": 509000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "101 - 253 LESTER STREET, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.53499
1 => 43.4738
]
+"Latitude": 43.4738
+"Longitude": -80.53499
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible turnkey investment in the heart of Waterloo's university district! This purpose-built 5-bedroom, 2-bathroom condo at 253 Lester St has the potential to generate over $49,000/year in gross rental income with positive monthly cash flow. Just steps to Wilfrid Laurier University and the University of Waterloo, this high-demand location ensures consistent tenancy. Features include a spacious open-concept living area, two full baths, included furniture, and professional property management options for a completely hands-off experience. Condo fees include heat and water, and the building offers parking, shared laundry, elevator access, and proximity to transit, shops, and amenities. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
]
+"AssociationFee": "802"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:38:47.258343+00:00"
+"Directions": "University Ave W/Lester St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045015"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T13:39:06Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T13:39:05Z"
+"StreetName": "Lester"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3950"
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30046734/101-253-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2022731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CIE Property Management"
+"CoListOfficeKey": "278195"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-07-17T13:39:05.97Z"
+"ListAgentNationalAssociationId": "1320619"
+"ListOfficeNationalAssociationId": "1268183"
+"CoListAgentNationalAssociationId": "1302336"
+"CoListOfficeNationalAssociationId": "1290805"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046734')"
+"ID": "1635569"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1632810"
+post_author: 1
+"ListingKey": "30044435"
+"ListingId": "X13573690"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:05:22Z"
+"RFModificationTimestamp": "2026-07-17T20:21:32Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5L6"
+"UnparsedAddress": "3 - 513 QUIET PLACE, Waterloo, Ontario N2L5L6"
+"Coordinates": array:2 [
0 => -80.543693
1 => 43.486532
]
+"Latitude": 43.486532
+"Longitude": -80.543693
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 513 Quiet Place, Unit 3, a beautifully maintained, move-in ready townhome located at the prime intersection of Albert Street and Phillip Street in Waterloo's highly sought-after Lakeshore South neighbourhood. This stylish home offers exceptional value for first-time buyers, families, professionals, and investors alike. From the moment you arrive, you'll appreciate the attractive two-tone exterior, black-trimmed windows, and charming front garden that create outstanding curb appeal. Inside, a bright and welcoming foyer with updated flooring in 2022 and pot lights throughout leads into the spacious living room, where an oversized front window fills the space with abundant natural light. The open-concept layout is perfect for both everyday living and entertaining. The updated kitchen features modern cabinetry, stainless steel appliances, a stylish tile backsplash, and generous counter space, while the adjoining dining area overlooks the front garden, creating a bright and inviting setting for family meals. Upstairs, you'll find three generously sized bedrooms and a beautifully renovated bathroom complete with sleek finishes, a modern vanity, and a tiled glass-enclosed shower. The spacious primary bedroom offers plenty of room to relax, while the additional bedrooms are ideal for children, guests, or a home office. The finished basement provides valuable additional living space and features a separate side entrance, a large recreation room, a full bathroom, and ample storage, offering excellent flexibility for extended family, guests, or future potential. Ideally located just steps from Albert McCormick Community Centre, parks, shopping, cafés, and two public schools, this home is also within walking distance of the ION LRT station, making commuting throughout Waterloo and Kitchener quick and convenient. Whether you're looking for your first home or an excellent investment opportunity, this is a property you won't want to miss. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "670.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T22:43:31.189594+00:00"
+"Directions": "Cross Streets: Weber. ** Directions: Albert Street to Quiet place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:59:07Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:59:07Z"
+"Stories": "2.0"
+"StreetName": "Quiet"
+"StreetNumber": "513"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2973"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3_513_quiet_pl_waterloo_on/"
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30044435/3-513-quiet-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-16T20:39:42.28Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044435')"
+"ID": "1632810"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1631896"
+post_author: 1
+"ListingKey": "30042236"
+"ListingId": "40847160"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:00:06Z"
+"RFModificationTimestamp": "2026-07-17T23:41:16Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1794.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5L6"
+"UnparsedAddress": "513 QUIET Place Unit# 3, Waterloo, Ontario N2L5L6"
+"Coordinates": array:2 [
0 => -80.5436938
1 => 43.486508
]
+"Latitude": 43.486508
+"Longitude": -80.5436938
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 513 Quiet Place, Unit 3, a beautifully maintained, move-in ready townhome located at the prime intersection of Albert Street and Phillip Street in Waterloo's highly sought-after Lakeshore South neighbourhood. This stylish home offers exceptional value for first-time buyers, families, professionals, and investors alike. From the moment you arrive, you'll appreciate the attractive two-tone exterior, black-trimmed windows, and charming front garden that create outstanding curb appeal. Inside, a bright and welcoming foyer with updated flooring in 2022 and pot lights throughout leads into the spacious living room, where an oversized front window fills the space with abundant natural light. The open-concept layout is perfect for both everyday living and entertaining. The updated kitchen features modern cabinetry, stainless steel appliances, a stylish tile backsplash, and generous counter space, while the adjoining dining area overlooks the front garden, creating a bright and inviting setting for family meals. Upstairs, you'll find three generously sized bedrooms and a beautifully renovated bathroom complete with sleek finishes, a modern vanity, and a tiled glass-enclosed shower. The spacious primary bedroom offers plenty of room to relax, while the additional bedrooms are ideal for children, guests, or a home office. The finished basement provides valuable additional living space and features a separate side entrance, a large recreation room, a full bathroom, and ample storage, offering excellent flexibility for extended family, guests, or future potential. Ideally located just steps from Albert McCormick Community Centre, parks, shopping and two public schools, this home is also within walking distance of the ION LRT station, making commuting throughout Waterloo and Kitchener quick and convenient. Whether you're looking for your first home or an excellent investment opportunity, this is a property you won't want to miss. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "670.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T19:54:35.362696+00:00"
+"Directions": "Albert Street to Quiet place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-17T19:52:53Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:52:53Z"
+"Stories": "2.0"
+"StreetName": "QUIET"
+"StreetNumber": "513"
+"StreetSuffix": "Place"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "2973"
+"VirtualTourURLUnbranded": "https://youriguide.com/3_513_quiet_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30042236/513-quiet-place-unit-3-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1240
+"BelowGradeFinishedArea": 554
+"OriginalEntryTimestamp": "2026-07-16T16:30:18.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042236')"
+"ID": "1631896"
}
]
+success: true
+page_size: 9
+page_count: 40
+count: 357
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]