Español  |  Fine Homes  |  Commercial Real Estate  |  Global  |  C21 Blog
CENTURY21 Real EstateThe Linda Frierdich Real Estate GroupHomes for Sale
My C21: Sign In  |  Register  |  My Favorites
Your Current Search

Homes for Sale By Team

The Linda Frierdich Real Estate Group

Property Features

1+ Car Garage (remove)
Refine Your Search
to
More Search Options
Sort By:
Per Page:
Page:
1 | 2 | 3 | 48 Next

$2,100,000

9420 Gilmore Lake Rd Columbia, IL 62236
5 Beds 7,400 Sq. Ft
5 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4310930
PROPERTY DESCRIPTION: 
Masterfully crafted Equestrian Estate Property located outside of St Louis boasts stunning 5BR/5.5 BA 7400+ sf home on 27.12 acres. Horse facilities include 42 x 72 Stone Horse Barn w/5 stalls, loft, tack room, grooming area, & is finished w/pine tongue & groove interior.Find a 80 x 160 riding arena, approx 10 acres fenced pasture, round pen,& paddock. Horse facilities are equipped with extensive exterior lighting for night riding plus a large loft in the barn. The expansive home boasts brick,natural stone & EFIS exterior and offers elegant appointments throughout- broad plank hardwood flooring, coffered ceilings, extensive millwork, in home gym & sauna, & warm neutrals throughout. Chef's Kitchen features glazed maple cabinets, 5 burner stove top, gleaming granite counters & opens to the hearth rm with stone fireplace. Outside entertaining area has covered patio, stone fireplace, & offers panoramic views of the property! Main floor master suite & additional 4 BR w/private bath access
FEATURES:
Age: 6-10 Years Old
Amenities: Stables, Horse facilities, Horse Ranch
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Area Description: Country Living, Equestrian / Polo
Basement: Full
Bath Features: Tub and Shower, Steam Room
Cooling: Central A/C - Electric
Exterior: Barn/Stable, Fire Pit
Exterior Description: Brick, E.I.F.S, Stone
Exterior Living Space: Patio
Fireplace Count: 1 Fireplace
Fireplace Description: Stone
Flooring: Hardwood, Wall to Wall Carpet, Ceramic
Garage Count: 4 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Geothermal
Interior: In-Home Gym
Kitchen Features: Granite Countertops
Lot Size: 20-50 Acres, 27.12 Acres
Property Description: Acreage
Sewer: Private
Style: 1 Level Ranch
Water: City Water

$599,900

1600 Timber Ridge Columbia, IL 62236
4 Beds 6,080 Sq. Ft
4 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4310786
PROPERTY DESCRIPTION: 
Stunningly finished home offers quality of crafstmanship & top-shelf finishes throughout, including 1500 bottle wine room. From the moment you approach the beautifully manicured grounds w/ expansive landscaping, retaining walls, and 9 zone irrigation system, you'll notice the attention to detail- 2 story entry porch, brick & stone exterior, & 3 car side entry garage. Once inside this masterpiece, find natural wood flooring, broad crown molding, central vac, wood cased windows, & 6-panel wood doors throughout. The soaring ceilings extend from the living room, to the open spindle stair, & into the hearth room. In the hearth room, find 18 ft ceiling w/floor to ceiling stone fireplace, dual doors leading to multi-tiered deck, fish pond w/waterfall & private back yard w/stamped patio. Kitchen boasts granite counters & 42"maple cabinets. Main level master suite w/trayed ceiling, luxury en suite, & walk-in closets! Finished lower level offers plenty of finished space for versatile purposes.
FEATURES:
Age: 6-10 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Basement: Full
Bath Features: Tub and Shower
Cooling: Central A/C - Electric
Exterior: Underground Lawn Sprinkler, Water Feature
Exterior Description: Brick, Stone
Exterior Living Space: Patio, Deck
Fireplace Count: 1 Fireplace
Fireplace Description: Stone
Flooring: Hardwood, Marble, Wall to Wall Carpet, Ceramic, Laminate
Garage Count: 3 Car Garage
Garage Description: Attached Garage
General: Built-in Vacuum
Heating - Fuel Type: Gas
Heating Type: Forced Air
Interior: Walk-in Closet, Wine Cellar
Kitchen Features: Granite Countertops
Lot Size: 1/2 - 1 Acre, 0.69 Acres
Road Type: City / Town Street
Sewer: Public
Style: 1.5 Story
Water: City Water

