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

3859 Green Hill Church Road
Quantico, MD 21856
PJ Whitney with Whitney-Wallace Commercial, original listing - (410) 548-5484

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1836 Square Feet
Agency: Whitney-Wallace Commercial
Agency Phone: (410) 548-5484

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Welcome to your dream waterfront retreat! This beautifully designed and freshly renovated contemporary craftsman-style home features 3 bedrooms and 2.5 bathrooms located on the quiet street of Green Hill Church Road along the serene Wicomico River. Nestled in a private, peaceful setting rich with wildlife, this home is your sanctuary while remaining just a short drive from local conveniences. Enjoy your own private pier, recently resurfaced and extended for deep-water access—ideal for boating, jet skiing, kayaking, paddle boarding and more.<br /> <br /> Step inside to an inviting large open floor plan that includes a spacious living room and dining area, all adorned with a stunning vaulted ceiling. The newly renovated kitchen is a chef's delight, boasting modern cabinetry, luxurious Quartzite countertops with a bar area, black stainless steel appliances, and a charming copper sink and faucet. French doors lead to a brand new 16x20 composite deck with built-in benches, perfect for outdoor gatherings. Enjoy additional outdoor living with a 12x16 screened porch offering river views, and a 16x30 wooden deck on the south side of the home—ideal for soaking up the sun or enjoying evening sunsets.<br /> <br /> The home features new flooring throughout, with hickory hardwood on the main level, upper hallway, and primary bedroom, complemented by new carpeting in the additional two bedrooms. All bathrooms have been tastefully renovated: the primary bathroom features elegant tile floors, a granite-topped vanity, and a spacious tiled shower with a built-in bench. The hall bathroom is equipped with new tiled floors, vanity and tiled tub surround. The primary bedroom is a true retreat with amazing views of the river, a large walk-in closet and an additional 12-foot closet with built-in shelves and four charming barn doors.<br /> <br /> This home is also located near Green Hill Country Club, featuring a great golf course, and a phenomenal restaurant. Additional restaurants nearby include, The Red Roost crab house, Bull Lips dock bar, and Boonies Restaurant and Bar.<br /> <br /> With abundant outdoor living spaces, luxurious interiors, and the beauty of riverfront living, this craftsman home is a rare find. Don’t miss your chance to experience the ultimate in comfort and tranquility on the Wicomico River! Schedule your showing today to see everything this wonderful home has to offer.
MlsNumber: --
ListingId: MDWC2015400


Listing Provided By: Whitney-Wallace Commercial, original listing
Phone: (410) 548-5484
Office Phone: (410) 548-5484
Agent Name: PJ Whitney
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 = 1204 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;
Real Estate Expert Photo for Brian Foley
Brian Foley
ASCIICoastal Life Realty Group
Call Today!: (443) 365-5075

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App