Public Remarks: Dream location backing to LOBO Trail! Open the fence gate and head to Boulder, Niwot or Longmont by foot or two-wheels. This updated Gunbarrel Estates gem is move-in ready. Four upper beds, a private primary suite, remodeled kitchen and baths, a finished basement, fireplace and hardwood floors make this home complete. The layout is perfect to work from home with a light-filled large main floor office, and the basement is finished with a full bath, non-conforming bedroom and custom built-in cabinetry. The professionally designed backyard is a dream with a stamped concrete patio, custom bolder outdoor fire feature, sun-shades and an Endless Pool! Love Where You Live.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
10,620 Sq. Ft.
Year renovated
2005
Sq. Ft.
2,995
Year built
1976
Style
Single Family Residential
County
Boulder County
APN
R0055400
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
SR
Suburban Residential District
Low density suburban residential areas.
Permitted uses
Include but are not limited to:
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Infrastructure
Bed & breakfast
Educational/school
Fire house
Communications tower
Park & open space
Property details
Parking
Parking Features
Covered Spaces: 2
Garage: Yes
Attached Garage: Yes
Garage Spaces: 2
Interior
Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 1
Bathrooms (Three Quarter): 1
Bedroom Information
Bedrooms Total: 5
Heating & Cooling
Cooling: Yes
Central Air, Ceiling Fan(s), Whole House Fan
Heating: Yes
Forced Air, Humidity Control
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer
Fireplace: Yes
Fireplace Features: Gas, Living Room
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Separate Dining Room, Wet Bar, Kitchen Island
Laundry Features: Main Level
Room Information
Basement: Full
Exterior
Exterior Features
Hot Tub Included
Fencing: Fenced, Wood
Patio and Porch Features: Patio
Roof: Composition
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System, Abuts Public Open Space
Other Structures: Storage
Road Frontage Type: City Street
Zoning: SR
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Gunbarrel Estates
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 2102
Below Grade Finished Area: 1455
Building Area Total: 2102
Construction Materials: Brick/Brick Veneer
Financial
Tax Information
Parcel Number: R0055400
Tax Annual Amount: 4397
Tax Year: 2020
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,Xcel
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
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 the Diagonal Hwy, 63rd Street to Lookout Road. East on Lookout to N 71st. North to Mount Sherman Road. Follow Mount Sherman to the property.
Unparsed Address: 7474 Mount Sherman Rd Longmont CO 80503
Street Number: 7474
Street Name: Mount Sherman
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.17891,40.07919
Latitude: 40.07919
Longitude: -105.17891
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 2,995
Stories: —
Lot Size: 10,620 square feet
Style: Single Family Residential
Year Built: 1976
Year Renovated: 2005
County: Boulder County
APN: R0055400
Home facts updated by county records on Sep 2, 2026
Other
Listing Information
Attribution Contact: 3034890755
Close Price: $880,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Monday, May 10, 2021
Cumulative Days on Market: 19
Days on Market: 19
Listing Contract Date: Thursday, April 22, 2021
Modification Timestamp: Thursday, August 1, 2024 10:09 AM
Home Information
Levels: Two
Window Features: Window Coverings, Bay Window(s)
Year Built: 1976
Green Information
Green Energy Efficient: HVAC
Around this home
Schools
K - 12
Preschool & daycare
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, 19 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°
90°
62°
86°
59°
78°
52°
66°
41°
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
$1.02M – $1.23M
Reach more buyers when you sell with Redfin. Save up to $10,686 in fees.3 minutes to get started.