London Properties Fresno Real Estate

Ruth Reisz

REALTOR^®

Ruth Reisz | 559.250.4476 | ruth@londonproperties.com | LIC #01300441

Ruth Reisz

(559) 250-4476

Home Buying Selling About Contact

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Home

Buying

Selling

Home Value Calculator

About

Create Account | Login

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

242 Fresno St

Fresno, CA 93706

Copy Link Get Directions

Photo Gallery

$349,900

4 bd

2 ba

1,475 sq ft

0.16 acre

242 Fresno St

Fresno, CA 93706

Get Directions

Listed On: 04/17/2026

Status: Active

Listing Number: 647365 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Ruth Reisz 559.250.4476 Email Agent

Property Description

Welcome to 242 Fresno Street, your move-in ready dream home, freshly renovated with timeless style and quality upgrades throughout. This home features 4 bedrooms, 2 bathrooms with neutral tones that provide a warm, inviting feel and a perfect canvas for your personal touch. Enjoy brand new dual pane windows, updated flooring, new doors, and a completely remodeled kitchen featuring white cabinetry, quartz countertops, and stainless steel appliances a modern chef's delight. The primary suite is a true retreat, showcasing plenty of space with the primary bathroom complete with a walk-in shower, custom tile work, grey cabinetry, and quartz counters. The hall bathroom matches the elegance with its own custom tile details and upgraded quartz finishes, offering comfort and style for guests or family. In addition, the property includes a detached bonus room in the backyard ideal for a home office, gym, guest suite, or creative studio. The possibilities are endless. Priced to sell, this home combines function, beauty, and opportunity. Schedule your showing today before it's gone!

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1922

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$237

Price Per Acre

$2,257,419

Days On London

Cumulative Days On London

County

Fresno

REO / Bank Owned

Cross Street Address

Fresno Street

Directions

Thorne / Cesar Chavez, Head East on Cesar Chavez, East on Fresno Street, Property is located on Fresno Street

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Composition

Foundation

Wood Subfloor

Kitchen

Gas Appliances

Primary Bedroom Level

Main

# of Fireplaces

Exterior

Stucco

Pool

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Parking Features

Carport

Are there garage spaces?

Yes

Garage Type

Detached

Garage Spaces

Carport Spaces

Lot Dimensions

50X135

APN

467 275 01 [PARCEL MAP]

Zoning

NMX

School District

Fresno Unified

School Type 1

High School

School Name 1

Edison

School Type 2

Junior High School

School Name 2

Bud Gaston

School Type 3

Grade School

School Name 3

Lincoln

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 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) >= 1225 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1725 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` = 1701914 OR `props-main`.`id` = 1701598 OR `props-main`.`id` = 1702046 OR `props-main`.`id` = 1701488 OR `props-main`.`id` = 1697091 OR `props-main`.`id` = 1702655 OR `props-main`.`id` = 1702103 OR `props-main`.`id` = 1690032 OR `props-main`.`id` = 1701374 OR `props-main`.`id` = 1699012 OR `props-main`.`id` = 1697094 OR `props-main`.`id` = 1681564 OR `props-main`.`id` = 1715724 OR `props-main`.`id` = 1714907 OR `props-main`.`id` = 1720549 OR `props-main`.`id` = 1705462 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1719610 OR `props-main`.`id` = 1719760 OR `props-main`.`id` = 1720580 OR `props-main`.`id` = 1704126 OR `props-main`.`id` = 1704322 OR `props-main`.`id` = 1691288 OR `props-main`.`id` = 1719693 OR `props-main`.`id` = 1705388 OR `props-main`.`id` = 1719263 OR `props-main`.`id` = 1713492 OR `props-main`.`id` = 1683103 OR `props-main`.`id` = 1707918 OR `props-main`.`id` = 1721861 OR `props-main`.`id` = 1717478 OR `props-main`.`id` = 1713037 OR `props-main`.`id` = 1713045 OR `props-main`.`id` = 1721112 OR `props-main`.`id` = 1701781 OR `props-main`.`id` = 1680010 OR `props-main`.`id` = 1696424 OR `props-main`.`id` = 1722378 OR `props-main`.`id` = 1718173 OR `props-main`.`id` = 1701669 OR `props-main`.`id` = 1719157 OR `props-main`.`id` = 1719517 OR `props-main`.`id` = 1666338 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1718172 OR `props-main`.`id` = 1708219 OR `props-main`.`id` = 1703613 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1715941 OR `props-main`.`id` = 1702590 OR `props-main`.`id` = 1704310 OR `props-main`.`id` = 1692127 OR `props-main`.`id` = 1654292 OR `props-main`.`id` = 1705358 OR `props-main`.`id` = 1681366 OR `props-main`.`id` = 1681364 OR `props-main`.`id` = 1681362 OR `props-main`.`id` = 1717138 OR `props-main`.`id` = 1681344 OR `props-main`.`id` = 1681343 OR `props-main`.`id` = 1722228 OR `props-main`.`id` = 1722008 OR `props-main`.`id` = 1681342 OR `props-main`.`id` = 1715665 OR `props-main`.`id` = 1712861 OR `props-main`.`id` = 1712947 OR `props-main`.`id` = 1696292 OR `props-main`.`id` = 1696288 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1718772 OR `props-main`.`id` = 1712377 OR `props-main`.`id` = 1702892 OR `props-main`.`id` = 1720540 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1700848 OR `props-main`.`id` = 1696514 OR `props-main`.`id` = 1709701 OR `props-main`.`id` = 1718039 OR `props-main`.`id` = 1649227 OR `props-main`.`id` = 1694019 OR `props-main`.`id` = 1713995 OR `props-main`.`id` = 1609082 OR `props-main`.`id` = 1720504 OR `props-main`.`id` = 1716853 OR `props-main`.`id` = 1714920 OR `props-main`.`id` = 1720525 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1719317 OR `props-main`.`id` = 1719404 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1716190 OR `props-main`.`id` = 1721467 OR `props-main`.`id` = 1694096 OR `props-main`.`id` = 1661123)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647365' 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();

Similar Properties

$354,900

4
2
1,688
0.11

2255 S Rose Ave

Fresno, CA 93706

Courtesy of Austin Hartman, Real Broker - austin@austinhartmanrealtor.com
Last modified 18 hours ago
Fresno MLS last checked for updates 51 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.

Get More Info

Print A Flyer

Get A Home Loan

Share

242 Fresno St

Fresno, CA 93706

Photo Gallery

$349,900

242 Fresno St

Fresno, CA 93706

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$354,900