• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Private Listings
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • estate, trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON OCT 26 2025 AT 6:32 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

5287 N Sequoia Dr

fresno, CA 93711

$1,285,000

  • 5 BR
    5 BA
    APPROX. 7,390 SF
  • contract signed

INTERESTED? LET'S CONNECT

Step into a one-of-a-kind North Fresno masterpiece where a 1970s time capsule collides with sleek James Bond-style sophistication. Nestled on 1.28 private gated acres off the prestigious Van Ness Extension, this 7,390 sq. ft. estate is an entertainer's dream, designed to impress at every turn.

From the moment you arrive, the lush, manicured landscaping and private gated entry set the tone for this extraordinary home. Featuring 5 bedrooms, 5 bathrooms, a 6-car garage plus 2-car carport, this residence blends retro charm with modern luxuries. The centerpiece is the expansive great room with a dramatic conversation pit, soaring ceilings, wet bar, and multiple seating areas including a cozy fireplace nook creating the ultimate space for gatherings. Upstairs, a loft overlooks the great room and opens to a rooftop patio, perfect for sunset cocktails.

The chef's kitchen is both massive and functional, with two stoves, two ranges (gas + electric), two sinks, two dishwashers, built-in fridge, a center island, and butler's pantry all seamlessly connected to the living and dining areas. The climate-controlled wine room adds an elevated touch for collectors.

The luxurious primary suite is a modern retreat with a romantic fireplace, huge walk-in closet, and spa-style bath. Outside, discover a resort-style oasis with an oversized custom pool & rock waterfall, outdoor kitchen and bar with commercial pizza oven setup, plus a large grassy area for play or events. Entertain effortlessly under the expansive covered patio or enjoy the unique outdoor shower after a swim.

This home offers unmatched potential, needing some TLC, yet priced well below market value, giving you the opportunity to customize and create your dream estate! Bathed in natural light and surrounded by breathtaking landscaping, this property delivers privacy, space, and style in one of Fresno's most desirable locations.

If you've been waiting for a home that makes a statement, this is it. Schedule your private showing today and experience a home that truly has no equal.

Details

7,390 Sq Ft

1.28 Private Acres Lot Size

Single Family Home

Built in 1979

MLS/Listing ID FR25217950

1 Units

Amenities & Features

French Doors / Atrium Doors

Wood

Wrought-iron

Dining Room Fireplace

Family Room Fireplace

Parking - Paved

Parking - RV Potential

Parking - Tandem

Concrete

Covered

Open

Patio

Rooftop

Pool - Inground

Pool - Private

Composition

Tile

Neighborhood View

Blinds

Skylights

Shutters

Laundry Room

Lot - Backyard

Lot - Front Yard

Lot - Lawn

Lot - Landscaped

Lot - Sprinkler System

Lot - Yard

Parking - Attached Carport

Parking - Driveway

Parking - Garage

Parking - Gated

Electric Range

Dishwasher

Double Oven

Built-in Range

Living Room Fireplace

Great Room Fireplace

Gas Fireplace

Disposal

Carpet

Laminate

Natural Wood

Slab

Wet Bar

Breakfast Bar

Built-in Features

Balcony

Breakfast Area

Cooling - Ceiling Fans

Separate Formal Dining Room

Eat-in Kitchen

High Ceilings

Open Floor Plan

Pantry

Recessed Lighting

Storage

Sunken Living Room

Two Story Ceilings

Bar

All Bedrooms Down

Jack and Jill Bath

Loft

Washer Hookup

In Garage

In Kitchen

Gas Range

Microwave

Refrigerator

Community - Suburban

Construction - Wood Siding

Cooling - Central Air

CRMLS

Source of Data: CALIFORNIA REGIONAL MULTIPLE LISTING SERVICE

Interested in 5287 N Sequoia Dr?