Public Remarks: Contemporary farmhouse on 20 lush acres backing to Left Hand Creek w/ great views of Haystack & Flatirons mtns. One of a kind, modern estate, completely rebuilt and located just minutes from Boulder. Spacious bright design, main level master suite, pool, pool house, tennis court, lighted hockey/sport court. Reclaimed Wyoming Snow fence siding, reclaimed beams, mixed hardwood flooring, soaring ceilings, 2+car attached garage, carport, barn & more! A gorgeous property w/ every amenity imaginable.
Single-familyProperty Type
2016Year Built
19.94 acresLot Size
$1,100Est. Price/Sq.Ft.
2 car garageParking
Listed by R Tim Goodacre• Goodacre & Company
Contact: 3034493434
Bought with Gregory W Smith• RE/MAX Alliance-Boulder
Study Area, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Wet Bar, Jack & Jill Bathroom, Kitchen Island
Laundry Features: Washer/Dryer Hookups, Main Level
Room Information
Basement: None, Crawl Space, Sump Pump
Exterior
Exterior Features
Tennis Court(s)
Fencing: Partial, Wood
Patio and Porch Features: Patio, Enclosed
Roof: Metal
Pool Information
Private Pool: Yes
Pool Features: Private
Spa: Yes
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): Yes
Pasture
Current Use: Zoning Appropriate for 4+ Horses
Lot Features: Lawn Sprinkler System, Wooded, Level, Abuts Ditch, Unincorporated
Other Structures: Storage, Carriage House, Outbuildings
Zoning: SFR
Property Information
New Construction
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: Foothills East
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 5661
Below Grade Finished Area: 0
Builder Name: Coburn Development
Building Area Total: 5661
Construction Materials: Wood/Frame, Wood Siding
Foundation Details: Slab
Financial
Tax Information
Parcel Number: R0054436
Tax Annual Amount: 5533
Tax Year: 2015
Financial Information
Listing Terms: Cash, Conventional
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available, Cable Available
Electric: Electric,Poudre Valley
Gas: Natural Gas,Xcel
Sewer: Septic
Location
HOA Information
Association: No
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Eagle Crest
Middle or Junior School: Altona
High School: Silver Creek
Location Information
Directions: Diagonal to 63rd. North on 63rd to Niwot Road. West on Niwot Road to property. OR north on US 36 (Foothills Hwy). East on Neva Road. South on 45th Street. East on Niwot Road.
Unparsed Address: 5225 Niwot Rd Longmont CO 80503
Street Number: 5225
Street Name: Niwot
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.231611,40.103638
Latitude: 40.103638
Longitude: -105.231611
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 6,791
Stories: —
Lot Size: 19.94 acres
Style: Single Family Residential
Year Built: 1973
Year Renovated: 2001
County: Boulder County
APN: R0054436
Home facts updated by county records on Aug 14, 2019
Other
Listing Information
Attribution Contact: 3034493434
Close Price: $5,475,000
Photos Count: 37
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, April 28, 2017
Cumulative Days on Market: 221
Days on Market: 221
Listing Contract Date: Tuesday, September 20, 2016
Modification Timestamp: Tuesday, August 27, 2024 5:57 PM
Home Information
Direction Faces: South
Levels: Two
New Construction: Yes
Window Features: Wood Frames, Double Pane Windows
Year Built: 2016
Green Information
Green Energy Efficient: Southern Exposure, HVAC, Thermostat, Energy Rated
Around this home
Schools
Blue Mountain Elementary School
Public PreK-5 • Assigned • 4.3mi
10/10
Altona Middle School
Public 6-8 • Assigned • 4.8mi
10/10
Silver Creek High School
Public 9-12 • Assigned • 4.9mi
9/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.