$890,000
Fresno, CA 93711
MLS# 237490
Status: Closed
4 beds | 3 baths | 3316 sqft
1 / 51
Property Description
Welcome to this stunning home tucked in a private cul-de-sac near the bluffs of the San Joaquin River. This thoughtfully designed residence offers comfort, privacy, and elegance in one of the area's most desirable neighborhoods. A charming front porch welcomes you into a grand entry with a sweeping staircase and abundant natural light. The spacious step-down family room is surrounded by windows and flows into a cozy den with a fireplaceperfect as a second living area or playroom. The gourmet kitchen features high-end stainless steel appliances, including a Thermador range, Kitchen Aid Dishwasher, sleek black granite counters, a walk-in pantry, and a center island with views of the front yard. A downstairs bedroom with full bath offers ideal space for guests or multi-generational living. Upstairs, the split staircase leads to two large bedrooms with walk-in closets and a Jack and Jill bathroom on one side. On the opposite end, the luxurious primary suite includes a fireplace, private office or retreat space, and balcony overlooking the backyard. The primary bath features an oversized soaking tub, dual vanities, and ample storage. The laundry room is conveniently located upstairs. The backyard is a true oasis with a heated pool, spa, waterfall, built-in BBQ, covered patio, and shaded lawn area. Additional amenities include newer HVAC systems, Solar and RV parking.
Details
Maps
Property Information
Property Sub-Type: Single Family Residence
New Construction: No
Stories: 2
Bedrooms: 4
Year Built Source: Public Records
# of Main Level Bedrooms: 1
Full Baths: 3
Total Baths: 3
Three Quarter Baths: 0
Half Baths: 0
Zip Plus 4: 6915
APN: 40260226
Quarter Baths: 0
# of Main Level Bathrooms: 1
SqFt Source: Public Records
Lot Acres: 0.3
Lot SqFt: 13068
Lot Size Source: Public Records
Lot Dimensions: cul-de-sac
Common Interest: None
Area: Out of Area
Street #: 242
Direction: W
Approx Square Feet: 3316
Street Name: Hubert
Suffix: Court
Year Built: 1990
State/Province: CA
Zip Code: 93711
County: Fresno
Listing Information
List Price/SqFt: 278.92
Original List Price: 924900
Status: Closed
Listing Date: 2025-09-18
Listing Price: 924900
Current Price: $890,000
Showing Information
Directions to Property: East on Audubon, North on Glenn Ave, West on Del Mar, North on Hubert
Remarks
Marketing Remarks: Welcome to this stunning home tucked in a private cul-de-sac near the bluffs of the San Joaquin River. This thoughtfully designed residence offers comfort, privacy, and elegance in one of the area's most desirable neighborhoods. A charming front porch welcomes you into a grand entry with a sweeping staircase and abundant natural light. The spacious step-down family room is surrounded by windows and flows into a cozy den with a fireplaceperfect as a second living area or playroom. The gourmet kitchen features high-end stainless steel appliances, including a Thermador range, Kitchen Aid Dishwasher, sleek black granite counters, a walk-in pantry, and a center island with views of the front yard. A downstairs bedroom with full bath offers ideal space for guests or multi-generational living.
Upstairs, the split staircase leads to two large bedrooms with walk-in closets and a Jack and Jill bathroom on one side. On the opposite end, the luxurious primary suite includes a fireplace, private office or retreat space, and balcony overlooking the backyard. The primary bath features an oversized soaking tub, dual vanities, and ample storage. The laundry room is conveniently located upstairs.
The backyard is a true oasis with a heated pool, spa, waterfall, built-in BBQ, covered patio, and shaded lawn area. Additional amenities include newer HVAC systems, Solar and RV parking.
General Information
Garage: Yes
Pool: Yes
# of Garage Spaces: 3
HOA: No
Fireplace: Yes
School Information: Buyer to verify
Spa: Yes
Solar YN: Yes
Accessory Dwelling Unit (ADU) Y/N: No
Additional Parcels Y/N: No
Tax Information
Land Value: 206113
Improvement Value: 474060
Status Change Info
Close Price/SqFt: 268.4
Status Change Date: 2025-11-03
Pending Date: 2025-10-02
Close Date: 2025-11-03
Close Price: 890000
Utilities
Electricity Connected: 1
Natural Gas Connected: 1
Sewer Connected: 1
Water
Public: 1
Sewer
Public Sewer: 1
Cooling
Ceiling Fan(s): 1
Central Air: 1
Heating
Central: 1
Roofing
Composition: 1
Lot Features
Cul-De-Sac: 1
Exterior Features
Barbecue: 1
Fireplace Features
Den: 1
Master Retreat: 1
Flooring
Carpet: 1
Ceramic Tile: 1
Hardwood: 1
Vinyl: 1
Interior Features
Ceiling Fan(s): 1
Kitchen Island: 1
Laundry Features
Inside: 1
Parking Features
Attached: 1
RV Access/Parking: 1
Patio and Porch Features
Front Porch: 1
Pool Features
Heated: 1
In Ground: 1
Rooms
Den: 1
Foyer: 1
Jack & Jill: 1
Walk-In Closet(s): 1
Walk-In Pantry: 1
Spa Features
In Ground: 1
Property Features
Utilities: Electricity Connected; Natural Gas Connected; Sewer Connected
Water: Public
Sewer: Public Sewer
Cooling: Ceiling Fan(s); Central Air
Heating: Central
Roofing: Composition
Exterior Features: Barbecue
Fireplace Features: Den; Master Retreat
Flooring: Carpet; Ceramic Tile; Hardwood; Vinyl
Interior Features: Ceiling Fan(s); Kitchen Island
Laundry Features: Inside
Lot Features: Cul-De-Sac
Parking Features: Attached; RV Access/Parking
Patio and Porch Features: Front Porch
Pool Features: Heated; In Ground
Rooms: Den; Foyer; Jack & Jill; Walk-In Closet(s); Walk-In Pantry
Spa Features: In Ground
IDX
Listing Office: Reside Real Estate
Listing Agent: Dominique M Lupercio-Villalobos | dominique@propertiesbylineage.com
Agent Email: dominique@propertiesbylineage.com
Last Updated: November - 04 - 2025
Information deemed reliable but not guaranteed.