Sold for $822,000
$822,000
1740 Red Cloud Rd, Longmont, CO 80504
4beds
4,220sqft
Single Family Residence
Built in 1997
0.28 Acres Lot
$801,800 Zestimate®
$195/sqft
$3,704 Estimated rent
Home value
$801,800
$746,000 - $866,000
$3,704/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Back on the market after undergoing a $30K exterior transformation with brand-new stucco, enhancing both its curb appeal and durability. Welcome to your dream home in the prestigious Stoney Ridge neighborhood! This stunning single-family residence offers a generous 4,220 sqft of luxurious living space, meticulously designed to cater to your every need. Situated on a prime 12,007 sqft corner lot, this home exudes elegance and sophistication from the moment you arrive. Step inside to discover an inviting open floor plan featuring four spacious bedrooms and four beautifully appointed bathrooms. The oversized primary bedroom is a true sanctuary, boasting two expansive walk-in closets, providing ample storage space for your wardrobe. The en-suite primary bath is a spa-like retreat, complete with dual vanities, a luxurious soaking tub, and a separate glass-enclosed shower, perfect for unwinding after a long day. The heart of this home is the gourmet kitchen, equipped with top-of-the-line appliances, granite countertops, and custom cabinetry, making it a chef's delight. The adjacent dining area and family room are ideal for entertaining, with large windows that fill the space with natural light and offer picturesque views of the beautifully landscaped backyard. For car enthusiasts or those in need of extra storage, the oversized six-car garage is a rare find, offering ample space for vehicles, hobbies, or a workshop. Additionally, the property features convenient RV parking, catering to all your recreational needs. Outside, the expansive yard provides endless possibilities for outdoor living. Whether you envision a tranquil garden, a play area for children, or a space for al fresco dining, this generous corner lot can accommodate it all. The Stoney Ridge neighborhood is known for its serene ambiance and family-friendly environment, making it the perfect place to call home. Schedule a private tour today and experience the unmatched quality of this exquisite property.
Zillow last checked: 8 hours ago
Listing updated: October 20, 2025 at 06:52pm
Listed by:
Dallas Hidalgo 7207061411,
Ohana Style Realty
Bought with:
Benjamin Cheang, 1319626
All Pro Realty Inc
Source: IRES,MLS#: 1012264
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 3/4 bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Description: Carpet
- Features: Full Primary Bath
- Level: Upper
- Area: 504 Square Feet
- Dimensions: 24 x 21
Bedroom 2
- Description: Carpet
- Level: Upper
Bedroom 3
- Description: Carpet
- Level: Upper
Bedroom 4
- Description: Carpet
- Level: Basement
Dining room
- Description: Ceramic Tile
- Level: Main
Great room
- Description: Engineered Hardwood
- Level: Main
Kitchen
- Description: Ceramic Tile
- Level: Main
- Area: 140 Square Feet
- Dimensions: 14 x 10
Living room
- Description: Engineered Hardwood
- Level: Main
Study
- Description: Ceramic Tile
- Level: Main
Heating
- Forced Air
Cooling
- Ceiling Fan(s)
Appliances
- Included: Electric Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
Features
- Walk-In Closet(s), Kitchen Island, High Ceilings
- Basement: Full,Partially Finished
Interior area
- Total structure area: 4,220
- Total interior livable area: 4,220 sqft
- Finished area above ground: 2,917
- Finished area below ground: 1,303
Property
Parking
- Total spaces: 6
- Parking features: Garage Door Opener, RV Access/Parking, Oversized
- Attached garage spaces: 6
- Details: Attached
Features
- Levels: Bi-Level
- Patio & porch: Patio
- Fencing: Fenced
Lot
- Size: 0.28 Acres
- Features: Corner Lot, Paved, Curbs, Gutters, Sidewalks, Street Light
Details
- Parcel number: R0108978
- Zoning: Res
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stucco
- Roof: Composition
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available
Community & neighborhood
Security
- Security features: Fire Alarm
Location
- Region: Longmont
- Subdivision: Stoney Ridge 9th Flg
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
Price history
| Date | Event | Price |
|---|---|---|
| 10/30/2024 | Sold | $822,000-2%$195/sqft |
Source: | ||
| 9/27/2024 | Pending sale | $839,000$199/sqft |
Source: | ||
| 8/29/2024 | Price change | $839,000-1.3%$199/sqft |
Source: | ||
| 7/18/2024 | Listed for sale | $850,000$201/sqft |
Source: | ||
| 7/8/2024 | Pending sale | $850,000$201/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,998 +1.4% | $50,725 -9.3% |
| 2024 | $4,930 +15.6% | $55,938 -1% |
| 2023 | $4,263 -1.3% | $56,481 +31.1% |
Find assessor info on the county website
Neighborhood: Lanyon
Nearby schools
GreatSchools rating
- 7/10Alpine Elementary SchoolGrades: PK-5Distance: 0.3 mi
- 4/10Timberline Pk-8Grades: PK-8Distance: 0.7 mi
- 3/10Skyline High SchoolGrades: 9-12Distance: 0.6 mi
Schools provided by the listing agent
- Elementary: Alpine
- Middle: Heritage
- High: Skyline
Source: IRES. 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$801,800
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
$801,800


