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/225129690/18624-Lake-Rd/Hickman/https://www.londonproperties.com/images/props/metrolist/full/225129690.jpgLondon Properties Hickman Real Estate | 18624 Lake Rd
ASSUMABLE LOAN AT 4.15%!!! According to seller, loan balance is approx $818,000 with a monthly payment of approx $5,828. Beautiful country views await with this 2,429 square foot home that sits on top of the property overlooking the 42 acre almond orchard. Other features are two domestic wells, one irrigation well, 15th leaf Butte/Padre trees, irrigated with an AG well with micro sprinklers. Also an option to assume next door lease of 28 acres, 7 year old trees.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
1995
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
Hawkins Rd to Lake Rd.
Cross Street
Hawkins Rd
County
Stanislaus
Special Listing Conditions
None
Main Level
Dining Room, Family Room, Garage, Kitchen, Street Entrance
Construction Materials
Wood Siding
Foundation
Raised
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Other
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Laminate, Wood
Kitchen Features
Other Counter, Island
Dining Room Features
Formal Area
Living Room Features
Cathedral/Vaulted
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Other
Electric
220 Volts
Irrigation
Other
Water Source
Well
Sewer
Other
Parking Features
Garage Facing Side
Garage Spaces
2.00
Lot Features
Shape Irregular
APN
020 001 040 000
Horse Property
No
Zoning Description
Res/Ag
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Roberts Ferry Union
Middle or Junior School District
Roberts Ferry Union
Senior High School District
Hughson Union
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1135250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1254750 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) >= 2179 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2679 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` = 1688852)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225129690' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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 Brian Brazeal, RE/MAX Executive 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.
