array:6 [
"RF Cache Key: 5dd2174bb7aae7b59f0b1d72468010dc26ea3f705911f2645b10ff8bf4f1b3ca" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21776
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23360
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:40Z"
+"RFModificationTimestamp": "2026-06-16T17:19:53Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:35:36Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1660561409"
"RoomType" => "3pc Bathroom"
"ListingId" => "40823911"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
1 => array:11 [
"RoomKey" => "1660561410"
"RoomType" => "Utility room"
"ListingId" => "40823911"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "17'5'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
2 => array:11 [
"RoomKey" => "1660561411"
"RoomType" => "Recreation room"
"ListingId" => "40823911"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "17'5'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
3 => array:11 [
"RoomKey" => "1660561412"
"RoomType" => "4pc Bathroom"
"ListingId" => "40823911"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
4 => array:11 [
"RoomKey" => "1660561413"
"RoomType" => "Bedroom"
"ListingId" => "40823911"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
5 => array:11 [
"RoomKey" => "1660561414"
"RoomType" => "Bedroom"
"ListingId" => "40823911"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
6 => array:11 [
"RoomKey" => "1660561415"
"RoomType" => "Primary Bedroom"
"ListingId" => "40823911"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
7 => array:11 [
"RoomKey" => "1660561416"
"RoomType" => "Kitchen"
"ListingId" => "40823911"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.11Z"
]
8 => array:11 [
"RoomKey" => "1660561417"
"RoomType" => "Dining room"
"ListingId" => "40823911"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.12Z"
]
9 => array:11 [
"RoomKey" => "1660561418"
"RoomType" => "Living room"
"ListingId" => "40823911"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29880685"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:35:36.12Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29880685_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/1dfaf08c1c78481f6d113b4f4e70f8fa.webp"
"MediaSize" => 137835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-1dfaf08c1c78481f6d113b4f4e70f8fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29880685_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/68ad1d5261a687b968fb9d734fbc18fd.webp"
"MediaSize" => 143236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-68ad1d5261a687b968fb9d734fbc18fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29880685_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/336033ca3c77843cca3d20e955c920ad.webp"
"MediaSize" => 149740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-336033ca3c77843cca3d20e955c920ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29880685_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/b9ebb8ec000ce2e1261adc55ef02f69c.webp"
"MediaSize" => 137683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-b9ebb8ec000ce2e1261adc55ef02f69c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29880685_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/4a56cc895fefbf5f562d8fc99413a2db.webp"
"MediaSize" => 60453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-4a56cc895fefbf5f562d8fc99413a2db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29880685_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/7743b527614b81dba3a8b91929eef475.webp"
"MediaSize" => 75882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-7743b527614b81dba3a8b91929eef475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29880685_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/1572133a83fe72f70fd911c9c2fb9de6.webp"
"MediaSize" => 75701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-1572133a83fe72f70fd911c9c2fb9de6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29880685_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/dbb0d1e982204f6c1ce78b8fc3a6d9bd.webp"
"MediaSize" => 73643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-dbb0d1e982204f6c1ce78b8fc3a6d9bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29880685_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/93d5998a50df0b051fd2d78227114116.webp"
"MediaSize" => 69464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-93d5998a50df0b051fd2d78227114116.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29880685_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/8e058aece1296f9c3456dd810a3a44ce.webp"
"MediaSize" => 80385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-8e058aece1296f9c3456dd810a3a44ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29880685_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/d81f24f2d8cbc6d5a70501e855df308d.webp"
"MediaSize" => 55453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-d81f24f2d8cbc6d5a70501e855df308d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29880685_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/429d492e4c6d6a74ce28af0090113ec0.webp"
"MediaSize" => 81753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-429d492e4c6d6a74ce28af0090113ec0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29880685_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/cf0de3f361cd66f21170717594cbd776.webp"
"MediaSize" => 64449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-cf0de3f361cd66f21170717594cbd776.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29880685_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/3ab9b72dece43739a150f7761b654c0c.webp"
"MediaSize" => 54741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-3ab9b72dece43739a150f7761b654c0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29880685_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/0f7c0c19232e0be7affaeff749e14177.webp"
"MediaSize" => 90027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-0f7c0c19232e0be7affaeff749e14177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29880685_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/03100e16ef117c89abae5a22399a301d.webp"
"MediaSize" => 97383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-03100e16ef117c89abae5a22399a301d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29880685_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/2f96f39df5c262d02b508383768863bb.webp"
"MediaSize" => 37850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-2f96f39df5c262d02b508383768863bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29880685_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/6ce68a8e2ec0274dadedc928b3bb5a26.webp"
"MediaSize" => 47441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-6ce68a8e2ec0274dadedc928b3bb5a26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29880685_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/0e1eca6465856493929d2ceac959a27a.webp"
"MediaSize" => 82261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-0e1eca6465856493929d2ceac959a27a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29880685_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/6f2f4bbf3f0ec283032d20b189b1bc51.webp"
"MediaSize" => 58182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-6f2f4bbf3f0ec283032d20b189b1bc51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29880685_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/ceb317032761ee28f120d49fe9fd49f3.webp"
"MediaSize" => 53738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-ceb317032761ee28f120d49fe9fd49f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29880685_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/3cbe276cb384c828bbdfbb8bd794b1ee.webp"
"MediaSize" => 63758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-3cbe276cb384c828bbdfbb8bd794b1ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29880685_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/2dde066c780f7a0b7b42dbb9f2197d70.webp"
"MediaSize" => 65148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-2dde066c780f7a0b7b42dbb9f2197d70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29880685_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/c53aa600eb6895f74eeb9f5193da4db8.webp"
"MediaSize" => 68220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-c53aa600eb6895f74eeb9f5193da4db8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29880685_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/f29aed0ab853619355c68b28097e178f.webp"
"MediaSize" => 39593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-f29aed0ab853619355c68b28097e178f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29880685_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/3179098a624cb4f4c9502ec479c578f0.webp"
"MediaSize" => 29077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-3179098a624cb4f4c9502ec479c578f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T11:52:28.2Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29880685_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/84a29ae33116ee0cfc289391787edba9.webp"
"MediaSize" => 91111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-84a29ae33116ee0cfc289391787edba9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "*Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:33.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29880685_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/9ce9d05734b9eb3b6e37c82a65ef45b5.webp"
"MediaSize" => 184021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-9ce9d05734b9eb3b6e37c82a65ef45b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:35.92Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29880685_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/7be300a06f603dadd2dc6d7bc76b75bc.webp"
"MediaSize" => 191044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-7be300a06f603dadd2dc6d7bc76b75bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:33.16Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29880685_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/4fefb6f71ca4f326ce73d86011b7b06a.webp"
"MediaSize" => 199147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-4fefb6f71ca4f326ce73d86011b7b06a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:34.49Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29880685_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/35ac45188526bdb1208ed9616b5b8f48.webp"
"MediaSize" => 140320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-35ac45188526bdb1208ed9616b5b8f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:33.27Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29880685_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/f0a30d4c84d3dfe3dceaa9ddab00235c.webp"
"MediaSize" => 170217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-f0a30d4c84d3dfe3dceaa9ddab00235c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:35.12Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29880685_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/05d56a26be48a0a825edcaafb27c57cf.webp"
"MediaSize" => 159198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-05d56a26be48a0a825edcaafb27c57cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:36.09Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29880685_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/fc18862bf124177585631d93154f0cee.webp"
"MediaSize" => 185921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-fc18862bf124177585631d93154f0cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:34.49Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29880685_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/1d64f4a7f98da9807642416a0d555c5e.webp"
"MediaSize" => 142729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-1d64f4a7f98da9807642416a0d555c5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:34.48Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29880685_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/5267e681079f0be0bdc81ed7cd1cf9a3.webp"
"MediaSize" => 154972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-5267e681079f0be0bdc81ed7cd1cf9a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:34.48Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29880685_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/21e364e7b964b761f6323cc5d7ebd88e.webp"
"MediaSize" => 143012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-21e364e7b964b761f6323cc5d7ebd88e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:32.74Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29880685_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/25fe4af374376dcc736710423341c449.webp"
"MediaSize" => 131843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-25fe4af374376dcc736710423341c449.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:37.42Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29880685_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/9a070b3c186bc24a77e4c5beb1bd7901.webp"
"MediaSize" => 38788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-9a070b3c186bc24a77e4c5beb1bd7901.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:35.92Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29880685_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/b4d7f48a7bf5fd00dde4fa36ae1611ed.webp"
"MediaSize" => 48170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-b4d7f48a7bf5fd00dde4fa36ae1611ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:37.18Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29880685_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880685/dc7616097e8031872e29fa378350af66.webp"
"MediaSize" => 38936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880685/thumbnail-dc7616097e8031872e29fa378350af66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823911"
"ResourceRecordKey" => "29880685"
"ModificationTimestamp" => "2026-06-10T17:42:32.74Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 274404" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24716
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908536" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24727
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29880685'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+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 '29880685'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25130
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25132
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31407052"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-10T15:27:08Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31407052')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25134
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31407053"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-10T15:27:08Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31407053')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31412366"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:38:43Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31412366')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25135
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31412365"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:38:43Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31412365')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25133
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31469952"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T20:01:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31469952')"
}
]
+success: true
+page_size: 5
+page_count: 1
+count: 5
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29880685' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5067851 43.4965407)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25232
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+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 [
"RoomKey" => "1660663954"
"RoomType" => "Laundry room"
"ListingId" => "40837260"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
1 => array:11 [
"RoomKey" => "1660663955"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837260"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
2 => array:11 [
"RoomKey" => "1660663956"
"RoomType" => "Recreation room"
"ListingId" => "40837260"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "18'7'' x 20'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
3 => array:11 [
"RoomKey" => "1660663957"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837260"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
4 => array:11 [
"RoomKey" => "1660663958"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837260"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
5 => array:11 [
"RoomKey" => "1660663959"
"RoomType" => "Bedroom"
"ListingId" => "40837260"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
6 => array:11 [
"RoomKey" => "1660663960"
"RoomType" => "Bedroom"
"ListingId" => "40837260"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
7 => array:11 [
"RoomKey" => "1660663961"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837260"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "2'8'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
8 => array:11 [
"RoomKey" => "1660663962"
"RoomType" => "Kitchen"
"ListingId" => "40837260"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
9 => array:11 [
"RoomKey" => "1660663963"
"RoomType" => "Living room"
"ListingId" => "40837260"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 18'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
10 => array:11 [
"RoomKey" => "1660663964"
"RoomType" => "Dining room"
"ListingId" => "40837260"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908622"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T18:51:52.34Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29908622_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908622/fe1c6457ed8428780adaccb80052c8c3.webp"
"MediaSize" => 122169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908622/thumbnail-fe1c6457ed8428780adaccb80052c8c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837260"
"ResourceRecordKey" => "29908622"
"ModificationTimestamp" => "2026-06-16T12:50:50.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908622_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908622/57e6e138fdcf36b96ea8e2add557ef37.webp"
"MediaSize" => 174787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908622/thumbnail-57e6e138fdcf36b96ea8e2add557ef37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908622')"
+"ID": "1534019"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1531565"
+post_author: 1
+"ListingKey": "29902976"
+"ListingId": "40839529"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:00:13Z"
+"RFModificationTimestamp": "2026-06-15T21:10:59Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3T1"
+"UnparsedAddress": "207 AUBURN Drive Unit# B, Waterloo, Ontario N2K3T1"
+"Coordinates": array:2 [
0 => -80.4867282
1 => 43.4875607
]
+"Latitude": 43.4875607
+"Longitude": -80.4867282
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in Waterloo's highly sought-after University Downs neighbourhood, this beautifully updated family home offers the perfect combination of modern updates, functional living space, and an unbeatable location. The bright open-concept main floor is designed for both everyday living and entertaining, featuring laminate flooring, a charming kitchen, and a spacious dining area overlooking the family room. Patio doors lead to a large, fully fenced backyard, creating the perfect setting for summer barbecues, outdoor play, and gatherings with family and friends. Upstairs, you'll find three spacious bedrooms and a beautifully updated bathroom, providing plenty of room for a growing family. The finished basement adds valuable living space and is ideal for a rec room, playroom, home office, or gym. A bathroom and laundry room complete the lower level. Thoughtful updates throughout make this home truly move-in ready. Outside, the large driveway offers ample parking for multiple vehicles, making everyday life and entertaining guests easy and convenient. Ideally located close to excellent schools, parks, walking trails, Conestoga Mall, the LRT, universities, shopping, restaurants, and major commuter routes, families will appreciate the mature tree-lined streets, strong sense of community, and proximity to all the amenities that make University Downs one of Waterloo's most desirable neighbourhoods. Beautifully updated, family-friendly, and ready to enjoy—this is a place you'll be proud to call home. Some photos virtually staged. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:10:50.683707+00:00"
+"Directions": "Auburn and University"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-06-15T13:50:25Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T14:51:44Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "207"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3637.94"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902976/207-auburn-drive-unit-b-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1090
+"BelowGradeFinishedArea": 268
+"OriginalEntryTimestamp": "2026-06-15T13:50:25.8Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902976')"
+"ID": "1531565"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1531566"
+post_author: 1
+"ListingKey": "29904482"
+"ListingId": "40839889"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:00:15Z"
+"RFModificationTimestamp": "2026-06-15T20:08:57Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2573.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S9"
+"UnparsedAddress": "225 DARTMOOR Crescent, Waterloo, Ontario N2K3S9"
+"Coordinates": array:2 [
0 => -80.4878773
1 => 43.4871065
]
+"Latitude": 43.4871065
+"Longitude": -80.4878773
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 225 Dartmoor Crescent in Waterloo, a spacious and well-maintained two-storey home offering over 2,500 sq. ft. of total living space in a sought-after family-friendly neighbourhood. This 3 bedroom, 4 bathroom home features a functional layout designed for both everyday living and entertaining. The main floor offers a large, inviting living room complete with a cozy fireplace, engineered hardwood floors, and extra large windows that fill the space with natural light. The living area flows seamlessly into the dining room, creating the perfect setting for family gatherings and hosting guests. The kitchen offers plenty of cabinet space, room for a breakfast table, and sliding glass doors leading to a private fully fenced backyard with patio, ideal for summer BBQs, outdoor dining, or relaxing evenings. Upstairs, you’ll find three generously sized bedrooms with plush carpeting, including a spacious primary suite featuring its own private ensuite bathroom. The finished basement adds even more living space with a large rec room complete with a built-in bar, making it the perfect spot for entertaining, movie nights, or a games area. Additional highlights include a double car garage and ample storage throughout. Conveniently located close to Bechtel Park, Bridgeport Public School, shopping, amenities, and with easy access to Highway 85 for commuters, this home offers the perfect combination of comfort, space, and location. (id:62783)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"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-15T20:08:46.315278+00:00"
+"Directions": "DARTMOOR CRES AND BRIDLE TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897572"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:51:48Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:51:48Z"
+"Stories": "2.0"
+"StreetName": "DARTMOOR"
+"StreetNumber": "225"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5480"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904482/225-dartmoor-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1699
+"BelowGradeFinishedArea": 874
+"OriginalEntryTimestamp": "2026-06-15T16:51:48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215332"
+"ListOfficeNationalAssociationId": "1438749"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904482')"
+"ID": "1531566"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1530988"
+post_author: 1
+"ListingKey": "29903648"
+"ListingId": "40839800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:40:14Z"
+"RFModificationTimestamp": "2026-06-16T15:44:15Z"
+"ListPrice": 700000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2954.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 24, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4939516
1 => 43.5014803
]
+"Latitude": 43.5014803
+"Longitude": -80.4939516
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to Riverstone Estates. Beautiful bright 3 bedroom, 3 bathroom multi level townhome located in highly desirable East Waterloo. Main floor has large open concept living/dining/kitchen area. Second floor features 2 bedrooms + 4 pc bath. Master suite located on upper level with full ensuite and walk in closet. Living room features a gas fireplace. All appliances included. Lower level finished, with full walkout basement and access to single garage. Patio door walk out from dining room to private deck area. Parking for 2 cars. Prime location to Walter Bean Trail, the Grand River, Kiwanis Park, Grey Silo Golf Course, Rim Park and expressway. Ample Visitor parking in front of unit. Seller can be flexible on closing. Low Condo Fee. Come Check out. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"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-15T19:21:53.555087+00:00"
+"Directions": "Off Woolwich"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:12Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:32:26Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4712.14"
+"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/29903648/460-woolwich-street-unit-24-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2287
+"BelowGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-15T15:31:11.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903648')"
+"ID": "1530988"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1531062"
+post_author: 1
+"ListingKey": "29904914"
+"ListingId": "X13445928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:05:14Z"
+"RFModificationTimestamp": "2026-06-15T18:27:43Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S9"
+"UnparsedAddress": "225 DARTMOOR CRESCENT, Waterloo, Ontario N2K3S9"
+"Coordinates": array:2 [
0 => -80.487876
1 => 43.487142
]
+"Latitude": 43.487142
+"Longitude": -80.487876
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 225 Dartmoor Crescent in Waterloo, a spacious and well-maintained two-storey home offering over 2,500 sq. ft. of total living space in a sought-after family-friendly neighbourhood. This 3 bedroom, 4 bathroom home features a functional layout designed for both everyday living and entertaining. The main floor offers a large, inviting living room complete with a cozy fireplace, engineered hardwood floors, and extra large windows that fill the space with natural light. The living area flows seamlessly into the dining room, creating the perfect setting for family gatherings and hosting guests. The kitchen offers plenty of cabinet space, room for a breakfast table, and sliding glass doors leading to a private fully fenced backyard with patio, ideal for summer BBQs, outdoor dining, or relaxing evenings. Upstairs, you'll find three generously sized bedrooms with plush carpeting, including a spacious primary suite featuring its own private ensuite bathroom. The finished basement adds even more living space with a large rec room complete with a built-in bar, making it the perfect spot for entertaining, movie nights, or a games area. Additional highlights include a double car garage and ample storage throughout. Conveniently located close to Bechtel Park, Bridgeport Public School, shopping, amenities, and with easy access to Highway 85 for commuters, this home offers the perfect combination of comfort, space, and location. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:27:12.284083+00:00"
+"Directions": "DARTMOOR CRES AND BRIDLE TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238795"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "56 x 115.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:58:06Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:58:06Z"
+"Stories": "2.0"
+"StreetName": "Dartmoor"
+"StreetNumber": "225"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5480"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29904914/225-dartmoor-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-06-15T17:40:06.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1476614"
+"ListOfficeNationalAssociationId": "1438893"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904914')"
+"ID": "1531062"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1525405"
+post_author: 1
+"ListingKey": "29898015"
+"ListingId": "40839057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:00:26Z"
+"RFModificationTimestamp": "2026-06-12T21:28:05Z"
+"ListPrice": 865000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2140.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B2"
+"UnparsedAddress": "180 OLD ABBEY Road Unit# 14, Waterloo, Ontario N2K4B2"
+"Coordinates": array:2 [
0 => -80.5259326
1 => 43.5008878
]
+"Latitude": 43.5008878
+"Longitude": -80.5259326
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO YOUR NEW HOME! Located in the best location in the hidden enclave of Abbey Woods, this bungalow townhome unit is the one you've been waiting for. Backing onto the greenspace, double car garage, finished basement and updates galore. As you enter you'll walk the enginerred hardwood floors right into the open concept main floor with The great room holds room for your living area, dining area, and large kitchen. The kitchen has been updated with newer countertops, sink and taps .All with large bright windows, pot lights, and a gas fireplace. The convenient patio doors go out to the greenspace and large deck with awning. The primary suite offers double closets, and updated 3 piece ensuite with a newer shower, newer counters, sink, taps, and lights. Rounding up the main floor is laundry and an updated extra 3 piece bathroom as well as a second bedroom or office. The space continues downstairs with a large guest room, rec room, and additional bathroom. A walk-in storage closet, and utility room with tons of extra storage. No need to garden or shovel here as condo fees cover so you can close up and enjoy spending time doing the things you love to do. Book your Showing TODAY! (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"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "640"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:27:58.329526+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1666913"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "No Pet Home"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T20:51:33Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:51:33Z"
+"Stories": "1.0"
+"StreetName": "OLD ABBEY"
+"StreetNumber": "180"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/180-Old-Abbey-Rd-14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898015/180-old-abbey-road-unit-14-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1322
+"BelowGradeFinishedArea": 818
+"OriginalEntryTimestamp": "2026-06-12T20:51:33.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1169212"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898015')"
+"ID": "1525405"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1523441"
+post_author: 1
+"ListingKey": "29894120"
+"ListingId": "40838919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T13:15:12Z"
+"RFModificationTimestamp": "2026-06-12T14:37:38Z"
+"ListPrice": 309000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "243 NORTHFIELD Drive E Unit# 408, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.5218062
1 => 43.510191
]
+"Latitude": 43.510191
+"Longitude": -80.5218062
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, where modern design meets convenient Waterloo living. This owner-occupied, carpet-free one-bedroom suite has been beautifully maintained and thoughtfully upgraded throughout. The bright open-concept layout overlooks the peaceful courtyard and features a stylish kitchen with upgraded cabinetry, quartz countertops, stainless steel appliances, subway tile backsplash, custom island, and modern pot lighting. Additional highlights include a spacious four-piece bathroom, in-suite laundry, custom remote-controlled blinds, and an owned underground parking space. Residents enjoy exceptional amenities including a fitness center, 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. Ideally located steps from Brown's Social House, shopping, restaurants, and everyday amenities, with easy access to Conestoga Mall, the ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, and Waterloo's universities and colleges. A fantastic opportunity for first-time buyers, professionals or investors seeking a move-in-ready home in one of Waterloo's most desirable communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:37:36.573103+00:00"
+"Directions": "Corner of Northfield Dr E & Bridge Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043154"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T12:50:34Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T13:10:08Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3122.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894120/243-northfield-drive-e-unit-408-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "r1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2026-06-12T12:50:34.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1318898"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894120')"
+"ID": "1523441"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1521904"
+post_author: 1
+"ListingKey": "29890891"
+"ListingId": "40835701"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T19:10:10Z"
+"RFModificationTimestamp": "2026-06-12T01:46:04Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2787.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS Street, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.4832054
1 => 43.4948702
]
+"Latitude": 43.4948702
+"Longitude": -80.4832054
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in Waterloo East’s exclusive Woolwich Estates, this spotless, high-end home sits in one of the area’s most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:45:53.425914+00:00"
+"Directions": "Woolwich Street to Carriage Way to Preakness"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1769740"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:00:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:00:41Z"
+"Stories": "2.0"
+"StreetName": "PREAKNESS"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_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/29890891/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2203749"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2787
+"OriginalEntryTimestamp": "2026-06-11T18:52:41.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1186018"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1452339"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890891')"
+"ID": "1521904"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: "1521275"
+post_author: 1
+"ListingKey": "29891441"
+"ListingId": "X13433564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:48:57Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS STREET, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.483088
1 => 43.494859
]
+"Latitude": 43.494859
+"Longitude": -80.483088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in Waterloo East's exclusive Woolwich Estates, this spotless, high-end home sits in one of the area's most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-11T21:48:52.710792+00:00"
+"Directions": "Cross Streets: Woolwich Street. ** Directions: Woolwich Street to Carriage Way to Preakness."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2250801"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Sump Pump"
]
+"LotSizeDimensions": "40.2 x 116.5 FT ; 40.17 x 109.12 x 71.30 x 116.53"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:53Z"
+"Stories": "2.0"
+"StreetName": "Preakness"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891441/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-06-11T19:54:53.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1489710"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891441')"
+"ID": "1521275"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 101
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]