Mcmahanhomes.com Search Results

Welcome to 203 W Union Drive in the popular Lea Eara Farms, an exceptional 4 bedroom, 3.5 bath home that sits on a cul-de-sac lot, backing to a peaceful tree-lined view. This property has been meticulously maintained and thoughtfully upgraded with quality finishes and attention to detail throughout. From the moment you arrive, the curb appeal stands out with gorgeous landscaping, lush garden beds, decorative black fencing adorning the front yard, freshly painted shutters, a brand-new front door, and a new driveway installed in 2025. Enter the grand two-story foyer featuring tile flooring, custom trim work, designer lighting, and rich ¾-inch cherry hardwood flooring throughout most of the living areas. Even the smallest details were carefully considered, including decorative vent and return covers that add an elevated custom touch throughout. The main level offers beautifully designed living spaces including a formal dining room with a custom accent wall detail, a private office with built-ins and a bay window, and an additional bonus room off the kitchen with French doors, perfect for a playroom, second office, or guest space. The stunning gourmet kitchen was designed for both entertaining and everyday living with crowned cabinetry, quartz countertops, custom-laid subway tile backsplash, gas cooking, pantry storage, a built-in desk area, oversized island with barstool seating, and open concept into the spacious family room. The family room provides an abundance of windows for natural lighting, recessed lighting, and a gas-fireplace with a decorative mantel. The main-level powder room adds even more character with designer wallpaper, an updated vanity and toilet, and a sliding barn door. There are three convenient access points to the backyard from the kitchen, mud room, and garage. The two-car side-turned garage itself features professionally finished epoxy flooring. Head up the staircase featuring designer carpet treads that coordinate seamlessly with the second-floor hallway carpet. Upstairs, the luxurious primary suite offers hardwood flooring, two chandeliers, crown moulding, and two professionally designed walk-in closets by Closets By Design. The primary spa-inspired bath provides upgraded designer plumbing fixtures, elevated tile flooring, a soaking-sub, and a stunning walk-in shower with a frameless glass enclosure, tile from floor to ceiling, a built-in shower niche, and pebble tile flooring. Three spacious bedrooms and a hall bath finish the second floor. The finished walk-out basement expands the living space beautifully with plush high-quality carpeting, a kitchenette with sink and a beautiful stone inlay gas fireplace. There is also a full bathroom with a walk-in shower, vanity and toilet, a large workout room, and a beautiful media/music room with a stone inlay electric fireplace. Outdoor living is equally impressive. Enjoy a large maintenance-free deck with vinyl spindles and an electronic retractable awning overlooking the private backyard oasis. The expansive concrete patio surrounding the pool and extending to the driveway is accented by beautiful river stone landscaping. Additional major upgrades include a roof that is only 5 years old, dual HVAC and AC systems that are only 5 years old, and a tankless water heater that is just 3 years old, offering peace of mind for years to come. Additional features include a whole house central vacuum, whole house generator serviced annually by Pace Electric, lawn irrigation system, whole house water filtration system with bypass, whole house steam humidifier, two attic exhaust fans, finished crawl space storage, natural gas service, and an 8x12 storage shed. The 20x40 in-ground pool features depths ranging from 3 to 8 feet and includes a new liner installed in 2025, new pump and filter installed in 2024, diving board, safety cover, and two Polaris pool vacuums. This is the kind of home that rarely becomes available, beautifully maintained, and extensively upgraded!

4 Beds ⋅ 4 Baths

