London Properties Fresno Real Estate

Jasmin Quintana | 559.448.7951 | jquintana@londonproperties.com | LIC #02127412

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

2997 W Silverhill Ln

Fresno, CA 93711

Copy Link Get Directions

Photo Gallery

$539,000

4 bd

3 ba

2,760 sq ft

0.12 acre

2997 W Silverhill Ln

Fresno, CA 93711

Get Directions

Listed On: 05/28/2026

Status: Active

Listing Number: 649579 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Jasmin Quintana 559.448.7951 Email Agent

Property Description

Courtesy of Cindy Smades Klein, Premier Plus Real Estate Company - cindy@cindysmades.com

Fabulous Freestanding parklike STONEBRIDGE which is a PUD of 235 homes at the SE corner of Herndon and Marks. This home features 4 bedrooms & 3 bathrooms, living room, family room, formal dining room and kitchen with eating area overlooking rear private grounds. 3 bedrooms & 2 baths are downstairs on ONE LEVEL and 1 bedroom and 1 bath upstairs in loft. Leaded glass door entry w/ Gorgeous luxury vinyl plank flooring and newer windows and sliders thru-out. The Chef's kitchen is equipped with SLEEK stainless steel BOSCH appliances, quartz countertops, tile backsplash, refaced cabinets and canned lighting. Plenty of room to Entertain in the formal dining room that opens up to the spacious living room w/ soaring ceilings and abundance of light. Relaxing Primary suite w/ huge spa like bathroom featuring dual sinks, jetted tub and walk-in shower is a dream. The newly remodeled hall bath features tile floors, tiled shower, stunning glass shower door all on one level perfect for wheel chair w/ tile walls 1/2 way up. Laundry comes w/ BOSCH W/D and tiled utility sink. Super 800 sq. ft. covered patio w/ tall privacy hedge of blueberry bushes and OWNED SOLAR TO BOOT!!Stonebridge delivers unmatched lifestyle w/ 24/7 guard gate, community club house, 3 sparkling pools & spas, 4 lighted tennis courts, casualty and liability insurance, landscaping & RV area available for small fee.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1992

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$195

Price Per Acre

$4,385,679

Days On London

Cumulative Days On London

County

Fresno

Special Features

Isolated Bedroom, Isolated Bathroom, Built In Cabinets

REO / Bank Owned

Cross Street Address

Marks

Directions

From Herndon go South on Marks and enter where Guard Gate is. Show your card and tell them you are showing Silverhill!

Heating & Cooling

Central Heat & Cool

Laundry

Inside, Utility Room, On Lower Level

Roofing

Composition

Foundation

Concrete

Kitchen

Built In Range/Oven, Disposal, Dishwasher, Eating Area, Refrigerator

Primary Bedroom Level

Main

Bath Features

Tub/Shower, Shower, Jetted Tub

Extra Rooms

Loft

Disabled Features

Wheel Chair Access, Hand Rails, One Level Floor

Flooring

Carpet, Laminate, Tile

# of Fireplaces

Exterior

Stucco

Pool

Yes

Pool

Yes

Pool Type

In Ground

Spa

Yes

Spa Type

Community Spa

Patio Features

Covered, Uncovered, Concrete

Yard

Sprinklers Front, Sprinklers Back, Sprinklers Auto, Mature Landscape

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Yes

Solar Type

Owned

Parking Features

Existing RV Parking, Auto Opener

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

Lot Dimensions

51X105

APN

406 482 01 S [PARCEL MAP]

Zoning

RS4

Association / Park Amenities

Pool, Spa, Club House, Green Area, RV Storage, Tennis, Security Guard, Lake/Pond, Landscape Maint, Gated Community

HOA Dues

