meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='321514' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15713
[post_author] => 4
[post_date] => 2018-11-02 19:54:26
[post_date_gmt] => 2018-11-02 19:54:26
[post_content] => San Francisco's South Beach of today is a far cry from the South Beach of 25 years ago. Once South Beach was storage yards, warehouses, and crumbling piers. Today, gleaming glass towers and soulful conversion lofts have transformed it into one of the most desired destinations in San Francisco.
[post_title] => South Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => south-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:26
[post_modified_gmt] => 2018-11-02 19:54:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15713
[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, 403 Main Street #620N, San Francisco, CA, 94105
ffd_mls_id, 422697374
ffd_salesforce_id, a0E8W00000ZKKcEUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 220
address2__c, 403 Main Street #620N, San Francisco, CA, 94105
pba__address_pb__c, 403 Main Street #620N, San Francisco, CA, 94105
agent_only_remarks__c, Easy to show, it is vacant! Combo Lock box is located at the door of unit# 620N, please call or text agent 650-642-5548 for showing appointment and instruction of the access code. You can view or download the seller package at: https://app.disclosures.io/link/403-Main-Street-620N-d3pymjma .Please email offer to: [email protected]
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Art Deco
bath_features__c, Tile;Bidet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1997
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-24T00:47:15.000+0000
days_on_market__c, 140
dom__c, 138
ffd_description_pb, Desirable location! Stunning Bay views! Charming Bay bridge! Beautifully updated in its great move in condition! All are in one! A short walking distance to the ferry building, farmer's market,financial district,downtown,Oracle park, Warriors Stadium and world's renowned restaurants. Top employers including Google, Apple, Amazon, Visa, UCSF and children hospitals are all nearby. This upgraded 2bd 2ba with balcony and signature curved glass is perfectly situated across from the water's edge, foyer leads to expansive views including a 4 tower Bay Bridge view, iconic buildings. Big windows, updated modern kitchen & bathrooms,new oak flooring throughout, soak in iconic views from balcony. Bridge and water view primary suite w/large custom walk in closet has an updated bathroom,second bedroom has an adjacent bathroom with washer/dryer.Garage parking and storage space complete the home. This art deco style building offers fitness room,outdoor heated pool with spa & sun deck. A sweet home!
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Roof,Sewer,Trash
pba__hoafees__c, 847
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Portside owners association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2023-02-09T13:49:35.000+0000
pba__latitude_pb__c, 37.788076
pba__latitude_property__c, 37.788076
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-09-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ken
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 981462
ffd_listingagentname, Ken K Kwok
listing_agent_number__c, 981462
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MXRE1
listing_office_name__c, MaxReal
listing_office_number__c, 25562
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.389586
mls_id__c, 422697374
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Bidet
master_property__c, a0O1I000001VhkgUAC
monthly_parking_fees__c, 165
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-23
original_price__c, 1095000
overall_days_on_market__c, -81349
parking_access__c, Side by Side
parking_features__c, Attached,Converted Garage
parking_type__c, On Site - Lease Available (Condo Only)
patio_and_porch_features__c, Covered Patio
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1103.42
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZKKcEUAX
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
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, 1083
size__c, 1083
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Main
subdist__c, South Beach
ffd_name, 403 Main Street #620N, San Francisco, CA, 94105
view__c, City;City Lights;Bay;Bay Bridge
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1997
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530533329-1.jpg