Virtual Tour Sold Berthoud, CO 80513 MLS# 2040986 Sold by Marshall Massaro on 01/08/2021
$1,850,000
Email
Facebook
Twitter
Pinterest
WhatsApp
Single Family Property Type
3 Bedroom
4 Bathroom
5 Garage
4584.00 Sq Ft
2.38 Acres
2015 Year Built

Overview

Welcome to this one-of-a-kind, custom-built home in west Berthoud!!! This meticulously-maintained, energy efficient home offers breathtaking Front Range views, over 4,000 sf of main floor living with an abundance of natural light, gourmet and prep kitchens, and a wealth of luxury finishes. Features include a luxury master bath, geothermal radiant heating and cooling, stone countertops, custom cabinetry, touch faucets, artistic accents and glass mosaics, building automation and AV systems, and SO MUCH MORE! Two garages offer over 2,500 sf of climate-controlled space with RV storage. Exterior features include a photovoltaic system (owned), snowmelt system in patios and driveway, professional landscaping with drip irrigation, rooftop patio, dog run, and an expansive outdoor patio and kitchen perfect for entertaining. Home abuts 80 acres of private open space and HOA owns 7.5 shares of irrigation water. Property is located just minutes from the TPC Colorado golf course and Carter Lake. View property at www.3457SnowyEgret.com

New Home Sales Hours

Courtesy Of RE/MAX TRADITIONS
Source: REcolorado

View On REcolorado

