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/metrolist/226081860/955-Elma-St/Hickman/https://www.londonproperties.com/images/props/metrolist/full/226081860.jpgLondon Properties Hickman Real Estate | 955 Elma St
Lovely 3bd 2ba 1300 sq ft Ranchette in Hickman! Newer refrigerator & dishwasher. Tiled upgraded showers. Fresh paint in the LR, entry, hallway. Partially finished garage (game room) with ductless air & heat. Upgraded 400amp electrical svc, wired for spa, outside bathroom & fire pit. Large SHOP building with 220. RV parking with 50-amp svc. 12x36 Tuff shed fully enclosed with electric & 50amp sub panel. Plenty of room for an ADU/second home. Plenty of storage/parking! Electric svc provided by Turlock Irrigation. All this on just under an acre. Agent owned property. Sold as is.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country, Detached, Semi-Custom
Property Condition
Updated/Remodeled
Year Built
1978
Year Built Source
Owner
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR
Stories
1
Pets Allowed
Yes, Service Animals OK, Cats OK, Dogs OK
Home Warranty
No
Other Equipment
TV Antenna
Directions to Property
From HWY 99 go east on Keyes Rd to Hickman Rd. Left on Hickman Rd to 6th St. Right on 6th, left on Elma St. Heading east on 132, in Waterford take Hickman Rd south to Davis St Left on Davis right on Elma St. No sign on property. House is on the west side of the street.
Cross Street
6th St
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Ranch, Contemporary
Construction Materials
Stone, Stucco, Wood
Foundation
Concrete, Slab
Roof
Composition
Heating
Central, Ductless, Electric
Cooling
Ceiling Fan(s), Central, Ductless
Laundry Features
Electric, In Garage
Window Features
Bay Window(s), Dual Pane Full, Window Coverings, Window Screens
Property Faces
East
Other Structures
Pergola, Shed(s), Storage, Outbuilding, Other
Full Bathrooms
2
Bath Features
Shower Stall(s), Tile, Window
Flooring
Carpet, Tile
Appliances
Free Standing Refrigerator, Hood Over Range, Dishwasher, Microwave, Plumbed For Ice Maker, Self/Cont Clean Oven, Free Standing Electric Range
Room Type
Primary Bathroom, Baths Other, Converted Garage, Game Room, Kitchen, Living Room
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 588905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 650895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1550 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` = 1742844 OR `props-main`.`id` = 1723424 OR `props-main`.`id` = 1731012 OR `props-main`.`id` = 1727862 OR `props-main`.`id` = 1732070 OR `props-main`.`id` = 1725669 OR `props-main`.`id` = 1724874 OR `props-main`.`id` = 1729308 OR `props-main`.`id` = 1733599 OR `props-main`.`id` = 1734259 OR `props-main`.`id` = 1724684 OR `props-main`.`id` = 1742338 OR `props-main`.`id` = 1726740 OR `props-main`.`id` = 1724204 OR `props-main`.`id` = 1736185)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226081860' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-27' 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 Janet Pierson, Atlantic Realty IDX provided by Reliance Marketing
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.
