4789 County Road 24 3/4
Longmont, CO 80504
$6,800,000
Price
5
Beds
7
Baths
8,300 Sq. Ft.
$819 / Sq. Ft.
8,300
Sq. Ft.
$819
per Sq. Ft.
Virtual Tour
Virtual Tour
Description
Nestled within a sprawling 43 +/- 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...Nestled within a sprawling 43 +/- 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.
- Listed by Marshall Marquardt • Equity Colorado Real Estate • 402-980-0090
Property Details for 4789 County Road 24 3/4
Structure Type
House
Architectural StyleTraditional
ViewLake, Mountain(s), Water
LevelsTwo
Stories2
Subdivision NameNone
AssociationNo
BasementYes
LISTING UPDATED: 11/02/2024 06:01 PM
Property Details for 4789 County Road 24 3/4
| Status | Active |
|---|---|
| MLS # | 6159240 |
| Days on Compass | 232 |
| Taxes | $8,660 / year |
| HOA Fees | - |
| Condo/Co-op Fees | - |
| Compass Type | Single Family |
| MLS Type | Residential-Detached |
| Year Built | 1999 |
| Lot Size | 43.00 AC / 1,873,080 SF |
| County | Weld County |
Virtual Tour
Building Information for 4789 County Road 24 3/4
Stories-Year Built1999Building Size-Lot Size43.00 AC / 1,873,080 SF
Property Information for 4789 County Road 24 3/4
Interior Area & SqFt
Interior Area & SqFt
- Building Area Total (SqFt Total): 8300
- Sqft Total: 8300
- Living Area (SqFt Finished): 8000
- Above Grade Finished Area: 6300
- Living SqFt: 6300
- Sq Ft Apx: 1700
- Below Grade Unfinished Area: 300
- Area Source: Listor Measured
- PSF Total: 819
- PSF Above Grade: 1079
- PSF Finished: 850
- Master on Main: Yes
- Direction Faces: South
- Room and Floor: Kitchen-Main-1, Family Room-Main-1, Dining Room-Main-1, Sun Room-Main-1, Sun Room-Main-2, Primary Bedroom-Main-1, Primary Bathroom (3/4)-Main-1, Bedroom-Main-1, Bathroom (Full)-Main-1, Bathroom (1/2)-Main-1, Office-Main-1, Laundry-Main-1, Mud Room-Main-1, Primary Bedroom-Upper-1, Primary Bedroom-Upper-2, Primary Bathroom (3/4)-Upper-1, Office-Upper-1, Media Room-Upper-1, Game Room-Basement-1, Bedroom-Basement-1, Bathroom (3/4)-Basement-1, Bathroom (3/4)-Basement-2, Laundry-Basement-1, Laundry-Upper-1, Bathroom (3/4)-Upper-1
- Room Count: 25
- Basement: Bath/Stubbed, Crawl Space, Daylight, Exterior Entry, Finished, Walk-Out Access
- Basement Ceiling Height: 9
- Foundation Details: Concrete Perimeter
- Fireplaces Total: 2
- Fireplace Features: Bedroom, Gas, Living Room
- Heating: Electric, Forced Air
- Cooling: Central Air, Other
- Interior Features: Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, In-Law Floor Plan, Kitchen Island, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Utility Sink, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Security Features: Carbon Monoxide Detector(s), Security System, Smart Cameras, Smoke Detector(s)
- Flooring: Concrete, Tile, Wood
- Furnished: Negotiable
- Appliances: Bar Fridge, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Humidifier, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Tankless Water Heater, Washer
- Spa Features: Steam Room
- Laundry Features: In Unit
- Virtual Tour URL Unbranded: https://youtu.be/3nnaIA30pQM
- Virtual Tour URL Unbranded 2: https://www.zillow.com/view-3d-home/b1e77061-a3fc-4c79-9f26-c32f83d33439?setAttribution=mls&wl=true&utm_source=dashboard
- Virtual Tour URL Unbranded 3: https://cdn.virtuance.com/v_residential/617329/videos/4789_county_road_24_34_Longmont_CO_720p 1.mp4
Bed & Bath Summary
Bedrooms
- Bedrooms Total: 5
- Upper Level Bedrooms: 2
- Main Level Bedrooms: 2
- Lower Level Bedrooms: 0
- Basement Level Bedrooms: 1
Bathrooms
- Bathrooms Total: 7
- Upper Level Bathrooms: 2
- Main Level Bathrooms: 3
- Lower Level Bathrooms: 0
- Basement Level Bathrooms: 2
- Bathrooms Full: 1
- Bathrooms Three Quarter: 5
- Bathrooms Half: 1
- Bathrooms One Quarter: 0
Detailed Room Info
Room 1
- Room Type: Kitchen
- Room Level: Main
- Room Description: 55 Sq feet hidden butler pantry, Monogram Appliances, 2 islands
- Room Length: 23
- Room Width: 22
Room 2
- Room Type: Family Room
- Room Level: Main
- Room Description: Fireplace
- Room Length: 21
- Room Width: 21
Room 3
- Room Type: Dining Room
- Room Level: Main
- Room Description: Wood floors
- Room Length: 15
- Room Width: 12
Room 4
- Room Type: Sun Room
- Room Level: Main
- Room Description: Off-Kitchen, Add. Dining room if needed
- Room Length: 19
- Room Width: 13
Room 5
- Room Type: Primary Bedroom
- Room Level: Main
- Room Description: Fireplace, Ceiling Fan
- Room Length: 18
- Room Width: 17
Room 6
- Room Type: Primary Bathroom (3/4)
- Room Level: Main
- Room Description: Steam Shower
- Room Length: 15
- Room Width: 11
Room 7
- Room Type: Bedroom
- Room Level: Main
- Room Description: Ceiling Fan, En Suite Bathroom
- Room Length: 13
- Room Width: 10
Room 8
- Room Type: Bathroom (Full)
- Room Level: Main
- Room Description: Tub/Shower Combo
- Room Length: 9
- Room Width: 5
Room 9
- Room Type: Office
- Room Level: Main
- Room Description: Built in Cabinets
- Room Length: 13
- Room Width: 11
Room 10
- Room Type: Laundry
- Room Level: Main
- Room Description: Picket Marble Walls, Dag Wash Station, Utility Sink, Island, Dog Door to Dog Run
- Room Length: 19
- Room Width: 19
Room 11
- Room Type: Bathroom (1/2)
- Room Level: Main
- Room Description: Powder Room
- Room Length: 8
- Room Width: 3
Room 12
- Room Type: Sun Room
- Room Level: Main
- Room Description: 15 foot pocket Slider Door, Motorized Screens
- Room Length: 16
- Room Width: 14
Room 13
- Room Type: Mud Room
- Room Level: Main
- Room Description: Built in Cabinets, Fridge, Utility Sink
- Room Length: 25
- Room Width: 11
Room 14
- Room Type: Primary Bedroom
- Room Level: Upper
- Room Description: 2nd Primary Bedroom, En Suite Bathroom
- Room Length: 25
- Room Width: 18
Room 15
- Room Type: Primary Bathroom (3/4)
- Room Level: Upper
- Room Length: 9
- Room Width: 9
Room 16
- Room Type: Office
- Room Level: Upper
- Room Description: Open office space
- Room Length: 10
- Room Width: 6
Room 17
- Room Type: Media Room
- Room Level: Upper
- Room Length: 24
- Room Width: 9
Room 18
- Room Type: Game Room
- Room Level: Basement
- Room Description: Wet Bar, Ice Maker, Dishwasher, Drink Fridge, Polished Concrete, Walk out
- Room Length: 61
- Room Width: 17
Room 19
- Room Type: Bedroom
- Room Level: Basement
- Room Description: En Suite Bathroom
- Room Length: 16
- Room Width: 13
Room 20
- Room Type: Bathroom (3/4)
- Room Level: Basement
- Room Length: 10
- Room Width: 8
Room 21
- Room Type: Laundry
- Room Level: Basement
- Room Description: Built Ins
- Room Length: 13
- Room Width: 13
Room 22
- Room Type: Bathroom (3/4)
- Room Level: Basement
- Room Length: 15
- Room Width: 5
Room 23
- Room Type: Primary Bedroom
- Room Level: Upper
- Room Description: MIL Suite
- Room Length: 20
- Room Width: 17
Room 24
- Room Type: Laundry
- Room Level: Upper
- Room Description: MIL Suite Laundry Room
- Room Length: 10
- Room Width: 9
Room 25
- Room Type: Bathroom (3/4)
- Room Level: Upper
- Room Description: MIL Suite Bathroom
- Room Length: 10
- Room Width: 8
Parking
Parking
- Parking Features: Asphalt, Concrete, Dry Walled, Exterior Access Door, Floor Coating, Heated Garage, Insulated Garage, Smart Garage Door
- Attached Garage: Yes
- Parking Total: 2
- Garage Spaces: 4
- Offstreet Spaces: 0
- Parking Count: 4
- Carport Spaces: 0
- Reserved Spaces: 0
- RV Spaces: 0
Association Information
Association Information
- Association Fee Total Annual: $0
- Senior Community: No
Site & Location Information
School Information
- School Of Choice: Yes
- Elementary School: Mead
- Elementary School District: St. Vrain Valley RE-1J
- Middle Or Junior School: Mead
- Middle Or Junior School District: St. Vrain Valley RE-1J
- High School: Mead
- High School District: St. Vrain Valley RE-1J
Site & Location Information
- Lot Size Acres: 43
- Lot Size Square Feet: 1873080
- Lot Features: Irrigated, Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear, Subdividable
- Fencing: Partial
- Waterfront Features: Lake, Pond, River Front, Stream
- Property Exclusions: Sellers Personal Property, Duck Blinds and Boat lift (Both negotiable)
Building Information
Green Features
- Green Verification Count: 0
Outbuildings
- Out Building Count: 1
- Number of Out Buildings: 1.0
- Horse: Yes
Building Information
- Construction Materials: Brick, Cement Siding
- Property Condition: Updated/Remodeled
- Roof: Composition
- Exterior Features: Balcony, Barbecue, Dog Run, Fire Pit, Gas Grill, Lighting, Playground, Private Yard, Rain Gutters, Spa/Hot Tub
- Patio And Porch Features: Covered, Deck, Front Porch, Patio
- Pool Features: Outdoor Pool, Private
- Livable Structure Count: 0
Water & Utilities
Water & Utilities
- Water Included: Yes
- Water Source: Public, Well
- Well Type: Irrigation, Operational
- Well Usage: Other
- Issued Well Permit Numbers: 51672-F
- Utilities: Electricity Connected, Natural Gas Connected
- Sewer: Septic Tank
- Electric: 110V, 220 Volts
Property History for 4789 County Road 24 3/4
| Date | Event & Source | Price | Appreciation |
|---|
| Date | Event & Source | Price |
|---|
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Public Records for 4789 County Road 24 3/4
Taxable ValueLand$43,670Additions$55,690Total$99,360
Tax Record2023$8,660 ($722 / month)
Home Facts
Beds4Total Finished SqFt5,420 SqFtAbove Grade Finished SqFt3,358 SqFtFinished Basement SqFt2,062 SqFtUnfinished Basement SqFt2,472 SqFtStories1Lot Size1,333,589 SqFtStyleSingle Family ResidenceYear Built1999Year Renovated2019CountyWELDAPNR7900099
Schools near 4789 County Road 24 3/4
This home is within St Vrain Valley Re 1j School District.
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | PK to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Charter - | PK to 8 |
Rating | School | Distance |
|---|---|---|
Mead Elementary School PublicPK to 5 | ||
Mead Middle School Public6 to 8 | ||
Mead High School Public9 to 12 | ||
Firestone Charter Academy CharterPK to 8 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Sorry, we can't find any similar homes at this time. Please check back later.
Similar Sold Homes
Sorry, we can't find any similar sold homes at this time. Please check back later.
Homes for Sale near Firestone
Neighborhoods
Cities
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass makes no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.
Listing Courtesy of Equity Colorado Real Estate, Marshall Marquardt
Based on information from one of the following Multiple Listing Services: REColorado, Summit MLS Inc (a wholly owned subsidiary of Summit Association of REALTORS), Pikes Peak Association of Realtors, IRES, Grand Junction Area REALTOR, CREN, Vail Board of REALTORS and Grand County Board of REALTORS . Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by REColorado, Summit MLS Inc (a wholly owned subsidiary of Summit Association of REALTORS), Pikes Peak Association of Realtors, IRES, Grand Junction Area REALTOR, CREN, Vail Board of REALTORS and Grand County Board of REALTORS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.
