Why wait for new construction when this 2-year-old DR Horton home offers everything you need—already finished—saving you tens of thousands? Situated on a large peaceful corner lot with fewer neighbors and mountain views, you’re just minutes from Barefoot Lakes’ paddle boarding, kayaking, playgrounds, and trails. The neighborhood also boasts scenic walking paths, a large community park, and two dog parks for your four-legged family members. Easy I-25 access makes trips to Denver, Boulder, or Northern Colorado a breeze.
Inside, the bright, open kitchen shines with natural light on the white cabinets, stainless steel appliances, granite counters, and an updated dining room light fixture—perfect for family meals. The main-floor office/den offers a quiet work-from-home space, while the upstairs loft is ready to become the ultimate playroom, game space, or homework zone. The huge primary retreat is a restful getaway, with two additional bedrooms giving everyone their own space.
Step outside to a fully fenced and landscaped backyard with an extended concrete patio—ideal for summer BBQs, playtime, or simply relaxing. No dirt lot, no waiting, just instant enjoyment. Add in a tankless water heater, welcoming front patio, and a family-friendly neighborhood, and you have the perfect blend of comfort, convenience, and community.
Sold for $515,000
$515,000
4146 Limestone Avenue, Longmont, CO 80504
3beds
2,222sqft
Single Family Residence
Built in 2023
8,201 Square Feet Lot
$513,900 Zestimate®
$232/sqft
$2,904 Estimated rent
Home value
$513,900
$488,000 - $540,000
$2,904/mo
Zestimate® history
Owner options
List your home for rent
$2,904/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,904/mo
Rent Zestimate®
Refinance and save
$3,192/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,192/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Mountain viewsCorner lotStainless steel appliancesGranite countersBright open kitchenWelcoming front patioWhite cabinets
Zillow last checked:
Listing updated:
Listed by:
Gabrielle Wunderlich 303-720-3003 Gabrielle@YourWunderHome.com,
Real Broker, LLC DBA Real,
COMMUNITY Team 720-690-5745,
Real Broker, LLC DBA Real
Bought with:
Dylan Nash, 100072476
LoKation Real Estate
Source: REcolorado as distributed by MLS GRID,MLS#: 4616409
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom
- Description: South Facing Bedroom
- Level: Upper
Bedroom
- Description: West Facing Bedroom Overlooking The Front Of The Home And Front Range Views
- Level: Upper
Bathroom
- Description: Large Full Bathroom On Second Floor For Bedrooms 2 And 3
- Level: Upper
Bathroom
- Description: Half Bath On The Main Floor For Easy Access
- Level: Main
Other
- Description: Expansive Primary Suite With Sitting Area, King Size Bedroom Set, Large Walk In Closet And En Suite Bathroom, Dual Windows Looking Out At The Mountains In The Distance
- Level: Upper
Other
- Description: Huge En-Suite Primary Bathroom With Dual Sinks, Linen Closet, Large Spa Shower
- Level: Upper
Den
- Description: Office On Main Level At Home Entryway
- Level: Main
Dining room
- Description: Open Concept Kitchen, Dining, Living, Great Room With Patio Access
- Level: Main
Kitchen
- Description: Open Concept Kitchen With Large Island For 4 Person Seating
- Level: Main
Laundry
- Description: Laundry Room Upstairs For Easy Access
- Level: Upper
Living room
- Description: Large Open Living Room With Loads Of Natural Light
- Level: Main
Loft
- Description: Large Loft For Playroom, Office, Work From Home, Remote Work Area
- Level: Upper
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Disposal, Microwave, Refrigerator, Self Cleaning Oven, Tankless Water Heater
- Laundry: In Unit
Features
- Entrance Foyer, Granite Counters, Kitchen Island, Open Floorplan, Primary Suite, Radon Mitigation System, Smoke Free, Wired for Data
- Flooring: Carpet, Tile, Vinyl
- Windows: Double Pane Windows, Window Coverings
- Has basement: No
- Common walls with other units/homes: No Common Walls
Interior area
- Total structure area: 2,222
- Total interior livable area: 2,222 sqft
- Finished area above ground: 2,222
Property
Parking
- Total spaces: 2
- Parking features: Concrete, Garage Door Opener, Storage
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: Ground
- Patio & porch: Front Porch
- Exterior features: Lighting, Private Yard
- Fencing: Full
- Has view: Yes
- View description: City, Mountain(s)
Lot
- Size: 8,201 sqft
- Features: Corner Lot, Foothills, Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
- Residential vegetation: Grassed
Details
- Parcel number: R8968456
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Composition
Condition
- Year built: 2023
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Internet Access (Wired), Natural Gas Available
Green energy
- Energy efficient items: Appliances, Construction, HVAC, Thermostat, Water Heater, Windows
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Security System, Video Doorbell
Location
- Region: Mead
- Subdivision: Lakeside Canyon
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $180 quarterly
- Amenities included: Park, Playground, Trail(s)
- Services included: Road Maintenance, Trash
- Association name: RM Mead Metro District
- Association phone: 970-663-9683
Other
Other facts
- Listing terms: 1031 Exchange,Cash,Conventional,FHA,Other,VA Loan
- Ownership: Individual
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 11/20/2025 | Sold | $515,000-1%$232/sqft |
Source:  REcolorado as distributed by MLS GRID #4616409 Report a problem | ||
| 10/1/2025 | Pending sale | $520,000$234/sqft |
Source: REcolorado as distributed by MLS GRID #4616409 Report a problem | ||
| 9/20/2025 | Listed for sale | $520,000$234/sqft |
Source: REcolorado as distributed by MLS GRID #4616409 Report a problem | ||
| 8/25/2025 | Listing removed | $520,000$234/sqft |
Source: REcolorado as distributed by MLS GRID #4616409 Report a problem | ||
| 8/15/2025 | Listed for sale | $520,000+1.9%$234/sqft |
Source: REcolorado as distributed by MLS GRID #4616409 Report a problem | ||
| 7/31/2023 | Sold | $510,090-4%$230/sqft |
Source: Public Record Report a problem | ||
| 2/8/2023 | Listed for sale | $531,090$239/sqft |
Source:  DR Horton Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,177 +359.9% | $33,110 +0.1% |
| 2024 | $1,126 +338.1% | $33,070 +399.5% |
| 2023 | $257 +41.9% | $6,620 +338.4% |
| 2022 | $181 | $1,510 +41.1% |
| 2021 | -- | $1,070 |
Find assessor info on the county website
Neighborhood: 80504
Nearby schools
GreatSchools rating
- 9/10Mead Elementary SchoolGrades: PK-5Distance: 3.4 mi
- 8/10Mead Middle SchoolGrades: 6-8Distance: 3.5 mi
- 7/10Mead High SchoolGrades: 9-12Distance: 1.1 mi
Schools provided by the listing agent
- Elementary: Mead
- Middle: Mead
- High: Mead
- 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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$513,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$513,900
- Colorado
- Weld County
- Longmont
- 80504
- 4146 Limestone Avenue
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Longmont Topics
