meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='323594' 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
(
)
)
ffd_listing_title, 174 Farallones Street, San Francisco, CA, 94112
ffd_mls_id, 422695475
ffd_salesforce_id, a0E8W00000YZdkgUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 174 Farallones Street, San Francisco, CA, 94112
pba__address_pb__c, 174 Farallones Street, San Francisco, CA, 94112
agent_only_remarks__c, No open house. Please don't disturb the occupants while you visiting the property. Vacant space can be shown with lock box. To show tenant occupied space, 1 bed/1 bath needs 24-hour notice. Pre-escrow open with ORTC, Karen Tam #1127029555. Bedroom/bathroom counts different than the public record. Any showings/questions please contact Kent at 415-933-7432 or [email protected].
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1907
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Crystal C Injo
pba__contingentdate__c, 2022-12-23
cooling__c, None
ffd_createddate, 2022-09-16T19:47:55.000+0000
days_on_market__c, 306
dom__c, 106
ffd_description_pb, Opportunity knocks with this fully detached, 5 bed / 4 bath home on an extra deep lot with potential to expand. Flexible floor plan provides the ability to generate supplemental rental income or to combine the property into one large home. One-car garage with driveway space to fit two or three more cars. Centrally located one block from Ocean View Park + a short distance from San Francisco State University, Stonestown, H-Mart, and Whole Foods. Loads of restaurants nearby on Ocean Ave & Mission St. Easy commutes with quick access to 19th Ave, I-280, BART, and Muni.
district__c, SF District 3
entry_level__c, 0
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, Central
ffd_lastmodifieddate, 2023-07-13T17:45:56.000+0000
pba__latitude_pb__c, 37.7142133
pba__latitude_property__c, 37.7142133
laundry_features__c, Hookups Only
listed_date__c, 2022-09-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kent
pba__listing_agent_lastname__c, Chen
listing_agent_mls_id__c, 808521
ffd_listingagentname, Kent Chen
listing_agent_number__c, 1036299
listing_co_agent_mls_id__c, 808900
listing_co_agent_number__c, 1038416
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4582929
lower_level__c, Bedroom(s),Living Room
mls_id__c, 422695475
main_level__c, Kitchen
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-16
original_price__c, 998000
overall_days_on_market__c, -81342
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-01-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 569.2
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YZdkgUAD
roof__c, Composition
room_type__c, Living Room
sale_date__c, 2023-01-20
sale_price__c, 950000
selling_agent_mls_id__c, 811506
selling_agent_number__c, 1051822
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 1669
size__c, 1669
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Farallones
subdist__c, Oceanview
ffd_name, 174 Farallones Street, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Dual Pane Partial
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530529594-1.jpg