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 = 3418 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 = 3418 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 = 3418 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;

1609 Sw Linda Drive
Clinton, MS 39056
John P Coughlin with Three Rivers Real Estate, original listing - (601) 303-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 7
Baths: Full: 5, ½: 1
Status: Active
SqFt: 7000 Square Feet
Agency: Three Rivers Real Estate
Agency Phone: (601) 303-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: ''MUST SEE PROPERTY''BEAUTIFUL LAKE FRONT EXECUTIVE COUNTRY ESTATE. NEWLY RENOVATED AND UPDATED, COUNTRY SETTING WITH ALL CITY CONVENIENCES, LOCATED ON 5.5 ACRES! VERY PRIVATE! 7 Bedrooms, 5.5 Bathrooms, Stunning Foyer and Beautiful Staircase, Formal Living and Dining Rooms, Enormous Kitchen (New Stainless Steel Appliances), with Island, Quartz Countertops, Large Butcher Block Countertop in Island, Study with Fireplace; (2) Primary Bedrooms with Fireplaces; Sun- Room or Hobby Room (Over-looking the pool), Spacious Den / Family Room with Lots of Built-ins with Stunning Fireplace and Hearth and many other oversized areas. Screened in Back porch, the full length of house with built-in BBQ grill. Perfect for relaxing and/or entertaining. Lots of storage with finished walk-in attics and finished and floored third floor attic.Beautiful Gunite pool and recreational area with pool house / apartment with full bath.New Septic and Treatment Systems.New and Updated electrical panels.New Full House Generator with 500 gallonunderground propane tank.New Driveway and Parking Area for 15 to 20 Parking Spaces. Wonderful for Entertaining and Family Functions.
MlsNumber: --
ListingId: 4095744


Listing Provided By: Three Rivers Real Estate, original listing
Phone: (601) 500-2852
Office Phone: (601) 303-7653
Agent Name: John P Coughlin
Disclaimer: Copyright © 2024 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