Wake up to breathtaking views and enjoy effortless lake living in this beautifully appointed 3-bedroom, 2-bath condo on Aspen Lake, Innsbrook's premier and most sought-after lake. Sold fully furnished, this turnkey retreat is ready for immediate enjoyment—just bring your suitcase and start making memories. Inside, you'll find an inviting open-concept living space centered around a cozy wood-burning fireplace, creating the perfect place to gather after a day on the water. The beautifully updated kitchen features modern finishes, stylish cabinetry, and ample prep space, making it as functional as it is attractive. Whether you're preparing a quick breakfast before heading to the lake or hosting friends for the weekend, this space is designed for easy entertaining. The spacious layout offers plenty of room for family and friends, while three comfortable bedrooms provide the ideal accommodations for weekend getaways or extended stays. Step outside and embrace the resort lifestyle with direct access to Aspen Lake, where you can spend your days boating, fishing, kayaking, paddleboarding, or simply taking in the peaceful waterfront scenery. Whether you're sipping your morning coffee or unwinding at sunset, the lake provides a spectacular backdrop to everyday life. Beyond the condo, enjoy all that Innsbrook has to offer, including an 18-hole championship golf course, clubhouse dining, swimming pool, fitness center, pickleball courts, hiking trails, beaches, and year-round community events and live entertainment. This rare opportunity combines a prime Aspen Lake location, turnkey convenience, and the unmatched Innsbrook lifestyle into one exceptional property.
3 Beds
2 Baths
1,840 sq.ft
$0 per sq.ft
Apartment Style
$ 549,900
Active
0
26047918
3
2
1,840
Innsbrook
Innsbrook
Wright City R-II
Warren
Residential
Apartment Style
Residential
$788
Last 6 closed homes in this zip.
| Address | Bd/Ba | SqFt | List | Sold | Closed |
|---|---|---|---|---|---|
| 140 Wakefield Drive, Wright City, MO 63390 | 3/2 | 1,286 | $305,000 | $305,000 100% of ask |
Aug 7, 2026 |
| 125 Fort Hancock Circle, Wright City, MO 63390 | 2/3 | 1,212 | $230,000 | $230,000 100% of ask |
Aug 5, 2026 |
| 24552 Ivy Court, Unincorporated, MO 63390 | 4/4 | 2,386 | $725,000 | $699,000 96.4% of ask |
Aug 4, 2026 |
| 511 Indian Lake Drive, Wright City, MO 63390 | 4/3 | 1,353 | $339,900 | $343,000 100.9% of ask |
Jul 31, 2026 |
| 148 Quail Creek Drive, Foristell, MO 63390 | 3/3 | 1,600 | $340,000 | $340,000 100% of ask |
Jul 30, 2026 |
| 119 Peruque Creek Manor, Wright City, MO 63390 | 3/3 | 1,365 | $309,900 | $309,900 100% of ask |
Jul 30, 2026 |
Estimate your monthly payment. Adjust the sliders below.
Estimate only. Not a loan offer. Consult a lender for an accurate quote, including HOA fees, PMI, and current rates.
Welcome to turn-key, stress-free living at 87 Beretta Ct, Wright City, MO 63390! Following an early-year fire, this home was taken down to the bare framing studs and rebuilt, inside and out—from the roof, trusses, and drywall to the plumbing, electrical, fixtures, and designer finishes—and is brand new, offering the peace of mind and quality of a new-construction build without the wait. Step inside to a bright, open-concept main floor featuring vaulted ceilings, natural light, custom arched transitions, and a warm fireplace with a floor-to-ceiling brick surround. The chef-inspired kitchen is appointed with crisp white shaker cabinetry, quartz countertops, a stylish tile backsplash, stainless steel appliances including a gas range, accent pendant lighting, and a cozy bay breakfast nook overlooking the backyard. The main-floor primary suite serves as a true private retreat, complete with vaulted ceilings, a large walk-in closet, and an elegant ensuite bath outfitted with double vanities, stylish gold hardware, and a fully tiled walk-in shower. One of the standout features of this dramatic update is the newly finished lower level, which substantially increases the overall functional square footage of the home. Designed with a sleek black exposed joist ceiling for a modern industrial-chic aesthetic and lined with durable luxury vinyl plank flooring, this versatile basement includes a spacious recreation space. It also offers a legal 4th bedroom with proper egress and a dedicated, custom-tiled full bathroom—making it the ideal setup for a guest suite, in-law quarters, or a private home office. Nestled on a quiet cul-de-sac lot, this move-in ready home offers unmatched everyday convenience. You are located just minutes from Wright City R-II schools, the Scenic Regional Library (Wright City Branch), and quick access to I-70 for an easy commute throughout Warren and St. Charles counties. Schedule your private showing today and be the first to live in this virtually brand-new masterpiece!
**Mechlin Farm** is a truly exceptional equestrian estate situated on approximately 23 scenic, rolling acres in an incredible Wright City location, with city limits bordering the property. Designed for serious equestrian use, this one-of-a-kind property offers more than 36 horse stalls, multiple fenced turnouts, six lush pastures with room for additional pastures, an outdoor riding arena and a massive heated and insulated indoor arena. The extensive equestrian facilities include a 23-stall barn with an approximately 172'x79' +/-; climate controlled indoor riding arena, 4 indoor and 3 outdoor wash stalls, tack room, office, viewing room with kitchenette, and hay storage. Additional improvements include a 5-stall barn, a 13-stall barn with concrete flooring, wash stall and tack room, plus multiple outbuildings and storage areas. A heated and insulated 72' x 54' shop features multiple overhead doors, including two approximately 14 feet high, and is currently partially leased, providing additional income to the owners. The property’s extensive storage, workshop space and accessibility also make it an excellent option for small contractors, equipment storage or a home-based business. The charming, custom-built, mostly brick 1.5-story main residence offers approximately 5,654 square feet of finished living space with five bedrooms, four full bathrooms and one half bathroom. Highlights include a main-floor primary suite, walkout lower level, oversized three-car garage, solar panels and a new furnace installed in 2025. A second residence, while in need of some updating and TLC, offers excellent potential for caretaker’s quarters, extended family, guest accommodations or additional rental income. This remarkable property is ideally suited for a large equine operation, boarding or training facility, private equestrian estate or income-producing investment. The listing includes two parcels: Tax ID 04-20.0-0-00-012.000.000 and Tax ID 04-20.0-0-00-012.157.000. **Priced to sell well below its potential value—do not wait to schedule your private showing. A property with this combination of acreage, residences, equestrian facilities and income potential will not last long!** Property is being sold in "AS IS" Condition, seller will make no repairs, inspections are for informational purposes only. **Gazebo does not stay & buyer to take over solar panel payments**
Don't miss this incredible opportunity to own a beautifully updated and well-maintained home in the sought-after Shire subdivision! This split-foyer home offers 3 bedrooms, 3 full bathrooms, a finished lower level with a functional layout designed for today’s lifestyle. The upper level features a bright living room, an inviting kitchen with an adjoining dining area, and two bedrooms, including a spacious primary suite with an ensuite bathroom. The finished lower level provides even more living space with a large family room, third bedroom, full bathroom, and additional storage—perfect for guests, a home office, or entertaining. Step outside to enjoy a nice sized fenced in backyard with plenty of room, while the attached two-car garage and newer roof add everyday convenience and peace of mind. This move-in-ready home offers the perfect combination of comfort, space, and value in a desirable neighborhood. Don’t miss your opportunity to make this home yours—you won’t want to miss this one!
