meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215211' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 338 Potrero Avenue #409, San Francisco, CA, 94110
ffd_mls_id, 507220
ffd_salesforce_id, a0E1I00000TjKTwUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 70
address2__c, 338 Potrero Avenue #409, San Francisco, CA, 94110
pba__address_pb__c, 338 Potrero Avenue #409, San Francisco, CA, 94110
agent_only_remarks__c, Leased parking may be available in next door lot. Contact information can be provided. Currently $220/month subject to change. There are also Zip Car rentals in the same lot and easy street parking nearby. 1st re-sale, buyer purchased from developer. Floor plan provided by developer. Balcony off unit great for keeping plants. Private storage for this unit and shared bike storage in garage. Pet friendly building. Virtual tour: https://my.matterport.com/show/?m=mcKqRuFLNnp&hl=0
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Cooktop Stove
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2017
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-12-19
cooling__c, Room Air
ffd_createddate, 2020-11-17T01:46:59.000+0000
days_on_market__c, 1016
dom__c, 91
ffd_description_pb, Relax in your peaceful urban retreat! This sleek, modern 2 BR, 2 BA home offers deluxe, designer-selected finishes & a calm Western-facing view of Twin Peaks-perfect for sheltering in place & finding sanctuary at the end of a long day. Walk to eateries, shopping & public trans. Coveted, light-filled floor plan accented by rich, wide-plank oak floors, offers ultimate privacy w/the BRs & baths on opposite sides of the open living & dining rooms. Prepare a gourmet meal in your fab kitchen w/beautiful Quartz counters, Bertazzoni gas range, Bosch dishwasher, Liebherr refrigerator & Italian cabinetry. Sit back in the sunny living room accented by a wall of windows & sliding glass doors to the private balcony. The restful master BR also faces West & has a large, custom closet. Both luxurious baths feature high-end Duravit finishes. Storage, in-unit W/D & Nest controlled air conditioning! Amazing amenities -gorgeous view roof deck w/bbq's + zen garden. Awesome storage space including bikes.
district__c, SF District 9
entry_level__c, 4
external_listing__c, 1
pba__floor__c, 4
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 653.46
pba__hoafees__c, 653
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
ffd_lastmodifieddate, 2022-01-25T15:36:13.000+0000
pba__latitude_pb__c, 37.7646228765638
pba__latitude_property__c, 37.7646228765638
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Laura
pba__listing_agent_lastname__c, Kaufman
listing_agent_mls_id__c, 804090
ffd_listingagentname, Laura R Kaufman
listing_agent_number__c, 166013532
listing_co_agent_mls_id__c, 806857
listing_co_agent_number__c, 0
listing_co_office_mls_id__c, CGL01
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 700000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=mcKqRuFLNnp&mls=1
pba__longitude_pb__c, -122.40738577522
pba__lotsize_pb__c, 0
mls_id__c, 507220
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001ViFUUA0
monthly_parking_fees__c, 220
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-10-06
original_price__c, 1079000
overall_days_on_market__c, 175
parking_access__c, Side by Side
parking_features__c, Side-by-Side,Uncovered
parking_type__c, Lease Avail Off Site
pba__pendingdate__c, 2021-01-07
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, a0E1I00000TjKTwUAN
sale_date__c, 2021-01-19
sale_price__c, 800000
selling_agent_mls_id__c, MLSL5081740
selling_agent_number__c, 981343998
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams Realty - Cupertino
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Potrero
subdist__c, The Mission
ffd_name, 338 Potrero Avenue #409, San Francisco, CA, 94110
unit_number__c, 409
view__c, San Francisco;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2017
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371308-1.jpg
ListingId, a0E1I00000TjKTwUAN