Public Remarks: Million Dollar Views from this outstanding custom built, no maintenance ranch with full walk out basement. 2 master suites or in-law area. Fabulous country kitchen with see through fireplace. A true find! Gorgeous finished basement with fireplace, wet bar, and 2nd master suite area. Beautifully landscaped yard with gazebo. One of a kind property!
Terry Medearis • Sellstate Altitude Property Group
See all
Provided by Redfin
Sale history for 1789 Red Cloud Rd
Date
Event
Price
Public Records
Jun 21, 2012
Sold
$437,500
$103/sq ft
IRES as Distributed by MLS Grid #675064
Jun 21, 2012
Sold
$437,000
$103/sq ft
May 8, 2012
Contingent
—
Mar 8, 2012
Listed
$459,000
$108/sq ft
REColorado as Distributed by MLS Grid #1072661
May 8, 2012
Pending
—
Mar 8, 2012
Listed
$459,000
$108/sq ft
IRES as Distributed by MLS Grid #549528
Nov 29, 2007
Sold
$480,000
$113/sq ft
Oct 15, 2007
Listed
$479,000
$113/sq ft
+9
Public Remarks
Million Dollar Views from this custom brick ranch w/ full walkout basement! This home features 2 master suites or in-law area. Spacious kitchen w/ granite counter tops, corner pantry, & large nook area. Wonderful master suite w/ 5pc bath. Great covered deck for BBQ's and sunset views, 2 gas fireplaces, bsmt family room & wet bar area. 3 car garage. Immaculately cared for inside & out. Wonderfully landscaped .40 acre lot w/ Gazebo, variety of trees/bushes & flowers. A one of a kind property!
*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
5
Baths
3.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.4 Acres
Year renovated
1994
Sq. Ft.
3,904
Year built
1994
Style
Single Family Residential
County
Boulder County
APN
R0108961
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
Property details
Parking
Parking Features
Covered Spaces: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Parking Features: Garage Door Opener
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)
Heating: Yes
Forced Air
Interior Features
Accessibility Features: Level Drive, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry
Electric Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
Fireplace: Yes
Fireplace Features: 2+ Fireplaces, Gas, Gas Logs Included, Double Sided, Living Room, Family/Recreation Room Fireplace, Kitchen
Flooring: Wood Floors
Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Stain/Natural Trim, Walk-In Closet(s), Kitchen Island
Laundry Features: Sink, Washer/Dryer Hookups, Main Level
Construction Materials: Brick/Brick Veneer, Vinyl Siding
Financial
Tax Information
Parcel Number: R0108961
Tax Annual Amount: 2635
Tax Year: 2011
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,City of Longmon
Gas: Natural Gas,Xcel
Sewer: City Sewer
Location
HOA Information
Association: No
Association Fee: 0
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Alpine
Middle or Junior School: Heritage
High School: Skyline
Location Information
Directions: Main St ( Hwy. 287) & 17th Avenue East to Alpine, North to Sunlight, West to Red Cloud
Unparsed Address: 1789 Red Cloud Rd Longmont CO 80504
Street Number: 1789
Street Name: Red Cloud
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80504
Coordinates: -105.08862,40.19001
Latitude: 40.19001
Longitude: -105.08862
Public facts
Beds: 5
Baths: 3.5
Sq. Ft.: 3,904
Stories: 1.0
Lot Size: 0.4 acres
Style: Single Family Residential
Year Built: 1994
Year Renovated: 1994
County: Boulder County
APN: R0108961
Home facts updated by county records on Sep 2, 2026
Other
Listing Information
Attribution Contact: 3036512300
Close Price: $437,000
Photos Count: 25
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Thursday, June 21, 2012
Cumulative Days on Market: 106
Days on Market: 106
Listing Contract Date: Thursday, March 8, 2012
Modification Timestamp: Saturday, July 27, 2024 12:24 PM
Home Information
Window Features: Window Coverings, Wood Frames, Bay Window(s), Double Pane Windows
Year Built: 1994
Green Information
Green Energy Efficient: Southern Exposure
Around this home
Schools
Alpine Elementary School
Public PreK-5 • Assigned • 0.3mi
5/10
Timberline Pk-8
Public PreK-8 • Assigned • 0.7mi
2/10
Skyline High School
Public 9-12 • Assigned • 0.6mi
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.