Mountain Homes Realty
Enter City, Zip or MLS

7458 mount sherman road

Longmont, CO 80503

$947,000

4 BEDS 3 BATHS
2,927 SQFT
Residential - Single Family
New Listing
Image 1
Image 2
Image 3
Image 4
Bedrooms 4
Total Baths 3
Full Baths 1
Square Feet 2927
Status Active
MLS # IR1063648
County Boulder
More Info
Category Residential - Single Family
Status Active
Square Feet 2927
MLS # IR1063648
County Boulder
Listed By: Listing Agent Martin Sugg
WK Real Estate - (303) 588-9441
Welcome to this this lovely four-level home in desirable Gunbarrel Estates. Don't let the Longmont zip code fool you! Gunbarrel Estates is right next to the city limits of Boulder. This bright, cheerful home backs directly to Boulder County Open Space and its extensive trail system that connects Boulder, Niwot and Longmont. A custom mosaic-tile entry leads into a freshly painted living area with laminate hardwood flooring and high vaulted ceilings. The kitchen and formal dining areas look down into the tranquility of a substantial 336 sqft sunroom/greenhouse with hot tub and large windows looking into the back yard and out into the open space beyond. A photo-voltaic solar array, which also provides hot water, is fully owned by the Seller, helping to maintain low electrical bills and, along with the sunroom and xeriscaped front yard, a commitment to sustainable living. An updated kitchen has plenty of space for cooking and socializing, featuring new soft-close cabinets, quartz counters, subway tile, a gas stove and breakfast bar. The laminate hardwood flooring continues from the main level throughout the entire home. The private primary bedroom upstairs has a walk-in closet, a three-quarter bath, and is separated down a hallway from three secondary bedrooms. A half-flight down from the kitchen is a large family room with a wood-burning stove, a wet bar and full walk-out access to the backyard with its shaded flagstone patio area and sliding glass door access to the three-season sunroom. The back yard has plenty of privacy, with mature trees, landscaping, and a birdhouse that is home to American Kestrels and other native bird species. Downstairs, the fourth level is a carpeted basement, perfect as a game room or private get-away. Gunbarrel Estates Park is only a short walk and Gunbarrel's restaurants and grocery shopping are only a 5 minute drive. Enjoy the benefits of country living next to open space just minutes to the communities of Boulder, Niwot and Longmont.
Location not available
Listing
Street
Satellite

Exterior Features

  • Construction Single Family Residence
  • Siding Brick, Frame, Wood Siding
  • Exterior Spa/Hot Tub
  • Roof Composition
  • Garage No
  • Water Public
  • Sewer Public Sewer
  • Lot Description Level, Open Space, Sprinklers In Front

Interior Features

  • Appliances Dishwasher, Disposal, Microwave, Oven, Refrigerator, Solar Hot Water
  • Heating Forced Air
  • Cooling Evaporative Cooling
  • Fireplaces Description Family Room, Insert
  • Living Area 2,927 SQFT
  • Year Built 1976

Neighborhood & Schools

  • Subdivision Gunbarrel Estates
  • Elementary School Niwot
  • Middle School Sunset
  • High School Niwot

Financial Information

  • Parcel ID R0055404
  • Zoning SFR

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of WK Real Estate - (303) 588-9441
Listings courtesy of the RE Colorado MLS as distributed by MLS GRID.

IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interestedin purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 07/10/2026 04:32:54 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 RE Colorado MLS, Inc.
Listing data is current as of 07/10/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.