$4,800,000

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

5 beds
1 full, 6 partial
8,000 sqft
33.0 acres
$600 / sqft
House

Property details

About 4789 County Road 24 Unit 3/4

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 four 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.

Highlights

Home typeSingle Family Residence
HeatingElectric, Forced Air
StatusActive
CoolingCentral Air, Other
Size8,000 sqft
BasementYes
Lot size33 Acres
Year built1999
ParkingAsphalt, Concrete, Dry Walled, Exterior Access Door, Floor Coating, Heated Garage, Insulated Garage, Smart Garage Door
MLS #6159240
Attached garage4 spaces
WaterfrontLake Front, Pond, River Front, Stream
FireplaceBedroom, Gas, Living Room
ViewLake, Mountain(s), Water
Private poolYes

Virtual tour

Summary

  • MLS Number: 6159240
  • MLS Name: RECOLORADO
  • Office Name: Equity Colorado Real Estate
  • Office Phone: (402) 980-0090
  • Listing Agent: Marshall Marquardt

IDX Listings courtesy of REColorado as distributed by MLS GRID.

All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.

IDX ©2025 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved.

Presented by Rocket Homes Real Estate, LLC
Licensed in Colorado Brokerage License # EC. 100073419

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Rocket Homes Real Estate, LLC are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.

The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.

All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.

METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.

Equal Housing

© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved
6455 S. Yosemite St., Suite 300
Greenwood Village, CO 80111 USA

ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 3/14/2025, 6:12:53 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Get an agent. Get a mortgage. Save big.¹

aerial view with a water view

$4,800,000

4789 County Road 24 Unit 3/4

Sell your home with Rocket and save even more!

Seller rebate

0.5% sale price²

Price information

Property sales

We're sorry, we currently don't have property sales data for this listing.

Tax history

We're sorry, we currently don't have tax history data for this listing.

Nearby schools

4

Centennial Elementary School

Public District PK-5

0.7 mi

10290 Neighbors Pkwy

5

Prairie Ridge Elementary School

Public District PK-5

1.5 mi

6632 St Vrain Ranch Blvd

6

Legacy Elementary School

Public District PK-5

3.3 mi

7701 Eagle Blvd

School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.

All data from GreatSchools

Neighborhood

The neighbors living near this home have an average income of $65,965. Residents of Longmont, CO typically earn between $35k-100k each year. Typical family type is single, no kids. The most common level of education of people living in this area is post secondary degree.

How much money do the neighbors make?

21%
<35k
47%
35k-100k
21%
100k-200k
11%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree

What types of families live nearby?

32%
Single, No Kids
15%
Single, with Kids
21%
Married, No Kids
32%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

23%
<11 yrs old
11%
12-17 yrs old
20%
18-34 yrs old
38%
35-64 yrs old
8%
65+ yrs old

What do the neighbors do for fun?

  • SoccerSoccer
  • College FootballCollege Football
  • Extreme SportsExtreme Sports

Where do the neighbors shop?

  • Old NavyOld Navy
  • Express/Express For MenExpress/Express For Men
  • Academy Sports & OutdoorsAcademy Sports & Outdoors

Where do the neighbors go to eat?

  • Jimmy JohnsJimmy Johns
  • SonicSonic
  • Little CaesarsLittle Caesars

What do the neighbors drive?

  • GMCGMC
  • KiaKia
  • ChevroletChevrolet

What do the neighbors listen to?

  • New CountryNew Country
  • CountryCountry
  • OldiesOldies
All data provided by Home Junction and Claritas

Similar homes for sale

Frequently asked questions

Living in Longmont, CO

About 4789 County Road 24 Unit 3/4

This home is located at 4789 County Road 24 Unit 3/4 in Longmont, CO and zip code 80504. This 8,000 square foot home, which was built in 1999, sits on a 33.00 acre lot. Features: 5 bedrooms, 7 bathrooms. It has been listed on Rocket Homes since April 17, 2024 and is currently priced at $4,800,000.

Longmont, CO housing market in February 2025 saw over 23 listings sold above listed price, more than 19 sold at listed price and over 43 sold below. Between January and February 2025, Longmont, CO real estate market has seen increase in the number of listings by 15.4%. Listings spent 72 days on the market in February 2025, and had a median list price of $576,975 during the same period.

From Rocket Homes Real Estate and based on county public records data.

More resources