Homes for Sale near H. Roger Tatarian Elementary School

Experience luxury and versatility in this stunning custom home designed for both comfort and entertaining. The beautifully updated kitchen features granite countertops, newer appliances including a Jenn-Air gas cooktop with grill, rebuilt Sub-Zero refrigerator, drink station with wine and beverage fridges, and a bay-window breakfast nook. Bathrooms have been stylishly renovated, including one

Julie Fulcher Redfin Corporation

Live Lakeside!Peace, security, comfort, and quality await behind the esteemed gates of North Fresno's finest and most prestigious Stonebridge Community. This 2-bedroom, 2-bathroom home features open living spaces. The spacious master suite includes an additional room, perfect for a home office. Enjoy stunning lake views and relax in the backyard with family and friends, sipping your favorite

Bryan Souza eXp Realty of California, Inc.

Nestled in the prestigious San Joaquin Estates, this exceptional Rich Riley custom home seamlessly blends the beauty of wood accents with nature through its multiple courtyards. Step into your own private oasis, where a lush courtyard welcomes you to a grand double-door entry, offering a stunning view of the expansive great room and formal dining area. The atrium, featuring a charming fountain,

Teddi Peters Coldwell Banker Preferred

What does this 4000 sq.ft. custom Rod DeLuca builthome have? Everything! Every detail has beenthoughtfully designed. This home boasts 4 bedrooms, 3.5 baths, whichoffers an exceptional living experience tailored for comfortand elegance. Enter through the beautifully crafted frontdoor to a large foyer which showcases an elegant stairway leading to the upstairs loft. This loftcould be used as a

Karyn Milutinovich Century 21 Jordan-Link & Compa

Step into a world of timeless charm and nostalgic elegance with this captivating 1955 custom home, nestled on a lush one-acre lot that exudes the character and craftsmanship of a bygone era. Designed to embrace the indoor-outdoor lifestyle, the home features floor-to-ceiling glass windows that flood the interior with natural light while framing picturesque views of the expansive entertainer's

Sarah Hedrick Realty Concepts, Ltd

Welcome to this fully updated 4 bedroom, 2 bathroom home located in the prestigious San Joaquin Country Club Estates, just moments from the San Joaquin Country Club itself. This thoughtfully renovated property is packed with upgrades and sits on a beautifully landscaped lot with mature trees and a refreshing pool for warm Central Valley days.The home features fresh interior and exterior paint,

Margaret Shamshoian Realty Concepts, Ltd. - Fresno

Nestled in the sought-after San Joaquin Country Club Estates, just .09 miles from the prestigious San Joaquin Country Club, this charming ranch-style home offers comfort, elegance, and a warm sense of community. Step into the spacious family room, where vaulted and beamed ceilings create an inviting atmosphere, complemented by beautiful woodwork and granite countertops throughout. The formal

Debra A Franklin Universal Realty Services, Inc

Welcome to this meticulously maintained 3-bedroom, 2.5-bath Leo Wilson home located in the desirable Elev8ions at the Bluffs gated community.Perfect for those seeking a low-maintenance, energy-efficient lifestyle, this home offers both comfort and convenience. The main level features an open-concept great room and kitchen, ideal for everyday living and entertaining. The kitchen is beautifully

Linda Coelho B & B Realty

Beautifully Remodeled PUD in the Coveted Stonebridge CommunityDon't miss this rare and unique opportunity to own a beautifully updated single-level home in the highly sought-after Stonebridge community of Northwest Fresno. Nestled on one of the most private and quiet streets in the neighborhood, this spacious 2-bedroom, 2-bathroom home offers a tranquil, park-like setting with ample guest parking

Jorge Perez-Guzman Western Pioneer Properties

Experience lakeside living in the prestigious, guard-gated Stonebridge community. This elegant 2,666 sq/ft waterfront residence offers refined style and tranquility with stunning lake views from multiple rooms. It features 3 spacious bedrooms, 2.75 baths, and a formal living/dining room ideal for entertaining. A cozy family room with fireplace captures picturesque lake views. The kitchen

