Welcome to 154 Sycamore Avenue, a stunning property nestled in Johnstown's desirable Clearview Subdivision. Step inside to discover new luxury vinyl plank flooring that enhances the main level, complemented by thoughtful updates throughout. The permitted finished basement boasts a spacious recreation room and a stylish 3/4 bathroom, adding flexibility and comfort. Upstairs, you'll find three inviting bedrooms, including a luxurious primary suite that offers a serene retreat. The kitchen is equipped with high-end appliances, making cooking a pleasure. An oversized tandem garage provides ample storage and workspace. Enjoy breathtaking views of open farmland and the Rocky Mountains from your elevated deck, perfect for outdoor gatherings or quiet moments. Additional benefits include new Anderson windows and radon mitigation system.
Utility FeaturesNatural Gas Available, Electricity Available, High Speed Avail
SEWERPublic Sewer
WATER SOURCECity
Year Built2013
BasementFull, Partially Finished
FINISHED BASEMENT SIZE760.0
RoofComposition
EXTERIOR FEATURESSprinkler System, Tandem Garage
Parking FeaturesAttached
FenceFenced
Lot FeaturesAbuts Private Open Space, Paved, Curbs, Gutters, Sidewalks
Garage spaces3
ViewMountain(s)
CITYJohnstown
SUBDIVISIONClearview
COUNTYWeld
AREAGreeley/Weld
STATECO
HOA1
TAX AMOUNT2767.0
HOA FEE275.0
HOA FREQUENCYAnnually
LATEST UPDATE2026-03-13T15:31:39.440Z
DAYS ON MARKET5
PRICE CHANGE(S)
$525,000 Mar 13, 2026
Market Trends
New Properties On Market
66
3%
Decrease In New Listings
Average Asking Price
$490,089
$71,662 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$226
$11 Decrease In List Price/Sq. Ft.
Average Days On Market
12
27 Day
Decrease In Days On Market
Data as of Mar 14, 2026.
Remaining statistics above are calculated on activity within the period from Jan 01, 2026 to Feb 28, 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.