REALHUB is on fire today

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

40 m/l acre tract located in Camden County. This tract has mature, old growth ,marketable timber. Great deer and turkey hunting with an established food plot several potential building spots, and a wet weather creek running through.  Close proximity to the little Niangua creek and Lake Of the Ozarks for great fishing and recreation. An access road is being put in the center between the tracts and will have an electric access easement in place along it. More tracts available. Tracts to be surveyed. Owner will entertain selling other options.
#26043541

Macks Creek

TBD Geronimo Springs Road-Tract 4

None Beds

None Baths

40.0 acres

$220,000

MLS#: 26043541

40 m/l acre tract located in Camden County. This tract has mature, old growth ,marketable timber. Great deer and turkey hunting.  Close proximity to the little Niangua creek and Lake Of the Ozarks for great fishing and recreation. An access road is being put in the center between the tracts and will have an electric access easement in place along it. More tracts available. Tracts to be surveyed. Owner will entertain selling other options.
#26043547

Macks Creek

TBD Geronimo Springs Road-Tract 5

None Beds

None Baths

40.0 acres

$180,000

MLS#: 26043547

40 m/l acre tract located in Camden County. This tract has mature, old growth ,marketable timber. Great deer and turkey hunting ,several potential building spots, and a wet weather creek frontage.  Close proximity to the little Niangua creek and Lake Of the Ozarks for great fishing and recreation. An access road is being put in the center between the tracts and will have an electric access easement in place along it. More tracts available. Tracts to be surveyed. Owner will entertain selling other options.
#26043518

Macks Creek

TBD Geronimo Springs Road-Tract 3

None Beds

None Baths

40.0 acres

$180,000

MLS#: 26043518

An exceptional turnkey business opportunity awaits in the heart of historic downtown Alton with the sale of Morrison’s Irish Pub, a well-established and fully operational Irish pub. This beloved corner property combines rich heritage, strong community ties, and an inviting pub atmosphere, making it a rare find for investors or owner-operators seeking a turnkey business in a vibrant location. Morrison’s Irish Pub has built a strong reputation for its hearty Irish-American cuisine, extensive whiskey and craft beer selection, and vibrant entertainment offerings, including live music on weekends. The property includes approximately 3,000 square feet of mixed-use space across three levels. The main floor features a cozy, fully furnished bar and dining area with seating for around 50 guests. The space has been thoughtfully designed with exposed brick walls, handcrafted woodwork, barnwood flooring, and authentic Irish decor—creating a warm, welcoming environment that has become a favorite among locals and visitors alike. A fully equipped commercial kitchen and custom-built bar make this a ready-to-go operation. With 12 beer taps, a full bar, and a loyal customer base, the pub enjoys excellent reviews across TripAdvisor, Yelp, and Google. All furniture, fixtures, equipment, and branding are included in the sale, allowing for a smooth transition for the next owner.

The second and third floors offer approximately 2,000 square feet of living space with a private entrance, featuring 2 bedrooms, 2.5 bathrooms, a full kitchen, dining area, and living room—perfect for owner occupancy, extra office space, or storage.
#26043643

Alton

200 State Street

2 Beds

2 Baths

2,000 Sq.Ft.

$549,000

MLS#: 26043643

40 m/l acre tract located in Camden County. This tract has mature, old growth ,marketable timber. Great deer and turkey hunting.  Close proximity to the little Niangua creek and Lake Of the Ozarks for great fishing and recreation. An access road is being put in the center between the tracts and will have an electric access easement in place along it. More tracts available. Tracts to be surveyed. Owner will entertain selling other options.
#26043554

Macks Creek

TBD Geronimo Springs Road-Tract 6

None Beds

None Baths

40.0 acres

$180,000

MLS#: 26043554

*For comp purposes only.*
#26043940

St Louis

5016 Sutherland Avenue

3 Beds

2 Baths

1,738 Sq.Ft.

$350,000

MLS#: 26043940

Located in the highly sought after Cherry Hill West community, this ranch-style residence is the perfect place to write your next chapter. With 3 bedrooms, 3 full bathrooms and over 3,000 square feet of living space, this home is the one you've been waiting for! Step inside to find a layout designed for effortless living, with a formal dining room, spacious living room w/gleaming hardwoods, and cozy family room w/beamed ceilings & fireplace! The heart of the home is a kitchen built for the culinary enthusiast, uniquely equipped with dual cooktops ideal for holiday hosting or impressive meal prep. The screened in porch is the perfect place to enjoy that morning coffee or unwind after a long day. Beneath the current carpet lie original hardwoods waiting for their moment to shine! Downstairs, the walkout lower level adds incredible versatility with a large media room, a dedicated office or sleeping area, and a third full bathroom. Recent updates provide peace of mind, including a new furnace w/humidifier (2024) and some new windows (2025) in key living areas. Outside, a fully fenced backyard offers privacy and room to play!  Located in a premier location in the Marquette boundary of Rockwood School District with easy access to everything, this home isn't just a place to live; it's an opportunity to build equity and make memories for years to come! The Wolf Cafe will be your new hang out, just steps from home! Don't miss this one - schedule your showing today!
#26024117

