Public Remarks: ** Happy Holidays - Sellers are Accepting Back up Offers ** An idyllic home for gatherings & entertaining with 7400 + finished sq ft on a 3 acre lot that allows horses * Uniquely situated in a quiet enclave w just 10 other homes, open space on 3 sides w breathtaking views of the mountains*Located 4 miles south of downtown Longmont & 4 miles east of Niwot, this impressive residence is perfect for buyers looking for space & solitude, an open floor plan & alluring outdoor living spaces * Upon entering you'll admire the voluminous great room w vaulted ceilings that flows to a stunning kitchen, a full bar, separate dining room and a breakfast nook * A large rock fireplace, new wood floors & multiple windows adorn this awesome great room * The dream kitchen has beautiful, granite countertops, a plethora of cabinets, top of the line appliances, a 6 burner gas range & a walk-in pantry * Steps away is the welcoming & spacious master suite, boasting a 5-piece spa bath room with a large walk-in steam shower * Other main floor features are the in-law bedroom w full bathroom & a lg laundry room/butler kitchen * Upstairs has 3 add'l bedrooms and 2 updated bathrooms including a large jack n jill * In the garden level bsmt - an executive office, a lg rec room, a lounge room & the 6th bathroom * A generous 3-car attached garage features several tall storage cabinets * The exterior living spaces are terrific - an expansive patio shaded by soaring mature trees, a monstrous yard, a 30 ft long swimming pool w a pool house, add'l space for outdoor games & horses * Bonus - park your RV & other vehicles in the 38 ft long outbuilding complete w an air compressor & 220 outlet * 5 min to restaurants & shopping; 15 minutes to I-25, 30 min to Boulder and 40 min to Denver * See 2 lists - Home Upgrades & Unique Property Features - under Docs tab for more detail * This well-cared-for home is sure to delight - make it yours today!
Single-familyProperty Type
1992Year Built
3.22 acresLot Size
$349Est. Price/Sq.Ft.
3 car garageParking
Listed by David Elmblad• Coldwell Banker Realty-Boulder
Contact: 9703764407
Bought with Shallon Daniel• Keller Williams Realty Downtown LLC
Priced below 2001 appraisal! Rural Estate w/incredible views. Vaulted ceilings & open floor plan with stone fireplace in Great Room. Exercise Room, Home Office, Rec. Room, & large storage room in lower Garden Level. Overlooks County Open Space to the north, east & west. Heated pool, spa, and spacious patio and yard for entertaining - yet offers great privacy. Deep well for irrigation. 1600 sq. ft. heated outbuilding w/studio, RV/boat parking, workshop, etc. Licensed Owner.
IRES as Distributed by MLS Grid #343871
Oct 22, 2002
Listing Removed
—
Jul 11, 2002
Listed
$1,499,000
$201/sq ft
Public Records
Feb 21, 1992
Sold
$58,000
$8/sq ft
Public Records
Jan 28, 1991
Sold
$15,000
$2/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$14,110 (+5.1%)
$36,275 + $94,669
$130,944
2024
$13,422 (+6.6%)
$36,275 + $94,669
$130,944
2023
$12,596 (+26.3%)
$20,575 + $116,078
$136,653
2022
$9,975 (−1.3%)
$24,261 + $116,078
$140,339
2021
$10,108 (+20.1%)
$21,538 + $83,581
$105,119
2020
$8,417 (+0.3%)
$22,158 + $85,986
$108,144
2019
$8,391 (+4.5%)
$18,233 + $73,216
$91,449
2018
$8,029 (−2.1%)
$18,233 + $73,216
$91,449
2017
$8,205 (−18.7%)
$17,640 + $70,862
$88,502
2016
$10,091 (+5.0%)
$17,640 + $70,862
$88,502
2015
$9,610 (+23.2%)
$21,253 + $85,411
$106,664
2014
$7,799 (−0.3%)
$30,168 + $54,415
$84,583
2013
$7,825 (−6.7%)
$30,168 + $54,415
$84,583
2012
$8,383 (+6.9%)
$30,168 + $54,415
$84,583
2011
$7,839 (−16.8%)
$21,014 + $70,282
$91,296
2010
$9,417 (+1.8%)
$21,014 + $70,282
$91,296
2009
$9,249
$23,880 + $86,920
$110,800
Tax history for 7654 Rodeo Dr
Year
Property tax
Land + Additions
Assessment*
2025
$14,110 (+5.1%)
$36,275 + $94,669
$130,944
2024
$13,422 (+6.6%)
$36,275 + $94,669
$130,944
2023
$12,596 (+26.3%)
$20,575 + $116,078
$136,653
2022
$9,975 (−1.3%)
$24,261 + $116,078
$140,339
2021
$10,108 (+20.1%)
$21,538 + $83,581
$105,119
2020
$8,417 (+0.3%)
$22,158 + $85,986
$108,144
2019
$8,391 (+4.5%)
$18,233 + $73,216
$91,449
2018
$8,029 (−2.1%)
$18,233 + $73,216
$91,449
2017
$8,205 (−18.7%)
$17,640 + $70,862
$88,502
2016
$10,091 (+5.0%)
$17,640 + $70,862
$88,502
2015
$9,610 (+23.2%)
$21,253 + $85,411
$106,664
2014
$7,799 (−0.3%)
$30,168 + $54,415
$84,583
2013
$7,825 (−6.7%)
$30,168 + $54,415
$84,583
2012
$8,383 (+6.9%)
$30,168 + $54,415
$84,583
2011
$7,839 (−16.8%)
$21,014 + $70,282
$91,296
2010
$9,417 (+1.8%)
$21,014 + $70,282
$91,296
2009
$9,249
$23,880 + $86,920
$110,800
*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
4
Baths
5
Stories
—
Lot width
—
Lot depth
—
Lot size
3.22 Acres
Year renovated
2005
Sq. Ft.
7,130
Year built
1992
Style
Single Family Residential
County
Boulder County
APN
R0089543
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
A
Agricultural District
Rural areas where conservation of agricultural resources is of major value, and where residential development compatible with agricultural uses is allowed.
Permitted uses
Include but are not limited to:
Agriculture
Equestrian facility
Livestock production
Religious facility
Day care facility
Housing-Group
Housing-Single unit
Bed & breakfast
Educational/school
Kennel
Property details
Parking
Parking Features
Covered Spaces: 3
Garage: Yes
Attached Garage: Yes
Garage Spaces: 3
Parking Features: Garage Door Opener, RV/Boat Parking, Oversized
Interior
Bathroom Information
Bathrooms (Full): 4
Bathrooms (Half): 2
Bathrooms (Three Quarter): 0
Bedroom Information
Bedrooms Total: 5
Heating & Cooling
Cooling: Yes
Central Air, Whole House Fan
Heating: Yes
Forced Air
Interior Features
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Softener Owned, Disposal
Fireplace: Yes
Fireplace Features: 2+ Fireplaces, Gas, Primary Bedroom, Great Room
Flooring: Wood Floors
Study Area, High Speed Internet, Central Vacuum, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Jack & Jill Bathroom, Steam Shower
Laundry Features: Main Level
Room Information
Basement: Full
Exterior
Exterior Features
Gas Grill
Fencing: Partial, Other
Patio and Porch Features: Patio
Roof: Fiberglass
Pool Information
Spa: Yes
Spa Features: Bath
Land Information
Road Surface Type: Paved, Asphalt
Lot Information
Horse(s): No
Lot Features: Lawn Sprinkler System, Mineral Rights Excluded, Sloped, Abuts Farm Land
Other Structures: Storage, Outbuildings
Zoning: residentia
Property Information
Property Type: Residential
View: Yes
Waterfront: No
Subdivision Information
Subdivision Name: OXFORD FARM Nupud
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 4377
Below Grade Finished Area: 3083
Builder Name: DMW
Building Area Total: 4377
Construction Materials: Wood/Frame, Composition Siding
Financial
Tax Information
Parcel Number: R0089543
Tax Annual Amount: 10108
Tax Year: 2021
Financial Information
Listing Terms: Cash, Conventional, 1031 Exchange
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,Xcel Energy
Gas: Natural Gas,Xcel Energy
Sewer: Septic
Location
HOA Information
Association: Yes
Association Fee: 750
Association Fee Frequency: Annually
Association Fee Includes: Snow Removal, Management
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Indian Peaks,OTHER
Middle or Junior School: Sunset Middle
High School: Niwot
Location Information
Directions: Pls use GPS
Unparsed Address: 7654 Rodeo Dr Longmont CO 80504
Street Number: 7654
Street Name: Rodeo
Street Suffix: Dr
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80504
Coordinates: -105.08136,40.11384
Latitude: 40.11384
Longitude: -105.08136
Public facts
Beds: 4
Baths: 5.0
Sq. Ft.: 7,130
Stories: —
Lot Size: 3.22 acres
Style: Single Family Residential
Year Built: 1992
Year Renovated: 2005
County: Boulder County
APN: R0089543
Home facts updated by county records on Sep 2, 2026
Other
Miscellaneous Information
Exclusions: Sellers Personal Possessions, Staging, some curtains, Baby Grand Piano, 2 trailers
Listing Information
Attribution Contact: 9703764407
Close Price: $2,600,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, January 20, 2023
Cumulative Days on Market: 74
Days on Market: 74
Listing Contract Date: Friday, September 23, 2022
Modification Timestamp: Friday, August 2, 2024 3:15 AM
Home Information
Direction Faces: West
Levels: Two
Year Built: 1992
Around this home
Schools
Indian Peaks Elementary School
Public PreK-5 • Assigned • 2.8mi
4/10
Sunset Middle School
Public 6-8 • Assigned • 2.9mi
6/10
Niwot High School
Public 9-12 • Assigned • 3.4mi
10/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
2/10 Fire Factor
0.00% chance of being in a wildfire in next 30 years
3/10 Heat Factor
8 days above 93° expected this year, 20 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
6/10 Air Factor
10 unhealthy days expected this year, 10 days in 30 years
Provided by First Street
Historical weather
Longmont, CO • 80504
Average low and high temperatures (°F)
42
16
52
23
65
36
65
37
72
46
85
55
92
61
87
57
79
50
69
41
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
$2.47M – $2.99M
Reach more buyers when you sell with Redfin. Save up to $26,030 in fees.3 minutes to get started.