Please provide the following information and Lisa Melton-Reimer will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lreimer.com/agent/15910/lisa-meltonreimer/property/link/fresno/639097/2300-Sierra-St-103/Kingsburg/https://www.lreimer.com/images/props/fresno/full/639097.jpgLondon Properties Kingsburg Real Estate | 2300 Sierra St #103
Lisa Melton-Reimer559.318.6798lreimer@londonproperties.comEmail Agent
Property Description
Enjoy the beauty & serenity of Park Place. This unit offers 2 bedrooms, 2 baths, plus office/den and is 1814 square feet. Plenty of space to entertain, visit with friends, write a book, you name it. It was built in 2003 and has been lovingly maintained throughout the years. The large kitchen offers a great space and a picture perfect view out onto the garden. It has a nice laundry room, with a deep sink and plenty of storage. The primary bath has a tub sized step-in tiled shower and the primary closet is simply enormous. A guest room is suitable to two twin beds or a queen size bed. Matching washer and dryer plus a newer refrigerator (all with no warranty) are included in sales price.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$267
Price Per Acre
$4,695,063
Days On Market
31
Cumulative Days On Market
31
County
Fresno
REO / Bank Owned
No
Cross Street Address
23rd
Directions
From Highway 99, exit Conejo/Sierra exit and proceed east about 3 miles past high school. Property is located on the south side of the street in Park Place, a gated community.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Extra Rooms
Den/Study
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 509250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1564 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2064 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` = 1657301 OR `props-main`.`id` = 1657541 OR `props-main`.`id` = 1680178 OR `props-main`.`id` = 1680173 OR `props-main`.`id` = 1693415 OR `props-main`.`id` = 115916 OR `props-main`.`id` = 1001782 OR `props-main`.`id` = 1695292 OR `props-main`.`id` = 1690366 OR `props-main`.`id` = 1696162 OR `props-main`.`id` = 1696161 OR `props-main`.`id` = 1696163 OR `props-main`.`id` = 1695241 OR `props-main`.`id` = 1696714 OR `props-main`.`id` = 1691837 OR `props-main`.`id` = 1696993 OR `props-main`.`id` = 1686902 OR `props-main`.`id` = 1693476 OR `props-main`.`id` = 1688248 OR `props-main`.`id` = 1689823 OR `props-main`.`id` = 1691269 OR `props-main`.`id` = 1694573 OR `props-main`.`id` = 1695585 OR `props-main`.`id` = 1689795 OR `props-main`.`id` = 1691739 OR `props-main`.`id` = 1659174 OR `props-main`.`id` = 1666326 OR `props-main`.`id` = 235510 OR `props-main`.`id` = 1693490 OR `props-main`.`id` = 1695943 OR `props-main`.`id` = 1685467 OR `props-main`.`id` = 1599957 OR `props-main`.`id` = 1695840 OR `props-main`.`id` = 1696738 OR `props-main`.`id` = 1691978 OR `props-main`.`id` = 1691984 OR `props-main`.`id` = 1697163 OR `props-main`.`id` = 1696768 OR `props-main`.`id` = 1688521 OR `props-main`.`id` = 1691034 OR `props-main`.`id` = 1691161 OR `props-main`.`id` = 1691093 OR `props-main`.`id` = 1690368 OR `props-main`.`id` = 1651108 OR `props-main`.`id` = 1663623 OR `props-main`.`id` = 1684007 OR `props-main`.`id` = 1696915)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639097' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-11' 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();
4
Similar Properties
$499,900
4
2
1,880
0.14
161 sunset St
Kingsburg, CA 93631
$485,000
2
1.75
1,814
0.11
2300 Sierra St #122
Kingsburg, CA 93631
$479,000
2
2
1,748
0.21
1673 Union
Kingsburg, CA 93631
$475,000
4
2
1,601
0.16
1303 22Nd Ave
Kingsburg, CA 93631
Courtesy of Judy Pagel, Thompson Real Estate Associates Corporation - judypagelre@gmail.com Last modified 1 week ago Fresno MLS last checked for updates 39 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.
