meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='333010' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 10:38:18
[post_modified_gmt] => 2023-06-23 17:38:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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, 253 Mississippi Street, San Francisco, CA, 94107
ffd_mls_id, 423745477
ffd_salesforce_id, a0E8W00000cJHXGUA4
num_of_rooms__c, 16
of_units__c, 2
address2__c, 253 Mississippi Street, San Francisco, CA, 94107
pba__address_pb__c, 253 Mississippi Street, San Francisco, CA, 94107
agent_only_remarks__c, Please do not use ShowingTime to schedule appointments. Contact Steve directly. Square footage noted is all inclusive.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kevin S Caravelli
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-06-08T21:50:59.000+0000
days_on_market__c, 114
dom__c, 98
ffd_description_pb, The units consist of 2 full floor flats. Unit 253 has 3 bedrooms and 1 full bath plus a finished attic. Unit 255 has 2 bedrooms, 1 full bath and an additional half bath. The main floors feature 2 (255) or 3 (253) bedrooms, a large living room with fireplace, formal dining room, eat-in kitchen gas stoves, ample cabinet space with a pantry, and separate room with washer and dryer hook-ups. There is a complete finished basement living area featuring 3 bedrooms and 1 bath. This area opens directly to the rear patio and garden. Downtown & City views from the upper floors Garden includes fruit trees and space for outdoor entertainment. Common Features include hardwood floors, forced air heat, individual updated electrical and gas services and hot water heaters. The property has had extensive work and upgrades to the exterior structure. Distinctive Victorian trim and moldings and high ceilings. Overall, the property is well maintained and offers a buyer the opportunity for future development into condos, or a multifamily compound.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Electric;Gas
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-09-28T02:52:21.000+0000
pba__latitude_pb__c, 37.762977
pba__latitude_property__c, 37.762977
laundry_features__c, In Each Unit;Washer/Dryer Owned
listed_date__c, 2023-06-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Steven
pba__listing_agent_lastname__c, Caravelli
listing_agent_mls_id__c, 216880
ffd_listingagentname, Steven Caravelli
listing_agent_number__c, 216880
listing_co_agent_mls_id__c, 811226
listing_co_agent_number__c, 1050570
listing_co_office_mls_id__c, CBCNRT
listing_co_office_name__c, Coldwell Banker Commercial Realty
listing_co_office_number__c, 28098
listing_office_mls_id__c, CBCNRT
listing_office_name__c, Coldwell Banker Commercial Realty
listing_office_number__c, 28098
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.253-255mississippi.com/
pba__longitude_pb__c, -122.394309
mls_id__c, 423745477
parkingspaces__c, 0
on_market_date__c, 2023-06-05
original_price__c, 2150000
overall_days_on_market__c, -81604
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 326.07
pba__propertytype__c, Duplex
ListingId, a0E8W00000cJHXGUA4
roof__c, Shingle
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 5505
size__c, 5505
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Mississippi
subdist__c, Potrero Hill
ffd_name, 253 Mississippi Street, San Francisco, CA, 94107
view__c, City;Bay;Downtown
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530630606-1.jpg