My Maloof

Saved Listing   Saved Listing
Unsaved Listing   Unsaved Listing
Luxury Home Portfolio   Luxury Home Portfolio
Just Listed   Just Listed
Price Change   Price Change
Virtual Tour   Virtual Tour
Save   Save This Listing
Unsave   Unsave This Listing

Icon Key

Contact Us  (309) 692-3900

121 Walnut Drive, East Peoria, IL 61611 - MLS# 1187422 - $199,900
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422
MLS# 1187422

Like new, 3 bedroom 3 bath home in desirable Walnut Hills subdivision.

Updates include, new Brazilian Cherry wood flooring in living room, all new carpet in bedrooms, remodeled master bath with whirlpool tub and new tile surround. New deck, freshened up landscaping, and new front door! Spacious kitchen is fully applianced. Finished lower level is plumbed for a wet bar. Spacious garage has built in air compressor outlets. Move in ready! Washer and dryer are negotiable.

Property Details

City: East Peoria

County: Tazewell

Subdivision: Walnut Hills

Schools: Woodrow Wilson, East Peoria Comm

Type: Residential

Style: Split Foyer

Exterior: Vinyl Siding

Fireplaces: 1

Garage: Yes

Cars: 2

New Construction: No

Bedrooms: 3

Bathrooms: 3

Partial Baths: 0

Square Ft.: 1923

Fin Basement Square Ft: 0

Tot Basement Square Ft: 0

Apx Lot Size:

Year Built: 2003

Mobile Home: No

Condo: No

Room Levels & Sizes

Bathrooms:
BsmtLowMainUppAddlTot
Full012003
Half000000
BsmtLowMainUppAddl
Master Bedroom16 x 13
Bedroom #212 x 11
Bedroom #311 x 11
     
Family Room27 x 13
Garage28 x 24
Kitchen19 x 12
Living Room19 x 16

Features

Exterior: Vinyl Siding

Roofing: Composition

Garage/Parking: Yes

Basement: None

Heating/Cooling: Gas, Forced Air, Water Heater - Gas, Central Air

Water/Sewer: Public Water, Public Sewer

Kitchen/Dining: Eat-In Kitchen, Pantry

Appliances: Dishwasher, Disposal, Microwave Oven, Range/Oven, Refrigerator, Water Softener - Owned

Interior Amenities: Cable TV Available, Ceilings/Cath or Vault, Garage Door Opener (s), Walk-In Closet, Whirlpool Tub, Formica Counter Top, Surround Sound Wiring

Exterior Amenities: Deck

Fireplace: Gas Logs, Living Room

Lot Description: Level, Rolling

Road/Access: Curbs & Gutters, Paved

Courtesy of Jim Maloof/REALTOR

PAAR IDXThe accuracy of all information, regardless of source, including but not limited to square footages and lot sizes, is deemed reliable but is not guaranteed and should be independently verified through personal inspection and/or with the appropriate professionals.

Shelly Rigelwood

Shelly Rigelwood

Morton Branch
405 N Morton Ave
Morton, IL 61550

Mobile: 309-208-2928
Office: 309-266-9200

srigelwood@maloofrealty.com
www.shellyrigelwood.com

Offered At $199,900
3 Bedrooms, 3.0 Baths

Click to View Map

{source}
<?php
 
// DO NOT EDIT THIS MODULE!!
$id = $app->input->getString('id');
 
$app = JFactory::getApplication('com_adcomls');
$user_id = JFactory::getUser()->id;
$params = $app->getParams();
$params_array = $params->toArray();
$db = JFactory::getDbo();
$option = array(); //prevent problems
$option['driver'] = 'mysql'; // Database driver name
$option['host'] = $params->get('dbhost'); // Database host name
$option['user'] = $params->get('dbuser'); // User for database authentication
$option['password'] = $params->get('dbpass'); // Password for database authentication
$option['database'] = $params->get('dbname'); // Database name
$option['prefix'] = ''; // Database prefix (may be empty)
$db = JDatabase::getInstance( $option );
 
$query = "SELECT r.mls, r.beds, r.baths, r.list_price, r.list_date, r.address, r.city, r.state, r.zip, r.acres, r.office, r.type, r.tour, r.office2, a.fname, a.lname, a.url, a.pid, a.email, a2.fname as fname2, a2.lname as lname2, a2.url as url2, a2.pid as pid2, a2.email as email2 FROM rets r LEFT JOIN rets_amen t ON t.mls = r.mls INNER JOIN agents a ON a.ID = r.agent LEFT JOIN agents a2 ON a2.ID = r.agent2 WHERE r.mls = '".$id."' LIMIT 1";
$db->setQuery($query);
$db->query();
$results = $db->loadObject();
 
// Check for a commercial listing
if($results->mls=='') {
$comm = true;
$query = "SELECT r.mls, r.sqft, r.cost_sqft, r.for_sale, r.for_lease, r.list_price, r.list_date, r.address, r.city, r.state, r.zip, r.office, r.type, r.tour, a.fname, a.lname, a.url, a.pid, a.email FROM rets_comm r INNER JOIN agents_comm a ON a.ID = r.agent WHERE r.mls = '".$id."' LIMIT 1";
$db->setQuery($query);
$db->query();
$results = $db->loadObject();
}
 
