Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 609 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 609 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 609 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3133 Palmer Drive
Champaign, IL 61822

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 1776
Agency: homecoin.com

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Standing out amongst the homes in The Legends community, this modern farmhouse style home was recently built in 2021 with multiple custom upgrades made. Built by Central Illinois' most trusted custom home builder, it features energy-efficient HVAC, water heater, windows, and more. The inviting porch features a newly stained wood column and is the only home with double doors. The front doors open to a family room with cathedral ceilings and added recessed lighting. The first-floor features engineered light oak hardwood throughout with an open floor plan. The eat-in kitchen includes upgraded white and gold GE Cafe appliances, shaker cabinets, pantry, XL farmhouse sink, quartz backsplash, waterfall island with aesthetic panels, and gold fixtures. The master suite dons stunning views of the backyard and golf course and has additional recessed lighting along with a large walk-in closet. The master bathroom has been upgraded to including porcelain octagon floor tile, gold Delta plumbing fixtures, a floor to ceiling tiled shower with built-in niche. There are also dual sinks and a linen closet. The laundry room acts as the drop-zone when entering the home from the garage and features a built-in entryway bench and coat rack. A half-bath is located off the laundry room, fitted with a vessel sink. The second floor is accessed via an upgraded oak wood staircase with a matching handrail and tasteful spindles. It opens to a small loft with 2 bedrooms and a full bath featuring dual sinks and shower/tub combo. The entire second floor has vinyl flooring to match the white oak on the first floor. The basement is accessed from the laundry room It is unfinished with 8ft tall walls and is framed out for a bedroom, bathroom, and separate recreation room should the homeowner wish to add these on. There is ample room for storage. The backyard features a freshly stained deck, paver patio, grass surrounded by a wrought-iron fence with exceptional unblocked views of the Legends golf course. Sale of home comes with all appliances, including washer, dryer, and GE Cafe appliances. This home is a blank slate with tasteful upgrades for new homeowners to make their own. Conveniently located off Staley Road, near the Curtis Road I57 exchange and an easy access to the New Carle at the Fields. Near all the southwest Champaign shopping and dining! In addition to golf, the neighborhood has a clubhouse, swimming pool, daycare, and dog park.
MlsNumber: 11988632


Listing Provided By: homecoin.com, original listing
Name: homecoin.com
Phone: (888) 400-2513
Office Name: Homecoin.com
Office Phone: (888) 400-2513
Agent Name: Jonathan Minerick
Disclaimer: Copyright © 2024 Midwest Real Estate Data, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App