meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219164' 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, 2883 Turk Boulevard, San Francisco, CA, 94118
ffd_mls_id, 421555361
ffd_salesforce_id, a0E1I00000UUrpyUAD
num_of_fireplaces__c, 2
num_of_rooms__c, 9
of_units__c, 0
address2__c, 2883 Turk Boulevard, San Francisco, CA, 94118
pba__address_pb__c, 2883 Turk Boulevard, San Francisco, CA, 94118
agent_only_remarks__c, Video:https://youtu.be/OC4xg-5r328 for 3D Matterport: https://my.matterport.com/show/?m=sfQhPvCWG5U. This property is Temporary taking off the market till further notice. Pls call L// A Betty Sun Wong for details. City records lists property as 2 legal units. A new owner may like previous owner had in the past, choose to use the entire building as a single dwelling unit. As such, this property is entered as a SFH and a two unit property in MLS. Fireplaces has not tested. Buyers are advised to hire professional specialists for inspection of all features important to Buyer. Termite Inspection by Lingruen, Home inspection report on file.
appliances__c, Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Marina
bath_features__c, Other
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-07-12
ffd_createddate, 2021-07-09T10:54:50.000+0000
days_on_market__c, 774
dom__c, 18
ffd_description_pb, First time on market in 5 decades. Built in 1939 as 2 different size units. Now for sale as an updated immaculately finished, light filled property in Lone Mountain. Sits directly across from internationally know USF (University of San Francisco), and a few blocks from Rossi Park and USF's Koret Heath & Recreation Center. The adjacent neighborhoods are Jordan Pk, Inner Richmond, and NOPA (North of the Panhandle). Interior and Exterior newly painted. Larger unit has 2 bedrooms and 1 bath on the main floor and 1 bedroom and 1 bath on the lower level. Neither Seller nor agent warrant he downstairs Bedroom and Bath. Kitchen has new cabinets, appliances, granite countertop, deep double-wide steel sink and new floors. Refinished hardwood floors in living rm, dining rm and breakfast nook complete a classy feel. The Upstairs unit has 1 BR 1 BA,kitchen w/ eating area. Living room and fireplace. Filled with natural light. Perfect for your Buyer who needed space w/ incom. Bright and cheerful
district__c, SF District 1
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;See Remarks
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:53:43.000+0000
pba__latitude_pb__c, 37.777627
pba__latitude_property__c, 37.777627
listed_date__c, 2021-05-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Betty Sun
pba__listing_agent_lastname__c, Wong
listing_agent_mls_id__c, 223445
ffd_listingagentname, Betty S Wong
listing_agent_number__c, 223445
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2250000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=sfQhPvCWG5U
pba__longitude_pb__c, -122.452951
lower_level__c, Bedroom(s),Garage
mls_id__c, 421555361
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-06-05
original_price__c, 2489000
overall_days_on_market__c, 117
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-07-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 889.58
pba__propertytype__c, Single Family Residence
id, a0E1I00000UUrpyUAD
road_surface_type__c, Asphalt
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room
sale_date__c, 2021-07-22
sale_price__c, 2288888
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 803844
selling_agent_number__c, 166013107
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, 2573
size__c, 2573
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Turk
subdist__c, Lone Mountain
ffd_name, 2883 Turk Boulevard, San Francisco, CA, 94118
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
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/530250968-1.jpg
ListingId, a0E1I00000UUrpyUAD