Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1458 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1458 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1458 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

404 Coleman Street
Como, MS 38619
Tracy Kirkley with Crye-Leike Of MS-OB, original listing - (662) 895-8300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2250 Square Feet
Agency: Crye-Leike Of MS-OB
Agency Phone: (662) 895-8300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: This stunning 3-bedroom, 3.5-bathroom home with a dedicated home office is a masterpiece of modern renovation and classic charm. Nestled in the heart of Como, just moments from its charming historic district, this beautifully updated home is a perfect blend of elegance and warmth. The spacious primary bedroom offers a private retreat with a full ensuite bath, while the second and third bedrooms share a thoughtfully designed Jack-and-Jill bathroom, ensuring both comfort and convenience.Throughout the home, refinished wood floors set the stage for an inviting atmosphere, complementing the carefully curated updates. The gourmet kitchen is a true showpiece, featuring gleaming granite countertops, a center cooking island with a gas cooktop, double ovens, a farmhouse sink, and stainless steel appliances, all accented by brushed gold fixtures and beautifully painted cabinetry. Designed for both style and functionality, the home boasts a formal living room, a cozy family room, and a spacious dining area, perfect for gathering and entertaining.Beyond the beautifully appointed interiors, the property offers over a 1-acre lot, providing space to enjoy the peace and privacy of country living while remaining conveniently close to Memphis, Hernando, Batesville, and a quick drive to Oxford and Ole Miss. A covered patio and two-car carport create an inviting outdoor space, ideal for hosting guests or enjoying quiet evenings under the stars. With every detail carefully considered, this home is a rare opportunity to experience refined living in a setting that feels like home the moment you arrive. (Some photos are virtually staged).
MlsNumber: --
ListingId: 4107285


Listing Provided By: Crye-Leike Of MS-OB, original listing
Phone: (901) 210-8045
Office Phone: (662) 895-8300
Agent Name: Tracy Kirkley
Disclaimer: Copyright © 2025 MLS United. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App