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

302 E Howard Street
Viola, DE 19979
Kimberly Rivera with Keller Williams Realty Central-Delaware, original listing - (302) 677-0020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,380,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 4319 Square Feet
Agency: Keller Williams Realty Central-Delaware
Agency Phone: (302) 677-0020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: This remarkable, custom-built estate boasts quality construction, thoughtful additions and limitless potential for the next owners to discover. Quality of the build was at the forefront including insulation in all walls and 2’x6’ wood was used in walls throughout. Upon arriving you will find that this sprawling home is situated on 3.8 acres which includes plenty of outdoor space, 6 attached garage bays, a 40’x80’ pole building and two sheds. The main home has a welcoming covered front porch that leads you into a spacious foyer with tile flooring that is flanked by a formal dining room and sitting room. To the right is the formal dining room that has plenty of space for furniture and creates a functional room for gatherings. To the left of the foyer is the spacious sitting room with double door entry into the in-law suite. Connected to the sitting room is a well-sized den, perfect for a home office. Next to the den is a sunroom with plenty of windows allowing in natural light, and a door leading out to the deck, which was built to support a hot tub, and backyard. Continuing on you enter the sprawling kitchen that overlooks the private backyard. Take note that all woodwork in the home was Amish built, including the door trim and cabinets. The large island has electrical outlets, space for seating and even more storage space. Imagine the ease of cooking and socializing with friends and family in this incredible space. A dinette is located between the kitchen and family room. Rounding out the kitchen space is a massive walk-in pantry that has a stackable washer and dryer for main floor use. The family room does not disappoint with gorgeous applewood laminate floorings, a cedar wall and plenty of space for furniture to create a relaxing sanctuary to spend down time. Heading towards the attached garages, there are two coat closets and the first full bathroom with a stall shower. Upstairs you will find three well-sized secondary bedrooms that share a full hall bathroom with a tub shower, deep linen closet and dual sink vanity. In the third bedroom you can access the attic by standard stairs leading to the incredible storage space that has 2’x10’ load bearing flooring. The main laundry room is on the second floor for added convenience. Completing this level is the primary suite that has double door entry into the spacious bedroom and another set leading into the attached bathroom. The bathroom has a large tiled stall shower, two separate vanities, commode room, a jetted tub and access to the enormous walk-in closet with deep storage space. Back downstairs, one of the most notable features of this property is the 781 sqft in-law suite. It has endless potential, whether it be for family to stay close by or its current use as a rental. This space has a full kitchen, living room with vaulted ceilings, 1 bedroom, 1 bathroom, attached 2-car garage with washer and dryer hookup and attic storage space and accessibility features such as lever door handles, 36” doors and a roll-in shower. Back over at the main house the jaw dropping garages and pole building attached to this home are incredible! All have piping for compressed air built-in and can all be accessed from the main house. The first garage is oversized and has three garage bays with openers for each door. The second garage has a 2-car overhead door with opener, a manual single door, and cabinetry and shelving along the back wall. This garage has a standard staircase to an additional storage area that has plywood flooring and electric outlets. In the breezeway there is an oil tank for the garage/pole building heaters and can be used to fuel equipment, next you will enter a 40’x80’ pole building that has a 12’x12’ RV overhead door, and a manual 8 ft overhead door to access the backyard. The quality and attention to detail in this home truly shine through as you walk through - schedule a tour today to see everything it has to offer for yourself!
MlsNumber: --
ListingId: DEKT2028522


Listing Provided By: Keller Williams Realty Central-Delaware, original listing
Phone: (302) 346-2719
Office Phone: (302) 677-0020
Agent Name: Kimberly Rivera
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 = 3382 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