array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29177727/Property?$select=ALL&$top=20&$filter=ListingKey eq 29177727&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29177727/Property?$select=ALL&$top=20&$filter=ListingKey eq 29177727&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23508
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23510
+post_id: "473825"
+post_author: 1
+"ListingKey": "29177727"
+"ListingId": "40793297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T19:45:33Z"
+"RFModificationTimestamp": "2025-12-10T19:52:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 51, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4951779
1 => 43.5235489
]
+"Latitude": 43.5235489
+"Longitude": -80.4951779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this luxury Trailside Townhome located in the highly sought-after Carriage Crossing community in Waterloo! Enjoy a maintenance-free lifestyle with lawn care, landscaping, and snow removal included. This modern and elegant 4-bedroom, 4-bathroom home offers a double car garage and exceptional finishes throughout. The main floor provides a versatile office/bedroom complete with a stunning 3-piece ensuite featuring a quartz vanity and sleek tiled shower. The second level showcases an open-concept layout with a gourmet kitchen boasting an island, quartz countertops, stainless steel appliances, and a spacious walk-in pantry/storage. The adjoining great room and dining area feature warm hardwood flooring, along with a convenient 2-piece powder room and access to a balcony. On the third level, the primary bedroom offers a walk-in closet and a beautifully designed ensuite with tiled shower and quartz vanity. Two additional bedrooms share a stylish 4-piece bathroom. The upper-level laundry adds convenience, plus a second balcony for outdoor enjoyment. Situated just steps from the Walter Bean Trail, Grand River, RIM Park, Grey Silo Golf Course, and close to Conestoga Mall, Conestoga College, and University of Waterloo—this home provides an unbeatable lifestyle with easy access to premium amenities and top-rated schools. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:52:20.050381+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-10T19:31:02Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T19:38:19Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6247"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1547262208"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.67Z"
]
1 => array:11 [
"RoomKey" => "1547262209"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.67Z"
]
2 => array:11 [
"RoomKey" => "1547262210"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.67Z"
]
3 => array:11 [
"RoomKey" => "1547262211"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.67Z"
]
4 => array:11 [
"RoomKey" => "1547262212"
"RoomType" => "Kitchen"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.67Z"
]
5 => array:11 [
"RoomKey" => "1547262213"
"RoomType" => "Dining room"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
6 => array:11 [
"RoomKey" => "1547262214"
"RoomType" => "Great room"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
7 => array:11 [
"RoomKey" => "1547262215"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
8 => array:11 [
"RoomKey" => "1547262216"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
9 => array:11 [
"RoomKey" => "1547262217"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
10 => array:11 [
"RoomKey" => "1547262218"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
11 => array:11 [
"RoomKey" => "1547262219"
"RoomType" => "Foyer"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-10T19:38:19.68Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29177727/271-grey-silo-road-unit-51-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2025-12-10T19:08:37.09Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6363556537"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/8e2dbb72f07135921fe4cc0519d1fe00.webp"
"MediaSize" => 89118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-8e2dbb72f07135921fe4cc0519d1fe00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6363556542"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/e08933b212cbee268c47c86b498ec65e.webp"
"MediaSize" => 49647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-e08933b212cbee268c47c86b498ec65e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6363556564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/394617d99b8ceb295770ebf2ad08a20d.webp"
"MediaSize" => 77362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-394617d99b8ceb295770ebf2ad08a20d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.61Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6363556579"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/284c05f736691f590761df07460b0e9f.webp"
"MediaSize" => 96486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-284c05f736691f590761df07460b0e9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6363556604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/344768f7910af204eb68dad7e4ebd97c.webp"
"MediaSize" => 79193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-344768f7910af204eb68dad7e4ebd97c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6363556634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/5e0a8f654e05db5d38149db42e09fc84.webp"
"MediaSize" => 140594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-5e0a8f654e05db5d38149db42e09fc84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom with ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6363556656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/91cef1d5ca4f5690c4acf0c588d5b819.webp"
"MediaSize" => 67200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-91cef1d5ca4f5690c4acf0c588d5b819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6363556678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/48b659e75578bdefe0278680354d74d0.webp"
"MediaSize" => 68882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-48b659e75578bdefe0278680354d74d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.61Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6363556706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/63b674ef8c04743b4920f758158de1c9.webp"
"MediaSize" => 55162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-63b674ef8c04743b4920f758158de1c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6363556717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/1be31454316e4c6ed39d64e6d467aa3f.webp"
"MediaSize" => 59433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-1be31454316e4c6ed39d64e6d467aa3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6363556727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/ca486c9266092f34c6b0ebba7ea42661.webp"
"MediaSize" => 69039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-ca486c9266092f34c6b0ebba7ea42661.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.24Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6363556747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/44ac32a9d9d36a63d172405222cab610.webp"
"MediaSize" => 37956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-44ac32a9d9d36a63d172405222cab610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6363556767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/429ccf8849c8fbd41b52e45ff9ab02a5.webp"
"MediaSize" => 25230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-429ccf8849c8fbd41b52e45ff9ab02a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6363556828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/fafc96d5736b16be76ba01f53fe9daaf.webp"
"MediaSize" => 101306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-fafc96d5736b16be76ba01f53fe9daaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6363556843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/0af85ec642bdf9066543889d7b0d68d9.webp"
"MediaSize" => 37377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-0af85ec642bdf9066543889d7b0d68d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6363556861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/fa35ccf8e18c1b1aa8564583eec97b54.webp"
"MediaSize" => 62330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-fa35ccf8e18c1b1aa8564583eec97b54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.65Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6363556908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/10556d0cdbb859d8b11ad478a6fc94be.webp"
"MediaSize" => 58919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-10556d0cdbb859d8b11ad478a6fc94be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6363556928"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/d91b1883c3fb619c31354102cb6df96c.webp"
"MediaSize" => 73306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-d91b1883c3fb619c31354102cb6df96c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6363556944"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/b52d2893e658652cf10ad7a14823976d.webp"
"MediaSize" => 95645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-b52d2893e658652cf10ad7a14823976d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6363556956"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/180972759f75310f96913c39a1edcd0d.webp"
"MediaSize" => 81393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-180972759f75310f96913c39a1edcd0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6363556974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/ceedc8559a3d0b6b0d867dcf414a4ee6.webp"
"MediaSize" => 45489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-ceedc8559a3d0b6b0d867dcf414a4ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Gagan Battoo"
"MemberFirstName" => "Gagan"
"MemberLastName" => "Battoo"
"MemberMlsId" => "WR59840"
"OriginatingSystemName" => 26
"MemberKey" => "2218013"
"ModificationTimestamp" => "2025-12-11T01:31:05Z"
"MemberStatus" => "Active"
"OfficeKey" => "289539"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "416-747-7135"
"MemberCity" => "CAMBRIDGE"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "204-951-4390"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-06-06T21:29:00Z"
"MemberNationalAssociationId" => "1463723"
"OfficeNationalAssociationId" => "1378643"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "HOMELIFE MIRACLE REALTY LTD."
"OfficePhone" => "416-747-9777"
"OfficeMlsId" => "CA721"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289539"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "450 HESPELER ROAD, UNIT G/107-108"
"OfficeCity" => "CAMBRIDGE"
"OfficePostalCode" => "N1R0E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "416-747-7135"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2021-02-10T19:07:00Z"
"OfficeNationalAssociationId" => "1378643"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1378645"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177727')"
+"ID": "473825"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289539/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289539&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289539/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289539&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE MIRACLE REALTY LTD."
+"OfficeEmail": null
+"OfficePhone": "416-747-9777"
+"OfficeMlsId": "CA721"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289539"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "450 HESPELER ROAD, UNIT G/107-108"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N1R0E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1378643"
+"OriginalEntryTimestamp": "2021-02-10T19:07:00Z"
+"OfficeFax": "416-747-7135"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1378645"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289539')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2218013/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2218013&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2218013/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2218013&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29177727" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24959
+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 29177727/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29177727&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29177727/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29177727&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24939
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29177727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4951779 43.5235489)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29177727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4951779 43.5235489)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29177727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4951779 43.5235489)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29177727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4951779 43.5235489)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: "466761"
+post_author: 1
+"ListingKey": "29166639"
+"ListingId": "40792630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T18:50:28Z"
+"RFModificationTimestamp": "2025-12-05T19:18:31Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1120.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G8"
+"UnparsedAddress": "249 GREY SILO Road Unit# 202, Waterloo, Ontario N2K0G8"
+"Coordinates": array:2 [
0 => -80.4967199
1 => 43.5226913
]
+"Latitude": 43.5226913
+"Longitude": -80.4967199
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this rare corner condo where sophisticated design meets everyday indulgence with over 1100 sqft of living space. From the moment you step inside, you’re welcomed by wide hallways, 8.5 ft ceilings, and sunlight streaming through expansive windows. At the heart of the home, the chef’s kitchen commands attention with its dramatic quartzite island, custom drawers, soft-close cabinetry, and full suite of KitchenAid appliances. Subtle details—USB outlets, under-cabinet lighting, and dimmer switches—make the space as functional as it is beautiful. The living/dining area flows effortlessly to a spectacular 320 sq ft wrap-around balcony. Imagine sipping morning coffee with the sunrise, hosting dinner outdoors, or filling the space with lush container gardens—this balcony is a private oasis large enough for both lounging and entertaining. Retreat to the serene primary suite with double closets customized for style and storage, and a spa-inspired ensuite featuring a walk-in tiled shower with bench seating and sleek quartz vanity. The versatile second bedroom doubles perfectly as a guest room or home office, while the 4-piece main bath with a soaker tub offers a touch of everyday luxury. Added conveniences include in-suite laundry, engineered hardwood floors, built-in closet systems, and a smart thermostat. Life here extends far beyond your walls. Head to the rooftop terrace where panoramic views stretch over farmland and skyline. With fire tables glowing, BBQs sizzling, community gardens thriving, and stylish lounge spaces, it feels like a private resort in the heart of Waterloo. Add two parking spaces (one underground with locker, one at-grade near the entrance), plenty of visitor parking, and meticulous landscaping, and the package is complete. All this in the coveted Grey Silo community—steps to Rim Park, Grey Silo Golf Course, and endless trails, with shopping, dining, and universities just minutes away. This is condo living at its finest. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "555.81"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:18:07.773871+00:00"
+"Directions": "Old Park Drive to Grey Silo Road"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565503"
+"ListOfficeKey": "283852"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-05T18:38:38Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:38:38Z"
+"Stories": "1.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "249"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4383.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/202_249_grey_silo_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1545372898"
"RoomType" => "Laundry room"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
1 => array:11 [
"RoomKey" => "1545372899"
"RoomType" => "Full bathroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
2 => array:11 [
"RoomKey" => "1545372900"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
3 => array:11 [
"RoomKey" => "1545372901"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
4 => array:11 [
"RoomKey" => "1545372902"
"RoomType" => "Bedroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
5 => array:11 [
"RoomKey" => "1545372903"
"RoomType" => "Living room"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
6 => array:11 [
"RoomKey" => "1545372904"
"RoomType" => "Kitchen"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166639/249-grey-silo-road-unit-202-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1565504"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2025-12-05T18:38:37.78Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:27 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6357294660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/2897a5e412ff6d116e8867413fdbb82f.webp"
"MediaSize" => 122302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-2897a5e412ff6d116e8867413fdbb82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6357294661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/130f940395c15b73285830153de2cc5a.webp"
"MediaSize" => 148009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-130f940395c15b73285830153de2cc5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6357294663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f2ad3023ff5383e0c77ea2952d45dfb3.webp"
"MediaSize" => 65260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f2ad3023ff5383e0c77ea2952d45dfb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6357294664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/68117b1d3ccdbfc74d06512f11f09128.webp"
"MediaSize" => 68533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-68117b1d3ccdbfc74d06512f11f09128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6357294667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/963f6d657e63585c899652345ec6ed73.webp"
"MediaSize" => 64253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-963f6d657e63585c899652345ec6ed73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6357294669"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/b4807bf186d7848978aef4a85625bed5.webp"
"MediaSize" => 65114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-b4807bf186d7848978aef4a85625bed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6357294673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/88c5fdb1cb3868df666a2b7e0081755a.webp"
"MediaSize" => 57480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-88c5fdb1cb3868df666a2b7e0081755a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6357294676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/1b44b1ef60fdab98aaefb35e8350933d.webp"
"MediaSize" => 64322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-1b44b1ef60fdab98aaefb35e8350933d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6357294679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/082ae0a4a757967f56dda09004aecedb.webp"
"MediaSize" => 67781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-082ae0a4a757967f56dda09004aecedb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6357294684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/a2c245385362fd9f522225a40c4f24d4.webp"
"MediaSize" => 65304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-a2c245385362fd9f522225a40c4f24d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6357294688"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/4655bcda766fdf7a720a3abafe98a21e.webp"
"MediaSize" => 57997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-4655bcda766fdf7a720a3abafe98a21e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6357294691"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f0c2c3d792fe0cc54f426ddd3d95ce4d.webp"
"MediaSize" => 70879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f0c2c3d792fe0cc54f426ddd3d95ce4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6357294695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f6994a845c00f2f97ec6085d88caffb0.webp"
"MediaSize" => 60438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f6994a845c00f2f97ec6085d88caffb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6357294700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f3f03e483747f49c1d4342c893b2026d.webp"
"MediaSize" => 68970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f3f03e483747f49c1d4342c893b2026d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6357294703"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/583af262368be1bbd8f71ab39482f2e0.webp"
"MediaSize" => 81865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-583af262368be1bbd8f71ab39482f2e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6357294706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/82629e67524b3999fbed496257e8e412.webp"
"MediaSize" => 85868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-82629e67524b3999fbed496257e8e412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6357294710"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/7d1186fc2ef57d3c3eeef7a351ae5b6a.webp"
"MediaSize" => 104997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-7d1186fc2ef57d3c3eeef7a351ae5b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6357294714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/21659e0642260746dd3d4a85c355e4d4.webp"
"MediaSize" => 104398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-21659e0642260746dd3d4a85c355e4d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6357294718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/fc8ead7fa6cd22d9183e575e5287a1f4.webp"
"MediaSize" => 67277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-fc8ead7fa6cd22d9183e575e5287a1f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6357294723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/91ea6d87c69e4e293e4e4b1ba62a1c66.webp"
"MediaSize" => 45845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-91ea6d87c69e4e293e4e4b1ba62a1c66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6357294727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f8691989309b948f49a74cb3ccdf7bd4.webp"
"MediaSize" => 50751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f8691989309b948f49a74cb3ccdf7bd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6357294731"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/fa3f9e9401abb4f24d880f08693ab706.webp"
"MediaSize" => 60326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-fa3f9e9401abb4f24d880f08693ab706.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6357294735"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/4d68b0ca56232eef113f4c033d6bf24f.webp"
"MediaSize" => 48909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-4d68b0ca56232eef113f4c033d6bf24f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6357294739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/e07ac8e2a8e26b2d7ac42b270a9e87ba.webp"
"MediaSize" => 57482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-e07ac8e2a8e26b2d7ac42b270a9e87ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6357294741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/330e571ec04b2a7f076b218fbdd6be9c.webp"
"MediaSize" => 46395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-330e571ec04b2a7f076b218fbdd6be9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6357294744"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/b23b79423d65a3373af758e879361b50.webp"
"MediaSize" => 42026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-b23b79423d65a3373af758e879361b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6357294747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/0943802154dcdead4afa5f8c1bce3503.webp"
"MediaSize" => 120727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-0943802154dcdead4afa5f8c1bce3503.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "KEVIN REITZEL"
"MemberFirstName" => "KEVIN"
"MemberLastName" => "REITZEL"
"MemberMlsId" => "KWkw5180"
"OriginatingSystemName" => 26
"MemberKey" => "1565503"
"ModificationTimestamp" => "2025-10-28T23:19:41Z"
"MemberStatus" => "Active"
"OfficeKey" => "283852"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberFax" => "519-579-0289"
"MemberCity" => "Waterloo"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-570-4447"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1093094"
"OfficeNationalAssociationId" => "1335957"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "Keller Williams Innovation Realty"
"OfficePhone" => "519-570-4447"
"OfficeMlsId" => "KW29"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283852"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "564 Weber St. N., Unit 10"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2L5C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "519-579-0289"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-08-17T13:41:00Z"
"OfficeNationalAssociationId" => "1335957"
"FranchiseNationalAssociationId" => "1230713"
"OfficeBrokerNationalAssociationId" => "1204241"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166639')"
+"ID": "466761"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "462847"
+post_author: 1
+"ListingKey": "29163523"
+"ListingId": "X12601812"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T20:05:03Z"
+"RFModificationTimestamp": "2025-12-04T20:24:54Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G6"
+"UnparsedAddress": "559 CHESAPEAKE DRIVE, Waterloo, Ontario N2K4G6"
+"Coordinates": array:2 [
0 => -80.5057891
1 => 43.5095071
]
+"Latitude": 43.5095071
+"Longitude": -80.5057891
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning, custom-built by Cameo Homes, 3 bedroom, 3 bathroom home located across from two of Waterloo's highly rated schools in Prime Eastbridge, best family neighbourhood! Exterior is all stone and brick with a grand entrance and impressive street curb appeal. Upon entering you will be greeted by the 2 storey open foyer with glass panel staircase and a sun-filled contemporary main floor that offers 9' ceilings and a unique open design featuring large Living Rom with gas fireplace, Dining Room, Family Room with vaulted ceiling open to above, and sliders to a large pool-sized backyard with gas line for BBQ. The large maple Kitchen seamlessly blends with the open area and is equipped with Stainless Steel appliances, ample cabinets, pantry, centre island and lots of counter space. It's a great open main floor to entertain family and friends. The upper level features 3 generous sized Bedrooms including large Primary with walk-in closet, 4 piece luxury Ensuite with corner Whirlpool tub and stand-up shower. Recent updates include roof (2018), water heater owned (2020) & sump pump (2025). Internet cabling (CAT-5-E) throughout the house and COAX cabling (6-R-G). Located minutes to RIM Park, Conestoga Mall, Grey Silo Golf course, Grand River trails, soccer fields and quick access to major highways. (id:62650)"
+"Appliances": array:16 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Dryer"
8 => "Microwave"
9 => "Freezer"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Blinds"
13 => "Garage door opener"
14 => "Garage door opener remote(s)"
15 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:24:46.041627+00:00"
+"Directions": "Cross Streets: New Bedford Drive. ** Directions: University Avenue East to New Bedford Drive to Chesapeake Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2244502"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "40.9 x 41 FT ; 132.26 x 40.08 x 139.68 x 40.97 feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T19:57:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T19:57:18Z"
+"Stories": "2.0"
+"StreetName": "Chesapeake"
+"StreetNumber": "559"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5995"
+"VirtualTourURLUnbranded": "https://milkmanmedia.hd.pics/559-Chesapeake-Dr"
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1544884490"
"RoomType" => "Foyer"
"ListingId" => "X12601812"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "29163523"
"RoomLength" => 3.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-04T19:57:18.92Z"
]
1 => array:11 [
"RoomKey" => "1544884491"
"RoomType" => "Bathroom"
"ListingId" => "X12601812"
"RoomLevel" => "Second level"
"RoomWidth" => 2.31
"ListingKey" => "29163523"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-04T19:57:18.92Z"
]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29163523/559-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.1
+"OriginalEntryTimestamp": "2025-12-04T19:57:18.88Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163523')"
+"ID": "462847"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "462612"
+post_author: 1
+"ListingKey": "29163072"
+"ListingId": "40786229"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T15:10:31Z"
+"RFModificationTimestamp": "2025-12-12T15:13:10Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2092.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G6"
+"UnparsedAddress": "559 CHESAPEAKE Drive, Waterloo, Ontario N2K4G6"
+"Coordinates": array:2 [
0 => -80.5057965
1 => 43.5095148
]
+"Latitude": 43.5095148
+"Longitude": -80.5057965
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning, custom-built by Cameo Homes, 3 bedroom, 3 bathroom home located across from two of Waterloo's highly rated schools in Prime Eastbridge, best family neighbourhood! Exterior is all stone and brick with a grand entrance and impressive street curb appeal. Upon entering you will be greeted by the 2 storey open foyer with glass panel staircase and a sun-filled contemporary main floor that offers 9' ceilings and a unique open design featuring large Living Rom with gas fireplace, Dining Room, Family Room with vaulted ceiling open to above, and sliders to a large pool-sized backyard with gas line for BBQ. The large maple Kitchen seamlessly blends with the open area and is equipped with Stainless Steel appliances, ample cabinets, pantry, centre island and lots of counter space. It's a great open main floor to entertain family and friends. The upper level features 3 generous sized Bedrooms including large Primary with walk-in closet, 4 piece luxury Ensuite with corner Whirlpool tub and stand-up shower. Recent updates include roof (2018), water heater owned (2020) & sump pump (2025). Internet cabling (CAT-5-E) throughout the house and COAX cabling (6-R-G). Located minutes to RIM Park, Conestoga Mall, Grey Silo Golf course, Grand River trails, soccer fields and quick access to major highways. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T19:35:47.926430+00:00"
+"Directions": "University Avenue East to New Bedford Drive to Chesapeake Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563894"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Tile Drained"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-12T14:51:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T14:51:03Z"
+"Stories": "2.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "559"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6014"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://milkmanmedia.hd.pics/559-Chesapeake-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29163072/559-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563896"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 2092
+"OriginalEntryTimestamp": "2025-12-04T18:39:47.95Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163072')"
+"ID": "462612"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24791
+post_id: "447768"
+post_author: 1
+"ListingKey": "29139760"
+"ListingId": "X12579306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:06:03Z"
+"RFModificationTimestamp": "2025-11-26T23:41:49Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "140 OAK PARK DRIVE, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4967276
1 => 43.520707
]
+"Latitude": 43.520707
+"Longitude": -80.4967276
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "EXECUTIVE FREEHOLD TOWNHOUSE LIVING IN UPSCALE WATERLOO NEIGHBORHOOD. Welcome to this beautifully upgraded and move-in readytownhome, offering over 2,000 SQ ft of thoughtfully designed living space in a desirable Waterloo neighborhood. This spacious home features 3large bedrooms, 4 bathrooms, and a versatile in-law suite in the fully finished basement. Step inside the grand foyer and enter a bright, modernmain level with open-concept living, perfect for entertaining. The chef's kitchen boasts stainless steel appliances, an island with seating, andample cabinet space - a true cooking lover's dream - flowing seamlessly into the dining area and cozy living room with gas fireplace. Walk outto your private backyard for effortless indoor-outdoor living. Upstairs, you'll find three generous bedrooms, each with its own walk-in closet,along with a convenient laundry room and full 4-piece bath. The impressive primary suite features vaulted ceilings, a luxurious 5-piece ensuitewith jacuzzi soaker tub, glass shower, and double vanity with great storage. The finished basement offers excellent in-law potential, with aspacious rec room, kitchenette, new luxury vinyl flooring, and a private 3-piece bath. Other highlights include fresh paint throughout, parking fortwo (one in the attached garage), and modern finishes throughout. Don't miss this exceptional opportunity to own a feature-packed, lowmaintenance home in one of Waterloo's sought-after communities. Schedule your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T23:41:44.585257+00:00"
+"Directions": "MILLENIUM BLVD"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.7 x 114.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:58:55Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:58:55Z"
+"Stories": "2.0"
+"StreetName": "Oak Park"
+"StreetNumber": "140"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5216"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_oak_park_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139760/140-oak-park-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-11-26T19:58:55.51Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139760')"
+"ID": "447768"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "446181"
+post_author: 1
+"ListingKey": "29139457"
+"ListingId": "X12579086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T18:35:35Z"
+"RFModificationTimestamp": "2025-11-30T18:37:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "MAIN - 579 WINDJAMMER WAY, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5029887
1 => 43.5084069
]
+"Latitude": 43.5084069
+"Longitude": -80.5029887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo's highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. Private Laundry. Private backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway, parking 1 on driveway 2 in garage! Tenants pay 80% utilities (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:40:52.761761+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023409"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:01:42Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T18:19:27Z"
+"Stories": "2.0"
+"StreetName": "Windjammer"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139457/main-579-windjammer-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T19:01:42.59Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139457')"
+"ID": "446181"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25174
+post_id: "446182"
+post_author: 1
+"ListingKey": "29139209"
+"ListingId": "40790670"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:41:09Z"
+"RFModificationTimestamp": "2025-11-30T21:45:07Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2780.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "140 OAK PARK Drive, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4969292
1 => 43.5207054
]
+"Latitude": 43.5207054
+"Longitude": -80.4969292
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "EXECUTIVE FREEHOLD TOWNHOUSE LIVING IN UPSCALE WATERLOO NEIGHBORHOOD. Welcome to this beautifully upgraded and move-in ready townhome, offering over 2,000 SQ ft of thoughtfully designed living space in a desirable Waterloo neighborhood. This spacious home features 3 large bedrooms, 4 bathrooms, and a versatile in-law suite in the fully finished basement. Step inside the grand foyer and enter a bright, modern main level with open-concept living, perfect for entertaining. The chef’s kitchen boasts stainless steel appliances, an island with seating, and ample cabinet space — a true cooking lover’s dream — flowing seamlessly into the dining area and cozy living room with gas fireplace. Walk out to your private backyard for effortless indoor-outdoor living. Upstairs, you'll find three generous bedrooms, each with its own walk-in closet, along with a convenient laundry room and full 4-piece bath. The impressive primary suite features vaulted ceilings, a luxurious 5-piece ensuite with jacuzzi soaker tub, glass shower, and double vanity with great storage. The finished basement offers excellent in-law potential, with a spacious rec room, kitchenette, new luxury vinyl flooring, and a private 3-piece bath. Other highlights include fresh paint throughout, parking for two (one in the attached garage), and modern finishes throughout. Don’t miss this exceptional opportunity to own a feature-packed, low-maintenance home in one of Waterloo’s sought-after communities. Schedule your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Property Management"
]
+"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": "2025-11-26T19:30:50.584247+00:00"
+"Directions": "MILLENIUM BLVD"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:30:13Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:29:53Z"
+"Stories": "2.0"
+"StreetName": "OAK PARK"
+"StreetNumber": "140"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5216"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_oak_park_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139209/140-oak-park-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MR-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1888
+"BelowGradeFinishedArea": 893
+"OriginalEntryTimestamp": "2025-11-26T18:30:13.19Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139209')"
+"ID": "446182"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23522
+post_id: "446183"
+post_author: 1
+"ListingKey": "29139074"
+"ListingId": "40790705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:52Z"
+"RFModificationTimestamp": "2025-11-26T18:56:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1991.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "579 WINDJAMMER Way Unit# Main, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5028784
1 => 43.5080285
]
+"Latitude": 43.5080285
+"Longitude": -80.5028784
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo’s highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. PrivauPrivate backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway included—an ideal place to call home! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:56:33.467036+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129629"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:11:43Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:11:43Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139074/579-windjammer-way-unit-main-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1991
+"OriginalEntryTimestamp": "2025-11-26T18:08:41.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139074')"
+"ID": "446183"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24850
+post_id: "397312"
+post_author: 1
+"ListingKey": "29077583"
+"ListingId": "40786425"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:55:50Z"
+"RFModificationTimestamp": "2025-11-26T18:24:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "779 ANGLER Way, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.49998273
1 => 43.51488371
]
+"Latitude": 43.51488371
+"Longitude": -80.49998273
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ALL INCLUSIVE LOWER level 1bedroom 1 bathroom apartment in very desirable location in Waterloo. This updated lower level LEGAL apartment with BIG windows, carpet free, 1 bedroom &1 bathroom with a tub includes 1 parking spot. Lower level has its own entrance. Free SHARED laundry. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-07T02:43:18.837577+00:00"
+"Directions": "University Ave. & New Hampshire St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"PhotosChangeTimestamp": "2025-11-06T22:30:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:39:23Z"
+"Stories": "1.0"
+"StreetName": "ANGLER"
+"StreetNumber": "779"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29077583/779-angler-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1350
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2025-11-06T22:30:30.26Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:8 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29077583')"
+"ID": "397312"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24851
+post_id: "389871"
+post_author: 1
+"ListingKey": "29068017"
+"ListingId": "40785768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-13T20:51:06Z"
+"RFModificationTimestamp": "2025-11-13T20:54:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 35, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.49651957
1 => 43.52115429
]
+"Latitude": 43.52115429
+"Longitude": -80.49651957
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream home in the prestigious Carriage Crossing area(Appliances are installed and ready for this home)! Situated in the highly sought-after area, this townhouse offers the ideal combination of tranquillity and accessibility. This never-lived-in, brand-new townhouse is the epitome of modern luxury and convenience. With 4 bedrooms, 4 bathrooms, a spacious double-car garage, and an array of $35,000 Upgrades. You'll appreciate the carpet-free engineered hardwood and vinyl floors, stained oak stairs, upgraded granite/quartz countertops, cabinets, doors, handles, and under-cabinet lighting in the kitchen. The great room and dining area feature added pot lights for a warm and inviting atmosphere. The bathrooms are adorned with upgraded granite/quartz vanities, sinks, floor tiles, shower tiles, wall tiles, toilets, handles, and faucets. The kitchen is equipped with brand-new, top-of-the-line appliances, making meal preparation a delight. Enjoy the beauty of the outdoors on two balconies, one on the north side and another on the south side of the main floor. The master bedroom boasts a raised ceiling and a spacious walk-in closet, creating a luxurious private retreat. Also, enjoy hassle-free living with no need for snow removal or lawn maintenance. Spend your free time doing the things you love. Don't miss the opportunity to make this beautiful, modern townhouse your own! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-05T02:05:56.994875+00:00"
+"Directions": "Millennium Blvd to Oak Park Dr. to Grey Silo Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-04T23:29:32Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-13T20:39:30Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29068017/271-grey-silo-road-unit-35-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"TotalActualRent": 3200
+"ZoningDescription": "MR-4/MD3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2025-11-04T23:29:31.79Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29068017')"
+"ID": "389871"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 28
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]