Move-in ready and meticulously maintained, this charming 3-bedroom, 2.5-bath ranch is perfect for first-time buyers or those looking to downsize! Enjoy one-level living with a spacious layout that includes a bright Adirondack room, formal dining room, and galley-style kitchen with modern finishes. The home features two cozy gas stoves, central air, and a full, dry basement with an additional full bathroom and bonus space—ideal for hobbies, storage, or future expansion. Set on over half an acre, the property offers a private backyard, deck, sprinkler system, and an oversized garage with convenient driveway access. Situated on a corner lot in a desirable location, this home is priced to sell and ready for its next chapter—schedule your showing today!
Pending
$339,900
510 Upper Sherman Avenue, Queensbury, NY 12804
3beds
1,196sqft
Single Family Residence, Residential
Built in 1997
0.52 Acres Lot
$-- Zestimate®
$284/sqft
$-- HOA
What's special
Modern finishesPrivate backyardCentral airBonus spaceFull dry basementBright adirondack roomCozy gas stoves
- 19 days
- on Zillow |
- 742 |
- 47 |
Zillow last checked: 7 hours ago
Listing updated: July 25, 2025 at 11:52am
Listing by:
eXp Realty 888-276-0630,
Angela Cugini-Girard 518-232-1460
Source: Global MLS,MLS#: 202522261

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: First
Half bathroom
- Level: First
Full bathroom
- Level: First
Full bathroom
- Level: Basement
Basement
- Level: Basement
Dining room
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Sun room
- Level: First
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Oven
- Laundry: Main Level, Washer Hookup
Features
- Flooring: Carpet, Laminate
- Windows: Skylight(s), Blinds
- Basement: Finished,Full
- Number of fireplaces: 2
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 1,196
- Total interior livable area: 1,196 sqft
- Finished area above ground: 1,196
- Finished area below ground: 0
Property
Parking
- Total spaces: 6
- Parking features: Paved, Attached, Driveway
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck
- Fencing: Back Yard,Fenced
Lot
- Size: 0.52 Acres
- Features: Road Frontage, Sprinklers In Front, Sprinklers In Rear, Landscaped
Details
- Parcel number: 308.8114
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Drywall, Vinyl Siding
- Roof: Shingle,Asphalt
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Queensbury
Financial & listing details
- Price per square foot: $284/sqft
- Tax assessed value: $178,200
- Annual tax amount: $4,851
- Date on market: 7/23/2025
- Loading