array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30044435 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: "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 [
"RoomKey" => "1686276078"
"RoomType" => "Bathroom"
"ListingId" => "X13573690"
"RoomLevel" => "Second level"
"RoomWidth" => 2.36
"ListingKey" => "30044435"
"RoomLength" => 1.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
1 => array:11 [
"RoomKey" => "1686276079"
"RoomType" => "Bedroom"
"ListingId" => "X13573690"
"RoomLevel" => "Second level"
"RoomWidth" => 3.72
"ListingKey" => "30044435"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
2 => array:11 [
"RoomKey" => "1686276080"
"RoomType" => "Bedroom 2"
"ListingId" => "X13573690"
"RoomLevel" => "Second level"
"RoomWidth" => 2.81
"ListingKey" => "30044435"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
3 => array:11 [
"RoomKey" => "1686276081"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13573690"
"RoomLevel" => "Second level"
"RoomWidth" => 3.25
"ListingKey" => "30044435"
"RoomLength" => 4.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
4 => array:11 [
"RoomKey" => "1686276082"
"RoomType" => "Bathroom"
"ListingId" => "X13573690"
"RoomLevel" => "Basement"
"RoomWidth" => 2.15
"ListingKey" => "30044435"
"RoomLength" => 1.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
5 => array:11 [
"RoomKey" => "1686276083"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13573690"
"RoomLevel" => "Basement"
"RoomWidth" => 6.23
"ListingKey" => "30044435"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
6 => array:11 [
"RoomKey" => "1686276084"
"RoomType" => "Utility room"
"ListingId" => "X13573690"
"RoomLevel" => "Basement"
"RoomWidth" => 4.69
"ListingKey" => "30044435"
"RoomLength" => 3.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
7 => array:11 [
"RoomKey" => "1686276085"
"RoomType" => "Dining room"
"ListingId" => "X13573690"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "30044435"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.35Z"
]
8 => array:11 [
"RoomKey" => "1686276086"
"RoomType" => "Kitchen"
"ListingId" => "X13573690"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "30044435"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.36Z"
]
9 => array:11 [
"RoomKey" => "1686276087"
"RoomType" => "Living room"
"ListingId" => "X13573690"
"RoomLevel" => "Main level"
"RoomWidth" => 6.34
"ListingKey" => "30044435"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-16T23:09:49.36Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30044435_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/f062d0ee5fdc6988d2229ce9a45624da.webp"
"MediaSize" => 447796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-f062d0ee5fdc6988d2229ce9a45624da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T20:39:42.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30044435_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/dd1e2e340e5d085dd554234e981b91fe.webp"
"MediaSize" => 365383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-dd1e2e340e5d085dd554234e981b91fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.49Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30044435_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/63e7ac426e608fff8e727fb6ddb77f07.webp"
"MediaSize" => 177517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-63e7ac426e608fff8e727fb6ddb77f07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:44.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30044435_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/27d0ce32344a38ea3380f707ba1e6cf2.webp"
"MediaSize" => 126487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-27d0ce32344a38ea3380f707ba1e6cf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30044435_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/97adb30af198f38923e52cd53037e996.webp"
"MediaSize" => 132888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-97adb30af198f38923e52cd53037e996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30044435_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/999ce144c4ce8c0ef9bc3f75b82af1b4.webp"
"MediaSize" => 170732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-999ce144c4ce8c0ef9bc3f75b82af1b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.44Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30044435_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/9e2e06210813d65faee982ae3fd56213.webp"
"MediaSize" => 184250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-9e2e06210813d65faee982ae3fd56213.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:43.04Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30044435_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/7ff16989a2a9104d76362fa8c275e1fa.webp"
"MediaSize" => 141728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-7ff16989a2a9104d76362fa8c275e1fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30044435_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/0fc6173d2c7401f8e4275b64304cf6f2.webp"
"MediaSize" => 111978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-0fc6173d2c7401f8e4275b64304cf6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.53Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30044435_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/0b3ff99455b67953c1e7456de1c03fc7.webp"
"MediaSize" => 157845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-0b3ff99455b67953c1e7456de1c03fc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30044435_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/8a47423731cd5e821046bb4ac95d2e60.webp"
"MediaSize" => 130521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-8a47423731cd5e821046bb4ac95d2e60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30044435_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/7d45009f4624703db5e62c15c9462a01.webp"
"MediaSize" => 184945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-7d45009f4624703db5e62c15c9462a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.62Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30044435_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/07b2322bdeaf4eace7a6a8bd4918e457.webp"
"MediaSize" => 143600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-07b2322bdeaf4eace7a6a8bd4918e457.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.26Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30044435_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/fb2beec430ef952b518ea2aae8b94e8b.webp"
"MediaSize" => 148851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-fb2beec430ef952b518ea2aae8b94e8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30044435_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/5c71fe258651748930ede05ca92b4f43.webp"
"MediaSize" => 109565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-5c71fe258651748930ede05ca92b4f43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:39.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30044435_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/b4d8742fd2c717cf039f8d4c515d4458.webp"
"MediaSize" => 99588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-b4d8742fd2c717cf039f8d4c515d4458.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:40.25Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30044435_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/b70c7e5ef7fa8ec136d52d2f9ffc92f7.webp"
"MediaSize" => 105595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-b70c7e5ef7fa8ec136d52d2f9ffc92f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:40.34Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30044435_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/4744b117fd32a0eab3ae6bf22d31033c.webp"
"MediaSize" => 161340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-4744b117fd32a0eab3ae6bf22d31033c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.3Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30044435_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/59eafbc12a2ffd778249071ba053fc0e.webp"
"MediaSize" => 152441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-59eafbc12a2ffd778249071ba053fc0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30044435_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/6b627ac29f61e8fe092d98d8ef26d328.webp"
"MediaSize" => 126042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-6b627ac29f61e8fe092d98d8ef26d328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.37Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30044435_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/d05d38a409dadc1093ce6d549c09249b.webp"
"MediaSize" => 172764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-d05d38a409dadc1093ce6d549c09249b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.48Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30044435_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/145358b30f9557d782f55475e2072ee6.webp"
"MediaSize" => 134954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-145358b30f9557d782f55475e2072ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.23Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30044435_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/71c4f86ac1f3862c094ec2a950165750.webp"
"MediaSize" => 124413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-71c4f86ac1f3862c094ec2a950165750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.49Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30044435_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/02df92f97a4c3306d8740581ab553e6f.webp"
"MediaSize" => 99295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-02df92f97a4c3306d8740581ab553e6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.34Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30044435_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/108c352e48f16cd755c589da04f03b50.webp"
"MediaSize" => 183432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-108c352e48f16cd755c589da04f03b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.29Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30044435_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/042531ffeb747abf99bce7dfd1ac33b2.webp"
"MediaSize" => 171404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-042531ffeb747abf99bce7dfd1ac33b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.33Z"
]
26 => array:13 [
"Order" => 28
"MediaKey" => "30044435_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/769aa76e65a5ab94d823165d5dac3992.webp"
"MediaSize" => 247431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-769aa76e65a5ab94d823165d5dac3992.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.2Z"
]
27 => array:13 [
"Order" => 29
"MediaKey" => "30044435_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/01a01bd0eea4736f398a200e0ac61657.webp"
"MediaSize" => 300472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-01a01bd0eea4736f398a200e0ac61657.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:41.86Z"
]
28 => array:13 [
"Order" => 30
"MediaKey" => "30044435_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/a59a74558735c3f539cfe2264aaee4ec.webp"
"MediaSize" => 548041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-a59a74558735c3f539cfe2264aaee4ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.35Z"
]
29 => array:13 [
"Order" => 31
"MediaKey" => "30044435_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/c73a6a771c14936a6e86fb119ccf815c.webp"
"MediaSize" => 425322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-c73a6a771c14936a6e86fb119ccf815c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.32Z"
]
30 => array:13 [
"Order" => 32
"MediaKey" => "30044435_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/9b70d0acabd49770896fc4e8b64b5c73.webp"
"MediaSize" => 346373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-9b70d0acabd49770896fc4e8b64b5c73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.45Z"
]
31 => array:13 [
"Order" => 33
"MediaKey" => "30044435_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/ab1360f9ecb29139c80c689ec679329d.webp"
"MediaSize" => 445056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-ab1360f9ecb29139c80c689ec679329d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.47Z"
]
32 => array:13 [
"Order" => 34
"MediaKey" => "30044435_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/3e3e3a36b4c65339b2234d37f56f4572.webp"
"MediaSize" => 469043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-3e3e3a36b4c65339b2234d37f56f4572.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.83Z"
]
33 => array:13 [
"Order" => 35
"MediaKey" => "30044435_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/c53ef6d0f6b7b3006592cd9f9acf02a0.webp"
"MediaSize" => 468243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-c53ef6d0f6b7b3006592cd9f9acf02a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:44.96Z"
]
34 => array:13 [
"Order" => 36
"MediaKey" => "30044435_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/f0c7d7283bdc6cfb81bb418de8bee84e.webp"
"MediaSize" => 482735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-f0c7d7283bdc6cfb81bb418de8bee84e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.49Z"
]
35 => array:13 [
"Order" => 37
"MediaKey" => "30044435_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/cb5409040ff09ead3a35b4feff05553b.webp"
"MediaSize" => 439053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-cb5409040ff09ead3a35b4feff05553b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.41Z"
]
36 => array:13 [
"Order" => 38
"MediaKey" => "30044435_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/69d4042c175ba4345b3f78b454f8ce4a.webp"
"MediaSize" => 454760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-69d4042c175ba4345b3f78b454f8ce4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.69Z"
]
37 => array:13 [
"Order" => 39
"MediaKey" => "30044435_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/8e5c7cd138b5ee7bb751ce409117a6da.webp"
"MediaSize" => 471695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-8e5c7cd138b5ee7bb751ce409117a6da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.43Z"
]
38 => array:13 [
"Order" => 40
"MediaKey" => "30044435_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/723c0741d931a52f931acc2d93e5c2ef.webp"
"MediaSize" => 92746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-723c0741d931a52f931acc2d93e5c2ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.37Z"
]
39 => array:13 [
"Order" => 41
"MediaKey" => "30044435_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/0279ab3bdeba0b374f7de5ede327cffa.webp"
"MediaSize" => 104037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-0279ab3bdeba0b374f7de5ede327cffa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:42.75Z"
]
40 => array:13 [
"Order" => 42
"MediaKey" => "30044435_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/56a9c1e7429f97ea2c4f2d1e0fcdee73.webp"
"MediaSize" => 95055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-56a9c1e7429f97ea2c4f2d1e0fcdee73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-16T22:26:45.45Z"
]
41 => array:13 [
"Order" => 27
"MediaKey" => "30044435_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30044435/e99880d8c53fe6c4066f2aa8cb47f63a.webp"
"MediaSize" => 104809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30044435/thumbnail-e99880d8c53fe6c4066f2aa8cb47f63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13573690"
"ResourceRecordKey" => "30044435"
"ModificationTimestamp" => "2026-07-17T19:59:07.15Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044435')"
+"ID": "1632810"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24996
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24940
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-579-4110"
+"OfficeMlsId": "360900"
+"ModificationTimestamp": "2025-06-17T20:58:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288578"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "901 VICTORIA STREET N UNIT B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2B3C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1369645"
+"OriginalEntryTimestamp": "2020-09-17T17:39:00Z"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "318561"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288578"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2025-06-17T19:05:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1369644"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('288578')"
}
]
+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 2130557" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24950
+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 '30044435'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+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 '30044435' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30044435' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.543693 43.486532)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25387
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+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"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30034574_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/be0abfe404a3e757fb6e23d4481e0980.webp"
"MediaSize" => 88828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-be0abfe404a3e757fb6e23d4481e0980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30034574_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/c61f6d8fae70a0cfc08f406a2244b834.webp"
"MediaSize" => 118961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-c61f6d8fae70a0cfc08f406a2244b834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting common area featuring a mix of tile and carpet flooring, a large mail center with individual boxes, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30034574_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/ebdeb36d61d806dd0b80fc64b0b0d0cc.webp"
"MediaSize" => 87647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-ebdeb36d61d806dd0b80fc64b0b0d0cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring patterned carpet flooring, white walls, and flush-mount ceiling lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30034574_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/3c136b3400b7e2f5c00a531afab60c43.webp"
"MediaSize" => 72458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-3c136b3400b7e2f5c00a531afab60c43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring textured white brick-patterned wall and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30034574_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/74d2c40a5727a7f91e073e1abac640fa.webp"
"MediaSize" => 50239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-74d2c40a5727a7f91e073e1abac640fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30034574_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/bd3c445eb0aa157f8b9efef5f581581e.webp"
"MediaSize" => 95167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-bd3c445eb0aa157f8b9efef5f581581e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, a wall of windows, and a sliding glass door leading to a private balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30034574_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/3327ec9416ce82175b9b147ff6dcc134.webp"
"MediaSize" => 93114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-3327ec9416ce82175b9b147ff6dcc134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with wood-finish flooring, a full-wall striped accent, and a white brick-look accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30034574_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/89b0b6a5e152e4b4d828de5358ab6892.webp"
"MediaSize" => 90049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-89b0b6a5e152e4b4d828de5358ab6892.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a wall of vertical stripe wallpaper, and sliding glass doors leading to a private outdoor balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30034574_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/af790d108d318ab2ff93ae531c5764c2.webp"
"MediaSize" => 98143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-af790d108d318ab2ff93ae531c5764c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a neutral color palette, and full-wall sliding glass doors opening to a balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30034574_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/2596bd5657cae10ff5f320e1289d39b6.webp"
"MediaSize" => 88058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-2596bd5657cae10ff5f320e1289d39b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30034574_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/161a51be0c90da5893ae29fe641abf8e.webp"
"MediaSize" => 95393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-161a51be0c90da5893ae29fe641abf8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, a pass-through to the kitchen with gray cabinetry, and full-height windows leading to an outdoor space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30034574_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/ea7bcd8d85c40b52810866d3b8788e3c.webp"
"MediaSize" => 96685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-ea7bcd8d85c40b52810866d3b8788e3c.webp"
…7
]
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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1637109"
+post_author: 1
+"ListingKey": "30044668"
+"ListingId": "40848250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:16Z"
+"RFModificationTimestamp": "2026-07-17T20:50:05Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.182
+"LivingArea": 2275.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1X2"
+"UnparsedAddress": "363 TWINFLOWER Crescent, Waterloo, Ontario N2V1X2"
+"Coordinates": array:2 [
0 => -80.5616005
1 => 43.4984169
]
+"Latitude": 43.4984169
+"Longitude": -80.5616005
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Empty nesters and not ready for condo living? Welcome to this bright, open-concept bungalow nestled in Waterloo’s highly desirable Lakeshore North neighborhood. Perfect for downsizers seeking convenient main-floor living or small families looking for a vibrant, established community. You'll love the luxurious main floor bathroom boasting a custom, spa-like 5-piece privilege ensuite bath and the convenience of main floor laundry. This home features custom finishes like 9' ceilings, hardwood flooring, 5 1/4 baseboards and pot lights. The sunken living room is an inviting space perfect for relaxation and offering a seamless transition to outdoor living. The sunny, private backyard is beautifully landscaped and fenced on 3 sides. The design is perfect for entertaining and outdoor enjoyment with a durable composite deck complete with a natural gas BBQ hookup. The rec room has space for all your toys including a snooker table. The lower level also has 9' ceilings and would accommodate a parent with a private bedroom and 3 piece bathroom. There's plenty of parking with a double garage and 3 spots outside for family and friends. All this located in one of Waterloo's premier communities, offering a peaceful, active lifestyle with everything you need just minutes away. It's located just steps from the quiet paths of Pinebrook Park and within close proximity to the stunning trails and reservoir at the Laurel Creek Conservation Area. Add in excellent local schools, community playgrounds, and the nearby Albert McCormick Community Centre and library. Enjoy easy access to premium shopping and dining at Conestoga Mall, local grocery stores, and essential services. It's also conveniently located near major transit routes, the LRT, and Highway 85, making commutes across Waterloo region a breeze. Don't miss the rare opportunity to own a turnkey bungalow in this highly coveted, friendly neighborhood! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:49:58.803696+00:00"
+"Directions": "Northlake to Monarch Place, turn right onto Twinflower"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.182"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:03:05Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:39Z"
+"Stories": "1.0"
+"StreetName": "TWINFLOWER"
+"StreetNumber": "363"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5915"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/363_twinflower_crescent_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/30044668/363-twinflower-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 67.0
+"AboveGradeFinishedArea": 1456
+"BelowGradeFinishedArea": 819
+"OriginalEntryTimestamp": "2026-07-16T21:18:17.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"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('30044668')"
+"ID": "1637109"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1637110"
+post_author: 1
+"ListingKey": "30032627"
+"ListingId": "40848012"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:07Z"
+"RFModificationTimestamp": "2026-07-17T20:44:06Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1075.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582721
1 => 43.4895441
]
+"Latitude": 43.4895441
+"Longitude": -80.5582721
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3-bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or potential fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:44:00.821133+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-14T20:18:42Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:59Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30032627/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1075
+"OriginalEntryTimestamp": "2026-07-14T20:18:42.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032627')"
+"ID": "1637110"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035744')"
+"ID": "1637039"
}
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 {#25385
+post_id: "1633477"
+post_author: 1
+"ListingKey": "30043986"
+"ListingId": "X13573118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y2"
+"UnparsedAddress": "615 DOGWOOD LANE, Waterloo, Ontario N2L4Y2"
+"Coordinates": array:2 [
0 => -80.562739
1 => 43.486821
]
+"Latitude": 43.486821
+"Longitude": -80.562739
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 615 Dogwood Lane, Waterloo! This beautifully updated detached bungalow offers the perfect blend of comfort, versatility, and location. Featuring 3 spacious bedrooms and 1 full bathroom on the main level, plus a fully finished basement with a separate side entrance, second kitchen, additional bedroom, full bathroom, and excellent in-law or income potential. The main floor showcases a beautifully renovated kitchen with quartz countertops, new cabinetry, backsplash, flooring, and stainless steel appliances, complemented by pot lights throughout the home. Enjoy a large private backyard, perfect for entertaining or relaxing, in a family-friendly neighbourhood just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, schools, parks, shopping, transit, uptown Waterloo and a new hospital is planned approximately 5 minutes from the property. A fantastic opportunity for families, investors, or multi-generational living in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T00:00:23.294569+00:00"
+"Directions": "Highpoint Ave & Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099530"
+"ListOfficeKey": "298485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:40:09Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:30Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "615"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "3823.47"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30043986/615-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2169025"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-16T19:40:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1369712"
+"ListOfficeNationalAssociationId": "1470118"
+"CoListAgentNationalAssociationId": "1419701"
+"CoListOfficeNationalAssociationId": "1470118"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043986')"
+"ID": "1633477"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25386
+post_id: "1632395"
+post_author: 1
+"ListingKey": "30043808"
+"ListingId": "40846000"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T16:30:15Z"
+"RFModificationTimestamp": "2026-07-17T16:32:33Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1A9"
+"UnparsedAddress": "264 NORTHLAKE Drive Unit# A, Waterloo, Ontario N2V1A9"
+"Coordinates": array:2 [
0 => -80.5525039
1 => 43.4970467
]
+"Latitude": 43.4970467
+"Longitude": -80.5525039
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in Waterloo's established Lakeshore neighbourhood, 264A Northlake Drive offers 3 bedrooms, 2 bathrooms, a partially fenced backyard, parking for up to three vehicles, and a layout with a walkout from the living room to the backyard. Step outside and you're minutes from Laurel Creek Conservation Area, St. Jacobs Farmers' Market, Conestoga Mall, both the University of Waterloo and Wilfrid Laurier University, excellent schools, parks, shopping, public transit, and Highway 85. Whether you're searching for a place to call home or your next investment, locations like this continue to stand the test of time—and this is your chance to make it your own. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-16T20:54:44.142043+00:00"
+"Directions": "WEBER TO GOLDEN EAGLE, LEFT ON NORTHLAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248310"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-07-17T16:23:54Z"
+"PhotosCount": 6
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:23:54Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "264"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3365.81"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043808/264-northlake-drive-unit-a-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2026-07-16T19:18:44.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1487214"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043808')"
+"ID": "1632395"
}
]
+success: true
+page_size: 9
+page_count: 31
+count: 278
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]