$609,900
UNDER CONTRACT $5K PRICE DROP

9046 Sandpiper Dr Longmont, CO 80504

Estimated payment $3,542/month

Total Views 6,035
3 Beds
2.5 Baths
2,033 Sq Ft
$300 Price per Sq Ft

Highlights

  • Open Floorplan
  • Vaulted Ceiling
  • Loft
  • Contemporary Architecture
  • Wood Flooring
  • Granite Countertops

About This Home

Welcome to this stunning home you will want to make your own! You will be delighted to enter the open spacious living room with vaulted ceiling, large windows and gas fireplace. Fabulous kitchen with eat in dining and breakfast bar along with beautiful granite counters, plank flooring, an abundance of cabinet space and a pantry. Highly sought after main floor master bedroom suite with vaulted ceilings and a 5 piece bath including a large soaking tub and a large walk in closet. The armoire in the master bedroom can stay as well. Upstairs you will find a open loft space with a catwalk that over looks the living room and on to the back patio. There are 2 additional bedrooms with walk in closets.The basement provides 1386 square feet of additional wide open space to finish however you desire or simply enjoy the spacious storage area. Laundry is on the main floor just inside the 3 car garage. Beautiful fenced back yard with gate access on both sides of the property. Sprinklers front and back including the planter bed on the concrete patio. You will enjoy some added privacy on the back patio with lovely flowers including some perennials. East facing patio for morning sun to relax and enjoy your coffee. Roof replaced in 2024. Exterior paint in 2024. Ducts cleaned 2025. No Metro District, No HOA and reasonable taxes. Located near an abundance of walking paths, Frederick Open Space, Stoneridge Park, Bella Rosa Golf Course and Saddleback Golf Club. Quick easy access to I-25.

Listing Agent

Cindi Brady

Berkshire Hathaway Home Services, Rocky Mountain Realtors Brokerage Email: cindibrady@gmail.com,303-868-3387 License #040021158 Listed on: 06/05/2025

Berkshire Hathaway Home Services, Rocky Mountain Realtors

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,939

Year Built

  • Built in 2012

Lot Details

  • 7,150 Sq Ft Lot
  • West Facing Home
  • Landscaped
  • Front and Back Yard Sprinklers

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Composition Roof

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Living Room with Fireplace
  • Dining Room
  • Loft
  • Unfinished Basement
  • Stubbed For A Bathroom

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Patio
  • Front Porch

Schools

  • Centennial Elementary School
  • Coal Ridge Middle School
  • Mead High School

Utilities

  • Forced Air Heating and Cooling System
  • 110 Volts
  • Natural Gas Connected
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Built by Saint Aubyn Homes LLC
  • No Name Creek Subdivision

Listing and Financial Details

  • Exclusions: Seller's Personal Property
  • Assessor Parcel Number R0735901

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,939

Year Built

Built in 2012

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2012
  • Above Grade Finished Sq Ft: 2033
  • Below Grade Sq Ft: 1386
  • Exclusions: Seller's Personal Property
  • Living Area: 2033
  • SubdivisionName: No Name Creek
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 1
  • REC_UpperLevelBedrooms: 2
  • REC_WaterIncludedYN: 1
  • Attribution Contact: cindibrady@gmail.com,303-868-3387
  • Special Features: 4224

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Open Floorplan, Pantry, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Gas, Living Room
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Bath/Stubbed, Unfinished
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 1
  • Window Features: Double Pane Windows, Window Coverings, Window Treatments

Exterior Features

  • Direction Faces: West
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Other
  • Patio and Porch Features: Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Coal Ridge

Lot Info

  • Parcel Number: R0735901
  • Lot Size Acres: 0.16
  • Building Area Total: 3419
  • Lot Features: Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 7150

Building Info

  • Builder Name: Saint Aubyn Homes LLC

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 2939

MLS Schools

  • Elementary School: Centennial
  • High School: Mead

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $2,939 $36,140 $7,190 $28,950
2024 $2,939 $36,140 $7,190 $28,950
2023 $2,818 $38,980 $9,130 $29,850
2022 $2,946 $28,230 $5,910 $22,320
2021 $2,975 $29,050 $6,080 $22,970
2020 $2,913 $28,670 $4,220 $24,450
2019 $2,956 $28,670 $4,220 $24,450
2018 $2,527 $25,440 $3,740 $21,700
2017 $2,583 $25,440 $3,740 $21,700
2016 $2,359 $22,860 $3,180 $19,680
2015 $2,287 $22,860 $3,180 $19,680
2014 $1,868 $18,690 $2,390 $16,300
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/07/2025 07/07/25 Price Changed $609,900 -0.8% $300 / Sq Ft
06/05/2025 06/05/25 For Sale $615,000 +146.8% $303 / Sq Ft
01/28/2019 01/28/19 Off Market $249,150 -- --
07/20/2012 07/20/12 Sold $249,150 +1.4% $75 / Sq Ft
06/20/2012 06/20/12 Pending -- -- --
03/19/2012 03/19/12 For Sale $245,750 -- $74 / Sq Ft
Source: REcolorado®

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $249,150 Heritage Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $199,320 New Conventional
Previous Owner $562,000 Stand Alone Refi Refinance Of Original Loan
Source: Public Records

