Date
Details
Price
Change
Source
1/31/2019
Sold
$538,684
—
Public Record
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/35
$649,900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/35
Property Description
Better-than-new and built for those who crave industrial-style living, this Frederick loft home pairs a show-stopping garage with a bright, modern upper-level living space. Downstairs, the 6+ car heated and insulated garage features tall ceilings, glass garage doors, and three 50-amp outlets-a true haven for collectors, creators, or anyone who needs serious power and space. Upstairs, the loft-style layout showcases exposed metal beams, belt-driven ceiling fans, big windows, and an airy, open feel. The kitchen is equipped with an industrial Thermador stove and dishwasher, Frigidaire Professional refrigerator and freezer, and a large island perfect for cooking or gathering. Mountain views complete the elevated living experience. Outside, you'll find a roomy covered patio space for entertaining and a 14×16 shed adds even more storage and flexibility to this one-of-a-kind property.
Full Property Details
Full Property Details for 204 Pinyon St
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Price: $649,900
- Taxes: $4,145 (2025)
- Status: Under Contract
- Type: Single Family
- Source: MetroList_Colorado
- MLS ID: 2428529
- Updated: 7/7/2026
- Added to Site: 29 day(s) ago
Interior
- Appliances: Dishwasher, Disposal, Double Oven, Microwave, Range Hood, Refrigerator
- Flooring: Carpet, Vinyl
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
Bedrooms
- Total Bedrooms: 2
Exterior
- Exterior Features: Balcony, Private Yard
- Porch/Patio/Deck: Patio
Parking
- Garage: Yes
- Garage Spaces: 6
- Total Spaces: 6
- Parking Features: 220 Volts, Heated Garage, Oversized
Location
- County: Weld
- Subdivision: Maplewood
School Information
- Elem School District: St. Vrain Valley RE-1J
- Midd School District: St. Vrain Valley RE-1J
- High School District: St. Vrain Valley RE-1J
- Elementary School: Thunder Valley
- Middle School: Coal Ridge
- High School: Frederick
Community
- Pets Allowed: Yes
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Forced Air
Utilities
- Gas: Yes
- Sewer: Public Sewer
- Water: Public
- Utility Description: Electricity Connected, Natural Gas Connected
Structural Information
- Architectural Style: Urban Contemporary
- Structure Type: House
- Construction: Brick, Metal Siding, Stucco
- Roof: Composition, Metal
- Square Feet: 1,820
- Sq. Ft. Source: Public Records
- Living Area: 1,820 Sq. Ft.
- Year Built: 2018
Lot Features
- Lot Size (Acres): 0.15
- Lot Size (Sq. Ft.): 6,534
- Fence: Yes
- Zoning: RES
- Fencing (Description): Full
Financial Considerations
- Tax Amount: $4,145
- Tax Year: 2025
- Terms: Cash, Conventional, VA Loan
Disclosures and Reports
- Ownership: Individual
- Special Conditions: None
- Legal Description: FRE 5MS L3 BLK2 MAPLEWOOD FG 5
- Exclusions: washer, dryer, personal belongings
- Property ID: R1004501
Listed by Fathom Realty Colorado LLC
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 204 Pinyon St —
Fathom Realty Colorado LLC
eric@yourwayhome.com,303-819-8622
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 204 Pinyon St
School District:St. Vrain Valley School District Re 1j
| Name | Grades | Distance |
|---|---|---|
Thunder Valley PK-8 555 Eighth Street, Frederick, CO 80530 | PK-8 | 0.4 mi |
Frederick Senior High School 5960 Tipple Parkway, Frederick, CO 80504 | 9-12 | 1 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 204 Pinyon St
Tax History
Tax History for 204 Pinyon St
Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,145
—
$36,250
-2%
2025
$4,145
10%
$37,020
-7%
2024
$3,760
4%
$39,790
-1%
2023
$3,606
16%
$40,180
32%
2021
$3,110
1%
$30,370
3%
2022
$3,080
-9%
$29,520
-12%
2020
$3,403
106%
$33,490
109%
2019
$1,650
15%
$16,000
11%
2018
$1,432
4%
$14,420
6%
2017
$1,379
278%
$13,580
284%
2016
$365
8%
$3,540
4%
2015
$339
62%
$3,390
62%
2014
$209
2%
$2,090
3%
2013
$205
—
$2,030
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 204 Pinyon St
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 12 days ago
- 2Beds
- 3Total Baths
- 1,405Sq. Ft.
- MLS # 1062867
Listed by eXp Realty LLC
- Single Family
- Active
- 3Beds
- 3Total Baths
- 1,953Sq. Ft.
- MLS # 1061959
Listed by Better Blueprint Realty
- Single Family
- Active
- 3Beds
- 3Total Baths
- 2,193Sq. Ft.
- MLS # 7039650
Listed by Keller Williams DTC
- Single Family
- Active
- Updated 17 hours ago
- 3Beds
- 3Total Baths
- 2,366Sq. Ft.
- MLS # 1062588
Listed by LIV Sotheby's Intl Realty
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 2Total Baths
- 1,497Sq. Ft.
- MLS # 1063595
Listed by Chum Tran (303) 931-4012
- Single Family
- Active
- Updated 3 hours ago
- 3Beds
- 2Total Baths
- 1,411Sq. Ft.
- MLS # 1063661
Listed by Real Realty Colorado
- Single Family
- Active
- Updated 2 days ago
- 6Beds
- 4Total Baths
- 4,374Sq. Ft.
- MLS # 1063546
Listed by Compass - Boulder
- Mobile Home
- Active
- Updated 1 hour ago
- 2Beds
- 1Total Bath
- 672Sq. Ft.
- MLS # 6924
Listed by RE/MAX Town and Country
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 5Total Baths
- 6,162Sq. Ft.
- MLS # 1056238
Listed by Boulder Financial Realty Inc
- Townhouse
- Active
- Updated 5 days ago
- 5Beds
- 4Total Baths
- 2,382Sq. Ft.
- MLS # 5198889
Listed by Your Castle Real Estate Inc
- Single Family
- Active
- Updated 4 days ago
- 6Beds
- 10Total Baths
- 22,454Sq. Ft.
- MLS # 7329670
Listed by Madison & Company Properties
- Single Family
- Active
- Updated 2 days ago
- 1Bed
- 1Total Bath
- 512Sq. Ft.
- MLS # 1060873
Listed by Compass - Boulder
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 4Beds
- 3Total Baths
- 3,107Sq. Ft.
- MLS # 1055269
Listed by RE/MAX of Boulder, Inc
Sold by RE/MAX Nexus
Sold by RE/MAX Nexus
- Single Family
- Closed
- Updated 2 days ago
- 5Beds
- 3Total Baths
- 2,981Sq. Ft.
- MLS # 5017827
Listed by Dylan Lario
Sold by Keller Williams Realty Downtown LLC
Sold by Keller Williams Realty Downtown LLC
- Single Family
- Closed
- 5Beds
- 3Total Baths
- 3,191Sq. Ft.
- MLS # 1040647
Listed by Group Centerra
Sold by Non-IRES
Sold by Non-IRES
- Single Family
- Closed
- 3Beds
- 3Total Baths
- 3,642Sq. Ft.
- MLS # 1055406
Listed by Better Blueprint Realty
Sold by Non-IRES
Sold by Non-IRES
204 Pinyon Street, Frederick, CO 80530 (MLS# 2428529) is a Single Family property with 2 bedrooms and 2 full bathrooms. 204 Pinyon Street is currently listed for $649,900 and was received on June 12, 2026. Want to learn more about 204 Pinyon Street? Do you have questions about finding other Single Family real estate for sale in Frederick? You can browse all Frederick real estate or contact a Coldwell Banker agent to request more information.