meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237625' 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, 255 Collins 257 Street, San Francisco, CA, 94118
ffd_mls_id, 422678099
ffd_salesforce_id, a0E8W00000YXnQvUAL
num_of_rooms__c, 9
of_units__c, 3
address2__c, 255 Collins 257 Street, San Francisco, CA, 94118
pba__address_pb__c, 255 Collins 257 Street, San Francisco, CA, 94118
agent_only_remarks__c, Fully tenant occupied. Potentially on the market by end of August 2022. Please contact Kevin Wong at 415-290-2927 or Sabrina at 415-290-3378 for questions. Trust sale with long term tenants. Top unit and garden unit tenants are protected. Middle unit has school-age student. Disclosure package is being assembled. Pre-sale escrow with Barbara Jimenez of Chicago Title, escrow #3652200829. Property is COPA compliant.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 6
year_build_text__c, 1908
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sabrina Gee-Shin
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-08-05T10:50:54.000+0000
days_on_market__c, 349
dom__c, 0
ffd_description_pb, Detached on three sides, this Lone Mountain duplex has a great location with a 95 WalkScore and plenty of upside. Top unit 3BD/1BA flat. Middle unit 2BD/1BA flat and has rights to garage space. Garden unit has a 2BD/1BA flat, legality unknown. Shared washer/dryer in garage and large shared yard for expansion possibilities. Tenants at 255A and 257 pay for garbage, PG&E and water, while top unit 255 pays for garbage and PG&E only as there are sub-water meters. This is a great long term investment at a 15 GRM and a 6.6% Gross Cap Rate that can get better over time.
district__c, SF District 1
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-08-22T13:46:15.000+0000
pba__latitude_pb__c, 37.781262
pba__latitude_property__c, 37.781262
laundry_features__c, In Common Area;Washer/Dryer Owned
listed_date__c, 2022-07-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kevin
pba__listing_agent_lastname__c, Wong
listing_agent_mls_id__c, 803845
ffd_listingagentname, Kevin S Wong
listing_agent_number__c, 166013108
listing_co_agent_mls_id__c, 804986
listing_co_agent_number__c, 166014733
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 950000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.450237
mls_id__c, 422678099
parkingspaces__c, 1
on_market_date__c, 2022-08-04
original_price__c, 950000
overall_days_on_market__c, -81299
parking_features__c, Attached,Garage,Garage Door Opener
pba__pendingdate__c, 2022-08-04
price_per_square_foot__c, 446.43
pba__propertytype__c, Duplex
ListingId, a0E8W00000YXnQvUAL
roof__c, Bitumen
sale_date__c, 2022-08-19
sale_price__c, 1200000
selling_agent_mls_id__c, 805322
selling_agent_number__c, 166015212
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2688
size__c, 2688
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Collins
subdist__c, Lone Mountain
ffd_name, 255 Collins 257 Street, San Francisco, CA, 94118
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530495841-1.jpg