meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331334' 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, 157 States Street, San Francisco, CA, 94114
ffd_mls_id, 423731229
ffd_salesforce_id, a0E8W00000bbVIYUA2
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 157 States Street, San Francisco, CA, 94114
pba__address_pb__c, 157 States Street, San Francisco, CA, 94114
agent_only_remarks__c, www.157States.com Pre-escrow opened with Kallie Castro ([email protected]) at First American Title. Limited pre-market showing availability, some work still being done. Please don't text/call - book showings through Calendly - https://calendly.com/helena7x7/157-states-showing-schedule
appliances__c, Dishwasher;Hood Over Range
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-04-20T18:48:10.000+0000
days_on_market__c, 90
dom__c, 8
ffd_description_pb, Discover the newest home by Eastwood Development with spectacular city views, luxurious finishes, and an unbeatable location in the heart of Corona Heights. This meticulously rebuilt, three-level home features 4 bedrooms, dedicated office, rec-room, 3 baths, two powder rooms and a host of modern amenities. Enjoy panoramic city views from every floor, designer lighting, white oak flooring, and calacatta crema countertops that exude sophistication and style. Entertain guests on the landscaped and wind-protected backyard patio with mature trees and plants, perfect for outdoor living. The primary bedroom boasts oversized custom windows, a spa-like en-suite bath, and a walk-in closet. A dedicated office provides versatility, and a large rec room is perfect for relaxing, working out play time. With outdoor access from both living levels, you can enjoy the best of indoor/outdoor living. The location is unbeatable, with easy access to Corona Heights Park and its breathtaking views. Enjoy one-car garage parking with charging capability and owned solar panels. This is the perfect home for those who appreciate quality, style, and a central, sunny location.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2023-07-13T18:44:10.000+0000
pba__latitude_pb__c, 37.7632811
pba__latitude_property__c, 37.7632811
laundry_features__c, Laundry Closet
listed_date__c, 2022-09-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helena
pba__listing_agent_lastname__c, Zaludova
listing_agent_mls_id__c, 804652
ffd_listingagentname, Helena Zaludova
listing_agent_number__c, 166014293
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 5600000
pba__listingtype__c, Sale
pba__listing_website__c, https://live7x7-my.sharepoint.com/:v:/p/helena/ESp_vkKG-9NJuNtkZmPxbuEBlCxo31SlQ_SifprNbZeBYw?e=er9kAI
pba__longitude_pb__c, -122.4387362
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Partial Bath(s),Retreat
mls_id__c, 423731229
main_level__c, Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Soaking Tub;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-20
original_price__c, 5600000
overall_days_on_market__c, -81558
parking_access__c, Independent
parking_features__c, Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-04-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1704.72
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbVIYUA2
room_type__c, Den;Library;Great Room
sale_date__c, 2023-05-10
sale_price__c, 5600000
selling_agent_mls_id__c, 810513
selling_agent_number__c, 1046592
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3285
size__c, 3285
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, States
subdist__c, Corona Heights
ffd_name, 157 States Street, San Francisco, CA, 94114
view__c, City
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530604300_5b6decde-cae0-4991-bf34-5f84aec5fcbc.jpg
