array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29146143/Property?$select=ALL&$top=20&$filter=ListingKey eq 29146143&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29146143/Property?$select=ALL&$top=20&$filter=ListingKey eq 29146143&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23310
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23312
+post_id: "451060"
+post_author: 1
+"ListingKey": "29146143"
+"ListingId": "X12585240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T18:31:01Z"
+"RFModificationTimestamp": "2025-11-28T19:04:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "322 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.521738
1 => 43.509974
]
+"Latitude": 43.509974
+"Longitude": -80.521738
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into the realm of contemporary sophistication with this stylish 2-bedroom, 2-bathroom condominium, ideally positioned near all conveniences and mere moments from the highway, catering perfectly to commuters. This modern space exudes an irresistible charm, accentuated by its underground parking, ensuring ease and safety for residents. Meticulously crafted, this unit offers not just a residence but a lifestyle. The sleek kitchen and bathroom are adorned with the latest fixtures and finishes, evoking an ambiance of refined elegance. The bedroom serves as a tranquil sanctuary, while the impeccably designed bathroom boasts contemporary elements. Adding to the appeal, the unit includes both an underground parking spot and an extra storage locker. The balcony provides a secluded outdoor retreat, ideal for relishing morning coffee or captivating sunsets. Moreover, revel in the convenience of an in-suite laundry, simplifying day-to-day living. Stay fit in the well equipped gym, unwind in the stylish lounge area, or boost productivity in the dedicated office space - all within the comfort of your own residence. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T19:04:34.760076+00:00"
+"Directions": "Northfield Dr E & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080076"
+"ListOfficeKey": "286296"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T18:00:53Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T18:00:53Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1541514848"
"RoomType" => "Kitchen"
"ListingId" => "X12585240"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29146143"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:00:53.81Z"
]
1 => array:11 [
"RoomKey" => "1541514849"
"RoomType" => "Living room"
"ListingId" => "X12585240"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29146143"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:00:53.81Z"
]
2 => array:11 [
"RoomKey" => "1541514850"
"RoomType" => "Dining room"
"ListingId" => "X12585240"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29146143"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:00:53.81Z"
]
3 => array:11 [
"RoomKey" => "1541514851"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12585240"
"RoomLevel" => "Main level"
"RoomWidth" => 3.27
"ListingKey" => "29146143"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:00:53.82Z"
]
4 => array:11 [
"RoomKey" => "1541514852"
"RoomType" => "Bedroom 2"
"ListingId" => "X12585240"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29146143"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:00:53.82Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29146143/322-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2141698"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Waterloo Standard Condominium Corporation"
+"CoListAgentKey2": "2182290"
+"CoListOfficeKey": "286296"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"CoListOfficeKey2": "286296"
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-28T18:00:53.78Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6344635749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/4ed40932da63391d7cc56d5ead2e996c.webp"
"MediaSize" => 114722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-4ed40932da63391d7cc56d5ead2e996c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6344635788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/0e120a5ffb48c551e04ef250c2fbe8e7.webp"
"MediaSize" => 91285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-0e120a5ffb48c551e04ef250c2fbe8e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6344635803"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/ff30c77500d22501fad8751d6990c46e.webp"
"MediaSize" => 97612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-ff30c77500d22501fad8751d6990c46e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6344635815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/8247e03efe51174e306e17bc96892706.webp"
"MediaSize" => 112911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-8247e03efe51174e306e17bc96892706.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6344635891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/0cd51b047ec2188fa83d10761f0c5473.webp"
"MediaSize" => 95175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-0cd51b047ec2188fa83d10761f0c5473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6344635907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/0cf2951ce946fe070a8b86197512ebdc.webp"
"MediaSize" => 182682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-0cf2951ce946fe070a8b86197512ebdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6344635941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/b812c7f109c77944078fce1706d7f519.webp"
"MediaSize" => 63584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-b812c7f109c77944078fce1706d7f519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6344636004"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/08cb97abb2e1650377762f62ffbc0926.webp"
"MediaSize" => 254176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-08cb97abb2e1650377762f62ffbc0926.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6344636045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/b4bb45cd9222c1ad2afac6c599701502.webp"
"MediaSize" => 194403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-b4bb45cd9222c1ad2afac6c599701502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6344636114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/33dfc6f9967e2c5302d3ae2cbfb33cc1.webp"
"MediaSize" => 119730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-33dfc6f9967e2c5302d3ae2cbfb33cc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6344636180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/82162a87ad210978aff3df8bbabc443d.webp"
"MediaSize" => 87836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-82162a87ad210978aff3df8bbabc443d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6344636186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/48e54619dafb62e2f0cdbbe261165f8e.webp"
"MediaSize" => 109462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-48e54619dafb62e2f0cdbbe261165f8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6344636200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/5d8b3bc37deeec9c5cfebeeae4713656.webp"
"MediaSize" => 113688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-5d8b3bc37deeec9c5cfebeeae4713656.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6344636217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/b86bef74422d204feb44767c904468fb.webp"
"MediaSize" => 385086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-b86bef74422d204feb44767c904468fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6344636252"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/b63024eadaa81a74fc5c9f5a4b1395ea.webp"
"MediaSize" => 108205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-b63024eadaa81a74fc5c9f5a4b1395ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6344636283"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/36535a82adfd29c443e663e58906043d.webp"
"MediaSize" => 225935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-36535a82adfd29c443e663e58906043d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6344636309"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/f51e59cd6b5f2e3debc90474fc12befe.webp"
"MediaSize" => 136231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-f51e59cd6b5f2e3debc90474fc12befe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6344636363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/a406f3feaf168772e284bdb25e9bb2c4.webp"
"MediaSize" => 110136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-a406f3feaf168772e284bdb25e9bb2c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6344636383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/c7a8a321bba3a8f8e13de37924bd5e45.webp"
"MediaSize" => 224380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-c7a8a321bba3a8f8e13de37924bd5e45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6344636413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/1986440433ab2bd1773e50bb46c8a704.webp"
"MediaSize" => 275369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-1986440433ab2bd1773e50bb46c8a704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6344636461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/e76cb5b471ca7758dad04a00002ff784.webp"
"MediaSize" => 384702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-e76cb5b471ca7758dad04a00002ff784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6344636488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/633aa79d3e6e08378e2bbfbda3099d68.webp"
"MediaSize" => 354624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-633aa79d3e6e08378e2bbfbda3099d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6344636497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/315788fa83d64e595baa12943a7298da.webp"
"MediaSize" => 145656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-315788fa83d64e595baa12943a7298da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6344636540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/a2fe4a8a01e0c4eebc214e7e1a4a3a27.webp"
"MediaSize" => 93302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-a2fe4a8a01e0c4eebc214e7e1a4a3a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6344636615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/a752b9c4933e0c5f9b70cd0650bf0242.webp"
"MediaSize" => 136558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-a752b9c4933e0c5f9b70cd0650bf0242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6344636655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/e2c187c90233e7130dc30a8cb2ae64d7.webp"
"MediaSize" => 378398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-e2c187c90233e7130dc30a8cb2ae64d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6344636686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/d43de3242a975302af355d2cdeba76b8.webp"
"MediaSize" => 80139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-d43de3242a975302af355d2cdeba76b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6344636741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/882efeb567ef8aad5245ec68457bc04d.webp"
"MediaSize" => 223547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-882efeb567ef8aad5245ec68457bc04d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6344636818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/51b9b35486a616253f7a0c3dafa650de.webp"
"MediaSize" => 93934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-51b9b35486a616253f7a0c3dafa650de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6344636830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/67891a9abcdf69c0fae78dabfdd45aa7.webp"
"MediaSize" => 368104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-67891a9abcdf69c0fae78dabfdd45aa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6344636890"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/fe063bedecb30abc5d4afe78de1575fd.webp"
"MediaSize" => 318033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-fe063bedecb30abc5d4afe78de1575fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6344636954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/2d001fa81d053e2d1b0adfcce5631cb3.webp"
"MediaSize" => 110266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-2d001fa81d053e2d1b0adfcce5631cb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6344637000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/2971b86081de5a36c558ec82c434a59b.webp"
"MediaSize" => 131300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-2971b86081de5a36c558ec82c434a59b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6344637040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/09691f65a5c7555ae49bd030e43fa67e.webp"
"MediaSize" => 225925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-09691f65a5c7555ae49bd030e43fa67e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6344637138"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/e1d4564579b21c0c7524b58925ad1189.webp"
"MediaSize" => 307266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-e1d4564579b21c0c7524b58925ad1189.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6344637166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/db3522e66ea4dd22763e4ebd191341e5.webp"
"MediaSize" => 213957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-db3522e66ea4dd22763e4ebd191341e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6344637244"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/9ed14efc4dde78d8f78e6737cda41336.webp"
"MediaSize" => 73825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-9ed14efc4dde78d8f78e6737cda41336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6344637305"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/da27fecc9a545289224a6d0a0c3b6e83.webp"
"MediaSize" => 368691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-da27fecc9a545289224a6d0a0c3b6e83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6344637352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/26ac487280082e696ce95ec1ae918655.webp"
"MediaSize" => 115072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-26ac487280082e696ce95ec1ae918655.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6344637392"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/b1cdc5c46c9546677d42874171aa12ec.webp"
"MediaSize" => 271095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-b1cdc5c46c9546677d42874171aa12ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6344637436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/7ffa08f7a0bb1c3d8f72221341edea43.webp"
"MediaSize" => 206399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-7ffa08f7a0bb1c3d8f72221341edea43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6344637533"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29146143/69a7aa9776ced05049891d0c1d1e3152.webp"
"MediaSize" => 406298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29146143/thumbnail-69a7aa9776ced05049891d0c1d1e3152.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12585240"
"ResourceRecordKey" => "29146143"
"ModificationTimestamp" => "2025-11-28T18:00:53.79Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29146143')"
+"ID": "451060"
}
]
+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=OfficeKey eq 286296/Office?$select=ALL&$top=10&$filter=OfficeKey eq 286296&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 286296/Office?$select=ALL&$top=10&$filter=OfficeKey eq 286296&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "EXECUTIVE REAL ESTATE SERVICES LTD."
+"OfficeEmail": null
+"OfficePhone": "289-752-4088"
+"OfficeMlsId": "345200"
+"ModificationTimestamp": "2025-05-21T20:02:13Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "286296"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5-B CONESTOGA DRIVE UNIT 301"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BRAMPTON"
+"OfficePostalCode": "L6Z4N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1359609"
+"OriginalEntryTimestamp": "2020-01-03T23:08:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6004480649"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/26/office-286296/f53ad0eea63607002af3b91805e7151a.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "345200"
"ResourceRecordKey" => "286296"
"ModificationTimestamp" => "2025-05-21T19:48:00Z"
]
]
+"OfficeFax": "289-752-6188"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "368221"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "286296"
"SocialMediaUrlOrId" => "http://www.theexecutiverealestate.com/"
"ModificationTimestamp" => "2025-05-21T19:48:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1359608"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('286296')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2080076/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2080076&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2080076/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2080076&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25172
+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 29146143" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24756
+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 29146143/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29146143&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29146143/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29146143&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24710
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29146143 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521738 43.509974)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29146143 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521738 43.509974)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29146143 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521738 43.509974)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29146143 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521738 43.509974)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25018
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25011
+post_id: "454818"
+post_author: 1
+"ListingKey": "29151028"
+"ListingId": "40791491"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T19:00:52Z"
+"RFModificationTimestamp": "2025-12-01T19:53:58Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y8"
+"UnparsedAddress": "540 MARINER Drive, Waterloo, Ontario N2K3Y8"
+"Coordinates": array:2 [
0 => -80.507857
1 => 43.5060424
]
+"Latitude": 43.5060424
+"Longitude": -80.507857
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Beautiful 3 bed , 3.5 bath Freehold Townhome backing on green space with fully finished basement available for sale in Eastbridge neighborhood of Waterloo! Upon entrance through the foyer, you will find open concept main floor with spacious kitchen featuring plenty of kitchen cabinets, breakfast bar, glass tile backsplash, a powder room and a bright and spacious living room. Second floor features a huge master bedroom with 4 pc ensuite bathroom and huge closet. 2 more good sized bedrooms with huge closets and another 4 pc family bathroom. Very spacious Fully finished basement with rec room and full bath. Total 2 parking spaces - Single car garage and an asphalt private single driveway. Conveniently located close to public schools, short walk to bus stop, parks, few minutes drive to Conestoga mall, Restaurants, Highway 85, Conestoga College,University of Waterloo, Wilfrid Laurier University And Other Major Amenities. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T18:41:26.600917+00:00"
+"Directions": "Eastbridge Blvd. & Mariner Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-12-01T17:30:24Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T18:49:20Z"
+"Stories": "2.0"
+"StreetName": "MARINER"
+"StreetNumber": "540"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3782.5"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1543249144"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.85Z"
]
1 => array:11 [
"RoomKey" => "1543249145"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.86Z"
]
2 => array:11 [
"RoomKey" => "1543249146"
"RoomType" => "Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.86Z"
]
3 => array:11 [
"RoomKey" => "1543249147"
"RoomType" => "Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.87Z"
]
4 => array:11 [
"RoomKey" => "1543249148"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.87Z"
]
5 => array:11 [
"RoomKey" => "1543249149"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.88Z"
]
6 => array:11 [
"RoomKey" => "1543249150"
"RoomType" => "Kitchen"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.88Z"
]
7 => array:11 [
"RoomKey" => "1543249151"
"RoomType" => "Living room/Dining room"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.88Z"
]
8 => array:11 [
"RoomKey" => "1543249152"
"RoomType" => "Bonus Room"
"ListingId" => "40791491"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.89Z"
]
9 => array:11 [
"RoomKey" => "1543249153"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.89Z"
]
10 => array:11 [
"RoomKey" => "1543249154"
"RoomType" => "Recreation room"
"ListingId" => "40791491"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.9Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29151028/540-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2025-12-01T17:30:24.07Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:1 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350152453"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29151028/d5045ec37a2be4a56828cda7e16ef2a9.webp"
"MediaSize" => 197958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29151028/thumbnail-d5045ec37a2be4a56828cda7e16ef2a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional home with an attached garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791491"
"ResourceRecordKey" => "29151028"
"ModificationTimestamp" => "2025-12-01T17:30:24.08Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29151028')"
+"ID": "454818"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25013
+post_id: "450704"
+post_author: 1
+"ListingKey": "29145460"
+"ListingId": "X12584864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T16:20:43Z"
+"RFModificationTimestamp": "2025-11-28T16:37:58Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE ROAD, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114497
1 => 43.5023835
]
+"Latitude": 43.5023835
+"Longitude": -80.5114497
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today's market. Set on one of Waterloo's most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we've created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It's rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility - an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo's most established and beloved neighbourhoods - close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region's best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you're looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T16:37:40.228806+00:00"
+"Directions": "Cross Streets: Lee & Old Stone Rd. ** Directions: Lexington to Lee, to Old Stone Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240105"
+"ListOfficeKey": "284058"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "135 x 137 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:05:31Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T16:05:31Z"
+"Stories": "2.0"
+"StreetName": "Old Stone"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15626.35"
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:28 [
0 => array:11 [
"RoomKey" => "1541459552"
"RoomType" => "Bathroom"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 2.42
"ListingKey" => "29145460"
"RoomLength" => 3.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
1 => array:11 [
"RoomKey" => "1541459553"
"RoomType" => "Mud room"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 3.8
"ListingKey" => "29145460"
"RoomLength" => 4.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
2 => array:11 [
"RoomKey" => "1541459554"
"RoomType" => "Bathroom"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29145460"
"RoomLength" => 2.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
3 => array:11 [
"RoomKey" => "1541459555"
"RoomType" => "Bedroom"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 3.89
"ListingKey" => "29145460"
"RoomLength" => 3.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
4 => array:11 [
"RoomKey" => "1541459556"
"RoomType" => "Other"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29145460"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
5 => array:11 [
"RoomKey" => "1541459557"
"RoomType" => "Utility room"
"ListingId" => "X12584864"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29145460"
"RoomLength" => 1.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.81Z"
]
6 => array:11 [
"RoomKey" => "1541459558"
"RoomType" => "Bathroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
"RoomWidth" => 3.46
"ListingKey" => "29145460"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.82Z"
]
7 => array:11 [
"RoomKey" => "1541459559"
"RoomType" => "Bathroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
"RoomWidth" => 3.04
"ListingKey" => "29145460"
"RoomLength" => 2.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.82Z"
]
8 => array:11 [
"RoomKey" => "1541459560"
"RoomType" => "Bedroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
"RoomWidth" => 3.61
"ListingKey" => "29145460"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.82Z"
]
9 => array:11 [
"RoomKey" => "1541459561"
"RoomType" => "Bedroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29145460"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.82Z"
]
10 => array:11 [
"RoomKey" => "1541459562"
"RoomType" => "Bedroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29145460"
"RoomLength" => 4.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T16:05:31.82Z"
]
11 => array:11 [
"RoomKey" => "1541459563"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12584864"
"RoomLevel" => "Second level"
…7
]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
27 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29145460/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 135.0
+"OriginalEntryTimestamp": "2025-11-28T16:05:31.77Z"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145460')"
+"ID": "450704"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+post_id: "449247"
+post_author: 1
+"ListingKey": "29143240"
+"ListingId": "40790704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T19:45:34Z"
+"RFModificationTimestamp": "2025-11-27T20:15:52Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 6334.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE Road, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114374
1 => 43.5026033
]
+"Latitude": 43.5026033
+"Longitude": -80.5114374
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today’s market. Set on one of Waterloo’s most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we’ve created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It’s rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility — an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo’s most established and beloved neighbourhoods — close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region’s best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you’re looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ductless"
]
+"CreationDate": "2025-11-27T20:15:42.815291+00:00"
+"Directions": "Lexington to Lee, to Old Stone Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Radiant heat"
1 => "Forced air"
2 => "In Floor Heating"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1889883"
+"ListOfficeKey": "274578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
3 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T19:38:38Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T19:38:38Z"
+"Stories": "2.0"
+"StreetName": "OLD STONE"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "15626.35"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:30 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
27 => array:11 [ …11]
28 => array:11 [ …11]
29 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29143240/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 4933
+"BelowGradeFinishedArea": 1401
+"OriginalEntryTimestamp": "2025-11-27T19:38:38.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143240')"
+"ID": "449247"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25014
+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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139457')"
+"ID": "446181"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25012
+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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139074')"
+"ID": "446183"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25004
+post_id: "446184"
+post_author: 1
+"ListingKey": "29138905"
+"ListingId": "40790707"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:50:15Z"
+"RFModificationTimestamp": "2025-11-26T18:32:43Z"
+"ListPrice": 1775000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.520379
1 => 43.508525
]
+"Latitude": 43.508525
+"Longitude": -80.520379
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 250 Grey Squirrel Place—an elegant family home tucked along a quiet crescent in one of Waterloo’s most desirable neighbourhoods, Colonial Acres, where warmth, space, and sophistication meet. Set on a rare double lot, this property offers exceptional outdoor space and privacy. The moment you step inside, you’re met with a stunning view of the main floor: a vaulted 14-foot ceiling in the front living room anchored by a wood-burning fireplace and framed by gleaming hardwood floors. A second wood fireplace enhances the cozy atmosphere in the main-level family room, while a dedicated office provides a quiet workspace. The mudroom/laundry room, conveniently located by the garage entrance, adds everyday practicality. The kitchen is designed for connection and function, featuring granite counters, Bosch stove and Miele appliances, and a walkout to the brand-new 2025 tiered wood deck overlooking the double-sized backyard—complete with a sports court, two Honeycrisp apple trees, and a peach tree, offering the perfect space for family play, gardening, or summer entertaining. Upstairs, you’ll find four generous bedrooms, including a serene primary suite with an ensuite, along with a second full washroom. The fully finished basement extends your living space with two additional bedrooms, a three-piece bathroom, and a large recreation room perfect for movie nights or weekend gatherings. With a double-car garage, interlock driveway, and mature trees surrounding the property, every detail speaks to comfort and quality. Ideally located minutes from Uptown Waterloo, the University of Waterloo, and Waterloo Park, with quick access to The Boardwalk, RIM Park, and Grey Silo Golf Course, this home offers the perfect balance of family living and professional convenience. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:32:38.425964+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:38:46Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:46Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"VirtualTourURLUnbranded": "https://youriguide.com/250_grey_squirrel_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138905/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2025-11-26T17:38:46.01Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138905')"
+"ID": "446184"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23324
+post_id: "443746"
+post_author: 1
+"ListingKey": "29134291"
+"ListingId": "40789308"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T15:15:50Z"
+"RFModificationTimestamp": "2025-12-01T15:19:34Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 E NORTHFIELD Drive E Unit# 415, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5218345
1 => 43.5102257
]
+"Latitude": 43.5102257
+"Longitude": -80.5218345
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T20:42:10.123381+00:00"
+"Directions": "Northfield E Drive and Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564314"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-11-25T13:30:22Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T15:00:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"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/29134291/247-northfield-drive-e-unit-415-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-11-25T13:30:22.65Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134291')"
+"ID": "443746"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25016
+post_id: "443071"
+post_author: 1
+"ListingKey": "29134352"
+"ListingId": "X12574088"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T16:10:22Z"
+"RFModificationTimestamp": "2025-12-01T16:27:28Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "415 - 247 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.521945
1 => 43.509547
]
+"Latitude": 43.509547
+"Longitude": -80.521945
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Electricity"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T17:37:59.494283+00:00"
+"Directions": "Cross Streets: Bridge St. W. ** Directions: Northfield E Drive and Bridge Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101285"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-25T14:20:20Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T15:55:34Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3220"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29134352/415-247-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-11-25T14:20:20.16Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134352')"
+"ID": "443071"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25017
+post_id: "441278"
+post_author: 1
+"ListingKey": "29131608"
+"ListingId": "40790134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:55:51Z"
+"RFModificationTimestamp": "2025-11-26T18:23:47Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2747.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B8"
+"UnparsedAddress": "442 CHESAPEAKE Drive, Waterloo, Ontario N2K4B8"
+"Coordinates": array:2 [
0 => -80.508133
1 => 43.506918
]
+"Latitude": 43.506918
+"Longitude": -80.508133
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this lovely and move-in-ready 3+1 bedroom single-family home, perfectly situated in Eastbridge, one of Waterloo's most sought-after neighbourhoods. Ideally located backing onto the school yard green space with no backyard neighbours, this home offers privacy and direct access to Lester B. Pearson Public School yard, green space and playground—a rare advantage for families. Inside, you'll enter into a stylishly updated (2025) main floor including spacious foyer leading into a bright, sun filled open-concept space featuring a lovely living room with a gas fireplace, a separate dining area and convenient mudroom/laundry. The impressive upper family room with vaulted ceilings is perfect for family gatherings, or cozy movie nights. This family room offers a unique covered second-storey balcony—an ideal spot for morning coffee or unwinding in the evening. The primary suite features a renovated (2025) 5 pc ensuite and generous walk-in closet. The fully finished lower level adds even more functional space, including a fabulous rec room with rustic barn board feature wall, an additional bedroom or office area and another full bath. With approximately 2,800 sq. ft. of living space, this home is designed for comfort and versatility. Just steps from two highly rated elementary schools, the new splash pad, walking trails, Manulife RIM park including the Eastside Library and Grey Silo Golf Club this home puts recreation, learning, and convenience at your doorstep. You're also minutes from Conestoga Mall, St. Jacobs Market, LRT, Expressway access and more—everything a growing family needs. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T19:58:38.442364+00:00"
+"Directions": "Bridge Street to Chesapeake Drive"
+"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": "1563572"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T17:30:15Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:51Z"
+"Stories": "2.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "442"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5680.58"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/442-Chesapeake-Dr"
+"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/29131608/442-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 2079
+"BelowGradeFinishedArea": 668
+"OriginalEntryTimestamp": "2025-11-24T17:30:15.59Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131608')"
+"ID": "441278"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 70
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]