meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221255' 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
(
)
)
ffd_listing_title, 2858 Sacramento Street, San Francisco, CA, 94115
ffd_mls_id, 421597688
ffd_salesforce_id, a0E8W00000V0QGlUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 2858 Sacramento Street, San Francisco, CA, 94115
pba__address_pb__c, 2858 Sacramento Street, San Francisco, CA, 94115
agent_only_remarks__c, More at www.2858Sacramento.com. For showings, please call or text Ron Abta: 415-595-7661. Disclosures Link: https://app.disclosures.io/link/2858-Sacramento-Street-08sdqnaf Escrow is opened with Steve Salviejo, (415) 346-0122, from North American Title. PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and enter at their own risk.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-09-24T16:49:24.000+0000
days_on_market__c, 663
dom__c, 11
ffd_description_pb, Located in the heart of Pacific Heights, this spacious 3 bed / 2 bath Queen Anne Victorian condo has been lovingly updated throughout with the finest attention to detail while keeping intact its San Francisco architectural charm. The gourmet kitchen impresses with its suite of Wolf, Miele and Bosch appliances, sizable pantry, and breakfast nook perfect for your morning coffee. The primary suite's bathroom enjoys a marble tile surround and Duravit amenities. Gorgeous detailing and high ceilings adorn the condo and mix well with the great open floor plan. A full basement for the building offers great storage and other potential as well. The landscaped backyard is ideal for relaxing, BBQ'ing, or the Work-From-Home day in the sun. Laundry in the unit and a 98 Walk Score (Walkers Paradise) complete this incredible home, with Fillmore Street cafes, restaurants, and Alta Plaza Park all literally just steps away. Don't miss!
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 375
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T16:02:52.000+0000
pba__latitude_pb__c, 37.789354
pba__latitude_property__c, 37.789354
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-09-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ron
pba__listing_agent_lastname__c, Abta
listing_agent_mls_id__c, 803878
ffd_listingagentname, Ron Abta
listing_agent_number__c, 166013231
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, POLARISR
listing_office_name__c, Polaris Realty
listing_office_number__c, 27749
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ivkfpSMTDjP
pba__longitude_pb__c, -122.439962
mls_id__c, 421597688
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Marble
master_property__c, a0O8W00000DXn2kUAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-09-24
original_price__c, 1695000
overall_days_on_market__c, 98
pba__pendingdate__c, 2021-10-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1146.63
pba__propertytype__c, Condominium
id, a0E8W00000V0QGlUAN
room_type__c, Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-10-25
sale_price__c, 1955000
selling_agent_mls_id__c, 808958
selling_agent_number__c, 1038682
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, 1705
size__c, 1705
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sacramento
subdist__c, Pacific Heights
ffd_name, 2858 Sacramento Street, San Francisco, CA, 94115
view__c, Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530329055-1.jpg
ListingId, a0E8W00000V0QGlUAN