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

113 Fay Street, Deer Creek, IL 61733 - MLS# 1188008 - $175,000
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008
MLS# 1188008

DON'T PASS UP THIS BEAUTIFUL RANCH HOME WITH 4 BEDROOMS & 3 FULL BATHROOMS, MANY UPDATES INCLUDING LAMINATE FLOOR THRU OUT MAIN FLOOR AND ALL FRESH NEW PAINT, GORGEOUS BACK SPLASH IN KITCHEN, NICE MASTER WITH MASTER BATH & HUGE WALK IN CLOSET.

THE BASEMENT HAS ALL NEW PORCELAIN GREY WOOD LOOK PLANKS THRU OUT & LOOKS AMAZING! THE GARAGE IS INSULATED, HEATED AND HAS CABLE OUTLET. . THE BACK YARD IS GREAT AND HAS A PRIVACY FENCE AND A NICE DECK OFF OF THE KITCHEN. NEW ROOF IN 2017

Property Details

City: Deer Creek

County: Tazewell

Subdivision: Westview Subd

Schools: Deer Creek Mackinaw

Type: Residential

Style: Ranch

Exterior: Vinyl Siding

Fireplaces: 0

Garage: Yes

Cars: 2

New Construction: No

Bedrooms: 4

Bathrooms: 3

Partial Baths: 0

Square Ft.: 1496

Fin Basement Square Ft: 1496

Tot Basement Square Ft: 1496

Apx Lot Size:

Year Built: 1999

Mobile Home: No

Condo: No

Room Levels & Sizes

Bathrooms:
BsmtLowMainUppAddlTot
Full102003
Half000000
BsmtLowMainUppAddl
Master Bedroom15 x 13
Bedroom #210 x 9
Bedroom #313 x 11
Bedroom #414 x 11
     
Den/Office16 x 14
Family Room35 x 25
Garage24 x 24
Informal Dining Room13 x 10
Kitchen13 x 10
Laundry Room13 x 7
Living Room19 x 14
STORAGE13 x 11

Features

Exterior: Vinyl Siding

Roofing: Composition

Garage/Parking: Yes

Basement: Egress Window, Finished, Full

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

Water/Sewer: Public Water, Public Sewer

Kitchen/Dining: Dining Room/Informal, Island

Appliances: Dishwasher, Hood/Fan, Range/Oven, Refrigerator, Water Softener - Owned, Water Filtration System

Interior Amenities: Garage Door Opener (s), Utility Sink, Formica Counter Top

Exterior Amenities: Deck, Fenced Yard, Porch, Shed

Lot Description: Level

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.

Shannon Gaunt

Shannon Gaunt

Morton Branch
405 N Morton Ave
Morton, IL 61550

Mobile: 309-256-5265
Office: 309-266-9200

sgaunt@maloofrealty.com
www.shannongaunt.com

Offered At $175,000
4 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