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

32724 Widgeon Rd
Ocean View, DE 19970
Joe Loughran with Bethany, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $785,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Bethany
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Beautiful 4 BD/3 BA + Huge Bonus Room NV Homes Bornquist Model Home w/ porch & partial stone front elevation on spacious corner lot. Enter Foyer w/ gleaming engineered hardwood floors thru beautiful front door w/ glass sidelights. At left, 2 Guest BD w/ upgraded W2W carpet, window treatments, ceiling fans & large closets share a Full Guest BA w/ an upgraded quartz countertop, upgraded cabinetry & brushed nickel fixtures. Proceed into luxurious Gourmet Kitchen w/ stainless steel appliances (French door fridge, wall oven & microwave, cooktop, DW & wine/beverage fridge) premium cabinetry including wine rack. Huge Kitchen Island seats four. Enjoy granite counters & tile backsplash plus large pantry, recessed lighting, pendant lamps & ""porthole windows""� above a wall of cabinets that flood the Kitchen w/ light. The adjacent Great Room, w/ tray ceiling, ceiling fan & recessed lighting, features a natural gas FP w/ slate surround & beautiful wood mantel trim. The Great Room windows, featuring premium blinds & transoms, look out onto broad lawns & a landscaped paver patio. The Door to Paver Patio also includes a transom window. In the Primary Suite, you'll find upgraded carpet, a tray ceiling w/ designer ceiling fan/light, recessed lighting & a wall screen TV. There's a large Sitting Area/Study Extension w/ a vaulted ceiling, and three side-by-side windows bridged by an ""eyebrow""� transom. Primary Bath: twin premium vanities w/ granite counters & brushed nickel lanterns & fixtures, walk-in Roman shower w/ twin shower heads & seats. Huge Primary closet. A beautiful Wrought Iron stair rail guides you to the 2nd Floor's: 4th BD w/ wall screen TV, ceiling fan, premium window treatments & BA w/ upgraded cabinets, fixtures, quartz counter. Plus large Bonus Room w/ twin ceiling fans. And a spacious Loft/Landing w/ gleaming wood floors. The Laundry Room has upgraded cabinets, granite counters. There's a Welcoming Space/Mud Room just inside the 2 Car Garage. The Paver Patio w/ Sitting Walls is well-landscaped. Tankless Water Heater. Conditioned Crawl Space. Bay Forest's HOA maintains the lawn (mowing, fertilization, occasional aeration). New Owner Capital Contribution: $1,000. $495 annual charge for water/sewer infrastructure. The National Association of Home Builders (NAHB) named Bay Forest a Platinum Award Winning ""Best in American Living"" community in 2019 as a community that ""maximized water and green spaces and created a nice sense of micro-communities inside the natural habitat. [Bay Forest Club] has a lovely pool and resort-like amenities and the outside of the (Recreation) Barn is spectacular."" So come enjoy our clubhouse with its lounge, grille, game room, Women's & Men's lockers opening to 3 pools (Lazy River!). And our 4 tennis courts (easily reconfigured for pickleball) & tennis pavilion, outdoor basketball nets, children's play areas, putting green, bocce lawns, horseshoe pits, volleyball space & fire pit. Not to mention Bay Forest's incredible Recreation ""˜Barn' which accommodates a basketball court or three pickleball courts or 450 guests for New Years Eve and other celebrations! The Barn opens to a Great Lawn, two new pools & a new exercise facility featuring a gym, a dance/yoga studio (w/ resilient floors), Men's & Women's changing rooms & beautiful gathering spaces. Don't forget the Kayak Launch w/ kayak storage & expansive Indian River Bay & Bay Bridge views. Or the Herb Garden. Or the Summer Beach Shuttle. Enjoy amazing Salt Marsh views from our wooden Shearwater Drive Bridge crossing directly over Collins Creek to the Recreation Barn, Pools & Gym. 15+ Miles sidewalks. 5 Miles Bethany Beach. Complimentary 2-YEAR-HOME-WARRANTY with a $100 DEDUCTIBLE ($1,200 VALUE!). PRICED 2 SELL! If you want to live in a Platinum Award-Winning ""Best in American Living"" community, come to Bay Forest Club!
MlsNumber: --
ListingId: DESU2071244


Listing Provided By: Bethany, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Joe Loughran
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 = 319 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