28 Riverview Street

Columbia County NY 12173

1600 sq. ft.

10454.4 sq. ft.

Single-Family

Last sold for $795,000

Overview

Timeless Hudson River Beauty Fully Renovated 1880s Farmhouse with Sweeping Water Views Perched on one of Stuyvesant's most coveted historic streets, this exquisitely restored 1880 farmhouse offers a rare blend of refined heritage, modern luxury, and cinematic views of the Hudson River and the cliffs of Greene County. Set on a quiet rise among Riverview Street's storied homes, the residence has been meticulously renovated to preserve its 19th-century soul while introducing elegant, contemporary comforts. From nearly every window, take in unobstructed vistas of the river—ever-changing with the light and seasons—making this home a serene and inspiring retreat just 2.5 hours from NYC or Boston. Inside, approximately 1,600 square feet of sun-drenched living space unfolds across three bedrooms and two stylishly updated baths. Original wide-plank floors, high ceilings, and carved double fireplace mantels have been lovingly maintained, complemented by thoughtful updates like central air and bespoke lighting. The heart of the home—a gourmet eat-in kitchen—flows effortlessly into the formal dining room and out to a lushly landscaped rear garden, ideal for effortless entertaining or quiet weekend morning reflection. Upstairs, a gracious central hall leads to three tranquil bedrooms, a full bath, and a sun-filled sitting nook overlooking the river—perfect for reading, or an afternoon nap with the breeze as your soundtrack. Out front, a full-length porch offers commanding views of the Hudson, where you can savor fiery sunsets and watch sailboats drift by. In back, a private terraced garden and porch offer space for al fresco dinners and intimate gatherings under the stars. A spacious detached garage—formerly an artist's studio—awaits your vision, complete with a wood-burning stove. Located just 20 minutes from Hudson's Warren Street and Amtrak, and within easy reach of Kinderhook, Albany, and the Berkshires, this rare offering captures the essence of luxury country living with water views that are nothing short of magical.

Features

3 bedrooms

2 bathrooms

1 carspace

1 garage space

1600 sq. ft. floor area

10454.4 sq. ft. lot size

Single-Family

Estimated Value

Based on this property and similar 3 bedroom single-family properties sold in Columbia County over the last 12 months, the estimated median property value of 28 Riverview Street is $275k.

Median value

$275k

Estimated value range

$96.9k - $795k

Median days on market

Estimated value trend

-48%

decrease over the last 12 months

Average days on market is based on recent, comparable sales in Columbia County. It is only an indication of the time a property is actively listed and should not be relied upon as an accurate representation of how soon a property will be sold.

Property history for 28 Riverview Street

2026

Sold

$795,000

16 Mar 2026

2022

Sold

$750,000

18 Oct 2022 by JANET KAIN, of The Kinderhook Group, Inc.

2021

Sold

$735,000

22 Jan 2021 by Alison Vaccarino, of Rouse + Co Real Estate, LLC

Happy sellers in Columbia County

We have insufficient information to provide an overview of customer satisfaction for Columbia County. Viewing the agent profiles, reviews and sales for Columbia County can provide insights for this location.