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

12905 13th Road
Hanford, CA 93230
Fernando Santos with Sierra View Realty, Inc, original listing - (559) 772-5684

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3000 Square Feet
Agency: Sierra View Realty, Inc
Agency Phone: (559) 772-5684

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Other
Year Built: 2016
Notes: Welcome to your dream home at 12905 13th Rd in Hanford, CA! This expansive 3,000 square foot residence sitting on 1.6 acres had a complete tear down remodel in 2016. The home boasts a blend of luxury and functionality. With three generously sized bedrooms, each featuring its own private bathroom, and walk in closet and an additional half bath downstairs for guests, comfort and convenience are paramount. Step into the chef's paradise with top-of-the-line KitchenAid commercial appliances, perfect for culinary creations. Relax and unwind in the main suite, featuring a luxurious claw tub, a spacious walk-in shower, and a grand walk-in closet. This thoughtfully designed home includes laundry hookups on both levels for effortless laundry days. Step outside to the enchanting backyard, where you'll find a sparkling swimming pool complete with a captivating water feature, perfect for entertaining or enjoying sunny California days. The home also features owned solar panels, dog kennel, RV parking shade, Chicken coop, Livestock pen and an oversized detached 2 car garage. The property also includes impressive additional structures: a 30x40 metal building featuring a one-bedroom, one-bathroom ADU for guests or rental income, and a sprawling 30' x 100' metal building equipped with an executive office, a dedicated craft room, and a cold storage room, accommodating all of your recreational and professional needs. Experience the perfect blend of comfort, luxury, and practicality at this remarkable property. Don't miss your chance to make this stunning home yours!
MlsNumber: --
ListingId: 231819


Listing Provided By: Sierra View Realty, Inc, original listing
Phone: 772-5684
Office Phone: (559) 772-5684
Agent Name: Fernando Santos
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App