**PAID SOLAR + 5.25% ASSUMABLE VA LOAN** This elevated, cul-de-sac home offers over 4,000 sq. ft. of modern living with a walk-out basement, stunning Rocky Mountain views, and top-tier finishes throughout. Say goodbye to blackouts and high energy bills with a fully paid 10 kW solar + 51 kWh battery **microgrid system**-complete with generator-ready capability.Inside, enjoy hardwood floors, granite counters, a large island, double ovens, and a gas-stubbed 5-burner cooktop. The main and upper floors include 4 spacious bedrooms, a loft, and upstairs laundry. The luxurious primary suite features panoramic views, spa-like bath, and a walk-in closet.Additional highlights: insulated/heated 3-car garage, electric pet door, whole-house humidifier, active radon system, and a basement ready to finish. Located just 4 miles from TPC Colorado Golf Course-don't miss this rare opportunity for energy-efficient luxury living with an assumable low-rate VA loan!
Offered By
Philip Apodaca 7202027158, Coldwell Banker Realty 02
Parking FeaturesGarage Door Opener, Heated Garage, Oversized
FenceFenced, Wood
Lot FeaturesGutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Sloped
Garage spaces3
ViewMountain(s), Foothills View, Plains View
CITYBerthoud
SUBDIVISIONROSE FARM ACRES
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPlayground, Park, Hiking/Biking Trails
HOA1
TAX AMOUNT4528.0
HOA FEE97.5
HOA FREQUENCYMonthly
LATEST UPDATE2025-06-27T19:26:03.158Z
DAYS ON MARKET113
PRICE CHANGE(S)
$855,000 Mar 7, 2025
$849,000 Apr 21, 2025
CUMULATIVE DAYS ON MARKET113
Market Trends
New Properties On Market
74
35%
Increase In New Listings
Average Asking Price
$964,335
$136,105 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$279
$50 Decrease In List Price/Sq. Ft.
Average Days On Market
5
20 Day
Decrease In Days On Market
Data as of Jul 05, 2025.
Remaining statistics above are calculated on activity within the period from May 01, 2025 to Jun 30, 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.