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;

3225 Bay St
Gulf Breeze, FL 32563

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,682,500
Beds: 5
Baths: 6
Status: Active
SqFt: 6216
Agency: Levin Rinke Resort Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2001
Notes: Welcome to Oriole Beach with its own Boat Ramp just .10 mile from your future Home! This Waterfront Home boasts over 6000 SF of Versatility, Spaciousness, and Strength. Hardie Plank Siding on all 2” X 6” Framing on Concrete Slab and 12” pilings. All 4 Levels, bright with natural lighting, share amazing views of Santa Rosa Sound! Each level has its own HVAC system for easy climate control. The 1st Floor features a 3-Car Garage with one garage bay conditioned ready for a hobbyist shop. Ground floor has a potential Income producing apartment with a Living area, Kitchen, (2) Sleeping Rooms, Full Bath, plumbed and wired for an extra laundry serving your potential AirBNB guests and access onto the covered porch facing the tranquil seascapes of the Santa Rosa Sound. The 2nd Floor is the Main Living area of the home which includes high ceilings in an open floor plan, a Living Room, Kitchen w/Stainless Steel Appliances and Granite countertops, Dining area, with substantial granite countertop separating kitchen/living area, Large Laundry room/Pantry, (2) large bedrooms separated by a full bath, and a 1/2 Bath! There is a full sundeck access including stairways on each side of the home that lead to the circular driveway area. The 3rd Floor also features high ceilings, a large Office/Study, a huge Master Suite, leading to its own deck with great views, (2) walk-in closets, large bath with large garden tub, separate shower and (2) separate sinks. There is a large guest bedroom/bath and an additional bedroom. The 4th Floor wins the day as a possible multi-purpose area, such as a recreation room, extra office space, gym/workout room, media room. There are conditioned knee-walls for an abundance of storage, as well as a stubbed-out full bath. A Built-in Elevator Shaft exists in the structure for a future elevator installation. If extra storage is necessary, there is a large, detached storage shed on site for your convenience. Your dream of living on the water has just come true!
MlsNumber: 640214


Listing Provided By: Levin Rinke Resort Realty, original listing
Name: Levin Rinke Resort Realty
Phone: (850) 916-5050
Office Name: Levin Rinke Realty
Office Phone: (850) 916-5050
Agent Name: Donovan White, Jr.
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