meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327510' 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, 260 King Street #473, San Francisco, CA, 94107
ffd_mls_id, 423715611
ffd_salesforce_id, a0E8W00000a8G7KUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 595
address2__c, 260 King Street #473, San Francisco, CA, 94107
pba__address_pb__c, 260 King Street #473, San Francisco, CA, 94107
agent_only_remarks__c, Presale escrow opened with Ashley Chuang of Fidelity National Title Company, Escrow # FSFM-0062202029 - AC. Seller paid all outstanding assessments. There is an additional Mission Bay HOA Fee ($39.15) on top of the Beacon HOA fee listed. For showings, please text/call Lota de Castro at 415-730-4088 or Steed Ahn at (650)278-6964. Use new SFAR contract.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2004
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Steed Ahn
pba__contingentdate__c, 2023-02-20
ffd_createddate, 2023-01-30T18:46:13.000+0000
days_on_market__c, 43
dom__c, 38
ffd_description_pb, Looking for a home with a large and private patio unit? Rare and often sought out, this 2BR/2BA unit with almost 500 sqft of private outdoor space is an ideal place to entertain, work, play, relax, and share urban living experiences with your family and furry friend. Your creativity will inspire you to reimagine this unit as your own from a blank canvas to an inviting and dramatic living space. The split floor plan allows for maximum privacy between the 2 bedrooms and creates a smooth flow to the living spaces and outdoor areas. The unit has hardwood floors, a mobile kitchen island, granite countertops, stainless steel kitchen appliances, walk-in closet in master bedroom, and in-unit laundry. The Beacon is a full amenity building of sophistication, elegance, and style. Nestled in the heart of a vibrant neighborhood, it is located right across from the ballpark, restaurants and coffee shops, a stroll away from the Ferry Building and Farmers' Markets, Embarcadero Waterfront, and a short bridge away to Chase Center and the other vibrant Mission Bay communities. Commuter residents will love the accessibility to Caltrain and the Central Subway T-line platform, MUNI, and to the freeways. An urban oasis. A Commuter's Dream. A Walker's Paradise.
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 882
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The Beacon Residential Community Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-03-14T10:48:54.000+0000
pba__latitude_pb__c, 37.7781648
pba__latitude_property__c, 37.7781648
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Stacked Only
listed_date__c, 2023-01-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lota
pba__listing_agent_lastname__c, de Castro
listing_agent_mls_id__c, 805634
ffd_listingagentname, Lota de Castro
listing_agent_number__c, 206524902
listing_co_agent_mls_id__c, 807673
listing_co_agent_number__c, 1023668
listing_co_office_mls_id__c, COLD02
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 874
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 930000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3930892
mls_id__c, 423715611
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Closet;Granite
master_property__c, a0O1I000001VhhZUAS
monthly_parking_fees__c, 218
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-30
original_price__c, 930000
overall_days_on_market__c, -81478
parking_access__c, Independent
parking_features__c, Covered,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Enclosed Deck
pba__pendingdate__c, 2023-03-09
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-13T19:40:54.000+0000
price_per_square_foot__c, 937.18
pba__propertytype__c, Condominium
ListingId, a0E8W00000a8G7KUAU
road_surface_type__c, Paved
room_type__c, Kitchen;Living Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-03-13
sale_price__c, 925000
security_features__c, Smoke Detector;Security Gate;Fire Alarm;Secured Access;Carbon Mon Detector
selling_agent_mls_id__c, 811044
selling_agent_number__c, 1049436
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, 987
size__c, 987
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, King
subdist__c, Mission Bay
ffd_name, 260 King Street #473, San Francisco, CA, 94107
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568975-1.jpg