Redfin is joining Rocket

Discover how we're simplifying your journey home.

$339,900

510 Upper Sherman Ave Queensbury, NY 12804

3 beds
2 full, 1 partial
1,196 sqft
0.5 acres
$284 / sqft
House

Property details

About 510 Upper Sherman Ave

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!

Highlights

Home typeSingle Family Residence
HeatingForced Air, Natural Gas
StatusSale Pending
(Pending)
CoolingCentral Air
Size1,196 sqft
BasementYes
Lot size0.52 Acres
Year built1997
ParkingPaved, Attached, Driveway
MLS #202522261
Attached garage2 spaces
FireplaceGas, Living Room

Summary

  • Partial Bathrooms: 1
  • Full Bathrooms: 2
  • Appliances: Dishwasher, Dryer, Oven
  • Basement: Yes
  • Flooring Type: Carpet, Laminate
  • Fireplace: Gas, Living Room
  • Total Bedroom Count: 3
  • Garage Space: 2 spaces
  • Attached Garage: Yes
  • Parking: Paved, Attached, Driveway
  • Exterior: Back Fence, Fence, Deck, Paved Driveway
  • Architectural Style: Ranch
  • Heating: Forced Air, Natural Gas
  • Cooling: Central Air
  • List Price: $339,900
  • Price/SqFt: $284
  • Annual Tax Amount: $1,106
  • Tax Year: 2023
  • Lot: Sprinklers In Front, Sprinklers In Rear, Landscaped
  • Directions: West on Sherman Avenue, corner of Sherman and Kylians Way. Garage faces Sherman; front of house faces Kylians Way.
  • Year Built: 1997
  • Living Area: 1,196 SqFt
  • Lot Size: 0.52 Acres
  • MLS Number: 202522261
  • MLS Name: Global MLS
  • Office Name: eXp Realty
  • Office Phone: (888) 276-0630
  • Office Email: ny.broker@exprealty.net
  • Listing Agent: Angela Cugini-Girard

IDX The data relating to real estate on this website comes in part from the Internet Data Exchange program of the Global MLS (GMLS). All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.

Copyright © 2025 Global Multiple Listing Service, Inc. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/30/2025, 8:40:33 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Price information

Property sales

We're sorry, we currently don't have property sales data for this listing.

Tax history

YearAssessmentProperty Tax
2023$189,400$1,106
2022$189,400$1,106
2021$189,400$1,106

History based on county public records data.

Nearby schools

9

Kensington Road School

Public District KG-4

1.7 mi

43 Kensington Rd

5

Queensbury Elementary School

Public District KG-3

1.8 mi

431 Aviation Rd

6

William H Barton Intermediate School

Public District 4-5

1.9 mi

425 Aviation Rd

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $55,242. The most common annual income of people living in Queensbury, NY is between $35k-100k. The majority of families are single, no kids. The most common level of education of people living in this area is high school diploma.

How much money do the neighbors make?

37%
<35k
48%
35k-100k
15%
100k-200k
0%
200k+

What level of education do the neighbors have?

No High School
High School Diploma
Post Secondary Degree
Masters Degree

What types of families live nearby?

40%
Single, No Kids
17%
Single, with Kids
25%
Married, No Kids
18%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

16%
<11 yrs old
7%
12-17 yrs old
21%
18-34 yrs old
40%
35-64 yrs old
16%
65+ yrs old

What do the neighbors do for fun?

  • Pro BoxingPro Boxing
  • NHRA Drag RacingNHRA Drag Racing
  • Horse RacesHorse Races

Where do the neighbors shop?

  • Family DollarFamily Dollar
  • Big LotsBig Lots
  • Stein MartStein Mart

Where do the neighbors go to eat?

  • White CastleWhite Castle
  • Golden CorralGolden Corral
  • LongHorn SteakhouseLongHorn Steakhouse

What do the neighbors drive?

  • ChevroletChevrolet
  • KiaKia
  • BuickBuick

What do the neighbors listen to?

  • RockRock
  • Adult StandardsAdult Standards
  • Contemporary InspirationalContemporary Inspirational
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

About 510 Upper Sherman Ave

The listing price of 510 Upper Sherman Ave property is $339,900.

The property 510 Upper Sherman Ave is a house located in Queensbury, New York, 12804.

Sale Pending: 510 Upper Sherman Ave is Sale Pending (Pending), which means that the seller has accepted an offer but the sale is not finalized.

The nearby schools for 510 Upper Sherman Ave are: Kensington Road School (GreatSchools Rating 9/10), Queensbury Elementary School (GreatSchools Rating 5/10), William H Barton Intermediate School (GreatSchools Rating 6/10), Queensbury Middle School (GreatSchools Rating 6/10), Glens Falls Middle School (GreatSchools Rating 6/10), Oliver W Winch Middle School (GreatSchools Rating 4/10), Queensbury Senior High School (GreatSchools Rating 6/10), Glens Falls Senior High School (GreatSchools Rating 5/10), South Glens Falls Senior High School (GreatSchools Rating 5/10).

According to the records, the last property tax for 2023 is $1,106 (source: MLS/based on county public records data).

The property at 510 Upper Sherman Ave has 3 bedrooms and 2 full and 1 half bathrooms.

The property 510 Upper Sherman Ave is 1,196 SqFt (source: MLS/tax record).

The year of construction for 510 Upper Sherman Ave is 1997.

This home is located at 510 Upper Sherman Ave in Queensbury, NY and zip code 12804. This 1,196 square foot home, which was built in 1997, sits on a 0.52 acre lot. Features: 3 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since July 23, 2025 and is currently priced at $339,900.

Over 14 listings were sold over their listed price in June 2025 in Queensbury, NY. In the same period over 8 listings were sold below the listed price and 7 listings were sold for the listed price. In June 2025 in Queensbury, NY there were 4.7% less homes for sale than in May. The median list price of listings available in June 2025 was $382,250, while the average time on the real estate market was 13 days.

From Rocket Homes Real Estate and based on county public records data.

More resources