meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239104' 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] => 2018-11-02 19:54:38
[post_modified_gmt] => 2018-11-02 19:54:38
[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, 18 Vandewater Street, San Francisco, CA, 94133
ffd_mls_id, 422685403
ffd_salesforce_id, a0E8W00000ZKGgZUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 23
address2__c, 18 Vandewater Street, San Francisco, CA, 94133
pba__address_pb__c, 18 Vandewater Street, San Francisco, CA, 94133
agent_only_remarks__c, Supra installed 22-Sept evening - go anytime! Escrow opened with Amy Edberg, First American. 2 pets ok. Rentals ok w/30d+ lease. Legal address is 329 Bay St #101. Front door is 18 Vandewater. Disclosures here: https://b.link/18-Vandewater
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Marble;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2007
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Michael Minson
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-22T19:48:00.000+0000
days_on_market__c, 135
dom__c, 133
ffd_description_pb, In the heart of the city live a Modern Lifestyle, this newer 3BD/3BA North Beach townhouse on a leafy street blocks from Columbus Ave, Fisherman's Wharf and The Embarcadero. This contemporary two story residence offers wide plank flooring, designer fixtures, gorgeous remodeled bathrooms, two en suite bedrooms, plus a private patio. The large living room leads to a chef's kitchen featuring stainless steel Viking appliances, new quartz marbled counters, and a peninsula with bar seating overlooking the dining area. Easy outdoor entertaining space off the dining room with sunny, deep patio. Full bath with shower over tub, gleaming tile, Kohler fixtures and vessel sink. Large downstairs bedroom. Primary suite features new carpet, large French doors, dual closets, stunning marble bath with double sink. Stackable laundry, big storage closet, one car garage parking. Just one block to Trader Joe's. Minutes to North Beach, Aquatic Park, Ferry Building and more.
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway
entry_level__c, 1
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Elevator,Homeowners Insurance,Maintenance Exterior,Management,Roof,Trash,Water
pba__hoafees__c, 875
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-02-04T01:47:28.000+0000
pba__latitude_pb__c, 37.805393
pba__latitude_property__c, 37.805393
laundry_features__c, Laundry Closet
listed_date__c, 2022-08-08
pba__listing_agent_email__c, tracy@levelupgroup.com
pba__listing_agent_firstname__c, Tracy
pba__listing_agent_lastname__c, Hsieh
listing_agent_mls_id__c, 813002
ffd_listingagentname, Tracy Hsieh
listing_agent_number__c, 1058962
listing_co_agent_mls_id__c, 808482
listing_co_agent_number__c, 1035858
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 1448000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4125438
mls_id__c, 422685403
main_level__c, Bedroom(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Low-Flow Toilet(s);Double Sinks;Tile;Marble;Low-Flow Shower(s);Multiple Shower Heads
master_property__c, a0O8W00000FrUWDUA3
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-22
original_price__c, 1698000
overall_days_on_market__c, -81348
parking_access__c, Side by Side
parking_features__c, Assigned
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-01-31T17:17:39.000+0000
price_per_square_foot__c, 778.49
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZKGgZUAX
road_surface_type__c, Paved
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
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, 1860
size__c, 1860
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vandewater
subdist__c, North Beach
ffd_name, 18 Vandewater Street, San Francisco, CA, 94133
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2007
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530509743-1.jpg