meta_query='key:subdist__c;value:South Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='416975' 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
(
)
)
_yoast_indexnow_last_ping, 1726855253
ffd_listing_title, 338 Main Street #35E, San Francisco, CA, 94105
ffd_mls_id, 424062460
ffd_salesforce_id, a0EUd0000039pXpMAI
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 230
address2__c, 338 Main Street #35E, San Francisco, CA, 94105
pba__address_pb__c, 338 Main Street #35E, San Francisco, CA, 94105
agent_only_remarks__c, The property is tenant occuppied. Rent is $10,250 per month. Great for your investor clients. Please allow time to arrange showing. Excellent tenants.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2016
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-09-20T11:47:53.000+0000
days_on_market__c, 2
dom__c, 2
ffd_description_pb, Stunning 3Br 3Ba on 35th floor (the highest level for 3Br floor plan) with spectacular Downtown and Bay views from North Bay to South Beach from every room. Great open plan with spacious living/dining and wall of window, a private terrace with stunning Bay views, two master suites and one guest suite with a separate bath. Interior features Gaggenau appliances, SieMatic cabinets, Caesarstone quartz countertops, European porcelain bathroom flooring and shower tiles, Maax soaking tub, Kohler shower and bath fixtures. Nest Learning Thermostats, power window shades in every room, and custom closets. LUMINA offers residents an unrivaled collection of amenity spaces including a bi-level club lounge, private dining room, rooftop terrace, Jay Wright-designed fitness center, 70-ft heated lap pool, private dining room, movie theater, full service valet, 24 hour doorman, concierge service, and Woodland's Market. Just blocks to the Embarcadero waterfront, Ferry Plaza, Farmer's market and world class dining.
district__c, SF District 9
entry_level__c, 35
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Door Person,Elevator,Gas,Maintenance Exterior,Maintenance Grounds,Management
pba__hoafees__c, 1406
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Lumina HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-09-20T17:47:52.000+0000
pba__latitude_pb__c, 37.7887038
pba__latitude_property__c, 37.7887038
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2024-09-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Masoumeh
pba__listing_agent_lastname__c, Pahlbod
listing_agent_mls_id__c, 404560
ffd_listingagentname, Masti M Pahlbod
listing_agent_number__c, 404560
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF4
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 28140
pba__listingprice_pb__c, 3198000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3914964
mls_id__c, 424062460
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
master_property__c, a0O1I000001VhhaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-18
original_price__c, 3198000
overall_days_on_market__c, -82075
parking_access__c, Independent
parking_features__c, Valet
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Enclosed Deck
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, 1785.59
pba__propertytype__c, Condominium
ListingId, a0EUd0000039pXpMAI
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Alarm;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, 1791
size__c, 1791
spa__c, 1
pba__state_pb__c, CA
stories__c, 37
pba__street_pb__c, Main
subdist__c, South Beach
ffd_name, 338 Main Street #35E, San Francisco, CA, 94105
view__c, City;City Lights;Bay;Water;Downtown;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530845051-1.jpg