Upcoming Open Houses

    Features

    Leasing Information

    Leasing Details
    • Application Fee $
    • Availability Date
    • Corporate Rental?
    • Deposits Potentially Refundable
    • Existing Lease Type
    • Lease Amount $
    • Lease Description
    • Lease Duration
    • Liability Insurance Required
    • Owner Pays
    • Rent Deposit
    • Rental Application
    • Security Deposit $
    Pet Details
    • Pet Deposit
    • Pet Rent
    • Pets Allowed Yes

    Interior Features

    Summary

    • Year Built Effective
    Basement Details
    • Basement? Yes
    • Basement Crawl Space
    • Basement Ceiling Height 5'
    Fireplace Detail
    • Fireplace Features Gas Log,Great Room,Primary Bedroom
    • No. of Fireplaces 2
    Square Foot Details
    • SqFt 4,584
    • Living Area, Finished 4,584
    • Above grade, Finished 4,584
    • Basement, Finished 0
    • Basement, Unfinished 0
    • PSF Total $403.58
    • PSF Finished $403.58
    • PSF Above Grade $403.58
    Use details
    • Leaseable Area
    • Office Area
    • Retail Area
    • Warehouse Area
    Other
    • Accessibility Features
    • Appliances Convection Oven,Cooktop,Dishwasher,Disposal,Double Oven,Dryer,Humidifier,Microwave,Oven,Range Hood,Refrigerator,Self Cleaning Oven,Tankless Water Heater,Warming Drawer,Washer,Wine Cooler
    • Building Class
    • Building Features
    • Ceiling Height
    • Common Walls
    • Exclusions Patio fridge, garage fridge & racks, Blink cameras, seller's personal property.
    • Flooring Laminate,Tile
    • Furnished
    • Interior Features Audio/Video Controls,Built-in Features,Ceiling Fan(s),Central Vacuum,Eat-in Kitchen,Entrance Foyer,Five Piece Bath,Granite Counters,Kitchen Island,Marble Counters,Open Floorplan,Pantry,Quartz Counters,Smart Thermostat,Smart Window Coverings,Smoke Free,Solid Surface Counters,Sound System,Spa/Hot Tub,Vaulted Ceiling(s),Walk-In Closet(s),Wet Bar
    • Laundry Availability In Unit
    • Security Features Carbon Monoxide Detector(s),Smart Security System,Smoke Detector(s)
    • Spa Features
    • Window Features Double Pane Windows

    Room Details

    Bathroom Details Total Bathrooms: 4
    Bathroom Location Details
    Bedroom Location Details Total Bedrooms: 3
    More Room Details

    Unit Information

    Summary

    • Number of Units
    • Number of Units Furnished
    • Number of Units Vacant
    • Unit Features
    Single Unit Details

    Exterior/Lot Features

    Summary

    • Available Elevations
    • Entry Location
    • Faces Northeast
    • Horse Amenities
    • Horse Property 0
    • Levels Two
    • Stories
    • Structure Type House
    • Unit Floor #
    • View Mountain(s)
    Builder Details
    • Builder
    •  
    • Completion Time From Groundbreaking
    • Model Type
    Construction details
    • Architecture Contemporary
    • Construction Materials Brick,Frame,Stucco
    • Foundation Details
    • Roof Composition
    Exterior Details
    • Dock Features
    • Door Features
    • Exterior Features Balcony,Dog Run,Fire Pit,Gas Grill,Gas Valve,Lighting,Private Yard,Rain Gutters,Smart Irrigation,Spa/Hot Tub
    • Fencing
    • Number of Docks
    • Number of Doors
    • Number of Storage Units
    • Other Equipment
    • Other Structures
    • Patio And Porch Features Covered,Deck,Front Porch,Patio,Rooftop
    • Pool Features
    • Ski Features
    Livable Structure Details
    Lot Details​​​​​​​
    • Acres Leased
    • Crop Acres
    • Cultivated Acres
    • Features Corner Lot,Cul-De-Sac,Irrigated,Landscaped,Level,Many Trees,Open Space,Sprinklers In Front,Sprinklers In Rear
    • Irrigated Acres
    • Lot Number
    • Lot Size Acres 2.38
    • Lot Size Dimensions
    • Lot Size SqFt 103,847
    • Sq Ft
    • Pasture Acres
    • Price Per Acre $777,310.92
    • Vegetation Aspen,Mixed,Xeriscaping
    • Waterfront Features
    Mobile Details
    • Make
    • Model
    • Body Type
    • Exterior Dimensions x
    • Skirt
    Outbuilding details
    Road details
    • Access Private Road,Shared
    • Road Responsibility Private Maintained Road
    • Road Surface Paved

    Parking/Garage

    Parking Space Summary

    • Parking Features 220 Volts,Concrete,Driveway-Heated,Exterior Access Door,Finished,Heated Garage,Insulated,Lighted,Oversized,Oversized Door,RV Garage,Storage
    • Total Parking Spaces 6
    • Garage Spaces
    • Total Carport Spaces
    • Total Offstreet Spaces 0
    • Total Reserved Spaces 0
    • Total RV Spaces 1
    Parking Space Details

    Utilities & Green Home Features

    Summary

    • Cooling Central Air,Other
    • Green Energy Efficient Appliances,Construction,HVAC,Insulation,Lighting,Windows
    • Heating Geothermal,Heat Pump,Natural Gas,Radiant
    • HVAC Description
    Green Ratings
    Power Production Details
    Sewer
    • Sewer Septic Tank
    • Sewer Fee
    • Sewer Tap Paid YN
    Utilities details
    • Electric Service 220 Volts
    • Gas Tap Fee
    • Gas Tap Paid YN
    • Utilities Cable Available,Electricity Connected,Natural Gas Connected
    Water / Well
    • Irrigation Source Ditch
    • Issued Well Permit Numbers
    • Water Available 1
    • Water Source Public
    • Well Type
    • Well Usage
    • Water Fees
    • Water Tap Paid? 1
    • Water/Mineral Rights Water Rights

    Association Information

    HOA Summary

    • Amenities Completed
    • Amenities Opening
    • Association Amenities
    • Association(s) Yes
    • HOA Fee Includes Capital Reserves,Irrigation Water,Road Maintenance,Snow Removal
    • Total Annual HOA Fees $2,116
    1st HOA
    • HOA Preserve at Lonetree
    • Type Professionally Managed
    • Fee $529.00 Quarterly
    • Phone (303) 482-2213
    • Total Annual Fee $2,116.00
    • Website
    2nd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $0.00
    • Website
    3rd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $0.00
    • Website
    Restrictions & Covenants
    • Pets Allowed Yes
    • Rentals Allowed
    • Restrictions Mobile/Manufactured Homes Not Allowed,Modular Homes Not Allowed,Other
    • Restrictions Other
    • Restrictions/Covenants? Yes

    Financial Considerations

    Summary

    • Cap Rate
    • Cap Rate Calculation
    Actual expense details
      Commission Information
      • Buyer Agency Compensation 2.80%
      • Transaction Broker Compensation 2.80%
      • Compensation Offered
      • Dual Variable Compensation No
      • Commission Modified
      • Closing Comments
      Income details
      • Actual Annual Net Income $
      • Gross Income $
      • Income Includes
      • Income Includes Description
      Landleasing details
      • Land Lease Amount
      • Land Lease Amount Frequency
      • Land Lease?
      Projected
      • Other Annual Income $
      • Potential Rental Income Annual $
      • Projected Annual Expense $
      • Projected Annual Net Income $
      • Projected Gross Income $
      • Projected Gross Operating Income $
      • Projected Gross Scheduled Income $
      • Vacancy Credit Losses
      Tax details
      • Annual Tax $8,227
      • Legal Description LOT 23, FARM AT BLUE MOUNTAIN MEADOW, AMD PLAT LOTS 1, 2, 4, 6 - 29, RESIDUAL LOTS A & B (20070077234)
      • Tax Exemptions
      • Tax ID R1626093
      • Tax Year 2019
      Other
      • Tenant Pays
      • Utilities Metering
      • Utilities Paid By Tenant

      Neighborhood

      Summary

      • Building Name
      • Development Name
      • Park Name
      • Senior Community No
      • Subdivision
      New Home Community
      • Community Description
      • Community MLS #
      • Community Name
      • Community Opening
      • Community Website
      • Current Promotions
      • Development Status
      • Directions from Agent From HWY 287 & West CR8, go west ~1.5 miles to CR21, turn right (north) on CR21 and travel 2 miles to CR10, turn left (west) on CR10 and take second right (north) onto Preserve Dr., home is on the SW corner of Preserve Dr. and Snowy Egret Lane.
      • Move In Date
      • New Home Available Options
      • New Home Land MLS #
      • New Home Plan MLS #
      Zoning Details
      • Current Use
      • Incorporated? No
      • Zoning FA1
      • Zoning Jurisdiction

      Other

      Business Details
      • Business Amenities
      • BusinessDescription
      • BusinessType
      • Year Established
      History
      • Original List Price $1,999,500
      Partial Ownership Details
      • Partial Ownership Amount
      • Week Remarks
      • Weeks Available
      Other
      • Home Warranty
      • Ownership Individual
      • Possession Closing/DOD
      • Special Listing Conditions None Known
      • Year Built 2015

      Mortgage Calculator

      School Zone

      District: Thompson R2-J
      Schools: Berthoud Elementary School, Berthoud High School, Turner Middle School

      Area Map

      Walk Score

      Bike Score

      Bike Score

      0 description
      Transit Score

      Transit Score

      0 description summary
      Walk Score

      Walk Score

      0 description
      Back to top
      span widget