NOT LISTED FOR SALE

4787 W Celeste Ave Fresno, CA 93722

Fig Garden Loop Neighborhood

Estimated Value: $470,055 - $493,000

3 Beds
2 Baths
2,153 Sq Ft
$224/Sq Ft Est. Value

Last Sold March 05, 2021

Last sale price $370,000 $172 Per Sq Ft

Est. 30% increase in value since last sale

Current estimated payment $3,052/month

4 Days on Market

Highlights

  • Formal Dining Room
  • 1-Story Property
  • Family Room
  • Breakfast Bar
  • Central Heating and Cooling System
  • Wood Siding

About This Home

As of March 2021

Check out this beautiful Lennar move in ready single story home! This home features an open kitchen with granite counter tops, new dishwasher and microwave. The extra large master suite is complete with a sitting area, double walk in closets and a large en suite with a soaking tub for relaxing. Newer laminate flooring throughout most of the home and a brand new AC unit! Low maintenance landscaping with a cement pad and gazebo. Washer and dryer included in sale. This home really shows pride of ownership!

Last Agent to Sell the Property

Erin Rengh

HomeSmart PV and Associates License #02058280 Listed on: 01/29/2021

HomeSmart PV and Associates

Last Buyer's Agent

Rebecca Vardapetian

Realty Associates, Inc. License #01495453

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,155

Year Built

  • Built in 2005

Lot Details

  • 6,000 Sq Ft Lot
  • Lot Dimensions are 60x100
  • Property is zoned RS5

Home Design

  • Concrete Foundation
  • Composition Roof
  • Wood Siding

Interior Spaces

  • 2,153 Sq Ft Home
  • 1-Story Property
  • Self Contained Fireplace Unit Or Insert
  • Family Room
  • Formal Dining Room
  • Breakfast Bar
  • Laundry in unit

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Bathrooms

Utilities

  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,155

Year Built

Built in 2005

Lot Details

0

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Price Per Square Foot: 171.85
  • Year Built Exception: 0
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 2005

Interior Features

  • Fireplace Type: Gas Insert
  • Number Of Fireplaces: 1
  • Bathrooms: 2.00
  • Bedrooms: 3
  • Dining Room Features: Formal, Family Room/Area
  • Kitchen: Gas Appliances, Breakfast Bar, Pantry
  • Laundry: Inside
  • Square Footage: 2153.00

Exterior Features

  • Roofing: Composition
  • Exterior: Wood
  • Foundation: Concrete
  • Pool: No

Utilities

  • Heating And Cooling: Central Heat & Cool
  • Gas And Electric: Public Utilities
  • Sewer/Water: Public Water, Public Sewer

Condo/Co-op/Association

  • Association: Fresno MLS

Schools

  • School District: Fresno Unified

Lot Info

  • Acres: 0.1377
  • Lot Dimensions: 60X100
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 6000.00
  • Price Per Acre: 2687000.73

Building Info

  • Year Built: 2005

MLS Schools

  • School District: Fresno Unified
  • School Type: High School
  • School Name: Bullard
  • School Type: Junior High School
  • School Name: Tenaya
  • School Type: Grade School
  • School Name: Lawless

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 29, 2021
Closed on
Feb 26, 2021
Sold by
Soria Jose Reyes
Bought by
Semirdjian Armine
Seller's Agent
Erin Rengh
HomeSmart PV and Associates
Buyer's Agent
Rebecca Vardapetian
Realty Associates, Inc.
List Price
$370,000
Sold Price
$370,000
Current Estimated Value
$481,264

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$111,264
Avg. Annual Appreciation
5.86%
Original Mortgage
$270,000
Outstanding Balance
$243,133
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$234,143

Purchase Details

Listed on
Jan 29, 2021
Closed on
Feb 10, 2021
Sold by
Sanchez Branden A
Bought by
Semirdjian Armine
Seller's Agent
Erin Rengh
HomeSmart PV and Associates
Buyer's Agent
Rebecca Vardapetian
Realty Associates, Inc.
List Price
$370,000
Sold Price
$370,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$270,000
Outstanding Balance
$243,133
Interest Rate
2.7%
Mortgage Type
New Conventional
Estimated Equity
$234,143

Purchase Details

