meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215977' 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, 2940 Turk Boulevard, San Francisco, CA, 94118
ffd_mls_id, 509572
ffd_salesforce_id, a0E1I00000TVEOSUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 2940 Turk Boulevard, San Francisco, CA, 94118
pba__address_pb__c, 2940 Turk Boulevard, San Francisco, CA, 94118
agent_only_remarks__c, Signed PEAD must be provided prior to entry. Seller reserves right to accept, counter, or reject any offers. Call Bob Walker 415-819-1291 or George Green 415-608-6485 to show. No monthly HOA dues, expenses are paid as incurred. Average monthly cost per unit is about $549 / month. Pre-sale Escrow is open with Michael Gaffney ([email protected]) at Fidelity National Title 415-345-5012, escrow # FSFM-0062003113-MG. Dining room light fixture is excluded from the sale. Dislosure.io link -https://app.disclosures.io/link/2940-Turk-Boulevard-mklnuohl
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator
architectural_style__c, Spanish/Med
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
listing_co_agent_name__c, George M Green
pba__contingentdate__c, 2020-11-15
ffd_createddate, 2020-11-10T22:46:44.000+0000
days_on_market__c, 981
dom__c, 7
ffd_description_pb, Remarkable three bedroom, two bath Lone Mountain condominium directly across from the Koret Recreation Center and close to USF and Rossi Park. This gracious full floor lower residence is in a two-unit Mediterranean style building with private entrance and is located on a 50' wide lot with windows on three sides providing the residence a light open feeling. There are plank and parquet hardwood floors throughout, dual pane windows, fireplace in the living room, plus a formal dining room. There is a private master bedroom with a full bath in the front of the residence plus two additional bedrooms and full bath overlooking the shared rear yard. Two of the bedrooms including the master have walk-in closets with shelving treatments. The kitchen has been remodeled with maple cabinets, tile floor and custom tile counters with full tile backsplash. The home has many period details including arched doorways and period moldings. To top it off there is also 2 car side by side parking & driveway
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
hoa_fee_includes__c, Trash,Heat,Homeowners Insurance
pba__hoafees__c, 0
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2022-01-25T15:39:46.000+0000
pba__latitude_pb__c, 37.777899
pba__latitude_property__c, 37.777899
laundry_appliances__c, In Garage
laundry_features__c, In Garage
listed_date__c, 2020-11-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bob
pba__listing_agent_lastname__c, Walker
listing_agent_mls_id__c, 805915
ffd_listingagentname, Bob Walker
listing_agent_number__c, 181518448
listing_co_agent_mls_id__c, 038605
listing_co_agent_number__c, 38605
listing_co_office_mls_id__c, GMGA
listing_co_office_name__c, GM Green Real Estate, Inc.
listing_co_office_number__c, 1151
listing_office_mls_id__c, GMGA
listing_office_name__c, GM Green Real Estate, Inc.
listing_office_number__c, 1151
pba__listingprice_pb__c, 1475000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.2940turk.com/mls
pba__longitude_pb__c, -122.45409
pba__lotsize_pb__c, 0
mls_id__c, 509572
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I00000BEQYxUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-11-10
original_price__c, 1475000
overall_days_on_market__c, 141
parking_access__c, Side by Side
parking_features__c, Side-by-Side,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-11-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 933.72
pba__propertytype__c, Condominium
id, a0E1I00000TVEOSUA5
sale_date__c, 2020-12-10
sale_price__c, 1620000
selling_agent_mls_id__c, 804302
selling_agent_name__c, Tim Farrell
selling_agent_number__c, 166013814
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, 1735
size__c, 1735
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Turk
subdist__c, Lone Mountain
ffd_name, 2940 Turk Boulevard, San Francisco, CA, 94118
transportation__c, 1 Block
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/373555-1.jpg
ListingId, a0E1I00000TVEOSUA5