Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

400 Campbell Rd , Greenville, DE 19807
$2,995,000
Est. Payment: $16,379.09/mo
4 Bed
5 Bath
5405 Sqft
4 Acres
Status: active | Days on site: 24
Get Pre-Qualified
COMMPROP1 - 3278847
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

Nestled on a sprawling 4-acre lot, this exquisite French-style residence, originally built in 1963 and masterfully renovated in 2004, embodies luxury and comfort at every turn. The exterior showcases a stunning stone façade that exudes timeless elegance, inviting you into a world of refined living. Mini estate property with multiple flagstone patios, pool, greenhouse, 3 car detached garage with storage above. Enter the tree lined driveway to a flagstone walk that leads to a grand foyer with marble floor. The foyer leads to a huge music and family room with one of the 8 fireplaces. From the family room you have your choice of a dining room with another fireplace and room for a table that seats 14 or you could want to the screened porch or covered flagstone patio with fireplace. The kitchen is just off the living room with granite tops, a, AGA stove, vaulted ceiling, fireplace and pantry with double ovens. There is also a small den/office with yet another fireplace. Finishing off the first floor is a master bedroom zip code the size of a small home. The master bedroom area has a large bedroom, with access to a flagstone patio, new master bath, large closet, laundry room, sitting room with fireplace and additional bath, along with a gym. The upstairs has 2 additional bedrooms and two baths along with a game room. The basement has a wine cellar too! The exterior of the home is like a resort with three flagstone patios, screened porch, covered porch and inground pool. The property has a detached 3 car garage with greenhouse, fireplace, sitting room and storage above the garage. This property is designed for those who appreciate the finer things in life, with every detail thoughtfully curated to enhance your lifestyle. The thoughtful design and high-end finishes throughout the home reflect a commitment to quality and sophistication. This property is not just a home; it's a lifestyle. Experience the joy of outdoor living with expansive spaces for entertaining, gardening, or simply enjoying the beauty of nature. The combination of luxurious amenities and serene surroundings makes this residence a true sanctuary. Embrace the opportunity to own a piece of paradise where elegance meets comfort, and every day feels like a getaway. This is more than just a home; it's a place where memories are made and cherished for years to come. Agent/Broker is the owner of the home.

Highlights

Listed by Jeannie Parrott , 3023882419 iBuyer , 3022505541. Bright MLS

Property Type

Residential

Lot/Acreage
4

Year Built

1963

County

New Castle

Area

Hockssn/Greenvl/Centrvl (30902)

Neighborhood

None Available

School District

Red Clay Consolidated

Listing ID

DENC2112448

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:1
Air Cond:Central A/C
Fireplaces:8 Fireplaces
Above Ground Sq Ft:5405
Basement:Partial
Other:
  • ▪ Main Floor Bedrooms:1
Water:Well

Exterior Features

Lot:Not New Construction,Horse Property: No
Garage Capacity:3
Zoning:S
Others:
  • ▪ Additional:Hot Tub, Water Fountains
Sewer:Septic Exists
Parking Features:Oversized,Detached Garage,3+ Spaces,2+ Spaces,1+ Spaces
Principal Interest
$16,379
Taxes
$1,102

Home Price

$2,995,000

Loan Details

30 yrs
7.271%

Down Payment

20%
$599,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$16,379.09

Principal

Taxes

Principal Taxes HOA Total
Monthly $16,379.09 $1,101.67 $0.00 $17,480.75
Yearly $196,549.03 $13,220.00 $0.00 $209,769.03
Total $5,896,470.80 $396,600.00 $0.00 $6,293,070.80
Lender profile image
Chico Gordy
Test
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Greenville, DE).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Bright MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-11-13T17:14:43.000Z

© 2026 Bright MLS