London Properties Fresno Real Estate

5286 N Maruyama Ave

Fresno, CA 93723

Copy Link Get Directions

Photo Gallery

$474,950

4 bd

2 ba

1,899 sq ft

0.14 acre

5286 N Maruyama Ave

Fresno, CA 93723

Get Directions

Virtual Tour

Listed On: 09/05/2025

Status: Active

Listing Number: 636445 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Back on the market through NO fault of the sellers. Every inspection imaginable has already been completed, giving the next buyer added confidence, and thousands of dollars in saved upfront costs. This home is truly ready for its next owner!Discover this modern single-story Lennar home designed for open-concept daily living. The kitchen, dining and living areas flow seamlessly together for effortless entertaining and family time.The four-bedroom configuration (buyer to verify) includes a flexible fourth room ideal for a home office, media space, or guest retreat, plus two full baths.Upgraded engineered hardwood flooring (installed 2022) extends through the main living areas, halls and flex room.Outdoor improvements include new north-side cement work, an extended paver walkway (2023) and a private fenced backyard perfect for relaxation or gatherings.The garage is equipped with a Tesla EV charging outlet and overhead storage. An energy-efficient 3.180 kW Solar Power Purchase Agreement (PPA) helps keep the utility costs lower (see attached solar docs for details).Conveniently located only 2.2 miles from The Marketplace at El Paseo, offering shopping, dining, coffee and entertainment options such as Dutch Bros, Panera, Olive Garden, Crumble Cookie and Regal Cinema. Easy commuter access via Veterans Blvd Herndon Ave and Hwy 99.Neighborhood highlights: nearby community play parks and local schools including Herndon/Barstow Elementary, Rio Vista Middle School, and Justin Garza High.Don't miss the Video Walkthrough and drone footage available in the photo section for a full property tour!

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2016

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$250

Price Per Acre

$3,449,165

Days On London

152

Cumulative Days On London

152

County

Fresno

Special Features

Other/See Remarks

REO / Bank Owned

Cross Street Address

Grantland and W San Bruno

Directions

Head West on Herndon and take the new North Veteran's Blvd. to W Barstow, left on Grantland Ave and right on W San Bruno and first left onto Maruyama and house will be on your left

Special Disclosure

Agent/Owner Related

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Composition

Foundation

Concrete

Kitchen

Gas Appliances

Primary Bedroom Level

Lower

Bath Features

Tub/Shower, Shower

Extra Rooms

Office, Den/Study, Other

Flooring

Carpet, Tile, Hardwood

Exterior

Stucco, Stone

Pool

Yard

Sprinklers Front, Synthetic Lawn, Drip System

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Solar

Yes

Solar Type

Power Purchase AGMT

Garage Type

Attached

Garage Spaces

APN

505 356 04 [PARCEL MAP]

Zoning

School District

Central Unified

School Type 1

High School

School Name 1

Justin Garza High

School Type 2

Junior High School

School Name 2

Rio Vista

School Type 3

Grade School

School Name 3

Herndon-Barstow

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451202.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498697.5 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) >= 1649 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2149 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` = 1692154 OR `props-main`.`id` = 1692283 OR `props-main`.`id` = 1692315 OR `props-main`.`id` = 1692281 OR `props-main`.`id` = 1708197 OR `props-main`.`id` = 1689271 OR `props-main`.`id` = 1703328 OR `props-main`.`id` = 1698470 OR `props-main`.`id` = 1698441 OR `props-main`.`id` = 1712774 OR `props-main`.`id` = 1697787 OR `props-main`.`id` = 1698161 OR `props-main`.`id` = 1698167 OR `props-main`.`id` = 1695664 OR `props-main`.`id` = 1705346 OR `props-main`.`id` = 1705639 OR `props-main`.`id` = 1710280 OR `props-main`.`id` = 1705729 OR `props-main`.`id` = 1688794 OR `props-main`.`id` = 1697225 OR `props-main`.`id` = 1707128 OR `props-main`.`id` = 1703493 OR `props-main`.`id` = 1703621 OR `props-main`.`id` = 1691506 OR `props-main`.`id` = 1703640 OR `props-main`.`id` = 1688199 OR `props-main`.`id` = 1683211 OR `props-main`.`id` = 1703021 OR `props-main`.`id` = 1712629 OR `props-main`.`id` = 1706840 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1698711 OR `props-main`.`id` = 1694449 OR `props-main`.`id` = 1691819 OR `props-main`.`id` = 1700194 OR `props-main`.`id` = 1703081 OR `props-main`.`id` = 1705692 OR `props-main`.`id` = 1708388 OR `props-main`.`id` = 1693937 OR `props-main`.`id` = 1705372 OR `props-main`.`id` = 1709671 OR `props-main`.`id` = 1681699 OR `props-main`.`id` = 1690592 OR `props-main`.`id` = 1702793 OR `props-main`.`id` = 1703327 OR `props-main`.`id` = 1702452 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` = 1712506 OR `props-main`.`id` = 1696600 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1712900 OR `props-main`.`id` = 1669960 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1712945 OR `props-main`.`id` = 1707034 OR `props-main`.`id` = 1705678 OR `props-main`.`id` = 1712638 OR `props-main`.`id` = 1712948 OR `props-main`.`id` = 1712885 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1697235 OR `props-main`.`id` = 1703125 OR `props-main`.`id` = 1712871 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 1706982 OR `props-main`.`id` = 1702865 OR `props-main`.`id` = 1709838 OR `props-main`.`id` = 1703267 OR `props-main`.`id` = 1704751 OR `props-main`.`id` = 1704953 OR `props-main`.`id` = 1704376 OR `props-main`.`id` = 1712624 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1706774 OR `props-main`.`id` = 1706050 OR `props-main`.`id` = 1707885 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1712664 OR `props-main`.`id` = 1707108 OR `props-main`.`id` = 1703916 OR `props-main`.`id` = 1712914 OR `props-main`.`id` = 1708477)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636445' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-02' 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

$475,000

4
2
2,010
0.14

6433 W Acacia Ave

Fresno, CA 93723

$472,000

4
2
1,705
0.10

4152 N Tisha Ave

Fresno, CA 93723

$462,990

4
3
2,126
0.09

6080 W Lansing Way #77

Fresno, CA 93723

$457,990

4
2.5
1,924
0.07

4048 N Rosalia (Lot 81)

Fresno, CA 93723

Courtesy of Sherri Eppler-DuBeau, Realty Concepts, Ltd. - Fresno - [email protected]
Last modified 2 hours ago
Fresno MLS last checked for updates 13 minutes 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.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

5286 N Maruyama Ave

Fresno, CA 93723

Photo Gallery

$474,950

5286 N Maruyama Ave

Fresno, CA 93723

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$475,000

$472,000

$462,990

$457,990

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

5286 N Maruyama Ave

Fresno, CA 93723

Photo Gallery

$474,950

5286 N Maruyama Ave

Fresno, CA 93723

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$475,000

$472,000

$462,990

$457,990

Loading...

Saving...

Deleting...

Searching...