meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336807' 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] => 2024-03-19 13:40:29
[post_modified_gmt] => 2024-03-19 20:40:29
[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, a0E8W00000bkhYzUAI
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, [email protected] for any questions
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
pba__contingentdate__c, 1800-01-01
cooling__c, Varies by Unit
ffd_createddate, 2023-07-15T19:48:14.000+0000
days_on_market__c, 108
dom__c, 32
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-08-28T21:27:56.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_number__c, 0
listing_co_office_number__c, 0
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
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, 2023-06-13
price_per_square_foot__c, 771.23
pba__propertytype__c, Triplex
ListingId, a0E8W00000bkhYzUAI
sale_date__c, 2023-08-11
sale_price__c, 1925000
selling_agent_mls_id__c, 816646
selling_agent_number__c, 1075602
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Estate Advisor Group
pba__status__c, Closed
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