meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209937' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 1742 28th Avenue, San Francisco, CA, 94122
ffd_mls_id, 494320
ffd_salesforce_id, a0E1I00000QpKffUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1742 28th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1742 28th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Send your clients sight unseen! Sellers still occupy the property, so it is not staged, but is in great condition. Charm galore, as well as potential to add more legal space down. Please text Alex at 415-254-5351 for private showings and details, or better yet, visit one of the many the open houses. Offer date 2/12/2020 at 12 noon via email to [email protected]. Please submit all offers on SFAR purchase contract with proof of funds, pre-approval, signed disclosure package, and 24 hours to respond.
appliances__c, Gas Range;Microwave;Refrigerator;Freestanding Range
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-01-31T20:45:30.000+0000
days_on_market__c, 1266
dom__c, 13
ffd_description_pb, Only the second time on the market since being built in 1939, and situated in a great Central Sunset location up the hill from Sunset Playground / Recreation area, 1742 28th Ave is a gem of gems. This home retains much of its original character and charm and is in excellent condition. Property Details: 2 Bedrooms; Bonus Room Downstairs; 1 Bath ; 1 car large garage; Formal Living Room; Dining Room; Eat - in Kitchen; Original Wood Floors; Wood Burning Fireplace; Center Patio; 1275 Square Feet (per tax records); Terraced Mature Yard / Garden; Solar Power; Washer & Dryer; Built - in wine rack/storage; Work bench/area. [Note: Rooms have been virtually staged in some photos.)
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:27:11.000+0000
pba__latitude_pb__c, 37.754875
pba__latitude_property__c, 37.754875
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-01-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Clark
listing_agent_mls_id__c, 802982
ffd_listingagentname, Alexander T Clark
listing_agent_number__c, 802982
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TFST
listing_office_name__c, The Front Steps
listing_office_number__c, 27633
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://thefrontsteps.com/drive-homepage/featured-listings/1742-28thave/
pba__longitude_pb__c, -122.485863
pba__lotsize_pb__c, 0.07
mls_id__c, 494320
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-01-30
original_price__c, 1195000
overall_days_on_market__c, 153
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-02-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1137.25
pba__propertytype__c, Single Family Residence
id, a0E1I00000QpKffUAF
room_type__c, Studio
sale_date__c, 2020-02-19
sale_price__c, 1450000
selling_agent_mls_id__c, MLSL107621
selling_agent_number__c, 981135928
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Century 21 Real Estate Alliance
pba__status__c, Closed
pba__totalarea_pb__c, 1275
size__c, 1275
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 28th
subdist__c, Central Sunset
ffd_name, 1742 28th Avenue, San Francisco, CA, 94122
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359809-1.jpg
ListingId, a0E1I00000QpKffUAF