Property
ActiveResidential
1/39
$635,000

9020 Sandpiper Drive

Longmont, CO 80504
4
Beds
3
Baths
3,107
SqFt
0.16
Acres
RECOLORADO
#5493360
Updated: Jun 18, 2026, 4:45am

Property Description

Rare opportunity in Frederick offering NO HOA, NO METRO DISTRICT, and approx. 75-ft RV/boat parking - a truly hard-to-find combination!! Thoughtfully updated and beautifully maintained, this home blends everyday functionality with elevated finishes throughout.

The kitchen has been tastefully refreshed with new quartz countertops, stainless steel appliances, and clean, modern finishes that carry seamlessly through the home with newer flooring, lighting, and interior/exterior paint. The main level flows comfortably for both daily living and entertaining.

Upstairs, the spacious primary suite serves as a true retreat with dual closets and a 5-piece en suite bath. Three additional bedrooms and a full bath provide flexibility for guests, work-from-home needs, or growing households. The unfinished basement with a bathroom rough-in presents an excellent opportunity to expand, whether you envision additional living space, a home gym, media room, or a custom layout tailored to your needs - the possibilities are endless!

Outside, the backyard is both functional and inviting, featuring a concrete patio, gazebo, storage shed, and of course a dog door - perfect for enjoying Colorado evenings and creating your own outdoor oasis. The extended RV/boat parking area is 75 feet long and features a 30 amp plug in. Park your trailers, toys, or additional vehicles! A new roof in 2018 and new water heater in 2026 adds peace of mind. Kitchen appliances are a year old.

Ideally located with easy access to Boulder while maintaining a quiet, residential feel, and just minutes from shopping, dining, and well regarded schools.

Preferred lender offering a 1% permanent interest rate buy-down - contact listing agent for details! The home is available to be purchased fully furnished. Please inquire for additional information.
Included Appliances
DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher

Property Details

Interior
Above Grade Finished Area
2195
Appliances
DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher
Basement
Bath/StubbedUnfinished
Below Grade Unfinished Area
912
Building Area Total
3107
Cooling
Central Air
Flooring
CarpetTileVinyl
Furnished
Negotiable
Heating
Forced Air
Interior Features
Ceiling Fan(s)Eat-in KitchenFive Piece BathHigh CeilingsHigh Speed InternetPantryPrimary SuiteQuartz CountersSmart ThermostatSmoke FreeVaulted Ceiling(s)Walk-In Closet(s)
Living Area
2195
Room Count
13
Security Features
Video Doorbell
Window Features
Window CoveringsWindow Treatments
Construction
Also Marketed As
Residential
Architectural Style
Contemporary
Building Area Source
Public Records
Construction Materials
Cement Siding
Foundation Details
Slab
Levels
Two
Out Building Count
Yes
Property Condition
Updated/Remodeled
Roof
Composition
Structure Type
House
Year Built
2012
Site & Exterior
Electric
110V220 Volts
Exterior Features
Private YardRain Gutters
Fencing
Full
Garage Spaces
3
Lot Features
LandscapedLevel
Lot Size Acres
0.16
Lot Size Area
6970
Lot Size Square Feet
6970
Lot Size Units
Square Feet
Out Building Number Of
Yes
Parking Features
ConcreteExterior Access DoorFinished GarageInsulated GarageLightedTandem
Parking Total
3
Patio And Porch Features
CoveredFront PorchPatio
Road Frontage Type
Public
Road Responsibility
Public Maintained Road
Road Surface Type
Paved
Sewer
Public Sewer
Utilities
Electricity ConnectedNatural Gas ConnectedPhone Available
Water Included
Yes
Water Source
Public
Financials
Contract Earnest Check To
Land Title
Contract Min Earnest
5000.00
Exclusions
Home security systemseller's personal belongings
Ownership
Individual
Parcel Number
R0733401
Special Listing Conditions
None
Tax Annual Amount
4064
Tax Legal Description
FRE NNCW L11 BLK6 NONAME CREEK WEST
Tax Year
2025

Neighborhood & Lifestyle

Community & Association
Senior Community
No
Subdivision Name
No Name Creek
Schools
Ratings
Elementary
Centennial
Middle
Coal Ridge
High
Frederick
Elem. District
St. Vrain Valley RE-1J
Middle District
St. Vrain Valley RE-1J
High District
St. Vrain Valley RE-1J
Listing provided courtesy of RECOLORADO via IDX. Updated: Jun 18, 2026, 4:45am.
Emily Karlis

Listing Agent

Equity Colorado Real Estate

Call Agent