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 = 3322 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 3322 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 3322 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

119 Lake Shore Drive E
Palm Harbor, FL 34684

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $829,499
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2169 Square Feet
Agency: COLDWELL BANKER REALTY
Agency Phone: (727) 360-6927

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Block
Flooring: Carpet, Tile
Heating: Fireplace
Interior Features: Solid Surface Counters, High Ceilings, Walk-in Closet(s), Eat-in Kitchen, CEILING FANS(S), LIVING ROOM/DINING ROOM COMBO, PRIMARY BEDROOM MAIN FLOOR, SOLID WOOD CABINETS, KITCHEN/FAMILY ROOM COMBO
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Kitchen, Living Room

Window Features

Exterior Features: Irrigation System, Balcony, Hurricane Shutters
Parking Features: Garage, Garage - Attached
Roof: Metal
Waterfront Features: Lake, Waterfront

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: LAKE SHORE ESTATES 1ST ADD

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Generator, Solar Panels, Dock, 3 Car Garage. Directly on Lake Tarpon-The Largest Freshwater Spring Fed Lake in Pinellas County at 2534 acres and Rated as the Best Bass Fishing Lake in Florida. This gorgeous centrally located Waterfront home has a spacious Dock/covered electric lift with a endless Lake Tarpon view. The 3 bedroom, 3 bathroom, 3 car garage features a Kohler home Generator utilizing a 200 gallon propane inground tank, Solar Panels-that are not drilled into the Metal Roof and electric(family room and primary bedroom sliding doors) and manual Hurricane Shutters(rear windows). The gourmet oversized custom kitchen is a chef's dream with custom made solid wood cabinets and stone countertops with a walk-in pantry. The family room, kitchen, dining area, primary bedroom, covered patio and both upstairs bedrooms all look out to the water. Primary bedroom is centrally located on the main floor and has two sinks, bidet, walk-in closet and a $25000 walk-in tub. There are two bathrooms on the main floor and the third full bathroom is on the second floor with the two bedrooms. The brick paver driveway and patio was recently installed. The public streets have recently been paved with new drain gutters. Original owners built this home with no expense spared including having the base earth removed and new fill put in, compacted and elevated to 15'. This is a concrete slab based home and not pillars.
MlsNumber: --
ListingId: U8222505


Listing Provided By: COLDWELL BANKER REALTY, original listing
Phone: (727) 457-3089
Office Phone: (727) 360-6927
Agent Name: Tim Shea
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 = 3322 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Shane Fujimoto
Shane Fujimoto
ASCIIHi Roots Realty
Call Today!: (808) 282-6532

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App