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;

30840 Ortega Lane
Big Pine Key, FL 33043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1034
Agency: Berkshire Hathaway HomeServices Keys Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1984
Notes: Welcome to this enchanting 2-bedroom, 1.5-bathroom property nestled in the tranquil neighborhood of Doctors Arm. With a serene ambiance and wildlife views, this home offers the perfect blend of comfort and relaxation.Situated along a picturesque boating canal, residents can enjoy seamless access to the pristine waters, ideal for boating enthusiasts and nature lovers alike. Adding to the allure, the county-owned land across the canal ensures privacy and a sense of exclusivity.Step inside to discover a newly renovated kitchen adorned with sleek stainless-steel appliances, complemented by new bamboo wood flooring that exudes modern elegance. The interior has been freshly painted, creating a bright and inviting atmosphere throughout. Vaulted wood ceilings add a touch of rustic charm, enhancing the overall character of the home.The property features new trex decking and steps, as well as freshly upgraded porch flooring, perfect for outdoor entertaining or simply unwinding amidst the serene surroundings. Additionally, a screened-in porch provides a cozy retreat where you can enjoy the gentle breeze keeping you safe from insects.Equipped with a solar panel system, this home offers eco-friendly living and significant savings on energy bills. Ample storage space downstairs ensures organizational convenience, while the surrounding wooded lots provide a sense of seclusion and tranquility.With easy access to Bogie Channel, this residence promises a lifestyle of convenience and leisure, making it an idyllic retreat for those seeking a peaceful waterfront haven. Don't miss the opportunity to make this captivating property your own!
MlsNumber: 609002


Listing Provided By: Berkshire Hathaway HomeServices Keys Real Estate, original listing
Name: Berkshire Hathaway HomeServices Keys Real Estate
Phone: (305) 743-7636
Office Name: Berkshire Hathaway HomeServices Keys Real Est
Office Phone: (305) 735-4962
Agent Name: Kasey Fey
Disclaimer: Copyright © 2024 Marathon and Lower Keys 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