meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331560' 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] => 2018-11-30 20:30:26
[post_modified_gmt] => 2018-11-30 20:30:26
[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, 2254 Fulton 2256 Street, San Francisco, CA, 94117
ffd_mls_id, 423741737
ffd_salesforce_id, a0E8W00000bchhdUAA
num_of_rooms__c, 19
of_units__c, 2
address2__c, 2254 Fulton 2256 Street, San Francisco, CA, 94117
pba__address_pb__c, 2254 Fulton 2256 Street, San Francisco, CA, 94117
agent_only_remarks__c, A full basement with good ceiling height offers further development potential. Can show upper unit #2254 easily. Scheduled open house and tour times available to see seller occupied unit #2256, otherwise will need 24-hour notice to show qualified buyers. Agents have additional photos of the Seller occupied unit for Buyers to view prior to calendaring a private appointment. Call/Text MaryAnn for showings. #2256 is 4 bed, 2 bath; #2254 is 5 bed, 3 bath. Dining Chandelier in #2254 does not convey with property. ***#2254 upstairs 2-level townhome TIC interest for sale separately, offered at $1.495M with the Buyer and Seller to cooperate in TIC agreement creation*** More info at www.2254fulton.com
appliances__c, Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Gas Range
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 9
year_build_text__c, 1902
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mary Ann Montano
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-13T10:50:21.000+0000
days_on_market__c, 19
dom__c, 18
ffd_description_pb, The possibilities are endless! Possible condo conversion? Possible ADU? Possible garage? Large scale, 2-unit building offering 5610 square feet (per tax records) of living space plus a full tall basement, view balcony and garden. Beautifully maintained over the last 50+ years by the same family. Grand old San Francisco Victorian architecture features gorgeous hardwood floors, high ceilings, detailed wainscotting, ornate moldings and trim and exquisite fireplaces on each level. Both units are light and bright. Unit #2256 is a full floor flat with 4 bedrooms, 2 baths, kitchen, laundry room, formal dining room, living room with fireplace. Unit #2254 is a 2-level 5-bedroom, 3-bath townhome and includes living room plus large family room, roof-top balcony with Golden Gate, Marin Headlands and City views. Updated systems in the 80's and 90's include plumbing, electrical and many windows it still retains historic charm. A perfect location offers Golden Gate Park at your front doorstep with the USF campus nearby. Easy public transportation and private shuttles nearby. Whole Foods and Cole Valley, NOPA and the Haight are just a few blocks away.
district__c, SF District 1
exterior_features__c, Fenced Yard;Yard Space
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s);Vaulted Ceiling(s)
ffd_lastmodifieddate, 2023-05-31T02:49:00.000+0000
pba__latitude_pb__c, 37.775125
pba__latitude_property__c, 37.775125
laundry_features__c, Laundry Closet;In Each Unit;Washer/Dryer Owned
listed_date__c, 2023-05-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dona
pba__listing_agent_lastname__c, Crowder
listing_agent_mls_id__c, 039695
ffd_listingagentname, Dona Crowder
listing_agent_number__c, 39695
listing_co_agent_mls_id__c, 808878
listing_co_agent_number__c, 1038181
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 2735000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.2254fulton.com
pba__longitude_pb__c, -122.453858
mls_id__c, 423741737
parkingspaces__c, 0
on_market_date__c, 2023-05-12
open_house_end__c, 2023-05-30T13:00:00.000+0000
open_house_start__c, 2023-05-30T11:00:00.000+0000
original_price__c, 2735000
overall_days_on_market__c, -81580
patio_and_porch_features__c, Balcony/Deck;Roof Deck(s);Varies by Unit
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 487.52
pba__propertytype__c, Duplex
ListingId, a0E8W00000bchhdUAA
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 5610
size__c, 5610
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Fulton
subdist__c, Lone Mountain
ffd_name, 2254 Fulton 2256 Street, San Francisco, CA, 94117
view__c, Ocean;Bay;San Francisco;Golden Gate Bridge;Mountains;Varies by Unit
website_property_type__c, Duplex
window_features__c, Window Coverings;Bay Window(s);Varies by Unit
pba__yearbuilt_pb__c, 1902
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530618168-1.jpg