meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210669' 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, 15 Vandewater Street, San Francisco, CA, 94133
ffd_mls_id, 494454
ffd_salesforce_id, a0E1I00000QpjFDUAZ
vacant__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 15 Vandewater Street, San Francisco, CA, 94133
pba__address_pb__c, 15 Vandewater Street, San Francisco, CA, 94133
agent_only_remarks__c, Square footage is not verified by agents or sellers; buyers to investigate. Photos from previous listing when staged. Pre-sale escrow open w/ Kevin Thompson @ First American. Contact Melissa Montoya at 415-328-9808 or [email protected] for showings or disclosures. Check out www.15Vandewater.com for more!
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Modern/High Tech;Conversion;Craftsman
pba__fullbathrooms_pb__c, 0
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-03T20:45:30.000+0000
days_on_market__c, 1262
dom__c, 5
ffd_description_pb, Situated in North Beach, one of San Francisco's most sought after neighborhoods, 15 Vandewater is a spectacular, loft-style 2-unit property that offers myriad possibilities to investors and home owner's alike. The modern finishes, clean design and open floor plan for each unit allow for countless creative uses for the building. The spacious, two-level, upper unit features 2BRs and 2.5 BAs. W/ incredible volume and wonderful natural light, this home blends the warm tones of walnut hardwood flrs w/ clean, modern lines, custom industrial sized windows and skylights. The chefs kitchen opens up to the generous living area, which is perfect for entertaining. The large, 1 bedroom lower unit has 1.5BA and Ash wood flrs throughout. Spacious garage has parking for 3 cars+additional storage + full sized W/D. Panoramic roof deck w/ views of Coit Tower, Salesforce tower, Alcatraz and the GGB.
district__c, SF District 8
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant;Central;Gas
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-01-12T20:10:10.000+0000
pba__latitude_pb__c, 37.805161
pba__latitude_property__c, 37.805161
laundry_features__c, Washer/Dryer
listed_date__c, 2020-02-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joshua
pba__listing_agent_lastname__c, McAdam
listing_agent_mls_id__c, 902000
ffd_listingagentname, Joshua J McAdam
listing_agent_number__c, 1027476
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2950000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.412398
pba__lotsize_pb__c, 0.03
mls_id__c, 494454
master_property__c, a0O8W00000DaEwJUAV
parkingspaces__c, 3
on_market_date__c, 2020-02-03
original_price__c, 2950000
overall_days_on_market__c, 87
parking__c, Garage,Interior Access
parking_features__c, Garage,Interior Access
patio_and_porch_features__c, Roof Deck(s)
pba__pendingdate__c, 2020-02-08
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 729.3
pba__propertytype__c, Duplex
id, a0E1I00000QpjFDUAZ
roof__c, Bitumen
sale_date__c, 2020-03-04
sale_price__c, 2950000
security_features__c, Smoke Detector;Fire Suppression System
selling_agent_mls_id__c, MLSL99528
selling_agent_number__c, 981127907
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Montalvo Realty
pba__status__c, Closed
pba__totalarea_pb__c, 4045
size__c, 4045
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vandewater
style__c, Custom,Modern/High Tech,Conversion
subdist__c, North Beach
ffd_name, 15 Vandewater Street, San Francisco, CA, 94133
type__c, Flats,Duplex,3 Story
view__c, Panoramic;City Lights;Bay;Water;Downtown;San Francisco;Golden Gate Bridge
website_property_type__c, Duplex
window_features__c, Window Coverings;Dual Pane;Window Screens
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359871-1.jpg
ListingId, a0E1I00000QpjFDUAZ