meta_query='key:subdist__c;value:Inner Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329382' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12162
[post_author] => 4
[post_date] => 2018-10-29 01:21:18
[post_date_gmt] => 2018-10-29 01:21:18
[post_content] => Barely west of Laurel Village and Jordan Park. Very east of Ocean Beach. It's not a transitional neighborhood, it's the Inner Richmond. Delightful shops on Clement Street and a surprisingly central location. But no Muni light rail.
[post_title] => Inner Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-04 08:18:28
[post_modified_gmt] => 2024-11-04 16:18:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12162
[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, 226 2nd Avenue #4, San Francisco, CA, 94118
ffd_mls_id, 423722825
ffd_salesforce_id, a0E8W00000bFH9TUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 226 2nd Avenue #4, San Francisco, CA, 94118
pba__address_pb__c, 226 2nd Avenue #4, San Francisco, CA, 94118
agent_only_remarks__c, Please email us for all showing requests @ [email protected]. Please do not book an appointment through Showing Time. All offers are to be submitted on a San Francisco Purchase Agreement with a TIC Addendum. If you do not have access to this document, kindly let us know and we can provide one for you. The tenant is moving out on March 12th.
appliances__c, Hood Over Range;Free Standing Gas Oven;Electric Cook Top;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1965
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-08T20:48:00.000+0000
days_on_market__c, 133
dom__c, 0
ffd_description_pb, Welcome home to this sweet residence in the midst of all the action in Inner Richmond! Live large in this spacious flat that features a great layout, the living room flows to the dining area, and kitchen. The home boasts two bedrooms with generous closets and one bath. Other amenities include a generous and charming, Eastern-facing landscaped garden, and 1 car parking. A+ location within moments of all that Clement and Geary have to offer - boutique shopping, cafes, artisanal coffee shops, craft cocktail bars, the farmer's market, parks, and more.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__hoafees__c, 377
pba__hoafrequency_pb__c, Monthly
hoa_name__c, HōmWorks Property Services
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2023-07-13T18:32:15.000+0000
pba__latitude_pb__c, 37.7845093
pba__latitude_property__c, 37.7845093
laundry_features__c, In Garage
listed_date__c, 2022-10-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Swann
listing_agent_mls_id__c, 807382
ffd_listingagentname, Rachel Swann
listing_agent_number__c, 1016936
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 850000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/772767412/9e59d18acc
pba__longitude_pb__c, -122.4600483
mls_id__c, 423722825
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-08
original_price__c, 850000
overall_days_on_market__c, -81515
parking_access__c, Side by Side
parking_features__c, Garage Facing Front,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-03-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000bFH9TUAW
room_type__c, Kitchen;Living Room;Primary Bedroom
sale_date__c, 2023-04-06
sale_price__c, 865000
selling_agent_mls_id__c, 815805
selling_agent_number__c, 1074814
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 2nd
subdist__c, Inner Richmond
ffd_name, 226 2nd Avenue #4, San Francisco, CA, 94118
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1965
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530588271-1.jpg