// Check for set agent
$db2 = JFactory::getDbo();
$id = JFactory::getUser()->id;
$type = '';
if($id!='0') {
$profile = JUserHelper::getProfile( $id );
$agent = $profile->extra['Agent'];
if($agent!='') { 
$query = "SELECT user_id FROM #__community_fields_values WHERE field_id = '16' AND value = '".$agent."' LIMIT 1";
$db2->setQuery($query);
$db2->query();
$agent2 = $db2->loadResult();
if($agent2!='') {
$aid = $agent2; 
$type = 'listingagent';
$query = "SELECT a.fname, a.lname, a.url, a.pid, a.email, a.office FROM agents a WHERE a.pid = 'P".$agent."' LIMIT 1";
$db->setQuery($query);
$db->query();
$results2 = $db->loadObject();
$results->fname = $results2->fname;
$results->lname = $results2->lname;
$results->url = $results2->url;
$results->pid = $results2->pid;
$results->email = $results2->email;
$results->office = $results2->office;
}
}
if($type=='') { $type = 'listing'; }
 
// Check the office
$db2 = JFactory::getDbo();
if($comm==true) {
$query = "SELECT * from #__adcomls_offices WHERE cid = '".$results->office."' LIMIT 1";
} else {
$query = "SELECT * from #__adcomls_offices WHERE oid = '".$results->office."' LIMIT 1";
if($results->office2!='') {
$query2 = "SELECT * from #__adcomls_offices WHERE oid = '".$results->office2."' LIMIT 1";
$db2->setQuery($query2);
$db2->query();
$office2 = $db2->loadObject();
}
}
$db2->setQuery($query);
$db2->query();
$office = $db2->loadObject();
 
// Get agent ID
$db2 = JFactory::getDbo();
if($comm==true) {
$query = "SELECT user_id FROM #__community_fields_values WHERE field_id = '57' AND value = '".$results->pid."' LIMIT 1";
} else {
$query = "SELECT user_id FROM #__community_fields_values WHERE field_id = '16' AND value = '".substr($results->pid,1)."' LIMIT 1";
if($results->office2!='') {
$query2 = "SELECT user_id FROM #__community_fields_values WHERE field_id = '16' AND value = '".substr($results->pid2,1)."' LIMIT 1";
$db2->setQuery($query2);
$db2->query();
$aid2 = $db2->loadResult();
}
}
$db2->setQuery($query);
$db2->query();
$aid = $db2->loadResult();
 
// Check for saved listings
$query = "SELECT id from #__adcomls_saves WHERE param = '".$results->mls."' AND created_by = '".$id."' LIMIT 1";
$db2->setQuery($query);
$db2->query();
$results->save_id = $db2->loadResult();
 
if($office->oid==''&&$type=='listingagent') {
require_once( JPATH_ROOT . DS . 'components' . DS . 'com_community' . DS . 'libraries' . DS . 'core.php');
$cuser = CFactory::getUser($aid);
if($cuser->getInfo('hide')!='Yes'&&$cuser->getInfo('email')!='') {
$email = $cuser->getInfo('email'); 
}
}
else if($office->oid!='') {
 
require_once( JPATH_ROOT . DS . 'components' . DS . 'com_community' . DS . 'libraries' . DS . 'core.php');
$cuser = CFactory::getUser($aid);
 
if($cuser->getInfo('hide')!='Yes') {
 
$name = $cuser->getInfo('name');
$results->pid = 'P'.$cuser->getInfo('pid');
if(empty($name)&&!empty($results->fname)) { $name = $results->fname.' '.$results->lname; }
if($cuser->getInfo('email')!='') { $email = $cuser->getInfo('email'); }
else { $email = $results->email; }
if($cuser->getInfo('url')!=''||$results->url!='') {
if($cuser->getInfo('url')!='') { 
$url2 = $cuser->getInfo('url'); 
$url_array = explode("//",$url2);
$url_short = $url_array[1];
}
else { 
$url2 = "http://".$results->url; 
$url_short = $results->url;
}
 
}
 
if($office2->oid!='') {
$cuser2 = CFactory::getUser($aid2);
 
if($cuser2->getInfo('hide')!='Yes') {
 
$name2 = $cuser2->getInfo('name');
//$results->pid2 = 'P'.$cuser2->getInfo('pid');
if(empty($name2)&&!empty($results->fname2)) { $name2 = $results->fname2.' '.$results->lname2; }
if($cuser2->getInfo('email')!='') { $email2 = $cuser2->getInfo('email'); }
else { $email2 = $results->email2; }
if($cuser2->getInfo('url')!=''||$results->url2!='') {
if($cuser2->getInfo('url')!='') { 
$url3 = $cuser2->getInfo('url'); 
$url3_array = explode("//",$url3);
$url3_short = $url3_array[1];
}
else { 
$url3 = "http://".$results->url2; 
$url3_short = $results->url2;
}
 
}
}
 
}
 
if(strlen($results->zip)>5) { $results->zip = substr($results->zip,0,-1); }
$results->add_map = $results->address.'+'.$results->city.'+'.$results->state.'+'.$results->zip;
$emailto = str_replace("@","+",$email);
$emailto2 = str_replace("@","+",$email2);
$uri = JFactory::getURI();
$absolute_url = $uri->toString();
?>
<div id="box27">
<?php // Check if it's a Maloof listing
if($office->oid!=''&&$cuser->getInfo('hide')!='Yes') {
 ?>
<a href="/agents/agent/<?php echo substr($results->pid, 1); ?>"><img src="/images/agents/<?php echo $results->pid; ?>.jpg" alt="<?php echo $name; ?>" class="image" id="image4" /></a>
<p id="text50"><a href="/agents/agent/<?php echo substr($results->pid, 1); ?>" id="textspan4"><?php echo $name; ?></a><br /><br />
<?php echo $office->name; ?> Branch<br>
<?php echo $office->address; ?><br>
<?php echo $office->city.', '.$office->st.' '.$office->zip; ?><br /><br />
Mobile: <?php echo $cuser->getInfo('cell'); ?><br>
Office: <?php echo $cuser->getInfo('work'); ?></p>
<p class="text50"><a href="/email?mls=<?php echo $results->mls; ?>&mail=<?php echo $emailto; ?>&type=listingagent&tmpl=component" target="_blank" class="jcepopup noicon" data-mediabox="width[400];height[450];title[Email Agent]"><?php echo $email; ?></a><br />
<?php if($url2!='') { ?>
<a href="/<?php echo $url2; ?>" target="_blank"><?php echo $url_short; ?></a>
<?php } } ?></p>
 
<?php // Check for a co-listing agent
if($office2->oid!=''&&$cuser2->getInfo('hide')!='Yes'&&$agent!='') {
 ?>
<a href="/agents/agent/<?php echo substr($results->pid2, 1); ?>"><img src="/images/agents/<?php echo $results->pid2; ?>.jpg" alt="<?php echo $name2; ?>" class="image" id="image4" /></a>
<p id="text50"><a href="/agents/agent/<?php echo substr($results->pid2, 1); ?>" id="textspan4"><?php echo $name2; ?></a><br /><br />
<?php echo $office2->name; ?> Branch<br>
<?php echo $office2->address; ?><br>
<?php echo $office2->city.', '.$office2->st.' '.$office2->zip; ?><br /><br />
Mobile: <?php echo $cuser2->getInfo('cell'); ?><br>
Office: <?php echo $cuser2->getInfo('work'); ?></p>
<p class="text50"><a href="/email?mls=<?php echo $results->mls2; ?>&mail=<?php echo $emailto2; ?>&type=listingagent&tmpl=component" target="_blank" class="jcepopup noicon" data-mediabox="width[400];height[450];title[Email Agent]"><?php echo $email2; ?></a><br />
<?php if($url3!='') { ?>
<a href="/<?php echo $url3; ?>" target="_blank"><?php echo $url3_short; ?></a>
<?php } } ?></p>
 
<div id="Box" class="clearfix">
<p id="text51">
<span id="textspan5">Offered At $<?php if($results->list_price>0) { echo number_format($results->list_price); } else { echo number_format($results->cost_sqft).' / Sq. Ft.'; } ?></span><br><?php if(!$comm) { echo $results->beds; ?> Bedrooms, <?php echo $results->baths; ?> Baths <?php } else { echo $results->sqft; ?> Square Feet, <?php if($results->for_sale=='Yes'){ echo 'For Sale'; } if($results->for_lease=='Yes'){ echo 'For Lease'; } } ?></p>
<p class="keyicon">
<?php if($results->list_price>=375000&&$results->type==1) { ?><img src="/templates/jsn_blank_pro/images/icon_diamond.png" alt='Luxury Home Portfolio' /> Luxury Home Portfolio<br /><?php } ?>
<!--<img src="/templates/jsn_blank_pro/images/icon_dollar.png" alt='Price Change' /> Price Change<br />-->
<?php if($results->list_date>=date("Y-m-d",strtotime("-10 days"))) { ?><img src="/templates/jsn_blank_pro/images/icon_house.png" alt='Just Listed' />Just Listed<br /><?php } ?>
<?php if($results->tour!='') { ?><a href="/<?php echo $results->tour; ?>" target="_blank" title="Virtual Tour"><img src="/templates/jsn_blank_pro/images/icon_photo.png" alt='Virtual Tour' /> Virtual Tour</a><br /><?php } ?>
</p>
<p id="text52">
<a href="https://www.google.com/maps/place/<?php echo $results->add_map; ?>/data=!4m2!3m1!" target="_blank">Click to View Map</a>
</p>
</div>
<div id="mcepastebin" data-mce-bogus="all" style="position: absolute; top: 10px; width: 10

equal housingkomenBBBleading real estate companies of the worldworldwide ercwqc  

Jim Maloof/Realtor®, Peoria IL | Agent Mail | Privacy Policy

Go to top // Reach Local