Public Remarks: Sip your morning coffee from the spacious deck and enjoy the fabulous breathtaking views of longs peak and the frontrange. More mountain views from the kitchen windows and the family room while the fireplace glows. Huge master bedroom with 5 piece master bath. Seperate dining room with bay windows. 3 bedrooms with additional spacious loft area, vaulted ceiling & tile entry. Additional 2 other bay windows creating lots of light. Call Jim or Linda Hess for more Info @ 303-684-7747.
*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
Permits
Beds
4
Baths
2.5
Stories
—
Lot width
—
Lot depth
—
Lot size
0.27 Acres
Year renovated
1991
Sq. Ft.
2,173
Year built
1991
Style
Single Family Residential
County
Boulder County
APN
R0108953
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
R-SF
Residential Single-Family District
The purpose of the R-SF district is to establish and preserve residential neighborhoods with primarily single-family detached dwellings on medium to larger lots. The district is intended to be located in proximity to activity centers and other public amenities or complementary uses and activities such as schools, parks, and open space.
Permitted uses
Include but are not limited to:
Housing-Single unit
Infrastructure
Public service
Communications tower
Park & open space
Oct 22, 2025 • Final
Combo permit - residential
Remodel
Aug 22, 2018 • Final
Combo permit - residential
Remove and replace the existing water heater with a new unit.
Plumbing
Water heater
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Features
Covered Spaces: 2
Garage: Yes
Attached Garage: Yes
Garage Spaces: 2
Parking Features: Garage Door Opener
Interior
Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 3
Heating & Cooling
Cooling: Yes
Central Air, Ceiling Fan(s)
Heating: Yes
Forced Air, Humidity Control
Interior Features
Electric Range/Oven, Dishwasher, Refrigerator, Microwave
Lot Features: Curbs, Sidewalks, Lawn Sprinkler System
Road Frontage Type: City Street
Zoning: Res
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Stoney Ridge
MLS Area Major: Longmont
Building Information
Above Grade Finished Area: 2186
Below Grade Finished Area: 1195
Building Area Total: 2186
Construction Materials: Wood/Frame, Brick/Brick Veneer
Financial
Tax Information
Tax Annual Amount: 1835.42
Tax Year: 2000
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric,City
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
Association Fee: 0
Association Fee Frequency: Monthly
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: MEAD
Middle or Junior School: MEAD
High School: SKYLINE
Location Information
Directions: From Main St. E on 17th to Alpine, West on Sunlight, West on Redcloud to property on West Side.
Unparsed Address: 1851 Red Cloud Rd Longmont CO 80501
Street Number: 1851
Street Name: Red Cloud
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80501
Coordinates: -105.089124,40.191722
Latitude: 40.191722
Longitude: -105.089124
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,173
Stories: —
Lot Size: 0.27 acres
Style: Single Family Residential
Year Built: 1991
Year Renovated: 1991
County: Boulder County
APN: R0108953
Home facts updated by county records on Sep 2, 2026
Other
Listing Information
Attribution Contact: 3037729620
Close Price: $334,500
Photos Count: 4
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Monday, April 15, 2002
Cumulative Days on Market: 305
Days on Market: 305
Listing Contract Date: Friday, June 15, 2001
Modification Timestamp: Thursday, February 27, 2025 3:09 AM
Home Information
Levels: Two
Window Features: Window Coverings, Bay Window(s)
Year Built: 1991
Around this home
Schools
Alpine Elementary School
Public PreK-5 • Assigned • 0.2mi
5/10
Timberline Pk-8
Public PreK-8 • Assigned • 0.8mi
2/10
Skyline High School
Public 9-12 • Assigned • 0.8mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
A vibrant northern Colorado community known for its scenic mountain views, extensive parks and trails, greenways, and a mix of established neighborhoods and newer housing options.