My Office's Listings

Some or all of the listings below are provided by the Select Real Estate, Inc. office.
$399,000 (USD)
Active

Yokuts Valley Area Single Family Home

Active

38758 Aster Lane Yokuts Valley, CA 93675

3 Bed
2.25 Baths
2688 sqft
MLS# 656876
Discover the beauty of country living with this custom Raised-Ranch, Hillside Retreat! This 2,688-square-foot, two-story home is nestled on 6.27 acres of gently rolling terrain at the end of a private cul-de-sac and built into the side of a hill, with a ground-level entrance to each story. The fenced and cross-fenced property offers a blend of privacy, functionality, and natural beauty, creating an inviting setting for those seeking room to spread out and enjoy the beautiful outdoors surrounding this amazing home.The main level features an open, spacious layout highlighted by a well-appointed kitchen with an island breakfast bar that flows into an expansive great room. Rustic cathedral ceilings with exposed wood beams and a distinctive adobe fireplace add warmth and character to the living space. Upstairs, all bedrooms, including the secluded primary suite, provide a private retreat, while covered wraparound decks offer sweeping mountain views and unforgettable sunsets. A creek that runs year-round is found just south of the home, and a perfect swing area over rock outcroppings under a beautiful tree. Outcroppings in the swing area have grinding holes used by Native Americans.The lower level adds even more versatility with a generously sized family room featuring a corner fireplace, wet bar, attractive wood accents, a half-bath, and ample storage. This space connects to an oversized attached two-car garage, making it ideal for entertaining, hobbies, or additional gathering space. Multiple gathering/entertaining areas are found throughout this property/home.Energy-conscious features include an 18 kW solar power purchase agreement (PPA) with two Tesla Powerwall batteries, a durable tile roof, and a newer HVAC unit.Approximately 39 minutes (25.6 mi) to Kings Canyon National Park, 1 h 5 min (40.6 mi) to Sequoia National Park, and 50 minutes (42.5 mi) to Fresno State University per Google Maps.
Listing Courtesy of Fresno Association of Realtors / Listed By: Candido "Candy" Alvarez, Century 21 Select Real Estate, Inc.
$399,000 (USD)
Active

Squaw Valley Area Single Family Home

Active

38758 Aster Lane Squaw Valley, CA 93675

3 Bed
3 Baths
2688 sqft
MLS# FR26243322
Discover the beauty of country living with this custom Raised-Ranch, Hillside Retreat! This 2,688-square-foot, two-story home is nestled on 6.27 acres of gently rolling terrain at the end of a private cul-de-sac and built into the side of a hill, with a ground-level entrance to each story. The fenced and cross-fenced property offers a blend of privacy, functionality, and natural beauty, creating an inviting setting for those seeking room to spread out and enjoy the beautiful outdoors surrounding this amazing home.



The main level features an open, spacious layout highlighted by a well-appointed kitchen with an island breakfast bar that flows into an expansive great room. Rustic cathedral ceilings with exposed wood beams and a distinctive adobe fireplace add warmth and character to the living space. Upstairs, all bedrooms, including the secluded primary suite, provide a private retreat, while covered wraparound decks offer sweeping mountain views and unforgettable sunsets. A creek that runs year-round is found just south of the home, and a perfect swing area over rock outcroppings under a beautiful tree. Outcroppings in the swing area have grinding holes used by Native Americans.



The lower level adds even more versatility with a generously sized family room featuring a corner fireplace, wet bar, attractive wood accents, a half-bath, and ample storage. This space connects to an oversized attached two-car garage, making it ideal for entertaining, hobbies, or additional gathering space. Multiple gathering/entertaining areas are found throughout this property/home.
Listing Courtesy of CRMLS / Listed By: Candido "Candy" Alvarez, Century 21 Select Real Estate, Inc.
$379,900 (USD)
Pending

Visalia Area Single Family Home

Pending

3611 E Center Court Visalia, CA 93292

4 Bed
2 Baths
1539 sqft
MLS# 244273
This is the one you have been waiting for. Beautiful updated 4 bedroom home on a cul-de-sac. A few items include freshly painted inside, laminated flooring through most of the house. The two bathrooms have granite counter tops. In the past month and also includes a newer roof mount HVAC., new hot water heater heater. Walk up to a relaxing front porch and enter the greatroom with a vaulted ceiling. Painted from ceiling to floor, raised panel white doors, oversized baseboards. Kitchen offers a breakfast nook, bar and a formal dining area in the greatroom or maybe use as a sitting area to read and relax in. Refrigerator included. Inside laundry. Four bedrooms with primary having 2 closets- his and a hers. Whole house fan to help with energy bills. Outside you find a covered patio for entertaining, relaxing while watching the kids, grandkids, dogs running around. Good sized yard with mature landscaping, 14 x 8 workshop, plus several different storage sheds. West side offers RV parking for a trailer, boat. This lovely move in ready home has something to offer for everyone. Termite clearance and Roof certification includes a new patio roof. Ready for you to be moved in for the holidays. Property is not in a flood zone. Termite Clearance and 2 year roof cert on file. Escrow is preopened with Chicago Title. Tracey Rouse & Kim.
Listing Courtesy of TULARE COUNTY / Listed By: Peggy Wilson, Century 21 Select Real Estate, Inc.