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

13620 Lockport Street
Hudson, FL 34667
Elizabeth Casner with TROPIC SHORES REALTY LLC, original listing - (352) 684-7371

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4036 Square Feet
Agency: TROPIC SHORES REALTY LLC
Agency Phone: (352) 684-7371

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1973
Notes: One or more photo(s) has been virtually staged. This is Home is Truly Spectacular. As you tour, you will be in awe! With Over 5 Bedrooms & 5 Bathrooms and multiple Bonus rooms it also includes a beautiful family room with Brick Fireplace that doubles outside by the pool as your own Smoker. As you come down the road to the end and see your private Estate, you pull in driveway #1. You will first notice the 4+ Car Garage and the beautiful hand laid brick that makes this house so Amazing. Enter through the Wrought Iron gates to your private breezeway between the Home and Garage #1 to come in your Entertaining room with a Pool Table, Multiple Hidden Closets and all the benches open for Extra Storage! Or you can go around front to your Solid Wood Double Door entrance into your foyer. Next to your Game room is your Inside Laundry Room, a Bathroom and one of the many room you can use as your office!! Come around the hallway to check out your Formal Dining Room, then Living Room and Family room and open Concept Kitchen. Check out all that counter space and enjoy the Corian Countertops and storage galore.<br /> One the First Floor is your Master Bedroom with Private EnSuite and a door to your Hot Tub which around the corner leads to your Pool. The bathroom is Very Unique with an Oversized Tub, Smaller Shower, double sinks and Private Bidet! Lots of storage in this Primary Bedroom with dual closets!! Head upstairs to your Loft Area and chose from 4 Nice Sized Bedrooms each sharing a Jack-n-Jill Bathroom.<br /> Outside one will be Amazed at the Gorgeous Paver Pool Deck with over 1,300 sq ft to relax and entertain or jump into that Giant Pool boasting over 9 1/2 Feet Deep! Pass the pool and head towards to Pool House and the 720 sq ft Greenhouse and Raised Garden Beds area (4 Commercial Garage Doors 2-10', 1-8' & 1-7'). Greenhouse needs lots of love but has so much potential. Very unique plants, trees and Muscadine Grave vines grow wild all over this property giving you so much privacy - Maybe it time you start making your own wine! Go past the Greenhouse and enter into your Oversized Garages (Over 2,700 sq Ft) with Multiple Door Entrances and your Business Office nestled Inside. Check out the the 11' well-built Commercial Shelves in their to store all of your Company's or Family's needs! This home's owner with Commercial Construction builders and built everything on the Property to the Best it Could Be! They hand laid the pavers around the pool to hand laying every Brick of the home to make these Garages Fit for anyone who wants to run their Large business out of their home but be separate from the Home. There is a Separate Driveway for work vehicles to enter on the property to get you to your Offices & Garages in the Back. Enjoy this very Private & Secluded Home and the end of the street right off of County Line Road and just a few miles from the Veteran's Expressway with a new Roof on the Home, 3 newer AC Units and lots of Extra. This home needs updating & some love but the potential is Endless. This Home is owned by the original people who built it in 1972-73. They were a Top Construction Company and put a lot of extra details and the Best of Everything in this home. Come enjoy a Truly Unique Home that offers the new Owners the Endless Opportunities to have a Business on their property and so much room to Grow. <br /> Enjoy Tranquility, Serenity, Opportunity and more in this One-Of-A-Kind Home built leaving nothing out. Great Place to work & Play! Hurry, this Estate will not Last!
MlsNumber: --
ListingId: W7865108


Listing Provided By: TROPIC SHORES REALTY LLC, original listing
Phone: (727) 599-9129
Office Phone: (352) 684-7371
Agent Name: Elizabeth Casner
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 = 374 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 Danielle Cockman
Danielle Cockman
ASCIIKeller Williams Realty - The Dani's Dream Homes Team
Call Today!: (813) 446-8136

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App