meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='400247' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
[post_title] => Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 07:08:05
[post_modified_gmt] => 2024-03-28 14:08:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15724
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1728741116
ffd_listing_title, 1836 Broadway 1840 Street, San Francisco, CA, 94109
ffd_mls_id, 424065264
ffd_salesforce_id, a0EUd0000036vhsMAA
num_of_rooms__c, 17
of_units__c, 3
address2__c, 1836 Broadway 1840 Street, San Francisco, CA, 94109
pba__address_pb__c, 1836 Broadway 1840 Street, San Francisco, CA, 94109
agent_only_remarks__c, Building is finalizing the condo conversion. Call Joseph Chav at 415.980.9262 and Roque Fernandes at 415.860.9008 for questions. Lockbox on the side gate. Please turn off all lights and lock all doors after showing. 3D Tour: https://my.matterport.com/show/?m=7E2RNdB174a Drone Video: https://youtu.be/tIobSdU82go Disclosure Package | https://app.disclosures.io/link/18361840-Broadway-xuobx0in
appliances__c, Dishwasher;Gas Water Heater;Free Standing Gas Oven;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 9
year_build_text__c, 1909
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Lily Tzu Lew
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-14T10:49:57.000+0000
days_on_market__c, 29
dom__c, 29
ffd_description_pb, Located in the heart of Pacific Heights, 1836-1840 Broadway presents a rare opportunity for both owner-occupants and investors alike. This VACANT property, currently in the final stages of condo conversion, offers over 4,300 square feet of living space across three units. The building features two spacious 3-bedroom, 2-bath units, a cozy 1-bedroom, 1-bath garden apartment, and an impressive 2-bedroom, 2-bath penthouse with breathtaking views. The expansive backyard, complete with a patio, provides an ideal space for outdoor gatherings, while being steps from the vibrant dining and shopping districts of Union, Fillmore and Chestnut Streets. Don't miss this rare chance to own a piece of San Francisco's finest real estate!
district__c, SF District 7
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Floor Furnace;Central
interior_features__c, Formal Entry;Skylight(s);Wet Bar;Elevator
ffd_lastmodifieddate, 2024-10-12T13:47:05.000+0000
pba__latitude_pb__c, 37.7954203
pba__latitude_property__c, 37.7954203
laundry_features__c, Laundry Closet;Washer/Dryer Hookups;In Common Area;Varies by Unit
listed_date__c, 2024-09-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Chav
listing_agent_mls_id__c, 805827
ffd_listingagentname, Joseph Chav
listing_agent_number__c, 166015886
listing_co_agent_mls_id__c, 257336
listing_co_agent_number__c, 257336
listing_co_office_mls_id__c, COLD03
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 875
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 4500000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=7E2RNdB174a
pba__longitude_pb__c, -122.4279194
mls_id__c, 424065264
parkingspaces__c, 3
on_market_date__c, 2024-09-13
open_house_end__c, 2024-10-12T16:00:00.000+0000
open_house_start__c, 2024-10-12T14:00:00.000+0000
original_price__c, 4500000
overall_days_on_market__c, -82070
parking_features__c, Garage,Side-by-Side,Tandem Garage,Varies by Unit
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 1044.57
pba__propertytype__c, Triplex
ListingId, a0EUd0000036vhsMAA
roof__c, Bitumen
sale_date__c, 1800-01-01
sale_price__c, 0
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, 4308
size__c, 4308
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Broadway
subdist__c, Pacific Heights
ffd_name, 1836 Broadway 1840 Street, San Francisco, CA, 94109
view__c, Water;San Francisco
website_property_type__c, Triplex
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530842123-1.jpg