meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332629' 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] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[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, 1546 18th 1548 Street, San Francisco, CA, 94107
ffd_mls_id, 423745485
ffd_salesforce_id, a0E8W00000cIzkhUAC
num_of_rooms__c, 12
of_units__c, 2
address2__c, 1546 18th 1548 Street, San Francisco, CA, 94107
pba__address_pb__c, 1546 18th 1548 Street, San Francisco, CA, 94107
agent_only_remarks__c, One of the sellers is a licensed real estate broker acting as agent. Rear cottage is occupied by one of the sellers as an office. Access is through side door to patio. Please knock on door before entering. Leave side door to cottage unlocked. Seller will rent back cottage if buyer is looking for some immediate income. Please use WFG National Title, Steve Salviejo,escrow#23-135065. For more info call Mario Flores 415-608-8571 or Lynn Aurelio 415-298-2488. Neither seller nor agents warrant legality of cottage.Lockbox & open 6/10 1:00-4:00 and 6/11 1:00-4:00. Disclosures available in Disclosures.IO Link: https://app.disclosures.io/link/15461548-18th-St-gd8jef7o
appliances__c, Dishwasher;Insulated Water Heater;Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Ice Maker;Self/Cont Clean Oven;Free Standing Electric Oven;Free Standing Electric Range;Plumbed For Ice Maker;Varies By Unit
architectural_style__c, Victorian;Cottage;Other
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, Lynn T Aurelio
pba__contingentdate__c, 2023-06-11
cooling__c, Ceiling Fan(s),Room Air,Varies by Unit,Whole House Fan
ffd_createddate, 2023-06-01T18:50:13.000+0000
days_on_market__c, 55
dom__c, 53
ffd_description_pb, Great opportunity for owner/investor in much sought after Potrero Hill location. Steps to shops, parks restaurants and transportation. Two bedroom 1 bath updated units. Full basement with storage, rear patio and unwarranted cottage. Possible condo conversion or up to 6 units on the lot under current city guidelines. Check with the city building department for current guidelines.
district__c, SF District 9
electric__c, 220 Volts
exterior_features__c, Fenced Yard;Yard Space
external_listing__c, 1
pba__floortype_pb__c, Carpet;Laminate;Linoleum;Tile;Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Hot Water;Central;Gas;Natural Gas;MultiUnits
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-07-27T01:48:49.000+0000
pba__latitude_pb__c, 37.762663
pba__latitude_property__c, 37.762663
laundry_features__c, Washer/Dryer Hookups;Washer/Dryer Owned
listed_date__c, 2023-06-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mario
pba__listing_agent_lastname__c, Flores
listing_agent_mls_id__c, 215789
ffd_listingagentname, Mario F Flores
listing_agent_number__c, 215789
listing_co_agent_mls_id__c, 215753
listing_co_agent_number__c, 215753
listing_co_office_mls_id__c, C-BA
listing_co_office_name__c, Century 21 Baldini Realty
listing_co_office_number__c, 770
listing_office_mls_id__c, C-BA
listing_office_name__c, Century 21 Baldini Realty
listing_office_number__c, 770
pba__listingprice_pb__c, 1650000
pba__listingtype__c, Sale
pba__listing_website__c, http://youtu.be/66a9W2Oph-g
pba__longitude_pb__c, -122.398297
mls_id__c, 423745485
parkingspaces__c, 0
on_market_date__c, 2023-06-01
original_price__c, 1650000
overall_days_on_market__c, -81600
patio_and_porch_features__c, Uncovered Patio;Varies by Unit
pba__pendingdate__c, 2023-07-24
price_per_square_foot__c, 733.94
pba__propertytype__c, Duplex
ListingId, a0E8W00000cIzkhUAC
roof__c, Tar/Gravel;Composition;Flat
sale_date__c, 2023-07-25
sale_price__c, 1600000
security_features__c, Smoke Detector;Security Gate;Security Fence;Fire Extinguisher;Varies By Unit;Carbon Mon Detector;Double Strapped Water Heater;Security Lights
selling_agent_mls_id__c, 215789
selling_agent_number__c, 215789
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Century 21 Baldini Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2180
size__c, 2180
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 18th
subdist__c, Potrero Hill
ffd_name, 1546 18th 1548 Street, San Francisco, CA, 94107
website_property_type__c, Duplex
window_features__c, Window Coverings;Dual Pane Partial;Window Screens;Varies by Unit;Weather Stripped
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/530626822-1.jpg