array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29816047 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: "1467814"
+post_author: 1
+"ListingKey": "29816047"
+"ListingId": "40834034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:30:09Z"
+"RFModificationTimestamp": "2026-06-27T20:36:17Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2532.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 28, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4954313
1 => 43.5244453
]
+"Latitude": 43.5244453
+"Longitude": -80.4954313
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover the perfect balance of sophisticated urban living and natural tranquility at Carriage Crossing, one of Waterloo’s most coveted condominium townhome communities. Tucked away on the scenic edge of the city, you’re just moments from the fairways of Grey Silo Golf Course, the recreation hubs at RIM Park, and the vibrant local culture of Conestoga Mall and the St. Jacobs Market. Spanning 2532 square feet of impeccably crafted, multi-level living space, this residence is designed to impress from the moment you step inside: The Arrival: A grand, airy foyer welcomes you, offering a striking visual preview of the open-concept main floor above. The Heart of the Home: Ascend to the main level, where sightlines sweep across an expansive living room and into a chef-inspired dream kitchen. The elegant separate dining area opens directly via sliders to a covered porch. The Guest & Work Level: One flight up, a dedicated wing features two generously sized bedrooms sharing a luxurious five-piece bath. Overlooking the heart of the home is a versatile open loft, perfect for an inspiring home office or a relaxed lounge space. The Primary Sanctuary: The entire top level is dedicated to comfort and flexibility. The sun-drenched primary suite boasts massive picture windows and a spa-like ensuite, complete with a freestanding soaking tub, a seamless walk-in shower, and an expansive walk-in closet. With three substantial bedrooms, two flexible loft areas, 2.5 beautifully appointed baths, and parking for four vehicles, this isn't just a place to live—it's a place to thrive. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water softener"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "594.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T04:05:02.975566+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T03:30:49Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:22:44Z"
+"Stories": "2.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7864"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1669674134"
"RoomType" => "Primary Bedroom"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
1 => array:11 [
"RoomKey" => "1669674135"
"RoomType" => "Full bathroom"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
2 => array:11 [
"RoomKey" => "1669674136"
"RoomType" => "Bedroom"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
3 => array:11 [
"RoomKey" => "1669674137"
"RoomType" => "Bedroom"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
4 => array:11 [
"RoomKey" => "1669674138"
"RoomType" => "4pc Bathroom"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
5 => array:11 [
"RoomKey" => "1669674139"
"RoomType" => "Den"
"ListingId" => "40834034"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
6 => array:11 [
"RoomKey" => "1669674140"
"RoomType" => "Dining room"
"ListingId" => "40834034"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
7 => array:11 [
"RoomKey" => "1669674141"
"RoomType" => "Kitchen"
"ListingId" => "40834034"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 20'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
8 => array:11 [
"RoomKey" => "1669674142"
"RoomType" => "Living room"
"ListingId" => "40834034"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.84Z"
]
9 => array:11 [
"RoomKey" => "1669674143"
"RoomType" => "Laundry room"
"ListingId" => "40834034"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.85Z"
]
10 => array:11 [
"RoomKey" => "1669674144"
"RoomType" => "2pc Bathroom"
"ListingId" => "40834034"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816047"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T20:22:44.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29816047/271-grey-silo-road-unit-28-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2532
+"OriginalEntryTimestamp": "2026-05-28T03:30:49Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1205413"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29816047_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/dc621ba8cdb09f58c253ca18616a4839.webp"
"MediaSize" => 113780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-dc621ba8cdb09f58c253ca18616a4839.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade residence featuring two garage bays with panel doors, upper-level windows with transom details, a paved driveway, and mature landscaping"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29816047_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/b226e086e2c02c8c6422d4430e19ecd8.webp"
"MediaSize" => 108401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-b226e086e2c02c8c6422d4430e19ecd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary exterior featuring a stone facade and beige garage doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29816047_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/0ae8bdb176da9b2b9e91e6a2f51c6b71.webp"
"MediaSize" => 42166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-0ae8bdb176da9b2b9e91e6a2f51c6b71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with two frosted sidelights, light-toned tile flooring, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29816047_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/a9c55048c37b290a0c1c50f56d708c8b.webp"
"MediaSize" => 43302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-a9c55048c37b290a0c1c50f56d708c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring light-toned tile flooring, white baseboards, and a carpeted staircase with dark wood-finish handrails"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29816047_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/7c26c6f1b977b2b2c82a01da6b6551ce.webp"
"MediaSize" => 63934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-7c26c6f1b977b2b2c82a01da6b6551ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled living area featuring vaulted ceilings, wood-finish flooring, a large window with white interior shutters, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29816047_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/442256f4852a60ca162f9894141c715d.webp"
"MediaSize" => 33903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-442256f4852a60ca162f9894141c715d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story living room featuring a double-height ceiling, modern brass-finish chandeliers, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29816047_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/eb5d9c12be91933c2229f86c509e70e3.webp"
"MediaSize" => 72324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-eb5d9c12be91933c2229f86c509e70e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring a kitchen with dark wood cabinetry and a central island, stainless steel appliances, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29816047_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/3f45e928d37a44434363b16364f49041.webp"
"MediaSize" => 66563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-3f45e928d37a44434363b16364f49041.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring an expansive island with an integrated sink, stone countertops, dark wood cabinetry, stainless steel appliances, and wood-look flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29816047_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/93468ad3fc3a1e37d45a75dace856223.webp"
"MediaSize" => 76943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-93468ad3fc3a1e37d45a75dace856223.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, a central island with a light-toned countertop and integrated sink, stainless steel appliances, and contemporary pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29816047_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/4153af95f6e8b2838ab4debcfddd6f9f.webp"
"MediaSize" => 84404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-4153af95f6e8b2838ab4debcfddd6f9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring an extended island with integrated sink, stone countertops, dark wood-finish cabinetry, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29816047_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/10822206de2dec0bdec6ed028ed65c23.webp"
"MediaSize" => 72398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-10822206de2dec0bdec6ed028ed65c23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark wood cabinetry, stainless steel appliances, and a central island with an undermount sink and light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29816047_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/654aaa2c89efede4e747e8b0eb8964fe.webp"
"MediaSize" => 77226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-654aaa2c89efede4e747e8b0eb8964fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring light-toned flooring, a tray ceiling, and a prominent window with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29816047_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/a9ea0b87fcfb5f36593e1a2fe19af930.webp"
"MediaSize" => 61928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-a9ea0b87fcfb5f36593e1a2fe19af930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with an undermount sink and gooseneck faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29816047_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/6a86fdda0b12e91311e98ebcc506439d.webp"
"MediaSize" => 72196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-6a86fdda0b12e91311e98ebcc506439d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a tray ceiling, recessed lighting, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29816047_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/1b7940ff6df7ca921cf4b62ca3e418b2.webp"
"MediaSize" => 46792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-1b7940ff6df7ca921cf4b62ca3e418b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with an undermount sink and gooseneck faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29816047_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/c711a10e938a5dbc296f8806feeb562f.webp"
"MediaSize" => 78224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-c711a10e938a5dbc296f8806feeb562f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29816047_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/0710a76b7e02a3ca79f3a09944964419.webp"
"MediaSize" => 59760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-0710a76b7e02a3ca79f3a09944964419.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a large window with sheer and blackout drapes, white baseboards, and a ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29816047_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/6fad604468683360874275345415b028.webp"
"MediaSize" => 55333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-6fad604468683360874275345415b028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bedroom featuring light neutral wall paint, light-colored carpet flooring, white baseboards, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29816047_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/5fdf863c8e3df52bdc1bda4ca9e3ad28.webp"
"MediaSize" => 74918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-5fdf863c8e3df52bdc1bda4ca9e3ad28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bathroom featuring a freestanding soaking tub, a large walk-in glass shower, and an extended dual-sink vanity with a light-colored stone countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29816047_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/295ca00b959e92664b0f45dcb8ef261a.webp"
"MediaSize" => 71792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-295ca00b959e92664b0f45dcb8ef261a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bathroom featuring a freestanding soaking tub, a large glass-enclosed shower with a built-in bench and dark stone-look tile, a wide window, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29816047_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/33dc31c4c393ab104b8bdc8debc677c3.webp"
"MediaSize" => 66240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-33dc31c4c393ab104b8bdc8debc677c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in closet featuring built-in white cabinetry, integrated shelving, multiple hanging rods, drawer storage, and a skylight"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29816047_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/daf2b96d8cf2406552a1a9c998cfaeda.webp"
"MediaSize" => 56292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-daf2b96d8cf2406552a1a9c998cfaeda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned room with plush grey carpeting and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29816047_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/1932abf7217fae32de0614d2eba4d748.webp"
"MediaSize" => 60968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-1932abf7217fae32de0614d2eba4d748.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled room featuring neutral wall paint, white trim, and plush carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29816047_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/37c815a6fab5d0ce8a47075dbda1784e.webp"
"MediaSize" => 77885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-37c815a6fab5d0ce8a47075dbda1784e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light-toned carpeting, a window with sheer and blackout drapery, and neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29816047_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/0a6d668e6774a01c32d4414d43d41cf6.webp"
"MediaSize" => 56399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-0a6d668e6774a01c32d4414d43d41cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring an expansive vanity with a speckled countertop, integrated sink, and brushed nickel faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29816047_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/b79f8faaee37ffade0b1f06d92ae79ca.webp"
"MediaSize" => 31905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-b79f8faaee37ffade0b1f06d92ae79ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room with a white pedestal sink, coordinating toilet, rectangular wall mirror, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29816047_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/5c0b431639d02ab2899d6b6558dd39f8.webp"
"MediaSize" => 47709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-5c0b431639d02ab2899d6b6558dd39f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring light-toned walls, wood-finish flooring, white baseboards, and a durable countertop over cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29816047_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/0334a0633df252bdf51ad2d5803c83e7.webp"
"MediaSize" => 120575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-0334a0633df252bdf51ad2d5803c83e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck featuring composite decking and black metal railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29816047_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/80c2a434f3393bac33a9c266b4915693.webp"
"MediaSize" => 119858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-80c2a434f3393bac33a9c266b4915693.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered outdoor deck featuring composite decking, black metal railings, and a brick exterior wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29816047_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/ceafd4af66dd5cb8362e67ae2b618afe.webp"
"MediaSize" => 124728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-ceafd4af66dd5cb8362e67ae2b618afe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive fenced backyard featuring a manicured lawn and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29816047_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816047/3127f27eac1e4f6bedfe237bbb3551a4.webp"
"MediaSize" => 121882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816047/thumbnail-3127f27eac1e4f6bedfe237bbb3551a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone and stucco exterior featuring multiple large windows and an upper-level balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834034"
"ResourceRecordKey" => "29816047"
"ModificationTimestamp" => "2026-05-28T03:30:49.01Z"
]
]
+"DaysOnMarket": 33
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816047')"
+"ID": "1467814"
}
]
+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 290620" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24884
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29816047'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29816047'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31292154"
+"ListingKey": "29816047"
+"ListingId": "40834034"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T18:55:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31292154')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31685093"
+"ListingKey": "29816047"
+"ListingId": "40834034"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:27:23Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31685093')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29816047' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4954313 43.5244453)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25303
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+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 [
"RoomKey" => "1671689606"
"RoomType" => "Utility room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.14Z"
]
1 => array:11 [
"RoomKey" => "1671689607"
"RoomType" => "Cold room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
2 => array:11 [
"RoomKey" => "1671689608"
"RoomType" => "Laundry room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
3 => array:11 [
"RoomKey" => "1671689609"
"RoomType" => "Recreation room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 23'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
4 => array:11 [
"RoomKey" => "1671689610"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
5 => array:11 [
"RoomKey" => "1671689611"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
6 => array:11 [
"RoomKey" => "1671689612"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
7 => array:11 [
"RoomKey" => "1671689613"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
8 => array:11 [
"RoomKey" => "1671689614"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
9 => array:11 [
"RoomKey" => "1671689615"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
10 => array:11 [
"RoomKey" => "1671689616"
"RoomType" => "Kitchen"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
11 => array:11 [
"RoomKey" => "1671689617"
"RoomType" => "Dining room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
12 => array:11 [
"RoomKey" => "1671689618"
"RoomType" => "Great room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29964583_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/2d983f4577119a075d858eaaeb7afa3a.webp"
"MediaSize" => 117065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-2d983f4577119a075d858eaaeb7afa3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding and a brown shingle roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964583_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/8158296ffdd392857a8e057793bd6eb4.webp"
"MediaSize" => 126454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-8158296ffdd392857a8e057793bd6eb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story home featuring light-colored siding, a prominent front garage with a panel design, and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964583_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"MediaSize" => 119519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story detached residence featuring light-colored siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964583_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c334977cdef17d9d6ccff4d93b3061e2.webp"
"MediaSize" => 74541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c334977cdef17d9d6ccff4d93b3061e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding, a prominent front gable, and an arched window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964583_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/19ea2b14561a92face62f1a6f7fce7ce.webp"
"MediaSize" => 59009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-19ea2b14561a92face62f1a6f7fce7ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary two-story residence with a light-colored facade, featuring an attached two-car garage with a brown door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964583_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/d2539857c00ff1c9f20a30b402db8066.webp"
"MediaSize" => 56936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-d2539857c00ff1c9f20a30b402db8066.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964583_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/e315bd514d854b14d5ad135288368a53.webp"
"MediaSize" => 37762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-e315bd514d854b14d5ad135288368a53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry with a dark-paneled door and storm door, accented by dual sconce lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
7 => array:13 [
"Order" => 8
…12
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1549420"
+post_author: 1
+"ListingKey": "29930600"
+"ListingId": "X13468586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T22:00:14Z"
+"RFModificationTimestamp": "2026-06-29T22:03:04Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B4"
+"UnparsedAddress": "325 DEERFOOT TRAIL, Waterloo, Ontario N2K0B4"
+"Coordinates": array:2 [
0 => -80.492293
1 => 43.520642
]
+"Latitude": 43.520642
+"Longitude": -80.492293
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo's most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. *Some images have been virtually staged. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"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-19T21:11:46.156494+00:00"
+"Directions": "Cross Streets: OAK PARK DRIVE. ** Directions: MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "59.1 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T21:12:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T21:53:08Z"
+"Stories": "2.0"
+"StreetName": "Deerfoot"
+"StreetNumber": "325"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "12084.9"
+"VirtualTourURLUnbranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29930600/325-deerfoot-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 59.1
+"OriginalEntryTimestamp": "2026-06-19T19:55:19.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"ListOfficeNationalAssociationId": "1385020"
+"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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930600')"
+"ID": "1549420"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1548926"
+post_author: 1
+"ListingKey": "29930068"
+"ListingId": "40841146"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T21:20:03Z"
+"RFModificationTimestamp": "2026-06-29T21:24:52Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 5333.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B4"
+"UnparsedAddress": "325 DEERFOOT Trail, Waterloo, Ontario N2K0B4"
+"Coordinates": array:2 [
0 => -80.4922223
1 => 43.5206371
]
+"Latitude": 43.5206371
+"Longitude": -80.4922223
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo’s most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. *Some images have been virtually staged. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Other, See Remarks"
]
+"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-19T20:31:37.100088+00:00"
+"Directions": "MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:3 [
0 => "Electric"
1 => "Other - See remarks"
2 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T21:01:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T21:11:05Z"
+"Stories": "2.0"
+"StreetName": "DEERFOOT"
+"StreetNumber": "325"
+"StreetSuffix": "Trail"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "12084.9"
+"VirtualTourURLUnbranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930068/325-deerfoot-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 3685
+"BelowGradeFinishedArea": 1648
+"OriginalEntryTimestamp": "2026-06-19T18:50:50.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930068')"
+"ID": "1548926"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1521017"
+post_author: 1
+"ListingKey": "29889988"
+"ListingId": "40836212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:40:07Z"
+"RFModificationTimestamp": "2026-06-11T20:19:37Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "123 OAK PARK Drive, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4977201
1 => 43.5205041
]
+"Latitude": 43.5205041
+"Longitude": -80.4977201
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This exceptional former model freehold townhome with no rear neighbours offers a luxurious living experience, showcasing high-end finishes throughout and an incredible backyard oasis. A spacious front entry welcomes you into the home and flows seamlessly into the dining area and beautifully appointed kitchen, creating the perfect space for both everyday living and entertaining. The inviting great room features a charming gas fireplace and overlooks the private backyard retreat, which can be enjoyed from the comfort of the three-season sunroom. The primary suite serves as a private retreat, complete with a spa-inspired ensuite and walk-in closet. Premium finishes throughout include California shutters, granite countertops, porcelain tile, and numerous quality upgrades. Two additional bedrooms share a second full size bathroom. The professionally finished basement extends the living space with a versatile recreation room, full bathroom and wet bar entertainment area (roughed-in for full kitchen). With excellent potential to add a kitchenette or second kitchen, the basement offers added flexibility for multigenerational living, extended family, or enhanced entertaining. Outside, discover a truly picturesque backyard oasis featuring a beautiful stone patio, gazebo, irrigation system, and meticulously maintained gardens bursting with colourful flowers. An ideal setting for relaxing or hosting family and friends. A rare opportunity to own a beautifully upgraded home, incredibly maintained, in one of the area's most desirable neighbourhoods. With convenient rear access to Rim Park, the Walter Bean Grand River Trail, Grey Silo Golf Course, the East Waterloo Branch Library, and shopping at Conestoga Mall, this exceptional location offers the perfect blend of recreation and everyday convenience. Don't miss your chance! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:26.578928+00:00"
+"Directions": "Millenium Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091826"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:31:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:31:42Z"
+"Stories": "2.0"
+"StreetName": "OAK PARK"
+"StreetNumber": "123"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6087.1"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/e9c41qpBM50"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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/29889988/123-oak-park-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 2141
+"BelowGradeFinishedArea": 725
+"OriginalEntryTimestamp": "2026-06-11T17:31:42.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889988')"
+"ID": "1521017"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1515453"
+post_author: 1
+"ListingKey": "29883236"
+"ListingId": "X13426634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T01:05:15Z"
+"RFModificationTimestamp": "2026-06-23T01:10:29Z"
+"ListPrice": 2050000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N2J4G8"
+"UnparsedAddress": "1883 SAWMILL ROAD, Woolwich, Ontario N2J4G8"
+"Coordinates": array:2 [
0 => -80.503835
1 => 43.540953
]
+"Latitude": 43.540953
+"Longitude": -80.503835
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "A landmark property. A beautifully reimagined home. An extraordinary space to gather, create, and thrive. Located in the heart of Conestogo, 1883 Sawmill Road has served the community for generations, evolving from the historic Landmark Inn to the beloved Adam's Steak House and, most recently, a thriving wellness and professional studio destination. Today, it offers a unique combination of heritage character, modern living, and exceptional flexibility. The residence features four bedrooms, two-and-a-half bathrooms, a chef-inspired kitchen, and thoughtfully-updated living spaces that blend original architectural details with contemporary comfort. Large windows, exposed brick, and views of the surrounding trees and river valley create a warm and inviting atmosphere throughout. Even more impressive is the dedicated studio space. With soaring vaulted ceilings, exposed heritage trusses, and a dramatic wall of windows overlooking the valley, it provides an inspiring setting for wellness, fitness, creative, educational, professional, or event-based uses. Separate entrances and established mixed-use functionality create opportunities for entrepreneurs, practitioners, and those seeking a truly integrated live-work lifestyle. Outside, over 1,700 square feet of outdoor living space includes multiple decks, a Scandinavian sauna, hot tub, cold plunge, and fire pit, all surrounded by mature trees and exceptional privacy. The property's strategic location offers a rare combination of village charm, natural beauty, and convenient access to Kitchener-Waterloo, St. Jacobs, Elora, and the many amenities of the surrounding region. With grandfathered commercial use, dual street frontage, and potential for a future accessory dwelling, garage, or carriage house, this property offers a rare opportunity to own a piece of local history while creating something uniquely your own. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T18:25:59.271334+00:00"
+"Directions": "Cross Streets: Northfield Drive East and Sawmill Road. ** Directions: From Waterloo, take Northfield Drive East toward Conestogo. At the lights, turn right onto Sawmill Road. Property is on the right."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:3 [
0 => "Stone"
1 => "Block"
2 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237748"
+"ListOfficeKey": "292802"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Lane"
1 => "Guest Suite"
2 => "Sauna"
]
+"LotSizeDimensions": "64 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T17:26:01Z"
+"PhotosCount": 43
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T00:56:56Z"
+"Stories": "2.5"
+"StreetName": "Sawmill"
+"StreetNumber": "1883"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15334.26"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ydtlf_1883_sawmill_rd_conestogo_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29883236/1883-sawmill-road-woolwich"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 64.0
+"OriginalEntryTimestamp": "2026-06-10T17:26:01.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475659"
+"ListOfficeNationalAssociationId": "1417590"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29883236')"
+"ID": "1515453"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1512893"
+post_author: 1
+"ListingKey": "29878309"
+"ListingId": "40838342"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:10:20Z"
+"RFModificationTimestamp": "2026-06-09T22:42:10Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2475.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 29, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.495489
1 => 43.5243855
]
+"Latitude": 43.5243855
+"Longitude": -80.495489
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is more than a townhouse - it's a thoughtfully crafted luxury residence offering nearly 2,500 SF of elegant living. Ideally situated on a peaceful, family-friendly street in the coveted Carriage Crossing. Step inside to a bright, open-concept main floor where soaring 9-foot ceilings and engineered hardwood flooring create a sense of space and sophistication. The heart of the home is the chef's kitchen, featuring Cambria quartz countertops, SS appliances including a gas stove with a double oven, wine fridge, cabinetry extending to the ceiling, under cabinet lighting & a spacious pantry. A convenient 2-piece bath and a main floor laundry/mud room completes the main level. The private primary retreat occupies its own dedicated floor, with grand-sized windows, an oversized walk-in-closet and a stunning ensuite showcasing a glass shower & Cambria quartz countertops. Upstairs, the top level provides incredible flexibility with a spacious open office, along with two generous, sun-filled bedrooms. The main bathroom is thoughtfully designed with a separate water closet and a shower/tub combination - ideal for family living. The finished look-out basement extends your living space even further, featuring 9 ft ceilings, engineered hardwood flooring, a beautifully appointed 3-piece bathroom with a glass shower, Italian marble tile, and herringbone floors. The rec room is perfect for a games room, playroom, or even a fourth bedroom. Outdoors, unwind on your back deck and enjoy the sounds of birdsong, visits from hummingbirds, and scenic walks along nearby trails where deer sightings and gorgeous sunsets are part of everyday life. Perfectly positioned minutes from top-rated schools, Grey Silo Golf Club, RIM Park, Universities, tech campuses, St. Jacobs, and major highways. Exterior maintenance, from summer landscaping to winter snow removal, is professionally managed. Most furnishings negotiable. This home truly offers the best of both worlds. Your perfect home awaits! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"AssociationFee": "594.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:42:06.895935+00:00"
+"Directions": "University to Millennium to Grey Silo"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2030628"
+"ListOfficeKey": "276982"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T20:01:00Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:00:59Z"
+"Stories": "2.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7059"
+"VirtualTourURLUnbranded": "https://singlepropertywebsite.mohrrealestatemedia.com/271_grey_silo_rd-7910"
+"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/29878309/271-grey-silo-road-unit-29-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2085
+"BelowGradeFinishedArea": 390
+"OriginalEntryTimestamp": "2026-06-09T20:00:59.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1308211"
+"ListOfficeNationalAssociationId": "1279868"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878309')"
+"ID": "1512893"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1499289"
+post_author: 1
+"ListingKey": "29860637"
+"ListingId": "X13248204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:30:15Z"
+"RFModificationTimestamp": "2026-06-29T12:42:50Z"
+"ListPrice": 565000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G7"
+"UnparsedAddress": "102 - 247 GREY SILO ROAD, Waterloo, Ontario N2K0G7"
+"Coordinates": array:2 [
0 => -80.497131
1 => 43.522269
]
+"Latitude": 43.522269
+"Longitude": -80.497131
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 102 at 247 Grey Silo Road - one of Waterloo's most sought-after addresses. This beautifully appointed 2-bed, 2-bath ground-floor condo features luxury vinyl plank flooring, oversized windows, and brushed nickel hardware throughout. The open concept kitchen is a true highlight, featuring a large island, quartz countertops, KitchenAid stainless steel appliances, and an upgraded range hood - perfect for both cooking and entertaining. Just off the kitchen, step onto an enormous balcony with three distinct seating areas where BBQs are permitted - an entertainer's delight for gatherings or quiet evenings outdoors. The generously sized primary suite comfortably fits a king-size bed with room to spare, includes a double closet, and features a private ensuite with walk-in shower - perfect for downsizers. Modern bathrooms feature quartz vanities and comfort-height toilets, while additional upgrades include in-suite washer and dryer, a high efficiency water heater, water softener, and an HRV system for fresh air circulation year-round. Ground-floor entry keeps daily life effortless, and the rooftop terrace offers even more outdoor space to enjoy. Two owned parking spots included.Steps from Grey Silo Golf Course, the Walter Bean Trail, St. Jacobs Farmers' Market, RIM Park, and local restaurants - with easy access to Uptown Waterloo, both universities, and the expressway. Low-maintenance luxury living in one of Waterloo's most prestigious pockets (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "625.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-05T17:29:16.857062+00:00"
+"Directions": "Cross Streets: University & Millennium. ** Directions: University to Millennium Blvd."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235403"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-06T13:12:35Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:25:09Z"
+"StreetName": "Grey Silo"
+"StreetNumber": "247"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4233.13"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29860637/102-247-grey-silo-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "MR4-MD3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-05T16:33:05.88Z"
+"ListAgentNationalAssociationId": "1473266"
+"ListOfficeNationalAssociationId": "1435796"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860637')"
+"ID": "1499289"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1498881"
+post_author: 1
+"ListingKey": "29860224"
+"ListingId": "40835057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:20:06Z"
+"RFModificationTimestamp": "2026-06-28T19:26:16Z"
+"ListPrice": 565000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G7"
+"UnparsedAddress": "247 GREY SILO Road Unit# 102, Waterloo, Ontario N2K0G7"
+"Coordinates": array:2 [
0 => -80.4970393
1 => 43.5221163
]
+"Latitude": 43.5221163
+"Longitude": -80.4970393
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 102 at 247 Grey Silo Road — one of Waterloo's most sought-after addresses. This beautifully appointed 2-bed, 2-bath ground-floor condo features luxury vinyl plank flooring, oversized windows, and brushed nickel hardware throughout. The open concept kitchen is a true highlight, featuring a large island, quartz countertops, KitchenAid stainless steel appliances, and an upgraded range hood — perfect for both cooking and entertaining. Just off the kitchen, step onto an enormous balcony with three distinct seating areas where BBQs are permitted — an entertainer's delight for gatherings or quiet evenings outdoors. The generously sized primary suite comfortably fits a king-size bed with room to spare, includes a double closet, and features a private ensuite with walk-in shower — perfect for downsizers. Modern bathrooms feature quartz vanities and comfort-height toilets, while additional upgrades include in-suite washer and dryer, a high efficiency water heater, water softener, and an HRV system for fresh air circulation year-round. Ground-floor entry keeps daily life effortless, and the rooftop terrace offers even more outdoor space to enjoy. Two owned parking spots included.Steps from Grey Silo Golf Course, the Walter Bean Trail, St. Jacobs Farmers' Market, RIM Park, and local restaurants — with easy access to Uptown Waterloo, both universities, and the expressway. Low-maintenance luxury living in one of Waterloo's most prestigious pockets (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "625"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T16:45:09.784991+00:00"
+"Directions": "University to Millenium to Crossgate Blvd to Grey Silo"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159234"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-06T13:02:09Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T19:12:21Z"
+"Stories": "1.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "247"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4247"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019e9811-fbef-734e-b539-fe9abba772b9"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29860224/247-grey-silo-road-unit-102-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MR-4/MD3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-06-05T15:51:47.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1410495"
+"ListOfficeNationalAssociationId": "1435346"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860224')"
+"ID": "1498881"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1494487"
+post_author: 1
+"ListingKey": "29852179"
+"ListingId": "40834591"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T13:40:09Z"
+"RFModificationTimestamp": "2026-06-23T13:45:58Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2789.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B9"
+"UnparsedAddress": "243 GREY SILO Road Unit# 11, Waterloo, Ontario N2K0B9"
+"Coordinates": array:2 [
0 => -80.495655
1 => 43.521308
]
+"Latitude": 43.521308
+"Longitude": -80.495655
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 11 - 243 Grey Silo Road, located in a luxury executive townhouse community! **This home has 3 Large bright bedrooms and 3 bathrooms in an open-concept layout, with an unfinished basement ready for your ideas. **Entry leads to a spacious foyer, main floor laundry, and convenient access to the powder room. **Kitchen features upgraded appliances, an island with a breakfast bar and pantry. **The living area's focal point is an upgraded mantle with a Tru-View Bespoke Electric Fireplace and features a double glass door that leads to the composite deck and gas barbecue. **Solid staircase with a runner leads to an upper-level reading nook or open den. **Primary bedroom features a luxury ensuite with a glass shower, double sink and separate toilet room, plus a massive 7'5 x 7'1 walk in closet. **Other features include maple hardwood flooring, updated lighting fixtures, numerous extra windows allowing for natural light, wrought iron railings, fresh paint, a mudroom, and all appliances. **This property has barely been lived in and feels like new! Located just minutes from RIM Park, Grey Silo Golf Course, Waterloo Public Library - Eastside Branch, and the Grand River Trail. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFee": "594.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T17:37:46.206137+00:00"
+"Directions": "Millennium Blvd. to Oak Park Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563803"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T14:00:50Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T13:34:09Z"
+"Stories": "2.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "243"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7083"
+"VirtualTourURLUnbranded": "https://youriguide.com/11_243_grey_silo_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29852179/243-grey-silo-road-unit-11-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 659
+"OriginalEntryTimestamp": "2026-06-04T14:00:50.29Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1108799"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29852179')"
+"ID": "1494487"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 18
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]