Skip main navigation
Accepting backups
    • Price increase: $21K (7/24)
    $613,000

    9020 Sandpiper Drive, Longmont, CO 80504

    4beds
    3,107sqft
    : 
    $3,897/mo
    Get pre-qualified
    Single Family Residence
    Built in 2012
    6,970 Square Feet Lot
    $-- Zestimate®
    $197/sqft
    $-- HOA

    What's special

    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.
    127 days
    |
    611
    |
    49
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Emily Karlis 720-552-0404,

    Equity Colorado Real Estate

    Source: REcolorado as distributed by MLS GRID,MLS#: 5493360MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 1
      • 3/4 bathrooms: 1
      • 1/2 bathrooms: 1
      • Main level bathrooms: 1
      Bedroom
      • Features: Primary Suite
      • Level: Upper
      Bedroom
      • Features: Primary Suite
      • Level: Upper
      Bedroom
      • Level: Upper
      Bedroom
      • Level: Upper
      Bathroom
      • Level: Main
      Bathroom
      • Features: Primary Suite
      • Level: Upper
      Bathroom
      • Level: Upper
      Bonus room
      • Level: Main
      Dining room
      • Level: Main
      Kitchen
      • Level: Main
      Laundry
      • Level: Upper
      Living room
      • Level: Main
      Utility room
      • Level: Basement
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
      Features
      • Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, High Ceilings, High Speed Internet, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)
      • Flooring: Carpet, Tile, Vinyl
      • Windows: Window Coverings, Window Treatments
      • Basement: Bath/Stubbed,Unfinished
      Interior area
      • Total structure area: 3,107
      • Total interior livable area: 3,107 sqft
      • Finished area above ground: 2,195
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 3
      • Parking features: Concrete, Exterior Access Door, Insulated Garage, Lighted, Tandem
      • Attached garage spaces: 3
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Covered, Front Porch, Patio
      • Exterior features: Private Yard, Rain Gutters
      • Fencing: Full
      Lot
      • Size: 6,970 Square Feet
      • Features: Landscaped, Level
      Details
      • Parcel number: R0733401
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Cement Siding
      • Foundation: Slab
      • Roof: Composition
      Condition
      • Updated/Remodeled
      • Year built: 2012

      Utilities & green energy

      • Electric: 110V, 220 Volts
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Electricity Connected, Natural Gas Connected, Phone Available

      Community & HOA

      Community
      • Security: Video Doorbell
      • Subdivision: No Name Creek
      HOA
      • Has HOA: No
      Location
      • Region: Frederick

      Financial & listing details

      • Price per square foot: $197/sqft
      • Tax assessed value: $580,742
      • Annual tax amount: $4,064
      • Date on market: 3/24/2026
      • Listing terms: 1031 Exchange,Cash,Conventional,FHA,VA Loan
      • Exclusions: Home Security System, Seller's Personal Belongings
      • Ownership: Individual
      • Electric utility on property: Yes
      • Road surface type: Paved

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/24/2026Pending sale$613,000$197/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        7/24/2026Price change$613,000+3.5%$197/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        7/18/2026Price change$592,000-4.5%$191/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        7/6/2026Price change$620,000-2.4%$200/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        6/18/2026Price change$635,000-2.3%$204/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        4/18/2026Price change$650,000-3.7%$209/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        3/24/2026Listed for sale$675,000+62.3%$217/sqft
        Source: REcolorado as distributed by MLS GRID #5493360 Report a problem
        3/27/2019Sold$416,000+1.5%$134/sqft
        Source: Public Record Report a problem
        2/24/2019Pending sale$409,900$132/sqft
        Source: KOIS REAL ESTATE #5391771 Report a problem
        2/23/2019Listed for sale$409,900+62.2%$132/sqft
        Source: KOIS REAL ESTATE #5391771 Report a problem
        10/19/2012Sold$252,672$81/sqft
        Source: IRES as distributed by MLS GRID #688347 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$4,064 +11.6%$35,540 -2.1%
        2025$3,643 +4.3%$36,300 -6.1%
        2024$3,494 +17.7%$38,670 -0.9%
        2023$2,969 -0.9%$39,040 +37.2%
        2022$2,997 +2.4%$28,450 -2.8%
        2021$2,926 $29,260 +1.6%
        2020$2,926 +14.8%$28,800
        2019$2,548 -14.2%$28,800 +12.3%
        2018$2,969 +16.5%$25,650
        2017$2,548 -2.2%$25,650 +11.9%
        2016$2,604 +13.5%$22,930
        2015$2,294 +21.6%$22,930 +21.5%
        2014$1,887 $18,880
        2013-- $18,880 +525.2%
        2012-- $3,020
        2011-- $3,020 +762.9%
        2010-- $350
        2009-- $350
        2008-- $350
        2007-- $350
        2006-- $350
        2005-- $350
        2004-- $350
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 80504

        Getting around

        14 / 100
        Car-Dependent
        33 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Centennial
        • Middle: Coal Ridge
        • High: Frederick
        • District: St. Vrain Valley RE-1J

        Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Frederick Topics

              Search
              Updates
              Favorites
              Plan
              Inbox