meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238298' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 703 Oak 705 Street, San Francisco, CA, 94117
ffd_mls_id, 422668111
ffd_salesforce_id, a0E8W00000Xil7kUAB
num_of_rooms__c, 12
of_units__c, 4
address2__c, 703 Oak 705 Street, San Francisco, CA, 94117
pba__address_pb__c, 703 Oak 705 Street, San Francisco, CA, 94117
agent_only_remarks__c, Offers should be submitted on the San Francisco Purchase Agreement (Rev. 12/21). A blank copy of the Purchase Agreement is available from the listing agents. If making an all-cash offer, please include verification-of-funds documentation.
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Tim Johnson
pba__contingentdate__c, 2022-08-20
cooling__c, Varies by Unit,None
ffd_createddate, 2022-06-18T02:48:05.000+0000
days_on_market__c, 397
dom__c, 90
ffd_description_pb, This expansive corner building in popular Hayes Valley offers a world of possibilities to both savvy investors and owner users. On the market for the first time in forty years, this four-unit mixed-use property boasts three residential units and one commercial unit. There are two spacious, full-floor flats with high ceilings,fireplaces, and many original details plus a recently remodeled studio. The substantial storefront space may offer the potential to be converted to a residential unit. Each unit's rent offers significant upside. Separate meters for gas and electricity keep operating expenses low. Priced at less than $250 per square foot, this property is an unbeatable value for an investor with a long-term perspective or an owner occupant seeking to live in one of the flats or occupy the commercial space. On the corner of Oak and Fillmore in desirable Hayes Valley, the property is convenient to Alamo Square and the shops and restaurants on Divisadero Street and Hayes Street.
district__c, SF District 6
electric__c, 220 Volts
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Varies by Unit
ffd_lastmodifieddate, 2022-09-24T10:50:31.000+0000
pba__latitude_pb__c, 37.773807
pba__latitude_property__c, 37.773807
laundry_features__c, Washer/Dryer Hookups;Varies by Unit
listed_date__c, 2022-06-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kristina
pba__listing_agent_lastname__c, Hansen
listing_agent_mls_id__c, 803516
ffd_listingagentname, Kristina L Hansen
listing_agent_number__c, 803516
listing_co_agent_mls_id__c, 805021
listing_co_agent_number__c, 166014787
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1149000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.431028
mls_id__c, 422668111
parkingspaces__c, 0
on_market_date__c, 2022-06-17
original_price__c, 1349000
overall_days_on_market__c, -81251
pba__pendingdate__c, 2022-09-15
price_per_square_foot__c, 245.82
pba__propertytype__c, Quadruplex
ListingId, a0E8W00000Xil7kUAB
roof__c, Bitumen;Composition
sale_date__c, 2022-09-22
sale_price__c, 1175000
security_features__c, Smoke Detector;Security Gate;Varies By Unit;Carbon Mon Detector;Window Security Bars
selling_agent_mls_id__c, MLSL150358
selling_agent_number__c, 981180543
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 4780
size__c, 4780
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Oak
subdist__c, Hayes Valley
ffd_name, 703 Oak 705 Street, San Francisco, CA, 94117
website_property_type__c, Quadruplex
window_features__c, Bay Window(s);Varies by Unit
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530478170-1.jpg