Properties For Sale

Real Estate For Sale In Colorado

Properties For Sale

Below, you will find current real estate listings throughout Colorado. To view the full details about a property, simply click on the photo of the property that you are interested in. Once you’re on the selected property, you’ll be able to request more info, schedule a showing, or directly contact the listing agent. We look forward to working with you on your next real estate transaction!

Save
Ask
Tour
Hide
Share
$721,500
1 Day On Site

9011 Sandpiper Drive
Longmont, CO 80504

For Sale|Single Family Residence|Coming Soon
5
Beds
2
Full Baths
2
Partial Baths
3,107
SqFt
$232
/SqFt
2012
Built
Subdivision:
No Name Creek
County:
Weld
9011 Sandpiper Drive9011 Sandpiper Drive9011 Sandpiper Drive9011 Sandpiper Drive
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$3,292
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

Welcome to this beautifully maintained single-family home in the highly desirable and growing area of Frederick/Firestone! No HOA and not in a metro tax district! This home offers 5 bedrooms & 3.5 baths - suitable for all lifestyles. The main level provides ample living space including a family room, office, dining room, breakfast bar, and bright kitchen with newer stainless-steel appliances. The open staircase leads to 3 spacious upstairs bedrooms (2 with walk-in closets), a double vanity full bath, as well as the primary bedroom complete with luxury ensuite bathroom (2 closets, 1 being a large walk-in). The convenience of an upper-level laundry room is a real treat in this home. In the large, finished basement you’ll find a custom wet bar with space for a full-size refrigerator, an expansive living area, a beautiful ¾ bathroom, bedroom with large closet, and under-stair storage. Updates and upgrades can be found throughout this unique home, including freshly painted cabinetry, newer carpet, turf lawn backyard, basketball court, large covered patio with full length shades (perfect for entertaining year-round), extended front porch, gazebo with firepit, living room fireplace, solar panels, security system, dual radon system, sprinklers, granite countertops, class 4 roof, and much more! Appliances included are a double gas oven w/ air fryer, refrigerator, microwave, dishwasher, and washer/dryer. The 3-car tandem stall garage offers overhead storage along with nearly 100ft of parking on the side for your recreational toys or professional vehicles. The secluded backyard is bordered by gorgeous mature trees and is perfect for entertaining or quiet relaxation. The No Name Creek neighborhood is well-maintained, quiet, and friendly. Two beautiful parks, 2 amazing golf courses, and unobstructed mountain views are within walking distance of the home. You will also enjoy the convenient and nearby access to I-25 & HWY 52, along with plenty of shopping & restaurants.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$721,500
Days On Site 
1 Day
Bedrooms 
5
Inside Area (SqFt) 
3,107 sqft
Total Baths 
4
Full Baths 
2
Partial Baths 
2
Lot Size 
0.18 Acres
Year Built 
2012
MLS® Number 
5959084
Status 
Coming Soon
Property Tax 
$3,435
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
19 hours agoListing updated with changes from the MLS®
yesterdayListing first seen on site
General Features
Acres 
0.18
Attached Garage 
Yes
Direction Faces 
East
Garage 
Yes
Garage Spaces 
3
Parking 
ConcreteHeated GarageLightedStorageTandemAttached
Parking Spaces 
8
Property Condition 
Updated/Remodeled
Property Sub Type 
Single Family Residence
Security 
Carbon Monoxide Detector(s)Security System
Sewer 
Public Sewer
SqFt Above 
2195
SqFt Below 
912
SqFt Total 
3107
Stories 
Two
Utilities 
Natural Gas AvailableCable AvailableElectricity ConnectedNatural Gas ConnectedPhone Connected
Water Source 
Public
Zoning 
Res
Interior Features
Appliances 
DishwasherDisposalDouble OvenDryerGas Water HeaterMicrowaveRangeRefrigeratorWasher
Basement 
FinishedFull
Cooling 
Ceiling Fan(s)Central Air
Electric 
220 Volts
Fireplace 
Yes
Fireplace Features 
Living Room
Fireplaces 
1
Flooring 
CarpetTileVinylWood
Heating 
Forced Air
Interior 
Ceiling Fan(s)Eat-in KitchenGranite CountersHigh Speed InternetKitchen IslandOpen FloorplanPantryVaulted Ceiling(s)Walk-In Closet(s)Wet BarWired for Data
Laundry Features 
In Unit
Window Features 
Double Pane WindowsWindow Coverings
Bathroom (1/2) 
Level - Main
Bathroom (3/4) 
Level - Basement
Bathroom (Full) 
Level - Upper
Bedroom 
Level - Basement
Bonus Room 
Level - Basement
Dining Room 
Level - Main
Family Room 
Level - Basement
Kitchen 
Level - Main
Laundry 
Level - Upper
Living Room 
Level - Main
Primary Bathroom (Full) 
Level - Upper
Primary Bedroom 
Level - Upper
Utility Room 
Level - Basement
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Cement SidingConcreteFrameStone
Exterior 
Fire PitLightingPrivate YardRain Gutters
Fencing 
FencedFull
Lot Features 
LandscapedMany TreesSprinklers In Front
Patio And Porch 
CoveredFront PorchPatio
Roof 
Composition
Windows/Doors 
Double Pane WindowsWindow Coverings
Community Features
Financing Terms Available 
CashConventional
Roads 
Paved
School District 
St. Vrain Valley RE-1J
Schools
School District
St. Vrain Valley RE-1J
Elementary School
Centennial
Middle School
Coal Ridge
High School
Mead
Listing courtesy of Price & Co. Real Estate b.tepesch@pricecohomes.com



The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO real estate listings held by brokers other than Price & Co. Real Estate are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share