meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214804' 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, 451 Kansas Street #447, San Francisco, CA, 94107
ffd_mls_id, 506090
ffd_salesforce_id, a0E1I00000THjtgUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 165
address2__c, 451 Kansas Street #447, San Francisco, CA, 94107
pba__address_pb__c, 451 Kansas Street #447, San Francisco, CA, 94107
agent_only_remarks__c, One of the sellers is a licensed agent. Website is www.greatpotrerocondo.com
appliances__c, Dishwasher;Electric Range;Microwave;Disposal;Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2007
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David G Cohen
pba__contingentdate__c, 2021-01-07
ffd_createddate, 2020-09-16T20:45:57.000+0000
days_on_market__c, 1036
dom__c, 126
ffd_description_pb, In a convenient Potrero Hill location steps to Whole Foods, restaurants and a short walk to the Giants Park and Warriors Stadium, this modern condo is the perfect balance of convenience and style. The unit has a large private patio overlooking the courtyard accessed directly from the open floor plan living room. The great kitchen, which connects to the living room, has Studio Becker cabinets and stainless appliances. The spacious bedroom, which will fit a King Bed, has generous closets and direct access to the updated bathroom. The condo is accessible with zero stairs. Hardwood floors, a washer/dryer in the unit, deeded parking with interior access, a fitness center, a roof deck with great views, and onsite management are only some of the many features that make this a terrific home.
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, 535
hoa_fee_includes__c, Management,Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 535
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Electric
ffd_lastmodifieddate, 2022-01-25T15:34:35.000+0000
pba__latitude_pb__c, 37.76382383
pba__latitude_property__c, 37.76382383
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joan
pba__listing_agent_lastname__c, Gordon
listing_agent_mls_id__c, 197853
ffd_listingagentname, Joan F Gordon
listing_agent_number__c, 197853
listing_co_agent_mls_id__c, 804695
listing_co_agent_number__c, 166014347
listing_co_office_mls_id__c, CITYRE
listing_co_office_name__c, City Real Estate
listing_co_office_number__c, 27425
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.greatprotrerocondo.com
pba__longitude_pb__c, -122.40319333
pba__lotsize_pb__c, 0
mls_id__c, 506090
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001Vhj9UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-16
original_price__c, 850000
overall_days_on_market__c, 166
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-01-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1191.55
pba__propertytype__c, Condominium
id, a0E1I00000THjtgUAD
sale_date__c, 2021-01-28
sale_price__c, 790000
selling_agent_mls_id__c, MLSL300804
selling_agent_number__c, 981198853
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 663
size__c, 663
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Kansas
subdist__c, Potrero Hill
ffd_name, 451 Kansas Street #447, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 447
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2007
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370377-1.jpg
ListingId, a0E1I00000THjtgUAD