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/fresno/655877/138-G-St/Turlock/https://www.londonproperties.com/images/props/fresno/full/655877.jpgLondon Properties Turlock Real Estate | 138 G St
Courtesy of Gloria Chavez, eXp Realty of Northern California, Inc. - [email protected]
Please Do Not Disturb Tenants 24 hour notice to view home. INVESTOR SPECIAL! Unlock the potential of this two-story Turlock home featuring 3 bedrooms and 1 bathroom. This property offers a great opportunity for investors, contractors, or buyers looking to add their personal touch and build equity. With some TLC and vision, this home has the potential to shine and become a fantastic investment or future residence. Bring your ideas and turn this diamond in the rough into something special! Conveniently located in Turlock with easy access to local shopping, dining, schools, and amenities. Property is being sold as-is.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1910
Region
Urban
# of Stories
Two
Price Per Square Foot
$216
Price Per Acre
$1,706,343
Days On London
20
Cumulative Days On London
20
County
Stanislaus
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Jessica
Directions
North on 99 freeway get off on Lander Ave. left then turn right on F Street Jessica left then a right on G Street
Unit Description
Ground Floor, Second Floor
Style
Contemporary
Heating & Cooling
Floor or Wall Unit
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Shower
Flooring
Carpet, Tile, Vinyl
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water
Solar
No
Are there garage spaces?
No
APN
043 013 034 000
School District
Stanislaus
School Type 1
High School
School Name 1
Stanislaus
School Type 2
Junior High School
School Name 2
Stanislaus
School Type 3
Grade School
School Name 3
Stanislaus
Seller Will Consider
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 226943.6 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 250832.4 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 858 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1358 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` = 1718451 OR `props-main`.`id` = 1786509 OR `props-main`.`id` = 1786335 OR `props-main`.`id` = 1765935 OR `props-main`.`id` = 1676713 OR `props-main`.`id` = 1786381 OR `props-main`.`id` = 1676721 OR `props-main`.`id` = 1788746 OR `props-main`.`id` = 1788743 OR `props-main`.`id` = 1780758 OR `props-main`.`id` = 1789753 OR `props-main`.`id` = 1760363 OR `props-main`.`id` = 1781922 OR `props-main`.`id` = 1766814 OR `props-main`.`id` = 1788050 OR `props-main`.`id` = 1789758 OR `props-main`.`id` = 1786677 OR `props-main`.`id` = 1786644 OR `props-main`.`id` = 1786390 OR `props-main`.`id` = 1781611 OR `props-main`.`id` = 1781667 OR `props-main`.`id` = 1786526 OR `props-main`.`id` = 1789159 OR `props-main`.`id` = 1781890 OR `props-main`.`id` = 1775926 OR `props-main`.`id` = 1775953 OR `props-main`.`id` = 1775307 OR `props-main`.`id` = 1775925 OR `props-main`.`id` = 1789111 OR `props-main`.`id` = 1781898 OR `props-main`.`id` = 1775952 OR `props-main`.`id` = 1770594 OR `props-main`.`id` = 1771790 OR `props-main`.`id` = 1786730 OR `props-main`.`id` = 1775200 OR `props-main`.`id` = 1776085 OR `props-main`.`id` = 1771726 OR `props-main`.`id` = 1780761 OR `props-main`.`id` = 1790987 OR `props-main`.`id` = 1786872 OR `props-main`.`id` = 1759507 OR `props-main`.`id` = 1771826 OR `props-main`.`id` = 1781930 OR `props-main`.`id` = 1771611 OR `props-main`.`id` = 1786323 OR `props-main`.`id` = 1790914 OR `props-main`.`id` = 1786802 OR `props-main`.`id` = 1773842 OR `props-main`.`id` = 1773825 OR `props-main`.`id` = 1790481 OR `props-main`.`id` = 1774312 OR `props-main`.`id` = 1768945 OR `props-main`.`id` = 1790512 OR `props-main`.`id` = 1785453 OR `props-main`.`id` = 1751869 OR `props-main`.`id` = 1786633 OR `props-main`.`id` = 1786632 OR `props-main`.`id` = 1771619 OR `props-main`.`id` = 1771573 OR `props-main`.`id` = 1786327 OR `props-main`.`id` = 1790116 OR `props-main`.`id` = 1758689 OR `props-main`.`id` = 1788774 OR `props-main`.`id` = 1779789 OR `props-main`.`id` = 1791087 OR `props-main`.`id` = 1769891 OR `props-main`.`id` = 1694953 OR `props-main`.`id` = 1771610 OR `props-main`.`id` = 1784845 OR `props-main`.`id` = 1762303 OR `props-main`.`id` = 1760712 OR `props-main`.`id` = 1751958 OR `props-main`.`id` = 1745329 OR `props-main`.`id` = 1788841 OR `props-main`.`id` = 1727795 OR `props-main`.`id` = 1787246 OR `props-main`.`id` = 1786653 OR `props-main`.`id` = 1760976 OR `props-main`.`id` = 1782230 OR `props-main`.`id` = 1753559 OR `props-main`.`id` = 1788788 OR `props-main`.`id` = 1704004 OR `props-main`.`id` = 1771648 OR `props-main`.`id` = 1786013 OR `props-main`.`id` = 1786398 OR `props-main`.`id` = 1790402 OR `props-main`.`id` = 1758819 OR `props-main`.`id` = 1729195 OR `props-main`.`id` = 1771549 OR `props-main`.`id` = 1754458 OR `props-main`.`id` = 1789643)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655877' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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
Last modified 4 days ago Fresno MLS last checked for updates 26 minutes ago
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.
