OFF MARKET

Last listed at $429,000, CLOSED ON Apr 2018

$635,274

Est. refi paymentEst. refi $3,275/mo

•

3,862

sq ft

1704 Columbia Quarry Rd, Columbia, IL 62236

About this home

Absolutely STUNNING 4 bedroom estate nestled on 2.5 acres backing to Fairfield Golf Club. Though built in 1956 this home was gutted to the studs & expanded in 2009. The outdoor living space is an entertainers dream! The custom tiki hut features built in kegerator, mini fridge & concrete slide leading to the in-ground pool highlighted by 2 cascading waterfalls. Step out of the pool & onto the beautiful stamped concrete patio featuring a fire pit & new built in outdoor kitchen. Expansive 75 x 50 finished outbuilding includes ½ bath & is loaded w/ amenities (See Features Sheet). Head inside this gorgeous home to find soaring vaulted ceilings & great natural light throughout. Incredible master bedroom features coffered ceiling, electric fireplace, 2 huge walk in closets & attached master bath w/ whirlpool tub, oversized marble shower & dual vanity. The family room offers wood burning stove & snack bar. The kitchen is higlighted by beautiful ceramic tile, tile backsplash & breakfast area.

Single-familyProperty Type

1956Year Built

2.57 acresLot Size

$164Est. Price/Sq.Ft.

12 car garageParking

Listed by Linda Frierdich • Century 21 Advantage

Bought with Wendy Santiago • Nester Realty

Redfin checked: a minute ago

•Source:MARIS as Distributed by MLS Grid #16063715

Redfin Estimate

$635,274

$206K over list price of $429K

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 21.4% higher than the average sale price ($523K) of 6 comparable homes.

SOLD SEP 14, 2026
$450,000
A
4 beds3 baths3,269 sq ft
818 E Wood Dr, Columbia, IL 62236
SOLD SEP 10, 2026
$560,000
B
4 beds3.5 baths3,788 sq ft
1515 Gedern Dr, Columbia, IL 62236
SOLD FEB 2, 2026
$549,900
C
4 beds3.5 baths5,048 sq ft
221 Tower Hill Dr, Columbia, IL 62236
SOLD JUL 30, 2026
$695,000
D
4 beds3 baths4,094 sq ft
607 W Laura Ct, Columbia, IL 62236
SOLD JUL 17, 2026
$541,000
E
4 beds3 baths3,376 sq ft
614 Laura Ct, Columbia, IL 62236
SOLD JUL 24, 2026
$345,000
F
3 beds3 baths2,710 sq ft
307 Longview Dr, Columbia, IL 62236

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$596,725

Est. take-home

List your home with Redfin and save $6,353

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,427/mo

Redfin rental estimate

List your home for rent

Market trends in 62236, IL

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.6%

0.4% MoM

Median sale price

$362K

$27K MoM

Avg. days on market

32d

0 days MoM

Recently sold homes

6 MoM

New listings for sale

COMING SOON
$289,900
3 beds2 baths2,266 sq ft
1360 N Glenwood Dr, Columbia, IL 62236
$235,000
2 beds1 bath1,285 sq ft
218 W Liberty St, Columbia, IL 62236
COMING SOON
$375,000
4 beds2.5 baths3,536 sq ft
242 Gall Rd, Columbia, IL 62236
COMING SOON
$259,000
2 beds1.5 baths1,800 sq ft
325 W Liberty St, Columbia, IL 62236
$265,000
3 beds1.5 baths1,120 sq ft
460 Fairfax St, Columbia, IL 62236
$207,500
2 beds1 bath1,075 sq ft
227 W Washington St, Columbia, IL 62236
$299,000
3 beds3 baths1,232 sq ft
2704 Harres Ln, Columbia, IL 62236
$869,900
8 beds5 baths4,310 sq ft
2838 Woodson Dr, Columbia, IL 62236
FOR SALE BY OWNER
$315,000
4 beds2 baths2,475 sq ft
450 Dianne Ave, Columbia, IL 62236
$299,500
3 beds1 bath1,420 sq ft
1608 Daleview St, Columbia, IL 62236
See all

Provided by Redfin

Sale history for 1704 Columbia Quarry Rd

Date

Event

Price

Public Records

Apr 13, 2018

Sold

$420,000

$109/sq ft

MARIS as Distributed by MLS Grid #16063715

Apr 12, 2018

