meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212438' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12155
[post_author] => 4
[post_date] => 2018-10-29 01:19:04
[post_date_gmt] => 2018-10-29 01:19:04
[post_content] => Above it all and sometimes in the fog, Diamond Heights has some great mid-century homes in the neighborhood overlooking Noe Valley. Diamond Heights Village dominates the neighborhood with nearly 400 condos, some of which have incredible downtown and Bay views. You'll need a car or quads of steel to get around in this 'hood.
[post_title] => Diamond Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => diamond-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-14 12:28:52
[post_modified_gmt] => 2024-11-14 20:28:52
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12155
[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, 220 Gold Mine Drive, San Francisco, CA, 94131
ffd_mls_id, 498877
ffd_salesforce_id, a0E1I00000SnW7hUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 220 Gold Mine Drive, San Francisco, CA, 94131
pba__address_pb__c, 220 Gold Mine Drive, San Francisco, CA, 94131
agent_only_remarks__c, New Price & 3% Commission to Buyer's Agent! Property is staged and shows well! Offers reviewed as they come. Website, Virtual Tour, Video is available. http://www.220goldminedrsf.com/ This home will be shown in compliance with Covid-19 CAR Guidelines, Buyers' Agent to submit PEAD Prior to showing. Additional Bonus Opportunity- Possible to build vertically down ( maybe more 2-3 stories). Escrow opened with Chicago Title, Kathie Ng. Seller will repair most problem in property inspection report after ratified. Please call LA for any questions (415-205-5185) BUYERS AND/OR BUYER'S AGENT MUST VERIFY PERMIT, BUILDING SQUARE FOOTAGE & LOT SIZE WITH CITY AUTHORITIES AND PROFESSIONAL SURVEYOR(S) BEFORE WRITING AN OFFER
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Freezer;Self/Cont Clean Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Remodeled;Tile;Sauna
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1967
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-06-29
ffd_createddate, 2020-05-29T12:41:37.000+0000
days_on_market__c, 1147
dom__c, 57
ffd_description_pb, Luxurious home in Quiet Diamond Heights Area! Fully Remodeled 3-Side Detached Home features an Open & Expansive layout w/ Unparalleled Panoramic SF views throughout the house, Double French Door Entrance, Radiant Floor Heat, Custom Made Cabinets & Closet, Hardwood Flooring, LED lighting & Sophisticated glass staircase railing. Main Level includes a chef's dream kitchen w/ Premium finishes across the modern cabinet, Massive Island Bar, professional grade THERMADOR Appliances. Spacious Dining & Living room w/ lovely fireplace & Half Bath. Upstairs features 3 Master Suites, w/ one extravagant suite w/ Private access to own Patio.Enjoy Watching Sunrise & Sunset from the private patio. Upscale Bathroom w/Bathtub, Shower, SAUNA & stunning view. Lower Level is built for Entertainment, includes Family Room w/ Built-in Wine Cellar, Wet Bar & Indoor PATIO, can BBQ. 2 Car Garage & BONUS Development opportunity below the property. Close to Shopping center, Restaurant & Freeway!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Electric
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Wall Furnace
interior_features__c, Formal Entry;Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:23:37.000+0000
pba__latitude_pb__c, 37.74183
pba__latitude_property__c, 37.74183
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-05-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tyson
pba__listing_agent_lastname__c, Li
listing_agent_mls_id__c, 810760
ffd_listingagentname, Tyson Li
listing_agent_number__c, 1047855
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 2795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=eBJhX5xGbL7&mls=1
pba__longitude_pb__c, -122.43997
pba__lotsize_pb__c, 0.07
lower_level__c, Family Room
mls_id__c, 498877
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-28
original_price__c, 2795000
overall_days_on_market__c, 64
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-07-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1047.27
pba__propertytype__c, Single Family Residence
id, a0E1I00000SnW7hUAF
room_type__c, Wine Cellar
sale_date__c, 2020-07-29
sale_price__c, 2725000
security_features__c, Smoke Detector;Security Alarm(s)
selling_agent_mls_id__c, 805631
selling_agent_name__c, Stefano Dezerega
selling_agent_number__c, 166015627
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2602
size__c, 2602
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Gold Mine
subdist__c, Diamond Heights
ffd_name, 220 Gold Mine Drive, San Francisco, CA, 94131
transportation__c, 3 Blocks
view__c, Panoramic;City Lights;San Francisco;Mountains;Canyon
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
pba__yearbuilt_pb__c, 1967
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363724-1.jpg
ListingId, a0E1I00000SnW7hUAF