London Properties Fresno Real Estate

6638 N Marty Ave

Fresno, CA 93711

Copy Link Get Directions

Photo Gallery

$779,000

3 bd

3 ba

3,417 sq ft

0.28 acre

6638 N Marty Ave

Fresno, CA 93711

Get Directions

Listed On: 05/07/2026

Status: Active

Listing Number: 648281 (Fresno MLS)

Open House

Sat, May 9
1:00pm - 4:00pm
Courtesy of Realty Concepts, Ltd. - Clovis

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Remote professionals and entrepreneurs, this home is a game changer! The private separate entrance,creates an ideal work-from-home environment perfect for meeting clients, operating a business, creating a studio, or simply enjoying a fully separate, distraction-free workspace. This flexible setup also offers excellent potential for multigenerational living.Tucked away on a quiet cul-de-sac, this property offers an impressive 3,417 sqft of thoughtfully designed living space. Featuring 3 spacious bedrooms, 3 bathrooms, a large home office that can easily serve as a fourth bedroom, a flexible bonus room, and an inviting upstairs loft ideal for relaxing or gathering, this home offers both comfort and functionality. Plus, abundant storage throughout, ensures everything has its place.Set on an expansive 12,000 sqft lot, the backyard is a private retreat beautifully designed and ready for both entertaining and everyday relaxation. Mature landscaping and generous outdoor space create a resort-like atmosphere, perfect for hosting gatherings or unwinding at the end of the day.With energy-efficient NEM 2 solar helping keep costs down and the added privacy of a desirable cul-de-sac location, this home seamlessly blends productivity, versatility, and lifestyle. A rare opportunity to elevate your work-from-home experience this property truly has it all. Call your Realtor to schedule a showing!

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1981

Region

Urban

# of Stories

Two

Price Per Square Foot

$228

Price Per Acre

$2,827,586

Days On London

Cumulative Days On London

County

Fresno

Special Features

Security System

REO / Bank Owned

Cross Street Address

Herndon

Directions

From 41, take Herndon exit and head west on Herndon. South on Valentine and property will be on the left in the cul-de-sac.

Style

Mid-Century Modern

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Composition

Foundation

Concrete

Primary Bedroom Level

Upper

Bath Features

Tub/Shower

Extra Rooms

Office, Family Room, Loft

Flooring

Carpet, Vinyl

# of Fireplaces

Fireplace Type

Pellet

Exterior

Wood

Pool

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Yes

Solar Type

Owned with Balance

Parking Features

Work/Shop Area

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

Lot Dimensions

120X100

APN

406 444 04 S [PARCEL MAP]

Zoning

RS4

School District

Fresno Unified

School Type 1

High School

School Name 1

Bullard

School Type 2

Junior High School

School Name 2

Tenaya

School Type 3

Grade School

School Name 3

Tatarian

Seller Will Consider

