For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Berthoud 80537
2354 Sugarloaf Road
$2,050,000
● House - Off Market

2354 Sugarloaf Road

Berthoud, CO 80513
bedrooms
4 Beds
bathrooms
5 Baths, 2 Half Baths
square feet
3,935 Ft²
$2,202,271
RealtyHop Estimate
0.10%
Since Oct 1, 2022
CO-Denver
Primary Model

About This Property

WELCOME HOME! This beautiful custom home located on the 9th hole of the TPC Golf Course features an open floor plan and luxurious upgrades sure to impress. Over-sized great room, gourmet kitchen, contemporary Montego fireplace, whole house humidifier, whole house audio and an upgraded garage with boat storage are just a few of the added features that make this home one of a kind. Control4 smart home also allows remote access to music, garage doors, thermostats, front door camera and surveillance cameras. The expansive backyard boasts direct views of the mountains, lake and course. This is Colorado living at its finest!
Unit Size
3,935 Ft²
Days on Market
-
Land Size
0.37 acres
Price per sqft
$559
Property Type
House
Property Taxes
-
HOA Dues
-
Year Built
2019

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 3 years ago (REcolorado MLS #RECIR968944)

Price History

Date / Event Date Event Price
Sep 22, 2022 Sold
Premium
Sold
Jun 14, 2022 Listed by Porchlight RE Group-Boulder $2,200,000
Listed by Porchlight RE Group-Boulder
Apr 17, 2020 Sold
Premium
Sold

Property Highlights

Air Conditioning
Fireplace
With View
Garage

Building Info

Overview

    General

  • Year Built: 2019
  • Effective Year Built: 2019
  • Building Count: 1
  • Total Rooms: 11
  • Bedroom Count: 4
  • Bathroom Count: 5
  • Full Bathrooms: 5
  • Partial Bathrooms: 5
  • Building Condition: 6
  • Building Quality: 1
  • Construction Type: 0
  • Building Style: 11
  • Exterior Walls Type: 23
  • Interior Walls Type: 0
  • Roof Shape Type: 8
  • Roof Cover Type: 4
  • Floor Count: 100
  • Floor Cover: 0
  • Basement Type: 6
  • Basement Area: 1,262
  • Garage Type: 1
  • Garage Square Area: 971
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 31
  • Pool Type: 0
  • Location Influence Type: 101

    Dimensions

  • Lot Size Square Feet: 16,037
  • Total Building Area: 5,085
  • Gross Building Area: 5,085
  • Building Area: 3,916
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 3,916
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: HERON LAKES 3RD FILING
  • Land Acres: 0000000368
  • Standard Land Use Code: 1001
  • County Land Use Code: 1219L
  • Legal Description 1: LOT 12, BLOCK 1, HERON LAKES THIRD FILING, BER (20160036869)

Neighborhood

  • School District Name: Thompson School District R-2J
  • Census Tract: 002602

Geography

  • Assessors Map Reference: 94041
  • Account Number: R1661619
  • Parcel: R1661619
  • Block: 1
  • Lot: 12
  • Meridian: SEC 4 TWN 4N RNG 69W
  • Municipality: BERTHOUD
  • Latitude: 40.3427
  • Longitude: -105.115

    Address

  • Full Address: 2354 Sugarloaf Rd
  • Address - House Number: 2354
  • Address - Street Name: Sugarloaf
  • Address - Suffix Type: Rd
  • State: CO
  • City Name: Berthoud
  • Carrier Code: R012
  • 4-Digit Zip Code: 9548
  • Zip Code: 80513

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $1,609,991
  • Tax Rate Code Area: 2403

    Appraisal Valuation

  • Standard Deviation: 0.0581
  • Valuation Date: Mar 20, 2024
  • Confidence Score: 98
  • Final Value: 2,180,602
  • High Value: 2,307,415
  • Low Value: 2,053,789

    Market Valuation

  • Market Total Value: $1,460,400
  • Market Land Value: $267,300
  • Market Improvement Value: $1,193,100

    Assessments Valuation

  • Assessed Year: 2024
  • Assessed Total Value: $97,847
  • Assessed Land Value: $17,909
  • Assessed Improvements Value: $79,938

    Sales

  • Current Sale Contract Date: Apr 17, 2020
  • Current Sale Recording Date: Apr 17, 2020
  • Current Sale Price:
    Premium
  • Current Sale Document Type: 68
  • Current Sale Input Document Number: 20200026583

    Financing

  • First Mortgage Financing Type: VAR
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Berthoud

Stats & Trends

Median Asking:

$599,990

Sale Price/ft²

$276

Below Asking

0.02%

Average Days on Market

64

Average Home Size

2690 ft²

Average Home Age

9.4 years

Currently For Sale

227 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Rentals Near You

Click here to view more rentals in the neighborhood.

Frequently Asked Questions

When was property at 2354 Sugarloaf Road built and last sold?
The property at 2354 Sugarloaf Road was built in 2019 and last sold on Apr 17, 2020 for $1,462,074.
How much is this home worth?
The estimated value of the home located at 2354 Sugarloaf Road is $2,165,216.
What are some comparable homes to 2354 Sugarloaf Road?
There are currently no comparable homes to 2354 Sugarloaf Road.
Recent Neighborhood News
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
The Current Status of iBuying in 2026: What To Know
Popular Searches
Larimer Homes for Sale
Larimer Houses for Sale
Larimer Condos for Sale
Larimer Townhouses for Sale
Larimer Multifamily for Sale
Larimer Land for Sale
Larimer Commercial for Sale
Larimer Homes with Basements
Nearby Cities
Denver Homes for Sale
Fort Collins Homes for Sale
Aurora Homes for Sale
Boulder Homes for Sale
Greeley Homes for Sale
Loveland Homes for Sale
Longmont Homes for Sale
Windsor Homes for Sale
Nearby Property Records
Larimer County, CO Property Records
Boulder County, CO Property Records
Grand County, CO Property Records
Weld County, CO Property Records
Gilpin County, CO Property Records
Broomfield County, CO Property Records
Laramie County, WY Property Records
Albany County, WY Property Records
Neighborhoods
Glenwood Grove - North Iris Real Estate
Stapleton Real Estate
Baseline Sub Real Estate
Park Hill Real Estate
Whittier Real Estate
Hampden Real Estate
West Colfax Real Estate
Windsor Real Estate
Nearby Counties
Weld Homes for Sale
Boulder Homes for Sale
Denver Homes for Sale
Arapahoe Homes for Sale
Jefferson Homes for Sale
Adams Homes for Sale
Laramie Homes for Sale
Broomfield Homes for Sale
Top Real Estate Agents
Top Agents in Larimer
Top Agents in Weld
Top Agents in Boulder
Top Agents in Denver
Top Agents in Denver
Top Agents in Arapahoe
Top Agents in Jefferson
Top Agents in Adams