502 STARBOARD LN Middletown, DE 19709

A rare and truly one-of-a-kind offering, this exceptional brick Colonial delivers luxury, space, and unmatched versatility on a beautifully maintained 2-acre homesite within the sought-after Appoquinimink school district. Set within one of Middletown's smaller established neighborhoods of just 65 homes, the property sits on a quiet cul-de-sac street. Thoughtfully renovated from top to bottom, the main residence showcases modern lighting, custom trim work, neutral tones, and an open layout designed for both everyday living and entertaining. Over the course of nearly a decade, the current owners invested extensively in renovations and enhancements, transforming the property with a meticulous eye for design and functionality. Significant exterior improvements include upgraded insulated vinyl siding, replacement windows throughout, and a premium fiberglass front entry door. At the heart of the home is a stunning, fully reimagined chef's kitchen featuring luxury appliances, expansive prep space and designer finishes. A full wall of floor-to-ceiling cabinetry surrounds the refrigerator, while glass upper accents, a farmhouse sink, induction cooktop, double ovens, and a built-in microwave drawer complete the space. Cathedral ceilings, expansive windows, and a gas fireplace create an inviting space in the family room. A functional mudroom with large hall tree, sizable storage closet and powder room add convenience to the main level, while formal living and dining rooms provide elegance. The upper level includes a versatile room currently styled as an office that can easily function as a bedroom, along with two additional secondary bedrooms. Each bedroom offers generous closet space and ceiling fans for added comfort. The beautifully renovated hall bath features a double vanity, striking tile accents and a modern glass-enclosed tub shower. The primary suite is both serene and inviting and serves as a true retreat. The bath is stunning with marble flooring and tilework, built-in storage, and marble countertops with dual vanities. A large skylight brightens the space, while the oversized glass shower adds a refined, spa-like feel. A grand walk-in closet offers impressive storage and dressing space. Just beyond the primary bedroom, a laundry room adds everyday convenience before leading into an expansive bonus retreat-ideal for a home office, fitness area, nursery or quiet escape. Partially finished, the basement adds additional living space with luxury vinyl plank flooring and walk-out access through Bilco doors. Ideal for storage, recreation or fitness, the space also includes a treadmill and elliptical that will remain with the home. What truly elevates this property is the remarkable attached private residence-over 1,600 square feet of beautifully designed independent living space. Connected to the main home through adjoining garage access, it is far beyond a traditional in-law suite. This thoughtfully designed secondary home features open-concept living, its own full kitchen, plantation shutters and hardwood flooring throughout. The kitchen boasts quartz countertops, soft-close cabinetry, stainless appliances and walk-in pantry. A spacious bedroom is complemented by an impressive walk-in closet and an oversized bathroom with a roll-in shower. With ADA-accessible features, private entrance and a dedicated one-car garage, this secondary residence feels fully self-sufficient. Ideal for multi-generational living, long-term guests, or evolving lifestyle it does not compromise privacy or luxury. The outdoor living space is equally impressive, with a resort-style setting that includes a 40,000-gallon salt water in-ground pool, stamped concrete surround, pool house with electric and mature landscaping. Both the main home and the attached residence enjoy private deck access overlooking the backyard oasis. There is simply nothing else like this on the market-a home designed to bring people together while preserving comfort and independence.