Welcome to 590 Noola St! Discover a standout opportunity in the Trevenna community with the Silverthorne model, offering a thoughtful blend of design, comfort, and long-term potential. This beautifully finished ranch-style home showcases an open and inviting layout, highlighted by a tray ceiling with natural wood beams, a striking electric fireplace, and a well-appointed kitchen designed for both everyday living and entertaining. The main living spaces flow seamlessly, creating a warm and functional environment, while the overall design emphasizes ease and livability throughout. High-end finishes and intentional details give the home a polished, elevated feel from the moment you step inside. This property also presents a unique investment opportunity, featuring a builder leaseback in place that provides consistent income and professional upkeep. With no HOA, low metro taxes, and a low-maintenance setup, ownership is both simple and efficient. Whether you are looking to expand your portfolio or secure a beautifully designed home with strong upside, 590 Noola St offers a compelling combination of style, simplicity, and opportunity.
Electric Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Electric, Great Room
Heating
Forced Air
Cooling
Central Air
Utility Features
Electricity Available, High Speed Avail
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2025
Builder Name
Dream Finders Homes
Basement
None, Crawl Space, Built-In Radon
FINISHED BASEMENT SIZE
0.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Sprinkler System, >8' Garage Door
Parking Features
Garage Door Opener, Attached
Fence
Fenced, Wood
Lot Features
Abuts Ditch, Abuts Public Open Space, House Faces East, City Limits, Paved, Curbs, Gutters, Sidewalks, Street Light, Water Rights Excluded, Mineral Rights Excluded
Garage spaces
2
View
Mountain(s), Hills
CITY
Windsor
SUBDIVISION
Trevenna
COUNTY
Weld
AREA
Greeley/Weld
STATE
CO
COMMUNITY FEATURES
Park, Trail(s)
TAX AMOUNT
6499.0
LATEST UPDATE
2026-04-16T02:10:29.875Z
DAYS ON MARKET
3
PRICE CHANGE(S)
$574,990 Apr 13, 2026
Property Details
Property TypeResidential
StatusActive
Bedrooms3
Bathrooms (Full)1
Property Sub TypeSingle Family Residence
Square Feet1,894
MLS #1056359
Bathrooms (¾)1
AppliancesElectric Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURESElectric, Great Room
HeatingForced Air
CoolingCentral Air
Utility FeaturesElectricity Available, High Speed Avail
SEWERPublic Sewer
WATER SOURCECity
Year Built2025
Builder NameDream Finders Homes
BasementNone, Crawl Space, Built-In Radon
FINISHED BASEMENT SIZE0.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
ARCHITECTURAL STYLEContemporary/Modern
RoofComposition
EXTERIOR FEATURESSprinkler System, >8' Garage Door
Parking FeaturesGarage Door Opener, Attached
FenceFenced, Wood
Lot FeaturesAbuts Ditch, Abuts Public Open Space, House Faces East, City Limits, Paved, Curbs, Gutters, Sidewalks, Street Light, Water Rights Excluded, Mineral Rights Excluded
Garage spaces2
ViewMountain(s), Hills
CITYWindsor
SUBDIVISIONTrevenna
COUNTYWeld
AREAGreeley/Weld
STATECO
COMMUNITY FEATURESPark, Trail(s)
TAX AMOUNT6499.0
LATEST UPDATE2026-04-16T02:10:29.875Z
DAYS ON MARKET3
PRICE CHANGE(S)
$574,990 Apr 13, 2026
Market Trends
New Properties On Market
126
Average Asking Price
$722,568
Average Asking Price / Sq. Ft.
$245
Average Days On Market
29
Data as of Apr 29, 2026.
Remaining statistics above are calculated on activity within the period from Mar 01, 2026 to Mar 31, 2026.
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.