meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331543' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15601
[post_author] => 4
[post_date] => 2018-11-02 02:29:46
[post_date_gmt] => 2018-11-02 02:29:46
[post_content] => Above it all but still in the thick of it, with a great neighborhood dog run, park, and community museum/center. Winding curves, steep hills, jaw-dropping views, sudden changes in direction. You aren't lost. You're in Corona Heights.
[post_title] => Corona Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => corona-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 02:29:46
[post_modified_gmt] => 2018-11-02 02:29:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15601
[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, 71 Uranus 75 Terrace, San Francisco, CA, 94114
ffd_mls_id, 423727260
ffd_salesforce_id, a0E8W00000bcgw7UAA
num_of_rooms__c, 12
of_units__c, 3
address2__c, 71 Uranus 75 Terrace, San Francisco, CA, 94114
pba__address_pb__c, 71 Uranus 75 Terrace, San Francisco, CA, 94114
agent_only_remarks__c, Fully vacant. Go direct via Supra in the utility closet on the ground floor level anytime. Disclosure requests = [email protected]
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range;Varies By Unit;Other
architectural_style__c, Contemporary;Traditional
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 5
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Chris Chour
pba__contingentdate__c, 1800-01-01
cooling__c, Varies by Unit
ffd_createddate, 2023-05-13T00:50:29.000+0000
days_on_market__c, 25
dom__c, 24
ffd_description_pb, Stunning triplex (will be delivered vacant) situated on a prime block in Corona Heights, offering breathtaking postcard views of the city and SF Bay. This gorgeous property comes with multiple private decks, perfect for relaxing and enjoying the stunning views. Perfect for an investor or end-user to make this your view residence with additional income. Location is the best being just minutes away from Cole Valley, and the Castro. A rare find!
district__c, SF District 5
exterior_features__c, Fenced Yard;Yard Space
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Central;Fireplace(s)
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-06-06T00:50:19.000+0000
pba__latitude_pb__c, 37.760939
pba__latitude_property__c, 37.760939
laundry_features__c, In Common Area;Washer/Dryer Owned
listed_date__c, 2023-05-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Heffernan
listing_agent_mls_id__c, 805965
ffd_listingagentname, Tim Heffernan
listing_agent_number__c, 166016071
listing_co_agent_mls_id__c, 816646
listing_co_agent_number__c, 1075602
listing_co_office_mls_id__c, READ
listing_co_office_name__c, Real Estate Advisor Group
listing_co_office_number__c, 27476
listing_office_mls_id__c, READ
listing_office_name__c, Real Estate Advisor Group
listing_office_number__c, 27476
pba__listingprice_pb__c, 1999999
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.445144
mls_id__c, 423727260
parkingspaces__c, 1
on_market_date__c, 2023-05-12
open_house_end__c, 2023-06-10T17:00:00.000+0000
open_house_start__c, 2023-06-10T15:00:00.000+0000
original_price__c, 1999999
overall_days_on_market__c, -81580
parking_features__c, Attached,Garage
patio_and_porch_features__c, Uncovered Deck;Balcony/Deck;Roof Deck(s);Varies by Unit
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 801.28
pba__propertytype__c, Triplex
ListingId, a0E8W00000bcgw7UAA
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, 2496
size__c, 2496
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Uranus
subdist__c, Corona Heights
ffd_name, 71 Uranus 75 Terrace, San Francisco, CA, 94114
view__c, City;Panoramic;Bay;Downtown;Bay Bridge;San Francisco;Mountains;Valley;Mt Diablo;Varies by Unit
website_property_type__c, Triplex
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s);Window Screens;Varies by Unit
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530618016-1.jpg