Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

Popular Features

Community Features

Association

Property Features

Waterfront

View

Exterior Features

Interior Features

Style

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

Incredible and Rare opportunity to own a beautifully restored, income-producing historic landmark in the heart of Historic Hermann! Built around 1880, this impressive 2½-story brick building offers multiple revenue streams and a prime downtown location just steps from Hermann’s shops, restaurants, wineries, and attractions.
Extensively updated in 2020, the property features new electrical service and wiring, plumbing, bathrooms, water heaters, water softener, HVAC systems, a metal roof, stonework, third-floor vinyl windows, and a spacious composite deck. A rear main-level addition was completed in 2023, further enhancing the property’s functionality and appeal.
The building includes three retail spaces—two leased storefronts on the main level and one second-floor studio currently occupied by the owner, each with its own half bath. The second floor also features four established short-term rental guest suites, operating as The Artist Suites, each with a private full bath. The third floor offers a loft apartment that is currently leased, providing yet another reliable income source.
Additional highlights include a stone storage building, off-street parking for six vehicles with convenient alley access, and an unbeatable downtown location in one of Missouri’s premier tourist destinations.
Whether you’re looking to expand your investment portfolio or own a turnkey mixed-use property with proven income potential, this one-of-a-kind Hermann landmark is an opportunity you won’t want to miss! This is a Duplicate Listing of MLS# 26040618
#26043923

Hermann

409 Market Street

None Beds

None Baths

N/A

$1,195,000

MLS#: 26043923

Exceptional brick & stone great room ranch from award-winning Lombardo Homes. This custom-built contemporary features sophisticated interior detailing & premium builder upgrades throughout including porcelain tile flooring, 11’ ceilings & full-height windows with transoms. Impressive covered porch entrance with 8’ front door leads to tiled foyer, formal dining room with tray ceiling and stunning great room with linear fireplace flanked by open shelving & built-in storage cabinets. The main living area unfolds into the designer kitchen featuring glazed maple Shaker cabinetry, double stacked mitered Cambria quartz countertops, KitchenAid appliances, 10’ center island with waterfall edges & butler’s pantry and light-filled breakfast room with sliding glass door that opens to deck. Primary bedroom suite with 2 customized walk-in closets, wide bay window & expansive bath with walk-through shower &freestanding tub offers an appealing retreat. 2 Additional bedrooms & hall full bath complete the main floor living quarters. Open staircase accesses Lower Level entertainment space with recreation room &gathering bar plus office, 4th bedroom & full bath. Situated on a premium lot at the end of the cul-de-sac with covered deck, aggregate patio & oversized 3-car garage
#26026601

O'Fallon

9 Keeney Creek Court

4 Beds

3 Baths

4,502 Sq.Ft.

$1,195,000

MLS#: 26026601

Extremely gentle lakefront, 125 feet of shoreline, and views for days! Welcome to 643 Heron Estates Drive, ideally located off highly desirable Sellers Road. This spacious lakefront home sits on a nearly level lot, offering rare, easy access from the home to the water.

Inside, the open main level features abundant natural light, multiple gathering spaces, a well-appointed kitchen with generous cabinetry, and direct access to a large deck overlooking the lake. The home offers 5 comfortable bedrooms, multiple living and entertaining areas, a private primary suite, a jetted tub, main-level laundry, and plenty of room for family and guests.

Mature trees, attractive landscaping, an attached two-car garage, and a covered dock with two boat lifts and a PWC lift complete the package. Whether you are searching for a full-time residence or weekend retreat, this property delivers exceptional lake views, amazing waterfront, and the relaxed Lake of the Ozarks lifestyle buyers are looking for.
#3588965

Camdenton

643 Heron Estates Drive

5 Beds

3 Baths

4,177 Sq.Ft.

$1,195,000

MLS#: 3588965

