PerformAction
 logo  logo  logo
  • (303) 443-2240
  • BUY
    • Search
    • Just Listed
    • Open Houses
    • Buyers
      • Home Buying Process
      • Get Pre Approved
      • Find a Broker
    • Mortgage Calculator
  • SELL
    • Sellers
      • Home Selling Process
      • Market Analysis
      • Five Reasons a Property Sells
      • Moving Out Of The Area
      • Find The Right Broker
  • Commercial
    • Commercial Services
    • Our Listings
    • Recent Closings
    • Find The Right Broker
  • Relocation
    • Individual and Family Solutions
    • Corporate Services
    • Meet the Relocation Team
    • Global Affiliations and Awards
    • National Home Search
  • OUR COMPANY
    • Our Brokers
    • Our Story
      • Who We Are
      • Community Engagement
      • Awards
      • Managing Team
    • Testimonials
    • Join our team
    • Blog
  • COMMUNITIES
  • CONTACT US
    • BUY
      • Search
      • Just Listed
      • Open Houses
      • Buyers
        • Home Buying Process
        • Get Pre Approved
        • Find a Broker
      • Mortgage Calculator
    • SELL
      • Sellers
        • Home Selling Process
        • Market Analysis
        • Five Reasons a Property Sells
        • Moving Out Of The Area
        • Find The Right Broker
    • Commercial
      • Commercial Services
      • Our Listings
      • Recent Closings
      • Find The Right Broker
    • Relocation
      • Individual and Family Solutions
      • Corporate Services
      • Meet the Relocation Team
      • Global Affiliations and Awards
      • National Home Search
    • OUR COMPANY
      • Our Brokers
      • Our Story
        • Who We Are
        • Community Engagement
        • Awards
        • Managing Team
      • Testimonials
      • Join our team
      • Blog
    • COMMUNITIES
    • CONTACT US
Log In Or Register
 logo  logo  logo
(303) 443-2240
Log In Or Register
Clear Price
Cancel
Done Search
  • Property Video
  • Virtual Tour
  • Interactive Brochure
  • 3D Property Tour
  • Website
  • Save Listing
  • Share Listing
  • Print

$650,000

9020 Sandpiper Dr, Longmont, CO 80504  (Sold on )

  • Price Reduced$25,000
  • Open House
  • New Listing
  • Coming Soon
  • 4 BedBeds
  • 3 BathBaths
  • 3,107 SqftSqft
  • TypeSingle Family
  • Active
  • MLS# 5493360
0 More Schedule

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.

Thank you for requesting a showing of this property. A representative will be in touch with you shortly to confirm the requested showing date and time.
Please note that your appointment is not confirmed until someone contacts you.

Request Info/ Schedule Showing

Submit

Property Details

General

  • Subdivision: No Name Creek
  • County: Weld
  • List Date: 03/24/2026
  • Expected Active Date: 03/24/2026
  • DOM: 79
  • Style: Contemporary
  • Lot SqFt: 6970
  • Beds: 4
  • Baths: 3.00
  • Full Baths: 1
  • ¾ Baths: 1
  • Half Baths: 1
  • Basement/Foundation: Unfinished, Slab
  • Year Built: 2012
  • New construction: NO
  • Sq Ft (total): 3107
  • Garage/Parking Spaces: 3
  • Garage Description: Attached
  • MLS#: 5493360

Interior Features

  • Heating: Forced Air
  • Cooling: Central Air, Ceiling Fan(s)
  • Fireplace: None
  • Disability Accessibility: Level Lot

Exterior Features

  • Construction: Composition
  • Roof: Composition
  • Type: Single Family Residence
  • Outdoor Features: Tandem Garage
  • Fences: Fenced
  • Waterfront: NO

Schools

  • School District: ST Vrain Dist RE 1J
  • Elementry: Centennial
  • Middle/Jr: Coal Ridge
  • High School: Frederick

Financial Considerations

  • Tax Year: 2025
  • Tax Amount: $4064

Utilities

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

