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

< Prev
1
2
Next >
Last →

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

View Listing

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

View Listing

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

View Listing

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

View Listing

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

View Listing

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

Virtual Tour

View Listing

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

View Listing

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

View Listing

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

View Listing

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

View Listing

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

< Prev
1
2
Next >
Last →

Quick Search

Property Class:

City:

Low Price:

High Price:

Beds:

Baths:

Featured Listings

$7,500.00

MLS# 785385
Newaygo MI
Beds: N/A
Baths: N/A

$119,900.00

MLS# 792098
Newaygo MI
Beds: 2
Baths: 1 Full

$369,000.00

MLS# 791300
Grandville MI
Beds: 4
Baths: 3 Full

(default) 22 queries took 109 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	32	32	3
2	DESCRIBE `page_feeds`	4	4	1
3	DESCRIBE `page_listings`	5	5	1
4	DESCRIBE `onlines`	5	5	1
5	DESCRIBE `users`	34	34	2
6	DESCRIBE `user_groups`	8	8	2
7	DESCRIBE `user_permissions`	4	4	1
8	DESCRIBE `user_groups_user_permissions`	2	2	1
9	DESCRIBE `tp_export`	5	5	38
10	DESCRIBE `favorites`	17	17	2
11	DESCRIBE `favorite_notes`	6	6	13
12	DESCRIBE `favorite_xrefs`	8	8	7
13	DESCRIBE `saved_searches`	8	8	3
14	DESCRIBE `redirects`	9	9	2
15	SELECT `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 1	0	0	1
16	SELECT `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 1	1	1	16
17	SELECT `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'	3	3	1
18	DELETE `Online` FROM `onlines` AS `Online` LEFT JOIN `users` AS `User` ON (`Online`.`user_id` = `User`.`id`) WHERE `Online`.`ip` IN (1076465993, -772196933, 1123633015)	3		1
19	SELECT COUNT(*) AS `count` FROM `onlines` AS `Online` WHERE `Online`.`ip` = 644595552	1	1	1
20	UPDATE `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` = 644595552	1		8
21	DESCRIBE `snippets`	9	9	2
22	DESCRIBE `custom_variables`	11	11	2

(default) 22 queries took 109 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `page_feeds`

DESCRIBE `page_listings`

DESCRIBE `onlines`

DESCRIBE `users`

DESCRIBE `user_groups`

DESCRIBE `user_permissions`

DESCRIBE `user_groups_user_permissions`

DESCRIBE `tp_export`

DESCRIBE `favorites`

DESCRIBE `favorite_notes`

DESCRIBE `favorite_xrefs`

DESCRIBE `saved_searches`

DESCRIBE `redirects`

SELECT `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 1

SELECT `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 1

SELECT `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'

DELETE `Online` FROM `onlines` AS `Online` LEFT JOIN `users` AS `User` ON (`Online`.`user_id` = `User`.`id`) WHERE `Online`.`ip` IN (1076465993, -772196933, 1123633015)

SELECT COUNT(*) AS `count` FROM `onlines` AS `Online` WHERE `Online`.`ip` = 644595552

UPDATE `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` = 644595552

DESCRIBE `snippets`

DESCRIBE `custom_variables`

(master) 2 queries took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `country`		4	4	1
2	DESCRIBE `country_province`		6	6	1

(master) 2 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `country`

DESCRIBE `country_province`

(board_db) 9 queries took 561 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `listings`	95	95	5
2	DESCRIBE `offices`	77	77	13
3	DESCRIBE `members`	69	69	9
4	DESCRIBE `aliases`	6	6	2
5	SELECT `ListingCity`.`city_name` FROM `aliases` AS `ListingCity` WHERE `ListingCity`.`city_id` = (65)	1	1	0
6	DESCRIBE `classes`	6	6	2
7	SELECT `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)	7	7	1
8	SELECT 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')	1	1	227
9	SELECT `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 10	10	10	302

(board_db) 9 queries took 561 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `listings`

DESCRIBE `offices`

DESCRIBE `members`

DESCRIBE `aliases`

SELECT `ListingCity`.`city_name` FROM `aliases` AS `ListingCity` WHERE `ListingCity`.`city_id` = (65)

DESCRIBE `classes`

SELECT `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)

SELECT 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')

227

SELECT `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 10

302

East Grand Rapids Homes For Sale 200000-250000

Quick Search

Featured Listings

Pages

Contact

Connect

Login