Built circa 1869 and rooted in more than 150 years of St. Louis history, 1840 South 8th Street is a remarkable Soulard residence where the architecture tells a story all its own. Historical research traces the home to German born bricklayer and stonemason Charles Eyermann, with later two story additions made during the ownership of prominent commission merchant Julius Petersen. The property has evolved through generations while retaining the craftsmanship and character that make historic Soulard homes so distinctive. Extensive whole house renovations have been completed inside and out with particular attention paid to preserving the architectural integrity of the residence. Exterior improvements include intricate mansard shingles and gutters thoughtfully executed to remain consistent with the home’s historic architecture, while comprehensive interior renovations allow the house to function beautifully for modern living without sacrificing the details that give it its identity. Inside, original wood floors, substantial millwork, exposed brick, soaring ceilings and an extraordinary carved stone fireplace create a dramatic backdrop for a home that is anything but ordinary. Rich color, statement lighting and thoughtfully selected finishes bring a sophisticated, collected sensibility to the historic interiors. The expansive living and dining spaces flow together beautifully, equally suited to entertaining a crowd or enjoying the intimacy of the home’s architectural details. The kitchen offers an unexpected amount of space for a home of this vintage, with extensive cabinetry, stone countertops, a large center island with seating, stainless appliances, abundant storage and a casual dining area surrounded by natural light. Original wood floors continue throughout, while the adjoining staircase, period trim and preserved architectural elements provide a constant connection to the home’s past. Perhaps most compelling is the juxtaposition of old and new. Ornate millwork meets contemporary art. Exposed brick sits alongside jewel toned walls. Historic woodwork, distinctive lighting and modern furnishings give the interiors a personality rarely found in a conventional renovation. Even the hallways have been treated as architectural moments, with dramatic wallcoverings, custom lighting and carefully preserved trim. The documented history of 1840 South 8th stretches from its likely construction around 1869 through generations of owners and uses, including more than five decades associated with the Petersen family. The historical record also documents two story additions dating to the 1880s, adding another layer to the story of a residence that has continually adapted while remaining unmistakably connected to its origins. This is not a reproduction of historic St. Louis. It is the real thing. Meticulously renovated, architecturally significant and unmistakably individual, 1840 South 8th offers the increasingly rare opportunity to own a piece of Soulard history that has been carefully stewarded for its next chapter.
#26053676

St Louis

1840 S 8th Street

5 Beds

2 Baths

3,959 Sq.Ft.

$1,195,000

MLS#: 26053676

Event Center, Brewery & Winery. This exceptional 67 acre commercial and agricultural property is part of the renowned Hermann Wine Trail.  The 5200 sq.ft. Microbrewery/Winery is perched on a bluff with sweeping views of the Missouri River bottoms. This turnkey operation includes all brewery/winery equipment and inventory, offering a seamless transition for a new owner. 
The Hearth Room provides indoor seating for 100 guests, a stone fireplace for warm inviting year-round hospitality.  There are outdoor seating areas to enjoy live music from the band stand while viewing the 6 acre vineyard. The property also features a charming 3 bed, 2 bath residence, a 36' x 40' multipurpose building, and a stocked pond. Ideal for events, wedding venue, production, or expansion. This unique property blends natural beauty, income producing potential, and multiple improvements in an unmatched setting.
#26012393

Berger

3166 Highway B

None Beds

None Baths

5,220 Sq.Ft.

$1,195,000

MLS#: 26012393

Price reduced
Checkout this C1 Commercial Zoned property in Warren County right on Highway 47 at the corner of Hwy 47 and Quarry Rd. This 7.25+/- acre parcel includes 2 buildings with a combined total of 18,312 sq ft under roof. The first building is approximately 5,212 sq ft and includes Office space, Living Space, and 2 large pulls through bays overlooked by an inspection balcony. Each Bay is 60' long one bay is 27' wide and the other is 16' wide. Each bay has pull through garage doors. The larger bay has a set of 12' tall x 16' wide garage doors, and the second bay has two 10' x 10' garage doors. This building has been used to build, fabricate, and store material needed for construction. The second building is approximately 13,100 sq ft.  The original plan was to provide space for a large fabrication shop and a tool and die facility. This large building has a lot of possibilities. It is under roof and can be finished specific to your company needs.
#26018871

Unincorporated

19199 Quarry Road

None Beds

None Baths

N/A

$1,195,000

MLS#: 26018871