Welcome to 203 W Union Drive in the popular Lea Eara Farms, an exceptional 4 bedroom, 3.5 bath home that sits on a cul-de-sac lot, backing to a peaceful tree-lined view. This property has been meticulously maintained and thoughtfully upgraded with quality finishes and attention to detail throughout. From the moment you arrive, the curb appeal stands out with gorgeous landscaping, lush garden beds, decorative black fencing adorning the front yard, freshly painted shutters, a brand-new front door, and a new driveway installed in 2025. Enter the grand two-story foyer featuring tile flooring, custom trim work, designer lighting, and rich ¾-inch cherry hardwood flooring throughout most of the living areas. Even the smallest details were carefully considered, including decorative vent and return covers that add an elevated custom touch throughout. The main level offers beautifully designed living spaces including a formal dining room with a custom accent wall detail, a private office with built-ins and a bay window, and an additional bonus room off the kitchen with French doors, perfect for a playroom, second office, or guest space. The stunning gourmet kitchen was designed for both entertaining and everyday living with crowned cabinetry, quartz countertops, custom-laid subway tile backsplash, gas cooking, pantry storage, a built-in desk area, oversized island with barstool seating, and open concept into the spacious family room. The family room provides an abundance of windows for natural lighting, recessed lighting, and a gas-fireplace with a decorative mantel. The main-level powder room adds even more character with designer wallpaper, an updated vanity and toilet, and a sliding barn door. There are three convenient access points to the backyard from the kitchen, mud room, and garage. The two-car side-turned garage itself features professionally finished epoxy flooring. Head up the staircase featuring designer carpet treads that coordinate seamlessly with the second-floor hallway carpet. Upstairs, the luxurious primary suite offers hardwood flooring, two chandeliers, crown moulding, and two professionally designed walk-in closets by Closets By Design. The primary spa-inspired bath provides upgraded designer plumbing fixtures, elevated tile flooring, a soaking-sub, and a stunning walk-in shower with a frameless glass enclosure, tile from floor to ceiling, a built-in shower niche, and pebble tile flooring. Three spacious bedrooms and a hall bath finish the second floor. The finished walk-out basement expands the living space beautifully with plush high-quality carpeting, a kitchenette with sink and a beautiful stone inlay gas fireplace. There is also a full bathroom with a walk-in shower, vanity and toilet, a large workout room, and a beautiful media/music room with a stone inlay electric fireplace. Outdoor living is equally impressive. Enjoy a large maintenance-free deck with vinyl spindles and an electronic retractable awning overlooking the private backyard oasis. The expansive concrete patio surrounding the pool and extending to the driveway is accented by beautiful river stone landscaping. Additional major upgrades include a roof that is only 5 years old, dual HVAC and AC systems that are only 5 years old, and a tankless water heater that is just 3 years old, offering peace of mind for years to come. Additional features include a whole house central vacuum, whole house generator serviced annually by Pace Electric, lawn irrigation system, whole house water filtration system with bypass, whole house steam humidifier, two attic exhaust fans, finished crawl space storage, natural gas service, and an 8x12 storage shed. The 20x40 in-ground pool features depths ranging from 3 to 8 feet and includes a new liner installed in 2025, new pump and filter installed in 2024, diving board, safety cover, and two Polaris pool vacuums. This is the kind of home that rarely becomes available, beautifully maintained, and extensively upgraded!

203 W Union Dr, Middletown

Listing courtesy of Crown Homes Real Estate. Contact:

Selling Office: Crown Homes Real Estate.

$615,000

Welcome to this captivating 4 bedroom, 3.1 bathroom colonial style home located in the desirable area of Middletown, DE. This property exudes freshness and modernity, having recently undergone a number of updates. From the moment you step inside to the grand entrance, you are greeted by a canvas of fresh paint and new Luxury Vinyl Plank (LVP) flooring that stretches throughout the entire first floor creating a sleek appearance and durability. The refreshed interior is further enhanced by the installation of new light fixtures throughout, casting a warm and inviting glow. The heart of the home is the large kitchen, which comes equipped with a new range and dishwasher for your culinary adventures which expands to the great room with a fireplace. Adjacent to this is a formal dining room, perfect for hosting family dinners and celebrations. The main level also offers a home office enclosed by sophisticated French doors, providing an ideal space for work or study. Convenience is ensured with a dedicated laundry room on this floor. Upstairs, three of the four ample sized bedrooms boast new carpeting, adding to the comfort and aesthetics of the space. The primary bedroom has a vaulted ceiling and an ensuite with walk-in closet, soaking tub, double vanity and standup shower. The property also features a spacious, finished basement with a full bathroom that provides a plethora of possibilities, be it an additional entertainment area or a workout zone. There is also an unfinished area perfect for storage which you can never have enough of. Step outside onto a large 16 x 20 deck, an ideal spot for lounging and soaking up the sun. The property also boasts a generous fenced backyard, offering plenty of room for outdoor activities and gardening. A 2-car attached garage with workbench caters to your parking needs while extra outdoor light fixtures add to the style and safety. This home is a combination of modern living, elegance and comfort. It is ready to offer a warm welcome to its new owners. Act now to seize this incredible opportunity.

4 Beds ⋅ 4 Baths