$439,900

5776 Deer Hill Rd. Waterloo, IL 62298
4 Beds 3,949 Sq. Ft
3 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4308475
PROPERTY DESCRIPTION: 
Horses are allowed on this beautiful 10 acre park like lot with a 64x36 barn with lean-to, concrete floors, electric, and riding area! Gleaming hardwood floors, vaulted ceilings, open floor plan, & stunning views can be seen from the living room with vaulted ceilings and floor to ceiling stone fireplace! Large eat-in kitchen with tons of 42in maple cabinetry, huge breakfast bar, and built in desk! Master Suite with coffered ceiling, large walk-in closet, corner jacuzzi tub, separate shower, dual vanity, and linen closet! The main level also features two additional bedrooms, formal dining room with column accents, laundry room, and full bath! Every entertainers dream in the walk out lower level family room and versatile game room with wood burning stove. 4th bedroom, full bathroom, and work out room can also be found in the lower level. Geothermal HVAC, composite decking, 3 car side entry garage, Anderson windows, wrap around porch, city water, and so many other amazing features!
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven
Area Description: Country Living
Basement: Full
Bath Features: Jacuzzi Tub, Stall Shower
Cooling: Other A/C
Exterior: Out Building, Barn/Stable
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio, Deck, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Stone, Wood Burning Stove
Flooring: Hardwood, Ceramic, Laminate
Garage Count: 3 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Gas, Geothermal
Interior: Walk-in Closet, Vaulted Ceilings
Kitchen Features: Granite Countertops, Eat-in Kitchen, Breakfast Bar
Lot Description: Wooded, Open
Lot Size: 10-20 Acres, 10 Acres
Property Description: Acreage
Roof: Asphalt Shingle Roof
Sewer: Private
Style: 1 Level Ranch
Views: Scenic
Water: City Water
NEWLY LISTED

$439,000

1628 Timber Ridge Columbia, IL 62236
5 Beds 4,647 Sq. Ft
3 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4311387
PROPERTY DESCRIPTION: 
Every entertainers dream can be found in this stylish, executive-style home w/huge heated salt-water pool with cool deck, lower level wet bar w/additional full kitchen,& wine room! Soaring 18 ft ceilings can be found in the entry foyer w/marble flooring & into the living room w/floor to ceiling windows flanking the gas fireplace. New granite counter tops, tons of 42in cabinets, beverage area, & doors leading to the expansive deck are just a few of the features in the kitchen. Master suite houses a large walk in closet & garden tub located on the main level along with a formal dining room w/trey ceilings, in home office featuring french doors, laundry room, and powder room w/pedestal sink. Upper level houses 3 spacious bedroom w/walk-in closets & a very large full bathroom w/dual vanity. The 5th bedroom can be found in the lower level w/ a full bathroom & cavernous family room w/gas fireplace & doors leading to the partially covered patio, tree lined lot, & professionally landscaped!
FEATURES:
Age: 6-10 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Basement: Walk-out
Bath Features: Tub and Shower
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio, Deck
Fencing: Vinyl Fence
Fireplace Count: 2 Fireplaces
Fireplace Description: Gas
Flooring: Marble, Tile, Wall to Wall Carpet, Ceramic, Laminate
Garage Count: 3 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Gas
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Granite Countertops, Eat-in Kitchen, Center Island
Lot Size: 1/2 - 1 Acre, 0.56 Acres
Pool Description: Inground, Pool
Road Type: City / Town Street
Sewer: Public
Style: 1 Level Ranch
Water: City Water

$395,000

