array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29880685 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T21:10:05Z"
+"RFModificationTimestamp": "2026-06-30T21:15:48Z"
+"ListPrice": 569000.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-30T21:03:13Z"
+"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" => "1672181221"
"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-30T21:03:13.86Z"
]
1 => array:11 [
"RoomKey" => "1672181222"
"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-30T21:03:13.86Z"
]
2 => array:11 [
"RoomKey" => "1672181223"
"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-30T21:03:13.86Z"
]
3 => array:11 [
"RoomKey" => "1672181224"
"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-30T21:03:13.87Z"
]
4 => array:11 [
"RoomKey" => "1672181225"
"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-30T21:03:13.87Z"
]
5 => array:11 [
"RoomKey" => "1672181226"
"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-30T21:03:13.87Z"
]
6 => array:11 [
"RoomKey" => "1672181227"
"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-30T21:03:13.87Z"
]
7 => array:11 [
"RoomKey" => "1672181228"
"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-30T21:03:13.87Z"
]
8 => array:11 [
"RoomKey" => "1672181229"
"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-30T21:03:13.87Z"
]
9 => array:11 [
"RoomKey" => "1672181230"
"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-30T21:03:13.87Z"
]
]
+"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": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 274404" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 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 {#24859
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29880685'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 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 {#24966
+items: array:7 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+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 {#25371
+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 {#25368
+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 {#24905
+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 {#25370
+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')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31736197"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T12:00:00Z"
+"OpenHouseEndTime": "2026-07-05T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-01T03:06:11Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31736197')"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31736198"
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T12:00:00Z"
+"OpenHouseEndTime": "2026-07-04T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-01T03:06:11Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31736198')"
}
]
+success: true
+page_size: 7
+page_count: 1
+count: 7
+after_key: ""
}
"RF Response Time" => "0.1 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 {#25305
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1576427"
+post_author: 1
+"ListingKey": "29964980"
+"ListingId": "X13499606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:35:17Z"
+"RFModificationTimestamp": "2026-06-29T19:41:06Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT STREET, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.490937
1 => 43.499333
]
+"Latitude": 43.499333
+"Longitude": -80.490937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property. The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23, AC '22 (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:43:10.232271+00:00"
+"Directions": "Cross Streets: University/Woolwich. ** Directions: University to Colt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22.9 x 102 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:08Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:28:30Z"
+"Stories": "2.0"
+"StreetName": "Colt"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671392524"
"RoomType" => "Great room"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29964980"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.75Z"
]
1 => array:11 [
"RoomKey" => "1671392525"
"RoomType" => "Kitchen"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "29964980"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.75Z"
]
2 => array:11 [
"RoomKey" => "1671392526"
"RoomType" => "Dining room"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29964980"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
3 => array:11 [
"RoomKey" => "1671392527"
"RoomType" => "Bedroom"
"ListingId" => "X13499606"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29964980"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
4 => array:11 [
"RoomKey" => "1671392528"
"RoomType" => "Bedroom 2"
"ListingId" => "X13499606"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29964980"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
5 => array:11 [
"RoomKey" => "1671392529"
"RoomType" => "Bedroom 3"
"ListingId" => "X13499606"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29964980"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964980/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.1
+"OriginalEntryTimestamp": "2026-06-29T13:50:08.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1364605"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964980_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/5ffd6e24cde23fc859f83fc3fb9651b4.webp"
"MediaSize" => 261391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-5ffd6e24cde23fc859f83fc3fb9651b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964980_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/b1fcf6c98c8a1df48f1537427c962203.webp"
"MediaSize" => 291453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-b1fcf6c98c8a1df48f1537427c962203.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964980_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/8e21b442b48b38c9168f6517735c48bd.webp"
"MediaSize" => 344145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-8e21b442b48b38c9168f6517735c48bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964980_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/8f95079e21f0207c261d3164d26a6cbe.webp"
"MediaSize" => 305572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-8f95079e21f0207c261d3164d26a6cbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964980_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/a8dca0f0475bb597c1712918425f902e.webp"
"MediaSize" => 130511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-a8dca0f0475bb597c1712918425f902e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964980_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/073acd4a54dc5f8d660297bdb8c4d19b.webp"
"MediaSize" => 101047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-073acd4a54dc5f8d660297bdb8c4d19b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964980_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/c5b735872c43d7367932ecee758fe053.webp"
"MediaSize" => 155761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-c5b735872c43d7367932ecee758fe053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964980')"
+"ID": "1576427"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1575738"
+post_author: 1
+"ListingKey": "29964993"
+"ListingId": "40839771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:07Z"
+"RFModificationTimestamp": "2026-06-29T19:03:37Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 1440.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT Street, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.4908096
1 => 43.4991897
]
+"Latitude": 43.4991897
+"Longitude": -80.4908096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property.The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23 AC ' 22 (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:32:02.394661+00:00"
+"Directions": "University to Colt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:41Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:51:28Z"
+"Stories": "2.0"
+"StreetName": "COLT"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4354"
+"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/29964993/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1440
+"OriginalEntryTimestamp": "2026-06-29T13:50:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1574855"
+post_author: 1
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T03:45:02Z"
+"RFModificationTimestamp": "2026-06-30T03:49:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2615.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "729 GRAND BANKS Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.4982397
1 => 43.5124183
]
+"Latitude": 43.5124183
+"Longitude": -80.4982397
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home in the highly desirable Eastbridge neighbourhood! Featuring a bright open-concept layout, this well-maintained home offers a grand two-storey foyer, spacious Great Room with maple hardwood flooring, California shutters, and a walkout to the deck with stunning seasonal views of the Grand River. The kitchen boasts abundant cabinetry, a breakfast bar, and updated appliances. Upstairs, the spacious primary bedroom features a walk-in closet, an elegant 9'4 tray ceiling, and a private ensuite. The finished walkout basement provides additional living space, direct access to a large stone patio, and a rough-in for a future bathroom. The fully fenced backyard is perfect for family enjoyment and entertaining. Recent updates include roof (2021), driveway resurfacing (2023), patio and deck improvements (2024), bathroom updates (2025), washer (2022), kitchen appliances (2019), and owned water softener. Ideally located within walking distance to top-rated schools and close to RIM Park, shopping, trails, transit, and the Expressway. A fantastic opportunity to own a move-in-ready home in one of Waterloo's most sought-after family communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:20:09.218915+00:00"
+"Directions": "TAKE UNIVERSITY AVE EAST; TURN LEFT ON TO NEW BEDFORD DR; THEN TURN RIGHT ON TO GRAND BANKS DR."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T03:39:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T03:39:21Z"
+"Stories": "2.0"
+"StreetName": "GRAND BANKS"
+"StreetNumber": "729"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964583/729-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1825
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-29T05:59:41.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1574152"
+post_author: 1
+"ListingKey": "29963525"
+"ListingId": "40843481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T01:33:44Z"
+"ListPrice": 354990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive Unit# 308, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213765
1 => 43.5107332
]
+"Latitude": 43.5107332
+"Longitude": -80.5213765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 1-bedroom plus den, 1-bath condo offering the perfect blend of style, comfort, and low-maintenance living in one of the area's most sought-after neighbourhoods. This beautifully appointed unit features high-end finishes, abundant natural light, a primary bedroom complete with a walk-in closet and ensuite access, convenient in-suite laundry, one underground parking space, and a private locker. The versatile den is ideal for a home office. Enjoy an impressive selection of building amenities, including a fitness centre, event room, rooftop terrace with BBQ area and beautiful views, bike storage, and even a dog washing station. The well-maintained building also offers keyless entry. Perfectly situated just minutes from restaurants, shopping, theatres, the community centre, and the renowned St. Jacobs Farmers' Market. Outdoor enthusiasts will appreciate the nearby Walter Bean Trail, Grand River, RIM Park, and Grey Silo Golf Course. Conveniently located close to two universities with quick access to Highways 85 and 401, making commuting a breeze. This exceptional condo truly has it all—don't miss your opportunity to make it yours. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "493"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:33:38.248335+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-28T00:20:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:20:47Z"
+"Stories": "3.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3137.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963525/255-northfield-drive-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 582
+"OriginalEntryTimestamp": "2026-06-28T00:20:47.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963525')"
+"ID": "1574152"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1572262"
+post_author: 1
+"ListingKey": "29961016"
+"ListingId": "40843507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:21Z"
+"RFModificationTimestamp": "2026-06-27T20:29:58Z"
+"ListPrice": 1630000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.5202288
1 => 43.5085201
]
+"Latitude": 43.5085201
+"Longitude": -80.5202288
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional family living at 250 Grey Squirrel Place, a beautifully maintained home nestled on a quiet crescent in Waterloo's sought-after Colonial Acres. Situated on a rare double-sized lot, this impressive property offers an outstanding blend of space, comfort, and privacy in one of the city's most established neighbourhoods. Step inside to an inviting interior highlighted by soaring 14-foot ceilings in the front living room, rich hardwood flooring, and a charming wood-burning fireplace. A second fireplace anchors the spacious family room, providing the perfect setting for relaxed evenings, while a dedicated main-floor office offers a quiet space for working from home. Everyday convenience is enhanced by the functional mudroom and laundry area with direct access from the double-car garage. At the heart of the home, the well-appointed kitchen features granite countertops, a Bosch stove, Miele appliances, and a walkout to the newly completed tiered wood deck (2025). The expansive backyard is a true standout, offering a sports court, mature landscaping, Honeycrisp apple trees, a peach tree, and ample room for entertaining, gardening, or family recreation. The upper level features four spacious bedrooms, including a private primary retreat with its own ensuite bath, as well as a second full bathroom to accommodate family and guests. The fully finished basement adds incredible versatility with two additional bedrooms, a three-piece bathroom, and a large recreation area ideal for movie nights, games, or multi-generational living. Surrounded by mature trees and enhanced by an interlock driveway, this home delivers both curb appeal and lasting quality. Ideally positioned just minutes from Uptown Waterloo, the University of Waterloo, Waterloo Park, RIM Park, Grey Silo Golf Course, and The Boardwalk, this exceptional property offers the perfect balance of peaceful family living and convenient access to the region's top amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:36:56.385277+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:19:50Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961016/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-06-26T21:50:05.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1403932"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961016')"
+"ID": "1572262"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1562594"
+post_author: 1
+"ListingKey": "29951014"
+"ListingId": "X13487184"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T17:55:16Z"
+"RFModificationTimestamp": "2026-06-27T17:56:56Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S6"
+"UnparsedAddress": "217 MAYFIELD AVENUE, Waterloo, Ontario N2J3S6"
+"Coordinates": array:2 [
0 => -80.510872
1 => 43.480402
]
+"Latitude": 43.480402
+"Longitude": -80.510872
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Find! Highly auspicious North-facing VASTU-compliant home; Fully Renovated LEGAL DUPLEX - Turnkey & Positive Cash Flow. Minutes from 3 universities 3+2 Bedrooms 2 Full Baths, 2 Kitchens. Detached bungalow on a large lot in a quiet, family-friendly avenue in the desirable Lincoln Heights / Glenridge neighbourhood - within the boundary of top-rated schools. MAIN FLOOR: Spacious layout with a Large primary bedroom and walk-out to a private deck overlooking the backyard, plus two additional regular bedrooms. LEGAL BASEMENT: 2 Large bedrooms + Office room. Highlights: Over 2,000 sq ft of finished living space; Detached oversized garage + long driveway with ample parking; Currently rented to respectful, responsible university students who pay on time and care for the property; POSITIVE CASH FLOW from day one; Bonus upside - BUILD BIG LATER: This large lot qualifies as-of-right for up to a 4-unit, 4-storey building under Waterloo's December 2024 "FOUR Units, FOUR Storeys" bylaw - no rezoning, no variances. A complete conceptual fourplex design (3D model + floor plans) is available for serious buyers. A standout opportunity for homeowners & investors alike. No gimmicks. NO offer date. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
7 => "Water Heater"
8 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:21:57.875346+00:00"
+"Directions": "Cross Streets: University Ave / Conestoga Pkwy. ** Directions: University Ave To Mayfield Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "60.1 x 120.7 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T13:13:58Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T17:47:10Z"
+"Stories": "1.0"
+"StreetName": "Mayfield"
+"StreetNumber": "217"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4451.61"
+"View": "View"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/48PjWV?branded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29951014/217-mayfield-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.1
+"OriginalEntryTimestamp": "2026-06-25T13:13:58.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1299556"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951014')"
+"ID": "1562594"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1563097"
+post_author: 1
+"ListingKey": "29953493"
+"ListingId": "40842924"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:40:16Z"
+"RFModificationTimestamp": "2026-06-25T21:14:57Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1488.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3G1"
+"UnparsedAddress": "255 CAMELOT Court Unit# 2, Waterloo, Ontario N2K3G1"
+"Coordinates": array:2 [
0 => -80.5079629
1 => 43.4921833
]
+"Latitude": 43.4921833
+"Longitude": -80.5079629
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2-255 Camelot Court, a charming 2-storey freehold townhome in Waterloo’s sought-after Lincoln Village. Offering 3 bedrooms and 1full bathroom, this home is an excellent opportunity for first-time buyers, young families, or investors looking to get into a well-established neighbourhood. The main floor features a bright, functional layout with spacious living areas and plenty of natural light, creating a warm and inviting atmosphere. Upstairs, you’ll find three comfortable bedrooms and a full bathroom—perfect for everyday family living. One of the standout features of this home is the backyard setting. Backing directly onto Sandowne Public School, you’ll enjoy added privacy with no rear neighbours. A deck off the living room provides the perfect space to relax or entertain outdoors. Additional highlights include an attached garage and private driveway with parking for two vehicles. Ideally located close to shopping, parks, schools, and with quick access to Highway 7/8, thishome offers both convenience and community. A great opportunity to own a freehold townhome in a desirable Waterloo neighbourhood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:14:49.632234+00:00"
+"Directions": "Hwy 8 E/ON-7, Take the University Ave East exit, Turn left onto Braemore Ave, Turn left onto Sandowne Dr, Turn right onto Dunvegan Dr, Turn left onto Bairstow Crescent, Turn left onto Camelot Ct, Property will be on the left"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099819"
+"ListOfficeKey": "292918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:33:04Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:33:04Z"
+"Stories": "2.0"
+"StreetName": "CAMELOT"
+"StreetNumber": "255"
+"StreetSuffix": "Court"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3186.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/255_camelot_ct_2_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/29953493/255-camelot-court-unit-2-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1138
+"BelowGradeFinishedArea": 350
+"OriginalEntryTimestamp": "2026-06-25T18:33:04.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1369903"
+"ListOfficeNationalAssociationId": "1419429"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953493')"
+"ID": "1563097"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1557351"
+post_author: 1
+"ListingKey": "29941712"
+"ListingId": "40842211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:22Z"
+"RFModificationTimestamp": "2026-06-28T20:25:14Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3520.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J1"
+"UnparsedAddress": "391 TIMLOCK Place, Waterloo, Ontario N2K3J1"
+"Coordinates": array:2 [
0 => -80.5005194
1 => 43.4981893
]
+"Latitude": 43.4981893
+"Longitude": -80.5005194
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home tucked away on a quiet court in Waterloo's sought-after Lexington neighbourhood. Surrounded by mature trees, parks, trails, schools and a strong sense of community, this is the kind of neighbourhood where families put down roots and stay for years. Offering generous above-grade living space plus a finished basement, this 4-bedroom, 4-bathroom home blends comfort, functionality and timeless style. Freshly painted in neutral tones with recent basement updates, it has been well maintained with a new roof (2020), furnace (2014), air conditioner (2026) 200 AMP service and many updated windows. The spacious kitchen is the heart of the home, with plenty of room for family and friends to gather. Multiple living areas on the main floor provide flexibility for everyday living and entertaining, including a welcoming family room, dining room and separate sitting room. Main floor laundry adds convenience. Upstairs, four generous bedrooms include a relaxing primary retreat with a beautifully updated ensuite bath. The finished basement adds valuable living space with a large recreation and games area, perfect for movie nights, gaming, ping pong, board games or simply spending time together. A separate bonus room works equally well as a home office, fitness room, guest space or hobby room. A two-piece bathroom and ample storage complete the lower level. Outside, the large private backyard offers plenty of room for children and pets to play, gardens to grow, or future outdoor living plans. A double garage and parking for four vehicles provide plenty of room for family and guests. Located minutes from Rim Park, recreation facilities, transit, shopping and everyday amenities, this home offers the perfect balance of peaceful suburban living and convenient city access. Beautifully maintained, thoughtfully updated and ideally located, this is a rare opportunity to own a home in one of Waterloo's most desirable family neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:50:07.259543+00:00"
+"Directions": "Bridge to Dansbury to Forestlawn to Timlock Pl"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830254"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:22:31Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:11:05Z"
+"Stories": "2.0"
+"StreetName": "TIMLOCK"
+"StreetNumber": "391"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "7963.37"
+"VirtualTourURLUnbranded": "https://youriguide.com/391_timlock_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29941712/391-timlock-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2400
+"BelowGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2026-06-23T16:11:30.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195645"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941712')"
+"ID": "1557351"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1555612"
+post_author: 1
+"ListingKey": "29938343"
+"ListingId": "40842043"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:21Z"
+"RFModificationTimestamp": "2026-06-28T20:25:27Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1090.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3T1"
+"UnparsedAddress": "207 B AUBURN Drive, Waterloo, Ontario N2K3T1"
+"Coordinates": array:2 [
0 => -80.4866626
1 => 43.4874765
]
+"Latitude": 43.4874765
+"Longitude": -80.4866626
+"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:62650)"
+"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-22T22:10:36.777923+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"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T20:32:10Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:11:12Z"
+"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/29938343/207-b-auburn-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1090
+"OriginalEntryTimestamp": "2026-06-22T20:32:10.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938343')"
+"ID": "1555612"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 87
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]