meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338553' 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] => 2023-08-21 10:41:08
[post_modified_gmt] => 2023-08-21 17:41:08
[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, 423750597
ffd_salesforce_id, a0E8W00000dSWN8UAO
num_of_fireplaces__c, 1
num_of_rooms__c, 6
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, Security System is active, please call/text Nicole (310.866.5458) before showing for access instructions. Bedrooms are in the back of the home and quiet. See Virtual Media for 2 of 3 CityStructure Reports; a Detached ADU Report is also available in the disclosure package. https://app.disclosures.io/link/3815-Market-Street-ecj2fg65
appliances__c, Microwave;Disposal;Built-In Gas Oven;Free Standing Refrigerator;Gas Cook Top
bath_features__c, Shower Stall(s);Tub
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, Brian W Garrett
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-09-15T15:46:33.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Incredible city and bay views abound, with three levels of decks for entertaining. Featuring beautiful hardwood floors, picture windows, and lots of charm, this two bedroom, two bathroom house with A/C is not to be missed! The main living area is at street level, and includes a kitchen, formal living and dining rooms, plus a bedroom and full bath. Downstairs is a spacious family room and a primary suite. Both floors open to decks with views, and there is an additional lower deck opening to the generous backyard. A garage with interior access and laundry rounds out this fabulous home. Lot extends to Grand View, presenting numerous expansion opportunities. Conveniently located just blocks away from 24th St in Noe Valley!
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
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
ffd_lastmodifieddate, 2023-09-23T10:47:54.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, 2023-06-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nicole
pba__listing_agent_lastname__c, Gambino
listing_agent_mls_id__c, 814832
ffd_listingagentname, Nicole Gambino
listing_agent_number__c, 1068469
listing_co_agent_mls_id__c, 805155
listing_co_agent_number__c, 166014957
listing_co_office_mls_id__c, SAGERE
listing_co_office_name__c, Sage Real Estate
listing_co_office_number__c, 28708
listing_office_mls_id__c, SAGERE
listing_office_name__c, Sage Real Estate
listing_office_number__c, 28708
pba__listingprice_pb__c, 1649000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.citystructure.com/report/maximum-vertical-expansion-report-3815-market-st-san-francisco
pba__longitude_pb__c, -122.4422889
lower_level__c, Family Room,Primary Bedroom
mls_id__c, 423750597
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-15
open_house_end__c, 2023-09-23T16:00:00.000+0000
open_house_start__c, 2023-09-23T11:00:00.000+0000
original_price__c, 1649000
overall_days_on_market__c, -81706
parking_access__c, Tandem
parking_features__c, Attached,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, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1044.33
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dSWN8UAO
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
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, 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;Bay;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/530677565-1.jpg
