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;

12090 Thames Avenue
Weeki Wachee, FL 34614

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,099,900
Beds: 4
Baths: 3
Status: Active
SqFt: 3358
Agency: Dalton Wade

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2021
Notes: An Amazing Opportunity to Own this Southern Craftsman Style Home. This Newly Built Home with 4,514 Sqft Under Roof Offers a Wrap Around Front Porch, Double Door Entrance in Foyer, & Wood Tile Floors Throughout Entire House. Very Open Floor Plan with 12ft Ceilings, Large Tray Ceilings, Huge Dining Room with Dormer Adding Natural Lighting into room. This Home Offers 4 Bedrooms, 2 1/2 Bathrooms, 2 Family Rooms, a Large Dining Room & a Bonus Crafts/Game room, Gourmet Kitchen with Platinum Cafe Series Double Oven (w/Air Fry and Convection Ovens), 5 Burner Gas Stove Top, Microwave Drawer, Beverage Refrigerator, 4 Door Refrigerator, Deep Porcelain Sink, Stove Hood Vent, Antiqued White Stacked Cabinets with Glass Doors & an Huge 10ft Island. Main Family room with Stacked Stone Double Sided Gas Fireplace. Split Plan with Large Master Suite, Double Walk-in Closets, Walk In Shower with Frameless Glass, Soaking Tub and Double Vanities. Side Entry Mud Room with 1/2 Bath. Large Laundry Flex Room with Wash Sink and Folding Counter. Second Roomy Family Room in Rear of House Perfect for Movie Nights. 32x16 Bonus Workshop/Dog House - with Separate Meter & 220 Amp Panel. Hookups For Washer and Dryer, Separate Hot water Heater, Fenced Area For Pets. House Backed up with a Generac Whole House Gas Generator. Home is at the End of the Road on 2.3 Acres, Surrounded by Conservation Land. Home Owner Did Not Spare Costs When Building from the Wood Tile to the Lighting Package, This Home is Truly ONE OF A KIND. Call For a Showing Today!
MlsNumber: 2235102


Listing Provided By: Dalton Wade, original listing
Name: Dalton Wade
Phone: (727) 888-4175
Office Name: Dalton Wade Inc
Office Phone: (888) 668-8283
Agent Name: Jon McCall
Disclaimer: Copyright © 2024 Hernando County 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 = 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