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

3615 Ward Basin Rd
Milton, FL 32583

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,079,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2548
Agency: Service Matters Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2002
Notes: WANT PRIVACY AND A PERMANENT VACATION WITH TROPICAL PAINTED SUNSETS & FREQUENT VIEWS FROM YOUR DOCK OF DOLPHINS JUMPING AND SPLASHING?! Then this BEAUTIFUL WATERFRONT home overlooking Blackwater Bay is THE ONE! Located on OVER 7 ACRES the property has approx. 250 Ft. of WATERFRONT on PRISTINE BLACKWATER BAY - Minutes from I-10 and close to Malls, Hospitals and the beautiful "sugar sand" beaches of Pensacola and Navarre. Home features a NEW Roof in Nov 2017, a NEW Water Heater in 2018, a 36'x18' POOL w/ Screened Enclosure, HUGE 36'x23' THREE CAR GARAGE w/a 1/2 Bathroom just off the Pool Deck, a large 28'x24' metal DETACHED GARAGE/WORKSHOP, a DOCK w/BOAT HOUSE & LIFT and an approx. 1/3 acre Fish Pond!! The KITCHEN features lots of Cabinet Space, Corian Counter Tops, Double Oven, Cooktop, Built-in Microwave, Refrigerator, Dishwasher, Trash Compactor and Breakfast Bar. Enjoy your morning coffee in the large Breakfast Room just off the kitchen with access to the pool deck. The Living Room w/Wood-Burning Fireplace flows nicely into the Formal Dining Area providing a Roomy and Open Entertainment Space for family and friends. Just off the living room, overlooking the MANICURED BACKYARD and BEAUTIFUL BLACKWATER BAY is the 9'x27' Family Room/Sunroom great for relaxing and enjoying the GORGEOUS SUNSETS! The Master Bedroom Suite features a large Walk-in Closet and Master Bathroom w/dual vanities, cultured marble counter-tops, Separate Shower and Jacuzzi Garden Tub. The Two Additional Bedrooms are split from the Master Bedroom and are serviced by a hall bathroom. The Utility Room has Storage Cabinets, Deep Sink, Built-In Ironing Board and the Washer & Dryer stay! Hurricane shutters on bayside windows and front door only. DON'T MISS OUT! ENJOY UNBELIEVABLY GORGEOUS SUNSETS while sitting on your DOCK or launch your boat and enjoy sunsets from the middle of Blackwater Bay! SO MUCH ROOM, SO MUCH PRIVACY and an INCREDIBLE "WATER RECREATION PARADISE'! SEE IT AND MAKE IT YOURS TODAY!!
MlsNumber: 628286


Listing Provided By: Service Matters Realty, Inc., original listing
Name: Service Matters Realty, Inc.
Phone: (850) 889-1529
Office Name: Service Matters Realty, Inc.
Office Phone: (850) 889-1529
Agent Name: Suzanne Morgan
Disclaimer: Copyright © 2024 Pensacola 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 = 380 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Georgia Koehler
ASCIIRE/MAX Infinity
Call Today!: (850) 889-5527

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App