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','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 = 3349 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 = 3349 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;

20007 Leonard Road
Lutz, FL 33558

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2126
Agency: Keller Williams Tampa Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: One or more photo(s) has been virtually staged. One or more photo(s) has been virtually staged. New Construction well designed and appointed corner lot house. Masterfully built 3 bedrooms, 2 bathrooms with dedicated office or a 4th bedroom, open and split floor plan with 2126 sq ft heated, covered lanai, laundry room with sink tub and a walk-in pantry. The large open kitchen has solid wood cabinetry, 42' uppers with crown, quartz counters, vented microwave exhaust, Frigidaire Gallery stainless steel appliances, glass top stove, double ovens, gold color handles, glass tile backsplash, island cabinets are blue for appealing contrast, sink in island with designer faucet, a vast island that adds to kitchen seating area. Kitchen is open to a great room that has tray ceiling, 3-sliders that are 16 wide and 8' high provide and incredible amount of natural light to the kitchen and great room areas. Step into the primary bedroom and enjoy a the tray ceilings that affords additional height from the 10' crowned ceilings and 8' single panel glass doors with built-in blinds that lead to your lanai area. A 6' arched entry welcomes you into your primary bathroom that is masterfully appointed with dual vanities across from each other for that personal feel, wood cabinets, quartz counters, oversized frameless glass walk-in shower that is porcelain tiled designed to look like marble and for those days that you just need to wine down and relax a large soaking tub, from the vanities are two walk-in closets. Throughout the house you have 20-mil layered luxury vinyl flooring, 5-1/4 baseboards, Led recessed lighting, wood cased windows, crown molding that enhance the 10' ceilings, porcelain subway style tiles with glass tile inlays in secondary bathroom, niches in tub/showers, brushed nickel designer faucets, all bathroom cabinets are kitchen height, wall to wall closets in bedrooms are solid hung doors, all interior doors have lever door handles and are shaker panel, laundry room has a sink tub, the air conditioning system has been upgrades to a 16-SEER variable speed air handler with WIFI thermostat, Impact windows and entry doors to include sliders for added security, cultured stone accents on exterior, GAF 30-year dimensional shingles, aluminum gutters, vinyl soffits with aluminum fascia, paved driveway and sidewalk up to front door along with the front entry, lush landscape and floratam sod with complete irrigation and fenced for added privacy. All bedrooms have remote ceiling fans with light and primary bedroom has additional recessed LED lighting. There are ceiling fans with light in great room, office and lanai. All you need in this house is to bring your furniture and clothes. This is one of the 3-houses that are available and a low maintenance type of setting and according to the sellers added features will afford many years of enjoyment with minimal concerns with energy efficient enhancements. There are no CDD's or Deed Restrictions to be concerned only a deeded driveway to all 3 houses. Put these houses on your list to see and you will not be disappointed. Easy access to 54, Dale Mabry and 41, schools and shopping. Bedroom Closet Type: Walk-in Closet (Primary Bedroom).
MlsNumber: T3506601


Listing Provided By: Keller Williams Tampa Properties, original listing
Name: Keller Williams Tampa Properties
Phone: (813) 264-7754
Office Name: KELLER WILLIAMS TAMPA PROP.
Office Phone: (813) 264-7754
Agent Name: Jorge Morejon
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 = 3349 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 Stacy Wolfson
Stacy Wolfson
ASCIIeXp Realty - The Wolfson Luxury Group
Call Today!: (813) 240-8888

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App