meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382876' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15721
[post_author] => 4
[post_date] => 2018-11-02 19:54:38
[post_date_gmt] => 2018-11-02 19:54:38
[post_content] => Marilyn Monroe married Joe DiMaggio in the neighborhood. The rest is history. Welcome to a neighborhood as old as San Francisco, with historic Italian roots, fragrant garlic feasts, and plenty of neighborhood haunts frequented by SF movers and martini-shakers. Here's to you, Herb!
[post_title] => North Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:42:39
[post_modified_gmt] => 2024-03-19 21:42:39
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15721
[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, 1726224822
ffd_listing_title, 629 Chestnut Street #401, San Francisco, CA, 94133
ffd_mls_id, 424052592
ffd_salesforce_id, a0EUd000002gJEnMAM
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 7
address2__c, 629 Chestnut Street #401, San Francisco, CA, 94133
pba__address_pb__c, 629 Chestnut Street #401, San Francisco, CA, 94133
agent_only_remarks__c, https://app.disclosures.io/link/629-Chestnut-Street-401-6d44nnkd Buyers are encouraged to investigate all matters to their satisfaction. Listing agent has not and will not verify any information provided by 3rd parties, which is deemed reliable.
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Gas Cook Top;Built-In Electric Oven
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1990
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-26T18:46:50.000+0000
days_on_market__c, 49
dom__c, 49
ffd_description_pb, Welcome to the penthouse unit of this rarely available boutique building, comprising the entire top floor. This light-filled, quiet home offers unparalleled privacy in a building with only 7 condominium units. Enjoy the luxury of three deeded parking spots and the convenience of an elevator directly from the garage to your private residence floor. The spacious open living room features a flexible floor plan, bay windows, and an abundance of natural light. Enjoy drinks on your private deeded deck or enjoy the shared roof top deck perfect for viewing fireworks and the Blue Angels as they soar overhead. Located just a half block from Columbus Avenue, this home is a walker's paradise with over 100 stores, cafes, and restaurants within a five-block radius. Start your day with coffee at City Lights Bookstore, have lunch at Mama's, and spend your afternoon relaxing in Washington Square Park.This penthouse is the epitome of city living at its finest.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 744
pba__hoafrequency_pb__c, Monthly
hoa_name__c, In Disclosures
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
interior_features__c, Elevator
ffd_lastmodifieddate, 2024-09-13T10:46:53.000+0000
pba__latitude_pb__c, 37.8034167
pba__latitude_property__c, 37.8034167
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-07-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joshua
pba__listing_agent_lastname__c, Altman
listing_agent_mls_id__c, 813222
ffd_listingagentname, Joshua Altman
listing_agent_number__c, 1060302
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDF
listing_office_name__c, Redfin
listing_office_number__c, 64045
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ipfcN7BxmYP&
pba__longitude_pb__c, -122.4136934
mls_id__c, 424052592
master_property__c, a0O8W00000KEjsTUAT
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-07-26
open_house_end__c, 2024-09-15T16:30:00.000+0000
open_house_start__c, 2024-09-15T15:00:00.000+0000
original_price__c, 1950000
overall_days_on_market__c, -82021
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-09-12T20:57:24.000+0000
price_per_square_foot__c, 861.36
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0EUd000002gJEnMAM
sale_date__c, 1800-01-01
sale_price__c, 0
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, 2200
size__c, 2200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Chestnut
subdist__c, North Beach
ffd_name, 629 Chestnut Street #401, San Francisco, CA, 94133
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1990
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530817078-1.jpg