Thinking of selling?

Blue Sapphireline

Browse Properties
  • Nearby me

Popular Features

Community Features

Association

Property Features

Waterfront

View

Exterior Features

Interior Features

Style

E-Alert name

Properties

10000 properties match your criteria

None
#26002592

Chesterfield

2048 Kingspointe Drive

4 Beds

4 Baths

6,110 Sq.Ft.

$1,500,000

MLS#: 26002592

Patterson MO cattle farm for sale!! Over 211 +/- acres of pristine acreage with numerous rotational grazing paddocks (12+), corrals, feed lots, loading pens, covered head catch areas, weight scales, sheds, and a hay barn. Automatic waterers, and or ponds, are in the paddock areas with a live creek running through the acreage. A 16'x80' single wide mobile home is included with the sale. It has electric, water, septic, newer HVAC system, all on a permanent concrete slab, front and back porches, and sidewalks around the entire home. Several areas available for a new house build if desired with hills in the distant for a beautiful backdrop. Abundant wildlife for the hunter. The property is only minutes from Sam Baker State Park. Clearwater Lake, Black River, and the Saint Francis rivers are nearby. The property would be an excellent location for a transfer station, holding lot, or shipping lot for cattle. You need to see the property in person to appreciate the potential and beauty!!
#25013664

Patterson

0 Highway N Angus Lane 1

3 Beds

2 Baths

N/A

$1,500,000

MLS#: 25013664

None
#26002774

Chesterfield

14899 Greenleaf Valley Drive

3 Beds

3 Baths

3,908 Sq.Ft.

$1,500,000

MLS#: 26002774

Set on more than four private, wooded acres, this brand-new Mid-Century Modern masterpiece redefines contemporary living with architectural precision and effortless sophistication. A long, dramatic drive leads to the striking facade, where clean lines, expansive glass, and impeccably landscaped grounds create a true sense of arrival. A stunning black metal pivot door opens to soaring ceilings and an open-concept plan bathed in natural light from high transom windows. The living room centers on a sleek linear fireplace, while the designer kitchen impresses with custom cabinetry, a sprawling island, and a built-in coffee bar for refined everyday living. The main-floor primary suite is a private sanctuary, featuring its own covered patio, dual walk-in closets, and a spa-worthy bath with a soaking tub encased in a glass-wrapped shower. A stylish laundry and drop zone complete the main level. Upstairs, a lofted office with a separate sitting area provides the perfect creative escape, while a breathtaking floating staircase with all-glass railings leads to the finished lower level, offering two bedrooms, a full bath, and expansive recreation space. Outdoors, mature trees and total privacy create an inspiring natural backdrop for future amenities or a peaceful retreat. A three-car garage and exceptional craftsmanship throughout complete this modern estate, where design, nature, and serenity exist in perfect balance.
#26052650

St Louis

4513 Du Bourg Lane

3 Beds

2 Baths

3,522 Sq.Ft.

$1,500,000

MLS#: 26052650

You’ve found your dream home—don’t miss out!
From the moment you pull into the driveway, you’ll think wow. As you and your guests step inside, an incredible sense of warmth and elegance welcomes you. Soaring atrium windows flood the home with natural light, while stunning coffered ceilings and custom-designed flooring showcase exceptional craftsmanship throughout.

After a long day, retreat to the luxurious main-floor primary suite. The spa-inspired bathroom features heated floors to keep your feet warm, a waterfall-style shower, and a private sauna—perfect for relaxation and stress relief. The cozy sleeping area includes two walk-in closets and a beautiful double-sided ventless fireplace, creating a serene and inviting atmosphere.

Feeling refreshed, make your way to the expansive kitchen—designed for both everyday living and entertaining. With ample space to host gatherings, the kitchen boasts granite countertops, stainless steel appliances, double sinks, and exceptional lighting. Rich wood floors flow seamlessly into the hearth room and sitting area, where you can enjoy the glow of a fireplace while preparing dinner and entertaining guests.

To complete the experience, the home is wired with speakers and a sound system throughout much of the house, allowing you to enjoy your favorite music whether you’re hosting a party or unwinding for the evening.

This home truly offers everything you want—and everything you deserve.

Whether you’re unwinding or entertaining, enjoy the stylish main-floor bar area, or head downstairs to a second bar paired with a beautiful game room—perfect for playing pool or hosting game nights in the additional entertainment space. The lower level also offers a bedroom and full bathroom, providing comfort and privacy for overnight guests.

When the evening comes to an end, retreat to the main-floor primary suite, while family and guests can settle into one of three spacious bedrooms on the second floor. This level also features three additional bathrooms, ensuring everyone has their own space. If the night isn’t quite over, the open loft area upstairs offers a comfortable spot to relax before turning in.

