Seller's Agent in 2025
Joseph Piscitelli
Coldwell Banker Milford
(203) 878-7424
14 in this area
56 Total Sales
Guilford ~ Old Quarry Area ~ Waterview Contemporary ~ one of the most unique homes on the entire Eastern seaboard. Set on 3.39 Acres. Designed to capture spectacular southerly views over Little Harbor as well as Long Island Sound. With its walls of glass, high ceilings & numerous Transom windows this Unique Designed Home allows for natural views to flow easily through nearly every living area. The Main Level Features Dramatic Entertaining area including a spacious Renovated Chefs Kitchen with Wolf & Subzero Appliances, Granite counters & Center Island with Breakfast Bar. A Generous Great Room featuring wood burning FP, Curved 20ft ceiling, Family rm also with 20 ft Ceiling & Sliders to Large Deck, great for entertaining and evening dinners. Two Bedrooms overlooking Pool Area, plus full bath & powder rm complete this Floor. The upper level offers a Spectacular Primary Bedroom Suite w/deck for enjoying morning sunrises and evening sunsets, featuring a domed ceiling. Sitting Area/office w/FP & Sliders to Deck. Two additional bedrooms with Waterview's & bath. The Lower Level Offers a Guest bedroom w/ Wood Burning FP w/Sliders to Deck, Entertainment room leading to the pool area. Additional features include access to Little Harbor, Koi Pond, whole house generator, 2 car detached garage & circular driveway. Enjoy some of the best Boating, Kayaking & Hiking trails on the CT Shoreline. Convenient to Town, Yale and Train.
Last Agent to Sell the Property
Coldwell Banker Realty Brokerage Phone: (203) 982-3511 License #RES.0542931 Listed on: 05/10/2025
Co-Listed By
Coldwell Banker Realty Brokerage Phone: (203) 982-3511 License #RES.0800672
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $2,200,000 | -- | |
| Warranty Deed | $875,000 | -- | |
| Deed | $1,037,500 | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $1,500,000 | No Value Available | |
| Previous Owner | $400,000 | No Value Available | |
| Previous Owner | $300,000 | No Value Available | |
| Previous Owner | $550,000 | No Value Available |
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 12/14/2025 12/14/25 | Pending | -- | -- | -- |
| 12/12/2025 12/12/25 | Sold | $2,200,000 | 0.0% | $557 / Sq Ft |
| 08/23/2025 08/23/25 | Price Changed | $2,200,000 | -11.5% | $557 / Sq Ft |
| 08/01/2025 08/01/25 | Price Changed | $2,485,000 | -6.2% | $629 / Sq Ft |
| 07/11/2025 07/11/25 | Price Changed | $2,650,000 | -5.4% | $671 / Sq Ft |
| 06/25/2025 06/25/25 | Price Changed | $2,800,000 | -9.7% | $709 / Sq Ft |
| 05/10/2025 05/10/25 | For Sale | $3,100,000 | -- | $785 / Sq Ft |
| 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 | $39,124 | $1,414,980 | $1,178,660 | $236,320 |
| 2024 | $43,639 | $1,641,780 | $1,198,680 | $443,100 |
| 2023 | $42,489 | $1,641,780 | $1,198,680 | $443,100 |
| 2022 | $19,414 | $583,890 | $294,270 | $289,620 |
| 2021 | $19,046 | $583,890 | $294,270 | $289,620 |
| 2020 | $18,865 | $583,890 | $294,270 | $289,620 |
| 2019 | $18,702 | $583,890 | $294,270 | $289,620 |
| 2018 | $18,264 | $583,890 | $294,270 | $289,620 |
| 2017 | $18,112 | $616,900 | $283,230 | $333,670 |
| 2016 | $17,687 | $616,900 | $283,230 | $333,670 |
Seller's Agent in 2025
Joseph Piscitelli
Coldwell Banker Milford
(203) 878-7424
14 in this area
56 Total Sales
J
Seller Co-Listing Agent in 2025
John Guarino
Coldwell Banker Milford
(949) 903-1721
12 in this area
52 Total Sales
Buyer's Agent in 2025
Rose Ciardiello
William Raveis Real Estate
(203) 314-6269
147 in this area
330 Total Sales
Source: SmartMLS
MLS Number: 24074214
APN: GUIL-000120-000000-000077A