Ellisville

343 Cherry Hill Drive

3 Beds

3 Baths

2,060 Sq.Ft.

$389,900

MLS#: 26024117

Exceptional Frontenac Woods residence set on a beautifully landscaped one-acre lot within the award-winning Ladue School District. Thoughtfully expanded and extensively renovated, this remarkable home seamlessly blends timeless design with modern comfort, offering a rare combination of elegant living spaces, a main-floor primary suite, a finished walk-out lower level, a resort-style backyard, and a three-car rear-entry garage.

A gracious entry introduces sophisticated yet comfortable interiors filled with natural light, rich hardwood flooring, and beautifully proportioned living spaces designed for both everyday living and effortless entertaining. At the heart of the home is a stunning expanded kitchen featuring generous workspace, a large walk-in pantry, a built-in planning station, and seamless flow to the surrounding gathering areas. The adjoining family room is anchored by a striking floor-to-ceiling stone fireplace, creating a warm and inviting focal point.

The spacious main-floor primary suite serves as a private retreat, offering hardwood floors, a walk-in closet, and a beautifully updated bath. Upstairs, hardwood flooring extends throughout all bedrooms and hallways, complemented by fully renovated baths and enhanced comfort provided by a dedicated third HVAC system.

The finished walk-out lower level significantly expands the home's living and entertaining capabilities, featuring a recreation area, kitchen space, updated bath, gas fireplace, and direct access to the outdoor amenities—ideal for hosting guests, poolside gatherings, or multi-generational living.

Designed for year-round enjoyment, the backyard offers a true resort-like setting. An inground saltwater pool, pergola, raised garden beds, lush landscaping, and expansive patios create a private outdoor sanctuary rarely found in such a central location.

Extensive updates throughout the home include Hardie Board siding, replacement windows, enhanced insulation, upgraded mechanical systems, a custom entry door, and numerous thoughtful improvements that reflect meticulous ownership and pride of maintenance.

Perfectly situated in one of Frontenac's most desirable neighborhoods, this exceptional property offers privacy, convenience, and an unparalleled lifestyle just moments from premier schools, shopping, dining, hospitals, and major commuter routes.
#26033945

Frontenac

1688 Frontenac Woods Lane

4 Beds

4 Baths

5,123 Sq.Ft.

$1,549,000

MLS#: 26033945

Introducing Native Ridge, an exclusive new development. Penthouse style luxury living. Each 3,500 SQFT residence pairs a massive 25' x 70' climate-controlled luxury locker Suite with a stunning 1,750 sq. ft., 3-bedroom, 2.5-bath home above, accessible by private elevator or staircase. The main level features 6-inch concrete floors with epoxy finish, upgraded metal interior walls, kitchenette, half bath, laundry hookups, oversized fan and a 16' x 15' insulated overhead door. Upstairs, soaring 14' ceilings showcase an open-concept great room with fireplace and designer kitchen featuring quartz or granite countertops, stainless appliances, custom soft-close cabinetry and crown molding with accent lighting. The luxurious primary suite offers a spacious walk-in closet, heated tile floors, dual vanity, walk-in shower with jetted tub and private water closet. Two guest rooms feature walk-in closets and a Jack-and-Jill bath. Native Ridge will offer an exceptional lifestyle with a clubhouse, pool, pickleball court, nature trails, boat ramp, lake access & boat slip availability.
#3588652

Sunrise Beach

201 Native Ridge Circle 201

3 Beds

2 Baths

3,500 Sq.Ft.

$1,395,000

MLS#: 3588652

