array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29803033 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1458694"
+post_author: 1
+"ListingKey": "29803033"
+"ListingId": "40832970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:45Z"
+"RFModificationTimestamp": "2026-06-02T16:36:54Z"
+"ListPrice": 585000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1930.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H8"
+"UnparsedAddress": "250 GLENRIDGE Drive Unit# 401, Waterloo, Ontario N2J4H8"
+"Coordinates": array:2 [
0 => -80.5109647
1 => 43.4825265
]
+"Latitude": 43.4825265
+"Longitude": -80.5109647
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome To Glen Royal! The Ultimate Bungalow Alternative! There is no substitute for square footage. For those wanting to leave behind house maintenance without sacrificing space, Suite 401 at Glen Royal is the answer. Sprawling across nearly 1,800 sq ft of bright interior space (approaching 2,000 sq ft with outdoor areas), this rare 3-bed, 2-bath residence offers the true scale of a home with lock-and-go condo security. The Glen Royal offers absolute peace of mind. The building has been heavily modernized, featuring all-new windows and new building-wide plumbing completed over the past two years—a substantial value-add upgrade that's already paid by the current owners. Common elements also boast recently updated lobby and hallway carpets, with an extensive resurfacing of the on-site tennis courts starting shortly. On the fourth floor, Unit 401 features an open, bright layout. The grand living room and formal dining space flow through large sliding doors to an expansive main balcony. Nearby, the kitchen is timelessly appointed with durable granite counters, a glass backsplash, and a clean suite of stainless-finish appliances. The 3-bedroom footprint is designed for maximum privacy. The spacious primary retreat fits a king bed and boasts a walk-in closet, a 5-piece ensuite, and its own balcony with noise-reducing, triple-glazed doors that keep utility costs low. The third bedroom offers great flexibility as a den or office, complete with practical mid-century built-ins and a walk-out to the main balcony. This suite includes an underground parking space and a storage locker. The building features EV charging stations billed directly to your suite so you only pay for what you use. Residents enjoy top-tier amenities: a heated indoor pool, hot tub, sauna, fitness room, ping-pong area, pay-per-use EV charging, landscaped gazebo with BBQs, and a party room. Located minutes from shopping, highways and transit, it balances size, comfort, and total convenience! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "1130"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T23:35:18.601603+00:00"
+"Directions": "Expressway to University West to Glenridge"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167367"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Paved driveway"
2 => "No Pet Home"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-05-26T01:01:00Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:17:42Z"
+"Stories": "1.0"
+"StreetName": "GLENRIDGE"
+"StreetNumber": "250"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4670.09"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=P1FnuRDHWdi"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1649798856"
"RoomType" => "Laundry room"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
1 => array:11 [
"RoomKey" => "1649798857"
"RoomType" => "Sunroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "23'8'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
2 => array:11 [
"RoomKey" => "1649798858"
"RoomType" => "Sunroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
3 => array:11 [
"RoomKey" => "1649798859"
"RoomType" => "4pc Bathroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
4 => array:11 [
"RoomKey" => "1649798860"
"RoomType" => "Bedroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
5 => array:11 [
"RoomKey" => "1649798861"
"RoomType" => "Bedroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.54Z"
]
6 => array:11 [
"RoomKey" => "1649798862"
"RoomType" => "4pc Bathroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.55Z"
]
7 => array:11 [
"RoomKey" => "1649798863"
"RoomType" => "Primary Bedroom"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.55Z"
]
8 => array:11 [
"RoomKey" => "1649798864"
"RoomType" => "Dining room"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.55Z"
]
9 => array:11 [
"RoomKey" => "1649798865"
"RoomType" => "Kitchen"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.55Z"
]
10 => array:11 [
"RoomKey" => "1649798866"
"RoomType" => "Living room"
"ListingId" => "40832970"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29803033"
"RoomLength" => null
"RoomDimensions" => "26'10'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:17:42.55Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29803033/250-glenridge-drive-unit-401-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1930
+"OriginalEntryTimestamp": "2026-05-25T22:19:36.17Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1418165"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29803033_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/cc421ac74b8040c84a87a71a53a3a4b3.webp"
"MediaSize" => 130024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-cc421ac74b8040c84a87a71a53a3a4b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29803033_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/7d33ff2ac8b572c1a88c6fc9d798e648.webp"
"MediaSize" => 75010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-7d33ff2ac8b572c1a88c6fc9d798e648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29803033_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/a49826ac990a132cb2ea37560f15272f.webp"
"MediaSize" => 62388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-a49826ac990a132cb2ea37560f15272f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29803033_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/181b4352726aad21919cfba14aee7aee.webp"
"MediaSize" => 68000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-181b4352726aad21919cfba14aee7aee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29803033_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/f80c72dedf60df947a3241dbb03325b8.webp"
"MediaSize" => 53454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-f80c72dedf60df947a3241dbb03325b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29803033_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/571c68ba7b40905a3b7efdf9d4bd7850.webp"
"MediaSize" => 86399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-571c68ba7b40905a3b7efdf9d4bd7850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29803033_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/fb162fbfa6fb0316b3d4891a1004326c.webp"
"MediaSize" => 83033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-fb162fbfa6fb0316b3d4891a1004326c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29803033_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/4a7532c7311ca8080f040e418684fbae.webp"
"MediaSize" => 89684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-4a7532c7311ca8080f040e418684fbae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29803033_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/1cf3f8b16e6ffe25ff00ad025e5be927.webp"
"MediaSize" => 85891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-1cf3f8b16e6ffe25ff00ad025e5be927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29803033_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/99c74ccbce6d82b452c802fe782fe96a.webp"
"MediaSize" => 57860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-99c74ccbce6d82b452c802fe782fe96a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29803033_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/5e408841df0e6082c9235921981d6fc9.webp"
"MediaSize" => 121202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-5e408841df0e6082c9235921981d6fc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29803033_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/959523f37aba73417a5300efb9b2116d.webp"
"MediaSize" => 86452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-959523f37aba73417a5300efb9b2116d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29803033_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/005f6d22202a7ff70000ef77d5141b09.webp"
"MediaSize" => 116005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-005f6d22202a7ff70000ef77d5141b09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29803033_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/461a70f1438edca8dbf04c64d603bb71.webp"
"MediaSize" => 105338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-461a70f1438edca8dbf04c64d603bb71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29803033_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/0b27b27372d49f7daa91e493993f51d9.webp"
"MediaSize" => 92465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-0b27b27372d49f7daa91e493993f51d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29803033_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/a3728c0ac15ed0c1c54a9b027248aa5a.webp"
"MediaSize" => 87277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-a3728c0ac15ed0c1c54a9b027248aa5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29803033_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/dc56c6c9e7cf5d513da15b259c64846e.webp"
"MediaSize" => 71398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-dc56c6c9e7cf5d513da15b259c64846e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29803033_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/93bda29cc32bda1a148d511465e52f2e.webp"
"MediaSize" => 76194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-93bda29cc32bda1a148d511465e52f2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29803033_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/cad8b266efc471b8aeee043b9cba7e70.webp"
"MediaSize" => 37089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-cad8b266efc471b8aeee043b9cba7e70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29803033_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/f6a02b220b0eab1387d957c42ceb89e2.webp"
"MediaSize" => 82090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-f6a02b220b0eab1387d957c42ceb89e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-25T22:19:36.18Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29803033_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/6c03835c82305bc9fad278c7aa41b0c1.webp"
"MediaSize" => 48694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-6c03835c82305bc9fad278c7aa41b0c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:50:49.59Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29803033_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/22af5383dfcfd76fc2b9e1b5311e395f.webp"
"MediaSize" => 39575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-22af5383dfcfd76fc2b9e1b5311e395f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.32Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29803033_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/771af29561e04f1d587bacc0c455b290.webp"
"MediaSize" => 84735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-771af29561e04f1d587bacc0c455b290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:13.33Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29803033_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/e015ba5b3cdc8ff1e31619a565e44eaa.webp"
"MediaSize" => 80626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-e015ba5b3cdc8ff1e31619a565e44eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:14.98Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29803033_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/fec12db8214c16c89801f5b71e458d70.webp"
"MediaSize" => 76023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-fec12db8214c16c89801f5b71e458d70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.03Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29803033_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/644c82a6575b66473d80dfebaaa3176d.webp"
"MediaSize" => 78738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-644c82a6575b66473d80dfebaaa3176d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.62Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29803033_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/e76ebe12c19fe2de7eb6c9320bcefbaa.webp"
"MediaSize" => 143559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-e76ebe12c19fe2de7eb6c9320bcefbaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.39Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29803033_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/50cb6b0e9a8b4cf19827a425a7e5a126.webp"
"MediaSize" => 69171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-50cb6b0e9a8b4cf19827a425a7e5a126.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.39Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29803033_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/e37450992655ef05f4a0b47b193e1381.webp"
"MediaSize" => 87295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-e37450992655ef05f4a0b47b193e1381.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:13.33Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29803033_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/3b7e9875fd29989147f4366a9ea4abb7.webp"
"MediaSize" => 103412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-3b7e9875fd29989147f4366a9ea4abb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:14.98Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29803033_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/23755ffdc874fbbcb58c3b1d7175a182.webp"
"MediaSize" => 87793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-23755ffdc874fbbcb58c3b1d7175a182.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:13.33Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29803033_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/15627f5c379ad631db3978162ce4b513.webp"
"MediaSize" => 72223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-15627f5c379ad631db3978162ce4b513.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.39Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29803033_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/d80fb5d6a54143c88e6b75660e5695f7.webp"
"MediaSize" => 85081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-d80fb5d6a54143c88e6b75660e5695f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.42Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29803033_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/a5b42e07567edc6c806b3e6b473e6423.webp"
"MediaSize" => 98969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-a5b42e07567edc6c806b3e6b473e6423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:14.97Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29803033_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/0a6ecf98c6bd2a6e52d5124740e63143.webp"
"MediaSize" => 65555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-0a6ecf98c6bd2a6e52d5124740e63143.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:13.33Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29803033_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/85249cedf600b67ccfa9a255e447a403.webp"
"MediaSize" => 99608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-85249cedf600b67ccfa9a255e447a403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:15.03Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29803033_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/79d9e4d436c27711fcbcb0a026e6c503.webp"
"MediaSize" => 92569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-79d9e4d436c27711fcbcb0a026e6c503.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.88Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29803033_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/1078e752a2f25a13c3322905c4498475.webp"
"MediaSize" => 95242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-1078e752a2f25a13c3322905c4498475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.07Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29803033_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/5e8ad267f1ac25a8e5185b3216307916.webp"
"MediaSize" => 111133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-5e8ad267f1ac25a8e5185b3216307916.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:19.28Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29803033_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/7802d8d6fc07ccf918fe436dac1f371a.webp"
"MediaSize" => 100977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-7802d8d6fc07ccf918fe436dac1f371a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lockers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.32Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29803033_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/3b4ca73174548310e8d0614bd4be65ba.webp"
"MediaSize" => 80885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-3b4ca73174548310e8d0614bd4be65ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.31Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29803033_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/211db5a0b341a34594e68379f829715c.webp"
"MediaSize" => 71250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-211db5a0b341a34594e68379f829715c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.32Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29803033_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29803033/5899778d40982fb394ba4424c4db30b7.webp"
"MediaSize" => 131765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29803033/thumbnail-5899778d40982fb394ba4424c4db30b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40832970"
"ResourceRecordKey" => "29803033"
"ModificationTimestamp" => "2026-05-26T00:51:18.59Z"
]
]
+"DaysOnMarket": 39
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29803033')"
+"ID": "1458694"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 246041" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24912
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2167367" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24870
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29803033'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25270
+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 '29803033'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25286
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29803033' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5109647 43.4825265)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25359
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1591144"
+post_author: 1
+"ListingKey": "29988197"
+"ListingId": "40844389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T23:05:28Z"
+"RFModificationTimestamp": "2026-07-03T23:19:43Z"
+"ListPrice": 2099900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4458.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3P9"
+"UnparsedAddress": "90 MARGARET Avenue N Unit# A, Waterloo, Ontario N2J3P9"
+"Coordinates": array:2 [
0 => -80.5063334
1 => 43.4772514
]
+"Latitude": 43.4772514
+"Longitude": -80.5063334
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this custom built Ross Miner home, completed in the fall of 2025, offering over 3,000 sqft. above grade on a 250-ft deep lot. Designed with impeccable craftsmanship, this home blends luxury, elegance, and everyday functionality. The main level features a main floor bedroom with 13-ft ceilings and oversized windows and is currently used as a home office. the formal dining room is complemented by a custom-built coffee bar complete with quartz countertops, bespoke cabinetry, and a built-in beverage centre—perfect for hosting family and guests. At the heart of the home is a stunning chef’s kitchen with premium finishes, an oversized 10-ft quartz island, and a seamless flow into the spectacular great room, with 14-ft ceilings and expansive windows flood the space with natural light. A sunroom with a gas fireplace that can be enjoyed in the cooler months, extends the living space and overlooks the backyard which consists of a composite deck overlooking the backyard with endless potential for a pool, outdoor kitchen, or your own private resort-style retreat. The upper level offers 4 generously sized bedrooms, including a primary retreat with high ceilings, a 5-pce ensuite, and a walk-in closet. A second bedroom has its own walk-in closet and private ensuite, while the remaining bedrooms share a Jack-and-Jill bathroom with double sinks. A spacious second-floor laundry room with custom cabinetry adds everyday convenience. Basement is finished with a bedroom and bathroom. Just minutes from Uptown Waterloo and Downtown Kitchener, residents enjoy easy access to grocery stores, dining, entertainment, and the public library. The area is rich with parks, walking trails, community centres, and excellent schools, making it perfect for families and professionals. Nearby universities, Glenridge Plaza, Bridgeport Plaza, and everyday conveniences further enhance this outstanding location, offering the perfect balance of urban accessibility and established neighbourhood charm. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:19:31.200148+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080001"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T22:59:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T22:59:05Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "MARGARET"
+"StreetNumber": "90"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/90a_margaret_ave_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1674498375"
"RoomType" => "Utility room"
"ListingId" => "40844389"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.83Z"
]
1 => array:11 [
"RoomKey" => "1674498376"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844389"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.83Z"
]
2 => array:11 [
"RoomKey" => "1674498377"
"RoomType" => "Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.83Z"
]
3 => array:11 [
"RoomKey" => "1674498378"
"RoomType" => "Recreation room"
"ListingId" => "40844389"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "32'2'' x 28'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
4 => array:11 [
"RoomKey" => "1674498379"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
5 => array:11 [
"RoomKey" => "1674498380"
"RoomType" => "Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
6 => array:11 [
"RoomKey" => "1674498381"
"RoomType" => "Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
7 => array:11 [
"RoomKey" => "1674498382"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
8 => array:11 [
"RoomKey" => "1674498383"
"RoomType" => "Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
9 => array:11 [
"RoomKey" => "1674498384"
"RoomType" => "Laundry room"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
10 => array:11 [
"RoomKey" => "1674498385"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
11 => array:11 [
"RoomKey" => "1674498386"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
12 => array:11 [
"RoomKey" => "1674498387"
"RoomType" => "Sunroom"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.84Z"
]
13 => array:11 [
"RoomKey" => "1674498388"
"RoomType" => "Dining room"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.85Z"
]
14 => array:11 [
"RoomKey" => "1674498389"
"RoomType" => "Living room"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "21'1'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.85Z"
]
15 => array:11 [
"RoomKey" => "1674498390"
"RoomType" => "Kitchen"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.85Z"
]
16 => array:11 [
"RoomKey" => "1674498391"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.85Z"
]
17 => array:11 [
"RoomKey" => "1674498392"
"RoomType" => "Bedroom"
"ListingId" => "40844389"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29988197"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T22:59:05.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29988197/90-margaret-avenue-n-unit-a-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 3074
+"BelowGradeFinishedArea": 1384
+"OriginalEntryTimestamp": "2026-07-03T22:59:05.8Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1354809"
+"ListOfficeNationalAssociationId": "1004415"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29988197_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/bdafe18bcee4587b2f081ef86ac1b06c.webp"
"MediaSize" => 122422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-bdafe18bcee4587b2f081ef86ac1b06c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844389"
"ResourceRecordKey" => "29988197"
"ModificationTimestamp" => "2026-07-03T22:59:05.81Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29988197_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/d49b2c028f865ebc2bf07801637b0070.webp"
"MediaSize" => 123138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-d49b2c028f865ebc2bf07801637b0070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844389"
"ResourceRecordKey" => "29988197"
"ModificationTimestamp" => "2026-07-03T22:59:05.81Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29988197_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/e0be2a265079183def1170afab64275b.webp"
"MediaSize" => 137077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-e0be2a265079183def1170afab64275b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844389"
"ResourceRecordKey" => "29988197"
"ModificationTimestamp" => "2026-07-03T22:59:05.81Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29988197_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/8ea52846523286144cadbc7b4c50cb22.webp"
"MediaSize" => 122640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-8ea52846523286144cadbc7b4c50cb22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844389"
"ResourceRecordKey" => "29988197"
"ModificationTimestamp" => "2026-07-03T22:59:05.81Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29988197_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/44f74c6d16d6ab25ce5b13f48b5b5dfe.webp"
"MediaSize" => 145705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-44f74c6d16d6ab25ce5b13f48b5b5dfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844389"
"ResourceRecordKey" => "29988197"
"ModificationTimestamp" => "2026-07-03T22:59:05.81Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29988197_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988197/f8a62cd1af59a31d52b5083bd16dec7c.webp"
"MediaSize" => 148150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988197/thumbnail-f8a62cd1af59a31d52b5083bd16dec7c.webp"
…7
]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988197')"
+"ID": "1591144"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1589616"
+post_author: 1
+"ListingKey": "29985631"
+"ListingId": "40844557"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:45:43Z"
+"RFModificationTimestamp": "2026-07-03T18:22:37Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 612, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5227424
1 => 43.4870953
]
+"Latitude": 43.4870953
+"Longitude": -80.5227424
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Atriums at 55 Blue Springs Drive in Waterloo. This spacious 1100 sq.ft. unit is located on the sixth floor and features two bedrooms, 2 full bathrooms and in suite laundry. This unit also has a separate storage locker and one owned underground parking space. This great building offers fantastic amenities, on site Manager, guest suite, party room, library, workshop, secured entrance, plenty of visitor parking and much more. Conveniently located near shopping, schools and quick access to the highway. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "709.97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:22:31.150706+00:00"
+"Directions": "King St N to Blue Springs Dr, turn right into ""The Atriums"", visitor parking is above the parking garage (stay right)."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1921574"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T17:29:35Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:29:35Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2539.87"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985631/55-blue-springs-drive-unit-612-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1108
+"OriginalEntryTimestamp": "2026-07-03T17:29:35.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227056"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985631')"
+"ID": "1589616"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1588108"
+post_author: 1
+"ListingKey": "29983121"
+"ListingId": "40844785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:35:14Z"
+"RFModificationTimestamp": "2026-07-03T21:36:29Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1125.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T2"
+"UnparsedAddress": "30 BLUE SPRINGS Drive Unit# 305, Waterloo, Ontario N2J4T2"
+"Coordinates": array:2 [
0 => -80.5261827
1 => 43.4886038
]
+"Latitude": 43.4886038
+"Longitude": -80.5261827
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit #305 at 30 Blue Springs Drive, a bright corner suite in Waterloo's sought-after Blue Springs community. With extra windows and exposure on two sides, this 2-bedroom, 2-bathroom home features a split-bedroom layout for added privacy, with the primary suite tucked away from the second bedroom and bath. Set beside Four Wells Lake and its surrounding green space, the building offers scenic walking and cycling trails, including the Four Wells Trail and a semi-private lakefront boardwalk, right at your doorstep, plus a party room, guest suites, library, bike storage, and a rooftop terrace with gas BBQs. You're just minutes from No Frills, Farm Boy, Conestoga Mall, both the University of Waterloo and Wilfrid Laurier University, and major highway access. This unit comes with the rare bonus of two parking spaces — one underground and one surface — plus an exclusive-use storage locker and in-suite laundry. Pet policy: dogs are not permitted, but cats and service dogs are welcome. A bright, well-located corner unit in one of Waterloo's most desirable lakeside communities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "910.63"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T04:37:27.438626+00:00"
+"Directions": "King Street N. to Blue Springs Dr"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Brick"
2 => "Stucco"
3 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2186086"
+"ListOfficeKey": "283007"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-03T03:01:57Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T21:29:28Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2507"
+"View": "Lake view"
+"WaterBodyName": "Four Wells Lake"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983121/30-blue-springs-drive-unit-305-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 1125
+"OriginalEntryTimestamp": "2026-07-03T03:01:57.29Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1435691"
+"ListOfficeNationalAssociationId": "1323543"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983121')"
+"ID": "1588108"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1588109"
+post_author: 1
+"ListingKey": "29983122"
+"ListingId": "40844772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:55:15Z"
+"RFModificationTimestamp": "2026-07-03T18:13:51Z"
+"ListPrice": 679900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1578.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3E2"
+"UnparsedAddress": "6 TWEED Street, Waterloo, Ontario N2J3E2"
+"Coordinates": array:2 [
0 => -80.5172119
1 => 43.4664292
]
+"Latitude": 43.4664292
+"Longitude": -80.5172119
+"YearBuilt": 1904
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 6 Tweed Street, a charming double-brick century home in the heart of Waterloo, offering the character buyers love with many thoughtful updates already completed. Built in 1904 and not heritage designated, this home features a double-wide interlock driveway, single detached garage with opener, steel roof, and replaced vinyl Centennial windows. Inside, you’ll find hardwood flooring through the entrance, living room, dining room, and staircase, along with a classic pocket door separating the living and dining areas. The main floor also offers a convenient office with a large closet, making it ideal for working from home or added storage. The kitchen was renovated approximately 10 years ago and features tile flooring, an island with granite counters, gas stove, range hood, dishwasher, and a butler’s pantry. Upstairs are three bedrooms, including a third bedroom with a walkout to a porch area, plus a beautifully renovated 4-piece bathroom with heated tile floor, tiled glass shower, new vanity, and clawfoot tub. The basement offers laundry, water softener, owned water heater, and a great shop area at the back of the basement. Major updates include electrical, plumbing, 200-amp service, conversion from oil to gas heat, central air approximately 5 years old, four new screen doors, and more. A rare opportunity to own a well-cared-for century home with timeless character, practical updates, and a fantastic Waterloo location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T04:37:10.957246+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564175"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T03:01:57Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:48:31Z"
+"Stories": "2.0"
+"StreetName": "TWEED"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5342.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/15w5d_6_tweed_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983122/6-tweed-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1578
+"OriginalEntryTimestamp": "2026-07-03T03:01:57.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140384"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983122')"
+"ID": "1588109"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1587309"
+post_author: 1
+"ListingKey": "29982072"
+"ListingId": "40844850"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:55:11Z"
+"RFModificationTimestamp": "2026-07-03T16:07:34Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 666.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H2"
+"UnparsedAddress": "251 HEMLOCK Street Unit# 208, Waterloo, Ontario N2L0H2"
+"Coordinates": array:2 [
0 => -80.5316024
1 => 43.4750774
]
+"Latitude": 43.4750774
+"Longitude": -80.5316024
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Sage 6! Located near both University of Laurier and University of Waterloo. Are you a student looking for a modern condo in one of Waterloo's most desirable locations....this one is for you! Are you an investor looking to purchase the perfect rental unit with excellent monthly income.....this condo is for you! This condo was designed beautifully for student living in the right location and steps away to so many amenities. This contemporary condo features nine foot ceilings, two spacious bedrooms, one three piece bathroom and a second two piece bathroom, kitchen with stainless steel appliances open to a perfectly sized family room with open balcony and in suite laundry. This corner condo unit is surrounded with large windows bringing in lots of natural light. You will love all the impressive amenities while living at Sage 6... a rooftop garden terrace, party room and lounge, fitness center, and secure bicycle storage. The location is so perfect and so close to everything you need for everyday living. Countless restaurants, grocery stores, shopping, major highway and excellent scenery and trails to enjoy when you have time. Look no further this condo is waiting for its new owner or student to move in and begin the next chapter of their life. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "435.77"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:22:43.025871+00:00"
+"Directions": "University to Hemlock"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088562"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-02T22:10:31Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:48:12Z"
+"Stories": "1.0"
+"StreetName": "HEMLOCK"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2826.63"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982072/251-hemlock-street-unit-208-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 666
+"OriginalEntryTimestamp": "2026-07-02T22:10:31.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1361859"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982072')"
+"ID": "1587309"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1586163"
+post_author: 1
+"ListingKey": "29981431"
+"ListingId": "X13515402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:25:08Z"
+"RFModificationTimestamp": "2026-07-02T21:42:09Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "1010 - 318 SPRUCE STREET E, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Sage ll - a 23-storey tower designed as a "recreational retreat" for students and young professionals in Waterloo's university district. This suite features 2 bedrooms / 2 washrooms with laminate flooring throughout and a sleek kitchen equipped with granite countertops, stainless steel appliances (including a built-in dishwasher), and ample storage. Enjoy a large open balcony with breathtaking city views, accessible via a walk-out from the main living area. Floor-to-ceiling windows in the bedrooms and living areas ensure the space is bright and inviting with natural light. Its also an Education Hub located within walking distance of Wilfrid Laurier University and just a 6-minute drive to the University of Waterloo. The Conestoga Waterloo Campus is also just 1.5 km away. Steps away from essential shopping like Walmart and No Frills, as well as numerous cafes, restaurants, and a cinema. Close to Express Hwy 85 and the LRT, with multiple bus routes (7 King, 31 Columbia, 201 iXpress) easily accessible for commuting across the Tri-Cities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Window Coverings"
]
+"AssociationFee": "692.08"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T21:42:04.650468+00:00"
+"Directions": "Cross Streets: Hickory St./ Spruce St. ** Directions: North on King St N, Left on Hickory St W then right on Spruce St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1409777"
+"ListOfficeKey": "275778"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-02T20:56:14Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:16:18Z"
+"StreetDirSuffix": "East"
+"StreetName": "Spruce"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4685"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981431/1010-318-spruce-street-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-02T20:56:13.98Z"
+"ListAgentNationalAssociationId": "1047557"
+"ListOfficeNationalAssociationId": "1268116"
+"Media": array:7 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981431')"
+"ID": "1586163"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1586706"
+post_author: 1
+"ListingKey": "29980952"
+"ListingId": "40843547"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T20:00:18Z"
+"RFModificationTimestamp": "2026-07-02T20:44:04Z"
+"ListPrice": 414900.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.5225463
1 => 43.4872136
]
+"Latitude": 43.4872136
+"Longitude": -80.5225463
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the perfect blend of nature and urban sophistication in this meticulously updated, open-concept unit at The Atriums. Featuring premium quartz countertops, designer fixtures, and modern flooring, the bright interior is framed by large windows boasting serene forest views. This rare find offers two spacious bedrooms, two full bathrooms, in-suite laundry, a storage locker, and the ultimate local luxury: two owned parking spaces. Residents enjoy premium building amenities—including a rooftop sun deck, guest suite, workshop, and library—all situated seconds from the expressway, prestigious Universities, and Conestoga Mall. Don't miss this exceptional opportunity; schedule your private viewing today! (Note: Some photos virtually staged). (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "812.39"
+"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": "2026-07-02T20:30:16.862485+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": "2026-07-02T19:51:50Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:51:49Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3351"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/55_blue_springs_dr_706_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980952/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": "2026-07-02T19:51:49.87Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069813"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980952')"
+"ID": "1586706"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1585507"
+post_author: 1
+"ListingKey": "29980548"
+"ListingId": "40844709"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:45:15Z"
+"RFModificationTimestamp": "2026-07-02T19:48:31Z"
+"ListPrice": 360000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 989.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4G2"
+"UnparsedAddress": "224 HARVARD Place, Waterloo, Ontario N2J4G2"
+"Coordinates": array:2 [
0 => -80.5035366
1 => 43.4833084
]
+"Latitude": 43.4833084
+"Longitude": -80.5035366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Incredible opportunity to own this stunning, fully renovated condo offering stylish, turnkey living in an unbeatable location! Updated from top to bottom with exceptional attention to detail, this home blends modern finishes with comfort and functionality throughout. The gorgeous new kitchen (2026) is sure to impress, featuring sleek cabinetry with soft-close doors, elegant gold hardware, and brand-new stainless steel appliances including a fridge, stove, and dishwasher. Luxury vinyl flooring (2026) flows seamlessly throughout the home, creating a warm and contemporary feel. The beautifully redesigned bathroom (2026) offers a spa-inspired retreat complete with new tile flooring, a modern vanity, updated fixtures, and a new bathtub with sliding glass doors. Freshly painted in a modern colour palette, every inch of this home feels bright, fresh, and inviting. The spacious living room opens through sliding doors to your own private, backyard oasis, the perfect spot to unwind, entertain, or enjoy your morning coffee. Owned Parking spot is steps from your front door, making it very convenient. Located in a highly desirable Waterloo neighbourhood close to schools, shopping, universities, parks, and easy highway access, this home offers the perfect combination of style, convenience, and low-maintenance living. Absolutely nothing to do but move in and enjoy. This home is a must-see! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "471"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:38:35.932906+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1881902"
+"ListOfficeKey": "283386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-02T19:11:06Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:32:25Z"
+"Stories": "4.0"
+"StreetName": "HARVARD"
+"StreetNumber": "224"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2191.36"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/224G-Harvard-Pl"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980548/224g-harvard-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2186110"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283386"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 989
+"OriginalEntryTimestamp": "2026-07-02T19:11:06.07Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1206941"
+"ListOfficeNationalAssociationId": "1328478"
+"CoListAgentNationalAssociationId": "1435727"
+"CoListOfficeNationalAssociationId": "1328478"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980548')"
+"ID": "1585507"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1584048"
+post_author: 1
+"ListingKey": "29978251"
+"ListingId": "40844581"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:25:14Z"
+"RFModificationTimestamp": "2026-07-02T19:32:17Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1910.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K1"
+"UnparsedAddress": "139 MACKAY Crescent, Waterloo, Ontario N2J3K1"
+"Coordinates": array:2 [
0 => -80.5139173
1 => 43.4744178
]
+"Latitude": 43.4744178
+"Longitude": -80.5139173
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 139 Makay Crescent, Waterloo—a beautifully updated home in an exceptional location backing onto Moses Springer Park and the Laurel Trail. Fully renovated throughout, this move-in ready home has modern finishes, thoughtful upgrades, and outstanding versatility for families, retired downsizers, multi-generational living, or investors. This home enjoys a premium location, set within one of Waterloo's desirable family neighbourhoods providing beautiful green space and walking trails that you can walk onto from your backyard. You'll also appreciate being within walking distance of local schools, Wilfrid Laurier University and Conestoga College's Waterloo Campus, with shopping, restaurants, transit, and everyday amenities just minutes away. This lovely updated home features three bedrooms on the main floor easily accessible to the fully redesigned bathroom, kitchen, living room, dining rooms with easy access to the beautiful backyard with mature trees that borders a trail and Moses Springer Park. The main floor living room has been opened up to a larger living area that extends through to the dining rooms; all with large windows, new flooring, updated colours and stylish new light fixtures which make it welcoming and attractive to many buyers of all generations and backgrounds. The main bathroom has been fully renovated including updated fixtures. Additional improvements include upgraded basement stairs. a refreshed bathroom on the lower level that can provide a separate facility should the spacious recreation room be further renovated for multi-generational living or rental accommodation. One of this home's standout features is the separate entrance from the garage to the lower level, again offering excellent potential for an in-law suite, multi-generational living arrangement, or future income-generating opportunities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-02T17:03:53.226538+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563737"
+"ListOfficeKey": "76816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:11:08Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:11:08Z"
+"Stories": "1.0"
+"StreetName": "MACKAY"
+"StreetNumber": "139"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5272"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Cable"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/139_mackay_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978251/139-mackay-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 1390
+"BelowGradeFinishedArea": 520
+"OriginalEntryTimestamp": "2026-07-02T15:32:04.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070277"
+"ListOfficeNationalAssociationId": "1004416"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978251')"
+"ID": "1584048"
}
]
+success: true
+page_size: 9
+page_count: 29
+count: 256
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]