meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='228287' 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 #475, San Francisco, CA, 94107
ffd_mls_id, 480744
ffd_salesforce_id, a0E1I0000083tQfUAI
address2__c, 451 Kansas Street #475, San Francisco, CA, 94107
pba__address_pb__c, 451 Kansas Street #475, San Francisco, CA, 94107
agent_only_remarks__c, Offers due Wednesday 04/10 by 2pm. Disclosures available and linked to MLS via disclosures.io This unit has no other unit above it! Brand new California Carpet in Bedroom. The HOA has a reserve account with a balance of $1,158,178. 2 pets allowed (weight not over 70 pounds each dog). Leasing permitted, has to be 30+ days. Escrow opened with First American Title Company, Kelley Lillis, escrow # 2102-5854358, (415) 968-3097, [email protected]
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2007
building_name__c, The Potrero
pba__city_pb__c, San Francisco
ffd_createddate, 2019-04-05T02:46:27.000+0000
days_on_market__c, 1567
dom__c, 6
ffd_description_pb, On the prestigious North Slope in Potrero Hill, this beautiful condominium offers amazing light & a quiet setting. It includes brand new wide plank oak hardwood floors, high ceilings, crown moldings, exceptional new light fixtures & double paned windows. One master en-suite, one full bathroom, entry hall, living room, dining room, spacious kitchen with Studio Becker cabinetry, washer/dryer in unit, newly painted interior, 1 car secure garage parking with interior access, fitness center, tranquil courtyards, bicycle racks, laundry lockers, common rooftop deck offering panoramic views of San Francisco, in-house community manager, security cameras. Garbage chute on floor, newly painted building exterior. Walk to the San Francisco Design Center and Whole Foods Market at street level in the building. Close to Potrero Hill's fabulous restaurants, highways 101 & 280, Caltrain, tech buses & easy access to Downtown Financial District & soon to open end of year- Chase Center. Walk Score of 92!
district__c, SF District 9
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 496.76
hoa_fee_includes__c, Water,Garbage,Ext Bldg Maintenance,Grounds Maintenance,Homeowners Insurance,Outside Management
hoa_name__c, The Potrero Owners Association
hoa__c, Yes
ffd_lastmodifieddate, 2022-03-01T19:56:58.000+0000
pba__latitude_pb__c, 0.000000
pba__latitude_property__c, 0.000000
laundry_appliances__c, Washer/Dryer,In Closet
listed_date__c, 2019-04-04
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Ayerdi
listing_agent_mls_id__c, 809742
listing_agent_number__c, 1043069
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MCGU
listing_office_name__c, McGuire Real Estate
listing_office_number__c, 1497
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.451Kansas475.com
pba__longitude_pb__c, 0.000000
pba__lotsize_pb__c, 0
mls_id__c, 480744
master_property__c, a0O1I000001Vhj9UAC
monthly_parking_fees__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-04-04
original_price__c, 799000
overall_days_on_market__c, 1567
parking_access__c, Side-by-Side
parking_features__c, Enclosed,Attached,Interior Access,Automatic Door,Garage
parking_type__c, Mapped On Site
price_per_square_foot__c, 1351.54
pba__propertytype__c, Condominium
id, a0E1I0000083tQfUAI
sale_date__c, 2019-04-26
sale_price__c, 965000
selling_agent_mls_id__c, 807654
selling_agent_name__c, Jamie Lawrence
selling_agent_number__c, 1023340
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Zephyr Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 714
size__c, 714
pba__state_pb__c, CA
pba__street_pb__c, Kansas
subdist__c, Potrero Hill
ffd_name, 451 Kansas Street #475, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 475
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/348657-1.jpg
ListingId, a0E1I0000083tQfUAI