455 Kopp Waterloo, IL 62298
5 Beds 3,270 Sq. Ft
2 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4309726
PROPERTY DESCRIPTION: 
Nestled on a plush 4.83 acres, this sprawling country estate home is minutes from Waterloo's amenities & offers all the extras! Find Nature at its finest, this private home has both wooded and open areas, plus mature Peach, Apple, Walnut & Cherry Trees and blue berry & black berry bushes! Commercial Inspired Kitchen Features stainless 6 burner gas stove & hood, pantry, breakfast bar, & attached dining space w/door leading to 3 tier deck. Find a family room with wood-burning stove, rich hardwood floors, & open spindle stair. Detached Garage/Workshop features 3/4 bath, heated floors, plus an additional 20 x 64 finished upper level for guest use or extra living space. Main floor master suite offers sitting area with fireplace, double coffered ceiling, hardwood flooring, & attached spa-inspired bath w/walk-in shower plus heated floors & shower seat- Jacuzzi tub, corner accent fireplace & pedestal sink in arched alcove! Home is heated with exterior wood heat but also has 2 furnaces/ACs. Additional 6.5 acres available for $74,900
FEATURES:
Age: 21-30 Years Old
Area Description: Country Living
Basement: Full
Bath Features: Jacuzzi Tub
Cooling: Central A/C
Exterior Description: Vinyl Siding
Exterior Living Space: Deck, Porch
Fencing: Partially Fenced
Fireplace Count: 2 Fireplaces
Fireplace Description: Fireplace, Wood Burning Stove
Flooring: Hardwood, Wall to Wall Carpet, Ceramic
Garage Count: 2 Car Garage
Garage Description: Detached Garage
Heating - Fuel Type: Propane
Heating Type: Forced Air
Interior: Fireplace in Master BR
Kitchen Features: Breakfast Bar
Lot Description: Wooded
Lot Size: 10-20 Acres, 4.83 Acres
Property Description: Acreage
Sewer: Private
Style: 1.5 Story
Views: Scenic
Water: Well

$350,000

1732 Clover Ridge Columbia, IL 62236
4 Beds 4,516 Sq. Ft
3 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4304051
PROPERTY DESCRIPTION: 
Sprawling Full Brick Ranch situated in Country Crossing is loaded with upgraded features! Enjoy a covered front porch, side entry garage, stamped/covered rear patio, extensive landscaping, Anderson windows/doors, central vac, plantation blinds, Trane HVAC, and much more! Eat-in kitchen offers hardwood floors, center island with seating, and abundant recessed lighting. Picture perfect living room has corner gas fireplace w/marble surround & detailed wood mantle, built in plant shelf, plus doors leading to the patio. Impressive master suite house walk-in closets & attached luxury bath w/Jacuzzi tub & dual vanity, plus vaulted ceilings! Enjoy large bedrooms and well-appointed hall bath on the main floor. Lower level finish features full kitchen with Maple Cabinetry, crown molding, and tons of storage. Family Room is ideal for entertaining and Bonus Room would make a great a 5th bedroom! This house is too much to pass up!
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Dryer, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Basement: Full
Bath Features: Jacuzzi Tub, Stall Shower
Cooling: Central A/C
Exterior Description: Brick
Exterior Living Space: Patio, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace
Flooring: Hardwood
Garage Count: 2 Car Garage
Garage Description: Attached Garage
General: Built-in Vacuum
Heating - Fuel Type: Gas
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Center Island
Lot Size: Under 1/2 Acre, 0.44 Acres
Roof: Asphalt Shingle Roof
Sewer: Public
Style: 1 Level Ranch
Water: City Water

$349,000

