meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320236' 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] => 2024-04-05 12:56:49
[post_modified_gmt] => 2024-04-05 19:56:49
[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 #604N, San Francisco, CA, 94105
ffd_mls_id, 422684893
ffd_salesforce_id, a0E8W00000YXqyBUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 220
address2__c, 403 Main Street #604N, San Francisco, CA, 94105
pba__address_pb__c, 403 Main Street #604N, San Francisco, CA, 94105
agent_only_remarks__c, Call/text Roxanne at 310.612.6124 for showings and/or disclosures. Some images virtually staged. Pending litigation is not a building defect. Lenders can lend.
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary;Art Deco
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1997
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Roxanne Mirdamadi
pba__contingentdate__c, 1800-01-01
cooling__c, Ceiling Fan(s)
ffd_createddate, 2022-08-06T01:47:45.000+0000
days_on_market__c, 348
dom__c, 82
ffd_description_pb, Welcome to the Portside and enjoy fabulous San Francisco waterfront and Bay Bridge views from this iconic Art-Deco unit! Dramatic curved windows, open kitchen, large bathroom, multiple closets and in-unit washer/dryer. Open floorplan, lots of light and a sleeping alcove away from the public area. The Portside offers many amenities, a heated pool overlooking the Bay, sun deck, two gyms, a spa, full-time security, one car parking (optional for a low monthly fee) and extra storage. Ideal location, 1 block to Embarcadero, close to Ferry Plaza, Oracle Park Stadium, Chase Center arena, and Financial District. Not to mention proximity to freeway entrance! Fabulous for pied-a-terre, or first-time homebuyer. A great place to live and enjoy the city!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Pool,Security,Trash,Water
pba__hoafees__c, 621
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2023-07-13T17:27:06.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-08-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Howard
pba__listing_agent_lastname__c, Reinstein
listing_agent_mls_id__c, 361126
ffd_listingagentname, Howard Reinstein
listing_agent_number__c, 361126
listing_co_agent_mls_id__c, 815319
listing_co_agent_number__c, 1072193
listing_co_office_mls_id__c, VANG06
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 25987
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 549000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.389586
mls_id__c, 422684893
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I000001VhkgUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-08-05
original_price__c, 549000
overall_days_on_market__c, -81300
pba__pendingdate__c, 2022-10-26
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1055.9
pba__propertytype__c, Condominium
ListingId, a0E8W00000YXqyBUAT
sale_date__c, 2022-12-06
sale_price__c, 510000
security_features__c, Smoke Detector;Security Gate;Secured Access;Carbon Mon Detector;Security Patrol
selling_agent_mls_id__c, 815319
selling_agent_number__c, 1072193
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 483
size__c, 483
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Main
subdist__c, South Beach
ffd_name, 403 Main Street #604N, San Francisco, CA, 94105
view__c, City;Bay
website_property_type__c, Condominium
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/530508916-1.jpg
