9020 Sandpiper Dr, Longmont, CO 80504

• 4 beds |
• 3 baths |
• 2,195 sqft

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 interest rate buy-down options - contact listing agent for details! The home is available to be purchased fully furnished. Please inquire for additional information.

Listing Status:

Active

Data Last Updated:

April 2, 2026 at 5:23AM

Listing Office:

Equity Colorado Real Estate : 720-552-0404

Listing Agent:

Emily Karlis : 720-552-0404

MLS ID:

5493360

Interior

• General: Eat-in KitchenCathedral Ceiling(s)PantryWalk-In Closet(s)
• Appliances: DishwasherRefrigeratorWasherDryerMicrowaveDisposal
• Basement: UnfinishedSlab
• A/C: Central AirCeiling Fan(s)
• Heating: Forced Air
• Fireplace: None
• Disability Feature: Level Lot
• Eco/Green Feature: Thermostat

Exterior

• General: Tandem Garage
• Style: Contemporary
• Other Structures: Patio
• Parking: Attached

Construction

• Roofing: Composition
• Windows: Window Coverings
• General: CompositionTwo

Location

• Originating MLS: ires
• School District: ST Vrain Dist RE 1J
• County: Weld

Lot

• Fencing: Fenced

Utilities

• Utilities: Electricity Available
• Water: City
• Sewer: Public Sewer

Financial

• Source: ires
• Exclusions: Home security systemseller's personal belongings