meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215111' 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, 1076 Rhode Island Street, San Francisco, CA, 94107
ffd_mls_id, 506996
ffd_salesforce_id, a0E1I00000THqOEUA1
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1076 Rhode Island Street, San Francisco, CA, 94107
pba__address_pb__c, 1076 Rhode Island Street, San Francisco, CA, 94107
agent_only_remarks__c, Transparent Pricing. Selling As Is. Vacant and ready for your Buyers and/or Developers. We have contractor plans for expansion but they expired earlier in 2020. COVID compliant private showings available. Text Mark at 415.955.7968 or Susanne 510.773.0640 to schedule an appointment. Proof of Funds or Pre-Approval Required Prior to Showing along with PEAD Form. Email PEAD to Deena Adkins ([email protected])to confirm showing appointment. *Virtually Staged*
appliances__c, Dishwasher;Gas Range;Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Susanne Alexander
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-30T10:46:14.000+0000
days_on_market__c, 1022
dom__c, 35
ffd_description_pb, This spacious 3bed/2bath single-family home in Potrero Hill provides BIG VIEWS, and is ready for you to add your personal style or take advantage of its RH-2 zoning. The first floor features a kitchen, two bedrooms, a full bathroom, and open concept living and dining areas that extend out to a sizeable deck with sweeping westerly views where you can watch the fog hover over Twin Peaks or the colors of each sunset. It's the perfect spot to entertain. The second lower floor offers a family room/office, a third bedroom, a second bathroom, laundry, and another large deck with the same westerly views. One-car garage, and yet another deck leading to a large yard that's ready for your green thumb. With some of the best weather in SF, and easy access to schools, freeways, SF General, and CalTrain, this place is looking for its next owner! Virtually Staged Selling As Is.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:35:53.000+0000
pba__latitude_pb__c, 37.7561691
pba__latitude_property__c, 37.7561691
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Venegas
listing_agent_mls_id__c, 808359
ffd_listingagentname, Mark A Venegas
listing_agent_number__c, 1033957
listing_co_agent_mls_id__c, 809677
listing_co_agent_number__c, 1042664
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1625000
pba__listingtype__c, Sale
pba__listing_website__c, https://1076RhodeIsland31395.f8re.com/
pba__longitude_pb__c, -122.4019848
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 506996
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-09-30
original_price__c, 1798000
overall_days_on_market__c, 181
parking__c, Attached,Garage
parking_access__c, Independent
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-11-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 902.78
pba__propertytype__c, Single Family Residence
id, a0E1I00000THqOEUA1
sale_date__c, 2020-11-30
sale_price__c, 1625000
selling_agent_mls_id__c, 812593
selling_agent_name__c, Charlene T. Gueco
selling_agent_number__c, 1057212
selling_co_agent_mls_id__c, 815058
selling_co_agent_name__c, Catherine Abalos
selling_co_agent_number__c, 1070430
selling_co_office_mls_id__c, KINOKO
selling_co_office_name__c, Kinoko
selling_co_office_number__c, 27835
selling_office_name__c, Kinoko
pba__status__c, Closed
pba__totalarea_pb__c, 1800
size__c, 1800
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Rhode Island
subdist__c, Potrero Hill
ffd_name, 1076 Rhode Island Street, San Francisco, CA, 94107
transportation__c, 1 Block
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371128-1.jpg
ListingId, a0E1I00000THqOEUA1
