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

804 E Tripp , Peoria, IL 61603 - MLS# 1188141 - $58,900
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141
MLS# 1188141

Looking for a Handymans Dream?

Welcome to 804 E. Tripp!! Investors Welcome!! Remodel was started, but not completed. This 3 Bedroom, 2 bath home has new carpet, some fresh paint and a newer water heater. Come take a look, this home is waiting to be finished! Garage door to be replaced. Dishwasher does not work. Sold As is.

Property Details

City: Peoria

County: Peoria

Subdivision: Highland

Schools: Peoria Central

Type: Residential

Style: 1.5 Story

Exterior: Vinyl Siding

Fireplaces: 0

Garage: Yes

Cars: 1

New Construction: No

Bedrooms: 3

Bathrooms: 2

Partial Baths: 0

Square Ft.: 1325

Fin Basement Square Ft: 0

Tot Basement Square Ft: 0

Apx Lot Size:

Year Built: 1950

Mobile Home: No

Condo: No

Room Levels & Sizes

Bathrooms:
BsmtLowMainUppAddlTot
Full001102
Half000000
BsmtLowMainUppAddl
Master Bedroom12 x 11
Bedroom #210 x 11
Bedroom #312 x 11
     
Family Room13 x 13
Garage19 x 16
Kitchen11 x 12
Living Room23 x 15

Features

Exterior: Vinyl Siding

Roofing: Composition

Garage/Parking: Yes

Basement: Crawl Space

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

Water/Sewer: Public Water, Public Sewer

Kitchen/Dining: Eat-In Kitchen

Appliances: Dishwasher

Interior Amenities: Formica Counter Top

Exterior Amenities: Fenced Yard, Patio, Porch

Lot Description: Level

Road/Access: 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

Lee Ann Eades

Lee Ann Eades

Morton Branch
405 N Morton Ave
Morton, IL 61550

Mobile: 309-645-1673
Office: 309-266-9200

leades@maloofrealty.com

Offered At $58,900
3 Bedrooms, 2.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