Please provide the following information and Connie Wilson-Velasco and Portia Luttrell will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.connieandportiahomes.com/agent/22125/conniewilsonvelasco-andportialuttrell/property/link/fresno/647408/3392-N-Forestiere-Ave/Fresno/https://www.connieandportiahomes.com/images/camerashy.pngLondon Properties Fresno Real Estate | 3392 N Forestiere Ave
This home is a 2-story corner lot in the Monte Vista Development. Family Room is located off a pass through breakfast bar/kitchen. Has a separate dining room with a fireplace in the living room with vaulted ceilings. The spacious back yard comes with a surrounded brick in ground vinyl 21' diameter circular pool. Includes a 3rd car garage/workshop, insulated with 220 feature, with RV access and covered patio(18X12).
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1992
Region
Urban
# of Stories
Two
Price Per Square Foot
$228
Price Per Acre
$2,825,230
Days On London
1
Cumulative Days On London
1
County
Fresno
Leased Equipment
Solar Panels
Special Features
Isolated Bathroom, Security System, Built In Cabinets, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
Garland & Forestiere
Directions
West on Dakota pass Cornelia, take 2nd left on Forestiere. The home is located on the corner of Garland and Forestiere
Style
Tudor
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Pantry
Dining Room Features
Formal, Living Room/Area, Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower
Extra Rooms
Converted Garage
Flooring
Carpet, Tile, Vinyl
# of Fireplaces
1
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered, Other
Yard
Sprinklers Front, Sprinklers Back, Other
Gas & Electric
All Electric
Sewer / Water
Public Water
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Lease
Parking Features
Existing RV Parking, Potential RV Parking, Work/Shop Area, Auto Opener, Other
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1636 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2136 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` = 1722239 OR `props-main`.`id` = 1721300 OR `props-main`.`id` = 1697222 OR `props-main`.`id` = 1718147 OR `props-main`.`id` = 1716472 OR `props-main`.`id` = 1713120 OR `props-main`.`id` = 1705341 OR `props-main`.`id` = 1718782 OR `props-main`.`id` = 1718790 OR `props-main`.`id` = 1721295 OR `props-main`.`id` = 1703904 OR `props-main`.`id` = 1703868 OR `props-main`.`id` = 1720112 OR `props-main`.`id` = 1712728 OR `props-main`.`id` = 1720781 OR `props-main`.`id` = 1719142 OR `props-main`.`id` = 1718678 OR `props-main`.`id` = 1718513 OR `props-main`.`id` = 804394 OR `props-main`.`id` = 1691526 OR `props-main`.`id` = 1691547 OR `props-main`.`id` = 1718779 OR `props-main`.`id` = 1718888 OR `props-main`.`id` = 1721956 OR `props-main`.`id` = 1715778 OR `props-main`.`id` = 1717665 OR `props-main`.`id` = 1719166 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1708353 OR `props-main`.`id` = 1719736 OR `props-main`.`id` = 1709206 OR `props-main`.`id` = 1721469 OR `props-main`.`id` = 1702615 OR `props-main`.`id` = 1701302 OR `props-main`.`id` = 1717390 OR `props-main`.`id` = 1721281 OR `props-main`.`id` = 1713026 OR `props-main`.`id` = 1715802 OR `props-main`.`id` = 1718848 OR `props-main`.`id` = 1703110 OR `props-main`.`id` = 1714621 OR `props-main`.`id` = 1713160 OR `props-main`.`id` = 1696810 OR `props-main`.`id` = 1721493 OR `props-main`.`id` = 1713605 OR `props-main`.`id` = 1719479 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1720499 OR `props-main`.`id` = 1722246 OR `props-main`.`id` = 1691122 OR `props-main`.`id` = 1694955 OR `props-main`.`id` = 1717342 OR `props-main`.`id` = 1696403 OR `props-main`.`id` = 1722337 OR `props-main`.`id` = 1718531 OR `props-main`.`id` = 1722484 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1711243 OR `props-main`.`id` = 1719156 OR `props-main`.`id` = 1678143 OR `props-main`.`id` = 1719387 OR `props-main`.`id` = 1708197 OR `props-main`.`id` = 1718851 OR `props-main`.`id` = 1712721 OR `props-main`.`id` = 1722190 OR `props-main`.`id` = 1660446 OR `props-main`.`id` = 1664574 OR `props-main`.`id` = 1722404 OR `props-main`.`id` = 1717032 OR `props-main`.`id` = 1706015 OR `props-main`.`id` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 1714024 OR `props-main`.`id` = 1722205 OR `props-main`.`id` = 1714022 OR `props-main`.`id` = 1716175 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1720501 OR `props-main`.`id` = 1717289 OR `props-main`.`id` = 1698470 OR `props-main`.`id` = 1717072 OR `props-main`.`id` = 1719727 OR `props-main`.`id` = 1712774 OR `props-main`.`id` = 1722198 OR `props-main`.`id` = 1718964 OR `props-main`.`id` = 1710280 OR `props-main`.`id` = 1716158 OR `props-main`.`id` = 1688794 OR `props-main`.`id` = 1716428 OR `props-main`.`id` = 1720955 OR `props-main`.`id` = 1719468 OR `props-main`.`id` = 1703809 OR `props-main`.`id` = 1691506 OR `props-main`.`id` = 1688199 OR `props-main`.`id` = 1720601 OR `props-main`.`id` = 1721517 OR `props-main`.`id` = 1712629 OR `props-main`.`id` = 1700030 OR `props-main`.`id` = 1714834 OR `props-main`.`id` = 1715662 OR `props-main`.`id` = 1677783 OR `props-main`.`id` = 1699177 OR `props-main`.`id` = 1722345 OR `props-main`.`id` = 1706840 OR `props-main`.`id` = 1713562 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1718476 OR `props-main`.`id` = 1691819 OR `props-main`.`id` = 1713567 OR `props-main`.`id` = 1708388 OR `props-main`.`id` = 1693937 OR `props-main`.`id` = 1716816 OR `props-main`.`id` = 1716822 OR `props-main`.`id` = 1703327 OR `props-main`.`id` = 1702452 OR `props-main`.`id` = 1720752 OR `props-main`.`id` = 1623993 OR `props-main`.`id` = 1624007 OR `props-main`.`id` = 1624009 OR `props-main`.`id` = 1665944 OR `props-main`.`id` = 1665945 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1696600 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1694431)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647408' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-18' 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();
6
Similar Properties
$443,990
4
2.5
1,924
0.07
6413 W Austin Way (Lot 50)
Fresno, CA 93723
$442,990
4
2.5
1,924
0.07
6429 W Austin Way (Lot 48)
Fresno, CA 93723
$434,900
4
3
2,083
0.14
4622 W Flint Way
Fresno, CA 93722
$414,999
5
3
1,775
0.07
4626 W Javier Way
Fresno, CA 93722
Courtesy of Connie Wilson, London Properties, Ltd. - cwilson@londonproperties.com Last modified 12 hours ago Fresno MLS last checked for updates 1 hour 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.
