Seller's Agent in 2023
Amanda D Dowell
Modern Design Realty Group LLC
(303) 886-5177
2 in this area
146 Total Sales
9037 Sandpiper Dr Longmont, CO 80504
Estimated Value: $620,000 - $628,000
6
Beds
3
Baths
3,148
Sq Ft
$198/Sq Ft
Est. Value
Highlights
- Open Floorplan
- Cathedral Ceiling
- No HOA
- Contemporary Architecture
- Wood Flooring
- 3 Car Attached Garage
About This Home
As of June 2023Fantastic Multi-Gen Home Ready to move in! Located in the heart of Frederick with miles of Hiking/Biking Trails, Restaurants, Brew Pubs and Shopping. Walk into this beautiful home with an open floor plan featuring ash hardwood flooring. Easy to entertain friends and family between the newly remodeled kitchen and family room. The kitchen includes newer appliances, gorgeous wood cabinets with quartz countertops, tile backsplash and additional seating at the island and a chefs dream pantry. The spacious master bedroom with barn door that separates the luxurious 5 pc master bath with soaking tub, double sinks, beautifully remodeled walk in shower and spacious walk in designer closet with lots of shelving and storage. The remaining two main floor bedrooms with closet organizers that share a full bathroom with granite counters and beautiful tile. The basement has a rare fully finished multi gen mother in law suite or if you prefer to generate additional rental income. Comes complete with a full kitchen, oven/stove, hood range, side by side refrigerator, dishwasher and laminate counters, tile back splash, wood cabinets and kitchen island that overlooks the living area. The additional 3 bedrooms and full bathroom also with beautiful granite counters and tile flooring. Also has its own washer and dryer. Egress windows to bring in lots of natural light. The sixth bedroom could easily serve as the perfect private office. The backyard has a private patio, perfect for outdoor entertaining with friends and family or relaxing after a long day. The attached 3 car garage with storage also an RV pad for additional parking for all the Toys! This beautiful home has over $40K in recent upgrades. Located in the highly desired St Vrain Valley school district, less than 40 minutes to Downtown Denver or Downtown Boulder. Enjoy small town living with all the conveniences of big city life. This rare find wont last long!
Last Agent to Sell the Property
Modern Design Realty Group LLC Listed on: 05/18/2023
Last Buyer's Agent
Non-IRES Agent
Non-IRES
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $3,097
Year Built
- Built in 2011
Lot Details
- 7,948 Sq Ft Lot
- East Facing Home
- Vinyl Fence
- Wood Fence
- Level Lot
- Sprinkler System
Parking
- 3 Car Attached Garage
- Garage Door Opener
- Driveway Level
Home Design
- Contemporary Architecture
- Slab Foundation
- Wood Frame Construction
- Composition Roof
- Vinyl Siding
Interior Spaces
- 3,148 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Cathedral Ceiling
- Ceiling Fan
- Double Pane Windows
- Family Room
- Dining Room
Kitchen
- Eat-In Kitchen
- Electric Oven or Range
- Self-Cleaning Oven
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Carpet
- Laminate
Bedrooms and Bathrooms
- 6 Bedrooms
- Walk-In Closet
- 3 Full Bathrooms
- Primary bathroom on main floor
- Walk-in Shower
Laundry
- Laundry on main level
- Dryer
- Sink Near Laundry
Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump
Schools
- Legacy Elementary School
- Coal Ridge Middle School
- Frederick High School
Utilities
- Forced Air Heating and Cooling System
- Water Softener is Owned
- High Speed Internet
- Cable TV Available
Additional Features
- Low Pile Carpeting
- Energy-Efficient Thermostat
- Patio
Community Details
- No Home Owners Association
- Built by Awesome
- No Name Creek West Subdivision
Listing and Financial Details
- Assessor Parcel Number R0728101
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 18, 2023
Closed on
Jun 16, 2023
Sold by
Illa Brenda and Illa Troy
Bought by
Buie Megan Larissa and Pierce Griffin Stuart
Seller's Agent
Amanda D Dowell
Modern Design Realty Group LLC
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$625,000
Sold Price
$625,000
Views
41
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,018
Avg. Annual Appreciation
-0.07%
Original Mortgage
$593,750
Outstanding Balance
$577,757
Interest Rate
6.35%
Mortgage Type
New Conventional
Estimated Equity
$46,225
Purchase Details
Listed on
May 7, 2021
Closed on
Jun 16, 2021
Sold by
Tubbs Brett Alan and Tubbs Ruth Ellen
Bought by
Illa Troy and Illa Brenda
Seller's Agent
Sarah Gooch
Keller Williams 1st Realty
Buyer's Agent
Deano Zahakis
Kittle Real Estate
List Price
$525,000
Sold Price
$565,000
Premium/Discount to List
$40,000
7.62%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.18%
Original Mortgage
$437,000
Interest Rate
2.9%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jun 1, 2019
Closed on
Jul 25, 2019
Sold by
Schmid Troy D
Bought by
Tubbs Brett Alan and Tubbs Ruth Ellen
Seller's Agent
Cassie Purdy
eXp Realty - Loveland
Buyer's Agent
Mary Romano
RE/MAX Alliance-Boulder
List Price
$449,000
Sold Price
$440,000
Premium/Discount to List
-$9,000
-2%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.07%
Original Mortgage
$370,000
Interest Rate
3.82%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 11, 2013
Sold by
Schmid Troy D and Schmid Frances M
Bought by
Schmid Troy D
Purchase Details
Listed on
Jan 6, 2012
Closed on
Apr 3, 2012
Sold by
Saint Aubyn Homes Llc
Bought by
Schmid Troy and Schmid Frances
Seller's Agent
Stephen Balliet
Stephen Balliet
Buyer's Agent
Charlie Hartley
The Hartley Team Realty Inc
List Price
$255,250
Sold Price
$255,250
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.87%
Original Mortgage
$260,459
Interest Rate
3.97%
Mortgage Type
New Conventional
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Buie Megan Larissa | $625,000 | First Integrity Title | |
| Illa Troy | $565,000 | First American Title | |
| Illa Troy | $565,000 | First American Title | |
| Tubbs Brett Alan | $440,000 | Stewart Title | |
| Schmid Troy D | -- | None Available | |
| Schmid Troy | $255,300 | Heritage Title |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Buie Megan Larissa | $593,750 | |
| Previous Owner | Illa Troy | $437,000 | |
| Previous Owner | Tubbs Brett Alan | $370,000 | |
| Previous Owner | Schmid Troy | $260,459 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/16/2023 06/16/23 | Sold | $625,000 | 0.0% | $199 / Sq Ft | |
| 05/20/2023 05/20/23 | Pending | -- | -- | -- | |
| 05/20/2023 05/20/23 | Price Changed | $624,990 | 0.0% | $199 / Sq Ft | |
| 05/18/2023 05/18/23 | For Sale | $625,000 | +10.6% | $199 / Sq Ft | |
| 09/15/2021 09/15/21 | Off Market | $565,000 | -- | -- | |
| 06/16/2021 06/16/21 | Sold | $565,000 | +7.6% | $179 / Sq Ft | View Prior Sale |
| 05/17/2021 05/17/21 | Pending | -- | -- | -- | |
| 05/07/2021 05/07/21 | For Sale | $525,000 | +19.3% | $167 / Sq Ft | |
| 10/23/2019 10/23/19 | Off Market | $440,000 | -- | -- | |
| 07/25/2019 07/25/19 | Sold | $440,000 | 0.0% | $140 / Sq Ft | View Prior Sale |
| 07/24/2019 07/24/19 | Off Market | $440,000 | -- | -- | |
| 06/20/2019 06/20/19 | Price Changed | $440,000 | -2.0% | $140 / Sq Ft | |
| 06/01/2019 06/01/19 | For Sale | $449,000 | +75.9% | $143 / Sq Ft | |
| 01/28/2019 01/28/19 | Off Market | $255,250 | -- | -- | |
| 04/19/2012 04/19/12 | Sold | $255,250 | 0.0% | $82 / Sq Ft | View Prior Sale |
| 03/20/2012 03/20/12 | Pending | -- | -- | -- | |
| 01/06/2012 01/06/12 | For Sale | $255,250 | -- | $82 / Sq Ft |
Source: IRES MLS
Tax History Compared to Growth
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 | $3,813 | $37,440 | $7,190 | $30,250 |
| 2024 | $3,813 | $37,440 | $7,190 | $30,250 |
| 2023 | $3,657 | $40,690 | $9,130 | $31,560 |
| 2022 | $3,097 | $29,680 | $5,910 | $23,770 |
| 2021 | $3,127 | $30,530 | $6,080 | $24,450 |
| 2020 | $3,005 | $29,580 | $4,220 | $25,360 |
| 2019 | $3,050 | $29,580 | $4,220 | $25,360 |
| 2018 | $2,557 | $25,740 | $3,740 | $22,000 |
| 2017 | $2,614 | $25,740 | $3,740 | $22,000 |
| 2016 | $2,452 | $23,760 | $3,180 | $20,580 |
| 2015 | $2,377 | $23,760 | $3,180 | $20,580 |
| 2014 | $1,847 | $18,480 | $2,390 | $16,090 |
Source: Public Records
Agents Affiliated with this Home
-
Amanda D Dowell
-
N
Buyer's Agent in 2023
Non-IRES Agent
CO_IRES
-
Sarah Gooch
Seller's Agent in 2021
Sarah Gooch
Keller Williams 1st Realty
(843) 496-3458
5 in this area
50 Total Sales
-
Deano Zahakis
Buyer's Agent in 2021
Deano Zahakis
Kittle Real Estate
(970) 308-2209
2 in this area
82 Total Sales
-
Cassie Purdy
Seller's Agent in 2019
Cassie Purdy
eXp Realty - Loveland
(303) 548-7896
95 Total Sales
-
Mary Romano
M
Buyer's Agent in 2019
Mary Romano
RE/MAX
(303) 588-8433
1 in this area
45 Total Sales
Map
Source: IRES MLS
MLS Number: 988119
APN: R0728101
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information deemed reliable but not guaranteed by the MLS.
Nearby Homes
- 9041 Sandpiper Dr
- 9046 Harlequin Cir
- 9048 Harlequin Cir
- 9147 Harlequin Cir
- 9018 Harlequin Cir
- 5487 Gunnison Dr
- 9006 Harlequin Cir
- 9000 Eldorado Ave
- 5780 E Wetlands Dr
- 5758 E Wetlands Dr
- 5759 Pintail Way
- 9673 Roadrunner Ave
- 5493 Bobcat St
- 5909 E Conservation Dr
- 5520 Morgan Way
- 5046 Rangeview Ave
- 5220 Bella Rosa Pkwy
- 5520 Pinto St
- 5415 Wolf St
- 5230 Warrior St
- 9039 Sandpiper Dr
- 9035 Sandpiper Dr
- 9034 Sandpiper Dr
- 9036 Sandpiper Dr
- 9038 Sandpiper Dr
- 9033 Sandpiper Dr
- 9034 Eldorado Ave
- 9036 Eldorado Ave
- 9040 Sandpiper Dr
- 9032 Eldorado Ave
- 9038 Eldorado Ave
- 9032 Sandpiper Dr
- 9043 Sandpiper Dr
- 9039 Harlequin Cir
- 9041 Harlequin Cir
- 9030 Eldorado Ave
- 9037 Harlequin Cir
- 9042 Sandpiper Dr
- 9040 Eldorado Ave
- 9031 Sandpiper Dr