meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212316' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
[post_title] => Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 07:08:05
[post_modified_gmt] => 2024-03-28 14:08:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15724
[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, 1810 Green Street, San Francisco, CA, 94123
ffd_mls_id, 498347
ffd_salesforce_id, a0E1I00000SlivaUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 2
address2__c, 1810 Green Street, San Francisco, CA, 94123
pba__address_pb__c, 1810 Green Street, San Francisco, CA, 94123
agent_only_remarks__c, -Property went through a $1.5 million total down to the studs renovation from March 2016 to April 2018- Home is currently unoccupied. Client is sheltering at another property. Please email: [email protected] for questions or to set up a showing. Please follow the Compass and SFAR SIP Rules for Showing. www.1810GreenStreet.com for floorplans,additional photos and feature list. Buyer's Agent/s: Please add the following to additional terms (paragraph 8.) of your PEAD: Further, all signatories to this Form mutually agree to release each other from any loss, liability, expense, claim or cause of action that may arise from allowing entry or entering the Property or are related in any manner to C.A.R. Form PEAD.
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2020-05-18T15:47:12.000+0000
days_on_market__c, 1157
dom__c, 86
ffd_description_pb, Completely renovated with an eye toward the highest level of detail and craftmanship, this generously appointed top floor Pacific Heights 3-bedroom, 3.5-bath bi-level condominium feels more like a separate house. Inside, the 1st level includes a grand dining room with original working pocket doors, built-in storage and bar, and a large living and sitting area as well as the half-bath, gourmet kitchen, and third bedroom. Upstairs you'll find the two spacious decks with views - one north-facing, one south-facing with unobstructed views of the full expanse of the Golden Gate Bridge and Palace of Fine Arts - master suite, and the second bedroom. All bedrooms have ensuite bathrooms. Angela Free Design has incorporated a refined and timeless feel into this historic home. New custom windows made of African Mahogany and window coverings, distressed walnut floors, and designer recessed lighting and coontrols. A long list of all the many custom features can be found at: www.1810GreenStreet.com
district__c, SF District 7
entry_level__c, 2
external_listing__c, 1
pba__floor__c, 2
hoa_dues__c, 250
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1806-1810 Green Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:22:54.000+0000
pba__latitude_pb__c, 37.79718
pba__latitude_property__c, 37.79718
laundry_appliances__c, In Closet
laundry_features__c, Laundry Closet
listed_date__c, 2020-05-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dean
pba__listing_agent_lastname__c, Sereni
listing_agent_mls_id__c, 802908
ffd_listingagentname, Dean R Sereni
listing_agent_number__c, 802908
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 3895000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1810GreenStreet.com
pba__longitude_pb__c, -122.42901
pba__lotsize_pb__c, 0
mls_id__c, 498347
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VY7VUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-18
original_price__c, 3895000
overall_days_on_market__c, 141
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-08-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000SlivaUAB
sale_date__c, 2020-09-02
sale_price__c, 3400000
selling_agent_mls_id__c, 812646
selling_agent_name__c, Grant Edward Beggs
selling_agent_number__c, 1057558
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Pacific Heights
ffd_name, 1810 Green Street, San Francisco, CA, 94123
transportation__c, 1 Block
view__c, City Lights;Water;Downtown;San Francisco;Golden Gate Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363286-1.jpg
ListingId, a0E1I00000SlivaUAB