array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29150063/Property?$select=ALL&$top=20&$filter=ListingKey eq 29150063&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29150063/Property?$select=ALL&$top=20&$filter=ListingKey eq 29150063&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23312
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23314
+post_id: "454669"
+post_author: 1
+"ListingKey": "29150063"
+"ListingId": "40791159"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T13:35:16Z"
+"RFModificationTimestamp": "2025-12-01T17:43:38Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1119.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 706, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5225571
1 => 43.4871516
]
+"Latitude": 43.4871516
+"Longitude": -80.5225571
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover tranquil, sophisticated condo living at The Atriums. Nestled in a peaceful setting, you are surrounded by scenic trails yet minutes from major conveniences: Conestoga Mall, the LRT, prestigious Universities, and quick access to the expressway. This unit is a stunningly updated, bright, and spacious retreat. The gorgeous open-concept kitchen anchors the living space, featuring quartz counters, a tiled backsplash, built-in pantry, oversized pot drawers, soft-close cabinets, and high-end stainless steel appliances. Modern flooring, contemporary fixtures, and designer decor elevate the entire unit. Enjoy an abundance of natural light and wonderful forest views through the large windows. This sought-after unit offers 2 bedrooms, 2 full updated bathrooms, convenient in-suite laundry, and a storage locker. A rare find, it includes TWO owned parking spaces! Upgrades abound, including new laminate flooring and LED pot lights throughout. The expansive living/dining area is perfect for entertaining and family gatherings. The primary bedroom boasts an updated 4-piece ensuite and a double closet walk-through. The building's amenities enhance your lifestyle: controlled entry, library, workshop, underground parking, bicycle storage, a fantastic rooftop lounge/sun deck, two party rooms with full facilities, and a dedicated Guest Suite for visitors. Don't miss out on this exceptional opportunity! Call your agent today to schedule your private viewing. Note some photos are virtually staged. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "730.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T17:43:24.616911+00:00"
+"Directions": "King St N to Blue Springs Dr, turn right into ""The Atriums"", visitor parking is above the parking garage (stay right). From the parking lot, take the stairs down to the main front entrance."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564578"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-01T13:29:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T13:29:27Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3195"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/55_blue_springs_dr_706_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1543082640"
"RoomType" => "Dining room"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
1 => array:11 [
"RoomKey" => "1543082641"
"RoomType" => "Full bathroom"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
2 => array:11 [
"RoomKey" => "1543082642"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
3 => array:11 [
"RoomKey" => "1543082643"
"RoomType" => "Living room"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 27'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
4 => array:11 [
"RoomKey" => "1543082644"
"RoomType" => "Kitchen"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
5 => array:11 [
"RoomKey" => "1543082645"
"RoomType" => "Bedroom"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
6 => array:11 [
"RoomKey" => "1543082646"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791159"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29150063"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T13:29:27.64Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29150063/55-blue-springs-drive-unit-706-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1119
+"OriginalEntryTimestamp": "2025-12-01T13:29:27.53Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:46 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6349496282"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/cc60b03b270c13536558fce895fcf442.webp"
"MediaSize" => 81313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-cc60b03b270c13536558fce895fcf442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6349496361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/5f1ce056a8c509b559109f7375b56f26.webp"
"MediaSize" => 90478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-5f1ce056a8c509b559109f7375b56f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6349496412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/8cb3d6b4666eee5bedcc865f8440c7ea.webp"
"MediaSize" => 43762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-8cb3d6b4666eee5bedcc865f8440c7ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6349496514"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/f86f72082295cbd4e46968fe259854bf.webp"
"MediaSize" => 63377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-f86f72082295cbd4e46968fe259854bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6349496631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/f546dc2cc19e8035eb70545d4e14b7bc.webp"
"MediaSize" => 42249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-f546dc2cc19e8035eb70545d4e14b7bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6349496663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/de9c2b9584f0fc090459b42942ffd6a1.webp"
"MediaSize" => 102218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-de9c2b9584f0fc090459b42942ffd6a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6349496712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/650c686e651acce38fe946208e79276f.webp"
"MediaSize" => 119951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-650c686e651acce38fe946208e79276f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6349496810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/f46507e04e5ed987f24a339acecbbaf6.webp"
"MediaSize" => 75025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-f46507e04e5ed987f24a339acecbbaf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6349496901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/9cc9bcb252fecbcc8ad6005be9aab991.webp"
"MediaSize" => 54903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-9cc9bcb252fecbcc8ad6005be9aab991.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6349496947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/1e0cc430d88e3881c26b9f536fec5f97.webp"
"MediaSize" => 221055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-1e0cc430d88e3881c26b9f536fec5f97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6349497020"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/0e85cfd8120f37bf518297e725ed23be.webp"
"MediaSize" => 53946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-0e85cfd8120f37bf518297e725ed23be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6349497104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/a9181876a84eebf0231ac56e0e5c0579.webp"
"MediaSize" => 46863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-a9181876a84eebf0231ac56e0e5c0579.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6349497210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/344db2ab1d1808a6664fb95625855fd9.webp"
"MediaSize" => 87758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-344db2ab1d1808a6664fb95625855fd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6349497289"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/aa924866e751b2fbeb0cdc5dcc1e5f6a.webp"
"MediaSize" => 37264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-aa924866e751b2fbeb0cdc5dcc1e5f6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6349497373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/0e8e99b7395a15d664a291c92c4ad717.webp"
"MediaSize" => 167591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-0e8e99b7395a15d664a291c92c4ad717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6349497442"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/c2f3d3a28a640bc183af014dbdd66468.webp"
"MediaSize" => 62692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-c2f3d3a28a640bc183af014dbdd66468.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6349497480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/6b7810a2c8d9d5df54c09ba21d593656.webp"
"MediaSize" => 67706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-6b7810a2c8d9d5df54c09ba21d593656.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6349497560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/e480b1de87196e9a9fb9aaac5ea6f94b.webp"
"MediaSize" => 53304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-e480b1de87196e9a9fb9aaac5ea6f94b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6349497635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/192b808d2eaa6c3542a9a6c0d9d094d4.webp"
"MediaSize" => 68282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-192b808d2eaa6c3542a9a6c0d9d094d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6349497665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/b3156f63ad8dc5c2c9fa05b2719d1d1e.webp"
"MediaSize" => 44008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-b3156f63ad8dc5c2c9fa05b2719d1d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6349497709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/6320f2ffbb3e265eb9c25f0e64ab7ed6.webp"
"MediaSize" => 46758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-6320f2ffbb3e265eb9c25f0e64ab7ed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6349497730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/c4f60d380765e3d29cee36cec8296531.webp"
"MediaSize" => 54019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-c4f60d380765e3d29cee36cec8296531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6349497741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/a371437ed7adfad3ded54816f8def151.webp"
"MediaSize" => 46209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-a371437ed7adfad3ded54816f8def151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6349497750"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/891e53bd2b88b1e75fe15716580334f0.webp"
"MediaSize" => 69406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-891e53bd2b88b1e75fe15716580334f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6349497792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/3cf096b53dab385ff10f636ea8845068.webp"
"MediaSize" => 31869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-3cf096b53dab385ff10f636ea8845068.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6349497871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/241d4db8c8541d1c683a463a1a70488c.webp"
"MediaSize" => 60977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-241d4db8c8541d1c683a463a1a70488c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6349497887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/5c55d65bf471eff199fb60d2d8ae67b3.webp"
"MediaSize" => 119846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-5c55d65bf471eff199fb60d2d8ae67b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6349497940"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/8e0c6541e2f7046a3f944beeab715947.webp"
"MediaSize" => 40818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-8e0c6541e2f7046a3f944beeab715947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6349497993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/12b67b2314d3e231d611b0635774d37f.webp"
"MediaSize" => 42217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-12b67b2314d3e231d611b0635774d37f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6349498041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/284beb43318bd026affdc5fdd10d7c8a.webp"
"MediaSize" => 113698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-284beb43318bd026affdc5fdd10d7c8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6349498069"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/90ae20ed99220e474e8f7cc16826932f.webp"
"MediaSize" => 60017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-90ae20ed99220e474e8f7cc16826932f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6349498085"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/cff2bb00a5820d64fb791fc41bdbc0c5.webp"
"MediaSize" => 66141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-cff2bb00a5820d64fb791fc41bdbc0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6349498134"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/bf9d05af1ea5b1b6394f3143633bdc8e.webp"
"MediaSize" => 121911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-bf9d05af1ea5b1b6394f3143633bdc8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6349498158"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/78218b7a3f77726c870701e8d6069e73.webp"
"MediaSize" => 103770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-78218b7a3f77726c870701e8d6069e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6349498169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/3f527dae29753d33cef745f31f5a83cf.webp"
"MediaSize" => 174910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-3f527dae29753d33cef745f31f5a83cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6349498211"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/3ae961fd03972cf1b576922ee0c1f75c.webp"
"MediaSize" => 125558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-3ae961fd03972cf1b576922ee0c1f75c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6349498237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/0585150937edb322f5b0c8c704c42aa8.webp"
"MediaSize" => 73174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-0585150937edb322f5b0c8c704c42aa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6349498269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/81c46c5e11936805a6e1d38812d15a59.webp"
"MediaSize" => 208575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-81c46c5e11936805a6e1d38812d15a59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6349498282"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/137da5da0cf5b4e24b87bf1561e20c88.webp"
"MediaSize" => 64800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-137da5da0cf5b4e24b87bf1561e20c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6349498307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/ef227c7d5cc06657dac292622d61ecb6.webp"
"MediaSize" => 58593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-ef227c7d5cc06657dac292622d61ecb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6349498340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/dce3dcdd76a3f335590f7613e3b74e8d.webp"
"MediaSize" => 60573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-dce3dcdd76a3f335590f7613e3b74e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6349498365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/dd47a2131d03b6710f612a6aa251b3f1.webp"
"MediaSize" => 54896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-dd47a2131d03b6710f612a6aa251b3f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6349498395"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/a04fb2759f0199fc427e29c814d41526.webp"
"MediaSize" => 99996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-a04fb2759f0199fc427e29c814d41526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6349498427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/014c615ac8a38d9f111a6bd4275dd689.webp"
"MediaSize" => 143781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-014c615ac8a38d9f111a6bd4275dd689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6349498440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/e03b916d34bb784d448efd1a5cf62e8e.webp"
"MediaSize" => 81595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-e03b916d34bb784d448efd1a5cf62e8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6349498461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150063/49e50de48550c8160e0996fd054393a5.webp"
"MediaSize" => 98650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150063/thumbnail-49e50de48550c8160e0996fd054393a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791159"
"ResourceRecordKey" => "29150063"
"ModificationTimestamp" => "2025-12-01T13:29:27.54Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150063')"
+"ID": "454669"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289541&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25179
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Wolle Realty"
+"OfficeEmail": null
+"OfficePhone": "519-578-7300"
+"OfficeMlsId": "KW348"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289541"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "71 Weber Street E., Unit B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2H1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1378680"
+"OriginalEntryTimestamp": "2021-02-10T20:35:00Z"
+"OfficeFax": "519-742-9904"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "10163"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "289541"
"SocialMediaUrlOrId" => "https://wollerealty.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1069818"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289541')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564578/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564578&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564578/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564578&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25184
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29150063" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24764
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29150063/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29150063&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29150063/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29150063&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24689
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29150063 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5225571 43.4871516)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29150063 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5225571 43.4871516)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29150063 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5225571 43.4871516)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29150063 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5225571 43.4871516)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25047
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25030
+post_id: "451917"
+post_author: 1
+"ListingKey": "29147256"
+"ListingId": "X12586322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T17:40:42Z"
+"RFModificationTimestamp": "2025-11-29T17:43:23Z"
+"ListPrice": 438000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G616 - 275 LARCH ST STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.532235
1 => 43.476892
]
+"Latitude": 43.476892
+"Longitude": -80.532235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**Excellent Location!** This fully furnished 2-bedroom apartment is located very close to Wilfrid Laurier University, the University of Waterloo, and Conestoga College. It's also near restaurants, grocery stores, parks, and theaters. The maintenance fees is low and include internet, water, and heating. The building features a fully equipped gym, a yoga and meditation room, a study lounge, as well as a theater and games room. Enjoy living in a clean and quiet neighborhood-this property is a fantastic investment opportunity for university parents and first-time buyers! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "293.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T22:58:29.518925+00:00"
+"Directions": "University Ave W & Albert St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129792"
+"ListOfficeKey": "234480"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T21:28:58Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T17:27:38Z"
+"StreetName": "Larch St"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2266.77"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1542043108"
"RoomType" => "Living room"
"ListingId" => "X12586322"
"RoomLevel" => "Flat"
"RoomWidth" => 2.92
"ListingKey" => "29147256"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T17:27:38.19Z"
]
1 => array:11 [
"RoomKey" => "1542043109"
"RoomType" => "Kitchen"
"ListingId" => "X12586322"
"RoomLevel" => "Flat"
"RoomWidth" => 1.09
"ListingKey" => "29147256"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T17:27:38.21Z"
]
2 => array:11 [
"RoomKey" => "1542043110"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12586322"
"RoomLevel" => "Flat"
"RoomWidth" => 2.74
"ListingKey" => "29147256"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T17:27:38.22Z"
]
3 => array:11 [
"RoomKey" => "1542043111"
"RoomType" => "Bedroom 2"
"ListingId" => "X12586322"
"RoomLevel" => "Flat"
"RoomWidth" => 2.74
"ListingKey" => "29147256"
"RoomLength" => 2.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-29T17:27:38.23Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29147256/g616-275-larch-st-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T21:28:58.06Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:10 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6345023380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/070df9c235c18afcfe3dbbf14d196c19.webp"
"MediaSize" => 100880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-070df9c235c18afcfe3dbbf14d196c19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6345023422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/875a74cfdaa2e5904c1f3896ad435b81.webp"
"MediaSize" => 150761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-875a74cfdaa2e5904c1f3896ad435b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6345023469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/bd3cf2cbf8464b67a5184e37032e0da1.webp"
"MediaSize" => 119296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-bd3cf2cbf8464b67a5184e37032e0da1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6345023585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/fa69563cdf37dda2d6a19f8d112517a9.webp"
"MediaSize" => 98161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-fa69563cdf37dda2d6a19f8d112517a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6345023604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/d1728b63fa906da233b5fe126f5b38ef.webp"
"MediaSize" => 204671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-d1728b63fa906da233b5fe126f5b38ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6345023713"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/3a180b9416104424708be7ef5051f64b.webp"
"MediaSize" => 245693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-3a180b9416104424708be7ef5051f64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6345023763"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/0dcce3d83bd03684d4313e173dc1b1f9.webp"
"MediaSize" => 106053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-0dcce3d83bd03684d4313e173dc1b1f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6345023861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/0f857e8f68d37568055c56932f33fcdc.webp"
"MediaSize" => 109110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-0f857e8f68d37568055c56932f33fcdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6345023897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/dc383f6e5825449ef9a32040e39be1f6.webp"
"MediaSize" => 121011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-dc383f6e5825449ef9a32040e39be1f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6345023931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29147256/abe5968eecfaa6303a9fe4720c5798f5.webp"
"MediaSize" => 206446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29147256/thumbnail-abe5968eecfaa6303a9fe4720c5798f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12586322"
"ResourceRecordKey" => "29147256"
"ModificationTimestamp" => "2025-11-28T21:28:58.07Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29147256')"
+"ID": "451917"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25032
+post_id: "450780"
+post_author: 1
+"ListingKey": "29145430"
+"ListingId": "X12584700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T18:45:34Z"
+"RFModificationTimestamp": "2025-11-28T18:50:17Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2Y2"
+"UnparsedAddress": "307 - 158 KING STREET, Waterloo, Ontario N2J2Y2"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 773 sq. ft. corner unit featuring 2 bedrooms, an impressive west-facing view, modernfinishes, 9 ft. ceilings, and quality laminate and tile flooring. The open-concept contemporarykitchen enhances the bright, functional layout. Ideally located within walking distance to theUniversity of Waterloo, Wilfrid Laurier University, and Uptown Waterloo, with convenient busstops right at the building's doorstep. Excellent Place to live - this property is a must-see! Tenant occupied property, so will require prior notice before showing. SELLER IS WILLING TO OFFER 5% DOWN PAYMENT TO FIRST TIME HOME BUYERS OR SIMILAR COMPENSATION TO INVESTOR . (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "492.2"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T16:40:55.218987+00:00"
+"Directions": "UNIVERSITY AVE/KING ST N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243854"
+"ListOfficeKey": "293109"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:02:38Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T18:33:14Z"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3523.06"
+"Rooms": array:1 [
0 => array:11 [
"RoomKey" => "1541531912"
"RoomType" => "Bedroom"
"ListingId" => "X12584700"
"RoomLevel" => "Main level"
"RoomWidth" => 2.5
"ListingKey" => "29145430"
"RoomLength" => 5.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:33:14.79Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29145430/307-158-king-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management (519-778-5986)"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T16:02:38.75Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6344399795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/8581e47275d0ff95d0233b18fa918c7b.webp"
"MediaSize" => 89594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-8581e47275d0ff95d0233b18fa918c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6344399814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/a1ced41b76d6dbce04f71581c7d0b516.webp"
"MediaSize" => 122849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-a1ced41b76d6dbce04f71581c7d0b516.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6344399820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/00a5108507f29e8fc84f2a9c7ab2c03a.webp"
"MediaSize" => 101111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-00a5108507f29e8fc84f2a9c7ab2c03a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6344399876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/9899ce9a3b6e2a656cfa13d3a4ca761c.webp"
"MediaSize" => 89176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-9899ce9a3b6e2a656cfa13d3a4ca761c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6344399945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/94d1a6e098fc04281144ed0bdaa782b2.webp"
"MediaSize" => 71767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-94d1a6e098fc04281144ed0bdaa782b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6344399970"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/b18299daf0434f0bc55025efe6d9a0a0.webp"
"MediaSize" => 88078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-b18299daf0434f0bc55025efe6d9a0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6344400033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/3c5878eaf736de80954f0aaf2a569247.webp"
"MediaSize" => 115006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-3c5878eaf736de80954f0aaf2a569247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6344400068"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/ff9f4ccc4b686125bb4035e94350b13f.webp"
"MediaSize" => 139201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-ff9f4ccc4b686125bb4035e94350b13f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6344400100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/7f059034b82b8c253452473b6144361d.webp"
"MediaSize" => 91064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-7f059034b82b8c253452473b6144361d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6344400151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/a1f9c2124a512a8a71642f16b4cd8a89.webp"
"MediaSize" => 221508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-a1f9c2124a512a8a71642f16b4cd8a89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6344400192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/062ab756708fdcb935ff1d4025211810.webp"
"MediaSize" => 69232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-062ab756708fdcb935ff1d4025211810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6344400214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/1cc5265d11a531569f8eccb28958a39d.webp"
"MediaSize" => 205567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-1cc5265d11a531569f8eccb28958a39d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6344400237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/53e9cf7873af8391159628f6dc114ae0.webp"
"MediaSize" => 83717
…9
]
13 => array:13 [ …13]
14 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145430')"
+"ID": "450780"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25029
+post_id: "450704"
+post_author: 1
+"ListingKey": "29145460"
+"ListingId": "X12584864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T16:20:43Z"
+"RFModificationTimestamp": "2025-11-28T16:37:58Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE ROAD, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114497
1 => 43.5023835
]
+"Latitude": 43.5023835
+"Longitude": -80.5114497
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today's market. Set on one of Waterloo's most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we've created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It's rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility - an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo's most established and beloved neighbourhoods - close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region's best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you're looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T16:37:40.228806+00:00"
+"Directions": "Cross Streets: Lee & Old Stone Rd. ** Directions: Lexington to Lee, to Old Stone Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240105"
+"ListOfficeKey": "284058"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "135 x 137 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:05:31Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T16:05:31Z"
+"Stories": "2.0"
+"StreetName": "Old Stone"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15626.35"
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:28 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
27 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29145460/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 135.0
+"OriginalEntryTimestamp": "2025-11-28T16:05:31.77Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145460')"
+"ID": "450704"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25034
+post_id: "450426"
+post_author: 1
+"ListingKey": "29144698"
+"ListingId": "X12583898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T02:35:27Z"
+"RFModificationTimestamp": "2025-11-28T03:30:00Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "1711 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 145 Columbia St W #1711 Luxury Living with Stunning Views in Waterloo's University District! Elevate your lifestyle with this gorgeous 2-bedroom, 1 bathroom condo perched on the 17th floor of the sought-after 145 Society Condos. Offering clear, unobstructed views and a fully furnished, turnkey layout, this modern unit is the perfect opportunity for investors, students, and first-time buyers alike. Enjoy thoughtfully designed interiors and high-end finishes throughout:? Sun-filled open-concept living space with floor-to-ceiling windows and breathtaking skyline views? Stylish kitchen with quartz countertops, chic backsplash, and built-in stainless steel appliances Sleek luxury laminate flooring, contemporary light fixtures, and a designer media accent wall? ? Two spacious bedrooms featuring built-in desks, beds, side tables, and trendy barn-style sliding doors World-Class Amenities Include:. Fully equipped fitness centre. Indoor basketball court?? Yoga studio & rejuvenating sauna. Games room, media lounge, and party room. Spectacular rooftop terrace with panoramic views. 24-hour security, keyless entry, and professional business/study lounges. On-site Starbucks in the lobby Prime Location: Ideally located just steps from University of Waterloo, and walking distance to Wilfrid Laurier University, Uptown Waterloo, and the LRT Station this location offers unbeatable convenience. This unit is cash flow positive with a current rental income of $2500 per month. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wall Mounted TV"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "274.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T03:29:55.043452+00:00"
+"Directions": "Columbia St, Phillip St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082108"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Partially cleared"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T02:27:49Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T02:27:49Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3141"
+"View": "View"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29144698/1711-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group KWG Inc."
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T02:27:49.05Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29144698')"
+"ID": "450426"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25031
+post_id: "449238"
+post_author: 1
+"ListingKey": "29142145"
+"ListingId": "X12581810"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T16:35:24Z"
+"RFModificationTimestamp": "2025-11-27T20:44:55Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "315 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Available from Jan 1 -book your viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T20:44:45.639182+00:00"
+"Directions": "Cross Streets: Hickory Street/Spruce Street. ** Directions: From Columbia St w to Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "168772"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T16:23:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T16:23:09Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29142145/315-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board"
+"GeocodeManualYN": false
+"TotalActualRent": 1950
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-27T16:23:09.65Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29142145')"
+"ID": "449238"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25025
+post_id: "449247"
+post_author: 1
+"ListingKey": "29143240"
+"ListingId": "40790704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T19:45:34Z"
+"RFModificationTimestamp": "2025-11-27T20:15:52Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 6334.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE Road, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114374
1 => 43.5026033
]
+"Latitude": 43.5026033
+"Longitude": -80.5114374
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today’s market. Set on one of Waterloo’s most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we’ve created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It’s rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility — an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo’s most established and beloved neighbourhoods — close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region’s best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you’re looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ductless"
]
+"CreationDate": "2025-11-27T20:15:42.815291+00:00"
+"Directions": "Lexington to Lee, to Old Stone Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Radiant heat"
1 => "Forced air"
2 => "In Floor Heating"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1889883"
+"ListOfficeKey": "274578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
3 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T19:38:38Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T19:38:38Z"
+"Stories": "2.0"
+"StreetName": "OLD STONE"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "15626.35"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:30 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
27 => array:11 [ …11]
28 => array:11 [ …11]
29 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29143240/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 4933
+"BelowGradeFinishedArea": 1401
+"OriginalEntryTimestamp": "2025-11-27T19:38:38.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143240')"
+"ID": "449247"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23326
+post_id: "448852"
+post_author: 1
+"ListingKey": "29142512"
+"ListingId": "X12581936"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T17:35:35Z"
+"RFModificationTimestamp": "2025-11-27T19:51:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H4"
+"UnparsedAddress": "225 HARVARD PLACE, Waterloo, Ontario N2J4H4"
+"Coordinates": array:2 [
0 => -80.5051
1 => 43.483891
]
+"Latitude": 43.483891
+"Longitude": -80.5051
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 225 Harvard Place Unit #611 - an exceptional opportunity to rent a beautifully maintained 1-bedroom, 1-bathroom condo offering 711 sq. ft. of bright, functional living space. This unit is located in a highly sought-after, amenity-rich building that's truly one-of-a-kind. Enjoy exclusive access to TWO fully-equipped gyms, a relaxing sauna, party room, library, children's playground, and a hobby workshop room - everything you need is right at your fingertips! Only 5 minutes to both the University of Waterloo and Wilfrid Laurier University, and just steps away from top-rated schools - an ideal location for students and families alike. A large shopping plaza is located directly behind the building, offering groceries, restaurants, banks, and more - all within walking distance. Includes underground parking and ample visitor parking right at the front entrance. Conveniently located just off Highway 85, offering quick access to everything the Waterloo Region has to offer. This unit offers incredible value, unbeatable location, and lifestyle convenience. Don't miss your chance - this one won't last! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"CreationDate": "2025-11-27T19:50:54.584044+00:00"
+"Directions": "Cross Streets: University Ave E. ** Directions: Bluevale, Harvard."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2208471"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-27T17:30:20Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T17:30:20Z"
+"StreetName": "HARVARD"
+"StreetNumber": "225"
+"StreetSuffix": "Place"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29142512/225-harvard-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2200
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-27T17:30:20.22Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29142512')"
+"ID": "448852"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25035
+post_id: "448699"
+post_author: 1
+"ListingKey": "29142944"
+"ListingId": "X12582284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T18:40:41Z"
+"RFModificationTimestamp": "2025-11-27T19:26:35Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3L2"
+"UnparsedAddress": "730 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L3L2"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience modern urban living in this bright and stylish 1-bedroom plus den condo, ideally situated in the highly sought-after Society 145 Waterloo Residences in the heart of the University District. This thoughtfully designed, fully furnished unit features an open-concept layout with a sleek modern kitchen, complete with designer backsplash and quality finishes. The den offers flexible space perfect for a home office or guest area. Enjoy breathtaking sunset views from this sunlit unit or the stunning rooftop terrace a perfect extension of your living space. Residents also enjoy access to top-tier amenities including a fully equipped gym, a chic party room, and more. An exceptional opportunity for students, professionals, or investors, with condo fees estimated. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "311.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T19:26:31.855362+00:00"
+"Directions": "Phillips St & Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1877313"
+"ListOfficeKey": "293894"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T18:33:56Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T18:33:56Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3150"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29142944/730-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-11-27T18:33:56.35Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29142944')"
+"ID": "448699"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25049
+post_id: "447222"
+post_author: 1
+"ListingKey": "29140568"
+"ListingId": "X12580172"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T23:06:04Z"
+"RFModificationTimestamp": "2025-11-27T01:05:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G611 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.5313421
1 => 43.4771648
]
+"Latitude": 43.4771648
+"Longitude": -80.5313421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Unbeatable Location! Spacious 2-Bed, 2-Bath Condo for Lease Discover this bright and spacious, 2-bedroom, 2-bathroom unit Located in a prime area, you'll be minutes away from Wilfrid Laurier and the University of Waterloo, as well as an abundance of restaurants, grocery stores, parks,and theater. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:05:26.277972+00:00"
+"Directions": "HICKORY ST W & HEMLOCK ST"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423976"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:58:53Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:58:53Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140568/g611-275-larch-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1966494"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "URL CONDOS, BUILDING G"
+"CoListOfficeKey": "275784"
+"GeocodeManualYN": false
+"TotalActualRent": 2049
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T22:58:53.08Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:16 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140568')"
+"ID": "447222"
}
]
+success: true
+page_size: 9
+page_count: 26
+count: 228
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]
