3191 Sparrow Hawk Lane Unit

See all 40 Photos
Virtual Tour Sold Berthoud, CO 80513 MLS# IR947441 Sold by TRELORA Team on 09/02/2021
$1,550,000
Email
Facebook
Twitter
Pinterest
WhatsApp
Single Family Property Type
4 Bedroom
4 Bathroom
4 Garage
6434.00 Sq Ft
2.29 Acres
2007 Year Built

Overview

MOUNTAIN VIEWS! Welcome to peaceful living in Berthoud. Your future custom home sits on private 2.3 acres with established landscape, gardens, and fruit orchard! Ranch-style home offers 10-ft ceilings, maple hardwood floors, designer lighting, and custom built-ins throughout. Unwind on the porches, relax in the outdoor hot tub after a long day, and entertain friends around the built-in gas grill! Great Room has gas fireplace, and opens to the eat-in kitchen. Kitchen features granite-slab countertops and custom Alder cabinetry, center island with prep station, additional seating, and gorgeous Mountain Views. Primary bedroom features private5-piece bathroom with deep soak tub and walk-in closet. Brand new partially-finished basement has 9-ft ceilings, huge Rec Room w/ full wet bar, and bonus concrete storm shelter. HOA owns shares in irrigation water for the summer months! Not in the metro tax area! Mins away from new TPC Golf Course, and partial Lake View! Fiber Optic coming soon!

New Home Sales Hours

