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 = 1185 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1185 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 = 1185 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

20750 N River Road
Alva, FL 33920

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,149,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3748 Square Feet
Agency: Barclays Real Estate Group 1
Agency Phone: (239) 201-2607

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Oven, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer, Ice Maker
Architectural Style: Other
Construction Materials: Vinyl Siding, Frame
Cooling: Ceiling Fan(s)
Flooring: Tile
Heating: Central Furnace
Interior Features: Pantry, Security System, Builtin Features, Main Level Primary, Workshop, Attic, Separate Shower, Cathedral Ceilings, Breakfast Bar, Split Bedrooms, Pull Down Attic Stairs, French Doors Atrium Doors, Walk In Closets, BATHTUB, HOME OFFICE, CLOSET CABINETRY, Living Dining Room, Walk In Pantry, Sitting Areain Primary
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Security Features: Security System

Window Features

Exterior Features: None, Storage
Parking Features: Garage, Paved or Surfaced, Driveway, Guest
Other Features: Storage
Roof: Metal

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: ALVA

Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Enjoy this 5 acre equestrian estate! It has it all including in ground pool, multiple out buildings including 2 all steel barns (60x60 and 30x40) with oversized roll-up doors. Enjoy family moments on the covered porches. Property is fully fenced and crossed-fenced, it has electronic gated entry and security system with cameras. Escape the hustle and bustle, cultivate your own crops, enjoy your privacy. Bring the chickens, goats, cows and live the homestead lifestyle. This property is suitable for it all. Located near bike & horse riding parks and arenas and 1 mile from a boat ramp. Home is in a non-flood zone, is eligible for AG EXEMPTION, offering potential tax benefits. This thoughtfully remodeled home prioritizes easy maintenance with tile floors throughout. The kitchen is a culinary haven, complete with an induction cooktop, convection oven, walk-in pantry, tons of granite counter space with roll out cabinet shelves. The living room accommodates your entire team for game day. This home truly defies description. Beyond the 4 beds and 3 full baths there is a huge rec with bonus room, office, gym or studio, could be 5th bedroom or guest suite. Large closets in each bedroom with custom closet organization, storage galore. There is a whole house RO system, 2 HVAC systems, 2 RV hookups and so much more. If you are not looking to house horses or livestock these barns offer a fantastic space to use as a workshop, storage space and/or a place to house that car collection or even store your business equipment/inventory. Less than 1 mile to Alva elementary and community parks. Check out the virtual tour and Matterport tour too. There is a lot to see. Owners negotiable.
MlsNumber: --
ListingId: 223077980


Listing Provided By: Barclays Real Estate Group 1, original listing
Phone: (239) 672-1699
Office Phone: (239) 201-2607
Agent Name: Laurel ONeill
Disclaimer: Copyright © 2024 Florida Gulf Coast Multiple Listing Service, 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 = 1185 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 Stephen Antonelli
Stephen Antonelli
Call Today!: (443) 840-7502

Local Mortgage Pro

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 = 1185 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;
Jason Mattingly
ASCIILakeview Mortgage Bankers
Office: (443) 534-8329

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App