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

5222 N Merrimac Avenue, Peoria, IL 61614 - MLS# 1186768 - $181,000
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768
MLS# 1186768

This 4 bed, 2.5 bth beauty has/over 2,800 finished sf!

Eat in kitchen w/beautiful HW flr has pantry, plenty of cabinets & lots of counter space! Lg family rm w/hw flr is where you'll cozy up to the beautiful brick fireplace or walk outside to huge fully fenced backyard w/large patio. Master bedroom w/gorgeous HW flr, has walk in closet & full bath. Large Rec Room for entertaining. Interior painted '17, new roof '17, water heater '16, some new windows in '15. Dewatering syst. Home Warranty! *seller to provide a buyer with an incentive up to 3% of the sale price for buyer concessions at closing.

Property Details

City: Peoria

County: Peoria

Subdivision: Glen Hills

Schools: Northmoor, Rolling Acres, Richwoods

Type: Residential

Style: 2 Story

Exterior: Brick, Vinyl Siding, Wood Siding

Fireplaces: 1

Garage: Yes

Cars: 2

New Construction: No

Bedrooms: 4

Bathrooms: 2

Partial Baths: 1

Square Ft.: 2384

Fin Basement Square Ft: 420

Tot Basement Square Ft: 945

Apx Lot Size: 0.36

Year Built: 1966

Mobile Home: No

Condo: No

Room Levels & Sizes

Bathrooms:
BsmtLowMainUppAddlTot
Full000202
Half001001
BsmtLowMainUppAddl
Master Bedroom16 x 12
Bedroom #216 x 11
Bedroom #312 x 11
Bedroom #412 x 10
     
Family Room22 x 14
Formal Dining Room13 x 11
Garage27 x 22
Kitchen20 x 11
Laundry Room33 x 13
Living Room21 x 13
Rec Room33 x 11

Features

Exterior: Brick, Vinyl Siding, Wood Siding

Roofing: Composition

Garage/Parking: Yes

Basement: Finished, Full

Heating/Cooling: Gas, Forced Air, Central Air

Water/Sewer: Public Water, Public Sewer

Kitchen/Dining: Dining Room/Formal, Dining Room/Informal, Eat-In Kitchen, Pantry

Appliances: Dishwasher, Disposal, Hood/Fan, Microwave Oven, Range/Oven, Refrigerator, Washer, Dryer

Interior Amenities: Cable TV Available, Garage Door Opener (s), Utility Sink, Walk-In Closet, Formica Counter Top

Exterior Amenities: Fenced Yard, Patio, Porch

Additional Amenities: Home Warranty

Fireplace: Wood Burning, Family Room

Lot Description: Level

Road/Access: Curbs & Gutters

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.

Dorothy Greene

Dorothy Greene

Peoria Branch
803 W Pioneer Parkway
Peoria, IL 61615

Mobile: 309-251-4358
Office: 309-692-3900

DGreene@Maloofrealty.com
www.TeamGreene309.realtor

Offered At $181,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