meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209802' 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-03-19 14:02:33
[post_modified_gmt] => 2024-03-19 21:02:33
[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, 650 Delancey Street #216, San Francisco, CA, 94107
ffd_mls_id, 493810
ffd_salesforce_id, a0E1I00000Q0V1oUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 66
address2__c, 650 Delancey Street #216, San Francisco, CA, 94107
pba__address_pb__c, 650 Delancey Street #216, San Francisco, CA, 94107
agent_only_remarks__c, Easy to show. Call Alicia to schdule 415-407-0714 Escrow pre-opened with Mark Adams at ORTC. If buyer does not need second parking space, I have a buyer for it. Don't miss the Virtual Tour: https://my.matterport.com/show/?m=CYN4HaYYp2j
appliances__c, Dishwasher;Electric Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
reo__c, No
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Low-Flow Toilet(s);Bidet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1996
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-02-22
ffd_createddate, 2020-01-17T17:45:41.000+0000
days_on_market__c, 1279
dom__c, 39
ffd_description_pb, The Oriental Warehouse is the premier historic live/work loft conversion building located in San Francisco's hip South Beach neighborhood. This ground floor loft, situated on the North side of the property, features an open floor plan perfect for entertaining, private patio, large mezzanine bedroom with walk-in closet, second main-level bedroom with custom sliding door, both bathrooms have been remodeled. Hardwood floors, exposed timber beams and a catwalk perfect for a library or art display with built in display shelves and lounge chair. Two deeded parking spaces in a secure garage with storage cages. This modern transformation at the Oriental Warehouse features the finest of finishes and offers a beautifully renovated residence at this historic building in an incredible location in the heart of everything. Enjoy easy access to the Embarcadero waterfront and Oracle Ballpark!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 2
external_listing__c, 1
pba__floor__c, 2
pba__floortype_pb__c, Wood
hoa_dues__c, 653.77
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 653
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Oriental Warehouse HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:26:37.000+0000
pba__latitude_pb__c, 37.78279133
pba__latitude_property__c, 37.78279133
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-01-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Adam
pba__listing_agent_lastname__c, Gavzer
listing_agent_mls_id__c, 800969
ffd_listingagentname, Adam I Gavzer
listing_agent_number__c, 800969
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1875000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=CYN4HaYYp2j
pba__longitude_pb__c, -122.38970667
pba__lotsize_pb__c, 0
mls_id__c, 493810
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001VhlQUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-01-17
original_price__c, 1875000
overall_days_on_market__c, 104
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-02-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1159.74
pba__propertytype__c, Condominium
id, a0E1I00000Q0V1oUAF
roof__c, Bitumen;Composition;Elastomeric
room_type__c, Den
sale_date__c, 2020-03-20
sale_price__c, 1815000
selling_agent_mls_id__c, 808121
selling_agent_name__c, Juliette S. Vo
selling_agent_number__c, 1031013
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, 1565
size__c, 1565
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Delancey
subdist__c, South Beach
ffd_name, 650 Delancey Street #216, San Francisco, CA, 94107
transportation__c, 1 Block
unit_number__c, 216
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1996
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359316-1.jpg
ListingId, a0E1I00000Q0V1oUAF