This extraordinary parcel in the heart of Town and Country offers a rare blend of privacy and convenience. Enter from Brook Mill Lane through the quiet neighborhood into the mowed drive. Atop the flat hill, nearly one-acre has been cleared and is ready for your dream home. Mature trees surround the 3.66 acre property, creating a secluded, park-like, private setting. This unique property presents an exceptional opportunity to create a custom estate in one of the area's most desirable locations. Soil testing and tree survey have been completed. Electric, gas, water, and cable are on the property. Conveniently located, this special piece of land is an ideal place to create a special retreat in St. Louis County. Access to the property is from Brook Mill Lane. From Clayton Road east of 141, turn north on Old Woods Mill Road, turn right on Brook Mill Lane. The access to the property is on your left after on Brook Mill. There is a clear cut grass pathway to the property. Enjoy this link to drone footage of the property. https://youtu.be/HUA68I2NexI
#26033936

Chesterfield

702 Salt Mill Road

None Beds

None Baths

3.66 acres

$1,195,000

MLS#: 26033936

Spectacular brick & stone 1.5-Sty on wooded 3-acre lot in beautiful August Estates. Impressive 2-sty foyer leads to coffered dining room with wide bay window & arched entryway framed by architectural columns and stunning great room with dramatic wall of windows & granite fireplace.  Designer kitchen with staggered white cabinetry, granite countertops, stainless steel appliances & 7’ center island adjoins breakfast room with convenient planning center & vaulted hearth room highlighted by floor-to-ceiling stone fireplace. Coffered primary bedroom suite with luxury bath offers an appealing retreat. Oak staircase accesses 3 additional bedrooms, 1 with ensuite bath & 2 with Jack n’ Jill bath, & bonus loft room. Lower Level entertainment space includes recreation room with wet bar, family room with 3rd fireplace & game room plus workout room, 5th bedroom & full bath. Atrium doors open to outdoor living area with pool, composite deck, covered patio & open patio with full-height fireplace.
#26007745

Defiance

1199 August Lake Drive

5 Beds

4 Baths

5,045 Sq.Ft.

$1,195,000

MLS#: 26007745

Better than new construction, this 1.5 story home sits on one of the largest (over an acre) & most private lots in Eagle Crest. Every available option was included in the original construction & has been extensively updated. The 2 story foyer features an expansive staircase w/iron spindles & French doors leading to a custom paneled library/music rm w/1 of 5 fireplaces found in this home. The 3 rm master suite boasts a sitting room w/FP & newer bath w/travertine marble. The Greatroom will take your breath away with a 20 ft wall of windows that captures this stunning backyard setting. The open kitchen is updated w/gorgeous granite counters & new appliances. Every bedroom has a walk-in closet & private bath access, all remodeled & there’s a 2nd floor family room & ‘Kids Cave.’ The W/O lower level offers expansive entertaining space & features a 15 ft granite bar, wine room, billiard area, exercise/bonus rm & 3 room In-law Suite. Plus a 4 car garage!
#18000239

Chesterfield

16843 Eagle Bluff Court

7 Beds

6 Baths

8,531 Sq.Ft.

$1,195,000

MLS#: 18000239

Excellent investment opportunity for a combined use office space and warehouse facility located off of Highway 94.  Abundant parking space in both the front office area, side warehouse space, and to the rear of the property.  Property is currently zoned AC1.  The 2 Story Office space offers a spacious training area on the top floor as well as functional and versatile offices and work space on the main.  The attached warehouse is ideal for equipment storage and shop operations. This property also features motion sensor lighting, newer electrical, and ability to park a fleet of vehicles in the rear fenced area. Find drive through overhead doors in the warehouse as well. Location: Industrial Area
#22039501

St Charles

1805 Scherer Parkway

None Beds

None Baths

17,280 Sq.Ft.

$1,195,000

MLS#: 22039501

The 16th floor at 801 Skinker overlooks our magnificent Forest Park, with the Arch and our beautiful St.Louis beyond.  9 foot floor-to-ceiling all-glass walls present this unreal setting.  Beautifully laid out with 3 spacious bedrooms and 4 baths.  Up-to-date in every sense.  Design by Arlene Lily. Cannot get any better. 24/7 doorman service in addition to the other high-end amenities. An exercise room not to be believed. The Demun neighborhood includes coffee, restaurants, smoothies, etc. Totally walkable when compared to the busy Clayton area. Dogs allowed after interview approval !! The rooftop terrace and enclosed party facility are free for all to enjoy. Two apartments available for your visiting guests. 2 parking spaces. Extra storage. Minutes from all St.Louis institutions thanks to this ideal central location. Experienced staff & management. Pictures do not do justice. Also, see our video !! You will love this modern high-rise community. It is the best urban living in St.Louis. Location: City, Corner Location, Upper Level
#22077450

