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

6191 Pearsons Corner Road
Dover, DE 19904
Ashley Hogate with EXP Realty, LLC, original listing - (888) 543-4829

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,860,000
Beds: 6
Baths: Full: 7, ½: 1
Status: Active
SqFt: 5904 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 543-4829

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 41 acre(s)
Property Type: Farm-Farm
Year Built: 1999
Notes: Welcome to an unparalleled equestrian estate, where luxury and functionality harmonize across 41+/- meticulously maintained acres. This exceptional property provides eight horse pastures, a horse barn, tillable land for hay or crops, and wooded acreage perfect for hunting. The main residence, a stunning 4-bedroom, 3.5-bath home, underwent a comprehensive renovation in 2010, showcasing exquisite attention to detail. Enter through the large, inviting front foyer into an open kitchen and dining area adorned with slate flooring, a wood stove, stainless steel appliances, a spacious oversized island, KraftMaid cabinetry, and crisp white solid surface countertops. A large butler's pantry features custom Amish-built cabinetry. The expansive family room, with hand-scraped hardwood flooring and another wood stove, provides the perfect setting for relaxation. Adjacent is a bedroom with a den and en-suite bath, a powder room for guests, and an office with French doors leading to a private deck. The rear foyer opens to a climate-controlled mudroom, ensuring comfort in all seasons. Upstairs, the primary suite offers two walk-in closets and an en-suite bath with a soaking tub, oversized shower, and private toilet room. Two additional bedrooms share a jack-and-jill bathroom. The upstairs laundry room adds convenience to luxury living. Step outside to the large deck to savor sunsets overlooking the inground pool and pastures, where horses frolic and play. Adjacent to the main house, a lounge/rec room, additional office, wood shop, and a one-car garage provide versatile spaces. The estate includes two 75-gallon self-contained water heaters with lifetime warranties, ensuring long-term peace of mind. The guest house, equally exquisite, features 2 bedrooms, 3 bathrooms, a sitting room/office, family room, and a well-appointed kitchen separated by a wood stove. It also offers a maintenance-free deck, mudroom, utility closet, and a detached 2-car garage, with slate tile in bathrooms and hand-scraped hardwood throughout. For equestrian needs, the property includes a hay/horse barn, a large pole building for equipment storage, and a small shed. Both residences are equipped with geothermal heating units, reflecting a commitment to sustainability. Each of the eight pastures is equipped with water and electric fencing, supporting various equestrian and agricultural activities. This extraordinary property is a versatile treasure, ideal for hunting, farming, or transforming into an event venue. Experience the perfect blend of luxury, practicality, and natural beauty in this distinguished horse farm estate.
MlsNumber: --
ListingId: DEKT2029204


Listing Provided By: EXP Realty, LLC, original listing
Phone: (443) 864-2772
Office Phone: (888) 543-4829
Agent Name: Ashley Hogate
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 = 317 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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 Anthony Lapinsky
Anthony Lapinsky
ASCIIOlson Realty
Call Today!: (302) 399-0546

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App