Public Remarks: YOU WILL FALL IN LOVE WITH THIS CUSTOM HOME. LARGEST LOT IN STONEY RIDGE. (21796 SQFT) EVERYTHING TOP OF THE LINE. CEMENT TILE ROOF. SIX PANEL OAK DOORS. QUARTZ COUNTERS IN KITCHEN. CHORION COUNTERS IN BATH AND LANDRY. A MUST SEE.
Single-familyProperty Type
2000Year Built
0.49 acresLot Size
$199Est. Price/Sq.Ft.
3 car garageParking
Listed by • One-Fee Realty
Contact: 3034428474
Bought with Penny Johnston• RE/MAX Alliance-Boulder
*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
6
Baths
4.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.49 Acres
Year renovated
1999
Sq. Ft.
3,758
Year built
1999
Style
Single Family Residential
County
Boulder County
APN
R0108940
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
Apr 9, 2020 • Final
Combo permit - residential
Electrical
Oct 17, 2016 • Final
Combo permit - residential
Install a new air conditioning unit and replace the furnace.
HVAC
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: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Interior
Bathroom Information
Bathrooms (Full): 2
Bathrooms (Half): 1
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 3
Heating & Cooling
Cooling: Yes
Central Air
Heating: Yes
Forced Air
Interior Features
Fireplace: Yes
Fireplace Features: Gas, Gas Logs Included
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s)
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: Full, Unfinished
Exterior
Exterior Features
Lighting
Fencing: Wood
Patio and Porch Features: Patio, Deck
Roof: Tile, Other
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Curbs, Gutters, Sidewalks, Rolling Slope
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: 2168
Below Grade Finished Area: 2154
Building Area Total: 2168
Construction Materials: Brick/Brick Veneer, Stucco
Financial
Tax Information
Parcel Number: 693N263240040108940
Tax Annual Amount: 2313
Tax Year: 2000
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Electricity Available
Electric: Electric,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: LOMA LINDA
Middle or Junior School: LONGS PEAK
High School: LONGMONT
Location Information
Unparsed Address: 1870 Red Cloud Rd Longmont CO 80501
Street Number: 1870
Street Name: Red Cloud
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80501
Coordinates: -105.08872,40.192167
Latitude: 40.192167
Longitude: -105.08872
Public facts
Beds: 6
Baths: 4.5
Sq. Ft.: 3,758
Stories: 1.0
Lot Size: 0.49 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: 1999
County: Boulder County
APN: R0108940
Home facts updated by county records on Sep 2, 2026
Other
Documents & Disclosures
Documents Available: Survey Available,Builder Plans,Title Report Available,Legal Description Available
Documents Count: 4
Listing Information
Attribution Contact: 3034428474
Close Price: $399,000
Photos Count: 1
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Wednesday, May 29, 2002
Cumulative Days on Market: 97
Days on Market: 97
Listing Contract Date: Wednesday, January 30, 2002
Modification Timestamp: Thursday, February 27, 2025 3:09 AM
Home Information
Window Features: Wood Frames
Year Built: 2000
Around this home
Schools
Alpine Elementary School
Public PreK-5 • Assigned • 0.1mi
5/10
Timberline Pk-8
Public PreK-8 • Assigned • 0.8mi
2/10
Skyline High School
Public 9-12 • Assigned • 0.7mi
5/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
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 93° 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
5 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Longmont, CO • 80501
Average low and high temperatures (°F)
42
16
52
23
65
36
65
37
72
46
85
55
92
61
87
57
79
50
66
39
55
29
53
26
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
$816,000 – $988,000
Reach more buyers when you sell with Redfin. Save up to $8,589 in fees.3 minutes to get started.