On coveted Scottsdale Road in Heron Lakes with access to McNeal Reservoir. Move into this incredible community and start enjoying the lakes, pool, trails, golf and more by this summer. This spacious home on a corner lot boasts a very well thought-out floorplan for living and entertaining and high quality construction at every turn. Mountain views from several rooms. 5 bedrooms (plus a study) and a full bar / kitchenette in lower level, this home is great for entertaining visitors ready to enjoy the amenities at Heron Lakes. This stylish home features Viking appliances in Kitchen. Lower level includes a guest suite (2 bedrooms) plus an in-home gym space/theater or family room adjacent to recreation area with a fully appointed bar area. Heron Lakes is a world class community that is currently featured on HGTV's Rock The Block series. 8.5 miles of walking trails, 2 lakes (Lonetree Reservoir allows motorized boating and jet skis), a 30,000 sf clubhouse with several restaurants, work-out facilities, resort style pool (with swim up bar) plus TPC Colorado Golf Course (membership not required).
Open House
November 30 11:00 am - 2:00 pm
Offered By
Laura Gippert 9704821781, RE/MAX Alliance-FTC Dwtn
Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURES
Washer/Dryer Hookups, Main Level
FIREPLACE FEATURES
Electric, Living Room
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available
SEWER
City Sewer
WATER SOURCE
City Water, Town of Berthoud
Year Built
2023
Builder Name
Development Contractors
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
2607.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern, Ranch
Roof
Concrete
EXTERIOR FEATURES
Gas Grill, Lighting
Parking Features
Garage Door Opener, Oversized
Lot Features
Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Corner Lot, Level, Near Golf Course
Garage spaces
3
View
Mountain(s), Foothills View, Water
CITY
Berthoud
SUBDIVISION
Heron Lakes
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
6293.0
LATEST UPDATE
2024-11-12T20:11:19.096Z
DAYS ON MARKET
167
PRICE CHANGE(S)
$2,195,000 May 30, 2024
CUMULATIVE DAYS ON MARKET
590
Property Details
Property TypeResidential
StatusActive
Bedrooms5
Bathrooms (Full)4
Property Sub TypeResidential-Detached
Square Feet5,382
MLS #1010730
Bathrooms (Half)1
FlooringWood Floors
AppliancesGas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
LAUNDRY FEATURESWasher/Dryer Hookups, Main Level
FIREPLACE FEATURESElectric, Living Room
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Berthoud
Year Built2023
Builder NameDevelopment Contractors
BasementFull, Partially Finished
FINISHED BASEMENT SIZE2607.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLEContemporary/Modern, Ranch
RoofConcrete
EXTERIOR FEATURESGas Grill, Lighting
Parking FeaturesGarage Door Opener, Oversized
Lot FeaturesCurbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Corner Lot, Level, Near Golf Course
Garage spaces3
ViewMountain(s), Foothills View, Water
CITYBerthoud
SUBDIVISIONHeron Lakes
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESClubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails, Recreation Room, Gated
TAX AMOUNT6293.0
LATEST UPDATE2024-11-12T20:11:19.096Z
DAYS ON MARKET167
PRICE CHANGE(S)
$2,195,000 May 30, 2024
CUMULATIVE DAYS ON MARKET590
Open House
November 30 11:00 am - 2:00 pm
Market Trends
New Properties On Market
46
24%
Increase In New Listings
Average Asking Price
$804,043
$407,638 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$234
$168 Decrease In List Price/Sq. Ft.
Average Days On Market
17
16 Day
Decrease In Days On Market
Data as of Nov 15, 2024.
Remaining statistics above are calculated on activity within the period from Sep 01, 2024 to Oct 31, 2024.
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.