East Grand Rapids Homes For Sale 200000-250000

East Grand Rapids Homes For Sale 200000-250000. East Grand Rapids Homes For Sale, East Grand Rapids Real Estate For Sale, East Grand Rapids Realtor, East Grand Rapids Property For Sale.

Sort By: MLS# Price City Subdivision Beds Baths   Limit: 10 | 20 | 30 Per Page

showing 1-10 of 17

1248  BRETON RD SE East Grand Rapids, MI 49506
$249,900.00 - East Grand Rapids, MI
MLS#
787313
Class:
Residential
Status:
active
Beds:
4
Baths:
4 Full / N/A
Area:
East Grand Rapids

1706  EXETER RD SE East Grand Rapids, MI 49506
$240,000.00 - East Grand Rapids, MI
MLS#
791467
Class:
Residential
Status:
active
Beds:
3
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

1536  EASTLAWN RD SE East Grand Rapids, MI 49506
$239,900.00 - East Grand Rapids, MI
MLS#
792640
Class:
Residential
Status:
active
Beds:
4
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

564  LAUREL AVE SE East Grand Rapids, MI 49506
$237,500.00 - East Grand Rapids, MI
MLS#
794752
Class:
Residential
Status:
active
Beds:
3
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

3000  LAKE DR SE East Grand Rapids, MI 49506
$232,500.00 - East Grand Rapids, MI
MLS#
794735
Class:
Residential
Status:
active
Beds:
4
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

1746  DANBY LN SE East Grand Rapids, MI 49506
$230,000.00 - East Grand Rapids, MI
MLS#
783774
Class:
Residential
Status:
active
Beds:
4
Baths:
3 Full / 1 Half
Area:
East Grand Rapids

1552  WOODLAWN AVE SE East Grand Rapids, MI 49506
$229,900.00 - East Grand Rapids, MI
MLS#
790389
Class:
Residential
Status:
active
Beds:
3
Baths:
2 Full / N/A
Area:
East Grand Rapids

2953  BEECHWOOD DR SE East Grand Rapids, MI 49506
$224,900.00 - East Grand Rapids, MI
MLS#
794745
Class:
Residential
Status:
active
Beds:
4
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

1564  RIDGEWOOD AVE SE East Grand Rapids, MI 49506
$222,200.00 - East Grand Rapids, MI
MLS#
757245
Class:
Residential
Status:
active
Beds:
4
Baths:
2 Full / 1 Half
Area:
East Grand Rapids

2354  LAKE DR SE East Grand Rapids, MI 49506
$219,500.00 - East Grand Rapids, MI
MLS#
788416
Class:
Residential
Status:
active
Beds:
2
Baths:
1 Full / 1 Half
Area:
East Grand Rapids

Broker Reciprocity Grand Rapids Association of REALTORS®, MLS Exchange, Inc
Information deemed reliable, but not guaranteed.
The properties on this website are generated from the Broker Reciprocity Program of the MLS Exchange, Inc.
Copyright © 2009 MLS Exchange, Inc. All rights reserved. Information was last updated: 2010-09-10

showing 1-10 of 17

Quick Search











