array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29903455 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1531877"
+post_author: 1
+"ListingKey": "29903455"
+"ListingId": "40839531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:30:25Z"
+"RFModificationTimestamp": "2026-06-17T17:44:54Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2865.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2H3"
+"UnparsedAddress": "115 ROSLIN Avenue S, Waterloo, Ontario N2L2H3"
+"Coordinates": array:2 [
0 => -80.5262505
1 => 43.4554417
]
+"Latitude": 43.4554417
+"Longitude": -80.5262505
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in a prime Westmount location, this beautifully renovated home sits on an exceptional 70 ft x 250 ft private, tree-lined lot with no visible neighbours. Offering over 2700 square feet of total living space, the home is thoughtfully designed for both everyday living and entertaining. The main floor is anchored by a massive, modern kitchen with Elmwood cabinetry featuring eco-conscious materials. The huge windows that flood the space with natural light, loads of counter space with center island make this an exceptional space for entertaining. The formal living room features large windows, built-in bookshelves and wood burning fireplace. This space flows seamlessly to an open-concept spacious dining room ideal for hosting large gatherings. Additional main-floor highlights include a 2-piece powder room and a sunken family room with wood stove and stunning picturesque views of treed backyard. The family room leads directly to a massive 250-foot-deep, private, tree-lined backyard with western sun exposure, offering exceptional outdoor enjoyment. The space easily accommodates a hot tub, two-tier deck, and a generous kids’ play area, while still providing ample room for entertaining and relaxation. The upper level features hardwood flooring throughout and a spacious primary bedroom with a 5-piece ensuite. Two additional generously sized children’s bedrooms, a dedicated kids’ bathroom, and a convenient upper-floor laundry room complete this well-designed second level. The lower level offers additional functional living space, featuring a rec room with a wood-burning fireplace, a 2-piece bathroom, a dedicated home office with windows and ample storage. A unique opportunity to own a move-in-ready home on one of the largest and most private residential lots in the Old Westmount neighbourhood, close to parks, schools, UpTown Waterloo, LRT, Cigi, Perimeter Institute and Waterloo Park. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:09:09.930699+00:00"
+"Directions": "NORMAN TO ROSLIN OR JOHN STREET WEST TO ROSLIN"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Wood"
2 => "Other - See remarks"
3 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T17:02:27Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:02:27Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "ROSLIN"
+"StreetNumber": "115"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "8687"
+"VirtualTourURLUnbranded": "https://youriguide.com/115_roslin_ave_s_waterloo_on/doc/floorplan_imperial_en.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1659852725"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839531"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.57Z"
]
1 => array:11 [
"RoomKey" => "1659852726"
"RoomType" => "Recreation room"
"ListingId" => "40839531"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "24'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.57Z"
]
2 => array:11 [
"RoomKey" => "1659852727"
"RoomType" => "Office"
"ListingId" => "40839531"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.57Z"
]
3 => array:11 [
"RoomKey" => "1659852728"
"RoomType" => "Bedroom"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
4 => array:11 [
"RoomKey" => "1659852729"
"RoomType" => "Bedroom"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
5 => array:11 [
"RoomKey" => "1659852730"
"RoomType" => "Laundry room"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
6 => array:11 [
"RoomKey" => "1659852731"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
7 => array:11 [
"RoomKey" => "1659852732"
"RoomType" => "Full bathroom"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
8 => array:11 [
"RoomKey" => "1659852733"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839531"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "20'9'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.58Z"
]
9 => array:11 [
"RoomKey" => "1659852734"
"RoomType" => "Family room"
"ListingId" => "40839531"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "16'11'' x 31'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.59Z"
]
10 => array:11 [
"RoomKey" => "1659852735"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839531"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.6Z"
]
11 => array:11 [
"RoomKey" => "1659852736"
"RoomType" => "Dining room"
"ListingId" => "40839531"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.6Z"
]
12 => array:11 [
"RoomKey" => "1659852737"
"RoomType" => "Living room"
"ListingId" => "40839531"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.6Z"
]
13 => array:11 [
"RoomKey" => "1659852738"
"RoomType" => "Kitchen"
"ListingId" => "40839531"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903455"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:43.6Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903455/115-roslin-avenue-s-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2465
+"BelowGradeFinishedArea": 400
+"OriginalEntryTimestamp": "2026-06-15T14:51:43.54Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29903455_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/c437414de4ff7ae3b8cfae6dd06ed20f.webp"
"MediaSize" => 154609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-c437414de4ff7ae3b8cfae6dd06ed20f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29903455_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/9aebc2884ee00cae3f2a4bca86a5d165.webp"
"MediaSize" => 159792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-9aebc2884ee00cae3f2a4bca86a5d165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29903455_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/b92f1221e6ffff8c00a7387f89c3599b.webp"
"MediaSize" => 182197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-b92f1221e6ffff8c00a7387f89c3599b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.32Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29903455_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/13ef4325b73ca95ab2e299c885272e95.webp"
"MediaSize" => 88637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-13ef4325b73ca95ab2e299c885272e95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29903455_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/6897ea17cf71f410ae14324dedc04df1.webp"
"MediaSize" => 106902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-6897ea17cf71f410ae14324dedc04df1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29903455_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/631afd19a1eeaf5850de034d88d70009.webp"
"MediaSize" => 87085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-631afd19a1eeaf5850de034d88d70009.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29903455_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/85971665014e9600f935c308a941abfb.webp"
"MediaSize" => 112393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-85971665014e9600f935c308a941abfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.3Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29903455_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/7b6460449b74e1cdba7b0b197fc21982.webp"
"MediaSize" => 62860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-7b6460449b74e1cdba7b0b197fc21982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29903455_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/3a6c3813a730fd7ae669bfa9577d1155.webp"
"MediaSize" => 53617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-3a6c3813a730fd7ae669bfa9577d1155.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.04Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29903455_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/50346579bef6ad151015350fb1732fdb.webp"
"MediaSize" => 64759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-50346579bef6ad151015350fb1732fdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29903455_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/987f6aaa8de93a222ee04cfa18ef6ac0.webp"
"MediaSize" => 72904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-987f6aaa8de93a222ee04cfa18ef6ac0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29903455_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/03baf60e5d4922ba5745d5b09c9ed700.webp"
"MediaSize" => 78170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-03baf60e5d4922ba5745d5b09c9ed700.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29903455_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/e064e51373adb85c366fb9475566b356.webp"
"MediaSize" => 88596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-e064e51373adb85c366fb9475566b356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.22Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29903455_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/a1634cfea3e22af44cb846953c2c1b8d.webp"
"MediaSize" => 85544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-a1634cfea3e22af44cb846953c2c1b8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29903455_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/ee2b5e2a2a5007e4b72d5185f6182fca.webp"
"MediaSize" => 50678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-ee2b5e2a2a5007e4b72d5185f6182fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29903455_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/d2126834c343e1e2ab7ab229f3d3c25c.webp"
"MediaSize" => 65627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-d2126834c343e1e2ab7ab229f3d3c25c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29903455_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/0b55fc2b057d19fb110bf5e67b2b4c16.webp"
"MediaSize" => 54465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-0b55fc2b057d19fb110bf5e67b2b4c16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.29Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29903455_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/38d71a0ebaa5aff018ee212143cdaa76.webp"
"MediaSize" => 52369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-38d71a0ebaa5aff018ee212143cdaa76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29903455_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/eedc4829abdb9d426c3430ed2764f695.webp"
"MediaSize" => 65426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-eedc4829abdb9d426c3430ed2764f695.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29903455_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/f9ab03e69d84eaee22136ce6dc358821.webp"
"MediaSize" => 63422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-f9ab03e69d84eaee22136ce6dc358821.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29903455_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/8bd08c7025783af03ebb5dfe8284a215.webp"
"MediaSize" => 74476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-8bd08c7025783af03ebb5dfe8284a215.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29903455_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/4de62ec6379176e9bb62c8a4cf99d824.webp"
"MediaSize" => 62240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-4de62ec6379176e9bb62c8a4cf99d824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29903455_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/f0d90449998e39806f5cd30fdeb1911e.webp"
"MediaSize" => 40298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-f0d90449998e39806f5cd30fdeb1911e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.95Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29903455_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/6bf865151505827532a60393f197996a.webp"
"MediaSize" => 145626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-6bf865151505827532a60393f197996a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.29Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29903455_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/9cf914dea50f7187259e3f61d9b3fdda.webp"
"MediaSize" => 170672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-9cf914dea50f7187259e3f61d9b3fdda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.04Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29903455_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/33d614744e1e2b6e724ccb36db6d1617.webp"
"MediaSize" => 173094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-33d614744e1e2b6e724ccb36db6d1617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.28Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29903455_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/573a5b185f1e57879e22b75c0c23ed3a.webp"
"MediaSize" => 186106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-573a5b185f1e57879e22b75c0c23ed3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.27Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29903455_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/b7c24fddc3e257186f4af23f55c45eaa.webp"
"MediaSize" => 176818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-b7c24fddc3e257186f4af23f55c45eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.38Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29903455_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/d1bfcbba2aef8771e752233eabb0ed9b.webp"
"MediaSize" => 133179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-d1bfcbba2aef8771e752233eabb0ed9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.9Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29903455_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/cc3b07e32286d00933ad1f79415bd120.webp"
"MediaSize" => 183567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-cc3b07e32286d00933ad1f79415bd120.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.41Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29903455_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/6ce20ce6336dacf03a452bef34ffd75f.webp"
"MediaSize" => 158673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-6ce20ce6336dacf03a452bef34ffd75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.3Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29903455_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/cc5da6459fa0d0e029b1cabe63aa493b.webp"
"MediaSize" => 172495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-cc5da6459fa0d0e029b1cabe63aa493b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:10.23Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29903455_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/f8f910ab0d0649c8883441ed670c36c2.webp"
"MediaSize" => 142030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-f8f910ab0d0649c8883441ed670c36c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.28Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29903455_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29903455/e27525d20f605455e318c7815c4c1de0.webp"
"MediaSize" => 142621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29903455/thumbnail-e27525d20f605455e318c7815c4c1de0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839531"
"ResourceRecordKey" => "29903455"
"ModificationTimestamp" => "2026-06-15T14:52:09.5Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903455')"
+"ID": "1531877"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76789" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24766
+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 1600661" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+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 '29903455'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25162
+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 '29903455'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25178
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29903455' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5262505 43.4554417)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25231
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1540909"
+post_author: 1
+"ListingKey": "29918535"
+"ListingId": "40840669"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:10:14Z"
+"RFModificationTimestamp": "2026-06-17T22:24:19Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.08
+"LivingArea": 8222.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2N8"
+"UnparsedAddress": "700 GLASGOW Street Unit# 3, Kitchener, Ontario N2M2N8"
+"Coordinates": array:2 [
0 => -80.5361057
1 => 43.4456189
]
+"Latitude": 43.4456189
+"Longitude": -80.5361057
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This spacious townhome offers the benefits buyers associate with condominium living while maintaining ownership of both the home and the land, all within Briar Patch adjacent to Westmount Golf & Country Club. Ideal for professionals and empty nesters who no longer want the responsibilities of a traditional property, particularly those who spend significant time at the cottage, travelling, or away during the winter. Whether for a weekend or a season, you can lock the door and leave knowing exterior maintenance is handled while this close-knit community helps keep an eye on your home. What truly sets this property apart is its potential. With more than 3,200 square feet of finished living space, the home offers an exceptional layout for everyday living and entertaining while providing the opportunity to tailor the finishes to your own tastes. Large principal rooms, two separate main-floor living spaces, a generous primary suite, finished lower level, and private courtyard create the kind of space and flexibility that are increasingly difficult to find. Images virtually staged. Although the finishes are dated and would benefit from cosmetic updates, the home has been meticulously maintained and is in excellent condition. It presents a rare opportunity for the next owner to update the finishes exactly to their preferences rather than paying a premium for someone else's design choices. The setting is equally appealing. A walk through the Briar Patch community leads directly to Westmount's 11th fairway, with the clubhouse just a short stroll beyond. Surrounded by mature landscaping and nature, this is a lifestyle-oriented location that is difficult to replicate. Lovingly maintained and offering tremendous upside for future value, opportunities to secure this combination of location, space, lifestyle, and updating potential rarely become available within one of Waterloo Region's most desirable communities. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Hood Fan"
]
+"AssociationFee": "450"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:24:07.664383+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony"
]
+"LotSizeDimensions": "0.08"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T21:02:09Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:02:09Z"
+"Stories": "2.0"
+"StreetName": "GLASGOW"
+"StreetNumber": "700"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "8222"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1661493115"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.83Z"
]
1 => array:11 [
"RoomKey" => "1661493116"
"RoomType" => "Laundry room"
"ListingId" => "40840669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "28'4'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
2 => array:11 [
"RoomKey" => "1661493117"
"RoomType" => "Recreation room"
"ListingId" => "40840669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "27'10'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
3 => array:11 [
"RoomKey" => "1661493118"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
4 => array:11 [
"RoomKey" => "1661493119"
"RoomType" => "Bedroom"
"ListingId" => "40840669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
5 => array:11 [
"RoomKey" => "1661493120"
"RoomType" => "Bedroom"
"ListingId" => "40840669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
6 => array:11 [
"RoomKey" => "1661493121"
"RoomType" => "Full bathroom"
"ListingId" => "40840669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
7 => array:11 [
"RoomKey" => "1661493122"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "26'6'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
8 => array:11 [
"RoomKey" => "1661493123"
"RoomType" => "Family room"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "19'7'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
9 => array:11 [
"RoomKey" => "1661493124"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
10 => array:11 [
"RoomKey" => "1661493125"
"RoomType" => "Foyer"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.84Z"
]
11 => array:11 [
"RoomKey" => "1661493126"
"RoomType" => "Breakfast"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.85Z"
]
12 => array:11 [
"RoomKey" => "1661493127"
"RoomType" => "Kitchen"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.85Z"
]
13 => array:11 [
"RoomKey" => "1661493128"
"RoomType" => "Dining room"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.85Z"
]
14 => array:11 [
"RoomKey" => "1661493129"
"RoomType" => "Living room"
"ListingId" => "40840669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918535"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 22'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T21:02:09.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918535/700-glasgow-street-unit-3-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 8222
+"OriginalEntryTimestamp": "2026-06-17T21:02:09.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918535_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/fb16ab6240e6866ea89823e0685b3201.webp"
"MediaSize" => 132927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-fb16ab6240e6866ea89823e0685b3201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918535_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/5aff991f40f4f2ab2f1752e13f36134d.webp"
"MediaSize" => 113118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-5aff991f40f4f2ab2f1752e13f36134d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918535_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/b8d7032b3aa9da59d85031b9075a5c5c.webp"
"MediaSize" => 106261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-b8d7032b3aa9da59d85031b9075a5c5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918535_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/d486741a7b1fca2de0f0e6d3f96d35ad.webp"
"MediaSize" => 89739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-d486741a7b1fca2de0f0e6d3f96d35ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918535_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/88ed2070eac97dedb1ee25773051e5d3.webp"
"MediaSize" => 94172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-88ed2070eac97dedb1ee25773051e5d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918535_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/272a35af936ead4205ea4215ecd3fb05.webp"
"MediaSize" => 94405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-272a35af936ead4205ea4215ecd3fb05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918535_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/356cd62c73db3ce4d2f44222cad19eaf.webp"
"MediaSize" => 77475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-356cd62c73db3ce4d2f44222cad19eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918535_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/64b53b429d32dc39c699e15d1d815a03.webp"
"MediaSize" => 71611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-64b53b429d32dc39c699e15d1d815a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918535_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/7fb44f881da2b58f01f3cf5ab6532a65.webp"
"MediaSize" => 82977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-7fb44f881da2b58f01f3cf5ab6532a65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918535_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/f91eed6e46477328cf154be96d55af01.webp"
"MediaSize" => 73661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-f91eed6e46477328cf154be96d55af01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918535_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/589cce077a8cc2be1ecf9d52717464ab.webp"
"MediaSize" => 68427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-589cce077a8cc2be1ecf9d52717464ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918535_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/fd65ed0d3118c40a794752f075af5a1c.webp"
"MediaSize" => 101991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-fd65ed0d3118c40a794752f075af5a1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840669"
"ResourceRecordKey" => "29918535"
"ModificationTimestamp" => "2026-06-17T21:02:09.8Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918535_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918535/f87df21cbe6f44780e81bb71c338a7ac.webp"
"MediaSize" => 73614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918535/thumbnail-f87df21cbe6f44780e81bb71c338a7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918535')"
+"ID": "1540909"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1539270"
+post_author: 1
+"ListingKey": "29914698"
+"ListingId": "40838131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:40:09Z"
+"RFModificationTimestamp": "2026-06-17T17:16:57Z"
+"ListPrice": 489888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1807, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5174295
1 => 43.4655213
]
+"Latitude": 43.4655213
+"Longitude": -80.5174295
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo’s most sought-after condo developments, offering BREATHTAKING VIEWS of the city skyline and a remarkable array of amenities designed to enhance your lifestyle. As you step into the building, you’re greeted by a warm, INVITING LOBBY. This stunning 2-bedroom, 1-bathroom features an impressive 1,100 sq. ft. of living space with southern exposure. The spacious living and dining areas offer new vinyl flooring and are anchored by the renovated kitchen that boasts ample cabinetry, quartz countertops, a stylish backsplash, and stainless appliances with built-in oven, making it a true chef’s delight. Sliders open to your PRIVATE BALCONY, where you can take in exceptional views of the Waterloo landscape. The primary bedroom is located at one end of the unit with a FULLY RENOVATED 4-PIECE main bathroom complete with a glass-enclosed walk-in shower, & quartz vanity. The 2nd bedroom provides additional space & comfort along with a convenient in-suite laundry. This unit includes 1 UNDERGROUND PARKING SPACE, and Waterpark Place offers an outstanding range of amenities designed for every lifestyle. Stay active with the ON-SITE GYM, enjoy leisurely games in the billiards room, relax by the POOL OR SAUNA, or host gatherings in the party room, which opens to an outdoor patio with a BBQ area. For quiet moments, the library area provides a peaceful retreat. Located in the heart of Uptown Waterloo, Waterpark Place sits on nearly 4 acres of beautifully landscaped grounds, making it a Walker’s and Biker’s Paradise. Enjoy easy access to local boutiques, a variety of dining options, Waterloo Park, and the nearby universities. With convenient access to the LRT and local highways, this location truly offers the best of urban living. Don’t miss the opportunity to own this corner unit in Waterpark Place and experience luxurious living in one of Waterloo’s most vibrant communities. Interior photos have been virtually staged inside unit. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"AssociationFee": "737"
+"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 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:16:51.087563+00:00"
+"Directions": "Willow Street / Erb Street"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T13:31:33Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:31:33Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4153.56"
+"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/29914698/6-willow-street-unit-1807-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-06-17T13:31:32.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914698')"
+"ID": "1539270"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+post_id: "1536818"
+post_author: 1
+"ListingKey": "29912221"
+"ListingId": "X13452506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:40:12Z"
+"RFModificationTimestamp": "2026-06-16T23:06:56Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2M2Y7"
+"UnparsedAddress": "140 ABERDEEN ROAD, Waterloo, Ontario N2M2Y7"
+"Coordinates": array:2 [
0 => -80.52919
1 => 43.451914
]
+"Latitude": 43.451914
+"Longitude": -80.52919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "When it comes to Waterloo Region real estate, there's nothing better than a Westmount location! This is 140 Aberdeen Road - perched on a sprawling nearly 80 by 150-plus foot lot just steps from Westmount Golf and Country Club. The exclusivity of the immediate neighbourhood is unparalleled in our region, and next to no other opportunities remain that have not already been built upon in this most prestigious of enclaves. The options and potential for a spectacular dream home are endless on this .29-acre property! The existing custom four-bedroom residence with renovations by Country Lane Builders strikes a balance between elevated luxury and a warmly inviting atmosphere. Stepping inside from the manicured front gardens through a handsome solid wood door, you'll be struck by light flooding the main level with its barrel-vaulted ceiling and multiple skylights. Turn left into the airy dream kitchen with quartz counters and custom cabinetry, or right into the formal dining room with lighting to showcase your art. Downstairs lies an extended triple-aspect family room with vaulted ceiling, custom lighting, skylights, and gas fireplace. An enormous fully fenced yard featuring a two-tier deck, mature walnut tree, and room for outdoor entertaining walks out just beyond. The lower level also includes a den (or fourth bedroom), home office, mudroom, powder room, and garage access. One level below is the basement with ample storage and updated mechanicals: a new Viessmann boiler for heated floors in the north wing, an updated furnace, water softener, and sump pump. Upstairs are the three principal bedrooms, led by the primary suite with vaulted ceiling, deep walk-in closet, three-piece ensuite, and adjacent laundry. The main four-piece family bath is down the hall. With parking for up to nine vehicles via the attached garage and triple-wide driveway, this home is ideal for entertaining, or enjoy walks to Belmont Village or Uptown Waterloo for dining. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Partial"
2 => "Crawl space"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-06-16T23:06:43.274460+00:00"
+"Directions": "Cross Streets: Forsyth Drive. ** Directions: Westmount Rd S. to Forsyth Dr to Aberdeen Rd."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213352"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "80.3 x 154.1 FT ; 79.99x154.11x80.35x161.97"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:30:58Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:30:58Z"
+"StreetName": "Aberdeen"
+"StreetNumber": "140"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "10294.04"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.wattyway.ca/multimedia/140-aberdeen-road/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912221/140-aberdeen-road-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "RES-1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 80.3
+"OriginalEntryTimestamp": "2026-06-16T20:30:58.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459170"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912221')"
+"ID": "1536818"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1535565"
+post_author: 1
+"ListingKey": "29911450"
+"ListingId": "40840364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:00:11Z"
+"RFModificationTimestamp": "2026-06-16T19:47:50Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1811.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2G6"
+"UnparsedAddress": "103 DALEGROVE Drive, Kitchener, Ontario N2M2G6"
+"Coordinates": array:2 [
0 => -80.5326969
1 => 43.4401779
]
+"Latitude": 43.4401779
+"Longitude": -80.5326969
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ATTENTION!!! Investors and construction groups. This property needs work from top to bottom. This one is ready the lucky person to purchase this Semi detached with a walk out basement and flip or hold either way there will be money to be made for the right buyer. Property to be purchased as is (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T19:47:44.045129+00:00"
+"Directions": "Victoria St to Hazelglen to Dalgrove"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564046"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T18:51:06Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:51:06Z"
+"Stories": "2.0"
+"StreetName": "DALEGROVE"
+"StreetNumber": "103"
+"StreetSuffix": "Drive"
+"SubdivisionName": "323 - Victoria Hills"
+"TaxAnnualAmount": "3378"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911450/103-dalegrove-drive-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1252
+"BelowGradeFinishedArea": 559
+"OriginalEntryTimestamp": "2026-06-16T18:51:05.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069863"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911450')"
+"ID": "1535565"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1535293"
+post_author: 1
+"ListingKey": "29911052"
+"ListingId": "40840266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:40:08Z"
+"RFModificationTimestamp": "2026-06-16T19:45:41Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2786.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2Y7"
+"UnparsedAddress": "140 ABERDEEN Road, Kitchener, Ontario N2M2Y7"
+"Coordinates": array:2 [
0 => -80.5290676
1 => 43.452082
]
+"Latitude": 43.452082
+"Longitude": -80.5290676
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "When it comes to Waterloo Region real estate,\u{A0}there’s\u{A0}nothing better than a Westmount location! This is 140 Aberdeen Road – perched on a sprawling 80\u{A0}by 150-plus foot\u{A0}lot just steps from Westmount Golf and Country Club. \u{A0}The exclusivity of the immediate neighbourhood is unparalleled in our region, and next to no other\u{A0}opportunities\u{A0}remain\u{A0}that have not already been built upon in this most prestigious of enclaves.\u{A0} The options and potential for a spectacular dream home are endless on this\u{A0}.29-acre\u{A0}property!\u{A0}The\u{A0}existing\u{A0}custom four-bedroom residence with renovations by Country Lane Builders strikes a balance between elevated luxury and a warmly inviting atmosphere. Stepping inside from the manicured front gardens through a handsome solid wood door,\u{A0}you’ll\u{A0}be struck by light flooding the main level with its barrel-vaulted ceiling and multiple skylights. Turn left into the airy dream kitchen with\u{A0}quartz\u{A0}counters\u{A0}and\u{A0}custom cabinetry, or right into the formal dining room with lighting to\u{A0}showcase\u{A0}your art.\u{A0}Downstairs\u{A0}lies an\u{A0}extended triple-aspect family room with vaulted ceiling, custom lighting, skylights, and gas fireplace.\u{A0}An\u{A0}enormous fully fenced yard featuring a two-tier deck, mature walnut tree, and room for outdoor\u{A0}entertaining\u{A0}walks out just beyond. The lower level also includes a den (or fourth bedroom), home office, mudroom, powder room, and garage access. One level below is the\u{A0}basement with ample storage and\u{A0}updated\u{A0}mechanicals:\u{A0}a\u{A0}new Viessmann boiler for heated floors in the north wing,\u{A0}an\u{A0}updated furnace, water softener, and sump pump. Upstairs are the three principal bedrooms, led by the primary suite with vaulted ceiling, deep walk-in closet, three-piece ensuite, and adjacent laundry. The main four-piece family bath is down the hall. With parking for up to nine vehicles via the attached garage and triple-wide driveway, this home is ideal for\u{A0}entertaining,\u{A0}or\u{A0}enjoy walks to Belmont Village or Uptown Waterloo for dining. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-06-16T18:57:05.467221+00:00"
+"Directions": "Westmount Rd S. to Forsyth Dr to Aberdeen Rd"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Boiler"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1833093"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Crushed stone driveway"
1 => "Skylight"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:31:46Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:31:46Z"
+"Stories": "2.0"
+"StreetName": "ABERDEEN"
+"StreetNumber": "140"
+"StreetSuffix": "Road"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "10294.04"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.wattyway.ca/multimedia/140-aberdeen-rd-/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911052/140-aberdeen-road-kitchener"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 2786
+"OriginalEntryTimestamp": "2026-06-16T18:11:12.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1196292"
+"ListOfficeNationalAssociationId": "1458684"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911052')"
+"ID": "1535293"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25221
+post_id: "1534881"
+post_author: 1
+"ListingKey": "29908756"
+"ListingId": "40840015"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:30:02Z"
+"RFModificationTimestamp": "2026-06-16T17:55:13Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1392.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1W5"
+"UnparsedAddress": "256 BOWMAN Street, Waterloo, Ontario N2J1W5"
+"Coordinates": array:2 [
0 => -80.5116886
1 => 43.4611148
]
+"Latitude": 43.4611148
+"Longitude": -80.5116886
+"YearBuilt": 1939
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Cute as a button and perfectly situated in a sought-after pocket of Uptown Waterloo! This detached freehold home with a garage is tucked away on one of Uptown’s most desirable streets — close to shops, restaurants, parks, transit, and everything this vibrant neighbourhood has to offer. Location, location, location! One of the rarest finds in this price range? An incredibly private, oversized backyard. Whether it’s space for kids and dogs to run, summer entertaining, or relaxing in the hot tub under the stars, this backyard oasis offers endless possibilities all year round. Inside, you’ll find just under 1,400 square feet of beautifully maintained living space featuring 2+1 bedrooms and 2 full bathrooms. Original hardwood floors and rounded archways preserve the timeless charm of this 87-year-old home, while thoughtful updates throughout provide the convenience and comfort of modern living. The primary bedroom includes a large sliding door overlooking the backyard, complete with a motorized blind for an added touch of luxury. The second main floor bedroom allows easy access to the backyard as well and can be repurposed as a gorgeous home office. From stainless steel appliances and ceiling height cabinets in the kitchen to a classic tiled main floor washroom with deep soaker tub, this house checks all the boxes. The recently redone fully finished basement features a family room with fireplace and built-in surround sound speakers. The stylish dedicated laundry area flows into another full bathroom which is ensuite to the third bedroom. The extensive update list speaks for itself — there is truly nothing to do but move in and enjoy. 256 Bowman Street proves that good things really do come in small packages! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:54:59.461170+00:00"
+"Directions": "See maps in supplements to avoid road closures due to temporary road work."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197958"
+"ListOfficeKey": "291617"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:24:35Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:24:35Z"
+"Stories": "1.0"
+"StreetName": "BOWMAN"
+"StreetNumber": "256"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4164.85"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=0Osv_Eo2TbM"
+"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": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29908756/256-bowman-street-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 770
+"BelowGradeFinishedArea": 622
+"OriginalEntryTimestamp": "2026-06-16T13:24:34.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446324"
+"ListOfficeNationalAssociationId": "1400956"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908756')"
+"ID": "1534881"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534882"
+post_author: 1
+"ListingKey": "29909411"
+"ListingId": "X13449876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:29Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2J3"
+"UnparsedAddress": "9 - 12 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2J3"
+"Coordinates": array:2 [
0 => -80.522235
1 => 43.467941
]
+"Latitude": 43.467941
+"Longitude": -80.522235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FULLY VACANT!! Exceptional investment opportunity with strong rental appeal. This unique property offers a spacious multi-level layout featuring 4 bedrooms, a bathroom on each level, and a shared kitchen configuration ideal for student housing or multi-tenant occupancy. Freshly painted throughout and enhanced with new waterproof vinyl flooring on the upper level, the unit combines modern updates with character-rich design. Originally a 1900s industrial building converted to residential use in 2002, the property showcases soaring ceilings, exposed beams, exposed brick, and stone accents that create a distinctive urban loft aesthetic. Residents enjoy access to secured bike storage, a media lounge/hangout area, and onsite laundry facilities in the building. Ideally situated within walking distance to University of Waterloo, Wilfred Laurier University, public transit including the ION LRT, grocery stores, restaurants, and everyday amenities, with an impressive Walk Score of 94. A proven income-generating property with a strong rental history and consistently high occupancy. Book your private showing today! (id:62650)"
+"AssociationFee": "571.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-16T17:21:55.045353+00:00"
+"Directions": "Bridgeport Rd E And King St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036658"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:21Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:21Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3099.74"
+"VirtualTourURLUnbranded": "https://youtu.be/NT8oDHOsHqU"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909411/9-12-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2145943"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "293284"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-06-16T15:02:21.67Z"
+"ListAgentNationalAssociationId": "1313160"
+"ListOfficeNationalAssociationId": "1469475"
+"CoListAgentNationalAssociationId": "1397346"
+"CoListOfficeNationalAssociationId": "1469475"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909411')"
+"ID": "1534882"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1534883"
+post_author: 1
+"ListingKey": "29909783"
+"ListingId": "40839660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:16:20Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1192.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0C6"
+"UnparsedAddress": "188 KING Street S Unit# 304, Waterloo, Ontario N2J0C6"
+"Coordinates": array:2 [
0 => -80.518475
1 => 43.460317
]
+"Latitude": 43.460317
+"Longitude": -80.518475
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright Corner Condo in the Heart of Uptown Waterloo! Welcome to this spacious 2-bedroom, 2-bathroom corner unit, perfectly located in one of Waterloo’s most sought-after neighbourhoods. Just steps from the LRT, shopping, restaurants, parks, and universities, this condominium unit offers the convenience of Uptown living at your doorstep. A private foyer leads into a bright open-concept living space featuring a modern kitchen with granite countertops, stainless steel appliances, and plenty of cabinet space. The large solarium is flooded with natural light and provides a quiet space to relax, work, or enjoy your morning coffee. Both bedrooms are generously sized with large windows, while the primary bedroom includes a walk-in closet and a private ensuite bathroom. The unit is completely carpet-free and finished with beautiful engineered hardwood flooring throughout. In-suite laundry adds everyday convenience. Residents enjoy excellent building amenities, including a fitness room, party room, rooftop terrace with BBQ area, private bike storage, exclusive underground parking space, and a storage designated locker. A fantastic opportunity to own a bright, well-maintained condo in an unbeatable Uptown Waterloo location. (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "984.81"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:16:10.100683+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2150801"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T15:51:53Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:51:22Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "188"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "6388"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_304_188_king_st_s_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29909783/188-king-street-s-unit-304-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1736200"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2192963"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "283125"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1192
+"OriginalEntryTimestamp": "2026-06-16T15:51:53.52Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1401593"
+"ListOfficeNationalAssociationId": "1324759"
+"CoListAgentNationalAssociationId": "1177848"
+"CoListAgentNationalAssociationId2": "1441925"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1324759"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909783')"
+"ID": "1534883"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1533982"
+post_author: 1
+"ListingKey": "29908620"
+"ListingId": "40839781"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:35:29Z"
+"RFModificationTimestamp": "2026-06-17T17:48:39Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 550.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0G5"
+"UnparsedAddress": "25 WELLINGTON Street S Unit# 705, Kitchener, Ontario N2G0G5"
+"Coordinates": array:2 [
0 => -80.5037996
1 => 43.4535938
]
+"Latitude": 43.4535938
+"Longitude": -80.5037996
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to premium urban living at brand new Station Park Duo. This bright, modern 1 bedroom suite features floor to ceiling windows, open concept living, luxury finishes and stainless steel appliances. Perfect for an efficient lifestyle in the heart of Kitcheners Innovation District. Directly across from Google. Steps from LRT Station. Enjoy access to some of best amenities in the area. Fitness centre, swim spa, sauna, game room include bowling and pool table. Resident lounge, co-working spaces. Outdoor terrace with BBQ and lounge seating. Party room. Concierge and Security 24 hours. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "464.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:11:58.571340+00:00"
+"Directions": "King Street to Wellington"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1926813"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T17:11:39Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:11:39Z"
+"Stories": "35.0"
+"StreetDirSuffix": "South"
+"StreetName": "WELLINGTON"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"SubdivisionName": "313 - Downtown Kitchener/W. Ward"
+"TaxAnnualAmount": "2439"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Cable"
2 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908620/25-wellington-street-s-unit-705-kitchener"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1600707"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "MU-3"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 550
+"OriginalEntryTimestamp": "2026-06-16T12:50:21.82Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1229829"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1149297"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908620')"
+"ID": "1533982"
}
]
+success: true
+page_size: 9
+page_count: 33
+count: 290
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]