meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='346658' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70661
[post_author] => 4
[post_date] => 2018-11-30 20:30:35
[post_date_gmt] => 2018-11-30 20:30:35
[post_content] => East of Orizaba, but northwest of I-280 and south of Lakeside, the Oceanview slopes gently down to the Outer Mission where I-280 snakes along the neighborhood border to Daly City and points south. There's good access to I-280 from the entire neighborhood, and Balboa Park BART is just a few blocks from the northeast side of the neighborhood.
[post_title] => Oceanview
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => oceanview
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:20:55
[post_modified_gmt] => 2024-04-12 19:20:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70661
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1702138450
ffd_listing_title, 36 Farallones Street, San Francisco, CA, 94112
ffd_mls_id, 423913509
ffd_salesforce_id, a0E8W00000dUL2SUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 36 Farallones Street, San Francisco, CA, 94112
pba__address_pb__c, 36 Farallones Street, San Francisco, CA, 94112
agent_only_remarks__c, Call/Text agent before showing. Stairs to the garage is through the kitchen. Please be very careful. Stairs are narrow & steep and not built to code. Call/Text agent with any questions at 415.830.7517. Escrow Pre-Opened with Connie Choy with WFG National Title. Disclosures Link: https://app.disclosures.io/link/36-Farallones-Street-8wabd8qk
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-09T10:47:25.000+0000
days_on_market__c, 61
dom__c, 44
ffd_description_pb, This Fully Detached 2 Bedroom, 1 Bath Home offers a blank canvas for your creative vision to turn it into your dream property. Step inside to find a formal living room adorned with elegant crown moldings and a charming fireplace. The spacious eat-in kitchen provides convenient access to the yard, and you can also reach the garage from within. Sitting on a generous lot spanning 28'x125', this property presents exciting possibilities for expansion, an accessory dwelling unit (ADU), or the addition of a deck to enjoy stunning views from the garden. Furthermore, its proximity to San Francisco State University, City College, Muni, the Bart Station, 280 freeway, Whole Foods, and various restaurants and shops make it a highly desirable location. Don't miss out on this opportunity - act fast!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-12-09T15:46:36.000+0000
pba__latitude_pb__c, 37.7142449
pba__latitude_property__c, 37.7142449
listed_date__c, 2022-11-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lily
pba__listing_agent_lastname__c, Tang
listing_agent_mls_id__c, 803755
ffd_listingagentname, Lily Tang
listing_agent_number__c, 803755
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4535355
lower_level__c, Garage
mls_id__c, 423913509
main_level__c, Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-10-09
original_price__c, 699000
overall_days_on_market__c, -81730
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-11-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 777.14
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUL2SUAW
sale_date__c, 2023-12-05
sale_price__c, 680000
selling_agent_mls_id__c, 803755
selling_agent_number__c, 803755
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 875
size__c, 875
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Farallones
subdist__c, Oceanview
ffd_name, 36 Farallones Street, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530685765-1.jpg