array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30025674 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1619955"
+post_author: 1
+"ListingKey": "30025674"
+"ListingId": "X13556706"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:50:07Z"
+"RFModificationTimestamp": "2026-07-13T19:36:13Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3M6"
+"UnparsedAddress": "307 - 276 EIWO COURT, Waterloo, Ontario N2K3M6"
+"Coordinates": array:2 [
0 => -80.500815
1 => 43.494951
]
+"Latitude": 43.494951
+"Longitude": -80.500815
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious open-concept corner unit offering 939 sq. ft. in Waterloo's highly sought after Lexington neighbourhood. This well-maintained 2-bedroom condo features a functional layout with an updated washroom and a private terrace, providing comfortable living in a secure, professionally managed building. One surface parking space included. Prime location-just minutes to the University of Waterloo, Wilfrid Laurier University, Conestoga Mall, Bechtel Park, shopping, restaurants, transit, and quick access to Hwy 85-making daily commuting effortless. An excellent opportunity for first-time buyers, young professionals, or investors. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
]
+"AssociationFee": "605.38"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-13T19:36:06.012636+00:00"
+"Directions": "Cross Streets: Bridge St W to Dansbury Dr. ** Directions: DANSBURY/BRIDGE ST W BRIDGE ST W TO DANSBURY DR TO EIWO Crt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1883526"
+"ListOfficeKey": "90347"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:10Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T16:40:10Z"
+"StreetName": "Eiwo"
+"StreetNumber": "276"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "2812.98"
+"VirtualTourURLUnbranded": "https://mississaugavirtualtour.ca/UzMarch2026/March09UnbrandedC/"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1683154561"
"RoomType" => "Living room"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 4.48
"ListingKey" => "30025674"
"RoomLength" => 5.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
1 => array:11 [
"RoomKey" => "1683154562"
"RoomType" => "Dining room"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 4.48
"ListingKey" => "30025674"
"RoomLength" => 5.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
2 => array:11 [
"RoomKey" => "1683154563"
"RoomType" => "Kitchen"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "30025674"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
3 => array:11 [
"RoomKey" => "1683154564"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "30025674"
"RoomLength" => 4.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
4 => array:11 [
"RoomKey" => "1683154565"
"RoomType" => "Bedroom 2"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 2.48
"ListingKey" => "30025674"
"RoomLength" => 3.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
5 => array:11 [
"RoomKey" => "1683154566"
"RoomType" => "Bedroom 3"
"ListingId" => "X13556706"
"RoomLevel" => "Main level"
"RoomWidth" => 2.48
"ListingKey" => "30025674"
"RoomLength" => 3.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-13T16:40:10.81Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30025674/307-276-eiwo-court-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1926240"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard MGMT"
+"CoListOfficeKey": "252772"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-13T16:40:10.78Z"
+"ListAgentNationalAssociationId": "1222554"
+"ListOfficeNationalAssociationId": "1102684"
+"CoListAgentNationalAssociationId": "1229518"
+"CoListOfficeNationalAssociationId": "1207865"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30025674_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/f2982f034f7b9c53099ad7fb043e24e6.webp"
"MediaSize" => 396082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-f2982f034f7b9c53099ad7fb043e24e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30025674_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/46bf366f7f3cfe59ec1e80d2ab12f479.webp"
"MediaSize" => 358259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-46bf366f7f3cfe59ec1e80d2ab12f479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30025674_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/bad4e73befd82b16f4200f3d9f097008.webp"
"MediaSize" => 296698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-bad4e73befd82b16f4200f3d9f097008.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30025674_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/c267c380b47934624bb63fd833b40e0b.webp"
"MediaSize" => 187699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-c267c380b47934624bb63fd833b40e0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30025674_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/672e8aefa9f556598a14cddb5d006576.webp"
"MediaSize" => 132190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-672e8aefa9f556598a14cddb5d006576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30025674_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/87bdadb71b23c13e08b865493afdf41f.webp"
"MediaSize" => 126078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-87bdadb71b23c13e08b865493afdf41f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30025674_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/b4628c169502ab81bf1f21beb60fc5a3.webp"
"MediaSize" => 147742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-b4628c169502ab81bf1f21beb60fc5a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30025674_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/5d4b3912909bfb9893fea462db68e406.webp"
"MediaSize" => 140167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-5d4b3912909bfb9893fea462db68e406.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30025674_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/866e4cbf178a4a6269b258b3fd7ceb80.webp"
"MediaSize" => 156104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-866e4cbf178a4a6269b258b3fd7ceb80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30025674_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/7ad1508440564218699be13642c53a52.webp"
"MediaSize" => 170080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-7ad1508440564218699be13642c53a52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30025674_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/1f8ed30a72da33547454e928342f0fc7.webp"
"MediaSize" => 146284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-1f8ed30a72da33547454e928342f0fc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30025674_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/1137050085b6e17d935aa7577e1e2318.webp"
"MediaSize" => 177279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-1137050085b6e17d935aa7577e1e2318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30025674_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/166bbee251af6d13c2df94c2c82647e1.webp"
"MediaSize" => 185261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-166bbee251af6d13c2df94c2c82647e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30025674_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/42ca6f479e93a39a2d41b2a52ba28d7e.webp"
"MediaSize" => 132673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-42ca6f479e93a39a2d41b2a52ba28d7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30025674_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/460f3b0aa7c02b38297b6b12ad3af3ac.webp"
"MediaSize" => 166364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-460f3b0aa7c02b38297b6b12ad3af3ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30025674_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/871102072c160c118f0b705a6902832e.webp"
"MediaSize" => 168649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-871102072c160c118f0b705a6902832e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30025674_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/5d4b0018d1e9b6c34cf8151067340850.webp"
"MediaSize" => 145488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-5d4b0018d1e9b6c34cf8151067340850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30025674_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/0089d2ee71cc1dd80369bd511e5094d4.webp"
"MediaSize" => 168319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-0089d2ee71cc1dd80369bd511e5094d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30025674_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/d8d4448c7773292249727c76db2a34b2.webp"
"MediaSize" => 162370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-d8d4448c7773292249727c76db2a34b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30025674_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/9e22ce5a3eae9d2f1e44fb403450ea1c.webp"
"MediaSize" => 147410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-9e22ce5a3eae9d2f1e44fb403450ea1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30025674_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/435e6cc9902418139ef20017e248cb8e.webp"
"MediaSize" => 155030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-435e6cc9902418139ef20017e248cb8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30025674_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/e8bde89f06723f9de16fcd27f4bdfaf9.webp"
"MediaSize" => 142231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-e8bde89f06723f9de16fcd27f4bdfaf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30025674_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/f687080cf1a58a5b4f6a8d90368111a4.webp"
"MediaSize" => 145915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-f687080cf1a58a5b4f6a8d90368111a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30025674_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/34e1df1392806a12e83982344f3fb1b7.webp"
"MediaSize" => 162246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-34e1df1392806a12e83982344f3fb1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30025674_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/7a4cee620e35b80754eafc7bf452c23d.webp"
"MediaSize" => 142411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-7a4cee620e35b80754eafc7bf452c23d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30025674_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/bd37a2f4c5c4bb18230d863d80fa07c6.webp"
"MediaSize" => 119366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-bd37a2f4c5c4bb18230d863d80fa07c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30025674_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/b18d583f5d6534d829f35e61306c78f9.webp"
"MediaSize" => 122164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-b18d583f5d6534d829f35e61306c78f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30025674_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/d604c8d4a04a66e64b618953dbaba82c.webp"
"MediaSize" => 116321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-d604c8d4a04a66e64b618953dbaba82c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30025674_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/7515de3c76606fcc7338b3a67706989a.webp"
"MediaSize" => 121550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-7515de3c76606fcc7338b3a67706989a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30025674_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/4a146be3ac4a72dbd21fd67e94d99d5e.webp"
"MediaSize" => 127343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-4a146be3ac4a72dbd21fd67e94d99d5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30025674_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/76f5d2298fcb511015b1e6f6ef8a2d05.webp"
"MediaSize" => 109778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-76f5d2298fcb511015b1e6f6ef8a2d05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30025674_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/bd4a41a28a30e7e90e0a99f2eb5628b7.webp"
"MediaSize" => 130146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-bd4a41a28a30e7e90e0a99f2eb5628b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30025674_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/be871a71acb302bfedc6428eeba86179.webp"
"MediaSize" => 113911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-be871a71acb302bfedc6428eeba86179.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30025674_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/844adbadc8895d5b52c19e03e057159c.webp"
"MediaSize" => 110736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-844adbadc8895d5b52c19e03e057159c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30025674_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/e3a5738664b5095a669516872222f444.webp"
"MediaSize" => 104854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-e3a5738664b5095a669516872222f444.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30025674_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/11680704f6ac345af7209f8b4748b22f.webp"
"MediaSize" => 475538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-11680704f6ac345af7209f8b4748b22f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30025674_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/0acacd9a72fbb7aa82376e14593d1886.webp"
"MediaSize" => 416277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-0acacd9a72fbb7aa82376e14593d1886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30025674_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/d0b3654e5764b74449781437a03362d0.webp"
"MediaSize" => 360282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-d0b3654e5764b74449781437a03362d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30025674_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/e657f6755d92a001343c22d5d24334da.webp"
"MediaSize" => 245380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-e657f6755d92a001343c22d5d24334da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30025674_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/a90473bbf8988151a7f421ce60e0e192.webp"
"MediaSize" => 259501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-a90473bbf8988151a7f421ce60e0e192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30025674_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/5e48b3ba790416bfb5b80959023233f4.webp"
"MediaSize" => 150099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-5e48b3ba790416bfb5b80959023233f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30025674_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/220c4f0afe0e591f5e551c5923a8517a.webp"
"MediaSize" => 300518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-220c4f0afe0e591f5e551c5923a8517a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30025674_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30025674/f2edbfa845e8df53be76b3c1fb0e6585.webp"
"MediaSize" => 413107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30025674/thumbnail-f2edbfa845e8df53be76b3c1fb0e6585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13556706"
"ResourceRecordKey" => "30025674"
"ModificationTimestamp" => "2026-07-13T16:40:10.79Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025674')"
+"ID": "1619955"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 90347" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24992
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24936
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE TERREQUITY REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-812-9000"
+"OfficeMlsId": "45703"
+"ModificationTimestamp": "2026-02-06T22:33:31Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "90347"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2345 Argentia Road Unit 201B1"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5N8K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1102684"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-812-9609"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "455347"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "90347"
"SocialMediaUrlOrId" => "https://www.terrequity.com/"
"ModificationTimestamp" => "2026-01-15T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1047400"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('90347')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1883526" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24946
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30025674'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25295
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30025674' AND OpenHouseDate ge '2026-07-13'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25311
+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 '30025674' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.500815 43.494951)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25384
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1621852"
+post_author: 1
+"ListingKey": "30028703"
+"ListingId": "X13559256"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T00:45:06Z"
+"RFModificationTimestamp": "2026-07-14T01:37:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4K8"
+"UnparsedAddress": "511 DANSBURY DRIVE, Waterloo, Ontario N2K4K8"
+"Coordinates": array:2 [
0 => -80.4920582
1 => 43.4952294
]
+"Latitude": 43.4952294
+"Longitude": -80.4920582
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 511 Dansbury Drive - a beautifully maintained semi-detached home nestled in one of Waterloo's most family-friendly neighbourhoods. Located in the highly desirable Lexington Village area, this home offers the perfect blend of comfort, convenience, and community living. Imagine morning walks to nearby parks, children playing safely on quiet streets, and easy access to excellent schools, shopping, restaurants, transit, and Highway 85 for effortless commuting. Step inside to discover a bright and inviting interior designed for everyday living and memorable family moments. The spacious open-concept main floor features modern finishes, stylish updated flooring, large windows filled with natural light, and a beautifully refreshed kitchen with ample cabinetry and prep space - perfect for busy mornings, family dinners, and entertaining alike. Upstairs, generous bedrooms provide comfortable retreats for the whole family, while the finished lower level offers additional flexible living space ideal for a playroom, media area, home office, or gym. Outside, enjoy summer evenings on the private backyard deck beneath the pergola, with space for BBQs, outdoor dining, and children or pets to play. Whether you're a first-time buyer, young family, or someone looking to settle into an established Waterloo neighbourhood close to every amenity, 511 Dansbury Drive offers the lifestyle you've been waiting for - a place that truly feels like home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T01:37:03.783241+00:00"
+"Directions": "Cross Streets: Pastern Trail. ** Directions: University turn onto Pastern Trail, turn right onto Dansbury Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2242261"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.6 x 109.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T00:39:13Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T00:39:13Z"
+"Stories": "2.0"
+"StreetName": "Dansbury"
+"StreetNumber": "511"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4178"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/511-Dansbury-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1683575062"
"RoomType" => "Bathroom"
"ListingId" => "X13559256"
"RoomLevel" => "Main level"
"RoomWidth" => 1.37
"ListingKey" => "30028703"
"RoomLength" => 1.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
1 => array:11 [
"RoomKey" => "1683575063"
"RoomType" => "Laundry room"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 1.93
"ListingKey" => "30028703"
"RoomLength" => 1.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
2 => array:11 [
"RoomKey" => "1683575064"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13559256"
"RoomLevel" => "Basement"
"RoomWidth" => 5.36
"ListingKey" => "30028703"
"RoomLength" => 6.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
3 => array:11 [
"RoomKey" => "1683575065"
"RoomType" => "Dining room"
"ListingId" => "X13559256"
"RoomLevel" => "Main level"
"RoomWidth" => 2.24
"ListingKey" => "30028703"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
4 => array:11 [
"RoomKey" => "1683575066"
"RoomType" => "Foyer"
"ListingId" => "X13559256"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "30028703"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
5 => array:11 [
"RoomKey" => "1683575067"
"RoomType" => "Kitchen"
"ListingId" => "X13559256"
"RoomLevel" => "Main level"
"RoomWidth" => 2.51
"ListingKey" => "30028703"
"RoomLength" => 6.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.48Z"
]
6 => array:11 [
"RoomKey" => "1683575068"
"RoomType" => "Living room"
"ListingId" => "X13559256"
"RoomLevel" => "Main level"
"RoomWidth" => 4.34
"ListingKey" => "30028703"
"RoomLength" => 5.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
7 => array:11 [
"RoomKey" => "1683575069"
"RoomType" => "Bathroom"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 1.5
"ListingKey" => "30028703"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
8 => array:11 [
"RoomKey" => "1683575070"
"RoomType" => "Bathroom"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "30028703"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
9 => array:11 [
"RoomKey" => "1683575071"
"RoomType" => "Bedroom 2"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 2.95
"ListingKey" => "30028703"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
10 => array:11 [
"RoomKey" => "1683575072"
"RoomType" => "Bedroom 3"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 2.77
"ListingKey" => "30028703"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
11 => array:11 [
"RoomKey" => "1683575073"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13559256"
"RoomLevel" => "Second level"
"RoomWidth" => 4.42
"ListingKey" => "30028703"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T00:39:13.49Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30028703/511-dansbury-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-07-14T00:39:13.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1480350"
+"ListOfficeNationalAssociationId": "1438599"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30028703_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30028703/307e6f0f409e7bdce27b4808c594082c.webp"
"MediaSize" => 333635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30028703/thumbnail-307e6f0f409e7bdce27b4808c594082c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story Semi-detached residence."
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13559256"
"ResourceRecordKey" => "30028703"
"ModificationTimestamp" => "2026-07-14T00:39:13.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30028703_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30028703/42acb6fc9ab959e816e1109ebe69a558.webp"
"MediaSize" => 401878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30028703/thumbnail-42acb6fc9ab959e816e1109ebe69a558.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story Semi-detached residence."
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13559256"
"ResourceRecordKey" => "30028703"
"ModificationTimestamp" => "2026-07-14T00:39:13.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30028703_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30028703/1bae0599e1e17771aad963c966b75334.webp"
"MediaSize" => 336778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30028703/thumbnail-1bae0599e1e17771aad963c966b75334.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028703')"
+"ID": "1621852"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1621133"
+post_author: 1
+"ListingKey": "30028048"
+"ListingId": "40847508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T22:35:28Z"
+"RFModificationTimestamp": "2026-07-13T22:50:21Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1166.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 514, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5224991
1 => 43.4871183
]
+"Latitude": 43.4871183
+"Longitude": -80.5224991
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Atriums in Waterloo – a well-maintained and very clean condo building located at the end of a cul-de-sac and siding onto greenspace, walking trails and ponds. Unit 514 offers a pleasing layout with professionally and recently completed upgrades. The unit is carpet-free throughout with luxury vinyl flooring and new trim throughout the main living space (installed by Menno Martin, spring 2025). The spacious living/dining room is a great space for relaxing or entertaining. The gorgeous kitchen was updated by Cerwood and features quartz counters, under cabinet lighting, a great mix of drawers and cupboards (some with glass fronts), a large pantry and five newer appliances including an impressive side-by-side fridge/freezer (spring 2025). The living room and kitchen have floor to ceiling windows offering lots of natural light. There are motorized blinds on all the windows. The laundry/storage room has a newer stackable washer/dryer set. The primary bedroom offers double closets and a 4-pc ensuite with tub updated by bath-fitter. The second bedroom is on the opposite side of the unit with the second bathroom right beside it (features stylish step-in shower). This unit comes with one parking spot which is conveniently close to the door to the building, and an owned locker. The building offers many useful amenities: party room, library, workshop on the main level; roof-top deck and party room on the penthouse floor. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"AssociationFee": "709.97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T22:50:11.474265+00:00"
+"Directions": "KING ST N TO BLUE SPRINGS DR"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1645520"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Backs on greenbelt"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-13T22:28:53Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T22:28:53Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2621"
+"VirtualTourURLUnbranded": "https://youriguide.com/514_55_blue_springs_dr_waterloo_on/"
+"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/30028048/55-blue-springs-drive-unit-514-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1953029"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1166
+"OriginalEntryTimestamp": "2026-07-13T22:28:53.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1166103"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1246446"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028048')"
+"ID": "1621133"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1619189"
+post_author: 1
+"ListingKey": "30024748"
+"ListingId": "X13555482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T14:50:05Z"
+"RFModificationTimestamp": "2026-07-13T17:02:20Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2K3"
+"UnparsedAddress": "438 LEXINGTON ROAD, Waterloo, Ontario N2K2K3"
+"Coordinates": array:2 [
0 => -80.497895
1 => 43.503531
]
+"Latitude": 43.503531
+"Longitude": -80.497895
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**ABSOLUTELY GORGEOUS** 4 Bedroom (2+2) Detached RENOVATED Home With WALK-OUT Finished BASEMENT. Approx 3008 SQFT (Including Basement). Carpet FREE Throughout. SUN-Filled Natural Light PRACTICAL Floor Plan. DOUBLE Car Garage With Total 8-10 CAR Parking. Excellent OPPORTUNITY for All Kinds of Buyers. INVITING Spacious Front PORCH Entrance That Leads to LARGE FOYER With DOUBLE Closet & 2Pc POWDER Room. Main Floor W/HARDWOOD FLOORS. Spacious LIVING Room Features GAS Fireplace, POT LIGHTS & 2 LARGE Windows OVERLOOKING Front Yard. Separate DINING Room OVERLOOKING Lush Green Backyard. Well-Appointed UPGRADED KITCHEN Equipped w/STAINLESS STEEL Appliances, GRANITE Counters & Ample CABINETRY. Separate BREAKFAST Area Provides Comfortable Space for FAMILY Gatherings With WALKOUT To Backyard Deck. Main Floor ACCESS To GARAGE & Closet. Spacious PRIMARY Bedroom With BAY WINDOW, 3Pc ENSUITE & WALK-IN Closet. Generous Size 2nd Bedroom With LARGE Window. WALK-OUT Fully Finished BASEMENT. Huge FAMILY Room With GAS Fireplace, Pot Lights & WALK-OUT to Backyard. SPACIOUS Bedrooms 3 & 4 With CLOSET & Large WINDOWS. Family Size Secondary KITCHEN in Basement With QUARTZ Countertop & S/S APPLIANCES. Endless Possibilities for Rental INCOME, In-LAW Suite Or Setup As Home THEATRE With BUILT-IN Speakers & BAR, RECREATIONAL/Games/Play Room, Home OFFICE & Personal GYM. PROFESSIONALLY Landscaped BACKYARD OASIS Awaits, Providing a PRIVATE Retreat For Outdoor RELAXATION, Bbq & ENJOYMENT For The Whole FAMILY! Thoughtfully UPGRADED Home With Over $100K in Updates over the years: Triple-Pane Windows (23), Bathrooms (24), Water Softener (22), Basement Kitchen (20), Furnace & AC (19), Roof (17), Driveway (15) and More. Located In One Of The MOST SOUGHT-After NEIGHBOURHOODS, Minutes to UNIVERSITY of Waterloo, LAURIER, Top Schools, Conestoga MALL, RIM Park, TRAILS, Transit, Grand River & HIGHWAYS Access & More. Act NOW!!!!! Won't LAST!!! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:02:13.847266+00:00"
+"Directions": "University Ave/Lexington Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:3 [
0 => "Concrete"
1 => "Tile"
2 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1663559"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "79.1 x 153 FT ; 77.22 ftx152.96 ft x79.05 ft x 135.84 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T14:40:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T14:40:41Z"
+"Stories": "1.0"
+"StreetName": "Lexington"
+"StreetNumber": "438"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6562"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/467103"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30024748/438-lexington-road-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 79.1
+"OriginalEntryTimestamp": "2026-07-13T14:40:41.47Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1168505"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024748')"
+"ID": "1619189"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1618764"
+post_author: 1
+"ListingKey": "30023954"
+"ListingId": "40846724"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T11:55:14Z"
+"RFModificationTimestamp": "2026-07-13T14:01:31Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1899.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z3"
+"UnparsedAddress": "309 PASTERN Trail, Waterloo, Ontario N2K3Z3"
+"Coordinates": array:2 [
0 => -80.4905589
1 => 43.4919561
]
+"Latitude": 43.4919561
+"Longitude": -80.4905589
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Pride of ownership shines in this immaculate 3 bedroom 3 bathroom freehold townhome, lovingly maintained by the original owner for 30 years. The main floor features a bright, well-kept kitchen with included water purification system, updated luxury vinyl flooring throughout, and a walkout to a beautifully kept backyard. Upstairs offers three comfortable bedrooms and a renovated main bath. Major updates deliver peace of mind: new furnace and A/c 2026, most windows replaced, and a widened double driveway (2024) plus attached garage. Water softener and central vac included. Set in a family-friendly University Downs steps from schools, walking trails, and dog parks, with quick access to the expressway and universities. Turn-key homes in this condition and price bracket are rare, book your private showing today and make this home your own! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:01:24.249197+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1926813"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T11:48:24Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T11:48:24Z"
+"Stories": "2.0"
+"StreetName": "PASTERN"
+"StreetNumber": "309"
+"StreetSuffix": "Trail"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3918"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/309_pastern_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30023954/309-pastern-trail-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600707"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1365
+"BelowGradeFinishedArea": 534
+"OriginalEntryTimestamp": "2026-07-13T11:48:24.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1229829"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1149297"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023954')"
+"ID": "1618764"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1618739"
+post_author: 1
+"ListingKey": "30023962"
+"ListingId": "40842506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T12:00:37Z"
+"RFModificationTimestamp": "2026-07-13T14:00:14Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2998.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3E1"
+"UnparsedAddress": "323 AUBURN Drive, Waterloo, Ontario N2K3E1"
+"Coordinates": array:2 [
0 => -80.4958023
1 => 43.4940372
]
+"Latitude": 43.4940372
+"Longitude": -80.4958023
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPEN HOUSE | Saturday & Sunday | 2:00 PM – 4:00 PM 323 Auburn Drive, Waterloo, $799,900 Welcome to this spacious family home offering 2,990 sq. ft. of finished living space. Featuring 3 bedrooms, 3.5 bathrooms, and a fully finished basement. Metal roof, furnace and A/C 2025. most windows replaced in 2009 with additional windows updated in 2015, and a patio door replaced in 2002. Lovely family room with hardwood floors and a wood burning fireplace and sliders to back yard. Convenient main floor laundry. EV Charger in the garage. Downstairs, the finished basement offers exceptional flexibility with a wet bar, a full bathroom with shower, and a bonus office or craft room. With a full double garage, ample driveway parking, and endless potential to personalize, this solid home is ready for your decorating ideas and personal touch. A fantastic opportunity to create your dream home in a highly sought-after Waterloo community. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:00:09.508200+00:00"
+"Directions": "UNIVERSITY TO AUBURN DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750628"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T11:48:49Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T11:48:49Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "323"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "6244.66"
+"VirtualTourURLUnbranded": "https://youriguide.com/323_auburn_drive_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30023962/323-auburn-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563970"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1889
+"BelowGradeFinishedArea": 1109
+"OriginalEntryTimestamp": "2026-07-13T11:48:49.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1145790"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069862"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023962')"
+"ID": "1618739"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1617321"
+post_author: 1
+"ListingKey": "30022491"
+"ListingId": "X13553558"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T21:50:03Z"
+"RFModificationTimestamp": "2026-07-13T21:53:50Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2C9"
+"UnparsedAddress": "433A DUNVEGAN DRIVE, Waterloo, Ontario N2K2C9"
+"Coordinates": array:2 [
0 => -80.509848
1 => 43.494193
]
+"Latitude": 43.494193
+"Longitude": -80.509848
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover this beautifully updated freehold semi-detached home with NO condo fees in the highly sought-after Colonial Acres neighbourhood.Featuring 3 spacious bedrooms on the 2nd floor, and 1+1 bedroom in the newly finished basement with a separate walkout entrance, 2.5 bathrooms, 2 kitchens and a big backyard. This move-in-ready home is perfect for first-time buyers, growing families, or savvy investors.With major updates already completed-including the roof (2020), furnace (2022), and owned hotwater heater-plus a newly finished basement . This is an opportunity you won't want to miss! (id:62650)"
+"Appliances": array:4 [
0 => "Dryer"
1 => "Two Washers"
2 => "Water Heater"
3 => "Two Refrigerators"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T22:34:46.667700+00:00"
+"Directions": "Dunvegan Drive & Lexington Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129593"
+"ListOfficeKey": "268183"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "44.9 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T15:06:36Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T21:40:14Z"
+"Stories": "2.0"
+"StreetName": "Dunvegan"
+"StreetNumber": "433a"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3523.36"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30022491/433a-dunvegan-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 44.1
+"OriginalEntryTimestamp": "2026-07-11T21:38:51.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1382638"
+"ListOfficeNationalAssociationId": "1230066"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022491')"
+"ID": "1617321"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1617008"
+post_author: 1
+"ListingKey": "30022008"
+"ListingId": "40847294"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T17:25:15Z"
+"RFModificationTimestamp": "2026-07-11T18:52:42Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1776.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K0G4"
+"UnparsedAddress": "54 BRIDGE Street W Unit# 12, Kitchener, Ontario N2K0G4"
+"Coordinates": array:2 [
0 => -80.48539
1 => 43.4840641
]
+"Latitude": 43.4840641
+"Longitude": -80.48539
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into effortless living at 12-54 Bridge Street, a beautifully maintained main-floor condo offering 3 bedrooms, 2 full bathrooms, and 2 dedicated parking spaces. Combining modern finishes with a functional layout, this move-in-ready home delivers the perfect balance of comfort, style, and convenience. Ideally located on the Kitchener-Waterloo border, you'll enjoy easy access to schools, shopping, universities, parks, trails, the Grand River, and Highway 8, making it an excellent choice for commuters, families, and investors alike. As you enter, you're welcomed by a bright and inviting open-concept living and dining area featuring 9-foot ceilings, large picture windows, and an abundance of natural light. The thoughtfully designed floor plan creates an ideal space for both everyday living and entertaining. The spacious primary bedroom offers direct access to a private balcony—the perfect place to enjoy your morning coffee or unwind at the end of the day. Thoughtful upgrades throughout the home include stunning white kitchen, upgraded tiled bathrooms with glass shower, updated lighting, and modern fixtures. The primary suite serves as a peaceful retreat, complete with a walk-in closet and private ensuite bathroom. Two additional bedrooms provide flexibility for growing families, guests, a home office, or hobby space. Additional highlights include in-suite laundry, window coverings throughout, ample closet space, visitor parking, Parking spaces are roughed in for car charging, and a well-maintained interior that showcases pride of ownership. Whether you're looking for your first home, seeking a low-maintenance lifestyle, or adding to your investment portfolio, this exceptional property checks all the boxes. Simply move in, unpack, and enjoy everything this desirable community has to offer. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "712.12"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T18:52:42.012202+00:00"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040891"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-11T17:18:02Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T17:18:02Z"
+"Stories": "3.0"
+"StreetDirSuffix": "West"
+"StreetName": "BRIDGE"
+"StreetNumber": "54"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Bridgeport"
+"TaxAnnualAmount": "4138"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/54_bridge_st_w_12_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30022008/54-bridge-street-w-unit-12-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2020528"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1776
+"OriginalEntryTimestamp": "2026-07-11T17:18:02.51Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1316855"
+"ListOfficeNationalAssociationId": "1004370"
+"CoListAgentNationalAssociationId": "1300415"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022008')"
+"ID": "1617008"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+post_id: "1614624"
+post_author: 1
+"ListingKey": "30019555"
+"ListingId": "40846577"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T20:25:25Z"
+"RFModificationTimestamp": "2026-07-12T20:28:50Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2180.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4K7"
+"UnparsedAddress": "384 PASTERN Trail, Waterloo, Ontario N2K4K7"
+"Coordinates": array:2 [
0 => -80.4923673
1 => 43.4949436
]
+"Latitude": 43.4949436
+"Longitude": -80.4923673
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 384 Pastern Trail, a beautiful and spacious semi-detached home in one of Waterloo’s most convenient, family-friendly neighborhoods. This meticulously maintained property features a flexible 3 bedroom layout and 3 bathrooms, making it an ideal fit for growing families or first-time buyers. The main level boasts a bright, open-concept living area that flows into a classic kitchen with a functional island, modern tile flooring, and a dedicated dining nook. Large sliding doors lead out to a fully fenced, private backyard complete with a lush lawn and a handy garden shed. Upstairs offers three generous bedrooms, complemented by a versatile lower-level room perfect for a home office, play room or guest suite. Complete with a garage and private driveway for 2-car parking, this home is steps away from top-rated schools, parks, playgrounds, places of worship, excellent shopping, and public transit. Perfect comfort and convenience await! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T21:15:34.938290+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1898236"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T15:48:08Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T20:18:24Z"
+"Stories": "2.0"
+"StreetName": "PASTERN"
+"StreetNumber": "384"
+"StreetSuffix": "Trail"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3946.37"
+"VirtualTourURLUnbranded": "https://youriguide.com/384_pastern_trail_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/30019555/384-pastern-trail-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1485
+"BelowGradeFinishedArea": 695
+"OriginalEntryTimestamp": "2026-07-10T20:28:54.32Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215753"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019555')"
+"ID": "1614624"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: "1612757"
+post_author: 1
+"ListingKey": "30016701"
+"ListingId": "X13547996"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T17:15:05Z"
+"RFModificationTimestamp": "2026-07-12T17:19:26Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4K5"
+"UnparsedAddress": "402 PALAMINO PLACE, Waterloo, Ontario N2K4K5"
+"Coordinates": array:2 [
0 => -80.494802
1 => 43.497701
]
+"Latitude": 43.497701
+"Longitude": -80.494802
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in Lincoln Village West, one of Waterloo's most sought-after neighbourhoods, this well-cared-for home offers an exceptional blend of comfort, space, and convenience. Built in 2010 and ideally situated on a rare cul-de-sac, the location is truly second to none - just minutes from Wilfrid Laurier University, the University of Waterloo, Conestoga Mall, Grey Silo Golf Course, the Waterloo Recreation Complex, major highways, shopping, restaurants, coffee shops, and more. The main floor features a bright and spacious layout with 9-foot ceilings, beautiful front windows, and a well-appointed living and dining area. The entertainer's kitchen boasts a large island and opens to both the breakfast area and the spacious family room, which stretches across the back of the home and offers a walkout to the private backyard. A large laundry room and updated powder room complete the main level. Upstairs, the spacious primary suite features a large walk-in closet and a private ensuite. Three additional generously sized bedrooms, including two with walk-in closets, and a full bathroom complete the upper level. The home also includes a double-car garage and a double driveway with parking for up to four vehicles, plus the added benefit of no sidewalk to shovel in the winter. This is a wonderful opportunity to live in a thriving community that offers comfort, convenience, and the perfect place to create lasting memories. Pictures are Virtually Enhanced. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:17:28.457729+00:00"
+"Directions": "Cross Streets: University Ave E / Lexington Rd. ** Directions: SW of University Ave E / Lexington."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922046"
+"ListOfficeKey": "84902"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Irregular lot size"
2 => "Sump Pump"
]
+"LotSizeDimensions": "55.2 x 104.7 FT ; 42.98ft x 98.72ft x 55.26ft x 110.62ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T14:41:16Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T17:08:25Z"
+"Stories": "2.0"
+"StreetName": "Palamino"
+"StreetNumber": "402"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7824.46"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30016701/402-palamino-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 55.2
+"OriginalEntryTimestamp": "2026-07-10T14:41:16.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227342"
+"ListOfficeNationalAssociationId": "1145553"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30016701')"
+"ID": "1612757"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 97
+after_key: ""
}
"RF Response Time" => "0.36 seconds"
]
]