London Properties Madera Real Estate

4154 Constance Rd

Madera, CA 93636

Copy Link Get Directions

Photo Gallery

$450,000

3 bd

2.5 ba

1,651 sq ft

0.04 acre

4154 Constance Rd

Madera, CA 93636

Get Directions

Listed On: 03/09/2026

Status: Active

Listing Number: 645005 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.661.6100 Email Agent

Property Description

Welcome to Tesoro Viejo. Step into this beautifully finished McCaffrey home that feels better than new. With owned solar and only one year old, the home offers the comfort and efficiency of modern construction without the wait of new builds.

The kitchen has been fully refreshed with brand new features, including a gas range, clean quartz countertops, and stylish finishes that create a warm and modern feel. The open layout makes everyday living easy, with a comfortable living space and natural light filling the home throughout the day.

Located in one of McCaffrey's most desirable communities, residents enjoy resort style amenities including a clubhouse, sparkling pool, relaxing jacuzzi, and regular neighborhood events that create a strong sense of community. Nearby shopping, dining, and a local coffee spot add convenience, while River Park is only about a ten minute drive away.

Blending comfort, quality, and location, this home offers a truly move in ready opportunity in one of the Central Valley's most loved master planned communities.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2024

Region

Urban

# of Stories

Two

Price Per Square Foot

$273

Price Per Acre

$11,250,000

Days On London

Cumulative Days On London

County

Madera

REO / Bank Owned

Cross Street Address

E/FWY 41 & S/ Tesoro Viejo

Directions

Fwy 41 and Tesoro Viejo: E on Tesoro Viejo, South on Vincent Rd, West on Phelia Ave, South on Constance, house on left.

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Composition

Foundation

Concrete

Primary Bedroom Level

Upper

Exterior

Stucco

Pool

Yes

Pool

Yes

Pool Type

In Ground

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Solar

Yes

Solar Type

Owned

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

APN

081 402 051 000

Association / Park Amenities

Pool, Spa, Club House, Exercise Room, Green Area, Playground, Landscape Maint

HOA Dues

200.00

School District

Chawanakee

School Type 1

High School

School Name 1

Minarets

School Type 2

Junior High School

School Name 2

Hillside

School Type 3

Grade School

School Name 3

Hillside

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1401 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1901 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` = 1691781 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1703559 OR `props-main`.`id` = 1712665 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1704446 OR `props-main`.`id` = 1691700 OR `props-main`.`id` = 1704550 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1702519 OR `props-main`.`id` = 1712454 OR `props-main`.`id` = 1707208 OR `props-main`.`id` = 1707209 OR `props-main`.`id` = 1712496 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1704029 OR `props-main`.`id` = 1704141 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1704028 OR `props-main`.`id` = 1698975 OR `props-main`.`id` = 1699174 OR `props-main`.`id` = 1710037 OR `props-main`.`id` = 1710046 OR `props-main`.`id` = 1704143 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1714903 OR `props-main`.`id` = 1703951 OR `props-main`.`id` = 1707243 OR `props-main`.`id` = 1705618 OR `props-main`.`id` = 1705650 OR `props-main`.`id` = 1705812 OR `props-main`.`id` = 1702738 OR `props-main`.`id` = 1709799 OR `props-main`.`id` = 1709808 OR `props-main`.`id` = 1703158 OR `props-main`.`id` = 1712449 OR `props-main`.`id` = 1716265 OR `props-main`.`id` = 1716044 OR `props-main`.`id` = 1713322 OR `props-main`.`id` = 1715532 OR `props-main`.`id` = 1714962 OR `props-main`.`id` = 1693967 OR `props-main`.`id` = 1711407 OR `props-main`.`id` = 1701823 OR `props-main`.`id` = 1698070 OR `props-main`.`id` = 1699189 OR `props-main`.`id` = 1711144 OR `props-main`.`id` = 1715813 OR `props-main`.`id` = 1692547 OR `props-main`.`id` = 1704393 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1695769 OR `props-main`.`id` = 1702888 OR `props-main`.`id` = 1712592 OR `props-main`.`id` = 1695774 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645005' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-13' 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

$459,500

3
2.5
1,820
0.06

696 Grace Way

Madera, CA 93636

$445,500

3
2.5
1,651
0.05

586 Ophelia Ave

Madera, CA 93636

$430,000

3
2.5
1,581
0.06

4301 San Miguel Rd

Madera, CA 93636

$430,000

3
3
1,581
0.06

4301 San Miguel

Madera, CA 93636

Courtesy of Darin Zuber, Real Broker - [email protected]
Last modified 4 days ago
Fresno MLS last checked for updates 17 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

4154 Constance Rd

Madera, CA 93636

Photo Gallery

$450,000

4154 Constance Rd

Madera, CA 93636

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$459,500

$445,500

$430,000

$430,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

4154 Constance Rd

Madera, CA 93636

Photo Gallery

$450,000

4154 Constance Rd

Madera, CA 93636

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$459,500

$445,500

$430,000

$430,000

Loading...

Saving...

Deleting...

Searching...