array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29919010 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23471
+post_id: "1541125"
+post_author: 1
+"ListingKey": "29919010"
+"ListingId": "X13458736"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:55:06Z"
+"RFModificationTimestamp": "2026-06-18T15:05:50Z"
+"ListPrice": 538888.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "901 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Highly Sought After Investment Opportunity. Located In Waterloo's Ideal And Luxurious Residential Pocket. Walking Distance To University Of Waterloo & Wilfred Laurier University. Public Transportation At Your Finger Tips. This Functional Suites Boosts Approx 1400sqft, Featuring 3 Full Size Bedrooms With Full Closet & Windows. 1 With Ensuite & Walk In Closet, 2 Full Bathrooms, In-suite Laundry, Open Concept Kitchen And Large Dining Island, Separate Living Space With Balcony Walk Out Access. Full Size Kitchen Appliances, Laminate Flooring Throughout, Soaring 9ft Ceilings, South And East Facing Views, In-suite Thermostat, HVAC & Water Tank, Ample Amount Of Storage And Closet Space. Ideal For Contemporary Student Living, Well-Maintained Building With Amenities And Features Including But Not Limited To; Gym, Secure Bike Storage, & Meeting Room / Common Lounge Space Equipped With High Speed Internet. Safe And. Secured Fob Entry With Buzzer, Condo Is Equipped With CCTV To Offer Parents Of Residents A Peace Of Mind. Currently Tenanted With 3 Great Laurier Students On First Year Lease Agreement And Moving Out End Of August 2026. (id:62783)"
+"Appliances": array:1 [
0 => "Furniture"
]
+"AssociationFee": "673.24"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:39:39.661326+00:00"
+"Directions": "Cross Streets: University / King. ** Directions: As Per Google."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2037204"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T14:48:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:48:53Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5864"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661543485"
"RoomType" => "Kitchen"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 5.71
"ListingKey" => "29919010"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
1 => array:11 [
"RoomKey" => "1661543486"
"RoomType" => "Dining room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "29919010"
"RoomLength" => 2.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
2 => array:11 [
"RoomKey" => "1661543487"
"RoomType" => "Living room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "29919010"
"RoomLength" => 5.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
3 => array:11 [
"RoomKey" => "1661543489"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.92
"ListingKey" => "29919010"
"RoomLength" => 4.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
4 => array:11 [
"RoomKey" => "1661543490"
"RoomType" => "Bedroom 2"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.48
"ListingKey" => "29919010"
"RoomLength" => 6.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
5 => array:11 [
"RoomKey" => "1661543491"
"RoomType" => "Bedroom 3"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.99
"ListingKey" => "29919010"
"RoomLength" => 5.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
6 => array:11 [
"RoomKey" => "1661543492"
"RoomType" => "Laundry room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 0.0
"ListingKey" => "29919010"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919010/901-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T21:55:09.9Z"
+"ListAgentNationalAssociationId": "1313612"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919010_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/e45830b4dd4b6ee9d4307a226179fd8e.webp"
"MediaSize" => 281007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-e45830b4dd4b6ee9d4307a226179fd8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919010_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/75be00e148f4834d1f42bdfbb43b6c4a.webp"
"MediaSize" => 316284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-75be00e148f4834d1f42bdfbb43b6c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919010_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/a053838bdcea8c636e6b91c31940e97e.webp"
"MediaSize" => 238581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-a053838bdcea8c636e6b91c31940e97e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919010_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/eee182764f9f6f0aaccd8cd47da4b7ed.webp"
"MediaSize" => 96845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-eee182764f9f6f0aaccd8cd47da4b7ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919010_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/c4b390321615e9be8262a2d9dcc394dc.webp"
"MediaSize" => 122424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-c4b390321615e9be8262a2d9dcc394dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919010_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/016a90cd7cd391b82ed8a1f950e9eaa7.webp"
"MediaSize" => 177119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-016a90cd7cd391b82ed8a1f950e9eaa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919010_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/b31ca35e4d4087086bb3042bea85b92b.webp"
"MediaSize" => 117297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-b31ca35e4d4087086bb3042bea85b92b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919010_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/e42b78f8e799ddbc07412ccd85147ab1.webp"
"MediaSize" => 132439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-e42b78f8e799ddbc07412ccd85147ab1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919010_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7bb2feb90b13f84b04c89033e52f74f7.webp"
"MediaSize" => 150931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7bb2feb90b13f84b04c89033e52f74f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29919010_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/b0df6019b2943e352c8e4bf8f35532fc.webp"
"MediaSize" => 146033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-b0df6019b2943e352c8e4bf8f35532fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29919010_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/38e16ffc4cc97f30963b8cd118b45c20.webp"
"MediaSize" => 215915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-38e16ffc4cc97f30963b8cd118b45c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29919010_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/8df74041af067d06ca9bb872bed629e7.webp"
"MediaSize" => 205625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-8df74041af067d06ca9bb872bed629e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29919010_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/48d582043f52c69ede160f6cca6b7240.webp"
"MediaSize" => 206001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-48d582043f52c69ede160f6cca6b7240.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29919010_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7b3746dae26e8d025d4ace07b485e5a7.webp"
"MediaSize" => 216699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7b3746dae26e8d025d4ace07b485e5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29919010_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7e61faf1f1c0c5f4917ff4e8c0b1fe6c.webp"
"MediaSize" => 170945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7e61faf1f1c0c5f4917ff4e8c0b1fe6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29919010_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/47852c525cc8be4ffd3bd64d044325d7.webp"
"MediaSize" => 130055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-47852c525cc8be4ffd3bd64d044325d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29919010_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/bff248a1cad08138e134630e54e4768b.webp"
"MediaSize" => 115922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-bff248a1cad08138e134630e54e4768b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29919010_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/eb70d464ef5b74221799687a3571a1d3.webp"
"MediaSize" => 174284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-eb70d464ef5b74221799687a3571a1d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29919010_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/2b095111ec3ec7a8e6a75aff7055ccae.webp"
"MediaSize" => 145837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-2b095111ec3ec7a8e6a75aff7055ccae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29919010_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/5ba0edd1583533655d41c7a8c15c975a.webp"
"MediaSize" => 153392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-5ba0edd1583533655d41c7a8c15c975a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29919010_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/de1b34241abb19018a7b503009207f78.webp"
"MediaSize" => 139294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-de1b34241abb19018a7b503009207f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29919010_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/13517ae2d1f6392fe255f36c50a537f6.webp"
"MediaSize" => 190322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-13517ae2d1f6392fe255f36c50a537f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29919010_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/cefd596f1ee0267a99c8e55bf768e108.webp"
"MediaSize" => 129282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-cefd596f1ee0267a99c8e55bf768e108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29919010_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/367f751b50b954eeef21007c74f2e132.webp"
"MediaSize" => 172382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-367f751b50b954eeef21007c74f2e132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29919010_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/a3e9bcc5d27449f99c728c8acbcf6441.webp"
"MediaSize" => 236633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-a3e9bcc5d27449f99c728c8acbcf6441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29919010_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/524111086e0ebe7c85db4c0314365048.webp"
"MediaSize" => 302178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-524111086e0ebe7c85db4c0314365048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29919010_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/6301bf22c04f03bdb3669f2b8e097087.webp"
"MediaSize" => 264667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-6301bf22c04f03bdb3669f2b8e097087.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29919010_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/ca4cb56503d79aa6cfc066dae98457ef.webp"
"MediaSize" => 285309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-ca4cb56503d79aa6cfc066dae98457ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29919010_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/5a7ed8fc556fe3b4ac0ed08b2d04a247.webp"
"MediaSize" => 243356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-5a7ed8fc556fe3b4ac0ed08b2d04a247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29919010_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/532786ea8575922b2d256e59b08c3e26.webp"
"MediaSize" => 271211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-532786ea8575922b2d256e59b08c3e26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919010')"
+"ID": "1541125"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 70066" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24964
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24861
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE LANDMARK REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-305-1600"
+"OfficeMlsId": "63000"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "70066"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "7240 WOODBINE AVE UNIT 103"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MARKHAM"
+"OfficePostalCode": "L3R1A4"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1132867"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-305-1609"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "270752"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "70066"
"SocialMediaUrlOrId" => "http://www.homelifelandmark.com/"
"ModificationTimestamp" => "2024-09-26T19:43:00Z"
]
]
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1097410"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('70066')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2037204" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24867
+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 '29919010'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29919010' AND OpenHouseDate ge '2026-07-10'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25279
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29919010' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.526206 43.478339)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25387
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1611937"
+post_author: 1
+"ListingKey": "30015282"
+"ListingId": "X13546684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T01:45:03Z"
+"RFModificationTimestamp": "2026-07-10T04:49:38Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "1505 - 318 SPRUCE STREET, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.526384
1 => 43.478992
]
+"Latitude": 43.478992
+"Longitude": -80.526384
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "2 BEDROOMS, 2 BATHROOMS + LARGE STORAGE LOCKER - Calling all investors, parents of university students, and young professionals. Welcome to Sage Condos in Waterloo's dynamic University Core. This spacious two-bedroom, two-bathroom suite offers just under 1,000 square feet of thoughtfully designed living space. The open concept layout features a modern kitchen with stainless steel appliances, stone countertops, and ample cabinetry, flowing seamlessly into the bright living area. Large windows bring in natural light, while the private balcony offers expansive city views. Both bedrooms are generously sized, making the layout ideal for roommates or shared living. The unit also includes in-suite laundry and an oversized premium storage locker conveniently located on the same floor, offering rare and practical everyday ease. Located just steps from the University of Waterloo and Wilfrid Laurier University, this is a prime opportunity in one of the city's most consistent rental pockets. Shops, restaurants, transit including the LRT and GO Bus Station, and everyday amenities are all within walking distance. Sage Condos offers attractive building amenities including a rooftop terrace, gym, party room, and high speed internet. Whether you are building your investment portfolio, securing a property for your child during university, or looking for a well-located urban home, this is a smart and versatile opportunity in the heart of Waterloo. (id:62650)"
+"AssociationFee": "627.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "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-07-10T04:49:34.029166+00:00"
+"Directions": "Cross Streets: Columbia. ** Directions: Columbia St W to Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213582"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Underground"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-10T01:38:13Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T01:38:13Z"
+"StreetName": "Spruce"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4726.46"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=dMFGUqA5E5f&mls=1"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1679691841"
"RoomType" => "Kitchen"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 2.717
"ListingKey" => "30015282"
"RoomLength" => 2.819
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.75Z"
]
1 => array:11 [
"RoomKey" => "1679691842"
"RoomType" => "Bathroom"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 1.6
"ListingKey" => "30015282"
"RoomLength" => 1.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.75Z"
]
2 => array:11 [
"RoomKey" => "1679691843"
"RoomType" => "Bedroom"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 2.896
"ListingKey" => "30015282"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.76Z"
]
3 => array:11 [
"RoomKey" => "1679691844"
"RoomType" => "Bedroom 2"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.099
"ListingKey" => "30015282"
"RoomLength" => 3.607
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.76Z"
]
4 => array:11 [
"RoomKey" => "1679691845"
"RoomType" => "Living room"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.048
"ListingKey" => "30015282"
"RoomLength" => 4.927
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.76Z"
]
5 => array:11 [
"RoomKey" => "1679691846"
"RoomType" => "Bathroom"
"ListingId" => "X13546684"
"RoomLevel" => "Main level"
"RoomWidth" => 2.5
"ListingKey" => "30015282"
"RoomLength" => 1.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T01:38:13.76Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30015282/1505-318-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Separate Heating Controls"
3 => "Party Room"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-10T01:38:13.72Z"
+"ListAgentNationalAssociationId": "1459405"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30015282_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/972a2ad2497ce464e4955405faa73f47.webp"
"MediaSize" => 153835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-972a2ad2497ce464e4955405faa73f47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30015282_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/02a664d93c16aed8d97713d8ead9856d.webp"
"MediaSize" => 130391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-02a664d93c16aed8d97713d8ead9856d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30015282_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/43df76ef5f8d6435907e2865cd370088.webp"
"MediaSize" => 279625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-43df76ef5f8d6435907e2865cd370088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30015282_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/ba0a1a771ea633e7eaa068783eeb62f3.webp"
"MediaSize" => 113642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-ba0a1a771ea633e7eaa068783eeb62f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30015282_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/6fbd5b546b320b7689296b25ea8f1737.webp"
"MediaSize" => 126537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-6fbd5b546b320b7689296b25ea8f1737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30015282_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/123dc6dbe6c1f0355b64c9b0488d37da.webp"
"MediaSize" => 123675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-123dc6dbe6c1f0355b64c9b0488d37da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30015282_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/1bfdee6c2565a8e7babdb85721405a30.webp"
"MediaSize" => 110775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-1bfdee6c2565a8e7babdb85721405a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30015282_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/a835889bb2244ff70acc8c798edd22de.webp"
"MediaSize" => 69622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-a835889bb2244ff70acc8c798edd22de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30015282_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/cae08d68f26284309772879764311048.webp"
"MediaSize" => 102461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-cae08d68f26284309772879764311048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30015282_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/c42bf660f7512d9d33d3e89569127750.webp"
"MediaSize" => 134940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-c42bf660f7512d9d33d3e89569127750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30015282_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/288ff191a538b37e86ea0cc898f58802.webp"
"MediaSize" => 149672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-288ff191a538b37e86ea0cc898f58802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30015282_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/b53ff24ac3c6517076fbaa607d4b7f13.webp"
"MediaSize" => 124406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-b53ff24ac3c6517076fbaa607d4b7f13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30015282_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/bfb4a78eb783db1c91e319918bae1d46.webp"
"MediaSize" => 128925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-bfb4a78eb783db1c91e319918bae1d46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30015282_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/2a0227a046023ee5b68ad55c4238ff1d.webp"
"MediaSize" => 124144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-2a0227a046023ee5b68ad55c4238ff1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30015282_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/2d304b58d5cae01abb6725c5c18521cc.webp"
"MediaSize" => 199418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-2d304b58d5cae01abb6725c5c18521cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30015282_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/74e2908fd790741c8731dfc995b85dee.webp"
"MediaSize" => 115270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-74e2908fd790741c8731dfc995b85dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30015282_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/3ee1435ae361b8bf476d8d0b7e7aae2c.webp"
"MediaSize" => 94103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-3ee1435ae361b8bf476d8d0b7e7aae2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30015282_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/ea4aa6c7423f178b235f0bf222545e3e.webp"
"MediaSize" => 127659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-ea4aa6c7423f178b235f0bf222545e3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30015282_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/e6e80d18e37b77e617105b8aecd2cc76.webp"
"MediaSize" => 102107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-e6e80d18e37b77e617105b8aecd2cc76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30015282_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/ae159b10608a0a33f0571ea8c3249843.webp"
"MediaSize" => 141851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-ae159b10608a0a33f0571ea8c3249843.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30015282_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/c4ccbcf142d269d18183a5b681a8a426.webp"
"MediaSize" => 145766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-c4ccbcf142d269d18183a5b681a8a426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30015282_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/3206945a2de8e221307923743ef8874f.webp"
"MediaSize" => 151898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-3206945a2de8e221307923743ef8874f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30015282_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/ea2e070596bbe68a7e83e144b33bee42.webp"
"MediaSize" => 99903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-ea2e070596bbe68a7e83e144b33bee42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30015282_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/4ee857ef5f3e31eebc3ffd3337292b45.webp"
"MediaSize" => 87250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-4ee857ef5f3e31eebc3ffd3337292b45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30015282_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/4a114a120c1ad8bbc7e08bf0cdd7dec7.webp"
"MediaSize" => 123948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-4a114a120c1ad8bbc7e08bf0cdd7dec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30015282_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/6dcc2672178ad43d4a0a773bb3f374ad.webp"
"MediaSize" => 123063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-6dcc2672178ad43d4a0a773bb3f374ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30015282_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/c287554e8b9cadf1c2041bc32d4eeb0b.webp"
"MediaSize" => 129775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-c287554e8b9cadf1c2041bc32d4eeb0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30015282_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/0f9b43e9543cced9b15bb73e3c95a6b4.webp"
"MediaSize" => 128132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-0f9b43e9543cced9b15bb73e3c95a6b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30015282_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/2e8926863de7e7cf6d3d15b81cdfb51b.webp"
"MediaSize" => 82670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-2e8926863de7e7cf6d3d15b81cdfb51b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13546684"
"ResourceRecordKey" => "30015282"
"ModificationTimestamp" => "2026-07-10T01:38:13.73Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30015282_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30015282/a629ecf0d80b6be863f7aae88c1f0492.webp"
"MediaSize" => 84696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30015282/thumbnail-a629ecf0d80b6be863f7aae88c1f0492.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30015282')"
+"ID": "1611937"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: "1611938"
+post_author: 1
+"ListingKey": "30015523"
+"ListingId": "X13546830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T15:10:16Z"
+"RFModificationTimestamp": "2026-07-10T15:12:42Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4G7"
+"UnparsedAddress": "391 TAMARACK DRIVE, Waterloo, Ontario N2L4G7"
+"Coordinates": array:2 [
0 => -80.531687
1 => 43.482781
]
+"Latitude": 43.482781
+"Longitude": -80.531687
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Location, Location, Location!!! Welcome to 391 Tamarack Drive, a beautifully maintained and renovated home located in the heart of Waterloo's highly sought-after University District. Just a short walk to the University of Waterloo, Wilfrid Laurier University, and Conestoga College, this property offers an exceptional opportunity for families, investors, parents of students, or buyers seeking a prime location with strong income potential. Situated in a family-friendly neighborhood, this well-kept raised bungalow features a bright open-concept living and dining area, three generously sized bedrooms, and a large private backyard perfect for relaxing or entertaining. The fully finished ground-floor apartment offers excellent flexibility as an in-law suite, extended family accommodation, or income-generating rental unit with the potential for a separate living arrangement. Additional highlights include a private driveway with parking for up to four vehicles, a spacious lot, and convenient access to public transit, shopping, restaurants, parks, and all major amenities. Located just minutes from Conestoga Mall and Highway 85, this property combines everyday convenience with outstanding long-term value. Located in an area with future medium-rise development potential, this property presents a rare opportunity for both homeowners and investors looking to benefit from Waterloo's continued growth. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T04:39:36.062090+00:00"
+"Directions": "Cross Streets: Austin Drive. ** Directions: columbia St W / Austin Dr/ Tamarack Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915931"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "70.1 x 132.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T03:38:11Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T14:41:13Z"
+"Stories": "1.0"
+"StreetName": "Tamarack"
+"StreetNumber": "391"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4640.52"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30015523/391-tamarack-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 70.1
+"OriginalEntryTimestamp": "2026-07-10T03:38:11.78Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1224695"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30015523')"
+"ID": "1611938"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1611501"
+post_author: 1
+"ListingKey": "30015187"
+"ListingId": "40846224"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T01:05:27Z"
+"RFModificationTimestamp": "2026-07-10T01:36:38Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 957.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1505, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.5264198
1 => 43.4790165
]
+"Latitude": 43.4790165
+"Longitude": -80.5264198
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "2 BEDROOMS, 2 BATHROOMS + LARGE STORAGE LOCKER - Calling all investors, parents of university students, and young professionals. Welcome to Sage Condos in Waterloo’s dynamic University Core. This spacious two-bedroom, two-bathroom suite offers just under 1,000 square feet of thoughtfully designed living space. The open concept layout features a modern kitchen with stainless steel appliances, stone countertops, and ample cabinetry, flowing seamlessly into the bright living area. Large windows bring in natural light, while the private balcony offers expansive city views. Both bedrooms are generously sized, making the layout ideal for roommates or shared living. The unit also includes in-suite laundry and an oversized premium storage locker conveniently located on the same floor, offering rare and practical everyday ease. Located just steps from the University of Waterloo and Wilfrid Laurier University, this is a prime opportunity in one of the city’s most consistent rental pockets. Shops, restaurants, transit including the LRT and GO Bus Station, and everyday amenities are all within walking distance. Sage Condos offers attractive building amenities including a rooftop terrace, gym, party room, and high speed internet. Whether you are building your investment portfolio, securing a property for your child during university, or looking for a well-located urban home, this is a smart and versatile opportunity in the heart of Waterloo. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "627.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T01:36:37.013680+00:00"
+"Directions": "Columbia St W to Spruce St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082150"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-10T00:59:01Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T00:59:01Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4726.46"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=dMFGUqA5E5f&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30015187/318-spruce-street-unit-1505-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2180308"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 957
+"OriginalEntryTimestamp": "2026-07-10T00:59:01.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1356952"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1430151"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30015187')"
+"ID": "1611501"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+post_id: "1609958"
+post_author: 1
+"ListingKey": "30011791"
+"ListingId": "X13543520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T16:50:06Z"
+"RFModificationTimestamp": "2026-07-09T19:45:45Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T2"
+"UnparsedAddress": "215 - 30 BLUE SPRINGS DRIVE, Waterloo, Ontario N2J4T2"
+"Coordinates": array:2 [
0 => -80.526035
1 => 43.488822
]
+"Latitude": 43.488822
+"Longitude": -80.526035
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the highly desirable Waterford community, this bright and spacious 2-bedroom, 2 full bath suite offers peaceful lakeside living in a quiet urban setting. Featuring a desirable split-bedroom layout for added privacy, this home offers over 1,000 sq. ft. of open-concept living space with beautiful views of Four Wells Lake and the surrounding green space. Thoughtful upgrades include wide-plank laminate flooring, quartz countertops in the kitchen and both bathrooms, and a recently replaced owned HVAC system for added comfort and peace of mind. The spacious kitchen and inviting living areas create the perfect space for everyday living and entertaining. Residents enjoy an impressive selection of amenities, including a party room with kitchen, guest suites, library, bike storage, rooftop terrace with gas BBQ, and ample visitor parking. Ideally situated near scenic walking and cycling trails, including the Forwell Trail, and just minutes from everyday conveniences such as No Frills, Farm Boy, Conestoga Mall, restaurants, the University of Waterloo, and Wilfrid Laurier University. Additional features include in-suite laundry, one underground parking space, and an exclusive-use storage locker. Whether you're entering the market, simplifying your lifestyle, or looking for a smart investment opportunity, this beautiful condo offers an incredible opportunity to enjoy lakeside living with all the conveniences of city life. **Building has access to local trails and private lakefront boardwalk. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "881.46"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "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-07-09T19:45:19.341170+00:00"
+"Directions": "Cross Streets: King Street North. ** Directions: King Street North To Blue Springs Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081113"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-09T16:41:08Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T16:41:08Z"
+"StreetName": "Blue Springs"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2498.91"
+"View": "Lake view,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://vimeo.com/1192979226?fl=ip&fe=ec"
+"WaterBodyName": "Four Wells Lake"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011791/215-30-blue-springs-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Property"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-07-09T16:41:08.31Z"
+"ListAgentNationalAssociationId": "1355945"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011791')"
+"ID": "1609958"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+post_id: "1609959"
+post_author: 1
+"ListingKey": "30011798"
+"ListingId": "X13543652"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T16:50:06Z"
+"RFModificationTimestamp": "2026-07-09T19:44:50Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "2429 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538447
1 => 43.476844
]
+"Latitude": 43.476844
+"Longitude": -80.538447
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the most desired Society 145 Condo building in the heart of the Waterloo University District. Modern fully furnished 1+1 bedroom, 1 bath unit perfect for investors. The unit boasts 10 ft ceiling, with abundance of natural light with a large sun filled open concept Kitchen with Quartz countertops and backsplash, built-in stainless-steel appliances. The living room features luxury laminate flooring media accent wall with a large floor to ceiling window,modern light fixtures as well as built-in desks, beds, side tables in the bedrooms, modern barnstyle sliding doors. The condominium provides start of the art fitness centre, basketball court, sauna, multimedia room, games room, party room stunning rooftop terrace, yoga studio, 24hr security, keyless entry, business studying and network lounges as well as Starbucks in the lobby. Prime Location across the University of Waterloo, walking distance to Wilfred LaurierUniversity, Uptown Waterloo and the new LRT Station. For investors this location consistentlyattracts strong rental demand making it a smart and reliable addition to your portfolio. A true win in one of Waterloo's most sought after areas. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "357.62"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:44:34.046949+00:00"
+"Directions": "Columbia St W & Phillip St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2222768"
+"ListOfficeKey": "293109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-09T16:41:09Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T16:41:09Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3466.07"
+"View": "View"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011798/2429-145-columbia-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group KWG Inc."
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-09T16:41:09.31Z"
+"ListAgentNationalAssociationId": "1466403"
+"ListOfficeNationalAssociationId": "1422605"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011798')"
+"ID": "1609959"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1609388"
+post_author: 1
+"ListingKey": "30013050"
+"ListingId": "40846469"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T19:05:32Z"
+"RFModificationTimestamp": "2026-07-09T19:16:25Z"
+"ListPrice": 459900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 940.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 2008, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5162927
1 => 43.4659934
]
+"Latitude": 43.4659934
+"Longitude": -80.5162927
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 2008 at Waterpark Place, one of Waterloo's most sought-after condominiums, where comfortable living meets spectacular Uptown views. This bright and inviting 1-bedroom condo features an abundance of natural light and stunning northwest-facing views that offer breathtaking sunsets from the spacious private balcony. Enjoy the convenience of underground parking and an exclusive-use locker, providing both ease and extra storage. Set on four acres of beautifully manicured land, this renowned building offers an exceptional lifestyle with premium amenities, including an indoor pool, sauna, fitness centre, library, billiards room, party room, conference room, guest suites, ample visitor parking, secure controlled entry, and on-site property management. Step outside to relax by the tranquil pond or unwind in one of the many outdoor seating areas surrounded by mature landscaping. Ideally located in the heart of Uptown Waterloo, you'll be just steps away from boutique shops, restaurants, groceries, parks, trails, the LRT/transit and much more! Whether you're a first-time buyer, downsizer, or simply looking for lock and go living, Unit 2008 offers an outstanding opportunity to enjoy comfort, convenience, and exceptional amenities in one of Waterloo's most desirable addresses. Don't delay and book your showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "658"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Other, See Remarks"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:16:17.626391+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160855"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Balcony"
2 => "No Pet Home"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T19:02:44Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T19:02:44Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3658"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/2008_6_willow_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30013050/6-willow-street-unit-2008-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563990"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 940
+"OriginalEntryTimestamp": "2026-07-09T18:59:42.03Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1411946"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1070024"
+"CoListOfficeNationalAssociationId": "1389824"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013050')"
+"ID": "1609388"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23483
+post_id: "1608426"
+post_author: 1
+"ListingKey": "30010656"
+"ListingId": "40846173"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:55:19Z"
+"RFModificationTimestamp": "2026-07-09T16:05:21Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T2"
+"UnparsedAddress": "30 BLUE SPRINGS Drive Unit# 215, Waterloo, Ontario N2J4T2"
+"Coordinates": array:2 [
0 => -80.5260897
1 => 43.4888152
]
+"Latitude": 43.4888152
+"Longitude": -80.5260897
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable Waterford community, this bright and spacious 2-bedroom, 2 full bath suite offers peaceful lakeside living in a quiet urban setting. Featuring a desirable split-bedroom layout for added privacy, this home offers over 1,000 sq. ft. of open-concept living space with beautiful views of Four Wells Lake and the surrounding green space. Thoughtful upgrades include wide-plank laminate flooring, quartz countertops in the kitchen and both bathrooms, and a recently replaced owned HVAC system for added comfort and peace of mind. The spacious kitchen and inviting living areas create the perfect space for everyday living and entertaining. Residents enjoy an impressive selection of amenities, including a party room with kitchen, guest suites, library, bike storage, rooftop terrace with gas BBQ, and ample visitor parking. Ideally situated near scenic walking and cycling trails, including the Forwell Trail, and just minutes from everyday conveniences such as No Frills, Farm Boy, Conestoga Mall, restaurants, the University of Waterloo, and Wilfrid Laurier University. Additional features include in-suite laundry, one underground parking space, and an exclusive-use storage locker. Whether you’re entering the market, simplifying your lifestyle, or looking for a smart investment opportunity, this beautiful condo offers an incredible opportunity to enjoy lakeside living with all the conveniences of city life. **Building has access to local trails and private lakefront boardwalk. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "881.46"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:59:35.187514+00:00"
+"Directions": "King Street North To Blue Springs Drive"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1875438"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-09T14:48:40Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:48:23Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2498.91"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://vimeo.com/1192979226?fl=ip&fe=ec"
+"WaterBodyName": "Four Wells Lake"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30010656/30-blue-springs-drive-unit-215-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2158242"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-07-09T14:48:40.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204077"
+"ListOfficeNationalAssociationId": "1408460"
+"CoListAgentNationalAssociationId": "1409588"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010656')"
+"ID": "1608426"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25385
+post_id: "1603715"
+post_author: 1
+"ListingKey": "30003757"
+"ListingId": "X13536140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T21:30:11Z"
+"RFModificationTimestamp": "2026-07-10T21:34:24Z"
+"ListPrice": 673000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4A1"
+"UnparsedAddress": "97 BLYTHWOOD ROAD, Waterloo, Ontario N2L4A1"
+"Coordinates": array:2 [
0 => -80.535497
1 => 43.486518
]
+"Latitude": 43.486518
+"Longitude": -80.535497
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Turnkey Duplex Investment in a Prime Waterloo Location! Situated on an expansive 62' x 147' mature lot, this well-maintained legal duplex offers an exceptional opportunity for investors and owner-occupiers alike. Located just 3 minutes from the University of Waterloo, Wilfrid Laurier University, and the Waterloo Technology Park, this property benefits from strong, year-round rental demand driven by students and professionals. The legal basement apartment is separately rented, providing immediate income potential, while the upper unit offers additional rental income or the flexibility for owner occupancy. The large, tree-lined backyard features two storage sheds, adding valuable storage space, and the property offers parking for up to five vehicles. With easy access to major highways, top educational institutions, and Waterloo's thriving tech corridor, this is a rare opportunity to own a turnkey income property in one of the region's most desirable investment locations. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T14:08:48.091190+00:00"
+"Directions": "Cross Streets: Webber and Blythwood RD. ** Directions: Turn left to Blythwood from Webber St."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127798"
+"ListOfficeKey": "277399"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "62.1 x 146.8 FT ; 146.78ft X 62.15ft X146.80ft X39.01ft"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-08T12:06:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T21:04:27Z"
+"StreetName": "Blythwood"
+"StreetNumber": "97"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4583"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=j_wFJsRFNuQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30003757/97-blythwood-road-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 62.1
+"OriginalEntryTimestamp": "2026-07-08T12:06:22.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381042"
+"ListOfficeNationalAssociationId": "1282815"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30003757')"
+"ID": "1603715"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25386
+post_id: "1602740"
+post_author: 1
+"ListingKey": "30002359"
+"ListingId": "40846189"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T22:25:18Z"
+"RFModificationTimestamp": "2026-07-08T01:14:58Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1766.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Y4"
+"UnparsedAddress": "299 DALE Crescent, Waterloo, Ontario N2J3Y4"
+"Coordinates": array:2 [
0 => -80.5092637
1 => 43.4842672
]
+"Latitude": 43.4842672
+"Longitude": -80.5092637
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 299 Dale Crescent – your chance to own a beautifully updated home on a quiet crescent in Waterloo's sought-after Glenridge neighbourhood. This bright and inviting 3 bedroom, 2 bathroom home has been extensively renovated, featuring modern finishes, updated flooring, and lighting throughout. The spacious open concept main level boasts an updated kitchen with quartz countertops by Franklin Kitchens and upgraded stainless-steel appliances, a living room with an accent wall and large windows, and a dining room with a bay window. The second level offers 3 spacious bedrooms and a fully renovated bathroom. The lower level includes a separate entrance, a fully finished rec room, bathroom, and laundry room, an ideal space for relaxation or entertaining. Outside, enjoy a private fenced backyard with a large yard and detached double car garage. Don't miss this rare opportunity to own a turn-key home with major updates already complete. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T01:14:51.247886+00:00"
+"Directions": "University Ave to Dale Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060458"
+"ListOfficeKey": "292862"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Private Yard"
]
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-07T22:01:10Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T22:18:29Z"
+"Stories": "2.0"
+"StreetName": "DALE"
+"StreetNumber": "299"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4697.82"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30002359/299-dale-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1194
+"BelowGradeFinishedArea": 572
+"OriginalEntryTimestamp": "2026-07-07T21:59:01.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1335588"
+"ListOfficeNationalAssociationId": "1418673"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002359')"
+"ID": "1602740"
}
]
+success: true
+page_size: 9
+page_count: 36
+count: 322
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]