meta_query='key:subdist__c;value:Lower Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211036' 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] => 2024-04-15 08:16:24
[post_modified_gmt] => 2024-04-15 15:16:24
[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, 2123 Bush Street, San Francisco, CA, 94115
ffd_mls_id, 509560
ffd_salesforce_id, a0E1I00000TVBLNUA5
vacant__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 2123 Bush Street, San Francisco, CA, 94115
pba__address_pb__c, 2123 Bush Street, San Francisco, CA, 94115
agent_only_remarks__c, In regards to Bathroom count- there are 3 full baths and 2 half baths in the property. Square footage includes an auxiliary finished office that was measured at 145 sqft but is not warranted sqft. Escrow opened with Michelle Patterson at First American Title. Property is legally a duplex with a 2 level upper unit and 1 level lower unit. showings by appt using Calendly link: https://calendly.com/ascendre/2123-bush-street-private-showings . Also submitted as a single family home.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1885
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Steven Huang
pba__contingentdate__c, 2020-11-19
ffd_createddate, 2020-11-07T11:48:02.000+0000
days_on_market__c, 985
dom__c, 19
ffd_description_pb, Grand 3-bed home with 2-bed second unit in desirable Lower Pac Heights, with soaring ceilings, modern lighting, wooden floors & Victorian details. Main residence features living room with fireplace, stylish powder room, formal dining room and upgraded kitchen with granite countertops, stainless steel appliances, modern cabinetry, and tree-shaded back deck designed for outdoor living. Ascend upstairs to a spacious primary bedroom suite and wood-clad sunroom or home office with city vista! Two additional bedrooms and a second bathroom complete this level. Second unit is perfect for visiting guests, rental income, au pair, home business, or more space to stretch out. The living, dining and kitchen are designed for comfort and convenience. The two bedrooms, bathroom and powder room allow for flexible use. Extra spacious backyard has lovely mature trees and hardscape areas for personal outdoor activities or private social events.
district__c, SF District 6
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Cork;Tile;Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Fireplace(s)
ffd_lastmodifieddate, 2022-01-25T13:32:27.000+0000
pba__latitude_pb__c, 37.786912
pba__latitude_property__c, 37.786912
laundry_features__c, Washer/Dryer;In Each Unit
listed_date__c, 2020-11-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Daniel
pba__listing_agent_lastname__c, Risman-Jones
listing_agent_mls_id__c, 400612
ffd_listingagentname, Daniel J Risman-Jones
listing_agent_number__c, 1023994
listing_co_agent_mls_id__c, 810090
listing_co_agent_number__c, 1044640
listing_co_office_mls_id__c, ASCEND
listing_co_office_name__c, Ascend Real Estate
listing_co_office_number__c, 27278
listing_office_mls_id__c, ASCEND
listing_office_name__c, Ascend Real Estate
listing_office_number__c, 27278
pba__listingprice_pb__c, 3100000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4328355
pba__lotsize_pb__c, 0.1
mls_id__c, 509560
master_property__c, a0O8W00000DaF6QUAV
parkingspaces__c, 5
on_market_date__c, 2020-11-06
original_price__c, 3100000
overall_days_on_market__c, 175
parking__c, Uncovered,Auto Door
parking_features__c, Garage Door Opener,Uncovered
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2020-11-25
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1083.92
pba__propertytype__c, Duplex
id, a0E1I00000TVBLNUA5
sale_date__c, 2020-12-30
sale_price__c, 3100000
selling_agent_mls_id__c, 400638
selling_agent_name__c, Natalie Kitchen
selling_agent_number__c, 1021887
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2860
size__c, 2860
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
style__c, Victorian
subdist__c, Lower Pacific Heights
ffd_name, 2123 Bush Street, San Francisco, CA, 94115
type__c, Duplex
view__c, City Lights
website_property_type__c, Duplex
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1885
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/373464-1.jpg
ListingId, a0E1I00000TVBLNUA5