Sold
Last Sold Price
4 beds1,916 sqft$196/sqft
451 Longhi Rd, Collinsville, IL 62234
Single FamilyProperty Type
10 acresLot Size
1974Year Built
$196/sq ftPrice per sq ft

Description

Absolutely charming, 4 bedroom, 3 bath, country farmhouse on 10 acres in unincorporated Madison County! From the moment you turn into the tree lined, circle drive, you realize this is a special home. Privacy, acreage, a residence surrounded by trees and lovely views from every window in the house! Your peaceful country living includes a warm, inviting home filled with wood floors and beams, wood burning fireplaces, bright new kitchen, new fixtures, fresh paint, and other updates that make this home...Absolutely charming, 4 bedroom, 3 bath, country farmhouse on 10 acres in unincorporated Madison County! From the moment you turn into the tree lined, circle drive, you realize this is a special home. Privacy, acreage, a residence surrounded by trees and lovely views from every window in the house! Your peaceful country living includes a warm, inviting home filled with wood floors and beams, wood burning fireplaces, bright new kitchen, new fixtures, fresh paint, and other updates that make this home feel like the ultimate vacation cabin. The 2nd floor spacious master suite includes a shower, separate vanity, 12x12 walk in closet and an awesome view of the property. Main floor bedroom opens to the expansive rear deck and landscaped back yard that includes a decorative well house and fire pit. A 40x70 pole barn will hold your equipment and toys. Triad schools! Buyer to verify all MLS data including but not limited to square feet, measurements, features, exemptions/taxes, schools, etc.
  • Listed by: James Blasingame 618.722.3088 jamesblasingame@kw.com • Keller Williams Marquee
Listing closed: 06/08/2021 12:00 AM • Source: MARIS as distributed by MLS GRID, MLS#: 21025638

Recent comparable sales

Median sold price

$330,000

Avg days on market

30

Sale-to-list ratio

100.8%

Collinsville, IL

9 comparable properties found

$330,000 | 2027 Greenbrier Drive, Collinsville, IL 62234
1/36
1

$330,000

Sold 07/28/25

4
Bedrooms
2,147
Square Feet
Unavailable
Acres
$233,000 | 835 Longhi Road, Collinsville, IL 62234
1/42
2

$233,000

Sold 05/16/25

4
Bedrooms
1,824
Square Feet
0.92
Acres
$395,000 | 116 Red Pine Court, Collinsville, IL 62234
1/32
3

$395,000

Sold 06/06/25

4
Bedrooms
2,172
Square Feet
0.33
Acres
$275,000 | 215 Woodridge Court, Collinsville, IL 62234
1/26
4

$275,000

Sold 12/03/24

4
Bedrooms
2,164
Square Feet
0.64
Acres
$389,922 | 3 Linden Court, Collinsville, IL 62234
1/72
5

$389,922

Sold 05/23/25

4
Bedrooms
2,422
Square Feet
Unavailable
Acres
$340,000 | 1024 Hickory Point, Collinsville, IL 62234
1/50
6

$340,000

Sold 02/23/26

4
Bedrooms
3,038
Square Feet
0.27
Acres
$343,500 | 17 Pine Valley Drive, Collinsville, IL 62234
1/69
7

$343,500

Sold 02/21/25

4
Bedrooms
2,484
Square Feet
0.29
Acres
$300,000 | 149 Troy Road, Collinsville, IL 62234
1/41
8

$300,000

Sold 04/02/25

4
Bedrooms
1,829
Square Feet
0.53
Acres
$330,000 | 2016 Greenbrier Drive, Collinsville, IL 62234
1/39
9

$330,000

Sold 02/17/26

3
Bedrooms
2,180
Square Feet
0.27
Acres

Location

Listing Courtesy of Keller Williams Marquee

Sold By RE/MAX Preferred

Add your commute

Payment Calculator

$2,201 per month

30 year fixed, 6.71% Interest

Principal and Interest

$1,938

Property Taxes

$263

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 451 Longhi Road

Property Details
  • Taxes: $3,156 / year
  • MLS Type: Residential / 1.5 Story / Detached Single
  • Architectural Style: Traditional
  • Style Description: Other
  • Waterfront: No
  • Cross Street: Lockmann Rd
Building Information
  • Year Built: 1974
  • Lot Size: 10.00 AC / 435,600 SF
Summary
Location and General Information
  • City: Collinsville
  • County Or Parish: Madison
  • Directions: Lebanon Rd to Lockmann Rd to Longhi Rd.
  • Latitude: 38.675508
  • Longitude: -89.927862
  • Postal Code: 62234
  • State Or Province: IL
  • Sub division Name: .
  • Postal Code Plus 4: 6927
Taxes and HOA Information
  • List AOR: Greater Gateway Association of Realtors
  • Association Fee: $.00
  • Association Fee Frequency: None
  • Prop Asses City Tax: 1
  • HOA Fee Includes: NA
  • Parcel Number: 09-1-22-30-00-000-006.001
  • Tax Annual Amount: $3,156.00
  • Tax Legal Description: TR IN W PT SW
  • Tax Year: 2019
