London Properties Fresno Real Estate

Jasmin Quintana | 559.448.7951 | jquintana@londonproperties.com | LIC #02127412

Home Buying Selling About Contact

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Home

Buying

Selling

Home Value Calculator

About

Create Account | Login

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

987 N Filbert Ave

Fresno, CA 93727

Copy Link Get Directions

Photo Gallery

$529,900

4 bd

3 ba

2,143 sq ft

0.09 acre

987 N Filbert Ave

Fresno, CA 93727

Get Directions

Listed On: 02/04/2026

Status: Active

Listing Number: 643297 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Jasmin Quintana 559.448.7951 Email Agent

Property Description

Step into this barely-lived-in model home, thoughtfully designed and truly move-in ready. This stunning residence offers a highly desirable downstairs guest suite, with full bathroom just outside the bedroom, ideal for visitors or multi-generational living. The open-concept living and dining areas create an inviting space for entertaining and flow seamlessly into the beautifully appointed kitchen. The kitchen features a generous island, pendant lighting, quartz countertops, a large undermount single-basin sink, and stainless-steel appliances perfect for both everyday living and hosting. The owner's suite is a private retreat, complete with a luxurious bathroom featuring a shower, dual sinks, and an expansive walk-in closet. A secondary bathroom includes an extended vanity with double sinks and cabinet, adding both style and functionality. Upstairs, a spacious loft provides endless versatility and can be used as a game room, second living area, or study space. Luxurious wood flooring runs throughout the home, complemented by plush carpeting in the bedrooms, loft and staircase. A dedicated laundry area with both an electric washer and dryer hook up and double sinks adds everyday convenience. The low-maintenance backyard has been beautifully landscaped, providing an ideal outdoor space to relax or entertain. Additional highlights include LED lighting, a 40-amp prewire for electric vehicle charging, and an owned solar energy system, making this home as efficient as it is beautiful.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2023

Region

Urban

# of Stories

Two

Price Per Square Foot

$247

Price Per Acre

$5,887,778

Days On London

Cumulative Days On London

County

Fresno

Special Features

Isolated Bedroom, Isolated Bathroom, Built In Cabinets

REO / Bank Owned

Cross Street Address

Belmont/Armstrong

Directions

eastbound on hwy 180 ;exit on fowler. turn right. Turn left on belmont. right on shelly. right on madison

Heating & Cooling

Central Heat & Cool

Laundry

Inside, Utility Room

Roofing

Tile

Foundation

Concrete

Kitchen

Gas Appliances, Disposal, Dishwasher, Pantry

Primary Bedroom Level

Upper

Exterior

Stucco

Pool

Patio Features

Uncovered, Concrete

Yard

Sprinklers Front, Sprinklers Back, Synthetic Lawn, Drip System

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Solar

Yes

Solar Type

Owned

Garage Type

Attached

Garage Spaces

APN

575 041 08 [PARCEL MAP]

Zoning

RS5

School District

Clovis Unified

School Type 1

High School

School Name 1

Clovis East

School Type 2

Junior High School

School Name 2

Reyburn

School Type 3

Grade School

School Name 3

