SoldMar 16, 2026

Source: Multiple Listing Service of Ulster County #20252214

28 Riverview Street, Columbia County, NY, 12173

$795,000

3
2
1
1600 sq. ft.
10454.4 sq. ft.

SingleFam

30+ days on the market

Sold: Mar 16, 2026

What's around 28 Riverview Street

About this property

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.

Looking for more information on 28 Riverview Street?

Explore comparables, sales history and growth for this property.
Learn more

Similar properties sold nearby

SoldMay 22, 2026
$285,000
623 State Route 9J
Stuyvesant NY 12173
3
2
6
Single-Family
Listing courtesy of The Kinderhook Group, Inc.
SoldMay 8, 2026
$365,000
437 Sharptown Rd
Columbia County NY 12173
3
2
2
Single-Family
Listing courtesy of Coldwell Banker Prime Properti
SoldApr 28, 2026
$287,000
16 Royal Road
Stuyvesant NY 12173
3
1
4
Single-Family
Listing courtesy of Berkshire Hathaway Blake

Browse properties sold in nearby areas

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the Ulster County Board of REALTORS®. IDX information is provided exclusively for consumers' personal, non - commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. Copyright ©2026 Ulster County Board of REALTORS®, Inc.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under MLS GRID IDX Rules Updated September 16, 2024 7 U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: dmca@ratemyagent.com

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 RateMyAgent