Please provide the following information and Rene Carson will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.renesrealestate.com/agent/10516/rene-carson/property/link/fresno/643667/8625-La-Vaca-Way/Hanford/https://www.renesrealestate.com/images/props/fresno/full/643667.jpgLondon Properties Hanford Real Estate | 8625 La Vaca Way
This super cute starter home or rental property, is a perfect home that offers upgrades throughout. The home has all new flooring, paint, fixtures, tile in both bathrooms and new vanities. The kitchen has all new granite countertops and new appliances. This GEM also has a newer roof, central heat/ air, and dual pane windows. It's only 3 minutes from local shopping like Costco and a few minutes from Downtown. Call me or your local agent and make this home yours .
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1959
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$275
Price Per Acre
$1,584,356
Days On London
16
Cumulative Days On London
16
County
Kings
REO / Bank Owned
No
Cross Street Address
Lacey
Directions
Lacey BLVD to Carolyne South to La Vaca East.
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Basement
None
Exterior
Stucco, Brick
Pool
No
Pool
No
Patio Features
Uncovered
Yard
Sprinklers Front, Sprinklers Back
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Garage Type
Attached
Garage Spaces
2
Site Amenities
Cul De Sac
APN
016 283 012 000
Zoning
R18
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Kit Carson
School Type 3
Grade School
School Name 3
Frontier
Seller Will Consider
Government, Conventional, Cash
1st Loan Type
Free & Clear
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 294405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 325395 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) >= 876 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1376 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` = 1703152 OR `props-main`.`id` = 1703140 OR `props-main`.`id` = 1703157 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1712806 OR `props-main`.`id` = 1701340 OR `props-main`.`id` = 1712150 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1707996 OR `props-main`.`id` = 1708247 OR `props-main`.`id` = 1702360 OR `props-main`.`id` = 1696094 OR `props-main`.`id` = 1696112 OR `props-main`.`id` = 1696509 OR `props-main`.`id` = 1712816 OR `props-main`.`id` = 1712810 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1709681 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1712808 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1707138 OR `props-main`.`id` = 1708345 OR `props-main`.`id` = 1701306 OR `props-main`.`id` = 1701203 OR `props-main`.`id` = 1702263 OR `props-main`.`id` = 1711264 OR `props-main`.`id` = 1705552 OR `props-main`.`id` = 1710055 OR `props-main`.`id` = 1703271 OR `props-main`.`id` = 1708500 OR `props-main`.`id` = 1709171 OR `props-main`.`id` = 1709168 OR `props-main`.`id` = 1706879 OR `props-main`.`id` = 1710202 OR `props-main`.`id` = 1707238 OR `props-main`.`id` = 1712787 OR `props-main`.`id` = 1712434 OR `props-main`.`id` = 1697272 OR `props-main`.`id` = 1664767 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1694426 OR `props-main`.`id` = 1699084 OR `props-main`.`id` = 1708489 OR `props-main`.`id` = 1712633 OR `props-main`.`id` = 1704551 OR `props-main`.`id` = 1712651 OR `props-main`.`id` = 1704293 OR `props-main`.`id` = 1708483 OR `props-main`.`id` = 1708010 OR `props-main`.`id` = 1704767 OR `props-main`.`id` = 1710247)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643667' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-04' 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 Rogelio Guizar, Universal Realty Services, Inc. - rogerguizar0412@gmail.com Last modified 4 days ago Fresno MLS last checked for updates 10 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.
