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

18240 Riverchase
Alva, FL 33920
Scott Levine, LLC with Premiere Plus Realty Co., original listing - (239) 732-7837

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,599,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4062 Square Feet
Agency: Premiere Plus Realty Co.
Agency Phone: (239) 732-7837

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Talk about WOW factor! You will feel like you are living in a 5 Star Resort. This magnificent home, situated on 1.5 acres, is located in the desirable community of Riverwind Cove in Alva. The owners have spared no expense with upgrades galore to create this exceptional property. Professionally landscaped and overlooking a lake, prepare to be captivated by the views from inside and out.<br /> Grand double door front entry, large foyer leading to the great room, and remodeled gourmet kitchen featuring a huge island, premium granite surfaces, stainless steel appliances, and a gas range. Perfect for entertaining large groups or small family gatherings. Walls of windows allow natural lighting and bring the pool area into full view.<br /> The master suite is a living space unto itself. The bedroom is large enough for a sitting area and has a private pool/lanai entrance. The master closet is enormous with his and hers entrances as well as built in cabinetry. the master bath has separate his and hers vanity areas, jetted jacuzzi tub and an extra-large alcove shower with multiple spray heads. Water closet includes a bidet.<br /> All guest bedrooms are full size with nearby bathrooms. Family room features 20-foot ceilings and extra-large sliding doors to the pool area. Formal dining room, eat in kitchen and an office near the master suite. Additionally, has a wet bar with wine cooler. Coffered cathedral ceilings surrounded by crown molding give the feel of a mansion not just a home.<br /> The custom designed inground saltwater pool features an adjoining spa and fountain. The pool area is fully screened and has a dedicated pool bathroom.<br /> The oversized 3 car garage features vinyl flooring tile, large work area with cabinetry, climate control and an EV charging port.<br /> All windows and doors are Andersen double glazed Low-E glass.<br /> Safety features include certified hurricane accordion shutters for all openings, whole house security monitoring, ring camera at the house perimeter, and a 12K propane generator for emergency power.<br /> You'll be amazed at what this home has to offer. There are too many extras and upgrades to list. This home can be purchased fully furnished. Everything has been taken care of; all this home needs is you.
MlsNumber: --
ListingId: 224075110


Listing Provided By: Premiere Plus Realty Co., original listing
Phone: (239) 451-1901
Office Phone: (239) 732-7837
Agent Name: Scott Levine, LLC
Disclaimer: Copyright © 2024 Naples Area 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App