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.
Accepting backups
Price cut: $5K (6/11)
$530,995
4155 Limestone Avenue, Longmont, CO 80504
3beds
1,503sqft
Single Family Residence
Built in 2022
6,325 Square Feet Lot
$529,700 Zestimate®
$353/sqft
$80/mo HOA
What's special
Modern finishes throughoutLush grassPlush carpetingWell-kept landscapingOversized walk-in pantryAiry cohesive designGas stove
- 60 days |
- 668 |
- 18 |
Zillow last checked:
Listing updated:
Listed by:
Corrine Lopez 720-668-6633,
Colorado Flat Fee Realty 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: $353/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
Estimated market value
$529,700
$503,000 - $556,000
$2,552/mo
Price history
| Date | Event | Price |
|---|---|---|
| 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 |
|---|---|---|
| 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
Monthly payment
Est. payment$--/mo
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.
Climate risks
Neighborhood: 80504
Nearby schools
GreatSchools rating
- 9/10Mead Elementary SchoolGrades: PK-5Distance: 3.4 mi
- 8/10Mead Middle SchoolGrades: 6-8Distance: 3.4 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.
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.
- Colorado
- Weld County
- Longmont
- 80504
- 4155 Limestone Avenue
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Longmont Topics
