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

IDX Support

sales rep | Brivity IDX

Agent profile image in message

By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , 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.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
View All (28)
property photo 1
property photo 2
property photo 3
557 Mansion House Rd , Bear, DE 19701
$1,200,000
Est. Payment: $6,562.57/mo
3 Bed
2 Bath
2050 Sqft
18.41 Acres
Status: active | Days on site: 441
Get Pre-Qualified
GOLDKEY - 3365016
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.
Agent profile image
IDX Support
sales rep
View agent profile
Email
Call

House Description

This listing is brimming with potential. Nearly 20 acres in the serene countryside of Bear, DE, this mixed use property offers a perfect blend of tranquility and convenience. Middletown and Newark, DE, including the University of Delaware; Cecil County (Elkton, MD); Kent County, and even Delaware beaches are accessible. Located just minutes from major highways (I-95, Rte 1, Rte 7, Rte 40 and Rte 896), shopping centers, and schools, it offers the ideal location for both privacy and accessibility. Reach the Philadelphia International airport within an hour and BWI airport in MD under 2 hours. Explore the possibilities of building your own home(s), a small subdivision, or restart a farm, etc. Three parcels are sold together with all existing homes included in the sale. Option to allow a paintball company to operate as an agricultural tourism use.
Show more

Highlights

Listed by VIVIAN SPAHR , 3025284430 Century 21 Gold Key Realty , 3023695397. Bright MLS

Property Type

Residential
Lot/Acreage
18.41

Year Built

1997

County

New Castle

Area

New Castle/Red Lion/Del.City (30904)

 Neighborhood

None Available

 School District

Appoquinimink

Listing ID

DENC2087284

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:3
  • ▪ Bathrooms:2
  • ▪ Full Bathrooms:2
Appliances:Negotiable
Air Cond:Heat Pump(s),Window Unit(s)
Fireplaces:
Above Ground Sq Ft:2050
Other:
  • ▪ Main Floor Bedrooms:2
  • ▪ Additional:Wood Floors
Water:Well

Exterior Features

Lot:Backs to Trees,Cleared,Front Yard,Irregular,Level,Partly Wooded,Private,Rear Yard,Rural,Trees/Wooded,Not New Construction,Horse Property: No
Lot Dimensions:245.00 x 180.00
Garage Capacity:2
Zoning:NC21
Roof:Pitched,Shingle
Others:
  • ▪ Additional:Outbuilding(s), Satellite Dish
Sewer:On Site Septic
Parking Features:Garage - Front Entry,Attached Garage,2+ Spaces,1+ Spaces
Principal Interest
$6,563
Taxes
$135

Home Price

$1,200,000

Loan Details

30 yrs
7.271%

Down Payment

20%
$240,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:
$6,562.57

Principal

Taxes

Principal Taxes HOA Total
Monthly $6,562.57 $134.50 $0.00 $6,697.07
Yearly $78,750.86 $1,614.00 $0.00 $80,364.86
Total $2,362,525.86 $48,420.00 $0.00 $2,410,945.86
Lender profile image
Chico Gordy
Test
Email
Call
Visit
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 (Bear, 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