Register Now
Already registered? Login

Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

Quick Search

view all



No Min.

No Max.

Helen Coyle Bergstein

Helen Coyle Bergstein
Nest Realty Co.
New Paltz, NY 12561

Contact Me

Contact Me

* fields are required
Back to Saved Search
Listing 7 out of 57
$825,000 Fully Executed Contract

118 Sparkling Ridge Road
New Paltz, NY 12561

3 beds, 3 full, 1 partial baths | Single Family Home
2,681 sq ft; lot: 4.7 acres - MLS# 20184825
Property Photo


Surrounded by Mohonk Preserve lands, this mid-century beauty possesses the spirit of Frank Lloyd Wright with its tranquil blend of wood, stone and glass. Along with the privacy and tranquil calm of a rushing stream and swimming pond below, there is such a sense of drama created by the Gunks' white cliffs backdrop, visible as you drive in and just a short hike away. Once inside the marble tiled entry, the home's open floor plan welcomes you to the world of light and nature with shimmering views of trees, cliffs and water from all directions. The striking two story stone fireplace brings a natural element to the inside creating balance and connection between the two living levels as well as with nature. Truly a living space that brings the outside in, you will enjoy the peace and serenity both inside and out. Take in the sounds of the rushing stream while enjoying coffee or cocktails from the curved deck tucked behind the house, or watch the wildlife at the pond while sunbathing on the lower deck. Although the flow of the home is open plan, there is still good separation between sleeping and living areas so you will never feel cramped or "on top of each other". In addition to the 3 Bedrooms and Den, there are 3.5 bathrooms, an attached garage PLUS a detached 2 car garage that could be great studio space or a future guest house. The kitchen is well equipped with Thermador and Sub-Zero appliances - a pleasure to cook in. Owners purchased additional acreage to ensure privacy for years to come and although under 5 acres total, this property enjoys the status of adjoining forever wild preserve land. Under 2 hours to NYC and 10 minutes to New Paltz, you can enjoy whatever your Hudson Valley pleasure may be - Rail Trail, Climbing, Hiking, Skydiving, Kayaking, Wineries, Orchards, Breweries, Spa at Mohonk, Shopping and restaurants nearby. Currently making money on AirBNB with a local host, you too could continue to rent when not using the house.


  • Property Type: Single Family Home
  • Sub Type: Single Family
  • Listing Status: Fully Executed Contract
  • County/Area: Ulster County
  • Zip Code: 12561
  • Year Built: 1966
  • Age: 41-60
  • School District: New Paltz Schools
  • Sq.Ft.: 2,681 sq ft
  • Style: Contempo
  • Bedrooms: 3
  • Full Baths: 3
  • Half Baths: 1
  • Basement: Finished, Full, Walk Out
  • Garage: 3-Car, Garage Detached
  • # of Parking Spaces: 3
  • Fireplace: Stone, Family Room, Living Room
  • Lot Size: 4.7 acres
  • Baths: 4
  • View: Mountain, Water
  • Waterfront: Pond, Stream
  • Zoning: SP-1
  • Area: Gardiner
  • Appliances: Dishwasher, Dryer, Range, Refrigerator, Washer
  • Bedroom 1 Level: 1
  • Bedroom 1 Room Size: 17x15'7"
  • Bedroom 2 Level: 1
  • Bedroom 2 Room Size: 15x13
  • Bedroom 3 Level: L
  • Bedroom 3 Room Size: 15x14'9"
  • Building Style: Mid Century Modern
  • Condition: Very Good
  • Den Level: L
  • Den Room Size: 12'2"x11
  • Dining Room Level: 1
  • Dining Room Room Size: 20x11'3"
  • Electricity: 200 Amps
  • Exterior Features: Balcony, Outside Lighting
  • Family Room Level: L
  • Family Room Room Size: 26x15
  • Floors: Ceramic, Hardwood
  • Heat Source: Baseboard
  • Heating Fuel: Electric
  • Hot Water: Electric
  • Interior Features: Master Bath, Sliding Glass Doors, Gas Stove Connection, Whirlpool Tub
  • Kitchen Description: Island
  • Kitchen Level: 1
  • Kitchen Room Size: 12'8'x10'8'
  • Living Room Level: 1
  • Living Room Room Size: 18x13
  • Lot Block Address: 16,1,118 Sparkling Ridge
  • Lot Dimensions: 4.81
  • Lot Features: Adjacent To State Land, Private
  • Lot/Site: Rural
  • Porch: Deck, Open, Patio
  • Sewer: Septic-Ingr.
  • Siding: Wood
  • Sqft 1st: 1536
  • Utility Level: L
  • Water: Drilled Well
Courtesy of Coldwell Banker Village Green
Helen Coyle Bergstein
Nest Realty Co.
114 Plains Road, New Paltz, NY 12561
(845) 417-7242 Mobile

More About Me


Helen knows the area thoroughly and showed us a number of properties in New Paltz. She was extremely patient as we decided to not pursue a few, often after multiple visits. Then, for the property we bought, she called us minutes after it became listed, got us the first showing, and we made an offer that was accepted. The house was not shown to any other parties and we had a signed contract and closed quickly. Through every step, including about the mortgage application, we received excellent guidance. Helen really came through for us and we now have a house we are truly happy with. Allen Ross
A joy to work with. Really not what I had come to expect. Straightforward, an advocate, not treating my small sale as anything lesser. I hope I have the opportunity to work with her again. I will definitely pass her name along! Itty - New Paltz
View All

Connect With Me

Contact Me

* fields are required
Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu