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

46 County Road 51310 Road
Rose Hill, MS 39356

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 1
Baths: Full: 3
Status: Active
SqFt: 2300 Square Feet
Agency: Keller Williams
Agency Phone: (601) 977-9411

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Presenting an extraordinary property that defies description! Accessible through its gated entrance, a scenic drive guides you across the lake's dam, enveloped by a serene line of Cedar trees, leading you to a meticulously designed custom 1-bedroom, 3.5 bath residence. In addition to the description below, be sure to ask your realtor for the attached documents with a more detailed description of the construction details. The main level houses the kitchen, dining area, living area, master bedroom, and two full bathrooms, including the master suite with a jetted tub. Upstairs is a huge loft area, with room for a second living area, second bedroom, and another full bathroom. Downstairs in the basement, the lower level showcases 720 square feet of secure rooms, thoughtfully constructed and complete with its own dedicated electrical system. A striking feature of this home is the Vermont wood stove, encircled by a stunning stone wall and a bench crafted from hand-selected stones sourced from Arizona. The kitchen boasts granite countertops and Red Oak bar, a testament to the attention to detail evident throughout. The walls, ceilings, and door/window trim are adorned with an exquisite selection of Cedar, Cypress, River Birch, and Red Oak lumber. Energy efficiency takes center stage with double insulated windows, 12'' concrete exterior walls, and 8'' interior walls, all resting on a solid 12'' concrete slab foundation. The property's allure extends beyond the home, as meticulously maintained pine plantations blend with mature hardwoods, creating a haven for wildlife. The stocked lake beckons fishing enthusiasts with its bass and bream. The property offers ample opportunities for outdoor pursuits and also features a 20x50 enclosed metal workshop, providing plenty of space for equipment storage and recreational vehicles. Don't miss this chance to experience the unmatched charm and possibilities of this remarkable property. Schedule your viewing today and open the door to a world of natural beauty and architectural craftsmanship.
MlsNumber: --
ListingId: 4057715


Listing Provided By: Keller Williams, original listing
Phone: (601) 977-9411
Office Phone: (601) 977-9411
Agent Name: Michael Manuel
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