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

10484 Gypsy Avenue
Weeki Wachee, FL 34613

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,799,900
Beds: 8
Baths: 5
Status: Pending
SqFt: 6295
Agency: Home-Land Real Estate Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Under contract-accepting backup offers. COME FALL IN LOVE!! INCREDIBLE DREAM PROPERTY --- THIS ONE HAS IT ALL AND SO MUCH MORE!! Huge stunning COUNTRY (Tuscany feel) CUSTOM ESTATE HOME with 8 bedrooms + 4.5 bathrooms + attached 2-car garage with huge gym/mancave and air conditioning (53x23) + in-law suite + theater room + private pool + spa + amazing outdoor living space + 9 stall center-isle horse barn + MASSIVE detached garage with lift + another 3-car detached garage with air conditioning + huge pole barn all nestled behind a private gated fence with a PAVED driveway on 5 acres tucked away in a highly desirable area with NO HOA and NO FLOOD! Wow...hard to even say it all! A MUST SEE!!! MAGAZINE WORTHY!! Car collectors, equine enthusiasts, large families...this offers so much!! Well constructed 2-story block home with insulation and siding! MOST AMAZING ENTRANCE and front porch! Double height soaring ceilings in the foyer greet your guests! Impressive family room with large beam ceilings and rock fireplace like you see in a lodge! Large upgraded kitchen with granite countertops, breakfast bar, copper sink, stainless steel appliances to include new double built-in convection ovens, Electrolux cooktop, large island with prep sink, real wood cabinets, media nook and large walk-in pantry! Formal dining room + breakfast nook! TWO offices off the kitchen for the families that work from home or use the rooms to fit your family's hobbies and desires! Gun room! Large laundry room with upgrades, tub and granite. Large lanai (21x12) outside by the pool + large matching outdoor pavilion for entertaining and relaxing by the pool! In-law suite with full living room and pool access downstairs or use it as a master bedroom downstairs! HUGE master suite upstairs with it's own living room, INCREDIBLE ensuite bathroom with real wood cabinets, granite countertops, an inviting jetted tub, huge walk-in shower, stone sinks, designer faucets and lighting, and walk-in closets to-die-for! Upstairs also offers 4 additional bedrooms + 2 bathrooms + theater room!! All the bathrooms are upgraded and stunning! Tray ceilings! Barrel ceilings! Pool and spa are heated (2 heaters). Chlorine pool is 7' deep at one end. Center isle (concrete) barn (36 x 96) with 9-stalls (clay/mats 12x12 stalls). Feed/tack rooms, wash station, covered trailer parking (24 x 36) and RV hookup! Kennels, too, 4 of them! 4 pastures (one is a riding pasture), 3 separate lean-tos in the pastures for covered shelter! Crossed board fenced and no climb fence! The ENORMOUS GARAGE (40 x 80)with pull through bay doors and 24" deep concrete floors and intense construction quality offers a lift and a space big enough to store 16 cars or whatever toys you can bring! Bring it all! AR Zoning with NO HOA...so bring all the toys, RVs, campers, boats, horses, chickens, animals...bring it all! NEW ROOF in 2019!! NEW AC unit(s) 2019!! Swimming pool and hot tub 2020!! This is an AMAZING PROPERTY!! You have EVERYTHING and more! Close to shopping, groceries, hospital, movies! Currently zoned for the county's newest schools Winding Waters K-8 and Weeki Wachee High School! 10 minutes to the Suncoast parkway for easy and quick access to Tampa! 40 minutes to Tampa Airport! 1 hour to TOP US BEACHES! 10 minutes to sunsets at Pine Island! 3 minutes to the State Park for kayaking the crystal clear Weeki Wachee River! Fishing, boating, water activities! Relax, enjoy your life, everything you could ever want is right here on this stunning property! Come see!
MlsNumber: W7857178


Listing Provided By: Home-Land Real Estate Inc., original listing
Name: Home-Land Real Estate Inc.
Phone: (352) 556-0909
Office Name: HOME LAND REAL ESTATE INC
Office Phone: (352) 556-0909
Agent Name: Kimberly Pye, PA
Disclaimer: Copyright © 2024 West Pasco Board of Realtors. 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 = 350 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 Carlos Nunez & Adam Brandt
Carlos Nunez & Adam Brandt
ASCIIBerkshire Hathaway HomeServices Florida Properties Group
Call Today!: (413) 454-3287

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App