meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235774' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70208
[post_author] => 4
[post_date] => 2018-11-30 20:29:21
[post_date_gmt] => 2018-11-30 20:29:21
[post_content] => What used to be rolling sand dunes as far as the eye can see is now an orderly neighborhood of tidy homes. Views of the Golden Gate Bridge are a welcome surprise from the lucky parts. Proximity to the park appeals to those with canines and kids.
[post_title] => Central Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:27:28
[post_modified_gmt] => 2024-04-09 17:27:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70208
[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, 515 23rd 517 Avenue, San Francisco, CA, 94121
ffd_mls_id, 422645603
ffd_salesforce_id, a0E8W00000WgnggUAB
num_of_rooms__c, 12
of_units__c, 2
address2__c, 515 23rd 517 Avenue, San Francisco, CA, 94121
pba__address_pb__c, 515 23rd 517 Avenue, San Francisco, CA, 94121
agent_only_remarks__c, non-contingent preemptive Building offer accepted. if it closes the TIC postings will be duplicate canceled.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1916
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Darin Holwitz
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-04-08T19:48:48.000+0000
days_on_market__c, 467
dom__c, 7
ffd_description_pb, Duplex in Prime Central Richmond District Located on a tranquil slow street. Walk to Golden Gate Park, Baker Beach and Lake Street. These well preserved 1916 two bedroom full floor flats have been tastefully updated while maintaining their original Art Deco period details. The desirable floor-plan includes a coveted split bedroom layout, light filled living room with fireplace and gracious formal dining room all with gleaming hardwood floors. The well equipped remodeled kitchen includes quartz countertops and plentiful closet space. Other highlights include a large renovated bathroom with stall shower and convenient In-unit laundry area at the rear of the flat. Gardeners delight, well maintained level backyard. Two car independent garage with plenty of storage and expansion potential on the ground floor behind the garage. No ellis or eviction history.
district__c, SF District 1
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2022-05-07T10:50:11.000+0000
pba__latitude_pb__c, 37.777897
pba__latitude_property__c, 37.777897
laundry_features__c, Washer/Dryer Hookups;In Each Unit
listed_date__c, 2022-04-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anthony
pba__listing_agent_lastname__c, Koutsos
listing_agent_mls_id__c, 803007
ffd_listingagentname, Anthony L Koutsos
listing_agent_number__c, 803007
listing_co_agent_mls_id__c, 803861
listing_co_agent_number__c, 166013126
listing_co_office_mls_id__c, COMP2
listing_co_office_name__c, Compass
listing_co_office_number__c, 27341
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 1960000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.515-517-23rd-ave.com/
pba__longitude_pb__c, -122.482741
mls_id__c, 422645603
parkingspaces__c, 2
on_market_date__c, 2022-04-08
original_price__c, 1960000
overall_days_on_market__c, -81181
parking_features__c, Garage,Garage Door Opener,Side-by-Side
pba__pendingdate__c, 2022-04-15
price_per_square_foot__c, 1008.88
pba__propertytype__c, Duplex
id, a0E8W00000WgnggUAB
sale_date__c, 2022-05-06
sale_price__c, 2500000
security_features__c, Security Gate
selling_agent_mls_id__c, EB145178
selling_agent_number__c, 981309542
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BHG RE Reliance Partners
pba__status__c, Closed
pba__totalarea_pb__c, 2478
size__c, 2478
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 23rd
subdist__c, Central Richmond
ffd_name, 515 23rd 517 Avenue, San Francisco, CA, 94121
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530434672-1.jpg
ListingId, a0E8W00000WgnggUAB