meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237269' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15736
[post_author] => 4
[post_date] => 2018-11-02 20:00:55
[post_date_gmt] => 2018-11-02 20:00:55
[post_content] => Cultural haven. Home to that high-rise. If any SF neighborhood comes remotely close to vaguely feeling like Manhattan, the hustle and bustle of Yerba Buena probably comes closest. Yes, you are south of Market. But this is Yerba Buena.
[post_title] => Yerba Buena
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => yerba-buena
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 20:00:55
[post_modified_gmt] => 2018-11-02 20:00:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15736
[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 301 Mission Street #42D, San Francisco, CA, 94105
ffd_mls_id 503307
ffd_salesforce_id a0E1I00000TG4yRUAT
num_of_fireplaces__c 0
num_of_rooms__c 6
of_units__c 419
address2__c 301 Mission Street #42D, San Francisco, CA, 94105
pba__address_pb__c 301 Mission Street #42D, San Francisco, CA, 94105
agent_only_remarks__c Seller financing available. Please contact Ron at 415-279-4579 with questions or to request a showing.
appliances__c Dishwasher;Microwave;Disposal;Hood Over Range;Ice Maker
architectural_style__c Contemporary
bath_features__c Tub w/Shower Over;Shower Stall(s);Tub
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 3
year_build_text__c 2009
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
cooling__c Central
ffd_createddate 2020-08-27T19:46:14.000+0000
days_on_market__c 853
dom__c 790
ffd_description_pb $500,000 PRICE IMPROVEMENT! This rarely available high level corner unit boasts three large bedrooms and three luxe bathrooms (including a grand primary suite with built-in and walk-in closets) and an expansive open living and dining room that is perfect for entertaining and enjoying the breathtaking Bay Bridge and southern views! This one-of-a-kind property features a state-of-the art-kitchen and many exceptional customizations including built-in wine storage, remote controlled window treatments, designer lighting, custom closet systems in every bedroom, beautiful wood floors, in-unit laundry and so much more. Enjoy the 5 star amenity package including valet parking, fitness center, wine storage, screening room, owners' lounge, lap pool & much more!
district__c SF District 9
driveway_sidewalks__c Paved Driveway,Paved Sidewalk
entry_level__c 0
external_listing__c 1
pba__floor__c 0
pba__floortype_pb__c Wood
hoa_dues__c 2730
hoa_fee_includes__c Door Person,Elevator,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Management,Security,Trash,Water
pba__hoafees__c 2730
pba__hoafrequency_pb__c Monthly
hoa__c Yes
pba__halfbathrooms_pb__c 0
has_monthly_parking_fees__c 1
pba__heatingtype_pb__c Central
ffd_lastmodifieddate 2022-12-06T11:47:23.000+0000
pba__latitude_pb__c 37.790771
pba__latitude_property__c 37.790771
laundry_appliances__c Washer/Dryer,In Closet
laundry_features__c Laundry Closet
listed_date__c 2020-08-07
pba__listing_agent_email__c rsebahar@compass.com
pba__listing_agent_firstname__c Ronald
pba__listing_agent_lastname__c Sebahar
listing_agent_mls_id__c 803012
ffd_listingagentname Ronald Sebahar
listing_agent_number__c 803012
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 2500000
pba__listingtype__c Sale
pba__longitude_pb__c -122.395754
pba__lotsize_pb__c 0
mls_id__c 503307
main_level__c Full Bath(s);Bedroom(s);Primary Bedroom
master_property__c a0O1I000001VhhvUAC
monthly_parking_fees__c 265
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2020-08-27
original_price__c 3100000
overall_days_on_market__c -80592
parking_access__c Independent
parking_features__c Valet
parking_type__c On Site - Unassigned (Condo Only)
pba__pendingdate__c 1800-01-01
possible_bedrooms__c 0
pba__pricechangedat__c 2022-12-05T13:07:56.000+0000
price_per_square_foot__c 1280.74
pba__propertytype__c Condominium
record_id a0E1I00000TG4yRUAT
room_type__c Storage;Office;Wine Cellar
sale_date__c 1800-01-01
sale_price__c 0
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
pba__status__c Active
pba__totalarea_pb__c 1952
size__c 1952
spa__c 1
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Mission
subdist__c Yerba Buena
ffd_name 301 Mission Street #42D, San Francisco, CA, 94105
transportation__c 1 Block
unit_number__c 42D
view__c Water;Bay Bridge;San Francisco
website_property_type__c Condominium
pba__yearbuilt_pb__c 2009
pba__postalcode_pb__c 94105
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368109-1.jpg
ListingId a0E1I00000TG4yRUAT