meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215510' 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, 649 Mississippi Street, San Francisco, CA, 94107
ffd_mls_id, 508214
ffd_salesforce_id, a0E1I00000TRt1qUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 649 Mississippi Street, San Francisco, CA, 94107
pba__address_pb__c, 649 Mississippi Street, San Francisco, CA, 94107
agent_only_remarks__c, For showings, disclosure requests, and questions please contact Bradley Joe at [email protected] or 415-269-8190 (call / text). Visit www.649Mississippi.com for 3D tour, floor plans, and property video. One of sellers is a CA licensed real estate broker. Showings by appointment under state and local guidelines and with signed CAR PEAD-V form.
appliances__c, Dishwasher;Gas Range;Microwave;Refrigerator;Hood Over Range
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1928
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Calvin Luo
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2020-10-15T10:45:56.000+0000
days_on_market__c, 1007
dom__c, 8
ffd_description_pb, Welcome to 649 Mississippi - an extensively updated 4 bed, 3 bath home in Potrero Hill! An inviting entryway leads to the light-filled upper level featuring 3 skylights and large, west-facing windows. Enjoy meals at home with the family or hosting guests (when safe) in the open concept kitchen, living, and dining areas. This level also includes 3 beds, 2 baths, a private deck, and wide oak engineered hardwood running throughout. The lower level offers flexibility with an additional family room, bed and full bath. There is a separate, street-facing entrance, perfect for the in-laws or guests to have their privacy while still maintaining connectedness to the home. The flat yard has both replicated grass and Trex decking, making it easy for enjoying those warm Potrero days. The home is wired for gigabit internet, dual zone heat & A/C, Ring security, Schlage keypads, and up to 200 amps electrical. Multiple options for commuters including the 22nd St Caltrain, or 101 / 280 freeway access!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:37:36.000+0000
pba__latitude_pb__c, 37.758351
pba__latitude_property__c, 37.758351
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-10-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bradley
pba__listing_agent_lastname__c, Joe
listing_agent_mls_id__c, 811419
ffd_listingagentname, Bradley Joe
listing_agent_number__c, 1051536
listing_co_agent_mls_id__c, 814114
listing_co_agent_number__c, 1064364
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, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=iDTbpu149gP&brand=0
pba__longitude_pb__c, -122.393867
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Master Bedroom
mls_id__c, 508214
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-15
original_price__c, 1995000
overall_days_on_market__c, 167
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-10-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1033.65
pba__propertytype__c, Single Family Residence
id, a0E1I00000TRt1qUAD
sale_date__c, 2020-11-25
sale_price__c, 2150000
selling_agent_mls_id__c, 390430
selling_agent_name__c, Deborah L. Nguyen
selling_agent_number__c, 390430
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2080
size__c, 2080
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mississippi
subdist__c, Potrero Hill
ffd_name, 649 Mississippi Street, San Francisco, CA, 94107
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/372216-1.jpg
ListingId, a0E1I00000TRt1qUAD