3 Mallard Nest Lane Columbia, IL 62236
3 Beds 3,709 Sq. Ft
2 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4307835
PROPERTY DESCRIPTION: 
This amazing home nestled on 3.14 acres with your own private pool is sure to please. Soaring 18 ft ceilings give the home an open and inviting feeling when stepping into the foyer. Spacious family room with gleaming hard wood floors, wood burning fireplace, wet bar with built in shelving, and doors leading to the large back deck. Gourmet kitchen with island and pantry leading into the sun room with doors leading to the pool and deck make this every entertainers dream. On the main level you will also find a formal dining room, laundry room, and half bath. Upper level features the master suite with large walk in closet, dual vanities, make up area, and doors leading to the painters deck along with 2 spacious bedrooms, and a full bath. The lower level family room and versatile office allow for additional space. Come cool off on a hot summer day in the 20x40 pool with pool house which includes a convenient half bath. New roof in 2013, Pella windows, and so much more!
FEATURES:
Age: 21-30 Years Old
Appliances: Garbage Disposal, Range / Oven
Area Description: Privacy
Basement: Full
Cooling: Central A/C
Exterior: Thermal Windows / Doors
Exterior Description: Other
Exterior Living Space: Patio, Deck, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Wood Burning
Flooring: Hardwood, Wall to Wall Carpet, Ceramic
Garage Count: 3 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Electric
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Gourmet Kitchen, Center Island, Butlers Pantry
Lot Size: 2-5 Acres, 3.14 Acres
Other: Association Fee
Pool Description: Inground, Pool, Outdoor
Property Description: Acreage
Roof: Asphalt Shingle Roof
Rooms: Library
Sewer: Private
Style: 2 Story
Views: Scenic
Water: City Water

$339,000

3401 Lunch Rd. Belleville, IL 62220
4 Beds 2,170 Sq. Ft
2 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4305162
PROPERTY DESCRIPTION: 
Located in Freeburg School District you can find this beautiful 10 acre organic horse farm. An 8 acre pasture with electric fence and 1.5 acre pond stocked with catfish, bluegill, and bass are just a few of the perks of this wonderful escape. The expansive 2 story barn features a 70x40 indoor riding area, 4 horse stalls, feeding area, chicken stalls, hay loft, and lean-to. 5 car detached shed, 24x50 board area with 3/4 bath, electric, concrete, and water, along with a 24x18 outbuilding can also be found on this gorgeous farmstead. Mature trees are found surrounding the beautiful ranch home with gleaming hardwood floors throughout the spacious family room and dining room. The eat-in kitchen with linoleum floors, island, built in desk, and all new counter tops in 2013 are ideal. The master suite has soaring ceilings, walk-in closet, and large picture window making this the perfect retreat! On the main level you will also find 3 spacious bedrooms, a 3/4 bathroom and a full bathroom.
FEATURES:
Age: Over 50 Years Old
Amenities: Horse Ranch
Appliances: Dishwasher, Dryer, Microwave, Range / Oven, Refrigerator, Washer
Area Amenities: Area Fishing, Area Horse Riding/Stables
Area Description: Country Living, Fishing, Privacy
Basement: Full
Body of Water: Pond
Cooling: Central A/C
Exterior: Out Building, Barn/Stable
Exterior Description: Brick, Vinyl Siding
Fencing: Fenced Yard
Flooring: Hardwood, Linoleum, Mixed, Wall to Wall Carpet, Laminate
Garage Count: 5 + Car Garage
Garage Description: Detached Garage
General: Fenced Range Land
Heating - Fuel Type: Propane
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Eat-in Kitchen, Center Island
Lot Description: Pond on Lot, Wooded, Level, Open
Lot Size: 10-20 Acres, 10.11 Acres
Property Description: Fenced Farm Acreage, Farm / Ranch, Acreage
Roof: Asphalt Shingle Roof
Rooms: Library
Sewer: Private
Style: 1 Level Ranch
Views: Scenic, Pond
Water: Well

$329,900

