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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;

112 Pinehaven Place
Clinton, MS 39056
Jake Clarke with NuWay Realty MS, original listing - (601) 941-2846

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2686 Square Feet
Agency: NuWay Realty MS
Agency Phone: (601) 941-2846

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Spacious 4-Bedroom Home on 2 Acres - Country Living with City Convenience!Welcome to 112 Pinehaven Pl, Clinton, MS--a rare opportunity to enjoy the best of both worlds: peaceful country living within city limits! This 2,686 square foot home sits on a beautiful 2-acre lot, offering space, privacy, and endless possibilities. With 4 bedrooms, 3 bathrooms, and a dedicated office, this home is designed for both comfort and functionality. Built in 2005, the home boasts a thoughtfully designed layout, perfect for families or anyone needing extra space. The oversized pantry, originally intended as a laundry room, provides exceptional storage--ideal for groceries, small appliances, and all the Costco runs you plan to make! Outdoor enthusiasts will appreciate the RV storage carport, a second garage that's perfect for additional vehicles, a workshop, or extra storage, and additional gravel driveway. Whether you love hosting gatherings or simply need space for all your hobbies, this property has it covered. Love the idea of a backyard oasis? This home is already wired for a future pool, making it easy to customize your outdoor space. Plus, with no HOA restrictions, you have the freedom to truly make this property your own. Despite its peaceful setting, this home is just 5 minutes from Clinton Schools, as well as local shopping, dining, and major roadways--offering both convenience and tranquility. The expansive lot provides endless opportunities, whether you're looking to garden, add outdoor entertainment spaces, or simply enjoy the wide-open space. If you've been searching for a spacious, move-in-ready home with room to grow, this is it! Don't miss your chance to own this one-of-a-kind property in Clinton. Call today to schedule your private tour and see all this home has to offer!
MlsNumber: --
ListingId: 4107240


Listing Provided By: NuWay Realty MS, original listing
Phone: (601) 941-2846
Office Phone: (601) 941-2846
Agent Name: Jake Clarke
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