Skip main navigation
Sold for $2,900,000 on 05/07/25
  • $2,900,000

    4789 County Road 24 3/4, Longmont, CO 80504

    5beds
    8,300sqft
    Single Family Residence
    Built in 1999
    33 Acres Lot
    $-- Zestimate®
    $349/sqft
    $6,913 Estimated rent

    What's special

    Nestled within a sprawling 33 +/- acre estate, this magnificent 8,300 square foot home offers an unparalleled blend of luxury, comfort, and serenity, perfectly suited for discerning homeowners seeking an opulent country lifestyle just minutes away from local amenities. The residence boasts five generously sized bedrooms and six bathrooms, ensuring ample space for family and guests alike. The inclusion of a full mother-in-law suite adds a layer of convenience and flexibility, making it ideal for extended family or visitors. Central to the home’s allure is its gourmet kitchen, a masterpiece of design and functionality. Outfitted with high-end Monogram appliances and custom inset cabinetry, this culinary space is both stunning and highly practical. The kitchen’s luxury is further enhanced by its 6cm thick marble and granite countertops, offering both durability and a touch of elegance. The home’s living spaces are defined by their sophisticated European white oak flooring, providing a seamless flow throughout. The grandeur of the interior is amplified by a dramatic 15-foot pocket slider, which opens expansively to integrate the indoor living area with a screened-in porch. This transition seamlessly extends the living space into the outdoors, overlooking a meticulously designed pool and tranquil lake, epitomizing indoor-outdoor living. Entertainment and leisure are brilliantly catered to within this agricultural zoned property, outside of city limits, where you can enjoy the three privately stocked Ponds for fishing, boating and hunting. Waterfowl, Turkey, and Trophy Whitetail frequent the property on the quarter mile of privately owned Saint Vrain river. An outdoor kitchen and a substantial 6,600 square foot shop provide additional facilities that are both practical and indulgent. This property represents a rare opportunity to own a significant estate that promises a lifestyle of peaceful privacy, sophisticated entertaining, and boundless outdoor activity.

    Zillow last checked: 7 hours ago

    Listing updated: May 07, 2025 at 02:39pm

    Listed by:

    Marshall Marquardt 402-980-0090,

    Equity Colorado Real Estate

    Bought with:

    Marshall Marquardt, 100076738

    Equity Colorado Real Estate

    Source: REcolorado,MLS#: 6159240MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 7
    • Full bathrooms: 1
    • 3/4 bathrooms: 5
    • 1/2 bathrooms: 1
    • Main level bathrooms: 3
    • Main level bedrooms: 2
    Primary bedroom
    • Description: Mil Suite
    • Level: Upper
    • Area: 330 Square Feet
    • Dimensions: 16.5 x 20
    Primary bedroom
    • Description: Fireplace, Ceiling Fan
    • Level: Main
    • Area: 306 Square Feet
    • Dimensions: 17 x 18
    Primary bedroom
    • Description: 2nd Primary Bedroom, En Suite Bathroom
    • Level: Upper
    • Area: 428.75 Square Feet
    • Dimensions: 17.5 x 24.5
    Bedroom
    • Description: En Suite Bathroom
    • Level: Basement
    • Area: 201.5 Square Feet
    • Dimensions: 13 x 15.5
    Bedroom
    • Description: Ceiling Fan, En Suite Bathroom
    • Level: Main
    • Area: 130 Square Feet
    • Dimensions: 10 x 13
    Primary bathroom
    • Level: Upper
    • Area: 81 Square Feet
    • Dimensions: 9 x 9
    Primary bathroom
    • Description: Steam Shower
    • Level: Main
    • Area: 165 Square Feet
    • Dimensions: 11 x 15
    Bathroom
    • Description: Powder Room
    • Level: Main
    • Area: 26 Square Feet
    • Dimensions: 3.25 x 8
    Bathroom
    • Description: Mil Suite Bathroom
    • Level: Upper
    • Area: 80 Square Feet
    • Dimensions: 8 x 10
    Bathroom
    • Level: Basement
    • Area: 67.5 Square Feet
    • Dimensions: 4.5 x 15
    Bathroom
    • Description: Tub/Shower Combo
    • Level: Main
    • Area: 43.75 Square Feet
    • Dimensions: 5 x 8.75
    Bathroom
    • Level: Basement
    • Area: 80 Square Feet
    • Dimensions: 8 x 10
    Dining room
    • Description: Wood Floors
    • Level: Main
    • Area: 177.63 Square Feet
    • Dimensions: 12.25 x 14.5
    Family room
    • Description: Fireplace
    • Level: Main
    • Area: 430.5 Square Feet
    • Dimensions: 20.5 x 21
    Game room
    • Description: Wet Bar, Ice Maker, Dishwasher, Drink Fridge, Polished Concrete, Walk Out
    • Level: Basement
    • Area: 1028.5 Square Feet
    • Dimensions: 17 x 60.5
    Kitchen
    • Description: 55 Sq Feet Hidden Butler Pantry, Monogram Appliances, 2 Islands
    • Level: Main
    • Area: 483.75 Square Feet
    • Dimensions: 21.5 x 22.5
    Laundry
    • Description: Picket Marble Walls, Dag Wash Station, Utility Sink, Island, Dog Door To Dog Run
    • Level: Main
    • Area: 346.88 Square Feet
    • Dimensions: 18.5 x 18.75
    Laundry
    • Description: Mil Suite Laundry Room
    • Level: Upper
    • Area: 85 Square Feet
    • Dimensions: 8.5 x 10
    Laundry
    • Description: Built Ins
    • Level: Basement
    • Area: 156.25 Square Feet
    • Dimensions: 12.5 x 12.5
    Media room
    • Level: Upper
    • Area: 212.19 Square Feet
    • Dimensions: 8.75 x 24.25
    Mud room
    • Description: Built In Cabinets, Fridge, Utility Sink
    • Level: Main
    • Area: 275 Square Feet
    • Dimensions: 11 x 25
    Office
    • Description: Built In Cabinets
    • Level: Main
    • Area: 136.5 Square Feet
    • Dimensions: 10.5 x 13
    Office
    • Description: Open Office Space
    • Level: Upper
    • Area: 57 Square Feet
    • Dimensions: 6 x 9.5
    Sun room
    • Description: Off-Kitchen, Add. Dining Room If Needed
    • Level: Main
    • Area: 255.06 Square Feet
    • Dimensions: 13.25 x 19.25
    Sun room
    • Description: 15 Foot Pocket Slider Door, Motorized Screens
    • Level: Main
    • Area: 224 Square Feet
    • Dimensions: 14 x 16
    Heating
    • Electric, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Bar Fridge, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Tankless Water Heater, Washer
    • Laundry: In Unit
    Features
    • Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Kitchen Island, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
    • Flooring: Concrete, Tile, Wood
    • Basement: Bath/Stubbed,Crawl Space,Daylight,Exterior Entry,Finished,Walk-Out Access
    • Number of fireplaces: 2
    • Fireplace features: Bedroom, Gas, Living Room
    Interior area
    • Total structure area: 8,300
    • Total interior livable area: 8,300 sqft
    • Finished area above ground: 6,300
    • Finished area below ground: 1,700

    Property

    Parking
    • Total spaces: 4
    • Parking features: Asphalt, Concrete, Dry Walled, Exterior Access Door, Floor Coating, Heated Garage, Insulated Garage, Garage Door Opener
    • Attached garage spaces: 4
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Covered, Deck, Front Porch, Patio
    • Exterior features: Balcony, Barbecue, Dog Run, Fire Pit, Gas Grill, Lighting, Playground, Private Yard, Rain Gutters
    • Has private pool: Yes
    • Pool features: Outdoor Pool, Private
    • Has spa: Yes
    • Spa features: Steam Room, Spa/Hot Tub
    • Fencing: Partial
    • Has view: Yes
    • View description: Lake, Mountain(s), Water
    • Has water view: Yes
    • Water view: Lake,Water
    • Waterfront features: Pond, River Front, Stream
    Lot
    • Size: 33 Acres
    • Features: Irrigated, Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear, Subdividable
    Details
    • Parcel number: R7900099
    • Special conditions: Standard
    • Horses can be raised: Yes

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence
    Materials
    • Brick, Cement Siding
    • Foundation: Concrete Perimeter
    • Roof: Composition
    Condition
    • Updated/Remodeled
    • Year built: 1999

    Utilities & green energy

    • Electric: 110V, 220 Volts
    • Water: Public, Well
    • Utilities for property: Electricity Connected, Natural Gas Connected

    Community & neighborhood

    Security
    • Security features: Carbon Monoxide Detector(s), Security System, Smart Cameras, Smoke Detector(s)
    Location
    • Region: Frederick
    • Subdivision: None

    Other

    Other facts
    • Listing terms: Cash,Conventional,Jumbo,Other
    • Ownership: Individual
    • Road surface type: Paved
    Services availability