array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29253436/Property?$select=ALL&$top=20&$filter=ListingKey eq 29253436&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29253436/Property?$select=ALL&$top=20&$filter=ListingKey eq 29253436&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "535940"
+post_author: 1
+"ListingKey": "29253436"
+"ListingId": "X12698164"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T06:20:15Z"
+"RFModificationTimestamp": "2026-01-15T06:44:49Z"
+"ListPrice": 429900.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"
]
+"AssociationFee": "601"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T06:44:36.904846+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": "2026-01-15T06:09:57Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T06:09:57Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3500"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560563507"
"RoomType" => "Kitchen"
"ListingId" => "X12698164"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29253436"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.28Z"
]
1 => array:11 [
"RoomKey" => "1560563508"
"RoomType" => "Living room"
"ListingId" => "X12698164"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29253436"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.28Z"
]
2 => array:11 [
"RoomKey" => "1560563509"
"RoomType" => "Dining room"
"ListingId" => "X12698164"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29253436"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.28Z"
]
3 => array:11 [
"RoomKey" => "1560563510"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12698164"
"RoomLevel" => "Main level"
"RoomWidth" => 3.27
"ListingKey" => "29253436"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.29Z"
]
4 => array:11 [
"RoomKey" => "1560563511"
"RoomType" => "Bedroom 2"
"ListingId" => "X12698164"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29253436"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.29Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29253436/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
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"CoListOfficeKey2": "286296"
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-15T06:09:57.26Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6405258048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/5b745a551463558290b9d3b5340783e1.webp"
"MediaSize" => 275369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-5b745a551463558290b9d3b5340783e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6405258054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/063266ed19f996f5f2d0f23e5fb2b795.webp"
"MediaSize" => 378398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-063266ed19f996f5f2d0f23e5fb2b795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6405258060"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/301c89ce53e7c1d2c9be5d124cb2edeb.webp"
"MediaSize" => 307266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-301c89ce53e7c1d2c9be5d124cb2edeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6405258064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/6110c5da487ee5a4c0865ad48ba88ad5.webp"
"MediaSize" => 224380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-6110c5da487ee5a4c0865ad48ba88ad5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6405258069"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/6a19678b55cc8f4e647e8fc93a3793ac.webp"
"MediaSize" => 318033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-6a19678b55cc8f4e647e8fc93a3793ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6405258073"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/d39eb79977bb44d0546b71d83a22c956.webp"
"MediaSize" => 271095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-d39eb79977bb44d0546b71d83a22c956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6405258076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/c3bfa2a5459ec0e4d00a8415fc4d26c8.webp"
"MediaSize" => 225935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-c3bfa2a5459ec0e4d00a8415fc4d26c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6405258079"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/cd3dd6e4e56973b0d5e8de903839a38a.webp"
"MediaSize" => 145656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-cd3dd6e4e56973b0d5e8de903839a38a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6405258084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/fa78c24d157208f6382f1d3676ccf5e5.webp"
"MediaSize" => 206399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-fa78c24d157208f6382f1d3676ccf5e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6405258089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/64915e61820bd93e0b987f45b31ea730.webp"
"MediaSize" => 182682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-64915e61820bd93e0b987f45b31ea730.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6405258094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/2f1937e9643b89bac6c896eeae032f17.webp"
"MediaSize" => 136558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-2f1937e9643b89bac6c896eeae032f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6405258098"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/44134a41ecf78f56953600473dc451f4.webp"
"MediaSize" => 73825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-44134a41ecf78f56953600473dc451f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6405258103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/3ea83ed1207f898e3af643082deef6f7.webp"
"MediaSize" => 63584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-3ea83ed1207f898e3af643082deef6f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6405258110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/d4098a305ce1546adbbc105cb09d6bbd.webp"
"MediaSize" => 112911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-d4098a305ce1546adbbc105cb09d6bbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6405258113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/78241108b20701ff5d3fb53c73c39e70.webp"
"MediaSize" => 115072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-78241108b20701ff5d3fb53c73c39e70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6405258117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/853a7d5656dca384f250ef533f2cad48.webp"
"MediaSize" => 87836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-853a7d5656dca384f250ef533f2cad48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6405258121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/f37166ad064ddd2a32346067fb477d24.webp"
"MediaSize" => 91285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-f37166ad064ddd2a32346067fb477d24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6405258125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/0abfbdb58950405989c0c3e587cb302e.webp"
"MediaSize" => 95175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-0abfbdb58950405989c0c3e587cb302e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6405258131"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/3577041a0a993906f244001086be0216.webp"
"MediaSize" => 119730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-3577041a0a993906f244001086be0216.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6405258133"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/388887dce5cd7a9a436f04efc906b803.webp"
"MediaSize" => 97612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-388887dce5cd7a9a436f04efc906b803.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6405258136"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/d25eb253da5df8850219c09038960d1c.webp"
"MediaSize" => 109462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-d25eb253da5df8850219c09038960d1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6405258143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/403fabad899c9d963f467349f0bd5b3f.webp"
"MediaSize" => 93934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-403fabad899c9d963f467349f0bd5b3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6405258147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/68ea9631b2c3d885a43da623f10690db.webp"
"MediaSize" => 114722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-68ea9631b2c3d885a43da623f10690db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6405258150"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/65db29ad9d1d0434ad098667716015b0.webp"
"MediaSize" => 113688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-65db29ad9d1d0434ad098667716015b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6405258153"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/173ec0186f946fbbd71f120ee442ce46.webp"
"MediaSize" => 80139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-173ec0186f946fbbd71f120ee442ce46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6405258157"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/3b5b6b4dd825b135ff7f407dc6692679.webp"
"MediaSize" => 225925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-3b5b6b4dd825b135ff7f407dc6692679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6405258161"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/b61fdef5e93b49ce24fc8b29e51051eb.webp"
"MediaSize" => 194403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-b61fdef5e93b49ce24fc8b29e51051eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6405258163"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/2d8425714d160a6b69735752c415d8c5.webp"
"MediaSize" => 223547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-2d8425714d160a6b69735752c415d8c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6405258164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/585f3a6b02158c96cd455d26dd831cf1.webp"
"MediaSize" => 213957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-585f3a6b02158c96cd455d26dd831cf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6405258166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/03b81a8b826772921c4676d9e93ae04b.webp"
"MediaSize" => 108205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-03b81a8b826772921c4676d9e93ae04b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6405258167"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/e3bf6e549536234b2ad1c397be05a493.webp"
"MediaSize" => 136231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-e3bf6e549536234b2ad1c397be05a493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6405258169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/0e21af080b47b65c886d58298e6ad24a.webp"
"MediaSize" => 110266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-0e21af080b47b65c886d58298e6ad24a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6405258171"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/73aea72fccf7aede793cb744be1495ca.webp"
"MediaSize" => 110136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-73aea72fccf7aede793cb744be1495ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6405258174"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/050ae39db507d4a1b9c7c0d98a2df0ce.webp"
"MediaSize" => 93302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-050ae39db507d4a1b9c7c0d98a2df0ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6405258175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/dbd2822b1931d9d4d8cf85eb37f70ccf.webp"
"MediaSize" => 131300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-dbd2822b1931d9d4d8cf85eb37f70ccf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6405258179"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/b1551f532f6ebc0e3da93b4295cafc74.webp"
"MediaSize" => 368104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-b1551f532f6ebc0e3da93b4295cafc74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6405258182"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/b07c71b5d06bc587c73d4d4f640a7111.webp"
"MediaSize" => 354624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-b07c71b5d06bc587c73d4d4f640a7111.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6405258187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/69f151eb00e488cc87858c6a3c14d792.webp"
"MediaSize" => 368691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-69f151eb00e488cc87858c6a3c14d792.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6405258190"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/22ae7cbda1eb95ba9e35d48ce0d4bec6.webp"
"MediaSize" => 385086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-22ae7cbda1eb95ba9e35d48ce0d4bec6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6405258193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/6fb20d06236e34c39ba6671fc4a5cefe.webp"
"MediaSize" => 384702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-6fb20d06236e34c39ba6671fc4a5cefe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6405258198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/04bf3256c48eb1d23c0e7179d1e25d4b.webp"
"MediaSize" => 406298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-04bf3256c48eb1d23c0e7179d1e25d4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6405258200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253436/ff526b1655941a01dc38e1aafad558a2.webp"
"MediaSize" => 254176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253436/thumbnail-ff526b1655941a01dc38e1aafad558a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698164"
"ResourceRecordKey" => "29253436"
"ModificationTimestamp" => "2026-01-15T06:09:57.27Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "JAIDEV GAIND"
"MemberFirstName" => "JAIDEV"
"MemberLastName" => "GAIND"
"MemberMlsId" => "9596190"
"OriginatingSystemName" => 26
"MemberKey" => "2080076"
"ModificationTimestamp" => "2025-12-15T10:09:24Z"
"MemberStatus" => "Active"
"OfficeKey" => "286296"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:3 [ …3]
"MemberOfficePhone" => "905-609-1944"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "905-609-1944"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2019-09-18T18:08:00Z"
"MemberNationalAssociationId" => "1354968"
"OfficeNationalAssociationId" => "1359609"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "EXECUTIVE REAL ESTATE SERVICES LTD."
"OfficePhone" => "289-752-4088"
"OfficeMlsId" => "345200"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "286296"
"ModificationTimestamp" => "2025-05-21T20:02:13Z"
"OfficeAddress1" => "5-B CONESTOGA DRIVE UNIT 301"
"OfficeCity" => "BRAMPTON"
"OfficePostalCode" => "L6Z4N"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "289-752-6188"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-01-03T23:08:00Z"
"OfficeNationalAssociationId" => "1359609"
"OfficeBrokerNationalAssociationId" => "1359608"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29253436')"
+"ID": "535940"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: b60e403254323a335a6acf24e0502e7cccf47e12b5b871e3932a48c32f5cd916" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23837
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+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"
+"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 Cache Key: 6eb73c1c54d5d7f384d8cd8c1a7deefcd475c049b54c08ad142b84c9c18e8933" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25341
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29253436" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24946
+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 29253436/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29253436&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29253436/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29253436&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+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 29253436 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 29253436 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=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29253436 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 29253436 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=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24863
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24797
+post_id: "535939"
+post_author: 1
+"ListingKey": "29253362"
+"ListingId": "40798504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T05:25:19Z"
+"RFModificationTimestamp": "2026-01-15T06:55:55Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2922.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3A5"
+"UnparsedAddress": "354 FORESTLAWN Road, Waterloo, Ontario N2K3A5"
+"Coordinates": array:2 [
0 => -80.5026144
1 => 43.4986231
]
+"Latitude": 43.4986231
+"Longitude": -80.5026144
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Desirable Lexington Area Family Home. Great Schools, close to Kiwanis Park (Swimming/Dog Park), Rim Park Recreation/Arenas, Grey Silo Golf, Bechtel Park Soccer Fields, Shopping at Conestoga Mall and just 3 minutes to Expressway. 4 Bedrooms, 4 Bathrooms and over 2529 sq ft, this is a true family home with plenty of room for all. Large Private Primary Bedroom has 3pc Ensuite plus a walk-in closet and a large freestanding tub. Large secondary Bedroom with 3pc ensuite. Plus 2 other good sized bedrooms and a 4 pc main bathroom. Perfect set up for getting everyone ready in the morning. Entry Foyer has French doors to Large Bright Living room. Dining room off kitchen could also be wonderful main floor office space. Kitchen has large eat-in area and is open to main floor family room. Cupboards and backsplash have been refreshed, updated appliances, large pantry closet has laundry hookups. Family room with built ins surrounding a natural gas fireplace and with large windows to back yard. Large Deck overlooks huge flat, fully fenced private yard. Childs playcenter, Tree-swing, Swing Set and a newly rebuilt shed with electric to store all your furniture, tools or could be wonderful playhouse for the kids. Chicken coop is included or can be removed by current owner if requested. Basement has finished recreation room with bar, good sized workshop has built in work bench, large utility/laundry area and plenty of storage. Well maintained - Including - Roof (2011), Furnace (2014), Air Conditioner (2022), Sump Pump (2023), Water Softener (2022), Water Heater (Rental - 2021), Shed Rebuilt (2022), Ensuite Update (2021), Kitchen Refresh (2017), Driveway (2016) (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Freezer"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T06:55:37.745685+00:00"
+"Directions": "Lexington to Meadowvale to Forestlawn"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564602"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T05:20:49Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T05:20:49Z"
+"Stories": "2.0"
+"StreetName": "FORESTLAWN"
+"StreetNumber": "354"
+"StreetSuffix": "Road"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "7209.98"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1560551834"
"RoomType" => "Utility room"
"ListingId" => "40798504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 25'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
1 => array:11 [
"RoomKey" => "1560551835"
"RoomType" => "Workshop"
"ListingId" => "40798504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
2 => array:11 [
"RoomKey" => "1560551836"
"RoomType" => "Recreation room"
"ListingId" => "40798504"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 22'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
3 => array:11 [
"RoomKey" => "1560551837"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
4 => array:11 [
"RoomKey" => "1560551838"
"RoomType" => "Bedroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
5 => array:11 [
"RoomKey" => "1560551839"
"RoomType" => "Bedroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.37Z"
]
6 => array:11 [
"RoomKey" => "1560551840"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
7 => array:11 [
"RoomKey" => "1560551841"
"RoomType" => "Bedroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
8 => array:11 [
"RoomKey" => "1560551842"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
9 => array:11 [
"RoomKey" => "1560551843"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798504"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "19'4'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
10 => array:11 [
"RoomKey" => "1560551844"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
11 => array:11 [
"RoomKey" => "1560551845"
"RoomType" => "Family room"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 21'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
12 => array:11 [
"RoomKey" => "1560551846"
"RoomType" => "Eat in kitchen"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
13 => array:11 [
"RoomKey" => "1560551847"
"RoomType" => "Dining room"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
14 => array:11 [
"RoomKey" => "1560551848"
"RoomType" => "Living room"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
15 => array:11 [
"RoomKey" => "1560551849"
"RoomType" => "Foyer"
"ListingId" => "40798504"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29253362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-15T05:18:49.38Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29253362/354-forestlawn-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2529
+"BelowGradeFinishedArea": 393
+"OriginalEntryTimestamp": "2026-01-15T05:18:49.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:1 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6405213738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253362/e63642d77f07716052e725a23b51bff4.webp"
"MediaSize" => 170661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253362/thumbnail-e63642d77f07716052e725a23b51bff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798504"
"ResourceRecordKey" => "29253362"
"ModificationTimestamp" => "2026-01-15T05:20:49.62Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "JOHN THOMPSON"
"MemberFirstName" => "JOHN"
"MemberLastName" => "THOMPSON"
"MemberMlsId" => "KWkw7361"
"OriginatingSystemName" => 26
"MemberKey" => "1564602"
"ModificationTimestamp" => "2025-08-19T16:26:45Z"
"MemberStatus" => "Active"
"OfficeKey" => "76789"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "519-885-4914"
"MemberCity" => "WATERLOO"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-885-0200"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1070191"
"OfficeNationalAssociationId" => "1004357"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX TWIN CITY REALTY INC."
"OfficePhone" => "519-885-0200"
"OfficeMlsId" => "KW207"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "76789"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "83 ERB ST.W."
"OfficeCity" => "WATERLOO"
"OfficePostalCode" => "N2L6C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "519-885-4914"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1004357"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1069905"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29253362')"
+"ID": "535939"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24875
+post_id: "535941"
+post_author: 1
+"ListingKey": "29253437"
+"ListingId": "X12698166"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T06:20:15Z"
+"RFModificationTimestamp": "2026-01-15T06:42:40Z"
+"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": "2026-01-15T06:42:31.324100+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": "2026-01-15T06:09:57Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T06:09:57Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560563512"
"RoomType" => "Kitchen"
"ListingId" => "X12698166"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29253437"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.43Z"
]
1 => array:11 [
"RoomKey" => "1560563513"
"RoomType" => "Living room"
"ListingId" => "X12698166"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29253437"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.43Z"
]
2 => array:11 [
"RoomKey" => "1560563514"
"RoomType" => "Dining room"
"ListingId" => "X12698166"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29253437"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T06:09:57.43Z"
]
3 => array:11 [
"RoomKey" => "1560563515"
…10
]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29253437/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": 2300
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"CoListOfficeKey2": "286296"
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-15T06:09:57.4Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29253437')"
+"ID": "535941"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24804
+post_id: "526557"
+post_author: 1
+"ListingKey": "29238768"
+"ListingId": "40797113"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T22:55:35Z"
+"RFModificationTimestamp": "2026-01-12T00:48:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 518.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 405, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5217691
1 => 43.5105762
]
+"Latitude": 43.5105762
+"Longitude": -80.5217691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone, a unique Scandinavian-inspired community blending modern farmhouse vibes with ultimate comfort. This bright 1-bedroom unit features a balcony overlooking the beautiful RO courtyard, complete with a fire pit, BBQs, and a spa for relaxing. The sleek kitchen boasts stainless steel appliances and quartz countertops, and Browns Social House is just a short walk away for nights off from cooking. With onsite shopping, 24/7 security, a fitness centre, and easy access to trails, the Grand River, and transit, Blackstone offers a lifestyle you’ll love! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T00:48:39.224990+00:00"
+"Directions": "CORNER OF NORTHFIELD DR AND BRIDGE ST"
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Stone"
2 => "Metal"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950448"
+"ListOfficeKey": "299742"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-11T22:49:28Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T22:49:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29238768/247-northfield-drive-e-unit-405-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1819312"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76849"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 518
+"OriginalEntryTimestamp": "2026-01-11T22:49:23.31Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238768')"
+"ID": "526557"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24870
+post_id: "526569"
+post_author: 1
+"ListingKey": "29238726"
+"ListingId": "X12685032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T21:50:35Z"
+"RFModificationTimestamp": "2026-01-11T22:36:32Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B7"
+"UnparsedAddress": "503 BRIGANTINE DRIVE, Waterloo, Ontario N2K4B7"
+"Coordinates": array:2 [
0 => -80.5142811
1 => 43.5076026
]
+"Latitude": 43.5076026
+"Longitude": -80.5142811
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime Eastbridge Location The Perfect Family Home with Room to Grow! Welcome to this beautifully maintained home in the heart of Eastbridge, one of Waterloos most desirable family-friendly neighborhoods. Offering plenty of space, comfort, and charm, this home is designed for both everyday living and entertaining. The main floor features a bright, open-concept layout with a spacious living room highlighted by a cozy center fireplace and Palladium windows that flood the space with natural light. The carpet-free design adds a clean, modern touch throughout. The expansive kitchen boasts ample cabinetry, including a full pantry wall, and an adjoining dining area with a walkout to a large deck perfect for family dinners or weekend barbecues. Upstairs, you'll find a welcoming family room with oversized windows, offering the ideal spot for movie nights or kids playtime. The second floor includes three generous bedrooms, including a primary suite complete with a walk-in closet and a private ensuite bathroom. The basement is mostly finished, offering a spacious recreation room, games area, laundry, and ample storage giving your family even more room to grow and play. Step outside to enjoy the oversized deck with a charming gazebo, overlooking a large fenced yard thats perfect for children, pets, or summer gatherings with friends and family. This home is ideally located with quick access to schools, parks, shopping, and transit everything a growing family needs, right at your doorstep. Move-in ready and waiting for its next family to make lasting memories. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T22:36:11.479436+00:00"
+"Directions": "Cross Streets: Chesapeake. ** Directions: Chesapeake to Bringantine."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094417"
+"ListOfficeKey": "270562"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36 x 148 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T21:40:59Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T21:40:59Z"
+"Stories": "2.0"
+"StreetName": "Brigantine"
+"StreetNumber": "503"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6069"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/36321914b51693ba3632b84777376e1e"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238726/503-brigantine-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4 Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-01-11T21:40:59.09Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238726')"
+"ID": "526569"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "517642"
+post_author: 1
+"ListingKey": "29226352"
+"ListingId": "X12673470"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:25:54Z"
+"RFModificationTimestamp": "2026-01-09T15:27:51Z"
+"ListPrice": 1875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3L7"
+"UnparsedAddress": "592 MANORWOOD COURT, Waterloo, Ontario N2K3L7"
+"Coordinates": array:2 [
0 => -80.519367
1 => 43.5024746
]
+"Latitude": 43.5024746
+"Longitude": -80.519367
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LARGE BUNGALOW LOCATED ON A PRIVATE STEET IN ONE OF THE MOST DESIRABLE POCKETS OF TOWN. Nestled on a serene, private street in one of the region's most coveted neighborhoods, this beautiful, unique bungalow presents a rare blend of timeless charm and endless potential. Set on a beautifully landscaped lot, the home boasts a resort-style backyard oasis featuring a custom stone-surrounded pool and jacuzzi-a true retreat for elegant outdoor living, perfect for entertaining or relaxing in total privacy. Recent updates, including a new furnace and AC, enhance comfort and efficiency, while other thoughtful upgrades throughout the home reflect pride of ownership. The unfinished lower level invites your vision, offering the perfect canvas for a luxury extension. Just moments from Conestoga Mall, restaurants, trails, parks, schools, and more. A remarkable opportunity for the discerning buyer. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Furniture"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 4
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T21:11:20.747069+00:00"
+"Directions": "Cross Streets: OLD ABBEY RD. ** Directions: OLD ABBEY RD TO MANORWOOD CRT."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T20:41:46Z"
+"PhotosCount": 33
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:14:20Z"
+"Stories": "1.0"
+"StreetName": "Manorwood"
+"StreetNumber": "592"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "13892"
+"VirtualTourURLUnbranded": "https://youriguide.com/vMO8OJ3ZOEEDD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29226352/592-manorwood-court-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 91.1
+"OriginalEntryTimestamp": "2026-01-07T20:41:46.25Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29226352')"
+"ID": "517642"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24868
+post_id: "517747"
+post_author: 1
+"ListingKey": "29225692"
+"ListingId": "40796792"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:10:38Z"
+"RFModificationTimestamp": "2026-01-09T15:13:01Z"
+"ListPrice": 1875000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3515.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3L7"
+"UnparsedAddress": "592 MANORWOOD Court, Waterloo, Ontario N2K3L7"
+"Coordinates": array:2 [
0 => -80.5192028
1 => 43.5023406
]
+"Latitude": 43.5023406
+"Longitude": -80.5192028
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "LARGE BUNGALOW LOCATED ON A PRIVATE STEET IN ONE OF THE MOST DESIRABLE POCKETS OF TOWN. Nestled on a serene, private street in one of the region’s most coveted neighborhoods, this beautiful, unique bungalow presents a rare blend of timeless charm and endless potential. Set on a beautifully landscaped lot, the home boasts a resort-style backyard oasis featuring a custom stone-surrounded pool and jacuzzi—a true retreat for elegant outdoor living, perfect for entertaining or relaxing in total privacy. Recent updates, including a new furnace and AC, enhance comfort and efficiency, while other thoughtful upgrades throughout the home reflect pride of ownership. The unfinished lower level invites your vision, offering the perfect canvas for a luxury extension. Just moments from Conestoga Mall, restaurants, trails, parks, schools, and more. A remarkable opportunity for the discerning buyer. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:40:26.137979+00:00"
+"Directions": "OLD ABBEY RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T19:08:51Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T14:59:44Z"
+"Stories": "1.0"
+"StreetName": "MANORWOOD"
+"StreetNumber": "592"
+"StreetSuffix": "Court"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "13892"
+"VirtualTourURLUnbranded": "https://youriguide.com/vMO8OJ3ZOEEDD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29225692/592-manorwood-court-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 92.0
+"AboveGradeFinishedArea": 3515
+"OriginalEntryTimestamp": "2026-01-07T19:08:51.09Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29225692')"
+"ID": "517747"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "515381"
+post_author: 1
+"ListingKey": "29223342"
+"ListingId": "40795022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T15:15:05Z"
+"RFModificationTimestamp": "2026-01-07T15:16:59Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 562.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Street Unit# 308, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5217286
1 => 43.5099657
]
+"Latitude": 43.5099657
+"Longitude": -80.5217286
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home at the prestigious Blackstone building in Waterloo! This stunning one bedroom condo offers luxury living at its finest. Step into a modern space with high-end finishes including stainless appliances, sleek quartz countertops, and a spacious walk-in closet. This unit also comes with an owned storage locker and a conveniently located parking spot, W6 - the closest parking space to the front doors of the building, ensuring a hassle-free experience every time you come home. Condo fees include water and internet as well. Blackstone's amenities are second to none, with a fitness centre to keep you active, social rooms for entertaining guests, a co-working space with meeting rooms for your business needs, and even a pet wash station for your furry friends. Outdoor enthusiasts will love the courtyard with a hot tub, fire bowl, BBQ area, and harvest table - perfect for enjoying the fresh air. And don't forget about the rooftop terrace with lounge seating and BBQ facilities, offering stunning views of the city skyline. Experience convenience, luxury, and a vibrant community lifestyle at Blackstone. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "469"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T06:53:42.491533+00:00"
+"Directions": "Northfield to entrance"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126426"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-07T05:21:44Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T15:00:51Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Street"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2822"
+"VirtualTourURLUnbranded": "https://youriguide.com/247_northfield_dr_e_suite_308_waterloo_on/"
+"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/29223342/247-northfield-street-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 562
+"OriginalEntryTimestamp": "2026-01-07T05:18:38.79Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223342')"
+"ID": "515381"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24869
+post_id: "512734"
+post_author: 1
+"ListingKey": "29220138"
+"ListingId": "40796187"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T17:35:37Z"
+"RFModificationTimestamp": "2026-01-06T17:52:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 538.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H4"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 105, Waterloo, Ontario N2K3H4"
+"Coordinates": array:2 [
0 => -80.5217325
1 => 43.5105682
]
+"Latitude": 43.5105682
+"Longitude": -80.5217325
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming embrace of 251 NORTHFIELD Drive E Unit #105, situated in the vibrant community of Waterloo. This delightful 1-bedroom, 1-bathroom unit invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting open-concept living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need to whip up delicious meals, while ample natural light floods the space, creating a warm and inviting atmosphere. When it's time to unwind, the bedroom offers a serene retreat, with plenty of storage space. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your private balcony, where you can enjoy your morning coffee or soak up the sunshine in peace. With reserved parking and on-site laundry facilities, everyday tasks become a breeze. And for those with furry companions, rest assured that this apartment is pet-friendly, so your four-legged friends can feel right at home too. With shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Ready to experience the charm and convenience of life at 251 NORTHFIELD Drive E Unit #105? Schedule a viewing today and discover your new home sweet home in Waterloo. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:52:35.282729+00:00"
+"Directions": "Northfield Dr. to Bridge St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897408"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2026-01-06T17:29:07Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-06T17:29:07Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2662.77"
+"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/29220138/251-northfield-drive-e-unit-105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1850
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 538
+"OriginalEntryTimestamp": "2026-01-06T17:29:07.33Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29220138')"
+"ID": "512734"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24862
+post_id: "512605"
+post_author: 1
+"ListingKey": "29219150"
+"ListingId": "40795948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:20:25Z"
+"RFModificationTimestamp": "2026-01-14T21:29:22Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y5"
+"UnparsedAddress": "537 WINDJAMMER Way, Waterloo, Ontario N2K3Y5"
+"Coordinates": array:2 [
0 => -80.5050792
1 => 43.506906
]
+"Latitude": 43.506906
+"Longitude": -80.5050792
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful Family Home in Highly Sought-After Eastbridge Community Welcome to this charming 4-bed, 3.5-bath home in the heart of Eastbridge—complete with a fully finished basement, covered outdoor living space, and no rear neighbours. With outstanding curb appeal in a family-friendly neighbourhood, this meticulously maintained home offers bright and thoughtfully designed living space. The spacious foyer includes a highly functional walk-in coat closet, ideal for busy families or hosting guests. A front living room provides the perfect spot for a home office or play area, with a clear view of the street to keep an eye on the kids. Elegant hardwood floors lead you to the renovated kitchen, featuring a gas stove, large island, and ambient pot lighting. The open-concept layout connects seamlessly to the second living area, complete with large windows and a cozy fireplace. Step through the sliding glass doors to your expansive covered deck, featuring a built-in BBQ, ample seating, and peaceful views—no rear neighbours make this private outdoor retreat exceptionally enjoyable. Upstairs, hardwood floors continue throughout. The large primary suite features two closets and a renovated spa-like 4-pc ensuite with heated floors and a steam shower. Three additional bedrooms, a linen closet, and a 5-pc bathroom complete the upper level. The fully finished basement offers engineered hardwood floors, a stone fireplace, a 3-pc bathroom, and generous storage space. This home has been exceptionally cared for and is truly move-in ready. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:43:16.683185+00:00"
+"Directions": "Eastbridge Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T15:00:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:09:21Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "537"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6138"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/95usa_537_windjammer_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29219150/537-windjammer-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2104
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-01-06T15:00:44.44Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:40 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29219150')"
+"ID": "512605"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 47
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]