meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215177' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 07:57:25
[post_modified_gmt] => 2024-04-17 14:57:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[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, 3106 Turk Boulevard, San Francisco, CA, 94118
ffd_mls_id, 507141
ffd_salesforce_id, a0E1I00000TRfWTUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 3106 Turk Boulevard, San Francisco, CA, 94118
pba__address_pb__c, 3106 Turk Boulevard, San Francisco, CA, 94118
agent_only_remarks__c, OFFER DATE: Tues 10/13 by noon. Showings subject to COVID-19 SIP guidelines. Buyers to provide signed PEAD form for showings. Please email/text Suhl (415) 265-1039 for disclosures. Pre-escrow opened with Paula Siegel at Fidelity on Market Street. Please submit offers on 7 page SFAR contact, with POF/lender approval letter and signed cover page. Disclosures to be signed and sent within 24 hours of contract acceptance. Property website: 3106Turk.com
appliances__c, Dishwasher;Gas Range;Freestanding Range;Hood Over Range;Cooktop Stove
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1952
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-01T14:46:28.000+0000
days_on_market__c, 1021
dom__c, 12
ffd_description_pb, Centrally located in desirable Lone Mountain, this classic mid-century home is flooded with natural light throughout the day. Features include hardwood floors, a wood-burning fireplace and a spacious kitchen with woodblock countertop usable for a casual meal or chopping vegetables. With 2 bedrooms and 2 baths located towards the back of the house and the public rooms in the front, this home is well laid-out for comfortable living. A deck off one of the rear bedrooms looks over the garden with several fruit trees. An additional room and bath down provide space for a home office. Access to the back patio and garden is from the garage. The large garage can accommodate 2 cars with plenty of room for a workshop. This property is within walking distance to Golden Gate Park, Rossi Playgrond and numerous shops/restaurants/public transportation options on Geary Blvd and Balboa Street.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood;Parquet
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:36:13.000+0000
pba__latitude_pb__c, 37.7775741
pba__latitude_property__c, 37.7775741
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-09-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Suhl
pba__listing_agent_lastname__c, Chin
listing_agent_mls_id__c, 800212
ffd_listingagentname, Suhl Chin
listing_agent_number__c, 800212
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=qgbw8donY77&mls=1
pba__longitude_pb__c, -122.4571438
pba__lotsize_pb__c, 0.06
mls_id__c, 507141
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-01
original_price__c, 1495000
overall_days_on_market__c, 91
parking__c, Attached,Garage,Interior Access
parking_features__c, Attached,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-10-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1196.43
pba__propertytype__c, Single Family Residence
id, a0E1I00000TRfWTUA1
sale_date__c, 2020-11-05
sale_price__c, 1675000
selling_agent_mls_id__c, 400593
selling_agent_name__c, Ruth Krishnan
selling_agent_number__c, 1019790
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1400
size__c, 1400
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Turk
subdist__c, Lone Mountain
ffd_name, 3106 Turk Boulevard, San Francisco, CA, 94118
transportation__c, 2 Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1952
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371376-1.jpg
ListingId, a0E1I00000TRfWTUA1