meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423690' 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
(
)
)
_yoast_indexnow_last_ping, 1739247500
ffd_listing_title, 152 Carnelian Way, San Francisco, CA, 94131
ffd_mls_id, 425007322
ffd_salesforce_id, a0EUd000004B9QhMAK
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 32
pba__address_pb__c, 152 Carnelian Way, San Francisco, CA, 94131
address2__c, 152 Carnelian Way, San Francisco, CA, 94131
agent_only_remarks__c, Escrow pre-opened with Janette Marcelo, Old Republic Title. Trust sale and sellers request keeping it with ORTC. Dues include roof, master insurance and earthquake insurance, grounds maintenance and property management. Some photos have been virtually staged.
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1976
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kathleen DiGrande
pba__contingentdate__c, 2025-02-08
ffd_createddate, 2025-01-31T01:48:28.000+0000
days_on_market__c, 11
dom__c, 11
ffd_description_pb, Perched above San Francisco in Diamond Heights, this spacious, house-like townhome offers incredible city views and a smart, versatile layout. A wall of windows in the living area frames stunning downtown vistas, while the formal dining room flows into a sunny kitchen with a breakfast nook that opens to a private patio and garden - a rare city retreat. A powder room completes this level. Upstairs, the primary suite boasts mesmerizing views, abundant closet space, and an en-suite bath. Two generous additional bedrooms, a full bath, and a sunroom offer flexibility for work or relaxation. The ground floor features a formal entry, a massive 2+ car garage, and a bonus room that's perfect for a home gym, office, or extra storage. Ideally located near Noe Valley, Twin Peaks, and Forest Hill, enjoy stunning vistas, green spaces, easy access to transit, and a wide variety of shops and restaurants. This is a rare opportunity to own a view-filled retreat in one of San Francisco's most desirable neighborhoods!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet
hoa_fee_includes__c, Earthquake Insurance,Insurance on Structure,Maintenance Grounds,Management,Roof
pba__hoafees__c, 1130
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Cathedral Ceiling
ffd_lastmodifieddate, 2025-02-11T03:47:02.000+0000
pba__latitude_pb__c, 37.7476793
pba__latitude_property__c, 37.7476793
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2025-01-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mary
pba__listing_agent_lastname__c, Macpherson
listing_agent_mls_id__c, 806933
ffd_listingagentname, Mary Macpherson
listing_agent_number__c, 166017897
listing_co_agent_mls_id__c, 810528
listing_co_agent_number__c, 1046694
listing_co_office_mls_id__c, VANTAGE
listing_co_office_name__c, Vantage Realty
listing_co_office_number__c, 28995
listing_office_mls_id__c, VANTAGE
listing_office_name__c, Vantage Realty
listing_office_number__c, 28995
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__listing_website__c, https://152carnelian.com/
pba__longitude_pb__c, -122.4410877
lower_level__c, Garage,Street Entrance
mls_id__c, 425007322
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks
master_property__c, a0OUd00000HQZrZMAX
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2025-01-30
original_price__c, 1299000
overall_days_on_market__c, -82209
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
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, 663.09
pba__propertytype__c, Condominium
ListingId, a0EUd000004B9QhMAK
room_type__c, Sun Room;Kitchen;Atrium;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, Contingent - Show
pba__totalarea_pb__c, 1959
size__c, 1959
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Carnelian
subdist__c, Diamond Heights
ffd_name, 152 Carnelian Way, San Francisco, CA, 94131
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1976
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530938397-1.jpg