Pending

—

Apr 11, 2018

Sold

Mar 13, 2018

Contingent

—

Mar 13, 2018

Relisted

—

Mar 9, 2018

Delisted

—

Dec 14, 2017

Contingent

—

Oct 9, 2017

Price Changed

$429,000

$111/sq ft

Jun 16, 2017

Price Changed

$449,000

$116/sq ft

Feb 24, 2017

Price Changed

$469,000

$121/sq ft

Nov 15, 2016

Price Changed

$479,000

$124/sq ft

Oct 20, 2016

Price Changed

$489,000

$127/sq ft

Sep 8, 2016

Listed

$495,000

$128/sq ft

Public Records

Apr 18, 2007

Sold

$169,500

$44/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$11,011 (+9.3%)

$9,163 + $178,521

$187,684

2024

$10,073 (+1.9%)

$9,393 + $160,375

$169,768

2023

$9,887 (+3.7%)

$8,728 + $149,022

$157,750

2022

$9,532 (+5.9%)

$8,187 + $139,782

$147,969

2021

$9,002 (+11.9%)

$7,704 + $131,545

$139,249

2020

$8,049 (+7.8%)

$7,508 + $111,257

$118,765

2019

$7,463 (+3.8%)

$7,054 + $104,535

$111,589

2018

$7,189 (+3.7%)

$6,730 + $99,738

$106,468

2017

$6,935 (+26.9%)

$6,432 + $95,315

$101,747

2016

$5,463

$6,515 + $75,202

$81,717

Tax history for 1704 Columbia Quarry Rd

Year

Property tax

Land + Additions

Assessment*

2025

$11,011 (+9.3%)

$9,163 + $178,521

$187,684

2024

$10,073 (+1.9%)

$9,393 + $160,375

$169,768

2023

$9,887 (+3.7%)

$8,728 + $149,022

$157,750

2022

$9,532 (+5.9%)

$8,187 + $139,782

$147,969

2021

$9,002 (+11.9%)

$7,704 + $131,545

$139,249

2020

$8,049 (+7.8%)

$7,508 + $111,257

$118,765

2019

$7,463 (+3.8%)

$7,054 + $104,535

$111,589

2018

$7,189 (+3.7%)

$6,730 + $99,738

$106,468

2017

$6,935 (+26.9%)

$6,432 + $95,315

$101,747

2016

$5,463

$6,515 + $75,202

$81,717

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

—

Baths

Stories

Lot width

—

Lot depth

—

Lot size

2.57 Acres

Year renovated

2005

Sq. Ft.

4,514

Year built

1956

Style

Single Family Residential

County

St. Clair County

APN

11110300008

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 23, 2026.

Agricultural Industry District

The A Agricultural Industry District encompasses prime and important farmland in St. Clair County where soil, water, vegetal, and topographical conditions are well suited to the raising of crops and domestic animals. These areas have been traditionally used for agricultural farming, the raising of domestic animals and poultry, horticulture, forestry, and truck gardening.; The St. Clair County Board is aware of the historical and continuing importance of agriculture to the economic and social structure of the County and of the unique characteristics and requirements necessary to retain agriculture as a viable industry. In recognition of this, the St. Clair County Board has established and adopted as a long range goal, the conservation and preservation of prime and important farmland (as defined by the U.S. Department of Agriculture Soil Conservation Service Evaluation System) and has acted to implement this goal through the adoption of a Comprehensive Plan and Zoning Code.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
Infrastructure
Military facility-Other
Educational / school
Recreation

Property details

Parking

Parking Information
Parking Features: Additional Parking, Attached Garage, Detached, Garage Door Opener
Garage Spaces: 12
Carport Spaces: 0
Has Attached Garage
Has Garage

Interior

Virtual Tour

Bedroom Information
# of Bedrooms: 4
# of Bedrooms Main: 4

Bathroom Information
# of Full Baths (Total): 3
# of Half Baths (Total): 1
# of Main Level Bathrooms (Total): 4
# of Main and Upper Bathrooms: 4
Main Level # of Half Bathrooms: 1
Main Level # of Full Bathrooms: 3

Room 1 Information
Room Type: Dining Room
Room Dimensions: 20x16
Room Length: 20
Room Width: 16
Room Level: Second or Main

Room 2 Information
Room Type: Kitchen
Room Dimensions: 11x11
Room Length: 11
Room Width: 11
Room Level: Second or Main

