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

550 E East Lake Road N
Tarpon Springs, FL 34688
Michael Choiniere with BHHS FLORIDA PROPERTIES GROUP, original listing - (727) 799-2227

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,850,000
Beds: 5
Baths: Full: 6, ½: 1
Status: Active
SqFt: 7264 Square Feet
Agency: BHHS FLORIDA PROPERTIES GROUP
Agency Phone: (727) 799-2227

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: This spectacular, one of a kind, FULLY FURNISHED Estate offers 12 acres of privacy, security and seclusion! The Estate consists of 2 parcels. The home sits on 5.61 acres and the adjacent parcel of 6.39 acres may be kept as is or is already approved for a second estate! Although built in 2000 the exhaustive list of upgrades and renovations makes this a newly remodeled masterpiece! Freshly painted in 2021, the mansion abounds with hand-carved, custom woodwork with tastefully ornate crown moldings, curved archways and exquisite imported chandeliers. The formal living room features a natural gas fireplace, museum quality aquarium and a huge double-pained picture window that affords views of the expansive resort-style pool area complete with spa and surrounded by gas fueled torch monoliths, and premium Leonardo Travertine and built in mosquito repellant system. A comfortable family room is accented with three sets of French doors and includes a welcoming wet bar. All adjacent to an impressive chef's kitchen with marble and stone surfaces and Wolf/Subzero appliances. Off the family area is the state of the art home theater with sound damping materials with a built in sound system and Sony Laser 4k UHD projector which projects onto a HUGE 2:35 ratio Custom Glass Screen built by Screen Innovations. The theater room houses a complete server rack, PlayStation, Backup power supplies, network switches and full home security DVR system. The house is also fully equipped inside and outside with full Wi-Fi system so you will always be connected to the fastest internet. The DVR can be accessed from your phone while you are home or away so you can always feel safe with this upgraded security system. Additionally, the house is fully equipped with Control 4 Home automation expandable to do anything your heart desires. The north side of the first floor features the impressive master bedroom with its own sitting room and a safe room off one of the master bathrooms. Yes, there are his and hers master bathrooms with massive walk-in closets. The second floor living area features three large bedrooms all with ensuite bathrooms and their own private balconies! The home is minutes from the area's best beaches and the quaint villages of Tarpon Springs, Palm Harbor and Dunedin.
MlsNumber: --
ListingId: U8243800


Listing Provided By: BHHS FLORIDA PROPERTIES GROUP, original listing
Phone: (727) 459-8843
Office Phone: (727) 799-2227
Agent Name: Michael Choiniere
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App