Please provide the following information and Ruth Reisz will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/24/ruth-reisz/property/link/fresno/638411/787-E-Vermont-Ave/Fresno/Woodward-Park/https://www.londonproperties.com/images/props/fresno/full/638411.jpgLondon Properties Fresno Real Estate | 787 E Vermont Ave
Love and care perfectly describes this 4 bedroom 2 bath custom home in desirable Parkwood Estates near Fort Washington Elementary, Clovis West HS and Tice Park! Owners have remodeled and updated for ultimate comfort and energy efficiency including PAID SOLAR. Front fenced courtyard offers privacy and the perfect spot for morning coffee. Living room with beamed ceiling & wet bar. Family room with fireplace and attractive built-in cabinets is currently being used as a formal dining room. Spacious kitchen has large quartz center island with additional cabinets, double oven and greenhouse window overlooking backyard. Breakfast nook plus large walk in pantry. Primary suite with plenty of closet space and jetted tub with shower..4th bedroom off entry makes the perfect home office. Decorator features include crown moldings, barn doors & custom wall and ceiling treatments. Sparkling pool, large covered patio and elevated covered sitting area make the backyard the perfect place to gather and enjoy the north/south exposure this fall. 3 car garage (3rd car has drive-through to back work/storage area). Visit and compare today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1981
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$315
Price Per Acre
$2,560,393
Days On Market
5
Cumulative Days On Market
5
County
Fresno
Reports Available
Roof, Pest
REO / Bank Owned
No
Cross Street Address
S/Cole W/Millbrook
Directions
West on Cole Ave from N. Millbrook Ave. north on 4th St, west on Vermont. Home is on the south side of the street.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1654 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2154 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` = 1680596 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1676244 OR `props-main`.`id` = 1685294 OR `props-main`.`id` = 1674973 OR `props-main`.`id` = 1690962 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1688178 OR `props-main`.`id` = 1671794 OR `props-main`.`id` = 1680698 OR `props-main`.`id` = 186738 OR `props-main`.`id` = 1680404 OR `props-main`.`id` = 1678450 OR `props-main`.`id` = 1690936 OR `props-main`.`id` = 1690843 OR `props-main`.`id` = 1685733 OR `props-main`.`id` = 1690191 OR `props-main`.`id` = 1646640 OR `props-main`.`id` = 1681105 OR `props-main`.`id` = 1664428 OR `props-main`.`id` = 1681067 OR `props-main`.`id` = 1688804 OR `props-main`.`id` = 1658211 OR `props-main`.`id` = 1678332 OR `props-main`.`id` = 1679036 OR `props-main`.`id` = 1679646 OR `props-main`.`id` = 1680162 OR `props-main`.`id` = 1690021 OR `props-main`.`id` = 1688652 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1686256 OR `props-main`.`id` = 1686238 OR `props-main`.`id` = 1686247 OR `props-main`.`id` = 1678724 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` = 1686073 OR `props-main`.`id` = 1685194 OR `props-main`.`id` = 1678246 OR `props-main`.`id` = 1655095 OR `props-main`.`id` = 1658242 OR `props-main`.`id` = 1683435 OR `props-main`.`id` = 1666576 OR `props-main`.`id` = 1689516 OR `props-main`.`id` = 1681683 OR `props-main`.`id` = 1689280 OR `props-main`.`id` = 1688558 OR `props-main`.`id` = 1689221 OR `props-main`.`id` = 1687048 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1681326 OR `props-main`.`id` = 1683120 OR `props-main`.`id` = 1686673 OR `props-main`.`id` = 1645406 OR `props-main`.`id` = 1689214 OR `props-main`.`id` = 1684568 OR `props-main`.`id` = 1681984 OR `props-main`.`id` = 1681862 OR `props-main`.`id` = 1681098 OR `props-main`.`id` = 1688809 OR `props-main`.`id` = 1680452 OR `props-main`.`id` = 1678426 OR `props-main`.`id` = 1689401 OR `props-main`.`id` = 1688583 OR `props-main`.`id` = 1689883 OR `props-main`.`id` = 1668344 OR `props-main`.`id` = 1682169 OR `props-main`.`id` = 1681517 OR `props-main`.`id` = 1639834 OR `props-main`.`id` = 1681709 OR `props-main`.`id` = 1685903 OR `props-main`.`id` = 1686969 OR `props-main`.`id` = 1665746 OR `props-main`.`id` = 1687233 OR `props-main`.`id` = 1686283 OR `props-main`.`id` = 1691036 OR `props-main`.`id` = 1691039 OR `props-main`.`id` = 1687794 OR `props-main`.`id` = 1690510 OR `props-main`.`id` = 1682171 OR `props-main`.`id` = 1687260 OR `props-main`.`id` = 1664386 OR `props-main`.`id` = 1664016 OR `props-main`.`id` = 1688308 OR `props-main`.`id` = 1687198 OR `props-main`.`id` = 1663479 OR `props-main`.`id` = 1690799 OR `props-main`.`id` = 1686700 OR `props-main`.`id` = 1674323 OR `props-main`.`id` = 1678589 OR `props-main`.`id` = 1688309 OR `props-main`.`id` = 1683209 OR `props-main`.`id` = 1687060 OR `props-main`.`id` = 1686224 OR `props-main`.`id` = 1674975 OR `props-main`.`id` = 1675085 OR `props-main`.`id` = 1674616 OR `props-main`.`id` = 1689449 OR `props-main`.`id` = 1689841 OR `props-main`.`id` = 1687902 OR `props-main`.`id` = 1684858 OR `props-main`.`id` = 1680578 OR `props-main`.`id` = 1689054 OR `props-main`.`id` = 1689036 OR `props-main`.`id` = 1689070 OR `props-main`.`id` = 1683677 OR `props-main`.`id` = 1680632 OR `props-main`.`id` = 1665791 OR `props-main`.`id` = 1689170 OR `props-main`.`id` = 1690106 OR `props-main`.`id` = 1685253 OR `props-main`.`id` = 1685217 OR `props-main`.`id` = 1687089 OR `props-main`.`id` = 1680432 OR `props-main`.`id` = 1678429 OR `props-main`.`id` = 1690450 OR `props-main`.`id` = 1676442 OR `props-main`.`id` = 1678006 OR `props-main`.`id` = 1681921 OR `props-main`.`id` = 1685574 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1683361 OR `props-main`.`id` = 1667858 OR `props-main`.`id` = 1684580 OR `props-main`.`id` = 1690352 OR `props-main`.`id` = 1684777 OR `props-main`.`id` = 1678408 OR `props-main`.`id` = 1674917 OR `props-main`.`id` = 1678833 OR `props-main`.`id` = 1685351 OR `props-main`.`id` = 1690004 OR `props-main`.`id` = 1690755 OR `props-main`.`id` = 1684548 OR `props-main`.`id` = 1683286 OR `props-main`.`id` = 1676631 OR `props-main`.`id` = 1682072 OR `props-main`.`id` = 1678412 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1668411 OR `props-main`.`id` = 1689805 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1683906 OR `props-main`.`id` = 1686932 OR `props-main`.`id` = 1681393 OR `props-main`.`id` = 1681129 OR `props-main`.`id` = 1681100 OR `props-main`.`id` = 1690650 OR `props-main`.`id` = 1641368 OR `props-main`.`id` = 1675415 OR `props-main`.`id` = 1691004 OR `props-main`.`id` = 1681716 OR `props-main`.`id` = 1658669 OR `props-main`.`id` = 1646142 OR `props-main`.`id` = 1680759)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638411' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
2
Similar Properties
$595,000
4
2
2,014
0.21
8418 N Del Mar Ave
Fresno, CA 93711
$589,000
4
3
2,080
0.19
1039 E Oakmont Ave
Fresno, CA 93730
Courtesy of Bob Wiginton, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 14 hours 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.
