array:6 [
"RF Cache Key: c96d111c3a4a1a817e0fca877c43d011647fc5c41354e6bf4063eba4cfd91bf9" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21778
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29905904"
+"ListingId": "40839961"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:40:08Z"
+"RFModificationTimestamp": "2026-06-15T23:18:39Z"
+"ListPrice": 1799990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2246.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "265 WESTCOURT Place Unit# PH9, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.540362
1 => 43.4608558
]
+"Latitude": 43.4608558
+"Longitude": -80.540362
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to an opulent, one-of-a-kind penthouse residence in the heart of Waterloo. Unique buyer incentive available - seller to credit purchaser on closing an amount equivalent to 5 years of current condo fees!! The exceptional layout was created by combining two units into one expansive suite, this luxurious home offers over-the-top space, craftsmanship, and breathtaking natural views-perfectly blending elegance with everyday comfort. Grand foyer with imported Italian marble floors and mirrored accents leads to an impressive 778 sqft great room featuring cherry hardwood floors, custom German cabinetry, wet bar with Italian marble top, surround sound, and wall-to-wall windows. Updated chef's kitchen with granite counters, subway tile backsplash, slate flooring, under-cabinet lighting, reverse osmosis system, 2 built-in Bosch ovens, and JennAir 5-burner cooktop. Spacious dining room with seating for 12+, marble floors, crystal chandeliers, and custom wall unit-all included. The 665 sqft primary bedroom offers hardwood floors, sitting area, balcony access, 2 walk-in closets, and dual ensuites with Italian marble, Jacuzzi tub, walk-in shower, and luxury 24 karat gold fixtures. Features include in-suite laundry, climate-controlled wine cellar (approx. 200 bottles), 2 parking spaces, 2 lockers, triple-glazed windows (2016), 2 furnaces (2021), 40+ pot lights (all with dimmer switches), built-in speakers, Hunter Douglas blinds, and fresh paint throughout. All furniture, artwork, electronics, and custom built-ins included-truly turnkey. Well-managed building with party room, guest suite (with 2 bedrooms), gym, library, workshop, car wash, and secure entry. Prime location: steps to Waterloo Park, Rec Centre, universities, and minutes to Westmount Golf Course, Uptown Waterloo, shopping, dining, and transit. Protected green space ensures lasting views. A rare opportunity to own an exceptional penthouse in a premier location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Window Coverings"
]
+"AssociationFee": "1730"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T23:18:34.119948+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564175"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-15T19:31:10Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:31:09Z"
+"Stories": "1.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "5598.65"
+"VirtualTourURLUnbranded": "https://youriguide.com/qz2lg_265_westcourt_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1660056286"
"RoomType" => "Wine Cellar"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "3'6'' x 3'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
1 => array:11 [
"RoomKey" => "1660056287"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
2 => array:11 [
"RoomKey" => "1660056288"
"RoomType" => "Full bathroom"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
3 => array:11 [
"RoomKey" => "1660056289"
"RoomType" => "Full bathroom"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
4 => array:11 [
"RoomKey" => "1660056290"
"RoomType" => "Bedroom"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
5 => array:11 [
"RoomKey" => "1660056291"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "19'1'' x 27'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.62Z"
]
6 => array:11 [
"RoomKey" => "1660056292"
"RoomType" => "Breakfast"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.63Z"
]
7 => array:11 [
"RoomKey" => "1660056293"
"RoomType" => "Dining room"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.63Z"
]
8 => array:11 [
"RoomKey" => "1660056294"
"RoomType" => "Foyer"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.63Z"
]
9 => array:11 [
"RoomKey" => "1660056295"
"RoomType" => "Kitchen"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.63Z"
]
10 => array:11 [
"RoomKey" => "1660056296"
"RoomType" => "Living room"
"ListingId" => "40839961"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905904"
"RoomLength" => null
"RoomDimensions" => "26'9'' x 29'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:31:09.63Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905904/265-westcourt-place-unit-ph9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:4 [
0 => "Car Wash"
1 => "Exercise Centre"
2 => "Guest Suite"
3 => "Party Room"
]
+"ZoningDescription": "MR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2246
+"OriginalEntryTimestamp": "2026-06-15T19:31:09.27Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140384"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905904_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/c11f1072d7d258e6e5c7538f3edcb40f.webp"
"MediaSize" => 219303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-c11f1072d7d258e6e5c7538f3edcb40f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905904_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/a7989b9a841eef223d046d2d1fb844ef.webp"
"MediaSize" => 100963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-a7989b9a841eef223d046d2d1fb844ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905904_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/b35dfdb877dc0d4bba1db2385ad01792.webp"
"MediaSize" => 95515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-b35dfdb877dc0d4bba1db2385ad01792.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905904_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/d5b2b669ba9003cf5218f560b2a79895.webp"
"MediaSize" => 99113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-d5b2b669ba9003cf5218f560b2a79895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905904_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/4e615a3a445546e603aa8eec846f004c.webp"
"MediaSize" => 100463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-4e615a3a445546e603aa8eec846f004c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905904_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/7fc1d3e761642b27cdd016a7e2cf5b71.webp"
"MediaSize" => 74934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-7fc1d3e761642b27cdd016a7e2cf5b71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905904_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/5a91a7e06fe8bdecfd05c55ae26d3b91.webp"
"MediaSize" => 60855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-5a91a7e06fe8bdecfd05c55ae26d3b91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905904_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/1189c1611948bb345465035bd4de8afd.webp"
"MediaSize" => 75383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-1189c1611948bb345465035bd4de8afd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905904_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/d29998f3edd30f9e6980863161cf8fcf.webp"
"MediaSize" => 58149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-d29998f3edd30f9e6980863161cf8fcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905904_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/82d0f8e326f4e3dda84d1df15555cc5b.webp"
"MediaSize" => 67838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-82d0f8e326f4e3dda84d1df15555cc5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905904_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/9119ca0b1a563d6d7a00abd093132570.webp"
"MediaSize" => 68719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-9119ca0b1a563d6d7a00abd093132570.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905904_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/8353256e87b3c678fd190bddedd63452.webp"
"MediaSize" => 79398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-8353256e87b3c678fd190bddedd63452.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905904_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/390da71a3e6244f080d77625dfaa32bb.webp"
"MediaSize" => 68782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-390da71a3e6244f080d77625dfaa32bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905904_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/1415785bf50f115a2d2ad5308e727a07.webp"
"MediaSize" => 61786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-1415785bf50f115a2d2ad5308e727a07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905904_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/915c9c4707788bf371a615ccd5a545b4.webp"
"MediaSize" => 60868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-915c9c4707788bf371a615ccd5a545b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905904_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/b352aed4e09d1d10468bd012142481b0.webp"
"MediaSize" => 72897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-b352aed4e09d1d10468bd012142481b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905904_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/0f8ad305071fc0d36552e586ac42efc6.webp"
"MediaSize" => 54638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-0f8ad305071fc0d36552e586ac42efc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905904_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/6e5ddde3549510a9d34ddbba2d2fe76d.webp"
"MediaSize" => 80394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-6e5ddde3549510a9d34ddbba2d2fe76d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29905904_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/23b8fa99ff23cd53b9e562d7bacb3b4b.webp"
"MediaSize" => 68520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-23b8fa99ff23cd53b9e562d7bacb3b4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29905904_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/d1c150b351507a1e7f92a9982923a220.webp"
"MediaSize" => 66577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-d1c150b351507a1e7f92a9982923a220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29905904_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/6537de7e639d264e16584cebf745804b.webp"
"MediaSize" => 72345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-6537de7e639d264e16584cebf745804b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29905904_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/3045bb1ce46ac3cfce8c410ce4cfd335.webp"
"MediaSize" => 65766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-3045bb1ce46ac3cfce8c410ce4cfd335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29905904_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/66e95c441e567f33389c130ea37c9b1a.webp"
"MediaSize" => 73163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-66e95c441e567f33389c130ea37c9b1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29905904_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/0d6dba425d312c006b032d9ed0beca89.webp"
"MediaSize" => 57689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-0d6dba425d312c006b032d9ed0beca89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29905904_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/1720963590c01008d0cdf95bd4792fa9.webp"
"MediaSize" => 64302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-1720963590c01008d0cdf95bd4792fa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29905904_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/3e58ca5f29c7efd23fb04cc9a99681f1.webp"
"MediaSize" => 82045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-3e58ca5f29c7efd23fb04cc9a99681f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29905904_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/d2b16b5573d15823dc79e978bcfccb4f.webp"
"MediaSize" => 91737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-d2b16b5573d15823dc79e978bcfccb4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29905904_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/ca76a179dca84605b51a06ed23610f33.webp"
"MediaSize" => 103820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-ca76a179dca84605b51a06ed23610f33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29905904_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/4a79c4e3baaf61fc3d2e0fe35fa679d9.webp"
"MediaSize" => 76239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-4a79c4e3baaf61fc3d2e0fe35fa679d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29905904_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/9c7634a57779db53382de03992a6a1c8.webp"
"MediaSize" => 79212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-9c7634a57779db53382de03992a6a1c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29905904_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/49131269a87dc3be4061896d96c7cf72.webp"
"MediaSize" => 88154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-49131269a87dc3be4061896d96c7cf72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29905904_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/9ed041c85ad925e1e70d3966f14f5b3b.webp"
"MediaSize" => 76296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-9ed041c85ad925e1e70d3966f14f5b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29905904_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/4a1d3c3ab8799637d3b246686cc9b32d.webp"
"MediaSize" => 76763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-4a1d3c3ab8799637d3b246686cc9b32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29905904_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/573c78fa9f4eee02ebb74c95efdff1ff.webp"
"MediaSize" => 83479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-573c78fa9f4eee02ebb74c95efdff1ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29905904_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/3c7b498842259898a57951e7e80ac464.webp"
"MediaSize" => 55080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-3c7b498842259898a57951e7e80ac464.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29905904_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/6a9ec995df630be63deea06ad293983e.webp"
"MediaSize" => 53452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-6a9ec995df630be63deea06ad293983e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29905904_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/30abb9f456555368fe66fee0c71f2a5f.webp"
"MediaSize" => 72708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-30abb9f456555368fe66fee0c71f2a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29905904_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/a3235ecaf2b4b3d225129957e6f33123.webp"
"MediaSize" => 69972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-a3235ecaf2b4b3d225129957e6f33123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29905904_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/dd301a1129c74b84d347896b4171642f.webp"
"MediaSize" => 63632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-dd301a1129c74b84d347896b4171642f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29905904_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/8b999673aef1c6101ee41f0ed01ae7d3.webp"
"MediaSize" => 79113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-8b999673aef1c6101ee41f0ed01ae7d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29905904_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/f627936ac7becd50d910521f47880fbb.webp"
"MediaSize" => 64178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-f627936ac7becd50d910521f47880fbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29905904_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/e607ffe26244e0ad41e47b8fff94b03c.webp"
"MediaSize" => 74413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-e607ffe26244e0ad41e47b8fff94b03c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29905904_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/438fccdea746c0507b7222d7daa25325.webp"
"MediaSize" => 71338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-438fccdea746c0507b7222d7daa25325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29905904_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/8046424440eb65c37630b55a180aa9fe.webp"
"MediaSize" => 70774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-8046424440eb65c37630b55a180aa9fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29905904_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/c1e3fa8834fe4d6eb473a443c03c68ea.webp"
"MediaSize" => 73066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-c1e3fa8834fe4d6eb473a443c03c68ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29905904_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/3e7c7f0afd446425696c24e93c8aeb56.webp"
"MediaSize" => 64773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-3e7c7f0afd446425696c24e93c8aeb56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29905904_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/e6f3fb1a25c02a1afa4ce5084a64e7bf.webp"
"MediaSize" => 73703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-e6f3fb1a25c02a1afa4ce5084a64e7bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29905904_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905904/98099cf0739ed7b956ca6ddaf9251d63.webp"
"MediaSize" => 48531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905904/thumbnail-98099cf0739ed7b956ca6ddaf9251d63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839961"
"ResourceRecordKey" => "29905904"
"ModificationTimestamp" => "2026-06-15T19:31:09.28Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905904')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 259258" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564175" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24778
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29905904'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29905904'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25206
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29905904' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.540362 43.4608558)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25320
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+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"
…6
]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918535')"
+"ID": "1540909"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+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 {#25313
+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 {#25317
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1535094"
+post_author: 1
+"ListingKey": "29908779"
+"ListingId": "40835169"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:40:12Z"
+"RFModificationTimestamp": "2026-06-16T17:54:46Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3956.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW Circle, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.5618392
1 => 43.4673142
]
+"Latitude": 43.4673142
+"Longitude": -80.5618392
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:49.943718+00:00"
+"Directions": "Columbia to Beechlawn to Stillmeadow"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:31:43Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:31:43Z"
+"Stories": "2.0"
+"StreetName": "STILLMEADOW"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908779/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 2681
+"BelowGradeFinishedArea": 1275
+"OriginalEntryTimestamp": "2026-06-16T13:31:43.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"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('29908779')"
+"ID": "1535094"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1535095"
+post_author: 1
+"ListingKey": "29909404"
+"ListingId": "X13449772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:49Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW CIRCLE, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.561844
1 => 43.467325
]
+"Latitude": 43.467325
+"Longitude": -80.561844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Cooktop"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:22:35.484541+00:00"
+"Directions": "Cross Streets: Columbia and Fischer Hallman. ** Directions: Columbia to Beechlawn to Stillmeadow."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.2 x 118.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:20Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:20Z"
+"Stories": "2.0"
+"StreetName": "Stillmeadow"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909404/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.2
+"OriginalEntryTimestamp": "2026-06-16T15:02:20.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909404')"
+"ID": "1535095"
}
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 {#25318
+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 {#25319
+post_id: "1533540"
+post_author: 1
+"ListingKey": "29908184"
+"ListingId": "X13448740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T03:50:00Z"
+"RFModificationTimestamp": "2026-06-16T04:03:05Z"
+"ListPrice": 409000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "113 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "One Parking Space Included with this sleek, well-maintained condo. Enjoy high ceilings and a quiet environment for ultimate comfort and a modern touch throughout. The unit features In-Unit Laundry and a spacious Great Room with large windows, offering plenty of natural light. The modern kitchen boasts granite countertops and stainless steel appliances, perfect for cooking and entertaining. The condo includes 2 large bedrooms and 2 full bathrooms, offering ample space for comfort and privacy. The Master Bedroom features a generous walk-in closet and a private ensuite bathroom. This unit is also available fully furnished at no extra cost. Ceiling height of 12 feet adds to the airy and spacious feel of the home. Parking space #9 is included. This building offers a fantastic opportunity for anyone looking for a quiet condo near all amenities, ideal for investment or living in the sought-after University District of Waterloo, walking distance to campus! (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
]
+"AssociationFee": "805.05"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T04:02:59.260043+00:00"
+"Directions": "Cross Streets: Albert St & Columbia St W. ** Directions: University Ave. W & Albert St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095720"
+"ListOfficeKey": "256758"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T03:42:45Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T03:42:45Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4931.46"
+"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"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29908184/113-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-16T03:42:45.77Z"
+"ListAgentNationalAssociationId": "1367886"
+"ListOfficeNationalAssociationId": "1213267"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908184')"
+"ID": "1533540"
}
]
+success: true
+page_size: 9
+page_count: 44
+count: 394
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]