Get new listings emailed daily! JOIN SIGN IN
James Allan Spear
Licensed Real Estate Salesperson
REALTOR®, Realtor
(518) 257-0565 Primary
Facebook Icon 
View Full Photo Gallery

Property Description

Turnkey Hudson Valley Retreat | Resort-Style Living Near HudsonA rare opportunity to own a refined and turnkey Hudson Valley retreat designed for effortless four-season living just minutes from the vibrant heart of Hudson. Privately set amidst serene natural surroundings in Ghent, this exceptional property blends resort-style outdoor living with the warmth, comfort, and lifestyle today's NYC and weekend buyers are searching for. **WAZE or Google Maps Address: 854 Ghent Mellenville Road, Ghent, NY 12075From the moment you arrive, the setting feels like a private escape. The resort-inspired outdoor experience is the true centerpiece of the property, featuring an in-ground saltwater pool, illuminated pergola with fan and electric, custom fire pit area, and expansive open grounds designed for unforgettable entertaining, quiet mornings, and evenings under the stars. Whether hosting summer weekends, gathering with friends after a day exploring Hudson Valley destinations, or simply unwinding in total privacy, the property captures the feeling of a luxury retreat rarely found at this price point.Inside, bright and inviting living spaces flow effortlessly throughout the home, enhanced by 9-foot ceilings on the first floor, abundant natural light, scenic views of the surrounding landscape, and many 2026 appliance upgrades adding to the home's turnkey appeal. The spacious layout includes 4 bedrooms and 2.5 baths, along with approximately 850+ sq ft of additional finished flex space connected to and extending from the second-floor living area - ideal for media space, recreation, fitness, creative pursuits, or today's highly sought-after work-from-home lifestyle. The lower level also offers unfinished storage and utility space for additional convenience and functionality. Fiber optic internet delivers seamless high-speed connectivity, making the property equally suited for remote work and weekend escapes. Enjoy the very best of Hudson Valley living with nearby farm-to-table dining, wineries, orchards, hiking trails, farmers markets, art galleries, and cultural destinations, including FilmColumbia at the historic Crandell Theatre. Outdoor recreation is moments away at Lake Taghkanic State Park, offering boating, kayaking, swimming, and nearby winter activities that add to the property's exceptional year-round appeal. Ideally positioned just 5 miles from the Taconic State Parkway and moments to Hudson, Chatham, and the surrounding Columbia County destinations, this curated Upstate New York retreat offers the pe

854 County Route 9 | MLS# 988566

This single family home located at 854 County Route 9, Ghent, NY 12075 is currently listed for sale with an asking price of $1,045,000. This property was built in 2003 and has 4 bedrooms and 2 full and 1 partial baths with 2268 sq. ft. County Route 9 is located within the Chatham school district. Search Ghent real estate on james-spear.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Sunday May 31st, 12:00pm - 2:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, See Remarks, Storage Space
Basement: Yes
Cooling: Wall/Window Unit(s)
Fenced: Yes
Fireplaces: 1
Garage: 2
Heating: Baseboard, Oil, Other
Home Style: Colonial, Farmhouse
Lot Size: 3.70 Acres
Taxes: $6,355
Year Built: 2003

Amenities

Ceiling Fan(s)
High Ceilings
High Speed Internet
Kitchen Island
Open Floorplan
Open Kitchen
Other
Pantry
Quartz/Quartzite Counters
Recessed Lighting
Storage
Fire Pit
Mailbox

Feature Descriptions

Appliances: Convection Oven, Dishwasher, Electric Cooktop, Electric Range, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer, Oil Water Heater
Attic: Partial
Community Features: Fitness Center, Golf, Park
Days on Site: 26
Exterior: Frame
Fireplace Features: Wood Burning Stove
Fireplace Y/N: Yes
Flooring: Wood
GarageY/N: Yes
Heating Zones: 3
Inclusions: All Stainless Steel and Black Appliances, Light Fixtures
Laundry: Electric Dryer Hookup, Laundry Room
Lot Features: Back Yard, Front Yard, Landscaped, Private
Number Of Kitchens: 1
On Market Date: 2026-04-30
Other Structures: Pergola
Parcel Number: 103889-093-000-0001-006-012-0000
Parking Features: Attached, Driveway, Oversized
Parking Total: 6
Patio And Porch: Deck, Patio, Porch
Pool Features: Fenced, In Ground, Outdoor Pool, Salt Water
Rental Term: Monthly
Rooms Total: 9
Sewer: Septic Tank
Special View Info: Park/Greenbelt, Trees/Woods
Swimming Pool: Yes
Utilities: Cable Available, Electricity Connected, Phone Connected, Trash Collection Private
Water: Well

Local Schools

High School: Chatham High School
Middle School: Chatham Middle School
Elementary School: Mary E Dardess Elementary School
School District: Chatham

Estimate Your Payment

Estimated Payment

$ 3,160.09 per month $2,325.72 Principal & Interest $529.58 Property Tax $304.79 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Houlihan Lawrence Inc.
Agency Contact: 914-967-7680

Shown By

Agent Name: James Allan Spear
Agent Phone: (518) 257-0565 Primary
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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 on this site was last updated 05/26/2026. The listing information on this page last changed on 05/26/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 05/26/2026 1:16:38 PM EST) or Global MLS (last updated Tue 05/26/2026 1:07:55 PM EST) or New York State Alliance MLS (last updated Tue 05/26/2026 1:15:21 PM EST) or Hudson Valley Catskill Region MLS (last updated Tue 05/26/2026 1:11:27 PM EST) or OneKey MLS (last updated Tue 05/26/2026 1:09:44 PM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.



C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell Banker®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel

THANK YOU FOR
YOUR INTEREST!

Complete the fields below to receive additional details.

Add to Calendar

Reserve A Time

Cancel Your Appointment?

Registration Successful

You are now registered to view virtual open houses for the listings.