16 Deerwood Tr Fairview Heights, IL 62208
3 Beds 3,108 Sq. Ft
3 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4308856
PROPERTY DESCRIPTION: 
This stunning 2 story home located on 10 acres in a secluded peaceful setting is sure to please. Gleaming hardwood floors can be found in the spacious living room w/floor to ceiling brick wood burning fireplace & glass doors leading to the expansive back to deck. Large eat in kitchen w/granite counter tops, trash compactor, & large pantry cabinet. The main level also features a formal dining room, breakfast nook w/doors leading to the back deck, laundry room w/42in cabinetry & mop sink, along w/a 1/2 bathroom w/heated floors. The upper level showcases the master suite w/Jacuzzi tub, separate shower, along with the 2 additional bedrooms, full bathroom, & loft. The walk out lower level has a large family room, full bathroom, & 2 versatile rooms which could be used as a bedroom, home office, game room, or playroom. This home has so many amazing features from the whole house attic fan, central, vac, new roof in 2012, 24x35 lean-to, and a 35x32 outbuilding w/electric, concrete, and heat.
FEATURES:
Age: 21-30 Years Old
Appliances: Dishwasher, Microwave, Range / Oven, Refrigerator
Area Description: Privacy
Basement: Full
Bath Features: Jacuzzi Tub, Stall Shower
Cooling: Central A/C
Exterior: Out Building
Exterior Description: Brick, Other
Exterior Living Space: Deck, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Brick, Wood Burning
Flooring: Hardwood, Tile, Wall to Wall Carpet
Garage Count: 2 Car Garage
Garage Description: Attached Garage
General: Built-in Vacuum
Heating - Fuel Type: Propane
Heating Type: Forced Air
Interior: Bay/Bow Window
Kitchen Features: Granite Countertops, Eat-in Kitchen, Butlers Pantry
Lot Description: Wooded, Open
Lot Size: 10-20 Acres, 9.8 Acres
Property Description: Acreage
Roof: Asphalt Shingle Roof
Rooms: Library
Sewer: Private
Style: 1 Level Ranch
Views: Scenic
Water: City Water

$329,000

8024 Lakewood Dr. Waterloo, IL 62298
5 Beds 4,913 Sq. Ft
4 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4214949
PROPERTY DESCRIPTION: 
Welcome home to this picturesque 1 1/2 Story home on a park-like lake lot located just outside of Waterloo! This full brick home features quality finishes throughout and panoramic lake views from many of the room. Enjoy stunning lake views from the large living room w/soaring vaulted ceilings, floor to ceiling brick fireplace, doors leading to covered patio & open spindle stair leading to upper level. Eat-in kitchen offers ceramic tile floor, breakfast nook, & doors leading to the enormous covered patio. Main floor master suite offers attached luxury bath w/separate shower & soaking tub. Main floor office is sure to please with warm wood paneling finishes & French doors leading to the entry hall! Lower level boasts a wet bar, family room, 12 x 24 private security vault, bedroom with attached bath, plus a game room! This impeccably maintained home features a side entry 3 car garage, extensive landscaping, central vac, water softener, 2 furnace systems, and an architectural roof.
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Dryer, Garbage Disposal, Microwave, Range / Oven, Refrigerator, Washer
Area Description: Privacy
Basement: Full
Bath Features: Jacuzzi Tub, Stall Shower and Tub
Body of Water: Lake, Pond
Cooling: Central A/C
Exterior Description: Brick
Exterior Living Space: Patio, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Brick
Flooring: Hardwood, Tile, Wall to Wall Carpet
Garage Count: 3 Car Garage
Garage Description: Attached Garage
General: Lake Privileges
Heating - Fuel Type: Propane
Heating Type: Forced Air
Interior: Walk-in Closet, Vaulted Ceilings
Kitchen Features: Eat-in Kitchen
Location: Lakefront
Lot Description: Private Lake, Lake on Lot, Pond on Lot, Wooded, Open
Lot Size: 2-5 Acres, 2.54 Acres
Other: Association Fee, Water Softener - Own
Property Description: Acreage
Roof: Asphalt Shingle Roof
Rooms: Library
Sewer: Private
Style: 1.5 Story
Views: Scenic, Lake & Stream, Pond
Water: Well
1 | 2 | 3 | 48 Next

The Linda Frierdich Real Estate Group Real Estate & Homes for Sale - 72 Listings Found

MY PLACES
Locate important places on the map like school, work, and home of a relative or friend to help find the best properties for you.
Add, Edit, or View My Places
DRAWING TOOL
Draw the area on the map that you would like to search. Click the pencil icon again to turn the drawing tool off.
DRAWING TOOL
Points Of Interest
Area Overlay
$50K $1M+
Heat maps are viewable one at a time.
Click the buttons to toggle them on or off.