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

1202 Elderflower Drive
Niceville, FL 32578
Jacob J Foreman with Coldwell Banker Realty, original listing - (850) 974-8687

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2593 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (850) 974-8687

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: STUNNING all brick 4 bedroom 3 bathroom POOL home built by award winning custom builder Andy Wilson in the highly desirable Deer Moss Creek community! This open concept custom built home offers a split floor plan, has numerous upgrades throughout the home, and is situated on a generous 0.26 acre corner lot. On the front and side of the home, there are two covered porches with herringbone brick, beautiful white columns, gas lighting, two car side entry garage, and mature landscaping offering excellent curb appeal. The interior of the home is nothing short of spectacular, offering you both comfort and beauty. The entire home has wood-look tile flooring, recessed lighting, cased doors and windows, tall base boards, built-in plantation shutters, and 10 ft ceilings throughout. As you enter the home, you are greeted by a beautiful foyer with 8 ft custom French doors, crown molding, and coat closet, with plenty of room for an entry table. The large living room is complete with crown molding, a brick gas fireplace with wood mantle and room for a TV above, power plug in floor, and 8 ft French doors that lead to the back porch and pool. The living room blends into the home's dining room and kitchen for the ultimate entertaining. The dining room easily accommodates a table to seat 8 or more with a beautiful chandelier centered over the table. The gourmet kitchen is a chef's dream complete with custom wood extended cabinets with glass doors and lighting, quiet close doors and drawers, two lazy Susan corner cabinets, under cabinet lighting, and HUGE island with farmhouse sink and breakfast bar with seating for four. The kitchen also offers quartz counter tops, beautiful Moroccan tile backsplash, gas cooktop with hood, double oven, French door refrigerator, dishwasher, and microwave. The impressive walk-in pantry offers custom wood shelving with plenty of room for storing food and small kitchen appliances. The home's master bedroom is both spacious and beautiful. The large master boats a brick accent wall with lighting and custom wood ceiling fan. The ensuite bathroom offers a double vanity with quartz counters, custom wood cabinets, and individual mirrors. You will love the stand alone soaking tub, walk-in tiled shower, and shiplap wall with additional cabinetry and towel cubbies. The master bathroom also offers a water closet and LARGE master walk-in closet with wood shelving. Your guests will enjoy a private guest suite with private access on both the interior and exterior of the home. The side porch will gain you access to this guest suite. This offers a generously sized closet, ceiling fan, and private bathroom complete with tiled shower with glass door and vanity with wood cabinetry and quartz countertop. There are two additional bedrooms with spacious closets and wood ceiling fans that share an additional third full bathroom just off of the hallway. You will truly appreciate the storage that this impressive indoor laundry room offers, complete with custom cabinetry, quartz counter tops, wash sink, and pull down stair access to the attic.<br /> This special home has a backyard oasis offering both peace and tranquility. You will love the gunite pool with triple waterfall, bench, and sun ledge with umbrella and lounge chairs, perfect for cooling off on those hot summer days. The pool has a custom hardscape paver patio and custom plant beds that flank the staircase that leads to the covered porch with custom black iron railing, finished floor, outdoor summer kitchen, and lounge area. There is a separate open patio with umbrella just behind the pool. Magnolia trees were added to perimeter of the backyard to add additional privacy. The exterior of the home offers rain gutters, privacy fenced backyard, 8 zone irrigation system, and whole home generator. This home is also quipped with TWO central HVAC systems (with gas heat), Rinnai tankless hot water heater, and foam insulation in the attic. The two car oversized garage offers plenty of room for both cars and is complete with storage system and auto openers. <br /> This home offers tremendous beauty, quality, and value with over $140,000 in UPGRADES!!! Don't let your opportunity to make 1202 Elderflower your personal FOREVER DREAM HOME...schedule your showing TODAY!
MlsNumber: --
ListingId: 975054


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (850) 974-8687
Office Phone: (850) 974-8687
Agent Name: Jacob J Foreman
Disclaimer: Copyright © 2025 Emerald Coast Association of Realtors. 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 = 3221 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Mary Beth Shumpert
Mary Beth Shumpert
ASCIIMotto Mortgage Assurance
Call Today!: (850) 665-0729

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App