Please provide the following information and Larry Schrimp will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lplenderservices.com/agent/10259/larry-schrimp/property/link/fresno/611486/10091-N-Sierra-Vista-Ave/Fresno/Woodward-Park/https://www.lplenderservices.com/images/props/fresno/full/611486.jpgLondon Properties Fresno Real Estate | 10091 N Sierra Vista Ave
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Located in the award winning Clovis Unified school district this property has a lot to offer. Located on a corner lot the home has 4 bedrooms plus 3 bathrooms within 2,207 square feet and one of the bedrooms & full bathroom is located downstairs. Hardwood flooring is used in the family room areas plus the kitchen and carpet will be in all the upstairs bedrooms. The home has been recently updated with fresh new paint on the exterior along with owned solar panels to lower those high energy bills. Also, in 2017 the entire home was repiped with new plumbing and a whole house water filtration system was installed with the Enviro Water Production brand. Make your appointment today to view this listing with your Realtor.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1998
Region
Urban
# of Stories
Two
Price Per Square Foot
$261
Price Per Acre
$3,683,536
Days On Market
17
Cumulative Days On Market
17
County
Fresno
Reports Available
NHD, Prelim Title Report
REO / Bank Owned
No
Cross Street Address
Maple n Behymer
Directions
East on Behymer from Maple Ave turn left on Sierra Vista.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Lower Level
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
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) >= 546250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 603750 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) >= 1957 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2457 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` = 1587745 OR `props-main`.`id` = 1580862 OR `props-main`.`id` = 1585847 OR `props-main`.`id` = 1585513 OR `props-main`.`id` = 1583048 OR `props-main`.`id` = 1579740 OR `props-main`.`id` = 1586464 OR `props-main`.`id` = 1586508 OR `props-main`.`id` = 1591253 OR `props-main`.`id` = 1588437 OR `props-main`.`id` = 1588408 OR `props-main`.`id` = 1590133 OR `props-main`.`id` = 1590551 OR `props-main`.`id` = 1589971 OR `props-main`.`id` = 1585949 OR `props-main`.`id` = 1585002 OR `props-main`.`id` = 1585006 OR `props-main`.`id` = 1591144 OR `props-main`.`id` = 1590769 OR `props-main`.`id` = 1590735 OR `props-main`.`id` = 1589753 OR `props-main`.`id` = 1582546 OR `props-main`.`id` = 1581826 OR `props-main`.`id` = 1581978 OR `props-main`.`id` = 1581798 OR `props-main`.`id` = 1591124 OR `props-main`.`id` = 1590951 OR `props-main`.`id` = 1581193 OR `props-main`.`id` = 1586052 OR `props-main`.`id` = 1590092 OR `props-main`.`id` = 1580173 OR `props-main`.`id` = 1588851 OR `props-main`.`id` = 1582090 OR `props-main`.`id` = 1582966 OR `props-main`.`id` = 1588362 OR `props-main`.`id` = 1589487 OR `props-main`.`id` = 1589351 OR `props-main`.`id` = 1582397 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1590275 OR `props-main`.`id` = 1584756 OR `props-main`.`id` = 1588752 OR `props-main`.`id` = 1589656 OR `props-main`.`id` = 1590761 OR `props-main`.`id` = 1578038 OR `props-main`.`id` = 1580822 OR `props-main`.`id` = 1585977 OR `props-main`.`id` = 1588294 OR `props-main`.`id` = 1587053 OR `props-main`.`id` = 1586031 OR `props-main`.`id` = 1588729 OR `props-main`.`id` = 1556348 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1586794 OR `props-main`.`id` = 1590776 OR `props-main`.`id` = 1586447 OR `props-main`.`id` = 1586999 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1590809 OR `props-main`.`id` = 1588049 OR `props-main`.`id` = 1587651 OR `props-main`.`id` = 1576993 OR `props-main`.`id` = 1588918 OR `props-main`.`id` = 1588266 OR `props-main`.`id` = 1569021 OR `props-main`.`id` = 1586275 OR `props-main`.`id` = 1585698 OR `props-main`.`id` = 1584232 OR `props-main`.`id` = 1589636 OR `props-main`.`id` = 1586583 OR `props-main`.`id` = 1581228 OR `props-main`.`id` = 1589372 OR `props-main`.`id` = 1585822 OR `props-main`.`id` = 1567339 OR `props-main`.`id` = 981418 OR `props-main`.`id` = 1590984 OR `props-main`.`id` = 1587573 OR `props-main`.`id` = 1588719 OR `props-main`.`id` = 1584445 OR `props-main`.`id` = 1582163 OR `props-main`.`id` = 1580686 OR `props-main`.`id` = 1584309 OR `props-main`.`id` = 1587996 OR `props-main`.`id` = 1585719 OR `props-main`.`id` = 1590786 OR `props-main`.`id` = 1589707 OR `props-main`.`id` = 1590364 OR `props-main`.`id` = 1584686 OR `props-main`.`id` = 1581524 OR `props-main`.`id` = 1581458 OR `props-main`.`id` = 1588001 OR `props-main`.`id` = 1589164 OR `props-main`.`id` = 1581632 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1585716 OR `props-main`.`id` = 1579107 OR `props-main`.`id` = 1583711 OR `props-main`.`id` = 1588402 OR `props-main`.`id` = 1588002 OR `props-main`.`id` = 1566009 OR `props-main`.`id` = 1586612 OR `props-main`.`id` = 1588724 OR `props-main`.`id` = 1584369 OR `props-main`.`id` = 1585601 OR `props-main`.`id` = 1585964 OR `props-main`.`id` = 1584465 OR `props-main`.`id` = 1588896 OR `props-main`.`id` = 1581429 OR `props-main`.`id` = 1589704 OR `props-main`.`id` = 1571539 OR `props-main`.`id` = 1584408 OR `props-main`.`id` = 1584478 OR `props-main`.`id` = 1584200 OR `props-main`.`id` = 1587045 OR `props-main`.`id` = 1586828 OR `props-main`.`id` = 1577993 OR `props-main`.`id` = 1572064 OR `props-main`.`id` = 1580104 OR `props-main`.`id` = 1590739 OR `props-main`.`id` = 1581900 OR `props-main`.`id` = 227897 OR `props-main`.`id` = 1587380)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611486' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-12' 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();
Courtesy of Frank Dickinson, Realty Concepts, Ltd. - Fresno - frank@realtyconcepts.com Last modified 1 week ago Fresno MLS last checked for updates 50 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.
