SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 1 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 1 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 2 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 2 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 3 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 3 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 4 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 4 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 5 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 5 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 6 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 6 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 7 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 7 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 8 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 8 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 9 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 9 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 10 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.bed_total BETWEEN 1 AND 10 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 10000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 10000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 100000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 100000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 200000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 200000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 300000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 300000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 400000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 400000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 500000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 500000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 600000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 600000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 700000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 700000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 800000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 800000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 900000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 900000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 1000000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current BETWEEN 1 AND 1000000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 10000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 10000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 100000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 100000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 200000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 200000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 300000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 300000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 400000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 400000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 500000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 500000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 600000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 600000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 700000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 700000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 800000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 800000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 900000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 900000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes'SELECT COUNT(*) AS cnt FROM vwr175474_listing_master as LM WHERE 1 AND LM.is_display_on_web = 'Yes' AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 1000000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' UNION ALL SELECT COUNT(*) AS cnt FROM vwr175474_listing_master_inactive as LM WHERE 1 AND LM.is_mark_for_deletion = 'N' AND LM.is_display_listing = 'Y' AND LM.city IN('Marcus') AND LM.state IN('IA') AND LM.category IN('Sale') AND LM.list_price_current >= 1000000 AND (status IN('Active') OR status IN('active-contingent') OR status IN('new')) AND LM.listing_type = 'MLS' AND LM.is_display_on_web = 'Yes' Marcus, IA 1-5 Bedrooms Real Estate, Marcus, IA 1-5 Bedrooms for Sale | RE/MAX Experience

Loading Search Results ...

Draw a shape around the region(s) you would like to live in

Marcus, IA 1-5 Bedrooms Real Estate

Search has been saved.
View Details 306 Walnut St. N, Marcus, IA 51035

$164,000

Status: Active
306 Walnut St. N, Marcus, IA 51035

  825696

 4

 1

  1,645


Listed by : FARMERS STATE BANK, LAURA LETSCHE (712.376.4318)
Price Decreased

Showing listings 1 to 1 of 1

Popular City Listings

Popular Areas/Communities

Contact Us

RE/MAX Experience
 712 4th St
 Sioux City, IA 51101
Email: info@sellsiouxcity.com
Licensed In Iowa, South Dakota, and Nebraska. Each Office Independently Owned and Operated.
Find Marcus, IA 1-5 Bedrooms homes for Sale and other Marcus 1-5 Bedrooms real estate on RE/MAX Experience, the premier real estate search website provided by RE/MAX Experience. Search Marcus 1-5 Bedrooms houses, Golf Course, townhomes and single-family homes by price, location, and amenities such as Condos and off-lake. Our MLS provides ALL 1-5 Bedrooms real estate listings and also provides the extensive property details such as home values, room sizes, lake access, as well as local school and neighborhood info so you can be sure that you have nearly all the information you would every want right away. Search RE/MAX Experience today! Want a closer look at more Marcus 1-5 Bedrooms Residential properties available? Also search our listings for Marcus 1-5 Bedrooms Open Houses, New Marcus 1-5 Bedrooms Listings and Marcus 1-5 Bedrooms Homes with Price changes, price increase, and price reductions that occur many times throughout the day now.

When buying Marcus 1-5 Bedrooms Homes for Sale, it's all about 'location, location, location!' With RE/MAX Experience, you can find Marcus 1-5 Bedrooms homes for Sale quickly and easily. How do you know a home in the community of Marcus is right for you? Sure a home in the right neighborhood is great, but what if it is facing the wrong way on the lake, or it is out of your price range, or you aren't going to the school you prefer? RE/MAX Experience can help you find the RIGHT home for Sale in RE/MAX Experience, as well as homes with space, features, and location you need. This is why you should continue to use RE/MAX Experience to find that Marcus 1-5 Bedrooms real estate you will fall in love with. RE/MAX Experience can also help you find that investment property in Marcus 1-5 Bedrooms as well. Make your search simple by selecting Marcus 1-5 Bedrooms that comforts you.

The detailed listings for Condos and single family homes in Marcus offered by RE/MAX Experience can help you narrow down your search according to property price, room dimensions, bedrooms, bathrooms, Condos, off lake, lake access, etc. Once you've got a search created, you can expand or narrow your search, save favorites, look at photos/pictures, and you can also stay in constant contact with the most professional real estate in the business at RE/MAX Experience. Use RE/MAX Experience custom search app by downloading from google play and the apple store. Here you can view your transactions with RE/MAX Experience and RE/MAX Experience transaction management system.

Get even more of information with just a click. Learn about the Marcus community and neighborhood and check out the interactive maps, statistics, and simple graphs that are easy to understand when searching for Marcus 1-5 Bedrooms homes for Sale. You'll often find school information, real estate market facts and much more with minimal effort.

Keep your real estate search simple. Use RE/MAX Experience.

Browse Marcus, IA by Property Type

Browse Marcus, IA by Beds

Browse Marcus, IA by Price

© 2024 Northwest Iowa Multiple Listing Service. Based on information from the Northwest Iowa MLS. The advertisers and publishers are not responsible or liable for misinformation, misprints, or other errors. All information provided is deemed reliable but is not guaranteed and should be independently verified. Prices subject to change without notice. Properties subject to prior sale or rental.

Real Estate IDX/RETS Website by Lead City
Agents login here