meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237309' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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, 690 Wisconsin 692 Street, San Francisco, CA, 94107
ffd_mls_id, 422646803
ffd_salesforce_id, a0E8W00000WgnghUAB
num_of_rooms__c, 9
of_units__c, 3
address2__c, 690 Wisconsin 692 Street, San Francisco, CA, 94107
pba__address_pb__c, 690 Wisconsin 692 Street, San Francisco, CA, 94107
agent_only_remarks__c, MASSIVE price reduction. Very motivated seller. Offers as they come. Disclosure package available: https://app.disclosures.io/link/690692-Wisconsin-St-2f6a1gqk. Access to property by permission only. Mask must be worn as soon as you enter the front gate. Additional tenant disclosures available by request only to buyers committed to making an offer. Seller projected NOI is between $100-115,000, which makes this roughly a 5% CAP when rented completely. Main house has two units, one is vacant and photographed. Other is tenant occupied. Legal non confirming cottage, also photographed, is vacant. To show please contact Bryce Adams at [email protected] or [email protected].
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-06-28
ffd_createddate, 2022-04-08T19:48:48.000+0000
days_on_market__c, 467
dom__c, 109
ffd_description_pb, Fabulous opportunity to own a truly one of a kind historic property in San Francisco's Potrero Hill District. Situated on a 66′ wide and 100′ deep lot (total 6600) and hidden off street, this view property has what used to be a single family residence (now 2 units) right in the middle, and a legal non-conforming view cottage tucked in the back. The main property is 2 units. Upper unit 692 features one bedroom, HW floors, fireplace, sunroom with amazing views, view deck, kitchen, and laundry. Lower unit 690 is two bedrooms, one with view sunroom, living room, fireplace, wood floors, kitchen and porch. The Cottage is a Bohemian Chic studio with views, deck, skylights, fireplace, wood floors, and tons of charm. The surrounding gardens are lush and landscaped, and the outdoor patio/seating area is a great escape from city living. Rumored to have been visited by Maya Angelou and many notable 20th century artists and poets, it undoubtedly has a fascinating history.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-08-02T10:49:07.000+0000
pba__latitude_pb__c, 37.758624
pba__latitude_property__c, 37.758624
laundry_features__c, Laundry Closet;Varies by Unit
listed_date__c, 2022-04-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Clark
listing_agent_mls_id__c, 802982
ffd_listingagentname, Alexander T Clark
listing_agent_number__c, 802982
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TFST
listing_office_name__c, The Front Steps
listing_office_number__c, 27633
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://thefrontsteps.com/690Wisconsin
pba__longitude_pb__c, -122.399379
mls_id__c, 422646803
parkingspaces__c, 1
on_market_date__c, 2022-04-08
original_price__c, 2595000
overall_days_on_market__c, -81181
parking_features__c, Off Street,Open
pba__pendingdate__c, 2022-07-26
price_per_square_foot__c, 891.34
pba__propertytype__c, Duplex
record_id, a0E8W00000WgnghUAB
sale_date__c, 2022-07-29
sale_price__c, 2100000
selling_agent_mls_id__c, MLSL157523
selling_agent_number__c, 981187821
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KMS Investments
pba__status__c, Closed
pba__totalarea_pb__c, 2356
size__c, 2356
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Wisconsin
subdist__c, Potrero Hill
ffd_name, 690 Wisconsin 692 Street, San Francisco, CA, 94107
view__c, Downtown;San Francisco
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530434688-1.jpg
ListingId, a0E8W00000WgnghUAB