Please provide the following information and Brittanni Shollenbarger will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.brittannihome.com/agent/10007/brittanni-shollenbarger/property/link/fresno/636579/710-W-Lisbon-Ln/Clovis/https://www.brittannihome.com/images/props/fresno/full/636579.jpgLondon Properties Clovis Real Estate | 710 W Lisbon Ln
Discover this cozy and charming home situated in the exclusive, privately gated European Parc community near Willow and Shepherd. The home is located within the highly desirable Clovis Unified School District in the Buchanan area. This inviting home offers three bedrooms and two bathrooms, complemented by an open floor plan that provides a sense of spaciousness throughout. The interior has been freshly painted, creating a welcoming and modern atmosphere.The primary suite features its own private bathroom and a walk-in closet, both generously sized for comfort and convenience.Enjoy the quaint and comfortable covered patio and backyard, perfect for relaxation and outdoor gatherings. This home is perfect for a young professional, parents looking to downsize, or an investor.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$313
Price Per Acre
$5,415,531
Days On Market
4
Cumulative Days On Market
4
County
Fresno
REO / Bank Owned
No
Cross Street Address
Willow/Sheperd
Directions
From Herndon, go N on Willow, E on Powers, turn left on Fontaine, R on Seville, and R on Lisbon.
Style
Bungalow
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Breakfast Bar
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Carpet, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Wood
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) >= 377625 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 417375 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1021 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1521 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` = 1646842 OR `props-main`.`id` = 1676630 OR `props-main`.`id` = 1646833 OR `props-main`.`id` = 1668366 OR `props-main`.`id` = 1682157 OR `props-main`.`id` = 1674952 OR `props-main`.`id` = 1683970 OR `props-main`.`id` = 1683984 OR `props-main`.`id` = 1683983 OR `props-main`.`id` = 1678515 OR `props-main`.`id` = 1680698 OR `props-main`.`id` = 1684552 OR `props-main`.`id` = 1678079 OR `props-main`.`id` = 1678087 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1678081 OR `props-main`.`id` = 1677203 OR `props-main`.`id` = 1676350 OR `props-main`.`id` = 1681105 OR `props-main`.`id` = 1663946 OR `props-main`.`id` = 1681595 OR `props-main`.`id` = 1678410 OR `props-main`.`id` = 1683321 OR `props-main`.`id` = 1674971 OR `props-main`.`id` = 1671308 OR `props-main`.`id` = 1671307 OR `props-main`.`id` = 1671311 OR `props-main`.`id` = 1671309 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1684477 OR `props-main`.`id` = 1683559 OR `props-main`.`id` = 1677277 OR `props-main`.`id` = 1683435 OR `props-main`.`id` = 1666576 OR `props-main`.`id` = 1660507 OR `props-main`.`id` = 1681683 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1684711 OR `props-main`.`id` = 1678959 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1675084 OR `props-main`.`id` = 1678766 OR `props-main`.`id` = 1683120 OR `props-main`.`id` = 1676181 OR `props-main`.`id` = 1646324 OR `props-main`.`id` = 1645406 OR `props-main`.`id` = 1681984 OR `props-main`.`id` = 1681862 OR `props-main`.`id` = 1684072 OR `props-main`.`id` = 1681098 OR `props-main`.`id` = 1680452 OR `props-main`.`id` = 1678426 OR `props-main`.`id` = 1657786 OR `props-main`.`id` = 1668344 OR `props-main`.`id` = 1639834 OR `props-main`.`id` = 1681709 OR `props-main`.`id` = 1668522 OR `props-main`.`id` = 1677154 OR `props-main`.`id` = 1656659 OR `props-main`.`id` = 1656650 OR `props-main`.`id` = 1681299 OR `props-main`.`id` = 1676627 OR `props-main`.`id` = 1659506 OR `props-main`.`id` = 1659491 OR `props-main`.`id` = 1679207 OR `props-main`.`id` = 1681514 OR `props-main`.`id` = 1680688 OR `props-main`.`id` = 1679315 OR `props-main`.`id` = 1665922 OR `props-main`.`id` = 1622629 OR `props-main`.`id` = 1684081 OR `props-main`.`id` = 1669743 OR `props-main`.`id` = 1681274 OR `props-main`.`id` = 1683038 OR `props-main`.`id` = 1679801 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1651069 OR `props-main`.`id` = 1684640 OR `props-main`.`id` = 1683080 OR `props-main`.`id` = 1683248 OR `props-main`.`id` = 1680784 OR `props-main`.`id` = 1682027 OR `props-main`.`id` = 1665909 OR `props-main`.`id` = 1681434 OR `props-main`.`id` = 1681404 OR `props-main`.`id` = 1677547 OR `props-main`.`id` = 1656704 OR `props-main`.`id` = 1667490 OR `props-main`.`id` = 1664016 OR `props-main`.`id` = 1684059 OR `props-main`.`id` = 1680292 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1679516 OR `props-main`.`id` = 1684006 OR `props-main`.`id` = 1679437 OR `props-main`.`id` = 1671244 OR `props-main`.`id` = 1674616 OR `props-main`.`id` = 1672916 OR `props-main`.`id` = 1683230 OR `props-main`.`id` = 1681608 OR `props-main`.`id` = 1677541 OR `props-main`.`id` = 1681604 OR `props-main`.`id` = 1681602 OR `props-main`.`id` = 1658132 OR `props-main`.`id` = 1667909 OR `props-main`.`id` = 1668162 OR `props-main`.`id` = 1667424 OR `props-main`.`id` = 1680832 OR `props-main`.`id` = 1667425 OR `props-main`.`id` = 1684067 OR `props-main`.`id` = 1673257 OR `props-main`.`id` = 1678487 OR `props-main`.`id` = 1679867 OR `props-main`.`id` = 1680632 OR `props-main`.`id` = 1679265 OR `props-main`.`id` = 1678093 OR `props-main`.`id` = 1683782 OR `props-main`.`id` = 1652832 OR `props-main`.`id` = 1678429 OR `props-main`.`id` = 1664150 OR `props-main`.`id` = 1681921 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1680887 OR `props-main`.`id` = 1667858 OR `props-main`.`id` = 1678408 OR `props-main`.`id` = 1648679 OR `props-main`.`id` = 1684548 OR `props-main`.`id` = 1678333 OR `props-main`.`id` = 1670916 OR `props-main`.`id` = 1670992 OR `props-main`.`id` = 1683410 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1668274 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1661928 OR `props-main`.`id` = 1678195 OR `props-main`.`id` = 1678142 OR `props-main`.`id` = 1678169 OR `props-main`.`id` = 1652473 OR `props-main`.`id` = 1681393 OR `props-main`.`id` = 1683466 OR `props-main`.`id` = 1681649 OR `props-main`.`id` = 1677116 OR `props-main`.`id` = 1674552)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636579' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-09' 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();
7
Similar Properties
$399,900
2
2
1,383
0.03
510 W Mahogany Ln
Clovis, CA 93611
$394,999
2
2
1,383
0.03
563 N Chapel Hill Lane
Clovis, CA 93636
$394,990
3
2.5
1,227
0.05
1484 Farmhouse Ln
Clovis, CA 93619
$394,990
3
2.5
1,227
0.05
1501 Farmhouse Ln
Clovis, CA 93619
Courtesy of Paul Ladwig, California Relocation Network - paul@calirelonet.com Last modified 17 hours ago Fresno MLS last checked for updates 7 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.
