Motivated! Stunning, sprawling ranch-style home featuring 3 spacious bedrooms and 2 full bathrooms. Upon entry, you’re welcomed by modern grey and brown-toned luxury vinyl plank flooring that flows seamlessly throughout the main living areas. Two secondary bedrooms and a full bathroom are conveniently located off the entry, each offering plush carpeting, large closets, window blinds, and neutral interior paint. The open-concept great room, kitchen, and dining area create an expansive space perfect for entertaining, highlighted by abundant natural light and breathtaking mountain views through multiple large windows. The kitchen is beautifully appointed with sleek grey cabinetry with crown molding, granite countertops, stainless steel appliances, a gas stove, and an oversized walk-in pantry. The dining area connects effortlessly with both the kitchen and great room, enhancing the home’s airy, cohesive design. The primary suite is a true retreat, showcasing stunning mountain views, a private ensuite bathroom, and a generous walk-in closet with built-in shelving. Step outside to enjoy the immaculate and well maintained front and backyard, offering exceptional curb appeal. The backyard features a stamped concrete patio, lush grass, and well-kept landscaping, along with built-in lighting in the stamped stairs for added ambiance. Additional highlights include a tankless water heater, crawlspace and modern finishes throughout. This move-in-ready home truly offers the perfect blend of comfort, style, and convenience. Neighborhood paths and dog park access.
Sold for $525,000
$525,000
4155 Limestone Avenue, Longmont, CO 80504
3beds
1,503sqft
Single Family Residence
Built in 2022
6,325 Square Feet Lot
$524,900 Zestimate®
$349/sqft
$2,503 Estimated rent
Home value
$524,900
$499,000 - $551,000
$2,503/mo
Zestimate® history
Owner options
List your home for rent
$2,503/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,503/mo
Rent Zestimate®
Refinance and save
$3,321/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,321/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
Modern finishes throughoutLush grassPlush carpetingWell-kept landscapingOversized walk-in pantryAiry cohesive designGas stove
Zillow last checked:
Listing updated:
Listed by:
Corrine Lopez 720-668-6633,
Colorado Flat Fee Realty Inc
Bought with:
Sandra McGee, 100067408
West and Main Homes Inc
Source: REcolorado as distributed by MLS GRID,MLS#: 1516718
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 3
Bedroom
- Description: Carpet, Spacious, Window Blinds, Off Entry Way Access
- Level: Main
- Area: 100 Square Feet
- Dimensions: 10 x 10
Bedroom
- Description: Carpet, Spacious, Window Blinds, Off Entry Way Access
- Level: Main
- Area: 100 Square Feet
- Dimensions: 10 x 10
Bedroom
- Description: Ensuite Bathroom, Huge Walk-In Closet, Mtn Views, Carpet, Spacious
- Features: Primary Suite
- Level: Main
- Area: 168 Square Feet
- Dimensions: 14 x 12
Bathroom
- Description: Full Bath, Vinyl Floor, Tub/Shower Combo
- Level: Main
Bathroom
- Description: Ensuite, Dual Sinks
- Features: En Suite Bathroom, Primary Suite
- Level: Main
Dining room
- Description: Lvp Floor, Ki/Dr Combo, Formal
- Level: Main
- Area: 88 Square Feet
- Dimensions: 8 x 11
Great room
- Description: Great Room, Lvp Floor, Open To Kit/Di, Beautiful Windows With Mtn. Views
- Level: Main
- Area: 228 Square Feet
- Dimensions: 19 x 12
Kitchen
- Description: Lvp Flooring, Open Spacious, Grey Modern Toned Cabinetry, All Appliances Included, Gas Stove, Pantry
- Level: Main
- Area: 130 Square Feet
- Dimensions: 10 x 13
Laundry
- Description: Washer/Dryer Excluded, Vinyl Floor, Shelving
- Level: Main
- Area: 64 Square Feet
- Dimensions: 8 x 8
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator, Tankless Water Heater
Features
- Entrance Foyer, Granite Counters, High Ceilings, High Speed Internet, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Vinyl
- Windows: Double Pane Windows, Window Coverings
- Basement: Crawl Space
Interior area
- Total structure area: 1,503
- Total interior livable area: 1,503 sqft
- Finished area above ground: 1,503
Property
Parking
- Total spaces: 3
- Parking features: Concrete, Lighted, Oversized
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Front Porch, Patio
- Exterior features: Lighting, Private Yard, Rain Gutters
- Fencing: Full
- Has view: Yes
- View description: Mountain(s)
Lot
- Size: 6,325 Square Feet
- Features: Irrigated, Landscaped, Level, Open Space, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R8968468
- Zoning: sfr
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Stone
- Roof: Composition
Condition
- Year built: 2022
Details
- Builder model: Harmony
- Builder name: D.R. Horton, Inc
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Available, Natural Gas Connected, Phone Available
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell
- Senior community: Yes
- Subdivision: Lakeside Canyon
HOA
- Has HOA: Yes
- Amenities included: Trail(s)
- Services included: Reserve Fund
- HOA fee: $240 quarterly
- HOA name: RM Mead Metro District
- HOA phone: 970-663-9683
Location
- Region: Mead
Financial & listing details
- Price per square foot: $349/sqft
- Tax assessed value: $483,447
- Annual tax amount: $5,498
- Date on market: 5/5/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Washer, Dryer, Tv/Brackets, Personal Belongings
- Ownership: Individual
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 7/22/2026 | Sold | $525,000-1.1%$349/sqft |
Source:  REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 6/27/2026 | Pending sale | $530,995$353/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 6/11/2026 | Price change | $530,995-0.9%$353/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 5/23/2026 | Price change | $535,995-0.9%$357/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 5/17/2026 | Price change | $540,995-0.9%$360/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 5/11/2026 | Price change | $545,995-0.7%$363/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 5/5/2026 | Listed for sale | $549,995+14.6%$366/sqft |
Source: REcolorado as distributed by MLS GRID #1516718 Report a problem | ||
| 12/23/2022 | Sold | $479,900-4%$319/sqft |
Source:  IRES as distributed by MLS GRID #978030 Report a problem | ||
| 11/7/2022 | Pending sale | $500,000$333/sqft |
Source: IRES as distributed by MLS GRID #978030 Report a problem | ||
| 10/28/2022 | Listed for sale | $500,000$333/sqft |
Source: IRES as distributed by MLS GRID #978030 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $5,498 +16.1% | $29,580 -2.1% |
| 2025 | $4,734 +3.6% | $30,210 -1.2% |
| 2024 | $4,570 +1678.7% | $30,570 -1% |
| 2023 | $257 +41.9% | $30,870 +1944.4% |
| 2022 | $181 | $1,510 +41.1% |
| 2021 | -- | $1,070 |
Find assessor info on the county website
Neighborhood: 80504
Nearby homes
- $555,7005 bd3 ba2.6k sqft4153 Limestone Ave, Mead, CO 80504Off Market
- $546,2004 bd3 ba2.3k sqft4157 Limestone Ave, Mead, CO 80504Off Market
- $537,6003 bd3 ba2.2k sqft4151 Limestone Ave, Mead, CO 80504Off Market
- $515,5004 bd2 ba1.7k sqft4159 Limestone Ave, Mead, CO 80504Off Market
- $541,3004 bd3 ba2.4k sqft4154 Limestone Ave, Mead, CO 80504Off Market
- $533,2004 bd2 ba2.1k sqft4156 Limestone Ave, Mead, CO 80504Off Market
- $515,2004 bd2 ba1.7k sqft4152 Limestone Ave, Mead, CO 80504Off Market
- $519,4004 bd2 ba1.7k sqft4149 Limestone Ave, Mead, CO 80504Off Market
Nearby schools
GreatSchools rating
- 9/10Mead Elementary SchoolGrades: PK-5Distance: 3.4 mi
- 8/10Mead Middle SchoolGrades: 6-8Distance: 3.4 mi
- 9/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
$524,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
$524,900
- Colorado
- Weld County
- Longmont
- 80504
- 4155 Limestone Avenue
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Longmont Topics
