email phone translateTranslate
homeOpen Houses

150 W CELESTE AVE, FRESNO, CA, 93704

(Sold On 03/09/2018) Represented the Buyer
  • $277,000 -$1,000
  • 3Beds
  • 0Baths
  • 1,962Sqft
  • Style
  • Single Family
  • Listed Date 12/26/2017
areamap school area overview 3D Tour Share
  • Open House
  • NEWLY PRICED -$1,000
  • Luxury
  • Pending
  • New Listing 12/26/2017
  • Coming Soon
  • Sold
  • Rental
Thank you

Interested in this property

FHA ready!!! Let this newly renovated home be your start. You'll be in awe with the large open floor plan, wood flooring, new paint, and light fixtures. The formal dining room and Living room is located off the gourmet kitchen with new appliances sink, fixtures, and quartz counter tops. The bedrooms are huge and feature new carpet, paint, and large closets. New garage doors, fresh sod, and a new roof finish off the look.

Listing courtesy of: Christopher Cissel, C-21 C Watson Real Estate Inc.
  • Property type: Single Family
  • Status: Sold
  • List Price: $277,000
  • MLS# 494569
  • Beds: 3
  • Baths: 0
  • Full Baths: 0
  • Half Baths: 0
  • Listed: 12/26/2017
  • Sqft: 1,962
  • Lot Size Acres: 0.21
  • Age: 62
  • Association: Fresno MLS
  • Basement Sq Ft: 0.00
  • Bath Features: Shower, Tub
  • List Price Per Sqft: 142
  • Carport Spaces: 0
  • County: Fresno
  • Directions: West on Bullard from Blackstone, south on Del Mar, east on Celeste.
  • Exterior: Stucco
  • Financing: VA
  • Fireplace Type: Masonry
  • Floor: Carpet, Hardwood, Tile
  • Foundation: Concrete
  • Garage Type: Attached
  • Garage Space: 2
  • Gas and Electric: Public Utilities
  • Heating and Cooling: Central Heat & Cool
  • Fireplace YN: Yes
  • New Construction YN: No
  • Pool YN: No
  • REO or Bank Owned YN: No
  • Short Sales YN: No
  • Kitchen Area: 0
  • Kitchen_x0020_Desc: Dishwasher, Disposal, Microwave, F/S Range/Oven
  • Kitchen Dim: 0 x 0
  • Kitchen Len: 0
  • Kitchen Wid: 0
  • Laundry: Inside, Utility Room
  • Living Room Area: 0
  • LivingRoom Dim: 0 x 0
  • LivingRoom Len: 0
  • LivingRoom Wid: 0
  • Lot Measurement: Square Feet
  • Lot Size Source: Tax Records
  • Lot Square Footage: 9288.00
  • Number of Fireplaces: 1
  • Number of Stories: 1
  • Pool: N
  • Roof: Comp Shingle
  • Solar: No
  • Stories: Single Story
  • Style: Ranch
  • Yard: Sprinklers Auto, Sprinklers Back, Sprinklers Front
  • Year Built: 1956
  • HOA Fee:
  • HOA Frequency:
  • HOA Include:

YOUR MORTAGE PROVIDERS

Your mortage providers plays a significant role in the success of your home purchase. To start the pre-qualification process we invite you to visit one of our preferred providers:

Mortgage Information


Results

Monthly insurance: 
$0.00
Monthly taxes: 
$0.00
Monthly payment: 
$0.00
Total monthly payment: 
$0.00
888-702-4297

Find out how much you can save on insurance!

Quote Type


Enter Your Zip Code

Area Map


 

radio_button_unchecked
location_on

Area Overview


Nearby Schools

