meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237603' 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, 659 Connecticut 661 Street, San Francisco, CA, 94107
ffd_mls_id, 422661299
ffd_salesforce_id, a0E8W00000WjX2mUAF
num_of_rooms__c, 10
of_units__c, 2
address2__c, 659 Connecticut 661 Street, San Francisco, CA, 94107
pba__address_pb__c, 659 Connecticut 661 Street, San Francisco, CA, 94107
agent_only_remarks__c, Top unit vacant and easy to show. Lower unit tenant not protected and very cooperative. Just need 24 hour notice to show. Low pest inspection. Great location.
appliances__c, Dishwasher;Disposal;Built-In Refrigerator
architectural_style__c, Contemporary;Mid-Century
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1964
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-05-21T00:53:36.000+0000
days_on_market__c, 425
dom__c, 75
ffd_description_pb, REDUCED. Amazing 2 unit view property located on a premier Potrero Hill street. Great opportunity to live in the top vacant unit and collect rental income from lower unit. The vacant owner's top floor unit boasts incredible views and desirable floor plan. The entry of this unit leads to a spacious living and dining area with beautiful beamed ceiling, wall of glass, galley kitchen, dining area and large deck off the living area to absorb the amazing views. Down the hall are two bedrooms, one with custom built-ins, and a full bath, which completes this unit. Freshly painted and refinished hardwood floors. Direct access to the two car garage from this unit. The two-level lower unit boasts 2 bedrooms and 1 bath with deck and beautiful views. The building has 2 car garage parking, abundance of storage and a rear yard. Minutes from transportation, Potrero Hill shops and restaurants, Dogpatch, and so much more.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Vaulted Ceiling(s)
ffd_lastmodifieddate, 2022-08-20T00:48:35.000+0000
pba__latitude_pb__c, 37.757983
pba__latitude_property__c, 37.757983
laundry_features__c, In Common Area;Washer/Dryer Owned
listed_date__c, 2022-02-19
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, 2248000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396746
mls_id__c, 422661299
parkingspaces__c, 2
on_market_date__c, 2022-05-20
original_price__c, 2499000
overall_days_on_market__c, -81223
parking_features__c, Attached,Garage,Garage Door Opener,Interior Access,Side-by-Side
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2022-08-03
price_per_square_foot__c, 1033.65
pba__propertytype__c, Duplex
ListingId, a0E8W00000WjX2mUAF
sale_date__c, 2022-08-19
sale_price__c, 2150000
security_features__c, Security Gate
selling_agent_mls_id__c, 811507
selling_agent_number__c, 1051824
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, eXp Realty of California, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 2080
size__c, 2080
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Connecticut
subdist__c, Potrero Hill
ffd_name, 659 Connecticut 661 Street, San Francisco, CA, 94107
view__c, Bay;Water;Downtown;Bay Bridge;San Francisco;Hills;Mt Diablo
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1964
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530463192-1.jpg