This home's estimate is 15.2% higher than the average sale price ($614K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate



































475 Longhi Rd, Collinsville, IL 62234
About this home
TRIAD SCHOOLS! BE PREPARED TO SAY "WOW" WHEN YOU SEE THIS CUSTOM-BUILT MOSTLY BRICK HOME ON 5 ACRES! FLOOR PLAN WITH VAULTED CEILINGS AND WINDOWS GALORE! KITCHEN FEATURES BEAUTIFUL CUSTOM CABINETRY, QUARTZ COUNTER TOPS AND STAINLESS APPLIANCES AND OPENS TO A LARGE DINING AREA WITH A VIEW OF THE 5 ACRE PARTIALLY WOODED AND VERY PRIVATE BACK YARD. AWESOME SPLIT BEDROOM FLOOR PLAN WITH THE MASTER SUITE BEING VERY PRIVATE AND INCLUDING A LARGE BEDROOM WITH DOORS TO DECK - WINDOWS ACROSS THE BACK WITH AWESOME PRIVATE VIEWS AND A MASTER BATHROOM THAT FEATURES SEPARATED DUAL BOWL VANITIES, WHIRLPOOL TUB AND SEPARATE SHOWER - AND A 18 X 6 WALK IN CLOSET! THE OTHER BEDROOMS ARE SPACIOUS WITH LARGE CLOSETS AND SEPARATED BY A JACK 'N JILL BATHROOM. LOWER LEVEL WALKS OUT TO A CONCRETE PATIO AND FEATURES A MASSIVE FAMILY/GAME ROOM, BONUS ROOM WIRED FOR SURROUND SOUND, 4TH BEDROOM WITH CROWN MOLDING AND LARGE CLOSET AND A FULL BATH! HORSES ALLOWED - 2 PER MAD. CO. SQ. FOOTAGE IS APPROXIMATE.
Redfin Estimate
Earn from this home
List your home with Redfin and save $7,071
Get cash now or lower your monthly rate
List your home for rent
Market trends in 62234, IL
Last updated July 2026
Buyer's Market
Seller's Market
Seller's market
0.0% MoM
See all
Provided by Redfin
Sale history for 475 Longhi Rd
$102/sq ft
$105/sq ft
$25/sq ft
Tax history for 475 Longhi Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking Information
- Parking Features: Attached Garage
- Garage Spaces: 3
- Has Attached Garage
- Has Garage
Interior
- Virtual Tour
- Bedroom Information
- # of Bedrooms: 4
- # of Bedrooms Main: 3
- Bathroom Information
- # of Full Baths (Total): 3
- # of Half Baths (Total): 1
- # of Main Level Bathrooms (Total): 1
- Main Level # of Half Bathrooms: 1
- Room 1 Information
- Room Type: Bedroom
- Room Length: 16
- Room Width: 12
- Room Level: Second or Main
- Room 2 Information
- Room Type: Bedroom
- Room Length: 15
- Room Width: 12
- Room Level: First or Lower
- Room 3 Information
- Room Type: Family Room
- Room Length: 41
- Room Width: 18
- Room Level: First or Lower
- Room 4 Information
- Room Type: Kitchen
- Room Length: 16
- Room Width: 14
- Room Level: Second or Main
- Room 5 Information
- Room Type: Living Room
- Room Length: 18
- Room Width: 16
- Room Level: Second or Main
- Room 6 Information
- Room Type: Other Room
- Room Length: 15
- Room Width: 10
- Room Level: First or Lower
- Room 7 Information
- Room Type: Bedroom
- Room Length: 19
- Room Width: 18
- Room Level: Second or Main
- Room 8 Information
- Room Type: Bedroom
- Room Length: 15
- Room Width: 14
- Room Level: Second or Main
- Room 9 Information
- Room Type: Dining Room
- Room Length: 13
- Room Width: 12
- Room Level: Second or Main
- Room 10 Information
- Room Type: Other Room
- Room Length: 11
- Room Width: 8
- Room Level: Second or Main
- Room 11 Information
- Room Type: Other Room
- Room Length: 16
- Room Width: 11
- Room Level: Second or Main
- Room 12 Information
- Room Type: Other Room
- Room Length: 12
- Room Width: 9
- Room Level: Second or Main
- Room 13 Information
- Room Type: Other Room
- Room Length: 27
- Room Width: 18
- Room Level: First or Lower
- Basement Information
- Basement Features: Walk-Out Access
- Fireplace Information
- Has Fireplace
- # of Fireplaces: 1
- Heating & Cooling
- Has Heating
- Heating Information: Forced Air
- Cooling Information: Central Air
- Interior Features
- Appliances: Dishwasher, Microwave, Range, Refrigerator
Exterior
- Building Information
- Roof: Asphalt
- Property Information
- Property Type: Residential
- Property Sub Type: Residential
- Above Grade Finished Area: 2,620
- Below Grade Finished Area: 1,750
- Lot Information
- Lot Features: None, Suitable for Horses
- Lot Size Acres: 5
- Lot Size Dimensions: 5 Acres
Financial
- Tax Information
- Tax Annual Amount: $6,496
- Tax Year: 2014
Utilities
- Utility Information
- Water Source: Public
- Sewer: Private Sewer
Location
- HOA Information
- Association Amenities: Deck, Patio
- School Information
- Elementary School: TRIAD DIST 2
- Middle Or Junior High School: TRIAD DIST 2
- High School: Triad
- High School District: Triad DIST 2
- Location Information
- Directions: Rt 40 to Formosa to W. Kirsch to Longhi
- Cross Street: W Mill Creek
Public facts
- Beds: 3
- Baths: 1.5
- Sq. Ft.: 2,620
- Stories: 1.0
- Lot Size: 5 acres
- Style: Single Family Residential
- Year Built: 2008
- Year Renovated: —
- County: Madison County
- APN: 091223000000006004
Other
- Home Information
- Living Area: 4370
- Levels: One
Around this home
Schools
Public PreK-5 • Assigned • 4.6mi
Public 6-8 • Assigned • 6.5mi
Public 9-12 • Assigned • 4.7mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 106° expected this year, 21 days in 30 years
1% chance of strong winds in next 30 years
3 unhealthy days expected this year, 3 days in 30 years
Sun exposure
In this area, properties receive around 9.9 hours in June and 4.1 hours in December, which is comparable to the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 62234
Home values near 475 Longhi Rd
| Address | Redfin Estimate |
|---|---|
2 Beds | 1.5 Baths | 1472 Sq. Ft. | $603,544 |
2 Beds | - Baths | 816 Sq. Ft. | $165,906 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 1 Baths | 1600 Sq. Ft. | $182,015 |
3 Beds | - Baths | 1232 Sq. Ft. | $280,287 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1334 Sq. Ft. | $305,238 |
5 Beds | 3 Baths | 3300 Sq. Ft. | $507,410 |
More real estate resources
- Zip Codes
- Neighborhoods
- Cities
- Popular Searches
| 62234 homes for sale | |||
| 62034 homes for sale | |||
| 62040 homes for sale | |||
| 62062 homes for sale | |||
| 62232 homes for sale |
| St. Louis Road homes for sale |
| St. Louis homes for sale | |||
| Webster Groves homes for sale | |||
| Belleville homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
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.












































United States
Canada