array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29978251 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1584048"
+post_author: 1
+"ListingKey": "29978251"
+"ListingId": "40844581"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:30:06Z"
+"RFModificationTimestamp": "2026-07-02T18:44:53Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1910.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K1"
+"UnparsedAddress": "139 MACKAY Crescent, Waterloo, Ontario N2J3K1"
+"Coordinates": array:2 [
0 => -80.5139173
1 => 43.4744178
]
+"Latitude": 43.4744178
+"Longitude": -80.5139173
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 139 Mackay Crescent, Waterloo—a beautifully updated home in an exceptional location backing onto Moses Springer Park and the Laurel Trail. Freshly renovated throughout, this move-in ready property offers modern finishes, thoughtful upgrades, and outstanding versatility for families, multi-generational living, or investors. You will enjoy this premium location, providing beautiful green space and walking trails right in your backyard. You'll also appreciate being within walking distance of Wilfrid Laurier University and Conestoga College's Waterloo Campus, with shopping, restaurants, transit, and everyday amenities just minutes away. The main floor has been freshly painted and features new flooring throughout, stylish new light fixtures, and pot lights in the bright living room. The completely renovated kitchen boasts new cabinetry, quartz countertops, an undermount stainless steel sink with a modern faucet, a contemporary backsplash, and a new over-the-range microwave. The kitchen also features a new stainless-steel dishwasher. The main bathroom has been fully redesigned with a new acrylic tub featuring a tiled surround, a new vanity, modern faucet, and updated fixtures. Additional improvements include new basement stair treads and risers, while the basement offers a refreshed bathroom with a new vanity and toilet, plus new lighting in the spacious recreation room. One of this home's standout features is the walkup to the garage, offering excellent potential for an in-law suite, multi-generational living arrangement, or future income-generating opportunities (subject to any required approvals). Whether you're searching for a beautifully updated family home or a property with exceptional flexibility and investment potential, 139 Mackay Crescent is an opportunity you won't want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-02T17:03:53.226538+00:00"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563737"
+"ListOfficeKey": "76816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:22:56Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:23:01Z"
+"Stories": "1.0"
+"StreetName": "MACKAY"
+"StreetNumber": "139"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5272"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Cable"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/139_mackay_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1673337962"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844581"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.94Z"
]
1 => array:11 [
"RoomKey" => "1673337963"
"RoomType" => "Laundry room"
"ListingId" => "40844581"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.94Z"
]
2 => array:11 [
"RoomKey" => "1673337964"
"RoomType" => "Recreation room"
"ListingId" => "40844581"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 39'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.94Z"
]
3 => array:11 [
"RoomKey" => "1673337965"
"RoomType" => "Bedroom"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.94Z"
]
4 => array:11 [
"RoomKey" => "1673337966"
"RoomType" => "Bedroom"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.95Z"
]
5 => array:11 [
"RoomKey" => "1673337968"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.97Z"
]
6 => array:11 [
"RoomKey" => "1673337974"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.97Z"
]
7 => array:11 [
"RoomKey" => "1673337984"
"RoomType" => "Kitchen"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.99Z"
]
8 => array:11 [
"RoomKey" => "1673337985"
"RoomType" => "Dining room"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.99Z"
]
9 => array:11 [
"RoomKey" => "1673337986"
"RoomType" => "Living room"
"ListingId" => "40844581"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978251"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:04.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978251/139-mackay-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 1390
+"BelowGradeFinishedArea": 520
+"OriginalEntryTimestamp": "2026-07-02T15:32:04.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070277"
+"ListOfficeNationalAssociationId": "1004416"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29978251_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978251/f6a190173549b708a731ceda5b4dd463.webp"
"MediaSize" => 190681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978251/thumbnail-f6a190173549b708a731ceda5b4dd463.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844581"
"ResourceRecordKey" => "29978251"
"ModificationTimestamp" => "2026-07-02T15:32:04.81Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978251')"
+"ID": "1584048"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76816" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24780
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563737" => 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.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29978251'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25152
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29978251'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25270
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29978251' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5139173 43.4744178)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25186
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25180
+post_id: "1583767"
+post_author: 1
+"ListingKey": "29977935"
+"ListingId": "X13511688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:05:04Z"
+"RFModificationTimestamp": "2026-07-02T16:17:21Z"
+"ListPrice": 400000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "608 - 181 KING STREET S, Kitchener, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.520205
1 => 43.460368
]
+"Latitude": 43.460368
+"Longitude": -80.520205
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Circa, one of Uptown Waterloo's premier condo residences. This stylishly upgraded 1-bedroom, 1-bathroom suite offers soaring ceilings, high-end flooring, and a bright south-facing exposure that fills the space with natural light. Designed with both comfort and functionality in mind, the open-concept layout features a generous entryway and seamless flow throughout. The contemporary kitchen is equipped with built-in appliances, upgraded cabinetry, and a large island, perfect for everyday living and entertaining. The primary bedroom is thoughtfully designed with custom built-in cabinetry, providing ample storage along with space for a convenient work-from-home setup. A standout feature of this unit is the expansive private terrace, an impressive outdoor retreat rarely found in condo living. Complete with a natural gas hookup, it's ideal for a fire table, hosting guests, or simply relaxing on warm summer evenings. Located on the same level, residents enjoy access to an array of exceptional amenities including a swimming pool, fitness centre, party room, outdoor lounge areas, BBQ space, and a dedicated co-working lounge. Step outside and immerse yourself in the vibrant Uptown lifestyle. With the ION LRT just steps away, you'll have easy access to boutique shopping, cafés, parks, restaurants, and nightlife. Enjoy the convenience of LaLa Social House right in the building, along with countless local favourites nearby. Luxury, convenience, and location, this is condo living at its best. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "685.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
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-07-02T16:17:16.229066+00:00"
+"Directions": "Cross Streets: King and Allen. ** Directions: King and Allen."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202928"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-02T14:51:02Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:58:05Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4497.3"
+"VirtualTourURLUnbranded": "https://vimeo.com/1206493927?fl=pl&fe=sh"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1673359589"
"RoomType" => "Kitchen"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29977935"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
1 => array:11 [
"RoomKey" => "1673359590"
"RoomType" => "Living room"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29977935"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
2 => array:11 [
"RoomKey" => "1673359591"
"RoomType" => "Bedroom"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29977935"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
3 => array:11 [
"RoomKey" => "1673359592"
"RoomType" => "Bathroom"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 2.29
"ListingKey" => "29977935"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
4 => array:11 [
"RoomKey" => "1673359593"
"RoomType" => "Foyer"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29977935"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
5 => array:11 [
"RoomKey" => "1673359594"
"RoomType" => "Other"
"ListingId" => "X13511688"
"RoomLevel" => "Main level"
"RoomWidth" => 4.72
"ListingKey" => "29977935"
"RoomLength" => 7.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T15:58:05.55Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977935/608-181-king-street-s-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo MGMT"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-02T14:51:02.54Z"
+"ListAgentNationalAssociationId": "1451479"
+"ListOfficeNationalAssociationId": "1438893"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29977935_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/a3882a5dd23cccc3cb77d5d852a26a3d.webp"
"MediaSize" => 67397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-a3882a5dd23cccc3cb77d5d852a26a3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29977935_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/898c74f47b86b4a4fc4a1490fde0097c.webp"
"MediaSize" => 68486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-898c74f47b86b4a4fc4a1490fde0097c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29977935_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/1fd6dfac2ec75c27ce37cf456c8d4ef6.webp"
"MediaSize" => 71752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-1fd6dfac2ec75c27ce37cf456c8d4ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29977935_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/c0bfede53b61c5927f6a5f290843467d.webp"
"MediaSize" => 61630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-c0bfede53b61c5927f6a5f290843467d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29977935_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/8fe0977950246364b4218128855716ff.webp"
"MediaSize" => 69331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-8fe0977950246364b4218128855716ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29977935_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/34a1f05d84fba2e7c8c809cfddc3d482.webp"
"MediaSize" => 70883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-34a1f05d84fba2e7c8c809cfddc3d482.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29977935_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/8b5fb32978b5a35dba1cdc3f7b1a41a2.webp"
"MediaSize" => 28796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-8b5fb32978b5a35dba1cdc3f7b1a41a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29977935_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/471492d380a4fc1f93a922dc3a05ce0a.webp"
"MediaSize" => 45838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-471492d380a4fc1f93a922dc3a05ce0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29977935_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/67730060ab5bfeeedccdb7f0fb64c1a0.webp"
"MediaSize" => 67177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-67730060ab5bfeeedccdb7f0fb64c1a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29977935_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/bec3ddd1e2cf31a852b2958a16f61cb3.webp"
"MediaSize" => 32808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-bec3ddd1e2cf31a852b2958a16f61cb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29977935_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/2eaf6351d549d104ef80abf04a06c003.webp"
"MediaSize" => 65810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-2eaf6351d549d104ef80abf04a06c003.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29977935_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/d5b73eb071201468efc034168b036cdf.webp"
"MediaSize" => 64784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-d5b73eb071201468efc034168b036cdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29977935_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/7cdde609d26f2459ed6a370a3acf3075.webp"
"MediaSize" => 64246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-7cdde609d26f2459ed6a370a3acf3075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29977935_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/f9ef3b255a4dc41615d01b903daeed3c.webp"
"MediaSize" => 55825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-f9ef3b255a4dc41615d01b903daeed3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29977935_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/51d1f271312a388f0edba2a0715700cf.webp"
"MediaSize" => 54438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-51d1f271312a388f0edba2a0715700cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29977935_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/1df5b86cd848074776d798c778b40f7a.webp"
"MediaSize" => 66784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-1df5b86cd848074776d798c778b40f7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29977935_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/f7190bdd303344908ab0577f17e5ac16.webp"
"MediaSize" => 66101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-f7190bdd303344908ab0577f17e5ac16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29977935_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/9191d70d68d87970b818a646f167fcfe.webp"
"MediaSize" => 100252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-9191d70d68d87970b818a646f167fcfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29977935_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/befdbf7275969f34518132d7fae5e631.webp"
"MediaSize" => 109229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-befdbf7275969f34518132d7fae5e631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29977935_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/ada2d27670d9d5f750ea77c790c5eafa.webp"
"MediaSize" => 105690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-ada2d27670d9d5f750ea77c790c5eafa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29977935_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/b22d7be22756e0105bb9ff6781c960c2.webp"
"MediaSize" => 75126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-b22d7be22756e0105bb9ff6781c960c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29977935_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/5fb69d552d30066120f4be89c7bb6559.webp"
"MediaSize" => 95925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-5fb69d552d30066120f4be89c7bb6559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29977935_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/fc4fcbb550c5e13fc9db364b5ddf164f.webp"
"MediaSize" => 87178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-fc4fcbb550c5e13fc9db364b5ddf164f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29977935_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/fbf594648d10617ec69c3fc43fbe225e.webp"
"MediaSize" => 111839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-fbf594648d10617ec69c3fc43fbe225e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29977935_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/58c9712f5339a760419dea1a14df11e9.webp"
"MediaSize" => 91275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-58c9712f5339a760419dea1a14df11e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29977935_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/26d364dd8b2ca908ae81992a8c55cd3c.webp"
"MediaSize" => 113146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-26d364dd8b2ca908ae81992a8c55cd3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29977935_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/316c629c14017b689de97f154335f831.webp"
"MediaSize" => 104499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-316c629c14017b689de97f154335f831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29977935_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/2324946bd06bf613fc1a72db6881acd5.webp"
"MediaSize" => 110310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-2324946bd06bf613fc1a72db6881acd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29977935_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/9286bab711bf6fec554f0fcd12b45fdf.webp"
"MediaSize" => 97408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-9286bab711bf6fec554f0fcd12b45fdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29977935_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/ef32f63d679285b5bf6e3e3342b8278a.webp"
"MediaSize" => 148207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-ef32f63d679285b5bf6e3e3342b8278a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29977935_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/71d4adc1cc37b7cc70b1bb3fc778f1c3.webp"
"MediaSize" => 144471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-71d4adc1cc37b7cc70b1bb3fc778f1c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29977935_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/6785f55ea5130542128d66857d716157.webp"
"MediaSize" => 114994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-6785f55ea5130542128d66857d716157.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29977935_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977935/fa0d7fb5cf723845b22e19c6ffb8cda9.webp"
"MediaSize" => 55462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977935/thumbnail-fa0d7fb5cf723845b22e19c6ffb8cda9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511688"
"ResourceRecordKey" => "29977935"
"ModificationTimestamp" => "2026-07-02T14:51:02.55Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977935')"
+"ID": "1583767"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25182
+post_id: "1583693"
+post_author: 1
+"ListingKey": "29977240"
+"ListingId": "40844265"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:20:11Z"
+"RFModificationTimestamp": "2026-07-02T15:29:23Z"
+"ListPrice": 400000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 742.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "181 KING Street S Unit# 608, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5204138
1 => 43.4603851
]
+"Latitude": 43.4603851
+"Longitude": -80.5204138
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Circa, one of Uptown Waterloo’s premier condo residences. This stylishly upgraded 1-bedroom, 1-bathroom suite offers soaring ceilings, high-end flooring, and a bright south-facing exposure that fills the space with natural light. Designed with both comfort and functionality in mind, the open-concept layout features a generous entryway and seamless flow throughout. The contemporary kitchen is equipped with built-in appliances, upgraded cabinetry, and a large island, perfect for everyday living and entertaining. The primary bedroom is thoughtfully designed with custom built-in cabinetry, providing ample storage along with space for a convenient work-from-home setup. A standout feature of this unit is the expansive private terrace, an impressive outdoor retreat rarely found in condo living. Complete with a natural gas hookup, it’s ideal for a fire table, hosting guests, or simply relaxing on warm summer evenings. Located on the same level, residents enjoy access to an array of exceptional amenities including a swimming pool, fitness centre, party room, outdoor lounge areas, BBQ space, and a dedicated co-working lounge. Step outside and immerse yourself in the vibrant Uptown lifestyle. With the ION LRT just steps away, you’ll have easy access to boutique shopping, cafés, parks, restaurants, and nightlife. Enjoy the convenience of LaLa Social House right in the building, along with countless local favourites nearby. Luxury, convenience, and location, this is condo living at its best. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Oven - Built-In"
]
+"AssociationFee": "685.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T14:07:40.114533+00:00"
+"Directions": "King and Allen."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2242919"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-02T13:31:53Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:11:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4497.3"
+"VirtualTourURLUnbranded": "https://vimeo.com/1206493927?fl=pl&fe=sh"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1673321311"
"RoomType" => "Other"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 23'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.9Z"
]
1 => array:11 [
"RoomKey" => "1673321312"
"RoomType" => "Foyer"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.9Z"
]
2 => array:11 [
"RoomKey" => "1673321313"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.9Z"
]
3 => array:11 [
"RoomKey" => "1673321314"
"RoomType" => "Bedroom"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.9Z"
]
4 => array:11 [
"RoomKey" => "1673321315"
"RoomType" => "Living room"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.91Z"
]
5 => array:11 [
"RoomKey" => "1673321316"
"RoomType" => "Kitchen"
"ListingId" => "40844265"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977240"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:11:17.91Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977240/181-king-street-s-unit-608-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2067042"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2142140"
+"CoListOfficeKey": "294394"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "290392"
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 742
+"OriginalEntryTimestamp": "2026-07-02T13:31:53.23Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1481019"
+"ListOfficeNationalAssociationId": "1386847"
+"CoListAgentNationalAssociationId": "1342144"
+"CoListAgentNationalAssociationId2": "1393735"
+"CoListOfficeNationalAssociationId": "1438749"
+"CoListOfficeNationalAssociationId2": "1386847"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29977240_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/73948a3d802b8b0fdd4591ee5bd7c076.webp"
"MediaSize" => 64526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-73948a3d802b8b0fdd4591ee5bd7c076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and a neutral color palette"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29977240_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/eb44ed8a46401ad345ee02554206bb41.webp"
"MediaSize" => 64129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-eb44ed8a46401ad345ee02554206bb41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring sleek white cabinetry, integrated stainless steel appliances, a generous island with a solid surface countertop, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29977240_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/6d05a43f1b08655a4aa3784c284957b9.webp"
"MediaSize" => 68180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-6d05a43f1b08655a4aa3784c284957b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, integrated stainless steel appliances, a center island, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29977240_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/50fa1726cc3271097fe20167de1e5523.webp"
"MediaSize" => 56178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-50fa1726cc3271097fe20167de1e5523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sleek kitchen featuring light-toned cabinetry, integrated stainless steel appliances, a built-in oven, and a contemporary sink with a gooseneck faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29977240_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/1fdbebfebcc99a7c7b91daa8a1ed43d6.webp"
"MediaSize" => 64965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-1fdbebfebcc99a7c7b91daa8a1ed43d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a central island with seating, stainless steel built-in appliances, two-tone cabinetry, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29977240_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/d77aae1b879a740d4940f22281079400.webp"
"MediaSize" => 66884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-d77aae1b879a740d4940f22281079400.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen island with a light-toned countertop and ample storage, complemented by light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29977240_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/06c4b0de23cb4ce69b551472497bab04.webp"
"MediaSize" => 25416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-06c4b0de23cb4ce69b551472497bab04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring flat-panel cabinetry with linear hardware, light-toned countertops, and a full-height backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29977240_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/decd6c679f9a0b926d9bd3aa92dd1e8b.webp"
"MediaSize" => 43877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-decd6c679f9a0b926d9bd3aa92dd1e8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring expansive windows, wood-finish flooring, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29977240_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/ff27d950c349eff12fe9a978726cfb1a.webp"
"MediaSize" => 63858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-ff27d950c349eff12fe9a978726cfb1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring light wood-finish flooring, recessed lighting, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29977240_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/02fb41464b63d2dd3ef395e56adc05f6.webp"
"MediaSize" => 30406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-02fb41464b63d2dd3ef395e56adc05f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space with light-toned walls, featuring a bed with a white duvet and layered textiles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29977240_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/5d7568cbedf41832c1b6c2ed1112beaf.webp"
"MediaSize" => 61820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-5d7568cbedf41832c1b6c2ed1112beaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior featuring wood-finish flooring, a full-height window, a ceiling fan, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29977240_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/ba211ae7d748e1da342ccdacfc9b2382.webp"
"MediaSize" => 61692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-ba211ae7d748e1da342ccdacfc9b2382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright bedroom with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29977240_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/aeabe9bc2e5991d74f532e6ba4c1f75d.webp"
"MediaSize" => 60330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-aeabe9bc2e5991d74f532e6ba4c1f75d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright bedroom featuring light wood-finish flooring, white walls, and a large window with city architecture visible"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29977240_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/8746e2ecfbc46e5981c30e944286b712.webp"
"MediaSize" => 50607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-8746e2ecfbc46e5981c30e944286b712.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29977240_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/7359730d6a42917c67adc295b3046afd.webp"
"MediaSize" => 49007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-7359730d6a42917c67adc295b3046afd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29977240_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/f575ce41543513a4bdf0d9124ce6cf0d.webp"
"MediaSize" => 61925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-f575ce41543513a4bdf0d9124ce6cf0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet with stacked appliances and tile flooring, situated off a hallway featuring wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29977240_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977240/dd796af12f5f0458cda3e7576a577c75.webp"
"MediaSize" => 61843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977240/thumbnail-dd796af12f5f0458cda3e7576a577c75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844265"
"ResourceRecordKey" => "29977240"
"ModificationTimestamp" => "2026-07-02T13:31:53.24Z"
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977240')"
+"ID": "1583693"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179
+post_id: "1583546"
+post_author: 1
+"ListingKey": "29976756"
+"ListingId": "40842864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:00:11Z"
+"RFModificationTimestamp": "2026-07-02T17:09:08Z"
+"ListPrice": 607000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1246.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 2203, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5163164
1 => 43.4658765
]
+"Latitude": 43.4658765
+"Longitude": -80.5163164
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury living at Waterpark Place! This beautifully renovated 2-bedroom, 2-bathroom suite offers stylish, move-in-ready living space in one of Waterloo's most sought-after condominium communities. Enjoy breathtaking southeast views and an abundance of natural light from the expansive sunroom, where floor-to-ceiling windows provide the fresh air of a private balcony without the wind, rain, or seasonal limitations. The extensively updated interior features a modern kitchen with granite countertops, white cabinetry, stainless steel appliances, and tile flooring. New flooring flows throughout the suite, while both bathrooms have been tastefully renovated with updated vanities, countertops, flooring, and walk-in tiled showers. The spacious primary bedroom includes a walk-in closet and upgraded ensuite. Waterpark Place residents enjoy exceptional amenities including an indoor pool, sauna, fitness room, library, party room, games room, outdoor patio with gazebo and BBQ area, plus ample visitor parking. Complete with two underground side-by-side parking spaces and a storage locker, this is carefree condo living at its finest. Just steps from Uptown Waterloo's shops, restaurants, parks, and everyday conveniences. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "847.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T05:05:03.221035+00:00"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-02T15:32:51Z"
+"PhotosCount": 33
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:50:51Z"
+"Stories": "24.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4535"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/6-Willow-St-5"
+"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/29976756/6-willow-street-unit-2203-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1246
+"OriginalEntryTimestamp": "2026-07-02T04:31:26.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29976756')"
+"ID": "1583546"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1582721"
+post_author: 1
+"ListingKey": "29974894"
+"ListingId": "X13508384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T13:50:02Z"
+"RFModificationTimestamp": "2026-07-01T17:14:11Z"
+"ListPrice": 409900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0J1"
+"UnparsedAddress": "206 - 275A LARCH STREET, Waterloo, Ontario N2L0J1"
+"Coordinates": array:2 [
0 => -80.531024
1 => 43.476283
]
+"Latitude": 43.476283
+"Longitude": -80.531024
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious, Safe For Students & Fully Furnished Two Bedrooms Two Full Washrooms, Unit Accessible By Wheelchair. Unit on 275A Larch St. Just Steps Away From The Heart Of Canada's Technology Hub, Next Door To Wilfrid Laurier's New Lazaridis School Of Business And Economics, is situation in The Prime Downtown Area And In Minutes To The University Of Waterloo. Conveniently Located Near All Of The Amenities Waterloo Has To Offer. Premier Suite Finishes 9 Foot Ceilings, Professionally Painted And Deep Cleaned, New Vinyl Flooring Through-out, Ceramic Tile In Bathroom, In Suite Laundry With Stackable Washer/Dryer, Oversized Low E Argon Windows, Texture Ceiling & More. Turnkey Real Estate Investment. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Furniture"
8 => "Window Coverings"
]
+"AssociationFee": "410.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Cable TV"
1 => "Heat"
2 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T17:02:23.712706+00:00"
+"Directions": "Cross Streets: Larch St & Balsam St. ** Directions: Hickory St W & Larch St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1419511"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T13:44:05Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T13:44:05Z"
+"StreetName": "Larch"
+"StreetNumber": "275A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2907.48"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974894/206-275a-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Management Corp"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-01T13:44:05.28Z"
+"ListAgentNationalAssociationId": "1113778"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974894')"
+"ID": "1582721"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: "1582643"
+post_author: 1
+"ListingKey": "29974948"
+"ListingId": "40844402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T14:15:06Z"
+"RFModificationTimestamp": "2026-07-01T17:13:13Z"
+"ListPrice": 295000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "318 SPRUCE Street Unit# 808, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.5264531
1 => 43.4791309
]
+"Latitude": 43.4791309
+"Longitude": -80.5264531
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 808 at 318 Spruce St.—a stylish 1-bed, 1-bath condo offering contemporary finishes, a bright open-concept layout, and stunning eighth-floor views in one of Waterloo's most sought-after locations. Whether you're a first-time buyer, investor, young professional, or university student, this move-in-ready suite combines modern comfort with exceptional convenience. Step inside to discover a thoughtfully designed interior featuring durable modern flooring, contemporary fixtures, and an abundance of natural light throughout. The sleek kitchen is both functional and inviting, showcasing granite countertops, stainless steel appliances, ample cabinetry, and a spacious peninsula with seating—perfect for casual dining or entertaining. The open-concept living area extends seamlessly to your private balcony, where you'll enjoy panoramic views of the Waterloo skyline while sipping your morning coffee or relaxing at the end of the day. The spacious bedroom offers large windows, generous closet space, and plenty of natural light, while the modern 4-piece bath and convenient in-suite laundry add everyday practicality. Residents enjoy an impressive collection of amenities including a fitness centre, an rooftop terrace with BBQs and outdoor seating, a co-working and study space, a theatre room, garbage chute, and reservable guest suites that provide comfortable accommodations for visiting family. Located steps from the University of Waterloo, Wilfrid Laurier University, Conestoga College, LRT, shopping, restaurants, cafés, parks, and countless everyday amenities, this exceptional condo offers outstanding convenience and long-term value. Condo fees include: internet, water, heat, AC, garbage, maintenance, snow & lawn care. Don't miss your next home or a turnkey investment opportunity in Waterloo's thriving university district. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "316.27"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:58:12.354402+00:00"
+"Directions": "King St N & Hickory St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047559"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "None"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-01T14:09:49Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:09:49Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3366"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974948/318-spruce-street-unit-808-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-07-01T14:09:49.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1322997"
+"ListOfficeNationalAssociationId": "1325206"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974948')"
+"ID": "1582643"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25176
+post_id: "1582263"
+post_author: 1
+"ListingKey": "29975147"
+"ListingId": "40841494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:14Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.14
+"LivingArea": 2712.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3S6"
+"UnparsedAddress": "85 ALBERT Street, Waterloo, Ontario N2L3S6"
+"Coordinates": array:2 [
0 => -80.5265075
1 => 43.468486
]
+"Latitude": 43.468486
+"Longitude": -80.5265075
+"YearBuilt": 1916
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Incredible opportunity to own a beautifully updated executive century home in one of Waterloo's most coveted locations, backing directly onto Waterloo Park and just steps from Uptown. The perfect blend of timeless character, modern luxury, and an unbeatable lifestyle. Spend summers in your own private backyard retreat, featuring a low-maintenance saltwater pool, mature trees, professional landscaping, and breathtaking views of Waterloo Park. Inside, this exceptionally bright three-storey home offers a spacious open-concept layout, elegant finishes, & sophisticated design throughout. The heart of the home is a dream kitchen designed for serious cooks, complete with professional built-in Thermador appliances, striking six-burner gas range, custom range hood, convenient pot filler, honed Carrara marble countertops, stainless apron-front sink, oversized island with built-in microwave drawer, and abundant custom cabinetry. The sun-filled main floor showcases hardwood flooring, beautiful gas fireplace with marble surround, generous dining space, and large new sliding door opening onto the backyard deck perfect for seamless indoor-outdoor entertaining. The second level features three spacious bedrooms, convenient upper-level laundry, and a luxurious main bathroom with a whirlpool tub, separate glass shower, and exceptional storage. The third floor offers outstanding flexibility with a bright family room overlooking the park, a private office, and a beautifully appointed bathroom with marble finishes. Ideal as a guest retreat, teen hideaway, home office, or potential in-law suite. Walk to everything that makes Uptown Waterloo so desirable, including boutique shopping, exceptional restaurants, Waterloo Park, the LRT, both universities, Perimeter Institute, CIGI, the Clay & Glass Gallery, trails, and countless community amenities. A rare opportunity to own a truly exceptional home where historic charm, contemporary luxury, and one of Waterloo's finest settings come together. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:08.954087+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1727629"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.14"
+"PhotosChangeTimestamp": "2026-07-01T14:50:54Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:54Z"
+"Stories": "3.0"
+"StreetName": "ALBERT"
+"StreetNumber": "85"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7920.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/qyzis_85_albert_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975147/85-albert-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RC1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2712
+"OriginalEntryTimestamp": "2026-07-01T14:50:54.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1176146"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975147')"
+"ID": "1582263"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1582300"
+post_author: 1
+"ListingKey": "29975321"
+"ListingId": "X13508816"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:55:09Z"
+"RFModificationTimestamp": "2026-07-01T16:36:24Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "1603 - 6 WILLOW STREET, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.516126
1 => 43.465828
]
+"Latitude": 43.465828
+"Longitude": -80.516126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo's most sought-after condominium residences! This stunning 2-bedroom, 2 full bathroom unit offers over 1200 square feet of living space, hardwood flooring throughout, an abundance of natural light, and breathtaking south-facing city views. Located in the heart of Uptown Waterloo, 6 Willow Street offers a walkable lifestyle that is steps away from vibrant restaurants, boutique shopping, groceries, the LRT, Waterloo Park, scenic trails and much more. Set on four acres of meticulously manicured and landscaped grounds, this prestigious building offers the perfect balance of luxury, comfort, and convenience. Residents enjoy exceptional amenities, including an indoor pool, sauna, fitness centre, library, billiards room, party room, conference room, controlled entry, underground parking, secure exclusive-use lockers, comprehensive security systems, and ample visitor parking. Multiple outdoor seating areas throughout the beautifully landscaped property provide the perfect place to relax and unwind. Whether you're downsizing or simply searching for maintenance-free living in one of Waterloo's most desirable addresses, this remarkable unit is an opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "847.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:36:15.678972+00:00"
+"Directions": "Cross Streets: Erb. ** Directions: Erb St E to Willow."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154943"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-01T15:45:38Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T15:45:38Z"
+"StreetName": "Willow"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4329"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/t7cwn_1603_6_willow_st_waterloo_on/"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975321/1603-6-willow-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "T & Company"
+"GeocodeManualYN": true
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Sauna"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-01T15:45:38.13Z"
+"ListAgentNationalAssociationId": "1406411"
+"ListOfficeNationalAssociationId": "1390130"
+"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('29975321')"
+"ID": "1582300"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1582301"
+post_author: 1
+"ListingKey": "29974934"
+"ListingId": "X13508488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:10:09Z"
+"RFModificationTimestamp": "2026-07-02T15:14:47Z"
+"ListPrice": 447500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "PH2 - 55 BLUE SPRINGS DRIVE, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5228237
1 => 43.4870169
]
+"Latitude": 43.4870169
+"Longitude": -80.5228237
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Experience sophisticated penthouse living in the heart of Waterloo. This stunning two-bedroom, two-bathroom residence features a stylish carpet-free interior and dramatic floor-to-ceiling windows that flood the space with natural light while showcasing sweeping views of lush green space and the city skyline. Thoughtfully updated with a new furnace and air conditioner (2021), this home offers both comfort and peace of mind.Enjoy an exceptional lifestyle with exclusive access to premium amenities, including a penthouse rooftop terrace, penthouse lounge, party room, workshop, and private library. Complete with covered parking, a storage locker, and ample visitor parking, this beautifully maintained residence offers the perfect blend of luxury, convenience, and low-maintenance living in one of Waterloo's most sought-after locations. (id:62650)"
+"Appliances": array:6 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "709"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T14:35:51.792338+00:00"
+"Directions": "Cross Streets: King St N. ** Directions: King St N > Blue Springs Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2212512"
+"ListOfficeKey": "292263"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-01T14:03:01Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:03:14Z"
+"StreetName": "Blue Springs"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2895"
+"VirtualTourURLUnbranded": "https://youriguide.com/ph_2_55_blue_springs_dr_waterloo_on/"
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29974934/ph2-55-blue-springs-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2051860"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CE PROPERTY MANAGEMENT AND CONSULTING INC."
+"CoListAgentKey2": "2082979"
+"CoListOfficeKey": "292263"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "292263"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-01T14:03:01.51Z"
+"ListAgentNationalAssociationId": "1458290"
+"ListOfficeNationalAssociationId": "1409914"
+"CoListAgentNationalAssociationId": "1326188"
+"CoListAgentNationalAssociationId2": "1357743"
+"CoListOfficeNationalAssociationId": "1409914"
+"CoListOfficeNationalAssociationId2": "1409914"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974934')"
+"ID": "1582301"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1580907"
+post_author: 1
+"ListingKey": "29973036"
+"ListingId": "40843175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T21:25:01Z"
+"RFModificationTimestamp": "2026-06-30T22:54:28Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1234.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1603, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5161532
1 => 43.4658494
]
+"Latitude": 43.4658494
+"Longitude": -80.5161532
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo's most sought-after condominium residences! This stunning 2-bedroom, 2 full bathroom unit offers over 1200 square feet of living space, hardwood flooring throughout, an abundance of natural light, and breathtaking south-facing city views. Located in the heart of Uptown Waterloo, 6 Willow Street offers a walkable lifestyle that is steps away from vibrant restaurants, boutique shopping, groceries, the LRT, Waterloo Park, scenic trails and much more. Set on four acres of meticulously manicured and landscaped grounds, this prestigious building offers the perfect balance of luxury, comfort, and convenience. Residents enjoy exceptional amenities, including an indoor pool, sauna, fitness centre, library, billiards room, party room, conference room, controlled entry, underground parking, secure exclusive-use lockers, comprehensive security systems, and ample visitor parking. Multiple outdoor seating areas throughout the beautifully landscaped property provide the perfect place to relax and unwind. Whether you're downsizing or simply searching for maintenance-free living in one of Waterloo's most desirable addresses, this remarkable unit is an opportunity you won't want to miss! (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Entrance"
]
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Sauna"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"AssociationFee": "847.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
3 => "Other, See Remarks"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:39:55.480778+00:00"
+"Directions": "Erb St E to Willow St"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160855"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Balcony"
3 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T21:19:50Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T21:19:50Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4329"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/t7cwn_1603_6_willow_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29973036/6-willow-street-unit-1603-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563990"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1234
+"OriginalEntryTimestamp": "2026-06-30T21:19:50.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1411946"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1070024"
+"CoListOfficeNationalAssociationId": "1389824"
+"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('29973036')"
+"ID": "1580907"
}
]
+success: true
+page_size: 9
+page_count: 43
+count: 381
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]