Title Page Background
DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => agent ) BEFORE: Site: 350 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => lender ) BEFORE: Site: 350 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 350 [1] => [2] => [3] => other ) BEFORE: Site: 350 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 350 Igate: njhud LocID: 350 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 350 AND i.igate IN ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

Foreclosure: 9460 Bearfoot Trail
Weeki Wachee, FL 34613
Carl Aiduck with DALTON WADE INC, original listing - (888) 668-8283

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $945,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 5502 Square Feet
Agency: DALTON WADE INC
Agency Phone: (888) 668-8283

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Luxury Living at its Finest. Exquisite three bedroom, three bath Executive Estate with Pool & Spa on 1.3 Acres. Welcome to this stunning 5,502 sq. ft. executive estate, nestled on a beautifully landscaped 1.3-acre lot in quite Woodland Waters . From the moment you enter, you’ll be captivated by the elegance and sophistication this home exudes. Featuring spacious bedrooms, luxurious bathrooms, and a perfect blend of formal and casual spaces, this residence is designed for both comfort and entertainment.<br /> Upon entrance, you are greeted with the elegance and numerous details including multiple chandeliers, custom floor inlays, even in the pool, floating wet bar, numerous fireplaces tray ceilings, crown moldings and custom painting. The gourmet kitchen includes marble counter tops center island cook top, built in built oven, microwave, refrigerator and large walk-in pantry with floating soffit.<br /> The master suite includes a spacious bedroom with dual closets, tray ceilings crown moldings, a sitting room for private relaxation, a luxurious bathroom with dual double sink vanities, Jacuzzi tub, large shower with waterfall spray head and full height tile walls with custom accents.<br /> The library/office with it’s built-in shelving provides a quiet work space or peaceful reading area.<br /> Entertainment and relaxation are built into this luxury estate, the game room includes an indoor BBQ grille with rotisserie, two prep sinks, gas range, microwave, fireplace still leaving plenty of space for a pool table. Adjacent to the game room is a carpeted home theater with two tier seating and mood lighting. <br /> All the main living areas open onto the outdoor oasis, resort style pool patio deck, perfect for unwinding and hosting guests. The permanent glass table, outdoor shower and access to the exercise/towel room just add to the comfort of this feature.<br /> Additional features include central vacuum cleaning, tankless water heater, three car garage with mop sink and storage closets. <br /> Every corner of this home reflects quality craftsmanship, from the custom glass-block showers to the elegant accent columns and wall sconces. Whether you’re hosting a dinner party in the formal dining room or enjoying a quiet evening in the library, this home offers the perfect balance of luxury and functionality.<br /> Don’t miss the opportunity to experience this one-of-a-kind estate. Schedule your tour today!
MlsNumber: --
ListingId: TB8369472


Listing Provided By: DALTON WADE INC, original listing
Phone: (813) 482-6710
Office Phone: (888) 668-8283
Agent Name: Carl Aiduck
Disclaimer: Copyright © 2025 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