Skip main navigation
For sale
  • $8,295,000

    247 Riverside Ave, Riverside, CT 06878

    6beds
    9,485sqft
    : 
    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
    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.
    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#: 124385MLS Logo

    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
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    Not available

    Estimated sales range

    Not available

    $7,392/mo

    Price history

    Price history
    DateEventPrice
    2/25/2026Listed for sale$8,295,000+33.8%$875/sqft
    Source: Greenwich MLS, Inc. #124385 Report a problem
    12/2/2024Sold$6,200,000-6.8%$654/sqft
    Source: Greenwich MLS, Inc. #121332 Report a problem
    10/24/2024Pending sale$6,650,000$701/sqft
    Source: Greenwich MLS, Inc. #121332 Report a problem
    9/4/2024Listed for sale$6,650,000+18.8%$701/sqft
    Source: Greenwich MLS, Inc. #121332 Report a problem
    6/14/2021Sold$5,600,000+0.1%$590/sqft
    Source: BHHS NE Properties sold #112885_06878 Report a problem
    4/29/2021Pending sale$5,595,000$590/sqft
    Source: Berkshire Hathaway HomeServices New England Properties #112885 Report a problem
    4/20/2021Listed for sale$5,595,000-3.5%$590/sqft
    Source: Greenwich MLS, Inc. #112885 Report a problem
    12/15/2020Listing removed$5,795,000$611/sqft
    Source: Berkshire Hathaway HomeServices New England Properties #109961 Report a problem
    6/2/2020Listed for sale$5,795,000$611/sqft
    Source: Berkshire Hathaway HomeServices New England Properties #109961 Report a problem
    1/1/2020Listing removed$5,795,000$611/sqft
    Source: Berkshire Hathaway HomeServices New England Properties #106944 Report a problem
    6/10/2019Listed for sale$5,795,000+9.3%$611/sqft
    Source: Berkshire Hathaway HomeServices New England Properties #106944 Report a problem
    1/24/2011Sold$5,300,000-5.4%$559/sqft
    Source: Public Record Report a problem
    11/6/2010Listed for sale$5,600,000+154.2%$590/sqft
    Source: ColdwellBankerMoves.com #77856 Report a problem
    1/4/2008Sold$2,203,000$232/sqft
    Source: Public Record Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax 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
      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.

      Local experts in 06878

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel
      • Loading
      • Loading