Similar Listings

    • Open House
    • Price Reduced
    • New Listing
    • Pending
    • Coming Soon
    • Sold
    11759 Ashton Rd, Longmont, CO 80504
    $810,000
    MLS# 1055759Active
    4,470 Sq. Ft.
     
    5 BEDS3 BATHS
    Listing courtesy of Key Realty LTD
    IRE logo
    MLS logo
    Request Info
    Delete
    Details
      • Open House Sun. Jun 14; 12:00 PM - 02:00 PM
      • Price Reduced $15,100
      • New Listing
      • Pending
      • Coming Soon
      • Sold
      9053 Foxfire St, Firestone, CO 80504
      $809,900
      MLS# 1059572Active
      4,768 Sq. Ft.
       
      4 BEDS4 BATHS
      Listing courtesy of Group Harmony
      IRE logo
      MLS logo
      Request Info
      Delete
      Details
        • Open House
        • Price Reduced
        • New Listing
        • Pending
        • Coming Soon
        • Sold
        8705 Tack St, Frederick, CO 80504
        $800,000
        MLS# 7422147Under Contract
        4,625 Sq. Ft.
         
        6 BEDS5 BATHS
        Listing courtesy of eXp Realty, LLC
        IRE logo
        MLS logo
        Request Info
        Delete
        Details
          • Open House
          • Price Reduced $10,001
          • New Listing
          • Pending
          • Coming Soon
          • Sold
          11721 Beasly Rd, Longmont, CO 80504
          $799,999
          MLS# 1057513Active
          4,867 Sq. Ft.
           
          4 BEDS4 BATHS
          Listing courtesy of Lovins Real Estate
          IRE logo
          MLS logo
          Request Info
          Delete
          Details
            • Open House
            • Price Reduced $20,000
            • New Listing
            • Pending
            • Coming Soon
            • Sold
            Address Undisclosed
            $799,950
            MLS# 7963408Active
            4,814 Sq. Ft.
             
            6 BEDS5 BATHS
            Listing courtesy of Richmond Realty Inc
            IRE logo
            MLS logo
            Request Info
            Delete
            Details
              • Open House
              • Price Reduced
              • New Listing
              • Pending
              • Coming Soon
              • Sold
              11790 Pleasant View Rdg, Longmont, CO 80504
              $799,000
              MLS# 1055664Under Contract
              5,080 Sq. Ft.
               
              4 BEDS4 BATHS
              Listing courtesy of Keller Williams-Preferred Rlty
              IRE logo
              MLS logo
              Request Info
              Delete
              Details
                • Open House Sat. Jun 13; 11:00 AM - 04:00 PM
                • Price Reduced $43,956
                • New Listing
                • Pending
                • Coming Soon
                • Sold
                5841 Aspenglow St, Firestone, CO 80504
                $799,000
                MLS# 1038462Active
                3,117 Sq. Ft.
                 
                5 BEDS5 BATHS
                Listing courtesy of American Legend Homes LLC
                IRE logo
                MLS logo
                Request Info
                Delete
                Details
                  • Open House Sat. Jun 13; 11:00 AM - 04:00 PM
                  • Price Reduced $49,226
                  • New Listing
                  • Pending
                  • Coming Soon
                  • Sold
                  5842 Aspenglow St, Firestone, CO 80504
                  $795,000
                  MLS# 1048221Active
                  4,002 Sq. Ft.
                   
                  3 BEDS2 BATHS
                  Listing courtesy of American Legend Homes LLC
                  IRE logo
                  MLS logo
                  Request Info
                  Delete
                  Details
                    • Open House
                    • Price Reduced $13,000
                    • New Listing
                    • Pending
                    • Coming Soon
                    • Sold
                    11786 N Beasly Rd, Longmont, CO 80504
                    $792,000
                    MLS# 9252785Under Contract
                    5,874 Sq. Ft.
                     
                    3 BEDS3 BATHS
                    Listing courtesy of Orchard Brokerage LLC
                    IRE logo
                    MLS logo
                    Request Info
                    Delete
                    Details
                      • Open House
                      • Price Reduced
                      • New Listing
                      • Pending
                      • Coming Soon
                      • Sold
                      12536 Creekside St, Firestone, CO 80504
                      $789,000
                      MLS# 3651374Active
                      4,159 Sq. Ft.
                       
                      5 BEDS4 BATHS
                      Listing courtesy of Taylor Realty Group
                      IRE logo
                      MLS logo
                      Request Info
                      Delete
                      Details
                        • Open House
                        • Price Reduced
                        • New Listing
                        • Pending
                        • Coming Soon
                        • Sold
                        12648 Canoe St, Longmont, CO 80504
                        $779,900
                        MLS# 4821840Active
                        4,401 Sq. Ft.
                         
                        3 BEDS4 BATHS
                        Listing courtesy of Trelora Realty, Inc.
                        IRE logo
                        MLS logo
                        Request Info
                        Delete
                        Details
                          • Open House
                          • Price Reduced
                          • New Listing
                          • Pending
                          • Coming Soon
                          • Sold
                          4960 Preserve Pl, Firestone, CO 80504
                          $775,000
                          MLS# 1061274Active
                          4,654 Sq. Ft.
                           
                          5 BEDS4 BATHS
                          Listing courtesy of Distinct Real Estate LLC
                          IRE logo
                          MLS logo
                          Request Info
                          Delete
                          Details
                          COL Logo IRE Logo
                          • Get in Touch

                          • (303) 443-2240 info@wkre.com
                          • 4875 Pearl E. Circle, Suite #100 BoulderCO80301
                          • 2101 Ken Pratt Blvd, Suite #100, Longmont, CO 80501

                          Follow Us

                          Luxury Portfolio Leading RE WKR Footer logo

                          Policies

                          • Privacy Policy
                          • Careers
                          • Accessibility Policy
                          • Agent Resources
                          • DMCA Notice
                          • Agent Login
                          Copyright © 2026 WK Real Estate. All Rights Reserved.
                          • Comparison List   0

                          WK Real Estate is powered by Burrow Services, Inc.