Please provide the following information and Larry Schrimp will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lplenderservices.com/agent/10259/larry-schrimp/property/link/fresno/611119/2258-E-Ticonderoga-Dr/Fresno/Woodward-Park/https://www.lplenderservices.com/images/props/fresno/full/611119.jpgLondon Properties Fresno Real Estate | 2258 E Ticonderoga Dr
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Welcome home to this beautiful NE Fresno gem! This lovely 5 bedroom, 2.75 bath home is situated on a spacious 6100 sq ft lot, nestled in a family friendly neighborhood in close proximity to award winning Clovis schools. This home has been updated with custom cabinetry, wood flooring, stainless appliances, including Wolf gas range with griddle and warming drawer. There is a nice flex space between the garage and kitchen that can be used as a mudroom, home office/ kids homework station or dining nook. The walk-in pantry is super spacious and well designed. Enjoy the benefits of having a downstairs bedroom and bathroom. Whether for guests or in-laws, there is plenty of space for comfort and privacy.The beautiful staircase leads you upstairs to the additional 4 bedroom and 2 baths. Entertain friends and family outdoors as the rear yard has mature landscaping and plenty of room for a pool, play equipment, garden and more. You are going to love this home!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Urban
# of Stories
Two
Price Per Square Foot
$263
Price Per Acre
$4,463,571
Days On Market
14
Cumulative Days On Market
14
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
CHESTNUT/PERRIN
Directions
From Chestnut & Perrin take Chestnut north, right on Plymouth Way, right on Backer, left on Sierra Vista, left on Ticonderoga.
Unit Description
Ground Floor
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
In Garage, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2128 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2628 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` = 54055 OR `props-main`.`id` = 1587745 OR `props-main`.`id` = 1580862 OR `props-main`.`id` = 1577949 OR `props-main`.`id` = 1588486 OR `props-main`.`id` = 1587250 OR `props-main`.`id` = 1585847 OR `props-main`.`id` = 1585513 OR `props-main`.`id` = 1583048 OR `props-main`.`id` = 1579740 OR `props-main`.`id` = 1586464 OR `props-main`.`id` = 1586508 OR `props-main`.`id` = 1588437 OR `props-main`.`id` = 1583152 OR `props-main`.`id` = 1586696 OR `props-main`.`id` = 1588690 OR `props-main`.`id` = 1588408 OR `props-main`.`id` = 1585949 OR `props-main`.`id` = 1588432 OR `props-main`.`id` = 1585002 OR `props-main`.`id` = 1585006 OR `props-main`.`id` = 1581031 OR `props-main`.`id` = 1582546 OR `props-main`.`id` = 1581826 OR `props-main`.`id` = 1581978 OR `props-main`.`id` = 1581798 OR `props-main`.`id` = 1581193 OR `props-main`.`id` = 1586052 OR `props-main`.`id` = 1578253 OR `props-main`.`id` = 1580173 OR `props-main`.`id` = 1588851 OR `props-main`.`id` = 1588364 OR `props-main`.`id` = 1582090 OR `props-main`.`id` = 1582966 OR `props-main`.`id` = 1588362 OR `props-main`.`id` = 1589487 OR `props-main`.`id` = 1589351 OR `props-main`.`id` = 1582397 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1584756 OR `props-main`.`id` = 1588752 OR `props-main`.`id` = 1578038 OR `props-main`.`id` = 1582573 OR `props-main`.`id` = 1587768 OR `props-main`.`id` = 1588226 OR `props-main`.`id` = 1580822 OR `props-main`.`id` = 1585977 OR `props-main`.`id` = 1588294 OR `props-main`.`id` = 1587053 OR `props-main`.`id` = 1586031 OR `props-main`.`id` = 1588729 OR `props-main`.`id` = 1589079 OR `props-main`.`id` = 1556348 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1586794 OR `props-main`.`id` = 1586447 OR `props-main`.`id` = 1586999 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1588049 OR `props-main`.`id` = 1587651 OR `props-main`.`id` = 1576993 OR `props-main`.`id` = 1588918 OR `props-main`.`id` = 1588266 OR `props-main`.`id` = 1589485 OR `props-main`.`id` = 1569021 OR `props-main`.`id` = 1586275 OR `props-main`.`id` = 1585698 OR `props-main`.`id` = 1584232 OR `props-main`.`id` = 1586583 OR `props-main`.`id` = 1581228 OR `props-main`.`id` = 1589372 OR `props-main`.`id` = 1585768 OR `props-main`.`id` = 1568121 OR `props-main`.`id` = 1585822 OR `props-main`.`id` = 1567339 OR `props-main`.`id` = 981418 OR `props-main`.`id` = 1587573 OR `props-main`.`id` = 1588719 OR `props-main`.`id` = 1584445 OR `props-main`.`id` = 1582163 OR `props-main`.`id` = 1580686 OR `props-main`.`id` = 1584309 OR `props-main`.`id` = 1587996 OR `props-main`.`id` = 1585719 OR `props-main`.`id` = 1584686 OR `props-main`.`id` = 1581524 OR `props-main`.`id` = 1581458 OR `props-main`.`id` = 1588001 OR `props-main`.`id` = 1589164 OR `props-main`.`id` = 1581632 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1585716 OR `props-main`.`id` = 1579107 OR `props-main`.`id` = 1583711 OR `props-main`.`id` = 1582833 OR `props-main`.`id` = 1588402 OR `props-main`.`id` = 1588002 OR `props-main`.`id` = 1566009 OR `props-main`.`id` = 1582840 OR `props-main`.`id` = 1586612 OR `props-main`.`id` = 1588724 OR `props-main`.`id` = 1584369 OR `props-main`.`id` = 1585601 OR `props-main`.`id` = 1585964 OR `props-main`.`id` = 1584465 OR `props-main`.`id` = 1588896 OR `props-main`.`id` = 1581429 OR `props-main`.`id` = 1571539 OR `props-main`.`id` = 1584408 OR `props-main`.`id` = 1584478 OR `props-main`.`id` = 1584200 OR `props-main`.`id` = 1587045 OR `props-main`.`id` = 1586828 OR `props-main`.`id` = 1577993 OR `props-main`.`id` = 1572064 OR `props-main`.`id` = 1580104 OR `props-main`.`id` = 1581900)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611119' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-03' 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();
Courtesy of Laura Mather, London Properties, Ltd. - lmather@londonproperties.com Last modified 2 weeks 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.