St Louis

801 S Skinker Boulevard 16B

3 Beds

3 Baths

2,843 Sq.Ft.

$1,195,000

MLS#: 22077450

PICS IN FRIDAY ! Exceptional opportunity to own a charming two story in sought after Dromora. Lush front yard landscaping welcomes you into a peaceful setting. Fresh modern look with refinished hardwood floors. Inviting formal living room with gas fireplace and custom built-ins. Exquisite millwork and natural light grace each room. Spacious dining room for effortless entertaining. Family room features additional gas fireplace and 4 sets of French doors that walk-out to exterior patio. Cook’s kitchen with a cozy breakfast room with built-in bench. Upper level includes four bedrooms, with a private Owner’s Suite wing with dressing rm, sitting rm and large bath. Two additional full baths on upper level. Wonderfully crafted main floor laundry. Expansive and level yard with ample room for a pool! The perfect neighborhood just minutes from Clayton. Create your dream.
#20023484

St Louis

12 Dromara Road

4 Beds

3 Baths

3,853 Sq.Ft.

$1,195,000

MLS#: 20023484

This is an exciting opportunity to purchase what was once esteemed architect, Harris Armstrong’s, former studio and offices. Over the years it has been expanded and transformed into a residence. A koi pond greets you as you venture towards the front door. The living room features a fireplace and is open to the dining room & kitchen. An abundance of windows throughout look onto the private yard, woods, and golf course beyond. There is an office, den & family room. Off of the family room is an expansive screened porch that leads to the terrace. The primary bedroom is spacious with doors that also lead to the terrace, a woodburning fireplace, jacuzzi tub, walk-in closet & an expansive bathroom with dual sink vanity. The main level has 2 more bedrooms, a recreation room that could be an additional bedroom, wine room & hobby shop. The upper area has a sitting room & 2 en-suite bedrooms. 2-car garage with epoxy painted floor & storage cabinets. Additional Rooms: Sun Room
#20081456

St Louis

934 Singlepath Lane

6 Beds

4 Baths

4,822 Sq.Ft.

$1,195,000

MLS#: 20081456

Incredible opportunity to own one of the largest, most pristinely-maintained four-family apartment buildings in Clayton!  Nestled in the heart of the enviable DeMun Neighborhood, this property boasts sizeable renovated 2-bedroom units with hardwood floors, great natural lighting, in-unit washers & dryers. Large updated kitchen with granite countertops and stainless appliances. Central AC & Forced-air heat. All units have the same layout &finishes, with minor differences: whereas the two west side units have kitchens with cherry cabinets & a large closet off the dining room, the two east side units have white cabinets & a second half-bathroom in lieu of the closet off the dining room. Updated plumbing throughout, updated electric including panels.  Solid brick building, roof in great shape, one-to-one off-street parking in the rear. Offered at a 5.97% cap rate with conservative pro forma market rents, buildings of this caliber do not come available often.  Call today! NOI is pro forma
#22047016

St Louis

6423 Alamo Avenue

None Beds

None Baths

4,596 Sq.Ft.

$1,195,000

MLS#: 22047016

Welcome to this magnificent Town and Country estate. This stately residence presents meticulously updated main-floor living areas, spacious bedrooms, and 3.5 elegantly modernized bathrooms. Step inside to be greeted by soaring ceilings, custom built-ins, and crown molding, all contributing to an ambiance of timeless sophistication. The northeastern exposure fills the home with natural light, illuminating gleaming hardwood floors and tasteful updates.
The main level exudes elegance, featuring a custom office and an inviting living area. The expansive, renovated kitchen, with views of the lush backyard and in-ground pool, serves as the heart of the home. The primary suite offers a luxurious ensuite bath and three oversized custom walk-in closets. Outdoors, the property transforms into a private sanctuary with an in-ground pool and a fenced backyard, ideal for relaxation and entertaining. A perfect fusion of classic charm and modern amenities in an unparalleled location. Additional Rooms: Sun Room
#24060203

Chesterfield

1025 Wellington Terrace

4 Beds

3 Baths

4,044 Sq.Ft.

$1,195,000

MLS#: 24060203

1 ... 425 426 427 428 429 ... 666
* Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2024. First Multiple Listing Service, Inc.
 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Rock Island Realty via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Rock Island Realty via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.