meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319560' 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] => 2018-11-02 19:54:27
[post_modified_gmt] => 2018-11-02 19:54:27
[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 1065 Carolina Street, San Francisco, CA, 94107
ffd_mls_id 422705223
ffd_salesforce_id a0E8W00000ZMLKkUAP
num_of_fireplaces__c 2
num_of_rooms__c 8
of_units__c 2
address2__c 1065 Carolina Street, San Francisco, CA, 94107
pba__address_pb__c 1065 Carolina Street, San Francisco, CA, 94107
agent_only_remarks__c Seller is a licensed real estate agent. Owner occupied. Do not disturb occupants.
appliances__c Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator;Compactor
pba__fullbathrooms_pb__c 4
pba__bedrooms_pb__c 4
year_build_text__c 1987
pba__city_pb__c San Francisco
listing_co_agent_name__c Joseph C Silva Gonsalves
pba__contingentdate__c 1800-01-01
ffd_createddate 2022-11-01T20:46:14.000+0000
days_on_market__c 84
dom__c 83
ffd_description_pb Pride of ownership is evident when you open the front door of this 4bedroom and 4bath updated condo in a two-unit building. The home combines two units and can be enjoyed by visiting family or one larger family to enjoy the top two building levels. Three spacious balconies and a large deck with seating and dining overlooking spectacular views of San Francisco. The neighborhood is between Potrero Hill restaurants on 18th street and inner Mission restaurants on 24th street. SFGH is a short walk. Close to freeways and public transportation. Quiet street with lots of parking. This home is a must-see to appreciate!
district__c SF District 9
entry_level__c 0
exterior_features__c Balcony
external_listing__c 1
fireplace_features__c Wood Burning;Family Room
pba__floortype_pb__c Carpet;Wood
hoa_fee_includes__c Common Areas,Insurance on Structure,Maintenance Grounds,Water,Other
pba__hoafees__c 483
pba__hoafrequency_pb__c Monthly
hoa__c Yes
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Electric
interior_features__c Wet Bar
ffd_lastmodifieddate 2023-01-24T02:45:35.000+0000
pba__latitude_pb__c 37.755309
pba__latitude_property__c 37.755309
laundry_features__c Inside Room;Ground Floor;Washer Included;Dryer Included
listed_date__c 2022-09-27
pba__listing_agent_email__c denise.paulson@compass.com
pba__listing_agent_firstname__c Denise
pba__listing_agent_lastname__c Paulson
listing_agent_mls_id__c 802017
ffd_listingagentname Denise L Paulson
listing_agent_number__c 802017
listing_co_agent_mls_id__c 814010
listing_co_agent_number__c 1063918
listing_co_office_mls_id__c COMP38
listing_co_office_name__c Compass
listing_co_office_number__c 27890
listing_office_mls_id__c COMP38
listing_office_name__c Compass
listing_office_number__c 27890
pba__listingprice_pb__c 1699000
pba__listingtype__c Sale
pba__longitude_pb__c -122.39941
mls_id__c 422705223
master_property__c a0O8W00000FsZgWUAV
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2022-11-01
open_house_end__c 2023-01-29T16:00:00.000+0000
open_house_start__c 2023-01-29T14:00:00.000+0000
original_price__c 1799000
overall_days_on_market__c -81388
parking_access__c Side by Side
parking_features__c Enclosed,Garage Door Opener,Interior Access
parking_type__c On Site - Assigned (Condo Only)
patio_and_porch_features__c Uncovered Deck;Enclosed Deck
pba__pendingdate__c 1800-01-01
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 668.63
pba__propertytype__c Condominium
ListingId a0E8W00000ZMLKkUAP
room_type__c Storage;Office
sale_date__c 1800-01-01
sale_price__c 0
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 2541
size__c 2541
pba__state_pb__c CA
stories__c 2
pba__street_pb__c Carolina
subdist__c Potrero Hill
ffd_name 1065 Carolina Street, San Francisco, CA, 94107
view__c Panoramic;City Lights;San Francisco;Twin Peaks;Hills;Mountains;Sutro Tower
website_property_type__c Condominium
window_features__c Window Coverings
pba__yearbuilt_pb__c 1987
pba__postalcode_pb__c 94107
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530549651-1.jpg