Listed on
Mar 3, 2015
Closed on
May 8, 2015
Sold by
Sanchez Brittney Nicole
Bought by
Sanchez Branden A
Seller's Agent
Tejinder Khehra
RE/MAX Gold
Buyer's Agent
Mike Bustamante
Keller Williams Fresno
List Price
$245,000
Sold Price
$245,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.35%
Original Mortgage
$232,750
Interest Rate
3.67%
Mortgage Type
New Conventional

Purchase Details

Listed on
Mar 3, 2015
Closed on
May 4, 2015
Sold by
Singh Sakinder
Bought by
Sanchez Branden A
Seller's Agent
Tejinder Khehra
RE/MAX Gold
Buyer's Agent
Mike Bustamante
Keller Williams Fresno
List Price
$245,000
Sold Price
$245,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$232,750
Interest Rate
3.67%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 21, 2010
Sold by
Singh Tarlok
Bought by
Singh Sakinder

Purchase Details

Closed on
Jan 27, 2005
Sold by
Kaur Sandip
Bought by
Singh Tarlok

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$231,600
Interest Rate
6.12%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jan 1, 2005
Sold by
Lennar Fresno Inc
Bought by
Singh Tarlok

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$231,600
Interest Rate
6.12%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Semirdjian Armine -- Chicago Title
Semirdjian Armine $370,000 Chicago Title
Sanchez Branden A -- Chicago Title Company
Sanchez Branden A $245,000 Chicago Title
Singh Sakinder $170,000 Placer Title Company
Singh Sakinder -- Placer Title Company
Singh Tarlok -- North American Title Co Inc
Singh Tarlok $290,000 North American Title Co Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Semirdjian Armine $270,000
Previous Owner Sanchez Branden A $232,750
Previous Owner Singh Sakinder $136,000
Previous Owner Singh Tarlok $70,000
Previous Owner Singh Tarlok $231,600
Closed Singh Tarlok $57,925
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/05/2021 03/05/21 Sold $370,000 0.0% $172 / Sq Ft
02/02/2021 02/02/21 Pending -- -- --
01/29/2021 01/29/21 For Sale $370,000 +51.0% $172 / Sq Ft
05/15/2015 05/15/15 Sold $245,000 0.0% $114 / Sq Ft
04/10/2015 04/10/15 Pending -- -- --
03/03/2015 03/03/15 For Sale $245,000 -- $114 / Sq Ft
Source: Fresno MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,155 $400,498 $108,242 $292,256
2023 $5,045 $384,948 $104,040 $280,908
2022 $4,970 $377,400 $102,000 $275,400
2021 $3,597 $272,023 $83,271 $188,752
2020 $3,536 $269,235 $82,418 $186,817
2019 $3,436 $263,956 $80,802 $183,154
2018 $3,344 $258,781 $79,218 $179,563
2017 $3,258 $253,708 $77,665 $176,043
2016 $3,150 $248,735 $76,143 $172,592
2015 $2,914 $236,285 $37,590 $198,695
2014 $2,859 $231,657 $36,854 $194,803
Source: Public Records

Agents Affiliated with this Home

  • Erin Rengh

    Seller's Agent in 2021

    Erin Rengh

    HomeSmart PV and Associates

    (559) 708-9758

    1 in this area

    31 Total Sales

    Erin Rengh
    Section Image
  • Rebecca Vardapetian

    Buyer's Agent in 2021

    Rebecca Vardapetian

    Realty Associates, Inc.

    (559) 287-3092

    3 in this area

    25 Total Sales

    Rebecca Vardapetian
    Section Image
  • Tejinder Khehra

    Seller's Agent in 2015

    Tejinder Khehra

    RE/MAX

    (559) 994-6636

    1 in this area

    110 Total Sales

    Tejinder Khehra
    Section Image

  • M

    Buyer's Agent in 2015

    Mike Bustamante

    Keller Williams Fresno

    Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 553681

Fresno MLS

APN: 509-370-09

California Fresno County Fresno 93722 Fig Garden Loop

4787 W Celeste Ave, Fresno, CA

This home is located at 4787 W Celeste Ave, Fresno, CA 93722 since 29 January 2021 and is currently estimated at $481,264, approximately $223 per square foot. This property was built in 2005. 4787 W Celeste Ave is a home located in Fresno County with nearby schools including Lawless Elementary School, Tenaya Middle School, and Bullard High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Fresno MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes