meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239751' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15732
[post_author] => 4
[post_date] => 2018-11-02 19:54:57
[post_date_gmt] => 2018-11-02 19:54:57
[post_content] => San Francisco's highest point was developed beginning in the 1960s. Mid-century construction, utilitarian buildings, and jaw-dropping views of downtown and the East Bay when the wind and fog relent.
[post_title] => Twin Peaks
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => twin-peaks
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-15 08:07:47
[post_modified_gmt] => 2024-04-15 15:07:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15732
[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, 3815 Market Street, San Francisco, CA, 94131
ffd_mls_id, 422688193
ffd_salesforce_id, a0E8W00000YZZUPUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3815 Market Street, San Francisco, CA, 94131
pba__address_pb__c, 3815 Market Street, San Francisco, CA, 94131
agent_only_remarks__c, Disclosures available. For more info, disclosures, or showing requests, please reach out to Jeff Stephenson [email protected] / 415-577-2580 Surprisingly quiet Market St home, bedrooms at rear of property. Great condo-alternative!!
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1938
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-16T10:49:15.000+0000
days_on_market__c, 306
dom__c, 5
ffd_description_pb, Perched high on Twin Peaks, this 2 bedroom, 2 bath single-family offers stunning views from every level. Step onto the terrace and watch the morning sunrise over the Bay or enjoy evening cocktails with the city lights below! Two levels of living space and outdoor decks are perfect for entertaining. The main floor offers a modern kitchen, living room, and formal dining room opening to a view deck. A bedroom and a charming vintage bathroom are also located on this level. The lower level includes a primary bedroom with ensuite bath plus a spacious family room accessing additional view decks and the level yard below. Relax to fabulous views over the city, the Bay, Mount Diablo, and the eastern hills. A garage with interior access, automatic door, and washer & dryer checks the remaining boxes. Freshly painted with beautifully refinished hardwood floors and move-in ready!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T17:45:56.000+0000
pba__latitude_pb__c, 37.7534295
pba__latitude_property__c, 37.7534295
laundry_features__c, In Garage;Washer/Dryer Stacked Included
listed_date__c, 2022-09-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
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, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.3815market.com
pba__longitude_pb__c, -122.4422889
lower_level__c, Family Room,Primary Bedroom
mls_id__c, 422688193
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-16
original_price__c, 1495000
overall_days_on_market__c, -81342
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-09-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1054.46
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YZZUPUA5
sale_date__c, 2022-10-12
sale_price__c, 1665000
selling_agent_mls_id__c, 814832
selling_agent_number__c, 1068469
selling_co_agent_mls_id__c, 805155
selling_co_agent_number__c, 166014957
selling_co_office_mls_id__c, SAGERE
selling_co_office_name__c, Sage Real Estate
selling_co_office_number__c, 28708
selling_office_name__c, Sage Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1579
size__c, 1579
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, Twin Peaks
ffd_name, 3815 Market Street, San Francisco, CA, 94131
view__c, City;City Lights;Bay;Water;Hills;Mt Diablo
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1938
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530529121-1.jpg