The home you've been waiting for—a timeless 5 bedroom Colonial, thoughtfully designed and built by renowned Sound Beach Partners (SBP) in the coveted Riverside neighborhood of Greenwich, CT. Set back from the road, this sun-filled residence has stunning architectural details, luxurious finishes, 10-foot ceilings, and hardwood floors throughout. The open, modern floor plan seamlessly blends elegant formal rooms with casual living spaces, all of which open onto a private fenced yard and veranda—perfect for entertaining or relaxation.
An exceptional primary suite features soaring vaulted ceilings, a fireplace, a walk-in closet, and a private balcony. There are three additional spacious bedrooms on this level plus space on third floor that is ready for customization. The lower level has 9-foot ceilings and includes a gym, playroom and bedroom with a private bath. The guest room is easily adaptable to an office, with its own separate exterior entrance.
An additional feature is a large cedar closet with potential for conversion into a wine cellar. Expansive open lawns for outdoor play, a wraparound porch, porte-cochère, two-car garage, and a generator too. All of this is just steps from schools and the train station - an ideal location for both convenience and luxury living.
Sold
$4,525,000
242 Riverside Ave, Riverside, CT 06878
5beds
5,158sqft
Residential, Single Family Residence
Built in 2006
0.28 Acres lot
$4,561,700 Zestimate®
$877/sqft
$-- HOA
What's special
Zillow last checked: 7 hours ago
Listing updated: March 14, 2025 at 03:17pm
Listed by:
Ellen Mosher 203-705-9680,
Houlihan Lawrence
Bought with:
Julie Church, RES.0762194
Houlihan Lawrence
Source: Greenwich MLS, Inc.,MLS#: 121978

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Laundry: Laundry Room
Features
- Sep Shower, Eat-in Kitchen, Kitchen Island, Entrance Foyer
- Basement: Finished,Full
- Number of fireplaces: 3
Interior area
- Total structure area: 5,158
- Total interior livable area: 5,158 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Garage spaces: 2
Features
- Patio & porch: Terrace
- Fencing: Fenced
Lot
- Size: 0.28 Acres
- Features: Level
Details
- Parcel number: 057 05 2671/S
- Zoning: R-12
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Residential, Single Family Residence
Materials
- Wood Siding
- Roof: Wood
Condition
- Year built: 2006
- Major remodel year: 2012
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Riverside