array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29964993 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: "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 [
"RoomKey" => "1671369203"
"RoomType" => "Laundry room"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
1 => array:11 [
"RoomKey" => "1671369204"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
2 => array:11 [
"RoomKey" => "1671369205"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
3 => array:11 [
"RoomKey" => "1671369206"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839771"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
4 => array:11 [
"RoomKey" => "1671369207"
"RoomType" => "Bedroom"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
5 => array:11 [
"RoomKey" => "1671369208"
"RoomType" => "Bedroom"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
6 => array:11 [
"RoomKey" => "1671369209"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839771"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
7 => array:11 [
"RoomKey" => "1671369210"
"RoomType" => "Dining room"
"ListingId" => "40839771"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
8 => array:11 [
"RoomKey" => "1671369211"
"RoomType" => "Kitchen"
"ListingId" => "40839771"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
9 => array:11 [
"RoomKey" => "1671369212"
"RoomType" => "Great room"
"ListingId" => "40839771"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964993"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:51:28.93Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29964993_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/9bb6ba55607c394c6f815f6cb72e76ed.webp"
"MediaSize" => 109868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-9bb6ba55607c394c6f815f6cb72e76ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story townhouse with light brick and horizontal siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964993_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/6f3cdd5fb6d33031d8add6d29b400745.webp"
"MediaSize" => 124414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-6f3cdd5fb6d33031d8add6d29b400745.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhome exterior featuring brick and horizontal siding, multiple windows with grilles, and an attached three-car garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964993_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/c0cd75e6edf7bf749896507ada2b71b0.webp"
"MediaSize" => 144135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-c0cd75e6edf7bf749896507ada2b71b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior featuring light-toned brick and horizontal siding, a covered front porch with a paneled entry door, and a concrete pathway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964993_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/c81b7920c0d0c67687228374490ec607.webp"
"MediaSize" => 125747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-c81b7920c0d0c67687228374490ec607.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered front entry with concrete porch, a brown entry door with upper glass paneling, and an exterior wall lantern"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964993_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/6c4437ef6854c325d3a09832e5443293.webp"
"MediaSize" => 53624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-6c4437ef6854c325d3a09832e5443293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry featuring ceramic tile flooring, a paneled entry door with decorative glass inserts, and two paneled closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964993_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/2ffbc806b5ad55931d9ff3ccaeeb7e48.webp"
"MediaSize" => 46328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-2ffbc806b5ad55931d9ff3ccaeeb7e48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring neutral wall tones and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964993_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/c7523175b299f95aaa8db9ebc6421573.webp"
"MediaSize" => 67670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-c7523175b299f95aaa8db9ebc6421573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, light-toned countertops, and stainless steel appliances including a refrigerator, range, and microwave"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964993_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/d4652bace65b5882437acaaba8b0b2ff.webp"
"MediaSize" => 73442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-d4652bace65b5882437acaaba8b0b2ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring a dining area with a contemporary chandelier, a kitchen with wood cabinetry and stainless steel appliances, and a living room with light-toned flooring and large wi"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964993_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/43c6acdfc5dc9936f88cf760daec1280.webp"
"MediaSize" => 72596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-43c6acdfc5dc9936f88cf760daec1280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring extensive wood cabinetry, light-toned countertops, stainless steel appliances, under-cabinet lighting, and light tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964993_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/860b764bc5be0434b6ccf232537585d5.webp"
"MediaSize" => 70455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-860b764bc5be0434b6ccf232537585d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept room featuring wood-finish flooring, neutral wall paint, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964993_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/c5d47aad4f3e598457f25a1443fd4065.webp"
"MediaSize" => 71934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-c5d47aad4f3e598457f25a1443fd4065.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Warm living area featuring wood-finish flooring, neutral wall tones, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964993_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/9ce3fd3451c31940f4ee89af9ee01f5a.webp"
"MediaSize" => 87318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-9ce3fd3451c31940f4ee89af9ee01f5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964993_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/015c64ef64a32b2f8ceaac1288994c4a.webp"
"MediaSize" => 72745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-015c64ef64a32b2f8ceaac1288994c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a contemporary track lighting fixture, and a large sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964993_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/79a3a57fa10787c8b25590b25dcc0a40.webp"
"MediaSize" => 63048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-79a3a57fa10787c8b25590b25dcc0a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a contemporary chandelier, neutral wall paint, and direct access to the main entry foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964993_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/f4cd44dc1020af3e5b1baee69c4225d1.webp"
"MediaSize" => 41414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-f4cd44dc1020af3e5b1baee69c4225d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with a chrome faucet, full-width mirror, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964993_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/4734a0927bb9d945066d8076ba944a96.webp"
"MediaSize" => 84396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-4734a0927bb9d945066d8076ba944a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring tile flooring, a staircase with wood banister and carpeted treads, a white paneled door with glass inserts, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964993_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/db6801c4722eadf3eee93df07f4d97e1.webp"
"MediaSize" => 82277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-db6801c4722eadf3eee93df07f4d97e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned room featuring a ceiling fan with integrated lighting, carpeted flooring, and two white panel doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964993_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/0b4c270d93e63b7b7c12ab574ad3a336.webp"
"MediaSize" => 93991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-0b4c270d93e63b7b7c12ab574ad3a336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned room featuring two windows with white blinds, a ceiling fan with integrated lighting, and wall-to-wall carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964993_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/51999cbabaa8410e2c1c8d2a0cf0660d.webp"
"MediaSize" => 101565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-51999cbabaa8410e2c1c8d2a0cf0660d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a wood-finish vanity with a light-toned countertop, a frameless mirror with a four-bulb vanity light, a toilet, a wall-mounted cabinet, and a glass-enclosed shower with tiled walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29964993_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/541bb26a692a2084c64f757f3e1b1ae2.webp"
"MediaSize" => 83038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-541bb26a692a2084c64f757f3e1b1ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower with clear glass enclosure, tiled walls, and decorative accent band"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29964993_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/0c8a51d39fe51adee1eddca4dbfb86d7.webp"
"MediaSize" => 79617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-0c8a51d39fe51adee1eddca4dbfb86d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring light-colored walls and a double-hung window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29964993_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/de12ca5e7b8d61d1471c0d8c16050f87.webp"
"MediaSize" => 63292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-de12ca5e7b8d61d1471c0d8c16050f87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring neutral wall tones, textured carpeting, a single window, and a flush mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29964993_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/4442d398c849b77af99a40ebc5b80fa9.webp"
"MediaSize" => 58920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-4442d398c849b77af99a40ebc5b80fa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring neutral-toned walls, light-colored carpeting, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29964993_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/cf3898d46a83d78156364da6450defc3.webp"
"MediaSize" => 45214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-cf3898d46a83d78156364da6450defc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral wall paint, white trim, and light carpeting throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29964993_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/8332534cbad7e7b059aeefef5aa760fb.webp"
"MediaSize" => 65411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-8332534cbad7e7b059aeefef5aa760fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area with front-load appliances and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29964993_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/b2523abcbb53fd70cab1c40e3a283f44.webp"
"MediaSize" => 58786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-b2523abcbb53fd70cab1c40e3a283f44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white bathtub and shower combination, a toilet, and a vanity with a light wood-finish cabinet and a white countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29964993_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/45e78d0dc1327be6ffd8bb10fc008638.webp"
"MediaSize" => 138036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-45e78d0dc1327be6ffd8bb10fc008638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor wood deck with a built-in bench, surrounded by mature trees and a private wooden fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29964993_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/a624865552bad4c6c86d1466ebab507e.webp"
"MediaSize" => 124692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-a624865552bad4c6c86d1466ebab507e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a lush lawn and a multi-level wooden deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29964993_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/f97f762825fc7abd71ba008c749ddebb.webp"
"MediaSize" => 134539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-f97f762825fc7abd71ba008c749ddebb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck featuring wood planking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29964993_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/3095e74564f41f4aec6aa41e5d4c8848.webp"
"MediaSize" => 137584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-3095e74564f41f4aec6aa41e5d4c8848.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a multi-level wooden deck with integrated bench seating, verdant lawn, and a privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29964993_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964993/36c421d994afbd1226375bd552ff1053.webp"
"MediaSize" => 151658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964993/thumbnail-36c421d994afbd1226375bd552ff1053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a sliding glass door, light-toned brick facade, and wood deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839771"
"ResourceRecordKey" => "29964993"
"ModificationTimestamp" => "2026-06-29T13:50:41.62Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
]
+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 294000" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24882
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Cache Key: f0151a4060bbd3ff2a94ccf0eb7e3c305804432bf85f528ce98b947ba3017e3a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29964993'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25228
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29964993'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25244
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29964993' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4908096 43.4991897)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25297
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+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"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964980_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/8001a6273a7d9765b63786f108aa201c.webp"
"MediaSize" => 169176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-8001a6273a7d9765b63786f108aa201c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964980_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/924fef7b48a80909e6eaa6b9e8df34ba.webp"
"MediaSize" => 163723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-924fef7b48a80909e6eaa6b9e8df34ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964980_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/67072ee1ba64ab561d3150d0d761cf95.webp"
"MediaSize" => 138097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-67072ee1ba64ab561d3150d0d761cf95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964980_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/f989548f4177c4aad3cf1a9370808330.webp"
"MediaSize" => 171429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-f989548f4177c4aad3cf1a9370808330.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964980_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/28c0524497d6ed886784f3ea624ab531.webp"
"MediaSize" => 127519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-28c0524497d6ed886784f3ea624ab531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964980_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/73bc4ca27fe41687c0163741959d7064.webp"
"MediaSize" => 104633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-73bc4ca27fe41687c0163741959d7064.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964980_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/3fedab442c12ec91686e91f8639bbd54.webp"
"MediaSize" => 143654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-3fedab442c12ec91686e91f8639bbd54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964980_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/f6d718a6c6caff8d34af1e32790db117.webp"
"MediaSize" => 90707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-f6d718a6c6caff8d34af1e32790db117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room - main"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964980_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/87fbcad829a0ad2ce968beb7dc54c9dc.webp"
"MediaSize" => 124694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-87fbcad829a0ad2ce968beb7dc54c9dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964980_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/2ff36e46eadbc278733d3f607eceb7bf.webp"
"MediaSize" => 146235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-2ff36e46eadbc278733d3f607eceb7bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964980_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/799f442b0946075d5125bae7a755b431.webp"
"MediaSize" => 124834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-799f442b0946075d5125bae7a755b431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
"ModificationTimestamp" => "2026-06-29T13:50:08.27Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964980_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964980/b96c052ef926d8d52680be53caf66965.webp"
"MediaSize" => 127222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964980/thumbnail-b96c052ef926d8d52680be53caf66965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13499606"
"ResourceRecordKey" => "29964980"
…1
]
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 {#25293
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1564964"
+post_author: 1
+"ListingKey": "29948389"
+"ListingId": "X13484878"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T13:55:01Z"
+"RFModificationTimestamp": "2026-06-26T13:55:57Z"
+"ListPrice": 1999900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K4H9"
+"UnparsedAddress": "521 FALCONRIDGE CRESCENT, Kitchener, Ontario N2K4H9"
+"Coordinates": array:2 [
0 => -80.479567
1 => 43.499168
]
+"Latitude": 43.499168
+"Longitude": -80.479567
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 521 Falconridge Crescent, an exceptional custom-built home in Kitchener's coveted Kiwanis Park community. Situated on a premium -acre lot surrounded by beautiful homes, parks, and trails, this one-of-a-kind residence offers over 4,800 sq. ft. of finished living space with 6 bedrooms and 5 bathrooms.Designed for modern and multi-generational living, this home features a fully self-contained basement apartment with a separate entrance, custom kitchen, and private laundry. A dedicated nanny/in-law suite provides additional flexibility, complete with rough-ins for a third kitchen and laundry area.The stunning main floor is highlighted by soaring 17-foot coffered ceilings, a dramatic marble-surround fireplace, and expansive windows that flood the home with natural light. The chef-inspired kitchen overlooks the family room and features a 10-foot island with seating for four, premium stainless steel appliances, custom cabinetry, drawer organizers, and abundant storage.The main-floor primary retreat offers a cathedral ceiling, custom walk-in closet, luxurious 5-piece ensuite with heated floors, and direct access to the backyard. A private den with cathedral ceilings creates the perfect work-from-home space, while the mudroom features built-in storage and convenient main-floor laundry.Upstairs, you'll find a second primary bedroom with soaring ceilings, two additional spacious bedrooms, and a beautifully appointed main bathroom with heated floors, double sinks, and ample storage.Premium features include custom windows and doors, electric blinds throughout, heated bathroom floors, and quality finishes throughout the home. Outside, the professionally landscaped backyard provides exceptional privacy and plenty of space for entertaining, family gatherings, or a future pool.A rare opportunity to own a truly unique home that perfectly blends luxury, comfort, and versatility in one of Kitchener's most sought-after neighbourhoods. "LUXURY CERTIFIED" (id:62650)"
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Two stoves"
3 => "Two Washers"
4 => "Garage door opener"
5 => "Two Refrigerators"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:46.215441+00:00"
+"Directions": "Cross Streets: Falconridge Drive. ** Directions: University/Woolwich/Falcronridge."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1520370"
+"ListOfficeKey": "291093"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "58 x 120 FT ; 119.95Ft X53.20Ft X5.11Ft X5.11Ftx132.87"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T13:45:51Z"
+"Stories": "2.0"
+"StreetName": "Falconridge"
+"StreetNumber": "521"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "10935"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/521-Falconridge-Crescent/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948389/521-falconridge-crescent-kitchener"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1957768"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291093"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 58.0
+"OriginalEntryTimestamp": "2026-06-24T18:56:18.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1137355"
+"ListOfficeNationalAssociationId": "1394340"
+"CoListAgentNationalAssociationId": "1248851"
+"CoListOfficeNationalAssociationId": "1394340"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948389')"
+"ID": "1564964"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1561251"
+post_author: 1
+"ListingKey": "29952261"
+"ListingId": "40842604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T02:00:28Z"
+"RFModificationTimestamp": "2026-06-26T04:47:15Z"
+"ListPrice": 1450000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 3
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3559.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K4J2"
+"UnparsedAddress": "576 FALCONRIDGE Crescent, Kitchener, Ontario N2K4J2"
+"Coordinates": array:2 [
0 => -80.4768802
1 => 43.499476
]
+"Latitude": 43.499476
+"Longitude": -80.4768802
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Rare Offering Backing Onto Kiwanis Park – Luxury Living at Its Finest! Welcome to this exceptional custom-built executive home offering over 3,600 sq. ft. of finished living space on a premium lot backing directly onto the tranquil green space of Kiwanis Park. Designed for both elegant entertaining and everyday living, this one-of-a-kind residence showcases quality craftsmanship and thoughtful design throughout. A grand foyer welcomes you into a bright, open-concept layout featuring 9-foot ceilings, a sunken family room with coffered ceilings & a gas fireplace, and expansive windows framing stunning backyard views. The custom Chervin kitchen will satisfy any chef, complete with bespoke cabinetry, granite countertops, built-in stainless appls, and an induction stove. The luxurious primary suite offers a private retreat with a spa-inspired 5-piece ensuite, 2nd gas fireplace, private balcony, overlooking the backyard oasis, California Closet, & dressing room. Two additional oversized bedrooms & a spacious loft provide exceptional flexibility for family living. The finished lower level adds apprx 1,000 sq. ft. of add'l living space with a large recreation room, laundry room with chute, extensive storage & future office potential. Step outside to your fully-fenced, resort-style backyard oasis featuring a covered concrete patio, saltwater pool, expansive yard, and unmatched privacy with no rear neighbours. Premium features and customization throughout the home include in-floor heating, hardwood and porcelain flooring, a whole-home speaker system, designer lighting, & an oversized double garage with workshop, potting area, pool shower, & change room, extensively landscaped with an irrigation system, Custom European Windows & doors throughout. Ideally located minutes from schools, shopping, dining, & expressway access, this remarkable property offers a rare opportunity to own one of the area's most distinguished homes. Luxury, privacy, and craftsmanship—welcome home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 3
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:21:13.600443+00:00"
+"Directions": "Falconridge Dr to Falconridge Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564059"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T17:33:06Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T01:50:49Z"
+"Stories": "2.0"
+"StreetName": "FALCONRIDGE"
+"StreetNumber": "576"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "8981"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/576-Falconridge-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29952261/576-falconridge-crescent-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 2609
+"BelowGradeFinishedArea": 950
+"OriginalEntryTimestamp": "2026-06-25T17:11:55.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1141403"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952261')"
+"ID": "1561251"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1562101"
+post_author: 1
+"ListingKey": "29952685"
+"ListingId": "X13488616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:10:12Z"
+"RFModificationTimestamp": "2026-06-25T23:49:18Z"
+"ListPrice": 535000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K1T1"
+"UnparsedAddress": "10 MACVILLE AVENUE, Kitchener, Ontario N2K1T1"
+"Coordinates": array:2 [
0 => -80.4813503
1 => 43.4873141
]
+"Latitude": 43.4873141
+"Longitude": -80.4813503
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 10 MacVille Avenue, a rare cottage-in-the-city retreat offering a perfect blend of bespoke design, absolute tranquility, and incredible financial upside. Nestled on a unique, quiet dead end street known for its friendly community and minimal traffic, this immaculate 2 bedroom, 1 bathroom detached freehold home is a true hidden gem. Whether you want to downsize, buy your first home, or need the perfect location to build your future dream home, this special property is a must see. The interior boasts a meticulously cared for aesthetic where every design choice perfectly honours the home's character. The heart of the home features a brilliantly remodelled kitchen, strategically moved to the front to optimize space, maximize natural light, and create a seamless flow through the house. The primary bedroom provides ample closet space, while the second bedroom would make a great nursery or home office. A classic interior walk down leads into the unfinished basement, laundry, and storage area. Step outside into your own private backyard sanctuary. Backing onto a serene unspoiled view, this deep, lush lot offers exceptional privacy with a large entertaining deck and storage shed. For buyers looking long term, the sheer size of the lot provides unparalleled potential for future expansion or additions. Surrounded by pristine homes, including a current active listing on the street offered at $1.5M, this property represents an elite investment opportunity. Enjoy ultimate peace of mind while remaining minutes from Conestoga Mall, universities, transit, and premium amenities. Frigidaire Refrigerator (Jan 2022) Frigidaire Range (Jan 2022) Frigidaire Dishwasher (August 2024). (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T18:25:04.272270+00:00"
+"Directions": "Cross Streets: Woolwich St and MacVille. ** Directions: Bridge St to Woolwich St to MacVille."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004361"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Carpet Free"
]
+"LotSizeDimensions": "48 x 111 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T17:43:53Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:04:40Z"
+"Stories": "1.0"
+"StreetName": "Macville"
+"StreetNumber": "10"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3524.46"
+"VirtualTourURLUnbranded": "https://youriguide.com/jjost_10_macville_ave_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29952685/10-macville-avenue-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1555410"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85457"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential Zone A"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 48.0
+"OriginalEntryTimestamp": "2026-06-25T17:43:53.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1286811"
+"ListOfficeNationalAssociationId": "1002051"
+"CoListAgentNationalAssociationId": "1099841"
+"CoListOfficeNationalAssociationId": "1002051"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952685')"
+"ID": "1562101"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1535126"
+post_author: 1
+"ListingKey": "29909398"
+"ListingId": "X13449660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T20:05:14Z"
+"RFModificationTimestamp": "2026-06-30T20:22:12Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K0C5"
+"UnparsedAddress": "275 FALCONRIDGE DRIVE, Kitchener, Ontario N2K0C5"
+"Coordinates": array:2 [
0 => -80.47411
1 => 43.49865
]
+"Latitude": 43.49865
+"Longitude": -80.47411
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Situated in a sought-after East Kitchener neighbourhood, this well-maintained family home offers a versatile layout with generous living space across all levels. The main floor is designed for everyday comfort and entertaining, featuring bright principal rooms, a functional kitchen, and seamless flow throughout the home. Upstairs, spacious bedrooms provide ample room for growing families, while the fully finished lower level offers additional living space ideal for extended family, guests, a home office, or recreation.Step outside to enjoy a private backyard setting with plenty of space for outdoor dining, relaxation, and seasonal gatherings. The property's practical design, abundant storage, and multiple living areas provide flexibility to suit a variety of lifestyles.Conveniently located near parks, walking trails, schools, shopping, recreation facilities, and major commuter routes, this home combines neighbourhood appeal with everyday convenience. An excellent opportunity to own a move-in-ready home in one of Kitchener's most established and family-friendly communities. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:23:57.791295+00:00"
+"Directions": "Cross Streets: Eaglecrest. ** Directions: Corner of Falconridge Dr and Eaglecrest St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163246"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "48.5 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T19:56:01Z"
+"Stories": "2.0"
+"StreetName": "Falconridge"
+"StreetNumber": "275"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6227"
+"VirtualTourURLUnbranded": "https://youriguide.com/falconbridge_dr_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909398/275-falconridge-drive-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "RES-3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 48.6
+"OriginalEntryTimestamp": "2026-06-16T15:02:19.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1414226"
+"ListOfficeNationalAssociationId": "1338998"
+"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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909398')"
+"ID": "1535126"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 71
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]