Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/653974/21987-Mary-Rebecca-Ln/Friant/https://www.londonproperties.com/images/props/fresno/full/653974.jpgLondon Properties Friant Real Estate | 21987 Mary Rebecca Ln
Welcome to this beautiful 3-bedroom, 2-bath tri-level home nestled in the foothills of the sought-after Eagle Spring Brighton Crest neighborhood. Ideally located directly across from Table Mountain Casino and just minutes from Millerton Lake, this home offers a wonderful blend of comfort, privacy, and scenic beauty.Situated directly on the golf course, the property enjoys expansive views and an exceptional sense of privacy, with no neighboring homes immediately on either side. The nearest neighboring home is comfortably situated farther down the way, allowing you to enjoy the peaceful, open surroundings.The bright and inviting main level features an open floor plan and an abundance of windows that fill the home with natural light while showcasing the beautiful views. The many windows create a warm, airy atmosphere and allow you to enjoy the surrounding scenery from the comfort of your living spaces.The home also offers peace of mind with an HVAC system installed just a few years ago, along with newer kitchen appliances including the oven, stovetop, and microwave. The tri-level layout provides a versatile floor plan with plenty of room for everyday living and entertaining, while the two-car garage adds convenient parking and storage.Whether you're looking for a full-time residence, weekend getaway, or a place to enjoy the foothill lifestyle, this home offers a unique opportunity to enjoy golf-course living, beautiful views, privacy, abundant natural light, and convenient access to Millerton Lake and Table Mountain Casino.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1995
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$271
Price Per Acre
$1,706,067
Days On London
0
Cumulative Days On London
0
County
Fresno
Leased Equipment
Propane
Special Features
Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Brighton Crest Dr
Directions
As you turn into eagle Spring community you will be on Brighton Crest Dr you go down til you get to Mary Rebecca and make a left on that street. Home is on the left
Unit Description
Split Level
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Refrigerator
Club House, Exercise Room, Tennis, Security Guard, Lake/Pond, Landscape Maint, Gated Community
HOA Dues
160.00
School District
Sierra Unified
School Type 1
High School
School Name 1
Sierra
School Type 2
Junior High School
School Name 2
Sierra
School Type 3
Grade School
School Name 3
Foothill
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 628950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1961 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2461 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` = 1747379 OR `props-main`.`id` = 1734864 OR `props-main`.`id` = 1760131 OR `props-main`.`id` = 1751421 OR `props-main`.`id` = 1751411 OR `props-main`.`id` = 1751412 OR `props-main`.`id` = 1765390 OR `props-main`.`id` = 1751400 OR `props-main`.`id` = 1754246 OR `props-main`.`id` = 1723756 OR `props-main`.`id` = 1743276 OR `props-main`.`id` = 1763261 OR `props-main`.`id` = 1713587 OR `props-main`.`id` = 1712949 OR `props-main`.`id` = 1713014 OR `props-main`.`id` = 1751420 OR `props-main`.`id` = 1721647 OR `props-main`.`id` = 1762355 OR `props-main`.`id` = 1762354 OR `props-main`.`id` = 1747609 OR `props-main`.`id` = 1738618 OR `props-main`.`id` = 1744677 OR `props-main`.`id` = 1759509 OR `props-main`.`id` = 1726211 OR `props-main`.`id` = 1684220)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653974' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-21' 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();
0
Last modified 2 hours 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.
