MOVE IN READY beautiful 4 beds/ 3 baths and 3 cars garage on a corner lot. Walk to Woods elementary and Buchanan High School , all Clovis award winning school . High ceiling, fresh interior paint and whole house has laminate wood floors. Separate room next to third bathroom for home office or guest room. Open kitchen with granite counters, gas appliances and large island with seating. A large attic space with storage in the garage and drop down ladder, with additional shelving in the garage. Neighborhood park with no HOA, and several trails nearby. Close to shopping, schools, and park.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2009
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$285
Price Per Acre
$3,608,117
Days On London
25
Cumulative Days On London
25
County
Fresno
Reports Available
NHD, Prelim Title Report
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Minnewawa/Teague
Directions
From Clovis Ave turn left to Teague and turn right .
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub
Basement
None
Disabled Features
One Level Floor
Flooring
Laminate
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 540550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 597450 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) >= 1750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2250 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` = 1709425 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1702842 OR `props-main`.`id` = 1702857 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1710071 OR `props-main`.`id` = 1709945 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1706699 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1702905 OR `props-main`.`id` = 1703308 OR `props-main`.`id` = 1694367 OR `props-main`.`id` = 1706687 OR `props-main`.`id` = 1710201 OR `props-main`.`id` = 1705649 OR `props-main`.`id` = 1701109 OR `props-main`.`id` = 1710075 OR `props-main`.`id` = 1708179 OR `props-main`.`id` = 1708180 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1705438 OR `props-main`.`id` = 1706785 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1708283 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1704483 OR `props-main`.`id` = 1711173 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1706078 OR `props-main`.`id` = 1704909 OR `props-main`.`id` = 1705575 OR `props-main`.`id` = 1711225 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1708302 OR `props-main`.`id` = 1708303 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1711092 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1708304 OR `props-main`.`id` = 1702212 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708310 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1708300 OR `props-main`.`id` = 1708301 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1708308 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1703671 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1696246 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1706921 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1709291 OR `props-main`.`id` = 1708322 OR `props-main`.`id` = 1709697 OR `props-main`.`id` = 1698439 OR `props-main`.`id` = 1705807 OR `props-main`.`id` = 1705158 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 1695575 OR `props-main`.`id` = 1692341 OR `props-main`.`id` = 1701895 OR `props-main`.`id` = 1701896 OR `props-main`.`id` = 1709645 OR `props-main`.`id` = 1709662 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1709664 OR `props-main`.`id` = 1701892 OR `props-main`.`id` = 1709644 OR `props-main`.`id` = 1705219 OR `props-main`.`id` = 1709643 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1709648 OR `props-main`.`id` = 1709649 OR `props-main`.`id` = 1701882 OR `props-main`.`id` = 1709660 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1709646 OR `props-main`.`id` = 1709642 OR `props-main`.`id` = 1702838 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1709647 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1701880 OR `props-main`.`id` = 1706045 OR `props-main`.`id` = 1703921 OR `props-main`.`id` = 1708512 OR `props-main`.`id` = 1709953 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1704030 OR `props-main`.`id` = 1704217 OR `props-main`.`id` = 1704441 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1704440)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643005' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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
$596,990
4
3
2,162
0.11
854 Solar Ln
Clovis, CA 93619
Courtesy of Linda Wong, HomeSmart PV and Associates - [email protected] Last modified 1 day 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.
