meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339964' 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
(
)
)
_yoast_indexnow_last_ping, 1697022532
ffd_listing_title, 212 Texas Street, San Francisco, CA, 94107
ffd_mls_id, 423754117
ffd_salesforce_id, a0E8W00000cqHZdUAM
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 212 Texas Street, San Francisco, CA, 94107
pba__address_pb__c, 212 Texas Street, San Francisco, CA, 94107
agent_only_remarks__c, Please email [email protected] for questions or to schedule a showing. Disclosures are available at https://app.disclosures.io/link/212-Texas-Street-kmgbcu3l. The fridge in the basement is not part of the sale.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Cottage
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-09-04T16:45:59.000+0000
days_on_market__c, 37
dom__c, 11
ffd_description_pb, Located on a prime block of Potrero, 212 Texas is a lovely cottage featuring 2 BR, 1.5 BA & 1 PKG. With a well laid-out floor plan, the home has been thoughtfully designed and offers an open living and dining area bathed in natural light, complemented by a striking MCM gas fireplace that sets the perfect ambiance. The remodeled kitchen effortlessly connects to the yard, creating a seamless indoor-outdoor flow & making it ideal for entertaining guests. The yard itself is a private oasis where you can enjoy the bounty of California fruits with your own Mission fig, Meyer lemon, apple and plum trees. A pull-down ladder in the living room leads to a loft, offering 144 sqft of versatile space for a home office, play area, or additional storage. The 1-car garage includes a large finished storage area, ensuring ample space for your belongings or a workshop. An additional parking pad allows for convenient parking of one more vehicle. Located just around the corner from beloved establishments like Plow, Farley's, and Chez Maman, and within minutes to the lively bars and restaurants of Dogpatch, this home masterfully balances serenity with access to the lively city life.
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-10-11T10:47:31.000+0000
pba__latitude_pb__c, 37.76356
pba__latitude_property__c, 37.76356
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-06-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Isabelle
pba__listing_agent_lastname__c, Grotte
listing_agent_mls_id__c, 807863
ffd_listingagentname, Isabelle Grotte
listing_agent_number__c, 1027872
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=4mz3QHXKJYJ
pba__longitude_pb__c, -122.395961
lower_level__c, Garage,Street Entrance
mls_id__c, 423754117
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-09-04
original_price__c, 1495000
overall_days_on_market__c, -81695
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-09-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-10-10T16:43:32.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cqHZdUAM
room_type__c, Kitchen;Loft;Living Room;Dining Room;Primary Bedroom
sale_date__c, 2023-10-10
sale_price__c, 1685000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 805620
selling_agent_number__c, 166015612
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Engel & Voelkers San Francisco
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, 212 Texas Street, San Francisco, CA, 94107
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530668329-1.jpg