Plantings Property is planted to Pistachios, which were planted in 2008. It is currently transitioning to an organic orchard. Water Property is located in the Kings River Conservation District and is part of North Fork Kings GSA. Seller has stated there are no pumping restrictions. There is one (1) 2,500 GPM, 1,000 Ft. Ag well, drilled in 2008. The property is physically adjacent to Crescent Canal, however no shares are included in this transaction. Groundwater Disclosure Sustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA requires a Groundwater Sustainability Plan (GSP) by 2020. Said plans may limit ground water pumping. For more inf
Plantings Property is fully planted to Pistachios. Planted in 2009. Includes +/-13 acres of 2021 replants and +/-30 acres of 5th leaf maturing acres. Water Property is located in Westlands Water District and is part of Westlands Water District GSA. The property receives full Westlands Water District rights. The property is physically adjacent to Crescent Canal, however no shares are included in this transaction. Sustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA requires a Groundwater Sustainability Plan (GSP) by 2020. Said plans may limit ground water pumping. For more information please visit the SGMA website at www. sgma. water.ca.
Plantings Property is planted to Pistachios, which were planted in 2008. It is currently transitioning to an organic orchard. Water Property is located in the Kings River Conservation District and is part of North Fork Kings GSA. Seller has stated there are no pumping restrictions. There is one (1) 2,500 GPM, 1,000 Ft. Ag well, drilled in 2008. The property is physically adjacent to Crescent Canal, however no shares are included in this transaction. Groundwater Disclosure Sustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA requires a Groundwater Sustainability Plan (GSP) by 2020. Said plans may limit ground water pumping. For more inf
Plantings Property is fully planted to Pistachios. Planted in 2009. Includes +/-13 acres of 2021 replants and +/-30 acres of 5th leaf maturing acres. Water Property is located in Westlands Water District and is part of Westlands Water District GSA. The property receives full Westlands Water District rights. The property is physically adjacent to Crescent Canal, however no shares are included in this transaction. Sustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA requires a Groundwater Sustainability Plan (GSP) by 2020. Said plans may limit ground water pumping. For more information please visit the SGMA website at www. sgma. water.ca.
Plantings Property is planted to Pistachios. +/-237 acres planted in 2012. +/-65 acres planted in 2017. Property is located in Westlands Water District and is part of Westlands Water District GSA. The property receives full Westlands Water District rights. There is one (1) 2,700 GPM, 1,100 ft. Ag well, drilled in 2012. The property is physically adjacent to Crescent Canal, however no shares are included in this transaction. +/-47.9% Tranquillity, Tranquillity, wet, complex, saline-sodic, 0 to 1 percent slopes. +/-52.1% Tranquillity clay, saline-sodic, wet, 0 to 1 percent slopes. Sustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA re
Country living with easy access to water to use for farming the land! The perfect home for a family ready to start a farm or someone looking to expand their farming operations. 20 Acres with large 2300 sq ft home. Prime location with easy access to State Route 145 which leads to Kerman and CA-180 leading to Fresno. Property is in the James Irrigation District. The home features 3 bedrooms 2 baths, with wood floors throughout the home. Large primary bedroom, living and dining rooms as well. You are going to enjoy the Front yard with a large shade tree, grassy area, plenty of fruit trees surround the home. The backyard with huge pool for the hot summers. There is an outdoor bathroom that is p
The Golden Hills Variety Pistachio Orchard was planted in 2017 on Platinum Rootstock, spacing is 20X16. The property is located on the south side of Rose Ave. in San Joaquin, Ca. The orchard is in the James Irrigation District and receives district water through the canal system and the trees receive water through a double line drip irrigation filtered system
This area's enrollment policy is not based solely on geography. Please check the school district website for more information.
Elementary schools
Middle schools
High schools
GreatSchools Summary Rating
8/10
Helm Elementary School
Public, K-8
School data is provided by GreatSchools, a nonprofit organization. Redfin recommends buyers and renters use GreatSchools information and ratings as a first step, and conduct their own investigation to determine their desired schools or school districts, including by contacting and visiting the schools themselves.Redfin does not endorse or guarantee this information. School service boundaries are intended to be used as a reference only; they may change and are not guaranteed to be accurate. To verify school enrollment eligibility, contact the school district directly.
Most of our new listings in 93627 are updated every 5 minutes so you can see new homes as soon as they come on the market. Learn more
Find your dream home in 93627 using the tools above. Use filters to narrow your search by price, square feet, beds, and baths to find homes that fit your criteria. Our top-rated real estate agents in 93627 are local experts and are ready to answer your questions about properties, neighborhoods, schools, and the newest listings for sale in 93627. If you're looking to sell your home in the 93627 area, our listing agents can help you get the best price. Redfin is redefining real estate and the home buying process in 93627 with industry-leading technology, full-service agents, and lower fees that provide a better value for Redfin buyers and sellers.