Temperance-Kutner

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1893 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2393 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1697310 OR `props-main`.`id` = 1703463 OR `props-main`.`id` = 1690171 OR `props-main`.`id` = 1690420 OR `props-main`.`id` = 1705161 OR `props-main`.`id` = 1691847 OR `props-main`.`id` = 1697805 OR `props-main`.`id` = 1697998 OR `props-main`.`id` = 1698731 OR `props-main`.`id` = 165776 OR `props-main`.`id` = 1703960 OR `props-main`.`id` = 1693810 OR `props-main`.`id` = 1703782 OR `props-main`.`id` = 1687866 OR `props-main`.`id` = 1701020 OR `props-main`.`id` = 1696750 OR `props-main`.`id` = 1703273 OR `props-main`.`id` = 1696304 OR `props-main`.`id` = 1705415 OR `props-main`.`id` = 1705399 OR `props-main`.`id` = 1696464 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1701749 OR `props-main`.`id` = 1701280 OR `props-main`.`id` = 1706132 OR `props-main`.`id` = 1695731 OR `props-main`.`id` = 1706644 OR `props-main`.`id` = 1679182 OR `props-main`.`id` = 1695065 OR `props-main`.`id` = 1679180 OR `props-main`.`id` = 1679181 OR `props-main`.`id` = 1705942 OR `props-main`.`id` = 1702241 OR `props-main`.`id` = 1678590 OR `props-main`.`id` = 1704906 OR `props-main`.`id` = 1680124 OR `props-main`.`id` = 1679440 OR `props-main`.`id` = 1704183 OR `props-main`.`id` = 1697987 OR `props-main`.`id` = 1697992 OR `props-main`.`id` = 1697986 OR `props-main`.`id` = 1697997 OR `props-main`.`id` = 1698951 OR `props-main`.`id` = 1701796 OR `props-main`.`id` = 1703743 OR `props-main`.`id` = 1704514 OR `props-main`.`id` = 1697267 OR `props-main`.`id` = 1703929 OR `props-main`.`id` = 1692328 OR `props-main`.`id` = 1703763 OR `props-main`.`id` = 1683995 OR `props-main`.`id` = 1696453 OR `props-main`.`id` = 1703137 OR `props-main`.`id` = 1701952 OR `props-main`.`id` = 1705930 OR `props-main`.`id` = 1702979 OR `props-main`.`id` = 1702954 OR `props-main`.`id` = 1702982 OR `props-main`.`id` = 1702961 OR `props-main`.`id` = 1688490 OR `props-main`.`id` = 1679220 OR `props-main`.`id` = 1700908 OR `props-main`.`id` = 1705881 OR `props-main`.`id` = 1703885 OR `props-main`.`id` = 1686337 OR `props-main`.`id` = 1706000 OR `props-main`.`id` = 1706719 OR `props-main`.`id` = 1703564 OR `props-main`.`id` = 1704460 OR `props-main`.`id` = 1703563 OR `props-main`.`id` = 1703562 OR `props-main`.`id` = 1703561 OR `props-main`.`id` = 1703539 OR `props-main`.`id` = 1703952 OR `props-main`.`id` = 1701845 OR `props-main`.`id` = 1697947 OR `props-main`.`id` = 1701411 OR `props-main`.`id` = 1702352 OR `props-main`.`id` = 1701404 OR `props-main`.`id` = 1703405 OR `props-main`.`id` = 1685109 OR `props-main`.`id` = 1701397 OR `props-main`.`id` = 1701406 OR `props-main`.`id` = 1701414 OR `props-main`.`id` = 1701408 OR `props-main`.`id` = 1701407 OR `props-main`.`id` = 1701409 OR `props-main`.`id` = 1701410 OR `props-main`.`id` = 1705111 OR `props-main`.`id` = 1701415 OR `props-main`.`id` = 1701416 OR `props-main`.`id` = 1701401 OR `props-main`.`id` = 1696055 OR `props-main`.`id` = 1689501 OR `props-main`.`id` = 1706669 OR `props-main`.`id` = 1701421 OR `props-main`.`id` = 1704185 OR `props-main`.`id` = 1696891 OR `props-main`.`id` = 1696893 OR `props-main`.`id` = 1691096 OR `props-main`.`id` = 1703734 OR `props-main`.`id` = 1692247 OR `props-main`.`id` = 1704621 OR `props-main`.`id` = 1666305 OR `props-main`.`id` = 1702481 OR `props-main`.`id` = 1703319 OR `props-main`.`id` = 1698022 OR `props-main`.`id` = 1701402 OR `props-main`.`id` = 1703049 OR `props-main`.`id` = 1691985 OR `props-main`.`id` = 1695102 OR `props-main`.`id` = 1691688 OR `props-main`.`id` = 1706044 OR `props-main`.`id` = 1705188 OR `props-main`.`id` = 1680358 OR `props-main`.`id` = 1671592 OR `props-main`.`id` = 1671586 OR `props-main`.`id` = 1698500 OR `props-main`.`id` = 1705869 OR `props-main`.`id` = 1695576 OR `props-main`.`id` = 1705085 OR `props-main`.`id` = 1697312 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1701643)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643297' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-08' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

Similar Properties

$549,000

4
3
2,249
0.12

2148 N Millard Ave

Fresno, CA 93727

$510,000

4
3
2,143
0.12

6693 E Nevada Ave

Fresno, CA 93727

$510,000

4
3
2,338
0.14

5922 E Fancher Creek Dr

Fresno, CA 93727

Courtesy of Damaris Lambrecht, Realty Concepts, Ltd. - Fresno - damaris@realtyconcepts.com
Last modified 3 days ago
Fresno MLS last checked for updates 16 minutes ago

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Get More Info

Print A Flyer

Get A Home Loan

Share

987 N Filbert Ave

Fresno, CA 93727

Photo Gallery

$529,900

987 N Filbert Ave

Fresno, CA 93727

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$549,000

$510,000

$510,000