meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212420' 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, 712 Wisconsin Street, San Francisco, CA, 94107
ffd_mls_id, 498689
ffd_salesforce_id, a0E1I00000Sm5i9UAB
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 2
address2__c, 712 Wisconsin Street, San Francisco, CA, 94107
pba__address_pb__c, 712 Wisconsin Street, San Francisco, CA, 94107
agent_only_remarks__c, Please have your buyer(s) view www.712wisconsin.com first before asking for an appointment. A signed PEAD and letter of pre-approval must be submitted before you can view. Please follow the guidelines posted inside the property for everyone's safety. Please use Fidelity National Title Company-Michael Gaffney
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Freezer
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Remodeled
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1995
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-05-26T17:46:34.000+0000
days_on_market__c, 1149
dom__c, 3
ffd_description_pb, This Potrero Hill North Slope home is a rare find. A contemporary 3 level, natural light-filled condominium in a 2 unit building with sweeping views of downtown and Bay Bridge. It lives like a single-family home. There are hardwood floors throughout and a soaring Venetian plaster wall that gives the entire space a warm glow. A spacious living room is a perfect place to entertain or just relax. There is an inviting open kitchen-dining combo floor plan. The kitchen includes Bosch and Miele appliances which include a gas range and dishwasher. The 3rd level master en-suite with a walkout deck has the most amazing SF downtown & bridge views. The master bath was remodeled and expanded in 2018 with designer finishes. The first level has 2 bedrooms, a full bath, an in-unit washer-dryer, and most importantly access to the exclusive use back yard where you can take in the sunshine and enjoy it with your favorite people. 2 car parking and additional storage. Come see and fall in love.
district__c, SF District 9
driveway_sidewalks__c, Shared Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floor__c, 0
pba__floortype_pb__c, Wood
hoa_dues__c, 350
hoa_fee_includes__c, Trash,Homeowners Insurance,Water
pba__hoafees__c, 350
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:23:25.000+0000
pba__latitude_pb__c, 37.75836
pba__latitude_property__c, 37.75836
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-05-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Roger
pba__listing_agent_lastname__c, Landry
listing_agent_mls_id__c, 800541
ffd_listingagentname, Roger S Landry
listing_agent_number__c, 800541
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MCGU
listing_office_name__c, McGuire Real Estate
listing_office_number__c, 1497
pba__listingprice_pb__c, 1750000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.39935
pba__lotsize_pb__c, 0
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 498689
main_level__c, Kitchen;Living Room;Dining Room
master_property__c, a0O1I00000A1RVeUAN
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-26
original_price__c, 1750000
overall_days_on_market__c, 97
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-05-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1095.62
pba__propertytype__c, Condominium
id, a0E1I00000Sm5i9UAB
sale_date__c, 2020-06-12
sale_price__c, 1925000
selling_agent_mls_id__c, EB32387
selling_agent_number__c, 981075027
selling_co_agent_mls_id__c, EB36695
selling_co_agent_number__c, 981076188
selling_co_office_mls_id__c, 14470
selling_co_office_name__c, Golden Gate Sotheby's Int'l Re
selling_co_office_number__c, 981021891
selling_office_name__c, Golden Gate Sotheby's Int'l Re
pba__status__c, Closed
pba__totalarea_pb__c, 1757
size__c, 1757
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Wisconsin
subdist__c, Potrero Hill
ffd_name, 712 Wisconsin Street, San Francisco, CA, 94107
transportation__c, 2 Blocks
view__c, Panoramic;City Lights;Bay;Downtown;Bay Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1995
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363605-1.jpg
ListingId, a0E1I00000Sm5i9UAB