$8,295,000
UNDER CONTRACT

247 Riverside Ave Riverside, CT 06878

Estimated payment $46,921/month

Total Views 1,507
6 Beds
8.5 Baths
9,485 Sq Ft
$875 Price per Sq Ft

Highlights

  • Private Pool
  • Sauna
  • Colonial Architecture
  • Riverside School Rated A+
  • Eat-In Gourmet Kitchen
  • Finished Attic

About This Home

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.

Listing Agent

Ellen Mosher

Houlihan Lawrence License #RES.0775225 Listed on: 02/24/2026

Houlihan Lawrence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $45,134

Year Built

  • Built in 2008 | Remodeled in 2025

Lot Details

  • 0.45 Acre Lot
  • Fenced Yard
  • Level Lot
  • Property is zoned R-12

Parking

  • 3 Car Attached Garage
  • Electric Vehicle Home Charger

Home Design

  • Colonial Architecture
  • Wood Roof
  • Shingle Siding

Interior Spaces

  • 9,485 Sq Ft Home
  • Rear Stairs
  • Built-In Features
  • Coffered Ceiling
  • Tray Ceiling
  • High Ceiling
  • Recessed Lighting
  • 6 Fireplaces
  • Bay Window
  • Pocket Doors
  • French Doors
  • Mud Room
  • Entrance Foyer
  • Formal Dining Room
  • Game Room
  • Play Room
  • Sauna
  • Home Gym
  • Finished Attic
  • Home Security System
  • Finished Basement

Kitchen

  • Eat-In Gourmet Kitchen
  • Walk-In Pantry

Bedrooms and Bathrooms

  • 6 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Steam Shower

Laundry

  • Laundry Room
  • Washer and Dryer

Outdoor Features

  • Private Pool
  • Balcony
  • Terrace
  • Outdoor Gas Grill

Utilities

  • Central Air
  • Heating System Uses Gas
  • Heating System Uses Natural Gas
  • Hydro-Air Heating System
  • Power Generator
  • Gas Available
  • Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 05-1768/S

Home Details

Home Type

Single Family

Est. Annual Taxes

$45,134

Year Built

Built in 2008 | Remodeled in 2025

Lot Details

0.45 Acres

Parking

3

Listing Details

  • Prop. Type: Residential
  • Year Built: 2008
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.45
  • Inclusions: Washer/Dryer, Call LB, All Kitchen Applncs
  • Architectural Style: Colonial
  • Effective Year Built: 2025
  • Entry Hall Comments:Foyer: Yes
  • Cooling System:Central AC: Yes
  • Included:WasherDryer: Yes
  • Lot Description:Level: Yes
  • Features:Terrace: Yes
  • Features:Fenced Yard: Yes
  • Features:Security System2: Yes
  • Entry Hall Ceilings:Extra Height: Yes
  • Features:Generator: Yes
  • Features:Gas Grill: Yes
  • Features:Back Stairs: Yes
  • Features:Sauna: Yes
  • Entry Hall LevelFP 1st37: 1
  • Special Features: UnderContract
  • Year Renovated: 2025

