meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='323508' 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
(
)
)
ffd_listing_title, 950 Columbus Avenue #4, San Francisco, CA, 94133
ffd_mls_id, 422703389
ffd_salesforce_id, a0E8W00000a6ViSUAU
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 20
address2__c, 950 Columbus Avenue #4, San Francisco, CA, 94133
pba__address_pb__c, 950 Columbus Avenue #4, San Francisco, CA, 94133
agent_only_remarks__c, Please call Burt Louie to show Text or Call (415)794-4506 Pre-Escrow opened with DOMA Title Company Kathie Ng (415)608-5633 Easy show call then lockbox
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1984
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-03T11:47:17.000+0000
days_on_market__c, 272
dom__c, 67
ffd_description_pb, Just Reduced priced to sell motivated sellers! Located in the heart of San Francisco's iconic North Beach neighborhood. Spacious one bedroom, one bath condo offers its own separate entrance into the unit of a center outdoor courtyard. This light-filled condo has an open floor plan in the living/dining room with a fireplace and step-out private balcony. The bedroom includes a good size closet. NEW woodblock counters in kitchen, paint and LVP flooring throughout. Double pane windows, in-unit laundry closet and one assigned full-sized parking space. Top floor area has common area with views! Convenient North Beach location to Columbus Ave. restaurants, cafes, and shops. Easy walk to Joe DiMaggio Park with Bocce Ball and Tennis courts, Washington Square Park, Trader Joe's and Safeway and a host of coffee shops.
district__c, SF District 8
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Laminate
hoa_fee_includes__c, Maintenance Exterior,Trash,Water
pba__hoafees__c, 821
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Chestnut Court
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T18:00:21.000+0000
pba__latitude_pb__c, 37.80322
pba__latitude_property__c, 37.80322
laundry_features__c, Laundry Closet
listed_date__c, 2022-10-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Burton
pba__listing_agent_lastname__c, Louie
listing_agent_mls_id__c, 800627
ffd_listingagentname, Burton Louie
listing_agent_number__c, 800627
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 725000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.41414
mls_id__c, 422703389
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
master_property__c, a0O1I000001VihYUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-20
original_price__c, 830000
overall_days_on_market__c, -81376
parking_access__c, Side by Side
parking_features__c, Assigned,Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-01-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 833.33
pba__propertytype__c, Condominium
ListingId, a0E8W00000a6ViSUAU
road_surface_type__c, Asphalt
roof__c, Bitumen
sale_date__c, 2023-01-19
sale_price__c, 695000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 808937
selling_agent_number__c, 1038623
selling_co_agent_mls_id__c, 808971
selling_co_agent_number__c, 1038794
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 834
size__c, 834
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Columbus
subdist__c, North Beach
ffd_name, 950 Columbus Avenue #4, San Francisco, CA, 94133
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1984
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530545103-1.jpg