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

9415 21st Avenue
Lemoore, CA 93245
Laura Silveira with Lemoore Real Estate, original listing - (559) 924-8355

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,300,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2550 Square Feet
Agency: Lemoore Real Estate
Agency Phone: (559) 924-8355

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 58 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1987
Notes: Exquisite country property in a private secluded setting that borders along the South Fork of the Kings River. Set amongst mature oak trees, the park like setting has 3500 feet of river frontage and is surrounded by almond orchards. The private 3 bdrm 3 bath home has 2550 sq ft with room to grow, and was custom built by Tom Sippel. This beautiful, pristine home features a separate living room, family room and dining room with high beamed ceilings and spectacular views of the outdoors. The entry way leads into the family room with an open floor plan, gorgeous brick fireplace, built-in book case and double French doors that open onto to a covered patio. The well-designed kitchen has a long-angled breakfast bar and bay window nook for table seating with views of the backyard. Included are newer GE Profile kitchen appliances, a refrigerator, washer and dryer. Spacious laundry room located off the kitchen with multiple pantries, cupboards, deep sink, drying rods and counter top plus a 3rd bathroom with convenient outdoor access. Bedrooms have built-in desks, cabinets, shelves and walk-in closets; front bedroom features a bay window seat. Large master suite with high ceilings and cozy fireplace area. The private master bath has double walk-in shower, built-in linen cabinet and lots of natural lighting. The bath extends into the walk-in closet featuring birchwood built-ins for extra storage and display. Master bdrm has double doors leading out to an extended shaded patio ideal for outdoor dining by the water fountain. The landscaped backyard is fenced and steps down into a large private garden, gardening shed and chicken coop. Both front and back yards have beautiful mature oak trees. A riding lawnmower is included for the large grassy areas in the front and back. The side yard is equipped with solar outdoor lighting, planter boxes and work space for market gardening. Further out is a 15000 sq ft garden space ready to grow flowers and vegetables. A John Deere 4400 tractor is available for purchase, plus attachable equipment to work the large garden. The property is located in the highly sought after Island School district, 3 miles from the fire station. The listing includes nearly 60 acres of land which is leased and planted with almond trees. The owner is paid annually for 51 acres of farmable ground with a 15 years lease remaining. Included are parcels APN# 004250057 which includes the beautiful 2550 sq ft home, APN# 004250056 - an almond orchard that borders Grangeville and 21st Ave and APN# 004250019 - an almond orchard plus useable metal shop on Grangeville Blvd. The domestic well is 400 ft with a Life Source whole house water system attached. Property includes 4 shallow wells and 1 deep 500 ft well. There is also a lift pressure pump for drip irrigation. If you are looking for a private relaxing place to live and experience country living at its fullest. THIS IS IT!
MlsNumber: --
ListingId: 229823


Listing Provided By: Lemoore Real Estate, original listing
Phone: 351-1573
Office Phone: (559) 924-8355
Agent Name: Laura Silveira
Disclaimer: Copyright © 2024 Kings County 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.


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 = 198 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;
Holley McKay
ASCIIKeller Williams Realty Hanford
Call Today!: (559) 707-2226

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App