meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330527' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15715
[post_author] => 4
[post_date] => 2018-11-02 19:54:29
[post_date_gmt] => 2018-11-02 19:54:29
[post_content] => Master-planned masterpiece or mid-rise suburban-esque stucco nightmare? Welcome to San Francisco's newest neighborhood, redeveloped from former railroad land and anchored by UCSF's Mission Bay campus. Sunny weather, new to newer construction, 47 acres of parks, and an arena for the Warriors.
[post_title] => Mission Bay
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-bay
[to_ping] =>
[pinged] =>
[post_modified] => 2023-03-09 10:09:41
[post_modified_gmt] => 2023-03-09 18:09:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15715
[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, 1000 3rd Street #402, San Francisco, CA, 94158
ffd_mls_id, 423733710
ffd_salesforce_id, a0E8W00000bbvcgUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 350
address2__c, 1000 3rd Street #402, San Francisco, CA, 94158
pba__address_pb__c, 1000 3rd Street #402, San Francisco, CA, 94158
agent_only_remarks__c, Photos of the interior of the home have been virtually staged. Bathroom photos are of a different unit with the same bathroom layout. Please write all offers on SFAR contract and include pre-approval letter & proof of funds. Buyers to pay Mission Bay Community Transfer Tax Fee of .25% of purchase price. In addition to OMB HOA, there is an additional approx. $39 monthly fee paid to MB Maintenance Corp. Escrow opened with Karen Tam at Old Republic Title Company [email protected]
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Built-In Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2018
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Terrence Chan
pba__contingentdate__c, 1800-01-01
cooling__c, Central,Heat Pump
ffd_createddate, 2023-04-27T18:49:42.000+0000
days_on_market__c, 27
dom__c, 26
ffd_description_pb, Welcome to One Mission Bay's Tower 402, where luxury living meets unparalleled convenience. This chic 2 bed, 2 bath + den unit boasts soaring 12-ft ceilings and a split floor plan that seamlessly combines fine contemporary finishes with stunning views of Oracle Park and the Bay Bridge. Beautiful hardwood flooring guides you through the home while custom closets provide ample storage space. The U-shaped kitchen is a chef's dream, featuring modern cabinetry and Caesarstone countertops that surround Gaggenau appliances. Whether you're entertaining guests or cooking for your loved ones, this kitchen is sure to impress. Central heat and air ensure year-round comfort, while in-unit laundry and one parking spot provide the ultimate city convenience. As a resident of OMB, you'll have amenities that cater to your every need. Enjoy the services of a 24-hour doorperson, take a dip in the outdoor heated pool, or unwind in the resident lounge areas. The community terrace also features fire pits, cabanas, barbecues, and outdoor dining, making it the perfect spot for entertainment. Stay in shape at the state-of-the-art fitness center, and conduct business with ease at the business center and library. Don't miss your chance to experience luxury living in one of the city's most coveted addresses.
district__c, SF District 9
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 1027
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Action Life
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-05-24T01:48:39.000+0000
pba__latitude_pb__c, 37.775661
pba__latitude_property__c, 37.775661
laundry_features__c, Laundry Closet
listed_date__c, 2023-04-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Crystal
pba__listing_agent_lastname__c, Injo
listing_agent_mls_id__c, 808900
ffd_listingagentname, Crystal C Injo
listing_agent_number__c, 1038416
listing_co_agent_mls_id__c, 810812
listing_co_agent_number__c, 1048237
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1679000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.390306
mls_id__c, 423733710
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
master_property__c, a0O8W00000DagteUAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-27
open_house_end__c, 2023-05-27T16:00:00.000+0000
open_house_start__c, 2023-05-27T14:00:00.000+0000
original_price__c, 1679000
overall_days_on_market__c, -81565
parking_access__c, Side by Side
parking_features__c, Interior Access
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1272.93
pba__propertytype__c, Condominium
ListingId, a0E8W00000bbvcgUAA
room_type__c, Bonus Room;Den
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, 1319
size__c, 1319
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 3rd
subdist__c, Mission Bay
ffd_name, 1000 3rd Street #402, San Francisco, CA, 94158
view__c, City;Bay;Water;Bay Bridge;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2018
pba__postalcode_pb__c, 94158
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530602640-1.jpg
