Search for Properties
Find An Agent
Explore Places to Live
About RE/MAX

Log in / Sign up

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload

Fairview Terrace, Frontier, MO

Fairview Terrace, Frontier, MO
Hide List

Search

Search Near Me

Real Estate and Properties for Sale

1 out of 1 Results

3bd
2ba
2,280sqft

4 Fairview Drive St Charles, MO 63303

Listing provided courtesy of Big Bend Realty LLC

Listing data copyright MLS Logo

2026. Information From Third Parties, Deemed Reliable But Not Verified.
RE/MAX Kansas-Missouri does not display the entire IDX database of MidAmerica Regional Information Systems, Inc. (MARIS MLS) on this website. Property listings of some REALTOR® brokerage firms have been excluded.

Filter

Property Type

Single Family

Condo/Townhouse

Multi Family

Vacant Land

Commercial

Rental

Property SubType

Patio/Villa

Listing Status

Active

Pending

Sold

Coming Soon

Price Range

$

Min Price

–

$

Max Price

Beds, Bath, and Size

Beds Minimum

Min Baths Minimum

Min Square Feet

–

Max Square Feet

Min Lot Size

–

More

Year Built

–

Max Year Built

Garage Spaces Minimum

Sold Date Within...

Days On Site Maximum

Open Houses

Has Open House

Has Virtual Open House

Only Listings With

Floor Plans

Photo Galleries

Main Photo

Virtual Tours

Virtual Showings

Waterfront

RE/MAX Collection

Subdivision

Search for subdivision by name...

Floor Plan

- 1 Story
- 1.5 Story
- 2 Story
- 3+ Story
- Atrium Split
- Bungalow
- California Split
- Front/Back Split
- Loft
- Raised Ranch
- Ranch
- Reverse 1.5
- Split entry
- Split

Property Condition

- Fixer
- Never Occupied
- New Construction
- Under Construction

Water Options

- Boat Ramp
- Creek
- Lake Access
- Lake Front
- Lake Access
- Pond
- Private Dock(s)
- Public Dock(s)
- River

Basement Type

- Bath/Stubbed
- Block
- Cellar
- Concrete
- Crawl Space
- Daylight
- Finished
- Full
- Interior Entry
- Partially Finished
- Unfinished
- Walkout

Association Amenities

- Boat Dock
- Maintenance
- Clubhouse
- Golf course
- Lawn Maintenance
- Playground
- Pool
- Tennis Court(s)
- Trails

Exterior Features

- Above Ground Pool
- Deck
- Handicap Accessible
- Horse Facilities
- Hot Tub
- In Ground Pool
- Patio
- Porch
- Tennis Court(s)
- Storm Shelter

Interior Features

- Breakfast Room
- Formal Dining Room
- Great Room
- Kitchen Island
- Bedroom-Master (Main Floor)
- Pantry
- Walk-In Closet(s)

Ownership

- HUD Owned
- Real Estate Owned

Save Search

Send me open houses for this search

Send me updates on this search

Save Local Area

Message

Log In

Email

Remember Me

Don't have an account?

Sign Up

Create Account

Create an account to save listings and receive listing updates as soon as they happen!

First Name

Last Name

Email

Phone

Already have an account?

Log In

RE/MAX Kansas City Real Estate
Central Kansas Real Estate
RE/MAX Jefferson City Missouri Real Estate
RE/MAX Southwest Missouri Real Estate
Missouri & Kansas RE/MAX Offices
Springfield Real Estate

RE/MAX Lawrence Real Estate
RE/MAX Lake of the Ozarks Real Estate
RE/MAX North Missouri Real Estate
Missouri Real Estate
RE/MAX National Real Estate Links

RE/MAX Wichita Real Estate
RE/MAX Columbia Missouri Real Estate
Kansas & Missouri Real Estate Agents
RE/MAX Central Missouri Real Estate
Franchise Opportunities in Kansas / Missouri

www.remax.com
RE/MAX Midstates
Site Map

Each RE/MAX Office is independently Owned and Operated. It is illegal to discriminate against any person because of race, color, religion, sex, handicap, familial status or nation of origin. Equal Housing Opportunity.

© 2026 RELIANCEai and RE/MAX Kansas-Missouri. All rights reserved. U.S. Reg. Copyright TX-5-910-991, TX-5-910-992, TX-5-910-993, and TX-5-910-994.

Equal Housing Opportunity.

Our Commitment to Accessibility

THE SITE IS PROVIDED ON AN AS-IS AND AS-AVAILABLE BASIS, SEE FURTHER DETAILS UNDER DISCLAIMER.

Agent Access