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

3623 N Sterling Avenue, A-12, Peoria, IL 61604 - MLS# 1180047 - $29,500
MLS# 1180047
MLS# 1180047
MLS# 1180047
MLS# 1180047
MLS# 1180047

THIRD FLOOR CONDO.

GREAT LOCATION. 2 BEDROOMS EAT-IN KITCHEN. DESIGNATED PARKING BAY IN COVERED CARPORT

Property Details

City: Peoria

County: Peoria

Subdivision: Sterling Arms Condos

Schools: Peoria Central

Type: Condo/Townhome

Style: Other Style

Exterior: Brick

Fireplaces: 0

Garage: No

New Construction: No

Bedrooms: 2

Bathrooms: 1

Partial Baths: 0

Square Ft.: 780

Fin Basement Square Ft: 0

Tot Basement Square Ft: 0

Apx Lot Size:

Year Built: 1970

Mobile Home: No

Condo: Yes

Room Levels & Sizes

Bathrooms:
BsmtLowMainUppAddlTot
Full001001
Half000000
BsmtLowMainUppAddl
Master Bedroom11 x 11
Bedroom #211 x 11
     
Kitchen10 x 10
Living Room16 x 12

Features

Exterior: Brick

Roofing: Tar & Gravel

Garage/Parking: No

Basement: None

Heating/Cooling: Gas, Forced Air, Central Air

Water/Sewer: Public Water, Public Sewer

Kitchen/Dining: Eat-In Kitchen

Appliances: Hood/Fan, Range/Oven, Refrigerator

Additional Amenities: Pool/In Ground

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.

Barb Fuller Heer

Barb Fuller Heer

Morton Branch
405 N Morton Ave
Morton, IL 61550

Mobile: 309-264-6416
Office: 309-266-9200

BarbHeer.realtor@gmail.com
www.barbheer.com

Offered At $29,500
2 Bedrooms, 1.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