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

22152 O'brien Road
Howey In The Hills, FL 34737

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,250,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2296
Agency: ERA Grizzard Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2004
Notes: ANYTHING IS POSSIBLE at this one-of-a-kind property! With a little over 10 ACRES (zoned A - Agricultural), this property can meet the needs of most any buyer! There are 2 parcels being sold all together here! A BEAUTIFUL home with many upgrades sits on one parcel. With almost 2300 square feet and DOUBLE MASTER BEDROOMS, one of which could act as an IN-LAW Suite with a separate entrance, this home is tucked away privately at the back of the first 5 acre parcel. With a NEW ROOF in 2023 as well as a HYBRID WATER HEATER (2023), no expense has been spared to keep this place in tip top condition. The floor plan is split with 2 bedrooms, a bathroom and an office on one side of the house, and the two master bedrooms on the other side of the house. The kitchen appliances are also top of the line with a convection mircrowave and double oven range. The drinking water is absolutely fabulous straight from the tap. The POOL/HOT-TUB was just resurfaced in 2023 and has solar panels to keep everything nice in comfortable, even in the winter! The BEAUTIFUL PAVER DECK adds elegance to the space. There are SURROUND SOUND SPEAKERS in both masters and in the living room. They are mounted flush in the ceiling. There is also a 288 square foot STORAGE SHED on this parcel along with a pump house that houses 2 out of the 3 WELLS on the property and a diesel pump.<br /> <br /> On the 2nd parcel (Address: 22146 O'Brien Rd. Howey-in-the-Hills, FL 34737, TAX ID: 14-21-25-0002-000-02300) there is SO MUCH TO OFFER!! There are two mobile homes on this parcel, one single-wide and one double-wide (New roof 2020) that have income producing potential. There is also a RED BARN with other 1500 sq feet and 3 bays and a 5 inch slab for heavy machinery. There is another warehouse that is about 3000 square feet. Within this warehouse, there is a 1/1 apartment with a kitchenette. At the front of this parcel is an adorable storefront from the days when the property had an active u-pick blueberry field. This storefront is around 700 square feet with an 8x8 walk-in refrigerator, 2 bathrooms (one for guests and one for staff) and a kitchen, complete with a microwave, range and under counter refrigerator. To the left of the building is the 3rd well for the property. This well is currently supplying water to the house and mobile homes and has impeccable water. As you pull in the front gate, you will see all the infrastructure for what was about 4.25 acres of blueberry and peach fields. Everything is still there and in working order if your dream is to be a farmer. The underground lines just need to be attached. The seller may be willing to sell some furnishings and/or equipment as well. Take a look at this UNIQUE property!! THE POSSIBILITIES ARE ENDLESS!
MlsNumber: G5079817


Listing Provided By: ERA Grizzard Real Estate, original listing
Name: ERA Grizzard Real Estate
Phone: (352) 504-0055
Office Name: ERA GRIZZARD REAL ESTATE
Office Phone: (352) 787-6966
Agent Name: Lindsay Sellars
Disclaimer: Copyright © 2024 Stellar MLS. 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 = 358 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 Jenny Mae Murphy
Jenny Mae Murphy
ASCIIKELLER WILLIAMS KEY WEST COMPASS REALTY
Call Today!: (305) 619-7706

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 = 358 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;
Real Estate Expert Photo for Michael R. Miller, NMLS#1730402
Michael R. Miller, NMLS#1730402
ASCIICrossCountry Mortgage, LLC
Call Today!: (330) 328-4084

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App