array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29240774/Property?$select=ALL&$top=20&$filter=ListingKey eq 29240774&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29240774/Property?$select=ALL&$top=20&$filter=ListingKey eq 29240774&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "527230"
+post_author: 1
+"ListingKey": "29240774"
+"ListingId": "X12687042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T17:50:23Z"
+"RFModificationTimestamp": "2026-01-12T18:03:25Z"
+"ListPrice": 315000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "217 - 257 HEMLOCK STREET, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.532334
1 => 43.475918
]
+"Latitude": 43.475918
+"Longitude": -80.532334
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to contemporary condo living in the heart of Waterloo-vacant and ready for you to move right in. Just steps from the University of Waterloo, Wilfrid Laurier University, shopping, and dining, this unbeatable location offers convenience at every turn. Inside, the open-concept layout is designed for modern comfort, featuring a sleek kitchen with stainless steel appliances, granite countertops, and plenty of cabinet space. Floor-to-ceiling windows fill the home with natural light, creating a bright and inviting atmosphere. Enjoy a morning coffee or unwind at the end of the day on the large private balcony, where you can take in vibrant city views. The unit comes fully furnished and includes in-suite laundry, making the move-in process effortless. Residents also have access to exceptional building amenities, including a fitness center, study area, lounge, and a rooftop terrace. Whether you're looking for a stylish place to call home or a smart investment opportunity, this condo is an excellent choice. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
]
+"AssociationFee": "430.48"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T18:03:07.763631+00:00"
+"Directions": "Cross Streets: University and Hemlock. ** Directions: University Ave to Hemlock."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T17:43:20Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T17:43:19Z"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2699"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29240774/217-257-hemlock-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-12T17:43:19.91Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:28 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6401702530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/fd0920726562612eb44aab81605e11df.webp"
"MediaSize" => 106878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-fd0920726562612eb44aab81605e11df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6401702549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/cd9c5ba1fafd590c4ccefd8a426f4e6a.webp"
"MediaSize" => 136205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-cd9c5ba1fafd590c4ccefd8a426f4e6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6401702560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/915af73eca10414a62356c8811bf2b04.webp"
"MediaSize" => 148736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-915af73eca10414a62356c8811bf2b04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6401702642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/4cde7af69022b37363195de95efc95eb.webp"
"MediaSize" => 147158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-4cde7af69022b37363195de95efc95eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6401702677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/47c0840e8edc20214d1f4f87c44b6a61.webp"
"MediaSize" => 141948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-47c0840e8edc20214d1f4f87c44b6a61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6401702725"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/69e7d49a4925be0f58036f5f31605288.webp"
"MediaSize" => 98328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-69e7d49a4925be0f58036f5f31605288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6401702773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/83a0e65f69e1a89e4d2f9e5b5f201c2a.webp"
"MediaSize" => 80625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-83a0e65f69e1a89e4d2f9e5b5f201c2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6401702813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/9952c6e98170fbb8127be0809e442986.webp"
"MediaSize" => 70729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-9952c6e98170fbb8127be0809e442986.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6401702846"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/e9442e0e38adaeeaecc00cf479783643.webp"
"MediaSize" => 56716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-e9442e0e38adaeeaecc00cf479783643.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6401702933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/4aca3f6c8133bb2636b46e84483e6ef2.webp"
"MediaSize" => 92709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-4aca3f6c8133bb2636b46e84483e6ef2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6401703018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/4952f6c46f7994faf113d2d4fdcb07b7.webp"
"MediaSize" => 89412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-4952f6c46f7994faf113d2d4fdcb07b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6401703064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/3d5d33fec9b448244b64916f6599bf79.webp"
"MediaSize" => 96748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-3d5d33fec9b448244b64916f6599bf79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6401703075"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/03202c90a744bb09e7643e7f99f65fa0.webp"
"MediaSize" => 104847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-03202c90a744bb09e7643e7f99f65fa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6401703139"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/f1558730df29669faf36513043e373f5.webp"
"MediaSize" => 93987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-f1558730df29669faf36513043e373f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6401703159"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/490cbe7c4ab25f9a166c86d2176192dd.webp"
"MediaSize" => 77893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-490cbe7c4ab25f9a166c86d2176192dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6401703256"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/a5a6475c26b62b873d8896178d5b5b64.webp"
"MediaSize" => 91435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-a5a6475c26b62b873d8896178d5b5b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6401703313"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/1ea979bafbae5faa7e96955be9773395.webp"
"MediaSize" => 80415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-1ea979bafbae5faa7e96955be9773395.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6401703340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/27de79b6664c52547930d62f149ab25b.webp"
"MediaSize" => 72458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-27de79b6664c52547930d62f149ab25b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6401703409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/959e75aaad49468533818e1071ff877a.webp"
"MediaSize" => 91784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-959e75aaad49468533818e1071ff877a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6401703492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/0ebdc8fbc0c9180b79f838ba5a522a85.webp"
"MediaSize" => 88573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-0ebdc8fbc0c9180b79f838ba5a522a85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6401703578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/385f5a4842f6254fed4f4f164d08c95b.webp"
"MediaSize" => 73726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-385f5a4842f6254fed4f4f164d08c95b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6401703597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/86c88413bac7c73872b5d50fc8db825a.webp"
"MediaSize" => 92050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-86c88413bac7c73872b5d50fc8db825a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6401703623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/1916b06fdba5c6c8b5692283cd52fd03.webp"
"MediaSize" => 90972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-1916b06fdba5c6c8b5692283cd52fd03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6401703643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/5365001acfcd218bbd64be38f61f74c7.webp"
"MediaSize" => 86285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-5365001acfcd218bbd64be38f61f74c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6401703673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/1bad1307e917bcccce103e9acf4b9c1b.webp"
"MediaSize" => 97664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-1bad1307e917bcccce103e9acf4b9c1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6401703689"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/9704d6d09525ab66bbd3cde908759aea.webp"
"MediaSize" => 111089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-9704d6d09525ab66bbd3cde908759aea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6401703747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/e1192704224cf10d27a6c7b633c1994e.webp"
"MediaSize" => 92789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-e1192704224cf10d27a6c7b633c1994e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6401703799"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29240774/0c40f017f687bb1a7d4da43b1cf2f3cb.webp"
"MediaSize" => 140078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29240774/thumbnail-0c40f017f687bb1a7d4da43b1cf2f3cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12687042"
"ResourceRecordKey" => "29240774"
"ModificationTimestamp" => "2026-01-12T17:43:19.91Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "LEE S. QUAILE"
"MemberFirstName" => "LEE S."
"MemberLastName" => "QUAILE"
"MemberMlsId" => "9638409"
"OriginatingSystemName" => 26
"MemberKey" => "2211703"
"ModificationTimestamp" => "2026-01-12T22:06:17Z"
"MemberStatus" => "Active"
"OfficeKey" => "296481"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "548-490-7336"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-02-22T20:21:00Z"
"MemberNationalAssociationId" => "1457628"
"OfficeNationalAssociationId" => "1470796"
]
]
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "CHESTNUT PARK REALTY(SOUTHWESTERN ONTARIO) LTD"
"OfficePhone" => "519-804-7200"
"OfficeMlsId" => "454001"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "296481"
"ModificationTimestamp" => "2024-10-17T00:36:22Z"
"OfficeAddress1" => "75 KING ST SOUTH #50A"
"OfficeCity" => "WATERLOO"
"OfficePostalCode" => "N2J1P2"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2024-03-21T19:18:00Z"
"OfficeNationalAssociationId" => "1470796"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1457628"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29240774')"
+"ID": "527230"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 296481/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296481&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296481/Office?$select=ALL&$top=10&$filter=OfficeKey eq 296481&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25302
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CHESTNUT PARK REALTY(SOUTHWESTERN ONTARIO) LTD"
+"OfficeEmail": null
+"OfficePhone": "519-804-7200"
+"OfficeMlsId": "454001"
+"ModificationTimestamp": "2024-10-17T00:36:22Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "296481"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "75 KING ST SOUTH #50A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2J1P2"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1470796"
+"OriginalEntryTimestamp": "2024-03-21T19:18:00Z"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1457628"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('296481')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211703/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211703&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211703/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2211703&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29240774" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24931
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29240774/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29240774&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29240774/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29240774&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29240774 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.532334 43.475918)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29240774 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.532334 43.475918)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29240774 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.532334 43.475918)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29240774 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.532334 43.475918)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24849
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25149
+post_id: "535219"
+post_author: 1
+"ListingKey": "29250998"
+"ListingId": "X12696136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:26:01Z"
+"RFModificationTimestamp": "2026-01-15T00:09:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K5"
+"UnparsedAddress": "1510 - 239 ALBERT STREET, Waterloo, Ontario N2L0K5"
+"Coordinates": array:2 [
0 => -80.53259
1 => 43.474388
]
+"Latitude": 43.474388
+"Longitude": -80.53259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "SUBLEASE From May to End of August. Two Bedroom with one bath* * Water and Internet is already included in the price! Floor garbage disposal, 2 desks, bed, chairs, coffee table, 2 couches. Prime Location - Close to Wilfrid Laurier University, University of Waterloo, and Conestoga College* Albert Street. Fully furnished. Very close to restaurants and stores. Could do early move-in at the end of April if easier for you. Can be be Lease Transfer if you wish to get more occupation time. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:09:50.221306+00:00"
+"Directions": "University Avenue W & Albert Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109403"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:18:46Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:18:46Z"
+"StreetName": "Albert"
+"StreetNumber": "239"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250998/1510-239-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "BBBB"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T19:18:45.98Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404541476"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/8edffc7f94fd6e34a86d896ef29b37d8.webp"
"MediaSize" => 332397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-8edffc7f94fd6e34a86d896ef29b37d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404541491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/7816689e29dabdf35ce6d27594274781.webp"
"MediaSize" => 96059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-7816689e29dabdf35ce6d27594274781.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404541571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/0b28684b08b2f10382aeb485e6de7ec3.webp"
"MediaSize" => 84439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-0b28684b08b2f10382aeb485e6de7ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404541601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/391ff8ee8dc0e51ba3e0c7a2b744f8e8.webp"
"MediaSize" => 85207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-391ff8ee8dc0e51ba3e0c7a2b744f8e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404541635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/5b7457fa3faa6a953fb0dec4618d6c98.webp"
"MediaSize" => 89917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-5b7457fa3faa6a953fb0dec4618d6c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404541644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/1080cbbb8bcd4021888dfdedf15b401c.webp"
"MediaSize" => 85285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-1080cbbb8bcd4021888dfdedf15b401c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404541681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/59232f743727552cf0f40f2dcea2f1a1.webp"
"MediaSize" => 86810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-59232f743727552cf0f40f2dcea2f1a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404541707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/fc0c720f4c75ab7bd5a6cbd210d91c35.webp"
"MediaSize" => 71390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-fc0c720f4c75ab7bd5a6cbd210d91c35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404541748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/80c7e629558ead5e1ccc189693962660.webp"
"MediaSize" => 90327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-80c7e629558ead5e1ccc189693962660.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404541785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/95110dc2a4957f5b5741d61a3725e360.webp"
"MediaSize" => 89640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-95110dc2a4957f5b5741d61a3725e360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404541829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/8b895577d43a00af5c0d0aa2f1ca06d5.webp"
"MediaSize" => 76246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-8b895577d43a00af5c0d0aa2f1ca06d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404541855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/91707b2f0ffaead9469c184764d48ddc.webp"
"MediaSize" => 87151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-91707b2f0ffaead9469c184764d48ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404541939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/95b6adce92778f6bc87c90ca9b93b8fc.webp"
"MediaSize" => 76805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-95b6adce92778f6bc87c90ca9b93b8fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404541989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/3f10b9c42bf762a73555dc3ae30003f9.webp"
"MediaSize" => 22400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-3f10b9c42bf762a73555dc3ae30003f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404541997"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/29eb480430c227af0689edd6383e097b.webp"
"MediaSize" => 320964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-29eb480430c227af0689edd6383e097b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "RITA SEIFIN"
"MemberFirstName" => "RITA"
"MemberLastName" => "SEIFIN"
"MemberMlsId" => "9604539"
"OriginatingSystemName" => 26
"MemberKey" => "2109403"
"ModificationTimestamp" => "2025-12-15T10:04:00Z"
"MemberStatus" => "Active"
"OfficeKey" => "283413"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "647-300-2721"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-02-04T22:42:00Z"
"MemberNationalAssociationId" => "1378246"
"OfficeNationalAssociationId" => "1328652"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "ROYAL LEPAGE REAL ESTATE SERVICES LTD."
"OfficePhone" => "905-257-3633"
"OfficeMlsId" => "519013"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283413"
"ModificationTimestamp" => "2025-05-21T20:02:13Z"
"OfficeAddress1" => "231 OAK PARK #400B"
"OfficeCity" => "OAKVILLE"
"OfficePostalCode" => "L6H7S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-257-3550"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-04-27T00:19:00Z"
"OfficeNationalAssociationId" => "1328652"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1128382"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250998')"
+"ID": "535219"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24779
+post_id: "534841"
+post_author: 1
+"ListingKey": "29252027"
+"ListingId": "X12696974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:52:10Z"
+"ListPrice": 439999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H7"
+"UnparsedAddress": "2122 - 258B SUNVIEW STREET, Waterloo, Ontario N2L0H7"
+"Coordinates": array:2 [
0 => -80.53335
1 => 43.474556
]
+"Latitude": 43.474556
+"Longitude": -80.53335
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 258B Sunview Street, Unit 2122 - A Bright And Modern 2-Bedroom, 1-Bathroom Corner Suite Offering 705 Sq Ft Of Thoughtfully Designed Living Space In The Heart Of Waterloo's Vibrant University District. This Stylish Unit Features An Open-Concept Layout With Large Windows That Flood The Space With Natural Light, A Contemporary Kitchen With Sleek Cabinetry, And Two Well-Sized Bedrooms Ideal For Students, Professionals, Or Investors. Step Out Onto Your Private Balcony And Enjoy Elevated Views Of The Neighbourhood, Perfect For Relaxing Or Entertaining. Located Just Minutes From The University Of Waterloo, Wilfrid Laurier University, Conestoga College, And Within Walking Distance To The Ion Lrt, Commuting Across The City Is Effortless. Surrounded By Cafés, Restaurants, Shopping, Tech Hubs, And Everyday Amenities, This Location Offers Unbeatable Convenience And Strong Rental Demand. Whether You're Looking For A Smart Investment Or A Place To Call Home, This Unit Delivers Lifestyle, Value, And Long-Term Potential In One Exceptional Package. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "427.43"
+"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-01-14T22:51:59.693638+00:00"
+"Directions": "ALBERT & UNIVERSITY AVE W."
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049355"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3659.64"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560412646"
"RoomType" => "Living room"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 2.56
"ListingKey" => "29252027"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
1 => array:11 [
"RoomKey" => "1560412647"
"RoomType" => "Kitchen"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 2.56
"ListingKey" => "29252027"
"RoomLength" => 2.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
2 => array:11 [
"RoomKey" => "1560412648"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 5.3
"ListingKey" => "29252027"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
3 => array:11 [
"RoomKey" => "1560412649"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 3.46
"ListingKey" => "29252027"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
4 => array:11 [
"RoomKey" => "1560412650"
"RoomType" => "Laundry room"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 0.0
"ListingKey" => "29252027"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252027/2122-258b-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1735636"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "289187"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.5Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404776151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/f86b9c42ac2b3b4dfe1cab7caa3684b0.webp"
"MediaSize" => 287542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-f86b9c42ac2b3b4dfe1cab7caa3684b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404776183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/c3a082ea2e253ae8fed6a227912a86d8.webp"
"MediaSize" => 39425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-c3a082ea2e253ae8fed6a227912a86d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404776226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/07dd8830019ab2b485187bec8394a370.webp"
"MediaSize" => 198903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-07dd8830019ab2b485187bec8394a370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404776301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/9f54741a8ca2d0ea73ee1e059429cef9.webp"
"MediaSize" => 164597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-9f54741a8ca2d0ea73ee1e059429cef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404776373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/869e78b9eca3d143fb68c1f2e9a03585.webp"
"MediaSize" => 235880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-869e78b9eca3d143fb68c1f2e9a03585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404776416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/2d7a8574c98c877bcff048410718b454.webp"
"MediaSize" => 225319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-2d7a8574c98c877bcff048410718b454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404776473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/cf1a7b5e754c6dc74e2a28e5bb0f7cd8.webp"
"MediaSize" => 275006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-cf1a7b5e754c6dc74e2a28e5bb0f7cd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404776517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/4b71ac09f99bfbbf7a54f71d41bd61b6.webp"
"MediaSize" => 139315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-4b71ac09f99bfbbf7a54f71d41bd61b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404776524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/09897dae8182b8b9865d3433ac8c8e8d.webp"
"MediaSize" => 251317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-09897dae8182b8b9865d3433ac8c8e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404776626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/4ed333e72d814e5e27d8f01ba1c29a31.webp"
"MediaSize" => 250735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-4ed333e72d814e5e27d8f01ba1c29a31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404776670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/36c4b050e4c7ca1bed699a4b7ec81c49.webp"
"MediaSize" => 234548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-36c4b050e4c7ca1bed699a4b7ec81c49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404776733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/2bbab1600178b6bdf5cdcfffb491da14.webp"
"MediaSize" => 207600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-2bbab1600178b6bdf5cdcfffb491da14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404776795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/546812e21ab45e8bb79c3a538f81b83d.webp"
"MediaSize" => 262528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-546812e21ab45e8bb79c3a538f81b83d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404776842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/a92b4e4fef3e1f9ebd031b8779e2b98e.webp"
"MediaSize" => 252383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-a92b4e4fef3e1f9ebd031b8779e2b98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404776864"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/5b0437d0d08536fa7b22ece8e9332c56.webp"
"MediaSize" => 115494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-5b0437d0d08536fa7b22ece8e9332c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "HARMAN SAINI"
"MemberFirstName" => "HARMAN"
"MemberLastName" => "SAINI"
"MemberMlsId" => "9585542"
"OriginatingSystemName" => 26
"MemberKey" => "2049355"
"ModificationTimestamp" => "2025-12-15T10:18:33Z"
"MemberStatus" => "Active"
"OfficeKey" => "289187"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "905-456-1010"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "416-317-4900"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2018-03-02T01:23:00Z"
"MemberNationalAssociationId" => "1324736"
"OfficeNationalAssociationId" => "1375388"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX GOLD REALTY INC."
"OfficePhone" => "905-456-1010"
"OfficeMlsId" => "187103"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289187"
"ModificationTimestamp" => "2025-06-10T15:18:00Z"
"OfficeAddress1" => "2720 NORTH PARK DRIVE #201"
"OfficeCity" => "BRAMPTON"
"OfficePostalCode" => "L6S0E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-673-8900"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2020-12-30T18:49:00Z"
"OfficeNationalAssociationId" => "1375388"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1051513"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252027')"
+"ID": "534841"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "534844"
+post_author: 1
+"ListingKey": "29252044"
+"ListingId": "40798497"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:44Z"
+"RFModificationTimestamp": "2026-01-14T22:49:01Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3B4"
+"UnparsedAddress": "179 REGINA Street N, Waterloo, Ontario N2J3B4"
+"Coordinates": array:2 [
0 => -80.5230119
1 => 43.4735808
]
+"Latitude": 43.4735808
+"Longitude": -80.5230119
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Uptown Waterloo Prime Location with multiple possibilities! Investors and Developers alike, note that this vacant home sits across the street from WLU and features RMU-81 Zoning for redevelopment, which entails high density residential that allows for complimentary commercial use. This solid 3 bedroom, 2 bathroom home is a great opportunity for rental income with its proximity to both Universities, Uptown Waterloo, and public transit. Upgrades include metal roof (2022), electrical panel with 200amp service (2016). Disclosure: Photos staged with furniture are AI generated. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-01-14T22:48:46.923630+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2012484"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-01-14T21:51:56Z"
+"PhotosCount": 7
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:51:56Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "REGINA"
+"StreetNumber": "179"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5439"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1560415453"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798497"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
1 => array:11 [
"RoomKey" => "1560415454"
"RoomType" => "Bedroom"
"ListingId" => "40798497"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
2 => array:11 [
"RoomKey" => "1560415455"
"RoomType" => "Bedroom"
"ListingId" => "40798497"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
3 => array:11 [
"RoomKey" => "1560415456"
"RoomType" => "Bedroom"
"ListingId" => "40798497"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
4 => array:11 [
"RoomKey" => "1560415457"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798497"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
5 => array:11 [
"RoomKey" => "1560415458"
"RoomType" => "Living room"
"ListingId" => "40798497"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
6 => array:11 [
"RoomKey" => "1560415459"
"RoomType" => "Dining room"
"ListingId" => "40798497"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
7 => array:11 [
"RoomKey" => "1560415460"
"RoomType" => "Kitchen"
"ListingId" => "40798497"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29252044"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T21:48:38.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29252044/179-regina-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2026-01-14T21:48:38.06Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:7 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404775828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/9a043523c7b25df7341e3fe936756007.webp"
"MediaSize" => 85742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-9a043523c7b25df7341e3fe936756007.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798497"
"ResourceRecordKey" => "29252044"
"ModificationTimestamp" => "2026-01-14T21:51:56.97Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404775855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/d6299f0d40e7f57694704d84eecfd82f.webp"
"MediaSize" => 75975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-d6299f0d40e7f57694704d84eecfd82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798497"
"ResourceRecordKey" => "29252044"
"ModificationTimestamp" => "2026-01-14T21:51:56.97Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404775917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/60114d887f9b990087f247d4dbf341d1.webp"
"MediaSize" => 82910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-60114d887f9b990087f247d4dbf341d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798497"
"ResourceRecordKey" => "29252044"
"ModificationTimestamp" => "2026-01-14T21:51:56.97Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404775934"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/b5edfe5be94d440d56c93b7d34524f5f.webp"
"MediaSize" => 71293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-b5edfe5be94d440d56c93b7d34524f5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798497"
"ResourceRecordKey" => "29252044"
"ModificationTimestamp" => "2026-01-14T21:51:56.98Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404775971"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/bcc2580e5220cbc9f214ed2ec8560c48.webp"
"MediaSize" => 76597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-bcc2580e5220cbc9f214ed2ec8560c48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798497"
"ResourceRecordKey" => "29252044"
"ModificationTimestamp" => "2026-01-14T21:51:56.97Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404776053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252044/98a50068405bf52fab0e36f4f63dc1e4.webp"
"MediaSize" => 68066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252044/thumbnail-98a50068405bf52fab0e36f4f63dc1e4.webp"
"ResourceName" => "Property"
…6
]
6 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252044')"
+"ID": "534844"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "534789"
+post_author: 1
+"ListingKey": "29252033"
+"ListingId": "X12697078"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T22:31:06Z"
+"RFModificationTimestamp": "2026-01-14T22:35:02Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "108 - 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 the Ivy Towns. One of the best off-campus condo's in Uptown Waterloo. Less than 5 minutes walk to the University of Waterloo and Wilfrid Laurier. Shopping, restaurants and many other offerings are within easy walking distance as well. These modern and beautifully appointed condo's feature vaulted ceilings, huge windows and an open-concept living area. With two spacious bedrooms, two bathrooms, a private terrace and in-suite laundry along with private parking, this unit has everything needed to call home. A beautiful rooftop garden and terrace is an added bonus space for residents as well. Recently leased for $2,600 monthly, this is a great investment opportunity or a wonderful place to call home for yourself! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Oven"
3 => "Dryer"
4 => "Furniture"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "779.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:34:42.607234+00:00"
+"Directions": "Albert St & Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998221"
+"ListOfficeKey": "50441"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:46:00Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T22:17:35Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4614"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252033/108-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-14T21:46:00.11Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252033')"
+"ID": "534789"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24755
+post_id: "534341"
+post_author: 1
+"ListingKey": "29251167"
+"ListingId": "X12696336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T00:25:24Z"
+"RFModificationTimestamp": "2026-01-15T00:28:12Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L4"
+"UnparsedAddress": "520 TEAKWOOD DRIVE, Waterloo, Ontario N2L4L4"
+"Coordinates": array:2 [
0 => -80.5530687
1 => 43.4843178
]
+"Latitude": 43.4843178
+"Longitude": -80.5530687
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "On a prime corner lot in the street of Lakeshore Village, you will find 520 Teakwood Drive. Sitting on an over-sized 65 by 122+ foot lot, this home offers plenty of outdoor space to enjoy with two large side yards and a private back deck. The interior is filled with natural light, creating a warm and inviting atmosphere across more than 2,000 square feet of total living space. Meticulously maintained, the main level features three bright bedrooms, including one with a seamless walk-out to the deck. Throughout this level, the recently refinished original hardwood floors add a touch of timeless character and warmth to every room. The kitchen has been thoughtfully updated with a larger island, newer appliances, modern countertops, and a stylish backsplash. Downstairs, the space continues to impress with a large family room and two additional bedrooms featuring egress windows. This lower level also includes a kitchenette new in 2018, a full bathroom, and laundry facilities. This home has been extensively renovated and is truly ready for its next owners. Much of the basement was redone in 2024, which included the installation of a new furnace and sump pump. The roof and siding were also redone this past fall, along with the completion of a new storage shed. This home is completely move-in ready. With two expansive side yards and a private back deck, this property is a dream for gardeners and families alike. Whether you're hosting a summer BBQ or enjoying a quiet morning coffee surrounded by mature trees, the outdoor space provides endless options for relaxation and play. Get in before the summer so you can relax and enjoy all that 520 Teakwood has to offer! (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Water meter"
2 => "Water softener"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T20:46:57.129329+00:00"
+"Directions": "Glen forrest blvd and Bearinger Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1911639"
+"ListOfficeKey": "50472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "65 x 122 FT ; longest 130 feet as sidewalk curves"
+"ParkingFeatures": array:3 [
0 => "Carport"
1 => "Covered"
2 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:46:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T00:13:48Z"
+"Stories": "1.0"
+"StreetName": "Teakwood"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4082.92"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/mls/224770381"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251167/520-teakwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"OriginalEntryTimestamp": "2026-01-14T19:46:22.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251167')"
+"ID": "534341"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "533317"
+post_author: 1
+"ListingKey": "29249728"
+"ListingId": "X12694842"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T16:35:08Z"
+"RFModificationTimestamp": "2026-01-14T16:47:41Z"
+"ListPrice": 688000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4S6"
+"UnparsedAddress": "231A CEDARBRAE AVENUE, Waterloo, Ontario N2L4S6"
+"Coordinates": array:2 [
0 => -80.5499591
1 => 43.4871352
]
+"Latitude": 43.4871352
+"Longitude": -80.5499591
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning, fully renovated bungalow 2 minutes from Waterloo University ! steps away from school and park. Featuring 3 bedrooms on main floor and 3 in the lower level. This home offers versatility and excellent income potential. Open concept layout is practical and functional, offering comfortable living for families. fully renovated house, new flooring, updated kitchen, beautifully refreshed washrooms. It's also an ideal spot for commuters, with quick access to both the 401 and the Expressway. Move in ready-Perfect for students, families, or investors looking for a turnkey property in prime location. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T16:47:27.185148+00:00"
+"Directions": "Bearinger rd/ glen forest blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1882561"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.8 x 100.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:25:57Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:25:57Z"
+"Stories": "1.0"
+"StreetName": "Cedarbrae"
+"StreetNumber": "231A"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3331.88"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249728/231a-cedarbrae-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 36.9
+"OriginalEntryTimestamp": "2026-01-14T16:25:57.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:13 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249728')"
+"ID": "533317"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "531256"
+post_author: 1
+"ListingKey": "29245928"
+"ListingId": "X12691786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T18:30:11Z"
+"RFModificationTimestamp": "2026-01-13T20:16:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2X9"
+"UnparsedAddress": "1409 - 128 KING STREET N, Waterloo, Ontario N2J2X9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to One28 Condos on King Street in Uptown Waterloo. This bright and spacious one-bedroom plus den suite features 9-foot ceilings, an open-concept living and dining area, and a large kitchen with stainless steel appliances. Enjoy a walk-out to a private balcony with unobstructed west-facing views. The generously sized primary bedroom offers excellent natural light, and the den is ideal for a home office or study. Ideally located with easy access to ION LRT transit, and just minutes to University of Waterloo, Wilfrid Laurier University, Downtown Waterloo, shops, restaurants, and amenities. The building offers indoor and outdoor amenities, including 24-hour security surveillance, party/study room, fitness room, yoga studio, green roof, and an outdoor terrace with BBQs. One parking space and one locker included. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T20:15:51.105752+00:00"
+"Directions": "King-University"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1625246"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-13T18:15:12Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T18:15:12Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"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/29245928/1409-128-king-street-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onyx Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 1990
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T18:15:12.57Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29245928')"
+"ID": "531256"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: "531257"
+post_author: 1
+"ListingKey": "29246008"
+"ListingId": "40795464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T18:30:13Z"
+"RFModificationTimestamp": "2026-01-13T20:13:09Z"
+"ListPrice": 559000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5C5"
+"UnparsedAddress": "88 MCDOUGALL Road Unit# F, Waterloo, Ontario N2L5C5"
+"Coordinates": array:2 [
0 => -80.544748
1 => 43.462943
]
+"Latitude": 43.462943
+"Longitude": -80.544748
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Lovely spacious 4 bedroom end unit townhome located in excellent Beechwood neighbourhood. Main floor boasts large bright main floor family room with gas fireplace and large windows overlooking green space. Separate dining room and eat in kitchen provide ample room for entertaining. This lovely home offers 4 large bedrooms including primary suite and 3 pc bath. You will be impressed with the large finished walk out basement offering high ceilings and two finished family room spaces. From the full walkout you have a private fenced yard for your family to enjoy. A patio and barbeque are surrounded by mature trees nd green space giving this townhome lots of privacy. Well over 2000 sq feet of finished living space. Walking distance to U of W. Uptown Waterloo, Waterloo Park close to all public transit. Wonderful family home or excellent investment property for your son or daughter while attending university. Current owner has all prior licensing requirements for City of Waterloo available for reference. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "681.15"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T20:12:48.730827+00:00"
+"Directions": "Keats Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563601"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-01-13T18:20:17Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T18:20:17Z"
+"Stories": "2.0"
+"StreetName": "MCDOUGALL"
+"StreetNumber": "88"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4205.82"
+"VirtualTourURLUnbranded": "https://youriguide.com/f_88_mcdougall_rd_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/29246008/88-mcdougall-road-unit-f-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1740
+"BelowGradeFinishedArea": 831
+"OriginalEntryTimestamp": "2026-01-13T18:20:17.58Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246008')"
+"ID": "531257"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24821
+post_id: "531031"
+post_author: 1
+"ListingKey": "29245264"
+"ListingId": "40798117"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T16:46:04Z"
+"RFModificationTimestamp": "2026-01-13T19:35:44Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 770.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "181 KING Street S Unit# 1510, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5202345
1 => 43.4603915
]
+"Latitude": 43.4603915
+"Longitude": -80.5202345
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched above its Uptown neighbors, Suite 1510, offers panoramic views and floods of morning light through its expansive windows. The convenience of Lutron automation allows you to effortlessly control custom blinds via your smartphone. With 770 interior sq ft, the open-concept layout provides ample living space in the primary rooms, enhanced by 10-foot ceilings! Suite 1510 elevates the kitchen experience with marble-patterned quartz countertops, a matching slab backsplash, integrated appliances, and modern two-toned cabinetry, ensuring that you never run out of storage. An exceptional feature of this unit is the custom-built storage solution in the den area, complete with wall-to-wall cabinetry for effortless access. The master bedroom offers generous space for a full-size bedroom set or the option to incorporate a tailored closet solution. Residents at Circa 1877 enjoy access to leading amenities, including a stunning outdoor salt water pool, professionally designed co-working space, fitness center, yoga area, indoor/outdoor party room, and an exquisite lobby library. The building's proximity to an iOn LRT stop ensures seamless connectivity throughout Kitchener and Waterloo, not to mention, it is just steps away from Uptown Waterloo. Don't miss the opportunity to tour this remarkable unit. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "678"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:4 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
3 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T19:34:35.437540+00:00"
+"Directions": "Allen St onto King St."
+"ExteriorFeatures": array:3 [
0 => "Steel"
1 => "Concrete"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987695"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Visual exposure"
2 => "Conservation/green belt"
3 => "Balcony"
4 => "Industrial mall/subdivision"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-13T16:38:35Z"
+"PhotosCount": 25
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T16:38:35Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4451.61"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29245264/181-king-street-s-unit-1510-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2026-01-13T16:38:35.46Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:25 [
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]
]
+"Member": array:1 [
0 => array:26 [ …26]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29245264')"
+"ID": "531031"
}
]
+success: true
+page_size: 9
+page_count: 27
+count: 238
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]