Mountain Homes Realty
Enter City, Zip or MLS
WaterfrontNew Listing

779 queens highway

Rochester, NY 12404

$5,200,000

4 BEDS 6 BATHS
3,279 SQFT17.45 AC LOT
Residential - Single Family
WaterfrontNew Listing
Image 1
Image 2
Image 3
Image 4
Bedrooms 4
Total Baths 6
Full Baths 5
Square Feet 3279
Acreage 17.46
Status Active
MLS # 1026149
County Ulster
More Info
Category Residential - Single Family
Status Active
Square Feet 3279
Acreage 17.46
MLS # 1026149
County Ulster
Listed By: Listing Agent Emily Daniels
BHHS Nutshell Realty - (845) 687-2200
Set on 17 private acres with sweeping views across the Catskill and Shawangunk mountain ranges, The Outside-In House at Overlook is a place where architecture, landscape, history, and daily life come into alignment. Restored antique structures, distinctive outbuildings, gardens, ponds, pools, and gathering spaces reflect a simple guiding principle: every decision begins with the land. The home has evolved in response to its extraordinary setting. More than one hundred windows and glass doors frame changing light, weather, and distant ridgelines from nearly every room. Locally milled cherry floors, exposed wood, soapstone, limestone and bluestone create interiors that are warm, substantial, and deeply connected to their surroundings. At the heart of the home is a soaring two-story sun room centered around a heated saltwater pool. An expansive wall of windows fills the room with natural light while overlooking lush, layered gardens that unfold from the first blooms of spring through the final colors of autumn. In warmer months, open windows welcome fresh air and birdsong. As the seasons turn, the cast-iron Jøtul woodstove becomes a natural gathering place. The kitchen is generous in scale and function, with soapstone countertops, custom cabinetry, abundant storage, walk-in pantry, and a Bluestar six-burner range. As comfortable for breakfast as hosting a house full of guests, it is practical, timeless, and elegant. Four ensuite bedrooms include two spacious primary suites with panoramic views. The main-level suite opens to a bluestone terrace and includes a spa bath with natural stone finishes and a soaking tub. Upstairs, large casement windows frame mornings that often begin above a layer of mist settled across the creek valley, with an adjoining marble bath overlooking the mountains. The remaining bedrooms are complete suites, each with its own beautifully finished bath and mountain outlook. The two-bedroom guest house offers a fully independent residence, with its own kitchen, laundry, wood stove, and wide-open views. Designed with its own distinct character, it feels every bit as complete and considered as the main house. Life here unfolds well beyond the walls of the homes. The heated saltwater pool and its well-appointed pool house serve as the property's outdoor centerpiece. It is a place for unhurried afternoons under open sky, vibrant celebrations and intimate evenings alike. Complete with an entertaining kitchen, bath, laundry, and indoor and outdoor showers, the pool house makes it easy to spend the entire day outdoors. Nearby, a cedar hot tub offers a quiet place to unwind. A restored office, a separate studio, a bunkhouse, an oversized two-car garage, and a restored nineteenth-century plank barn provide spaces for work, creativity, gathering, and retreat, each with its own distinct purpose and character. The landscape has been tended with patience and care. Gardens give way to wildflower meadows. Mature trees create privacy, while stone walls quietly define the landscape. Meandering paths encourage wandering. At the pond's edge, more than one hundred hand-built steps rise through a historic stone wall. Beyond its beauty, the property has been engineered for dependable year-round living, with significant investment in mechanical systems and infrastructure. Private and deeply rooted in its setting, yet within easy reach of the Hudson Valley's most celebrated towns, acclaimed restaurants, farms, trails, and cultural destinations, The Outside-In House at Overlook offers something increasingly difficult to find. It is a place to retreat from the pace of everyday life, gather generations, and enjoy complete privacy, refined living, and an enduring relationship with one of the region's most breathtaking landscapes. The opportunity to call a place like this home is exceptionally rare. Additional visual media and property information are available upon request.
Location not available
Listing
Street
Satellite

Exterior Features

  • Style Modern
  • Construction Single Family Residence
  • Siding Stone, Wood Siding
  • Garage Yes
  • Garage Description Driveway, Garage
  • Water Well
  • Sewer Septic Tank
  • Lot Description Garden, Landscaped, Part Wooded, Stone/Brick Wall, Views

Interior Features

  • Appliances Dishwasher, Dryer, Gas Range, Refrigerator, Stainless Steel Appliance(s), Tankless Water Heater, Washer, Water Purifier Owned, Water Softener Owned
  • Heating Baseboard, Electric, Forced Air, Heat Pump, Radiant
  • Cooling Central Air, Ductless, Electric
  • Basement Finished, Full
  • Fireplaces 5
  • Fireplaces Description Family Room, Living Room, Wood Burning, Wood Burning Stove
  • Living Area 3,279 SQFT
  • Year Built 1987

Neighborhood & Schools

  • School Disrict Rondout Valley
  • Elementary School Kerhonkson Elementary School
  • Middle School Rondout Valley Junior High School
  • High School Rondout Valley High School

Financial Information

  • Parcel ID 4400-068.001-0002-086.000-0000

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of BHHS Nutshell Realty - (845) 687-2200
Listings courtesy of the One Key MLS as distributed by MLS GRID.

IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interestedin 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 as of 07/26/2026 03:23:47 UTC. 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.

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 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: DMCAnotice@MLSGrid.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 One Key MLS, Inc.
Listing data is current as of 07/26/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.