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

6751 Newcastle Court
Port Tobacco, MD 20677
Joi Nicholas with KW Metro Center, original listing - (703) 535-3610

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5784 Square Feet
Agency: KW Metro Center
Agency Phone: (703) 535-3610

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Welcome home! This gorgeous custom-built home offers over 5,000 square feet of light-filled spaces with more than 2.5 acres of land! Step inside and fall in love with the grand foyer’s dramatic two-story ceiling. To your right you’ll find the perfect private office for all of your conference calls, with gleaming hardwood floors and French doors. On the other side of the home, the bright living room features a stunning vaulted ceiling and large arched window flooding the space with natural light. The adjacent formal dining room is elegant, with a refined tray ceiling and chair rail molding. Continue into the spacious kitchen and you’ll discover an oversized island, newer appliances, granite countertops, a classic tiled backsplash, and a sunny casual dining area. This expansive space opens directly into the family room, where you’ll enjoy getting cozy by the fire this Winter. A half bathroom and a large mud room that includes cabinet storage and a utility sink round off this level of the home. Upstairs, the magnificent primary bedroom boasts a sophisticated tray ceiling, large walk-in closet, and private sitting room. The luxurious en suite bathroom features a frameless glass door shower, double sink vanity with rich wood, and lavish jetted soaking tub. Down the hall, the second bedroom makes a fantastic guest space, with its own attached full bathroom. Both additional bedrooms on this level are sizable, with large closets and share access to the third full bathroom in the hallway. For the utmost convenience, a large laundry room is located on the bedroom level. Downstairs in the lower level, a spacious recreation room offers an additional living space with endless opportunities. On this level, you will also find a secluded 5th bedroom and 4th full bathroom. Outside, the well-manicured property includes a large deck for relaxing and entertaining, a boat-slip, and long driveway in addition to the 3-car garage. Just minutes to Safeway, Target, Walmart, St. Charles Towne Center, Chapel Point State Park, Charles County Fairgrounds, College of Southern Maryland, and UM Charles Regional Medical Center. Quick access to Route 301, Hawthorne Road, Indian Head Highway, and Leonardtown Road. Schedule a private tour of your magnificent home today!
MlsNumber: --
ListingId: MDCH2036434


Listing Provided By: KW Metro Center, original listing
Phone: (703) 535-3610
Office Phone: (703) 535-3610
Agent Name: Joi Nicholas
Disclaimer: Copyright © 2024 Bright MLS. 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 = 1190 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;
Brian Crayton
ASCIICENTURY 21 Envision
Call Today!: (240) 473-3426

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App