meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376179' 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
(
)
)
_yoast_indexnow_last_ping, 1713495336
ffd_listing_title, 3795 Market Street, San Francisco, CA, 94131
ffd_mls_id, 424008605
ffd_salesforce_id, a0EUd000001F5YIMA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3795 Market Street, San Francisco, CA, 94131
pba__address_pb__c, 3795 Market Street, San Francisco, CA, 94131
agent_only_remarks__c, Offers due on 3/27 (Wednesday) at 10AM. Home is being marketed as a single family home but according to the tax records, it's actually a two unit building. Buyers to decide. There is interior access to the lower unit if Buyer wants to use the entire home. Please DO NOT text for showings. Showing instructions can be found here: https://calendly.com/3795marketst/showings Please review disclosures: https://app.glide.com/share/7dVHfg7zQhFqzePlCknvIm/ Escrow is opened with [email protected]. All buyers to use the most current 8-page SFAR contract. If needed, one will be provided. *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Disposal;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Built-In Refrigerator
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-23T15:46:42.000+0000
days_on_market__c, 56
dom__c, 34
ffd_description_pb, 900K price reduction! Exceptional 3-bed, 3.5-bath home built tastefully updated in 2018. Solar panels were added and paid in full. Versatile layout offers single-family living or separate unit potential: you choose. Main level features an open kitchen/dining area with Venetian plaster walls and high-end stainless steel appliances including a Wolf range & Sub-zero refrigerator. Upstairs, primary suite with spa-like bath and sunset views from decks. Separate laundry rooms on top and lower level. Right outside your door, Dixie Alley offers a lifeline to Noe Valley and Castro, with local favorites like Le Marais Bakery, Bernie's Coffee, Firefly, and Starbelly. With a walk score of 78, a seemingly endless amount of secret stairways, including the 22nd Street jungle steps, lets you explore nearby neighborhoods with ease. You'll also appreciate access to Whole Foods for weekly grocery shopping, and nearby playgrounds like Noe Courts, Douglass Park, and Alvarado Park. For more exploration, the Castro BART allows for easy access to the rest of the city.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-19T02:46:52.000+0000
pba__latitude_pb__c, 37.753626
pba__latitude_property__c, 37.753626
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2024-02-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://ruthkrishnan.com/property-listings/3795-market-st-twin-peaks/
pba__longitude_pb__c, -122.442189
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Kitchen,Street Entrance
mls_id__c, 424008605
main_level__c, Partial Bath(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Double Sinks;Tile;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-02-22
original_price__c, 2595000
overall_days_on_market__c, -81866
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-18T13:29:51.000+0000
price_per_square_foot__c, 882.67
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001F5YIMA0
sale_date__c, 2024-04-18
sale_price__c, 2475000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 809119
selling_agent_number__c, 1040495
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, 2804
size__c, 2804
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, Twin Peaks
ffd_name, 3795 Market Street, San Francisco, CA, 94131
view__c, City;Bay;Water;Downtown
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530735343-1.jpg