Owner
  • Township: Unincorporated
Parking
  • Attached Garage: Yes
  • Carport Spaces: 0.0
  • Carport: No
  • Covered Spaces: 2.0
  • Garage Spaces: 2.0
  • Garage: Yes
  • Parking Features: Attached Garage, Off Street
  • Parking Total: 0.0
  • Driveway: Asphalt,Gravel
School Information
  • Elementary School: TRIAD DIST 2
  • High School: Triad
  • High School District: Triad DIST 2
  • Middle Or Junior School: TRIAD DIST 2
Property
Lot Information
  • Living Area: 1916.0
  • Lot Features: Chain Link Fence, Wooded
  • Lot Size Acres: 10.0
  • Lot Size Dimensions: 10 acres
  • Lot Size Source: County Records
  • Lot Size Square Feet: 435600.0
  • Special Areas: Living Room
  • Other Structures: Pole Barn(s), Poultry Coup, Silo(s)
  • Property Sub Type: Residential
  • Property Type: Residential
Property and Assessments
  • Above Grade Finished Area: 1916.0
  • Above Grade Finished Area Source: Other
  • Below Grade Finished Area: 0.0
  • Below Grade Finished Area Source: County Records
  • Documents Count: 1
  • Photos Count: 57
  • Videos Count: 0
  • Year Built: 1974
  • Disclosures: Unknown, Sellers Discl. Avail, Unincorporated
  • Age: 47
  • Construction Materials: Brk/Stn Veneer Frnt, Vinyl Siding
  • Ownership Type: Private
  • BuyerFinancing: Conventional
Utilities
  • Sewer: Septic Tank
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Pool Private: No
Interior Features
  • Appliances: Dishwasher, Microwave, Gas Oven
  • Basement: Concrete, Fireplace in LL, Full, Partially Finished, Rec/Family Area, Bath/Stubbed, Walk-Out Access
  • Basement YN: Yes
  • Levels: One and One Half
  • Main Level Bathrooms: 1.0
  • Main Level Bedrooms: 1.0
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4
  • Low Full Baths: 0
  • Low half Baths: 0
  • Primary Bath Description: Shower Only
  • Upper Full Baths: 2
  • Upper Half Baths: 0
  • Fireplace Location: Basement,Living Room
  • Heat Source: Gas
  • Cooling: Ceiling Fan(s), Electric
  • Fireplace Features: Woodburning Fireplce
  • Fireplaces Total: 2
  • Fireplace: Yes
  • Heating: Forced Air
  • Heating YN: Yes
  • Interior Features: Window Treatments, Walk-in Closet(s), Some Wood Floors
  • Dining: Kitchen/Dining Combo
  • Window Features: Some Insulated Wndws, Some Tilt-In Windows
  • Rooms Total: 7
  • Main and Upper Bathrooms: 3
  • Main Level Full Bathrooms: 0
  • Main Level Half Bathrooms: 1
  • LivingAreaSource: Other
  • OtherEquipment: Ceiling Fan(s)
Room Information
Room 1
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 18x13
  • Room Length: 18.0
  • Room Level: 2 - M
  • Room Type: Living Room
  • Room Width: 13.0
Room 2
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 14x13
  • Room Length: 14.0
  • Room Level: 2 - M
  • Room Type: Dining Room
  • Room Width: 13.0
Room 3
  • Room Floor Covering: Luxury Vinyl Tile
  • Room Wall Covering: None
  • Room Dimensions: 12x11
  • Room Length: 12.0
  • Room Level: 2 - M
  • Room Type: Kitchen
  • Room Width: 11.0
Room 4
  • Room Floor Covering: Luxury Vinyl Plank
  • Room Wall Covering: None
  • Room Dimensions: 8x4
  • Room Length: 8.0
  • Room Level: 2 - M
  • Room Type: Bathroom
  • Room Width: 4.0
Room 5
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 27x16
  • Room Length: 27.0
  • Room Level: 3 - U
  • Room Type: Master Bedroom
  • Room Width: 16.0
Room 6
  • Room Floor Covering: Vinyl
  • Room Wall Covering: None
  • Room Dimensions: 8x4
  • Room Length: 8.0
  • Room Level: 3 - U
  • Room Type: Master Bathroom
  • Room Width: 4.0
Room 7
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 19x14
  • Room Length: 19.0
  • Room Level: 3 - U
  • Room Type: Bedroom
  • Room Width: 14.0
Room 8
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 14x13
  • Room Length: 14.0
  • Room Level: 3 - U
  • Room Type: Bedroom
  • Room Width: 13.0
Room 9
  • Room Floor Covering: Wood
  • Room Wall Covering: None
  • Room Dimensions: 11x11
  • Room Length: 11.0
  • Room Level: 2 - M
  • Room Type: Bedroom
  • Room Width: 11.0
