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

136 Paul Brewer Road
Magee, MS 39111
Linda Curlee with Main Street Realty LLC, original listing - (601) 849-3226

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3636 Square Feet
Agency: Main Street Realty LLC
Agency Phone: (601) 849-3226

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: If you are looking for privacy, this is the right home for you. This lovely home sits on top of a hill, which overlooks a pond (much larger after a rain). With 360 degree views, it is spectacular. You can watch the wild life and the seasons change. The home features many extras throughout which include: post-tension cable in the perimeter footings, large tilt-out vinyl windows for easy cleaning, Tech-shield decking to lower attic temperatures and there is insulation in the main interior walls to decrease interior noise. The center rooms of the home have 10ft ceilings. The 15.5 x 17.5 Master bedroom with 9ft ceilings has a large walk-in closet and a pass through to the laundry room. The home has a split plan with walk-in closets in oversized spare bedrooms, which were built large enough for either king or queen bedroom sets. The spare bedrooms have a Jack-and-Jill bath. The open floor plan has a spacious family room and kitchen combination that includes a gas log fireplace. Kitchen features stainless appliances, custom cabinets, a large 5x7 island, a pantry and lots of storage. The open floor plan has easy flow for large group entertaining. Whether you have pets or children the Mud Room is conveniently located off garage and features a shower with an entrance to laundry room. The Mud room is a fabulous feature of this home! The upstairs has flexibility and endless possibilities, with 2 finished rooms and ''nearly another house'' of unfinished, floored, walk-in attic space. The play room is 9x 27ft with an additional 4ft opened and finished play space running the length of the room. The second finished room (16x 18ft) has been a craft room, office, playroom and extra sleep space (you decide how it will best suit your needs). Behind one wall of this room are installed plumbing connections for future bathroom if needed. The unfinished attic space has 3 sections that are all open and connected. The first measures 12x32ft, the second 7x 32ft and the third 16x18ft. The 16x18 area has plumbing connections for future use as well. This custom home was built with functional use of space and future possibilities in mind. It's conveniently located 5 minutes from downtown Magee and it will not last long! Make it yours today by calling and making an appointment.
MlsNumber: --
ListingId: 4084816


Listing Provided By: Main Street Realty LLC, original listing
Phone: (601) 849-3226
Office Phone: (601) 849-3226
Agent Name: Linda Curlee
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.


Local Real Estate Expert

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 = 1468 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;
Real Estate Expert Photo for Hunter Dedmon
Hunter Dedmon
ASCIIMcGee Realty Services
Call Today!: (601) 720-5674

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App