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

37997 Millwood Drive
Woodlake, CA 93286
Robyn Icenhower with Keller Williams Realty Tulare County, original listing - (559) 733-4100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $874,900
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3037 Square Feet
Agency: Keller Williams Realty Tulare County
Agency Phone: (559) 733-4100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Discover your slice of paradise with this exceptional country home, nestled on 12.77 acres of picturesque land. With breathtaking views framed by floor-to-ceiling windows, this two-story gem checks all the boxes.<br /> <br /> Step into the heart of the home, greeted by an abundance of natural light and open space. The updated kitchen awaits, featuring sleek countertops and state-of-the-art appliances perfect for culinary adventures. On the main floor, the expansive primary suite is a true retreat, boasting exquisite design and ample space to unwind in style. With two additional bedrooms on the main floor plus two bedrooms on the second floor the home is built with functionality in mind.<br /> <br /> Outside, the property truly shines with its top-notch equestrian amenities. The impressive riding arena and multiple pastures are ideal for both seasoned riders and beginners alike. Two well-equipped tool sheds and a spacious barn ensure you have everything you need to maintain your country lifestyle with ease.<br /> <br /> Relax and entertain in style by the stunning pool, where a natural rock waterfall provides a serene backdrop. An outdoor restroom adds convenience for poolside gatherings, making this space perfect for hosting friends and family.<br /> <br /> Embrace the tranquility and beauty of country living with every modern convenience at your fingertips. This extraordinary property offers a rare blend of luxury, functionality, and natural beauty—come and make it yours today!
MlsNumber: --
ListingId: 231344


Listing Provided By: Keller Williams Realty Tulare County, original listing
Phone: (559) 372-9713
Office Phone: (559) 733-4100
Agent Name: Robyn Icenhower
Disclaimer: Copyright © 2024 Tulare County MLS. 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