Please provide the following information and Jasmin Quintana will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.quintanahomes.com/agent/19708/jasmin-quintana/property/link/fresno/642848/257-S-Lead-Ave/Fresno/https://www.quintanahomes.com/images/props/fresno/full/642848.jpgLondon Properties Fresno Real Estate | 257 S Lead Ave
Welcome to the exquisite 2-floor house. With a Den next to entry door, the spacious living room/dining room next to open kitchen has countertops and closets. Downstairs has one isolated bedroom with a full bathroom, which is good for guests. Upstairs has 2 bedrooms sharing a bathroom, and a master room features spacious walk-in-closet and large primary balcony which is wonderful for the farm viewing. 3-car garage with an extra permitted room which is designed for the solar panels on the roof. 27 solar panels owner owned with the property for efficiency the power usages/cost. Mature front landscape and spacious backyard. Easy to 180 FWY for commuting. The property locates a quiet and safety community! The property is move in ready!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Two
Price Per Square Foot
$225
Price Per Acre
$2,623,457
Days On Market
0
Cumulative Days On Market
0
County
Fresno
Reports Available
Appraisal
REO / Bank Owned
No
Cross Street Address
W Stanislaus St.
Directions
Driving 180FWY, exiting on Marks Ave., west on Chandler Ave., south on Lead Ave., home is on right side.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 484500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 535500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2018 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2518 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` = 1694841 OR `props-main`.`id` = 1694657 OR `props-main`.`id` = 1664266 OR `props-main`.`id` = 1664262 OR `props-main`.`id` = 1700059 OR `props-main`.`id` = 1679412 OR `props-main`.`id` = 1703459 OR `props-main`.`id` = 1695178 OR `props-main`.`id` = 1696834 OR `props-main`.`id` = 1702096 OR `props-main`.`id` = 1701669 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1701251 OR `props-main`.`id` = 1703865 OR `props-main`.`id` = 1697772 OR `props-main`.`id` = 1703613 OR `props-main`.`id` = 1697911 OR `props-main`.`id` = 1704536 OR `props-main`.`id` = 1692397 OR `props-main`.`id` = 1689996 OR `props-main`.`id` = 1668403 OR `props-main`.`id` = 1683609 OR `props-main`.`id` = 1697680 OR `props-main`.`id` = 1700848 OR `props-main`.`id` = 1691862 OR `props-main`.`id` = 1681487 OR `props-main`.`id` = 1690827 OR `props-main`.`id` = 1703084 OR `props-main`.`id` = 1689173 OR `props-main`.`id` = 1675273 OR `props-main`.`id` = 1703215 OR `props-main`.`id` = 1703216 OR `props-main`.`id` = 1696345 OR `props-main`.`id` = 1687883 OR `props-main`.`id` = 1687884 OR `props-main`.`id` = 1696344 OR `props-main`.`id` = 1699044)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642848' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-29' 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 Xiangyang Shi, Allegiant Realty & Associates - shawnbroker2100@yahoo.com Last modified 1 day ago Fresno MLS last checked for updates 32 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.
