Skip to main content

MLS ID KEY985224Last updated Sep 18, 2026

Mixed Use

5125 Route 209

Active · Rochester · Ulster County, NY 12404

Asking price$925,000Request a Showing
Year built
2004
Est. monthly taxes
$687.19
Property gallery0 / 36
Loading photo…Photo unavailable

About this home

This beloved restaurant and community space is now available to become the turnkey hub for your enterprise! While the business - Harana Market - is not for sale, it has established this superb location as a draw for an enthusiastic patronage from close and afar. An inviting creek-side ambiance on an arterial road in the Rondout/Hudson Valley, with an average daily traffic count of 9,200 cars per day. 36 parking spaces, Rondout Creek and seasonal mountain views, inviting outdoor areas on a 2.6-acre parcel. This property offers 3,500 sq ft across two buildings. The eye-catching gambrel barn-style building, constructed in 2004 and with many recent updates, extends 2,500 sq ft across two floors. 1,500 sq ft main restaurant/retail space with inviting guest space, open kitchen, two ADA compliant restrooms, a locker room with shower, dish and prep areas, walk-in cooler, cleaning and utility closets. An added 1,000 sq ft on the second floor with new oak hardwood floors, offering staff/conference rooms and office space. Central air/heat, instant hot water with water softener and UV light treatment system. There is a multi-tank commercial septic system, including a grease trap, in place. Serve your guests from a modern commercial kitchen laid out to offer flexibility for both fast-casual and full service with an open design that can be partially shielded. The kitchen is equipped with a six-burner CPG range, an EconAir 12-foot hood with a Makeup Air unit and suppression system ensuring optimal ventilation and safety. Accommodating ovens, indoor grill, fryers, and other essential appliances such as multiple refrigerators and freezers, a walk-in cooler, and more. Hardwired internet/power for POS system and electrical and plumbing upgrades were made to streamline a high-volume workflow. Indoor occupancy of 50 guests for sit-down service and up to 100 including take-out and fast casual service with outdoor seating. The second building, finished in 2010, is a 1,000 sq ft one-level annex with a large open room, storage spaces, an ADA compliant restroom, granite kitchen counters, two sinks, on-demand hot water, concrete and terra cotta floors. This flex space is suitable for many commercial uses and could also be converted into a residence with creek views. In business-nurturing neighborhood of popular destinations such as Arrowood Brewery, Westwind Orchard, Inness Resort and Golf Course, Starlite Motel, Saunderskill and Kelder Farms, BjornQorn and Skate Time, Helena's Pierogies, Stone House Tavern, and the Accord Market. In addition to these neighborhood highlights, the location benefits from proximity to world-renowned, all-season tourist attractions: The Mohonk Preserve, Minnewaska State Park, and the Catskill Mountains. This is your opportunity to be part of and contribute to this vibrant community!

Listing snapshot

Days on site
59 days
Listed on MLS
Apr 14, 2026
Annual property tax (MLS)
$8,246.31
Tax year
2025
Listing brokerage
Halter Associates Realty Inc
MLS ID
KEY985224
Last updated
Sep 18, 2026

General features

Property type
Mixed Use
Year built
2004
Stories
2
Total parking
0.36
Parking
Parking Lot
Water source
Well
Sewer
Septic Tank
Utilities
Cable Connected

Interior features

Heating
Forced Air, Propane
Cooling
Central Air
Appliances
Convection Oven, Exhaust Fan, Freezer, Gas Range, Refrigerator, Tankless Water Heater
Flooring
Concrete, Hardwood, Tile

Exterior features

Construction materials
Frame, Wood Siding

Recent activity

  1. Listing updated from MLS
  2. First seen on this site
  3. MLS status changed

Location

Rochester · Ulster County, NY 12404Show interactive map
5125 Route 209

Rochester · Ulster County, NY 12404

Google Maps directions

Listing data is supplied by the MLS and may change without notice.