Listing Agent: Sherri Camargo, Majestic Palm Realty Inc.
Delano corner 2 story home, Great Price for the right buyers. 4 Bedrooms with 1 bedroom downstairs and full bathroom downstairs, 3 bedrooms 2 bathroom upstairs, main bedroom has walk in closet, soaking tub, separate shower, and dual sinks. Laundry room has laundry sink and door to exterior, plenty of storage, 2 living areas, one with a fireplace for cold winter nights. Close to schools and park.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1995
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
1st
Price Per Square Foot
$204
Days On London
0
Cumulative Days On London
0
County Or Parish
Kern
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
from south, head north on Browning Rd, turn west on 20th ave, north on Morningside WY, West on Cascade Ave, south on Rainbow St., west on Blossom Ave.
Room Type
Walk-In Closet, Separate Family Room, Laundry, Living Room, Main Floor Bedroom, Primary Bathroom
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Gas Dryer Hookup, Individual Room, Washer Hookup
Property Condition
Fixer, Repairs Cosmetic
Main Level Bedrooms
1
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
1
Room Kitchen Features
Kitchen Open to Family Room
Eating Area
Breakfast Counter / Bar, In Living Room, In Kitchen, Breakfast Nook
Natural Gas Connected, Phone Available, Sewer Connected, Cable Available, Electricity Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Corner Lot, 0-1 Unit/Acre, Back Yard
Lot Size Area
6969.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street
View Y/N
Yes
View
City Lights
Common Interest
None
Parcel Number
03452209009
Additional Parcels Y/N
No
Community Features
Curbs, Biking, Street Lights, Storm Drains, Sidewalks, Park
Senior Community Y/N
No
Association Y/N
No
High School District
Delano Joint Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Special Assessments
Tax Lot
54
Tax Tract Number
5792
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 384750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 425250 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) >= 1735 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2235 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` = 1727942 OR `props-main`.`id` = 1723172 OR `props-main`.`id` = 1748566 OR `props-main`.`id` = 1723413 OR `props-main`.`id` = 1706622 OR `props-main`.`id` = 1706623 OR `props-main`.`id` = 1723353 OR `props-main`.`id` = 1754393 OR `props-main`.`id` = 1745708 OR `props-main`.`id` = 1728048 OR `props-main`.`id` = 1766433)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC26185462' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-24' 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();
0
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.