Similar Homes in Longmont, CO

  • 11729 Elmer Linn Dr, Longmont, CO 80504

    $675,000

    • 3 Beds
    • 2.5 Baths
    • 2,556 Sq Ft
    • 11729 Elmer Linn Dr
    • Longmont, CO

    Discounted rate options and no lender fee future refinancing may be available for qualified buyers of this home.Welcome to your dream home in the highly sought-after neighborhood of The Elms at Meadow Vale in Weld county, wherethe taxes are significantly lower than both the national median of 0.99% and the Colorado state median of 0.55%. Thislovely 3-bedroom, 2.5-bath home is

    Tiffany Osborn Orchard Brokerage LLC

    Section Image
  • 227 Cattail Ct, Longmont, CO 80501

    $499,999

    • 3 Beds
    • 2.5 Baths
    • 1,496 Sq Ft
    • 227 Cattail Ct
    • Longmont, CO

    Step into a light-filled home featuring a beautifully remodeled kitchen with, sleek countertops, stainless steel appliances, and an open layout perfect for both cooking and entertaining. The living and dining areas flow seamlessly with warm finishes and functional design. Upstairs, you’ll find three generously sized bedrooms, including a spacious primary suite with vaulted ceilings, a soaking

    Adam Mayfield eXp Realty, LLC

    Section Image
  • 502 Peregrine Cir, Longmont, CO 80504

    $739,000

    • 5 Beds
    • 5 Baths
    • 4,569 Sq Ft
    • 502 Peregrine Cir
    • Longmont, CO

    Located on a quiet corner and overlooking open green space, this home offers a beautiful balance of character and comfort, where classic charm meets modern ease. Located in one of Longmont's most tranquil neighborhoods and just steps from the brand-new Fox Meadows Park, Fox Hill Country Club, and Union Reservoir it's an ideal setting for those who value both community and calm. Step inside to a

    Heather McChesney Keller Williams 1st Realty

    Section Image
  • 1005 E 5th Ave, Longmont, CO 80504

    $675,000

    • 4 Beds
    • 2.5 Baths
    • 3,136 Sq Ft
    • 1005 E 5th Ave
    • Longmont, CO

    Exceptionally unique Fox Hill gem! This distinctive 4-level home sits on a desirable corner lot with fantastic views and gorgeous mature trees providing shade and privacy. Inside, you'll find 4 spacious bedrooms and 3 baths, plus fresh new paint and carpet throughout. The kitchen features brand-new stainless-steel appliances and an inviting eat-in area. A separate dining room adjoins which is

    Janet Leap RE/MAX of Boulder, Inc

    Section Image
  • 747 Elliott St, Longmont, CO 80504

    $530,000

    • 6 Beds
    • 3 Baths
    • 2,464 Sq Ft
    • 747 Elliott St
    • Longmont, CO

    **Welcome to this Original Owner, Custom Ranch with Walk-Out Basement in Sun Valley**This thoughtfully designed ranch-style home, built and lovingly maintained by the original owner, offers both space and versatility. Featuring five bedrooms plus an additional office or rec room, the layout provides surprising flexibility-ideal for multi-generational living or potential rental opportunities with

    Jenny Hart Keller Williams 1st Realty

    Section Image
  • 1927 Rannoch Dr, Longmont, CO 80504

    $685,000

    • 5 Beds
    • 3 Baths
    • 3,762 Sq Ft
    • 1927 Rannoch Dr
    • Longmont, CO

    Tucked into Longmont’s Spring Valley Golf Estates, this home has an easygoing charm that’s hard to ignore. The kitchen is bright and modern with granite counters and stainless steel finishes—perfect for everything from lazy weekend breakfasts to hosting your next dinner party. Sun-drenched living spaces flow effortlessly into a cozy primary suite, complete with a spa-inspired bath that’s made for

    Kelly Dolph Keller Williams Foothills Realty

    Section Image
  • 2344 Flagstaff Dr, Longmont, CO 80504

    $599,000

    • 4 Beds
    • 3.5 Baths
    • 3,422 Sq Ft
    • 2344 Flagstaff Dr
    • Longmont, CO

    SELLERS OFFERING A $650 AMERICAN FURNITURE GIFT CARD TO BUYER IF UNDER CONTRACT ON OR BEFORE SEPT. 20, 2025, AND SALE SUCCESSFULLY CLOSES WITHIN 30 DAYS OF UC DATE. Hard to find beautifully updated ranch style home with 3-car garage in popular Pleasant Valley. Open floor plan. 2000+sf on main floor with 3 bedrooms. Great for entertaining. Vaulted ceilings. Hardwood floors throughout. Refurbished

    Mark Webber Equity Colorado-Front Range

    Section Image
  • 1157 Gay St, Longmont, CO 80501

    $485,000

    • 3 Beds
    • 1.5 Baths
    • 1,296 Sq Ft
    • 1157 Gay St
    • Longmont, CO

    Charming Bungalow in the Heart of Old Town Longmont!This cozy 3-bedroom, 1.5-bath home sits on a spacious corner lot surrounded by mature landscaping and beautiful shade trees that help keep the home cool during summer months. Freshly painted throughout with newly refinished hardwood floors, this home offers a warm and inviting feel from the moment you step inside. The updated kitchen flows into

    Cecilia De Villiers Shasta Realty Inc

    Section Image
  • 1313 Garden Cir, Longmont, CO 80501

    $595,000

    • 4 Beds
    • 3 Baths
    • 2,616 Sq Ft
    • 1313 Garden Cir
    • Longmont, CO

    Welcome to your private backyard retreat-this Longmont home is built for entertaining and relaxing. The standout feature is the beautifully landscaped yard with a covered outdoor living space, raised garden beds, spacious patios, fire pit, and plenty of grassy space to play or unwind. 2 large sheds offering extra storage in addition to the oversized 2 car garage. A masterfully planned irrigation

    Jeremy Kane eXp Realty LLC

    Section Image

Source: REcolorado®

MLS Number: 5812151

REcolorado®

APN: R0735901