Start of property details
4789 County Road 24 3/4
Longmont, 80504
FOR
SALE
$7,000,000
For Sale
5
Beds7
Baths4
Garage8,300
Sq.Ft.43.66
AcresMLS# 6159240
Cumulative Days on Market: 14
(since
April 17th, 2024)
Data provided by the MLS.
Property Details
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 homes 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 kitchens luxury is further enhanced by its 6cm thick marble and granite countertops, offering both durability and a touch of elegance. The homes 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.
Property Highlights
Price
$7,000,000
Property Type
Residential
Property Sub Type
Single Family Residence
Architectural Style
Traditional
Total Bathrooms
7
Year Built
1999
Acres
43.66
Location
County
Weld
Direction Faces
South
Subdivision
None
View
Lake, Mountain(s), Water
Waterfront Features
Lake, Pond, River Front, Stream
Property Details
Condition
Updated/Remodeled
Price
$7,000,000
Property Sub Type
Single Family Residence
Property Type
Residential
Building
Levels
Two
Structure Type
House
Total Area
8,300
Community
Local Schools
Elementary School
Mead
High School
Mead
Middle School
Mead
School District
St. Vrain Valley RE-1J
Interior Features
Bedrooms and Bathrooms
1/2 Bathrooms
1
3/4 Bathrooms
5
Bathrooms on Main Level
3
Bedrooms
5
Bedrooms on Main Level
2
Full Bathrooms
1
Total Bathrooms
7
Rooms and Basement
Basement Features
Bath/Stubbed, Crawl Space, Daylight, Exterior Entry, Finished, Walk-Out Access
Has Basement
Yes
Area and Spaces
Above Grade Finished Area
6,300
Below Grade Finished Area
1,700
Living Area
8,000
Appliances
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
Interior Features
Electic
110V, 220 Volts
Fireplace Features
Bedroom, Gas, Living Room
Flooring
Concrete, Tile, Wood
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
Laundry Features
In Unit
Security Features
Carbon Monoxide Detector(s), Security System, Smart Cameras, Smoke Detector(s)
Heating and Cooling
Fireplaces
2
Heating Features
Electric, Forced Air
Building Details
Construction
Architectural Style
Traditional
Foundation
Concrete Perimeter
Year Built
1999
Materials
Construction Materials
Brick, Cement Siding
Roof
Composition
Terms
Terms
Exclusions
Sellers Personal Property, Duck Blinds and Boat lift (Both negotiable)
Ownership
Individual
Special Conditions
None
Special Terms
Cash, Conventional, Jumbo, Other
Taxes
Tax
Tax (Annual)
$8,660
Heating, Cooling & Utilities
Cooling Features
Central Air, Other
Utilities
Sewer
Septic Tank
Utilities
Electricity Connected, Natural Gas Connected
Water Source
Public, Well
Lot
Acres
43.66
Lot Features
Irrigated, Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear, Subdividable
Lot Size
1,902,047
Lot Size Area Sq Ft
1,902,047
Exterior Features
Exterior Features
Balcony, Barbecue, Dog Run, Fire Pit, Gas Grill, Lighting, Playground, Private Yard, Rain Gutters, Spa/Hot Tub
Fencing
Partial
For Horses
Yes
Patio And Porch Features
Covered, Deck, Front Porch, Patio
Parking
Garage Capacity
4
Parking Features
Asphalt, Concrete, Dry Walled, Exterior Access Door, Floor Coating, Heated Garage, Insulated Garage, Smart Garage Door
Total Parking Spaces
4
Pool Features
Pool Features
Outdoor Pool, Private
Spa Features
Steam Room
Listed by Equity Colorado Real Estate, 402-980-0090.
Listing Data last updated 05/01/2024 08:31 AM
Get a Link to this Property: Copy To Clipboard
Phone:
Payment Calculator
per month.
Fixed.
% interest.
Total interest paid over s will be:
Principal & Interest
Home Insurance
Property Tax
HOA Fees
All estimates and provided for informational purposes only.
Actual amounts may vary.
The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice.
Information, rates, programs and loan scenarios shown are for example only as of 1-May-2024 and are subject to change without notice.
All products are subject to credit and property approval.
Not all products are available in all states or for all loan amounts.
Other restrictions and limitations apply.
Contact your preferred lender for the pricing associated with your specific transaction.
Calculations are generated by open source mortgage calculation software tools using common mathematical formulas.
Copyright © 2024 Buying Buddy.
All calculations should be independantly verified.
Get Walk Score Content
Property History
14 days ago
Property information last updated
14 days ago
Status Active. This is the date the listing was placed on market.
NOTE: Cumulative Days on Market: 14.
Data provided by the MLS.
Similar Properties
Listings courtesy of REcolorado as distributed by MLS GRID
IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MLS GRID.
Based on information submitted to the MLS GRID as of 05/01/2024 08:31 AM.
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.
Listing Data last updated: 05/01/2024 08:31 AM
Service by Buying Buddy® IDX CRM
Copyright © 2003 - 2024 Buying Buddy. All rights reserved.
Copyright © 2003 - 2024 Buying Buddy. All rights reserved.
Listed by Equity Colorado Real Estate
{"property_id":"denver_6159240","AboveGradeFinishedArea":"6300","AccessibilityFeatures":null,"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","ArchitecturalStyle":"Traditional","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"402-980-0090","Basement":"Bath\/Stubbed, Crawl Space, Daylight, Exterior Entry, Finished, Walk-Out Access","BasementYN":"1","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"5","BelowGradeFinishedArea":"1700","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick, Cement Siding","Contingency":null,"Cooling":"Central Air, Other","CountyOrParish":"Weld","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"South","DoorFeatures":null,"Electric":"110V, 220 Volts","ElementarySchool":"Mead","Exclusions":"Sellers Personal Property, Duck Blinds and Boat lift (Both negotiable)","ExteriorFeatures":"Balcony, Barbecue, Dog Run, Fire Pit, Gas Grill, Lighting, Playground, Private Yard, Rain Gutters, Spa\/Hot Tub","Fencing":"Partial","FireplaceFeatures":"Bedroom, Gas, Living Room","FireplaceYN":null,"FireplacesTotal":"2","Flooring":"Concrete, Tile, Wood","FoundationDetails":"Concrete Perimeter","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Electric, Forced Air","HighSchool":"Mead","HorseAmenities":null,"HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"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","InternetAddressDisplayYN":null,"LaundryFeatures":"In Unit","Levels":"Two","ListAgentFullName":"Marshall Marquardt","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, Jumbo, Other","LivingArea":null,"LotFeatures":"Irrigated, Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear, Subdividable","LotSizeArea":"1902047.00","LotSizeDimensions":null,"LotSizeSquareFeet":"1902047.00","MainLevelBathrooms":"3","MainLevelBedrooms":"2","MiddleOrJuniorSchool":"Mead","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Asphalt, Concrete, Dry Walled, Exterior Access Door, Floor Coating, Heated Garage, Insulated Garage, Smart Garage Door","ParkingTotal":"4","PatioAndPorchFeatures":"Covered, Deck, Front Porch, Patio","PoolFeatures":"Outdoor Pool, Private","PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"0","PropertyCondition":"Updated\/Remodeled","PropertySubType":"Single Family Residence","public_remarks":"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 homes 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 kitchens luxury is further enhanced by its 6cm thick marble and granite countertops, offering both durability and a touch of elegance. The homes 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.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"Carbon Monoxide Detector(s), Security System, Smart Cameras, Smoke Detector(s)","seller_office_id":null,"SeniorCommunityYN":"0","Sewer":"Septic Tank","SkiFeatures":null,"SpaFeatures":"Steam Room","SpaYN":null,"SpecialListingConditions":"None","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"8660.00","Utilities":"Electricity Connected, Natural Gas Connected","View":"Lake, Mountain(s), Water","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/youtu.be\/NvVYcFBiOZw?si=cT2s95cUT7KBXGEV","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public, Well","WaterfrontFeatures":"Lake, Pond, River Front, Stream","WaterfrontYN":null,"WindowFeatures":null,"YearBuilt":"1999","Zoning":null,"ZoningDescription":null,"property_uid":"REC2037869169","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"6159240","acreage":null,"acres":"43.66","address":null,"address_direction":null,"address_flg":"1","address_num":"4789","agent_id":"55045277","area":null,"baths_total":"7.00","bedrooms_total":"5","car_spaces":"4","city":"Longmont","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"8000","geocode_address":"4789 County Road 24 3\/4","geocode_status":null,"lat":"40.1727555","lon":"-104.96866592","office_id":"EQTCO","office_name":"Equity Colorado Real Estate","orig_price":"7000000","photo_count":"49","previous_price":null,"price":"7000000","prop_img":"\/listing\/photos\/denver\/6159240-0.jpeg","property_type":"Residential","sqft_total":"8300","state":"CO","street_type":null,"street_name":"County Road 24 3\/4","sub_area":"None","unit":null,"zip_code":"80504","listing_dt":"2024-04-17","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-04-17 21:51:24","create_dt":"2024-04-17 21:48:38","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}
