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 = 367 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 = 367 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 = 367 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;

2816 Central Avenue
Big Pine Key, FL 33043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $820,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1482
Agency: Coldwell Banker Schmitt Lower Keys (KW)

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1966
Notes: VA Assumable Loan at 4.125% to qualified VA Buyers. Large fenced parcels are a rare in the Florida Keys!!! This beautiful 3 bedroom 2 bath pool home is on .63 acres offering unparalleled privacy and tranquility. Surrounded by wildlife preserve, this is a nature-lovers dream home in the Florida Keys Wildlife Refuge located inside of the National Marine Sanctuary. This fabulous keys home has so much to offer with almost 1500 square feet of living space including a huge master suite with an updated bath with soaking tub and a massive walk in closet. The super cute galley style kitchen and large adjacent dining area make it easy to prepare gourmet meals and entertain guests. The living area has a working fireplace for ambiance on those few cool weeks we see in the winter. Step outside to enjoy the peace and quiet of your expansive fenced in back yard which is perfect for families with pets. In addition to the in ground pool, you are afforded a tremendous space for outdoor entertaining, landscaping, storing all of your toys, trailers, and RVs. There are many walking and biking trails in the neighborhood where you can see our local wildlife first hand in their natural environment. You can find Key Deer, Great Blue Heron, Egrets, White Ibises, Roseate Spoonbills, Ospreys, and Eagles, as well as the occasional siting of Flamingoes, just to name a few. The community boat ramp is at the end of the street on the back side of the property for your convenience. VA Assumable Loan at 4.125% to qualified VA Buyers only,
MlsNumber: 608111


Listing Provided By: Coldwell Banker Schmitt Lower Keys (KW), original listing
Name: Coldwell Banker Schmitt Lower Keys (KW)
Phone: (305) 872-3050
Office Name: Coldwell Banker Schmitt Lower Keys (KW)
Office Phone: (305) 872-3050
Agent Name: Anneliese Dietrick
Disclaimer: Copyright © 2024 Key West 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App