Landlord's Agent in 2025
Mandy McGuire
Keller Williams Pinnacle
(618) 558-1350
283 in this area
702 Total Sales
1547 Frost Landing Columbia, IL 62236
5
Beds
4.5
Baths
4,790
Sq Ft
$166
Price per Sq Ft
Highlights
- In Ground Pool
- Family Room with Fireplace
- Traditional Architecture
- Columbia High School Rated 9+
- Vaulted Ceiling
- Wood Flooring
About This Home
As of August 2025Uniquely designed & attention to detail describes this Masterfully crafted 5bed/5bath on corner lot in Brellinger subdivision. Welcoming foyer flooded w/natural light shows off the incredible Brazilian Pecan Hardwood floor, Spacious Formal Dining & Cozy Living rm w/gas fireplace. Gourmet kitchen w/huge island, luxury appliances, under cabinet lighting, tile backsplash & hearth rm that could serve as breakfast rm. Hearth rm opens to the amazing backyard/pool area & see thru fireplace to private den. Luxury primary suite w/coffered ceiling, customized closet, double vanity & oversized dual shower. Laundry w/flooding area tall enough to hide the ironing board,Full bath, 2 large beds w/shared bathroom, butlers pantry w/wine fridge, drop zone off the garage & powder rm complete the main level. In the lower level you will find the family rm w/electric fireplace, rec rm & bar area, 4th/5th beds, full bath & 2 storage areas. Too many features to list, call for the list or to set up your tour!
Last Agent to Rent the Property
Keller Williams Pinnacle License #475127709 Listed on: 07/19/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 2020
Lot Details
- 0.6 Acre Lot
- Lot Dimensions are 16'x55'x75'x179'x203'x132'
- Landscaped
- Corner Lot
- Level Lot
- Front and Back Yard Sprinklers
- Few Trees
- Back Yard Fenced and Front Yard
HOA Fees
- $30 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Side Facing Garage
- Garage Door Opener
- Driveway
- Uncovered Parking
- Off-Street Parking
Home Design
- Traditional Architecture
- Brick Veneer
- Architectural Shingle Roof
- Concrete Perimeter Foundation
Interior Spaces
- 1-Story Property
- Bar
- Vaulted Ceiling
- Ceiling Fan
- Recessed Lighting
- Chandelier
- Insulated Windows
- Entrance Foyer
- Family Room with Fireplace
- 3 Fireplaces
- Living Room with Fireplace
- Breakfast Room
- Formal Dining Room
- Recreation Room with Fireplace
- Storage
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Walk-In Pantry
- Butlers Pantry
- Double Oven
- Gas Cooktop
- Range Hood
- Microwave
- Dishwasher
- Wine Cooler
- Stainless Steel Appliances
- Kitchen Island
- Stone Countertops
Flooring
- Wood
- Carpet
- Concrete
- Ceramic Tile
- Vinyl
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- Easy To Use Faucet Levers
- Soaking Tub
- Shower Only
- Separate Shower
Laundry
- Laundry Room
- Laundry on main level
- Sink Near Laundry
Partially Finished Basement
- Basement Fills Entire Space Under The House
- 9 Foot Basement Ceiling Height
- Sump Pump
- Bedroom in Basement
- Finished Basement Bathroom
- Basement Storage
- Basement Window Egress
Home Security
- Security Lights
- Fire and Smoke Detector
Pool
- In Ground Pool
- Outdoor Pool
- Fence Around Pool
- Pool Cover
Outdoor Features
- Covered Patio or Porch
- Exterior Lighting
Location
- City Lot
Schools
- Columbia Dist 4 Elementary And Middle School
- Columbia High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
- Cable TV Available
Community Details
- Brellinger Fourth Add Association
Listing and Financial Details
- Security Deposit $4,800
- Property Available on 7/19/25
- Tenant pays for all utilities
- The owner pays for all utilities
- Negotiable Lease Term
- Assessor Parcel Number 04-04-450-003-000
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 7, 2019
Sold by
Brellinger Trust
Bought by
Holzrichter Robb Anthony and Powell Kenneth Shawn
Current Estimated Value
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Holzrichter Robb Anthony | $72,000 | Monroe County Title Company |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 08/01/2025 08/01/25 | Rented | $4,800 | 0.0% | -- |
| 07/19/2025 07/19/25 | For Rent | $4,800 | -- | -- |
Source: MARIS MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $13,837 | $248,099 | $35,327 | $212,772 |
| 2023 | $13,124 | $220,340 | $34,940 | $185,400 |
| 2022 | $12,458 | $206,260 | $34,410 | $171,850 |
| 2021 | $11,267 | $188,670 | $24,130 | $164,540 |
| 2020 | $1,676 | $24,130 | $24,130 | $0 |
| 2019 | $74 | $1,060 | $1,060 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Mandy McGuire
Map
Source: MARIS MLS
MLS Number: MIS25049999
APN: 04-04-450-003-000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Based on information submitted to the MLS GRID. 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. Some IDX listings have been excluded from this website.
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked.
Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.
The DMCA requires that your notice of alleged copyright infringement include the following information:
(1) description of the copyrighted work that is the subject of claimed infringement;
(2) description of the alleged infringing content and information sufficient to permit us to locate the content;
(3) contact information for you, including your address, telephone number and email address;
(4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law;
(5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and
(6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Nearby Homes
- 1539 Frost Landing
- 420 Micahs Way
- 5 Ogle Estates
- 7 Ogle Estates
- 4 Ogle Estates
- 2838 Robert Dr
- 2846 Robert Dr
- 1391 Walnut Ridge Dr
- 305 Fox Run Dr
- 1379 Walnut Ridge Dr
- 1374 Walnut Ridge Dr
- 2620 Brookfield Ct
- 527 Fairfax Dr
- 221 E Crestview Dr
- 6 Ogle Estates
- 3 Ogle Estates
- 2219 Stone Gate Dr
- 1 Ogle Estates
- 106 W Cascade Dr
- 2148 Stone Gate Dr
- 1544 Frost Landing
- 1559 Frost Landing
- 516 Lacroix Way
- 1605 Martin Dr
- 522 Lacroix Way
- 410 Brellinger
- 512 Charles Way
- 422 Brellinger
- 528 Lacroix Way
- 510 Lacroix Way
- 517 Charles Way
- 428 Brellinger
- 405 Brellinger St
- 523 Lacroix Way
- 4 Ogle Ridgeway
- 4 Ogle Ridgeway
- 413 Brellinger
- 534 Lacroix Way
- 2 Ogle Ridgeway
- 502 Pfeffer Dr