meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211202' 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, 885 Rhode Island 887 Street, San Francisco, CA, 94107
ffd_mls_id, 421528033
ffd_salesforce_id, a0E1I00000Twg3ZUAR
num_of_rooms__c, 0
of_units__c, 2
address2__c, 885 Rhode Island 887 Street, San Francisco, CA, 94107
pba__address_pb__c, 885 Rhode Island 887 Street, San Francisco, CA, 94107
agent_only_remarks__c, Back on the market at NO fault of the property. This is a great property. Views and location. TIC buyers can take advantage of the Seller's draft TIC agreement from Andy Sirkin. Unit 887 Rhode Island IS tenant occupied and the photos are completed with virtual staging. It is a beautiful and well maintained unit but for privacy purposes I have went the virtual staging route. Operating expenses includes management fee of $300/month for the rented unit 887 Rhode Island. COVID compliant showings for Unit 885 Rhode Island only. Send PEAD to [email protected].
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1988
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-11
ffd_createddate, 2021-03-15T23:12:00.000+0000
days_on_market__c, 859
dom__c, 72
ffd_description_pb, What an amazing investment opportunity in this handsome 2-unit building in Sunny Potrero Hill. The lower unit (#885) consists of two levels: the entry leads to a spacious, open kitchen/dining and living room concept with direct access to a deck. There are two large bedrooms, one with a private deck, and a full bath. The lower level has an incredible master suite with a large sitting area, office, walk-in closet, full bath, and direct access to the rear yard. The upper flat (#887 is tenant occupied) is also two levels. The entry leads to a remodeled kitchen with dining area that opens to a large deck. The living room has vaulted ceilings. There are abundant closets and a half-bath on this level.The upper level has a loft, half-bath, and bedroom with full bath. There are outstanding views of downtown. A lovely private yard, a one-car garage and two side-by-side driveway spaces completes this lovely building. Excellent location close to 18th St. shops, restaurants and freeways
district__c, SF District 9
exterior_features__c, Yard Space
external_listing__c, 1
pba__floortype_pb__c, Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
interior_features__c, Formal Entry;Vaulted Ceiling(s)
ffd_lastmodifieddate, 2022-01-25T13:33:12.000+0000
pba__latitude_pb__c, 37.7585493
pba__latitude_property__c, 37.7585493
laundry_features__c, Varies by Unit
listed_date__c, 2021-01-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
ffd_listingagentname, William J Kitchen Jr.
listing_agent_number__c, 803707
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, 3090000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4019028
mls_id__c, 421528033
master_property__c, a0O8W00000DaF9WUAV
parkingspaces__c, 3
on_market_date__c, 2021-03-12
original_price__c, 3090000
overall_days_on_market__c, 172
parking_features__c, Garage,Garage Door Opener,Guest Parking Available,Side-by-Side
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2021-05-25
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 780.42
pba__propertytype__c, Duplex
id, a0E1I00000Twg3ZUAR
sale_date__c, 2021-06-10
sale_price__c, 2950000
selling_agent_mls_id__c, 802803
selling_agent_number__c, 802803
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3780
size__c, 3780
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Rhode Island
subdist__c, Potrero Hill
ffd_name, 885 Rhode Island 887 Street, San Francisco, CA, 94107
view__c, City;Panoramic;Bay;Downtown;Bay Bridge;San Francisco;Mt Diablo;Bridges
website_property_type__c, Duplex
window_features__c, Varies by Unit
pba__yearbuilt_pb__c, 1988
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530199196-1.jpg
ListingId, a0E1I00000Twg3ZUAR