The home is thoughtfully designed with laundry rooms on both the main and second floors for added convenience. Additional highlights include three HVAC systems, two water heaters, a beautiful exterior patio ideal for enjoying warm evenings, and an impressive four-car garage featuring a durable epoxy flake floor.
#26002502

St Louis

12410 Grandview Lake Drive

5 Beds

5 Baths

5,729 Sq.Ft.

$1,500,000

MLS#: 26002502

269 acres m/l with highway frontage on H Hwy, Salem, MO – located on Dry Creek. Beautiful working farm with an excellent combination of pasture, hay ground, and timber. Approximately half wooded and half pasture/hay ground. Nine grazing paddocks with well water available to each paddock. Well and two septic tanks. Pasture over seeded with both summer (Lespedeza, red clover, Indian grass, and Bermuda grass) and winter (Fescue grass orchard grass, clover, and red clover grass). Buildings include a 30X50 hay barn, 50X50 grain storage, tack room, implement shed, 30X40 modern shop and lots of storage space. Spacious home features 3 bedrooms, 2 ½ baths, game room, (Don’t miss this modern kitchen with moveable island on rollers, sink tilt-tray, built-in book case for cookbooks, custom hickory cabinets, walk-in pantry with pullout drawers, bread box, toe kick drawers, kitchen desk), dining room, living room, den, study, and much more. If that isn't enough, enjoy the 8-foot wrap around porch with a view of the whole farm. This well-maintained farm offers an excellent combination of woods and pasture/hay ground, making it ideal for cattle, hay production, recreation, or country living at its finest. This new home was built in 2011 and added to the original home. Nice to know that the farm is located along the White River Trace Wagon Trail.
#26031085

Salem

3947 Highway H

3 Beds

2 Baths

2,688 Sq.Ft.

$1,500,000

MLS#: 26031085

Prime opportunity to acquire a well-located hospitality asset in the heart of Bridgeton, just minutes from St. Louis Lambert International Airport and major interstates (I-70, I-270, and I-170). Situated on Hollenburg Drive, this hotel benefits from strong visibility, convenient access, and proximity to key demand drivers including the airport, business parks, and regional attractions. The property has massive 104 rooms and a manager's apartment onsite.
The property offers a functional layout designed for efficient operations, with ample parking and infrastructure in place to support continued hotel use or repositioning opportunities. Ideal for investors or owner-operators seeking to capitalize on steady travel demand in a high-traffic corridor.
This location provides excellent connectivity to downtown St. Louis, St. Charles, and surrounding commercial hubs, making it an attractive option for both business and leisure travelers.
Significant upside potential exists through operational improvements, brand conversion, or renovation. Property needs significant repairs and is being offered as-is.
#26030881

Bridgeton

3470 Hollenberg Drive

None Beds

None Baths

44,570 Sq.Ft.

$1,500,000

MLS#: 26030881

Welcome to Whitetail Ridge, an exceptional 179-acre hunting and recreational property offering the combination serious outdoorsmen look for marketable timber, established food plots, extensive hunting infrastructure, and a comfortable home base. The property is dominated by mature timber, providing excellent cover and habitat for whitetails while also offering the added value of a significant timber resource. Strategically placed food plots and a large pond providing a premium, dependable water source create the key ingredients needed to attract and hold deer throughout the year. Whitetail Ridge is already set up to hunt, featuring 10+ hunting blinds along with additional deer stands positioned throughout the property. Adding to its trophy potential, neighboring landowners practice Quality Deer Management (QDM), helping promote a healthier deer herd and more mature bucks throughout the area. The approximately 1,560 sq. ft. home and detached garage are located about one mile from the 179 acres, providing a comfortable home base, hunting lodge, or weekend retreat while maintaining the privacy and recreational feel of the property. 179 acres. Heavy timber. Food plots. Premium water. Multiple blinds. QDM neighborhood. Home and garage approximately one mile from the acreage.

Whitetail Ridge isn't just hunting ground—it's a turnkey whitetail property ready for its next chapter.
#26052748

Kahoka

30001 County RD 237

4 Beds

2 Baths

1,560 Sq.Ft.

$1,500,000

MLS#: 26052748

