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 = 1863 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 1863 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 1863 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

24065 Ingrams Dr #120
Millsboro, DE 19966

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $860,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: Welcome to opulent living in the heart of Ingrams Point! Nestled on a sprawling half-acre wooded lot, this magnificent Caruso Homes Lexington II model exudes unparalleled luxury with its meticulous design elements and flawless craftsmanship throughout. Upon entry, prepare to be mesmerized by the grandeur of the two-story foyer, featuring a majestic turned staircase that leads to the upper level. The main floor seamlessly combines opulence and practicality, boasting a spacious home office and a dining area adorned with sophistication, ideal for hosting extravagant gatherings. The main living space is adorned with luxury vinyl plank flooring, creating a seamless and tasteful ambiance. Expansive windows and doors throughout the home flood the interior with an abundance of natural light at every corner providing a warm and inviting aura. Prepare to be captivated by the gourmet kitchen, a culinary paradise featuring 42"" crisp white soft-close cabinets, a stylish 5-burner gas range with an elegant range hood, classic subway tile backsplash, Quartz countertops, double wall ovens, a French door GE Profile refrigerator, built-in microwave, and a generously sized walk-in pantry. The magnificent island, accentuated with striking navy-blue cabinets, not only offers additional storage but also serves as the focal point for culinary delights and gatherings. Adjacent to the kitchen lies a delightful dining area overlooking the lush, wooded backyard, seamlessly merging indoor opulence with outdoor splendor. Transition through glass sliding doors to a composite deck, perfect for dining al fresco. The open floor plan flows effortlessly into a gracious living room, complete with a cozy gas fireplace, perfect for unwinding on tranquil evenings at home. The main level also hosts a sumptuous primary bedroom retreat, boasting an abundance of closet space, including a palatial walk-in closet. The lavish spa-like bath serves as a sanctuary of relaxation, featuring a dual sink vanity with display cabinetry, a custom walk-in shower with expansive windows, and a step-up to a lovely standalone tub. Ascend the staircase to discover an expansive family room and three lavishly appointed bedrooms, two of which are ensuites. These luxurious bedrooms boast amenities such as walk-in closets, dual sink vanities, and private water closets. The vast basement presents endless possibilities, with some flooring and drywall already in place, and rough plumbing ready for customization to fulfill your desires. Outside, the Ingrams Point community offers enchanting nature trails weaving through woodlands and along serene streams, as well as parks and open spaces, providing limitless opportunities for outdoor recreation. Indulge in nearby dining, shopping, and entertainment, while relishing the convenience of Delaware beaches and coastal amenities just a short drive away. Do not miss this rare opportunity to immerse yourself in the pinnacle of luxury living in the breathtaking Caruso Homes Lexington II model at Ingrams Point. Schedule your exclusive private tour today and embark on a journey of unparalleled refinement and sophistication.
MlsNumber: DESU2006738


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Northrop - Bethany
Office Phone: (888) 536-0216
Agent Name: Jim Lattanzi Lattanzi
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 = 1863 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Tulay DeLuca
Tulay DeLuca
ASCIIHighLine Residential
Direct: (516) 425-7195

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App