mccardle elementary school ()
577 e sierra ave
fresno, CA 93710
place1.11 miles from listing, web Website 21 students per teacher Educational climate index: below average
20 staff members 420 total students Poverty level:30 percent or more percent Enrollment change: -5% to -10%
robinson elementary school ()
555 e browning ave
fresno, CA 93710
place0.90 miles from listing, web Website 9 students per teacher Educational climate index: below average
50 staff members 475 total students Poverty level:30 percent or more percent Enrollment change: +15% to +20%
herbert hoover high school ()
5550 n 1st st
fresno, CA 93710
place1.24 miles from listing, web Website 23 students per teacher Educational climate index: below average
80 staff members 1848 total students Poverty level:30 percent or more percent Enrollment change: -5% to -10%
wolters elementary school ()
5174 n 1st st
fresno, CA 93710
place1.37 miles from listing, web Website 24 students per teacher Educational climate index: below average
22 staff members 540 total students Poverty level:30 percent or more percent Enrollment change: -5% to -10%
malloch elementary school ()
2251 w morris ave
fresno, CA 93711
place2.11 miles from listing, web Website 18 students per teacher Educational climate index: average
25 staff members 469 total students Poverty level:30 percent or more percent Enrollment change: +5% to +10%
tenaya middle school ()
1239 w mesa ave
fresno, CA 93711
place1.14 miles from listing, web Website 24 students per teacher Educational climate index: average
40 staff members 960 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
gibson elementary school ()
1266 w barstow ave
fresno, CA 93711
place1.20 miles from listing, web Website 26 students per teacher Educational climate index: average
22 staff members 580 total students Poverty level:30 percent or more percent Enrollment change: +20% to +50%
kratt elementary school ()
650 w sierra ave
fresno, CA 93704
place0.86 miles from listing, web Website 27 students per teacher Educational climate index: average
20 staff members 540 total students Poverty level:30 percent or more percent Enrollment change: +1% to +5%
bullard high school ()
5445 n palm ave
fresno, CA 93704
place0.88 miles from listing, web Website 22 students per teacher Educational climate index: average
120 staff members 2730 total students Poverty level:30 percent or more percent Enrollment change: +1% to +5%
baird middle school ()
5500 n maroa ave
fresno, CA 93704
place0.40 miles from listing, web Website 17 students per teacher Educational climate index: average
35 staff members 600 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
bullard talent project school ()
4950 n harrison ave
fresno, CA 93704
place1.33 miles from listing, web Website 20 students per teacher Educational climate index: average
40 staff members 800 total students Poverty level:30 percent or more percent Enrollment change: +5% to +10%
powers-ginsburg elementary school ()
110 e swift ave
fresno, CA 93704
place1.98 miles from listing, web Website 19 students per teacher Educational climate index: average
42 staff members 800 total students Poverty level:30 percent or more percent Enrollment change: More than -50%/+50%
st. anthony school ()
5680 n maroa ave
fresno, CA 93704
place0.30 miles from listing, web Website 24 students per teacher Educational climate index: average
19 staff members 625 total students Poverty level:30 percent or more percent Enrollment change: No Change
mountain view christian school ()
1284 e bullard ave
fresno, CA 93710
place1.58 miles from listing, web Website 9 students per teacher Educational climate index: below average
6 staff members 38 total students Poverty level:30 percent or more percent Enrollment change:
fairmont private school of fresno ()
435 w fairmont ave
fresno, CA 93705
place1.63 miles from listing, web Website 28 students per teacher Educational climate index: low
2 staff members 57 total students Poverty level:not reported percent Enrollment change:
fresno montessori school ()
1572 e barstow ave
fresno, CA 93710
place1.89 miles from listing, web Website Not Reported students per teacher Educational climate index: below average
4 staff members 160 total students Poverty level:not reported percent Enrollment change:
rata (florence e.) ()
1373 w mesa ave
fresno, CA 93711
place1.29 miles from listing, web Website 8 students per teacher Educational climate index: average
8 staff members 70 total students Poverty level:30 percent or more percent Enrollment change: +5% to +10%
truth tabernacle christian school ()
4411 n 1st st
fresno, CA 93726
place1.94 miles from listing, web Website 13 students per teacher Educational climate index: unclassified
7 staff members 93 total students Poverty level:30 percent or more percent Enrollment change:
Fresno Multiple Listing Service™ system The real estate listing data marked with this icon comes from the IDX program of the Fresno Multiple Listing Service™ system.
keyboard_arrow_up