Rare model home opportunity with guaranteed income. This highly sought-after Willow plan is beautifully appointed and ideally positioned on a fully fenced, fully landscaped corner lot backing to open space, with stunning mountain views and abundant natural light throughout. The amazing upgrades elevate the home, highlighted by a statement fireplace, upgraded carpet, tile, and luxury vinyl plank flooring, soft-close cabinetry, upgraded hardware, and high-end appliances. The open, functional layout includes a spacious loft, a private office with French doors, and an expansive primary suite featuring an oversized walk-in closet. The kitchen is thoughtfully designed with a large walk-in pantry, premium soft-close cabinetry, high-end stainless steel appliances, and a seamless flow ideal for everyday living or entertaining. A deep two-car garage adds exceptional storage and convenience. This investor-friendly leaseback opportunity offers an estimated 8% cap rate with a builder-guaranteed leaseback for two years, followed by a month-to-month lease until neighborhood completion. Enjoy on-time rent payments, zero vacancy risk, weekly professional cleaning, and builder-managed maintenance, along with an additional investor rate incentive, providing true peace of mind and effortless ownership. Located in a desirable area with highly regarded schools, no HOA fees, and low metro taxes, this is a rare chance to own a premium model home that delivers long-term value, strong cash flow, and hands-off ownership.
Lot FeaturesCurbs, Gutters, Sidewalks, Lawn Sprinkler System, Water Rights Excluded, Mineral Rights Excluded, Abuts Public Open Space
Garage spaces2
ViewFoothills
CITYWindsor
SUBDIVISIONTrevenna
COUNTYWeld
AREAGreeley/Weld
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPark, Hiking/Biking Trails
TAX AMOUNT7499.0
LATEST UPDATE2026-01-27T13:03:51.259Z
DAYS ON MARKET38
PRICE CHANGE(S)
$749,990 Dec 22, 2025
$724,990 Jan 23, 2026
CUMULATIVE DAYS ON MARKET38
Open House
January 28 11:00 am - 5:00 pm
Market Trends
New Properties On Market
45
13%
Decrease In New Listings
Average Asking Price
$608,621
$113,130 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$207
$21 Decrease In List Price/Sq. Ft.
Average Days On Market
29
16 Day
Decrease In Days On Market
Data as of Jan 27, 2026.
Remaining statistics above are calculated on activity within the period from Nov 01, 2025 to Dec 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.