meta_query='key:subdist__c;value:Lower Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337191' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15728
[post_author] => 4
[post_date] => 2018-11-02 19:54:52
[post_date_gmt] => 2018-11-02 19:54:52
[post_content] => Historic cottage row, Fillmore Street shops, and Pacific Heights style, just down the hill a smidge. A vibrant neighborhood that blends the best of Western Addition and Pacific Heights with classic sprinkles of San Francisco history.
[post_title] => Lower Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lower-pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 09:02:57
[post_modified_gmt] => 2023-06-23 16:02:57
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15728
[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, 1876 Bush 1878 Street, San Francisco, CA, 94109
ffd_mls_id, 423900330
ffd_salesforce_id, a0E8W00000cpwwmUAA
num_of_rooms__c, 13
of_units__c, 2
address2__c, 1876 Bush 1878 Street, San Francisco, CA, 94109
pba__address_pb__c, 1876 Bush 1878 Street, San Francisco, CA, 94109
agent_only_remarks__c, These flats are easy to use as a single family, or as a unit with income. There are also plans available to add the extra legal rooms down to the lower unit. Fast track condo conversion, no eviction history. CAN BE SOLD INDIVIDUALLY. TIC AGREEMENT AVAILABLE.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Plumbed For Ice Maker
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 6
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Tatyana Mironova
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-08-28T21:29:12.000+0000
days_on_market__c, 36
dom__c, 36
ffd_description_pb, These stunning Vic flats were built in 1900 & have recently been extensively remodeled w/the elegant finishes of a Parisian apt. The new open floor plans feature chef's kitchens that would please any graduate of the Le Cordon Bleu. Extensive cabinets, Thermadore appliances, marble backsplashes, quartz counters & a generous center island for prep and entertaining. The open living space features dining & a living room areas w/gas frpl w/a venetian plaster finish. In the lower unit there are French doors out to the generous deck and level back yard for al fresco dining & barbecues & perhaps to grow your own garden vegetables. The Upper unit's living space also features a lovely & bright breakfast nook for more cafe & croissant. In each flat all 3 bedrooms are generously proportioned. Upstairs & down the primary suites are south facing & flooded w/light & have ensuite baths & walk-in closets. The 2nd & 3rd bedrooms are also quite generous & offer good closet space. 11-foot ceilings throughout both units, along w/stunning hrdwd flrs & period trim & moldings only add to the elegance of these beautiful flats.The ground floor level features a very large 2+ car garage w/extra storage & 1 car in the driveway. Legally finished & flexible rooms behind the garage include a full bath & wetbar
district__c, SF District 6
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s);Separate
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-09-29T11:47:19.000+0000
pba__latitude_pb__c, 37.787987
pba__latitude_property__c, 37.787987
laundry_features__c, Laundry Closet;Washer/Dryer Hookups;In Each Unit
listed_date__c, 2023-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Woodruff
listing_agent_mls_id__c, 239976
ffd_listingagentname, John L Woodruff III
listing_agent_number__c, 239976
listing_co_agent_mls_id__c, A339024
listing_co_agent_number__c, 981093067
listing_co_office_mls_id__c, 7B2246
listing_co_office_name__c, Radius Agent Realty
listing_co_office_number__c, 981085829
listing_office_mls_id__c, AETHOS
listing_office_name__c, Aethos Real Estate
listing_office_number__c, 27302
pba__listingprice_pb__c, 4250000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1876-1878BushSt.com
pba__longitude_pb__c, -122.428133
mls_id__c, 423900330
parkingspaces__c, 3
on_market_date__c, 2023-08-24
open_house_end__c, 2023-09-30T16:30:00.000+0000
open_house_start__c, 2023-09-30T14:00:00.000+0000
original_price__c, 4499000
overall_days_on_market__c, -81684
parking_features__c, Attached,Covered,Garage,Side-by-Side
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 998.59
pba__propertytype__c, Duplex
ListingId, a0E8W00000cpwwmUAA
roof__c, Composition;Elastomeric
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Unguarded Gate
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, 4256
size__c, 4256
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Bush
subdist__c, Lower Pacific Heights
ffd_name, 1876 Bush 1878 Street, San Francisco, CA, 94109
website_property_type__c, Duplex
window_features__c, Bay Window(s);Storm Windows
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661361-1.jpg
_wp_old_slug, 1876-bush-1878-street-san-francisco-ca-94109-3