The Hamptons meets Greenwich.
This ultra-chic property, built by SBP-Sound Beach Partners, has just undergone a comprehensive, top-to-bottom renovation designed for the way we live now blending timeless classic architecture with a fresh, lifestyle-driven edge made for seamless everyday living.
Inside, the crisp, light-filled design makes an immediate statement. Four finished levels unfold with six bedrooms and an airy, open-concept layout anchored by wide-plank white oak floors and fresh, on-trend designer lighting throughout. The original build showcased exceptional craftsmanship, and last year's comprehensive renovation elevated every surface and finish. Soaring ten-foot ceilings and walls of windows drench the main living space in natural light. Formal rooms are substantial and flow easily between casual spaces. The new chef's kitchen is as stunning as it is functional, with quartz countertops, a striking porcelain tile backsplash and enormous island . A full suite of Miele appliances, separate catering-ready kitchen, walk in food pantry and oversized breakfast and desk areas are adjacent to the family room-a natural gathering spot anchored by a fireplace and coffered ceilings. A handsome office tucked away offers a quiet work-from-home retreat or can double as a first-floor guest room. There are smartly designed mudroom areas and multiple baths for poolside living and entertaining ease.
Upstairs, the primary suite feels straight out of a Nancy Meyers movie--a serene retreat drenched in light with two marble-clad bathrooms, two custom walk-in closets and a private balcony overlooking the pool and open lawn. Four additional en-suite bedrooms complete the second floor, each with their own personality, while the third level unfolds as a generous playroom or art studio flooded with light.
The fully renovated lower level is where the fun truly comes alive: Golf Simulator, another family room, guest/nanny suite, fully equipped gym, relaxing sauna, wine room and a show-stopping custom bar built for everything from weekend hangouts to game night marathons.
The redesigned grounds are just as impressive as the house itself. A deep, private lawn framed by 40 new tall trees sets the scene for the ultimate backyard escape, complete with a stunning new rectangular pool and spa with automated cover, a covered lounge featuring a stone fireplace and TV, plus a full outdoor kitchen. Every detail has been thoughtfully upgraded--from reimagined hardscaping and landscaping to enhanced drainage, expanded irrigation, outdoor lighting, a convenient parking courtyard, fresh plantings, stone enhancements and lush new sod.
Behind the scenes, no detail was overlooked--every modern upgrade has been integrated, including a Kohler 30KW whole-house generator, Lutron RadioRA3 lighting system, water filtration, Total Connect security with cameras, Google Nest climate control, EV charger and LED recessed lighting.
For those who love the specifics, every detail of the renovation is outlined and ready for review in the attached document.
This incredible property is just moments from public and private schools, train, village of Old Greenwich, Binney Park and the beaches at Greenwich Point. This is exactly the lifestyle and home you've been waiting for.
For sale
$8,295,000
247 Riverside Ave, Riverside, CT 06878
6beds
9,485sqft
Est.:
Residential, Single Family Residence
Built in 2008
0.45 Acres Lot
$-- Zestimate®
$875/sqft
$-- HOA
What's special
Soaring ten-foot ceilingsFour additional en-suite bedroomsTwo marble-clad bathroomsWide-plank white oak floorsEnormous islandStriking porcelain tile backsplashQuartz countertops
- 4 hours |
- 1,235 |
- 50 |
Zillow last checked: 8 hours ago
Listing updated: 12 hours ago
Listed by:
Ellen Mosher 203-705-9680,
Houlihan Lawrence
Source: Greenwich MLS, Inc.,MLS#: 124385
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 8
- Full bathrooms: 7
- 1/2 bathrooms: 1
Heating
- Natural Gas, Hydro-Air
Cooling
- Central Air
Appliances
- Laundry: Laundry Room
Features
- Eat-in Kitchen, Entrance Foyer, Pantry, Back Stairs, Sauna
- Windows: Bay Window(s)
- Basement: Finished
- Number of fireplaces: 6
Interior area
- Total structure area: 9,485
- Total interior livable area: 9,485 sqft
Property
Parking
- Total spaces: 3
- Parking features: Garage
- Garage spaces: 3
Features
- Patio & porch: Terrace
- Exterior features: Gas Grill
- Has private pool: Yes
Lot
- Size: 0.45 Acres
- Features: Level
Details
- Parcel number: 051768/S
- Zoning: R-12
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Residential, Single Family Residence
Materials
- Shingle Siding
- Roof: Wood
Condition
- Year built: 2008
- Major remodel year: 2025
Utilities & green energy
- Water: Public
Community & HOA
Community
- Security: Security System
Location
- Region: Riverside
Financial & listing details
- Price per square foot: $875/sqft
- Tax assessed value: $3,651,900
- Annual tax amount: $45,134
- Date on market: 2/24/2026
- Inclusions: Washer/Dryer, Call LB, All Kitchen Applncs
Estimated market value
Not available
Estimated sales range
Not available
$7,392/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 2/25/2026 | Listed for sale | $8,295,000+33.8%$875/sqft |
Source: | ||
| 12/2/2024 | Sold | $6,200,000-6.8%$654/sqft |
Source: | ||
| 10/24/2024 | Pending sale | $6,650,000$701/sqft |
Source: | ||
| 9/4/2024 | Listed for sale | $6,650,000+18.8%$701/sqft |
Source: | ||
| 6/14/2021 | Sold | $5,600,000+0.1%$590/sqft |
Source: BHHS NE Properties sold #112885_06878 Report a problem | ||
| 4/29/2021 | Pending sale | $5,595,000$590/sqft |
Source: | ||
| 4/20/2021 | Listed for sale | $5,595,000-3.5%$590/sqft |
Source: Greenwich MLS, Inc. #112885 Report a problem | ||
| 12/15/2020 | Listing removed | $5,795,000$611/sqft |
Source: Berkshire Hathaway HomeServices New England Properties #109961 Report a problem | ||
| 6/2/2020 | Listed for sale | $5,795,000$611/sqft |
Source: Berkshire Hathaway HomeServices New England Properties #109961 Report a problem | ||
| 1/1/2020 | Listing removed | $5,795,000$611/sqft |
Source: Berkshire Hathaway HomeServices New England Properties #106944 Report a problem | ||
| 6/10/2019 | Listed for sale | $5,795,000+9.3%$611/sqft |
Source: Berkshire Hathaway HomeServices New England Properties #106944 Report a problem | ||
| 1/24/2011 | Sold | $5,300,000-5.4%$559/sqft |
Source: Public Record Report a problem | ||
| 11/6/2010 | Listed for sale | $5,600,000+154.2%$590/sqft |
Source: ColdwellBankerMoves.com #77856 Report a problem | ||
| 1/4/2008 | Sold | $2,203,000$232/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $45,134 +3.5% | $3,651,900 |
| 2024 | $43,589 +2.6% | $3,651,900 |
| 2023 | $42,494 +0.9% | $3,651,900 |
| 2022 | $42,106 +1.1% | $3,651,900 +5.6% |
| 2021 | $41,631 +1.1% | $3,457,720 +0.9% |
| 2020 | $41,178 -1% | $3,425,800 |
| 2019 | $41,589 +2.3% | $3,425,800 |
| 2018 | $40,664 -1.2% | $3,425,800 |
| 2017 | $41,175 +18.1% | $3,425,800 +17.1% |
| 2015 | $34,875 +4.3% | $2,924,530 +1.7% |
| 2014 | $33,439 +2.8% | $2,876,440 |
| 2013 | $32,533 +2.8% | $2,876,440 |
| 2012 | $31,641 +3.4% | $2,876,440 |
| 2011 | $30,605 +10.4% | $2,876,440 -6.2% |
| 2010 | $27,724 +41.7% | $3,066,770 +37% |
| 2009 | $19,562 +90.1% | $2,238,250 +83.5% |
| 2008 | $10,292 +3.5% | $1,219,470 -0.1% |
| 2007 | $9,948 +3.8% | $1,220,590 |
| 2006 | $9,582 +3.2% | $1,220,590 +58.9% |
| 2005 | $9,289 +3.6% | $768,320 |
| 2004 | $8,966 +3.4% | $768,320 |
| 2003 | $8,674 +27.5% | $768,320 +111.2% |
| 2001 | $6,804 +5.7% | $363,860 |
| 2000 | $6,440 -4.6% | $363,860 |
| 1999 | $6,750 | $363,860 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$54,459/mo
Principal & interest
$42777
Property taxes
$11682
Climate risks
Neighborhood: Riverside
Nearby schools
GreatSchools rating
- 9/10Riverside SchoolGrades: K-5Distance: 0.2 mi
- 9/10Eastern Middle SchoolGrades: 6-8Distance: 0.4 mi
- 10/10Greenwich High SchoolGrades: 9-12Distance: 1.8 mi
Schools provided by the listing agent
- Elementary: Riverside
- Middle: Eastern
Source: Greenwich MLS, Inc.. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.








