Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/kings/232557/335-Helene-St/Lemoore/https://www.londonproperties.com/images/props/kings/full/232557.jpgLondon Properties Lemoore Real Estate | 335 Helene St
Nestled on nearly an acre of land in one of Kings Countuy's most sought after neighborhoods. This exceptional home offers the perfect blend of comfort, style & functionality.Boasting a spacious layout & a host of high-end amenities, this property is a true gem.The bright & airy kitchen with beautiful quartz countertops has an abundance of storage.Fresh paint throughout home adds to it pristine appeal and the home benefits from owned solar panels.This home offers 2 primary suites perfect for guests or multigenerational living. Outside you'll enjoy a beautifully landscaped yard complete with waterfall rock pool The property also includes a 14 X 24 shop, RV pad,2 water heaters on each end of home, city water and well for irrigation. New roof just installed!!!! It's truly a rare find!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1993
Location
City
Stories
1
Price Per Square Foot
$282
Price Per Acre
$1,062,092
Cumulative Days On Market
157
County
Kings
Directions
from Hwy 198, take 18th Ave (North Lemoore Ave) turn south, left on Helene
Heating Systems
Central
Cooling
Central
Water Heater Types
Propane
Laundry
Room
Roof
Composition
Security Features
Smoke Detectors
Window Treatments
All Stay, Shutters
Windows
Dual Pane
Full Bathrooms
3
Basement Foundation
None
Floors
Laminate Floors, Tile Floors
Fireplace
Insert
Exterior Features
Built in BBQ, Other
Pool
In-Ground Pool
Pool Private Y/N
Yes
Spa Y/N
No
Porch / Patio
Covered Patio, Covered Porch
Utilities
Propane
Water Supply
Public, Well
Sewer
Septic Tank
Solar Y/N
Yes
Solar Options
Solar Panels
Solar Ownership
Owned
Garage Type
Garage Attached
Garage Capacity
3
Site Description
Corner Lot
Sprinklers
Automatic
Horse Property Y/N
No
APN Number
023 090 004 000
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 926250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1023750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3212 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3712 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1671679 OR `props-main`.`id` = 1691554 OR `props-main`.`id` = 1691552 OR `props-main`.`id` = 1695436 OR `props-main`.`id` = 1695446 OR `props-main`.`id` = 1694357 OR `props-main`.`id` = 1694664 OR `props-main`.`id` = 1678253 OR `props-main`.`id` = 1643823 OR `props-main`.`id` = 1696511 OR `props-main`.`id` = 1696505 OR `props-main`.`id` = 1696454 OR `props-main`.`id` = 1696508 OR `props-main`.`id` = 1701360 OR `props-main`.`id` = 1701466 OR `props-main`.`id` = 1701195 OR `props-main`.`id` = 1701357 OR `props-main`.`id` = 1690098 OR `props-main`.`id` = 1684402 OR `props-main`.`id` = 1684418 OR `props-main`.`id` = 1695714 OR `props-main`.`id` = 1694628 OR `props-main`.`id` = 1694354 OR `props-main`.`id` = 1689732 OR `props-main`.`id` = 1697685 OR `props-main`.`id` = 1697683 OR `props-main`.`id` = 1694550 OR `props-main`.`id` = 1694358 OR `props-main`.`id` = 1694549 OR `props-main`.`id` = 1691173 OR `props-main`.`id` = 1694349 OR `props-main`.`id` = 1589173 OR `props-main`.`id` = 1696354 OR `props-main`.`id` = 1696353 OR `props-main`.`id` = 1696351 OR `props-main`.`id` = 1696352 OR `props-main`.`id` = 1701293 OR `props-main`.`id` = 1647420 OR `props-main`.`id` = 1696350 OR `props-main`.`id` = 1696518 OR `props-main`.`id` = 1694551 OR `props-main`.`id` = 1694353 OR `props-main`.`id` = 1647419 OR `props-main`.`id` = 1694355 OR `props-main`.`id` = 1694553 OR `props-main`.`id` = 1694665 OR `props-main`.`id` = 1694351 OR `props-main`.`id` = 1696347 OR `props-main`.`id` = 1647413 OR `props-main`.`id` = 1698600 OR `props-main`.`id` = 1682999 OR `props-main`.`id` = 1696621 OR `props-main`.`id` = 1697385 OR `props-main`.`id` = 1680421 OR `props-main`.`id` = 1700812 OR `props-main`.`id` = 1689923 OR `props-main`.`id` = 1671982 OR `props-main`.`id` = 1696803 OR `props-main`.`id` = 1697449 OR `props-main`.`id` = 1697731 OR `props-main`.`id` = 1698631 OR `props-main`.`id` = 1696773 OR `props-main`.`id` = 1694352 OR `props-main`.`id` = 1694677 OR `props-main`.`id` = 1697939 OR `props-main`.`id` = 1694901 OR `props-main`.`id` = 1678224 OR `props-main`.`id` = 1694356 OR `props-main`.`id` = 1694667)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings232557' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Laverne Johansen, All Family Lending & Real Estate Inc
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
