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 30 out of 150
$1,400,000 For Sale

11 Sparkling Ridge Road
New Paltz, NY 12561

4 beds, 3 full, 1 partial baths | Single Family Home
3,015 sq ft; lot: 3.21 acres - MLS# 20190346
Property Photo


“LYRICAL LAKE” – Absolutely extraordinary waterfront living at the base of the magnificent Shawangunk Ridge, a world-class rock-climbing destination. Masterfully built and custom designed, this singular residence is perfectly perched and overlooks a 25' deep aerated sparkling lake joyously reflecting the dancing sunlight and passing clouds. You can swim, fish, kayak and canoe literally steps from your door! The distinctive architecture perfectly augments the soothing natural landscape with its sensitive use of hand laid native stone and brawny woodwork. The generously proportioned interior superbly accommodates casual country living and easy entertaining of family and friends. Expansive walls of windows wash the living space in natural light and offer magical water vistas from every room. The open plan living level, warmed by a cozy gas fireplace, features a quality equipped gourmet kitchen with high end appliances and amazing sculpted custom cabinetry. It's the perfect venue for farm-to-table cookery from the many local farm markets. Beautiful radiant heated wood and ceramic tile floors throughout keep it toasty in winter and central AC helps beat the summer heat. The four lofty and generous bedrooms include two ensuites, one encompassing the entire 3rd level and featuring a soothing steam shower and a private screened porch overlooking the lake. If you're a rock climber or want to learn, don't miss the 3 story, 4-sided climbing wall with belay system that rises through the center of the house. So convenient! Seamless access to a multitude of inviting outdoor living spaces provides additional opportunity to enjoy fine lakeside living from screened porches, decks and a water's edge patio with firepit. Imagine the star gazing possibilities! This truly singular offering has been meticulously maintained and presents a rare opportunity for luxurious waterfront living in a premier location just minutes to vibrant New Platz village, a myriad of cultural venues, fine dining, the magnificent Mohonk Preserve and under 2 hours to NYC Metro area.


  • Property Type: Single Family Home
  • Sub Type: Single Family
  • Listing Status: Active
  • County/Area: Ulster County
  • Zip Code: 12561
  • Year Built: 2006
  • Age: 11-20
  • Subdivision/Neighborhood: Sparklingridge
  • School District: New Paltz Schools
  • Elementary School: Duzine K-2
  • Sq.Ft.: 3,015 sq ft
  • Style: Contempo
  • Total Rooms: 8
  • Bedrooms: 4
  • Full Baths: 3
  • Half Baths: 1
  • Basement: Slab
  • Fireplace: Free Standing, Living Room
  • Lot Size: 3.21 acres
  • Baths: 4
  • View: Water
  • Waterfront: Lake
  • Zoning: Res SP1
  • Area: Gardiner
  • Appliances: Dishwasher, Dryer, Exhaust Fan, Microwave, Range, Range Hood, Refrigerator, Washer, Water Softener
  • Attic: Storage
  • Bedroom 1 Level: 2
  • Bedroom 1 Room Size: 17x11.6
  • Bedroom 2 Level: L
  • Bedroom 2 Room Size: 17x11.2
  • Bedroom 3 Level: L
  • Bedroom 3 Room Size: 17x13
  • Bedroom 4 Level: L
  • Bedroom 4 Room Size: 13.2x13
  • Building Style: Contempo
  • Color: Tan, Stone, Brown
  • Construction: Frame/Stick
  • Cooling/Air Conditioning: Ceiling Fan, Central
  • Dining Room Level: 1
  • Dining Room Room Size: 18.4x13.8
  • Driveway: Dirt
  • Electricity: 200 Amps
  • Exterior Features: Outside Lighting, Screened Porch
  • Floors: Ceramic, Concrete, Hardwood, Radiant
  • Garage/Parking Extras: Driveway-Shared
  • Heat Source: Radiant
  • Heating Fuel: Propane
  • Interior Features: Insulated Doors, Storm Windows, Insulated Windows, Skylights, 9 Ft. Ceilings, Master Bath, French Doors, Gas Stove Connection, Washer Connection, Gas Dryer Connection, Sauna/Steam Room, Smoke Detector, Carbon Monoxide Detector
  • Internet Access: Cable
  • Kitchen Description: Custom Cabinets, Cabinets Wood, Gourmet, Pantry, Gourmet
  • Kitchen Level: 1
  • Kitchen Room Size: 14.5x11.2
  • Living Room Level: 1
  • Living Room Room Size: 22x17.4
  • Lot Block Address: 42.220,1,11 Sparkling Ridge Road
  • Lot Dimensions: 3.21 acres
  • Lot Features: Private, Rock Outcrop, Wooded, Water Frontage
  • Lot/Site: Rural
  • Miscellaneous Features: Ceiling-Cathedral, French Doors, Security System
  • Other 1 Level: L
  • Other 1 Room Size: 13.5x12
  • Other Rooms: Utility Room
  • Plumbing: Mixed
  • Porch: Deck, Enclosed Porch, Patio, Screened Porch
  • Roof: Metal
  • Sewer: Septic-Ingr.
  • Siding: Stone, Wood, Hardiplank
  • Sqft 1st: 1116
  • Sqft 2nd: 555
  • Utility Level: L
  • Utility Room Size: 10.9x6.6
  • Water: Drilled Well
Courtesy of Bhhs Hudson Valley Prop-Np
Helen Coyle Bergstein
Nest Realty Co.
114 Plains Road, New Paltz, NY 12561
(845) 417-7242 Mobile

More About Me


Hi Helen,
Thank you so much for making the house buying experience fun, magical and seamless! 
Aileen - Woodstock
Dear Helen,
Thank you so much for working your magic and being our guide on this fabulous journey! It's been such a joyous and smooth process, in no small part because of your positive energy and hard work. Wishing you all the best,

Gabriela and Daniel - Kingston
View All

Connect With Me

Contact Me

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