James Chavez London Properties, Ltd.

Imagine yourself in this beautiful spilt level home with many upgrades! Nestled in a well-established neighborhood. Imagine yourself cooking in this gorgeous spacious kitchen with an oversize eating bar, granite countertops. This home is perfect for hosting company in your spacious Livingroom which features an electric fireplace .The Master bedroom bathroom has a deep soaking tub, separate tiled

LUIS FERNANDEZ HomeSmart PV and Associates

Welcome to luxury living in the prestigious gated community of Lake Van Ness. This Mediterranean-inspired waterfront estate offers timeless elegance with direct lake frontage and resort-style amenities. From the grand circular driveway and lush landscaping to the stately entrance, every detail is thoughtfully designed. Inside, enjoy soaring ceilings, marble floors, and expansive living spaces

Nico Gentile Gentile Real Estate

Step into your dream home in the prestigious Stonebridge gated community, where this impeccably updated 3-bedroom, 2.5-bathroom residence offers a fairytale lifestyle across 2,315 square feet. With soaring ceilings and a spacious living room featuring a gorgeous fireplace, this home exudes elegance and warmth. Enjoy the modern updates of lovely LVP flooring and stylish light fixtures throughout,

Darla Togo Diamond Realtors

This immaculate traditional single-family home in the prestigious gated community of Bluff View, located in Fresno's highly desirable Royal Coach neighborhood. This exclusive enclave features 36 homes, enhanced by lush green spaces, a pool, clubhouse, and tennis court. Upon entry, you're immediately welcomed by soaring ceilings, beautiful shuttered windows, and soft, inviting hues throughout the

Darin Zuber Real Broker

Step into a home that redefines luxury living where architectural brilliance meets serene privacy on the fairways of the prestigious San Joaquin Country Club. This one-of-a-kind estate is a true masterpiece, blending bold modern design with warm, rustic elegance throughout. Mature trees and vibrant landscaping frame the private gated entry, while a lush front courtyard reveals a secluded pool

Nico Gentile Gentile Real Estate

Fresno's PREMIER Country Club View! An Extraordinary Setting Overlooking The Signature 11th Fairway at San Joaquin Country Club! Lakeview, Vine covered Bluffs and Breathtaking Vistas will give you a feeling of a Vacation Home in Carmel. Grand Opulence in this Ultra-Custom Home, featuring Light Oak Hardwood floors, 8 ft. solid wood doors, Beveled glass French doors, and a Wall of Windows to absorb

Rod Aluisi Rod Aluisi Real Estate

Welcome to this breathtaking, fully remodeled home in the prestigious Stonebridge Community (over-the-top construction and features)! Upon entry, you're greeted by a grand foyer leading to a family room with an inviting fireplace, ample natural light, and an open floor plan flowing seamlessly into the dining areaperfect for entertaining. The culinary kitchen is a chef's dream, featuring

Darin Zuber Real Broker

Paramount Properties is honored to present the sale of two (2) rough graded APNs (501-043-30 & -31). Each APN comes with approved site plans with APN 501-043-31 being sold with an approved building plan!

Tony Simone Paramount Properties

Paramount Properties is honored to present the sale of two (2) rough graded APNs (501-043-30 & -31). Each APN comes with approved site plans with APN 501-043-31 being sold with an approved building plan!Discover an exceptional opportunity with these parcels, ideally positioned just north of the bustling northwest corner of West Herndon and North Blythe Avenues in vibrant

Tony Simone Paramount Properties

Property is zoned CP - Commercial Professional.

John Duncan Realty Concepts, Ltd. - Fresno

Arthur Basmajian Realty Unlimited Group

Arthur Basmajian Realty Unlimited Group

Experience the tranquility of lakeside living in the exclusive Stonebridge community, a gated retreat nestled in the heart of NW Fresno. This spacious home features three large bedrooms, three bathrooms, two charming dining areas, and a grand living room. High ceilings, calming neutral tones, and an abundance of oversized windows fill the home with natural light, creating a warm and airy

Kevin Finley CENTURY 21 CITRUS REALTY INC