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.
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
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#: 6159240

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