Queensbury, NY 12804 · Warren County

This four-bedroom, two-and-a-half-bath home on just over an acre in Queensbury's Rolling Ridge neighborhood offers more than 3,300 square feet of living space built in 1976 and updated over time. The residence features hardwood floors, extensive crown molding, a kitchen with premium appliances, a primary suite with en suite bath and sitting area, and a finished basement. Outdoor amenities include an in-ground pool, stone walls, mature landscaping with gardens and fountains, a recently completed covered patio with stone outdoor kitchen and Trex decking, and a circular driveway. Additional systems include geothermal heating and cooling, a whole-home generator, two-car garage with epoxy flooring, and high-speed internet. Located in the Queensbury school district, the property is minutes from lakes and mountains while maintaining suburban convenience.
Welcome to timeless elegance. A rare opportunity in Rolling Ridge, this distinctive French Provincial residence combines timeless craftsmanship, extraordinary outdoor spaces and a warmth that makes its impressive scale feel immediately inviting. Custom built for its original owners by Bob Ruggles, the home offers more than 3,300 square feet of beautifully detailed living space, plus approximately 700 square feet of partially finished lower level. Inside, hardwood floors and extensive crown molding set a refined tone throughout. The partially updated kitchen features a Wolf cooktop and Sub-Zero refrigerator, while the spacious primary suite has been thoughtfully updated with a beautiful en suite bath and adjoining library/sitting area. Outside is where this property becomes truly exceptional. Meticulously cultivated gardens surround the home with ornamental trees, mature shrubs, fountains and intimate sitting areas creating something new to discover around every corner. The private backyard is anchored by a beautiful gunite pool and defined by a handsome stone wall. A recently completed covered patio by Witt Construction elevates the outdoor living experience with Trex decking and a stunning masonry stone outdoor kitchen, creating an incredible setting for summer entertainment. A bomanite circular driveway provides an impressive approach, while geothermal HVAC, a whole-home generator, garage with epoxy flooring and a convenient mudroom/laundry add substance to the beauty. A sauna in the lower level may also be negotiable. Elegant without feeling formal, grand without sacrificing comfort; this is a home that has been meticulously cared for, thoughtfully improved and surrounded by grounds that simply cannot be recreated overnight. 27 Sheraton Ln South, a spectacular place to call home.
The price signals we can read on this listing today. For a true sense of value against recent Queensbury sales, Sharon will pull the comparable closings and walk you through them.
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the comps25 facts pulled straight from the MLS listing.
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
Try a preset
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
Queensbury is in Warren County, NY. There are currently 96 active listings here, ranging from $10,000 to $6,349,000. Listings in this address fall under the Queensbury school district. Priced 96% above the Queensbury median of $498,950.
See Sharon's Queensbury community guideSharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Howard Hanna Capital Inc · Listed by Sean Rogge (war.roggse)
Contact: 518-307-8492
MLS #202624937 · Source: Global MLS, Inc.
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, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
Every change captured by Global MLS since this listing went live.
Real numbers from current MLS data. Not a third-party estimate.