Welcome to this immaculate home located in Harlan Ranch. This home boasts a large kitchen with breakfast bar, walk in pantry, stainless steel appliances and a gas stove.The kitchen is open to the Dining area and great room with buildt-in shelving and space for your entertainment needs. The great room is light and bright with big picture windows looking out to the wonderful backyard. Have your privacy with the primary suite on the opposite side of the other bedrooms . The en -suite features double sinks, oval tub and separate stall shower.If you opt for formal dining the dinning area is perfect for hosting guests. Walk out to the picturesque and peaceful backyard,whether entertaining or having a quite day enjoy those hot summer days with a Pebble tech pool with waterfalls. In the evening as the night cools off grab your favorite beverage while relaxing in front of the fireplace .Check out the 3 car finished garage with the Epoxy flooring . Additional items include faux blinds ceiling fans and a lot of love!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2009
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$314
Price Per Acre
$3,374,935
Days On London
2
Cumulative Days On London
2
County
Fresno
Reports Available
Prelim Title Report
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
S/shepherd W/Locan
Directions
Shepherd Ave to highland , east on highland , right on Harlan ranch .right on Fancher to Trenton
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub, Oval Tub
Extra Rooms
Great Room
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Auto, Fenced, Mature Landscape, Drip System
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows, Solar Pool Heater, Tankless Water Heater
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 616550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 681450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1815 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2315 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` = 1726080 OR `props-main`.`id` = 1723788 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1727387 OR `props-main`.`id` = 1726451 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1722430 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1722623 OR `props-main`.`id` = 1722847 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1717197 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1715709 OR `props-main`.`id` = 1726814 OR `props-main`.`id` = 1724751 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1725116 OR `props-main`.`id` = 1720901 OR `props-main`.`id` = 1727497 OR `props-main`.`id` = 1721973)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648224' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-20' 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();
1
Similar Properties
$649,900
4
2.75
2,298
0.20
3245 Lexington Ave
Clovis, CA 93619
Courtesy of Trisha Coffman, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 18 hours ago Fresno MLS last checked for updates 14 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.
