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

19003 Apian Way
Lutz, FL 33558
Toby Caroline with SUN N FUN REALTY, original listing - (813) 428-6992

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $929,950
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3044 Square Feet
Agency: SUN N FUN REALTY
Agency Phone: (813) 428-6992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: STUNNING CONTRACTOR BUILT AND OWNED this 3 bedroom, 3 full bath, 3 car garage home on a large 147' x 127' lot has just been freshly painted. Owner spared no expense and built it with heavy insulation for low monthly electric bills. Mahogany kitchen cabinets and top of the line Granite counter tops throughout, stainless appliances, built-in Mahogany entertainment center with a custom designed $8,000 etched glass the length of the family room built-in entertainment center. Beautiful Travertine and wood flooring through out. A real wood burning Fireplace, large inside laundry room, crown molding and a Disney style rock/Grotto water fall formation over spa and swim up area with walkway into pool that leads to the custom designed and built Bar-B-Que bar and grill area with plenty of room to chill out. Pool bath is complete with a shower, commode and sink. The larger than life Master bedroom leads to the pool and heated spa via sliding glass doors adorned with custom Plantation shutters. 2 Master walk-in closets with custom shelving plus his & her separate vanities, Roman tub and separate glass and tile walk in shower. Plantation shutters throughout. Spiral staircase leads to the Bonus room that could be an additional office, but was built for a playroom with lots of storage area. Oversized functional custom kitchen allows for entertainment with long eat at counter with matching bar chairs. Beautiful built-in dry bar gives plenty of display, cabinets and drawers. Plantation shutters on sliding glass doors leading to the pool/spa and Bar-B-Q entertainment area. Ceiling fans and surround sound throughout. Ultra energy efficient with 18 seer heat pumps, insulated glass and polar foam roof, attic and block cores. The super oversized paver driveway can accommodate multiple cars with matching paver walkway to the front door. WOW - 880 SF (28.5' x 28.1') garage with 9 foot high doors, epoxy floor surface and workshop space. Located in a gated community of only 17 custom homes. Owner is downsizing. There are just too many upgraded features in this beautiful home to list. Call for your personal tour. Owner can provide original building specs, floor plan and lot information.
MlsNumber: --
ListingId: U8254933


Listing Provided By: SUN N FUN REALTY, original listing
Phone: (813) 781-6888
Office Phone: (813) 428-6992
Agent Name: Toby Caroline
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS®, Inc. 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 = 3349 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Jocelyne Yanez, Hablo Español
Jocelyne Yanez, Hablo Español
ASCIIHomeSmart
Call Today!: (845) 653-6117

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App