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 | 46 Next

$1,900,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
PRICE REDUCED!

$489,000

5643 Lemen Rd Waterloo, IL 62298
3 Beds 2,814 Sq. Ft
1 Full Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4313882
PROPERTY DESCRIPTION: 
Country charmer on 43.9 magnificent acres! Fall in love with this stone combo home with covered front porch and attached carport situated down a private drive in a retreat like setting featuring mature trees, meadow like yard and peach and apple trees. The expansive living room features plush carpet, a stone fireplace and wet bar. Also find an additional seating area and loads of natural light, and exposed wood beams. The eat in kitchen with vintage cabinets offers a built in oven, ample counter space and room for your table. The cavernous 17x22 main floor master bedroom with plush carpet and loads of closet space is sure to please. Upstairs space find a 14x16 second bedroom with plush carpet, neutral decor and natural light. Also find a versatile 16x15 bedroom with great views of the beautiful country side. Enjoy the breathtaking land and abundant storage you will find in the 50x40 shed and a oversized 4 car detached garage. This private retreat is just 5 miles form WHS! Will Divide.
FEATURES:
Age: Over 50 Years Old
Appliances: Dishwasher, Dryer, Garbage Disposal, Range / Oven, Refrigerator, Washer
Area Description: Country Living, Privacy
Basement: Crawl Space
Bath Features: Tub and Shower
Cooling: Central A/C - Electric
Exterior: Out Building, Barn/Stable
Exterior Description: Stone, Wood Siding
Exterior Living Space: Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Stone
Flooring: Linoleum, Wall to Wall Carpet
Garage Count: 4 Car Garage
Garage Description: Detached Garage
Heating - Fuel Type: Electric
Heating Type: Forced Air
Kitchen Features: Eat-in Kitchen
Lot Description: Wooded
Lot Size: 20-50 Acres, 43.9 Acres
Property Description: Acreage
Road Type: County Street
Sewer: Private
Style: 1.5 Story
Water: City Water

$449,000

3524 Sweet Briar Ln Columbia, IL 62236
5 Beds 4,953 Sq. Ft
4 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4312696
PROPERTY DESCRIPTION: 
Beauty and space abound in this amazing 2 story, 5 bedroom, 5 bath dream home with spectacular views of the countryside. Welcomed by the inviting foyer with marble flooring, french doors leading to the spacious office and an open view of the lovely formal dining room which boasts gleaming hardwood floors, you're sure to feel right at home. The expansive living room features plush carpet, a fabulous wet bar, neutral decor and access to the no maintenance deck. You'll be blown away by the beautiful and abundant maple cabinetry with crown molding in the gorgeous eat in kitchen which features ceramic tile floors, island, walk in pantry, granite countertops and a chef's range! The master suite features plush carpet, vaulted ceiling, jacuzzi tub, double vanity, separate shower, and a makeup vanity. This amazing home also features a theatre room with stadium seating, a fabulous hot tub room, a beautiful deck with amazing views of the pool and fantastic lot, a finished basement and much more!
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Dryer, Garbage Disposal, Range / Oven, Refrigerator, Washer
Basement: Walk-out
Bath Features: Jacuzzi Tub, Tub and Shower
Cooling: Central A/C
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio, Deck
Fencing: Partially Fenced
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace
Flooring: Hardwood, Marble, Wall to Wall Carpet, Ceramic
Garage Count: 5 + Car Garage
Garage Description: Attached Garage
Heating Type: Forced Air
Interior: Walk-in Closet, Wet Bar
Kitchen Features: Granite Countertops, Eat-in Kitchen, Center Island
Lot Size: 2-5 Acres, 3.43 Acres
Pool Description: Inground
Property Description: Acreage
Road Type: County Street
Rooms: Media Room / Home Theater
Sewer: Private
Style: 2 Story
Views: Scenic
Water: City Water

$419,000