Room 10
  • Room Floor Covering: Ceramic Tile
  • Room Wall Covering: Some
  • Room Dimensions: 10x10
  • Room Length: 10.0
  • Room Level: 3 - U
  • Room Type: Bathroom
  • Room Width: 10.0
Room 11
  • Room Floor Covering: Concrete
  • Room Wall Covering: None
  • Room Dimensions: 13x13
  • Room Length: 13.0
  • Room Level: 1 - L
  • Room Type: Kitchen
  • Room Width: 13.0
Room 12
  • Room Floor Covering: Concrete
  • Room Wall Covering: None
  • Room Dimensions: 18x14
  • Room Length: 18.0
  • Room Level: 1 - L
  • Room Type: Family Room
  • Room Width: 14.0
Room 13
  • Room Floor Covering: Concrete
  • Room Wall Covering: None
  • Room Dimensions: 12x11
  • Room Length: 12.0
  • Room Level: 1 - L
  • Room Type: Recreation Room
  • Room Width: 11.0
Room 14
  • Room Floor Covering: Concrete
  • Room Wall Covering: None
  • Room Dimensions: 14x12
  • Room Length: 14.0
  • Room Level: 1 - L
  • Room Type: Laundry
  • Room Width: 12.0
Bedrooms
  • Bedroom Description: Master Bdr. Suite
  • Main and Upper Beds: 4
  • Lower Beds: 0
  • Upper Beds: 3
Kitchen
  • Kitchen: Walk-In Pantry
Multi Family
Income & Expenses
  • Miscellaneous: Deck,Porch-Covered,Security Alarm-Leased
Rental
Rent Information
  • Sub Lease: 0

Property History for 451 Longhi Road

DateEvent & SourcePriceAppreciation
Jun 8, 2021

Closed

MARIS #21025638

$375,000
Jun 8, 2021

Closed

MRED #11067737

$375,000
Jun 4, 2021

Pending

MARIS #21025638

DateEvent & SourcePrice
06/08/2021

Closed

MARIS #21025638

$375,000
06/08/2021

Closed

MRED #11067737

$375,000
06/04/2021

Pending

MARIS #21025638

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 451 Longhi Road

Taxable ValueLand$15,180Additions$61,910Total$77,090
Tax Record2025$4,553 ($379 / month)
Home Facts
Beds2Baths2Total Finished SqFt936 SqFtAbove Grade Finished SqFt936 SqFtStories1Lot Size73,616 SqFtStyleMiscellaneous ResidentialYear Built1974Year Renovated1974CountyMADISONAPN09-1-22-30-00-000-006-001

Schools near 451 Longhi Road

This home is within Triad Community Unit School District 2.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Silver Creek Elementary School
PublicPK to 5

Triad Middle School
Public6 to 8

Triad High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 62234

$199,900 | 1396 North Keebler Avenue, Collinsville, IL 62234
1/46
New

$199,900

3
Bedrooms
1,872
Square Feet
0.5
Acres
$290,000 | 216 Willow Drive, Collinsville, IL 62234
1/34
Coming Soon

$290,000

3
Bedrooms
1,680
Square Feet
0.67
Acres
$220,000 | 106 Guinzy Hill, Collinsville, IL 62234
1/67

$220,000

3
Bedrooms
1,730
Square Feet
0.24
Acres
$54,895 | 1609 California Avenue, Collinsville, IL 62234
Active Under Contract

$54,895

3
Bedrooms
1,875
Square Feet
0.42
Acres
$484,900 | 19 Sugar Lane, Collinsville, IL 62234
1/66
Coming SoonOpen: 9/12 12:00PM - 02:00PM

$484,900

3
Bedrooms
3,000
Square Feet
1.19
Acres
$132,900 | 259 Silver Fox Crossing, Collinsville, IL 62234
1/24

$132,900

3
Bedrooms
1,848
Square Feet
3,500
Acres
$210,000 | 108 St Mary Drive, Collinsville, IL 62234
1/26
Active Under Contract

$210,000

3
Bedrooms
1,802
Square Feet
0.76
Acres
$185,000 | 300 Pine Lake Road, Unit 14, Collinsville, IL 62234
1/26
Active Under Contract

$185,000

2
Bedrooms
1,519
Square Feet
$290,000 | 809 Braidwood Court, Collinsville, IL 62234
1/35

$290,000

3
Bedrooms
1,659
Square Feet
0.22
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 451 Longhi Road, Collinsville, IL 62234
$375,000
4
1,916
435,600
$445,000
4
4,370
$107,500
1
2
2,105
217,800
$45,000
3
2
2,000
348,480
$173,000
3
2
1,656
188,615
$174,000
3
1
1,232
87,120

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Keller Williams Marquee

Based on information submitted to the MLS GRID as of 06/10/2021 07:57 AM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.