meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='384637' 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-04-11 08:32:42
[post_modified_gmt] => 2024-04-11 15:32:42
[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
(
)
)
_yoast_indexnow_last_ping, 1726620778
ffd_listing_title, 16 Amber Drive, San Francisco, CA, 94131
ffd_mls_id, 424058731
ffd_salesforce_id, a0EUd000002vGWjMAM
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 28
address2__c, 16 Amber Drive, San Francisco, CA, 94131
pba__address_pb__c, 16 Amber Drive, San Francisco, CA, 94131
agent_only_remarks__c, Price Reduction. Motivated Seller. Offers shall be reviewed as they are submitted. Property is listed on the FNMA (Ineligible Fannie Mae List). Non warranted or specialized lender required. DO NOT USE SHOWING TIME. Schedule a showing by contacting Lance Bullerwell at 707-496-0419, [email protected] or John Solaegui at 415-999-0673, [email protected]. Escrow is opened with Gerrie Brindley at Chicago Title, [email protected]. Offers shall be submitted on the most current SFAR contract. Contact the listing agent for disclosures.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1963
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Lance E Bullerwell
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-08-22T18:46:46.000+0000
days_on_market__c, 26
dom__c, 26
ffd_description_pb, Nestled in serene Diamond Heights, the crown of the city and its geographical center, this top-floor Mid-Century condo offers a sophisticated retreat from the bustling city. With a private balcony offering stunning southwestern views toward Glen Park Canyon, the spacious living room overlooks a quiet residential street. The well-appointed kitchen provides the perfect canvas for your personal touch. Floor-to-ceiling windows, ample closet space, and two balconies enhance the residence's appeal. Located at the back, the two bedrooms and two bathrooms offer a peaceful view of the heated pool, shared by residents of this 28-unit, professionally managed HOA. The expansive primary bedroom features an adjoining bathroom for added convenience. Hardwood floors grace the open living and dining area, complemented by new carpet in the bedrooms. Additional amenities include a deep two-car garage, in-building laundry, and dedicated storage space on the ground level. The proximity to green spaces like Walter Haas Playground, Twin Peaks, and the Upper Douglass Dog Play Area is unmatched. Conveniently located near Diamond Heights Shopping Center, Tower Market, and offering easy access to Highways 101 and 280.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Grounds,Management,Pool,Trash,Water
pba__hoafees__c, 671
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Red Rock Owners Association No. 1
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-09-18T00:47:00.000+0000
pba__latitude_pb__c, 37.746181
pba__latitude_property__c, 37.746181
laundry_features__c, Ground Floor
listed_date__c, 2024-07-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Solaegui
listing_agent_mls_id__c, 803722
ffd_listingagentname, John R Solaegui
listing_agent_number__c, 803722
listing_co_agent_mls_id__c, 814098
listing_co_agent_number__c, 1064308
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 749000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4438981
mls_id__c, 424058731
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0OUd00000B7NHiMAN
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-08-22
open_house_end__c, 2024-09-17T15:00:00.000+0000
open_house_start__c, 2024-09-17T13:00:00.000+0000
original_price__c, 799000
overall_days_on_market__c, -82048
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-09-17T10:57:36.000+0000
price_per_square_foot__c, 678.44
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0EUd000002vGWjMAM
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Primary Bathroom;Primary Bedroom
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, 1104
size__c, 1104
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Amber
subdist__c, Diamond Heights
ffd_name, 16 Amber Drive, San Francisco, CA, 94131
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530828931-1.jpg