Skip main navigation
Sold for $2,600,000 on 01/20/23
  • $2,600,000

    7654 Rodeo Dr, Longmont, CO 80504

    5beds
    7,460sqft
    Residential-Detached, Residential
    Built in 1992
    3.22 Acres Lot
    $2,811,600 Zestimate®
    $349/sqft
    $5,681 Estimated rent

    Owner options

    List your home for rent

    $5,681/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,681/mo

    Rent Zestimate®

    Refinance and save

    $15,913/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $15,913/mo

    Est. payment

    What's special

    ** 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!

    Zillow last checked: 7 hours ago

    Listing updated: August 01, 2024 at 08:17pm

    Listed by:

    David Elmblad 970-376-4407,

    Coldwell Banker Realty-Boulder

    Bought with:

    Shallon Daniel

    Source: IRES,MLS#: 976127MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 6
    • Full bathrooms: 4
    • 1/2 bathrooms: 2
    • Main level bedrooms: 2
    Primary bedroom
    • Area: 300
    • Dimensions: 20 x 15
    Bedroom 2
    • Area: 192
    • Dimensions: 16 x 12
    Bedroom 3
    • Area: 168
    • Dimensions: 14 x 12
    Bedroom 4
    • Area: 216
    • Dimensions: 18 x 12
    Bedroom 5
    • Area: 180
    • Dimensions: 15 x 12
    Dining room
    • Area: 168
    • Dimensions: 14 x 12
    Kitchen
    • Area: 448
    • Dimensions: 32 x 14
    Heating
    • Forced Air
    Cooling
    • Central Air, Whole House Fan
    Appliances
    • Included: Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Softener Owned, Disposal
    • Laundry: Main Level
    Features
    • 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, Open Floor Plan, Walk-in Closet
    • Flooring: Wood, Wood Floors, Tile, Carpet
    • Basement: Full
    • Has fireplace: Yes
    • Fireplace features: 2+ Fireplaces, Gas, Master Bedroom, Great Room
    Interior area
    • Total structure area: 7,460
    • Total interior livable area: 7,460 sqft
    • Finished area above ground: 4,377
    • Finished area below ground: 3,083

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage Door Opener, RV/Boat Parking, Oversized
    • Attached garage spaces: 3
    • Details: Garage Type: Attached
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Patio
    • Exterior features: Gas Grill
    • Has spa: Yes
    • Spa features: Bath
    • Fencing: Partial,Other
    • Has view: Yes
    • View description: Hills
    Lot
    • Size: 3.22 Acres
    • Features: Lawn Sprinkler System, Mineral Rights Excluded, Sloped, Abuts Farm Land
    Details
    • Additional structures: Storage, Outbuilding
    • Parcel number: R0089543
    • Zoning: residentia
    • Special conditions: Private Owner

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary/Modern
    • Property subtype: Residential-Detached, Residential
    Materials
    • Wood/Frame, Composition Siding
    • Roof: Fiberglass
    Condition
    • Not New, Previously Owned
    • New construction: No
    • Year built: 1992
    Details
    • Builder name: DMW

    Utilities & green energy

    • Electric: Electric, Xcel Energy
    • Gas: Natural Gas, Xcel Energy
    • Sewer: Septic
    • Water: District Water, Well, Cistern, Left Hand
    • Utilities for property: Natural Gas Available, Electricity Available

    Community & neighborhood

    Location
    • Region: Longmont
    • Subdivision: Oxford Farm Nupud

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $750 annually
    • Services included: Snow Removal, Management

    Other

    Other facts
    • Listing terms: Cash,Conventional,1031 Exchange
    • Road surface type: Paved, Asphalt
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,811,600