array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29871245 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1508749"
+post_author: 1
+"ListingKey": "29871245"
+"ListingId": "40837653"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T01:40:06Z"
+"RFModificationTimestamp": "2026-06-16T01:43:53Z"
+"ListPrice": 529900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1317.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3N7"
+"UnparsedAddress": "375 KINGSCOURT Drive Unit# 35, Waterloo, Ontario N2K3N7"
+"Coordinates": array:2 [
0 => -80.5232356
1 => 43.4963215
]
+"Latitude": 43.4963215
+"Longitude": -80.5232356
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in a quiet, mature neighbourhood and backing onto a peaceful park setting, this three-bedroom townhouse combines modern updates with an ideal central location. The main floor is anchored by Brazilian cherry hardwood flooring and a custom galley kitchen featuring white cabinetry, granite countertops, and stainless appliances. Thoughtful updates provide long-term peace of mind, including a furnace and air conditioner replaced in 2019, a newer roof (2019), patio (2020), front walkway and porch (2025), and an owned water softener and hot water tank. The interior is finished with a neutral palette, pot lighting, and custom California shutters throughout the main floor and upper level. Each of the three bedrooms is generously sized, with the primary suite offering a large walk-in closet for ample storage. Outside, the property offers a private rear patio that backs onto a tranquil park setting. With abundant visitor parking and walking distance to many day to day amenities, Conestoga mall, and access to the ION light rail, this home offers a comfortable lifestyle for those seeking a move-in-ready home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFee": "548.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T19:56:18.573511+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2225370"
+"ListOfficeKey": "300082"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T18:19:49Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T01:31:55Z"
+"Stories": "2.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "375"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3343"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660265840"
"RoomType" => "Recreation room"
"ListingId" => "40837653"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 21'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.38Z"
]
1 => array:11 [
"RoomKey" => "1660265841"
"RoomType" => "Bedroom"
"ListingId" => "40837653"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
2 => array:11 [
"RoomKey" => "1660265842"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837653"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
3 => array:11 [
"RoomKey" => "1660265843"
"RoomType" => "Bedroom"
"ListingId" => "40837653"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
4 => array:11 [
"RoomKey" => "1660265844"
"RoomType" => "Bedroom"
"ListingId" => "40837653"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
5 => array:11 [
"RoomKey" => "1660265845"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837653"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "4'5'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
6 => array:11 [
"RoomKey" => "1660265846"
"RoomType" => "Living room"
"ListingId" => "40837653"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
7 => array:11 [
"RoomKey" => "1660265847"
"RoomType" => "Dining room"
"ListingId" => "40837653"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
8 => array:11 [
"RoomKey" => "1660265848"
"RoomType" => "Kitchen"
"ListingId" => "40837653"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871245"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T01:31:55.39Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29871245/375-kingscourt-drive-unit-35-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1317
+"OriginalEntryTimestamp": "2026-06-08T18:19:49.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1468653"
+"ListOfficeNationalAssociationId": "1482793"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29871245_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/508c760d9141371374ae629d2601e111.webp"
"MediaSize" => 125280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-508c760d9141371374ae629d2601e111.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29871245_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/31feaa30d53d38ea3fb9f127d6d3fc7d.webp"
"MediaSize" => 127934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-31feaa30d53d38ea3fb9f127d6d3fc7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29871245_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/0a7d1bd3e7de05bf490c5fc4db025535.webp"
"MediaSize" => 132148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-0a7d1bd3e7de05bf490c5fc4db025535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29871245_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/c947d662f825b338b833119cdbff1d19.webp"
"MediaSize" => 62327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-c947d662f825b338b833119cdbff1d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29871245_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/4e30e94f0dba7d036efcb1242ea9d519.webp"
"MediaSize" => 63384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-4e30e94f0dba7d036efcb1242ea9d519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29871245_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/5fca36a85d9470d52db2d85cca2100f2.webp"
"MediaSize" => 80999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-5fca36a85d9470d52db2d85cca2100f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29871245_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/366378c0564de0217c2acd38e5a3a37a.webp"
"MediaSize" => 82485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-366378c0564de0217c2acd38e5a3a37a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29871245_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/dd92ed4ab5edf78b0f879a8454436a1f.webp"
"MediaSize" => 81242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-dd92ed4ab5edf78b0f879a8454436a1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29871245_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/3ed43eb2885bfd9c20caca4edd09459c.webp"
"MediaSize" => 81982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-3ed43eb2885bfd9c20caca4edd09459c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29871245_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/a09b7889c2b66bc5752acfffee957115.webp"
"MediaSize" => 83939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-a09b7889c2b66bc5752acfffee957115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29871245_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/7d32e8bd796c90d71e917b072b15ebf9.webp"
"MediaSize" => 84533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-7d32e8bd796c90d71e917b072b15ebf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29871245_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/088fb534ffa1d709e3683d4c5f2eddb3.webp"
"MediaSize" => 88901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-088fb534ffa1d709e3683d4c5f2eddb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29871245_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/535c1ced3170604b2d5b0f336f4615ac.webp"
"MediaSize" => 70117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-535c1ced3170604b2d5b0f336f4615ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29871245_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/b0140a4b67060ba3d6918902d9885f99.webp"
"MediaSize" => 78744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-b0140a4b67060ba3d6918902d9885f99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29871245_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/b07d6172b091ada24b69b3dba474de6d.webp"
"MediaSize" => 55674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-b07d6172b091ada24b69b3dba474de6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29871245_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/8bd9593fa501ea28a297e331ec011618.webp"
"MediaSize" => 55211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-8bd9593fa501ea28a297e331ec011618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29871245_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/a1de097daaf939820ddd131819d99652.webp"
"MediaSize" => 87928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-a1de097daaf939820ddd131819d99652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29871245_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/7e35a7750441ca1c9e294b55e8839301.webp"
"MediaSize" => 82760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-7e35a7750441ca1c9e294b55e8839301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29871245_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/8a8e44dc462ea7dad17ea31e7af484ce.webp"
"MediaSize" => 82041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-8a8e44dc462ea7dad17ea31e7af484ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29871245_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/9b8945df33a95059505a5e261f937bbe.webp"
"MediaSize" => 69472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-9b8945df33a95059505a5e261f937bbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29871245_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/0af84a6f8449aeb67c0cf10cca1c9cb4.webp"
"MediaSize" => 91486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-0af84a6f8449aeb67c0cf10cca1c9cb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29871245_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/6ec10a4a6f1a25ce8af2011f50bc535f.webp"
"MediaSize" => 63733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-6ec10a4a6f1a25ce8af2011f50bc535f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29871245_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/e5bc1445fac5704da586db0b13d0fe70.webp"
"MediaSize" => 103527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-e5bc1445fac5704da586db0b13d0fe70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29871245_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/6ada9a1dbee863799bd5b178cfd435e3.webp"
"MediaSize" => 94626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-6ada9a1dbee863799bd5b178cfd435e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29871245_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/6a4c964329abf96b8af4d0d2f80c3994.webp"
"MediaSize" => 69909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-6a4c964329abf96b8af4d0d2f80c3994.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29871245_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/e0f2c53ebd62ee622a8670cd9b090349.webp"
"MediaSize" => 151378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-e0f2c53ebd62ee622a8670cd9b090349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29871245_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/2f9761d032e8f5263e306f7220b9d40d.webp"
"MediaSize" => 130026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-2f9761d032e8f5263e306f7220b9d40d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29871245_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871245/865c6dc1f02756af98e643b8790e716b.webp"
"MediaSize" => 116188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871245/thumbnail-865c6dc1f02756af98e643b8790e716b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837653"
"ResourceRecordKey" => "29871245"
"ModificationTimestamp" => "2026-06-08T18:19:49.41Z"
]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871245')"
+"ID": "1508749"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 300082" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24819
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24753
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "300082"
+"ModificationTimestamp": "2025-06-07T06:14:14Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "300082"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('300082')"
}
]
+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 2225370" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24835
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29871245'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25144
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29871245'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25163
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31388175"
+"ListingKey": "29871245"
+"ListingId": "40837653"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T15:00:00Z"
+"OpenHouseEndTime": "2026-06-14T17:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T19:59:36Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31388175')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31500274"
+"ListingKey": "29871245"
+"ListingId": "40837653"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T06:33:26Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31500274')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31500275"
+"ListingKey": "29871245"
+"ListingId": "40837653"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-24"
+"OpenHouseStartTime": "2026-06-24T16:00:00Z"
+"OpenHouseEndTime": "2026-06-24T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T06:33:26Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31500275')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.28 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29871245' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5232356 43.4963215)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25219
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1539914"
+post_author: 1
+"ListingKey": "29917046"
+"ListingId": "40840083"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:10:06Z"
+"RFModificationTimestamp": "2026-06-17T18:54:12Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1009, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526452
1 => 43.4787911
]
+"Latitude": 43.4787911
+"Longitude": -80.526452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Low condo fee!!! This stylish and convenient condo is in excellent condition, featuring a 1-bedroom layout with 1 bathrooms. The unit is carpetfree, offering a modern and clean living space. It boasts a spacious 9 ft ceiling that creates an open and airy atmosphere. The balcony seamlessly connects the living room, providing easy access to fresh air and outdoor relaxation. The built-in laundry room adds to the convenience, making everyday living effortless. The condo is ideally located with shopping plazas and restaurants just steps away, ensuring you have everything you need at your fingertips. It is adjacent to the prestigious Waterloo Collegiate Institute (WCI) and offers close proximity to Laurier University, the University of Waterloo, and Conestoga College (Waterloo Campus), making it an excellent choice for families, professionals, or students. Don't miss the opportunity to own this bright and functional condo that perfectly balances comfort, style, and location. Contact us today for more details or to schedule a viewing! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "337.21"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T18:54:02.414253+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T18:01:29Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:01:29Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3220"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1661335707"
"RoomType" => "Laundry room"
"ListingId" => "40840083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917046"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:01:29.89Z"
]
1 => array:11 [
"RoomKey" => "1661335708"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917046"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:01:29.89Z"
]
2 => array:11 [
"RoomKey" => "1661335709"
"RoomType" => "Bedroom"
"ListingId" => "40840083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917046"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:01:29.89Z"
]
3 => array:11 [
"RoomKey" => "1661335710"
"RoomType" => "Living room"
"ListingId" => "40840083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917046"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:01:29.89Z"
]
4 => array:11 [
"RoomKey" => "1661335711"
"RoomType" => "Kitchen"
"ListingId" => "40840083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917046"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:01:29.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917046/318-spruce-street-unit-1009-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Guest Suite"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-06-17T18:01:29.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29917046_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/7ff51882e7bdae179a3f4c99b87f1071.webp"
"MediaSize" => 144178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-7ff51882e7bdae179a3f4c99b87f1071.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29917046_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/d94c63adc42bddd5d6deb431891b755d.webp"
"MediaSize" => 96761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-d94c63adc42bddd5d6deb431891b755d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29917046_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/d16e3b38560ea568a43a6ada39ed1162.webp"
"MediaSize" => 69991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-d16e3b38560ea568a43a6ada39ed1162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29917046_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/42171c66ecba497018c21e1f8c6e229d.webp"
"MediaSize" => 77995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-42171c66ecba497018c21e1f8c6e229d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29917046_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/99bac25dd6c42c3beab04c7d0600b76a.webp"
"MediaSize" => 72737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-99bac25dd6c42c3beab04c7d0600b76a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29917046_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/06ec116ab3d75c68014755dbefa73c6e.webp"
"MediaSize" => 63868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-06ec116ab3d75c68014755dbefa73c6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29917046_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/2e07e562e685f6dd6e8ef234e34d27f7.webp"
"MediaSize" => 62175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-2e07e562e685f6dd6e8ef234e34d27f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29917046_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/f4b11772a6d3fc3bd2270818502e15f6.webp"
"MediaSize" => 61161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-f4b11772a6d3fc3bd2270818502e15f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29917046_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/48b5bde8c736736984766f1c48b8569c.webp"
"MediaSize" => 112111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-48b5bde8c736736984766f1c48b8569c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29917046_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/c92ad33a4425b966fc814304d266845f.webp"
"MediaSize" => 132471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-c92ad33a4425b966fc814304d266845f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29917046_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/23b8740582e9cd37c0650fae2c8a68d8.webp"
"MediaSize" => 92064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-23b8740582e9cd37c0650fae2c8a68d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29917046_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/d091ac797364d378c56a880d3113c1e8.webp"
"MediaSize" => 124878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-d091ac797364d378c56a880d3113c1e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29917046_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/9356ac02150a246441f7753e16ed157e.webp"
"MediaSize" => 97788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-9356ac02150a246441f7753e16ed157e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29917046_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917046/3705b6d6ac6069f3c625e5819f0e5629.webp"
"MediaSize" => 65345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917046/thumbnail-3705b6d6ac6069f3c625e5819f0e5629.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840083"
"ResourceRecordKey" => "29917046"
"ModificationTimestamp" => "2026-06-17T18:01:29.87Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917046')"
+"ID": "1539914"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1538278"
+post_author: 1
+"ListingKey": "29914287"
+"ListingId": "40839253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:00:01Z"
+"RFModificationTimestamp": "2026-06-17T13:57:19Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.094
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z8"
+"UnparsedAddress": "212 SLEAFORD Street, Waterloo, Ontario N2J4Z8"
+"Coordinates": array:2 [
0 => -80.5224041
1 => 43.4908368
]
+"Latitude": 43.4908368
+"Longitude": -80.5224041
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Welcome to 212 Sleaford Street, Waterloo!** LOCATION LOCATION LOCATION!! This inviting detached house with a double-car garage locates in one of the most desirable area in the City of Waterloo. It offers an exceptional combination of space, versatility, and convenience. The upper level features 3 comfortable bedrooms and a generously sized family room filled with natural light, make it an ideal space for relaxing, entertaining, or spending quality time with family members together. The finished basement expands the home’s possibilities with an additional bedroom, a 3-piece bathroom, and spacious recreation space. With its own separate entrance, the lower level offers excellent flexibility for extended family, guests, a private home office, or potential future rental use. Ideally situated just minutes from Conestoga Mall and HWY 85, provides convenient access to shopping, restaurants, public transit, major routes throughout Waterloo Region. It is also within easy reach of the University of Waterloo, Wilfrid Laurier University, and Conestoga College by public transit or a 10 mins drive, making it an attractive opportunity for first-time buyers, growing families, and investors alike. RIM Park Sportsplex is also nearby, provides family with easy access to various sports throughout the season (hockey, skating, indoor/outdoor soccer fields, basketball, badminton and more). Recent improvements include a new hot water tank installed in 2026 (owned), and a new water softener (owned, 2025). As an added bonus, ALL FURNITURE currently in the home can be INCLUDED, offering a truly convenient and move-in-ready opportunity. With its generous living space, versatile finished basement, double garage, and highly desirable Waterloo location, this is a home you will not want to miss!!! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:57:09.434616+00:00"
+"Directions": "Dearborn Blvd / Tealby Crt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168724"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.094"
+"PhotosChangeTimestamp": "2026-06-17T11:50:23Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T11:50:23Z"
+"Stories": "2.0"
+"StreetName": "SLEAFORD"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5421.13"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1661033852"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.79Z"
]
1 => array:11 [
"RoomKey" => "1661033853"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.79Z"
]
2 => array:11 [
"RoomKey" => "1661033854"
"RoomType" => "Bedroom"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.79Z"
]
3 => array:11 [
"RoomKey" => "1661033855"
"RoomType" => "Bedroom"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.79Z"
]
4 => array:11 [
"RoomKey" => "1661033856"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
5 => array:11 [
"RoomKey" => "1661033857"
"RoomType" => "Family room"
"ListingId" => "40839253"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
6 => array:11 [
"RoomKey" => "1661033858"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839253"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
7 => array:11 [
"RoomKey" => "1661033859"
"RoomType" => "Living room/Dining room"
"ListingId" => "40839253"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
8 => array:11 [
"RoomKey" => "1661033860"
"RoomType" => "Dining room"
"ListingId" => "40839253"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
9 => array:11 [
"RoomKey" => "1661033861"
"RoomType" => "Kitchen"
"ListingId" => "40839253"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
10 => array:11 [
"RoomKey" => "1661033862"
"RoomType" => "Bedroom"
"ListingId" => "40839253"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
11 => array:11 [
"RoomKey" => "1661033863"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839253"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
12 => array:11 [
"RoomKey" => "1661033864"
"RoomType" => "Recreation room"
"ListingId" => "40839253"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914287"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T11:50:23.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914287/212-sleaford-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1818
+"BelowGradeFinishedArea": 753
+"OriginalEntryTimestamp": "2026-06-17T11:50:23.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419405"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914287_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/db6cb7f8301aa5d100dd96f2dace97a2.webp"
"MediaSize" => 137753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-db6cb7f8301aa5d100dd96f2dace97a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front house"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914287_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/e4e26ad9874af8c4568fcb22f0697161.webp"
"MediaSize" => 140679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-e4e26ad9874af8c4568fcb22f0697161.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front house"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914287_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/00e376ebed1cf38ee40ab1a5e7cf71db.webp"
"MediaSize" => 184236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-00e376ebed1cf38ee40ab1a5e7cf71db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry featuring a white paneled door with decorative glass inserts, a gray brick facade, an entry porch with wrought iron railing, and a patterned concrete walkway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914287_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/402c2eca29cb99bc171dd9359822c9c8.webp"
"MediaSize" => 70557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-402c2eca29cb99bc171dd9359822c9c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914287_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/d4739ef391d04860c91644262c32a3b6.webp"
"MediaSize" => 56967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-d4739ef391d04860c91644262c32a3b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring a white paneled front door with sidelights, a decorative column, and a combination of wood-finish flooring and tile"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914287_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/44f3815c85b8f118c055d5604041ec8c.webp"
"MediaSize" => 66424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-44f3815c85b8f118c055d5604041ec8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914287_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/2724f4de0a1783f18b1b04c94b6cede1.webp"
"MediaSize" => 76698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-2724f4de0a1783f18b1b04c94b6cede1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring extensive wood-finish flooring, light-toned wall paint, and a large multi-pane window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914287_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/01a3f9af8ee386dc268025ea70aac8d1.webp"
"MediaSize" => 88293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-01a3f9af8ee386dc268025ea70aac8d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914287_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/7bac7197902beb8fea1bdd796487db5a.webp"
"MediaSize" => 77271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-7bac7197902beb8fea1bdd796487db5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, a central island with a solid surface countertop, tile flooring, and a patterned tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914287_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/296fe6188811658e172b754a36fd00bb.webp"
"MediaSize" => 88040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-296fe6188811658e172b754a36fd00bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, a center island with drawer storage, a tile backsplash, and a double basin sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914287_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/88478e2ac8879d62aee987acda802c5b.webp"
"MediaSize" => 96282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-88478e2ac8879d62aee987acda802c5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914287_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/4b93cf3d72171e56146971d905f5bb51.webp"
"MediaSize" => 45709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-4b93cf3d72171e56146971d905f5bb51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914287_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/508b6a61b9cf6b85ea65f0a3d2155045.webp"
"MediaSize" => 71620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-508b6a61b9cf6b85ea65f0a3d2155045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914287_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/f7ec912bb70b1e7eadd61425f2f28759.webp"
"MediaSize" => 70648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-f7ec912bb70b1e7eadd61425f2f28759.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914287_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/d3659e1f2a6080cd9c9fd39214cbcb22.webp"
"MediaSize" => 89952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-d3659e1f2a6080cd9c9fd39214cbcb22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceilings complement the arched window, enhancing the natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
"ModificationTimestamp" => "2026-06-17T11:50:23.73Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914287_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914287/8318b900190ae8becbf781ecc36e9265.webp"
"MediaSize" => 68891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914287/thumbnail-8318b900190ae8becbf781ecc36e9265.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring carpet flooring, an arched transom window, vaulted ceiling, and a built-in media console"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839253"
"ResourceRecordKey" => "29914287"
…1
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914287')"
+"ID": "1538278"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:25:15Z"
+"RFModificationTimestamp": "2026-06-17T13:47:33Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:16:42Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1534946"
+post_author: 1
+"ListingKey": "29910675"
+"ListingId": "TB2601537"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:05Z"
+"RFModificationTimestamp": "2026-06-16T19:09:09Z"
+"ListPrice": 119900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 80.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kaministiquia"
+"PostalCode": "P0T1X0"
+"UnparsedAddress": "PCL 13464 Granholm Road, Kaministiquia, Ontario P0T1X0"
+"Coordinates": array:2 [
0 => -80.532027
1 => 43.486195
]
+"Latitude": 43.486195
+"Longitude": -80.532027
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Thunder Bay Real Estate Board"
+"PublicRemarks": "Escape to your own private wilderness retreat with this incredible 80-acre property located in an unorganized area of Kaministiquia, Ontario. With road access and an extensive network of trails throughout the property, this is the ultimate outdoorsman's paradise. Used primarily for hunting and recreation, the land offers excellent habitat for wildlife and endless opportunities for ATVing, hiking, snowmobiling, and exploring Northern Ontario's rugged beauty. The unorganized township status means low property taxes and fewer restrictions, making it an ideal location for an off-grid cabin, hunting camp, recreational getaway, or future homestead. Located just west of Thunder Bay, the Kaministiquia area is renowned for its vast forests, lakes, rivers, and abundant wildlife. Outdoor enthusiasts are drawn to the region for its exceptional hunting, fishing, and year-round recreational opportunities, while still enjoying reasonable access to city amenities when needed. Surrounded by nature and offering incredible privacy, this rare 80-acre parcel provides the freedom to enjoy the Northern Ontario lifestyle the way it was meant to be peaceful, self-sufficient, and connected to the outdoors. Whether you're looking for a hunting property, a recreational retreat, or a place to build your dream off-grid escape, this is an opportunity you won't want to miss. Visit www.century21superior.com for more info and pics (id:62650)"
+"CreationDate": "2026-06-16T17:55:09.716027+00:00"
+"Directions": "North on Ware Road off Auto Road - turn left on Granholm. 40 min drive from Thunder Bay"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1433215"
+"ListOfficeKey": "87589"
+"LotSizeDimensions": "80"
+"ParcelNumber": "623210030"
+"PhotosChangeTimestamp": "2026-06-16T18:55:24Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:58:00Z"
+"TaxAnnualAmount": "500"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "Thunder Bay"
+"CityRegion": "Kaministiquia"
+"ListAORKey": "91"
+"ListingURL": "www.realtor.ca/real-estate/29910675/pcl-13464-granholm-road-kaministiquia-kaministiquia"
+"GeocodeManualYN": false
+"FrontageLengthNumeric": 0.0
+"OriginalEntryTimestamp": "2026-06-16T17:28:01.11Z"
+"ListAgentNationalAssociationId": "1042738"
+"ListOfficeNationalAssociationId": "1230457"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910675')"
+"ID": "1534946"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1534019"
+post_author: 1
+"ListingKey": "29908622"
+"ListingId": "40837260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:00:10Z"
+"RFModificationTimestamp": "2026-06-16T19:12:00Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1931.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2C1"
+"UnparsedAddress": "279 SANDOWNE Drive Unit# 2, Waterloo, Ontario N2K2C1"
+"Coordinates": array:2 [
0 => -80.505079
1 => 43.4913217
]
+"Latitude": 43.4913217
+"Longitude": -80.505079
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "With 3 available Parking Spots and a long list of thoughtful updates, this 3 bedroom townhome delivers comfort, convenience and an unbeatable location with a front yard view of the beautiful mature landscaping. Just move in and enjoy with the recent updates: Kitchen, Appliances, Reverse Osmosis Water system, Bathrooms, Flooring, Trim/Baseboards, Lighting, Built in Closet Organizers, Interior Doors, Paint, Window Coverings, Furnace and A/C, Patio and more. A great bright and spacious main floor layout. Primary Bedroom easily fits a King bed and has a dream built in closet system. Lower level with a cozy rec-room, Laundry (front load washer and dryer) and a 3 pc bath rough in with walls and plumbing. (currently used for storage) Oversized windows throughout brings an abundance of natural light into every room. A private rear court yard/patio and a carport for added convenience and protection for your vehicle. Located in the family-friendly mature neighbourhood of Lincoln Village. Steps from Sandowne P.S. and minutes to major roadways, nearby restaurants and services, Conestoga Mall, Rim Park/Grey Silo Golf and a whole lot more. An extremely well cared for complex where the snow is shovelled to your front door. Maintenance free living perfect for first-time buyers, downsizers, or young families. Open House this Saturday and Sunday 1-3pm or call/click for your private showing. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"AssociationFee": "540"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:12:07.521463+00:00"
+"Directions": "SOUTH OFF DANSBURY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1815005"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:50Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:51:52Z"
+"Stories": "2.0"
+"StreetName": "SANDOWNE"
+"StreetNumber": "279"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3036"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ukg7b_2_279_sandowne_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908622/279-sandowne-drive-unit-2-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1305
+"BelowGradeFinishedArea": 626
+"OriginalEntryTimestamp": "2026-06-16T12:50:50.49Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1192453"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908622')"
+"ID": "1534019"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1531876"
+post_author: 1
+"ListingKey": "29906649"
+"ListingId": "40840091"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T21:40:09Z"
+"RFModificationTimestamp": "2026-06-15T21:45:12Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 688.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1106, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.5265379
1 => 43.4788845
]
+"Latitude": 43.4788845
+"Longitude": -80.5265379
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stylish and convenient condo is in excellent condition, featuring a 1-bedroom plus 1 den layout with 2 bathrooms. The unit is carpet-free, offering a modern and clean living space. It boasts a spacious 9 ft ceiling that creates an open and airy atmosphere. The balcony seamlessly connects the living room and bedroom, providing easy access to fresh air and outdoor relaxation. The den is a versatile space that can serve as a home office or a temporary guest room, catering to different needs. The built-in laundry room adds to the convenience, making everyday living effortless. The condo is ideally located with shopping plazas and restaurants just steps away, ensuring you have everything you need at your fingertips. It is adjacent to the prestigious Waterloo Collegiate Institute (WCI) and offers close proximity to Laurier University, the University of Waterloo, and Conestoga College (Waterloo Campus), making it an excellent choice for families, professionals, or students. Don't miss the opportunity to own this bright and functional condo that perfectly balances comfort, style, and location. Contact us today for more details or to schedule a viewing! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"AssociationFee": "497.23"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:34:29.172215+00:00"
+"Directions": "Columbia St W to Spruce St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-15T21:32:00Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T21:32:00Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3919.05"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29906649/318-spruce-street-unit-1106-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Guest Suite"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 688
+"OriginalEntryTimestamp": "2026-06-15T21:10:52.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906649')"
+"ID": "1531876"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1530146"
+post_author: 1
+"ListingKey": "29902582"
+"ListingId": "X13443564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:00:19Z"
+"RFModificationTimestamp": "2026-06-15T15:48:28Z"
+"ListPrice": 274900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "501 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Immediate occupancy is available book your viewing today! (id:62783)"
+"AssociationFee": "739.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:48:25.808780+00:00"
+"Directions": "Cross Streets: King and University. ** Directions: From Columbia St W turn onto Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "168772"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T11:54:47Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:54:47Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3452"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29902582/501-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board Self Manage"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-15T11:54:47.88Z"
+"ListAgentNationalAssociationId": "1370499"
+"ListOfficeNationalAssociationId": "1185768"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902582')"
+"ID": "1530146"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1529258"
+post_author: 1
+"ListingKey": "29901833"
+"ListingId": "40839465"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:15:56Z"
+"ListPrice": 335000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1175.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4L6"
+"UnparsedAddress": "375 KING Street N Unit# 1005, Waterloo, Ontario N2J4L6"
+"Coordinates": array:2 [
0 => -80.5271182
1 => 43.4822607
]
+"Latitude": 43.4822607
+"Longitude": -80.5271182
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious 2-bedroom, 1.5-bathroom condo in one of Waterloo's most desirable locations! Perfectly situated just minutes from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, this well-maintained unit offers exceptional value for investors, first-time buyers, professionals, and families alike. The functional layout features generous living spaces, ample natural light, and the convenience of 1 parking space. Residents enjoy access to an outstanding selection of building amenities, including an indoor pool, sauna, fitness centre, library, party room, and more. Coin laundry is available within the building, as well as in-unit laundry space. Ideally located close to shopping, restaurants, public transit, parks, and everyday essentials, this is an excellent opportunity to own a home in the heart of Waterloo. Professional photos coming soon. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Sauna"
2 => "Dishwasher"
3 => "Stove"
]
+"AssociationFee": "1125"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Property Management"
1 => "Heat"
2 => "Electricity"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T21:09:09.730670+00:00"
+"Directions": "On the corner of Columbia St and King St N."
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2177614"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Laundry- Coin operated"
3 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-16T16:54:00Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:54:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "375"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "2430.64"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29901833/375-king-street-n-unit-1005-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1175
+"OriginalEntryTimestamp": "2026-06-14T17:50:13.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1427612"
+"ListOfficeNationalAssociationId": "1484182"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901833')"
+"ID": "1529258"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1529055"
+post_author: 1
+"ListingKey": "29901539"
+"ListingId": "X13442604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T13:55:08Z"
+"RFModificationTimestamp": "2026-06-14T16:31:08Z"
+"ListPrice": 325000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "1406 - 318 SPRUCE STREET, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Attention, Investors/university students/young professional!! Sage 2 Condos Offers Luxurious Living Close To Both Wilfrid Laurier University And University Of Waterloo. Walkable access to shops, restaurants, transit, including the LRT and GO Bus Station, and all essential amenities. Building amenities such as a rooftop terrace, fitness center, party room, and high-speed internet. Modern, Bright, And Open 1 + Den Layout With 2 Bathrooms & 159 Sf Balcony! Ss Appliances, Granite Counter Tops, Ensuite Laundry And Beautiful North Facing Views! Book Shelve in Living room, Study desk & chair, and 50" Tv & stand Included! ** 688 Sq Ft As Per Builder Plan** Condo Fees Include Gas, Hydro, Water & Internet! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Microwave"
6 => "Cooktop"
]
+"AssociationFee": "434.16"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T16:31:02.317662+00:00"
+"Directions": "University Ave & King St. N"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1617735"
+"ListOfficeKey": "289061"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-14T13:45:47Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T13:45:47Z"
+"StreetName": "Spruce"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3924.4"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29901539/1406-318-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-14T13:45:47.46Z"
+"ListAgentNationalAssociationId": "1160117"
+"ListOfficeNationalAssociationId": "1374074"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901539')"
+"ID": "1529055"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 104
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]