Courtesy Of TRELORA Realty
Source: IRES

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

    Interior Features

    Summary

    • Year Built Effective
    Basement Details
    • Basement? No
    • Basement
    • Basement Ceiling Height
    Fireplace Detail
    • Fireplace Features Family Room,Gas
    • No. of Fireplaces
    Square Foot Details
    • SqFt 6,434
    • Living Area, Finished 4,748
    • Above grade, Finished 3,217
    • Basement, Finished 1,531
    • Basement, Unfinished 1,686
    • PSF Total $
    • PSF Finished $326.45
    • PSF Above Grade $481.82
    Use details
    • Leaseable Area
    • Office Area
    • Retail Area
    • Warehouse Area
    Other
    • Accessibility Features
    • Appliances Bar Fridge,Dishwasher,Disposal,Dryer,Microwave,Oven,Refrigerator,Washer
    • Building Class
    • Building Features
    • Ceiling Height
    • Common Walls
    • Exclusions personal property, sauna (negotiable). Internet satellite dish and the direct tv satellite dish
    • Flooring Tile
    • Furnished
    • Interior Features Eat-in Kitchen,Five Piece Bath,Kitchen Island,Vaulted Ceiling(s),Walk-In Closet(s),Wet Bar
    • Laundry Availability In Unit
    • Security Features
    • Spa Features
    • Window Features

    Room Details

    Bathroom Details Total Bathrooms: 4
    Bathroom Location Details
    Bedroom Location Details Total Bedrooms: 4
    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
    • Horse Amenities
    • Horse Property
    • Levels One
    • Stories
    • Structure Type House
    • Unit Floor #
    • View Mountain(s),Water
    Builder Details
    • Builder
    •  
    • Completion Time From Groundbreaking
    • Model Type
    Construction details
    • Architecture
    • Construction Materials Wood Frame,Wood Siding
    • Foundation Details
    • Roof Composition
    Exterior Details
    • Dock Features
    • Door Features
    • Exterior Features Spa/Hot Tub
    • Fencing
    • Number of Docks
    • Number of Doors
    • Number of Storage Units
    • Other Equipment
    • Other Structures
    • Patio And Porch Features Deck,Patio
    • Pool Features
    • Ski Features
    Livable Structure Details
    Lot Details​​​​​​​
    • Acres Leased
    • Crop Acres
    • Cultivated Acres
    • Features
    • Irrigated Acres
    • Lot Number
    • Lot Size Acres 2.29
    • Lot Size Dimensions
    • Lot Size SqFt 99,622
    • Sq Ft
    • Pasture Acres
    • Price Per Acre $676,855.90
    • Vegetation
    • Waterfront Features
    Mobile Details
    • Make
    • Model
    • Body Type
    • Exterior Dimensions x
    • Skirt
    Outbuilding details
    Road details
    • Access
    • Road Responsibility
    • Road Surface Paved

    Parking/Garage

    Parking Space Summary

    Parking Features

    • Total Parking Spaces 4
    • Garage Spaces
    • Total Carport Spaces
    • Total Offstreet Spaces
    • Total Reserved Spaces
    • Total RV Spaces
    Parking Space Details

    Utilities & Green Home Features

    Summary

    • Cooling Central Air
    • Green Energy Efficient
    • Heating Forced Air
    • HVAC Description Central Air Conditioning
    Green Ratings
    Power Production Details
    Sewer
    • Sewer Public Sewer
    • Sewer Fee
    • Sewer Tap Paid YN 0
    Utilities details
    • Electric Service
    • Gas Tap Fee
    • Gas Tap Paid YN
    • Utilities Cable Available,Electricity Available,Internet Access (Wired),Natural Gas Available
    Water / Well
    • Irrigation Source
    • Issued Well Permit Numbers
    • Water Available
    • Water Source Public
    • Well Type
    • Well Usage
    • Water Fees
    • Water Tap Paid? 0
    • Water/Mineral Rights

    Association Information

    HOA Summary

    • Amenities Completed
    • Amenities Opening
    • Association Amenities
    • Association(s) No
    • HOA Fee Includes
    • Total Annual HOA Fees $2,106.84
    1st HOA
    • HOA The Preserve
    • Type
    • Fee $526.71 Quarterly
    • Phone (303) 482-2213
    • Total Annual Fee $2,106.84
    • Website advancehoa.com
    2nd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $
    • Website
    3rd HOA
    • HOA
    • Type
    • Fee $
    • Phone
    • Total Annual Fee $
    • Website
    Restrictions & Covenants
    • Pets Allowed
    • Rentals Allowed
    • Restrictions
    • Restrictions Other
    • Restrictions/Covenants? No

    Financial Considerations

    Summary

    • Cap Rate
    • Cap Rate Calculation
    Actual expense details
    • Annual Expenses Benefits
    • Annual Water Expense $
    • Association Fee Annual Expense $
    • Cable TV Expense $
    • CAM Fees $
    • Electric Expense $
    • Gas Expense $
    • Insurance Expense $
    • Internet Annual Expense $
    • Maintenance Expense $
    • Operating Expense $
    • Operating Expense Includes
    • Other Expense
    • Payroll Annual Expense $
    • Personal Property Annual Expense $
    • Phone Annual Expense $
    • Professional Management Expense $
    • Real Estate Taxes $
    • Workmans Compensation Expense
    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 $
    • Vacancy Credit Losses
    Tax details
    • Annual Tax $6,077
    • Legal Description LOT 3, FARM AT BLUE MOUNTAIN MEADOW, THE, (20030089414)
    • Tax Exemptions
    • Tax ID R1626073
    • Tax Year 2020
    Other
    • Tenant Pays
    • Utilities Metering
    • Utilities Paid By Tenant

    Neighborhood

    Summary

    • Building Name
    • Development Name
    • Park Name
    • Senior Community No
    • Subdivision Farm At Blue Mountain Meadow
    New Home Community
    • Community Description
    • Community MLS #
    • Community Name
    • Community Opening
    • Community Website
    • Current Promotions
    • Development Status
    • Directions from Agent
    • Move In Date
    • New Home Available Options
    • New Home Land MLS #
    • New Home Plan MLS #
    Zoning Details
    • Current Use
    • Incorporated? No
    • Zoning R1626073
    • Zoning Jurisdiction

    Other

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

    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