1556 Mule Road Columbia, IL 62236
3 Beds 5,037 Sq. Ft
4 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4312952
PROPERTY DESCRIPTION: 
Sprawling 3 bedroom, 4.5 bath home on nestled on a private & parklike 5+ acres showcases Hardy Board siding, picture perfect salt water pool w/maintenance free fence surround & entertainers' patio, multi-tiered maintenance free deck, covered patio, 2 car attached garage/addtl 2 car detached garage w/loft, & updates throughout. Main level houses versatile living room w/ loads of light! Cavernous formal dining room with a beautiful fireplace & attached sitting area are sure to please. Find an eat in kitchen w/ cherry cabinetry, granite counters, island, & porcelain tile floors. Mud room, climate controlled sun room, & full bath complete the main level. Enjoy a sprawling master suite upstairs w/ vaulted ceiling, walk in closet,bay window, plus an attached bath w/ stunning tile work throughout, walk-in shower jacuzzi tub, & double vanity. Leading to the patio that connects to the fenced pool area, finished walk out basement offers family room w/wood burning stove, bonus room & half bath.
FEATURES:
Age: 31-40 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Area Description: Country Living, Privacy
Basement: Walk-out
Bath Features: Jacuzzi Tub, Tub and Shower
Cooling: Central A/C - Electric
Exterior Description: Hardiboard Siding
Exterior Living Space: Patio, Deck
Fencing: Partially Fenced
Fireplace Count: 2 Fireplaces
Fireplace Description: Fireplace, Wood Burning Stove
Flooring: Tile, Wall to Wall Carpet, Ceramic
Garage Count: 4 Car Garage
Garage Description: Attached Garage, Detached Garage
Heating - Fuel Type: Propane
Heating Type: Forced Air
Kitchen Features: Granite Countertops, Eat-in Kitchen, Center Island
Lot Size: 5-10 Acres, 5.03 Acres
Pool Description: Inground, Pool
Property Description: Acreage
Road Type: County Street
Sewer: Private
Style: 2 Story
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

$389,900

112 Country Ridge Columbia, IL 62236
5 Beds 4,526 Sq. Ft
3 Full Baths 1 Half Bath
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4314840
PROPERTY DESCRIPTION: 
Country Crossings welcomes you to this fabulous 4500+ sqft home with 5 sprawling bedrooms and 3 & 1/2 baths! The main level boasts a warm foyer with wood floors, a formal dining room w/ bay window, 2 story stone fireplace & 18ft ceiling in the sprawling living room that opens to the generously sized eat in kitchen with maple cabinetry w/crown molding, granite counters, ceramic tile/wood floors, breakfast bar, pantry room & glass doors leading to the covered stamped concrete patio. The luxurious main floor master suite features dual walk in closets, double vanity, jacuzzi tub & separate shower. Laundry room & 3/4 bath complete the main level. Comfortable loft, 4 spacious bedrooms and a full bath w/ ceramic tile floors & linen closet, & home office are found upstairs. The finished lower level features a cavernous family room, wet bar w/ granite counters, workout room and half bath. Outside enjoy fabulous covered patio & salt water pool with gorgeous low maintenance landscaping.
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven
Basement: Full
Bath Features: Jacuzzi Tub, Tub and Shower
Cooling: Central A/C - Electric
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio
Fencing: Fenced Yard
Fireplace Count: 1 Fireplace
Fireplace Description: Fireplace, Stone
Flooring: Hardwood, Wall to Wall Carpet, Ceramic
Garage Count: 3 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Gas
Heating Type: Forced Air
Kitchen Features: Granite Countertops, Breakfast Bar
Lot Size: 1/2 - 1 Acre, 0.55 Acres
Other: Association Fee
Pool Description: Inground
Sewer: City
Style: 2 Story
Water: City Water

$389,000

3841 LL Road Fults, IL 62244
3 Beds 2,532 Sq. Ft
2 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4314955
PROPERTY DESCRIPTION: 
Country Chic style Estate Home on 40 breathtaking acres showcases thoughtful touches throughout such as hardwood floors, geo thermal hvac, glass front display case, ceramic tile flooring, vaulted ceiling & much more. You will be awed by the grandeur of the towering ceiling with exposed beams, beautiful wood trim, natural light and expansive size of the living room. The open eat in kitchen featuring tile floors, loads of cabinetry, ample prep space, large island, built in oven, attached buffet, & generous breakfast nook make this an entertainers dream. Gleaming hardwood floors of the dining room are sure to please. The sprawling loft w/ vaulted ceiling offers fabulous views & endless possibilities. Master suite is complete w/ walk in closet, jacuzzi tub, separate shower, oversize vanity & linen closet. A sizable additional bedroom, a full bath, and laundry room w/mop sink and vanity complete the living space. You will also find a full walkout basement & 60 x 80 outbuilding w/ electric.
FEATURES:
Age: 11-20 Years Old
Appliances: Range / Oven, Refrigerator
Area Description: Country Living
Basement: Walk-out
Bath Features: Jacuzzi Tub, Tub and Shower
Cooling: A/C
Exterior: Out Building
Exterior Description: Vinyl Siding
Exterior Living Space: Deck
Flooring: Hardwood, Wall to Wall Carpet, Ceramic
Garage Count: 2 Car Garage
Garage Description: Detached Garage
Heating - Fuel Type: Geothermal
Interior: Walk-in Closet, Vaulted Ceilings
Kitchen Features: Eat-in Kitchen, Center Island
Lot Size: 20-50 Acres, 40 Acres
Property Description: Acreage
Road Type: County Street
Sewer: Private
Style: 1.5 Story
Views: Scenic
Water: Other Water Source

