7654 Rodeo Dr Longmont, CO 80504
Listing Courtesy of: IRES LLC / Boulder / David "Dave" Elmblad

  7654 Rodeo Dr Longmont, CO 80504

Pending (75 Days)


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!

MLS #:
Lot Size
3.22 acres
Single-Family Home
Year Built
Foothills View
School District
St Vrain Dist Re 1J
Boulder County
Oxford Farm Nupud
Bathroom Details
  • Full Bathrooms: 4
  • Half Bathrooms: 2
Interior Features
  • Disposal
  • Water Softener Owned
  • Microwave
  • Dryer
  • Washer
  • Bar Fridge
  • Refrigerator
  • Dishwasher
  • Gas Range/Oven
  • Laundry: Main Level
  • Steam Shower
  • Jack & Jill Bathroom
  • Walk-In Closet(s)
  • Pantry
  • Open Floorplan
  • Cathedral/Vaulted Ceilings
  • Separate Dining Room
  • Eat-In Kitchen
  • Central Vacuum
  • High Speed Internet
  • Study Area
  • Wood Floor
  • Oxford Farm Nupud
Lot Information
  • Abuts Farm Land
  • Sloped
  • Mineral Rights Excluded
  • Lawn Sprinkler System
Property Features
  • Fireplace: Great Room
  • Fireplace: Primary Bedroom
  • Fireplace: Gas
  • Fireplace: 2+ Fireplaces
Heating and Cooling
  • Forced Air
  • Whole House Fan
  • Central Air
Basement Information
  • 90%+ Finished Basement
  • Full
Homeowners Association Information
  • Dues: $750/Annually
  • Wood Floors
Exterior Features
  • Roof: Fiberglass
Utility Information
  • Utilities: Electricity Available, Natural Gas Available
  • Sewer: Septic
School Information
  • Elementary School: Indian Peaks,Other
  • Middle School: Sunset Middle
  • High School: Niwot
  • Attached Garage
  • Oversized
  • Rv/Boat Parking
  • Garage Door Opener
  • 2
Living Area
  • 7,260 sqft
Calculate drive times to this property

Estimated Monthly Mortgage Payment

*Based on Fixed Interest Rate withe a 30 year term, principal and interest only

Listing price
Down payment
Interest rate
Mortgage calculator estimates are provided by Coldwell Banker Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: Updated: 12/9/22 00:39 Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES. Terms of Use: Listing information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed by the MLS.