Welcome to this captivating 4 bedroom, 3.1 bathroom colonial style home located in the desirable area of Middletown, DE. This property exudes freshness and modernity, having recently undergone a number of updates. From the moment you step inside to the grand entrance, you are greeted by a canvas of fresh paint and new Luxury Vinyl Plank (LVP) flooring that stretches throughout the entire first floor creating a sleek appearance and durability. The refreshed interior is further enhanced by the installation of new light fixtures throughout, casting a warm and inviting glow. The heart of the home is the large kitchen, which comes equipped with a new range and dishwasher for your culinary adventures which expands to the great room with a fireplace. Adjacent to this is a formal dining room, perfect for hosting family dinners and celebrations. The main level also offers a home office enclosed by sophisticated French doors, providing an ideal space for work or study. Convenience is ensured with a dedicated laundry room on this floor. Upstairs, three of the four ample sized bedrooms boast new carpeting, adding to the comfort and aesthetics of the space. The primary bedroom has a vaulted ceiling and an ensuite with walk-in closet, soaking tub, double vanity and standup shower. The property also features a spacious, finished basement with a full bathroom that provides a plethora of possibilities, be it an additional entertainment area or a workout zone. There is also an unfinished area perfect for storage which you can never have enough of. Step outside onto a large 16 x 20 deck, an ideal spot for lounging and soaking up the sun. The property also boasts a generous fenced backyard, offering plenty of room for outdoor activities and gardening. A 2-car attached garage with workbench caters to your parking needs while extra outdoor light fixtures add to the style and safety. This home is a combination of modern living, elegance and comfort. It is ready to offer a warm welcome to its new owners. Act now to seize this incredible opportunity.

408 Maplewood Dr, Middletown

Listing courtesy of Patterson-Schwartz-Middletown. Contact:

Selling Office: EXP Realty, LLC.

$399,900

This charming Colonial-style home in the desirable Lea Eara Farms subdivision offers a perfect blend of comfort and functionality. Built in 1996, this detached residence features 2,050 sq. ft. of living space, ideal for modern lifestyles. The interior boasts three spacious bedrooms and 2.5 bathrooms, including a primary suite with a soaking tub and walk-in shower, ensuring a relaxing retreat. The heart of the home is the eat-in kitchen, complete with an island and breakfast area, perfect for casual dining or entertaining. The combination dining/living area is enhanced by ceiling fans, creating a welcoming atmosphere. An unfinished basement provides ample storage or the potential for future expansion. Set on a generous 0.63-acre lot, the exterior features bump-outs that add character and space. The property includes a storage barn/shed for additional utility. Parking is a breeze with a side-entry attached garage accommodating two vehicles and a driveway with space for five more. Located in a suburban setting, this home is conveniently situated less than 10 miles from the airport and within 5 miles of commuter lots and rail stations, making it ideal for commuters. Enjoy the tranquility of suburban living while being close to essential amenities. This property is a fantastic opportunity for those seeking a blend of space, comfort, and convenience.

3 Beds ⋅ 3 Baths

This charming Colonial-style home in the desirable Lea Eara Farms subdivision offers a perfect blend of comfort and functionality. Built in 1996, this detached residence features 2,050 sq. ft. of living space, ideal for modern lifestyles. The interior boasts three spacious bedrooms and 2.5 bathrooms, including a primary suite with a soaking tub and walk-in shower, ensuring a relaxing retreat. The heart of the home is the eat-in kitchen, complete with an island and breakfast area, perfect for casual dining or entertaining. The combination dining/living area is enhanced by ceiling fans, creating a welcoming atmosphere. An unfinished basement provides ample storage or the potential for future expansion. Set on a generous 0.63-acre lot, the exterior features bump-outs that add character and space. The property includes a storage barn/shed for additional utility. Parking is a breeze with a side-entry attached garage accommodating two vehicles and a driveway with space for five more. Located in a suburban setting, this home is conveniently situated less than 10 miles from the airport and within 5 miles of commuter lots and rail stations, making it ideal for commuters. Enjoy the tranquility of suburban living while being close to essential amenities. This property is a fantastic opportunity for those seeking a blend of space, comfort, and convenience.

407 Maplewood Dr, Middletown

Listing courtesy of Long & Foster Real Estate, Inc.. Contact:

Selling Office: Patterson-Schwartz-Newark.

How much is your home worth?

How much is your home worth?