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 walk-in). The convenience of a newly renovated upper-level laundry room is a real treat in this home. In the large, finished basement you’ll find a custom wet bar with accommodations for a full-size water/ice dispensing refrigerator, an expansive living & entertainment 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, covered patio with full length roller shades (perfect for entertaining year-round), extended front porch, gazebo with firepit, living room fireplace, solar power system with new inverter, smart doorbell w/ camera, dual radon system, 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 heated and fully insulated garage has overhead storage, and there is nearly 100ft of recreational or professional vehicle parking with power. The secluded backyard is bordered by gorgeous mature trees and is perfect for entertaining or relaxation. The Two beautiful parks, 2 amazing golf courses, and unobstructed mountain views are within walking distance of the home. You will also enjoy the convenient nearby access to I-25 & HWY 52, along with plenty of shopping & restaurants.
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 walk-in). The convenience of a newly renovated upper-level laundry room is a real treat in this home. In the large, finished basement you’ll find a custom wet bar with accommodations for a full-size water/ice dispensing refrigerator, an expansive living & entertainment 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, covered patio with full length roller shades (perfect for entertaining year-round), extended front porch, gazebo with firepit, living room fireplace, solar power system with new inverter, smart doorbell w/ camera, dual radon system, 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 heated and fully insulated garage has overhead storage, and there is nearly 100ft of recreational or professional vehicle parking with power. The secluded backyard is bordered by gorgeous mature trees and is perfect for entertaining or relaxation. The Two beautiful parks, 2 amazing golf courses, and unobstructed mountain views are within walking distance of the home. You will also enjoy the convenient nearby access to I-25 & HWY 52, along with plenty of shopping & restaurants.
Property Details
Price:
$625,000
MLS #:
REC5959084
Status:
Active Under Contract
Beds:
5
Baths:
4
Type:
Single Family
Subtype:
Single Family Residence
Subdivision:
No Name Creek
Finished Sq Ft:
3,107
Total Sq Ft:
3,107
Lot Size:
7,841 sqft / 0.18 acres (approx)
Year Built:
2012
See this Listing
Schools
School District:
St. Vrain Valley RE-1J
Elementary School:
Centennial
Middle School:
Coal Ridge
High School:
Mead
Interior
Above Grade Finished Area
2195
Appliances
Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer
Bathrooms
2 Full Bathrooms, 1 Three Quarter Bathroom, 1 Half Bathroom
Below Grade Finished Area
912
Cooling
Central Air
Fireplaces Total
1
Flooring
Carpet, Tile, Vinyl, Wood
Heating
Forced Air
Interior Features
Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Radon Mitigation System, Smart Ceiling Fan, Smart Light(s), Solid Surface Counters, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Wired for Data
Laundry Features
In Unit
Levels
Two
Main Level Bathrooms
1
Exterior
Attached Garage YN
1
Common Walls
No Common Walls
Construction Materials
Cement Siding, Concrete, Frame, Stone
Direction Faces
East
Exterior Features
Fire Pit, Gas Valve, Lighting, Private Yard, Rain Gutters
Fencing
Full
Garage Spaces
3
Lot Features
Landscaped, Many Trees, Sprinklers In Front
Parking Features
Concrete, Dry Walled, Exterior Access Door, Finished Garage, Heated Garage, Insulated Garage, Lighted, Storage, Tandem
Parking Spots
8
Parking Total
8
Patio And Porch Features
Covered, Front Porch, Patio
Roof
Composition
Security Features
Carbon Monoxide Detector(s), Smart Cameras, Smart Security System, Video Doorbell, Water Leak/Flood Alarm
Window Features
Double Pane Windows, Egress Windows, Window Coverings
Financial
Tax Year
2023
Taxes
$3,435
Map
Community
- Address9011 Sandpiper Drive Longmont CO
- SubdivisionNo Name Creek
- CityLongmont
- CountyWeld
- Zip Code80504
Subdivisions in Longmont
- 18 At Ute Creek
- 18 At Ute Creek Condos
- 18 at Ute Creek Sonoma Village
- 4/1
- 400 Emery Street Condos
- 911 Tulip Condos
- ANHAWA MANOR
- Anhawa Manor 3
- Bacons
- Barefoot Lakes
- Barefoot Lakes Fg 4
- Barefoot Lakes Fg 6
- Barrett-Klein
- Bleys
- BLUE VISTA PUD REPLAT C
- Bohn Farm Neighborhood
- Boulder Hills
- Brianna Marie Condo 2nd Ph
- Brianna Marie Condos
- Brigadoon Glen
- Broadview Add
- Buffalo Acres Sub
- Caribou Spgs Ranch Exempt
- Caribou Springs Ranch
- Carlson Farmstead
- Carpenter Nupud
- central square condos
- Champion Greens
- Clark Centennial
- Clover Basin Farm Flg 2
- Clover Basin Ranch
- Clover Creek Flg 1
- Clover Creek South 1st Flg
- Countryside
- County of Weld District Court Sub. E2NW4 29-3-68
- Creekside
- Creekside 5
- Creekside 6
- Crownover
- Darvey Farms
- Denio West
- Dollaghan Family Farm
- Dollhouse Acres
- Dollhouse Village
- Dollhouse Village 2
- Dollhouse Village 3
- EAGLE CREST
- East County
- East Side
- Eastern Meadows III Condos Ph 2
- Eastgate
- Eastgate Flg 1
- Eastgate Flg 5 At Shadow Grass Park
- Enchanted HIlls
- Exemption 472
- Fairview
- Fairview Condos
- Fairview Condos 8th Supp Bldg Gg
- Fairview Condos 9th Supp Bldgs Hh & II
- Faiths
- Falcon Point
- Foothills East
- Forbes Park
- Fox Creek Farm Flg 1
- Fox Creek Farm Flg 4
- Fox Meadow
- Fox Meadows
- Fox Meadows Flg 1
- Fox Meadows Flg 3
- Fox Meadows Flg 4
- Fox Medows Flg 1
- Fox Run 2 Sub
- Gaynor Lake
- Golden Bear
- Gorder Harper
- Gunbarrel Estates
- Hardt Estates
- Harvest Junction
- Harvest Junction Village
- Heritage Townhomes At Renaissance
- Highland at Fox Hill
- Highlands at Fox Hill
- Highlands at Fox Hills
- Highlands At Foxhill Discovery Bldg 2
- Highlands At Foxhill Discovery Building 3
- Highlands At Foxhill Flats Bldg 2
- Highlands Sub Final
- Hilltop Village
- Hilltop Village 1
- Holiday Park
- HORIZON PARKWAY REPLT B – LG
- Horizon West
- Horseshoe Park
- Hover Acres
- HOVER ACRES REPLATS – LG
- Hover Crossing PUD Flg 2
- Hover Park
- Hover Place Condo Ph 2
- Hover Place Condos
- Hover Place Condos Ph 3
- Hover Place Condos Ph 5
- Hutchins
- Hygiene Heights 3
- Idaho Creek
- IDAHO CREEK AMD
- Idaho Creek Sub Am
- Johnson Farm Sub
- Kensington Place
- Kent & Davis
- Kinsig
- Lake Valley
- Lake Valley Estate
- Lake Valley Estates
- Lakeside Canyon
- LASHLEY ROAD – LG
- Lee Park 2
- Lighthouse Cove
- Longmont
- Longmont Estate 8th filling
- Longmont Estates
- Longmont Estates 6
- Longmont Estates 7
- Longmont Estates Lakeshore
- LONGMONT INDUSTRIAL PARK REPLAT D
- Longmont Land Co 1
- Longmont Land Co 2
- Longmont Old Town
- Longmont Ot
- Longmont Village
- Longview Add
- LOOMILLER & FORBES – LG
- Lykins Gulch Farm
- Lyons Area
- Macy
- Madison Park Townhouses
- Madison Park Twnhs
- Meadow Green Farm
- Meadow Mountain
- Meadowlark
- Meadowlark 1
- Meadows The
- Meadowview
- Meadowview 7&8 Condos Ph 10
- Meadowview 7&8 Condos Ph 21
- Meadowview 7&8 Condos Ph 5
- Meadowview Filing 1
- Meadowview Flg 3
- Meadowview Flg 5
- Melody Valley 1
- Mill Village Flg 2
- Montview Park
- Morgan & Forbes
- Morningside
- Mountain Brook
- Mountain Brook Flg 2
- Mountain View
- Mountain View West
- Nelson Park Amd
- Noname Creek
- Noname Creek Estates Fg#1 Rplt B
- Noname Creek West
- North Central Longmont
- North Longmont Aka Howze & Sheir Lg
- North Longmont, Howze and Shiers
- North Pointe
- North Rim
- North Star
- Northern Plains
- Northstar
- Oak Meadows
- Olander & Forbes
- Old Town
- Old town Longmont
- Old Town; AR Goldens
- Outside City Limits
- Pamona
- Park North
- Park North 2 – LG
- Park Ridge 3
- Parkes At Stonebridge
- Parkside at Quail Ridge
- Parkside At Quail Ridge Condos
- Parkside At Quail Ridge Condos G-K 1240 Wren Court
- Parkside At Quail Ridge Condos G-M 1305 Kestrel La
- Parkwood Almquist
- Pelican Shores
- Pinnacle Condos
- Pinnacle Condos Ph 16
- Pleasant Valley 1st Flg
- Pleasant Valley 2
- Pleasant Valley 3
- Pomona Lakes
- Poplar Grove
- Poplar Grove Townhome Condos Ph 2lg
- Poplar Grove Twnhms Ph 9
- Prairie Village
- PRAIRIE VILLAGE 4
- Prairie Village 6
- Prairie Village Flg 1
- Prospect
- Prospect New Town Brianna Marie Condo 2nd Ph
- Provenance
- quail crossing
- Quail Crossing Fig 1 Pud
- Quail Crossing Flg 1 PUD
- Quail Ridge
- Quailridge
- R & S Resub
- Rainbow Creek Minor
- Ranch At Clover Basin Nupud
- Range View Acres
- Recorded Exemption #1313-02-2
- Red Barn Fg 2
- Renaissance
- Renaissance Filing 4
- Renaissance Flg 3
- Reserve At Renaissance
- Rider Ridge
- Rider Ridge Farm
- RIDER RIDGE FARM FLG 1 – LG
- Rider Ridge Farm Flg 2
- Rider Ridge Farm, Sugarmill Farms
- Rider Ridge Flg 3
- Ridge Crest
- Rinn Valley Ranch
- Riverbend at Mill Village
- RIVERBEND AT MILL VILLAGE CONDOS
- Riverbend At Mill Village Condos Lg
- Rockmont Heights 2
- Rosewood
- Rural Bo & Lgt
- S33 T04 R70
- Saddleback
- Seemore Heights
- Shadow Grass
- Sherri Mar
- Shores
- Shores PUD 1
- Shores PUD 1
- SHORES PUD 1 – LG
- Shores PUD 2nd Fld
- Shores The 2
- Sienna Park
- Silver Meadows
- skrbina 1
- Solar Village Prospect Condo
- Somerset Meadows
- Sonoma Village
- Sonoma Village At Ute Creek
- Sonoma Village At Ute Creek Condos
- Sonoma Village At Ute Creek Condos Ph1 B 7
- Sonoma Village At Ute Creek P
- Sonoma Village-Ute Creek Condos Ph1 B5
- Southmoor Park
- Southmoor Park 2
- Southmoor Park 3
- Southmoor Park 4
- Spring Valley
- Spring Valley Golf Estate
- Spring Valley Golf Estates
- Spring Valley Ph 1 1st Flg
- Spring Valley Ph 11 Prcl N
- Spring Valley Ph 6 Prcl E
- Spring Valley Ph 9 Prcl K
- Spring Valley Ph I Flg 1
- St Vrain
- St Vrain High School 4
- St Vrain Twnhms
- Stickler
- Stoney Ridge
- Stoney Ridge 2
- Stoney Ridge 7th Filing
- Stroh Heights
- Sugar Mill Village
- Sugarmill
- Sugarmill Paired Homes
- Sullivan Replat A
- Summerlin 1st Flg
- Sun Valley
- Sundance
- Sunnyvale
- Sunnyvale 3
- Sunnyvale Condo 1
- Sunnyvale Condos Ph I
- Terry Street Brownhomes
- Terry Street Brownstones
- The Meadows Meadowridge
- The Shores
- The Valley
- Town & Country
- Tramonto
- Trinity Subdivision Replat A
- True North
- Unincorporated Boulder County
- Valley The
- Valley View
- Villa Vista
- Villa Vista Twnhs
- Villas At Parkcrest 3rd Ph
- Villas At Pleasant Valley Condos Ph 1
- Villas At Pleasant Valley Condos Ph 11
- Villas at Spring Valley
- Villas at Ute Creek
- Villas At Ute Creek Condos
- Villas At Ute Creek Condos 5th
- Vista Comm Center Fg#1
- Vista Comm Center Fg#2 Corr
- Wadsworth
- Wallace Add 4th Flg
- Warren Park
- Watersong at Creekside
- West Grange
- West Grange Filing 2
- West Grange Flg 2 Duplex Condos
- West Point Village
- Westbrook Village
- Western Hill
- Western Meadows
- Westlake
- Westlake Manor
- Westlake Manors
- Westlake Manors Filing 6
- Whittington Estates
- Wolf Creek
- Wolf Creek 2nd Flg
- Wolf Creek Flg 1
- Wood Meadows
- Wood Meadows 1
- Woodmeadow
- Woodmeadow 1
- Woodmeadow 3
- Yeager Farm Flg 1
- Yeager Garden Acres
- Yeager Garden Acres 5
- YEAGER GARDEN ACRES 5 REP A – LG
- Yeager Gardens Acres 5
Market Summary
Current real estate data for Single Family in Longmont as of Sep 10, 2026
429
Single Family Listed
87
Avg DOM
359
Avg $ / SqFt
$1,194,356
Avg List Price
Property Summary
- Located in the No Name Creek subdivision, 9011 Sandpiper Drive Longmont CO is a Single Family for sale in Longmont, CO, 80504. It is listed for $625,000 and features 5 beds, 4 baths, and has approximately 3,107 square feet of living space, and was originally constructed in 2012. The current price per square foot is $201. The average price per square foot for Single Family listings in Longmont is $359. The average listing price for Single Family in Longmont is $1,194,356. To schedule a showing of MLS#rec5959084 at 9011 Sandpiper Drive in Longmont, CO, contact your milehimodern agent at 303-619-3373.
Similar Listings Nearby

Copyright 2026. All rights reserved.
9011 Sandpiper Drive
Longmont, CO