$309,000

1344 Briar Path Ct Columbia, IL 62236
3 Beds 2,176 Sq. Ft
2 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4311840
PROPERTY DESCRIPTION: 
Beautiful ranch brick combo with three spacious bedrooms and two full baths located well sought out Briar Lake subdivision. Sprawling park like lot, professionally landscaped and inviting front porch offers amazing curb appeal. The elegant master suite with walk in closet and a master bath that features a double vanity, garden tub and separate shower are sure to fit the bill. The natural light, neutral decor and fireplace in the family room compliment the amazing kitchen that offers ample room at the large breakfast bar. The open floor plan flows beautifully from living area to the spacious no maintenance deck that overlooks the large back yard and expansive patio. Vaulted ceilings soaring from the foyer through the living room to the breakfast nook and kitchen. Trey ceilings in the formal dining room, stainless steel appliances and the unfinished walkout basement with rough in plumbing, and a three car garage make this a must see! Contingent upon seller finding suitable home.
FEATURES:
Age: 1-5 Years Old
Appliances: Dishwasher, Garbage Disposal, Microwave, Range / Oven, Refrigerator
Basement: Walk-out
Bath Features: Tub and Shower
Cooling: Central A/C - Electric
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio, Deck
Fireplace Count: 1 Fireplace
Flooring: Hardwood, Linoleum, Wall to Wall Carpet
Garage Count: 3 Car Garage
Garage Description: Attached Garage
Heating - Fuel Type: Gas
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Eat-in Kitchen, Breakfast Bar
Lot Size: 1/2 - 1 Acre, 0.61 Acres
Other: Association Fee
Property Description: Community Living
Road Type: City / Town Street
Sewer: Public
Style: 1 Level Ranch
Water: City Water

$299,900

746 Gilmore Lake Road Waterloo, IL 62298
5 Beds 3,366 Sq. Ft
3 Full Baths
Listed By CENTURY 21 Advantage Real Estate, Inc.
MLS# 4315990
PROPERTY DESCRIPTION: 
Move in Ready home on 7.5 acres! Enjoy the privacy and take in the sights & sounds of nature from your spacious covered front porch or enjoy yourself on the expansive partially covered patio. Inside you'll be delighted by the warm flooring that flows throughout the home. You'll find real hardwood floors in the family room w/ a brick wood burning fireplace. The kitchen updated in 2010 features 42 inch maple cabinets, built in desk, island/breakfast bar, glass front cabinets, & spacious dining area w/ coffered ceiling. The master bedroom offers walk in closet & private bath w/ double vanity. Two additional bedrooms & a full bath complete the main level. The walkout finished lower level features a 2nd master suite w/ double vanity & Jacuzzi tub, a 5th bedroom, sprawling family room & laundry room w/ mop sink. Updates include water heater & partial roof in 13, water softener & purification system in 11 & 12! Bonuses include 40x25 2 car detached garage w/ office & pond/creek! Must see!
FEATURES:
Age: 11-20 Years Old
Appliances: Dishwasher, Dryer, Garbage Disposal, Microwave, Range / Oven, Refrigerator, Washer
Area Description: Country Living, Privacy
Basement: Walk-out
Bath Features: Jacuzzi Tub, Tub and Shower
Body of Water: Pond
Cooling: Central A/C - Electric
Exterior Description: Brick, Vinyl Siding
Exterior Living Space: Patio, Porch
Fireplace Count: 1 Fireplace
Fireplace Description: Brick, Wood Burning
Flooring: Hardwood, Linoleum, Laminate
Garage Count: 4 Car Garage
Garage Description: Attached Garage, Detached Garage
Heating - Fuel Type: Electric
Heating Type: Forced Air
Interior: Walk-in Closet
Kitchen Features: Breakfast Bar
Lot Description: Pond on Lot
Lot Size: 5-10 Acres, 7.5 Acres
Road Type: County Street
Sewer: Private
Style: 1 Level Ranch
Water: Well
1 | 2 | 3 | 46 Next

The Linda Frierdich Real Estate Group Real Estate & Homes for Sale - 57 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.