Introducing Native Ridge, an exclusive new development. Penthouse style luxury living. Each 3,500 SQFT residence pairs a massive 25' x 70' climate-controlled luxury locker Suite with a stunning 1,750 sq. ft., 3-bedroom, 2.5-bath home above, accessible by private elevator or staircase. The main level features 6-inch concrete floors with epoxy finish, upgraded metal interior walls, kitchenette, half bath, laundry hookups, oversized fan and a 16' x 15' insulated overhead door. Upstairs, soaring 14' ceilings showcase an open-concept great room with fireplace and designer kitchen featuring quartz or granite countertops, stainless appliances, custom soft-close cabinetry and crown molding with accent lighting. The luxurious primary suite offers a spacious walk-in closet, heated tile floors, dual vanity, walk-in shower with jetted tub and private water closet. Two guest rooms feature walk-in closets and a Jack-and-Jill bath. Native Ridge will offer an exceptional lifestyle with a clubhouse, pool, pickleball court, nature trails, boat ramp, lake access & boat slip availability.
#3588653

Sunrise Beach

104 Native Ridge Circle 104

3 Beds

2 Baths

3,500 Sq.Ft.

$1,295,000

MLS#: 3588653

This fully leased multi-tenant retail plaza is a rare opportunity in the highly desirable Saint Charles market. Located along Campus Drive, this established multi-tenant property consists of eight occupied storefronts serving a diverse mix of local businesses, including restaurant, wellness, professional services, chiropractic, beauty, and personal care tenants.
The property generates $103,455 in annual gross rental income and delivers a strong Net Operating Income (NOI) of $86,848, providing investors with immediate cash flow and stable in-place tenancy. Monthly rents include CAM reimbursements, helping support consistent operating performance and expense recovery. 
Strategically positioned in a growing commercial corridor with convenient access to major thoroughfares, the plaza benefits from strong visibility, ample parking, and a tenant roster that serves the surrounding residential and business communities. The diversified tenant mix reduces vacancy risk while creating a dependable income stream for investors seeking a stabilized asset.
Whether you are completing a 1031 exchange, expanding your investment portfolio, or seeking a management-friendly commercial asset, this neighborhood retail center offers an attractive combination of income, stability, and upside potential. Offered For Sale – Contact Listing Agent for Pricing, Financials, and Showing Information.
#26042524

St Charles

2040 Campus Drive

None Beds

None Baths

N/A

$1,050,000

MLS#: 26042524

Prime Investment Opportunity with Multiple Income Streams!

Don’t miss this exceptional mixed-use commercial property offering endless potential for investors or owner-operators alike. This income-producing property features multiple office and retail spaces, with tenants already in place, creating immediate rental income. In addition, a separate apartment located at the rear of the property provides an additional source of revenue.

Situated on +/- 2.70 acres, this property offers room for future expansion, additional development, or extra parking. The seller is willing to sell the property with or without the acreage, providing flexibility to meet a variety of investment goals.

Conveniently located right off Highway 63 with excellent visibility and easy access, this versatile property is ideal for expanding your investment portfolio or establishing your own business while generating rental income from the existing tenants.

Opportunities like this don’t come along often schedule your private showing today to explore the possibilities!
#26043756

Vienna

303 Highway 63

None Beds

None Baths

N/A

$1,300,000

MLS#: 26043756

Welcome home to this move in ready 2 bedroom 2 full bathroom in Summer Winds condominiums. Perfectly convenient in St. Peters most prime location. The private entrance leads to this spacious open floor plan that feels like a single-family layout. Large living/dining area with luxury vinyl plank flooring and direct access to the private deck. Kitchen boasts plenty of counter space, ample cabinets and stainless appliances. The primary bedroom suite offers a walk in closet and private bath. Second bedroom with natural light, ceiling fan and hall access to second full bathroom. Dedicated laundry in primary hall with full size washer and dryer. Association pays water, sewer, trash, exterior insurance. Desired Zumwalt South schools, shopping, entertainment and dining. Must See!
#26041091

St Peters

612 Summer Winds Lane E

2 Beds

2 Baths

968 Sq.Ft.

$159,000

MLS#: 26041091

Beautiful, secluded lakefront lot just minutes from Interstate 55.  Build your dream home on this beautiful 3 acre lakefront lot.  Partially wooded, there are many homesites on this lot that could include a walk-out basement.  A lot of the prep work has been done for you.  Water is connected and active.  Power has been run to the center of the property, the shed, and the dock with plenty of capacity for building your dream home.  Come take a look at this lakefront lot in a very secluded, quiet area.  Homeowner is responsible for 6% of the lake and dam maintenance fees (seller has paid $0 in the 5 years he's owned it).  Lot may be used for residential or recreational purposes only - public facing businesses are not allowed.  Ask your Realtor for more information and a private showing today!
#26044018

Mount Olive

0 S Panther Creek Road

None Beds

None Baths

3.0 acres

$129,900

MLS#: 26044018

1 ... 245 246 247 248 249 ... 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 Kornelije Josić 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 Kornelije Josić 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.