Skip main navigation
Pending
  • $8,295,000

    247 Riverside Ave, Riverside, CT 06878

    6beds
    9,485sqft
    : 
    Residential, Single Family Residence
    Built in 2008
    0.45 Acres Lot
    $8,816,400 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.
    39 days
    |
    536
    |
    8
    |

    Zillow last checked: 7 hours ago

    Listing updated: March 20, 2026 at 11:22am

    Listed by:

    Ellen Mosher 203-705-9680,

    Houlihan Lawrence

    Source: Greenwich MLS, Inc.,MLS#: 124385MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 9
      • Full bathrooms: 8
      • 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

        $8,816,400

        $8.38M - $9.26M

        $7,392/mo

        Price history

        Price history
        DateEventPrice
        3/20/2026Pending sale$8,295,000$875/sqft
        Source: Greenwich MLS, Inc. #124385 Report a problem
        3/5/2026Contingent$8,295,000$875/sqft
        Source: Greenwich MLS, Inc. #124385 Report a problem
        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
        $53,810/mo
        Principal & interest
        $42128
        Property taxes
        $11682
        More affordability tools

          Climate risks

          Neighborhood: Riverside

          Getting around

          34 / 100
          Car-Dependent
          33 / 100
          Somewhat Bikeable

          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