Room 3 Information
Room Type: Hearth Room
Room Dimensions: 13x25
Room Length: 13
Room Width: 25
Room Level: Second or Main

Room 4 Information
Room Type: Great Room
Room Dimensions: 28x16
Room Length: 28
Room Width: 16
Room Level: Second or Main

Room 5 Information
Room Type: Master Bedroom
Room Dimensions: 19x16
Room Length: 19
Room Width: 16
Room Level: Second or Main

Room 6 Information
Room Type: Bathroom
Room Dimensions: 14x10
Room Length: 14
Room Width: 10
Room Level: Second or Main

Room 7 Information
Room Type: Den
Room Dimensions: 10x12
Room Length: 10
Room Width: 12
Room Level: Second or Main

Room 8 Information
Room Type: Other Room
Room Dimensions: 13x8
Room Length: 13
Room Width: 8
Room Level: Second or Main

Room 9 Information
Room Type: Bathroom
Room Dimensions: 5x5
Room Length: 5
Room Width: 5
Room Level: Second or Main

Room 10 Information
Room Type: Sitting Room
Room Dimensions: 10x7
Room Length: 10
Room Width: 7
Room Level: Second or Main

Room 11 Information
Room Type: Bedroom
Room Dimensions: 13x13
Room Length: 13
Room Width: 13
Room Level: Second or Main

Room 12 Information
Room Type: Bathroom
Room Dimensions: 6x8
Room Length: 6
Room Width: 8
Room Level: Second or Main

Room 13 Information
Room Type: Bedroom
Room Dimensions: 10x12
Room Length: 10
Room Width: 12
Room Level: Second or Main

Room 14 Information
Room Type: Bedroom
Room Dimensions: 11x15
Room Length: 11
Room Width: 15
Room Level: Second or Main

Room 15 Information
Room Type: Other Room
Room Dimensions: 12x12
Room Length: 12
Room Width: 12
Room Level: Second or Main

Room 16 Information
Room Type: Recreation Room
Room Dimensions: 21x15
Room Length: 21
Room Width: 15
Room Level: Second or Main

Room 17 Information
Room Type: Laundry
Room Dimensions: 10x12
Room Length: 10
Room Width: 12
Room Level: Second or Main

Room 18 Information
Room Type: Bathroom
Room Dimensions: 6x8
Room Length: 6
Room Width: 8
Room Level: Second or Main

Room 19 Information
Room Type: Family Room
Room Dimensions: 16x12
Room Length: 16
Room Width: 12
Room Level: First or Lower

Room 20 Information
Room Type: Other Room
Room Dimensions: 12x13
Room Length: 12
Room Width: 13
Room Level: First or Lower

Basement Information
Basement Features: Concrete, Partially Finished, Rec/Family Area

Other Rooms Information
# of Rooms: 17

Fireplace Information
Has Fireplace
# of Fireplaces: 2
Fireplace Features: Electric, Woodburning Fireplce

Heating & Cooling
Has Heating
Heating Information: Forced Air 90+
Cooling Information: Electric, ENERGY STAR Qualified Equipment

Interior Features
Interior Features: Bookcases, Cathedral Ceiling(s), High Ceilings, Coffered Ceiling(s), Open Floorplan, Special Millwork, Walk-in Closet(s), Wet Bar
Window Features: Low Emissivity Windows, Power Door Operator, Sliding Glass Doors
Appliances: Dishwasher, Electric Cooktop, Microwave, Refrigerator

Exterior

Building Information
Construction Materials: Brick, Vinyl Siding

Pool Information
Has Private Pool

Property Information
Ownership Type: Private
Property Type: Residential
Property Sub Type: Residential
Above Grade Finished Area: 3,514
Above Grade Finished Area Source: Public Records
Below Grade Finished Area: 348
Below Grade Finished Area Source: Other

Lot Information
Lot Features: Backs To Golf Course, Corner Lot
Lot Size Acres: 2.57
Lot Size Dimensions: 2.57 acres
Lot Size Source: Owner

Financial

Tax Information
Tax Annual Amount: $5,463
Tax Year: 2016

Utilities

Utility Information
Water Source: Cistern
Sewer: Septic Tank

Location

HOA Information
Association Amenities: Private Inground Pool, Security Lighting, Underground Utilities, Workshop Area

