Listing Agent: Christie Majors, Real Brokerage Technologies
Reduced just for You ! Beautifully maintained 3-bedroom home in Clovis Unified near Shepherd & Clovis! Enjoy PPA solar, laminate flooring, granite counters with custom tile backsplash, smart plugs, and a 3-car drive-thru garage. The backyard is ready for fun with a sparkling pool plus grassy area for kids, pets, or entertaining. Walk to Dry Creek Trail, with schools, shopping, dining, and everyday conveniences just minutes away. Seller's have the contractor to make the extended master into a 4th bedroom and can meet with you!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2005
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
main
Price Per Square Foot
$314
Days On London
0
Cumulative Days On London
0
County Or Parish
Fresno
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Minnewawa south to Teague, turn east, turn left on Harvard. House is straight from there
Room Type
All Bedrooms Down
Heating
Solar, Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Gas Dryer Hookup
Roof
Composition
Direction Faces
South
Other Structures
Gazebo
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
2
Room Kitchen Features
Remodeled Kitchen, Granite Counters
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Appliances
Disposal, Gas Oven, Dishwasher, Electric Cooktop
Room Bathroom Features
Bathtub, Shower
Interior Features
Built-in Features, High Ceilings, Ceiling Fan(s), Pantry, Granite Counters
Flooring
Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Two Way
Pool Features
Private
Pool Private Y/N
Yes
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Covered
Utilities
Natural Gas Connected, Sewer Connected, Cable Connected, Electricity Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
3.00
Parking Features
Garage, Garage Faces Front
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Lot 6500-9999, Sprinklers Drip System
Lot Size Area
8625.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
56033108
Additional Parcels Y/N
No
Community Features
Urban, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Clovis Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
58
Tax Tract Number
5131
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1903 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2403 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` = 1767779 OR `props-main`.`id` = 1767762 OR `props-main`.`id` = 1732361 OR `props-main`.`id` = 1761462 OR `props-main`.`id` = 1738209 OR `props-main`.`id` = 1758321 OR `props-main`.`id` = 1754702 OR `props-main`.`id` = 1754967 OR `props-main`.`id` = 1754965 OR `props-main`.`id` = 1774124 OR `props-main`.`id` = 1774842 OR `props-main`.`id` = 1774926 OR `props-main`.`id` = 1774502 OR `props-main`.`id` = 1767577 OR `props-main`.`id` = 1751330 OR `props-main`.`id` = 1752147 OR `props-main`.`id` = 1772095 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1749723 OR `props-main`.`id` = 1761852 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1774925 OR `props-main`.`id` = 1774181 OR `props-main`.`id` = 1775074 OR `props-main`.`id` = 1774684 OR `props-main`.`id` = 1736632 OR `props-main`.`id` = 1736611 OR `props-main`.`id` = 1759439 OR `props-main`.`id` = 1755862 OR `props-main`.`id` = 1756208 OR `props-main`.`id` = 1763604 OR `props-main`.`id` = 1766301 OR `props-main`.`id` = 1763285 OR `props-main`.`id` = 1744635 OR `props-main`.`id` = 1748966 OR `props-main`.`id` = 1767041 OR `props-main`.`id` = 1765448 OR `props-main`.`id` = 1764114 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1746461 OR `props-main`.`id` = 1774179 OR `props-main`.`id` = 1775041 OR `props-main`.`id` = 1750117 OR `props-main`.`id` = 1744938 OR `props-main`.`id` = 1730174 OR `props-main`.`id` = 1771257 OR `props-main`.`id` = 1749962 OR `props-main`.`id` = 1774839 OR `props-main`.`id` = 1774205 OR `props-main`.`id` = 1772828 OR `props-main`.`id` = 1769084 OR `props-main`.`id` = 1734829 OR `props-main`.`id` = 1749065 OR `props-main`.`id` = 1728572 OR `props-main`.`id` = 1728333 OR `props-main`.`id` = 1728447 OR `props-main`.`id` = 1759511 OR `props-main`.`id` = 1764565 OR `props-main`.`id` = 1763391 OR `props-main`.`id` = 1770992 OR `props-main`.`id` = 1759004 OR `props-main`.`id` = 1775554 OR `props-main`.`id` = 1754731 OR `props-main`.`id` = 1721190 OR `props-main`.`id` = 1752236 OR `props-main`.`id` = 1715704 OR `props-main`.`id` = 1713613 OR `props-main`.`id` = 1715710 OR `props-main`.`id` = 1772200 OR `props-main`.`id` = 1729119 OR `props-main`.`id` = 1729135 OR `props-main`.`id` = 1747217 OR `props-main`.`id` = 1764443 OR `props-main`.`id` = 1764424 OR `props-main`.`id` = 1754348 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1746896 OR `props-main`.`id` = 1766282 OR `props-main`.`id` = 1766797 OR `props-main`.`id` = 1764801 OR `props-main`.`id` = 1773784 OR `props-main`.`id` = 1775487 OR `props-main`.`id` = 1755151 OR `props-main`.`id` = 1753412 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1774747 OR `props-main`.`id` = 1770308 OR `props-main`.`id` = 1774052 OR `props-main`.`id` = 1761774 OR `props-main`.`id` = 1731795 OR `props-main`.`id` = 1766284 OR `props-main`.`id` = 1775259 OR `props-main`.`id` = 1773974 OR `props-main`.`id` = 1727742 OR `props-main`.`id` = 1727740 OR `props-main`.`id` = 1727738 OR `props-main`.`id` = 1727737 OR `props-main`.`id` = 1754304 OR `props-main`.`id` = 1754303 OR `props-main`.`id` = 1754300 OR `props-main`.`id` = 1754302 OR `props-main`.`id` = 1754301 OR `props-main`.`id` = 1754299 OR `props-main`.`id` = 1727377 OR `props-main`.`id` = 1775567 OR `props-main`.`id` = 1754296 OR `props-main`.`id` = 1762836 OR `props-main`.`id` = 1758320 OR `props-main`.`id` = 1774923 OR `props-main`.`id` = 1769052 OR `props-main`.`id` = 1732770 OR `props-main`.`id` = 1726901 OR `props-main`.`id` = 1760193 OR `props-main`.`id` = 1766787 OR `props-main`.`id` = 1760418 OR `props-main`.`id` = 1771392 OR `props-main`.`id` = 1756523 OR `props-main`.`id` = 1732813 OR `props-main`.`id` = 1765524 OR `props-main`.`id` = 1737032 OR `props-main`.`id` = 1735550 OR `props-main`.`id` = 1735502 OR `props-main`.`id` = 1773063 OR `props-main`.`id` = 1768392 OR `props-main`.`id` = 1766384 OR `props-main`.`id` = 1773066 OR `props-main`.`id` = 1763287 OR `props-main`.`id` = 1759481 OR `props-main`.`id` = 1759437 OR `props-main`.`id` = 1759482 OR `props-main`.`id` = 1759656 OR `props-main`.`id` = 1752195 OR `props-main`.`id` = 1752209 OR `props-main`.`id` = 1752227 OR `props-main`.`id` = 1757713 OR `props-main`.`id` = 1774922 OR `props-main`.`id` = 1761623 OR `props-main`.`id` = 1766440 OR `props-main`.`id` = 1762249 OR `props-main`.`id` = 1746188 OR `props-main`.`id` = 1746187 OR `props-main`.`id` = 1766444 OR `props-main`.`id` = 1758891 OR `props-main`.`id` = 1758923 OR `props-main`.`id` = 1758925 OR `props-main`.`id` = 1746198 OR `props-main`.`id` = 1758892 OR `props-main`.`id` = 1766442 OR `props-main`.`id` = 1746199 OR `props-main`.`id` = 1766446 OR `props-main`.`id` = 1758864 OR `props-main`.`id` = 1758889 OR `props-main`.`id` = 1747248 OR `props-main`.`id` = 1766439 OR `props-main`.`id` = 1766445 OR `props-main`.`id` = 1758890 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1769625 OR `props-main`.`id` = 1758849 OR `props-main`.`id` = 1768605 OR `props-main`.`id` = 1755005 OR `props-main`.`id` = 1755025 OR `props-main`.`id` = 1755078 OR `props-main`.`id` = 1742074 OR `props-main`.`id` = 1731877 OR `props-main`.`id` = 1770448)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26200538' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-13' 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();
3
Similar Properties
$699,850
4
3
2,134
0.21
1888 El Paso Ave
Clovis, CA 93611
$675,000
4
3
2,221
0.23
493 W Omaha Ave
Clovis, CA 93619
$674,800
4
3
2,207
0.23
1170 N Homsy Ave
Clovis, CA 93611
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.
