meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214900' 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, 2257 Fulton Street, San Francisco, CA, 94117
ffd_mls_id, 506328
ffd_salesforce_id, a0E1I00000THlOgUAL
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 3
address2__c, 2257 Fulton Street, San Francisco, CA, 94117
pba__address_pb__c, 2257 Fulton Street, San Francisco, CA, 94117
agent_only_remarks__c, Questions to: [email protected] Please do not call or text. Offers due by 10:00 AM on Oct 1. See the COVERSHEET in D.IO for full instructions. Viewings by appointment only. To schedule, follow this link:https://www.signupgenius.com/go/70A0A45AAAB2DABF85-2257 If the button in the listing does not work for you, disclosures are at: https://app.disclosures.io/link/2257-Fulton-Street-of1e4exj
appliances__c, Dishwasher;Gas Range;Refrigerator;Freezer;Built-In Oven
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-19T19:48:38.000+0000
days_on_market__c, 1034
dom__c, 14
ffd_description_pb, This large, full floor, 2 bedroom / 2 bath flat is a classic San Francisco Edwardian, featuring hardwood floors, high, coved ceilings, two fireplaces, and coveted period details. Enjoy substantial upgrades throughout, including fully renovating the kitchen and removing the wall to the dining room, creating a beautiful open floorplan. Both bathrooms were also updated, and the house has recently been freshly painted and fixtures upgraded. Major structural and seismic upgrades including moment frames and a poured in place foundation. Finally, the rear yard has been lovingly redesigned, and features lush, irrigated greenery, night lighting, peaceful seating areas, a gas grill, bar and firepit. The attached garage has a deeded parking space, storage shelves, accessed from front or rear exterior doors. Less than a block from Golden Gate Park and USF.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Dining Room
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 384
hoa_fee_includes__c, Trash,Maintenance Grounds,Water
pba__hoafees__c, 384
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2225-2259 Fulton St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:35:04.000+0000
pba__latitude_pb__c, 37.774567
pba__latitude_property__c, 37.774567
laundry_appliances__c, Washer/Dryer,In Laundry Room
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Craig
pba__listing_agent_lastname__c, Ackerman
listing_agent_mls_id__c, 804180
ffd_listingagentname, Craig Ackerman
listing_agent_number__c, 166013654
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDR
listing_office_name__c, Ackerman Realty Group
listing_office_number__c, 166013114
pba__listingprice_pb__c, 1199000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.2257fulton.com
pba__longitude_pb__c, -122.453919
pba__lotsize_pb__c, 0
mls_id__c, 506328
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VXeKUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-18
original_price__c, 1199000
overall_days_on_market__c, 104
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-10-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000THlOgUAL
room_type__c, Storage;Laundry
sale_date__c, 2020-10-28
sale_price__c, 1350000
selling_agent_mls_id__c, 805161
selling_agent_name__c, Annie W. Chang
selling_agent_number__c, 199019491
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sequoia Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fulton
subdist__c, Lone Mountain
ffd_name, 2257 Fulton Street, San Francisco, CA, 94117
transportation__c, 1 Block
view__c, City Lights
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370657-1.jpg
ListingId, a0E1I00000THlOgUAL