Property search · The Consumer Protection Brokerage
Every listing shows your estimated rebate.
The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.
2997 W SilverhillFresno, CA 93711
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 Master 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.
| 4 weeks ago | Listing updated with changes from the MLS® | |
| 3 months ago | Listing first seen on site |
This information is deemed reliable but not guaranteed. You should rely on this information only to decide whether or not to further investigate a particular property. BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional. You may use this information only to identify properties you may be interested in investigating further. All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited. Redistribution or copying of this information, any photographs or video tours is strictly prohibited. This information is derived from the Internet Data Exchange (IDX) service provided by San Diego MLS®. Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display. The information and any photographs and video tours and the compilation from which they are derived is protected by copyright. Copyright © 2026 San Diego MLS®.
Last checked 2026
*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.
Found a home you love?
Schedule a free consultation to lock in your rebate before you offer.
Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.