Public Remarks: Gorgeous 4 bed, 3 bath, 2 car attached single family residence. Massive entry way, vaulted ceilings, open floor plan, huge lot - backyard, new covered deck, New siding, new roof being put on, new paint, new floors, new fixtures, beautiful wood fireplace, great location, Gun Barrel Estates has tennis courts, Volleyball, basketball, park, great hiking trail, biking trail, close to creek. Quiet, mature location, Niwot high school, move in ready!
Single-familyProperty Type
1977Year Built
0.27 acresLot Size
$291Est. Price/Sq.Ft.
2 car garageParking
Listed by Duane Penny• Coldwell Banker Realty-Lgmt
Satellite Avail, High Speed Internet, Eat-in Kitchen
Laundry Features: Lower Level
Room Information
Basement: Unfinished
Exterior
Exterior Features
Fencing: Fenced, Wood
Patio and Porch Features: Deck
Roof: Slate
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level
Road Frontage Type: City Street
Zoning: SR
Property Information
Property Type: Residential
Waterfront: No
Subdivision Information
Subdivision Name: Gunbarrel Estates
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 1595
Below Grade Finished Area: 1153
Building Area Total: 1595
Construction Materials: Wood/Frame, Brick/Brick Veneer, Vinyl Siding
Financial
Tax Information
Parcel Number: R0055433
Tax Annual Amount: 2939
Tax Year: 2017
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric
Gas: Natural Gas
Sewer: City Sewer
Location
HOA Information
Association: Yes
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Niwot
Middle or Junior School: Sunset Middle
High School: Niwot
Location Information
Directions: From 119 & 63rd St, drive South .28 mile to Lookout Rd / Turn left (East) drive 1.05 mile to N.71st / turn left (North) drive 250 ft. to Mt. Sherman Rd. / Turn right (East) drive .72 miles to home on left
Unparsed Address: 7475 Mount Sherman Rd Longmont CO 80503
Street Number: 7475
Street Name: Mount Sherman
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.17957,40.07921
Latitude: 40.07921
Longitude: -105.17957
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,245
Stories: —
Lot Size: 0.27 acres
Style: Single Family Residential
Year Built: 1977
Year Renovated: 1982
County: Boulder County
APN: R0055433
Home facts updated by county records on Sep 2, 2026
Other
Miscellaneous Information
Exclusions: seller's personal belongings
Listing Information
Attribution Contact: 3037727478
Close Price: $533,500
Photos Count: 35
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Tuesday, November 20, 2018
Cumulative Days on Market: 113
Days on Market: 113
Listing Contract Date: Tuesday, July 31, 2018
Modification Timestamp: Tuesday, July 30, 2024 10:18 PM
Home Information
Direction Faces: East
Levels: Tri-Level
Window Features: Bay Window(s)
Year Built: 1977
Around this home
Schools
Niwot Elementary School
Public PreK-5 • Assigned • 2.2mi
10/10
Sunset Middle School
Public 6-8 • Assigned • 5.5mi
6/10
Niwot High School
Public 9-12 • Assigned • 2.5mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
5/10 Fire Factor
6% chance of being in a wildfire in next 30 years
3/10 Heat Factor
7 days above 92° expected this year, 18 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Longmont, CO • 80503
Average low and high temperatures (°F)
43
18
52
26
64
37
64
39
71
46
83
56
88
61
86
59
81
53
69
43
55
31
53
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.5 hours in
June and 6 hours in December, placing it above the
U.S. average for solar exposure.
10.5 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$800,000 – $968,000
Reach more buyers when you sell with Redfin. Save up to $8,412 in fees.3 minutes to get started.