array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29854251 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: "1496013"
+post_author: 1
+"ListingKey": "29854251"
+"ListingId": "X13240524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T14:00:05Z"
+"RFModificationTimestamp": "2026-06-30T14:03:03Z"
+"ListPrice": 2050000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z2"
+"UnparsedAddress": "345 OLD STONE ROAD, Waterloo, Ontario N2K1Z2"
+"Coordinates": array:2 [
0 => -80.511713
1 => 43.501889
]
+"Latitude": 43.501889
+"Longitude": -80.511713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to an extraordinary Colonial Acres bungalow, offering over 4,000 sq. ft. of finished living space on a breathtaking 0.376-acre park-like lot. Combining luxury, comfort, and resort-style outdoor living, this exceptional property is a rare opportunity in one of Waterloo's most sought-after neighbourhoods. From the moment you arrive, you'll be impressed by the outstanding curb appeal, featuring an oversized double-car garage and an expansive driveway with parking for six or more vehicles. The beautifully landscaped grounds create a private backyard retreat complete with a stunning inground concrete pool,hot tub, and multiple outdoor entertaining spaces designed for relaxation and memorable gatherings. Inside, the thoughtfully designed open-concept main floor is highlighted by a dramatic two-sided stone gas fireplace that serves as the heart of the home. The custom gourmet kitchen is a chef's dream, showcasing premium appliances, a gas cooktop, built-in convection oven and microwave, wine fridge, oversized island, and peninsula seating-perfect for both everyday living and entertaining. The main level features three spacious bedrooms, including a generous primary retreat, along with a beautifully appointed main bathroom featuring a double-sink vanity, glass shower, and luxurious soaker tub. A separate front entrance leads to a functional mudroom and laundry area, complemented by a stylish powder room with a custom live-edge vanity. The finished lower level extends the home's impressive living space with a large family room featuring a cozy gas stove, two oversized bedrooms, a full bathroom, and a versatile office/library complete with custom built-in shelving. Offering the perfect blend of luxury and convenience, this private urban oasis is ideally located just minutes from the expressway, shopping, golf courses, parks, and everyday amenities. Experience resort-style living without ever leaving the city. (id:62783)"
+"Appliances": array:15 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
14 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T19:09:52.050938+00:00"
+"Directions": "Cross Streets: Lexington Road and Lee Ave. ** Directions: Lee Ave to Green Acres to Old Stone."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "125.2 x 132.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T13:51:51Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T13:51:51Z"
+"Stories": "1.0"
+"StreetName": "Old Stone"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "9039.77"
+"VirtualTourURLUnbranded": "https://youriguide.com/345_old_stone_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854251/345-old-stone-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 125.2
+"OriginalEntryTimestamp": "2026-06-04T17:13:02.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29854251_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/92f6b9bf4682c394c3dfdce29a1c290e.webp"
"MediaSize" => 216228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-92f6b9bf4682c394c3dfdce29a1c290e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-26T16:17:02.46Z"
]
1 => array:13 [
"Order" => 6
"MediaKey" => "29854251_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/a8fdf1b1e7e9289321f59c1599210b01.webp"
"MediaSize" => 175478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-a8fdf1b1e7e9289321f59c1599210b01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
2 => array:13 [
"Order" => 7
"MediaKey" => "29854251_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/43f235b461122f389cc1f0e8743bd277.webp"
"MediaSize" => 90374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-43f235b461122f389cc1f0e8743bd277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
3 => array:13 [
"Order" => 8
"MediaKey" => "29854251_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/3d1dee3954baca9d14a48f4455cb3fce.webp"
"MediaSize" => 133130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-3d1dee3954baca9d14a48f4455cb3fce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
4 => array:13 [
"Order" => 9
"MediaKey" => "29854251_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/2f9bd32a8965790480f560b95ee79cb6.webp"
"MediaSize" => 121322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-2f9bd32a8965790480f560b95ee79cb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
5 => array:13 [
"Order" => 10
"MediaKey" => "29854251_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/cdda2dcf72fae69de45d12ec1a65d73f.webp"
"MediaSize" => 131153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-cdda2dcf72fae69de45d12ec1a65d73f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
6 => array:13 [
"Order" => 11
"MediaKey" => "29854251_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/2d4689d48f4f3ceae8ee2a8190965cd0.webp"
"MediaSize" => 124399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-2d4689d48f4f3ceae8ee2a8190965cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
7 => array:13 [
"Order" => 12
"MediaKey" => "29854251_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/cdd113f934103c25e7db2119d813120a.webp"
"MediaSize" => 104919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-cdd113f934103c25e7db2119d813120a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-04T17:13:02.9Z"
]
8 => array:13 [
"Order" => 13
"MediaKey" => "29854251_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/f16176c4fa44f04be9515d2e4c50f277.webp"
"MediaSize" => 86910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-f16176c4fa44f04be9515d2e4c50f277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.62Z"
]
9 => array:13 [
"Order" => 14
"MediaKey" => "29854251_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b42bf3c70c0da5362d565c0620153b43.webp"
"MediaSize" => 119073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b42bf3c70c0da5362d565c0620153b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.63Z"
]
10 => array:13 [
"Order" => 15
"MediaKey" => "29854251_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/f466972bc808df854bd09affbe315634.webp"
"MediaSize" => 147471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-f466972bc808df854bd09affbe315634.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.63Z"
]
11 => array:13 [
"Order" => 16
"MediaKey" => "29854251_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/14f59dd20a0ed3a845f6a4b12c50f4dc.webp"
"MediaSize" => 132424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-14f59dd20a0ed3a845f6a4b12c50f4dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.62Z"
]
12 => array:13 [
"Order" => 17
"MediaKey" => "29854251_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/0f2b021c9cec241b61069bbc1ab1d7f9.webp"
"MediaSize" => 81380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-0f2b021c9cec241b61069bbc1ab1d7f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:47.8Z"
]
13 => array:13 [
"Order" => 18
"MediaKey" => "29854251_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/560f4364c5104b7d38f2ab1c1717e6a4.webp"
"MediaSize" => 139336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-560f4364c5104b7d38f2ab1c1717e6a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:51.77Z"
]
14 => array:13 [
"Order" => 19
"MediaKey" => "29854251_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/ed83320c4c640ae4e597056096cc4b6e.webp"
"MediaSize" => 110518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-ed83320c4c640ae4e597056096cc4b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.61Z"
]
15 => array:13 [
"Order" => 20
"MediaKey" => "29854251_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/703f1250c546ae9b70776e2f4706f9c0.webp"
"MediaSize" => 104314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-703f1250c546ae9b70776e2f4706f9c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.62Z"
]
16 => array:13 [
"Order" => 21
"MediaKey" => "29854251_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/5006dc5dbfc19b6d6d0b82bea3899f70.webp"
"MediaSize" => 100747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-5006dc5dbfc19b6d6d0b82bea3899f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:52.65Z"
]
17 => array:13 [
"Order" => 22
"MediaKey" => "29854251_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/6e151a7fa9d4ee8531726ec3e947c7f6.webp"
"MediaSize" => 89878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-6e151a7fa9d4ee8531726ec3e947c7f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:53.61Z"
]
18 => array:13 [
"Order" => 23
"MediaKey" => "29854251_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/0fc1214fba2d328fcca3514a759b95be.webp"
"MediaSize" => 76250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-0fc1214fba2d328fcca3514a759b95be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:53.84Z"
]
19 => array:13 [
"Order" => 24
"MediaKey" => "29854251_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/e675b3e089fcb8e7f640dcacb323ba6d.webp"
"MediaSize" => 117575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-e675b3e089fcb8e7f640dcacb323ba6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.1Z"
]
20 => array:13 [
"Order" => 25
"MediaKey" => "29854251_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/894548184b68069b4d4d716e7fe0a334.webp"
"MediaSize" => 99657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-894548184b68069b4d4d716e7fe0a334.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.66Z"
]
21 => array:13 [
"Order" => 26
"MediaKey" => "29854251_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/7d6a3e4c815aa798aea362847ed6919d.webp"
"MediaSize" => 115204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-7d6a3e4c815aa798aea362847ed6919d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.38Z"
]
22 => array:13 [
"Order" => 27
"MediaKey" => "29854251_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b469727b0d9030ca28d4088e8c263d42.webp"
"MediaSize" => 109827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b469727b0d9030ca28d4088e8c263d42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.11Z"
]
23 => array:13 [
"Order" => 28
"MediaKey" => "29854251_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/8f82ff4daffd23d2607b5d8e4469240f.webp"
"MediaSize" => 120665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-8f82ff4daffd23d2607b5d8e4469240f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.25Z"
]
24 => array:13 [
"Order" => 29
"MediaKey" => "29854251_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/3f317fa5232fd0a26b92075736e48bf6.webp"
"MediaSize" => 114670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-3f317fa5232fd0a26b92075736e48bf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:53.9Z"
]
25 => array:13 [
"Order" => 30
"MediaKey" => "29854251_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b511254b2c3a55c76df0f6098930826f.webp"
"MediaSize" => 116482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b511254b2c3a55c76df0f6098930826f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.33Z"
]
26 => array:13 [
"Order" => 31
"MediaKey" => "29854251_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/d644c74194a32102849965a33449b2e5.webp"
"MediaSize" => 66937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-d644c74194a32102849965a33449b2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.61Z"
]
27 => array:13 [
"Order" => 32
"MediaKey" => "29854251_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/719f5efde13d4acca259d81733d5298e.webp"
"MediaSize" => 93945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-719f5efde13d4acca259d81733d5298e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.62Z"
]
28 => array:13 [
"Order" => 33
"MediaKey" => "29854251_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/736ccc04bc20863c19461f1eee01607c.webp"
"MediaSize" => 119058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-736ccc04bc20863c19461f1eee01607c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.47Z"
]
29 => array:13 [
"Order" => 34
"MediaKey" => "29854251_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b519b9059b2080a1ad6c38f8dfa8b84d.webp"
"MediaSize" => 125878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b519b9059b2080a1ad6c38f8dfa8b84d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.41Z"
]
30 => array:13 [
"Order" => 35
"MediaKey" => "29854251_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/d7e0e5152b048819f2033113bc0f13e9.webp"
"MediaSize" => 249998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-d7e0e5152b048819f2033113bc0f13e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.64Z"
]
31 => array:13 [
"Order" => 36
"MediaKey" => "29854251_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/56209eb9401510b6cf0b3830a3596640.webp"
"MediaSize" => 246792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-56209eb9401510b6cf0b3830a3596640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:53.99Z"
]
32 => array:13 [
"Order" => 37
"MediaKey" => "29854251_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/a90fe6ef9c0697f8e525b142f3302096.webp"
"MediaSize" => 199982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-a90fe6ef9c0697f8e525b142f3302096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.32Z"
]
33 => array:13 [
"Order" => 38
"MediaKey" => "29854251_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/1f0cce3f6a0b5c91ef6996f28bbbb4b6.webp"
"MediaSize" => 241717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-1f0cce3f6a0b5c91ef6996f28bbbb4b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.43Z"
]
34 => array:13 [
"Order" => 39
"MediaKey" => "29854251_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/4a11df0943fe64b4b97cc3fd375befea.webp"
"MediaSize" => 259134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-4a11df0943fe64b4b97cc3fd375befea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.6Z"
]
35 => array:13 [
"Order" => 40
"MediaKey" => "29854251_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/c34df78e287e8f67c2cee071e16feba7.webp"
"MediaSize" => 208524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-c34df78e287e8f67c2cee071e16feba7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.21Z"
]
36 => array:13 [
"Order" => 41
"MediaKey" => "29854251_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/558a7c6917730cf280133c89485afa9b.webp"
"MediaSize" => 206804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-558a7c6917730cf280133c89485afa9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.28Z"
]
37 => array:13 [
"Order" => 42
"MediaKey" => "29854251_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/6370194ce88b19ea4f6d1659acdeea6e.webp"
"MediaSize" => 241715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-6370194ce88b19ea4f6d1659acdeea6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.65Z"
]
38 => array:13 [
"Order" => 43
"MediaKey" => "29854251_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b6c75cecece88d83dca044aaac6902e4.webp"
"MediaSize" => 203380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b6c75cecece88d83dca044aaac6902e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.58Z"
]
39 => array:13 [
"Order" => 44
"MediaKey" => "29854251_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/8bb2dbed22821db0157ba28b73fbd07a.webp"
"MediaSize" => 215779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-8bb2dbed22821db0157ba28b73fbd07a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.53Z"
]
40 => array:13 [
"Order" => 45
"MediaKey" => "29854251_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/7d0e73845d7011b2e6a8cdeedea6e08a.webp"
"MediaSize" => 196025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-7d0e73845d7011b2e6a8cdeedea6e08a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-20T11:49:54.33Z"
]
41 => array:13 [
"Order" => 2
"MediaKey" => "29854251_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/19dad54c899aca7c25e59777fee059c4.webp"
"MediaSize" => 223646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-19dad54c899aca7c25e59777fee059c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:46.66Z"
]
42 => array:13 [
"Order" => 3
"MediaKey" => "29854251_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/9c52f3a7c28ca87dd18d8bfb92686afc.webp"
"MediaSize" => 158489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-9c52f3a7c28ca87dd18d8bfb92686afc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:51.28Z"
]
43 => array:13 [
"Order" => 4
"MediaKey" => "29854251_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/be750c7abd2dc517d09011f4d0f911ab.webp"
"MediaSize" => 211048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-be750c7abd2dc517d09011f4d0f911ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:46.67Z"
]
44 => array:13 [
"Order" => 5
"MediaKey" => "29854251_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/19a5d2a127faad068ebd686b8c9f2acc.webp"
"MediaSize" => 164372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-19a5d2a127faad068ebd686b8c9f2acc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:51.3Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29854251_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/55ce4274fd1337fde1b6e409d17e9ad2.webp"
"MediaSize" => 223740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-55ce4274fd1337fde1b6e409d17e9ad2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:51.36Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29854251_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/5c245c9b5ba0ae8e9be344cdd90757ed.webp"
"MediaSize" => 186362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-5c245c9b5ba0ae8e9be344cdd90757ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:46.71Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29854251_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/80eceb09841f0fee3294042c696ff780.webp"
"MediaSize" => 215400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-80eceb09841f0fee3294042c696ff780.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:51.04Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29854251_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/6b9454342baefd15aa7515c21c8e9ce5.webp"
"MediaSize" => 141376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-6b9454342baefd15aa7515c21c8e9ce5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:46.79Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29854251_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29854251/b78add971707d1224072c62252a6e129.webp"
"MediaSize" => 216398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29854251/thumbnail-b78add971707d1224072c62252a6e129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13240524"
"ResourceRecordKey" => "29854251"
"ModificationTimestamp" => "2026-06-30T13:51:46.71Z"
]
]
+"DaysOnMarket": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854251')"
+"ID": "1496013"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 296481" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24923
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211703" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29854251'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29854251'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25304
+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 '29854251' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.511713 43.501889)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25377
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+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
…9
]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964980')"
+"ID": "1576427"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1575738"
+post_author: 1
+"ListingKey": "29964993"
+"ListingId": "40839771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:07Z"
+"RFModificationTimestamp": "2026-06-29T19:03:37Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 1440.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT Street, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.4908096
1 => 43.4991897
]
+"Latitude": 43.4991897
+"Longitude": -80.4908096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property.The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23 AC ' 22 (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:32:02.394661+00:00"
+"Directions": "University to Colt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:41Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:51:28Z"
+"Stories": "2.0"
+"StreetName": "COLT"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964993/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1440
+"OriginalEntryTimestamp": "2026-06-29T13:50:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1574855"
+post_author: 1
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T03:45:02Z"
+"RFModificationTimestamp": "2026-06-30T03:49:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2615.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "729 GRAND BANKS Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.4982397
1 => 43.5124183
]
+"Latitude": 43.5124183
+"Longitude": -80.4982397
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home in the highly desirable Eastbridge neighbourhood! Featuring a bright open-concept layout, this well-maintained home offers a grand two-storey foyer, spacious Great Room with maple hardwood flooring, California shutters, and a walkout to the deck with stunning seasonal views of the Grand River. The kitchen boasts abundant cabinetry, a breakfast bar, and updated appliances. Upstairs, the spacious primary bedroom features a walk-in closet, an elegant 9'4 tray ceiling, and a private ensuite. The finished walkout basement provides additional living space, direct access to a large stone patio, and a rough-in for a future bathroom. The fully fenced backyard is perfect for family enjoyment and entertaining. Recent updates include roof (2021), driveway resurfacing (2023), patio and deck improvements (2024), bathroom updates (2025), washer (2022), kitchen appliances (2019), and owned water softener. Ideally located within walking distance to top-rated schools and close to RIM Park, shopping, trails, transit, and the Expressway. A fantastic opportunity to own a move-in-ready home in one of Waterloo's most sought-after family communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:20:09.218915+00:00"
+"Directions": "TAKE UNIVERSITY AVE EAST; TURN LEFT ON TO NEW BEDFORD DR; THEN TURN RIGHT ON TO GRAND BANKS DR."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T03:39:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T03:39:21Z"
+"Stories": "2.0"
+"StreetName": "GRAND BANKS"
+"StreetNumber": "729"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964583/729-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1825
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-29T05:59:41.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1574152"
+post_author: 1
+"ListingKey": "29963525"
+"ListingId": "40843481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T01:33:44Z"
+"ListPrice": 354990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive Unit# 308, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213765
1 => 43.5107332
]
+"Latitude": 43.5107332
+"Longitude": -80.5213765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 1-bedroom plus den, 1-bath condo offering the perfect blend of style, comfort, and low-maintenance living in one of the area's most sought-after neighbourhoods. This beautifully appointed unit features high-end finishes, abundant natural light, a primary bedroom complete with a walk-in closet and ensuite access, convenient in-suite laundry, one underground parking space, and a private locker. The versatile den is ideal for a home office. Enjoy an impressive selection of building amenities, including a fitness centre, event room, rooftop terrace with BBQ area and beautiful views, bike storage, and even a dog washing station. The well-maintained building also offers keyless entry. Perfectly situated just minutes from restaurants, shopping, theatres, the community centre, and the renowned St. Jacobs Farmers' Market. Outdoor enthusiasts will appreciate the nearby Walter Bean Trail, Grand River, RIM Park, and Grey Silo Golf Course. Conveniently located close to two universities with quick access to Highways 85 and 401, making commuting a breeze. This exceptional condo truly has it all—don't miss your opportunity to make it yours. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "493"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:33:38.248335+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-28T00:20:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:20:47Z"
+"Stories": "3.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3137.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963525/255-northfield-drive-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 582
+"OriginalEntryTimestamp": "2026-06-28T00:20:47.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963525')"
+"ID": "1574152"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1572262"
+post_author: 1
+"ListingKey": "29961016"
+"ListingId": "40843507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:21Z"
+"RFModificationTimestamp": "2026-06-27T20:29:58Z"
+"ListPrice": 1630000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.5202288
1 => 43.5085201
]
+"Latitude": 43.5085201
+"Longitude": -80.5202288
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional family living at 250 Grey Squirrel Place, a beautifully maintained home nestled on a quiet crescent in Waterloo's sought-after Colonial Acres. Situated on a rare double-sized lot, this impressive property offers an outstanding blend of space, comfort, and privacy in one of the city's most established neighbourhoods. Step inside to an inviting interior highlighted by soaring 14-foot ceilings in the front living room, rich hardwood flooring, and a charming wood-burning fireplace. A second fireplace anchors the spacious family room, providing the perfect setting for relaxed evenings, while a dedicated main-floor office offers a quiet space for working from home. Everyday convenience is enhanced by the functional mudroom and laundry area with direct access from the double-car garage. At the heart of the home, the well-appointed kitchen features granite countertops, a Bosch stove, Miele appliances, and a walkout to the newly completed tiered wood deck (2025). The expansive backyard is a true standout, offering a sports court, mature landscaping, Honeycrisp apple trees, a peach tree, and ample room for entertaining, gardening, or family recreation. The upper level features four spacious bedrooms, including a private primary retreat with its own ensuite bath, as well as a second full bathroom to accommodate family and guests. The fully finished basement adds incredible versatility with two additional bedrooms, a three-piece bathroom, and a large recreation area ideal for movie nights, games, or multi-generational living. Surrounded by mature trees and enhanced by an interlock driveway, this home delivers both curb appeal and lasting quality. Ideally positioned just minutes from Uptown Waterloo, the University of Waterloo, Waterloo Park, RIM Park, Grey Silo Golf Course, and The Boardwalk, this exceptional property offers the perfect balance of peaceful family living and convenient access to the region's top amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:36:56.385277+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:19:50Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961016/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-06-26T21:50:05.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1403932"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961016')"
+"ID": "1572262"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+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"
}
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 {#25375
+post_id: "1538278"
+post_author: 1
+"ListingKey": "29914287"
+"ListingId": "40839253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:00:17Z"
+"RFModificationTimestamp": "2026-06-23T19:54:52Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.094
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z8"
+"UnparsedAddress": "212 SLEAFORD Street, Waterloo, Ontario N2J4Z8"
+"Coordinates": array:2 [
0 => -80.5224041
1 => 43.4908368
]
+"Latitude": 43.4908368
+"Longitude": -80.5224041
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Welcome to 212 Sleaford Street, Waterloo!** LOCATION LOCATION LOCATION!! This inviting detached house with a double-car garage locates in one of the most desirable area in the City of Waterloo. It offers an exceptional combination of space, versatility, and convenience. The upper level features 3 comfortable bedrooms and a generously sized family room filled with natural light, make it an ideal space for relaxing, entertaining, or spending quality time with family members together. The finished basement expands the home’s possibilities with an additional bedroom, a 3-piece bathroom, and spacious recreation space. With its own separate entrance, the lower level offers excellent flexibility for extended family, guests, a private home office, or potential future rental use. Ideally situated just minutes from Conestoga Mall and HWY 85, provides convenient access to shopping, restaurants, public transit, major routes throughout Waterloo Region. It is also within easy reach of the University of Waterloo, Wilfrid Laurier University, and Conestoga College by public transit or a 10 mins drive, making it an attractive opportunity for first-time buyers, growing families, and investors alike. RIM Park Sportsplex is also nearby, provides family with easy access to various sports throughout the season (hockey, skating, indoor/outdoor soccer fields, basketball, badminton and more). Recent improvements include a new hot water tank installed in 2026 (owned), and a new water softener (owned, 2025). As an added bonus, ALL FURNITURE currently in the home can be INCLUDED, offering a truly convenient and move-in-ready opportunity. With its generous living space, versatile finished basement, double garage, and highly desirable Waterloo location, this is a home you will not want to miss!!! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:57:09.434616+00:00"
+"Directions": "Dearborn Blvd / Tealby Crt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168724"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.094"
+"PhotosChangeTimestamp": "2026-06-19T21:41:14Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:52:05Z"
+"Stories": "2.0"
+"StreetName": "SLEAFORD"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5421.13"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …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/29914287/212-sleaford-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1818
+"BelowGradeFinishedArea": 753
+"OriginalEntryTimestamp": "2026-06-17T11:50:23.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419405"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914287')"
+"ID": "1538278"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T16:35:07Z"
+"RFModificationTimestamp": "2026-06-29T16:47:50Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "633"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:29:14Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 59
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]