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

2459 Dunbrooke Road
Tappahannock, VA 22560
Karin Andrews with Shaheen Ruth Martin & Fonville, original listing - (804) 288-2100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3584 Square Feet
Agency: Shaheen Ruth Martin & Fonville
Agency Phone: (804) 288-2100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 95 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1781
Notes: Cherry Walk, circa 1781 built for Carter Croxton of Revolutionary War fame, is sited on a lovely knoll and built upon a high English Basement. The main house features handsome flemish bond brickwork, a wood shake gambrel roof, and two elegant chimneys that flank both sides of this 18th century Tidewater Cape. Original doors, floors, hardware and moldings. 95+ acres of pristine farmland, including mature hardwoods and pine forests, which provide abundant habitats for all types of waterfowl, upland birds, wild turkey and wildlife. In recent years, the current owners have embarked upon a sensitive restoration of the main house, fencing and pollinator gardens. Water features found on the property include natural streams which meander through part of the woodland with wood duck habitats and a farm pond. An in-ground salt pool with new salt system provides a wonderful focal point in the garden and a relaxing respite on summer days. A rare and remarkable assemblage of historic dependencies original to the property, offer a rare glimpse into farm life in the late 18th century. Located in the Millers Tavern Rural Historic District of Essex County, the offering of this very handsome home presents a unique buying opportunity to those seeking a fully renovated turn-key oasis. Minutes to Wineries, Medical Facilities, Antique Shops, Boutiques, Fine Dining, Historic Sites, Museums, Marinas and so much more. An easy drive to Richmond, Williamsburg, the Northern Neck and Fredericksburg. Convenient to Washington, D.C.
MlsNumber: --
ListingId: 2415438


Listing Provided By: Shaheen Ruth Martin & Fonville, original listing
Phone: (804) 288-2100
Office Phone: (804) 288-2100
Agent Name: Karin Andrews
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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