meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210949' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 02:53:28
[post_modified_gmt] => 2022-12-05 10:53:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 151 Bartlett 153 Street, San Francisco, CA, 94110
ffd_mls_id, 506369
ffd_salesforce_id, a0E1I00000THlDNUA1
vacant__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 151 Bartlett 153 Street, San Francisco, CA, 94110
pba__address_pb__c, 151 Bartlett 153 Street, San Francisco, CA, 94110
agent_only_remarks__c, Call/ Text Gene at 415-203-1916 with any questions Appointment only. No Lock box. Vacant areas easy to show. Signed PEAD form /Own personals protective equipment required. Disclosure package available after viewing. One tenant occupied unit viewing once offer is accepted. Escrow with First American title/Nick Shanta. Note: Tax records show building as 2328 SQ FT. Measuring service calculated 2803 SQ FT for living area, 596 SQ FT for Garage area, plus 755 SQ FT for bonus/ unwarranted rooms with functioning bath area on ground floor. Potential TIC to Condo conversion possibility. Buyer(s) to verify.
appliances__c, Dishwasher;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-26
ffd_createddate, 2020-09-18T22:55:02.000+0000
days_on_market__c, 888
dom__c, 204
ffd_description_pb, Over 120K in listing price improvements! Elegant, spacious Victorian Duplex ready to be rejuvenated to its full potential. Nestled in the western part of the Mission District on Bartlett Street, offering 2 spacious full floor flats totaling 2803 SQ FT of living space (as per measuring service; differs from assessor records). Flats have high ceilings, spacious floor plan and traditional period detail. Large garage plus additional bonus area on the ground floor that offers home office or some other possibilities. Upper flat, garage and bonus space rooms/ bath adjacent to the garage are all Vacant. Explore possibilities of restoration, income potential, TIC ownership, or further condo conversion potential. Amazing location with nearby Valencia Street eateries and conveniences, transportation, BART and Thursday's Farmers Market around the corner. Bike score 99 and Walk score 100. Come see!
district__c, SF District 9
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Linoleum;Tile;Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Skylight(s);Storage Area(s);Vaulted Ceiling(s)
ffd_lastmodifieddate, 2023-02-22T23:51:27.000+0000
pba__latitude_pb__c, 37.754568
pba__latitude_property__c, 37.754568
laundry_features__c, Washer/Dryer Hookups
listed_date__c, 2020-09-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gene
pba__listing_agent_lastname__c, Gorokhovsky
listing_agent_mls_id__c, 802485
ffd_listingagentname, Gene Gorokhovsky
listing_agent_number__c, 802485
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, LUXE
listing_office_name__c, Luxe Places International Realty
listing_office_number__c, 28202
pba__listingprice_pb__c, 1875000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.419461
pba__lotsize_pb__c, 0.07
mls_id__c, 506369
master_property__c, a0O8W00000DaF41UAF
parkingspaces__c, 2
on_market_date__c, 2020-09-18
original_price__c, 1997000
overall_days_on_market__c, -80614
parking__c, Garage
parking_features__c, Garage
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2021-04-16
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 642.17
pba__propertytype__c, Duplex
id, a0E1I00000THlDNUA1
roof__c, Tar/Gravel
sale_date__c, 2021-05-03
sale_price__c, 1800000
selling_agent_mls_id__c, 803878
selling_agent_number__c, 166013231
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2803
size__c, 2803
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bartlett
style__c, Victorian
subdist__c, The Mission
ffd_name, 151 Bartlett 153 Street, San Francisco, CA, 94110
type__c, Flats,Duplex
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370593-1.jpg
ListingId, a0E1I00000THlDNUA1