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

11972 W Riverhaven Drive
Homosassa, FL 34448
Nicole Parker with Dennis Realty & Investment Corp., original listing - (352) 606-3911

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3281 Square Feet
Agency: Dennis Realty & Investment Corp.
Agency Phone: (352) 606-3911

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: This is your fortress in the storm!!! A luxurious waterfront property, just a stone's throw away from DIRECT ACCESS to the Homosassa River and the Gulf of Mexico and is ideal for those who dream of days filled with fishing and boating! This custom 2007 built home by Joe Flynn, has an Engineered foundation on 67 pilings. Walk through the grand double door entrance, and you immediately notice the impeccable attention to detail with freshly painted interior, plantation shutters throughout, the amazing, coffered ceilings, arched doorways, crown molding, and the many windows which offers a bright, airy feeling to the house. Just to your right is an office built for executives with custom built floor to ceiling cabinetry and spacious shelving for displaying awards. To your left a large formal dining room which is just off of your enormous kitchen offering newer high-end, black-brushed stainless steel appliance package, complete with a Hydroviv custom water filtration for the refrigerator water and ice, new quartz countertops, large center island, walk-in pantry, and beautiful wood cabinetry with under cabinet lighting. Your eat-in breakfast nook with large windows overlooking the water, is perfect for family breakfasts and drinking your morning coffee. The kitchen opens up to your expansive living room with floor to ceiling custom cabinetry, with built in gas fireplace, and Florida room complete with solar shades, summer kitchen (bar/sink/built-in BBQ) & commercial exhaust fan; all perfect for entertaining your friends and family. The split-floorplan offers a large master suite with spacious bathroom complete with extensive closet, a roman shower, and gorgeous stained-glass window showcased over the soaking tub. Two more large bedrooms, complete with large walk-in closets, two full size bathrooms with new Corian counters/sinks and linen closets for your guests. Keep everyone safe and comfortable with 3 zoned heating & cooling, 2 zoned surround sound system with built-in speakers, security system, and whole house generator with hook-ups for a second portable generator. Your volume ceiling garage with stand-up attic, built in scuttle stairs, and extra hanging storage is all you need to keep your extra tools/decorations/toys. On the outside, coming back from a day of fishing and boating will be a breeze as you pull your boat up to your newly replaced composite boat dock complete with fish cleaning station, 9000-pound boat lift with remote control, and a place to store your dock supplies and fishing gear accessible at rear of house. On cooler evenings take in your 100 foot-waterfront property and relax by the canal with your friends, sitting around your custom-built fireplace surrounded by the beautiful landscaping, paver pathways and patio. Enjoy all of the extras that the neighborhood of Riverhaven Village has to offer, such as a community park, clubhouse (membership optional) with events, card playing, Pool, Tennis courts, Pickleball, RV/boat parking area and a short distance to the Riverhaven Marina. This gorgeous home has all you need to enjoy all that the Florida lifestyle has to offer. NEW:22 KW Generac whole house generator 2021, HVAC 2022, Luxury carpeting 2021, pavers and landscaping 2019, New dock and Upper deck 2019, Indirect patio column lighting 2019, LG Washer/Dryer 2021 and MORE!!! Home didn't flood during Idalia, or Milton and only had a little water in the garage from Helene!
MlsNumber: --
ListingId: 2241212


Listing Provided By: Dennis Realty & Investment Corp., original listing
Phone: (352) 606-3911
Office Phone: (352) 606-3911
Agent Name: Nicole Parker
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 = 332 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 Trevor Selden
Trevor Selden
ASCIITropic Shores Realty
Call Today!: (352) 201-4383

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App