NOT LISTED FOR SALE

6704 W Celeste Ave Fresno, CA 93723

Estimated Value: $550,349 - $585,000

4 Beds
3 Baths
2,291 Sq Ft
$250/Sq Ft Est. Value

Last Sold December 01, 2023

Last sale price $515,000 $225 Per Sq Ft

Est. 11% increase in value since last sale

Current estimated payment $3,625/month

84 Days on Market

Highlights

  • 1 Fireplace
  • 1-Story Property
  • Central Heating and Cooling System

About This Home

As of December 2023

Beautiful first time buyer with beautiful landscaping. It has a spacious living room with a fireplace to enjoy family time and a porch in the back yard ready for family get togethers. Did I mention there solar and its paid off!

Last Agent to Sell the Property

Harpreet Deol

Realty One Group Action License #01893138 Listed on: 08/17/2023

Realty One Group Action

Last Buyer's Agent

Kaying Vang

HomeSmart PV and Associates License #01934717

HomeSmart PV and Associates

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,930

Year Built

  • Built in 2006

Lot Details

  • 7,670 Sq Ft Lot
  • Lot Dimensions are 65x118
  • Property is zoned RS3

Home Design

  • Concrete Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 2,291 Sq Ft Home
  • 1-Story Property
  • 1 Fireplace
  • Laundry in unit

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Bathrooms

Utilities

  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,930

Year Built

Built in 2006

Lot Details

0

Listing Details

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

Interior Features

  • Number Of Fireplaces: 1
  • Bathrooms: 3.00
  • Bedrooms: 4
  • Laundry: Inside
  • Square Footage: 2291.00

Exterior Features

  • Roofing: Tile
  • Exterior: Stucco
  • Foundation: Concrete
  • Pool: No

Utilities

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

Condo/Co-op/Association

  • Association: Fresno MLS

Lot Info

  • Acres: 0.1761
  • Lot Dimensions: 65X118
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 7670.00
  • Price Per Acre: 2924474.73

Building Info

  • Year Built: 2006

MLS Schools

  • School District 2: Central Unified
  • School Type: High School
  • School Name: Central
  • School Type: Junior High School
  • School Name: Glacier Point
  • School Type: Grade School
  • School Name: Harvest

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 17, 2023
Closed on
Nov 24, 2023
Sold by
Yang Lucy
Bought by
Her Nha
Seller's Agent
Harpreet Deol
Realty One Group Action
Buyer's Agent
Kaying Vang
HomeSmart PV and Associates
List Price
$1,224,000
Sold Price
$515,000
Premium/Discount to List
-$709,000
-57.92%
Views
243
Current Estimated Value
$571,837

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$56,837
Avg. Annual Appreciation
4.70%
Original Mortgage
$334,750
Interest Rate
7.63%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 7, 2010
Sold by
Bansal Seema
Bought by
Bansal Vikas

Purchase Details

Closed on
Feb 2, 2010
Sold by
Aurora Loan Services Llc
Bought by
Bansal Vikas

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$187,728
Interest Rate
5.25%
Mortgage Type
FHA

Purchase Details

Closed on
Aug 10, 2009
Sold by
Smith Mary
Bought by
Aurora Loan Services Llc

Purchase Details

Closed on
Jan 20, 2006
Sold by
Smith Mary
Bought by
Lett Rolinda D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$347,952
Interest Rate
7.75%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Dec 28, 2005
Sold by
Grantland Avenue Llc
Bought by
Smith Mary

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$347,952
Interest Rate
7.75%
Mortgage Type
Fannie Mae Freddie Mac
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
Her Nha -- Chicago Title
Her Nha $515,090 Chicago Title
Bansal Vikas -- Lsi
Bansal Vikas $205,000 Lsi
Aurora Loan Services Llc $407,879 Accommodation
Lett Rolinda D -- Financial Title Company
Smith Mary $435,000 Financial Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Her Nha $312,000
Closed Her Nha $334,750
Previous Owner Bansal Vikas $185,200
Previous Owner Bansal Vikas $187,728
Previous Owner Smith Mary $347,952
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/01/2023 12/01/23 Sold $515,000 -2.8% $225 / Sq Ft
10/31/2023 10/31/23 Pending -- -- --
10/03/2023 10/03/23 Price Changed $529,900 -1.0% $231 / Sq Ft
09/21/2023 09/21/23 Price Changed $535,000 -1.7% $234 / Sq Ft
09/15/2023 09/15/23 Price Changed $544,000 -0.9% $237 / Sq Ft
09/08/2023 09/08/23 Price Changed $549,000 -0.2% $240 / Sq Ft
08/22/2023 08/22/23 Price Changed $550,000 -55.1% $240 / Sq Ft
08/08/2023 08/08/23 For Sale $1,224,000 -- $534 / 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 $6,930 $525,300 $157,590 $367,710
2023 $6,930 $254,333 $63,271 $191,062
2022 $3,376 $249,347 $62,031 $187,316
2021 $3,378 $244,459 $60,815 $183,644
2020 $3,267 $241,953 $60,192 $181,761
2019 $3,253 $237,210 $59,012 $178,198
2018 $3,060 $232,559 $57,855 $174,704
2017 $2,995 $228,000 $56,721 $171,279
2016 $2,785 $223,530 $55,609 $167,921
2015 $3,042 $220,173 $54,774 $165,399
2014 $3,073 $215,862 $53,702 $162,160
Source: Public Records

Agents Affiliated with this Home

  • Harpreet Deol

    Seller's Agent in 2023

    Harpreet Deol

    Realty One Group Action

    (559) 761-9335

    76 Total Sales

    Harpreet Deol
    Section Image
  • Kaying Vang

    Buyer's Agent in 2023

    Kaying Vang

    HomeSmart PV and Associates

    (559) 288-9841

    120 Total Sales

    Kaying Vang
    Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 600438

Fresno MLS

APN: 505-184-17

California Fresno County Fresno 93723

6704 W Celeste Ave, Fresno, CA

This home is located at 6704 W Celeste Ave, Fresno, CA 93723 since 17 August 2023 and is currently estimated at $571,837, approximately $249 per square foot. This property was built in 2006. 6704 W Celeste Ave is a home located in Fresno County with nearby schools including Herndon-Barstow Elementary School and Rio Vista Middle 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