My Office's Listings

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

Fresno Area Single Family Home

Pending

2510 W San Ramon Avenue Fresno, CA 93711

5 Bed
4 Baths
4003 sqft
MLS# 657151
Proud to introduce 2510 West San Ramon Ave! An extraordinary private oasis nestled in a premier location just off Van Ness Boulevard. Blending timeless warm and welcoming character, charm, quality craftsmanship, and thoughtful modern, opulent designs. This impressive 4,003-square-foot residence offers 5 bedrooms, 4 bathrooms, and a dedicated office, providing exceptional flexibility for entertaining, and everyday comfort.From the moment you arrive, the home's distinctive architectural character makes a lasting impression. A terra-cotta tile roof, freshly painted stucco, flagstone accents, and an ornate wrought-iron double-door entry establish a warm Mediterranean-inspired aesthetic. The welcoming front courtyard, enclosed by stucco and stone walls, features a partially shaded front yard, a sunny patio, and extensive exterior lighting with smart-home timing for a beautiful evening ambiance.Inside, expansive living spaces are filled with natural light, enhanced by skylights, Jeld-Wen low-emissivity windows. A dual-sided fireplace adds warmth and character to the adjoining great rooms, creating an inviting atmosphere for relaxed evenings and memorable gatherings. The thoughtfully designed interior balances architectural elegance with comfortable, functional living spaces.The kitchen is designed to bring people together, featuring professional-grade stainless-steel appliances, a professional-style gas range, sleek stainless-steel range hood, wine chiller, elegant granite countertops, and extensive custom cabinetry. Whether preparing meals for a crowd or hosting an intimate dinner, this well-appointed space offers an appealing combination of style, workspace, and storage. Relax and enjoy the views as throughout the house you will be overlooking the park-like backyard designed for enjoying. A refreshing pool and spa provide the centerpiece for outdoor relaxation, while generous patio areas and expansive lawn space create room for dining, entertaining, and recreation. Majestic redwoods and towering majesty palms contribute to the lush outdoor ambiance. Upstairs, a completely separate bedroom, bath and sitting area is ideal for guests, hang out space or multi-generational living!
Listing Courtesy of Fresno Association of Realtors / Listed By: Ryan Johnson, Century 21 Select Real Estate, Inc.
$819,000 (USD)
Active

Clovis Area Single Family Home

Active

20146 Nicholas Road Clovis, CA 93619

3 Bed
2.5 Baths
2408 sqft
MLS# 648481
Perched atop approximately 18.48 acres with breathtaking foothill and valley views, this beautifully updated log cabin retreat offers a rare blend of rustic character, modern comfort, and outdoor lifestyle living.Surrounded by rolling hills and natural landscape, the property captures the essence of peaceful foothill living with expansive covered patios designed for entertaining, relaxing, and taking in unforgettable sunsets and panoramic scenery from nearly every angle.Inside, the home has been thoughtfully renovated while preserving the warmth and authenticity of classic log cabin architecture. Vaulted wood-beam ceilings, exposed log walls, and expansive windows create an inviting mountain-lodge atmosphere throughout.The stunning remodeled kitchen serves as the heart of the home, featuring quartz countertops, custom cabinetry, designer lighting, stainless appliances, a farmhouse sink, and picturesque views from the surrounding windows. Open-concept living and dining spaces flow seamlessly together, creating ideal gathering areas for everyday living or entertaining guests.Additional interior highlights include a spacious great room with soaring ceilings, stylishly updated bathrooms, generously sized bedrooms, and a dedicated entertaining/game room complete with bar area and shuffleboard space, offering the perfect setting for hosting family and friends.Step outside and experience the versatility of the land itself. The property features fenced and cross-fenced acreage, barns, chicken coop and storage structures, and a private dirt track ideal for motorcycles, ATVs, and recreational use.A substantial 30x40 Borga shop with roll-up door and its own HVAC system provides excellent space for vehicles, recreational toys, workshop use, equipment storage, or hobby needs.Whether you're searching for a private retreat, full-time foothill residence, recreational ranch property, or entertainer's getaway, 20146 Nicholas Rd offers a truly distinctive lifestyle opportunity just outside of Clovis.
Listing Courtesy of Fresno Association of Realtors / Listed By: Lena Marie Fisher, Century 21 Select Real Estate, Inc.