Interior Features

  • Other Equipment: Generator
  • Has Basement: Finished
  • Full Bathrooms: 8
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplaces: 6
  • Fireplace: Yes
  • Interior Amenities: Eat-in Kitchen, Entrance Foyer, Pantry, Back Stairs, Sauna
  • Window Features: Bay Window(s)
  • Kitchen Comments:Gourmet: Yes
  • Primary Bdrm Ceilings:Tray9: Yes
  • Primary Bdrm Comments:Walk-in Closet(s): Yes
  • Primary Bth Comments:Luxury Bath: Yes
  • Laundry Comments:Separate Room: Yes
  • Living Room LevelFP:FP2: 1
  • Primary Bdrm LevelFP:FP8: 1
  • Basement Type:Finished2: Yes
  • Kitchen Comments:Eat-In Kitchen: Yes
  • Primary Bdrm Comments:Balcony2: Yes
  • Primary Bth Comments:Steam Shower: Yes
  • Attic Finished: Yes
  • Family Room LevelFP:FP5: 2
  • Family Room Comments:French Doors2: Yes
  • Family Room Ceilings:Extra Height6: Yes
  • Primary Bdrm Comments:Primary Bedroom Suite: Yes
  • Dining Room Comments:Formal: Yes
  • Other Room Comments 3:Game Room3: Yes
  • Living Room Ceilings:Extra Height2: Yes
  • Dining Room Ceilings:Extra Height4: Yes
  • Powder Room Ceilings:Extra Height7: Yes
  • Kitchen Ceilings:Extra Height8: Yes
  • Family Room LevelFP:LL41: 1
  • Living Room Comments:Bay Window: Yes
  • LibraryDen LevelFP:FP4: 1
  • LibraryDen Comments:Built-Ins3: Yes
  • Dining Room LevelFP:FP3: 1
  • Other Room Comments:Mudroom: Yes
  • Other Room LevelFP 3:LL51: 2
  • Primary Bth Ceilings:Extra Height10: Yes
  • Dbl Bdrms Ceilings:Extra Height16: Yes
  • LibraryDen Ceilings:Coffered5: Yes
  • LibraryDen Ceilings:Extra Height5: Yes
  • Other Room Comments 3:Exercise Room4: Yes
  • Family Room Ceilings:Coffered6: Yes
  • Living Room Comments:Pocket Door: Yes
  • Other Room Comments 2:Playroom2: Yes
  • Living Room LevelFP 1st38: 1
  • Dining Room LevelFP 1st39: 1
  • Family Room LevelFP 1st41: 1
  • Powder Room LevelFP 1st42: 1
  • Kitchen LevelFP 1st43: 1
  • Primary Bdrm LevelFP 2nd44: 1
  • Primary Bath LevelFP 2nd45: 2
  • Bath LevelFP 1st48: 2
  • Laundry LevelFP 2nd53: 1
  • LibraryDen LevelFP 1st40: 1
  • Laundry LevelFP 1st53: 1

Exterior Features

  • Roof: Wood
  • Lot Features: Level
  • Pool Private: Yes
  • Exclusions: Call LB
  • Construction Type: Shingle Siding
  • Exterior Features: Gas Grill
  • Patio And Porch Features: Terrace
  • Exterior:Shingle Siding: Yes
  • Roof:Wood: Yes

Garage/Parking

  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features: Attached Garage

Utilities

  • Water Source: Public
  • Cooling: Central Air
  • Laundry Features: Laundry Room
  • Security: Security System
  • Cooling Y N: Yes
  • Heating: Natural Gas, Hydro-Air
  • Heating Yn: Yes
  • Sewer: Town Sewer
  • Heat Fuel:Gas: Yes
  • Water Source:Public: Yes
  • Sanitation Source:Town Sewer: Yes
  • Hot Water:Gas2: Yes
  • Gas Source:Public Utility: Yes
  • Heat System:Hydro-Air: Yes

Schools

  • Elementary School: Riverside
  • Middle Or Junior School: Eastern

Lot Info

  • Zoning: R-12
  • Lot Size Sq Ft: 19602.0
  • Parcel #: 05-1768/S

Tax Info

  • Tax Annual Amount: 45134.0

Map

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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/24/2026 02/24/26 For Sale $8,295,000 +33.8% $875 / Sq Ft
12/05/2024 12/05/24 Off Market $6,200,000 -- --
12/02/2024 12/02/24 Sold $6,200,000 -6.8% $654 / Sq Ft View Prior Sale
10/24/2024 10/24/24 Pending -- -- --
09/30/2024 09/30/24 For Sale $6,650,000 +18.8% $701 / Sq Ft
06/14/2021 06/14/21 Sold $5,600,000 +0.1% $590 / Sq Ft View Prior Sale
04/29/2021 04/29/21 Pending -- -- --
04/20/2021 04/20/21 For Sale $5,595,000 -- $590 / Sq Ft
Source: Greenwich Association of REALTORS®

Source: Greenwich Association of REALTORS®

MLS Number: 124385

Greenwich Association of REALTORS®

APN: GREE M:05 B:1768/S

Your Personal Tour Guide

Ask me questions while you tour the home.