Beautiful single story! With 3 bedroom and 2 baths, includes indoor laundry room. Move in ready! Get in before the Holidays. Home offers beautiful granite kitchen countertops and laminate flooring thru out the home. This home shows pride of ownership. Walking distance to Fresno State, close to HWY 168, public transportation accessible. All FHA and VA welcome.
Property Type
Residential
Property Subtype 1
PUD
Property Subtype 2
Single Family Residence
Property Subtype 3
Condominium
Year Built
1984
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$196
Price Per Acre
$5,553,333
Days On Market
75
Cumulative Days On Market
75
County
Fresno
Special Features
Security Gate, Built In Cabinets, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
Shaw & Cedar
Directions
Use GPS. GPS will take you to gate. Must input code to get in.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Electric Appliances, Dishwasher, Microwave, Breakfast Bar
Pool, Spa, Club House, Green Area, Security Guard, Landscape Maint, Gated Community, Other/None
HOA Dues
465.00
Frequency
Monthly
School District
Fresno Unified
School Type 1
High School
School Name 1
Hoover
School Type 2
Junior High School
School Name 2
Tioga
School Type 3
Grade School
School Name 3
Vinland
1st Loan Type
Non-Assumable
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1023 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1523 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` = 1684412 OR `props-main`.`id` = 1695754 OR `props-main`.`id` = 1698824 OR `props-main`.`id` = 1696540 OR `props-main`.`id` = 1691098 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 1691001 OR `props-main`.`id` = 1695582 OR `props-main`.`id` = 1701281 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1696732 OR `props-main`.`id` = 1696455 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696446 OR `props-main`.`id` = 1696456 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696447 OR `props-main`.`id` = 1696457 OR `props-main`.`id` = 1696448 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1691849 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1677679 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1694761 OR `props-main`.`id` = 1701174 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1694301 OR `props-main`.`id` = 1700906 OR `props-main`.`id` = 1690591 OR `props-main`.`id` = 1695772 OR `props-main`.`id` = 1700806 OR `props-main`.`id` = 1698713 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1696806 OR `props-main`.`id` = 1701418 OR `props-main`.`id` = 1701668 OR `props-main`.`id` = 1701246 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1694857 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1701564 OR `props-main`.`id` = 1700060 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1689450 OR `props-main`.`id` = 1702006 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1689290 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1694690 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1701172 OR `props-main`.`id` = 1649781 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1692325 OR `props-main`.`id` = 1696609 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1685930 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1695855 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1697319 OR `props-main`.`id` = 1693812 OR `props-main`.`id` = 1694858 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1688987 OR `props-main`.`id` = 1698844 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1680103 OR `props-main`.`id` = 1701263 OR `props-main`.`id` = 1701260 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1700020 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1695440 OR `props-main`.`id` = 1702095 OR `props-main`.`id` = 1692526 OR `props-main`.`id` = 1696790 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1701231 OR `props-main`.`id` = 1699980 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1691062 OR `props-main`.`id` = 1694788 OR `props-main`.`id` = 1697415 OR `props-main`.`id` = 1696497 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1660355 OR `props-main`.`id` = 1687083 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1691716 OR `props-main`.`id` = 1691176 OR `props-main`.`id` = 1692236 OR `props-main`.`id` = 1696519 OR `props-main`.`id` = 1701818 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1695665 OR `props-main`.`id` = 1695890 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1695637 OR `props-main`.`id` = 1686274 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1697121 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1697200 OR `props-main`.`id` = 1694006 OR `props-main`.`id` = 1694007 OR `props-main`.`id` = 1697379 OR `props-main`.`id` = 1686039 OR `props-main`.`id` = 1701821 OR `props-main`.`id` = 1701237 OR `props-main`.`id` = 1697808 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1699036 OR `props-main`.`id` = 1691762 OR `props-main`.`id` = 1701131)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639121' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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();
1
Similar Properties
$249,000
3
2
1,521
1272 Villa Ave #76
Clovis, CA 93612
Courtesy of Lucia Magdaleno, Universal Realty Services, Inc. - [email protected] Last modified 1 week ago Fresno MLS last checked for updates 4 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.
