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

201 Mechanic Street
Odessa, DE 19730
Joseph Berchock with RE/MAX Associates - Newark, original listing - (302) 453-3200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1975 Square Feet
Agency: RE/MAX Associates - Newark
Agency Phone: (302) 453-3200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Outstanding opportunity to own a lovely, Value packed & Renovated 3 Bedroom, 2.5 Bath Ranch home with 1975 Sq Ft. on the Main living Level, sitting on a small quite Street in the Historic Town of "Odessa" within the sought after Appoquinimink School District. The recent updates include, entire Home is newly Painted, all new Carpet & pad, plus LVP Flooring throughout the entire home. There was a vast 32' x 20' Family room and Primary Bedroom & Bath addition. The Family Room features a dramatic volume ceiling, recessed lights, a convenient Powder room & an Andersen atrium door to the updated Rear deck with all new Deck boards and a Vinyl rail and Spindles. Surely another highlight is the Primary bedroom with en-suite bath with a true dressing area, large walk-in closet, 4 Piece bath with a corner Whirlpool tub, separate Shower w/ glass doors, a vanity sink with makeup area and a private water closet. This huge bedroom area also features an office niche, and a double closet as well. The Kitchen features Oak cabinets with a double Pantry cabinet, three stool Breakfast bar w/ recessed lights, all updated appliances, and this overlooks the large breakfast room with pantry/storage closet and chair rail molding, plus a step saving first floor laundry area. There is a private Living room off the Foyer, that offers flex space with two 10 panel lite entry doors and a wood burning Fireplace. System features include a Brand New 30 Year Dimensional Shake Roof(2024), Andersen Windows & Doors, an Updated High efficiency Natural Gas HVAC System(10+/-) & High " E" Gas Hot water, Copper plumbing, 200 amp CB's, Security system, Ceiling fans throughout. There is a Full Basement with a rear Bilco door entry, plus a Front seating Porch, a rear Deck and and a one car garage w/ Base & Wall cabinets and a rear service door. Outstanding location near all major roads, Route # 13 & 1, 299 to Downtown Middletown and scenic route # 9. Odessa offers true Convenience and History. The Historic Odessa Foundation, features 18th & 19th Century Architecture w/ Walking tours & upcoming Special Events, Corbit Calloway Public Library, Corbit-Sharp House, Cantwell Tavern and Odessa Park is across the Street. Only 30 minutes to Wilmington, 20 minutes to Dover and One hour to the Resorts in Sussex County. This is one of the Best Values in the greater MOT, for a Ranch Home. Wow look at those $$$ per Sq Ft. Available Immediately!<br /> The Home does qualify for 100% USDA and VA Financing.
MlsNumber: --
ListingId: DENC2069306


Listing Provided By: RE/MAX Associates - Newark, original listing
Phone: (302) 453-3200
Office Phone: (302) 453-3200
Agent Name: Joseph Berchock
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 = 3381 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 Javia Campbell
Javia Campbell
ASCIICENTURY 21 Gold Key Realty
Call Today!: (302) 383-4337

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App