meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329027' 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] => 2018-11-02 19:54:27
[post_modified_gmt] => 2018-11-02 19:54:27
[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, 2238 23rd Street, San Francisco, CA, 94107
ffd_mls_id, 423730719
ffd_salesforce_id, a0E8W00000baUKPUA2
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 2
address2__c, 2238 23rd Street, San Francisco, CA, 94107
pba__address_pb__c, 2238 23rd Street, San Francisco, CA, 94107
agent_only_remarks__c, Upper unit also available for $1,199,000 to show by appointment. According to seller: Common bonus room + bathroom has consistently brought in $2500/month of supplemental income through short-midterm with traveling medical medical staff.
appliances__c, Gas Water Heater;Disposal;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Derek M Jackson
pba__contingentdate__c, 1800-01-01
cooling__c, Ceiling Fan(s)
ffd_createddate, 2023-03-31T10:49:48.000+0000
days_on_market__c, 63
dom__c, 62
ffd_description_pb, PRICE ADJUSTMENT: Look no further! This spacious Victorian 2-bedroom, 1-bathroom flat in Sunny Potrero Hill perfectly blends the charm of a classic Victorian facade with modern form and function. Major systems upgrades of the electrical and plumbing, heating, & dual pane windows throughout. The high ceilings, southern exposure, and large eat-in kitchen leading to a massive sunroom create a bright and airy living space. Potrero Hill offers one of the best micro climates in SF, along with fantastic eats and treats along 18th and 24th street corridors, easy shopping at Whole Foods, and so much more! EZ access to HWY 101/ 280 and Caltrain. Common amenities include: Rotating parking (1 garage / 1 blocks driveway), a large rec room + bath, and groovy backyard. See Agent Notes for more information. Fast Track condo conversion duplex. FOr salwe as whole building or individual TIC units.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-06-02T01:48:45.000+0000
pba__latitude_pb__c, 37.754756
pba__latitude_property__c, 37.754756
laundry_features__c, Inside Room;Washer Included;Gas Hook-Up
listed_date__c, 2023-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Morton
listing_agent_mls_id__c, 804736
ffd_listingagentname, Scott E Morton
listing_agent_number__c, 166014407
listing_co_agent_mls_id__c, 810859
listing_co_agent_number__c, 1048512
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, 1049000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.402312
mls_id__c, 423730719
main_level__c, Bedroom(s);Living Room
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-31
open_house_end__c, 2023-06-04T16:00:00.000+0000
open_house_start__c, 2023-06-04T14:00:00.000+0000
original_price__c, 1099000
overall_days_on_market__c, -81538
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, Other
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 955.37
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000baUKPUA2
road_surface_type__c, Asphalt
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1098
size__c, 1098
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 23rd
subdist__c, Potrero Hill
ffd_name, 2238 23rd Street, San Francisco, CA, 94107
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530596894-1.jpg
