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/611176/305-N-Maple-Ave/Fresno/McLane/https://www.lplenderservices.com/images/props/fresno/full/611176.jpgLondon Properties Fresno Real Estate | 305 N Maple Ave
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Welcome to your new Home! Step into luxury with this stunning property, meticulously remodeled from the ground up! Every detail has been carefully crafted to offer a blend of elegance and modern convenience. Inside, you'll be greeted by stylish vinyl flooring and fresh paint throughout, setting the stage for a contemporary living experience. The kitchen is a chef's dream, huge island, boasting quartz countertops, drop down island hood, a marble backsplash, and high-end appliances including an ice maker box. Indulge in spa-like relaxation in the upgraded bathrooms featuring rainfall showers, and cozy up by the electric fireplace against a striking stone wall. Rest easy knowing that all new ceiling fans installed for added comfort. Outside, the expansive lot provides ample space for outdoor activities and potential for an ADU (Accessory Dwelling Unit) or parking trailers. A gated backyard offers privacy and security, while the laundry room has been updated for added convenience. Recent improvements also include AC repairs, a new gate, and a sleek black paint job. Don't miss out on this exceptional opportunity to own a fully remodeled home with endless possibilities! Contact us today to schedule a viewing.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1939
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$301
Price Per Acre
$1,275,862
Days On Market
14
Cumulative Days On Market
14
County
Fresno
REO / Bank Owned
No
Cross Street Address
Tulare and maple
Directions
Take exit 60B toward Cedar Ave, turn left onto N Cedar Ave, turn left onto E Belmont Ave then turn.
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 351500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 388500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 978 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1478 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` = 1589131 OR `props-main`.`id` = 1557337 OR `props-main`.`id` = 1589531 OR `props-main`.`id` = 1585859 OR `props-main`.`id` = 1584405 OR `props-main`.`id` = 1580881 OR `props-main`.`id` = 1588877 OR `props-main`.`id` = 1582028 OR `props-main`.`id` = 1588222 OR `props-main`.`id` = 1589161 OR `props-main`.`id` = 1581572 OR `props-main`.`id` = 1570979 OR `props-main`.`id` = 1588234 OR `props-main`.`id` = 1566663 OR `props-main`.`id` = 1585032 OR `props-main`.`id` = 1585625 OR `props-main`.`id` = 1587001 OR `props-main`.`id` = 1588674 OR `props-main`.`id` = 1588060 OR `props-main`.`id` = 1588742 OR `props-main`.`id` = 1580097 OR `props-main`.`id` = 1586974 OR `props-main`.`id` = 1553762 OR `props-main`.`id` = 1589456 OR `props-main`.`id` = 1572133 OR `props-main`.`id` = 1577761 OR `props-main`.`id` = 1572109 OR `props-main`.`id` = 1577760 OR `props-main`.`id` = 1579029 OR `props-main`.`id` = 1573390 OR `props-main`.`id` = 1585642 OR `props-main`.`id` = 1577508 OR `props-main`.`id` = 1588786 OR `props-main`.`id` = 1585517 OR `props-main`.`id` = 1583090 OR `props-main`.`id` = 1582019 OR `props-main`.`id` = 194016 OR `props-main`.`id` = 1576138 OR `props-main`.`id` = 1577860 OR `props-main`.`id` = 1577911 OR `props-main`.`id` = 1589168 OR `props-main`.`id` = 1583947 OR `props-main`.`id` = 1583601 OR `props-main`.`id` = 1584958 OR `props-main`.`id` = 1572891 OR `props-main`.`id` = 1577525 OR `props-main`.`id` = 1588504 OR `props-main`.`id` = 1578501 OR `props-main`.`id` = 1578498 OR `props-main`.`id` = 1576107 OR `props-main`.`id` = 1479802 OR `props-main`.`id` = 1586701 OR `props-main`.`id` = 1588050 OR `props-main`.`id` = 1589419 OR `props-main`.`id` = 1578176 OR `props-main`.`id` = 1578179 OR `props-main`.`id` = 1578170 OR `props-main`.`id` = 1582511 OR `props-main`.`id` = 1576483 OR `props-main`.`id` = 1583348 OR `props-main`.`id` = 1577529 OR `props-main`.`id` = 1577539 OR `props-main`.`id` = 1577549 OR `props-main`.`id` = 1577552 OR `props-main`.`id` = 1585697 OR `props-main`.`id` = 1585680 OR `props-main`.`id` = 1585685 OR `props-main`.`id` = 1585700 OR `props-main`.`id` = 1585682 OR `props-main`.`id` = 1582654 OR `props-main`.`id` = 232302 OR `props-main`.`id` = 232595 OR `props-main`.`id` = 1574941 OR `props-main`.`id` = 1574926 OR `props-main`.`id` = 1574938 OR `props-main`.`id` = 1574930 OR `props-main`.`id` = 1574943 OR `props-main`.`id` = 1577907 OR `props-main`.`id` = 1587044 OR `props-main`.`id` = 1576502 OR `props-main`.`id` = 1576505 OR `props-main`.`id` = 1580792 OR `props-main`.`id` = 1583000 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1587999 OR `props-main`.`id` = 1583381 OR `props-main`.`id` = 1584524 OR `props-main`.`id` = 1583377 OR `props-main`.`id` = 1586700 OR `props-main`.`id` = 1587629 OR `props-main`.`id` = 1584974 OR `props-main`.`id` = 1587648 OR `props-main`.`id` = 1578965 OR `props-main`.`id` = 1567940 OR `props-main`.`id` = 1578628 OR `props-main`.`id` = 1586425 OR `props-main`.`id` = 1584543 OR `props-main`.`id` = 1575443 OR `props-main`.`id` = 1577905 OR `props-main`.`id` = 1575445 OR `props-main`.`id` = 1583640 OR `props-main`.`id` = 1578924 OR `props-main`.`id` = 1585018 OR `props-main`.`id` = 1585024 OR `props-main`.`id` = 1577893 OR `props-main`.`id` = 1575446 OR `props-main`.`id` = 1575461 OR `props-main`.`id` = 1567503 OR `props-main`.`id` = 1586306 OR `props-main`.`id` = 1571197 OR `props-main`.`id` = 1587251 OR `props-main`.`id` = 1557264 OR `props-main`.`id` = 1562130 OR `props-main`.`id` = 1587036 OR `props-main`.`id` = 1583092 OR `props-main`.`id` = 1584876 OR `props-main`.`id` = 1575625 OR `props-main`.`id` = 1582986 OR `props-main`.`id` = 1587047 OR `props-main`.`id` = 1583091 OR `props-main`.`id` = 1588980 OR `props-main`.`id` = 52454 OR `props-main`.`id` = 361177 OR `props-main`.`id` = 282686 OR `props-main`.`id` = 1588425 OR `props-main`.`id` = 1583694 OR `props-main`.`id` = 1583704 OR `props-main`.`id` = 1585521 OR `props-main`.`id` = 1586673 OR `props-main`.`id` = 1588521 OR `props-main`.`id` = 1581348 OR `props-main`.`id` = 1581182 OR `props-main`.`id` = 1581174 OR `props-main`.`id` = 1562979 OR `props-main`.`id` = 1582672 OR `props-main`.`id` = 1583835 OR `props-main`.`id` = 1583842 OR `props-main`.`id` = 1580493 OR `props-main`.`id` = 1585069 OR `props-main`.`id` = 1571560 OR `props-main`.`id` = 1585647 OR `props-main`.`id` = 1585551 OR `props-main`.`id` = 1587040 OR `props-main`.`id` = 1588744 OR `props-main`.`id` = 1588965 OR `props-main`.`id` = 1588961 OR `props-main`.`id` = 1563891 OR `props-main`.`id` = 1577246 OR `props-main`.`id` = 1587276 OR `props-main`.`id` = 1581324 OR `props-main`.`id` = 1585236 OR `props-main`.`id` = 1586743 OR `props-main`.`id` = 1584747 OR `props-main`.`id` = 1545174 OR `props-main`.`id` = 1544912 OR `props-main`.`id` = 1583205 OR `props-main`.`id` = 1585460 OR `props-main`.`id` = 1585458 OR `props-main`.`id` = 1538327 OR `props-main`.`id` = 1553968 OR `props-main`.`id` = 1555765 OR `props-main`.`id` = 1585133 OR `props-main`.`id` = 1569210 OR `props-main`.`id` = 1588930 OR `props-main`.`id` = 1588921 OR `props-main`.`id` = 1575239 OR `props-main`.`id` = 1589454 OR `props-main`.`id` = 1589413 OR `props-main`.`id` = 1579688 OR `props-main`.`id` = 1582154 OR `props-main`.`id` = 1587762 OR `props-main`.`id` = 1587767 OR `props-main`.`id` = 1586121 OR `props-main`.`id` = 1584111 OR `props-main`.`id` = 1589347 OR `props-main`.`id` = 1589337 OR `props-main`.`id` = 1581772 OR `props-main`.`id` = 507301 OR `props-main`.`id` = 1586122)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611176' 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();
Similar Properties
$375,000
3
1
1,377
0.25
4156 E Huntington Blvd
Fresno, CA 93702
$365,000
5
3
1,086
0.14
4565 E Madison Ave
Fresno, CA 93702
$359,999
3
2
1,349
0.20
807 N Orangewood Ave
Fresno, CA 93727
$355,000
3
2
1,278
0.19
4611 E Woodward Ave
Fresno, CA 93702
Courtesy of Thethong Thepvong, Realty Concepts, Ltd. - Clovis - phillip@realtyconcepts.com Last modified 3 days 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.