550.00

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

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 512050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 565950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2510 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3010 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` = 1727682 OR `props-main`.`id` = 1721318 OR `props-main`.`id` = 1718650 OR `props-main`.`id` = 1722249 OR `props-main`.`id` = 1728770 OR `props-main`.`id` = 1686281 OR `props-main`.`id` = 1727294 OR `props-main`.`id` = 1731707 OR `props-main`.`id` = 1725117 OR `props-main`.`id` = 1725789 OR `props-main`.`id` = 1717333 OR `props-main`.`id` = 1727583 OR `props-main`.`id` = 1727324 OR `props-main`.`id` = 1707004 OR `props-main`.`id` = 1722089 OR `props-main`.`id` = 1730173 OR `props-main`.`id` = 1726890 OR `props-main`.`id` = 1729009 OR `props-main`.`id` = 1726888 OR `props-main`.`id` = 1730995 OR `props-main`.`id` = 1725856 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` = 37604 OR `props-main`.`id` = 1728112 OR `props-main`.`id` = 1731735 OR `props-main`.`id` = 1702555 OR `props-main`.`id` = 1722829 OR `props-main`.`id` = 1720531 OR `props-main`.`id` = 1720597 OR `props-main`.`id` = 1723471 OR `props-main`.`id` = 1727651 OR `props-main`.`id` = 1723899 OR `props-main`.`id` = 1722979 OR `props-main`.`id` = 1721214 OR `props-main`.`id` = 1730589 OR `props-main`.`id` = 1723711 OR `props-main`.`id` = 1729142 OR `props-main`.`id` = 1716213 OR `props-main`.`id` = 1716295 OR `props-main`.`id` = 1701983 OR `props-main`.`id` = 1731199 OR `props-main`.`id` = 1729896 OR `props-main`.`id` = 1719609 OR `props-main`.`id` = 1722957 OR `props-main`.`id` = 1712950 OR `props-main`.`id` = 1731491 OR `props-main`.`id` = 1727426 OR `props-main`.`id` = 1721513 OR `props-main`.`id` = 1726282 OR `props-main`.`id` = 1720960 OR `props-main`.`id` = 1720289 OR `props-main`.`id` = 1724853 OR `props-main`.`id` = 1716474 OR `props-main`.`id` = 1731809 OR `props-main`.`id` = 1726508 OR `props-main`.`id` = 1707125 OR `props-main`.`id` = 1729309 OR `props-main`.`id` = 1708091 OR `props-main`.`id` = 1718963 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1723132 OR `props-main`.`id` = 1729228 OR `props-main`.`id` = 1705153 OR `props-main`.`id` = 1704539 OR `props-main`.`id` = 1726873 OR `props-main`.`id` = 1719224 OR `props-main`.`id` = 1713827 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1722436 OR `props-main`.`id` = 1729725 OR `props-main`.`id` = 1722414 OR `props-main`.`id` = 1724301 OR `props-main`.`id` = 233922 OR `props-main`.`id` = 1726541 OR `props-main`.`id` = 1704748 OR `props-main`.`id` = 1722750 OR `props-main`.`id` = 1728352 OR `props-main`.`id` = 1704718 OR `props-main`.`id` = 330848 OR `props-main`.`id` = 1705414 OR `props-main`.`id` = 1715531 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 1725783 OR `props-main`.`id` = 1725782 OR `props-main`.`id` = 1721350 OR `props-main`.`id` = 1728485 OR `props-main`.`id` = 1726488 OR `props-main`.`id` = 1729156 OR `props-main`.`id` = 1724330 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1709254 OR `props-main`.`id` = 1719560 OR `props-main`.`id` = 1723983 OR `props-main`.`id` = 1704188 OR `props-main`.`id` = 1731424 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1727232 OR `props-main`.`id` = 1688764 OR `props-main`.`id` = 1723492 OR `props-main`.`id` = 1725859 OR `props-main`.`id` = 1731687 OR `props-main`.`id` = 1728162 OR `props-main`.`id` = 1731737 OR `props-main`.`id` = 1729398 OR `props-main`.`id` = 1689147 OR `props-main`.`id` = 1728067 OR `props-main`.`id` = 1701249 OR `props-main`.`id` = 1719462 OR `props-main`.`id` = 1704086 OR `props-main`.`id` = 1695724 OR `props-main`.`id` = 1731380 OR `props-main`.`id` = 1722710 OR `props-main`.`id` = 1725055 OR `props-main`.`id` = 1725054 OR `props-main`.`id` = 1725315 OR `props-main`.`id` = 1725316 OR `props-main`.`id` = 1717341 OR `props-main`.`id` = 1717084 OR `props-main`.`id` = 1725999 OR `props-main`.`id` = 1704902 OR `props-main`.`id` = 1728066 OR `props-main`.`id` = 1729256 OR `props-main`.`id` = 1712589 OR `props-main`.`id` = 1715475 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1702051 OR `props-main`.`id` = 1727680 OR `props-main`.`id` = 1723795 OR `props-main`.`id` = 1727878 OR `props-main`.`id` = 1726407 OR `props-main`.`id` = 1731698 OR `props-main`.`id` = 1722044 OR `props-main`.`id` = 1721495 OR `props-main`.`id` = 1727880 OR `props-main`.`id` = 1723702 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 1724360 OR `props-main`.`id` = 248378 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` = 1731588 OR `props-main`.`id` = 1729482 OR `props-main`.`id` = 1718735 OR `props-main`.`id` = 1727748 OR `props-main`.`id` = 1728750 OR `props-main`.`id` = 1724087 OR `props-main`.`id` = 1724141 OR `props-main`.`id` = 1721210 OR `props-main`.`id` = 1702495 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 1727750 OR `props-main`.`id` = 1731724 OR `props-main`.`id` = 1720394 OR `props-main`.`id` = 1725403 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1705340 OR `props-main`.`id` = 1731452 OR `props-main`.`id` = 1718461 OR `props-main`.`id` = 1731550 OR `props-main`.`id` = 1726907)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649579' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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

$539,000

4
3
2,590
0.29

3094 W Escalon Ave

Fresno, CA 93711

Last modified 4 days ago
Fresno MLS last checked for updates 40 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

2997 W Silverhill Ln

Fresno, CA 93711

Photo Gallery

$539,000

2997 W Silverhill Ln

Fresno, CA 93711

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$539,000