meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219947' 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, 542 Rhode Island Street, San Francisco, CA, 94107
ffd_mls_id, 421571597
ffd_salesforce_id, a0E1I00000UUtFSUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 542 Rhode Island Street, San Francisco, CA, 94107
pba__address_pb__c, 542 Rhode Island Street, San Francisco, CA, 94107
agent_only_remarks__c, More at www.542RhodeIsland.com For showings, please call or text Sherry Gray 415-656-9825 or Ron Abta: 415-595-7661. Escrow opened with Steve Salviejo, (415) 346-0122, from North American Title. Showings by appointment only. PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Buyers should investigate to their satisfaction.Disclosures link here https://app.disclosures.io/link/542-Rhode-Island-Street-dh31vnni
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Contemporary;Spanish;Mediterranean
bath_features__c, Shower Stall(s);Low-Flow Toilet(s);Dual Flush Toilet;Low-Flow Shower(s);Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1938
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sherry L Gray
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-07-09T21:53:51.000+0000
days_on_market__c, 741
dom__c, 32
ffd_description_pb, This remodeled 3 bed / 2 bath house offers many high-end finishes and impresses with its amazing flat backyard on Potrero's north slope. White Oak herringbone floors greet you as you enter this updated home with an open floor plan and great flow throughout. The gourmet kitchen delights with its Italian tile backsplash, Hallman stove, Sub-Zero refrigerator, Miele dishwasher, and wine fridge. The dining & living areas dazzle with direct access to the lush backyard, perfect for entertaining & indoor / outdoor living. The spacious bedrooms enjoy ample closet space with built-out organizers, while the primary bedroom impresses with its vaulted ceiling & beams, two closets, and bathroom with large rainfall shower. Relax in the Zen backyard with its hot tub and large bench seating area. Air conditioning & a storage room completes this great house. Room to grow with plans for a 4th bedroom & roof deck for amazing SF skyline views. Just steps to Whole Foods and all the great retail of 18th St.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Gas Piped
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Smart Vent
ffd_lastmodifieddate, 2022-01-25T15:57:06.000+0000
pba__latitude_pb__c, 37.7628897
pba__latitude_property__c, 37.7628897
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2021-07-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ron
pba__listing_agent_lastname__c, Abta
listing_agent_mls_id__c, 803878
ffd_listingagentname, Ron Abta
listing_agent_number__c, 166013231
listing_co_agent_mls_id__c, 810109
listing_co_agent_number__c, 1044758
listing_co_office_mls_id__c, POLARISR
listing_co_office_name__c, Polaris Realty
listing_co_office_number__c, 27749
listing_office_mls_id__c, POLARISR
listing_office_name__c, Polaris Realty
listing_office_number__c, 27749
pba__listingprice_pb__c, 2295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=G37h2xWJN7E
pba__longitude_pb__c, -122.4026595
lower_level__c, Full Bath(s),Garage,Master Bedroom,Retreat
mls_id__c, 421571597
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Tile;Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-08
original_price__c, 1995000
overall_days_on_market__c, 90
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-08-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000UUtFSUA1
room_type__c, Storage;Kitchen;Living Room;Master Bathroom;Guest Quarters;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-08-31
sale_price__c, 2275000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 805155
selling_agent_number__c, 166014957
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Side, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Rhode Island
subdist__c, Potrero Hill
ffd_name, 542 Rhode Island Street, San Francisco, CA, 94107
view__c, City;City Lights;Downtown;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1938
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530280233-1.jpg
ListingId, a0E1I00000UUtFSUA1