Prime Main Street Opportunity in Historic Downtown Columbia! Discover the perfect blend of historic charm and modern functionality at 216 N. Main Street, Columbia, IL. This impressive newly renovated 9000+ square foot commercial property including new roof, new HVAC, new electrical wiring throughout. Newly renovated ceilings, and new flooring are just a few updates.  This property offers a rare opportunity in the heart of Columbia’s vibrant downtown district. With exceptional visibility and a desirable Main Street location, this property is ideal for retail, office, showroom, creative space, or mixed-use possibilities. Featuring the character and charm of a historic downtown setting, this versatile space provides a unique opportunity for an entrepreneur, investor, or established business looking to become part of a growing community. The flexible layout allows for a variety of uses while offering excellent exposure along one of Columbia’s most recognizable corridors. Enjoy being surrounded by local shops, restaurants, community events, and downtown amenities while benefiting from convenient access to surrounding areas including St. Louis, Interstate 255, and the greater Metro East region. Columbia continues to be a highly desirable area known for its strong community, growth, and small business atmosphere. A rare opportunity to own a piece of Columbia’s historic Main Street — bring your vision and create something special in this exceptional commercial space!
#26037460

Columbia

216 N Main Street

None Beds

None Baths

N/A

$1,500,000

MLS#: 26037460

Rare opportunity to own a fully functional, income-producing 100-acre pecan farm offering a rare combination of mature production, versatile improvements, and picturesque rural character. The property is planted with approximately 1,249 mature pecan trees — well-established and maintained — providing immediate production potential for a buyer seeking agricultural revenue or a turnkey operation to expand. Rows are accessible for equipment, and the acreage is laid out to support efficient harvest, irrigation, and future planting or orchard expansion.

Water resources are a standout: the farm includes two well-sized stocked ponds (a 6-acre pond and a 2-acre pond) that provide irrigation support, livestock water, recreational fishing, and attractive reflecting water features that enhance the landscape. Rolling fields and gently undulating terrain create beautiful vistas across the property, ideal for pasture, hay production, supplemental crops, or amenity uses such as trails, hunting stands, and event space.

The improvements are substantial and practical for active farm life:

A 70' x 45' main house/shop that combines approximately 1,500 sq ft of living area with attached shop/covered bays — perfect for comfortable on-site living with convenient work space for maintenance and equipment service.
Two large 60' x 40' equipment shops capable of housing tractors, harvesters, trailers, and other large machinery; each shop offers high clearance, wide doors, and durable construction suited to heavy use.
A separate 1,100 sq ft cottage/guest or caretaker house outfitted with a dedicated pet-washing station — well-suited for staff, visitors, or family, and particularly convenient for owners who keep dogs or other household animals.
Unique amenities add to the property’s appeal:

A private airplane landing strip for direct access, enabling quick travel or accommodating hobbyist pilots.
Multiple all-weather drives, equipment turnarounds, and ample laydown areas for staging harvest and machinery.
Thoughtfully sited fencing and cross-fencing options for livestock rotation or pasture management.
Wildlife habitat around ponds and woodlines that supports waterfowl, deer, and other species — attractive for recreational hunting or nature observation.
Practical essentials and investment upside:

The mature pecan trees offer near-term production and cash-flow potential; the farm is ideal for a grower, investor, or family looking to maintain or scale pecan production.
Infrastructure is tailored for working operations, minimizing immediate capital expenditures for equipment storage and routine maintenance.
Strong potential for diversification — add agri-tourism, equestrian facilities, hay production, cattle, or additional crops — depending on the buyer’s objectives.
Close proximity to regional roads (detail available on request) makes transport of product and access to markets straightforward.
This property marries productive agricultural acreage with comfortable residences, robust operational structures, attractive water features, and an airstrip — delivering a rare, turn-key rural estate and working farm. Contact us for detailed maps, production records, utility information, and to schedule a private showing
#26047304

Puxico

26133 County Road 249

None Beds

2 Baths

2,016 Sq.Ft.

$1,500,000

MLS#: 26047304

Rare opportunity to own a fully functional, income-producing 100-acre pecan farm offering a rare combination of mature production, versatile improvements, and picturesque rural character. The property is planted with approximately 1,249 mature pecan trees — well-established and maintained — providing immediate production potential for a buyer seeking agricultural revenue or a turnkey operation to expand. Rows are accessible for equipment, and the acreage is laid out to support efficient harvest, irrigation, and future planting or orchard expansion.

Water resources are a standout: the farm includes two well-sized stocked ponds (a 6-acre pond and a 2-acre pond) that provide irrigation support, livestock water, recreational fishing, and attractive reflecting water features that enhance the landscape. Rolling fields and gently undulating terrain create beautiful vistas across the property, ideal for pasture, hay production, supplemental crops, or amenity uses such as trails, hunting stands, and event space.

The improvements are substantial and practical for active farm life:

