Come to the Parade of Homes Sept 12 - 14 from 10 - 5. This stunning custom residence, to be crafted by the locally renowned Custom On-Site Builders, will stand proudly in the prestigious Heron Lakes community. A corner lot boasting a spacious open ranch floorplan, the home also includes an upper loft-complete with a private balcony. This home is slated to be entered into the Parade of Homes and will include an array of premium finishes, with the opportunity to customize still available. On the main floor, 10-foot ceilings soar above an expansive living area, seamlessly flowing into the gourmet kitchen. Here, you'll find Cafe appliances, a gas cooktop, a hidden pantry with extra fridge, quartzite countertops, custom cabinetry with appliance garages, and an oversized island-ideal for casual gatherings. The adjacent living room centers on a dramatic floor-to-ceiling stone fireplace, while oversized windows flood the space with natural light. Step out to a large, covered patio, where stamped and colored concrete meets elegant timber accents. Descend to the lower level for another layer of class in entertaining. A wet bar-including custom shelving, icemaker and more-can imbue your favorite hang-out aesthetic. A second fireplace adds to the perfect cozy vibes for relaxing. Included are two additional bedrooms, and a three-quarter bath. Residents of Heron Lakes enjoy exclusive access to an array of upscale amenities. Unwind by the seasonal resort-style pool, which features a swim-up bar and cabana kitchen, or host events in the elegant clubhouse dining and event spaces. Stay active in the state-of-the-art fitness center, complete with group classes and massage services. Golf enthusiasts can opt for unlimited membership, while boating aficionados will appreciate the private lake privileges. Expertly designed, and full landscaping completes this exceptional offering.
Open House
September 12 10:00 am - 5:00 pm
Offered By
Jace Thorpe 9702139394, Better Homes and Gardens Real Estate - Neuhaus
Gas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURES
Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
2+ Fireplaces, Gas, Gas Logs Included, Family/Recreation Room Fireplace, Great Room
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s), Ductless
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2025
Builder Name
Custom On-Site Builders
Basement
Full, Partially Finished, Sump Pump
FINISHED BASEMENT SIZE
1880.0
NEW CONSTRUCTION
1
FOUNDATION
Slab
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern, Ranch
Roof
Tile, Rubber
EXTERIOR FEATURES
Lighting, Balcony
Parking Features
Oversized
Fence
Partial, Metal Post Fence
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Corner Lot, Level
Garage spaces
3
View
Foothills View, City
CITY
Berthoud
SUBDIVISION
Heron Lakes 3rd Filing
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
SENIOR COMMUNITY
No
COMMUNITY FEATURES
Clubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails, Recreation Room, Gated
TAX AMOUNT
3614.0
LATEST UPDATE
2025-09-09T22:05:49.913Z
DAYS ON MARKET
7
PRICE CHANGE(S)
$1,825,120 Sep 3, 2025
CUMULATIVE DAYS ON MARKET
443
Property Details
Property TypeResidential
StatusActive
Bedrooms4
Bathrooms (Full)3
Property Sub TypeResidential-Detached
Square Feet4,303
MLS #1042774
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURES2+ Fireplaces, Gas, Gas Logs Included, Family/Recreation Room Fireplace, Great Room
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s), Ductless
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2025
Builder NameCustom On-Site Builders
BasementFull, Partially Finished, Sump Pump
FINISHED BASEMENT SIZE1880.0
NEW CONSTRUCTION1
FOUNDATIONSlab
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofTile, Rubber
EXTERIOR FEATURESLighting, Balcony
Parking FeaturesOversized
FencePartial, Metal Post Fence
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Corner Lot, Level
Garage spaces3
ViewFoothills View, City
CITYBerthoud
SUBDIVISIONHeron Lakes 3rd Filing
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails, Recreation Room, Gated
TAX AMOUNT3614.0
LATEST UPDATE2025-09-09T22:05:49.913Z
DAYS ON MARKET7
PRICE CHANGE(S)
$1,825,120 Sep 3, 2025
CUMULATIVE DAYS ON MARKET443
Open House
September 12 10:00 am - 5:00 pm
Market Trends
New Properties On Market
39
8%
Increase In New Listings
Average Asking Price
$866,874
$8,269 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$235
$6 Decrease In List Price/Sq. Ft.
Average Days On Market
11
26 Day
Decrease In Days On Market
Data as of Sep 09, 2025.
Remaining statistics above are calculated on activity within the period from Jul 01, 2025 to Aug 31, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.