Conventional, Cash

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 817950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3167 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3667 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` = 1709494 OR `props-main`.`id` = 1709493 OR `props-main`.`id` = 1709515 OR `props-main`.`id` = 1702489 OR `props-main`.`id` = 1656685 OR `props-main`.`id` = 1711345 OR `props-main`.`id` = 1652461 OR `props-main`.`id` = 1721318 OR `props-main`.`id` = 1718650 OR `props-main`.`id` = 1718500 OR `props-main`.`id` = 1722249 OR `props-main`.`id` = 1686281 OR `props-main`.`id` = 1724340 OR `props-main`.`id` = 1723076 OR `props-main`.`id` = 1703982 OR `props-main`.`id` = 1725789 OR `props-main`.`id` = 1716878 OR `props-main`.`id` = 1717333 OR `props-main`.`id` = 1702911 OR `props-main`.`id` = 1702935 OR `props-main`.`id` = 1702875 OR `props-main`.`id` = 1702913 OR `props-main`.`id` = 1722333 OR `props-main`.`id` = 1697185 OR `props-main`.`id` = 1722089 OR `props-main`.`id` = 1716644 OR `props-main`.`id` = 1613712 OR `props-main`.`id` = 1717841 OR `props-main`.`id` = 1697695 OR `props-main`.`id` = 1723640 OR `props-main`.`id` = 1694413 OR `props-main`.`id` = 1688680 OR `props-main`.`id` = 1629374 OR `props-main`.`id` = 1711346 OR `props-main`.`id` = 1704787 OR `props-main`.`id` = 1722449 OR `props-main`.`id` = 1724703 OR `props-main`.`id` = 1724651 OR `props-main`.`id` = 1723768 OR `props-main`.`id` = 1712911 OR `props-main`.`id` = 1723682 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1717096 OR `props-main`.`id` = 1702555 OR `props-main`.`id` = 1722829 OR `props-main`.`id` = 1717955 OR `props-main`.`id` = 1722376 OR `props-main`.`id` = 1725015 OR `props-main`.`id` = 1723471 OR `props-main`.`id` = 1725359 OR `props-main`.`id` = 1723899 OR `props-main`.`id` = 1725357 OR `props-main`.`id` = 1722088 OR `props-main`.`id` = 1722979 OR `props-main`.`id` = 1721214 OR `props-main`.`id` = 1723711 OR `props-main`.`id` = 1716213 OR `props-main`.`id` = 1716295 OR `props-main`.`id` = 1701983 OR `props-main`.`id` = 1721686 OR `props-main`.`id` = 1719609 OR `props-main`.`id` = 1712950 OR `props-main`.`id` = 1724283 OR `props-main`.`id` = 1712993 OR `props-main`.`id` = 1709933 OR `props-main`.`id` = 1723712 OR `props-main`.`id` = 1721513 OR `props-main`.`id` = 1720960 OR `props-main`.`id` = 1720289 OR `props-main`.`id` = 1717428 OR `props-main`.`id` = 1717467 OR `props-main`.`id` = 1724853 OR `props-main`.`id` = 1716474 OR `props-main`.`id` = 1707125 OR `props-main`.`id` = 1721869 OR `props-main`.`id` = 1708091 OR `props-main`.`id` = 1718963 OR `props-main`.`id` = 1704376 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1723723 OR `props-main`.`id` = 1723132 OR `props-main`.`id` = 1721253 OR `props-main`.`id` = 1720972 OR `props-main`.`id` = 1705153 OR `props-main`.`id` = 1725666 OR `props-main`.`id` = 1704539 OR `props-main`.`id` = 1719224 OR `props-main`.`id` = 1713827 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1698794 OR `props-main`.`id` = 1722414 OR `props-main`.`id` = 1696662 OR `props-main`.`id` = 1724301 OR `props-main`.`id` = 1709958 OR `props-main`.`id` = 1718268 OR `props-main`.`id` = 1704748 OR `props-main`.`id` = 1722750 OR `props-main`.`id` = 1704032 OR `props-main`.`id` = 1725571 OR `props-main`.`id` = 1704718 OR `props-main`.`id` = 1709253 OR `props-main`.`id` = 1705414 OR `props-main`.`id` = 1715531 OR `props-main`.`id` = 1724485 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 1725783 OR `props-main`.`id` = 1725782 OR `props-main`.`id` = 1721350 OR `props-main`.`id` = 1722951 OR `props-main`.`id` = 1724330 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1709254 OR `props-main`.`id` = 1719560 OR `props-main`.`id` = 1713861 OR `props-main`.`id` = 1723983 OR `props-main`.`id` = 1718563 OR `props-main`.`id` = 1718922 OR `props-main`.`id` = 1722844 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1723492 OR `props-main`.`id` = 1709629 OR `props-main`.`id` = 1689147 OR `props-main`.`id` = 1720500 OR `props-main`.`id` = 1725103 OR `props-main`.`id` = 1701249 OR `props-main`.`id` = 1719462 OR `props-main`.`id` = 1704086 OR `props-main`.`id` = 1725792 OR `props-main`.`id` = 1716453 OR `props-main`.`id` = 1695724 OR `props-main`.`id` = 1722710 OR `props-main`.`id` = 1725055 OR `props-main`.`id` = 1725277 OR `props-main`.`id` = 1725751 OR `props-main`.`id` = 1725054 OR `props-main`.`id` = 1725282 OR `props-main`.`id` = 1725752 OR `props-main`.`id` = 1725238 OR `props-main`.`id` = 1725315 OR `props-main`.`id` = 1725233 OR `props-main`.`id` = 1725316 OR `props-main`.`id` = 1717341 OR `props-main`.`id` = 1717084 OR `props-main`.`id` = 1712589 OR `props-main`.`id` = 1718388 OR `props-main`.`id` = 1718238 OR `props-main`.`id` = 1725548 OR `props-main`.`id` = 1718764 OR `props-main`.`id` = 1724978 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1702051 OR `props-main`.`id` = 1723795 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1703313 OR `props-main`.`id` = 1722044 OR `props-main`.`id` = 1721495 OR `props-main`.`id` = 1714026 OR `props-main`.`id` = 1723702 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 1724360 OR `props-main`.`id` = 1721465 OR `props-main`.`id` = 1722375 OR `props-main`.`id` = 37607 OR `props-main`.`id` = 1717593 OR `props-main`.`id` = 1724746 OR `props-main`.`id` = 1721048 OR `props-main`.`id` = 1721049 OR `props-main`.`id` = 1718735 OR `props-main`.`id` = 1716654 OR `props-main`.`id` = 1724087 OR `props-main`.`id` = 1724141 OR `props-main`.`id` = 1721210 OR `props-main`.`id` = 1716954 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 1718813 OR `props-main`.`id` = 1720394 OR `props-main`.`id` = 1725403 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1705340 OR `props-main`.`id` = 1718461)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648281' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-07' 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

$799,000

5
3
3,600
0.24

3509 W Menlo Ave

Fresno, CA 93711

Courtesy of Carey Kepford, Realty Concepts, Ltd. - Clovis - [email protected]
Last modified 1 hour ago
Fresno MLS last checked for updates 42 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

6638 N Marty Ave

Fresno, CA 93711

Photo Gallery

$779,000

6638 N Marty Ave

Fresno, CA 93711

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$799,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

6638 N Marty Ave

Fresno, CA 93711

Photo Gallery

$779,000

6638 N Marty Ave

Fresno, CA 93711

Open House

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$799,000

Loading...

Saving...

Deleting...

Searching...