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;

4210 W Horseshoe Drive
Beverly Hills, FL 34465

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 3
Baths: 2
Status: Active
SqFt: 2596
Agency: REALTRUST REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2004
Notes: CHARACTER IS WOVEN THROUGHOUT THIS CHARMING CUSTOM DESIGNED, METICULOUSLY MAINTAINED HOME, MAKING IT A WELCOME HAVEN FOR EQUESTRIAN ENTHUSIASTS. YOUR DREAM HOME INCLUDES 3 BEDROOMS, 2 BATHS, 2 LARGE LIVING AREAS, 2 CAR GARAGE and 2 CAR DETACHED GARAGE PINE RIDGE HOME ON 2.22 ACRES FULLY FENCED HOME SITE W/2 STALL BARN THAT HAS DIRECT ACCESS TO OVER 28 MILES OF MAINTAINED, EQUESTRIAN ONLY, DEED RESTRICTED, RIDING TRAILS. This home is move in ready for you and for your horses! This custom designed home has too many attributes to list here (Please See Picture Section) but the highlights include: A Metal Roof. Your kitchen w/plenty of counter space (Granite) & cupboard/drawer space (Wood), stainless appliances, large pantry, and an eat in area. The Master Suite offers privacy from the rest of the home with a large walk-in closet. plenty of windows for natural light, and your private Bath Suite. Your Living Area includes both a large Living Room/Dining Room and another separate Family/TV Room. Both have Wood Fireplaces and are private from each other. Plenty of room for everyone to enjoy. But wait, we’re not done yet... There are 2 Additional Bedrooms and a full bath. The 2nd Bedroom has lots of room for your furniture and a nice size closet while the 3rd Bedroom has a large walk-in closet. Now let’s talk about outdoor space. You will LOVE your Covered Lanai that overlooks your expansive back yard. With 2 Garages, you will plenty of space to store your cars and/or toys. But the icing on the cake is your expansive 2.22 Equestrian homesite with a 2 STALL BARN that is ready for your horses or other fury friends today. As mentioned, the perimeter is fully fenced along with Two Pastures, Front Yard Area, and Holding Area, and The Trail is accessible from your back gate. Did I mention that it has numerous flowering trees/bushes, concrete driveway, well for irrigation, metal roof, and the best news of all is offers tons of privacy. The minute you pull into the driveway you will know you and your horses have come home!
MlsNumber: 832280


Listing Provided By: REALTRUST REALTY, original listing
Name: REALTRUST REALTY
Phone: (352) 770-7002
Office Name: REALTRUST REALTY
Office Phone: (352) 770-7002
Agent Name: David E Collins
Disclaimer: Copyright © 2024 REALTORS Association of Citrus County, 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;
Nancy Minch
ASCIILocal Realty Services, LLC
Call Today!: (757) 642-6847

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App