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

11011 Bourassa Boulevard
Weeki Wachee, FL 34613
Kimberly Pye, PA with HOME LAND REAL ESTATE INC, original listing - (352) 556-0909

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,700,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: HOME LAND REAL ESTATE INC
Agency Phone: (352) 556-0909

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Land-Other
Year Built: --
Notes: INCREDIBLE OPPORTUNITY for a developer to purchase 9.1 acres in the middle of the Lake Hideaway Lagoon Development that is going in with 3700 homes and the country's largest man-made lagoon pool in Hernando County east of US 19 and north of State Road 50 (Cortez). It's approved and land site work is currently being done for 2400 single family detached homes, 644 attached townhouses, 656 senior adult attached housing, a new charter school, community recreation, and for new supportive commercial and office spaces. This 9.1 acre property should be able to be rezoned for high-density residential based on the approval of the surrounding property. Potential for apartments or townhomes. Public sewer and water will be available nearby with the Hidden Lagoon development going in now. The excitement for the coming Hidden Lagoon Community is HIGH, so call for more details! ***Capitalize on this extremely unique opportunity!*** The area offers so much and is a fast growing area!! Only 10 minutes to the Suncoast Parkway/Veteran's Expressway for easy and fast access to Tampa! Straight drive to Tampa International Airport which is only 45 minutes!! 10 minutes to the beach and sunsets and Pine Island! 5 minutes to kayaking, paddle-boarding, swimming in the the crystal clear Weeki Wachee Spring and River with the manatees or enjoy the Weeki Wachee State Park on the main spring head with Buccaneer Bay Water Park with tubing, slides, splash park, boat rides, and the world-famous Live Mermaid Shows! 10 minutes to Hernando Beach Coastal Community for boating, fishing, swimming, water sports, jet-skiing, hanging out on your boat at the flats with other boaters, beach bars and restaurants!! A short boat ride from Hernando Beach takes your to Anclote Island for an amazing day at the white sand and glowing clear waters of the island! Travel North from this site 10-20 minutes and enjoy Homosassa River and Crystal River swimming the clear springs with the manatees and eating at the restaurants/bars on the river...pull your boat right up to the tiki bars!! Quaint historic towns in every direction from Brooksville, Inverness, Crystal River, Dade City and more...enjoy the old town squares with coffee shoppes, antique and decor shoppes, festivals, craft and art shows, music concerts and so much more! The area offers so much and yet is so close to Tampa! Just over 1 hour to TOP US BEACHES!! Call today for more details!
MlsNumber: --
ListingId: W7868031


Listing Provided By: HOME LAND REAL ESTATE INC, original listing
Phone: (352) 279-1150
Office Phone: (352) 556-0909
Agent Name: Kimberly Pye, PA
Disclaimer: Copyright © 2024 Stellar MLS. 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 = 350 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;
Real Estate Expert Photo for Lori Penisse
Lori Penisse
ASCIITropic Shores Realty
Call Today!: (585) 309-0857

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App