meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218040' 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] => 2024-04-17 08:01:07
[post_modified_gmt] => 2024-04-17 15:01:07
[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 #10H, San Francisco, CA, 94105
ffd_mls_id, 421533232
ffd_salesforce_id, a0E1I00000TxXcrUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 419
address2__c, 301 Mission Street #10H, San Francisco, CA, 94105
pba__address_pb__c, 301 Mission Street #10H, San Francisco, CA, 94105
agent_only_remarks__c, Keys at the concierge. Please email PEAD to [email protected] for access.Sellers reserve the right to reject, counter or accept any offers. Escrow pre-open with Steve Salviejo of North American Title. Disclosure links : https://app.disclosures.io/link/301-Mission-Street-10H-j9ri02j8 . Offers to be submitted by email with signed disclosure package cover sheet and proof of funds. Please contact Patrick Gardner (510-599-8499) [email protected] for financing. Due to vacancy, seller and seller's agent cannot guarantee disinfection. Showings by appointment only and In compliance with COVID-19 showing procedures PEAD-V must be signed before entry and emailed to the listing agent. *Must Follow, CAR Covid-19 Best Practices, State, Counties, Cities & Bay East Guidelines. Each visitor including the agent must sign the CAR PEAD form prior to the showing. All parties must wear gloves, masks and Buyer/Agent practice Social distancing while in property.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2009
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-04-01T03:00:50.000+0000
days_on_market__c, 842
dom__c, 223
ffd_description_pb, Luxury 1 BR/ 1BA condo at Millennium Tower with storage, one of the most luxurious condominium building in San Francisco. Unit 10H features floor to ceiling windows on the living room, Bosch stainless steel appliances in the kitchen, and W/D on site.The unit comes with 1-storage unit. It also offers world class building amenities such as: 20,000 sq ft Club Level with lounge, private dining room, children's playroom, and outdoor terrace. The 5,000 sq ft fitness center features: indoor swimming pool, yoga studios, Jacuzzi & steam rooms, massage room, and locker rooms. Short distance to Ferry Building, Union Square, Westfield SF Centre, Metreon, Moscone Center, Yerba Buena Square Shopping Center, Yerba Buena Gardens, Target, Starbucks, and many other restaurants and entertainments! Easy access to Muni, Bart, Caltrain, and Bay Bridge/ Freeways. Please find the link www.millenniumtower-sf.com for the photos and the information of the common area at Millennium Tower.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Gas,Maintenance Exterior,Maintenance Grounds,Recreation Facility,Security,Sewer,Trash,Water
pba__hoafees__c, 1502
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Millennium Tower Residence
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:48:40.000+0000
pba__latitude_pb__c, 37.790402
pba__latitude_property__c, 37.790402
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-03-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ronny
pba__listing_agent_lastname__c, Budiutama
listing_agent_mls_id__c, 806331
ffd_listingagentname, Ronny Budiutama
listing_agent_number__c, 166016758
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, AJ&C
listing_office_name__c, Andersen, Jung & Co.
listing_office_number__c, 576
pba__listingprice_pb__c, 675000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396139
mls_id__c, 421533232
master_bathroom_features__c, Shower Stall(s);Tub;Tile
master_property__c, a0O1I000001VhhvUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-03-29
original_price__c, 750000
overall_days_on_market__c, 360
parking_features__c, Valet,Other
pba__pendingdate__c, 2021-11-09
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 975.98
pba__propertytype__c, Condominium
id, a0E1I00000TxXcrUAF
room_type__c, Storage;Laundry;Kitchen;Living Room;Master Bathroom;Master Bedroom
sale_date__c, 2021-12-10
sale_price__c, 650000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 809013
selling_agent_number__c, 1039719
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, 666
size__c, 666
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 #10H, San Francisco, CA, 94105
view__c, City;Garden/Greenbelt
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/530209858-1.jpg
ListingId, a0E1I00000TxXcrUAF