Error
  • Incorrect key file for table '/tmp/mysqltmp/#sql_22a9_4.MYI'; try to repair it SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM w3xvp_content AS a LEFT JOIN w3xvp_categories AS c ON c.id = a.catid LEFT JOIN w3xvp_users AS ua ON ua.id = a.created_by LEFT JOIN w3xvp_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM w3xvp_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN w3xvp_categories as parent ON parent.id = c.parent_id LEFT JOIN w3xvp_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM w3xvp_categories AS cat JOIN w3xvp_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN w3xvp_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-18 18:10:42') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-18 18:10:42') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END DESC , a.created DESC LIMIT 0, 3 Incorrect key file for table '/tmp/mysqltmp/#sql_22a9_4.MYI'; try to repair it SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM w3xvp_content AS a LEFT JOIN w3xvp_categories AS c ON c.id = a.catid LEFT JOIN w3xvp_users AS ua ON ua.id = a.created_by LEFT JOIN w3xvp_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM w3xvp_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN w3xvp_categories as parent ON parent.id = c.parent_id LEFT JOIN w3xvp_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM w3xvp_categories AS cat JOIN w3xvp_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN w3xvp_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-18 18:10:42') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-18 18:10:42') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END DESC , a.created DESC

                                                             Mississippi's Largest Property Management Company Est.1933                                                                

  • IMG 0539
  • IMG 0545
  • showcase-b
  • showcase-e

About Hattiesburg

Hattiesburg, Mississippi, encompasses much of Forrest County (where it is the county seat) and Lamar County and has a population of over 50,000. Find useful links and more information about Hattiesburg by clicking below.

Read More

London and Stetelman Commercial Real Estate and Property Management - Tenant Portal

London and Stetelman Commercial Real Estate and Property Management - Owner Portal


Warning: Invalid argument supplied for foreach() in /home/content/87/10308087/html/components/com_content/models/articles.php on line 486

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/content/87/10308087/html/libraries/joomla/database/database/mysqli.php on line 263
 Portal

Tenants: New Online Access

Our new Tenant Portal provides 24/7 online access for our tenants to request services, see your balance and pay on your account online. We are excited to bring this new level of functionality to our tenants and invite you to contact us if you have any questions or if you need assistance.

Login

 
 Portal

Owners: New Online Access

We are pleased to introduce our new Owner Portal, providing 24/7 access for property owners to login and see information about their accounts, balances and other information. This new portal provides convenience to the owners we represent and is provided to give you the information you need when you need it.

Login

 
Commercial

Search our Commercial Listings

London and Stetelman Commercial Realtors has a wide selection of commercial properties throughout the Hattiesburg, Forrest and Lamar County area. Please use the link below to view information about available commercial properties or contact us to find out about our commercial property services.

View Listings

 
 Residential

Search Our Residential Listings

London & Stetelman manages a large inventory of residential property including houses, apartments, condos and duplexes.  Please click the link below to view our interactive, mapped rental listings. If you would like to learn more about the management services we provide, please contact us.

View Listings

 

News from around the State

Mississippi Business Journal

Mississippi Business Journal
  • In 2011 when Flowood-based Transcript Pharmacy was once again ranked in the Inc. 5000 as one of the fastest-growing privately held companies in the nation, president Cliff Osbon, R.Ph., attributed Transcript Pharmacy’s growth to the trust patients, health care providers, payors and other third parties put in his company. Now, that trust factor has been […]

  • The Mississippi Economic Council completed a victory lap over passage of its priority tax legislation by having Gov. Phil Bryant sign House Bill 799 at the close of the business organization’s annual meeting and luncheon last Thursday. At the prodding of the MEC and other business groups, lawmakers crafted HB799 to counter the effects of […]

  • Canton’s Panther Creek Commerce Center has an attraction no other Mississippi mega site can offer — inclusion in a state Health Care Industry Zone. The nearly 2,000-acre tract off Nissan Drive falls within the required five-mile radius of Madison River Oaks Medical Center in Canton. This qualifies prospective medical-related tenants of the megasite for such […]

  • Megasites can bring mega worries to the CEOs and directors of companies looking to put a major manufacturing plant or other high-cost facility on one. Once those worries grow to a certain point or linger for too long, the decision makers put the megasite in a folder designated for “uncertain propositions.” A Purgatory like that […]

  • It takes time and money to turn around a publicly owned rural hospital’s image once it is seen as troubled and cash-strapped. That’s why the chief administrator of Tallahatchie General Hospital says he fears his work to convince Charleston and the surrounding communities to think differently about Tallahatchie General sustained an unnecessary set back in […]