meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209574' 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, 456 Kansas Street #Upper, San Francisco, CA, 94107
ffd_mls_id, 492559
ffd_salesforce_id, a0E1I00000MGTJOUA5
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 456 Kansas Street #Upper, San Francisco, CA, 94107
pba__address_pb__c, 456 Kansas Street #Upper, San Francisco, CA, 94107
agent_only_remarks__c, For upfront disclosures, either click on the Disclosures.io link in the listing, or request directly from listing agent. For showings, please contact Chris Stein at 415.328.0792. If writing an offer, please use SFAR Purchase Agreement (if you do not have one, I am happy to provide one for you) and provide proof of funds for cash offers and/or pre-approval letter along with signed disclosure cover sheet. Open escrow with Gerrie Brindley at Chicago Title Company 415.252.2757 [email protected]. Property is in the middle of condo conversion and will close as a condominium, a slightly longer close may be needed, conversion being handled by Andy Sirkin. HOA dues not yet set for building.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Ice Maker
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Remodeled;Radiant Heat
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1958
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2019-11-29
ffd_createddate, 2019-11-16T02:47:09.000+0000
days_on_market__c, 1342
dom__c, 54
ffd_description_pb, Spectacular down to the studs renovated condominium located in the heart of Potrero! Top floor of a renovated 2-unit building this amazing 3BR, 2BA home boasts an open floorplan with huge windows offering amazing light, a chef's kitchen with Caesarstone counters and marble backsplash, & top of the line SS Viking appliances. Both bathrooms have Spanish tile flooring, the master has Spanish tile wrapping around the walls as well as heated floors. You will also find 9.5 inch Monarch Plank wood flooring throughout the unit, interior doors imported from Italy, all new windows, new plumbing and heating as well as the home being a voice activated SMART home offering voice commands to control sound, temperature, door locks & Alarm. Also wired for Gigabit internet, ceiling mount speakers in every room, & 1 car garage parking. Just up a few stairs to the shared view roof deck with jaw dropping views of downtown San Francisco! Close to Uber, Airbnb, Chase Center & Caltrain
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:25:37.000+0000
pba__latitude_pb__c, 37.7640762
pba__latitude_property__c, 37.7640762
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2019-10-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dan
pba__listing_agent_lastname__c, Dodd
listing_agent_mls_id__c, 804303
ffd_listingagentname, Dan Dodd
listing_agent_number__c, 166013815
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, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/YcZKMapVGKY
pba__longitude_pb__c, -122.4036932
pba__lotsize_pb__c, 0
mls_id__c, 492559
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
master_property__c, a0O1I000004VY5FUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-11-15
original_price__c, 1895000
overall_days_on_market__c, 94
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-01-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000MGTJOUA5
sale_date__c, 2020-02-03
sale_price__c, 1950000
selling_agent_mls_id__c, 803845
selling_agent_name__c, Kevin Wong
selling_agent_number__c, 166013108
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Kansas
subdist__c, Potrero Hill
ffd_name, 456 Kansas Street #Upper, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, Upper
view__c, City Lights;Water;Downtown;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1958
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/358332-1.jpg
ListingId, a0E1I00000MGTJOUA5