School Information
Elementary School: COLUMBIA DIST 4
Middle Or Junior High School: COLUMBIA DIST 4
High School: Columbia
High School District: Columbia DIST 4

Location Information
Directions: rt 158 to Columbia Quarry Rd or Main to Cherry St (Turns into Bluffside) house at 4 way stop
Cross Street: Bluffside

Public facts

Beds: —
Baths: 4.0
Sq. Ft.: 4,514
Stories: 1.0
Lot Size: 2.57 acres
Style: Single Family Residential
Year Built: 1956
Year Renovated: 2005
County: St. Clair County
APN: 11110300008

Home facts updated by county records on Jul 23, 2026

Other

Home Information
Living Area: 3862
Levels: One

Around this home

Schools

Eagleview Elementary School

Public PreK-1 • Assigned • 1.7mi

Columbia Middle School

Public 5-8 • Assigned • 2.2mi

8/10

Columbia High School

Public 9-12 • Assigned • 2.3mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

3/10 Fire Factor

0.77% chance of being in a wildfire in next 30 years

5/10 Heat Factor

7 days above 106° expected this year, 21 days in 30 years

2/10 Wind Factor

2% chance of strong winds in next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Columbia, IL • 62236

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.8 hours in June and 4.2 hours in December, which is comparable to the U.S. average for solar exposure.

9.8 hrs

4.2 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$604,000 – $731,000

Reach more buyers when you sell with Redfin. Save up to $6,353 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$740,000

5 beds4 baths4,049 sq ft

3025 Canman Ln, Columbia, IL 62236

NEW CONSTRUCTION

$465,000

2 beds2 baths1,658 sq ft

210 Northcrest Dr, Columbia, IL 62236

NEW CONSTRUCTION

$460,000

2 beds2 baths1,658 sq ft

205 Northcrest Dr, Columbia, IL 62236

NEW CONSTRUCTION

$460,000

2 beds2 baths1,658 sq ft

237 Northcrest Dr, Columbia, IL 62236

FOR SALE BY OWNER

$289,900

3 beds3 baths1,258 sq ft

104 Meadow Ln N, Columbia, IL 62236

NEW CONSTRUCTION

$460,000

2 beds2 baths1,658 sq ft

238 Northcrest Dr, Columbia, IL 62236

New listings for sale in 62236

COMING SOON

$289,900

3 beds2 baths2,266 sq ft

1360 N Glenwood Dr, Columbia, IL 62236

$235,000

2 beds1 bath1,285 sq ft

218 W Liberty St, Columbia, IL 62236

COMING SOON

$375,000

4 beds2.5 baths3,536 sq ft

242 Gall Rd, Columbia, IL 62236

COMING SOON

$259,000

2 beds1.5 baths1,800 sq ft

325 W Liberty St, Columbia, IL 62236

$265,000

3 beds1.5 baths1,120 sq ft

460 Fairfax St, Columbia, IL 62236

$207,500

2 beds1 bath1,075 sq ft

227 W Washington St, Columbia, IL 62236

$299,000

3 beds3 baths1,232 sq ft

2704 Harres Ln, Columbia, IL 62236

$869,900

8 beds5 baths4,310 sq ft

2838 Woodson Dr, Columbia, IL 62236

FOR SALE BY OWNER

$315,000

4 beds2 baths2,475 sq ft

450 Dianne Ave, Columbia, IL 62236

Home values near 1704 Columbia Quarry Rd

Data from public records.

Address

Address

Address

Property information provided by MARIS as Distributed by MLS Grid when last listed in 2016. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

63129 homes for sale
62236 homes for sale
62239 homes for sale
62298 homes for sale
62260 homes for sale

Houses for rent in Columbia	Agents near me	Glenview, IL homes for sale	Columbia Housing Market
Houses for sale near me	Chicago, IL homes for sale	Evanston, IL homes for sale
Land for sale near me	Naperville, IL homes for sale	Oak Park, IL homes for sale
Open Houses near me	Schaumburg, IL homes for sale	Columbia Property Records
Condos for sale near me	Arlington Heights, IL homes for sale	IL New Listings

St. Louis homes for sale
Chesterfield homes for sale
Webster Groves homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 62236, IL

Sale history for 1704 Columbia Quarry Rd

Tax history for 1704 Columbia Quarry Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 62236

Home values near 1704 Columbia Quarry Rd

More real estate resources