meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214503' 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, 580 Wisconsin Street, San Francisco, CA, 94107
ffd_mls_id, 505179
ffd_salesforce_id, a0E1I00000THgPAUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 87
address2__c, 580 Wisconsin Street, San Francisco, CA, 94107
pba__address_pb__c, 580 Wisconsin Street, San Francisco, CA, 94107
agent_only_remarks__c, Please call Laila for all showing requests, Transparent pricing!!! Covid compliant showings w/ signed pead form and pre-approval letter at list price. This is an excellent and rare 3 bedroom floor plan. Seller just installed brand new oak floors, replaced all light fixtures, replaced all heaters, new white quartz counters and backsplash in the kitchen and primary bathroom. Property video available @ www.580wisconsin.com.
appliances__c, Dishwasher;Gas Range;Electric Range;Microwave;Disposal;Refrigerator
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1978
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Laila Y Salma
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-09T10:48:22.000+0000
days_on_market__c, 1043
dom__c, 74
ffd_description_pb, Gorgeous living on top of Potrero Hill. Rare 3 bedroom/2 bath floor plan at the Victoria Mews property. The unit features an amazing city view deck directly off the living room and dining room. Well appointed kitchen with new quartz counters. Spacious primary ensuite bedroom with walk in closet and tranquil outlook from windows. 2 guest bedrooms offers immense flexibility for today's lifestyle. Use as home office, exercise studio? The options are endless here! Brand new, white French oak floors installed throughout the unit. New paint, new light fixtures, in unit w/d. Amazing community features include heated pool, tennis courts, gym, spa, landscaped gardens, community room, and professional management.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 848
hoa_fee_includes__c, Management,Maintenance Grounds,Water
pba__hoafees__c, 848
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2022-01-25T15:33:13.000+0000
pba__latitude_pb__c, 37.76019967
pba__latitude_property__c, 37.76019967
laundry_appliances__c, Washer/Dryer
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-09-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rhanda
pba__listing_agent_lastname__c, Salma
listing_agent_mls_id__c, 803904
ffd_listingagentname, Rhanda Salma
listing_agent_number__c, 166013265
listing_co_agent_mls_id__c, 806006
listing_co_agent_number__c, 166016136
listing_co_office_mls_id__c, SCYA
listing_co_office_name__c, Salma & Company
listing_co_office_number__c, 1956
listing_office_mls_id__c, SCYA
listing_office_name__c, Salma & Company
listing_office_number__c, 1956
pba__listingprice_pb__c, 1250000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3994685
pba__lotsize_pb__c, 0
mls_id__c, 505179
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VYM8UAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-09
original_price__c, 1295000
overall_days_on_market__c, 113
parking_access__c, Independent
parking_features__c, Attached,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-11-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 961.54
pba__propertytype__c, Condominium
id, a0E1I00000THgPAUA1
sale_date__c, 2020-12-02
sale_price__c, 1250000
selling_agent_mls_id__c, 807966
selling_agent_name__c, Ilana D. Minkoff
selling_agent_number__c, 1029271
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1300
size__c, 1300
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Wisconsin
subdist__c, Potrero Hill
ffd_name, 580 Wisconsin Street, San Francisco, CA, 94107
view__c, City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1978
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369499-1.jpg
ListingId, a0E1I00000THgPAUA1