meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325718' 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, 832 Rhode Island Street, San Francisco, CA, 94107
ffd_mls_id, 423721326
ffd_salesforce_id, a0E8W00000bEFH4UAO
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 832 Rhode Island Street, San Francisco, CA, 94107
pba__address_pb__c, 832 Rhode Island Street, San Francisco, CA, 94107
agent_only_remarks__c, Disclosures available. Dues estimated at $205/month. For more info contact Mark Brown 415-359-5576 / [email protected]
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Wine Refrigerator;Built-In Refrigerator;Gas Cook Top;Built-In Freezer;Built-In Electric Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Radiant Heat;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2022
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-17T11:50:26.000+0000
days_on_market__c, 35
dom__c, 35
ffd_description_pb, Luxurious new construction with views! Presenting new luxury condominiums in a boutique Potrero Hill building. 832 Rhode Island is a 2-level home with private outdoor space. The open plan main level is flooded with light from a sliding glass wall which provides seamless access to a large view deck. The kitchen is equipped with a large island, Vadara Varenna countertops & backsplashes, plus high-end, built-in appliances. Interior finishes include custom Manhattan oak and slate built-in cabinetry throughout. Gorgeous white oak floors provide visual and tactile warmth with radiant heat. On the upper level, two bedrooms and an office await. The primary bedroom offers views of the Downtown San Francisco skyline and includes a walk-through closet and ensuite bath. The bathrooms feature large format tile and beautiful European Cocoon stone bath basins & fixtures. Perfect for a modern and luxurious lifestyle. Each unit comes with in-unit laundry, 9' tall ceilings, designer light fixtures, and keyless entry with intercom. Enjoy easy access to freeways and the world-class cafes and restaurants in this tremendous San Francisco neighborhood. Some photos of similar unit. Finishes and layout may vary.
district__c, SF District 9
entry_level__c, 1
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 205
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant Floor
ffd_lastmodifieddate, 2023-03-24T10:48:58.000+0000
pba__latitude_pb__c, 37.7591634
pba__latitude_property__c, 37.7591634
laundry_features__c, Laundry Closet
listed_date__c, 2023-02-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.830-rhode-island.com
pba__longitude_pb__c, -122.40209026
mls_id__c, 423721326
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Quartz;Tile;Radiant Heat;Multiple Shower Heads
master_property__c, a0O8W00000HsmLTUAZ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-02-17
open_house_end__c, 2023-03-26T16:00:00.000+0000
open_house_start__c, 2023-03-26T14:00:00.000+0000
original_price__c, 1795000
overall_days_on_market__c, -81496
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, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEFH4UAO
sale_date__c, 1800-01-01
sale_price__c, 0
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Rhode Island
subdist__c, Potrero Hill
ffd_name, 832 Rhode Island Street, San Francisco, CA, 94107
view__c, Downtown
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 2022
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530581113-1.jpg
