meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218103' 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] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[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, 607 Texas Street, San Francisco, CA, 94107
ffd_mls_id, 421523048
ffd_salesforce_id, a0E1I00000TxponUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 607 Texas Street, San Francisco, CA, 94107
pba__address_pb__c, 607 Texas Street, San Francisco, CA, 94107
agent_only_remarks__c, OFFER's if any welcomed 4/13 at 1pm Please provide your own PPE supplies. COVID compliant appts. available on Calendly: https://calendly.com/claudiasf/607-texas-street?month=2021-04. Offer date TBD. Please no pre-emptive offers per Sellers. Pre-sale escrow opened with Joanne Kung at Chicago Title. Will furnish lockbox code after PEAD is sent. Sellers have loved living in this this home for over 23 years. Website: 607TexasSt.com
appliances__c, Dishwasher;Free Standing Gas Oven;Free Standing Refrigerator;Ice Maker
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1907
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-06T18:38:25.000+0000
days_on_market__c, 834
dom__c, 9
ffd_description_pb, A Potrero Hill Gem! A light filled move in ready home with easy flow and livability. Large open kitchen with beautiful walk out deck and sunny flat garden. Perfect for enjoying the best weather in the city. Main floor has 2 bedrooms and 1 full bath. Hardwood floors with unique geometric inlay shows the history of the home. The airy and open eat-in kitchen boasts a large island and a sliding glass door opens to the walk out deck and deep landscaped garden, making entertaining and enjoying the outdoor space a breeze. Downstairs (accessed from rear exterior stairs) is a large unwarranted space; featuring a living area, bedroom, full bath, kitchen area plus a separate entrance. The landscaped garden has a Meyer lemon tree, a Cherry tree, beautiful roses, a patio, 2 seating areas and an adorable potting shed that can be used as an office, writing space, or a play space. The White Birch tree in the rear of the garden serves as a stunning anchor. Enjoy the magic of Potrero Hill!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Wood;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:48:58.000+0000
pba__latitude_pb__c, 37.758708
pba__latitude_property__c, 37.758708
laundry_features__c, In Garage;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2021-03-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Claudia
pba__listing_agent_lastname__c, Siegel
listing_agent_mls_id__c, 804416
ffd_listingagentname, Claudia L Siegel
listing_agent_number__c, 166013962
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, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/532590843
pba__longitude_pb__c, -122.394873
lower_level__c, Bedroom(s),Full Bath(s),Living Room,Street Entrance
mls_id__c, 421523048
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-06
original_price__c, 1295000
overall_days_on_market__c, 169
parking_access__c, Independent
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-04-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxponUAB
road_surface_type__c, Asphalt
roof__c, Shingle
room_type__c, Bonus Room;Kitchen;In Law Apartment;Living Room;Guest Quarters;Workshop
sale_date__c, 2021-05-13
sale_price__c, 1750000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 811377
selling_agent_number__c, 1051265
selling_co_agent_mls_id__c, 806718
selling_co_agent_number__c, 166017501
selling_co_office_mls_id__c, BRAVA
selling_co_office_name__c, Brava Real Estate
selling_co_office_number__c, 28638
selling_office_name__c, Brava Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Texas
subdist__c, Potrero Hill
ffd_name, 607 Texas Street, San Francisco, CA, 94107
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530213123-1.jpg
ListingId, a0E1I00000TxponUAB
