array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29076246/Property?$select=ALL&$top=20&$filter=ListingKey eq 29076246&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29076246/Property?$select=ALL&$top=20&$filter=ListingKey eq 29076246&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23181
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23183
+post_id: "396161"
+post_author: 1
+"ListingKey": "29076246"
+"ListingId": "X12517716"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-06T19:05:55Z"
+"RFModificationTimestamp": "2025-11-06T23:16:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "402 - 243 NORTHFIELD DRIVE, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 243 Northfield Unit 402, located in the highly sought-after Blackstone Building in anamazing neighborhood. This modern 1 bedroom, 1 bath apartment boasts 9' ceilings and huge windows, creating a bright and spacious atmosphere. The open concept living and dining room offers a seamless flow and opens onto a large balcony, perfect for enjoying the outdoors. The contemporary kitchen is equipped with stylish white cabinetry, luxurious quartz countertops, and top-of-the-line stainless steel appliances. Upgrades throughout the unit include high-quality wood grain laminate flooring and elegant pot lights, adding a touch of sophistication to the space. Residents of the Blackstone Building enjoy a wealth of amenities designed to enhance their lifestyle. Stay fit and active in the fully equipped fitness center, host gatherings in the event/party room, and take advantage of the convenient dog wash station. The building is secured with 24/7 security and features keyless entry for added peace of mind. Additionally, residents benefit from free Rogers Ignite Internet. The property also offers a perfect mix of urban and city living with access to the Terrace & Courtyard, located on the 2nd floor of the Nord Building. This outdoor space is beautifully designed with modern furnishings, stainless steel BBQs, a gas fire pit, loungers, and dinettes, providing a relaxing environment for entertaining or simply enjoying some fresh air. Conveniently situated close to the highway, this property offers easy access to the St. Jacobs Farmers Market, a variety of restaurants, shopping centers, parks, and trails. Embrace the best of both worlds with this exceptional leasing opportunity at Blackstone Building. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-06T23:11:52.933161+00:00"
+"Directions": "Cross Streets: Corner Of Bridge St&Northfield. ** Directions: Corner of Bridge St and Northfield Dr E."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-06T18:58:59Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-06T18:58:59Z"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29076246/402-243-northfield-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MF Property Management"
+"TotalActualRent": 1900
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-06T18:58:59.62Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:17 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6299265843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/7559456e1b90606ff78699d343c593ec.webp"
"MediaSize" => 215273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-7559456e1b90606ff78699d343c593ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6299265866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/b5c613139d2ce4b3246da92b9932e13e.webp"
"MediaSize" => 156536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-b5c613139d2ce4b3246da92b9932e13e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6299265990"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/0df8c6acaea973bba7771d4c822e6199.webp"
"MediaSize" => 181801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-0df8c6acaea973bba7771d4c822e6199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6299266041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/f405ddfc860681243e405a30327f7e52.webp"
"MediaSize" => 189301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-f405ddfc860681243e405a30327f7e52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6299266042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/faa5191b061e9ec135a8e996df78dc9b.webp"
"MediaSize" => 176753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-faa5191b061e9ec135a8e996df78dc9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6299266044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/6da2edd5784c75fc6f2adece842b8453.webp"
"MediaSize" => 177745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-6da2edd5784c75fc6f2adece842b8453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6299266046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/711da07c594bb8df4ef6a71a963637e6.webp"
"MediaSize" => 176232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-711da07c594bb8df4ef6a71a963637e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6299266049"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/5846bda6a85bd0bcbd1be7431a0e9d0b.webp"
"MediaSize" => 188982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-5846bda6a85bd0bcbd1be7431a0e9d0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6299266125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/c8c02d1d24e36b272b745091a7a37763.webp"
"MediaSize" => 190106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-c8c02d1d24e36b272b745091a7a37763.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6299266130"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/e2906d8ffcc61462487fa09530c11530.webp"
"MediaSize" => 203108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-e2906d8ffcc61462487fa09530c11530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6299266156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/2564c7ed710dc7f5ffd2f9adee1a0170.webp"
"MediaSize" => 163394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-2564c7ed710dc7f5ffd2f9adee1a0170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6299266180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/f16b9c7afaa11e5213218c6f20490dd5.webp"
"MediaSize" => 291652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-f16b9c7afaa11e5213218c6f20490dd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6299266195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/2eaafb0b981515e030d60f5fcacb6ae8.webp"
"MediaSize" => 114768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-2eaafb0b981515e030d60f5fcacb6ae8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6299266277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/0905a073202b4ad418b195074a2518f1.webp"
"MediaSize" => 263771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-0905a073202b4ad418b195074a2518f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6299266292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/2c902d916274443d73619be73805a5d3.webp"
"MediaSize" => 263733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-2c902d916274443d73619be73805a5d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6299266296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/1f83acd400ab4db42320255f43120353.webp"
"MediaSize" => 311031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-1f83acd400ab4db42320255f43120353.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6299266397"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29076246/f96e980793b3ad962fc25120fb1eefe1.webp"
"MediaSize" => 291881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29076246/thumbnail-f96e980793b3ad962fc25120fb1eefe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12517716"
"ResourceRecordKey" => "29076246"
"ModificationTimestamp" => "2025-11-06T18:58:59.63Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29076246')"
+"ID": "396161"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Cache Key: 5ccb196343ece072243962f98199202abdb1c06e0961a9370908b81492b753a7" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23486
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2130557/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2130557&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2130557/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2130557&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24977
+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 29076246" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24595
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29076246/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29076246&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29076246/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29076246&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24575
+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 29076246 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.522255 43.509258)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29076246 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.522255 43.509258)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29076246 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.522255 43.509258)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29076246 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.522255 43.509258)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24448
+post_id: "429878"
+post_author: 1
+"ListingKey": "29117382"
+"ListingId": "40789088"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T15:40:12Z"
+"RFModificationTimestamp": "2025-11-19T16:58:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 NORTHFIELD Drive Unit# 522, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5220637
1 => 43.5103726
]
+"Latitude": 43.5103726
+"Longitude": -80.5220637
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Awesome opportunity to lease in Sentral - Blackstone Modern Condominiums in Waterloo! Enjoy all the amenities of urban living, while giving you quick access to biking trails and surrounding rural communities to unwind. This is relaxed city living. Inspired by Scandinavian Living and designed around the comforts of a Modern Farmhouse. From our fully equipped gym and co-working space, to the great room and bike room, as a Blackstone tenant you have full access to all amenities across all buildings. No need to even step outside. The beautiful lobby connects you to both buildings, making it easy to setup for an event or stay just a little warmer during the winter months. Amenities include keyless entry, bike storage, dog wash station and 24/7 security. Enjoy full use of the terrace which is a beautiful oasis located on the 2nd floor of Nord. With manicured gardens and modern outdoor furnishings, the terrace is a serene, relaxing space, perfect for entertaining or just simply getting some fresh air. Stainless steel barbeques, a gas fire pit, loungers and dinettes ensure you have everything you need for dinner and drinks under the stars. This EVA model features many upgrades featuring quartz counter tops and stainless steel appliances. This carpet free 800 sq ft unit has two bedrooms and two full bathrooms. The Primary Bedroom has a nice Walk in closet. Spend time on your large 78 sq ft balcony. 1 surface parking spot is included. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T16:57:57.794684+00:00"
+"Directions": "CORNER OF NORTHFIELD AND BRIDGE ST - - ENTER OFF OF BRIDGE ST"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564166"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-11-19T15:30:30Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T15:30:30Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1536469997"
"RoomType" => "4pc Bathroom"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.42Z"
]
1 => array:11 [
"RoomKey" => "1536469998"
"RoomType" => "Bedroom"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
2 => array:11 [
"RoomKey" => "1536469999"
"RoomType" => "Full bathroom"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
3 => array:11 [
"RoomKey" => "1536470000"
"RoomType" => "Primary Bedroom"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
4 => array:11 [
"RoomKey" => "1536470001"
"RoomType" => "Living room"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
5 => array:11 [
"RoomKey" => "1536470002"
"RoomType" => "Laundry room"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
6 => array:11 [
"RoomKey" => "1536470003"
"RoomType" => "Eat in kitchen"
"ListingId" => "40789088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29117382"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-19T15:30:30.43Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29117382/251-northfield-drive-unit-522-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"TotalActualRent": 2399
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2025-11-19T15:30:30.39Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:18 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6328091643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/0a7593abcaffa5190a3b129aa1f8d38e.webp"
"MediaSize" => 136642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-0a7593abcaffa5190a3b129aa1f8d38e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6328091666"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/2b9214fd05007e209fe92f3d102d268c.webp"
"MediaSize" => 177801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-2b9214fd05007e209fe92f3d102d268c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6328091684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/6a44afbaae0970b4dcdc458f8f27870c.webp"
"MediaSize" => 69966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-6a44afbaae0970b4dcdc458f8f27870c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6328091707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/441607c2042e75047b230f2ea9638891.webp"
"MediaSize" => 60632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-441607c2042e75047b230f2ea9638891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6328091714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/5dbe86387c8382a61e49af7b58dd3d02.webp"
"MediaSize" => 60614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-5dbe86387c8382a61e49af7b58dd3d02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6328091727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/1413b7a82906a876b955613439a0f462.webp"
"MediaSize" => 43137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-1413b7a82906a876b955613439a0f462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6328091741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/2133a6e7b98d7805fd840795752c7047.webp"
"MediaSize" => 38247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-2133a6e7b98d7805fd840795752c7047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6328091753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/7208d8df28c73d3bffdbb42f4a25b61b.webp"
"MediaSize" => 66003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-7208d8df28c73d3bffdbb42f4a25b61b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6328091771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/670b1514a9c54a1309db82484977f342.webp"
"MediaSize" => 68168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-670b1514a9c54a1309db82484977f342.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6328091779"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/0e3aa82930875acd3b09a55410acce57.webp"
"MediaSize" => 127924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-0e3aa82930875acd3b09a55410acce57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Drone / aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6328091783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/01a083c9ffbe62b3c240ca04e6b2470d.webp"
"MediaSize" => 43409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-01a083c9ffbe62b3c240ca04e6b2470d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6328091786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/07e59a4eb3af1858c44d0618a5a401b0.webp"
"MediaSize" => 28786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-07e59a4eb3af1858c44d0618a5a401b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6328091791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/a7f1e18ffafc9c2d080837043f3b4b4d.webp"
"MediaSize" => 27912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-a7f1e18ffafc9c2d080837043f3b4b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6328091794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/783b0c706722fc1b98ea79ecb6e49fca.webp"
"MediaSize" => 34436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-783b0c706722fc1b98ea79ecb6e49fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6328091798"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/3a513c1880842eb6fe54f1c9b4ad24a2.webp"
"MediaSize" => 34295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-3a513c1880842eb6fe54f1c9b4ad24a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6328091801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/bc0660893f4c440638dc4549d8d5e3f3.webp"
"MediaSize" => 115241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-bc0660893f4c440638dc4549d8d5e3f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of patio / terrace featuring area for grilling, a pergola, and grilling area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6328091806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/194fef0d0063f7dd9a855aafdaa7db21.webp"
"MediaSize" => 114057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-194fef0d0063f7dd9a855aafdaa7db21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of community with a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6328091809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29117382/006c525087749ed1aa10fbddfd26c4d2.webp"
"MediaSize" => 154654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29117382/thumbnail-006c525087749ed1aa10fbddfd26c4d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789088"
"ResourceRecordKey" => "29117382"
"ModificationTimestamp" => "2025-11-19T15:30:30.4Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29117382')"
+"ID": "429878"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24511
+post_id: "429616"
+post_author: 1
+"ListingKey": "29116977"
+"ListingId": "40782526"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T02:25:48Z"
+"RFModificationTimestamp": "2025-11-20T02:30:33Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2183.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2E3"
+"UnparsedAddress": "449 ANNDALE Road, Waterloo, Ontario N2K2E3"
+"Coordinates": array:2 [
0 => -80.5128156
1 => 43.4944309
]
+"Latitude": 43.4944309
+"Longitude": -80.5128156
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 449 Anndale Road, where comfort and character meet in a beautiful Waterloo neighbourhood! Step through the charming covered porch and into an open-concept main floor designed for modern living. The remodeled kitchen (2013) features granite counters, bamboo hardwood floors, and a spacious island that’s perfect for gathering with friends and family. The main level includes two bright, spacious bedrooms, a private 3-piece ensuite, and a stunning 4-piece family bathroom. The finished lower level offers space for a third bedroom, a cozy rec room, and a walk-up to the backyard — ideal for guests or in-law potential. Upgrades include new HE (97%) furnace, A/C and Heat Pump (2023) Outside, you’ll fall in love with the large, fully fenced yard featuring a covered porch with gas hookup for BBQ, lower patio, propane-heated workshop, and attached shed. With easy access to highways, parks, transit, universities, restaurants, and shops — this home truly has it all! Don't wait - Book your showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Wet Bar"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"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-19T15:12:34.547512+00:00"
+"Directions": "Lexington Road to Anndale Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563761"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Wet bar"
2 => "Paved driveway"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T12:50:31Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T02:12:17Z"
+"Stories": "1.0"
+"StreetName": "ANNDALE"
+"StreetNumber": "449"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5489.41"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/449_anndale_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1536756422"
"RoomType" => "Utility room"
"ListingId" => "40782526"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.84Z"
]
1 => array:11 [
"RoomKey" => "1536756423"
"RoomType" => "Laundry room"
"ListingId" => "40782526"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
2 => array:11 [
"RoomKey" => "1536756424"
"RoomType" => "Recreation room"
"ListingId" => "40782526"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "27'7'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
3 => array:11 [
"RoomKey" => "1536756425"
"RoomType" => "Family room"
"ListingId" => "40782526"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
4 => array:11 [
"RoomKey" => "1536756426"
"RoomType" => "2pc Bathroom"
"ListingId" => "40782526"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
5 => array:11 [
"RoomKey" => "1536756427"
"RoomType" => "4pc Bathroom"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
6 => array:11 [
"RoomKey" => "1536756428"
"RoomType" => "3pc Bathroom"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
7 => array:11 [
"RoomKey" => "1536756429"
"RoomType" => "Bedroom"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.85Z"
]
8 => array:11 [
"RoomKey" => "1536756430"
"RoomType" => "Primary Bedroom"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.86Z"
]
9 => array:11 [
"RoomKey" => "1536756431"
"RoomType" => "Living room"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.86Z"
]
10 => array:11 [
"RoomKey" => "1536756432"
"RoomType" => "Dining room"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.86Z"
]
11 => array:11 [
"RoomKey" => "1536756433"
"RoomType" => "Kitchen"
"ListingId" => "40782526"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29116977"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-20T02:12:17.86Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29116977/449-anndale-road-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1167
+"BelowGradeFinishedArea": 1016
+"OriginalEntryTimestamp": "2025-11-19T12:50:31.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6327839088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/7389b280e17d7183b7458f17c35a5d11.webp"
"MediaSize" => 168847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-7389b280e17d7183b7458f17c35a5d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6327839090"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/bf68877f7001ad9e4b533d359e2107f9.webp"
"MediaSize" => 173442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-bf68877f7001ad9e4b533d359e2107f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6327839093"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/2ce138fdf38892c7afefee6c4a391a1b.webp"
"MediaSize" => 161942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-2ce138fdf38892c7afefee6c4a391a1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6327839095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/263b9e15a13d63322e5c3d7c07c1c0ba.webp"
"MediaSize" => 151796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-263b9e15a13d63322e5c3d7c07c1c0ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6327839097"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/11561e94ab95e0b7ab764e0b34b6c88d.webp"
"MediaSize" => 74883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-11561e94ab95e0b7ab764e0b34b6c88d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6327839099"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/e9f9f86c010ddf7a3d98de925f3e0248.webp"
"MediaSize" => 76017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-e9f9f86c010ddf7a3d98de925f3e0248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6327839101"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/09611b51d1aea7c38590adb761eb06e0.webp"
"MediaSize" => 91679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-09611b51d1aea7c38590adb761eb06e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6327839103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/f12653b0eae775cb629aade3d128e6fd.webp"
"MediaSize" => 95148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-f12653b0eae775cb629aade3d128e6fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6327839105"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/e4347cf7873581aaba8009d81f8e322a.webp"
"MediaSize" => 91154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-e4347cf7873581aaba8009d81f8e322a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6327839108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/0e1469b597473931a9d10ef46b55266f.webp"
"MediaSize" => 87146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-0e1469b597473931a9d10ef46b55266f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6327839110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/0fc994495cfbcd666b9e285d1eaca164.webp"
"MediaSize" => 91049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-0fc994495cfbcd666b9e285d1eaca164.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6327839111"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/e2a7dcb866cf032017e1044405f9ed47.webp"
"MediaSize" => 91788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-e2a7dcb866cf032017e1044405f9ed47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6327839112"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/346e150bfa245f0158626195e9c36e72.webp"
"MediaSize" => 93939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-346e150bfa245f0158626195e9c36e72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6327839113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/2a93c38d3e87697f210dcd383ce9b115.webp"
"MediaSize" => 89104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-2a93c38d3e87697f210dcd383ce9b115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6327839114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/8c18a338b01163e23834f00b251bc140.webp"
"MediaSize" => 100046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-8c18a338b01163e23834f00b251bc140.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6327839115"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/cddc66e059d0249a37d1fce6896c55c4.webp"
"MediaSize" => 101182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-cddc66e059d0249a37d1fce6896c55c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6327839116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/b646f7fe24f53c46ae9903fb37001812.webp"
"MediaSize" => 87425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-b646f7fe24f53c46ae9903fb37001812.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6327839117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/d4e90ccacfeed4f9b7379a3c11c634d3.webp"
"MediaSize" => 93034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-d4e90ccacfeed4f9b7379a3c11c634d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6327839118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/535a542e46663c8422540ad053111e0b.webp"
"MediaSize" => 95268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-535a542e46663c8422540ad053111e0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6327839119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/2b50f01ca4de6bc6779a74f5867cf6c0.webp"
"MediaSize" => 62446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-2b50f01ca4de6bc6779a74f5867cf6c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6327839120"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/41750770c261ceaa0fbbfea7367cafd3.webp"
"MediaSize" => 93322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29116977/thumbnail-41750770c261ceaa0fbbfea7367cafd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40782526"
"ResourceRecordKey" => "29116977"
"ModificationTimestamp" => "2025-11-19T12:50:31.1Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6327839121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29116977/23198a77fefa05e4afb4d4b9a3cb181b.webp"
"MediaSize" => 67583
"MediaType" => "webp"
…8
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29116977')"
+"ID": "429616"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24492
+post_id: "426887"
+post_author: 1
+"ListingKey": "29113395"
+"ListingId": "40787998"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-18T20:06:04Z"
+"RFModificationTimestamp": "2025-11-18T20:08:39Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2138.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "596 CANSO Place, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5014362
1 => 43.5079403
]
+"Latitude": 43.5079403
+"Longitude": -80.5014362
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Eastbridge, one of Waterloo’s most loved neighbourhoods, celebrated for its parks, trails, top schools, and the unmatched convenience of being close to RIM Park, Grey Silo Golf Course, soccer fields, riverfront walking paths, Conestoga Mall, the LRT, and the expressway. Tucked away on a quiet court, this home offers a level of peace and privacy that’s hard to find, while still keeping you wonderfully connected to everything the area offers. Inside, the home feels bright, airy, and incredibly fresh. Large windows on every level invite in natural light throughout the day, giving each room a warm and welcoming glow. The main floor has an intuitive, easy flow, and the kitchen has been thoughtfully refreshed with 2023 upgraded appliances and updated countertops, while the spacious dining room and comfortable living room make family time feel effortless. It truly shows beautifully from the moment you step inside. The outdoor space is where this property becomes truly special. Over $100,000 has been invested in creating a backyard oasis designed for comfort, connection, and complete privacy. The covered porch, finished with integrated lighting and a ceiling fan, functions as an outdoor living room perfect for morning coffee, relaxed summer dinners, or watching the kids enjoy the oversized yard. Movie nights on the projector screen, evenings in the hot tub, beautiful interlock work, and an upgraded custom shed all come together to create a space that feels like a private retreat. Upstairs are three generous bedrooms, including a standout primary suite with vaulted ceilings and exceptional natural light. The fully finished basement adds even more versatility with a great rec room, work-from-home option, or ideal teen hangout, complete with an additional bathroom. Homes with lots this large, on a court, with this level of privacy and care, are incredibly rare in Eastbridge. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T18:28:25.028586+00:00"
+"Directions": "Windjammer to Kelso"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T20:02:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-18T20:02:22Z"
+"Stories": "2.0"
+"StreetName": "CANSO"
+"StreetNumber": "596"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5812.35"
+"VirtualTourURLUnbranded": "https://youriguide.com/596_canso_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29113395/596-canso-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1470
+"BelowGradeFinishedArea": 669
+"OriginalEntryTimestamp": "2025-11-18T16:19:08.39Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113395')"
+"ID": "426887"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24861
+post_id: "426609"
+post_author: 1
+"ListingKey": "29113563"
+"ListingId": "40789025"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T17:20:26Z"
+"RFModificationTimestamp": "2025-11-20T17:23:10Z"
+"ListPrice": 643900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2014.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2X9"
+"UnparsedAddress": "501 KINGSCOURT Drive Unit# B, Waterloo, Ontario N2K2X9"
+"Coordinates": array:2 [
0 => -80.5230195
1 => 43.496872
]
+"Latitude": 43.496872
+"Longitude": -80.5230195
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this spacious 3+2 bedroom property featuring a separate entrance to a fully finished basement making it ideal for an in-law suite, multi-generational living, or an excellent setup for extended family. Located just a short walk to Conestoga Mall, transit, restaurants, and with quick access to Highway 7/8, this home with over 2000 sq ft of finished space offers outstanding convenience for any lifestyle. Whether you're a first-time buyer looking to offset your mortgage, an investor seeking strong rental returns, or a family needing flexible living arrangements, this property is a fantastic mortgage helper with good rental potential. The home is carpet-free, freshly painted, and move-in ready. The large pool-sized backyard provides excellent privacy—ideal for children, pets, and outdoor entertaining. Parking is a breeze with a driveway that accommodates up to 6 vehicles. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T17:14:51.262386+00:00"
+"Directions": "Davenport Road and Kingscourt Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031341"
+"ListOfficeKey": "280014"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2025-11-20T15:38:45Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T17:09:20Z"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "501"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3644"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/501-Kingscourt-Dr"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29113563/501-kingscourt-drive-unit-b-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1052
+"BelowGradeFinishedArea": 962
+"OriginalEntryTimestamp": "2025-11-18T16:38:49.81Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:39 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113563')"
+"ID": "426609"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504
+post_id: "423258"
+post_author: 1
+"ListingKey": "29109650"
+"ListingId": "40788271"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-18T02:40:16Z"
+"RFModificationTimestamp": "2025-11-18T02:43:02Z"
+"ListPrice": 999000.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:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "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": "2025-11-17T17:04:28.470850+00:00"
+"Directions": "Eastbridge Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T02:30:03Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-18T02:38:26Z"
+"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/29109650/537-windjammer-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2104
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2025-11-17T16:30:34.32Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:39 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29109650')"
+"ID": "423258"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24526
+post_id: "411321"
+post_author: 1
+"ListingKey": "29092848"
+"ListingId": "X12534808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-12T04:50:58Z"
+"RFModificationTimestamp": "2025-11-12T05:35:22Z"
+"ListPrice": 374800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "308 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condos - where modern design meets urban convenience in the heart of Waterloo. A perfect opportunity for first-time buyers, investors, or professionals, with 584 Square Feet, this stylish condo features a bright, open-concept layout with a spacious living area that flows seamlessly to a private balcony overlooking the tranquil courtyard - ideal for morning coffee or evening relaxation. The contemporary kitchen offers stainless steel appliances, sleek quartz countertops, subway tile backsplash and an open dining space perfect for entertaining. The generous primary bedroom includes a walk-in closet, while the elegant 4-piece bathroom combines comfort and functionality. Additional highlights include in-suite laundry (stacked washer & dryer) and a dedicated underground parking space for your convenience and peace of mind. Residents enjoy resort-inspired amenities, including a fitness centre, rooftop patio, business centre with Wi-Fi, party room, pet wash station, BBQ area, courtyard with fire pit and hot tub, dining room with catering kitchen, bike storage, and more. Ideally located near Conestoga Mall, the LRT, Grey Silo Golf Club, Rim Park, University of Waterloo, Wilfrid Laurier University, restaurants, shops, trails, and major highways - this condo offers the perfect balance of luxury, lifestyle, and location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-12T00:46:57.368539+00:00"
+"Directions": "Northfield Dr E & Bridge St W"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236082"
+"ListOfficeKey": "283412"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-12T04:36:29Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-12T04:36:29Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2976.85"
+"VirtualTourURLUnbranded": "https://youtu.be/mHbx81EsEks"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29092848/308-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1963030"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MF Property Management"
+"CoListOfficeKey": "283412"
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-11-11T22:56:25.3Z"
+"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('29092848')"
+"ID": "411321"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23195
+post_id: "410739"
+post_author: 1
+"ListingKey": "29091589"
+"ListingId": "X12533072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-17T13:40:17Z"
+"RFModificationTimestamp": "2025-11-17T19:54:55Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y7"
+"UnparsedAddress": "502 MARINER DRIVE, Waterloo, Ontario N2K3Y7"
+"Coordinates": array:2 [
0 => -80.5077181
1 => 43.5046026
]
+"Latitude": 43.5046026
+"Longitude": -80.5077181
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Looking for a home in a great location? Welcome to Eastbridge, Waterloo! This freehold townhouse comes with no condo fees and has been fully renovated from top to bottom (October 2025). New flooring, fresh paint, modern light fixtures, a stunning white kitchen with quartz countertops, stainless steel appliances, and new vanities, toilets, and showers-this home feels brand new. With 3 bedrooms and 3 bathrooms, a bright main floor, sliding doors to the backyard, and a finished basement with gas fireplace and built-in wall unit, there's space for everyone. The basement even features a ceiling-mounted projector and screen-perfect for movie nights! Outside, enjoy driveway parking for two, an attached garage, a covered front porch, and a large partially fenced backyard. Located near parks, schools, Grey Silo Golf Course, and just minutes to Conestoga Mall and Hwy 7/8, this home combines modern comfort with a convenient, family-friendly location. Move-in ready and priced to sell-call your realtor to book your showing. This one won't last! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-11T21:48:08.811955+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145750"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "22 x 128.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-11T17:55:22Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-17T13:23:54Z"
+"Stories": "2.0"
+"StreetName": "Mariner"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3919.05"
+"VirtualTourURLUnbranded": "https://youriguide.com/502_mariner_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29091589/502-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2025-11-11T17:55:22.07Z"
+"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('29091589')"
+"ID": "410739"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24491
+post_id: "410319"
+post_author: 1
+"ListingKey": "29091146"
+"ListingId": "40784487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-16T21:45:27Z"
+"RFModificationTimestamp": "2025-11-18T01:27:11Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1570.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y7"
+"UnparsedAddress": "502 MARINER Drive, Waterloo, Ontario N2K3Y7"
+"Coordinates": array:2 [
0 => -80.5078461
1 => 43.5045833
]
+"Latitude": 43.5045833
+"Longitude": -80.5078461
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for a home in a great location? Welcome to Eastbridge, Waterloo! This freehold townhouse comes with no condo fees and has been fully renovated from top to bottom (October 2025). New flooring, fresh paint, modern light fixtures, a stunning white kitchen with quartz countertops, stainless steel appliances, and new vanities, toilets, and showers—this home feels brand new. With 3 bedrooms and 3 bathrooms, a bright main floor, sliding doors to the backyard, and a finished basement with gas fireplace and built-in wall unit, there’s space for everyone. The basement even features a ceiling-mounted projector and screen—perfect for movie nights! Outside, enjoy driveway parking for two, an attached garage, a covered front porch, and a large partially fenced backyard. Located near parks, schools, Grey Silo Golf Course, and just minutes to Conestoga Mall and Hwy 7/8, this home combines modern comfort with a convenient, family-friendly location. Move-in ready and priced to sell—call your realtor to book your showing. This one won’t last! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-11T19:03:38.239104+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1816506"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-11T16:42:00Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-16T21:32:52Z"
+"Stories": "2.0"
+"StreetName": "MARINER"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3919.05"
+"VirtualTourURLUnbranded": "https://youriguide.com/502_mariner_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29091146/502-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1272
+"BelowGradeFinishedArea": 298
+"OriginalEntryTimestamp": "2025-11-11T16:39:04.42Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29091146')"
+"ID": "410319"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24460
+post_id: "405759"
+post_author: 1
+"ListingKey": "29085999"
+"ListingId": "40785024"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T20:50:36Z"
+"RFModificationTimestamp": "2025-11-14T01:31:03Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 502, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.52225296
1 => 43.50965694
]
+"Latitude": 43.50965694
+"Longitude": -80.52225296
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condos – Modern Living in Waterloo’s Vibrant North End! Step into this bright and stylish corner suite offering 644 sq. ft. of open-concept living space plus a 67 sq. ft. balcony with treetop views over Colonial Acres. With three large windows filling the unit with natural light, this one-bedroom, one-bathroom condo is perfect for first-time buyers, investors, or those looking to downsize. Enjoy the best of urban convenience right outside your door — meet friends for dinner and drinks at Brown’s Socialhouse, treat yourself at Worthy & Co., or indulge in something sweet from Sweet & Savoury Pie Co. Walk to Conestoga Mall for everyday shopping, hop on the LRT to explore Uptown Waterloo, or spend a weekend browsing the St. Jacobs Market. Nearby recreation includes RIM Park and Grey Silo Golf Course. Blackstone Condos offers an impressive list of amenities: a fully equipped fitness centre, co-working space, event room, 24/7 security, bike room, and access to The Ro Courtyard — the perfect spot to relax and unwind. Discover the perfect blend of comfort, style, and convenience at Blackstone Condos — where modern living meets community charm. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "470"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-10T15:30:52.054336+00:00"
+"Directions": "Northfield Drive E, between Wissler Rd and Bridge Street."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-11-10T14:21:02Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-11T20:38:56Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3041"
+"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/29085999/247-northfield-drive-e-unit-502-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "MRU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-11-10T13:09:07.74Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29085999')"
+"ID": "405759"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 73
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]