A 70' x 45' main house/shop that combines approximately 1,500 sq ft of living area with attached shop/covered bays — perfect for comfortable on-site living with convenient work space for maintenance and equipment service.
Two large 60' x 40' equipment shops capable of housing tractors, harvesters, trailers, and other large machinery; each shop offers high clearance, wide doors, and durable construction suited to heavy use.
A separate 1,100 sq ft cottage/guest or caretaker house outfitted with a dedicated pet-washing station — well-suited for staff, visitors, or family, and particularly convenient for owners who keep dogs or other household animals.
Unique amenities add to the property’s appeal:

A private airplane landing strip for direct access, enabling quick travel or accommodating hobbyist pilots.
Multiple all-weather drives, equipment turnarounds, and ample laydown areas for staging harvest and machinery.
Thoughtfully sited fencing and cross-fencing options for livestock rotation or pasture management.
Wildlife habitat around ponds and woodlines that supports waterfowl, deer, and other species — attractive for recreational hunting or nature observation.
Practical essentials and investment upside:

The mature pecan trees offer near-term production and cash-flow potential; the farm is ideal for a grower, investor, or family looking to maintain or scale pecan production.
Infrastructure is tailored for working operations, minimizing immediate capital expenditures for equipment storage and routine maintenance.
Strong potential for diversification — add agri-tourism, equestrian facilities, hay production, cattle, or additional crops — depending on the buyer’s objectives.
Close proximity to regional roads (detail available on request) makes transport of product and access to markets straightforward.
This property marries productive agricultural acreage with comfortable residences, robust operational structures, attractive water features, and an airstrip — delivering a rare, turn-key rural estate and working farm. Contact us for detailed maps, production records, utility information, and to schedule a private showing
#26047313

Puxico

26133 County Road 249

2 Beds

2 Baths

1,500 Sq.Ft.

$1,500,000

MLS#: 26047313

Perched high above the Mississippi River on 9.7 scenic acres just outside of Hannibal on Highway 79, this custom-built 5-bedroom, 4.5-bath home offers breathtaking panoramic views and a truly one-of-a-kind setting. Built in 2003, the home was thoughtfully designed to take full advantage of its bluff-top location, with expansive windows and an open floor plan that capture the beauty of the river from nearly every room. The spacious main level features a four-season screened porch, while the upper-level deck provides the perfect place to enjoy river traffic, abundant wildlife, and spectacular sunrises and sunsets. Whether entertaining guests or enjoying a quiet morning with a cup of coffee, the views are simply unmatched. A private asphalt driveway leads to the home, where you'll find both an attached garage and a detached garage, providing ample space for vehicles, recreational equipment, hobbies, or a workshop. Surrounded by mature trees and beautifully maintained grounds, the 9.7-acre property offers the ideal combination of privacy, natural beauty, and convenience. 

Properties like this rarely come to market. With incredible Mississippi River views, quality custom construction, generous indoor and outdoor living spaces, and an unbeatable location just minutes from Hannibal, this exceptional property is a rare opportunity to own one of Northeast Missouri's premier bluff-top homes.
#26048432

Hannibal

4 River Hills Road

5 Beds

4 Baths

5,612 Sq.Ft.

$1,500,000

MLS#: 26048432

Here is the St Albans Construction built atrium ranch home that highlights superior construction quality and is a home that has been perfectly maintained from its manicured lawn and landscaping to its spotless interiors and exteriors. The stone and brick exterior, slate styled DaVinci roof and circle driveway add to its wonderful curb appeal. Enter thru a beautiful foyer with custom faux painting. All the carpeting on the main floor and on atrium stairway is new in 5/26. The garage floor is epoxy coated. There is a sprinkler system and Beam central vacuum and surround sound music system with dual speakers in every room in the home including garage, deck and patio (excludes 3 bedrooms and office). The home features 4 full masonry fireplaces with gas logs, many high vaulted, wood beamed or trey ceilings, 3 powder rooms with custom faux painting, all bedrooms are ensuite, 8' doors on the main floor, crown molding and wainscoting in the dining room, a Den/Office with double French doors and a wall of built-in bookshelves, a fabulous atrium stairway that captures all the beauty of the treed backyard. Relax on the Trex deck with solar post lighting or on the large aggregate patio in the backyard that backs to landscape lighted trees for privacy and hear the peaceful water feature in the pond behind the house on the golf course beyond. The expansive kitchen features Subzero refrigerator, Viking double convection ovens, Asko Dishwasher, floor kick vacuum, granite countertops, walk-in pantry, vaulted ceiling with wood beams in the kitchen, hearth room and breakfast room. The Primary suite is massive with a private gas logged fireplace, a custom finished 17' x 12' closet, vaulted ceiling, bath with jacuzzi tub and large shower with shower seat. The lower level is perfect for entertaining and for family living or guests visiting. All three bedrooms are ensuite with full bathrooms, large walk-in closets and darkening shades for those who like to sleep in. There is a floor to ceiling stone fireplace with gas logs, a space for billiards and a theater area away from the atrium which is perfect for watching tv. the 3-D theater system is negotiable. The bar features a subzero refrigerator, wine cooler and ice machine. The French door leads to the lower-level patio. The new construction homes being built on the street do not have nearly the features and are costing a much higher price.
#26032275

