meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212347' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 457 Hill Street, San Francisco, CA, 94114
ffd_mls_id, 498534
ffd_salesforce_id, a0E1I00000Sm4vdUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 457 Hill Street, San Francisco, CA, 94114
pba__address_pb__c, 457 Hill Street, San Francisco, CA, 94114
agent_only_remarks__c, Escrow open with Michelle Patterson with First American Title. For showings contact Walter Johnson 415-298-5332 or [email protected]
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Remodeled
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Walter J Johnson
pba__contingentdate__c, 2020-06-08
ffd_createddate, 2020-05-25T18:45:32.000+0000
days_on_market__c, 1150
dom__c, 17
ffd_description_pb, Located in the coveted Liberty Hill neighborhood, 457 Hill Street has old world charm, with a contemporary interior with open floor plan and great flow. The south facing windows bathe the main living area with light all day and they provide you amazing views to the south and east. The beautiful kitchen comes equipped with new stainless Thermador and Bosch appliances, granite countertops and looks onto the living and dining areas. To complete the main floor you have a guest bedroom just off the entrance of the home and a full bath that has been fully remodeled. The downstairs master suite features an oversized bathroom with walk in shower and dual shower heads. The large master suite has a walk-in closet, and French doors that lead to just one of the 3 decks in the rear landscaped garden. Steps down you have two more decks and views to the south. New solar that produces more energy than needed. Easy walk to 24th St., Dolores Park, Castro and Valencia Corridor.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning;Gas Piped
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:23:06.000+0000
pba__latitude_pb__c, 37.75524
pba__latitude_property__c, 37.75524
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-05-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Nolan
listing_agent_mls_id__c, 803037
ffd_listingagentname, Frank A Nolan
listing_agent_number__c, 803037
listing_co_agent_mls_id__c, 809688
listing_co_agent_number__c, 1042733
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.457hillstreet.com/
pba__longitude_pb__c, -122.43132
pba__lotsize_pb__c, 0.07
lower_level__c, Master Bedroom
mls_id__c, 498534
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-25
original_price__c, 2495000
overall_days_on_market__c, 109
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-06-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1486.78
pba__propertytype__c, Single Family Residence
id, a0E1I00000Sm4vdUAB
roof__c, Composition
room_type__c, Laundry
sale_date__c, 2020-06-26
sale_price__c, 2700000
security_features__c, Security Alarm(s)
selling_agent_mls_id__c, 502811
selling_agent_name__c, Linda S. Gordon
selling_agent_number__c, 502811
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1816
size__c, 1816
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Hill
subdist__c, The Castro - Dolores Heights
ffd_name, 457 Hill Street, San Francisco, CA, 94114
view__c, Panoramic;Bay;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane
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/363449-1.jpg
ListingId, a0E1I00000Sm4vdUAB