x
Showing 1 of 0
X
Save

242 Church St.
Columbia MS 39429 US

$59,900

Active Listing ID 146826
bed icon
1 bed
home icon
Business

$59,900

Active Listing ID 146826
Save

242 Church St. Located in the heart of downtown Columbia, this versatile commercial property offers endless potential for a variety of business or residential uses. The space is well-suited for a hair or nail salon, professional office, boutique retail, or could be converted into an apartment or mixed-use setup.The building features a new roof with a 15-year warranty, providing added value and peace of mind for future owners. With its prime in-town location and adaptable layout, this property presents an excellent opportunity for entrepreneurs, investors, or those looking to create a customized space in a growing area.

Collapse all

Property Features

  • Facts
  • Property Type: Commercial Sale
  • Property Sub-type: Business

Property

  • propertytype: Commercial Sale
  • propertysubtype: Business
  • listprice: 59900
  • unparsedaddress: 242 Church St.
  • postalcity: Columbia
  • stateorprovince: MS
  • country: US
  • postalcode: 39429
  • bathroomsfull: 0
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 1100
  • livingareaunits: Square Feet
  • latitude: 31.253047
  • longitude: -89.836248
  • listagentfullname: Beau Davis
  • listagentemail: beauchancedavis79@gmail.com
  • listagentkey: 3yd-HAARMS-20210514183255474720000000
  • listagentmlsid: 20210514183255474720000000
  • listagentpreferredphone: 6014229812
  • listagentofficephone: 2284715211
  • listofficekey: 3yd-HAARMS-20220415173316963404000000
  • listagentstatelicense: S-56272
  • listofficemlsid: 20220415173316963404000000
  • disclaimer: Copyright © 2026 Hattiesburg Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: HAARMS
  • listingcontractdate: 2026-04-24
  • listagenturl: https://www.onereal.com
  • countyorparish: Marion
  • constructionmaterials: Block
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • waterfrontyn: False
  • interiorfeatures: Other - See Remarks
  • architecturalstyle: Other
  • rooms: Bedroom 1
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -89.83625, 31.253048
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Real Broker LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"beauchancedavis79@gmail.com", "ListBrokerageCity":"Pascagoula", "ListBrokerageCountry":"US", "ListBrokerageEmail":"msbroker@therealbrokerage.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Real Broker LLC", "ListBrokeragePhone":"(855) 450-0442", "ListBrokeragePostalCode":"39567", "ListBrokerageStateOrProvince":"MS", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"803 Live Oak Ave", "ListBrokerageWebsiteUrl":"https://www.onereal.com", "ListOfficeAddress1":"803 Live Oak Ave., Pascagoula, MS 39567", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"20181009202333780456000000", "ListOfficeCity":"Pascagoula", "ListOfficeCountry":"US", "ListOfficeEmail":"arittdavis@gmail.com", "ListOfficePostalCode":"39567", "ListOfficeStateOrProvince":"MS", "ListPriceCurrencyType":"USD", "ListingTitle":"Other - See Remarks, Business - Columbia, MS", "ListingURL":"https://listings.listhub.net/pages/HAARMS/146826/?channel=rexren", "MLSModificationTimestamp":"2026-04-24T20:19:58Z", "Neighborhoods":[{"Description":null, "Name":"Columbia"}], "PostalCode":null, "RawPropertySubType":"Business", "RawPropertyType":"Commercial", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/27/2026 8:33:23 PM GMT
Source Updated Date: 5/2/2026 7:14:23 AM GMT

Courtesy of: Beau Davis, Real Broker, beauchancedavis79@gmail.com

Copyright © 2026 Hattiesburg Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.