Please provide the following information and Margarita Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.margaritagarciarealtor.com/agent/16700/margarita-garcia/property/link/fresno/639941/11710-11712-3rd-Place/Hanford/https://www.margaritagarciarealtor.com/images/props/fresno/full/639941.jpgLondon Properties Hanford Real Estate | 11710 11712 3rd Place
Looking for an investment? Or you can live in one and rent the other! This property has 2 mobile homes on almost 1/2 acre lot! One mobile home has 2 bdrm, 2 ba, approx 684 sq. ft, with tile floors throughout and the other has 2 bdrm 1 ba. approx 600 sq. ft. There's also a basketball court in back, storage shed, and some fruit trees in back. There is a lot of potential in this property! Make your appointment to see today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built Exception
Unknown
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$136
Price Per Acre
$381,181
Days On Market
4
Cumulative Days On Market
4
County
Kings
REO / Bank Owned
No
Cross Street Address
Garden
Directions
South on 10th, East on Garden, North on 3rd
Heating & Cooling
Window or Wall A/C
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shed, Other/See Remarks
Kitchen
F/S Range/Oven
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Flooring
Carpet, Tile
Exterior
Other
Pool
No
Pool
No
Yard
Fenced, Fruit/Nut Trees
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
APN
016 172 022
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Kings River Hardwick
School Type 3
Grade School
School Name 3
Hamilton
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 166250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 183750 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) >= 1034 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1534 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` = 1694206 OR `props-main`.`id` = 1626116 OR `props-main`.`id` = 1626120 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1692727 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1694201 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1693870 OR `props-main`.`id` = 1693668 OR `props-main`.`id` = 1693865 OR `props-main`.`id` = 1692046 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1695327 OR `props-main`.`id` = 1695027 OR `props-main`.`id` = 1693846 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1689477 OR `props-main`.`id` = 1689476 OR `props-main`.`id` = 1694904 OR `props-main`.`id` = 1695124 OR `props-main`.`id` = 1695271 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1695172 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1662106 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1690595 OR `props-main`.`id` = 1690519 OR `props-main`.`id` = 1691606 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1689974 OR `props-main`.`id` = 1685056 OR `props-main`.`id` = 1695043 OR `props-main`.`id` = 1695045 OR `props-main`.`id` = 1695051 OR `props-main`.`id` = 1695044 OR `props-main`.`id` = 1695046 OR `props-main`.`id` = 1691937)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639941' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-19' 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 Angela Barajas, Newton & Sons Real Estate - angieb.homes@yahoo.com Last modified 3 days 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.