St Albans

638 Morel Court

4 Beds

4 Baths

5,300 Sq.Ft.

$1,500,000

MLS#: 26032275

This exceptional investment opportunity offers the chance to acquire one of Southern Illinois' most recognizable hospitality and entertainment destinations. Situated on more than 10 acres near Carlyle Lake, this turnkey property has been thoughtfully developed into a multi-faceted venue serving guests from throughout the region. Featuring approximately 900 feet of highway frontage and benefiting from an average daily traffic count of approximately 5,000 vehicles, the property enjoys outstanding visibility and exposure that supports both its current operations and future growth opportunities.

What began as the dream of a local couple grew into a thriving destination known for its welcoming atmosphere, live entertainment, weddings, special events, dining experiences, and wine production. Through years of dedication and hard work, the owners created a business that has become a gathering place where countless memories have been made. Now, a rare opportunity exists for new ownership to build upon that foundation and elevate the property to its next stage of growth.

The property offers nearly 18,000 square feet of improvements designed to support a variety of business operations and revenue streams. Guests can enjoy a full-service restaurant, indoor event facilities, wine tasting experiences, outdoor entertainment venues, and scenic grounds that attract visitors throughout the year. The spacious indoor event center, complete with a separate bar area, provides an ideal setting for weddings, corporate events, private parties, fundraisers, and community gatherings. Outside, two entertainment stages create the perfect atmosphere for concerts, festivals, and seasonal events, while the dedicated wedding venue and picturesque ponds provide a beautiful backdrop for special occasions.

With established regional recognition, a loyal customer following, and a strategic location near Carlyle Lake, the property is well-positioned for continued success. Investors and operators will appreciate the flexibility offered by the existing infrastructure and the opportunity to expand programming, increase event bookings, grow tourism traffic, enhance food and beverage operations, expand wine production, or introduce new concepts that capitalize on the property's strong foundation.
#26040346

Carlyle

15469 State 127 Route

None Beds

None Baths

16,926 Sq.Ft.

$1,500,000

MLS#: 26040346

Situated just north of Hermann, MO and West of Hwy 19, this 185+/- acre farm offers a well-rounded mix of features.   The scenery at this farm is incredible.  With high wooded peaks overlooking the Loutre River bottom, good pasture for livestock & some tillable acreage for income.  All of this creates an awesome habitat for wildlife & views that never get old.  This farm would make a perfect hunting & recreation piece, great hobby farm or private residence. Several historical barns remain on-site, with large shop building featuring finished living quarters—complete w/kitchen, 1.5 bathrooms, bar, bunk loft, and a deck overlooking a stocked pond. The building makes for a great hunting lodge. It has plenty of room for lots of hunters, tools, toys and equipment. Located just 3 miles west of Big Spring, MO, this property is just 1 hr from Chesterfield Valley, 1 hr from Columbia, MO and you can be in downtown Hermann in under 20 minutes!
#26017308

Hermann

161 Van Booven Lane

None Beds

None Baths

N/A

$1,500,000

MLS#: 26017308

* 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.

Categories

Homes Tailored to Your Lifestyle

Buyers Guide

Buying a home is one of the most exciting milestones of your life.

View more

Sellers Guide

Putting your home on the market can be a stressful process, especially when you don’t know what to expect.

View more

Market report

With just a few clicks, you'll gain instant access to valuable insights about the real estate market, including trends, property values, and community analytics.

View more

Home value

Unlike automated valuations, our hands-on review will provide a comprehensive opinion of your home’s value while considering important interior elements and other location intangible factors that machine algorithms so often miss.

View more

Buyers resources

Guides on financing, inspections, and choosing the right Realtor for a smooth home purchase.

Sellers resources

Practical tips on staging, pricing, and preparing your home to attract buyers and maximize your sale.

 - property

Send a message

Message successfully sent.

Preferred Agent

Reason for contacting?

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

I agree to be contacted by Realhub DEV 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 In 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 Realhub DEV 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.