(default) 22 queries took 109 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`32323
2DESCRIBE `page_feeds`441
3DESCRIBE `page_listings`551
4DESCRIBE `onlines`551
5DESCRIBE `users`34342
6DESCRIBE `user_groups`882
7DESCRIBE `user_permissions`441
8DESCRIBE `user_groups_user_permissions`221
9DESCRIBE `tp_export`5538
10DESCRIBE `favorites`17172
11DESCRIBE `favorite_notes`6613
12DESCRIBE `favorite_xrefs`887
13DESCRIBE `saved_searches`883
14DESCRIBE `redirects`992
15SELECT `Redirect`.`id`, `Redirect`.`site_id`, `Redirect`.`redirect_code`, `Redirect`.`url_from`, `Redirect`.`url_to`, `Redirect`.`wildcard`, `Redirect`.`created`, `Redirect`.`modified`, `Redirect`.`modified_by` FROM `redirects` AS `Redirect` WHERE `Redirect`.`site_id` = 94 AND `Redirect`.`url_from` IN ('http://www.griffinproperties.net/east-grand-rapids-real-estate/east-grand-rapids-homes-for-sale-200000-250000.html', 'www.griffinproperties.net/east-grand-rapids-real-estate/east-grand-rapids-homes-for-sale-200000-250000.html', 'east-grand-rapids-real-estate/east-grand-rapids-homes-for-sale-200000-250000.html') LIMIT 1001
16SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`title`, `Page`.`body`, `Page`.`compiled_body`, `Page`.`slug`, `Page`.`fullslug`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`redirect_code`, `Page`.`redirect_url`, `Page`.`layout`, `Page`.`active`, `Page`.`visible`, `Page`.`actas_folder`, `Page`.`sitemap_show`, `Page`.`sitemap_priority`, `Page`.`sitemap_changefreq`, `Page`.`enable_listings`, `Page`.`is_home`, `Page`.`is_protected`, `Page`.`display_title`, `Page`.`position`, `Page`.`require_login`, `Page`.`require_login_msg`, `Page`.`tweetmeme_enable`, `Page`.`tweetmeme_user`, `Page`.`tweetmeme_css`, `Page`.`created`, `Page`.`modified`, `Page`.`modified_by`, `ParentPg`.`id`, `ParentPg`.`site_id`, `ParentPg`.`parent_id`, `ParentPg`.`title`, `ParentPg`.`body`, `ParentPg`.`compiled_body`, `ParentPg`.`slug`, `ParentPg`.`fullslug`, `ParentPg`.`meta_description`, `ParentPg`.`meta_keywords`, `ParentPg`.`redirect_code`, `ParentPg`.`redirect_url`, `ParentPg`.`layout`, `ParentPg`.`active`, `ParentPg`.`visible`, `ParentPg`.`actas_folder`, `ParentPg`.`sitemap_show`, `ParentPg`.`sitemap_priority`, `ParentPg`.`sitemap_changefreq`, `ParentPg`.`enable_listings`, `ParentPg`.`is_home`, `ParentPg`.`is_protected`, `ParentPg`.`display_title`, `ParentPg`.`position`, `ParentPg`.`require_login`, `ParentPg`.`require_login_msg`, `ParentPg`.`tweetmeme_enable`, `ParentPg`.`tweetmeme_user`, `ParentPg`.`tweetmeme_css`, `ParentPg`.`created`, `ParentPg`.`modified`, `ParentPg`.`modified_by`, `PageFeed`.`id`, `PageFeed`.`site_id`, `PageFeed`.`page_id`, `PageFeed`.`feed_urls`, `PageListing`.`id`, `PageListing`.`site_id`, `PageListing`.`page_id`, `PageListing`.`controller`, `PageListing`.`listing_params` FROM `pages` AS `Page` LEFT JOIN `pages` AS `ParentPg` ON (`Page`.`parent_id` = `ParentPg`.`id`) LEFT JOIN `page_feeds` AS `PageFeed` ON (`PageFeed`.`page_id` = `Page`.`id`) LEFT JOIN `page_listings` AS `PageListing` ON (`PageListing`.`page_id` = `Page`.`id`) WHERE `Page`.`site_id` = 94 AND `Page`.`fullslug` = 'east-grand-rapids-real-estate/east-grand-rapids-homes-for-sale-200000-250000.html' LIMIT 11116
17SELECT `Online`.`ip` FROM `onlines` AS `Online` LEFT JOIN `users` AS `User` ON (`Online`.`user_id` = `User`.`id`) WHERE `Online`.`modified` < '2010-09-10 20:53:50' 331
18DELETE `Online` FROM `onlines` AS `Online` LEFT JOIN `users` AS `User` ON (`Online`.`user_id` = `User`.`id`) WHERE `Online`.`ip` IN (1076465993, -772196933, 1123633015)31
19SELECT COUNT(*) AS `count` FROM `onlines` AS `Online` WHERE `Online`.`ip` = 644595552 111
20UPDATE `onlines` SET `ip` = 644595552, `site_id` = 94, `user_id` = NULL, `url` = '/east-grand-rapids-real-estate/east-grand-rapids-homes-for-sale-200000-250000.html', `modified` = '2010-09-10 21:03:50' WHERE `onlines`.`ip` = 64459555218
21DESCRIBE `snippets`992
22DESCRIBE `custom_variables`11112
(master) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `country`441
2DESCRIBE `country_province`661
(board_db) 9 queries took 561 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`95955
2DESCRIBE `offices`777713
3DESCRIBE `members`69699
4DESCRIBE `aliases`662
5SELECT `ListingCity`.`city_name` FROM `aliases` AS `ListingCity` WHERE `ListingCity`.`city_id` = (65) 110
6DESCRIBE `classes`662
7SELECT `ListingClass`.`id`, `ListingClass`.`class_name`, `ListingClass`.`search_id`, `ListingClass`.`search_name` FROM `classes` AS `ListingClass` WHERE `ListingClass`.`parent_id` = 0 AND `ListingClass`.`search_id` IN (6, 4, 5, 8, 2, 1, 3) 771
8SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` LEFT JOIN `offices` AS `MiGrarOffice` ON (`Listing`.`office_id` = `MiGrarOffice`.`office_id`) LEFT JOIN `members` AS `MiGrarMember` ON (`Listing`.`agent_id` = `MiGrarMember`.`agent_id`) WHERE `Listing`.`asking_price` BETWEEN 200000 AND 250000 AND ((`Listing`.`beds` >= '0') OR (`Listing`.`beds` = '') OR (`Listing`.`beds` IS NULL) OR (`Listing`.`beds` = 'Efficiency')) AND ((`Listing`.`fullbaths` >= '0') OR (`Listing`.`fullbaths` = '') OR (`Listing`.`fullbaths` IS NULL)) AND `Listing`.`city` = ('East Grand Rapids') AND `Listing`.`class` IN ('residential', 'multifamily', 'residential land', 'commercial land', 'commercial lease', 'business opportunity', 'commercial sales') AND `Listing`.`status_id` IN ('Active', 'Price Change', 'pending') 11227
9SELECT `Listing`.*, `MiGrarOffice`.`officename`, `MiGrarOffice`.`office_id`, CONCAT_WS(" ", MiGrarMember.firstname, MiGrarMember.lastname) as full_name FROM `listings` AS `Listing` LEFT JOIN `offices` AS `MiGrarOffice` ON (`Listing`.`office_id` = `MiGrarOffice`.`office_id`) LEFT JOIN `members` AS `MiGrarMember` ON (`Listing`.`agent_id` = `MiGrarMember`.`agent_id`) WHERE `Listing`.`asking_price` BETWEEN 200000 AND 250000 AND ((`Listing`.`beds` >= '0') OR (`Listing`.`beds` = '') OR (`Listing`.`beds` IS NULL) OR (`Listing`.`beds` = 'Efficiency')) AND ((`Listing`.`fullbaths` >= '0') OR (`Listing`.`fullbaths` = '') OR (`Listing`.`fullbaths` IS NULL)) AND `Listing`.`city` = ('East Grand Rapids') AND `Listing`.`class` IN ('residential', 'multifamily', 'residential land', 'commercial land', 'commercial lease', 'business opportunity', 'commercial sales') AND `Listing`.`status_id` IN ('Active', 'Price Change', 'pending') ORDER BY `Listing`.`asking_price` DESC LIMIT 101010302