array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29725473 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1404735"
+post_author: 1
+"ListingKey": "29725473"
+"ListingId": "X13104832"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-25T22:30:16Z"
+"RFModificationTimestamp": "2026-05-25T22:36:24Z"
+"ListPrice": 485900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "17 - 250 KEATS WAY, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.543669
1 => 43.462848
]
+"Latitude": 43.462848
+"Longitude": -80.543669
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This upgraded 3+1 bedroom home is just a five-minute walk from the university and offers three washrooms, an attached garage, and a walkout basement leading to a paved patio. Located within a private courtyard of only four homes, the property also features a rough-in for a 220V car charger and an electric garage door opener with direct access into the house. The living room is enhanced with a gas fireplace, custom-built cabinets and bookshelves with accent lighting, hardwood flooring, crown moldings, custom baseboards and door casings, and a patio door opening onto a new deck. The kitchen features new flooring, a large window, ceiling fan, and an open-concept view through the living and dining areas. Upstairs, a hardwood hallway leads to the primary bedroom, complete with hardwood flooring, triple mirrored closets, double-aspect windows, and direct access to the family bathroom. Two additional bedrooms feature vinyl flooring, double closets, and ceiling fans. The condo corporation is also planning to install new front and garage doors in the near future. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-09T02:00:33.292375+00:00"
+"Directions": "University & Keats Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423969"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Ravine"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-08T20:53:14Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-25T22:23:45Z"
+"Stories": "3.0"
+"StreetName": "Keats"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4151.2"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1643926354"
"RoomType" => "Living room"
"ListingId" => "X13104832"
"RoomLevel" => "Ground level"
"RoomWidth" => 5.64
"ListingKey" => "29725473"
"RoomLength" => 6.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
1 => array:11 [
"RoomKey" => "1643926355"
"RoomType" => "Dining room"
"ListingId" => "X13104832"
"RoomLevel" => "Ground level"
"RoomWidth" => 5.64
"ListingKey" => "29725473"
"RoomLength" => 6.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
2 => array:11 [
"RoomKey" => "1643926356"
"RoomType" => "Kitchen"
"ListingId" => "X13104832"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.51
"ListingKey" => "29725473"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
3 => array:11 [
"RoomKey" => "1643926357"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13104832"
"RoomLevel" => "Second level"
"RoomWidth" => 3.89
"ListingKey" => "29725473"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
4 => array:11 [
"RoomKey" => "1643926358"
"RoomType" => "Bedroom 2"
"ListingId" => "X13104832"
"RoomLevel" => "Second level"
"RoomWidth" => 3.99
"ListingKey" => "29725473"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
5 => array:11 [
"RoomKey" => "1643926359"
"RoomType" => "Bedroom 3"
"ListingId" => "X13104832"
"RoomLevel" => "Second level"
"RoomWidth" => 2.81
"ListingKey" => "29725473"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
6 => array:11 [
"RoomKey" => "1643926360"
"RoomType" => "Bedroom"
"ListingId" => "X13104832"
"RoomLevel" => "Basement"
"RoomWidth" => 4.11
"ListingKey" => "29725473"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
7 => array:11 [
"RoomKey" => "1643926361"
"RoomType" => "Utility room"
"ListingId" => "X13104832"
"RoomLevel" => "Basement"
"RoomWidth" => 3.2
"ListingKey" => "29725473"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T22:23:45.17Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29725473/17-250-keats-way-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
2 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-05-08T20:53:14.27Z"
+"ListAgentNationalAssociationId": "1062946"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29725473_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/52eaa37fb72b100c6debeef888844056.webp"
"MediaSize" => 324240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-52eaa37fb72b100c6debeef888844056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29725473_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/0bcd9bb5bea8b389af1a2bc5f4122e92.webp"
"MediaSize" => 384230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-0bcd9bb5bea8b389af1a2bc5f4122e92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29725473_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/2f7e3fb3d84fbdfba51b2c97cf0b7fe5.webp"
"MediaSize" => 232342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-2f7e3fb3d84fbdfba51b2c97cf0b7fe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29725473_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/01fe2daba052ee04d65d12a862954eed.webp"
"MediaSize" => 303132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-01fe2daba052ee04d65d12a862954eed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29725473_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/6eddc1f45c63cbaa52da58a87a197e7e.webp"
"MediaSize" => 276790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-6eddc1f45c63cbaa52da58a87a197e7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29725473_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/030a10b31c03eb1ae01c77cc2b003f63.webp"
"MediaSize" => 158355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-030a10b31c03eb1ae01c77cc2b003f63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29725473_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/1d6d8156694f5a36f81daaaa0e5dfa43.webp"
"MediaSize" => 176263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-1d6d8156694f5a36f81daaaa0e5dfa43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29725473_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/5c39083c73b0d3a05d41b01bb4f8a67c.webp"
"MediaSize" => 163951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-5c39083c73b0d3a05d41b01bb4f8a67c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29725473_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/f346fe4a1cad404fb5fa8cdb9fe22ba2.webp"
"MediaSize" => 197120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-f346fe4a1cad404fb5fa8cdb9fe22ba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29725473_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/721753bb837348725b56d132eb7f0b2b.webp"
"MediaSize" => 256566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-721753bb837348725b56d132eb7f0b2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29725473_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/dec3c1a376408481436c5071dc94915a.webp"
"MediaSize" => 98310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-dec3c1a376408481436c5071dc94915a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29725473_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/9546c0561607d94b3adfd5070d8d82c0.webp"
"MediaSize" => 143600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-9546c0561607d94b3adfd5070d8d82c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29725473_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/a010f7b4bf670b38906480972feeb5c0.webp"
"MediaSize" => 231197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-a010f7b4bf670b38906480972feeb5c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29725473_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/991edbf19a4f2f0e72a7481b5e08a90f.webp"
"MediaSize" => 190962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-991edbf19a4f2f0e72a7481b5e08a90f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29725473_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/9c3d864b9ea8c02e27dc29da3c231dcc.webp"
"MediaSize" => 232896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-9c3d864b9ea8c02e27dc29da3c231dcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29725473_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/632c0fb7331b576e6b77fea04b34abd4.webp"
"MediaSize" => 152242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-632c0fb7331b576e6b77fea04b34abd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29725473_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/99abe428e266748557aa590a6ce8fb1e.webp"
"MediaSize" => 137903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-99abe428e266748557aa590a6ce8fb1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29725473_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/1464c18c9c238ce701ca44c65c211425.webp"
"MediaSize" => 187919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-1464c18c9c238ce701ca44c65c211425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29725473_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/d2137e11b54531d4eabdd4ba055e993f.webp"
"MediaSize" => 179569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-d2137e11b54531d4eabdd4ba055e993f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29725473_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/86e80700b56a88acbbbb8dd1a63594b9.webp"
"MediaSize" => 166998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-86e80700b56a88acbbbb8dd1a63594b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29725473_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/91cb309acc04dc2abfd4e05ed3d24884.webp"
"MediaSize" => 143157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-91cb309acc04dc2abfd4e05ed3d24884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29725473_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/c885fbb95ddf32f8c3e72e407313b5f9.webp"
"MediaSize" => 172331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-c885fbb95ddf32f8c3e72e407313b5f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29725473_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/c257e40e8ec122f44ff8d86d37e14cb7.webp"
"MediaSize" => 146497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-c257e40e8ec122f44ff8d86d37e14cb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29725473_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/46ed49b4d255c366fb35ee297c2a8e9b.webp"
"MediaSize" => 148385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-46ed49b4d255c366fb35ee297c2a8e9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29725473_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/12eb4fa85a98e1c1d170af787e997c3d.webp"
"MediaSize" => 194948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-12eb4fa85a98e1c1d170af787e997c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29725473_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/cd3ce4b3da197fa43a574868f949dec0.webp"
"MediaSize" => 191313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-cd3ce4b3da197fa43a574868f949dec0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29725473_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/5aae22129a906d532bb2781bb745dd63.webp"
"MediaSize" => 336410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-5aae22129a906d532bb2781bb745dd63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29725473_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/755cf19b8e6a9dbbcd56234f1fb40dc6.webp"
"MediaSize" => 95169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-755cf19b8e6a9dbbcd56234f1fb40dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29725473_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/974a9c4217de46ed66ac1bcbd423f67e.webp"
"MediaSize" => 148555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-974a9c4217de46ed66ac1bcbd423f67e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29725473_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/f15402047a5489f7a9b52cbc917a777b.webp"
"MediaSize" => 257295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-f15402047a5489f7a9b52cbc917a777b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29725473_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/8d67b689d6d694c1ee62a6fc8402e13d.webp"
"MediaSize" => 442879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-8d67b689d6d694c1ee62a6fc8402e13d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29725473_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/34a03c910e75ddc2290ee8f23055bb06.webp"
"MediaSize" => 412026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-34a03c910e75ddc2290ee8f23055bb06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29725473_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/19dea0c5e49137e64a2b0116fe674df3.webp"
"MediaSize" => 461110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-19dea0c5e49137e64a2b0116fe674df3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29725473_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29725473/67a45122bbc1ca63c7e3dff47f300fc4.webp"
"MediaSize" => 466225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29725473/thumbnail-67a45122bbc1ca63c7e3dff47f300fc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13104832"
"ResourceRecordKey" => "29725473"
"ModificationTimestamp" => "2026-05-08T20:53:14.27Z"
]
]
+"DaysOnMarket": 52
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29725473')"
+"ID": "1404735"
}
]
+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=OfficeMlsId eq 238732" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24853
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1423969" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24951
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24844
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "1423969"
+"ModificationTimestamp": "2025-05-31T12:22:50Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "1423969"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('1423969')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29725473'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25242
+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 '29725473'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25332
+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 '29725473' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.543669 43.462848)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1579629"
+post_author: 1
+"ListingKey": "29971291"
+"ListingId": "X13505422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:26Z"
+"RFModificationTimestamp": "2026-06-30T18:22:53Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G104 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.531342
1 => 43.477165
]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover exceptional value in this beautifully maintained 2-bedroom, 1-bathroom condominium located in Waterloo's highly desirable University District. Offering approximately 762 sq. ft. of thoughtfully designed living space, this bright and inviting unit features a practical layout that is ideal for both owner-occupiers and investors.Positioned within walking distance of the University of Waterloo, Wilfrid Laurier University, Conestoga College, the ION LRT, shopping, dining, parks, and everyday amenities, this location provides unmatched convenience and strong rental demand.Being sold fully furnished, the condo is ready for immediate use with minimal effort. The property is currently occupied by long-term tenants, presenting an excellent opportunity for buyers looking to generate rental income from day one while benefiting from continued leasing potential. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "344"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:20:48.259501+00:00"
+"Directions": "Hickory St W & Hemlock St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141272"
+"ListOfficeKey": "296550"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T17:16:20Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:16:20Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2581.45"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1672010417"
"RoomType" => "Living room"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.83
"ListingKey" => "29971291"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
1 => array:11 [
"RoomKey" => "1672010418"
"RoomType" => "Kitchen"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.83
"ListingKey" => "29971291"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
2 => array:11 [
"RoomKey" => "1672010419"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.76
"ListingKey" => "29971291"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
3 => array:11 [
"RoomKey" => "1672010420"
"RoomType" => "Bedroom 2"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.94
"ListingKey" => "29971291"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
4 => array:11 [
"RoomKey" => "1672010421"
"RoomType" => "Bathroom"
"ListingId" => "X13505422"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29971291"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:20.9Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29971291/g104-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blackline Management Services"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-30T17:16:20.88Z"
+"ListAgentNationalAssociationId": "1393034"
+"ListOfficeNationalAssociationId": "1459693"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29971291_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/2b8d4ab1fa4874a5a42c527c967a41e6.webp"
"MediaSize" => 302661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-2b8d4ab1fa4874a5a42c527c967a41e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29971291_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/c0b88b1d4de5851965535d8a9837f47d.webp"
"MediaSize" => 316881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-c0b88b1d4de5851965535d8a9837f47d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29971291_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/fdfb8963afe89fc576ed3fb5e0a8acdc.webp"
"MediaSize" => 330308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-fdfb8963afe89fc576ed3fb5e0a8acdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29971291_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/371ffb4ffd7de985ab199f1b3b6aa4a5.webp"
"MediaSize" => 323199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-371ffb4ffd7de985ab199f1b3b6aa4a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29971291_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d54bf654c6013e76bed5e6c26ecb9284.webp"
"MediaSize" => 360141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d54bf654c6013e76bed5e6c26ecb9284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29971291_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/e3fe501484562c589d0e6e602f9144f0.webp"
"MediaSize" => 326822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-e3fe501484562c589d0e6e602f9144f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29971291_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/9e80c178ebd352c11d2f98673c771501.webp"
"MediaSize" => 321851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-9e80c178ebd352c11d2f98673c771501.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29971291_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/8b22c8763036b6ba75dc8a79f2e5e126.webp"
"MediaSize" => 329729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-8b22c8763036b6ba75dc8a79f2e5e126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29971291_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/e83866530dfdb35466e0f1025d7ae7ad.webp"
"MediaSize" => 337196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-e83866530dfdb35466e0f1025d7ae7ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29971291_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/1b9cb35c00cdfb8cc77c98de2d99ab45.webp"
"MediaSize" => 349380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-1b9cb35c00cdfb8cc77c98de2d99ab45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29971291_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/74faf7aec952ec386ba09bf8732f9332.webp"
"MediaSize" => 350550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-74faf7aec952ec386ba09bf8732f9332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29971291_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/f3f2f77c4607d6318e1a071c20057367.webp"
"MediaSize" => 362306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-f3f2f77c4607d6318e1a071c20057367.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29971291_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/96d5139bd09ed5179d65e03163eb5bc6.webp"
"MediaSize" => 360813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-96d5139bd09ed5179d65e03163eb5bc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29971291_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/0e21c952665bd689bcd3f75490b91d4e.webp"
"MediaSize" => 346535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-0e21c952665bd689bcd3f75490b91d4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29971291_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/607aa6fc4fea41c5243a333056d5b7a0.webp"
"MediaSize" => 93803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-607aa6fc4fea41c5243a333056d5b7a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29971291_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/90fa8d1e663c6953c0a2159bc338f47a.webp"
"MediaSize" => 64599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-90fa8d1e663c6953c0a2159bc338f47a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29971291_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d1267444d691a7e46206b32da5b4f1fa.webp"
"MediaSize" => 113348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d1267444d691a7e46206b32da5b4f1fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29971291_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/2caf3d3a923e0d4f7ad6e086e81ea7c4.webp"
"MediaSize" => 102207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-2caf3d3a923e0d4f7ad6e086e81ea7c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29971291_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/d3fe63d3efd8d86f8b8f4f9953f8c1ee.webp"
"MediaSize" => 122085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-d3fe63d3efd8d86f8b8f4f9953f8c1ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29971291_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/5e4e0d5d738d319746eee4aeb8386a33.webp"
"MediaSize" => 117290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-5e4e0d5d738d319746eee4aeb8386a33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29971291_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/5d01057332ee710011136fe531f47cd2.webp"
"MediaSize" => 137628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-5d01057332ee710011136fe531f47cd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29971291_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/4d7df7d8a9896967f8ea1992b06352a8.webp"
"MediaSize" => 148573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-4d7df7d8a9896967f8ea1992b06352a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29971291_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/a927c801ba052dd9ec801c1b20c8ef16.webp"
"MediaSize" => 141891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-a927c801ba052dd9ec801c1b20c8ef16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29971291_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/82069a4a8d17635b1002dc57dcd53733.webp"
"MediaSize" => 112055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-82069a4a8d17635b1002dc57dcd53733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29971291_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/b44b503d63f75255da851423005b8b01.webp"
"MediaSize" => 141331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-b44b503d63f75255da851423005b8b01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29971291_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971291/ce7f06482fcd557930ad4668fb6bdb5c.webp"
"MediaSize" => 109332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971291/thumbnail-ce7f06482fcd557930ad4668fb6bdb5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505422"
"ResourceRecordKey" => "29971291"
"ModificationTimestamp" => "2026-06-30T17:16:20.88Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29971291_4890_27"
…11
]
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('29971291')"
+"ID": "1579629"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1578689"
+post_author: 1
+"ListingKey": "29970323"
+"ListingId": "X13504430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3 Bdr Unit Offers Large Windows, Lots Of Natural Light,9 Ft Ceilings, Custom Kitchen Cabinetry, Fully furnished Appliance, Ensuite Laundry (brand new),3 Great Size Bdrms & 2 FullBaths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "812.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.712374+00:00"
+"Directions": "King St N/ University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:26Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:26Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5127.5"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970323/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-30T15:16:26.76Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970323')"
+"ID": "1578689"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: "1576006"
+post_author: 1
+"ListingKey": "29967155"
+"ListingId": "40843458"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:08Z"
+"RFModificationTimestamp": "2026-06-29T19:38:50Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.196
+"LivingArea": 2254.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1L1"
+"UnparsedAddress": "200 MACDONALD Place, Waterloo, Ontario N2L1L1"
+"Coordinates": array:2 [
0 => -80.5336085
1 => 43.45156
]
+"Latitude": 43.45156
+"Longitude": -80.5336085
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Westmount welcomes you to the established, quiet court of MacDonald Place. If the time is right to downsize then this gorgeous ranch style home will be of interest. Attractive curb appeal with no sidewalks. Wide covered front porch is ready for evening chats with a glass of wine. The aggregate driveway leads to a double car garage with finished interior & roughed-in EV charger. Renovated extensively to high standards in 2013 and very well maintained by present owner. An open concept interior with vaulted ceilings are highlighted with numerous pot lights plus windows for natural light. Walkouts to two decks with a rear stone patio waiting for you to relax in the privacy of your lushly landscaped low maintenance fenced yard. Brazilian cherry hardwood floors & tile make for a carpet free main floor. You can have one level living with two bedrooms, two bathrooms, and stackable laundry all on the main level. Fabulous kitchen with gas stove & stainless appliances, centre island with bar sink & wine racks, plus thick granite counters with breakfast bar seating at the end. The Dining room has an open flow to the Living room featuring a gas fireplace accented with custom cabinets & wall mounted TV. The primary bedroom fits a king size bed, has an inverted tray ceiling, his & her closets, luxury 5 pc ensuite with walk-in shower, jet tub & double vanities plus additional storage cabinetry. The second bedroom is presently being used as an office but has a walk-in closet for use as a bedroom. The lower level is equally spacious with an office/guest room, 3 pc bathroom, Rec room/gym area plus unfinished storage & utility room. Be over to the Private Westmount Golf & Country Club within minutes where year round activities include golf, curling, & tennis in an engaging social atmosphere. Belmont Village & two Universities beckon minutes away. You can bike & walk the Iron Horse Trail from Waterloo to Kitchener or catch the ION light rail routes to explore further. August closing! (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Garburator"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T19:38:45.112482+00:00"
+"Directions": "Westmount Road South to Forsyth Drive, left on Stanley Drive, left on MacDonald Place"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.196"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T18:50:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:50:44Z"
+"Stories": "1.0"
+"StreetName": "MACDONALD"
+"StreetNumber": "200"
+"StreetSuffix": "Place"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "9080.53"
+"VirtualTourURLUnbranded": "https://youriguide.com/200_macdonald_place_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/29967155/200-macdonald-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 110.0
+"AboveGradeFinishedArea": 1707
+"BelowGradeFinishedArea": 547
+"OriginalEntryTimestamp": "2026-06-29T18:50:44.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967155')"
+"ID": "1576006"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1576317"
+post_author: 1
+"ListingKey": "29966442"
+"ListingId": "40836179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:17Z"
+"ListPrice": 1470000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2663.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2S8"
+"UnparsedAddress": "294 ALGONQUIN Drive, Waterloo, Ontario N2L2S8"
+"Coordinates": array:2 [
0 => -80.5462881
1 => 43.4644504
]
+"Latitude": 43.4644504
+"Longitude": -80.5462881
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Architecturally Distinct Mid-Century Bungalow in Prestigious Beechwood. A rare opportunity to own a truly unique home in one of Waterloo's most sought-after neighbourhoods. Nestled within a private wooded enclave, this architecturally significant mid-century executive bungalow offers over 2,650 sq. ft. of thoughtfully designed living space and an exceptional connection to nature. Step inside and be captivated by soaring floor-to-ceiling windows that frame private views and fill the home with natural light. The spacious main level is designed for both everyday living and entertaining, featuring expansive principal rooms, a welcoming living and dining area with a striking double-sided fireplace, and multiple spaces to gather with family and friends. The lower level offers incredible flexibility with a walkout to the backyard, a large family room, two additional bedrooms or office, a full bathroom, and direct access to the garage—ideal for multi-generational living, guests, or a future in-law setup. Outside, enjoy your own private backyard retreat surrounded by mature trees, offering peace, privacy, and endless potential to create your dream outdoor oasis. Updates include windows, roof, hot water tank and boiler, electrical service, extensive landscaping. While some cosmetic updating may be desired, the home presents an outstanding opportunity to personalize a property with exceptional character in an unbeatable location. Virtual staging has been provided to show decorating potential. Situated just minutes from the University of Waterloo, top-rated schools, parks, trails, shopping, and amenities, this is a location rarely offered and highly coveted. Bring your vision and imagination or just move in—this remarkable Beechwood property is ready to become your forever home. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Sauna"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-06-29T18:49:12.869016+00:00"
+"Directions": "Westmount Rd to Longfellow Dr. to Iroquois Pl. to Algonquin Dr."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Boiler"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996603"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Ravine"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:33:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:33:05Z"
+"Stories": "1.0"
+"StreetName": "ALGONQUIN"
+"StreetNumber": "294"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7014"
+"VirtualTourURLUnbranded": "https://youriguide.com/7ypyq_294_algonquin_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966442/294-algonquin-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 1011
+"OriginalEntryTimestamp": "2026-06-29T17:33:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279276"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966442')"
+"ID": "1576317"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1571971"
+post_author: 1
+"ListingKey": "29961135"
+"ListingId": "X13496232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T22:25:18Z"
+"RFModificationTimestamp": "2026-06-26T23:39:42Z"
+"ListPrice": 354000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "618 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 618 at Sage 5, a rare opportunity to own a bright 1-bedroom, 1-bathroom suite featuring floor-to-ceiling windows, unobstructed green views, and abundant natural light throughout. Occupied by only two residents since construction and exceptionally well maintained, this carpet-free home offers a functional layout with a spacious bedroom, large granite kitchen island, stainless steel appliances, and ensuite laundry. Enjoy the spacious balcony, accessible from both the living room and bedroom, overlooking peaceful greenery. Offered fully furnished, this move-in ready unit provides added convenience for both end-users and investors. Residents enjoy excellent amenities including a rooftop terrace, theatre room, fitness centre, student lounge, and study spaces. Ideally located in the heart of Waterloo's university district, just steps from the University of Waterloo, Wilfrid Laurier University, Waterloo Collegiate Institute, shopping, restaurants, and public transit. Condo fees include heat, , A/C, water, and high-speed internet. Ideal for parents, first-time buyers, and investors. Book your showing today! (id:62783)"
+"AssociationFee": "399.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:39:32.064487+00:00"
+"Directions": "Cross Streets: Lester St & Hickory St. ** Directions: University Ave West to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T22:20:07Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T22:20:07Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961135/618-280-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Mgmt"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-26T22:20:07.24Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961135')"
+"ID": "1571971"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1570278"
+post_author: 1
+"ListingKey": "29958902"
+"ListingId": "X13494404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:35:48Z"
+"RFModificationTimestamp": "2026-06-26T18:22:55Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "103 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Furniture"
5 => "Water Heater"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:22:49.894189+00:00"
+"Directions": "Cross Streets: Albert And Hickory. ** Directions: Bridgeport Rd E To Albert Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T17:20:42Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:20:42Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958902/103-253-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T17:20:42.81Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958902')"
+"ID": "1570278"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1570279"
+post_author: 1
+"ListingKey": "29958394"
+"ListingId": "40843131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:40:10Z"
+"RFModificationTimestamp": "2026-06-26T18:12:38Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 734.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G3"
+"UnparsedAddress": "253 ALBERT Street Unit# 103, Waterloo, Ontario N2L0G3"
+"Coordinates": array:2 [
0 => -80.5334114
1 => 43.4754303
]
+"Latitude": 43.4754303
+"Longitude": -80.5334114
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:12:19.049966+00:00"
+"Directions": "Bridgeport Rd E To Albert Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-26T16:32:51Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:32:51Z"
+"Stories": "1.0"
+"StreetName": "ALBERT"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29958394/253-albert-street-unit-103-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 734
+"OriginalEntryTimestamp": "2026-06-26T16:32:51.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958394')"
+"ID": "1570279"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1566543"
+post_author: 1
+"ListingKey": "29945902"
+"ListingId": "40842169"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T17:40:35Z"
+"RFModificationTimestamp": "2026-06-28T17:44:24Z"
+"ListPrice": 1925000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4223.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1A1"
+"UnparsedAddress": "203 FORSYTH Drive, Waterloo, Ontario N2L1A1"
+"Coordinates": array:2 [
0 => -80.5292292
1 => 43.4522978
]
+"Latitude": 43.4522978
+"Longitude": -80.5292292
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The perfect home in the perfect neighbourhood. Just steps from Westmount Golf & Country Club, this fully renovated 4-bedroom, 4-bathroom home offers turnkey living in Waterloo’s prestigious Westmount neighbourhood. At its heart is a stunning eat-in kitchen with a large island, flowing seamlessly into the dining area and adjacent wet bar, ideal for everyday living and entertaining. The sunken living room features vaulted ceilings, custom built-ins, and a fully retractable three-panel sliding door that opens to the home’s standout feature: the Cottage room. This four-season retreat includes heated floors, retractable screened windows, and a wood-burning fireplace for year-round comfort and enjoyment. The main floor also offers a spacious mudroom, full bathroom, and versatile fourth bedroom, perfect for guests, extended family, or a home office. Upstairs, the primary suite provides a private escape with a spa-inspired bathroom. Two additional bedrooms feature imaginative built-in “tree forts” and connected closet pass-throughs that kids will love. The finished lower level adds a two-piece bathroom, separate recreation and games areas, and a full-height fitness room. With extensive updates, timeless design, and an unrivalled location near Westmount Golf & Country Club, this is a rare opportunity to own a truly unique family home in one of Waterloo’s most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:38:47.375647+00:00"
+"Directions": "Forsyth off Westmount"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Hardboard"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239753"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:12:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T17:20:55Z"
+"Stories": "2.0"
+"StreetName": "FORSYTH"
+"StreetNumber": "203"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "9617"
+"VirtualTourURLUnbranded": "https://youriguide.com/0emk4_203_forsyth_dr_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/29945902/203-forsyth-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 2898
+"BelowGradeFinishedArea": 1325
+"OriginalEntryTimestamp": "2026-06-24T13:30:42.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1477702"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945902')"
+"ID": "1566543"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1564961"
+post_author: 1
+"ListingKey": "29948377"
+"ListingId": "X13484680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:49:29Z"
+"ListPrice": 469000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "611 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stylish suite for two offers modern finishes and a bright open-concept layout, ideally located just minutes from the University of Waterloo and Laurier University. Residents enjoy exceptional amenities, including concierge service, a fully equipped fitness centre, sauna, games room, private theatre, and study lounges. Perfect for students, young professionals, or investors seeking a blend of convenience, comfort, and upscale living. The unit also includes one parking space. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "342.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:52.091411+00:00"
+"Directions": "Columbia St, Phillip St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1594283"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Partially cleared"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:16Z"
+"PhotosCount": 11
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:05Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2646.96"
+"View": "View"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948377/611-145-columbia-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-24T18:56:16.35Z"
+"ListAgentNationalAssociationId": "1155343"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948377')"
+"ID": "1564961"
}
]
+success: true
+page_size: 9
+page_count: 40
+count: 358
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]