meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215106' 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, 42 August Alley, San Francisco, CA, 94133
ffd_mls_id, 506869
ffd_salesforce_id, a0E1I00000THpPpUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 42 August Alley, San Francisco, CA, 94133
pba__address_pb__c, 42 August Alley, San Francisco, CA, 94133
agent_only_remarks__c, Reduced and ready to sell! Full virtual media available at www.42August.com. Prelim courtesy of Gerrie Brindley at Chicago Title. Legally a 2 unit building the home is currently configured as a single family home. Bonus room on lower level is unwarranted.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range;Ice Maker;Freezer
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s);Remodeled;Marble;Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-26T22:46:15.000+0000
days_on_market__c, 1026
dom__c, 53
ffd_description_pb, Iconic, romantic and aspirational: fall in love with 42 August Alley. A view home tucked away in the heart of North Beach; this private residence was extensively remodeled with an eye for detail. This beautiful 3 bed, 2.5 bath home boasts an expansive view roof deck, 2 car parking, and bonus room making this home a must-see for the most discerning buyer. A home like this is seldom available and affords a rare opportunity. With views from all levels, this home is one not to miss! The top floor entertaining level features an open floor plan with Coit Tower and cathedral views. Equipped with state-of-the-art appliances and expansive prep space the chef's kitchen leads to the panoramic view roof deck. The main level features 3 bedrooms, each generously proportioned, and 2 stunningly remodeled bathrooms. The master suite delights with iconic views over Washington Square Park. A large artist's studio opening onto the sunny city garden finishes the home perfectly.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:35:53.000+0000
pba__latitude_pb__c, 37.799775
pba__latitude_property__c, 37.799775
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-07-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brendon
pba__listing_agent_lastname__c, Kearney
listing_agent_mls_id__c, 802979
ffd_listingagentname, Brendon Kearney
listing_agent_number__c, 802979
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 3195000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.42august.com/unbranded
pba__longitude_pb__c, -122.411447
pba__lotsize_pb__c, 0.03
lower_level__c, Family Room,Partial Bath(s)
mls_id__c, 506869
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-26
original_price__c, 3495000
overall_days_on_market__c, 88
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Deck(s);Patio(s)
pba__pendingdate__c, 2020-11-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1500
pba__propertytype__c, Single Family Residence
id, a0E1I00000THpPpUAL
roof__c, Bitumen
room_type__c, Office;Bonus Room
sale_date__c, 2020-11-30
sale_price__c, 3000000
security_features__c, Security Gate
selling_agent_mls_id__c, 404547
selling_agent_name__c, Andrew Herrera II
selling_agent_number__c, 404547
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berkshire Hathaway-Franciscan
pba__status__c, Closed
pba__totalarea_pb__c, 2000
size__c, 2000
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, August
subdist__c, North Beach
ffd_name, 42 August Alley, San Francisco, CA, 94133
transportation__c, 1 Block
view__c, Panoramic;City Lights;Bay;Water
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Bay Window(s);Window Screens
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371137-1.jpg
ListingId, a0E1I00000THpPpUAL
