Seller's Agent in 2026
Ryan Mills
Superlative Real Estate, Inc.
(716) 553-3558
2 in this area
231 Total Sales
40 Waterfront Cir Buffalo, NY 14202
Waterfront Neighborhood
2
Beds
2
Baths
1,945
Sq Ft
1990
Built
Highlights
- Wood Flooring
- Formal Dining Room
- Eat-In Kitchen
- 1 Fireplace
- 1 Car Attached Garage
- Forced Air Heating and Cooling System
About This Home
As of May 2026Spectacular and breathtaking 3rd floor unit with unbelievable panoramic waterfront views!! Recently underwent complete renovation! (2024) This unit is essentially a new build!!! Has not been lived in since entirely remodeled! Everything is brand new including kitchen and bathrooms! Exquisite custom millwork and finishes throughout. Kitchen includes giant island, artisan cabinetry, quartz counters, SS appliances and more!! Spacious open family room with hard maple flooring and linear fireplace adjoins eat in kitchen. Family room and kitchen enjoy captivating waterfront views. Patio overlooks prime Buffalo waterfront! Primary suite includes custom built in closets and oversized dual head shower with quartz slab walls. Underground parking and personal boat slip included. Whether it's watching a summer sunset, or a storm roll in, the views from this unit are unmatched!!
Last Agent to Sell the Property
Listing by Superlative Real Estate, Inc. License #35MI1015957 Listed on: 11/14/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $7,616
Year Built
- Built in 1990
Lot Details
- Lot Dimensions are 400x0
- Rectangular Lot
HOA Fees
- $71 Monthly HOA Fees
Parking
- 1 Car Attached Garage
- Assigned Parking
Home Design
- Brick Exterior Construction
- Stucco
Interior Spaces
- 1,945 Sq Ft Home
- 1-Story Property
- 1 Fireplace
- Formal Dining Room
- Eat-In Kitchen
Flooring
- Wood
- Ceramic Tile
Bedrooms and Bathrooms
- 2 Main Level Bedrooms
- 2 Full Bathrooms
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- Association fees include common area maintenance, common area insurance, common areas, insurance, maintenance structure, reserve fund, sewer, snow removal, trash, water
- Fairwood Association, Phone Number (716) 656-9070
- Waterfront Village Pt I Subdivision
Listing and Financial Details
- Assessor Parcel Number 140200-110-680-0001-007-100-301
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 18, 2007
Sold by
Daly Ellen and Daly James J
Bought by
Hayes John and Hayes Lynne R
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Executors Deed | $202,500 | None Available | |
| Executors Deed | $202,500 | None Available | |
| Executors Deed | $202,500 | None Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 05/29/2026 05/29/26 | Sold | $975,000 | -2.5% | $501 / Sq Ft | |
| 04/25/2026 04/25/26 | Pending | -- | -- | -- | |
| 11/14/2025 11/14/25 | For Sale | $999,900 | +8.1% | $514 / Sq Ft | |
| 08/05/2025 08/05/25 | Sold | $925,000 | -5.1% | $314 / Sq Ft | View Prior Sale |
| 06/27/2025 06/27/25 | Pending | -- | -- | -- | |
| 06/13/2025 06/13/25 | For Sale | $975,000 | -- | $331 / Sq Ft |
Source: Western New York Real Estate Information Services (WNYREIS)
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | -- | $362,000 | $0 | $362,000 |
| 2024 | $731 | $272,000 | $1 | $271,999 |
| 2023 | $897 | $272,000 | $1 | $271,999 |
| 2022 | $890 | $272,000 | $1 | $271,999 |
| 2021 | $890 | $272,000 | $1 | $271,999 |
| 2020 | $542 | $272,000 | $1 | $271,999 |
| 2019 | $3,179 | $176,500 | $13,400 | $163,100 |
| 2018 | $3,779 | $176,500 | $13,400 | $163,100 |
| 2017 | $419 | $176,500 | $13,400 | $163,100 |
| 2016 | $2,923 | $176,500 | $13,400 | $163,100 |
| 2015 | -- | $176,500 | $13,400 | $163,100 |
| 2014 | -- | $176,500 | $13,400 | $163,100 |
Source: Public Records
Agents Affiliated with this Home
-
Ryan Mills
-
Sarah Carney
S
Buyer's Agent in 2026
Sarah Carney
Symphony Real Estate LLC
(716) 913-3094
1 in this area
2 Total Sales
-
Christine Piggot
Seller's Agent in 2025
Christine Piggot
Howard Hanna
(716) 932-5300
1 in this area
17 Total Sales
-
Dana Sciolino
Buyer's Agent in 2025
Dana Sciolino
WNY Metro Roberts Realty
(716) 544-1631
2 in this area
134 Total Sales
Map
Source: Western New York Real Estate Information Services (WNYREIS)
MLS Number: B1651044
APN: 140200-110-680-0001-007-100-407
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, UNYREIS and WNYREIS. Real estate listings held by firms other than Homes.com, LLC are marked with the IDX logo and include the Listing Broker’s Firm Name.
Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties
are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor Homes.com, LLC shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless.
© 2026 CNYIS, UNYREIS, WNYREIS. All rights reserved.
Nearby Homes
- 40 Waterfront Cir Unit 401
- 40 Waterfront Cir Unit 305
- 40 Waterfront Cir Unit 406
- 207 Admirals Walk
- 201 Admirals Walk
- 132 Lakefront Blvd Unit 204
- 132 Lakefront Blvd Unit 401
- 132 Lakefront Blvd Unit 404
- 132 Lakefront Blvd Unit 902
- 47 Ojibwa Cir
- 252 Rivermist Dr
- 801 Admirals Walk Cir
- 75 Ojibwa Cir Unit 505
- 200 Lakefront Blvd Unit 301
- 324 Rivermist Dr
- 300 Rivermist Dr
- 18 Marina Park S Unit 18
- 240 Lakefront Blvd
- 244 Lakefront Blvd
- 260 Lakefront Blvd
Your Personal Tour Guide
Ask me questions while you tour the home.